//按商品类别获取该类别下所有的商品信息(存储过程) public List<Model.ProductBase> GetpInfoByTypeId(int cid) { List<Model.ProductBase> goodsI = new List<Model.ProductBase>(); SqlParameter[] ps = new SqlParameter[] { new SqlParameter("@ptid",cid), }; DataTable table = DbHelperSQL.GetTable("GetpInfoByTypeId", ps); foreach (DataRow r in table.Rows) { Model.ProductBase p = new Model.ProductBase(); p.p_Name = r["p_Name"].ToString(); p.productSkuInfo = new Model.SKUBase { sku_Price = (decimal)r["sku_Price"], sku_scPric = (decimal)r["sku_scPric"], sku_ID = (int)r["sku_ID"], };//价格,skuid p.productImgInfo = new Model.ProductImgBase { pi_Url = r["pi_Url"].ToString() };//图片地址 p.productAttrInfo = new Model.ProductAttributesBase { pa_Name = r["shuxing"].ToString() };//全部属性 p.productAppInfo = new Model.ProductAppraiseBase { pa_ID = (int)r["countpl"] };//评价条数 goodsI.Add(p); } return goodsI; }
public ActionResult ProductsEdit() { this.ViewData["texOtype"] = RequestBase.GetString("otype"); BindControl bc = new BindControl(); ViewData["IsHasFunRole"] = Rolemanager.IsHasFunRole(EmployeeBase.e_ID, "001001001");//是否拥有管理的权限 Model.ProductBase model = new Model.ProductBase(); Model.RegionBase regmodel = new Model.RegionBase(); #region 运费模板下拉菜单 BLL.CarriageTempleteBase pctbll = new BLL.CarriageTempleteBase(); List<Model.CarriageTempleteBase> carmodel = pctbll.GetModelList(" ct_IsDel=0 and ct_StatusCode=0 "); List<SelectListItem> carriageTemplete = new List<SelectListItem>(); carriageTemplete = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "chose" } }; for (int i = 0; i < carmodel.Count; i++) { carriageTemplete.Add(new SelectListItem { Value = carmodel[i].ct_ID.ToString(), Text = carmodel[i].ct_Name }); } ViewData["carriageTemplete"] = new SelectList(carriageTemplete, "Value", "Text", "请选择"); #endregion #region 商品分类 下拉菜单 BLL.ProductTypeBase ptbll = new BLL.ProductTypeBase(); List<Model.ProductTypeBase> modelType = ptbll.GetModelList(" pt_parentId = 0 and pt_IsDel=0 and pt_StatusCode=0"); List<SelectListItem> pType = new List<SelectListItem>(); pType = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "chose" } }; for (int i = 0; i < modelType.Count; i++) { pType.Add(new SelectListItem { Value = modelType[i].pt_ID.ToString(), Text = modelType[i].pt_Name }); } ViewData["pType"] = new SelectList(pType, "Value", "Text", "请选择"); //中类 List<SelectListItem> zType = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "chose" } }; ViewData["zType"] = new SelectList(zType, "Value", "Text", "请选择"); #endregion #region 地区信息下拉菜单 List<Model.RegionBase> Pregion = regbll.GetModelList(" reg_PId = 0"); List<SelectListItem> Province = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "chose" } }; for (int i = 0; i < Pregion.Count; i++) { Province.Add(new SelectListItem { Value = Pregion[i].reg_ID.ToString(), Text = Pregion[i].reg_Name }); } ViewData["Province"] = new SelectList(Province, "Value", "Text", "请选择"); List<SelectListItem> City = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "chose" } }; ViewData["City"] = new SelectList(City, "Value", "Text", "请选择"); List<SelectListItem> Country = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "chose" } }; ViewData["Country"] = new SelectList(Country, "Value", "Text", "请选择"); List<SelectListItem> brandlist = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "chose" } }; ViewData["brands"] = new SelectList(brandlist, "Value", "Text", "请选择"); #endregion if (RequestBase.GetString("otype") == "modify") { string ids = RequestBase.GetString("dli_id"); ViewData["hfPId"] = ids; int id = int.Parse(ids.Split('|')[0]); string typeid = ids.Split('|')[1];//类别ID #region 修改时加载分类下拉列表 model = pbll.GetModel(id); Model.ProductTypeBase modelm = ptbll.GetModel(int.Parse(typeid));//当前小类,它的父ID是大类ID,PID=208,大类ID是207 List<Model.ProductTypeBase> modelType2 = ptbll.GetModelList(" pt_parentId =0 " );//大类 List<Model.ProductTypeBase> modelType3 = ptbll.GetModelList(" pt_parentId = " + modelm.pt_ParentId);//小类 //加载大类的下拉菜单 for (int i = 0; i < modelType2.Count; i++) { pType.Add(new SelectListItem { Value = modelType2[i].pt_ID.ToString(), Text = modelType2[i].pt_Name }); } ViewData["pType"] = new SelectList(pType, "Value", "Text", modelm.pt_ParentId); //加载小类的下拉菜单 for (int i = 0; i < modelType3.Count; i++) { zType.Add(new SelectListItem { Value = modelType3[i].pt_ID.ToString(), Text = modelType3[i].pt_Name }); } ViewData["zType"] = new SelectList(zType, "Value", "Text", modelm.pt_ID); #endregion #region 修改时加载地区下拉列表 regmodel = regbll.GetModel(model.p_Province);//43 Model.RegionBase citymodel = regbll.GetModel(model.p_City);//44 Model.RegionBase countrymodel = regbll.GetModel(model.p_County);//45 List<Model.RegionBase> model2 = regbll.GetModelList(" reg_PId = " + regmodel.reg_Code);//市 List<Model.RegionBase> model3 = regbll.GetModelList(" reg_PId = " + citymodel.reg_Code);//县 ViewData["Province"] = new SelectList(Province, "Value", "Text", regmodel.reg_ID); //加载市的下拉菜单 for (int i = 0; i < model2.Count; i++) { City.Add(new SelectListItem { Value = model2[i].reg_ID.ToString(), Text = model2[i].reg_Name }); } ViewData["City"] = new SelectList(City, "Value", "Text", citymodel.reg_ID); //加载县的下拉菜单 for (int i = 0; i < model3.Count; i++) { Country.Add(new SelectListItem { Value = model3[i].reg_ID.ToString(), Text = model3[i].reg_Name }); } ViewData["Country"] = new SelectList(Country, "Value", "Text", countrymodel.reg_ID); #endregion #region 修改时加载运费模板下拉列表 ViewData["carriageTemplete"] = new SelectList(carriageTemplete, "Value", "Text", model.ct_ID); #endregion #region 加载品牌下拉菜单 List<SelectListItem> selectbrand = new List<SelectListItem>(); List<Model.BrandBase> modelbrand = new BLL.BrandBase().GetModelList(" b_ID in (select b_ID from ProductTypeBrandBase where pt_ID=" + modelm.pt_ID + ")"); //加载品牌的下拉菜单 for (int i = 0; i < modelbrand.Count; i++) { selectbrand.Add(new SelectListItem { Value = modelbrand[i].b_ID.ToString(), Text = modelbrand[i].b_Name }); } ViewData["brands"] = new SelectList(selectbrand, "Value", "Text",new BLL.ProductBase().GetModel(id).b_ID); #endregion return View(model); } else { string pids = RequestBase.GetString("dli_id"); ViewData["hfPId"] = pids; return View(); } }
//获取商品信息(添加各个条件) public List<Model.ProductBase> GetpInfoByRecommendTypeId(int id) { List<Model.ProductBase> goodsI = new List<Model.ProductBase>(); SqlParameter[] ps = new SqlParameter[] { new SqlParameter("@ptid",id), }; DataTable table = DbHelperSQL.GetTable("GetpInfoByRecommendTypeId",ps); foreach (DataRow r in table.Rows) { Model.ProductBase p = new Model.ProductBase(); if (r["sku_Price"] != null && r["sku_Price"].ToString() != "") { StringBuilder strSqlgp = new StringBuilder(); strSqlgp.Append("select gp_ID,sku_ID,gp_StartTime,gp_EndTime,gp_pCount,gp_pPric,gp_CreateOn,gp_CreateBy,gp_StatusCode,gp_IsDel,gp_Logo,gp_Slogan,gp_SaleCount "); strSqlgp.Append(" FROM GroupPurchaseBase "); strSqlgp.Append(" where sku_ID=" + r["sku_ID"] + " and gp_StatusCode=0 and gp_IsDel=0 and gp_EndTime > '" + DateTime.Now + "'"); var gplist = DbHelperSQL.Query(strSqlgp.ToString()); if (gplist.Tables[0].Rows.Count > 0) { p.productSkuInfo = new Model.SKUBase { sku_Price = (decimal)gplist.Tables[0].Rows[0]["gp_pPric"], sku_scPric = (decimal)r["sku_scPric"], sku_ID = (int)r["sku_ID"], }; } else { p.productSkuInfo = new Model.SKUBase { sku_Price = (decimal)r["sku_Price"], sku_scPric = (decimal)r["sku_scPric"], sku_ID = (int)r["sku_ID"], }; } } p.p_Name = r["p_Name"].ToString(); //p.productSkuInfo = new Model.SKUBase //{ // sku_Price = (decimal)r["sku_Price"], // sku_scPric = (decimal)r["sku_scPric"], // sku_ID = (int)r["sku_ID"], //};//价格,skuid p.productImgInfo = new Model.ProductImgBase { pi_Url = r["pi_Url"].ToString() };//图片地址 p.productAttrInfo = new Model.ProductAttributesBase { pa_Name = r["shuxing"].ToString() };//全部属性 p.productAppInfo = new Model.ProductAppraiseBase { pa_ID = (int)r["countpl"] };//评价条数 goodsI.Add(p); } return goodsI; }