| | |
| | | using Mapster; |
| | | using Masuit.Tools; |
| | | using NewLife.Caching; |
| | | using SqlSugar; |
| | | using System.Text.RegularExpressions; |
| | | using WIDESEA_Cache; |
| | |
| | | await DeleteTaskAsync(task.TaskId); |
| | | await AddTaskHtyAsync(taskHty); |
| | | }); |
| | | |
| | | _simpleCacheService.HashDel<DtStockInfo>(WIDESEA_Cache.CacheConst.Cache_DtStockInfo, new string[] { stock.PalletCode }); |
| | | |
| | | return content.OK("任务完成成功", task.Remark); |
| | | } |
| | |
| | | { |
| | | _locationStatusChangeRecordRepository.AddLocationStatusChangeRecord(locationInf, lastStatus, (int)StatusChangeTypeEnum.AutomaticStorage, task.TaskNum); |
| | | |
| | | stock.StockInfoDetails = new List<DtStockInfoDetail>() { { stock.StockInfoDetails[0] } }; |
| | | _simpleCacheService.HashAdd(WIDESEA_Cache.CacheConst.Cache_DtStockInfo, stock.PalletCode, stock); |
| | | |
| | | content.OK("入库任务完成成功"); |
| | |
| | | .OrderBy(x => x.OutboundTime) |
| | | .FirstOrDefault(); |
| | | |
| | | if (result != null) |
| | | { |
| | | stockInfoList = stockInfoList.Where(x => x != result).ToList(); |
| | | _simpleCacheService.HashDel<DtStockInfo>(WIDESEA_Cache.CacheConst.Cache_DtStockInfo, new string[] { result.PalletCode }); |
| | | } |
| | | |
| | | return result; |
| | | |
| | | if (stockInfoList.IsNullOrEmpty()) |
| | | { |
| | | stockInfoList = await _stockInfoRepository.Db.Queryable<DtStockInfo>().IncludesAllFirstLayer().ToListAsync(); |
| | | |
| | | result = stockInfoList.Where(x => x.AreaCode == areaCode && x.OutboundTime < DateTime.Now && x.IsFull == true) |
| | | .WhereIF(!productionLine.IsNullOrEmpty(), x => x.ProductionLine == productionLine) |
| | | .Where(x => x.LocationInfo.LocationStatus == (int)LocationEnum.InStock && x.LocationInfo.AreaId == area.AreaID && x.LocationInfo.EnalbeStatus == (int)EnableEnum.Enable) // 过滤条件 |
| | | .WhereIF(!devices.IsNullOrEmpty(), x => devices.Contains(x.LocationInfo.RoadwayNo)) |
| | | .WhereIF(!materielCodes.IsNullOrEmpty(), x => x.StockInfoDetails.Any(y => materielCodes.Contains(y.MaterielCode))) |
| | | .OrderBy(x => x.OutboundTime) // 排序 |
| | | .FirstOrDefault(); // 获取第一个元素 |
| | | |
| | | if (result != null) |
| | | { |
| | | // 排除 result 中的元素 |
| | | stockInfoList = stockInfoList.Where(x => x != result).ToList(); |
| | | } |
| | | foreach (var item in stockInfoList) |
| | | { |
| | | _simpleCacheService.HashAdd(WIDESEA_Cache.CacheConst.Cache_DtStockInfo, item.PalletCode, item); |
| | | } |
| | | } |
| | | else |
| | | { |
| | | result = stockInfoList.Where(x => x.AreaCode == areaCode && x.OutboundTime < DateTime.Now && x.IsFull == true) |
| | | .WhereIF(!productionLine.IsNullOrEmpty(), x => x.ProductionLine == productionLine) |
| | | .Where(x => x.LocationInfo.LocationStatus == (int)LocationEnum.InStock && x.LocationInfo.AreaId == area.AreaID && x.LocationInfo.EnalbeStatus == (int)EnableEnum.Enable) // 过滤条件 |
| | | .WhereIF(!devices.IsNullOrEmpty(), x => devices.Contains(x.LocationInfo.RoadwayNo)) |
| | | .WhereIF(!materielCodes.IsNullOrEmpty(), x => x.StockInfoDetails.Any(y => materielCodes.Contains(y.MaterielCode))) |
| | | .OrderBy(x => x.OutboundTime) // 排序 |
| | | .FirstOrDefault(); // 获取第一个元素 |
| | | if (result != null) |
| | | { |
| | | // 排除 result 中的元素 |
| | | stockInfoList = stockInfoList.Where(x => x != result).ToList(); |
| | | } |
| | | string[] xfasd = new string[] { result.PalletCode }; |
| | | _simpleCacheService.HashDel<DtStockInfo>(WIDESEA_Cache.CacheConst.Cache_DtStockInfo, new string[] { result.PalletCode }); |
| | | } |
| | | |
| | | #region |
| | | //var result = await _stockInfoRepository.Db.Queryable<DtStockInfo>() |
| | | // .Includes(x => x.LocationInfo) // 预加载LocationInfo |
| | | // .Includes(x => x.StockInfoDetails) // 预加载StockInfoDetails |
| | | // .Where(x => x.AreaCode == areaCode && x.OutboundTime < DateTime.Now && x.IsFull == true) // 过滤条件 |
| | | // .WhereIF(!productionLine.IsNullOrEmpty(), x => x.ProductionLine == productionLine) |
| | | // .Where(x => x.LocationInfo.LocationStatus == (int)LocationEnum.InStock && x.LocationInfo.AreaId == area.AreaID && x.LocationInfo.EnalbeStatus == (int)EnableEnum.Enable) // 过滤条件 |
| | | // .WhereIF(!devices.IsNullOrEmpty(), x => devices.Contains(x.LocationInfo.RoadwayNo)) |
| | | // .WhereIF(!materielCodes.IsNullOrEmpty(), x => x.StockInfoDetails.Any(y => materielCodes.Contains(y.MaterielCode))) |
| | | // .OrderBy(x => x.OutboundTime) // 排序 |
| | | // .FirstAsync(); // 获取第一个元素 |
| | | #endregion 请求出库(实盘&空盘) |
| | | |
| | | return result; |
| | | } |
| | | |
| | |
| | | .OrderBy(x => x.OutboundTime) // 排序 |
| | | .FirstOrDefault(); // 获取第一个元素 |
| | | |
| | | if (result != null) |
| | | { |
| | | stockInfoList = stockInfoList.Where(x => x != result).ToList(); |
| | | _simpleCacheService.HashDel<DtStockInfo>(WIDESEA_Cache.CacheConst.Cache_DtStockInfo, new string[] { result.PalletCode }); |
| | | } |
| | | |
| | | return result; |
| | | } |
| | | |
| | |
| | | .OrderBy(x => x.CreateDate) // 排序 |
| | | .FirstOrDefault(); // 转换为列表 |
| | | |
| | | if (result != null) |
| | | { |
| | | stockInfoList = stockInfoList.Where(x => x != result).ToList(); |
| | | _simpleCacheService.HashDel<DtStockInfo>(WIDESEA_Cache.CacheConst.Cache_DtStockInfo, new string[] { result.PalletCode }); |
| | | } |
| | | //if (result != null) |
| | | //{ |
| | | // stockInfoList = stockInfoList.Where(x => x != result).ToList(); |
| | | // _simpleCacheService.HashDel<DtStockInfo>(WIDESEA_Cache.CacheConst.Cache_DtStockInfo, new string[] { result.PalletCode }); |
| | | //} |
| | | |
| | | return result; |
| | | } |