From 6295e95e558ab6e9da2e7ff860b6918cc6b414b6 Mon Sep 17 00:00:00 2001
From: Rodney Chen <rodney.chen@hotmail.com>
Date: 星期六, 22 三月 2025 21:00:44 +0800
Subject: [PATCH] 优化了一些已知问题
---
Tiger.Api/Controllers/Test/TestController.R.cs | 2 +-
Tiger.Business.WMS/iSRM/SrmToWms.cs | 4 ++--
Tiger.Business.WMS/WMS_ITEM_Biz.cs | 4 ++--
Tiger.Business.WMS/Transaction/WmsCount.cs | 2 +-
4 files changed, 6 insertions(+), 6 deletions(-)
diff --git a/Tiger.Api/Controllers/Test/TestController.R.cs b/Tiger.Api/Controllers/Test/TestController.R.cs
index 33e9ae2..9e42073 100644
--- a/Tiger.Api/Controllers/Test/TestController.R.cs
+++ b/Tiger.Api/Controllers/Test/TestController.R.cs
@@ -154,7 +154,7 @@
//var data = 0;
//try
//{
- // data = Biz.Db.Ado.UseStoredProcedure().ExecuteCommand("pkg_ImportItemFromSRM", new SugarParameter("dlvyNo", "BAD202308240443"));
+ // data = Biz.Db.Ado.UseStoredProcedure().ExecuteCommand("sp_ImportItemFromSRM", new SugarParameter("dlvyNo", "BAD202308240443"));
//}
//catch (System.Exception ex)
//{
diff --git a/Tiger.Business.WMS/Transaction/WmsCount.cs b/Tiger.Business.WMS/Transaction/WmsCount.cs
index e4f788b..1bfac82 100644
--- a/Tiger.Business.WMS/Transaction/WmsCount.cs
+++ b/Tiger.Business.WMS/Transaction/WmsCount.cs
@@ -546,7 +546,7 @@
public override bool Close(bool needSaveHistoryLog = false)
{
//妫�鏌ョ洏鐐瑰崟鏄惁鍏抽棴
- Biz.Db.Ado.UseStoredProcedure().ExecuteCommand("pkg_count_status", new SugarParameter("CountNo", count.COUNT_NO));
+ Biz.Db.Ado.UseStoredProcedure().ExecuteCommand("sp_count_status", new SugarParameter("CountNo", count.COUNT_NO));
//needSaveHistoryLog = true;
CloseLight(new CountLightEntity() { ShelfCode = "" }).Wait();
//淇濆瓨鎿嶄綔鏃ュ織
diff --git a/Tiger.Business.WMS/WMS_ITEM_Biz.cs b/Tiger.Business.WMS/WMS_ITEM_Biz.cs
index ea6dae1..5e22b24 100644
--- a/Tiger.Business.WMS/WMS_ITEM_Biz.cs
+++ b/Tiger.Business.WMS/WMS_ITEM_Biz.cs
@@ -185,8 +185,8 @@
inv.Region = query.Region;
inv.Shelf = query.Shelf;
inv.Location = query.Location;
- inv.Packages = Biz.Db.Ado.UseStoredProcedure().SqlQuery<WMS_ITEM_PKG>("pkg_wms_get_item_pkg", new SugarParameter("root", barcode.SN));
- inv.Items = Biz.Db.Ado.UseStoredProcedure().SqlQuery<WMS_ITEM>("pkg_wms_get_items", new SugarParameter("root", barcode.SN));
+ inv.Packages = Biz.Db.Ado.UseStoredProcedure().SqlQuery<WMS_ITEM_PKG>("sp_wms_get_item_pkg", new SugarParameter("root", barcode.SN));
+ inv.Items = Biz.Db.Ado.UseStoredProcedure().SqlQuery<WMS_ITEM>("sp_wms_get_items", new SugarParameter("root", barcode.SN));
inv.ItemsExt = Biz.Db.Queryable<WMS_ITEM_EXT>().Where(q => inv.Items.Any(s => s.SN == q.SN)).ToList();//鎵╁睍琛�
//var data = inv.Items.Select(i => i.SN).ToList().Except(inv.ItemsExt.Select(i => i.SN).ToList());
var data = inv.Items.Where(q => !inv.ItemsExt.Any(s => s.SN == q.SN)).ToList();
diff --git a/Tiger.Business.WMS/iSRM/SrmToWms.cs b/Tiger.Business.WMS/iSRM/SrmToWms.cs
index 0c65b3b..7e672d5 100644
--- a/Tiger.Business.WMS/iSRM/SrmToWms.cs
+++ b/Tiger.Business.WMS/iSRM/SrmToWms.cs
@@ -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)
@@ -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