public ActionResult BrandEdit() { string ptidlist = ""; string ptname = ""; ViewData["IsHasFunRole"] = true;//管理权限 ViewData["hf_luj"] = ConfigurationManager.AppSettings["SaveImage"];//图片的存储路径 Model.BrandBase model = new Model.BrandBase(); ViewData["texOtype"] = RequestBase.GetString("otype"); List<SelectListItem> selectType2 = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "chose" } }; List<SelectListItem> selectType3 = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "chose" } }; ViewData["selectType2"] = new SelectList(selectType2, "Value", "Text"); ViewData["selectType3"] = new SelectList(selectType3, "Value", "Text"); switch (RequestBase.GetString("otype")) { case "modify": string id = RequestBase.GetString("b_ID");//44 ViewData["b_ID"] = id; #region 实体 model = bll.GetModel(Convert.ToInt32(id)); ViewData["LogoUrl"] = model.b_LogoUrl; #endregion if (!string.IsNullOrEmpty(RequestBase.GetString("pt_id"))) { string ptidlist2 = RequestBase.GetString("pt_id").ToString(); ptidlist2 = ptidlist2.Substring(0, ptidlist2.Length - 1); var ptlist = ptypebBll.GetModelList(" pt_ID in(" + ptidlist2 + ")"); foreach (var item in ptlist) { ptname += item.pt_Name + ","; } if (ptname.Length > 0) ptname = ptname.Substring(0, ptname.Length - 1); ViewData["ptidlist"] = ptidlist2; ViewData["ptname"] = ptname; } else { //查品牌分类明细中指定品牌所属的类别 var ptblist = ptbBll.GetModelList(" b_ID=" + id); if (ptblist.Count > 0) { foreach (var i in ptblist) { ptidlist += i.pt_ID + ","; } ptidlist = ptidlist.Substring(0, ptidlist.Length - 1); var pt = ptypebBll.GetModelList(" pt_ID in(" + ptidlist + ")"); foreach (var item in pt) { ptname += item.pt_Name + ","; } if (ptname.Length > 0) ptname = ptname.Substring(0, ptname.Length - 1); ViewData["ptidlist"] = ptidlist; ViewData["ptname"] = ptname; } else { ViewData["ptidlist"] = ""; ViewData["ptname"] = ""; } } return View(model); default: if (!string.IsNullOrEmpty(RequestBase.GetString("pt_id"))) { string ptidlist2 = RequestBase.GetString("pt_id").ToString(); ptidlist2 = ptidlist2.Substring(0, ptidlist2.Length - 1); var ptlist = ptypebBll.GetModelList(" pt_ID in(" + ptidlist2 + ")"); foreach (var item in ptlist) { ptname += item.pt_Name + ","; } if (ptname.Length > 0) ptname = ptname.Substring(0, ptname.Length - 1); ViewData["ptidlist"] = ptidlist2; ViewData["ptname"] = ptname; } else { ViewData["ptidlist"] = ""; ViewData["ptname"] = ""; } ViewData["b_ID"] = RequestBase.GetString("b_ID"); return View(); } }
//按商品类别获取该类别下所有的品牌(存储过程) public List<Model.BrandBase> GetbrandByTypeId(int cid) { List<Model.BrandBase> brandlist = new List<Model.BrandBase>(); SqlParameter[] ps = new SqlParameter[] { new SqlParameter("@rptid",cid), }; DataTable table = DbHelperSQL.GetTable("GetbrandByTypeId", ps); foreach (DataRow r in table.Rows) { Model.BrandBase b = new Model.BrandBase(); b.b_Name = r["b_Name"].ToString(); b.b_ID = (int)r["b_ID"]; brandlist.Add(b); } return brandlist; }