百胜BS3000+用到的一些语句-1

 

 delete from SAVEDETAIL where DJBH='JORDER330894656'
 
 delete from SAVEDETAIL where DJBH='JORDER331043828'
 
 
 
select 1 from JORDER with (nolock) where DJBH='JH1000023'
--test
select * from JORDER with (nolock) where DJBH='JH1000023'

go
 delete from SAVEDETAIL where DJBH='JORDER331145562' and SPDM='111MA10853'
 insert into SAVEDETAIL (DJBH, MXBH, SPDM, GG1DM, GG2DM, SL)          values ('JORDER331145562', '1', '111MA10853', '05', '01', 3.00)
 insert into SAVEDETAIL (DJBH, MXBH, SPDM, GG1DM, GG2DM, SL)          values ('JORDER331145562', '2', '111MA10853', '05', '02', 3.00)
 insert into SAVEDETAIL (DJBH, MXBH, SPDM, GG1DM, GG2DM, SL)          values ('JORDER331145562', '3', '111MA10853', '05', '03', 3.00)
 insert into SAVEDETAIL (DJBH, MXBH, SPDM, GG1DM, GG2DM, SL)          values ('JORDER331145562', '4', '111MA10853', '05', '04', 3.00)
 insert into SAVEDETAIL (DJBH, MXBH, SPDM, GG1DM, GG2DM, SL)          values ('JORDER331145562', '5', '111MA10853', '05', '05', 3.00)

 

 

 delete from SAVEDETAIL where DJBH='JORDER331145562'
 
 
 
 --测试
select * from JORDERMX

select * from JORDER
--
SELECT * FROM JORDERMX;
SELECT * FROM JORDER;

UPDATE [BS3000+_000_2010].[dbo].[JORDER] set DM2='001' WHERE DJBH='JH1000001';

exec sp_executesql N'SELECT * FROM UserVendors WHERE vUserCode=@P1
', N'@P1 varchar(4)', '0301'

SELECT * FROM SPJHD
SELECT * FROM SPJHDMX

 

--查询商品进货订单
SELECT * FROM JORDER
SELECT * FROM JORDERMX
-----------------------------------------------------》
--商品进货订单状态更改
--SELECT 23 AND 25 LIST DIFF!
SELECT * FROM JORDER WHERE DJBH='JH1000023' OR DJBH='JH1000025';
--商品进货订单未知
UPDATE JORDER SET YS = null WHERE DJBH='JH1000023';
--商品进货订单审核状态！
UPDATE JORDER SET JZ='1' WHERE DJBH='JH1000023';
--商品进货订单执行状态
UPDATE JORDER SET JS='1' WHERE DJBH='JH1000023';
--商品进货订单终止状态
UPDATE JORDER SET SP='1' WHERE DJBH='JH1000023';

-----------------------------------------------------《
--删除商品进货订单的顺序
DELETE FROM JORDERMX WHERE DJBH='JH1000004';
DELETE FROM JORDER   WHERE DJBH='JH1000004';

 

 

 

--查找生产通知单 的审核 和 执行
--查询通知单
SELECT * FROM  JSEND
SELECT * FROM  JSENDMX

UPDATE JSEND SET YS='0' WHERE DJBH='JH2000001';
UPDATE JSEND SET JZ='0' WHERE DJBH='JH2000001';
UPDATE JSEND SET JS='0' WHERE DJBH='JH2000001';
UPDATE JSEND SET SP='0' WHERE DJBH='JH2000001';

--删除生产通知单的顺序
DELETE FROM JSENDMX WHERE DJBH='JH2000006';
DELETE FROM JSEND   WHERE DJBH='JH2000006';

 

生产3步
--生产入库单
SELECT * FROM SPJHD
SELECT * FROM SPJHDMX

--删除生产入库单的顺序
DELETE FROM SPJHDMX WHERE DJBH='JH3000006';
DELETE FROM SPJHD   WHERE DJBH='JH3000006';