using System;
|
using Microsoft.AspNetCore.Http;
|
using Microsoft.AspNetCore.Mvc;
|
using Model.ModelDto.DataDto;
|
using System.Collections.Generic;
|
using WMS.Entity.DataEntity;
|
using WMS.IBLL.IDataServer;
|
using System.Security.Claims;
|
using System.Threading.Tasks;
|
using Model.ModelDto.SysDto;
|
using WMS.BLL.LogServer;
|
using Model.ModelVm.BllTaskVm;
|
using Model.ModelVm;
|
|
namespace Wms.Controllers
|
{
|
[Route("api/[controller]/[action]")]
|
[ApiController]
|
public class StatisticalController : ControllerBase
|
{
|
/// <summary>
|
/// 依赖注入
|
/// </summary>
|
private readonly IStockServer _stock; //统计报表
|
private readonly IStockDetailServer _stockDetail; //统计报表
|
private readonly IDataBoxInfoServer _dataBoxInfo; //导出
|
private readonly IStockInfoServer _stockInfo; //库存信息
|
|
|
/// <summary>
|
/// 构造函数
|
/// </summary>
|
/// <param name="stock">统计报表</param>
|
/// <param name="stockDetail">库存箱码明细</param>
|
/// <param name="dataBoxInfo">导出</param>
|
/// <param name="stockInfo">库存信息</param>
|
public StatisticalController(IStockServer stock, IStockDetailServer stockDetail, IDataBoxInfoServer dataBoxInfo, IStockInfoServer stockInfo)
|
{
|
_stock = stock; //统计报表
|
_stockDetail = stockDetail;
|
_dataBoxInfo = dataBoxInfo;
|
_stockInfo = stockInfo; //库存信息
|
}
|
|
|
/// <summary>
|
/// 获取库存物料类型分布
|
/// </summary>
|
/// <returns></returns>
|
[HttpGet]
|
public IActionResult GetGoodsTypeFb()
|
{
|
IEnumerable<IdNameNumRateDto> dtoIE = _stock.GetGoodsTypeFb();
|
return Ok(new
|
{
|
data = dtoIE,
|
code = 0,
|
msg = "获取仓库详情成功"
|
});
|
}
|
|
|
/// <summary>
|
/// 获取库存质量状态分布
|
/// </summary>
|
/// <returns></returns>
|
[HttpGet]
|
public IActionResult GetQualityStatusFb()
|
{
|
IEnumerable<IdNameNumRateDto> dtoIE = _stock.GetQualityStatusFb();
|
return Ok(new
|
{
|
data = dtoIE,
|
code = 0,
|
msg = "获取仓库详情成功"
|
});
|
}
|
|
|
/// <summary>
|
/// 获取仓库状况总
|
/// </summary>
|
/// <returns></returns>
|
[HttpGet]
|
public IActionResult GetWareHouseState()
|
{
|
WarehouseStateDto dto = _stock.GetWareHouseState();
|
return Ok(new
|
{
|
data = dto,
|
code = 0,
|
msg = "获取仓库概况成功"
|
});
|
}
|
|
|
/// <summary>
|
/// 获取仓库状况详情
|
/// </summary>
|
/// <returns></returns>
|
[HttpGet]
|
public IActionResult GetWareHouseStateInfo()
|
{
|
IEnumerable<WarehouseUseDto> dtoIE = _stock.GetWareHouseStateInfo();
|
return Ok(new
|
{
|
data = dtoIE,
|
code = 0,
|
msg = "获取仓库详情成功"
|
});
|
}
|
|
|
|
#region 库存明细
|
|
/// <summary>
|
/// 获取库存总量
|
/// </summary>
|
/// <param name="selectType">查询类型</param>
|
/// <param name="skuNo">物料编码</param>
|
/// <param name="skuName">物料名称</param>
|
/// <param name="ownerNo">货主编码</param>
|
/// <param name="ownerName">货主名称</param>
|
/// <param name="lotNo">批次</param>
|
/// <param name="status">库存状态</param>
|
/// <param name="inspectStatus">质检状态</param>
|
/// <returns></returns>
|
[HttpGet]
|
public async Task<IActionResult> GetInventoryList(string selectType, string skuNo, string skuName, string ownerNo, string ownerName, string lotNo, string status, string inspectStatus, string wareHouseNo, string areaNo)
|
{
|
List<MateDataStockDto> StockList = await _stock.GetDataStockList(selectType, skuNo, skuName, ownerNo, ownerName, lotNo, status, inspectStatus, wareHouseNo, areaNo);
|
return Ok(new
|
{
|
data = StockList,
|
code = 0,
|
msg = "获取库存总量成功"
|
});
|
}
|
|
|
/// <summary>
|
/// 获取库存明细
|
/// </summary>
|
/// <param name="skuNo">物料编码</param>
|
/// <param name="skuName">物料名称</param>
|
/// <param name="lotNo">批次</param>
|
/// <param name="locatNo">储位地址</param>
|
/// <param name="palletNo">托盘条码</param>
|
/// <param name="status">库存状态</param>
|
/// <param name="inspectStatus">质检状态</param>
|
/// <returns></returns>
|
[HttpGet]
|
public IActionResult GetInventoryList1(string skuNo, string skuName, string lotNo, string locatNo, string palletNo, string status, string inspectStatus, string ownerNo, string ownerName, string startTime, string endTime)
|
{
|
List<StockDetailDto> stockDetailsList = _stock.GetInventoryList1(skuNo, skuName, lotNo, locatNo, palletNo, status, inspectStatus, ownerNo, ownerName, startTime, endTime);
|
return Ok(new
|
{
|
data = stockDetailsList,
|
code = 0,
|
msg = "获取库存明细成功"
|
});
|
}
|
|
#endregion
|
|
#region 托盘明细
|
|
/// <summary>
|
/// 获取托盘明细
|
/// </summary>
|
/// <param name="skuNo">物料号</param>
|
/// <param name="skuName">物料名称</param>
|
/// <param name="palletNo">托盘号</param>
|
/// <param name="lotNo">批次号</param>
|
/// <param name="boxNo">箱码</param>
|
/// <param name="status">箱支状态</param>
|
/// <param name="inspectMark">检验标记</param>
|
/// <param name="bitPalletMark">零托标记</param>
|
/// <param name="bitBoxMark">零箱标记</param>
|
/// <param name="inspectStatus">质量状态</param>
|
/// <returns></returns>
|
[HttpGet]
|
public IActionResult GetBindList(string skuNo, string skuName, string palletNo, string lotNo, string boxNo, string status, string inspectMark, string bitPalletMark, string bitBoxMark, string inspectStatus, string ownerNo, string ownerName, string startTime, string endTIme, string WareHouseNo, string AreaNo)
|
{
|
try
|
{
|
List<StockDetailDto> boxInfoList = _stockDetail.GetBindList(skuNo, skuName, palletNo, lotNo, boxNo, status, inspectMark, bitPalletMark, bitBoxMark, inspectStatus, ownerNo, ownerName, startTime, endTIme, WareHouseNo, AreaNo);
|
return Ok(new { data = boxInfoList, code = 0, msg = "获取托盘明细成功" });
|
}
|
catch (Exception e)
|
{
|
return Ok(new { data = "", code = 0, msg = e.Message });
|
}
|
|
}
|
/// <summary>
|
/// 托盘明细备注
|
/// </summary>
|
/// <param name="id"></param>
|
/// <param name="demo"></param>
|
/// <param name="userId"></param>
|
/// <exception cref="Exception"></exception>
|
[HttpGet]
|
public IActionResult EditStockDetailDemo(int id, string demo)
|
{
|
try
|
{
|
var claimsIdentity = this.User.Identity as ClaimsIdentity;
|
if (claimsIdentity == null)
|
{
|
throw new Exception("未获取到用户信息");
|
}
|
string userId = claimsIdentity.FindFirst(ClaimTypes.Name)?.Value;
|
if (string.IsNullOrWhiteSpace(userId))
|
{
|
throw new Exception("未获取到用户信息");
|
}
|
|
_stockDetail.EditStockDetailDemo(id, demo, int.Parse(userId));
|
|
|
return Ok(new { code = 0, msg = "编辑备注成功" });
|
|
}
|
catch (Exception e)
|
{
|
return Ok(new { code = 1, msg = e.Message });
|
}
|
}
|
|
/// <summary>
|
/// 获取箱码明细
|
/// </summary>
|
/// <param name="id">id</param>
|
/// <param name="skuNo">物料号</param>
|
/// <param name="skuName">物料名称</param>
|
/// <param name="palletNo">托盘号</param>
|
/// <param name="lotNo">批次号</param>
|
/// <param name="boxNo">箱码</param>
|
/// <param name="status">箱支状态</param>
|
/// <param name="inspectMark">检验标记</param>
|
/// <param name="bitBoxMark">零箱标记</param>
|
/// <param name="inspectStatus">质量状态</param>
|
/// <returns></returns>
|
[HttpGet]
|
public IActionResult GetBoxInfo(string id, string skuNo, string skuName, string palletNo, string lotNo,
|
string boxNo, string status, string inspectMark, string bitBoxMark, string inspectStatus, string WareHouseNo, string AreaNo)
|
{
|
try
|
{
|
List<DataBoxInfo> boxInfo = _dataBoxInfo.GetDataBoxInfo(id, skuNo, skuName, palletNo,
|
lotNo, boxNo, status, inspectMark, bitBoxMark, inspectStatus, WareHouseNo, AreaNo);
|
return Ok(new { data = boxInfo, code = 0, msg = "获取箱码明细成功" });
|
}
|
catch (Exception e)
|
{
|
return Ok(new { data = "", code = 0, msg = e.Message });
|
}
|
|
}
|
|
/// <summary>
|
/// 根据箱码获取箱支信息
|
/// </summary>
|
/// <param name="boxNo">箱码</param>
|
/// <param name="boxNo3">支码</param>
|
/// <returns></returns>
|
[HttpGet]
|
public IActionResult GetBoxInfoByBoxNo(string boxNo, string boxNo3)
|
{
|
try
|
{
|
List<DataBoxInfo> boxInfo = _dataBoxInfo.GetBoxInfoByBoxNo(boxNo, boxNo3);
|
return Ok(new { data = boxInfo, code = 0, msg = "根据箱码获取箱支信息成功" });
|
}
|
catch (Exception e)
|
{
|
return Ok(new { data = "", code = 0, msg = e.Message });
|
}
|
}
|
|
#endregion
|
|
#region 低库存预警
|
|
/// <summary>
|
/// 低库存预警
|
/// </summary>
|
/// <param name="skuNo">物料号</param>
|
/// <param name="skuName">物料名称</param>
|
/// <param name="lotNo">批次</param>
|
/// <param name="type">物料类型</param>
|
/// <returns></returns>
|
[HttpGet]
|
public IActionResult GetInventoryWarning(string skuNo, string skuName, string lotNo, string type)
|
{
|
List<MateDataStockDto> stockList = _stock.GetInventoryWarning(skuNo, skuName, lotNo, type);
|
return Ok(new
|
{
|
data = stockList,
|
code = 0,
|
msg = "获取低库存预警成功"
|
});
|
}
|
|
#endregion
|
|
#region 临期预警
|
|
/// <summary>
|
/// 获取临期预警信息
|
/// </summary>
|
/// <param name="skuNo">物料号</param>
|
/// <param name="skuName">物料名称</param>
|
/// <param name="lotNo">批次</param>
|
/// <param name="palletNo">托盘号</param>
|
/// <param name="status">状态</param>
|
/// <param name="inspectMark">检验标记</param>
|
/// <param name="inspectStatus">质量状态</param>
|
/// <returns></returns>
|
[HttpGet]
|
public IActionResult GetEmergencyWarning(string skuNo, string skuName, string lotNo, string palletNo, string status, string inspectMark, string inspectStatus)
|
{
|
try
|
{
|
List<AdventBoxInfoDto> stockList = _dataBoxInfo.GetEmergencyWarning(skuNo, skuName, lotNo, palletNo, status, inspectMark, inspectStatus);
|
return Ok(new { data = stockList, code = 0, msg = "获取临期预警成功" });
|
}
|
catch (Exception e)
|
{
|
return Ok(new { data = "", code = 0, msg = e.Message });
|
}
|
|
}
|
|
#endregion
|
|
#region 出入库报表
|
|
/// <summary>
|
/// 获取出入库总量
|
/// </summary>
|
/// <param name="skuNo">物料号</param>
|
/// <param name="skuName">物料名称</param>
|
/// <param name="lotNo">批次</param>
|
/// <param name="startTime">开始时间</param>
|
/// <param name="endTime">结束时间</param>
|
/// <returns></returns>
|
[HttpGet]
|
public IActionResult GetTotalRecord(string skuNo, string skuName, string lotNo, string startTime, string endTime)
|
{
|
List<TotalRecordDto> totalsList = _stock.GetTotalRecord(skuNo, skuName, lotNo, startTime, endTime);
|
return Ok(new
|
{
|
data = totalsList,
|
code = 0,
|
msg = "获取出入库总量成功"
|
});
|
}
|
|
/// <summary>
|
/// 获取出入库记录
|
/// </summary>
|
/// <param name="skuNo">物料号</param>
|
/// <param name="skuName">物料名称</param>
|
/// <param name="lotNo">批次</param>
|
/// <param name="palletNo">托盘</param>
|
/// <param name="startTime">开始时间</param>
|
/// <param name="endTime">结束时间</param>
|
/// <returns></returns>
|
[HttpGet]
|
public IActionResult GetDetailedRecord(string skuNo, string skuName, string lotNo, string palletNo, string startTime, string endTime)
|
{
|
List<TotalRecordDto> totalsList = _stock.GetDetailedRecord(skuNo, skuName, lotNo, palletNo, startTime, endTime);
|
return Ok(new
|
{
|
data = totalsList,
|
code = 0,
|
msg = "获取出入库记录成功"
|
});
|
}
|
|
|
#endregion
|
|
#region 年度报表
|
|
/// <summary>
|
/// 获取年报表
|
/// </summary>
|
/// <param name="StartTime"></param>
|
/// <param name="EndTime"></param>
|
/// <returns></returns>
|
[HttpGet]
|
public IActionResult GetAssSoInfo(string StartTime, string EndTime)
|
{
|
try
|
{
|
var skulist = _stock.GetAssSoInfo(StartTime, EndTime);
|
return Ok(new { code = 0, count = 0, data = skulist, msg = "获取总量成功" });
|
}
|
catch (Exception ex)
|
{
|
|
return Ok(new { code = 1, count = 0, msg = ex.Message });
|
}
|
}
|
|
/// <summary>
|
/// 获取年报表明细
|
/// </summary>
|
/// <param name="skuNo"></param>
|
/// <param name="StartTime"></param>
|
/// <param name="EndTime"></param>
|
/// <returns></returns>
|
[HttpGet]
|
public IActionResult GetAssSoInfoDetail(string skuNo, string StartTime, string EndTime)
|
{
|
try
|
{
|
var infolist = _stock.GetAssSoInfoDetail(skuNo, StartTime, EndTime);
|
return Ok(new { code = 0, count = 0, data = infolist, msg = "获取明细成功" });
|
}
|
catch (Exception ex)
|
{
|
return Ok(new { code = 1, count = 0, msg = ex.Message });
|
}
|
}
|
|
#endregion
|
|
#region 导出
|
/// <summary>
|
/// 导出库存总量
|
/// </summary>
|
/// <param name="skuNo"></param>
|
/// <param name="skuName"></param>
|
/// <param name="InspectStatus">质检状态</param>
|
/// <returns></returns>
|
[HttpGet]
|
public IActionResult GetInventoryListDaoChu(string skuNo, string skuName, string InspectStatus)
|
{
|
List<MateDataStockDto> StockList = _stock.GetDataStockListDaoChu(skuNo, skuName, InspectStatus);
|
return Ok(new
|
{
|
data = StockList,
|
code = 0,
|
msg = "导出库存总量成功"
|
});
|
}
|
/// <summary>GetDataStockListDaoChu
|
/// 导出库存明细
|
/// </summary>
|
/// <param name="skuNo">物料编码</param>
|
/// <param name="skuName">物料名称</param>
|
/// <param name="lotNo">批次</param>
|
/// <param name="locatNo">储位地址</param>
|
/// <param name="palletNo">托盘条码</param>
|
/// <param name="status">库存状态</param>
|
/// <param name="inspectStatus">质检状态</param>
|
/// <returns></returns>
|
[HttpGet]
|
public IActionResult GetDataStockList1DaoChu(string skuNo, string skuName, string lotNo, string locatNo, string status, string inspectStatus, string ownerNo, string ownerName, string startTime, string endTime)
|
{
|
List<StockDetailDto> stockDetailsList = _stock.GetDataStockList1DaoChu(skuNo, skuName, lotNo, locatNo, status, inspectStatus, ownerNo, ownerName, startTime, endTime);
|
return Ok(new
|
{
|
data = stockDetailsList,
|
code = 0,
|
msg = "导出库存明细成功"
|
});
|
}
|
|
/// <summary>
|
/// 导出托盘明细
|
/// </summary>
|
/// <param name="skuNo">物料号</param>
|
/// <param name="skuName">物料名称</param>
|
/// <param name="palletNo">托盘号</param>
|
/// <param name="lotNo">批次号</param>
|
/// <param name="boxNo">箱码</param>
|
/// <param name="status">箱支状态</param>
|
/// <param name="inspectMark">检验标记</param>
|
/// <param name="bitPalletMark">零托标记</param>
|
/// <param name="bitBoxMark">零箱标记</param>
|
/// <param name="inspectStatus">质量状态</param>
|
/// <returns></returns>
|
[HttpGet]
|
public IActionResult GetBindListDaoChu(string skuNo, string skuName, string palletNo, string lotNo, string boxNo, string status, string inspectMark, string bitPalletMark, string bitBoxMark, string inspectStatus)
|
{
|
try
|
{
|
List<DataStockDetail> boxInfoList = _stockDetail.GetBindListDaoChu(skuNo, skuName, palletNo, lotNo, boxNo, status, inspectMark, bitPalletMark, bitBoxMark, inspectStatus);
|
return Ok(new { data = boxInfoList, code = 0, msg = "导出托盘明细成功" });
|
}
|
catch (Exception e)
|
{
|
return Ok(new { data = "", code = 0, msg = e.Message });
|
}
|
|
}
|
|
/// <summary>
|
/// 导出箱码明细
|
/// </summary>
|
/// <param name="id">id</param>
|
/// <param name="skuNo">物料号</param>
|
/// <param name="skuName">物料名称</param>
|
/// <param name="palletNo">托盘号</param>
|
/// <param name="lotNo">批次号</param>
|
/// <param name="boxNo">箱码</param>
|
/// <param name="status">箱支状态</param>
|
/// <param name="inspectMark">检验标记</param>
|
/// <param name="bitBoxMark">零箱标记</param>
|
/// <param name="inspectStatus">质量状态</param>
|
/// <returns></returns>
|
[HttpGet]
|
public IActionResult GetBoxInfoDaoChu(string id, string skuNo, string skuName, string palletNo, string lotNo, string boxNo, string status, string inspectMark, string bitBoxMark, string inspectStatus)
|
{
|
try
|
{
|
List<DataBoxInfo> boxInfo = _dataBoxInfo.GetDataBoxInfoDaoChu(id, skuNo, skuName, palletNo, lotNo, boxNo, status, inspectMark, bitBoxMark, inspectStatus);
|
return Ok(new { data = boxInfo, code = 0, msg = "导出箱码明细成功" });
|
}
|
catch (Exception e)
|
{
|
return Ok(new { data = "", code = 0, msg = e.Message });
|
}
|
|
}
|
#endregion
|
|
#region 库存信息
|
|
/// <summary>
|
/// 根据时间获取显示库存信息
|
/// </summary>
|
/// <param name="StartTime"></param>
|
/// <returns></returns>
|
[HttpGet]
|
public IActionResult GetDataStockInfo(string StartTime)
|
{
|
try
|
{
|
var list = _stockInfo.GetDataStockInfo(StartTime);
|
return Ok(new { code = 0, count = list.Count, data = list, msg = "获取库存信息成功" });
|
}
|
catch (Exception ex)
|
{
|
|
return Ok(new { code = 1, count = 0, msg = ex.Message });
|
}
|
}
|
|
#endregion
|
|
#region#补打标签
|
/// <summary>
|
/// 补打库存明细箱码
|
/// </summary>
|
/// <param name="model"></param>
|
/// <returns></returns>
|
[HttpPost]
|
public IActionResult GetBuDaLabelList(BuDaLabelBoxVm model)
|
{
|
try
|
{
|
var list = _dataBoxInfo.GetBuDaLabelList(model.BoxNo);
|
return Ok(new { code = 0, msg = "获取补打箱码标签信息", data = list });
|
}
|
catch (Exception e)
|
{
|
return Ok(new { code = 1, count = 0, msg = e.Message });
|
}
|
}
|
#endregion
|
}
|
}
|
