alter PROCEDURE QSP_GET_BACK_SIGN site varchar20 AS SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTEDdeclare b3 intdeclare b4 intSELECT b3=b3b4=b4 FROM b_arg SELECT 0 as ischecked

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 <> 1