获取存储过程传值

CREATE  PROCEDURE m_eform_data_saveTomaster
  
 @formno nvarchar(30),
 @peoId int = null,
 @managerPeoid int = null,
 @sendDate datetime = null,
 @meno text,
 @formType smallint = 0,

             @formId int output
 AS
  SET NOCOUNT ON

set @sendDate = getdate()
 
if  @PeoId is not  null  --and (select count(*) as c from M_Form_master where peoId = @PeoId ) = 0
begin
 insert into  M_Form_master
  (  
 formno,
 peoId,
 managerPeoid,
 sendDate,
 meno,
 formType
 )
 values(  
 @formno,
 @peoId,
 @managerPeoid,
 @sendDate,
 @meno,
 @formType
 )

set @formId = (SELECT  @@identity as 'formId')    //  or  set @formId = @@identity( 表内自增形)
end
return 0
GO
 

 

CS 文件

p[5] = new SqlParameter("@formId",SqlDbType.Int);
            p[5].Direction=ParameterDirection.Output;
    
       SqlHelper.ExecuteNonQuery(MyConfig.MyConfigSectionHandler.ConnectionString,CommandType.StoredProcedure,"m_eform_data_saveTomaster ",p);


   string formId = p[5].Value.ToString();