数据库查改案例

admin

选择数据lxsysdata
修改单个供应商抬头
select * from CKRKh where swh='R00090506'  
select * from cgpjh where swh='R00090506'
select * from kcswh where swh='R00090506'


update ckrkh set gys='新的公司抬头有限公司',gysdm='3187' where swh='R00090506'            备注：3187供应商为新公司代码     
update cgpjh set gys='新的公司抬头有限公司',gysh='3187',fktgysh='3187' where swh='R00090506'
update kcswh set gysdm='3187' where swh='R00090506'


批量修改供应商抬头
select * from cgpjh where gysh='2631'     备注：2631供应商代码
update cgpjh set gys='绍兴市袍江术生五金修理部',gysh='2423',fktgysh='2423' where swrq>'2017-9-1' and gysh='2631'
update ckrkh set gys='绍兴市袍江术生五金修理部',gysdm='2423' where swrq>'2017-9-1' AND gysdm='2631'


修改打印标签模版
select * from dcdh where khmc='隆泰'
update dcdh set bqgs='万达利' where khmc='隆泰'




成品完工入库单
查表头  select * from cpwgrkdH where djlsh=1454806
查表体  select * from cpwgrkdB where djlsh=1454806


改表头 白坯数量UPDATE cpwgrkdH set BPPS=50.00 WHERE djlsh=1469292
       合计重量UPDATE cpwgrkdH set HJZL=715.25 WHERE djlsh=1476388


修改表体 重量  UPDATE cpwgrkdB SET ZL=23 WHERE djlsh=1454806 AND ph=17
修改表体 米数  UPDATE cpwgrkdB SET ms=.00 WHERE djlsh=1470613 AND ph>25


djlsh单据流水号   ZL重量   ph匹号


勾选字段单据流水号


删除销售出库编号DXJTMLSBBFH重复问题,(这个跟之前出的批量冲突所以有002)
select * from DXJTMLSBBFH where bh='0700072118001'
select * from DXJTMLSBBFH where bh='0700072118002'
delete from DXJTMLSBBFH where bh='0700072118001'




SELECT * FROM KCSWH WHERE WPH='10600000xxx' ORDER BY SWRQ
SELECT * FROM  ILIFH WHERE WPH='10600000xxx' AND CKH='32' ORDER BY NIAN,YUE
UPDATE ILIFH SET CBDJ=22500.00,JSJE=45000.00,FF=0,FFJE=0,XYSL=2,XYJE=45000.00 WHERE DJLSH=587xxx
UPDATE ILIFH SET CBDJ=22500.00,QC=2,QCJE=45000.00,FF=2,FFJE=45000.00,XYSL=0,XYJE=0 WHERE DJLSH=592xxx
UPDATE ILIFH SET CBDJ=22500.00,QC=0,QCJE=0,FF=0,FFJE=0,XYSL=0,XYJE=0 WHERE DJLSH=597xxx