服务端的TigerApi 框架,基于.NET6 2024 版本
Rodney Chen
12 小时以前 77da8b9247b9df926678cfb7e4af0f0900f3a084
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("没有单号不查询ASN单"))).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单粉裱YF加强过哑膜 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]