文件过期提醒功能
摘要:
数据库脚本:create view view_LiuYanasselect mouldNo,outUserName,partName,drawingNo,rstartDate,ostartDate,oendDate,supplierName , case when DATEDIFF (D,GETDATE(),ostartDate)0 then 'tryellow' when DATEDIFF(D,GETDATE(),ostartDate)>" %> VOutProceSchedule ... 阅读全文
posted @ 2013-11-13 16:52 守望星空 阅读(386) 评论(0) 推荐(0) 编辑