| | |
| | | .Where(!string.IsNullOrEmpty(input.PlaceAlias), u => u.PlaceAlias == input.PlaceAlias) |
| | | .Where(input.PlaceType != null, u => u.PlaceType == input.PlaceType) |
| | | .Where(!string.IsNullOrEmpty(input.PlaceTypeName), u => u.PlaceTypeName == input.PlaceTypeName) |
| | | .Where(!string.IsNullOrEmpty(input.StockUnit), u => u.StockUnit == input.StockUnit) |
| | | .Where(input.PlaceStatus != null, u => u.PlaceStatus == input.PlaceStatus) |
| | | .Where(input.IsSrmPlace != null, u => u.IsSrmPlace == input.IsSrmPlace) |
| | | .Where(!string.IsNullOrEmpty(input.SrmPlaceNo), u => u.SrmPlaceNo == input.SrmPlaceNo) |
| | |
| | | .Where(input.IsDisabled != null, u => u.IsDisabled == input.IsDisabled) |
| | | .Where(input.CreatedTime!=null, u => u.CreatedTime>= Convert.ToDateTime(input.CreatedTime[0]) && u.CreatedTime<= Convert.ToDateTime(input.CreatedTime[1])) |
| | | .Where(input.UpdatedTime!=null, u => u.UpdatedTime>= Convert.ToDateTime(input.UpdatedTime[0]) && u.UpdatedTime<= Convert.ToDateTime(input.UpdatedTime[1])) |
| | | .Where(!string.IsNullOrEmpty(input.CreatedUserName), u => u.CreatedUserName == input.CreatedUserName) |
| | | .Where(!string.IsNullOrEmpty(input.UpdatedUserName), u => u.UpdatedUserName == input.UpdatedUserName) |
| | | .OrderBy(PageInputOrder.OrderBuilder<WmsPlaceSearch>(input)) |
| | | .ProjectToType<WmsPlaceOutput>() |
| | | .ToADPagedListAsync(input.PageNo, input.PageSize); |
| | |
| | | var pPlaceAlias = input.PlaceAlias?.Trim() ?? ""; |
| | | var pPlaceType = input.PlaceType; |
| | | var pPlaceTypeName = input.PlaceTypeName?.Trim() ?? ""; |
| | | var pStockUnit = input.StockUnit?.Trim() ?? ""; |
| | | var pPlaceStatus = input.PlaceStatus; |
| | | var pIsSrmPlace = input.IsSrmPlace; |
| | | var pSrmPlaceNo = input.SrmPlaceNo?.Trim() ?? ""; |
| | |
| | | var pIsDisabled = input.IsDisabled; |
| | | var pCreatedTime = input.CreatedTime; |
| | | var pUpdatedTime = input.UpdatedTime; |
| | | var pCreatedUserName = input.CreatedUserName?.Trim() ?? ""; |
| | | var pUpdatedUserName = input.UpdatedUserName?.Trim() ?? ""; |
| | | var wmsPlaces = await _wmsPlaceRep.DetachedEntities |
| | | .Where(!string.IsNullOrEmpty(pPlaceCode), u => u.PlaceCode == pPlaceCode) |
| | | .Where(!string.IsNullOrEmpty(pPlaceName), u => u.PlaceName == pPlaceName) |
| | | .Where(!string.IsNullOrEmpty(pPlaceAlias), u => u.PlaceAlias == pPlaceAlias) |
| | | .Where(pPlaceType != null, u => u.PlaceType == pPlaceType) |
| | | .Where(!string.IsNullOrEmpty(pPlaceTypeName), u => u.PlaceTypeName == pPlaceTypeName) |
| | | .Where(!string.IsNullOrEmpty(pStockUnit), u => u.StockUnit == pStockUnit) |
| | | .Where(pPlaceStatus != null, u => u.PlaceStatus == pPlaceStatus) |
| | | .Where(pIsSrmPlace != null, u => u.IsSrmPlace == pIsSrmPlace) |
| | | .Where(!string.IsNullOrEmpty(pSrmPlaceNo), u => u.SrmPlaceNo == pSrmPlaceNo) |
| | |
| | | .Where(pIsDisabled != null, u => u.IsDisabled == pIsDisabled) |
| | | .Where(input.CreatedTime!=null, u => u.CreatedTime>= Convert.ToDateTime(input.CreatedTime[0]) && u.CreatedTime<= Convert.ToDateTime(input.CreatedTime[1])) |
| | | .Where(input.UpdatedTime!=null, u => u.UpdatedTime>= Convert.ToDateTime(input.UpdatedTime[0]) && u.UpdatedTime<= Convert.ToDateTime(input.UpdatedTime[1])) |
| | | .Where(!string.IsNullOrEmpty(pCreatedUserName), u => u.CreatedUserName == pCreatedUserName) |
| | | .Where(!string.IsNullOrEmpty(pUpdatedUserName), u => u.UpdatedUserName == pUpdatedUserName) |
| | | .OrderBy(PageInputOrder.OrderNonPageBuilder(input)) |
| | | .ProjectToType<WmsPlaceOutput>() |
| | | .ToListAsync(); |
| | |
| | | var _PlaceAlias = "";//库位别名 |
| | | var _PlaceType = "";//库位类型 |
| | | var _PlaceTypeName = "";//库位类型名称 |
| | | var _StockUnit = "";//存放单位 |
| | | var _PlaceStatus = "";//库位属性 |
| | | var _IsSrmPlace = "";//是否堆垛机库位 |
| | | var _SrmPlaceNo = "";//堆垛机库位号 |
| | |
| | | _PlaceAlias = row["库位别名"]?.ToString() ; |
| | | _PlaceType = row["库位类型"]?.ToString() ; |
| | | _PlaceTypeName = row["库位类型名称"]?.ToString() ; |
| | | _StockUnit = row["存放单位"]?.ToString() ; |
| | | _PlaceStatus = row["库位属性"]?.ToString() ; |
| | | _IsSrmPlace = row["是否堆垛机库位"]?.ToString() ; |
| | | _SrmPlaceNo = row["堆垛机库位号"]?.ToString() ; |
| | |
| | | |
| | | if(!string.IsNullOrEmpty(_PlaceType)) |
| | | { |
| | | if (!int.TryParse(_PlaceType, out int outPlaceType)&&!string.IsNullOrEmpty(_PlaceType)) |
| | | Admin.NET.Core.PlaceTypeEnum enumPlaceType = default(Admin.NET.Core.PlaceTypeEnum); |
| | | |
| | | if(!Enum.TryParse<Admin.NET.Core.PlaceTypeEnum>(_PlaceType, out enumPlaceType)&&!string.IsNullOrEmpty(_PlaceType)) |
| | | { |
| | | throw Oops.Oh($"第{index}行[库位类型]{_PlaceType}值不正确!"); |
| | | } |
| | | if (outPlaceType <= 0&&!string.IsNullOrEmpty(_PlaceType)) |
| | | { |
| | | throw Oops.Oh($"第{index}行[库位类型]{_PlaceType}值不能小于等于0!"); |
| | | throw Oops.Oh($"第{index}行[库位类型]{_PlaceType}值不正确!"); |
| | | } |
| | | else |
| | | { |
| | | addItem.PlaceType = outPlaceType; |
| | | addItem.PlaceType = enumPlaceType; |
| | | } |
| | | |
| | | } |
| | | } |
| | | if(!string.IsNullOrEmpty(_PlaceTypeName)) |
| | | { |
| | | addItem.PlaceTypeName = (string)_PlaceTypeName; |
| | | } |
| | | if(!string.IsNullOrEmpty(_StockUnit)) |
| | | |
| | | if (string.IsNullOrEmpty(_PlaceStatus)) |
| | | { |
| | | addItem.StockUnit = (string)_StockUnit; |
| | | } |
| | | throw Oops.Oh($"第{index}行[库位属性]{_PlaceStatus}不能为空!"); |
| | | } |
| | | |
| | | if(!string.IsNullOrEmpty(_PlaceStatus)) |
| | | { |
| | | if (!int.TryParse(_PlaceStatus, out int outPlaceStatus)&&!string.IsNullOrEmpty(_PlaceStatus)) |
| | | Admin.NET.Core.PlaceStatusEnum enumPlaceStatus = default(Admin.NET.Core.PlaceStatusEnum); |
| | | |
| | | if(!Enum.TryParse<Admin.NET.Core.PlaceStatusEnum>(_PlaceStatus, out enumPlaceStatus)&&!string.IsNullOrEmpty(_PlaceStatus)) |
| | | { |
| | | throw Oops.Oh($"第{index}行[库位属性]{_PlaceStatus}值不正确!"); |
| | | } |
| | | if (outPlaceStatus <= 0&&!string.IsNullOrEmpty(_PlaceStatus)) |
| | | { |
| | | throw Oops.Oh($"第{index}行[库位属性]{_PlaceStatus}值不能小于等于0!"); |
| | | throw Oops.Oh($"第{index}行[库位属性]{_PlaceStatus}值不正确!"); |
| | | } |
| | | else |
| | | { |
| | | addItem.PlaceStatus = outPlaceStatus; |
| | | addItem.PlaceStatus = enumPlaceStatus; |
| | | } |
| | | |
| | | } |
| | | } |
| | | if(!string.IsNullOrEmpty(_IsSrmPlace)) |
| | | { |
| | | if(!_IsSrmPlace.Equals("是") && !_IsSrmPlace.Equals("否")) |