窗口收费存储过程.sql

水费管理系统

/*
	功能: 生成窗口收费用户单据,并返回单据ID号
*/

if exists(select * from sysobjects where type='P' and name = 'wsp_gen_cust_win_receipt')
	drop proc wsp_gen_cust_win_receipt
go

create proc wsp_gen_cust_win_receipt
					(@cust_code varchar(20),
					@cust_name varchar(30),
					@oper_code varchar(20),
					@fee_sum money,
					@this_fee_sum money,
					@last_balance money,
					@this_balance money,
					@print_stat tinyint = 0
					)
as
	insert into cust_win_receipt(cust_code, cust_name, fee_sum, act_fee_sum,  last_balance, this_balance, print_stat, oper_code)
		values(@cust_code, @cust_name,@fee_sum, @this_fee_sum, @last_balance,@this_balance, @print_stat, @oper_code)
	return scope_identity()
go


/*
	功能: 查询窗口收费用户单据
*/

if exists(select * from sysobjects where type='P' and name = 'wsp_qry_cust_win_receipt')
	drop proc wsp_qry_cust_win_receipt
go

create proc wsp_qry_cust_win_receipt(@receipt_sn int)
as
select * from cust_win_receipt where receipt_sn = @receipt_sn
go