批量更新折扣

批量更新折扣 开发工具与关键技术： Visual Studio 2015 – jQuery 作者：廖亚星 撰写时间：2019年 8 月 7 日 在商品里会根据类别筛选条件对所属类的商品进行批量更新折扣 首先我们要根据筛选条件创建参数来定义方法 public ActionResult UpdateDiscount(int CategoryManagementID, int BrandManagementID, int SeasonManagementID, string SalesDiscount) { string strMsg = “failed”; int countSuccessDel = 0;//记录删除成功的条数 int countFailedDel = 0;//记录删除失败的条数 try { List dbCommod = (from tbCommodityManagement in myModel.B_CommodityManagement//商品ID表 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(); pwCommodits.SalesDiscount = Convert.ToDecimal(SalesDiscount); //折扣 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 UpdateDiscount() { var CategoryManagementID = $("#SPLBAA").val(); var BrandManagementID = $("#PPAA").val(); var SeasonManagementID = $("#JJAA").val(); var SalesDiscount = KaTeX parse error: Expected 'EOF', got '#' at position 3: ("#̲XSZKAA").val();…/ if (!DiscoKou.test(SalesDiscount)) { layer.msg(“请输入正确的折扣！”, { icon: 0, offset: “200px;” }); $("#XSZKAA").val(“1.00”); return; } if (SalesDiscount > 1 || SalesDiscount == 0) { layer.msg(“折扣超出限定范围，请重新输入！”, { icon: 0, title: “提示”, offset: “200px;” }); $("#XSZKAA").val(“1.00”); return; } layerIndex = layer.load(); $.post("/DailyRoutine/CommodityManagement/UpdateDiscount", { CategoryManagementID: CategoryManagementID, BrandManagementID: BrandManagementID, SeasonManagementID: SeasonManagementID, SalesDiscount: SalesDiscount}, function (strMsg) { layer.close(layerIndex); $("#PLGXXSZK").modal(‘hide’); layer.alert(strMsg, { icon: 1, title: “提示”,offset:“200px;” }); TabTitles.reload(); }, ‘json’); } 做好后我们筛选类别的女鞋的所有商品，对这一类商品的折扣进行更改 修改成功