急！！！asp.net和sql server 各位师傅帮帮小女子

请各位高手帮帮忙，我怎么把以下的存储过程在页面中改写成sql语句？谢谢了
CREATE PROCEDURE [Proc_GetOrderInfo]
(
 @Flag int,
 @IsMember int,
 @MemberID int,
 @OrderID int,
 @Confirm int,
 @Payed int,
 @Shipped int,
 @Finished int,
 @IsConfirm int,
 @IsPayment int,
 @IsConsignment int,
 @IsPigeonhole int)
as
if(@IsMember>0)
begin
declare
            @Msql varchar(1024)
set @Msql='select * from tb_OrderInfo  where MemberID ='+ convert(varchar(20),@MemberID)

            if @Confirm>0
                
begin
set @Msql=@Msql+'and IsConfirm='+ convert(varchar(20),@isConfirm)
end
if @Payed>0
begin
set @Msql=@Msql+'and IsPayment='+ convert(varchar(20),@IsPayment)
end
if @Shipped>0
begin
set @Msql=@Msql+'and IsConsignment='+ convert(varchar(20),@IsConsignment)
end
if @Finished>0
begin
set @Msql=@Msql+'and IsPigeonhole='+ convert(varchar(20),@IsPigeonhole)
end
           exec(@Msql)
  end
else if(@IsMember=0) 
begin
if(@Flag=1)
begin
  select * from tb_OrderInfo   where IsConfirm=@IsConfirm 
end
else if(@Flag=2)
begin
  select * from tb_OrderInfo  where IsPayment=@IsPayment 
end
else if(@Flag=3)
begin
  select * from tb_OrderInfo  where IsConsignment=@IsConsignment 
end
else if(@Flag=4)
begin
  select * from tb_OrderInfo  where IsPigeonhole=@IsPigeonhole
end
else if(@Flag=0)
begin
declare
@Osql  varchar(1024)
set @Osql='select * from tb_OrderInfo where OrderID ='+ convert(varchar(20), @OrderID)
           if @Confirm>0
begin
set @Osql=@Osql+'and IsConfirm='+ convert(varchar(20), @IsConfirm)
end
if @Payed>0
begin
set @Osql=@Osql+'and IsPayment='+ convert(varchar(20), @IsPayment)
end
if @Shipped>0
begin
set @Osql=@Osql+'and IsConsignment='+ convert(varchar(20), @IsConsignment)
end
if @Finished>0
begin
set @Osql=@Osql+'and IsPigeonhole='+ convert(varchar(20), @IsPigeonhole)
end
   exec(@Osql)
  end
end
GO