From 0e17f5d5afb9e21500390cedb83fb5e1af0ded1d Mon Sep 17 00:00:00 2001
From: YangYuGang <1378265336@qq.com>
Date: 星期三, 19 三月 2025 18:06:04 +0800
Subject: [PATCH] 分页存储优化
---
Tiger.Business.WMS/iSRM/iSRM.cs | 20 ++++++++++----------
1 files changed, 10 insertions(+), 10 deletions(-)
diff --git a/Tiger.Business.WMS/iSRM/iSRM.cs b/Tiger.Business.WMS/iSRM/iSRM.cs
index 1f38284..11a3b56 100644
--- a/Tiger.Business.WMS/iSRM/iSRM.cs
+++ b/Tiger.Business.WMS/iSRM/iSRM.cs
@@ -146,9 +146,9 @@
asn.CreationTime = DateTime.Now;
asn.LastModificationTime = DateTime.Now;
asn.updateTime = FromUnixTime(responseJson["data"]["updateTime"]?.ToInt64());
- asn.grossWeight = responseJson["data"]["grossWeight"]?.ToDecimal() ?? 0;
- asn.netWeight = responseJson["data"]["netWeight"]?.ToDecimal() ?? 0;
- asn.totalPackingQty = responseJson["data"]["totalPackingQty"]?.ToDecimal() ?? 0;
+ asn.grossWeight = responseJson["data"]["grossWeight"]?.ToDouble() ?? 0;
+ asn.netWeight = responseJson["data"]["netWeight"]?.ToDouble() ?? 0;
+ asn.totalPackingQty = responseJson["data"]["totalPackingQty"]?.ToDouble() ?? 0;
asn.cargoDeliveryTime = FromUnixTime(responseJson["data"]["cargoDeliveryTime"]?.ToInt64());
asn.CreationTime = DateTime.Now;
dlvy.FLAW = "Y";
@@ -169,10 +169,10 @@
productCode = item["productCode"]?.ToString(),
productName = item["productName"]?.ToString(),
productScale = item["productScale"]?.ToString(),
- deliveryQty = item["deliveryQty"]?.ToDecimal() ?? 0,
+ deliveryQty = item["deliveryQty"]?.ToDouble() ?? 0,
deliveryUnitCode = item["deliveryUnitCode"]?.ToString(),
deliveryUnitName = item["deliveryUnitName"]?.ToString(),
- deliveryValuationQty = item["deliveryValuationQty"]?.ToDecimal() ?? 0,
+ deliveryValuationQty = item["deliveryValuationQty"]?.ToDouble() ?? 0,
price = item["price"]?.ToDouble() ?? double.MinValue,
taxPrice = item["taxPrice"]?.ToDouble() ?? double.MinValue,
status = item["status"]?.ToInt32() ?? 0,
@@ -355,7 +355,7 @@
db = Biz.DataSource["Test"].Client;
break;
case "XCSJ":
- db = Biz.DataSource["Main"].Client;
+ db = Biz.Db;
_lastrun = "QqtLastRun";
break;
case "DGXC":
@@ -447,7 +447,7 @@
productCode = item["materialNumber"]?.ToString(),
//productName = item["productName"]?.ToString(),
//productScale = item["productScale"]?.ToString(),
- deliveryQty = item["deliveryQuantity"]?.ToDecimal() ?? 0,
+ deliveryQty = item["deliveryQuantity"]?.ToDouble() ?? 0,
//deliveryUnitCode = item["deliveryUnitCode"]?.ToString(),
deliveryUnitName = item["purchaseUnit"]?.ToString(),
//deliveryValuationQty = item["deliveryValuationQty"]?.ToInt32() ?? 0,
@@ -482,7 +482,7 @@
dlvySn.SOURCETYPE = "SRM";
//dlvySn.ITEM_NAME = item["productName"]?.ToString();
//dlvySn.SPECIFICATION = item["productScale"]?.ToString();
- dlvySn.IncludeQty = item["materialQuantity"]?.ToDecimal() ?? int.MinValue;
+ dlvySn.IncludeQty = item["materialQuantity"]?.ToDouble() ?? int.MinValue;
dlvySn.SmallBarcode = item["packetBarcodeNumber"]?.ToString();
dlvySn.BigBarcode = item["mediumBarcodeNumber"]?.ToString();
dlvySn.OuterBarcode = item["cartonBarcodeNumber"]?.ToString();
@@ -666,7 +666,7 @@
ITEM_CODE = item["materialNumber"]?.ToString(),
//productName = item["productName"]?.ToString(),
//productScale = item["productScale"]?.ToString(),
- QTY = item["deliveryQuantity"]?.ToDecimal() ?? 0,
+ QTY = item["deliveryQuantity"]?.ToDouble() ?? 0,
//deliveryUnitCode = item["deliveryUnitCode"]?.ToString(),
UNIT = item["purchaseUnit"]?.ToString(),
//deliveryValuationQty = item["deliveryValuationQty"]?.ToInt32() ?? 0,
@@ -700,7 +700,7 @@
//dlvySn.SOURCETYPE = "SRM";
//dlvySn.ITEM_NAME = item["productName"]?.ToString();
//dlvySn.SPECIFICATION = item["productScale"]?.ToString();
- dlvySn.QTY = item["materialQuantity"]?.ToDecimal() ?? int.MinValue;
+ dlvySn.QTY = item["materialQuantity"]?.ToDouble() ?? int.MinValue;
dlvySn.SMALL_BARCODE = item["packetBarcodeNumber"]?.ToString();
dlvySn.BIG_BARCODE = item["mediumBarcodeNumber"]?.ToString();
dlvySn.OUTER_BARCODE = item["cartonBarcodeNumber"]?.ToString();
--
Gitblit v1.9.3