From 5c4192f0b813d72a427eaca183d08d42046f1b41 Mon Sep 17 00:00:00 2001
From: jinxin <1013386558@qq.com>
Date: 星期一, 23 六月 2025 14:43:44 +0800
Subject: [PATCH] 11
---
C#/HH.WCS.Mobox3.WeiLi/api/ApiHelper.cs | 13 +++++++++++--
1 files changed, 11 insertions(+), 2 deletions(-)
diff --git "a/C\043/HH.WCS.Mobox3.WeiLi/api/ApiHelper.cs" "b/C\043/HH.WCS.Mobox3.WeiLi/api/ApiHelper.cs"
index 3a95f06..dd506a9 100644
--- "a/C\043/HH.WCS.Mobox3.WeiLi/api/ApiHelper.cs"
+++ "b/C\043/HH.WCS.Mobox3.WeiLi/api/ApiHelper.cs"
@@ -71,11 +71,15 @@
info.S_ITEM_NAME = a.itemName;
info.S_IS_MANAGE = a.isManage;
info.S_IS_MANAGEDATE = a.isManageDate;
- db.Updateable<TN_Material>(info).UpdateColumns(it => new { it.S_ITEM_NAME, it.S_IS_MANAGE, it.S_IS_MANAGEDATE }).ExecuteCommand();
+ info.S_UOM = a.unit;
+ db.Updateable<TN_Material>(info).UpdateColumns(it => new { it.S_ITEM_NAME, it.S_IS_MANAGE, it.S_IS_MANAGEDATE,it.S_UOM }).ExecuteCommand();
+
+
+ db.Updateable<CntrItemRel>().SetColumns(it => new CntrItemRel() { S_ITEM_NAME = a.itemName , S_UOM = a.unit }).Where(it=>it.S_ITEM_CODE==a.itemCode).ExecuteCommand();
}
else
{
- db.Insertable(new TN_Material { S_ITEM_CODE = a.itemCode, S_ITEM_NAME = a.itemName, S_IS_MANAGE = a.isManage, S_IS_MANAGEDATE = a.isManageDate }).ExecuteCommand();
+ db.Insertable(new TN_Material { S_ITEM_CODE = a.itemCode, S_ITEM_NAME = a.itemName, S_IS_MANAGE = a.isManage, S_IS_MANAGEDATE = a.isManageDate, S_UOM = a.unit }).ExecuteCommand();
}
//db.Updateable<TN_Material>().SetColumns(it => new TN_Material() { S_ITEM_NAME = a.itemName }).Where(it => it.S_ITEM_CODE == a.itemCode).ExecuteCommand();
//db.Updateable<WHInventory>().SetColumns(it => new WHInventory() { S_ITEM_NAME = a.itemName }).Where(it => it.S_ITEM_CODE == a.itemCode).ExecuteCommand();
@@ -1433,6 +1437,7 @@
S_BATCH_NO = a.batchNo,
S_OWNER = a.factoryCode,
S_ERP_WH_CODE = a.stockLoc,
+ S_UOM=itemName.S_UOM,
F_QTY = a.qty,
S_SUPPLIER_NO = a.vendorCode,
S_SERIAL_NO = a.serialNo,
@@ -3166,6 +3171,7 @@
S_ITEM_NAME = itemName.S_ITEM_NAME,
S_ITEM_CODE = a.itemCode,
S_BATCH_NO = a.batchNo,
+ S_UOM=itemName.S_UOM,
S_BS_NO=a.inWorkNo,
S_OWNER = a.factoryCode,
S_ERP_WH_CODE = a.stockLocation,
@@ -3371,6 +3377,7 @@
S_CNTR_CODE = model.cntrNo,
S_WU = a.rowID,
S_ITEM_NAME = itemName.S_ITEM_NAME,
+ S_UOM = itemName.S_UOM,
S_ITEM_CODE = a.itemCode,
S_BATCH_NO = a.batchNo,
S_OWNER = a.factoryCode,
@@ -3516,6 +3523,7 @@
{
S_CNTR_CODE = cntr,
S_ITEM_NAME = itemName.S_ITEM_NAME,
+ S_UOM = itemName.S_UOM,
S_ITEM_CODE = a.itemCode,
S_BATCH_NO = a.batchNo,
S_OWNER = a.factoryCode,
@@ -3580,6 +3588,7 @@
{
S_CNTR_CODE = cntr,
S_ITEM_NAME = itemName.S_ITEM_NAME,
+ S_UOM = itemName.S_UOM,
S_ITEM_CODE = it.itemCode,
S_BATCH_NO = it.batchNo,
S_OWNER = it.factoryCode,
--
Gitblit v1.9.1