| | |
| | | using OfficeOpenXml.FormulaParsing.Excel.Functions.Text; |
| | | using SqlSugar; |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Linq; |
| | |
| | | public KLSLocationInfoService(IRepository<Dt_KLSLocationInfo> BaseDal) : base(BaseDal) |
| | | { |
| | | } |
| | | |
| | | private Dictionary<string, OrderByType> _emptyAssignOrderBy = new Dictionary<string, OrderByType>() |
| | | { |
| | | { nameof(Dt_KLSLocationInfo.Depth), OrderByType.Desc }, |
| | | { nameof(Dt_KLSLocationInfo.Layer), OrderByType.Asc }, |
| | | { nameof(Dt_KLSLocationInfo.Column), OrderByType.Asc }, |
| | | { nameof(Dt_KLSLocationInfo.Row), OrderByType.Asc }, |
| | | }; |
| | | public IRepository<Dt_KLSLocationInfo> Repository => BaseDal; |
| | | /// <summary> |
| | | /// è·åå¯ç¨ç©ºè´§ä½ |
| | |
| | | /// <returns></returns> |
| | | public Dt_KLSLocationInfo GetFreeLocationInfo(string AreaCode, int containerType) |
| | | { |
| | | Dt_KLSLocationInfo? kLSLocationInfo = BaseDal.QueryFirst(x => x.WarehouseId.ToString() == AreaCode && x.EnableStatus == EnableStatusEnum.Normal.ObjToInt() && x.LocationStatus == LocationStatusEnum.Free.ObjToInt() && x.LocationType == containerType); |
| | | Dt_KLSLocationInfo? kLSLocationInfo = BaseDal.QueryFirst(x => x.WarehouseId.ToString() == AreaCode && x.EnableStatus == EnableStatusEnum.Normal.ObjToInt() && x.LocationStatus == LocationStatusEnum.Free.ObjToInt() && x.LocationType == containerType,_emptyAssignOrderBy); |
| | | return kLSLocationInfo; |
| | | } |
| | | |