插入数据并返回ID

CREATE procedure pr_AddProduct
(
    @ChineseName nvarchar(50),
    @EnglishName nvarchar(50),
    @Supplier text,
    @MOQ float,
    @Material nvarchar(50),
    @Size        float    ,
    @SGW        nvarchar(50),
    @CategoryID    int    ,
    @TPI        text    ,
    @RSC decimal
)
as
  Declare @ProductId int
begin transaction
insert into
Product
(
ChineseName,
EnglishName,
Supplier,
MOQ,
Material,
size,
SGW,
CategoryID,
TPI,
RSC
)
VALUES
(
    @ChineseName ,
    @EnglishName,
    @Supplier ,
    @MOQ,
    @Material ,
    @Size        ,
    @SGW        ,
    @CategoryID    ,
    @TPI        ,
    @RSC
)
Select @ProductId=@@IDENTITY
commit transaction
return @ProductId
GO

     public int AddProduct(Product prtd)
        ...{
            try
            ...{
                string strsql = "pr_AddProduct";
                SqlParameter[] sqlParam =
                ...{
                    new SqlParameter("@ChineseName",SqlDbType.NVarChar),
                    new SqlParameter("@EnglishName",SqlDbType.NVarChar),
                    new SqlParameter("@Supplier",SqlDbType.Text),
                    new SqlParameter("@MOQ",SqlDbType.Float),
                    new SqlParameter("@Material",SqlDbType.NVarChar),
                    new SqlParameter("@size",SqlDbType.Float),
                    new SqlParameter("@SGW",SqlDbType.NVarChar),
                    new SqlParameter("@CategoryID",SqlDbType.Int),
                    new SqlParameter("@TPI",SqlDbType.Text),
                    new SqlParameter("@RSC",SqlDbType.NVarChar),
                    new SqlParameter("@ReturnValue",SqlDbType.Int)
                };
                sqlParam[0].Value = prtd.ChineseName;
                sqlParam[1].Value = prtd.EnglishName;
                sqlParam[2].Value = prtd.Supplier;
                sqlParam[3].Value = prtd.MOQ;
                sqlParam[4].Value =prtd.Material;
                sqlParam[5].Value=prtd.Size;
                sqlParam[6].Value=prtd.Sgw;
                sqlParam[7].Value=prtd.CategoryID;
                sqlParam[8].Value = prtd.Tpi;
                sqlParam[9].Value = prtd.Rsc;
        sqlParam[10].Direction=System.Data.ParameterDirection.ReturnValue;
                
        SqlHelper.ExecuteNonQuery(SqlHelper.CONNSTR, CommandType.StoredProcedure, strsql, sqlParam);
        return Convert.ToInt32(sqlParam[10].Value);
            }
            catch(Exception ex)
            ...{
                throw ex;
            }
        }