From f68218d98591c1238d6f299152545b018cc31257 Mon Sep 17 00:00:00 2001
From: hudong <Administrator@PC-20250329JZUF>
Date: 星期五, 06 六月 2025 13:54:45 +0800
Subject: [PATCH] 代码超时优化
---
api/WmsSapController.cs | 42 ++++++++++++++++++++++++++++++++++++++----
1 files changed, 38 insertions(+), 4 deletions(-)
diff --git a/api/WmsSapController.cs b/api/WmsSapController.cs
index ea23188..cdc1ded 100644
--- a/api/WmsSapController.cs
+++ b/api/WmsSapController.cs
@@ -20,17 +20,46 @@
using static HH.WCS.Mobox3.pinggao.models.DAPING;
using HH.WCS.Mobox3.pinggao.util;
using SqlSugar;
+using System.Diagnostics;
namespace HH.WCS.Mobox3.pinggao.api
{
public class WmsSapController : System.Web.Http.ApiController
{
-
- #region 澶у睆鏁版嵁鎺ュ彛
/// <summary>
- /// 澶у睆鏁版嵁
+ /// 鍑哄韩浠诲嫏鍒楄〃
/// </summary>
/// <returns></returns>
+ public DPList DpRecord(DpDto dpDto)
+ {
+ var response = new DPList
+ {
+ DpList = new List<DP> { }
+ };
+ if (string.IsNullOrEmpty(dpDto.Code))
+ {
+ LogHelper.Info("璐т綅淇℃伅涓嶈兘涓虹┖" );
+ return response;
+ }
+ var db = new SqlHelper<object>().GetInstance();
+ var list =db.Queryable<TN_DPRECORD>().Where(s=>s.S_LOCATION== dpDto.Code).OrderByDescending(s=>s.T_CREATE).ToList();
+ var tasksList = list.Select(t => new DP
+ {
+ S_NO = t.S_NO,
+ S_WLBM = t.S_WLBM,
+ S_WLMC = t.S_WLMC,
+ N_COUNT = t.N_COUNT,
+ S_LOCATION = t.S_LOCATION
+ }).ToList();
+ response.DpList = tasksList;
+ return response;
+
+ }
+ #region 澶у睆鏁版嵁鎺ュ彛
+ /// <summary>
+ /// 澶у睆鏁版嵁
+ /// </summary>
+ /// <returns></returns>
public BarChartResponse InOut(){
var response = new BarChartResponse
@@ -584,6 +613,8 @@
[HttpPost]
public LLDReturnRoot.Root LLDReceiveXmlData([FromBody] CKDdto.Root xmlData)
{
+ Stopwatch sw = new Stopwatch();
+ sw.Start();
#region xml鏁版嵁鎺ユ敹杞暟缁� LogHelper.Info("鐢熶骇璁㈠崟棰嗘枡鍗�鐢熸垚棰嗘枡鍗�鎺ュ彛锛� + JsonConvert.SerializeObject(xmlData));
@@ -604,11 +635,14 @@
#region 鍑哄簱涓氬姟娴佺▼
LLDReturnRoot.Root json = WmsSpaHelper.Out_Order_Ins(xmlData);
+
+
//鎺ユ敹杩斿洖鍙傛暟 鐢熸垚sap瀵规帴鏂囨。杩斿洖鏍煎紡
//var json = WmsSpaHelper.GetJsonResult(simpleResult.WLPZBH, simpleResult.resultCode.ToString(), simpleResult.resultMsg);
//鎺ユ敹杩斿洖鍙傛暟 鐢熸垚sap瀵规帴鏂囨。杩斿洖鏍煎紡
List<WcReturnRoot.ITEM> wcReturnRoots = new List<WcReturnRoot.ITEM>();
-
+ sw.Stop();
+ long elapsedMilliseconds = sw.ElapsedMilliseconds;
return json;
#endregion
//#region 杩斿洖xml
--
Gitblit v1.9.1