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 { /// /// 数字孪生调用接口 /// [RoutePrefix("api")] public class DigitController : System.Web.Http.ApiController { /// /// 1.查询当前备货区所有成品信息 /// /// /// [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; } /// /// 2.查询三个立体库的汇总数据 /// /// [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; } /// /// 3.按工作号汇总成品、半成品所占库位数量列表 /// /// [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; } /// /// 4.按工作号汇总成品、半成品所占库位数量、占比 /// /// [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; } /// /// 4.1.按工作号、物料类型汇总物料所占库位数量、占比 /// /// [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; } /// /// 5.根据在库时长汇总成品、半成品的所占库位数量 /// /// [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; } /// /// 6.按图号汇总三个立体库的出库(入库)数量和占比 /// /// [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; } /// /// 7.查询今日出厂的成品信息 /// /// [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; } /// /// 8.查询当前立体库汇总数据 /// /// [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; } /// /// 9.查询出入库信息汇总 /// /// [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; } /// /// 10.查询当前执行中和待执行任务列表汇总 /// /// [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; } /// /// 11.查询库位数据 /// /// [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; } /// /// 12.统计各库区库位总数、使用数量和使用率 /// /// [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; } /// /// 13.查询立体库库位数据 /// /// [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; } /// /// 14.查询钢卷库库位数据 /// /// [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; } /// /// 15.查询模具库库位数据 /// /// [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; } /// /// 16.查询钢卷库区汇总数据 /// /// [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; } /// /// 17.查询模具库区汇总数据 /// /// [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; } /// /// 18.钢卷按规格分类统计 /// /// [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; } /// /// 19.查询堆垛机状态信息 /// /// [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; } /// /// 20.查询接驳点物料信息 /// /// [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; } /// /// 21.查询钢卷出入库记录 /// /// [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; } /// /// 22.按照工作号统计当前钢卷库的重量, /// /// [HttpPost] public ResponseResult querySummaryGJKWeightData() { ResponseResult responseResult = new ResponseResult(); try { responseResult = DigitHelper.querySummaryGJKWeightData(); } catch (Exception ex) { LogHelper.Error("22.按照工作号统计当前钢卷库的重量,,错误原因:" + ex.Message, ex, "数字孪生"); } return responseResult; } } }