From 49b484da5f9d4cde8e47764891a5e112b2883e5d Mon Sep 17 00:00:00 2001
From: yuyou_x <2336760928@qq.com>
Date: 星期四, 01 二月 2024 09:34:18 +0800
Subject: [PATCH] 修改物料类别,调整物料信息页面

---
 Wms/WMS.BLL/SysServer/MaterialCategoryServer.cs |   15 +++++++++++----
 1 files changed, 11 insertions(+), 4 deletions(-)

diff --git a/Wms/WMS.BLL/SysServer/MaterialCategoryServer.cs b/Wms/WMS.BLL/SysServer/MaterialCategoryServer.cs
index 9789bf9..09f7b18 100644
--- a/Wms/WMS.BLL/SysServer/MaterialCategoryServer.cs
+++ b/Wms/WMS.BLL/SysServer/MaterialCategoryServer.cs
@@ -60,7 +60,7 @@
                 {
                     Id = a.Id,
 
-                    CategoryNo = a.CategoryNo, //绫诲埆鍙�
+                    CategoryNo = a.CategoryNo, //绫诲埆缂栫爜
                     CategoryName = a.CategoryName, //绫诲埆鍚嶇О
 
                     AreaNo = a.AreaNo, //鍖哄煙鍙�
@@ -215,7 +215,7 @@
                 Db.BeginTran();
                 SysMaterialCategory list = new SysMaterialCategory()
                 {
-                    CategoryNo = category.CategoryNo, //绫诲埆鍙�
+                    CategoryNo = category.CategoryNo, //绫诲埆缂栫爜
                     CategoryName = category.CategoryName, //绫诲埆鍚嶇О
 
                     AreaNo = category.AreaNo, //鍖哄煙缂栫爜
@@ -256,6 +256,8 @@
                 string msg = "";
                 //鑾峰彇绫诲埆淇℃伅
                 var categoryInfo = Db.Queryable<SysMaterialCategory>().First(a => a.IsDel == "0" && a.Id == category.Id);
+                //鑾峰彇绫诲埆瀵瑰簲鐗╂枡淇℃伅
+                var matelist = Db.Queryable<SysMaterials>().Where(a=>a.IsDel == "0" && a.CategoryNo == categoryInfo.CategoryNo).ToList();
                 //鑾峰彇鍖哄煙淇℃伅
                 var area = Db.Queryable<SysStorageArea>().First(a => category.AreaNo.Contains(a.AreaNo) && a.IsDel == "0");
 
@@ -265,16 +267,21 @@
                 }
 
                 Db.BeginTran();
-                categoryInfo.CategoryNo = category.CategoryNo; //绫诲埆鍙�
+                categoryInfo.CategoryNo = category.CategoryNo; //绫诲埆缂栫爜
                 categoryInfo.CategoryName = category.CategoryName; //绫诲埆鍚嶇О
                 categoryInfo.AreaNo = category.AreaNo; //鍖哄煙缂栫爜
                 categoryInfo.Demo = category.Demo; //澶囨敞
                 categoryInfo.UpdateUser = category.CreateUser; //鏇存敼浜�
                 categoryInfo.UpdateTime = Db.GetDate(); //鏇存敼鏃堕棿
 
-
                 Db.Updateable(categoryInfo).ExecuteCommand();
 
+                foreach (var item in matelist)
+                {
+                    item.CategoryNo = categoryInfo.CategoryNo;
+                }
+                Db.Updateable(matelist).ExecuteCommand();
+
                 Db.CommitTran();
 
                 msg = "缂栬緫绫诲埆淇℃伅鎴愬姛锛�";

--
Gitblit v1.8.0