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
注：分包结算类型是一可以更换的类型名称，更换字段是 基础信息---其他分类类别------分类属性设置 里面的分类类别字段
