加盟配送单直接转调拨申请单

wbv123

declare @srcbusno varchar(20),@objbusno varchar(20),@billno varchar(30),@distno varchar(30)
set @distno = ‘21080900000592’ —配送单单号
set @objbusno = ‘130’ –调入门店
set @srcbusno =’252′ –调出门店

IF OBJECT_ID(‘tempdb..#u_store_c_out’) IS NOT NULL DROP TABLE #u_store_c_out

SELECT a.objbusno,b.wareid, m.minqty as safeqty ,m.maxqty as overqty , m.sumqty as wareqty,b.wareqty as applyqty ,
m.lastmqty as salemonqty,
i.purprice,q.saleprice,b.batchno,b.idno,i.makeno,i.invalidate,b.rowid,i.midqty,i.invalidate_char ,
i.distprice,b.objbatchno,b.objidno,b.objstallno,q.saletax
INTO #u_store_c_out
FROM dbo.u_dist_m a (NOLOCK) ,dbo.u_dist_c b (NOLOCK)
LEFT JOIN u_store_i i(NOLOCK) ON i.wareid=b.wareid AND i.batchno=b.batchno AND i.idno=b.idno
LEFT JOIN u_ware_q q(NOLOCK) ON q.wareid=b.wareid ,u_store_m m(NOLOCK)
WHERE a.distno=b.distno and a.billcode in (‘DIS’,’ADD’) and a.status=1 and m.wareid=b.wareid AND m.busno=a.objbusno and a.distno=@distno
and m.sumqty>0

–配送转店间调拨单
exec p_skip ‘APD’
select @billno = serialno from dbo.f_get_serialno(‘APD’)

INSERT dbo.u_distapply_m(billcode,applyno,srcbusno,objbusno,status,
checkbit1,checker1,checkbit2,checker2,checkbit3,checker3,checkbit4,checker4,
execdate,createuser,createtime,notes,distno,mark,init_createtime,init_createuser,bak1)

select ‘APD’,@billno,@srcbusno,@objbusno,0,
0,null,0,null,0,null,0,null,
null,’168′,getdate(),’配送转调拨’,null,0,getdate(),’168′ ,@distno

INSERT u_distapply_c(applyno,wareid,safeqty,overqty,wareqty,applyqty,
salemonqty,purprice,salerpice,checkqty,distqty,parityflag,parityware,
batchno,idno,makeno,invalidate,rowid,stallno,bandcode,notes,saletax)

SELECT @billno,a.wareid ,safeqty,overqty,wareqty,applyqty,
isnull(salemonqty,0),purprice,saleprice , applyqty as checkqty,0,”,”,
isnull(objbatchno,batchno) ,isnull(objidno,idno ),makeno ,invalidate,rowid,@srcbusno as stallno ,null,’配送转调拨’,saletax
FROM #u_store_c_out a

select ‘店间调拨单号: ‘+@billno