From 9597b1df912c1ca4401a74970d9472e268b3a9c2 Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周六, 07 12月 2024 15:12:59 +0800
Subject: [PATCH] 33
---
LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/WmsStockQuan/WmsStockQuan/WmsStockQuanService.cs | 93 ++++++----------------------------------------
1 files changed, 12 insertions(+), 81 deletions(-)
diff --git a/LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/WmsStockQuan/WmsStockQuan/WmsStockQuanService.cs b/LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/WmsStockQuan/WmsStockQuan/WmsStockQuanService.cs
index f246294..a397772 100644
--- a/LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/WmsStockQuan/WmsStockQuan/WmsStockQuanService.cs
+++ b/LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/WmsStockQuan/WmsStockQuan/WmsStockQuanService.cs
@@ -4,7 +4,6 @@
using System.Data;
using System.Web;
using System.Text;
-using System;
namespace Admin.NET.Application;
/// <summary>
/// 搴撳瓨淇℃伅鏈嶅姟
@@ -159,12 +158,12 @@
.Select<WmsStockQuanOutput>();
if(input.InTimeRange != null && input.InTimeRange.Count >0)
{
- DateTime? start= input.InTimeRange[0].Value.AddDays(-1);
- query = query.WhereIF(start.HasValue, u => u.InTime > start);
+ DateTime? start= input.InTimeRange[0].Value;
+ query = query.WhereIF(start.HasValue, u => u.InTime >= start);
if (input.InTimeRange.Count >1 && input.InTimeRange[1].HasValue)
{
- var end = input.InTimeRange[1].Value.AddDays(1);
- query = query.Where(u => u.InTime < end);
+ var end = input.InTimeRange[1].Value;
+ query = query.Where(u => u.InTime <= end);
}
}
if(input.OperTimeRange != null && input.OperTimeRange.Count >0)
@@ -190,13 +189,13 @@
return query;
}
- /// <summary>
- /// 閲嶅鎬ч獙璇�
- /// </summary>
- /// <param name="input">楠岃瘉瀵硅薄</param>
- /// <param name="isEdit">鏄惁鏄紪杈�</param>
- /// <returns></returns>
- private async Task CheckExist( WmsStockQuan input,bool isEdit=false)
+ /// <summary>
+ /// 閲嶅鎬ч獙璇�
+ /// </summary>
+ /// <param name="input">楠岃瘉瀵硅薄</param>
+ /// <param name="isEdit">鏄惁鏄紪杈�</param>
+ /// <returns></returns>
+ private async Task CheckExist( WmsStockQuan input,bool isEdit=false)
{
@@ -232,75 +231,7 @@
}
- #endregion
-
-
- /// <summary>
- /// 涓嶅垎椤垫煡璇㈤綈鍖呯鐞�
- /// </summary>
- /// <param name="input"></param>
- /// <returns></returns>
- [HttpGet]
- [ApiDescriptionSettings(Name = "packList")]
- [Description("WmsStockQuan/packList")]
- public async Task<List<WmsPackListOutput>> packList([FromQuery] PackListInput input)
- {
- // 鏌ヨ骞惰浆鎹负 WmsKittingListOutput 瀵硅薄鐨勫垪琛�
- var list = await _rep.AsQueryable()
- .WhereIF(!string.IsNullOrWhiteSpace(input.DetailName), u => u.PlaceCode.Contains(input.DetailName.Trim()))
- .Select(x => new WmsPackListOutput
- {
- PackageCode = x.PackageCode,
- // 鏄犲皠鍏朵粬瀛楁
- })
- .ToListAsync(); // 纭繚鑾峰彇缁撴灉涓� List
- // 鍒嗙粍骞惰繑鍥炲垎缁勪俊鎭�
- var groupedResult = list
- .GroupBy(x => x.PackageCode) // 鎸� PackageCode 鍒嗙粍
- .Select(g => new WmsPackListOutput
- {
- PackageCode = g.Key, // 鑾峰彇鍒嗙粍鐨勯敭
- Count = g.Count(), // 缁熻姣忕粍鐨勬暟閲�
- IsPack = g.Count() == 5 ? true : false // 濡傛灉 Count 涓� 5 鍒� IsKitting 涓� 1锛屽惁鍒欎负 0
- })
- .WhereIF(input.IsPack.HasValue, u => u.IsPack == input.IsPack)
- .OrderBy(g => g.PackageCode) // 鏍规嵁 PackageCode 鎺掑簭
- .ToList(); // 杞崲涓� List
- return groupedResult; // 杩斿洖鍒嗙粍缁撴灉
- }
-
-
- /// <summary>
- /// 涓嶅垎椤垫煡璇㈤綈濂楃鐞�
- /// </summary>
- /// <param name="input"></param>
- /// <returns></returns>
- [HttpGet]
- [ApiDescriptionSettings(Name = "KittingList")]
- [Description("WmsStockQuan/KittingList")]
- public async Task<List<WmsKittingListOutput>> KittingList([FromQuery] KittingListInput input)
- {
- var list = await _rep.AsQueryable()
- .WhereIF(!string.IsNullOrWhiteSpace(input.DetailName), u => u.PlaceCode.Contains(input.DetailName.Trim()))
- .Select(x => new WmsKittingListOutput
- {
- OrderId = x.OrderId
- })
- .ToListAsync(); // 纭繚鑾峰彇缁撴灉涓� List
- // 鍒嗙粍骞惰繑鍥炲垎缁勪俊鎭�
- var groupedResult = list
- .GroupBy(x => x.OrderId) // 鎸� PackageCode 鍒嗙粍
- .Select(g => new WmsKittingListOutput
- {
- OrderId = g.Key, // 鑾峰彇鍒嗙粍鐨勯敭
- Count = g.Count(), // 缁熻姣忕粍鐨勬暟閲�
- IsKitting = g.Count() == 5 ? true : false // 濡傛灉 Count 涓� 5 鍒� IsKitting 涓� 1锛屽惁鍒欎负 0
- })
- .WhereIF(input.IsKitting.HasValue, u => u.IsKitting == input.IsKitting)
- .OrderBy(g => g.OrderId) // 鏍规嵁 PackageCode 鎺掑簭
- .ToList(); // 杞崲涓� List
- return groupedResult; // 杩斿洖鍒嗙粍缁撴灉
- }
+ #endregion
}
--
Gitblit v1.9.3