| | |
| | | Dt_LocationInfo? locationInfo = null; |
| | | string CarChargingStation = AppSettings.Configuration[nameof(CarChargingStation)];//è·åç©¿æ¢è½¦å
çµä½ç½® |
| | | var ChargingStations = CarChargingStation.Split(","); |
| | | locationInfo = BaseDal.QueryFirst(x => !ChargingStations.Contains(x.LocationCode) && x.LocationStatus == LocationStatusEnum.Free.ObjToInt() && (x.EnableStatus == EnableStatusEnum.OnlyIn.ObjToInt() || x.EnableStatus == EnableStatusEnum.Normal.ObjToInt()) && x.Row == 3, _emptyAssignOrderBy); |
| | | locationInfo = BaseDal.QueryFirst(x => !ChargingStations.Contains(x.LocationCode) && x.LocationStatus == LocationStatusEnum.Free.ObjToInt() && (x.EnableStatus == EnableStatusEnum.OnlyIn.ObjToInt() || x.EnableStatus == EnableStatusEnum.Normal.ObjToInt()) && x.Row == 2, _emptyAssignOrderBy); |
| | | |
| | | if (locationInfo == null) |
| | | locationInfo = BaseDal.QueryFirst(x => !ChargingStations.Contains(x.LocationCode) && x.LocationStatus == LocationStatusEnum.Free.ObjToInt() && (x.EnableStatus == EnableStatusEnum.OnlyIn.ObjToInt() || x.EnableStatus == EnableStatusEnum.Normal.ObjToInt() && x.Row == 1), _emptyAssignOrderBy); |
| | | if (locationInfo == null) |
| | | locationInfo = BaseDal.QueryFirst(x => !ChargingStations.Contains(x.LocationCode) && x.LocationStatus == LocationStatusEnum.Free.ObjToInt() && (x.EnableStatus == EnableStatusEnum.OnlyIn.ObjToInt() || x.EnableStatus == EnableStatusEnum.Normal.ObjToInt() && x.Row == 2), _emptyAssignOrderBy); |
| | | //if (locationInfo == null) |
| | | // locationInfo = BaseDal.QueryFirst(x => !ChargingStations.Contains(x.LocationCode) && x.LocationStatus == LocationStatusEnum.Free.ObjToInt() && (x.EnableStatus == EnableStatusEnum.OnlyIn.ObjToInt() || x.EnableStatus == EnableStatusEnum.Normal.ObjToInt() && x.Row == 2), _emptyAssignOrderBy); |
| | | return locationInfo; |
| | | } |
| | | |
| | |
| | | /// è·å空æè´§ä½ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | public Dt_LocationInfo GetLocationPallet() |
| | | public List<Dt_LocationInfo> GetLocationPallet() |
| | | { |
| | | string CarChargingStation = AppSettings.Configuration[nameof(CarChargingStation)];//è·åç©¿æ¢è½¦å
çµä½ç½® |
| | | var ChargingStations = CarChargingStation.Split(","); |
| | | Dt_LocationInfo? locationInfo = null; |
| | | var locationInfos = BaseDal.QueryData(x => !ChargingStations.Contains(x.LocationCode) && x.LocationStatus == LocationStatusEnum.Pallet.ObjToInt() && x.CurrentQty < x.MaxQty, _emptyAssignOrderBy); |
| | | if (locationInfos.Count > 1 && locationInfos != null) locationInfo = locationInfos[0]; |
| | | return locationInfo; |
| | | return BaseDal.QueryData(x => !ChargingStations.Contains(x.LocationCode) && x.LocationStatus == LocationStatusEnum.Pallet.ObjToInt() && x.CurrentQty < x.MaxQty, _emptyAssignOrderBy); |
| | | //if (locationInfos.Count > 1 && locationInfos != null) locationInfo = locationInfos[0]; |
| | | //return locationInfo; |
| | | } |
| | | /// <summary> |
| | | /// åé
è´§ä½ |
| | |
| | | string CarChargingStation = AppSettings.Configuration[nameof(CarChargingStation)];//è·åç©¿æ¢è½¦å
çµä½ç½® |
| | | var ChargingStations = CarChargingStation.Split(","); |
| | | Dt_LocationInfo? locationInfo = null; |
| | | var locationInfos = BaseDal.QueryData(x => !ChargingStations.Contains(x.LocationCode) && x.LocationStatus == LocationStatusEnum.Free.ObjToInt() && (x.EnableStatus == EnableStatusEnum.OnlyIn.ObjToInt() || x.EnableStatus == EnableStatusEnum.Normal.ObjToInt()) && x.CurrentQty < 1 && x.Row == (inboundOrderCount > 1 ? 1 : 3), _emptyAssignOrderBy); |
| | | var locationInfos = BaseDal.QueryData(x => !ChargingStations.Contains(x.LocationCode) && x.LocationStatus == LocationStatusEnum.Free.ObjToInt() && (x.EnableStatus == EnableStatusEnum.OnlyIn.ObjToInt() || x.EnableStatus == EnableStatusEnum.Normal.ObjToInt()) && x.CurrentQty < 1 && x.Row == (inboundOrderCount > 1 ? 1 : 2), _emptyAssignOrderBy); |
| | | if (locationInfos.Count > 1 && locationInfos != null) locationInfo = locationInfos[0]; |
| | | |
| | | if (locationInfo == null) |
| | |
| | | Dt_LocationInfo? locationInfo = null; |
| | | //Dt_LocationInfo locationInfo = BaseDal.QueryFirst(x => x.LocationStatus == LocationStatusEnum.Free.ObjToInt() && (x.EnableStatus == EnableStatusEnum.OnlyIn.ObjToInt() || x.EnableStatus == EnableStatusEnum.Normal.ObjToInt()) && (x.Row == 1 || x.Row == 3), _emptyAssignOrderBy); |
| | | string position2 = string.Empty; |
| | | string[] Codes = position1.Split("-"); |
| | | var row = Convert.ToInt16(Codes[0]); |
| | | if (row < 3) |
| | | { |
| | | position2 = row == 1 ? "002" + "-" + Codes[1] + "-" + Codes[2] : "001" + "-" + Codes[1] + "-" + Codes[2]; |
| | | } |
| | | //string[] Codes = position1.Split("-"); |
| | | //var row = Convert.ToInt16(Codes[0]); |
| | | //if (row < 3) |
| | | //{ |
| | | // position2 = row == 1 ? "002" + "-" + Codes[1] + "-" + Codes[2] : "001" + "-" + Codes[1] + "-" + Codes[2]; |
| | | //} |
| | | if (string.IsNullOrEmpty(position2)) |
| | | { |
| | | locationInfo = BaseDal.QueryFirst(x => x.CurrentQty < x.MaxQty && x.LocationCode != position && x.LocationCode != position1, _emptyAssignOrderBy); |