首页 > 其他 > 详细

0118工作备份

时间:2017-01-18 12:28:39      阅读:260      评论:0      收藏:0      [点我收藏+]

select * from ICTransType
select * from ICTemplateEntry where fid=‘B08‘
select * from ppbom where FBillNo=‘PBOM000278‘
select * from ppbomentry where FInterID=1278
select ficmointerid from ICStockBillEntry
select * from t_Department
select * from t_Item where FItemClassID=2
select a1.fitemid,a1.FAuxQty,a1.FICMOInterID from ICStockBillEntry a1 inner join ppbom b1 on a1.FICMOInterID=b1.FICMOInterID

inner join ICStockBill c1 on a1.finterid=c1.finterid where c1.FTranType=28
select * from ppbom where FICMOInterID=1380
select fitemid,FAuxStockQty from ppbomentry where FInterID=1618

DECLARE @FFAUXQTY decimal(18,10)
DECLARE @FITEMID int
DECLARE @FDCSTOCKID int
DECLARE @finterid int
DECLARE @FAuxStockQty int
DECLARE @FTranType int
DECLARE @FAuxQtyMust decimal(18,10)
DECLARE @FICMOInterID int
DECLARE @ppbomfinterid int
DECLARE @FQTY decimal(18,10)
DECLARE @FAUXQTY decimal(18,10)
DECLARE #point_cursor CURSOR
FOR
SELECT a1.FItemID ,a1.FAuxQty,a1.FICMOInterID from
ICStockBillEntry a1 inner join ppbom b1 on a1.FICMOInterID=b1.FICMOInterID
inner join ICStockBill c1 on a1.finterid=c1.finterid where c1.FTranType=28
OPEN #point_cursor
FETCH NEXT FROM #point_cursor INTO @fitemid,@FAuxStockQty,@FICMOInterID
while @@fetch_status = 0
BEGIN

select @ppbomfinterid=finterid from PPBOM where FICMOInterID=@FICMOInterID
update ppbomentry set FAuxStockQty=FAuxStockQty+@FAuxStockQty where FInterID=@ppbomfinterid and FItemID=@FITEMID
FETCH NEXT FROM #point_cursor INTO @fitemid,@FAuxStockQty,@FICMOInterID
END
CLOSE #point_cursor
DEALLOCATE #point_cursor

update ppbomentry set FAuxStockQty=0

0118工作备份

原文:http://www.cnblogs.com/xujiating/p/6295995.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!