|

楼主 |
发表于 2008-3-25 16:14:07
|
显示全部楼层
贴图,我在客户端用'zengbo'登录运行值班功能,并运行systemmonitor.exe,图如下,
select PBMXB.PID, PBMXB.STARTTIME, PBMXB.ENDTIME, PBMXB.DUTY_PERSON, PBMXB.TASK, PBMXB.WORK_CONTENT, PBMXB.UNFINISHED_WORK, PBMXB.SIGN_TIME, PBMXB.LEAVE_TIME, PBMXB.SIGN_STATUS, PBB.ID, PBB.DUTYDATE, PBB.LEADER, PBB.PHONE, PBMXB.ID from PBMXB, PBB where PBB.ID = PBMXB.PID and PBB.DUTYDATE = ? and PBMXB.DUTY_PERSON = ?
值班人和时间为?是正常的么?
我用SQL查询分析器是把日期写成'2008-3-25',DUTY_PERSON='ZengBo'是有记录的?其实我就是想找出今天是否有值班,有就填写工作内容,有没有更好的办法实现,
|
|