C#代码
public int insertEntity(CreditLeafEntity entity)
{
int iResult=0;
SqlParameter[] paramater = new SqlParameter[]{
new SqlParameter("@CreditLeaf_name" , entity.CreditLeaf_name),
new SqlParameter("@CreditLeaf_upId" , entity.CreditLeaf_upId),
new SqlParameter("@CreditLeaf_enable" , entity.CreditLeaf_enable),
new SqlParameter("num", "")};
paramater[3].Direction = ParameterDirection.ReturnValue;
try
{
iResult = SqlHelper.ExecuteNonQuery(SqlHelper.strDBConnString
, CommandType.StoredProcedure
, "creditLeaf_insert"
, paramater);
}
catch (Exception ex)
{
throw ex;
}
String str = paramater[3].Value.ToString();
return Convert.ToInt32(paramater[3].Value);
}
存储过程:
ALTER PROCEDURE [dbo].[creditLeaf_insert]
(
@CreditLeaf_name varchar(20),
@CreditLeaf_upId int,
@CreditLeaf_enable bit
)
AS
BEGIN
insert into tb_creditLeaf values
(
@CreditLeaf_name,
@CreditLeaf_upId,
@CreditLeaf_enable
)
RETURN @@identity
END