using HH.WCS.Mobox3.HD.wms;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using HH.WCS.Mobox3.HD.util;
|
using System.Web.Http;
|
using SqlSugar;
|
using HH.WCS.Mobox3.HD.models;
|
using Newtonsoft.Json;
|
using static HH.WCS.Mobox3.HD.api.WmsController;
|
using static HH.WCS.Mobox3.HD.api.DigitHelper;
|
using System.Reflection;
|
|
namespace HH.WCS.Mobox3.HD.api
|
{
|
|
/// <summary>
|
/// 数字孪生调用接口
|
/// </summary>
|
[RoutePrefix("api")]
|
public class DigitController : System.Web.Http.ApiController
|
{
|
|
/// <summary>
|
/// 1.查询当前备货区所有成品信息
|
/// </summary>
|
/// <param name="model"></param>
|
/// <returns></returns>
|
[HttpPost]
|
public ResponseResult queryAllFinishProduct(AreaModel model)
|
{
|
/*LogHelper.Info("queryAllFinishProduct 入参:" + JsonConvert.SerializeObject(model), "数字孪生");*/
|
ResponseResult responseResult = new ResponseResult();
|
try
|
{
|
responseResult.result = DigitHelper.queryAllFinishProduct(model);
|
}
|
catch (Exception ex)
|
{
|
LogHelper.Error("1.查询当前备货区所有成品信息 错误,错误原因:" + ex.Message, ex, "数字孪生");
|
}
|
/*LogHelper.Info("queryAllFinishProduct 出参:" + JsonConvert.SerializeObject(responseResult), "数字孪生");*/
|
return responseResult;
|
}
|
|
/// <summary>
|
/// 2.查询三个立体库的汇总数据
|
/// </summary>
|
/// <returns></returns>
|
[HttpPost]
|
public ResponseResult queryLTKSummaryData()
|
{
|
/* LogHelper.Info("queryLTKSummaryData 入参:" , "数字孪生");*/
|
ResponseResult responseResult = new ResponseResult();
|
try
|
{
|
responseResult.result = DigitHelper.queryLTKSummaryData();
|
}
|
catch (Exception ex)
|
{
|
LogHelper.Error("2.查询三个立体库的汇总数据 错误,错误原因:" + ex.Message, ex, "数字孪生");
|
}
|
/* LogHelper.Info("queryLTKSummaryData 出参:" + JsonConvert.SerializeObject(responseResult), "数字孪生");*/
|
return responseResult;
|
}
|
|
/// <summary>
|
/// 3.按工作号汇总成品、半成品所占库位数量列表
|
/// </summary>
|
/// <returns></returns>
|
[HttpPost]
|
public ResponseResult queryLTKWorkNoSummaryData1(ItemTypeModel model)
|
{
|
/*LogHelper.Info("queryLTKDrawNoSummaryData 入参:" + JsonConvert.SerializeObject(model), "数字孪生");*/
|
ResponseResult responseResult = new ResponseResult();
|
try
|
{
|
responseResult.result = DigitHelper.queryLTKWorkNoSummaryData1(model);
|
}
|
catch (Exception ex)
|
{
|
LogHelper.Error("3.按工作号汇总成品、半成品所占库位数量列表 错误,错误原因:" + ex.Message, ex, "数字孪生");
|
}
|
/* LogHelper.Info("queryLTKDrawNoSummaryData 出参:" + JsonConvert.SerializeObject(responseResult), "数字孪生");*/
|
return responseResult;
|
}
|
|
/// <summary>
|
/// 4.按工作号汇总成品、半成品所占库位数量、占比
|
/// </summary>
|
/// <returns></returns>
|
[HttpPost]
|
public ResponseResult queryLTKWorkNoSummaryData()
|
{
|
/* LogHelper.Info("queryLTKWorkNoSummaryData 入参:" , "数字孪生");*/
|
ResponseResult responseResult = new ResponseResult();
|
try
|
{
|
responseResult.result = DigitHelper.queryLTKWorkNoSummaryData();
|
}
|
catch (Exception ex)
|
{
|
LogHelper.Error("4.按工作号汇总成品、半成品所占库位数量、占比 错误,错误原因:" + ex.Message, ex, "数字孪生");
|
}
|
/* LogHelper.Info("queryLTKWorkNoSummaryData 出参:" + JsonConvert.SerializeObject(responseResult), "数字孪生");*/
|
return responseResult;
|
}
|
|
/// <summary>
|
/// 4.1.按工作号、物料类型汇总物料所占库位数量、占比
|
/// </summary>
|
/// <returns></returns>
|
[HttpPost]
|
public ResponseResult queryWorkNoAndItemTypeLTKSummaryData(AreaModel model)
|
{
|
/* LogHelper.Info("queryWorkNoAndItemTypeLTKSummaryData 入参:", "数字孪生");*/
|
ResponseResult responseResult = new ResponseResult();
|
try
|
{
|
responseResult.result = DigitHelper.queryWorkNoAndItemTypeLTKSummaryData(model);
|
}
|
catch (Exception ex)
|
{
|
LogHelper.Error("4.1.按工作号、物料类型汇总物料所占库位数量、占比 错误,错误原因:" + ex.Message, ex, "数字孪生");
|
}
|
/*LogHelper.Info("queryWorkNoAndItemTypeLTKSummaryData 出参:" + JsonConvert.SerializeObject(responseResult), "数字孪生");*/
|
return responseResult;
|
}
|
|
/// <summary>
|
/// 5.根据在库时长汇总成品、半成品的所占库位数量
|
/// </summary>
|
/// <returns></returns>
|
[HttpPost]
|
public ResponseResult storageTimeSummary()
|
{
|
LogHelper.Info("storageTimeSummary 入参:" , "数字孪生");
|
ResponseResult responseResult = new ResponseResult();
|
try
|
{
|
responseResult.result = DigitHelper.storageTimeSummary();
|
}
|
catch (Exception ex)
|
{
|
LogHelper.Error("5.根据在库时长汇总成品、半成品的所占库位数量 错误,错误原因:" + ex.Message, ex, "数字孪生");
|
}
|
LogHelper.Info("storageTimeSummary 出参:" + JsonConvert.SerializeObject(responseResult), "数字孪生");
|
return responseResult;
|
}
|
|
/// <summary>
|
/// 6.按图号汇总三个立体库的出库(入库)数量和占比
|
/// </summary>
|
/// <returns></returns>
|
[HttpPost]
|
public ResponseResult outInStockDrawNoSummary(ActModel model)
|
{
|
/*LogHelper.Info("outInStockDrawNoSummary 入参:" + JsonConvert.SerializeObject(model), "数字孪生");*/
|
ResponseResult responseResult = new ResponseResult();
|
try
|
{
|
responseResult.result = DigitHelper.outInStockDrawNoSummary(model);
|
}
|
catch (Exception ex)
|
{
|
LogHelper.Error("6.按图号汇总三个立体库的出库(入库)数量和占比 错误,错误原因:" + ex.Message, ex, "数字孪生");
|
}
|
/*LogHelper.Info("outInStockDrawNoSummary 出参:" + JsonConvert.SerializeObject(responseResult), "数字孪生");*/
|
return responseResult;
|
}
|
|
/// <summary>
|
/// 7.查询今日出厂的成品信息
|
/// </summary>
|
/// <returns></returns>
|
[HttpPost]
|
public ResponseResult queryOutFactoryFinishProdList(DateModel model)
|
{
|
/*LogHelper.Info("queryOutFactoryFinishProdList 入参:" + JsonConvert.SerializeObject(model), "数字孪生");*/
|
ResponseResult responseResult = new ResponseResult();
|
try
|
{
|
responseResult.result = DigitHelper.queryOutFactoryFinishProdList(model);
|
}
|
catch (Exception ex)
|
{
|
LogHelper.Error("7.查询今日出厂的成品信息 错误,错误原因:" + ex.Message, ex, "数字孪生");
|
}
|
/*LogHelper.Info("queryOutFactoryFinishProdList 出参:" + JsonConvert.SerializeObject(responseResult), "数字孪生");*/
|
return responseResult;
|
}
|
|
/// <summary>
|
/// 8.查询当前立体库汇总数据
|
/// </summary>
|
/// <returns></returns>
|
[HttpPost]
|
public ResponseResult queryLTKAreaSummaryData(AreaModel model)
|
{
|
/*LogHelper.Info("queryLTKAreaSummaryData 入参:" + JsonConvert.SerializeObject(model), "数字孪生");*/
|
ResponseResult responseResult = new ResponseResult();
|
try
|
{
|
responseResult.result = DigitHelper.queryLTKAreaSummaryData(model);
|
}
|
catch (Exception ex)
|
{
|
LogHelper.Error("8.查询当前立体库汇总数据 错误,错误原因:" + ex.Message, ex, "数字孪生");
|
}
|
/*LogHelper.Info("queryLTKAreaSummaryData 出参:" + JsonConvert.SerializeObject(responseResult), "数字孪生");*/
|
return responseResult;
|
}
|
|
/// <summary>
|
/// 9.查询出入库信息汇总
|
/// </summary>
|
/// <returns></returns>
|
[HttpPost]
|
public ResponseResult outInStackSummary(OutInStockModel model)
|
{
|
/*LogHelper.Info("outInStackSummary 入参:" + JsonConvert.SerializeObject(model), "数字孪生");*/
|
ResponseResult responseResult = new ResponseResult();
|
try
|
{
|
responseResult.result = DigitHelper.outInStackSummary(model);
|
}
|
catch (Exception ex)
|
{
|
LogHelper.Error("9.查询出入库信息汇总 错误,错误原因:" + ex.Message, ex, "数字孪生");
|
}
|
/* LogHelper.Info("outInStackSummary 出参:" + JsonConvert.SerializeObject(responseResult), "数字孪生");*/
|
return responseResult;
|
}
|
|
/// <summary>
|
/// 10.查询当前执行中和待执行任务列表汇总
|
/// </summary>
|
/// <returns></returns>
|
[HttpPost]
|
public ResponseResult queryProceedTaskList(AreaModel model)
|
{
|
/*LogHelper.Info("queryProceedTaskList 入参:" + JsonConvert.SerializeObject(model), "数字孪生");*/
|
ResponseResult responseResult = new ResponseResult();
|
try
|
{
|
responseResult.result = DigitHelper.queryProceedTaskList(model);
|
}
|
catch (Exception ex)
|
{
|
LogHelper.Error("10.查询当前执行中和待执行任务列表汇总 错误,错误原因:" + ex.Message, ex, "数字孪生");
|
}
|
/*LogHelper.Info("queryProceedTaskList 出参:" + JsonConvert.SerializeObject(responseResult), "数字孪生");*/
|
return responseResult;
|
}
|
|
/// <summary>
|
/// 11.查询库位数据
|
/// </summary>
|
/// <returns></returns>
|
[HttpPost]
|
public ResponseResult queryAreaLocData(AreaModel model)
|
{
|
/* LogHelper.Info("queryAreaLocData 入参:" + JsonConvert.SerializeObject(model), "数字孪生");*/
|
ResponseResult responseResult = new ResponseResult();
|
|
try
|
{
|
responseResult.result = DigitHelper.queryAreaLocData(model);
|
}
|
catch (Exception ex)
|
{
|
LogHelper.Error("11.查询库位数据 错误,错误原因:" + ex.Message, ex, "数字孪生");
|
}
|
/*LogHelper.Info("queryAreaLocData 出参:" + JsonConvert.SerializeObject(responseResult), "数字孪生");*/
|
return responseResult;
|
}
|
|
/// <summary>
|
/// 12.统计各库区库位总数、使用数量和使用率
|
/// </summary>
|
/// <returns></returns>
|
[HttpPost]
|
public ResponseResult statisticsAllArea()
|
{
|
/* LogHelper.Info("statisticsAllArea 入参:", "数字孪生");*/
|
ResponseResult responseResult = new ResponseResult();
|
try
|
{
|
responseResult.result = DigitHelper.statisticsAllArea();
|
}
|
catch (Exception ex) {
|
LogHelper.Error("12.统计各库区库位总数、使用数量和使用率 错误,错误原因:"+ex.Message,ex ,"数字孪生");
|
}
|
/* LogHelper.Info("statisticsAllArea 出参:" + JsonConvert.SerializeObject(responseResult), "数字孪生");*/
|
return responseResult;
|
}
|
|
/// <summary>
|
/// 13.查询立体库库位数据
|
/// </summary>
|
/// <returns></returns>
|
[HttpPost]
|
public ResponseResult queryLTKLocData(LocModel model)
|
{
|
/*LogHelper.Info("queryLTKLocData 入参:" + JsonConvert.SerializeObject(model), "数字孪生");*/
|
ResponseResult responseResult = new ResponseResult();
|
|
try
|
{
|
responseResult.result = DigitHelper.queryLTKLocData(model);
|
}
|
catch (Exception ex)
|
{
|
LogHelper.Error("13.查询立体库库位数据 错误,错误原因:" + ex.Message, ex, "数字孪生");
|
}
|
/*LogHelper.Info("queryLTKLocData 出参:" + JsonConvert.SerializeObject(responseResult), "数字孪生");*/
|
return responseResult;
|
}
|
|
/// <summary>
|
/// 14.查询钢卷库库位数据
|
/// </summary>
|
/// <returns></returns>
|
[HttpPost]
|
public ResponseResult queryGJKLocData(LocModel model)
|
{
|
/*LogHelper.Info("queryGJKLocData 入参:" + JsonConvert.SerializeObject(model), "数字孪生");*/
|
ResponseResult responseResult = new ResponseResult();
|
try
|
{
|
responseResult.result = DigitHelper.queryGJKLocData(model);
|
}
|
catch (Exception ex)
|
{
|
LogHelper.Error("14.查询钢卷库库位数据 错误,错误原因:" + ex.Message, ex, "数字孪生");
|
}
|
/* LogHelper.Info("queryGJKLocData 出参:" + JsonConvert.SerializeObject(responseResult), "数字孪生");*/
|
return responseResult;
|
}
|
|
/// <summary>
|
/// 15.查询模具库库位数据
|
/// </summary>
|
/// <returns></returns>
|
[HttpPost]
|
public ResponseResult queryMJKLocData(LocModel model)
|
{
|
/*LogHelper.Info("queryMJKLocData 入参:" + JsonConvert.SerializeObject(model), "数字孪生");*/
|
ResponseResult responseResult = new ResponseResult();
|
try
|
{
|
responseResult.result = DigitHelper.queryMJKLocData(model);
|
}
|
catch (Exception ex)
|
{
|
LogHelper.Error("15.查询模具库库位数据 错误,错误原因:" + ex.Message, ex, "数字孪生");
|
}
|
/* LogHelper.Info("queryMJKLocData 出参:" + JsonConvert.SerializeObject(responseResult), "数字孪生");*/
|
return responseResult;
|
}
|
|
/// <summary>
|
/// 16.查询钢卷库区汇总数据
|
/// </summary>
|
/// <returns></returns>
|
[HttpPost]
|
public ResponseResult queryGJKAreaSummaryData(AreaListModel model)
|
{
|
/*LogHelper.Info("查询钢卷库区汇总数据-queryGJKAreaSummaryData 入参:", "数字孪生");*/
|
ResponseResult responseResult = new ResponseResult();
|
try
|
{
|
responseResult.result = DigitHelper.queryGJKAreaSummaryData(model);
|
}
|
catch (Exception ex)
|
{
|
LogHelper.Error("16.查询钢卷库区汇总数据 错误,错误原因:" + ex.Message, ex, "数字孪生");
|
}
|
/*LogHelper.Info("查询钢卷库区汇总数据-queryGJKAreaSummaryData 出参:" + JsonConvert.SerializeObject(responseResult), "数字孪生");*/
|
return responseResult;
|
}
|
|
/// <summary>
|
/// 17.查询模具库区汇总数据
|
/// </summary>
|
/// <returns></returns>
|
[HttpPost]
|
public ResponseResult queryMJKAreaSummaryData(AreaModel model)
|
{
|
|
/* LogHelper.Info("queryMJKAreaSummaryData 入参:" + JsonConvert.SerializeObject(model), "数字孪生");*/
|
ResponseResult responseResult = new ResponseResult();
|
try
|
{
|
responseResult.result = DigitHelper.queryMJKAreaSummaryData(model);
|
}
|
catch (Exception ex)
|
{
|
LogHelper.Error("17.查询模具库区汇总数据 错误,错误原因:" + ex.Message, ex, "数字孪生");
|
}
|
/*LogHelper.Info("queryMJKAreaSummaryData 出参:" + JsonConvert.SerializeObject(responseResult), "数字孪生");*/
|
return responseResult;
|
}
|
|
/// <summary>
|
/// 18.钢卷按规格分类统计
|
/// </summary>
|
/// <returns></returns>
|
[HttpPost]
|
public ResponseResult steelCoilSpecStatistic(AreaModel model)
|
{
|
|
/*LogHelper.Info("钢卷按规格分类统计-steelCoilSpecStatistic 入参:", "数字孪生");*/
|
ResponseResult responseResult = new ResponseResult();
|
try
|
{
|
responseResult.result = DigitHelper.steelCoilSpecStatistic(model);
|
}
|
catch (Exception ex)
|
{
|
LogHelper.Error("18.钢卷按规格分类统计 错误,错误原因:" + ex.Message, ex, "数字孪生");
|
}
|
|
/* LogHelper.Info("钢卷按规格分类统计-steelCoilSpecStatistic 出参:" + JsonConvert.SerializeObject(responseResult), "数字孪生");*/
|
return responseResult;
|
}
|
|
/// <summary>
|
/// 19.查询堆垛机状态信息
|
/// </summary>
|
/// <returns></returns>
|
[HttpPost]
|
public ResponseResult getDDJStatusInfo()
|
{
|
|
/*LogHelper.Info("查询堆垛机状态信息-getDDJStatusInfo 入参:", "数字孪生");*/
|
ResponseResult responseResult = new ResponseResult();
|
try
|
{
|
responseResult.result = DigitHelper.getDDJStatusInfos();
|
}
|
catch (Exception ex)
|
{
|
LogHelper.Error("19.查询堆垛机状态信息 错误,错误原因:" + ex.Message, ex, "数字孪生");
|
}
|
|
/*LogHelper.Info("查询堆垛机状态信息-getDDJStatusInfo 出参:" + JsonConvert.SerializeObject(responseResult), "数字孪生");*/
|
return responseResult;
|
}
|
|
/// <summary>
|
/// 20.查询接驳点物料信息
|
/// </summary>
|
/// <returns></returns>
|
[HttpPost]
|
public ResponseResult queryJBItemInfo(LocModel model)
|
{
|
|
/*LogHelper.Info("查询接驳点物料信息-queryJBItemInfo 入参:"+ JsonConvert.SerializeObject(model), "数字孪生");*/
|
ResponseResult responseResult = new ResponseResult();
|
try
|
{
|
responseResult.result = DigitHelper.queryJBItemInfo(model.locCode);
|
}
|
catch (Exception ex)
|
{
|
LogHelper.Error("20.查询接驳点物料信息 错误,错误原因:" + ex.Message, ex, "数字孪生");
|
}
|
|
/*LogHelper.Info("查询接驳点物料信息-queryJBItemInfo 出参:" + JsonConvert.SerializeObject(responseResult), "数字孪生");*/
|
return responseResult;
|
}
|
|
/// <summary>
|
/// 21.查询钢卷出入库记录
|
/// </summary>
|
/// <returns></returns>
|
[HttpPost]
|
public ResponseResult queryGjOutInStockRecord(AreaModel model)
|
{
|
|
/* LogHelper.Info("查询钢卷出入库记录-queryGjOutInStockRecord 入参:" + JsonConvert.SerializeObject(model), "数字孪生");*/
|
ResponseResult responseResult = new ResponseResult();
|
try
|
{
|
responseResult.result = DigitHelper.queryGjOutInStockRecord(model);
|
}
|
catch (Exception ex)
|
{
|
LogHelper.Error("21.查询钢卷出入库记录 错误,错误原因:" + ex.Message, ex, "数字孪生");
|
}
|
|
/*LogHelper.Info("查询钢卷出入库记录-queryGjOutInStockRecord 出参:" + JsonConvert.SerializeObject(responseResult), "数字孪生");*/
|
return responseResult;
|
}
|
|
/// <summary>
|
/// 22.按照工作号统计当前钢卷库的重量,
|
/// </summary>
|
/// <returns></returns>
|
[HttpPost]
|
public ResponseResult querySummaryGJKWeightData()
|
{
|
ResponseResult responseResult = new ResponseResult();
|
try
|
{
|
responseResult = DigitHelper.querySummaryGJKWeightData();
|
}
|
catch (Exception ex)
|
{
|
LogHelper.Error("22.按照工作号统计当前钢卷库的重量,,错误原因:" + ex.Message, ex, "数字孪生");
|
}
|
return responseResult;
|
}
|
}
|
}
|