| | |
| | | /// </summary> |
| | | /// <param name="AreaCode"></param> |
| | | /// <returns></returns> |
| | | public Dt_RGVLocationInfo GetInFreeLocationInfo(string AreaCode) |
| | | public Dt_RGVLocationInfo? GetInFreeLocationInfo(string AreaCode) |
| | | { |
| | | Dt_RGVLocationInfo? rGVLocationInfo = BaseDal.QueryFirst(x => x.WarehouseId.ToString() == AreaCode && x.EnableStatus == EnableStatusEnum.Normal.ObjToInt() && x.LocationStatus == LocationStatusEnum.Free.ObjToInt(), _emptyAssignOrderBy); |
| | | Dt_RGVLocationInfo? rGVLocationInfo = null; |
| | | List<Dt_RGVLocationInfo> rGVLocationInfos = BaseDal.QueryData(x => x.WarehouseId.ToString() == AreaCode && x.EnableStatus == EnableStatusEnum.Normal.ObjToInt() && x.LocationStatus == LocationStatusEnum.Free.ObjToInt(), _emptyAssignOrderBy); |
| | | if (rGVLocationInfos == null || rGVLocationInfos.Count < 1) return rGVLocationInfo; |
| | | #region 鍒ゆ柇宸烽亾鏄惁鏈夎揣 |
| | | List<string> LocationCodes = new List<string>(); |
| | | foreach (var item in rGVLocationInfos) |
| | | { |
| | | Dt_RGVLocationInfo dt_RGVLocationInfo = BaseDal.QueryFirst(x => x.RoadwayNo == item.RoadwayNo && x.EnableStatus == EnableStatusEnum.Normal.ObjToInt() && x.Depth < item.Depth && x.LocationStatus == LocationStatusEnum.InStock.ObjToInt(), _emptyAssignOrderBy); |
| | | if (dt_RGVLocationInfo == null) return dt_RGVLocationInfo; |
| | | dt_RGVLocationInfo = BaseDal.QueryFirst(x => x.RoadwayNo == item.RoadwayNo && x.EnableStatus == EnableStatusEnum.Normal.ObjToInt() && x.Depth > item.Depth && x.LocationStatus == LocationStatusEnum.InStock.ObjToInt(), _DepthAscOrderBy); |
| | | } |
| | | if (rGVLocationInfo != null) |
| | | { |
| | | List<string> NoRoadwayNos = new List<string>(); |