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 | 15 +++++++++++---- 1 files changed, 11 insertions(+), 4 deletions(-) diff --git a/Tiger.Api/Controllers/Test/TestController.R.cs b/Tiger.Api/Controllers/Test/TestController.R.cs index 33e9ae2..e5dd609 100644 --- a/Tiger.Api/Controllers/Test/TestController.R.cs +++ b/Tiger.Api/Controllers/Test/TestController.R.cs @@ -27,6 +27,7 @@ using System.Runtime.Loader; using MailKit.Search; using Tiger.Model.DigitalTwin; +using static Microsoft.Scripting.Hosting.Shell.ConsoleHostOptions; namespace Tiger.Api.Controllers.Test { @@ -100,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(""); } @@ -154,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) //{ @@ -169,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() @@ -201,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> -- Gitblit v1.9.3