using SqlSugar;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Reflection.Metadata;
|
using System.Text;
|
using System.Threading.Tasks;
|
using WIDESEA_Common;
|
using WIDESEA_Core;
|
using WIDESEA_Core.BaseRepository;
|
using WIDESEA_Core.BaseServices;
|
using WIDESEA_Core.Enums;
|
using WIDESEA_Core.Helper;
|
using WIDESEA_Core.Utilities;
|
using WIDESEA_DTO.Basic;
|
using WIDESEA_IBasicRepository;
|
using WIDESEA_IBasicService;
|
using WIDESEA_Model.Models;
|
|
namespace WIDESEA_BasicService
|
{
|
public partial class LocationInfoService : ServiceBase<Dt_LocationInfo, ILocationInfoRepository>, ILocationInfoService
|
{
|
private readonly IBasicRepository _basicRepository;
|
public ILocationInfoRepository Repository => BaseDal;
|
|
public LocationInfoService(ILocationInfoRepository BaseDal, IBasicRepository basicRepository) : base(BaseDal)
|
{
|
_basicRepository = basicRepository;
|
}
|
|
public override WebResponseContent AddData(SaveModel saveModel)
|
{
|
Dt_LocationInfo locationInfo = saveModel.MainData.DicToModel<Dt_LocationInfo>();
|
return base.AddData(locationInfo);
|
}
|
|
public override WebResponseContent UpdateData(SaveModel saveModel)
|
{
|
return base.UpdateData(saveModel);
|
}
|
|
public override WebResponseContent DeleteData(object[] keys)
|
{
|
return base.DeleteData(keys);
|
}
|
public override PageGridData<Dt_LocationInfo> GetPageData(PageDataOptions options)
|
{
|
return base.GetPageData(options);
|
}
|
/// <summary>
|
/// 修改货位的禁用状态
|
/// </summary>
|
/// <param name="saveModel"></param>
|
/// <returns></returns>
|
public WebResponseContent UpdateEnableStatus(SaveModel saveModel)
|
{
|
WebResponseContent content = new WebResponseContent();
|
try
|
{
|
List<Dt_LocationInfo> locationInfos = Repository.QueryData(x => saveModel.DelKeys.Contains(x.Id));
|
var values = Enum.GetValues(typeof(EnableStatusEnum));
|
var Index = saveModel.Extra.ObjToInt();
|
var EnableStatus = (EnableStatusEnum)values.GetValue(Index);
|
locationInfos.ForEach(x =>
|
{
|
x.EnableStatus = EnableStatus.ObjToInt();
|
});
|
Repository.UpdateData(locationInfos);
|
content.OK();
|
}
|
catch (Exception ex)
|
{
|
content.Error(ex.Message);
|
}
|
|
return content;
|
}
|
public WebResponseContent LocationEnableStatus(int[] keys)
|
{
|
List<Dt_LocationInfo> locationInfos = Repository.QueryData(x => keys.Contains(x.Id));
|
locationInfos.ForEach(x =>
|
{
|
x.EnableStatus = EnableEnum.Enable.ObjToInt();
|
});
|
Repository.UpdateData(locationInfos);
|
|
return WebResponseContent.Instance.OK();
|
}
|
|
public WebResponseContent LocationDisableStatus(int[] keys)
|
{
|
List<Dt_LocationInfo> locationInfos = Repository.QueryData(x => keys.Contains(x.Id));
|
locationInfos.ForEach(x =>
|
{
|
x.EnableStatus = EnableEnum.Disable.ObjToInt();
|
});
|
Repository.UpdateData(locationInfos);
|
|
return WebResponseContent.Instance.OK();
|
}
|
|
public WebResponseContent LocationEnableStatus(int key)
|
{
|
return LocationEnableStatus(new int[] { key });
|
}
|
|
public WebResponseContent LocationDisableStatus(int key)
|
{
|
return LocationDisableStatus(new int[] { key });
|
}
|
|
public WebResponseContent GetLocationCodes()
|
{
|
WebResponseContent content = new WebResponseContent();
|
try
|
{
|
//content.OK(_basicRepository.MaterielInfoRepository.Getmaterianame(saveModel).Message, Repository.QueryData(x => x.EnableStatus == EnableStatusEnum.Normal.ObjToInt()).Select(x => x.LocationCode).ToList());
|
content.OK(data: Repository.QueryData(x => x.EnableStatus == EnableStatusEnum.Normal.ObjToInt()).Select(x => x.LocationCode).ToList());
|
}
|
catch (Exception ex)
|
{
|
content.Error(ex.Message);
|
}
|
return content;
|
}
|
public object GetLocationLayer()
|
{
|
List<object> list = new List<object>();
|
var data = Db.Ado.SqlQuery<LocationArea>(@"SELECT areaName,areaCode,roadwayNo,layer from Dt_AreaInfo as t1
|
INNER JOIN
|
(
|
select DISTINCT AreaId,RoadwayNo,Layer from Dt_LocationInfo
|
) as t2
|
on t1.Id=t2.AreaId");
|
foreach (var item in data.GroupBy(t => t.areaName))
|
{
|
var obj = new
|
{
|
areaName = item.Key,
|
areaCode = item.Max(x => x.areaCode),
|
tunnel = item.Select(t => t.roadwayNo).OrderBy(t => t).Distinct().ToList(),
|
Layers = item.Select(t => t.layer).OrderBy(t => t).ToList(),
|
};
|
list.Add(obj);
|
}
|
return list;
|
}
|
public WebResponseContent InitializationLocation(InitializationLocationDTO initializationLocationDTO)
|
{
|
try
|
{
|
(bool, string, object?) result = ModelValidate.ValidateModelData(initializationLocationDTO);
|
if (!result.Item1) return WebResponseContent.Instance.Error(result.Item2);
|
|
int side = 1;
|
List<Dt_LocationInfo> locationInfos = new List<Dt_LocationInfo>();
|
for (int i = 0; i < initializationLocationDTO.MaxRow; i++)
|
{
|
for (int j = 0; j < initializationLocationDTO.MaxColumn; j++)
|
{
|
for (int k = 0; k < initializationLocationDTO.MaxLayer; k++)
|
{
|
Dt_LocationInfo locationInfo = new Dt_LocationInfo()
|
{
|
AreaId = 0,
|
Column = j + 1,
|
EnableStatus = EnableStatusEnum.Normal.ObjToInt(),
|
Layer = k + 1,
|
LocationStatus = LocationStatusEnum.Free.ObjToInt(),
|
LocationType = LocationTypeEnum.Cube.ObjToInt(),
|
RoadwayNo = initializationLocationDTO.Roadway,
|
Row = i + 1,
|
MaxQty = 12,
|
CurrentQty = 0,
|
};
|
|
if (initializationLocationDTO.IsSingleDepth)
|
{
|
locationInfo.Depth = 1;
|
locationInfo.LocationCode = $"{locationInfo.Row.ToString().PadLeft(3, '0')}-{locationInfo.Column.ToString().PadLeft(3, '0')}-{locationInfo.Layer.ToString().PadLeft(3, '0')}";
|
locationInfo.LocationName = $"{locationInfo.Row.ToString().PadLeft(3, '0')}行{locationInfo.Column.ToString().PadLeft(3, '0')}列{locationInfo.Layer.ToString().PadLeft(3, '0')}层";
|
}
|
else
|
{
|
if (initializationLocationDTO.FirstDepthRows.Contains(i + 1))
|
{
|
locationInfo.Depth = 1;
|
}
|
else
|
{
|
locationInfo.Depth = 2;
|
}
|
locationInfo.LocationCode = $"R{initializationLocationDTO.Roadway.ToString().PadLeft(2, '0')}-{locationInfo.Row.ToString().PadLeft(3, '0')}-{locationInfo.Column.ToString().PadLeft(3, '0')}-{locationInfo.Layer.ToString().PadLeft(3, '0')}-{locationInfo.Depth.ToString().PadLeft(2, '0')}";
|
locationInfo.LocationName = $"R{initializationLocationDTO.Roadway.ToString().PadLeft(2, '0')}巷道{locationInfo.Row.ToString().PadLeft(3, '0')}行{locationInfo.Column.ToString().PadLeft(3, '0')}列{locationInfo.Layer.ToString().PadLeft(3, '0')}层{locationInfo.Depth.ToString().PadLeft(2, '0')}深";
|
}
|
locationInfo.Creater = "System";
|
locationInfo.CreateDate = DateTime.Now;
|
locationInfos.Add(locationInfo);
|
}
|
}
|
}
|
|
BaseDal.AddData(locationInfos);
|
return WebResponseContent.Instance.OK();
|
}
|
catch (Exception ex)
|
{
|
return WebResponseContent.Instance.Error(ex.Message);
|
}
|
}
|
}
|
}
|
