From 2a7ba2095fede6da921e696f2667cb896ba0bd8d Mon Sep 17 00:00:00 2001
From: bklLiudl <673013083@qq.com>
Date: 星期日, 04 二月 2024 08:02:44 +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