proc_sign_log_write.sql

工厂采购系统,DELPHI+SQL SERVER,三层技术

if object_id('dbo.Proc_Sign_Log_Write') is not null
drop procedure dbo.Proc_Sign_Log_Write
go

create procedure Proc_Sign_Log_Write
@Order_number varchar(30) = null,
@signatured_by varchar(15) = null

as
begin
	 insert into PO_Signature_log
	(Order_number,version,signatured_by,signatured_dt)
	select pono,version,@signatured_by,getdate() from ord_mst
	where pono = @order_number
	
	if (@@error=0)
	 update ord_mst 
		    set confirmed_sig ='Y',
			confirmed_by = @signatured_by,
			confirmed_dt = getdate()
	where pono = @order_number
end
go