批量特价商品

批量特价商品
商品管理中会对商品进行分类，当有活动时，会把商品单独分为特价商品进行销售，所以商品分为特价商品与正常商品两类，而我们要实现根据筛选把商品更换于这两种商品
首先定义方法，通过参数进行筛选
public ActionResult UpdateBargain(int CategoryManagementID, int BrandManagementID, int SeasonManagementID, string SalesDiscount,int customs)
{
string strMsg = “failed”;
int countSuccessDel = 0;//记录删除成功的条数
int countFailedDel = 0;//记录删除失败的条数
try
{
List dbCommod = (from tbCommodityManagement in myModel.B_CommodityManagement//商品表
select new commodity
{
CommodityManagementID = tbCommodityManagement.CommodityManagementID,//商品ID
CategoryManagementID = tbCommodityManagement.CategoryManagementID,//类别ID
BrandManagementID = tbCommodityManagement.BrandManagementID,//品牌ID
SeasonManagementID = tbCommodityManagement.SeasonManagementID,//季节ID
}).ToList();
if (CategoryManagementID > 0)
{
dbCommod = dbCommod.Where(S => S.CategoryManagementID == CategoryManagementID).ToList();//根据类别进行筛选
}
if (BrandManagementID > 0)
{
dbCommod = dbCommod.Where(S => S.BrandManagementID == BrandManagementID).ToList();//根据品牌进行筛选
}
if (SeasonManagementID > 0)
{
dbCommod = dbCommod.Where(S => S.SeasonManagementID == SeasonManagementID).ToList();//根据季节进行筛选
}
if (dbCommod.Count() != 0)
{
for (int i = 0; i < dbCommod.Count; i++)
{
int? CommodityManagementID = dbCommod[i].CommodityManagementID;
B_CommodityManagement pwCommodits = (from tbCommodityManagement in myModel.B_CommodityManagement
where tbCommodityManagement.CommodityManagementID == CommodityManagementID
select tbCommodityManagement).Single();
if (customs == 1)
{
pwCommodits.Bargain = “否”;
}
if (customs == 2)
{
pwCommodits.Bargain = “是”;
}
myModel.Entry(pwCommodits).State = EntityState.Modified;
if (myModel.SaveChanges() > 0)
{
countSuccessDel++;
}
else
{
countFailedDel++;
}
}
strMsg = “总共需要修改” + dbCommod.Count() + “条商品信息！其中成功修改” + countSuccessDel + “条，失败” + countFailedDel + “条。”;
}
else
{
strMsg = “没有匹配的数据！”;
}
}
catch (Exception e)
{
Console.Write(e);
strMsg = “参数异常！”;
}
return Json(strMsg, JsonRequestBehavior.AllowGet);
}
然后在页面上获取值，通过键值对的形式引用方法
function UpdateBargain() {
var CategoryManagementID = $("#SPLBCC").val();
var BrandManagementID = $("#PPCC").val();
var SeasonManagementID = $("#JJCC").val();
if (CategoryManagementID == null || CategoryManagementID == “” || CategoryManagementID == undefined) {
CategoryManagementID = 0;
}
if (BrandManagementID == null || BrandManagementID == “” || BrandManagementID == undefined) {
BrandManagementID = 0;
}
if (SeasonManagementID == null || SeasonManagementID == “” || SeasonManagementID == undefined) {
SeasonManagementID = 0;
}
if (customs == null || customs == “” || customs == undefined) {
customs = 0;
}
layerIndex = layer.load();
$.post("/DailyRoutine/CommodityManagement/UpdateBargain",
{ CategoryManagementID: CategoryManagementID, BrandManagementID: BrandManagementID, SeasonManagementID: SeasonManagementID, customs: customs },
function (strMsg) {
layer.close(layerIndex);
$("#PLTJSPCL").modal(‘hide’);
layer.alert(strMsg, { icon: 1, title: “提示”, offset: “200px;” });
TabTitles.reload();
}, ‘json’);
}
这样就能把商品分类为特价商品与正常商品了