批量更新折扣

￡神魔★判官ぃ 2021-11-05 02:50 309阅读 0赞

批量更新折扣  
开发工具与关键技术： 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’);  
\}

做好后我们筛选类别的女鞋的所有商品，对这一类商品的折扣进行更改  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDU0MDY4MQ_size_16_color_FFFFFF_t_70]  
修改成功  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDU0MDY4MQ_size_16_color_FFFFFF_t_70 1]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDU0MDY4MQ_size_16_color_FFFFFF_t_70]: /images/20211104/84133a372bf5430cbacae78a2fd5778e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDU0MDY4MQ_size_16_color_FFFFFF_t_70 1]: /images/20211104/c099d5a420304406ac741ebd52019bf8.png