QSP_GET_BACK_SIGN 存储过程：获取待回签信息

ALTER PROCEDURE QSP_GET_BACK_SIGN @site varchar(20) AS

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

declare @b3 int declare @b4 int SELECT @b3=b3,@b4=b4 FROM b_arg

SELECT 0 as ischecked, a.unit, a.billno, a.billdate, a.bsite, a.esite, a.state, a.shipper, a.consignee, a.product, a.qty,

     backqty,

s1=case when fetchdate IS NOT NULL AND fetchdate <> '' then 1 else 0 end, s2=case when modifyremark IS NOT NULL AND modifyremark <> '' then 1 else 0 end, s3=case when isnull(isbad, 0) > 0 then 1 else 0 end, s4=case when outinoneflag <> '' then 1 else 0 end, acctype, accnow,accarrived,accback,accmonth,accdaishou,acczz,accsend, webid ,createby,outcygs,outdate, acctype,shippertel,shippermb,a.middlesite,outbillno,vipno,addr,weight,volumn,fapiaono,shippercompany,consigneecompany,acchuokuankou,acctotal,acctax FROM B_TYD as a left join b_tyd_trace_tpl as b on (a.unit=b.unit)
WHERE ( a.esite = @site OR a.middlesite = @site OR (a.bsite=@site AND @b4=1) OR ( a.bsite = @site AND ( (a.state=10 AND tosite=0) OR okprocess = '司机直送' ) ) ) AND signdate IS NULL AND isnull(backrecipient, '') = '' AND isnull(a.backqty, '') <> '' AND a.state<>100 AND a.state<>11