using SqlSugar;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using WIDESEA_Common.LocationEnum;
|
using WIDESEA_Core.BaseRepository;
|
using WIDESEA_Core.Enums;
|
using WIDESEA_Core.Helper;
|
using WIDESEA_DTO.Basic;
|
using WIDESEA_IBasicRepository;
|
using WIDESEA_Model.Models;
|
|
namespace WIDESEA_BasicRepository
|
{
|
/// <summary>
|
/// 货位仓储实现层
|
/// </summary>
|
public class LocationInfoRepository : RepositoryBase<Dt_LocationInfo>, ILocationInfoRepository
|
{
|
public LocationInfoRepository(IUnitOfWorkManage unitOfWorkManage) : base(unitOfWorkManage)
|
{
|
|
}
|
|
/// <summary>
|
/// 获取分组所有货位
|
/// </summary>
|
/// <param name="roadway"></param>
|
/// <returns></returns>
|
public List<LocationGroupDTO> GetAllLocationGroups(string roadway)
|
{
|
return QueryTabs<Dt_LocationInfo, Dt_LocationInfo, LocationGroupDTO>((a, b) => a.Column == b.Column && a.Layer == b.Layer && a.Row != b.Row && SqlFunc.Abs(a.Row - b.Row) == 1, (a, b) => new LocationGroupDTO { DepthA = a.Depth, DepthB = b.Depth, EnableStatusA = a.EnableStatus, EnableStatusB = b.EnableStatus, IdA = a.Id, IdB = b.Id, LocationCodeA = a.LocationCode, LocationCodeB = b.LocationCode, LocationStatusA = a.LocationStatus, LocationStatusB = b.LocationStatus, LocationTypeA = a.LocationType, LocationTypeB = b.LocationType }, a => a.Depth == 1 && a.RoadwayNo == roadway, b => b.Depth == 2 && b.RoadwayNo == roadway, x => true);
|
}
|
|
/// <summary>
|
/// 根据状态获取分组货位
|
/// </summary>
|
/// <param name="roadway"></param>
|
/// <param name="locationAStatus"></param>
|
/// <param name="locationBStatus"></param>
|
/// <returns></returns>
|
public List<LocationGroupDTO> GetLocationGroups(string roadway, LocationStatusEnum locationAStatus, LocationStatusEnum locationBStatus)
|
{
|
return QueryTabs<Dt_LocationInfo, Dt_LocationInfo, LocationGroupDTO>(
|
(a, b) => a.Column == b.Column && a.Layer == b.Layer && a.Row != b.Row && SqlFunc.Abs(a.Row - b.Row) == 1,
|
(a, b) => new LocationGroupDTO { DepthA = a.Depth, DepthB = b.Depth, EnableStatusA = a.EnableStatus, EnableStatusB = b.EnableStatus, IdA = a.Id, IdB = b.Id, LocationCodeA = a.LocationCode, LocationCodeB = b.LocationCode, LocationStatusA = a.LocationStatus, LocationStatusB = b.LocationStatus, LocationTypeA = a.LocationType, LocationTypeB = b.LocationType },
|
a => a.Depth == 1 && a.RoadwayNo == roadway && a.LocationStatus == locationAStatus.ObjToInt(),
|
b => b.Depth == 2 && b.RoadwayNo == roadway && b.LocationStatus == locationBStatus.ObjToInt(),
|
x => true);
|
}
|
|
/// <summary>
|
/// 根据货位编号集合获取货位信息
|
/// </summary>
|
/// <param name="locationCodes"></param>
|
/// <returns></returns>
|
public List<Dt_LocationInfo> GetLocationInfos(List<string> locationCodes)
|
{
|
return QueryData(x => locationCodes.Contains(x.LocationCode));
|
}
|
|
/// <summary>
|
/// 批量修改货位状态
|
/// </summary>
|
/// <param name="locationInfos"></param>
|
/// <param name="locationStatus"></param>
|
public void UpdateLocationStatus(List<Dt_LocationInfo> locationInfos, LocationStatusEnum locationStatus)
|
{
|
locationInfos.ForEach(x =>
|
{
|
x.LocationStatus = locationStatus.ObjToInt();
|
});
|
UpdateData(locationInfos);
|
}
|
|
/// <summary>
|
/// 获取可出库货位编号
|
/// </summary>
|
/// <param name="warehouseId"></param>
|
/// <returns></returns>
|
public List<string> GetCanOutLocationCodes(int warehouseId)
|
{
|
return QueryData(x => x.LocationCode, x => x.WarehouseId == warehouseId && x.LocationStatus == LocationStatusEnum.InStock.ObjToInt() && (x.EnableStatus == EnableStatusEnum.OnlyOut.ObjToInt() || x.EnableStatus == EnableStatusEnum.Normal.ObjToInt())).Distinct().ToList();
|
}
|
}
|
}
|
