/// <summary> /// 获得数据列表(通过SKUID和PID) /// </summary> public List<Model.ProductAttributesBase> GetModelListByskuId(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select pa1.pa_Name n,pa2.pa_Name from ProductAttributesBase pa1,ProductAttributesBase pa2,ProductAttributeDetails pad where pa1.pa_ID=pa2.pa_parentId and pa2.pa_ID = pad.pa_ID and pa1.pa_StatusCode=0 and pa1.pa_IsDel=0 and "); if (strWhere.Trim() != "") { strSql.Append(strWhere); } DataSet ds = DbHelperSQL.Query(strSql.ToString()); List<Model.ProductAttributesBase> proattr = new List<Model.ProductAttributesBase>(); foreach (DataRow r in ds.Tables[0].Rows) { Model.ProductAttributesBase attrmodel = new Model.ProductAttributesBase(); attrmodel.pa_Name = r["pa_Name"].ToString(); attrmodel.pa_Alias = r["n"].ToString(); proattr.Add(attrmodel); } return proattr; }
public ActionResult ProductAttrEdit() { this.ViewData["texOtype"] = RequestBase.GetString("otype"); BindControl bc = new BindControl(); ViewData["IsHasFunRole"] = Rolemanager.IsHasFunRole(EmployeeBase.e_ID, "001001001");//是否拥有管理的权限 Model.ProductAttributeDetails model = new Model.ProductAttributeDetails(); Model.ProductAttributesBase pabmodel = new Model.ProductAttributesBase(); List<SelectListItem> selectattrType = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "0" }, new SelectListItem { Text = "属性", Value = "1" }, new SelectListItem { Text = "规格", Value = "2" }, new SelectListItem { Text = "颜色", Value = "3" } }; ViewData["selectattrType"] = new SelectList(selectattrType, "Value", "Text"); List<SelectListItem> attribute = new List<SelectListItem>(); attribute = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = null }, new SelectListItem { Text = "ww", Value = "40" } }; ViewData["attribute"] = new SelectList(attribute, "Value", "Text", "请选择"); List<SelectListItem> attrValue = new List<SelectListItem>(); attrValue = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = null } }; ViewData["attrValue"] = new SelectList(attrValue, "Value", "Text", "请选择"); if (RequestBase.GetString("otype") == "modify") { string ids = RequestBase.GetString("dli_id"); ViewData["hfPId"] = ids; attrpaid = ids.Split('|')[0];//pa_id int skuid = int.Parse(ids.Split('|')[1]);//sku_ID int pid = int.Parse(ids.Split('|')[2]);//p_ID pabmodel = patbll.GetModel(int.Parse(attrpaid)); paid = pabmodel.pa_Type.ToString(); parentpaid = pabmodel.pa_ParentId.ToString(); ViewData["paid"] = paid; ViewData["parentpaid"] = parentpaid; ViewData["attrpaid"] = attrpaid; ViewData["selectattrType"] = new SelectList(selectattrType, "Value", "Text", paid); List<Model.ProductAttributesBase> modelType = patbll.GetModelList(" pa_type = " + paid+" and pa_parentId=0"); for (int i = 0; i < modelType.Count; i++) { attribute.Add(new SelectListItem { Value = modelType[i].pa_ID.ToString(), Text = modelType[i].pa_Name }); } ViewData["attribute"] = new SelectList(attribute, "Value", "Text", parentpaid); List<Model.ProductAttributesBase> modelType2 = patbll.GetModelList(" pa_parentId = " + parentpaid); for (int i = 0; i < modelType2.Count; i++) { attrValue.Add(new SelectListItem { Value = modelType2[i].pa_ID.ToString(), Text = modelType2[i].pa_Name }); } ViewData["attrValue"] = new SelectList(attrValue, "Value", "Text", attrpaid); return View(); } else { string pids = RequestBase.GetString("dli_id"); ViewData["hfPId"] = pids; return View(); } }
/// <summary> /// 获得数据列表(通过SKUID) /// </summary> public List<Model.ProductAttributesBase> GetModelListByPid(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from ProductAttributesBase pa,SKUBase sku,ProductAttributeDetails pad where pa.pa_ID=pad.pa_ID and sku.sku_ID=pad.sku_ID "); if (strWhere.Trim() != "") { strSql.Append(strWhere); } DataSet ds = DbHelperSQL.Query(strSql.ToString()); List<Model.ProductAttributesBase> proattr = new List<Model.ProductAttributesBase>(); foreach (DataRow r in ds.Tables[0].Rows) { Model.ProductAttributesBase attrmodel = new Model.ProductAttributesBase(); attrmodel.pa_Name = r["pa_Name"].ToString(); attrmodel.pa_ID = int.Parse(r["pa_ID"].ToString()); attrmodel.sku = new Model.SKUBase { sku_ID = int.Parse(r["sku_ID"].ToString()), }; proattr.Add(attrmodel); } return proattr; }
public ActionResult ProductAttributesEdit() { Model.ProductAttributesBase pamodel = new Model.ProductAttributesBase(); this.ViewData["texOtype"] = RequestBase.GetString("otype"); ViewData["IsHasFunRole"] = _roleManager.IsHasFunRole(EmployeeBase.e_ID, "001002001"); //是否拥有管理的权限 List<SelectListItem> selectType2 = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "chose" } }; ViewData["selectType2"] = new SelectList(selectType2, "Value", "Text"); if (RequestBase.GetString("otype") == "modify")//编辑 { string ids = RequestBase.GetString("dli_id"); string id = ids.Split('|')[0];//属性ID string typeid = ids.Split('|')[4];//属性类别 string Pid = ids.Split('|')[5];//类别ID int ptid = int.Parse(id); pamodel = pabll.GetModel(ptid); if (pamodel.pa_Type == 1&&pamodel.pa_ParentId!=0) { List<SelectListItem> select1 = new List<SelectListItem> { new SelectListItem { Text = "商品属性", Value = "1" } }; ViewData["select1"] = new SelectList(select1, "Value", "Text"); ViewData["selectType"] = null; } else if (pamodel.pa_Type == 2 && pamodel.pa_ParentId != 0) { List<SelectListItem> select1 = new List<SelectListItem> { new SelectListItem { Text = "商品规格", Value = "2" } }; ViewData["select1"] = new SelectList(select1, "Value", "Text"); ViewData["selectType"] = null; } else if (pamodel.pa_Type == 3 && pamodel.pa_ParentId != 0) { List<SelectListItem> select1 = new List<SelectListItem> { new SelectListItem { Text = "商品颜色", Value = "3" } }; ViewData["select1"] = new SelectList(select1, "Value", "Text"); ViewData["selectType"] = null; } else { List<SelectListItem> select1 = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "0" }, new SelectListItem { Text = "商品属性", Value = "1" }, new SelectListItem { Text = "商品规格", Value = "2" }, new SelectListItem { Text = "商品颜色", Value = "3" } }; ViewData["select1"] = new SelectList(select1, "Value", "Text", typeid); List<Model.ProductTypeBase> modelType = ptbll.GetModelList(" pt_parentId = 0 and pt_IsDel=0 and pt_StatusCode=0");//大类 Model.ProductTypeBase modelm = ptbll.GetModel(int.Parse(Pid));//当前小类,它的父ID是中类ID,PID=9,中类ID是7 Model.ProductTypeBase modelb = ptbll.GetModel(modelm.pt_ParentId);//当前中类,它的父ID是大类ID,大类ID是3 List<Model.ProductTypeBase> modelType2 = ptbll.GetModelList(" pt_IsDel=0 and pt_StatusCode=0 and pt_parentId = " + modelb.pt_ParentId);//中类 List<Model.ProductTypeBase> modelType3 = ptbll.GetModelList(" pt_IsDel=0 and pt_StatusCode=0 and pt_parentId = " + modelm.pt_ParentId);//小类 List<SelectListItem> selectType = new List<SelectListItem>(); selectType = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "chose" } }; for (int i = 0; i < modelType.Count; i++) { selectType.Add(new SelectListItem { Value = modelType[i].pt_ID.ToString(), Text = modelType[i].pt_Name }); } ViewData["selectType"] = new SelectList(selectType, "Value", "Text", modelb.pt_ParentId); //加载中类的下拉菜单 for (int i = 0; i < modelType2.Count; i++) { selectType2.Add(new SelectListItem { Value = modelType2[i].pt_ID.ToString(), Text = modelType2[i].pt_Name }); } ViewData["selectType2"] = new SelectList(selectType2, "Value", "Text", modelb.pt_ID); } return View(pamodel); } else//添加 { string pids = RequestBase.GetString("dli_id"); ViewData["hfPId"] = pids; string fid = pids.Split('|')[0]; string type = pids.Split('|')[3]; int ffid = 0; int ttype = 0; if (fid != "" && type != "") { ffid = int.Parse(fid); ttype = int.Parse(type); } if (ttype == 1 && ffid != 0) { List<SelectListItem> select1 = new List<SelectListItem> { new SelectListItem { Text = "商品属性", Value = "1" } }; ViewData["select1"] = new SelectList(select1, "Value", "Text"); ViewData["selectType"] = null; } else if (ttype == 2 && ffid != 0) { List<SelectListItem> select1 = new List<SelectListItem> { new SelectListItem { Text = "商品规格", Value = "2" } }; ViewData["select1"] = new SelectList(select1, "Value", "Text"); ViewData["selectType"] = null; } else if (ttype == 3 && ffid != 0) { List<SelectListItem> select1 = new List<SelectListItem> { new SelectListItem { Text = "商品颜色", Value = "3" } }; ViewData["select1"] = new SelectList(select1, "Value", "Text"); ViewData["selectType"] = null; } else { List<SelectListItem> select1 = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "0" }, new SelectListItem { Text = "商品属性", Value = "1" }, new SelectListItem { Text = "商品规格", Value = "2" }, new SelectListItem { Text = "商品颜色", Value = "3" } }; ViewData["select1"] = new SelectList(select1, "Value", "Text"); 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> selectType = new List<SelectListItem>(); selectType = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "chose" } }; for (int i = 0; i < modelType.Count; i++) { selectType.Add(new SelectListItem { Value = modelType[i].pt_ID.ToString(), Text = modelType[i].pt_Name }); } ViewData["selectType"] = new SelectList(selectType, "Value", "Text", "请选择"); } return View(); } }