IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE NAME='proc_刪除銷售單' AND TYPE='P')
DROP PROC proc_刪除銷售單
go
create proc proc_刪除銷售單
@源銷售單 INT,
@as_ren CHAR(1) OUTPUT---'0'-->成功;'1'---源銷售單不存在;'2'---目標銷售單存在;
AS
BEGIN
DECLARE @li_count integer
select @li_count=count(*) from 銷售訂單明細表 WHERE 銷售單號=@源銷售單  
if isnull(@li_count,0)=0
begin
select @as_ren='1'
return
end
select @li_count=count(*) from 銷售訂單明細表 WHERE 銷售單號=@源銷售單  
if isnull(@li_count,0)>0
begin
DELETE FROM 銷售訂單明細表  WHERE 銷售單號=@源銷售單  
DELETE FROM 銷售單_金額 WHERE 銷售單號=@源銷售單
DELETE FROM 銷售單_稅 WHERE 銷售單號=@源銷售單
DELETE FROM 銷售單_基本  WHERE 銷售單號=@源銷售單
select @as_ren='0'
END
END