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();