From 77da8b9247b9df926678cfb7e4af0f0900f3a084 Mon Sep 17 00:00:00 2001
From: Rodney Chen <rodney.chen@hotmail.com>
Date: 星期二, 13 五月 2025 18:32:52 +0800
Subject: [PATCH] 修复了一些已知问题
---
Tiger.Api/Controllers/Test/TestController.R.cs | 72 ++++++++++++++++++++++++++++++++---
1 files changed, 65 insertions(+), 7 deletions(-)
diff --git a/Tiger.Api/Controllers/Test/TestController.R.cs b/Tiger.Api/Controllers/Test/TestController.R.cs
index 7221958..e5dd609 100644
--- a/Tiger.Api/Controllers/Test/TestController.R.cs
+++ b/Tiger.Api/Controllers/Test/TestController.R.cs
@@ -25,6 +25,9 @@
using Microsoft.CodeAnalysis.Options;
using System.IO;
using System.Runtime.Loader;
+using MailKit.Search;
+using Tiger.Model.DigitalTwin;
+using static Microsoft.Scripting.Hosting.Shell.ConsoleHostOptions;
namespace Tiger.Api.Controllers.Test
{
@@ -98,6 +101,10 @@
//predicate = predicate.And(q => q.RULE_TYPE == 0);
////var data = Cache.CodeRule.Rules.Where(predicate.Compile());
//var data = Cache.CodeRule.Verify("AB23#7930000002010", predicate.Compile());
+
+ var trans = AutoFacContainer.Instance.Resolve<IOut_BIZ_WMS_PREP>().Init("action.ID", "action.Data?.USER_CODE", "", "action.Data?.ORG_CODE");
+ var task = trans.Scan(new BaseInput() { Data = "" });
+
return Ok("");
}
@@ -152,7 +159,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)
//{
@@ -167,9 +174,9 @@
//Biz.Db.Fastest<WMS_WAREHOUSE>().BulkUpdate(data, new string[] { "ID" }, new string[] { "UPDATE_TIME", "UPDATE_USER" });
//Biz.Db.Insertable(data, "Interface").ExecuteCommand();
- var root = new SugarParameter("root", "system01");
- var dt = Biz.Db.Ado.UseStoredProcedure().GetDataTable("SP_SYS_GET_MENU", root);//杩斿洖dt
- var data = Biz.Db.Ado.UseStoredProcedure().SqlQuery<SYS_MENU>("SP_SYS_GET_MENU", root);//杩斿洖List
+ //var root = new SugarParameter("root", "system01");
+ //var dt = Biz.Db.Ado.UseStoredProcedure().GetDataTable("SP_SYS_GET_MENU", root);//杩斿洖dt
+ //var data = Biz.Db.Ado.UseStoredProcedure().SqlQuery<SYS_MENU>("SP_SYS_GET_MENU", root);//杩斿洖List
;
//var data = Biz.Db.Queryable<BIZ_SRM_DLVY>()
// .IncludesAllFirstLayer()
@@ -199,6 +206,8 @@
//{
// throw dbTran.ErrorException;
//}
+
+ var data = Biz.Db.Queryable<BIZ_U9_ASN>().Where(q => q.ORDER_NO.Contains(param.IsNullOrEmpty("娌℃湁鍗曞彿涓嶆煡璇SN鍗�"))).Select(q => q.ID).ToList().IsNullOrEmpty(new() { "鏌ヨ涓嶅埌ASN鍗�" });
return Ok(data);
}
/// <summary>
@@ -373,11 +382,60 @@
{
var data = action.Data;
- var json = @$"";
+ //var json = new {
+ // SN = "V025720241120000161",
+ // ItemCode = "160305330",
+ // Qty = 1700,
+ // Unit = "PCS",
+ // Supplier = "V0381",
+ // DeliveryDate = DateTime.Now,
+ // ProdDate = DateTime.Now,
+ // BatchNo = "20241120",
+ // ValidityDays = 365,
+ // SerialNo = 161,
+ // ItemName = "L-CW1323GA 涓や釜瑁呭僵鐩� 闅旀澘 鏉愯川300g鍗曠矇瑁盰F鍔犲己杩囧搼鑶� 105 mm 85 mm 3 mm 鍗楁嘲 ",
+ // Warehouse = "W0001",
+ // ItemModel = "鏉愭枡 闆朵欢 鍟嗗搧",
+ //};
+ //var result = action.GetResponse("GetSnInfo success.", json, true);
- var result = action.GetResponse("GetSnInfo success.", json, true);
+ //var json = new List<object>
+ //{
+ // new {
+ // OrderNo = "RE202404308721",
+ // Warehouse = "",
+ // Details = new List<object>
+ // {
+ // new { ItemCode = "442500010", ItemName = "闀挎き鍦嗗舰鍗￠拡 35 x7.3 x0.9mm SUS304H 鏂粶娉�", Qty = 1000 },
+ // new { ItemCode = "442500011", ItemName = "鐭き鍦嗗舰鍗￠拡 35 x7.3 x0.9mm SUS304H 鏂粶娉�", Qty = 500 }
+ // },
+ // SnDetails = new List<object>
+ // {
+ // new { SN = "V029720240427000069", ItemCode = "442500010", Qty = 500, Carton = "CV029720240427000001", Pallet = "PV029720240427000001" },
+ // new { SN = "V029720240427000070", ItemCode = "442500010", Qty = 500, Carton = "CV029720240427000001", Pallet = "PV029720240427000001" },
+ // new { SN = "V029720240427000071", ItemCode = "442500011", Qty = 500, Carton = "CV029720240427000002", Pallet = "PV029720240427000001" },
+ // },
+ // }
+ //};
+ //var result = action.GetResponse("GetInOrder success.", json, true);
- return Ok(new { result, result.Timestamp, result.IsSuccessed, result.Message, result.Data });
+ //var json = new List<object>
+ //{
+ // new {
+ // OrderNo = "XC5406-231014306",
+ // Warehouse = "XC003",
+ // Details = new List<object>
+ // {
+ // new { ItemCode = "250100420", ItemName = "IC SMD DC-DC 0.6V 鍗曡矾 1A 1.5MHZ SOT563 TLV62568DRL TI", Qty = 1000 },
+ // new { ItemCode = "200203670", ItemName = "CAP SMD X5R 0402 6.3V 4.7uF卤20%", Qty = 1500 }
+ // },
+ // }
+ //};
+ //var result = action.GetResponse("GetOutOrder success.", json, true);
+
+ var result = action.GetResponse("OutTask success.", true);
+
+ return Ok(new { result.Timestamp, result.IsSuccessed, result.Message, result.Data });
}
[HttpGet]
--
Gitblit v1.9.3