/// <summary>
/// 根据产品编号，获取组合方式
/// </summary>
/// <param name="proid">组合产品ID</param>
/// <returns></returns>
public static IList <ProductCombineDetailModel> GetCombineDetil(int proid)
{
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@combineProductID", SqlDbType.Int, 4)
};
paras[0].Value = proid;
DataTable dt = DBHelper.ExecuteDataTable("select a.*,b.PreferentialPrice,b.PreferentialPV from ProductCombineDetail a join Product b on a.SubProductID=b.ProductID where a.CombineProductID=@combineProductID", paras, CommandType.Text);
IList <ProductCombineDetailModel> comDetails = new List <ProductCombineDetailModel>();
foreach (DataRow dr in dt.Rows)
{
ProductCombineDetailModel comDetail = new ProductCombineDetailModel();
comDetail.ID = Convert.ToInt32(dr["ID"]);
comDetail.CombineProductID = Convert.ToInt32(dr["CombineProductID"]);
comDetail.SubProductID = Convert.ToInt32(dr["SubProductID"]);
comDetail.Quantity = Convert.ToInt32(dr["Quantity"]);
comDetail.UnitPrice = Convert.ToInt32(dr["PreferentialPrice"]);
comDetail.PV = Convert.ToInt32(dr["PreferentialPV"]);
comDetail.Remark = Convert.ToString(dr["remark"]);
comDetails.Add(comDetail);
}
return(comDetails);
}
/// <summary>
/// 向组合产品中插入相关信息
/// </summary>
/// <param name="proCombineDetail">组合产品参数</param>
/// <returns>返回插入组合产品所影响的行数</returns>
public static int AddCombineProduct(ProductCombineDetailModel proCombineDetail)
{
SqlParameter[] sparams = new SqlParameter[]
{
new SqlParameter("@combineProductID", SqlDbType.Int),
new SqlParameter("@subProductID", SqlDbType.Int),
new SqlParameter("@quantity", SqlDbType.Int)
};
sparams[0].Value = proCombineDetail.CombineProductID;
sparams[1].Value = proCombineDetail.SubProductID;
sparams[2].Value = proCombineDetail.Quantity;
return(DBHelper.ExecuteNonQuery("AddCombineProduct", sparams, CommandType.StoredProcedure));
}
/// <summary>
/// 向组合产品中插入相关信息
/// </summary>
/// <param name="proCombineDetail">组合产品参数</param>
/// <returns>返回插入组合产品所影响的行数</returns>
public static int AddCombineProduct(ProductCombineDetailModel proCombineDetail)
{
return(ProductCombineDetailDAL.AddCombineProduct(proCombineDetail));
}
