proc_mis_gr_overview.sql

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

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

create procedure Proc_MIS_GR_Overview
@order_num varchar(30) = null,
@hpn varchar(18) = null
as
begin

	if(isnull(@hpn,'')='') 
	begin
   
	select  
	DN_Number as [DN Number],
	HPN,
	convert(varchar(50),Creation_dt) as [Creation Date],
	created_by as [Created By],
	convert(varchar(50),Rcv_Qty) as [GR Quantity] 
	From View_MIS_GR_List 
	where Order_Number =@order_num 
	union
all
select '','','','GR Total:',convert(varchar(50),sum(rcv_qty))  from View_MIS_GR_List
where Order_Number =@order_num  group by  hpn
end
else
begin
select  
DN_Number as [DN Number],
HPN,
convert(varchar(50),Creation_dt) as [Creation Date],
created_by as [Created By],
convert(varchar(50),rcv_qty) as [GR Quantity] 
From View_MIS_GR_List 
where Order_Number =@order_num and hpn =@Hpn
union
all
select '','','','GR Total:',convert(varchar(50),sum(rcv_qty))  from View_MIS_GR_List
where Order_Number =@order_num and hpn =@hpn  group by  hpn
end
end
	



/*

  Proc_MIS_GR_Overview 'PO04-00563',null

*/