<pre><code>

alter PROCEDURE [BAD_GET_BASE_INFO]
@unit int,
@billno varchar(30)
AS
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

declare @count int
IF(@unit>0)
SELECT @count=count() FROM bad WHERE unit=@unit
else
SELECT @count=count() FROM bad WHERE unit=(SELECT top 1 unit FROM b_tyd WHERE billno=@billno)

IF(@count>0)
begin
declare @s varchar(1000)
set @s='運(yùn)單號(hào)為%d(貨號(hào)為%s)的運(yùn)單已經(jīng)登記過貨損信息了！'+char(13)+char(10)+'如果需要修改，請(qǐng)?jiān)跔I(yíng)運(yùn)中心-異常登記中處理!'
raiserror(@s,16,1,@unit,@billno)
end
else
begin
IF(@billno='' or (@unit <> 0 AND @billno <> '')) --按運(yùn)單號(hào)
SELECT unit,billno,product,qty,package,billdate, bsite,esite,shipper,consignee, accdeclare,accsafe FROM b_tyd WHERE unit=@unit

 IF(@unit=0) --按貨號(hào)
    SELECT  unit,billno,product,qty,package,billdate, bsite,esite,shipper,consignee, accdeclare,accsafe  FROM b_tyd  WHERE  billno=@billno

end
</pre></code>