1、單選人員：
選擇輸入框：
select a.userid as id,a.UserName as 姓名,a.UserDeptID as id2,a.UserQuarterID as id3,b.ID as id4, b.DeptName as 部門,c.id as id5,c.QuarterName as 崗位 FROM officedba.UserInfo a LEFT JOIN officedba.DeptInfo b ON a.UserDeptID=b.ID LEFT JOIN officedba.DeptQuarter c ON a.UserQuarterID=c.id where a.LockFlag='0' AND a.username IS NOT NULL AND b.DeptName IS NOT NULL AND b. UsedStatus=1
綁定字段：id 回顯字段：姓名 過濾字段：姓名，崗位，編號，手機號碼
聯動SQL：
select id,DeptName as name,SuperDeptID as s from officedba.DeptInfo where 1=1
聯動綁定：id 聯動回顯：name 聯動分組：s 目標聯動列：id2
2、多選人員：
綁定SQL：
select -1*ID as ID ,DeptNO as 編號 ,DeptName as 名稱,-1*SuperDeptID as xxjgx from officedba.DeptInfo bm where SuperDeptID is not null union all select id as ID,EmployeeNo as bh, EmployeeName as mc,-1*DeptID as xxjgx from officedba.EmployeeInfo where DeptID is not null and 1=1
綁定字段：id 回顯字段：姓名 過濾字段：bh, 姓名 分組字段：xxjgx
3、選部門
下拉列表：select id,DeptName as 部門,SuperDeptID from officedba.DeptInfo where 1=1 and UsedStatus=1
綁定字段：id 回顯字段：部門 分組字段：SuperDeptID
4、選崗位
下拉列表：select id,QuarterName,SuperQuarterID from officedba.DeptQuarter where 1=1 and UsedStatus=1
綁定字段：id 回顯字段：崗位 分組字段：SuperQuarterID
5、選投標管理里面的項目
選擇輸入框：SELECT id,xiangmu AS 項目名稱,dizhi AS 地址,lrr AS 錄入人,appTime AS 日期,leixingid FROM T_xiangmuxinxi WHERE sc=0 AND 1=1
綁定字段：id 回顯字段：項目名稱 過濾字段：項目名稱，日期
聯動SQL：select id,flmc as name, fllbid as s from rsgl_jcsz_FLSXSZ where sc=0 and 1=1 and fllb='項目類型'
聯動綁定：id 聯動回顯：name 聯動分組：s 目標聯動列：leixingid
6、選立項信息里面的項目
選擇輸入框：
select id,xmmc as 項目名稱,kaishi as 開始日期,jieshu as 結束日期,quyu as 區域,xmdz as 地址,leixingid from T_lixiang WHERE sc=0 AND 1=1
綁定字段：id 回顯字段：項目名稱 過濾字段：項目名稱，開始日期
聯動SQL：select id,flmc as name, fllbid as s from rsgl_jcsz_FLSXSZ where sc=0 and 1=1 and fllb='項目類型'
聯動綁定：id 聯動回顯：name 聯動分組：s 目標聯動列：leixingid
7、選供應商
選擇輸入框：select id,wldwmc as 供應商,dq as 地區,leibieid from jcsz_wldw where sc=0 and 1=1
聯動綁定：id 聯動回顯：供應商 過濾字段：供應商，地區
聯動SQL：select ID as id , danwei as name,sjlbid as s from JCSZ_WLDWLB where sc=0 and 1=1
聯動綁定：id 聯動回顯：name 聯動分組：s 目標聯動列：leibieid
8、選倉庫
選擇輸入框：select id,ckmc as 倉庫名稱 from c_cangku where sc=0 and 1=1
聯動綁定：id 聯動回顯：倉庫名稱
9、選材料，物品
選擇輸入框：select id,wupin as 物品名稱,bianma as 物品編碼,pinpai as 品牌,xinghao as 規格型號,danwei as 單位,leixingid from c_cljck where sc=0 and 1=1
綁定字段：id 回顯字段：物品名稱 過濾字段：物品名稱，物品編碼，品牌,規格型號,單位
聯動SQL：select ID as id,mingcheng as name,fujiid as s from c_leixing where sc=0 and fuji is not null
聯動綁定：id 聯動回顯：name 聯動分組：s 目標聯動列：leixingid
10、選擇類型
下來列表：select '1' as id,'請選擇' as flmc union select id,flmc from rsgl_jcsz_flsxsz where sc=0 and fllb ='分包結算類型'
綁定字段：id 回顯字段：flmc
注：分包結算類型是一可以更換的類型名稱，更換字段是 基礎信息---其他分類類別------分類屬性設置 里面的分類類別字段
