proc_删除销售单.sql

来自「SQL server 进销存软件数据库设计。大家积极下载」· SQL 代码 · 共 26 行

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