厂牌的制作方法.docxVIP

进入厂牌制作模块按F11键进入菜单修改照片路径输入以下代码beginiffileexists(E:\EastMoney\photo\+[trim([DM2DM.V_Employeecard.Empno])]+.jpg) then picture2.loadfromfile(E:\EastMoney\photo\+[trim([DM2DM.V_Employeecard.Empno])]+.jpg)end将其中的照存放路径改为系统中存放照片的路径选择 picture2 修改其中的DataField值，将原有的删除，设置新的为空。部分代码： select distinct v.empno,empname,:月份 as YYMMA,dutyname,partname,y.夜班,z.时数和,z.平时和,z.双休和,z.节假和,z.旷职,z.休假, :开始日期 AS BEGINdate ,:结束日期 AS ENDdate from V_employeedaycarddata v left join (select empno ,count(isnull(isnightshift,0)) as 夜班 from employeedaycarddata where yymmdd=:开始日期 AND YYMMDD=:结束日期 and isnightshift=1 group by empno ) y on v.empno=y.empno left join (select empno ,sum (isnull(WorkTime,0)) as 时数和,sum(case when addworktime0 then addworktime4 end) as 平时和,sum(case when addworktime10 then addworktime4 end) as 双休和,sum(case when addworktime20 then addworktime4 end) as 节假和 ,sum(round(truancy,2)) as 旷职,sum(kmoney) as 休假 from employeedaycarddata where yymmdd=:开始日期 AND YYMMDD=:结束日期 group by empno ) z on v.empno=z.empno where yymmdd=:开始日期 AND YYMMDD=:结束日期 and (partname=:部门名称 or partname2=:组别名称 ) or v.empno=:工号 order by partname,v.empno月报中的自定义字段的数据统计------请假时数--病假旷工事假-- CustomItem1 ---- CustomItem4declare @c1 float,@c2 float,@c3 float,@c4 floatset @c1 = 0 set @c2 = 0 set @c3 = 0 set @c4 = 0 update EmployeeMonthCount set CustomItem1= (IsNull(( select sum(IsNull(A.Times,0))from PleaseIll_Detail A Left Join PleaseIll_Master B on A.Id=B.Id where A.Times0 and B.LeaveType=病假 and A.EMPNO=@EMPNO and A.YYMMDD=@YYMMDD1 and A.YYMMDD=@YYMMDD2 ), 0)) where EmpNo=@EMPNO and YYMM=@YYMM update EmployeeMonthCount set CustomItem2=( (IsNull(( select sum(IsNull(A.Times,0))from PleaseIll_Detail A Left Join PleaseIll_Master B on A.Id=B.Id where A.Times0 and B.LeaveType=旷工 and A.EMPNO=@EMPNO and A.YYMMDD=@YYMMDD1 and A.YYMMDD=@YYMMDD2 ), 0)) ) where EmpNo=@EMPNO and YYMM=@YYMM and IsOK=0 update EmployeeMonthCount set CustomItem3 = ((IsNull(( select sum(IsNull(A.Times,0)) from PleaseIll_Detail A