易飞ERP 数据库工单查

Jack·高峰 • 2013-04-27 14:49 • 3118 阅读

--检查工单实际开工日期大于实际完工日期的sql select TA006,TA027,TA012,TA014 from MOCTA where TA012>TA014 and TA012>0 and TA014>0 and TA006 like '%0123167001%' --更改工单实际开工日期大于实际完工日期的sql UPDATE MOCTA SET TA0...

当前字体大小 15px

12px 50px

为了以后检查方便，不用临时搞那么浪费时间了。嘻嘻。。

--检查工单实际开工日期大于实际完工日期的sql
select TA006,TA027,TA012,TA014 from MOCTA where TA012>TA014 and TA012>0 and TA014>0 and TA006 like '%0123167001%'

--更改工单实际开工日期大于实际完工日期的sql
UPDATE MOCTA SET TA014='20130420' where TA012>TA014 and TA012>0 and TA014>0 and TA006 like 'TL5551167001        ' and TA027 like 'TLM13031   '

--检查工单成品的生产工厂和入库仓库是否正
select TA006,TA027 from MOCTA where TA001='5102' and (TA019!='tlll' or TA020!='103')

--检查工单电镀成品工单无委外供应商的（电镀工艺错误
select TA006,TA027,TA001,TA032,TA021 from MOCTA where TA021='DB01' and TA001!='5103' and TA032='' and TA001!='5109' and TA001!='5101' and UDF53>0

--检查工单非电镀成品工单有委外供应商(非电镀工艺错误)
select TA006,TA027,TA021,TA032,TA021 from MOCTA where TA021!='DB01' and TA001!='5103' and TA032!='' and TA001!='5109' and TA001!='5101' and UDF53>0