//using Furion.DatabaseAccessor;
|
//using Furion.DependencyInjection;
|
//using Furion.DynamicApiController;
|
//using Mapster;
|
//using Microsoft.AspNetCore.Mvc;
|
//using Microsoft.EntityFrameworkCore;
|
//using Admin.NET.Core;
|
|
//namespace Admin.NET.Application
|
//{
|
// /// <summary>
|
// /// 库位试图服务
|
// /// </summary>
|
// [ApiDescriptionSettings("仓库作业", Name = "LocationView", Order = 104)]
|
// [Route("api/[Controller]")]
|
// public class LocationViewService : IDynamicApiController, ITransient
|
// {
|
// private readonly IRepository<WmsArea, MasterDbContextLocator> _wmsAreaRep;
|
// private readonly IRepository<WmsPlace, MasterDbContextLocator> _wmsPlaceRep;
|
// private readonly IRepository<WmsMaterialStock, MasterDbContextLocator> _wmsMaterialStockRep;
|
// private readonly IRepository<WmsContainerPlace, MasterDbContextLocator> _wmsContainerPlaceRep;
|
// private readonly IRepository<WmsContainer, MasterDbContextLocator> _wmsContainerRep;
|
// private readonly IRepository<WmsMaterialContainer, MasterDbContextLocator> _wmsMaterialContainerRep;
|
|
// /// <summary>
|
// /// 构造函数
|
// /// </summary>
|
// public LocationViewService(
|
// IRepository<WmsArea, MasterDbContextLocator> wmsAreaRep,
|
// IRepository<WmsPlace, MasterDbContextLocator> wmsPlaceRep,
|
// IRepository<WmsMaterialStock, MasterDbContextLocator> wmsMaterialStockRep,
|
// IRepository<WmsContainerPlace, MasterDbContextLocator> wmsContainerPlaceRe,
|
// IRepository<WmsContainer, MasterDbContextLocator> wmsContainerRep,
|
// IRepository<WmsMaterialContainer, MasterDbContextLocator> wmsMaterialContainer
|
// )
|
// {
|
// _wmsAreaRep = wmsAreaRep;
|
// _wmsPlaceRep = wmsPlaceRep;
|
// _wmsMaterialStockRep = wmsMaterialStockRep;
|
// _wmsContainerPlaceRep = wmsContainerPlaceRe;
|
// _wmsContainerRep = wmsContainerRep;
|
// _wmsMaterialContainerRep = wmsMaterialContainer;
|
// }
|
|
// /// <summary>
|
// /// 获取库区信息
|
// /// </summary>
|
// /// <returns></returns>
|
// [HttpGet("GetArea")]
|
// public async Task<List<WmsArea>> GetArea()
|
// {
|
// var areaList = await _wmsAreaRep.Where(n => n.AreaStatus == CommonStatus.ENABLE && n.WorkShopType == LesWorkShopType.FAPAOCHEJIAN).ToListAsync();
|
// return areaList;
|
// }
|
|
// /// <summary>
|
// /// 根据库区获取巷道
|
// /// </summary>
|
// /// <param name="input"></param>
|
// /// <returns></returns>
|
// [HttpGet("GetAisle")]
|
// public async Task<object> GetPalceAisle([FromQuery] GetPalceAisleInput input)
|
// {
|
|
// var objList=await _wmsPlaceRep.Where(n => n.AreaId == input.Areaid).OrderBy(n=>n.Aisle).Select(n => n.Aisle).Distinct().ToArrayAsync();
|
// for (int i = 0; i < objList.Length-1; i++)
|
// {
|
// for (int j = 0; j < objList.Length-1; j++)
|
// {
|
// int k = j + 1;
|
// if (objList[j] >objList[k])
|
// {
|
// var temp = objList[k];
|
// objList[k] = objList[j];
|
// objList[j] = temp;
|
// }
|
// }
|
// }
|
// return objList;
|
// }
|
|
// /// <summary>
|
// /// 根据库区和巷道获取排
|
// /// </summary>
|
// /// <param name="input"></param>
|
// /// <returns></returns>
|
// [HttpGet("GetPalceRowno")]
|
// public async Task<object> GetPalceRowno([FromQuery] GetPalceAisleRownoInput input)
|
// {
|
// var objList=await _wmsPlaceRep.Where(n => n.AreaId == input.Areaid && n.Aisle==input.Aisleid && n.WmsArea.WorkShopType == LesWorkShopType.FAPAOCHEJIAN).OrderBy(n => n.RowNo).Select(n => n.RowNo).Distinct().ToArrayAsync();
|
|
// for (int i = 0; i < objList.Length - 1; i++)
|
// {
|
// for (int j = 0; j < objList.Length - 1; j++)
|
// {
|
// int k = j + 1;
|
// if (objList[j] > objList[k])
|
// {
|
// var temp = objList[k];
|
// objList[k] = objList[j];
|
// objList[j] = temp;
|
// }
|
// }
|
// }
|
// return objList;
|
// }
|
|
// /// <summary>
|
// /// 根据库区 排获取库位信息
|
// /// </summary>
|
// /// <param name="input"></param>
|
// /// <returns></returns>
|
// [HttpGet("GetPalceList")]
|
// public async Task<PalceInfoOtput> GetPalceList([FromQuery] GetPalceListInput input)
|
// {
|
// var palceList = await _wmsPlaceRep.DetachedEntities
|
// .Where(p => p.AreaId == input.Areaid)
|
// .Where(input.Aisleid != 0, p => p.Aisle == input.Aisleid)
|
// .Where(input.Rowno != 0, p => p.RowNo == input.Rowno)
|
// .ToListAsync();
|
|
// //获取有多少巷,排,列,层
|
// var Aisles = palceList.OrderBy(n => n.Aisle).Select(n => n.Aisle).Distinct().ToList();
|
|
// var locationDataList = new List<WareLocationAisleData>();
|
// //巷道
|
// foreach (var aisle in Aisles)
|
// {
|
// var aisleData = new WareLocationAisleData();
|
// aisleData.Aisle = aisle;
|
// aisleData.wareLocationRownoData = new List<WareLocationRownoData>();
|
// //排
|
// var RowNos = palceList.Where(p=>p.Aisle==aisle).OrderBy(n => n.RowNo).Select(n => n.RowNo).Distinct().ToList();
|
// foreach (var row in RowNos)
|
// {
|
// var rownoData = new WareLocationRownoData();
|
// rownoData.Rowno = row;
|
// rownoData.wareLocationLayerData = new List<WareLocationLayerData>();
|
// //层
|
// var LayerNo = palceList.Where(p=>p.Aisle==aisle && p.RowNo==row).OrderByDescending(n => n.LayerNo).Select(n => n.LayerNo).Distinct();
|
// foreach (var lay in LayerNo)
|
// {
|
// var layerData = new WareLocationLayerData();
|
// layerData.Layer = lay;
|
// layerData.wareLocationColumnNoData = new List<PalceDetail>();
|
// //列
|
// var ColumnNos = palceList.Where(p=>p.Aisle==aisle && p.RowNo==row).OrderByDescending(n => n.ColumnNo).Select(n => n.ColumnNo).Distinct();
|
// foreach (var col in ColumnNos)
|
// {
|
// var wareLocationMdoel = palceList.Where(p =>p.Aisle==aisle && p.RowNo == row && p.LayerNo == lay && p.ColumnNo == col).FirstOrDefault();
|
// if (wareLocationMdoel != null)
|
// {
|
// var locationDetail = new PalceDetail()
|
// {
|
// Id = wareLocationMdoel.Id,
|
// RowNo = wareLocationMdoel.RowNo,
|
// ColumnNo = wareLocationMdoel.ColumnNo,
|
// LayerNo = wareLocationMdoel.LayerNo,
|
// PlaceCode = wareLocationMdoel.PlaceCode,
|
// Islock = wareLocationMdoel.Islock,
|
// EmptyContainer = wareLocationMdoel.EmptyContainer,
|
// PlaceStatus = wareLocationMdoel.PlaceStatus,
|
// };
|
// layerData.wareLocationColumnNoData.Add(locationDetail);
|
// }
|
// else
|
// {
|
// layerData.wareLocationColumnNoData.Add(null);
|
// }
|
// }
|
// rownoData.wareLocationLayerData.Add(layerData);
|
// }
|
// aisleData.wareLocationRownoData.Add(rownoData);
|
// }
|
// locationDataList.Add(aisleData);
|
// }
|
|
// return new PalceInfoOtput()
|
// {
|
// countNum = palceList.Count,
|
// cunhuoNum = palceList.Where(n => n.PlaceStatus == PlaceStatus.CUNHUO).Count(),
|
// emptyNum = palceList.Where(n => n.PlaceStatus == PlaceStatus.KONGXIAN).Count(),
|
// DaiRuNum = palceList.Where(n => n.PlaceStatus == PlaceStatus.DAIRU).Count(),
|
// DaichuNum = palceList.Where(n => n.PlaceStatus == PlaceStatus.DAICHU).Count(),
|
// emptyContainerNum = palceList.Where(p => p.EmptyContainer == YesOrNot.Y && p.PlaceStatus == PlaceStatus.CUNHUO).Count(),
|
// materialNum = palceList.Where(p => p.EmptyContainer == YesOrNot.N && p.PlaceStatus == PlaceStatus.CUNHUO).Count(),
|
// lockNum = palceList.Where(p => p.Islock == YesOrNot.Y).Count(),
|
// PalceDetails = locationDataList,
|
// };
|
// }
|
|
// /// <summary>
|
// /// 根据库位获取对应信息
|
// /// </summary>
|
// /// <param name="input"></param>
|
// /// <returns></returns>
|
// [HttpGet("GetMaterialDetail")]
|
// [UnifyResult(typeof(MaterialDetailsOutput))]
|
// public async Task<object> GetMaterialDetail([FromQuery] GetMaterialDetailInput input)
|
// {
|
// var palceModel = await _wmsPlaceRep.FirstOrDefaultAsync(p => p.Id == input.Id);
|
// if (palceModel == null) return XnRestfulResultProvider.RESTfulMesaage("库位信息不存在!");
|
// var MaterialStockList = await _wmsMaterialStockRep.Where(p => p.PlaceCode == palceModel.PlaceCode).ToListAsync();
|
// var model = new MaterialDetailsOutput()
|
// {
|
// PalceDetails = palceModel.Adapt<PalceDetail>()
|
// };
|
// if (MaterialStockList.Count > 0)
|
// {
|
// model.Containercode = MaterialStockList.FirstOrDefault().ContainerCode;
|
// model.WmsMaterialStocks = MaterialStockList;
|
// }
|
// return XnRestfulResultProvider.RESTfulResult(model);
|
// }
|
|
// /// <summary>
|
// /// 修改库位锁定信息
|
// /// </summary>
|
// /// <param name="input"></param>
|
// /// <returns></returns>
|
// [HttpGet("UpdatePalceIslock")]
|
// [UnifyResult(typeof(object))]
|
// public async Task<object> UpdatePalceIslock([FromQuery] GetMaterialDetailInput input)
|
// {
|
// var palceModel = await _wmsPlaceRep.FirstOrDefaultAsync(p => p.Id == input.Id);
|
// if (palceModel == null) return XnRestfulResultProvider.RESTfulMesaage("库位信息不存在!");
|
// if (palceModel.Islock == YesOrNot.Y)
|
// {
|
// palceModel.Islock = YesOrNot.N;
|
// }
|
// else
|
// {
|
// palceModel.Islock = YesOrNot.Y;
|
// }
|
// await _wmsPlaceRep.UpdateAsync(palceModel);
|
// return XnRestfulResultProvider.RESTfulResult();
|
// }
|
|
// /// <summary>
|
// /// 将库位置为空闲
|
// /// </summary>
|
// /// <param name="input"></param>
|
// /// <returns></returns>
|
// [HttpGet("UpdatePalceKongXian")]
|
// [UnifyResult(typeof(object))]
|
// [UnitOfWork]
|
// public async Task<object> UpdatePalceKongXian([FromQuery] GetMaterialDetailInput input)
|
// {
|
// var palceModel = await _wmsPlaceRep.FirstOrDefaultAsync(p => p.Id == input.Id);
|
// if (palceModel == null) return XnRestfulResultProvider.RESTfulMesaage("库位信息不存在!");
|
// palceModel.PlaceStatus = PlaceStatus.KONGXIAN;
|
// await _wmsPlaceRep.UpdateAsync(palceModel);
|
|
// var materialStockModel = await _wmsMaterialStockRep.Where(p => p.PlaceCode == palceModel.PlaceCode).FirstOrDefaultAsync();
|
// if (materialStockModel != null)
|
// {
|
// await _wmsMaterialStockRep.DeleteAsync(materialStockModel);
|
// }
|
// var containerPlaceModel = await _wmsContainerPlaceRep.Where(p => p.PlaceCode == palceModel.PlaceCode && p.ContainerPlaceStatus == CommonStatus.ENABLE).FirstOrDefaultAsync();
|
// if (containerPlaceModel != null)
|
// {
|
// containerPlaceModel.ContainerPlaceStatus = CommonStatus.DISABLE;
|
// await _wmsContainerPlaceRep.UpdateAsync(containerPlaceModel);
|
|
// var wmsMaterialContainerModal = await _wmsMaterialContainerRep.FirstOrDefaultAsync(p => p.ContainerCode == containerPlaceModel.ContainerCode && p.BindStatus == CommonStatus.ENABLE);
|
// if (containerPlaceModel != null) return XnRestfulResultProvider.RESTfulMesaage("物料托盘信息不存在!");
|
// containerPlaceModel.ContainerPlaceStatus = CommonStatus.DISABLE;
|
// await _wmsMaterialContainerRep.UpdateAsync(wmsMaterialContainerModal);
|
|
// var containerModel = await _wmsContainerRep.FirstOrDefaultAsync(p => p.ContainerCode == containerPlaceModel.ContainerCode);
|
// if (containerModel != null)
|
// {
|
// containerModel.ContainerStatus = ContainerStatus.KOUXIAN;
|
// await _wmsContainerRep.UpdateAsync(containerModel);
|
// }
|
// }
|
// return XnRestfulResultProvider.RESTfulResult();
|
// }
|
// }
|
//}
|
