/// <summary>
/// 添加/编辑
/// </summary>
/// <returns></returns>
public ActionResult AdertEdit()
{
//绑定广告位置
BLL.AdertPositionBase apbll = new BLL.AdertPositionBase();
List<Model.AdertPositionBase> listadert= apbll.GetModelList(" p_Delete=0 and p_Status=0 ");
List<SelectListItem> seltype = new List<SelectListItem>();
seltype = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "-1" } };
for (int i = 0; i < listadert.Count; i++)
{
seltype.Add(new SelectListItem
{
Value = listadert[i].p_ID.ToString(),
Text = listadert[i].p_PositionName
});
}
ViewData["AdertPosition"] = new SelectList(seltype, "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 = "-1" } };
for (int i = 0; i < modelType.Count; i++)
{
selectType.Add(new SelectListItem
{
Value = modelType[i].pt_ID.ToString(),
Text = modelType[i].pt_Name
});
}
ViewData["AdertFenLeiPosition"] = new SelectList(selectType, "Value", "Text", "请选择");
ViewData["otype"] = RequestBase.GetString("otype");
if (RequestBase.GetString("a_ID") != null && RequestBase.GetString("a_ID") != "")
{
Model.Adert adert = new BLL.Adert().GetModel(int.Parse(RequestBase.GetString("a_ID")));
ViewData["AdertPosition"] = new SelectList(seltype, "Value", "Text", adert.a_PID);
if (adert.a_spare2 != null)
{
ViewData["AdertFenLeiPosition"] = new SelectList(selectType, "Value", "Text", adert.a_spare2);
}
else {
}
ViewData["picurl"] = adert.a_Image;
return View(adert);
}
else {
return View();
}
}
public ActionResult BrandClass()
{
ViewData["hf_IsManage"] = true; // new CRM.Public.RoleManager().IsHasFunRole(EmployeeInfo.e_ID, "006007001");//管理权限
//所有商品分类
BLL.ProductTypeBase rtBll = new BLL.ProductTypeBase();
var List = rtBll.GetModelList(" pt_IsDel=0 order by pt_Sort ASC");
var Ids = ptbBll.GetModelList(" b_ID='" + RequestBase.GetString("b_ID") + "'");//拥有分类
string PTIds = "";
foreach (Model.ProductTypeBrandBase j in Ids)
{
PTIds += j.pt_ID + ",";
}
@ViewData["hfItems"] = PTIds;
@ViewData["hfbId"] = RequestBase.GetString("b_ID");
return View(List.ToList());
}
public ActionResult ProList()
{
string type = Request.QueryString["type"] == null ? "ProList" : Request.QueryString["type"].ToString();
if (type == "ProList" || string.IsNullOrEmpty(type) || type == "undefined")
{
int pagerows = 12;
string where = "";
string sortby = "";
string page = Request.QueryString["page"] == null ? "1" : Request.QueryString["page"].ToString();
string ptype = Request.QueryString["ptype"] == null ? "" : Request.QueryString["ptype"].ToString();
int typeid = int.Parse(ptype);//类别ID
string tui = Request.QueryString["tui"] == null ? "" : Request.QueryString["tui"].ToString();
string price = Request.QueryString["price"] == null ? "" : Request.QueryString["price"].ToString();
string brand = Request.QueryString["brand"] == null ? "" : Request.QueryString["brand"].ToString();
string sort = Request.QueryString["sort"] == null ? "" : Request.QueryString["sort"].ToString();
string typeidd = ptype;//需进行类别判断
Model.ProductTypeBase ptmodel = ptbll.GetModel(int.Parse(typeidd));
if (ptmodel.pt_Layer == 1)//大类
{
where += " and pt_ID in(select pt_ID from ProductTypeBase where pt_ParentId =" + ptype + ")";
}
else if (ptmodel.pt_Layer == 2)
{
where += " and pt_id=" + ptype;
}
//else if (ptmodel.pt_Layer == 3)
//{
// where += " and pt_id=" + ptype;
//}
////string ptype = " and pt_id=" + ptype;//需进行类别判断
if (!string.IsNullOrEmpty(brand) && brand != "undefined")
where += " and b_id=" + brand;
if (!string.IsNullOrEmpty(price) && price != "undefined")
{
if (price == "5000以上")
where += "and sku_Price>=5000" + " and p_id not in(select p_id from skubase where sku_id in(select sku_id from GroupPurchaseBase where gp_pPric<5000 and sku_ID in(select sku_ID from skubase where p_ID in( select p_ID from ProductRecommendDetail where prt_ID=1 and prd_Status=0 and prd_IsDelete=0))))";
else
{
string[] prilist = price.Split('-');
where += " and sku_Price>=" + prilist[0] + " and sku_Price<=" + prilist[1] + " and p_id not in(select p_id from skubase where sku_id in(select sku_id from GroupPurchaseBase where gp_pPric<" + prilist[0] + " or gp_pPric>" + prilist[1] + " and sku_ID in(select sku_ID from skubase where p_ID in( select p_ID from ProductRecommendDetail where prt_ID=1 and prd_Status=0 and prd_IsDelete=0))))";
}
}
if (!string.IsNullOrEmpty(sort) && sort != "undefined")
{
if (sort == "sku")
sortby = " order by sku_ID desc";
if (sort == "xliang")
sortby = " order by sku_SalesCount desc ";
if (sort == "spric")
sortby = " order by sku_Price desc";
if (sort == "pinglun")
sortby = " order by pinglun desc";
if (sort == "selltime")
sortby = " order by p_ModifyOn desc";
}
var model = new ListModel();
model.blist = bbll.GetbrandByTypeId(typeid);
model.ptlist = ptbll.GetModelList(" pt_parentId=" + typeid+" and pt_Isdel=0 and pt_statusCode=0");
model.vmpinfolist = new BLL.vw_PInfo().GetModelList(" p_IsDel=0 " + where, int.Parse(page), pagerows, sortby);
List<Model.vw_PInfo> list = new BLL.vw_PInfo().GetModelList(" p_IsDel=0" + where);
model.proattr = new BLL.ProductAttributesBase().GetModelList(" pa_IsDel=0 and pa_StatusCode=0 and pa_Type=1 ");
ViewData["count"] = list.Count;
ViewData["pagerows"] = pagerows;
ViewData["page"] = page;
ViewData["pagecount"] = Math.Ceiling((double)list.Count / (double)pagerows);
ViewData["typename"] = new BLL.ProductTypeBase().GetModel(int.Parse(typeidd)).pt_Name;
var cpt = adertbll.GetModelList(" a_PID=28 and a_spare2=3 and a_Delete=0 ");
ViewBag.GuangGao = cpt.ToList();
return View(model);
}
else
return View();
}
public ActionResult ProTuiList()
{
string type = Request.QueryString["type"] == null ? "ProTuiList" : Request.QueryString["type"].ToString();
if (type == "ProTuiList" || string.IsNullOrEmpty(type) || type == "undefined")
{
int pagerows = 4;
string where = "";
string sortby = "";
//页数
string page = Request.QueryString["page"] == null ? "1" : Request.QueryString["page"].ToString();
//推荐
string tui = Request.QueryString["tui"] == null ? "" : Request.QueryString["tui"].ToString();
//分类ID
string ptid = Request.QueryString["ptype"] == null ? "" : Request.QueryString["ptype"].ToString();
//查询条件
string condition = Request.QueryString["condition"] == null ? "" : Request.QueryString["condition"].ToString();
//价格
string price = Request.QueryString["price"] == null ? "" : Request.QueryString["price"].ToString();
//品牌
string brand = Request.QueryString["brand"] == null ? "" : Request.QueryString["brand"].ToString();
//排序
string sort = Request.QueryString["sort"] == null ? "" : Request.QueryString["sort"].ToString();
//存在推荐分类
if (!string.IsNullOrEmpty(tui) && tui != "undefined")
{
where += " and p_ID in (select p_ID from ProductRecommendDetail where prt_ID=" + tui + " and prd_Status=0 and prd_IsDelete=0) ";
}
else
{
string strptCon = "";
if (!string.IsNullOrWhiteSpace(ptid) && ptid != "undefined")
{
ptid = HttpUtility.UrlDecode(ptid);
var proType = new BLL.ProductTypeBase().GetModelList(" pt_IsDel = 0 and pt_StatusCode = 0 and pt_Name = '" + ptid +"'").FirstOrDefault();
if (proType != null)
{
strptCon = " and pt_ID=" + proType.pt_ID;
}
}
if (!string.IsNullOrWhiteSpace(condition) && condition != "undefined")
{
condition = HttpUtility.UrlDecode(condition);
where += " and p_ID in (select p_ID from ProductBase where p_Name like '%[" + condition + "]%' and p_SellStatus=1 and p_IsDel=0 and p_StatusCode=0 " + strptCon + ") ";
}
}
//存在分类
if (!string.IsNullOrEmpty(ptid) && ptid != "undefined")
{
where += " and pt_ID=" + ptid;
}
//存在品牌
if (!string.IsNullOrEmpty(brand) && brand != "undefined")
{
where += " and b_id=" + brand;
}
//价格
if (!string.IsNullOrEmpty(price) && price != "undefined")
{
if (price == "5000以上")
where += "and sku_Price>=5000" + " and p_id not in(select p_id from skubase where sku_id in(select sku_id from GroupPurchaseBase where gp_pPric<5000 and sku_ID in(select sku_ID from skubase where p_ID in( select p_ID from ProductRecommendDetail where prt_ID=1 and prd_Status=0 and prd_IsDelete=0))))";
else
{
string[] prilist = price.Split('-');
where += " and sku_Price>=" + prilist[0] + " and sku_Price<=" + prilist[1] + " and p_id not in(select p_id from skubase where sku_id in(select sku_id from GroupPurchaseBase where gp_pPric<" + prilist[0] + " or gp_pPric>"+prilist[1] +" and sku_ID in(select sku_ID from skubase where p_ID in( select p_ID from ProductRecommendDetail where prt_ID=1 and prd_Status=0 and prd_IsDelete=0))))";
}
}
//排序
if (!string.IsNullOrEmpty(sort) && sort != "undefined")
{
if (sort == "sku")
sortby = " order by sku_ID desc";
if (sort == "xliang")
sortby = " order by sku_SalesCount desc ";
if (sort == "spric")
sortby = " order by sku_Price desc";
if (sort == "pinglun")
sortby = " order by pinglun desc";
if (sort == "selltime")
sortby = " order by p_ModifyOn desc";
}
var model = new ListModel();
if (!string.IsNullOrWhiteSpace(tui) && tui != "undefined")
{
model.blist = bbll.GetModelList(" b_IsDel=0 and b_StatusCode=0 and b_ID in(select b_ID from ProductTypeBrandBase where pt_ID in(select pt_ID from productbase where p_ID in(select p_ID from ProductRecommendDetail where prt_ID=" + tui + " and prd_IsDelete=0 and prd_Status=0)))");
model.ptlist = ptbll.GetModelList(" pt_IsDel=0 and pt_StatusCode=0 and pt_ID in(select pt_ID from productbase where p_ID in(select p_ID from ProductRecommendDetail where prt_ID=" + tui + " and prd_IsDelete=0 and prd_Status=0))");
ViewData["typename"] = new BLL.ProductRecommendTypeBase().GetModel(int.Parse(tui)).prt_Name;
}
else
{
model.blist = new List<BrandBase>();
model.ptlist = new List<ProductTypeBase>();
ViewData["typename"] = "";
}
model.vmpinfolist = new BLL.vw_PInfo().GetModelList(" p_IsDel=0 and p_StatusCode=0 and p_SellStatus=1 " + where, int.Parse(page), pagerows, sortby);
List<Model.vw_PInfo> list = new BLL.vw_PInfo().GetModelList(" p_IsDel=0 and p_SellStatus=1 and p_StatusCode=0 " + where);
ViewData["count"] = list.Count;
ViewData["pagerows"] = pagerows;
ViewData["page"] = page;
ViewData["pagecount"] = Math.Ceiling((double)list.Count / (double)pagerows);
return View(model);
}
else
return View();
}
//广告管理
// GET: /Adert/
/// <summary>
/// 广告列表页
/// </summary>
/// <returns></returns>
public ActionResult AdertMsg()
{
//绑定广告分类
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 = "-1" } };
for (int i = 0; i < modelType.Count; i++)
{
selectType.Add(new SelectListItem
{
Value = modelType[i].pt_ID.ToString(),
Text = modelType[i].pt_Name
});
}
ViewData["AdertFenLeiPosition"] = new SelectList(selectType, "Value", "Text", "请选择");
//绑定广告位置
BLL.AdertPositionBase apbll = new BLL.AdertPositionBase();
List<Model.AdertPositionBase> listap = apbll.GetModelList(" p_Status = 0 and p_Delete=0");
List<SelectListItem> selectposition = new List<SelectListItem>();
selectposition = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "-1" } };
for (int i = 0; i < listap.Count; i++)
{
selectposition.Add(new SelectListItem
{
Value = listap[i].p_ID.ToString(),
Text = listap[i].p_PositionName
});
}
ViewData["AdertPosition"] = new SelectList(selectposition, "Value", "Text", "请选择");
return View();
}
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 ActionResult SelectProductsMsg()
{
ViewData["IsHasFunRole"] = _roleManager.IsHasFunRole(EmployeeBase.e_ID, "001002001"); //是否拥有管理的权限
ViewData["prt_ID"] = RequestBase.GetString("prt_ID");
List<Model.ProductTypeBase> modelType = new BLL.ProductTypeBase().GetModelList(" pt_parentId = 0 and pt_IsDel=0 and pt_StatusCode=0");
List<SelectListItem> selectTypeTui = new List<SelectListItem>();
selectTypeTui = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "chose" } };
for (int i = 0; i < modelType.Count; i++)
{
selectTypeTui.Add(new SelectListItem
{
Value = modelType[i].pt_ID.ToString(),
Text = modelType[i].pt_Name
});
}
ViewData["selectTypeTui"] = new SelectList(selectTypeTui, "Value", "Text", "请选择");
return View();
}
/// <summary>
/// 购物车
/// </summary>
/// <returns></returns>
private string shopcartMethod()
{
string result = "";
string pid = Form["p_id"];
string p_chima = Form["p_chima"];
string p_yanse = Form["p_yanse"];
string p_commoditynum = Form["p_commoditynum"];
DataTable dtsku = new BLL.SKUBase().GetList(" sku_IsDel=0 and p_ID= "+pid).Tables[0];
string pt_id= new BLL.ProductBase().GetModel(int.Parse(pid)).pt_ID.ToString();//商品小类型
string ptp_id= new BLL.ProductTypeBase().GetModel(int.Parse(pt_id)).pt_ParentId.ToString();//商品大类型
if (System.Web.HttpContext.Current.Request.Cookies[":userlogin"] == null || System.Web.HttpContext.Current.Request.Cookies[":userlogin"].Value == "")//如果没有用户登录
{
result = "{'result':'error_login'}";
}
else {//如果有用户登录
Model.MemberBase mbmodel = CookieEncrypt.DeserializeObject(System.Web.HttpContext.Current.Request.Cookies[":userlogin"].Value) as MemberBase;
if (ptp_id == "488" || ptp_id == "489") //是男鞋或女鞋
{
if (p_chima == "0")
{
result = "{'result':'error_chima'}";
}
else if (p_yanse == "0")
{
result = "{'result':'error_yanse'}";
}
else
{ //尺码 颜色都选择后 写入购物车
Model.ShoppingCartBase scmodel = new ShoppingCartBase();
scmodel.sku_ID = int.Parse(dtsku.Rows[0]["sku_ID"].ToString());
scmodel.m_ID = mbmodel.m_ID;
scmodel.sc_pCount =int.Parse( p_commoditynum);
scmodel.sc_pPric = Convert.ToDecimal(dtsku.Rows[0]["sku_Price"]);
scmodel.sc_CreateOn = DateTime.Now;
scmodel.sc_IsDel = false;
scmodel.sc_Status = false;
scmodel.sc_IsGP = false;
scmodel.sc_chima = p_chima;
scmodel.sc_yanse = p_yanse;
int re= new BLL.ShoppingCartBase().Add(scmodel);
if (re > 0)
{
result = "{'result':'success'}";
}
else {
result = "{'result':'error_data'}";
}
}
}
else//如果选择的商品不是鞋子那么尺码颜色设为0
{
Model.ShoppingCartBase scmodel = new ShoppingCartBase();
scmodel.sku_ID = int.Parse(dtsku.Rows[0]["sku_id"].ToString());
scmodel.m_ID = mbmodel.m_ID;
scmodel.sc_pCount = int.Parse(p_commoditynum);
scmodel.sc_pPric = Convert.ToDecimal(dtsku.Rows[0]["sku_Price"]);
scmodel.sc_CreateOn = DateTime.Now;
scmodel.sc_IsDel = false;
scmodel.sc_Status = false;
scmodel.sc_IsGP = false;
scmodel.sc_chima = p_chima;
scmodel.sc_yanse = p_yanse;
int re = new BLL.ShoppingCartBase().Add(scmodel);
if (re > 0)
{
result = "{'result':'success'}";
}
else
{
result = "{'result':'error_data'}";
}
}
}
return result;
}
public ActionResult Commodity()
{
ViewBag.Title = "商品列表-书生网";
//商品导航
StringBuilder sb = new StringBuilder();
DataTable dtptb1 = new BLL.ProductTypeBase().GetList(" pt_Layer=1 and pt_StatusCode=0 and pt_IsDel=0 order by pt_Sort asc").Tables[0];//一级商品类型
if (dtptb1.Rows.Count > 0)
{
for (int i = 0; i < dtptb1.Rows.Count; i++)
{
sb.Append("<dt class=\"odd\">" + dtptb1.Rows[i]["pt_Name"] + "</dt>");
DataTable dtptb2 = new BLL.ProductTypeBase().GetList(" pt_Layer=2 and pt_StatusCode=0 and pt_IsDel=0 and pt_ParentId="+dtptb1.Rows[i]["pt_ID"]+" order by pt_Sort asc").Tables[0];//二级商品类型
if (dtptb2.Rows.Count > 0)
{
sb.Append("<dd class=\"odd\">");
sb.Append("<ol>");
for (int n = 0; n < dtptb2.Rows.Count; n++)
{
sb.Append("<li>");
sb.Append("<a href='/sswCommodity/Commodity?pt_id="+dtptb2.Rows[n]["pt_ID"]+"'><span class=\"price1\">"+dtptb2.Rows[n]["pt_Name"]+"</span></a>("+dtptb2.Rows.Count+")");
sb.Append("</li>");
}
sb.Append("</ol>");
sb.Append("</dd>");
}
ViewBag.CommodityTitle = sb.ToString();
}
}
string ptb_id = Request.QueryString["pt_id"] == null ? "0" : Request.QueryString["pt_id"].ToString();
string brand_id = Request.QueryString["b_id"] == null ? "0" : Request.QueryString["b_id"].ToString();
DataTable dtmztm=null;
if (ptb_id != "0")
{
dtmztm = new webs_YueyxShop.BLL.SKUBase().GetDefaultSKUDetial(" and pt_ID=" + ptb_id + " and pi_type=0 and pt_IsDel=0 and pt_StatusCode=0 and b_IsDel=0 and sku_IsDel=0 and sku_StatusCode=0 and pi_StatusCode=0 and pi_IsDel=0 and p_IsDel=0 and p_StatusCode=0");
}
else if(brand_id!="0") {
dtmztm = new webs_YueyxShop.BLL.SKUBase().GetDefaultSKUDetial(" and b_ID=" + brand_id + " and pi_type=0 and pt_IsDel=0 and pt_StatusCode=0 and b_IsDel=0 and sku_IsDel=0 and sku_StatusCode=0 and pi_StatusCode=0 and pi_IsDel=0 and p_IsDel=0 and p_StatusCode=0");
}
else
{
dtmztm = new webs_YueyxShop.BLL.SKUBase().GetDefaultSKUDetial(" and pi_type=0 and pt_IsDel=0 and pt_StatusCode=0 and b_IsDel=0 and sku_IsDel=0 and sku_StatusCode=0 and pi_StatusCode=0 and pi_IsDel=0 and p_IsDel=0 and p_StatusCode=0");
}
//得到全部商品列表
ViewData["pcCommodityList"] = dtmztm;
//List<Model.SKUBase> list= new webs_YueyxShop.BLL.SKUBase().DataTableToList(dtmztm);
//int total = 0;//总行数
//int pageSize = 300;//每页25行
//int pageNumber = 1;//当前页
//var skucc= new BLL.SKUBase().GetModelList(" sku_StatusCode=0 and sku_IsDel=0 ");
//total = skucc.Count();
//this.ViewData["TotalCount"] = total.ToString();
//this.ViewData["NumberPage"] = pageSize.ToString();
//this.ViewData["PagenumShown"] = "10";
//this.ViewData["CurrentPage"] = pageNumber.ToString();
//return View(skucc.ToPagedList(pageNumber, pageSize));
return View();
}
public ActionResult ProductAttributesMsg()
{
ViewData["IsHasFunRole"] = _roleManager.IsHasFunRole(EmployeeBase.e_ID, "001002001"); //是否拥有管理的权限
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", "请选择");
List<SelectListItem> selectType2 = new List<SelectListItem>();
selectType2 = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "chose" } };
ViewData["selectType2"] = new SelectList(selectType2, "Value", "Text", "请选择");
return View();
}
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();
}
}
