proc_+

本系统为企业进存销管理系统

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