using SqlSugar;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using WIDESEA_Core;
|
using WIDESEA_Core.BaseServices;
|
using WIDESEA_Core.Enums;
|
using WIDESEA_Core.Helper;
|
using WIDESEA_DTO.Basic;
|
using WIDESEA_IBasicRepository;
|
using WIDESEA_IBasicService;
|
using WIDESEA_Model.Models;
|
|
namespace WIDESEA_BasicService
|
{
|
public class CachePointService : ServiceBase<Dt_CachePoint, ICachePointRepository>, ICachePointService
|
{
|
public CachePointService(ICachePointRepository BaseDal) : base(BaseDal)
|
{
|
}
|
|
public ICachePointRepository Repository => BaseDal;
|
|
private readonly Dictionary<string, OrderByType> _emptyAssignOrderBy = new()
|
{
|
{ nameof(Dt_CachePoint.Depth), OrderByType.Desc },
|
{ nameof(Dt_CachePoint.Column), OrderByType.Asc },
|
{ nameof(Dt_CachePoint.Row), OrderByType.Asc },
|
};
|
|
public Dt_CachePoint? AssignCachePoint(int areaId)
|
{
|
List<CachePointGroupDTO> cachePointGroups = Repository.GetCachePointGroups(areaId, LocationStatusEnum.InStock, LocationStatusEnum.Free);
|
if (cachePointGroups != null && cachePointGroups.Count > 0)
|
{
|
CachePointGroupDTO? pointGroupDTO = cachePointGroups.FirstOrDefault(x => x.EnableStatusB == LocationEnalbeStatusEnum.OnlyIn.ObjToInt() || x.EnableStatusB == LocationEnalbeStatusEnum.Normal.ObjToInt());
|
int id = pointGroupDTO?.IdB ?? 0;
|
return BaseDal.QueryFirst(x => x.Id == id);
|
}
|
cachePointGroups = Repository.GetCachePointGroups(areaId, LocationStatusEnum.Free, LocationStatusEnum.Free);
|
if (cachePointGroups != null && cachePointGroups.Count > 0)
|
{
|
CachePointGroupDTO? pointGroupDTO = cachePointGroups.FirstOrDefault(x => x.EnableStatusA == LocationEnalbeStatusEnum.OnlyIn.ObjToInt() || x.EnableStatusA == LocationEnalbeStatusEnum.Normal.ObjToInt());
|
int id = pointGroupDTO?.IdA ?? 0;
|
return BaseDal.QueryFirst(x => x.Id == id);
|
}
|
|
return BaseDal.QueryFirst(x => x.PointStatus == LocationStatusEnum.Free.ObjToInt() && (x.EnableStatus == LocationEnalbeStatusEnum.OnlyIn.ObjToInt() || x.EnableStatus == LocationEnalbeStatusEnum.Normal.ObjToInt() && x.AreaId == areaId), _emptyAssignOrderBy);
|
}
|
|
public Dt_CachePoint? GetIbStockCachePoint(int areaId)
|
{
|
List<CachePointGroupDTO> cachePointGroups = Repository.GetCachePointGroups(areaId, LocationStatusEnum.InStock, LocationStatusEnum.Free);
|
if (cachePointGroups != null && cachePointGroups.Count > 0)
|
{
|
CachePointGroupDTO? pointGroupDTO = cachePointGroups.FirstOrDefault(x => x.EnableStatusA == LocationEnalbeStatusEnum.OnlyOut.ObjToInt() || x.EnableStatusA == LocationEnalbeStatusEnum.Normal.ObjToInt());
|
int id = pointGroupDTO?.IdA ?? 0;
|
return BaseDal.QueryFirst(x => x.Id == id);
|
}
|
cachePointGroups = Repository.GetCachePointGroups(areaId, LocationStatusEnum.InStock, LocationStatusEnum.InStock);
|
if (cachePointGroups != null && cachePointGroups.Count > 0)
|
{
|
CachePointGroupDTO? pointGroupDTO = cachePointGroups.FirstOrDefault(x => x.EnableStatusB == LocationEnalbeStatusEnum.OnlyOut.ObjToInt() || x.EnableStatusB == LocationEnalbeStatusEnum.Normal.ObjToInt());
|
int id = pointGroupDTO?.IdB ?? 0;
|
return BaseDal.QueryFirst(x => x.Id == id);
|
}
|
|
return BaseDal.QueryFirst(x => x.PointStatus == LocationStatusEnum.InStock.ObjToInt() && (x.EnableStatus == LocationEnalbeStatusEnum.OnlyOut.ObjToInt() || x.EnableStatus == LocationEnalbeStatusEnum.Normal.ObjToInt() && x.AreaId == areaId), _emptyAssignOrderBy);
|
}
|
}
|
}
|