厂牌的制作方法

1. 进入厂牌制作模块

2. 按F11键进入菜单

流水工艺品3. 修改照片路径

包边带

输入以下代码

begin

if山人全息码 fileexists('E:\EastMoney\photo\'+[trim([DM2DM.V_Employeecard."Empno"])]+'.jpg') then picture2.loadfromfile('E:\EastMoney\photo\'+[trim([DM2DM.V_Employeecard."Empno"])]+'.jpg')

end

4. 将其中的照存放路径改为系统中存放照片的路径

5. 选择 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 pno left join (select empno ,sum (isnull(WorkTime,0)) as 时数和,sum(case when addworktime>0 then addworktime4 end) as 平时和,sum(case when addworktime1>0 then addworktime4 end) as 双休和,sum(case when addworktime2>0 then addworktime4 end) as 节假和 ,sum(round(truancy,2)) as 旷职,sum(kmoney) as 休假 from employeedaycarddata where yymmdd>=:开始日期 AND YYMMDD<=:结束日期 group by empno ) z pno where yymmdd>=:开始日期 AND YYMMDD<=:结束日期 and (partname=:部门名称 or partname2=:组别名称 ) pno=:工号 order by pno

月报中的自定义字段的数据统计

------请假时数

三极管自锁电路--病假旷工事假

-- CustomItem1 ---- CustomItem4

declare @c1 float,@c2 float,@c3 float,@c4 float

set @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.Times>0

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.Times>0 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 Left Join PleaseIll_Master B on A.Id=B.Id

where A.Times>0 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

氧气过滤器select @c1 = sum(isnull(WorkTimes,0)) from PleaseIllReq a

电解离子接地棒

where a.BD >= @YYMMDD1 and a.ED <= @YYMMDD2 and ISNULL(A.LeaveType,'FF') = '病假' pno = @empno and isnull(WorkTimes,0) > 0

select @c2 = sum(isnull(WorkTimes,0)) from PleaseIllReq a

where a.BD >= @YYMMDD1 and a.ED <= @YYMMDD2 and ISNULL(A.LeaveType,'FF') = '旷工' pno = @empno and isnull(WorkTimes,0) > 0

select @c3 = sum(isnull(WorkTimes,0)) from PleaseIllReq a

where a.BD >= @YYMMDD1 and a.ED <= @YYMMDD2 and ISNULL(A.LeaveType,'FF') = '事假'

pno = @empno

update EmployeeMonthCount

SET CustomItem1 = ISNULL(CustomItem1,0) + isnull(@C1,0),CustomItem2 = ISNULL(CustomItem2,0) + isnull(@C2,0),CustomItem3 = ISNULL(CustomItem3,0) + isnull(@C3,0) where YYMM = @YYMM AND EMPNO = @EMPNO and IsOK=0

本文发布于:2024-09-21 17:56:05，感谢您对本站的认可！

本文链接：https://www.17tex.com/tex/2/230191.html

上一篇：基于HTML5的界面交互及展示系统、方法与设计方案

下一篇：单片机电子琴设计.正文

标签：路径时数代码

留言与评论（共有 0 条评论）