From c1c1b1f95b0880cd58afadb98d6933287fe6311c Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周日, 15 12月 2024 16:41:37 +0800
Subject: [PATCH] 22
---
LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/WmsTask/WmsRbLineTask/WmsRbLineTaskService.cs | 287 ++++-----------------------------------------------------
1 files changed, 20 insertions(+), 267 deletions(-)
diff --git a/LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/WmsTask/WmsRbLineTask/WmsRbLineTaskService.cs b/LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/WmsTask/WmsRbLineTask/WmsRbLineTaskService.cs
index 59a9c05..e9266de 100644
--- a/LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/WmsTask/WmsRbLineTask/WmsRbLineTaskService.cs
+++ b/LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/WmsTask/WmsRbLineTask/WmsRbLineTaskService.cs
@@ -116,274 +116,7 @@
#region 瀵煎叆
- /// <summary>
- /// Excel妯℃澘瀵煎叆鏈哄櫒浜轰换鍔¤〃鍔熻兘
- /// </summary>
- /// <param name="file">Excel妯℃澘鏂囦欢</param>
- /// <returns>瀵煎叆鐨勮褰曟暟</returns>
- [HttpPost]
- [ApiDescriptionSettings(Name = "ImportExcel")]
- [Description("WmsRbLineTask/ImportExcel")]
- public async Task<int> ImportExcelAsync(IFormFile file)
- {
- int _HeadStartLine = 2;//绗�1琛屾槸璇存槑,绗�2琛屾槸鍒楀悕
- int _DataStartLine = 3;//绗�3琛屽紑濮嬫槸鏁版嵁
- DataTable importDataTable = ExcelUtil.ImportExcelToDataTable(file, _HeadStartLine, _DataStartLine);
- var addList =await CommonImport(importDataTable, _DataStartLine);
- await _rep.InsertRangeAsync(addList);
- return addList.Count;
- }
- /// <summary>
- /// DataTable杞崲瀹炰綋瀵硅薄鍒楄〃
- /// </summary>
- /// <param name="dataTable"></param>
- /// <param name="dataStartLine">妯＄増鍒楀悕寮�濮嬭</param>
- /// <returns></returns>
- private async Task<List<WmsRbLineTask>> CommonImport(DataTable dataTable, int dataStartLine)
- {
- var details = new List<WmsRbLineTask>();
- int index = dataStartLine;//妯＄増鍒楀悕寮�濮嬭
- foreach (System.Data.DataRow row in dataTable.Rows)
- {
- index++;
- //瀵煎叆妯＄増瀹氬埗鍖栦唬鐮侊紙鏇挎崲妯＄増浣跨敤锛�
-
- var addItem = new WmsRbLineTask();
- #region 瀹氫箟鍙橀噺
- var _TaskNo = "";//浠诲姟鍙�
- var _Upi = "";//閮ㄤ欢鏉＄爜
- var _Length = "";//闀�
- var _Width = "";//瀹�
- var _Thk = "";//鍘�
- var _PlanNo = "";//鎵规鍙�
- var _OrderId = "";//璁㈠崟鍙�
- var _PackageCode = "";//鍖呰鍙�
- var _PlaceCode = "";//搴撲綅缂栫爜
- var _RbTaskType = "";//浠诲姟绫诲瀷
- var _TaskStatus = "";//浠诲姟鐘舵��
- var _TaskDescribe = "";//浠诲姟鎻忚堪
- var _TaskMsg = "";//浠诲姟娑堟伅
- var _IssueTime = "";//涓嬪彂鏃堕棿
- var _FinishedTime = "";//浠诲姟瀹屾垚鏃堕棿
- var _IsFlagFinish = "";//鏄惁鏍囪寮哄埗瀹屾垚
- var _LastNum = "";//鏄惁鏈澘
- var _Info17 = "";//鏈烘鑷傛槸鍚︽棆杞�
- var _MachineXCenter = "";//鍖呰X鍧愭爣
- var _MachineYCenter = "";//鍖呰Y鍧愭爣
- var _MachineZCenter = "";//鍖呰Z鍧愭爣
- var _Sequence = "";//灞傛暟
- #endregion
-
-
- #region 鍙栧��
- _TaskNo = row["浠诲姟鍙�"]?.ToString() ;
- _Upi = row["閮ㄤ欢鏉＄爜"]?.ToString() ;
- _Length = row["闀�"]?.ToString() ;
- _Width = row["瀹�"]?.ToString() ;
- _Thk = row["鍘�"]?.ToString() ;
- _PlanNo = row["鎵规鍙�"]?.ToString() ;
- _OrderId = row["璁㈠崟鍙�"]?.ToString() ;
- _PackageCode = row["鍖呰鍙�"]?.ToString() ;
- _PlaceCode = row["搴撲綅缂栫爜"]?.ToString() ;
- _RbTaskType = row["浠诲姟绫诲瀷"]?.ToString() ;
- _TaskStatus = row["浠诲姟鐘舵��"]?.ToString() ;
- _TaskDescribe = row["浠诲姟鎻忚堪"]?.ToString() ;
- _TaskMsg = row["浠诲姟娑堟伅"]?.ToString() ;
- _IssueTime = row["涓嬪彂鏃堕棿"]?.ToString() ;
- _FinishedTime = row["浠诲姟瀹屾垚鏃堕棿"]?.ToString() ;
- _IsFlagFinish = row["鏄惁鏍囪寮哄埗瀹屾垚"]?.ToString() ;
- _LastNum = row["鏄惁鏈澘"]?.ToString() ;
- _Info17 = row["鏈烘鑷傛槸鍚︽棆杞�"]?.ToString() ;
- _MachineXCenter = row["鍖呰X鍧愭爣"]?.ToString() ;
- _MachineYCenter = row["鍖呰Y鍧愭爣"]?.ToString() ;
- _MachineZCenter = row["鍖呰Z鍧愭爣"]?.ToString() ;
- _Sequence = row["灞傛暟"]?.ToString() ;
- #endregion
-
-
- #region 楠岃瘉
-
- if (string.IsNullOrEmpty(_TaskNo))
- {
- throw Oops.Oh($"绗瑊index}琛孾浠诲姟鍙穄{_TaskNo}涓嶈兘涓虹┖锛�");
- }
-
- if(!string.IsNullOrEmpty(_TaskNo))
- {
- addItem.TaskNo = (string)(_TaskNo.Trim());
- }
-
- if (string.IsNullOrEmpty(_Upi))
- {
- throw Oops.Oh($"绗瑊index}琛孾閮ㄤ欢鏉＄爜]{_Upi}涓嶈兘涓虹┖锛�");
- }
-
- if(!string.IsNullOrEmpty(_Upi))
- {
- addItem.Upi = (string)(_Upi.Trim());
- }
-
- if (string.IsNullOrEmpty(_Length))
- {
- throw Oops.Oh($"绗瑊index}琛孾闀縘{_Length}涓嶈兘涓虹┖锛�");
- }
-
-
- if (string.IsNullOrEmpty(_PlanNo))
- {
- throw Oops.Oh($"绗瑊index}琛孾鎵规鍙穄{_PlanNo}涓嶈兘涓虹┖锛�");
- }
-
- if(!string.IsNullOrEmpty(_PlanNo))
- {
- addItem.PlanNo = (string)(_PlanNo.Trim());
- }
-
- if (string.IsNullOrEmpty(_OrderId))
- {
- throw Oops.Oh($"绗瑊index}琛孾璁㈠崟鍙穄{_OrderId}涓嶈兘涓虹┖锛�");
- }
-
- if(!string.IsNullOrEmpty(_OrderId))
- {
- addItem.OrderId = (string)(_OrderId.Trim());
- }
-
- if (string.IsNullOrEmpty(_PackageCode))
- {
- throw Oops.Oh($"绗瑊index}琛孾鍖呰鍙穄{_PackageCode}涓嶈兘涓虹┖锛�");
- }
-
- if(!string.IsNullOrEmpty(_PackageCode))
- {
- addItem.PackageCode = (string)(_PackageCode.Trim());
- }
-
- if (string.IsNullOrEmpty(_PlaceCode))
- {
- throw Oops.Oh($"绗瑊index}琛孾搴撲綅缂栫爜]{_PlaceCode}涓嶈兘涓虹┖锛�");
- }
-
- if(!string.IsNullOrEmpty(_PlaceCode))
- {
- addItem.PlaceCode = (string)(_PlaceCode.Trim());
- }
- if(!string.IsNullOrEmpty(_RbTaskType))
- {
- Admin.NET.Application.RbTaskTypeEnum enumRbTaskType = default(Admin.NET.Application.RbTaskTypeEnum);
-
- if(!Enum.TryParse<Admin.NET.Application.RbTaskTypeEnum>(_RbTaskType, out enumRbTaskType)&&!string.IsNullOrEmpty(_RbTaskType))
- {
- throw Oops.Oh($"绗瑊index}琛孾浠诲姟绫诲瀷]{_RbTaskType}鍊间笉姝ｇ‘锛�");
- }
- else
- {
- addItem.RbTaskType = enumRbTaskType;
- }
-
- }
-
- if (string.IsNullOrEmpty(_TaskStatus))
- {
- throw Oops.Oh($"绗瑊index}琛孾浠诲姟鐘舵�乚{_TaskStatus}涓嶈兘涓虹┖锛�");
- }
-
- if(!string.IsNullOrEmpty(_TaskStatus))
- {
- Admin.NET.Application.TaskStatusEnum enumTaskStatus = default(Admin.NET.Application.TaskStatusEnum);
-
- if(!Enum.TryParse<Admin.NET.Application.TaskStatusEnum>(_TaskStatus, out enumTaskStatus)&&!string.IsNullOrEmpty(_TaskStatus))
- {
- throw Oops.Oh($"绗瑊index}琛孾浠诲姟鐘舵�乚{_TaskStatus}鍊间笉姝ｇ‘锛�");
- }
- else
- {
- addItem.TaskStatus = enumTaskStatus;
- }
-
- }
- if(!string.IsNullOrEmpty(_TaskDescribe))
- {
- addItem.TaskDescribe = (string)(_TaskDescribe.Trim());
- }
- if(!string.IsNullOrEmpty(_TaskMsg))
- {
- addItem.TaskMsg = (string)(_TaskMsg.Trim());
- }
- if(!string.IsNullOrEmpty(_IssueTime))
- {
- addItem.IssueTime = Convert.ToDateTime(_IssueTime.Trim());
- }
- if(!string.IsNullOrEmpty(_FinishedTime))
- {
- addItem.FinishedTime = Convert.ToDateTime(_FinishedTime.Trim());
- }
-
- if (string.IsNullOrEmpty(_IsFlagFinish))
- {
- throw Oops.Oh($"绗瑊index}琛孾鏄惁鏍囪寮哄埗瀹屾垚]{_IsFlagFinish}涓嶈兘涓虹┖锛�");
- }
-
- if(!string.IsNullOrEmpty(_IsFlagFinish))
- {
- if(!_IsFlagFinish.Equals("鏄�") && !_IsFlagFinish.Equals("鍚�"))
- {
- throw Oops.Oh($"绗瑊index}琛孾鏄惁鏍囪寮哄埗瀹屾垚]{_IsFlagFinish}鍊间笉姝ｇ‘锛�");
- }
- else
- {
- bool outIsFlagFinish = _IsFlagFinish.Equals("鏄�") ? true : false;
- addItem.IsFlagFinish = outIsFlagFinish;
- }
- }
-
- if(!string.IsNullOrEmpty(_LastNum))
- {
- if (!int.TryParse(_LastNum, out int outLastNum)&&!string.IsNullOrEmpty(_LastNum))
- {
- throw Oops.Oh($"绗瑊index}琛孾鏄惁鏈澘]{_LastNum}鍊间笉姝ｇ‘锛�");
- }
- if (outLastNum <= 0&&!string.IsNullOrEmpty(_LastNum))
- {
- throw Oops.Oh($"绗瑊index}琛孾鏄惁鏈澘]{_LastNum}鍊间笉鑳藉皬浜庣瓑浜�0锛�");
- }
- else
- {
- addItem.LastNum = outLastNum;
- }
-
- }
- if(!string.IsNullOrEmpty(_Info17))
- {
- addItem.Info17 = (string)(_Info17.Trim());
- }
-
- if(!string.IsNullOrEmpty(_Sequence))
- {
- if (!int.TryParse(_Sequence, out int outSequence)&&!string.IsNullOrEmpty(_Sequence))
- {
- throw Oops.Oh($"绗瑊index}琛孾灞傛暟]{_Sequence}鍊间笉姝ｇ‘锛�");
- }
- if (outSequence <= 0&&!string.IsNullOrEmpty(_Sequence))
- {
- throw Oops.Oh($"绗瑊index}琛孾灞傛暟]{_Sequence}鍊间笉鑳藉皬浜庣瓑浜�0锛�");
- }
- else
- {
- addItem.Sequence = outSequence;
- }
-
- }
- #endregion
-
-
- details.Add(addItem);
- }
- //楠岄噸
- await CheckExisitForImport(details);
- return details;
- }
/// <summary>
/// 鏍规嵁鐗堟湰涓嬭浇鏈哄櫒浜轰换鍔¤〃鐨凟xcel瀵煎叆妯℃澘
@@ -459,6 +192,26 @@
query = query.Where(u => u.FinishedTime <= end);
}
}
+ if(input.CreateTimeRange != null && input.CreateTimeRange.Count >0)
+ {
+ DateTime? start= input.CreateTimeRange[0].Value;
+ query = query.WhereIF(start.HasValue, u => u.CreateTime >= start);
+ if (input.CreateTimeRange.Count >1 && input.CreateTimeRange[1].HasValue)
+ {
+ var end = input.CreateTimeRange[1].Value;
+ query = query.Where(u => u.CreateTime <= end);
+ }
+ }
+ if(input.UpdateTimeRange != null && input.UpdateTimeRange.Count >0)
+ {
+ DateTime? start= input.UpdateTimeRange[0].Value;
+ query = query.WhereIF(start.HasValue, u => u.UpdateTime >= start);
+ if (input.UpdateTimeRange.Count >1 && input.UpdateTimeRange[1].HasValue)
+ {
+ var end = input.UpdateTimeRange[1].Value;
+ query = query.Where(u => u.UpdateTime <= end);
+ }
+ }
return query;
}
--
Gitblit v1.9.3