tB3.Fill("select 实际生产员工,(convert(varchar(8),扫码时间,112)) AS 日期,sum(a.件数*a.工价) F rom {派发工序表} a left join {员工管理} b on a.实际生产员工=b.姓名 where month(a.扫码时间)=datename(month,getdate()) And year(a.扫码时间)=datename(year,getdate()) And (a.件数*a.工价)>0 And a.实际生产员工 Is not null group by 实际生产员工,(convert(varchar(8),扫码时间,112)) order by 实际生产员工,(convert(varchar(8),扫码时间,112))" , "xsc_erp",True)
|