工程项目管理系统 | OA系统 | ERP系统 | 工程项目管理软件 | 装饰管理系统 | 签约案例 | 购买价格 | 在线试用 | 手机APP | 产品资料
X 关闭

公司级表格定义

当前位置:工程项目OA系统 > 工程管理平台教程 > 个性化 > 公司级表格定义

公司级表格定义

  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

  注:分包结算类型是一可以更换的类型名称,更换字段是 基础信息---其他分类类别------分类属性设置 里面的分类类别字段

发布:2007-02-14 14:34    来源:泛普软件    [打印此页]    [关闭]