批量上架下架

怼烎@ 2021-11-05 02:48 409阅读 0赞

开发工具与关键技术： Visual Studio 2015 – jQuery  
作者：廖亚星  
撰写时间：2019年 7 月 31 日  
在商品里面，我们会对商品进行上架下架的操作，而根据类别、季节、品牌等条件对商品进行批量上架下架，会使操作更方便。在我的项目里面，商品管理会根据筛选的条件对商品进行批量上下架的操作。  
下面我们来控制器定义方法  
public ActionResult UpdatePutaway(int CategoryManagementID,int BrandManagementID,int SeasonManagementID  
,int? customs, int SelectKC)  
\{  
string strMsg = “failed”;  
int countSuccessDel = 0;//记录删除成功的条数  
int countFailedDel = 0;//记录删除失败的条数  
try  
\{  
List dbCommod = (from tbCommodityManagement in myModel.B\_CommodityManagement  
join tbCommodityList in myModel.B\_CommodityList on tbCommodityManagement.CommodityManagementID equals tbCommodityList.CommodityManagementID join tbQuantityInStock in myModel.S\_QuantityInStock on tbCommodityManagement.QuantityInStockID equals tbQuantityInStock.QuantityInStockID  
select new commodity  
\{  
CommodityManagementID = tbCommodityManagement.CommodityManagementID,//商品ID  
CategoryManagementID = tbCommodityManagement.CategoryManagementID,//类别ID  
BrandManagementID = tbCommodityManagement.BrandManagementID,//品牌ID  
SeasonManagementID = tbCommodityManagement.SeasonManagementID,//季节ID  
Putaway=tbCommodityList.Putaway,//上架  
Amount =tbQuantityInStock.Amount,//库存数  
\}).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\_CommodityList pwCommodits = (from tbCommodityList in myModel.B\_CommodityList//商品明细表  
where tbCommodityList.CommodityManagementID == CommodityManagementID  
select tbCommodityList).Single();  
if (SelectKC > 0)  
\{  
if (SelectKC == 1)  
\{  
dbCommod = dbCommod.Where(S => S.Amount > 0).ToList();//库存数>0  
\}  
if (SelectKC == 2)  
\{  
dbCommod = dbCommod.Where(S => S.Amount == 0).ToList();//库存数=0  
\}  
\}  
if (customs == 1)  
\{  
pwCommodits.Putaway = “是”;//上架  
\}  
if (customs == 2)  
\{  
pwCommodits.Putaway = “否”;//下架  
\}  
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 UpdatePutaway() \{  
var CategoryManagementID = $("\#SPLBBB").val();//类别  
var BrandManagementID = $("\#PPBB").val();//品牌  
var SeasonManagementID = $("\#JJBB").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;  
\}  
var SelectKC = $("\#SelectKC").val();//库存下拉框  
if (customs == null || customs == “” || customs == undefined) \{// customs–上架下架  
customs = 0;  
\}  
layerIndex = layer.load();  
$.post("/DailyRoutine/CommodityManagement/UpdatePutaway",  
\{ CategoryManagementID: CategoryManagementID, BrandManagementID: BrandManagementID, SeasonManagementID: SeasonManagementID, SelectKC: SelectKC, customs: customs \},  
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 2]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDU0MDY4MQ_size_16_color_FFFFFF_t_70]: /images/20211104/fb3747bc300447ba98208db69a6cbe4c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDU0MDY4MQ_size_16_color_FFFFFF_t_70 1]: /images/20211104/9a3d84adc6444c51a3ed648d526c6563.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDU0MDY4MQ_size_16_color_FFFFFF_t_70 2]: /images/20211104/c1f2de5a13934614890e649ab4f981ea.png