批量特价商品

短命女 2021-10-24 00:16 197阅读 0赞

批量特价商品  
商品管理中会对商品进行分类，当有活动时，会把商品单独分为特价商品进行销售，所以商品分为特价商品与正常商品两类，而我们要实现根据筛选把商品更换于这两种商品  
首先定义方法，通过参数进行筛选  
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’);  
\}  
这样就能把商品分类为特价商品与正常商品了  
![在这里插入图片描述][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/20211023/98214793d4674c3a83f9c4e450d147bb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDU0MDY4MQ_size_16_color_FFFFFF_t_70 1]: /images/20211023/6409cc4a53444c7886587e2f9db0cf35.png