//按商品类别获取该类别下所有的商品信息（存储过程）
public List<Model.ProductBase> GetpInfoByTypeId(int cid)
{
List<Model.ProductBase> goodsI = new List<Model.ProductBase>();
SqlParameter[] ps = new SqlParameter[]
{
new SqlParameter("@ptid",cid),
};
DataTable table = DbHelperSQL.GetTable("GetpInfoByTypeId", ps);
foreach (DataRow r in table.Rows)
{
Model.ProductBase p = new Model.ProductBase();
p.p_Name = r["p_Name"].ToString();
p.productSkuInfo = new Model.SKUBase
{
sku_Price = (decimal)r["sku_Price"],
sku_scPric = (decimal)r["sku_scPric"],
sku_ID = (int)r["sku_ID"],
};//价格，skuid
p.productImgInfo = new Model.ProductImgBase { pi_Url = r["pi_Url"].ToString() };//图片地址
p.productAttrInfo = new Model.ProductAttributesBase
{
pa_Name = r["shuxing"].ToString()
};//全部属性
p.productAppInfo = new Model.ProductAppraiseBase
{
pa_ID = (int)r["countpl"]
};//评价条数
goodsI.Add(p);
}
return goodsI;
}
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 List<Model.ProductBase> GetpInfoByRecommendTypeId(int id)
{
List<Model.ProductBase> goodsI = new List<Model.ProductBase>();
SqlParameter[] ps = new SqlParameter[]
{
new SqlParameter("@ptid",id),
};
DataTable table = DbHelperSQL.GetTable("GetpInfoByRecommendTypeId",ps);
foreach (DataRow r in table.Rows)
{
Model.ProductBase p = new Model.ProductBase();
if (r["sku_Price"] != null && r["sku_Price"].ToString() != "")
{
StringBuilder strSqlgp = new StringBuilder();
strSqlgp.Append("select gp_ID,sku_ID,gp_StartTime,gp_EndTime,gp_pCount,gp_pPric,gp_CreateOn,gp_CreateBy,gp_StatusCode,gp_IsDel,gp_Logo,gp_Slogan,gp_SaleCount ");
strSqlgp.Append(" FROM GroupPurchaseBase ");
strSqlgp.Append(" where sku_ID=" + r["sku_ID"] + " and gp_StatusCode=0 and gp_IsDel=0 and gp_EndTime > '" + DateTime.Now + "'");
var gplist = DbHelperSQL.Query(strSqlgp.ToString());
if (gplist.Tables[0].Rows.Count > 0)
{
p.productSkuInfo = new Model.SKUBase
{
sku_Price = (decimal)gplist.Tables[0].Rows[0]["gp_pPric"],
sku_scPric = (decimal)r["sku_scPric"],
sku_ID = (int)r["sku_ID"],
};
}
else
{
p.productSkuInfo = new Model.SKUBase
{
sku_Price = (decimal)r["sku_Price"],
sku_scPric = (decimal)r["sku_scPric"],
sku_ID = (int)r["sku_ID"],
};
}
}
p.p_Name = r["p_Name"].ToString();
//p.productSkuInfo = new Model.SKUBase
//{
// sku_Price = (decimal)r["sku_Price"],
// sku_scPric = (decimal)r["sku_scPric"],
// sku_ID = (int)r["sku_ID"],
//};//价格，skuid
p.productImgInfo = new Model.ProductImgBase { pi_Url = r["pi_Url"].ToString() };//图片地址
p.productAttrInfo = new Model.ProductAttributesBase
{
pa_Name = r["shuxing"].ToString()
};//全部属性
p.productAppInfo = new Model.ProductAppraiseBase
{
pa_ID = (int)r["countpl"]
};//评价条数
goodsI.Add(p);
}
return goodsI;
}
