From f8be4db0be9e9de5830dd41f7d156c368a1ea43f Mon Sep 17 00:00:00 2001
From: Rodney Chen <rodney.chen@hotmail.com>
Date: 星期四, 24 四月 2025 09:45:20 +0800
Subject: [PATCH] 优化了一些已知问题
---
Tiger.Business.WMS/iSRM/SrmToWms.cs | 18 +++++++++---------
1 files changed, 9 insertions(+), 9 deletions(-)
diff --git a/Tiger.Business.WMS/iSRM/SrmToWms.cs b/Tiger.Business.WMS/iSRM/SrmToWms.cs
index 315ff3b..7e672d5 100644
--- a/Tiger.Business.WMS/iSRM/SrmToWms.cs
+++ b/Tiger.Business.WMS/iSRM/SrmToWms.cs
@@ -53,7 +53,7 @@
switch (group)
{
case "XCSJ":
- db = Biz.DataSource["Main"].Client;
+ db = Biz.Db;
break;
case "DGXC":
@@ -124,7 +124,7 @@
productCode = item.materialNumber,
//productName = item.productName,
//productScale = item.productScale,
- deliveryQty = Convert.ToDecimal(item.deliveryQuantity),
+ deliveryQty = Convert.ToDouble(item.deliveryQuantity),
//deliveryUnitCode = item.deliveryUnitCode,
deliveryUnitName = item.purchaseUnit,
//deliveryValuationQty = Convert.ToInt32(item.deliveryValuationQty),
@@ -159,7 +159,7 @@
dlvySn.SOURCETYPE = "SRM";
//dlvySn.ITEM_NAME = item.productName;
//dlvySn.SPECIFICATION = item.productScale;
- dlvySn.IncludeQty = Convert.ToDecimal(item.materialQuantity);
+ dlvySn.IncludeQty = Convert.ToDouble(item.materialQuantity);
dlvySn.SmallBarcode = item.packetBarcodeNumber;
dlvySn.BigBarcode = item.mediumBarcodeNumber;
dlvySn.OuterBarcode = item.cartonBarcodeNumber;
@@ -301,7 +301,7 @@
dtl.ITEM_CODE = item.materialNumber;
//productName = item.productName,
//productScale = item.productScale,
- dtl.QTY = Convert.ToDecimal(item.deliveryQuantity);
+ dtl.QTY = Convert.ToDouble(item.deliveryQuantity);
dtl.UNIT = item.purchaseUnit;
dtl.PRICE = Convert.ToDouble(item.price);
dtl.TAX_PRICE = Convert.ToDouble(item.taxPrice);
@@ -331,7 +331,7 @@
dlvySn.DELIVERY_NO = DeliveryNo;
//dlvySn.PO_LINE_NO = lineno;
dlvySn.ITEM_CODE = item.materialNumber;
- dlvySn.QTY = Convert.ToDecimal(item.materialQuantity);
+ dlvySn.QTY = Convert.ToDouble(item.materialQuantity);
dlvySn.SMALL_BARCODE = sn;
dlvySn.SMALL_SN = sn;
dlvySn.BIG_BARCODE = item.mediumBarcodeNumber;
@@ -538,7 +538,7 @@
try
{
var bTime = DateTime.Now;
- Biz.Db.Ado.UseStoredProcedure().ExecuteCommand("pkg_ImportItemFromSRM", new SugarParameter("dlvyNo", dlvy.documnetNumber));
+ Biz.Db.Ado.UseStoredProcedure().ExecuteCommand("sp_ImportItemFromSRM", new SugarParameter("dlvyNo", dlvy.documnetNumber));
Logger.Scheduler.Info($"New QqtSRM 淇濆瓨閫佽揣鍗昜{dlvy.documnetNumber}]鏉＄爜瀵煎叆WMS_ITEM瀹屾垚锛岃�楁椂:[{(DateTime.Now - bTime).TotalMilliseconds}]姣");
}
catch (System.Exception ex)
@@ -621,7 +621,7 @@
dtl.ITEM_CODE = item.materialNumber;
//productName = item.productName,
//productScale = item.productScale,
- dtl.QTY = Convert.ToDecimal(item.deliveryQuantity);
+ dtl.QTY = Convert.ToDouble(item.deliveryQuantity);
dtl.UNIT = item.purchaseUnit;
dtl.PRICE = Convert.ToDouble(item.price);
dtl.TAX_PRICE = Convert.ToDouble(item.taxPrice);
@@ -651,7 +651,7 @@
dlvySn.DELIVERY_NO = DeliveryNo;
//dlvySn.PO_LINE_NO = lineno;
dlvySn.ITEM_CODE = item.materialNumber;
- dlvySn.QTY = Convert.ToDecimal(item.materialQuantity);
+ dlvySn.QTY = Convert.ToDouble(item.materialQuantity);
dlvySn.SMALL_BARCODE = sn;
dlvySn.SMALL_SN = sn;
dlvySn.BIG_BARCODE = item.mediumBarcodeNumber;
@@ -921,7 +921,7 @@
try
{
var bTime = DateTime.Now;
- adoDb.Ado.UseStoredProcedure().ExecuteCommand("pkg_ImportItemFromSRM", new SugarParameter("dlvyNo", dlvy.documnetNumber));
+ adoDb.Ado.UseStoredProcedure().ExecuteCommand("sp_ImportItemFromSRM", new SugarParameter("dlvyNo", dlvy.documnetNumber));
Logger.Scheduler.Info($"New QqtSRM 淇濆瓨閫佽揣鍗昜{dlvy.documnetNumber}]鏉＄爜瀵煎叆WMS_ITEM瀹屾垚锛岃�楁椂:[{(DateTime.Now - bTime).TotalMilliseconds}]姣");
}
catch (System.Exception ex)
--
Gitblit v1.9.3