莫等闲

caizhengzhu

管理员

公司条形码数据库处理

select * from usrInLabel where sLotNo1='A14070303A'

select * from usrInLabel where sLotNo1='A14070303A'

select * from BC_TMMANODDT   BC_TMMANODDT  生产排程

select * from BC_TMMANODDT where csnm like '%140770%'

select * from BC_TMMANODDT where csnm ='T14070702A'

where sBillID ='PT14070028'

BC_TSTOCKOUTPD  客户订单号

select * from BC_BITEM where IM_NAME like 'ATX-248%'  查询成品资料

SELECT * from msrMaterial where sItemName = 'Atnen S-80'

update msrMaterial set BRIEFMSDS='80% Sulfur，硫磺； 20% Polymer and dispersing agent，聚合物及分散劑；50% Polymer and dispersing agent，聚合物及分散劑;' where sItemName = 'Atnen S-80'

update  [Hightone].[dbo].[BC_BITEM]
set BRIEFMSDS='11180% Tetramethyl thiuram disulphide,二硫化四甲基秋蘭姆;20% Polymer and dispersing agent,聚合物及分散劑;80% Sulfur,硫磺;  test'

update  hightone.dbo.BC_BITEM set DATE_synch = NULL
EXEC RLERP.dbo.Bitem_Synchronous

更新成品资料公用表

update BC_BITEM set BRIEFMSDS='80% Tetramethyl thiuram disulphide,硫化四甲基秋蘭姆;2% Polymer and dispersing agent,聚合物及分散劑;800% Sulfur,硫磺;' where IM_Name = 'Atnen TMTD-80'

SELECT * from BC_BITEM where IM_Name = 'Atnen TMTD-80'
SELECT * from msrMaterial where sItemName = 'Atnen TMTD-80'
80% Tetramethyl thiuram disulphide,硫化四甲基秋蘭姆;2% Polymer and dispersing agent,聚合物及分散劑;800% Sulfur,硫磺;

50% Bis-triethoxy silypropyl-polysulfide,    雙-（三乙氧基硅丙基）多硫化物;50% Hydrocarbon polymer,    碳氢化合物之聚合物；
50% Bis-triethoxy silypropyl-polysulfide,    雙-（三乙氧基硅丙基）多硫化物;50% Hydrocarbon polymer,    碳氢化合物之聚合物；

80% Tetramethyl thiuram disulphide,        硫化四甲基秋蘭姆;2% Polymer and dispersing agent,      聚合物及分散劑;100% Sulfur,        硫磺;' where IM_Name = 'Atnen TMTD-80'

---

仓库库存检验问题：

SELECT * FROM [Hightone].[dbo].[usrStockQty] where iStatus='2'    【查询】
                                                                                                               
update [Hightone].[dbo].[usrStockQty] set sLotNo2='KL628121' where iStatus='2'       

---

删除旧数据：

delete from [Hightone].[dbo].[usrInLabel] where cast(sManufactureDate  as datetime)<'2013-12-30'