From 3706fb22a858169204aa05a01b38ec1a4e04b5c7 Mon Sep 17 00:00:00 2001
From: liuying <1427574514@qq.com>
Date: 周六, 30 11月 2024 16:22:31 +0800
Subject: [PATCH] 大屏
---
LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/WmsCommonnQuery/WmsCommonnQueryService.cs | 109 ++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 108 insertions(+), 1 deletions(-)
diff --git a/LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/WmsCommonnQuery/WmsCommonnQueryService.cs b/LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/WmsCommonnQuery/WmsCommonnQueryService.cs
index f13ebdd..ded416f 100644
--- a/LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/WmsCommonnQuery/WmsCommonnQueryService.cs
+++ b/LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/WmsCommonnQuery/WmsCommonnQueryService.cs
@@ -7,6 +7,8 @@
using DocumentFormat.OpenXml.Office.CustomUI;
using Microsoft.CodeAnalysis.Operations;
using Admin.NET.Application.Service.WmsTask.WmsRbLineTask.Dto;
+using Admin.NET.Application.Service.WmsCommonnQuery.Dto;
+using System.Collections.Generic;
namespace Admin.NET.Application;
/// <summary>
@@ -22,12 +24,16 @@
private readonly SqlSugarRepository<SysConfig> _sysConfigRep;
private readonly SqlSugarRepository<Mes_BatchOrderUPI_New> _mesBatchOrderUpiRep;
private readonly SqlSugarRepository<Mes_Order_Gather> _mesOrderGatherRep;
+ private readonly SqlSugarRepository<Mes_Package_UnLine_Record> _mesPackage_UnLine_RecordRep;
+ private readonly SqlSugarRepository<Mes_Package_LineQueue> _mesPackage_LineQueueRep;
public WmsCommonnQueryService(SqlSugarRepository<WmsRbLineTask> rep, SqlSugarRepository<WmsStockQuan> wmsStockQuanRep
, SqlSugarRepository<Mes_Package_Gather> mesPackageGatherRep
, SqlSugarRepository<SysConfig> sysConfigRep
, SqlSugarRepository<Mes_BatchOrderUPI_New> mesBatchOrderUpiRep
, SqlSugarRepository<Mes_Order_Gather> mesOrderGatherRep
+ , SqlSugarRepository<Mes_Package_UnLine_Record> mesPackage_UnLine_RecordRep
+ , SqlSugarRepository<Mes_Package_LineQueue> mesPackage_LineQueueRep
)
{
_sysConfigRep = sysConfigRep;
@@ -36,6 +42,8 @@
_wmsStockQuanRep = wmsStockQuanRep;
_mesBatchOrderUpiRep = mesBatchOrderUpiRep;
_mesOrderGatherRep = mesOrderGatherRep;
+ _mesPackage_UnLine_RecordRep = mesPackage_UnLine_RecordRep;
+ _mesPackage_LineQueueRep = mesPackage_LineQueueRep;
}
/// <summary>
@@ -59,6 +67,39 @@
return list; // 缁撴灉
}
+
+
+ /// <summary>
+ /// 鏌ヨ 璁″垝鐢熶骇璁㈠崟璁板綍 锛堝ぇ灞忎娇鐢級
+ /// </summary>
+ /// <returns></returns>
+ [HttpGet]
+ [ApiDescriptionSettings(Name = "QueryPlanOrderList")]
+ [Description("WmsCommonnQuery/QueryPlanOrderList")]
+ public async Task<List<Mes_Order_Gather>> QueryPlanOrderList()
+ {
+ var list = await _mesPackage_LineQueueRep.AsQueryable()
+ .OrderBy(g => g.Id)
+ .ToListAsync(); // 纭繚鑾峰彇缁撴灉涓� List
+ List<Mes_Order_Gather> resultList = new List<Mes_Order_Gather>();
+ foreach (var item in list)
+ {
+ if (resultList.Select(x => x.Info5).ToList().Contains(item.Info5))
+ {
+
+ }
+ else
+ {
+ var mesOrderGather = await _mesOrderGatherRep.GetFirstAsync(x => x.Info5 == item.Info5);
+ if (mesOrderGather != null)
+ {
+ resultList.Add(mesOrderGather);
+ }
+ }
+ }
+
+ return resultList; // 缁撴灉
+ }
/// <summary>
/// 鏌ヨ 鍘嗗彶鐢熶骇璁㈠崟璁板綍 锛堝ぇ灞忎娇鐢級
@@ -97,7 +138,7 @@
public async Task<Mes_Order_Gather> QueryCurrentOrder()
{
//鑾峰彇涓婄彮鏃堕棿銆�
- var sysConfig_wms_wms_unline_oper = await _sysConfigRep.GetFirstAsync(x => x.Code == CommonConst.wms_unline_oper);
+ var sysConfig_wms_wms_unline_oper = await _sysConfigRep.GetFirstAsync(x => x.Code == CommonConst.WmsBZ30_QiTao);
if (sysConfig_wms_wms_unline_oper == null || sysConfig_wms_wms_unline_oper.Value == "鏃�")
{
return null;
@@ -116,5 +157,71 @@
return list; // 缁撴灉
}
+
+
+
+
+ /// <summary>
+ /// 澶у睆 - 鐧诲綍浜� 鐧诲綍鏃堕棿 LS070700117B0005GS
+ /// </summary>
+ /// <param name="input"></param>
+ /// <returns></returns>
+ [HttpGet]
+ [ApiDescriptionSettings(Name = "ScreenLogin")]
+ [Description("WmsCommonnQuery/ScreenLogin")]
+ [AllowAnonymous]
+ public async Task<ScreenLoginUserOutput> ScreenLogin([FromQuery] Mes_Package_LineQueueInput input)
+ {
+ // 鍩烘湰鏌ヨ
+ var list = await _sysConfigRep.AsQueryable()
+ .Where(x => x.Code == "wms_bz30_qitao" || x.Code == "wms_unline_oper" || x.Code == "wms_unline_time")
+ .ToListAsync();
+ // 妫�鏌ist鏄惁涓虹┖
+ if (list == null || !list.Any())
+ {
+ // 杩斿洖榛樿鍊兼垨鑰呮姏鍑哄紓甯�
+ return new ScreenLoginUserOutput
+ {
+ LoginUser = null,
+ TimeLogin = null,
+ };
+ }
+
+ //鑾峰彇涓婄彮鏃堕棿銆�
+ DateTime unLineTime = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd 00:00:00"));
+ var sysConfig_wms_unline_time = await _sysConfigRep.GetFirstAsync(x => x.Code == CommonConst.wms_unline_time);
+ if (sysConfig_wms_unline_time == null || sysConfig_wms_unline_time.Value == "鏃�")
+ {
+
+ }
+ else
+ {
+ unLineTime = Convert.ToDateTime(sysConfig_wms_unline_time.Value);
+ }
+
+
+ var recordList = await _mesPackage_UnLine_RecordRep.AsQueryable()
+ .Where(x => x.CreateTime >= unLineTime)
+ .ToListAsync(); // 纭繚鑾峰彇缁撴灉涓� List
+ //姹囨�绘暟鎹�
+
+
+ TimeSpan ts = DateTime.Now - unLineTime;
+
+ // 杩斿洖缁撴灉
+ return new ScreenLoginUserOutput
+ {
+ LoginUser = list.FirstOrDefault(x => x.Code == "wms_unline_oper")?.Value,
+ TimeLogin = list.FirstOrDefault(x => x.Code == "wms_unline_time")?.Value,
+ AllOrderNum = recordList.GroupBy(x => x.Info5).Count(),
+ AllPackageArea = recordList.Sum(x => Convert.ToDecimal((x.Info13))),
+ PackageNum = recordList.GroupBy(x => x.PackageCode).Count(),
+ WorkTime = ts.TotalHours
+ };
+ }
+
+
+
+
}
--
Gitblit v1.9.3