public void GetBrandBase()
{
BLL.BrandBase brandBase = new BLL.BrandBase();
var list = brandBase.GetModelList("b_IsDel = 0 and b_StatusCode = 0");
ViewData["BarndBaseLogo"] = GetBrandBaseLogoString(list);//品牌logo
GetBrandBaseAdert();
//ViewData["BrandBase"] = GetBrandBaseString(list);
//ViewData["BrandBaseSpan"] = GetBrandBaseSpanString(list.Count);
}
public string Getbrand(string id)
{
StringBuilder attr = new StringBuilder();
if (RequestBase.GetString("code") != "")
{
id = RequestBase.GetString("code");
}
if (id == "chose")
{
return "refresh";
}
else
{
List<SelectListItem> selectattrP = new List<SelectListItem>();
List<Model.BrandBase> modelbrand = new BLL.BrandBase().GetModelList(" b_ID in (select b_ID from ProductTypeBrandBase where pt_ID="+id+")");
StringBuilder sbGoodsName = new StringBuilder();
attr.Append("[[\"chose\",\"请选择\"]");
for (int i = 0; i < modelbrand.Count; i++)
{
attr.Append(",[");
attr.Append("\"" + modelbrand[i].b_ID.ToString() + "\",");
attr.Append("\"" + modelbrand[i].b_Name + "\"");
attr.Append("]");
}
attr.Append("]");
return attr.ToString();
}
}
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();
}
}
