/// <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();
}
}
