易飞ERP 数据库客户订单查

Jack·高峰

•

• 2013-04-27 15:00 • 2964 阅读

--查询订单数量大于0 SELECT * FROM COPTD WHERE TD002='TLS12223' AND UDF51>0 --根据订单数量批量更改生产数量 UPDATE COPTD SET TD008=80,UDF51=0 WHERE TD002='TLS12223' AND UDF51=80 --客户订单查询 select * from COPTC W...

--查询订单数量大于0
SELECT * FROM COPTD WHERE TD002='TLS12223' AND UDF51>0

--根据订单数量批量更改生产数量
UPDATE COPTD SET TD008=80,UDF51=0 WHERE TD002='TLS12223' AND UDF51=80

--客户订单查询
select * from COPTC WHERE TC002='TLS12253'

--更改客户订单更改
UPDATE COPTC SET MODIFIER='zzjh' WHERE TC002='TLS12226'

--撤销订单单据审核
UPDATE COPTC SET TC027='N'  WHERE TC002='TLS12264'

--更改客户订单审核/录入
UPDATE COPTC SET MODIFIER='',CREATOR='zzjh',TC040='zzjh' WHERE TC002='TLS12223' or TC002='TLS12226'

--查询更改客户订单审核/录入
select * from COPTC WHERE TC002='TLS12223' or TC002='TLS12226'

--根据订单/产品编码查询工单---成品/半成
SELECT * FROM MOCTA where TA006 like '%5167146005%'AND TA027 LIKE'TLS12300'
SELECT * FROM MOCTA where TA006 like '%5171146012%'AND TA027 LIKE'TLS12300'
SELECT * FROM MOCTA where TA006 like '%103146035%'AND TA027 LIKE'TLS12300' 

--根据订单号查询工---未审核工
SELECT * FROM MOCTA where TA057='TLS12300' OR TA013='N'
SELECT * FROM MOCTA where TA006='TL1205187528SDMFLB' AND TA057='TLS12227' AND TA002='130100363'
UPDATE MOCTA SET TA013='N' where TA006='TL1205187528SDMFLB' AND TA057='TLS12227' AND TA002='130100363'