店间调拨太大导致传输不过的解决办法

wbv123

select ‘insert #ws_u_distapply_m select ‘+dbo.f_var_to_string(billcode)+’,’+dbo.f_var_to_string(applyno)+’,’+dbo.f_var_to_string(srcbusno)+’,’+dbo.f_var_to_string(objbusno)+’,’+dbo.f_var_to_string(status)+’,’+dbo.f_var_to_string(checkbit1)+’,’+dbo.f_var_to_string(checker1)+’,’+dbo.f_var_to_string(checkbit2)+’,’+dbo.f_var_to_string(checker2)+’,’+dbo.f_var_to_string(checkbit3)+’,’+dbo.f_var_to_string(checker3)+’,’+dbo.f_var_to_string(checkbit4)+’,’+dbo.f_var_to_string(checker4)+’,’+dbo.f_var_to_string(execdate)+’,’+dbo.f_var_to_string(createuser)+’,’+dbo.f_var_to_string(createtime)+’,’+dbo.f_var_to_string(notes)+’,’+dbo.f_var_to_string(distno)+’,’+dbo.f_var_to_string(splitno)+’,’+dbo.f_var_to_string(applytype)+’,’+dbo.f_var_to_string(retdistno)+’,’+dbo.f_var_to_string(vendorno)
from u_distapply_m a
where status in (0,1,3) ~and applyno=’2007020231002′~ and billcode=’APD’ and checkbit1 = 1 and stamp > cast(cast($minserialno as bigint) as timestamp) and stamp <= cast(cast($maxserialno as bigint) as timestamp)
and ($tranorg_obj = ‘0000’ or
exists(select * from c_org_busi i (nolock) where i.busno in (a.srcbusno,a.objbusno) and i.org_tran_code in ($tranorg_src,$tranorg_obj))
)

union all

select ‘insert #ws_u_distapply_c select ‘+dbo.f_var_to_string(b.applyno)+’,’+dbo.f_var_to_string(rtrim(wareid))+’,’+dbo.f_var_to_string(safeqty)+’,’+dbo.f_var_to_string(overqty)+’,’+dbo.f_var_to_string(wareqty)+’,’+dbo.f_var_to_string(applyqty)+’,’+dbo.f_var_to_string(salemonqty)+’,’+dbo.f_var_to_string(purprice)+’,’+dbo.f_var_to_string(salerpice)+’,’+dbo.f_var_to_string(checkqty)+’,’+dbo.f_var_to_string(distqty)+’,’+dbo.f_var_to_string(parityflag)+’,’+dbo.f_var_to_string(parityware)+’,’+dbo.f_var_to_string(batchno)+’,’+dbo.f_var_to_string(idno)+’,’+dbo.f_var_to_string(makeno)+’,’+dbo.f_var_to_string(distno_list)+’,’+dbo.f_var_to_string(distno_qty)+’,’+dbo.f_var_to_string(invalidate)+’,’+dbo.f_var_to_string(rowid)+’,’+dbo.f_var_to_string(stallno)+’,’+dbo.f_var_to_string(bandcode)+’,’+dbo.f_var_to_string(b.notes)+’,’+dbo.f_var_to_string(batqty)+’,’+dbo.f_var_to_string(groupid)
from u_distapply_m a,u_distapply_c b
where a.applyno =b.applyno ~~and a.applyno=’2007020231002′~~ and a.status in (0,1,3) and billcode=’apd’ and checkbit1=1 and stamp > cast(cast($minserialno as bigint) as timestamp) and stamp <= cast(cast($maxserialno as bigint) as timestamp)
and ($tranorg_obj = ‘0000’ or
exists(select * from c_org_busi i (nolock) where i.busno in (a.srcbusno,a.objbusno) and i.org_tran_code in ($tranorg_src,$tranorg_obj))
)

店间调拨申请单传输太大传输不过去的情况下在WS传输项目中APP(ZZ)中修改传输提。让门店单独一个单子一个单子传输。过程中要WS传输设置传出传入做清零（设置小）操作。