閱讀時間:5 分鐘 
瀏覽量:次
業(yè)務(wù)實踐題
一、概念題
請對以下系統(tǒng)名詞的作用意義做出解釋(5分)
立項信息登記
智能建模
數(shù)據(jù)權(quán)限
崗位智能計算
審后編輯
二、實際操作題
請將一下圖片表單在系統(tǒng)中進行新增，且增加對應(yīng)列表，需要根據(jù)具體需求選擇控件，且將列表樣式，查詢條件，且超鏈接進行優(yōu)化(10分)
三、Sql業(yè)務(wù)題
根據(jù)一下需要實現(xiàn)的業(yè)務(wù)，寫出對應(yīng)的sql語句。
選擇項目帶出對應(yīng)項目的立項人，立項人控件的帶入sql(2分)
選擇人員帶出對應(yīng)部門，部門控件的帶入sql(4分)
將立項表單中，項目狀態(tài)為“落標”的數(shù)據(jù)，全部修改為“放棄”(3分)
四、請解釋一下sql的具體含義
舉例：
SELECT t.id,t.appTime,t.gjzt,t.bianhao,c.xiangmu,c1.kemu,SUM(c1.jiner) as ljbx,c.bumen,c.FlowStatus FROM C_feiyongbaoxiao c,T_lixiang t,C_feiyongbaoxiaobxmx c1
WHERE 1=1 AND C.sc=0 and c1.sc=0 and c.FlowStatus='3' and t.id=c.xiangmuid and t.FlowStatus='3' and c.id=c1.parentid GROUP BY t.id,t.appTime,t.gjzt,t.bianhao,c.xiangmu,c1.kemu,c.bumen,c.FlowStatus
order by t.ID desc
通過泛普軟件立項表單的id和費用報銷的項目id相等，費用報銷的id和項目費用明細表的parentid相等的條件下，將立項表單，費用報銷表單，費用報銷明細表單 三張表進行聯(lián)動查詢。
且過濾掉費用報銷已刪除的數(shù)據(jù)和費用報銷明細表已刪除的數(shù)據(jù)。
查詢出立項表的id字段，立項日期字段，項目狀態(tài)，項目編號字段，
費用報銷：所屬項目，部門，流程狀態(tài)
費用報銷明細表：費用科目，累積報銷金額
列表使用了sum()......group by 函數(shù)進行求和，order by...desc 進行排序
(1)來源于工程監(jiān)理系統(tǒng)(6分)
select a.id,a.name,a.UnitA,a.UnitAid,a.ContractPerformance,a.Expire,
case when (select count(id) from Payment where sc=0 and ContractNameid=a.id)=0 then '未申請' else '已申請' End as sqState from LedgerContract a where a.sc=0
(2)來源于工程管理系統(tǒng)(10分)
SELECT aa.xmmc as 項目名稱,B as 材料,aa.appTime as 立項日期,aa.bianhao as 項目編號,aa.gjzt as 項目狀態(tài),(isnull(c1,0)+isnull(c2,0)) as 勞務(wù),(isnull(d1,0)+isnull(d2,0)) as 租賃,E as 分包,F as 間接費,
(isnull(b,0)+isnull(c1,0)+isnull(c2,0)+isnull(d1,0)+isnull(d2,0)+isnull(e,0)+isnull (f,0)) as 合計
FROM
(SELECT xmmc,appTime,bianhao,gjzt FROM T_lixiang where sc=0 and FlowStatus='3') aa
FULL JOIN
(SELECT SUM(fkje) as b,xiangmu FROM C_cailiaofukuan where sc=0 and FlowStatus='3' GROUP BY xiangmu) b on aa.xmmc=b.xiangmu/*材料*/
FULL JOIN
(SELECT SUM(yfhj) as C1,xmmc FROM L_xmgz where sc=0 and FlowStatus='3' GROUP BY xmmc) c1 on aa.xmmc=c1.xmmc/*勞務(wù)人工費*/
FULL JOIN
(SELECT SUM(jiner) as c2,xiangmu FROM L_laowufukuan where sc=0 and FlowStatus='3' GROUP BY xiangmu)c2 on aa.xmmc=c2.xiangmu/*勞務(wù)付款*/
FULL JOIN
(SELECT SUM(bcfk) as D1,xiangmu FROM Z_zulinfukuan where sc=0 and FlowStatus='3' GROUP BY xiangmu)d1 on aa.xmmc=d1.xiangmu/*租賃付款*/
FULL JOIN
(SELECT SUM(hjje) as D2,ssxm FROM Z_jxf where sc=0 and FlowStatus='3' GROUP BY ssxm)d2 on aa.xmmc=d2.ssxm/*機械費*/
FULL JOIN
(SELECT SUM(fkje) as E,xiangmu FROM F_fenbaofukuan where sc=0 and FlowStatus='3' GROUP BY xiangmu) e on aa.xmmc=e.xiangmu/*分包*/
FULL JOIN
(SELECT SUM(jine) as F,xiangmu FROM C_feiyongbaoxiao d where sc=0 and FlowStatus='3' GROUP BY xiangmu) f on aa.xmmc=f.xiangmu/*間接費*/
.jpg)
.jpg)
