/// <summary>
/// 更新指定产品适用人群
/// </summary>
/// <param name="productSexType">适用人群模型</param>
/// <returns>返回更新指定产品适用人群所影响的行数</returns>
public static int UpdProductSexTypeByID(ProductSexTypeModel productSexType)
{
SqlParameter[] sparams = new SqlParameter[]
{
new SqlParameter("@productSexTypeID", SqlDbType.Int),
new SqlParameter("@productSexTypeName", SqlDbType.VarChar, 50),
new SqlParameter("@productSexTypeDescr", SqlDbType.VarChar, 50)
};
sparams[0].Value = productSexType.ProductSexTypeID;
sparams[1].Value = productSexType.ProductSexTypeName;
sparams[2].Value = productSexType.ProductSexTypeDescr;
return(DBHelper.ExecuteNonQuery("UpdProductSexTypeByID", sparams, CommandType.StoredProcedure));
}
/// <summary>
/// 向产品适用人群表中插入记录
/// </summary>
/// <param name="productSexType">适用人群模型</param>
/// <returns>返回插入记录所影响的行数</returns>
public static int AddProductSexType(SqlTransaction tran, ProductSexTypeModel productSexType, out int id)
{
int addCount = 0;
SqlParameter[] sparams = new SqlParameter[]
{
new SqlParameter("@productSexTypeName", SqlDbType.VarChar, 50),
new SqlParameter("@productSexTypeDescr", SqlDbType.VarChar, 50),
new SqlParameter("@identityId", SqlDbType.Int)
};
sparams[0].Value = productSexType.ProductSexTypeName;
sparams[1].Value = productSexType.ProductSexTypeDescr;
sparams[2].Value = ParameterDirection.Output;
addCount = DBHelper.ExecuteNonQuery(tran, "AddProductSexType", sparams, CommandType.StoredProcedure);
id = Convert.ToInt32(sparams[2].Value);
return(addCount);
}
/// <summary>
/// 查询产品适用人群
/// </summary>
/// <param name="productSexTypeID"></param>
/// <returns></returns>
public static ProductSexTypeModel GetProductSexTypeItem(int productSexTypeID)
{
string cmd = "select ProductSexTypeID,ProductSexTypeName,ProductSexTypeDescr from ProductSexType where ProductSexTypeID=@ProductSexTypeID";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@ProductSexTypeID", productSexTypeID)
};
SqlDataReader dr = DBHelper.ExecuteReader(cmd, param, CommandType.Text);
dr.Read();
ProductSexTypeModel psm = new ProductSexTypeModel();
psm.ProductSexTypeID = Convert.ToInt32(dr["ProductSexTypeID"]);
psm.ProductSexTypeName = dr["ProductSexTypeName"].ToString();
psm.ProductSexTypeDescr = dr["ProductSexTypeDescr"].ToString();
dr.Close();
return(psm);
}
/// <summary>
/// 向产品适用人群表中插入记录
/// </summary>
/// <param name="productSexType">适用人群模型</param>
/// <returns>返回插入记录所影响的行数</returns>
public static int AddProductSexType(SqlTransaction tran, ProductSexTypeModel productSexType, out int id)
{
return(ProductSexTypeDAL.AddProductSexType(tran, productSexType, out id));
}
/// <summary>
/// 更新指定产品适用人群
/// </summary>
/// <param name="productSexType">适用人群模型</param>
/// <returns>返回更新指定产品适用人群所影响的行数</returns>
public static int UpdProductSexTypeByID(ProductSexTypeModel productSexType)
{
return(ProductSexTypeDAL.UpdProductSexTypeByID(productSexType));
}
