#region << 版 本 注 释 >> /*---------------------------------------------------------------- * 命名空间:WIDESEAWCS_TaskInfoService * 创建者:胡童庆 * 创建时间:2024/8/2 16:13:36 * 版本:V1.0.0 * 描述: * * ---------------------------------------------------------------- * 修改人: * 修改时间: * 版本:V1.0.1 * 修改说明: * *----------------------------------------------------------------*/ #endregion << 版 本 注 释 >> using AutoMapper; using Microsoft.AspNetCore.Mvc; using Microsoft.AspNetCore.Mvc.RazorPages; using NetTaste; using Newtonsoft.Json; using OfficeOpenXml.FormulaParsing.Excel.Functions.DateTime; using OfficeOpenXml.FormulaParsing.Excel.Functions.Text; using SqlSugar; using System; using System.Collections.Generic; using System.ComponentModel; using System.Diagnostics; using System.Diagnostics.CodeAnalysis; using System.Linq; using System.Linq.Expressions; using System.Reflection; using System.Reflection.Metadata; using System.Text; using System.Threading.Tasks; using WIDESEA_Comm.Http; using WIDESEAWCS_Core; using WIDESEAWCS_Core.BaseServices; using WIDESEAWCS_Core.Enums; using WIDESEAWCS_DTO.Enum; using WIDESEAWCS_DTO.TaskInfo; using WIDESEAWCS_ITaskInfoRepository; using WIDESEAWCS_ITaskInfoService; using WIDESEAWCS_Model.Models; using WIDESEAWCS_QuartzJob.Service; namespace WIDESEAWCS_TaskInfoService { public class Task_HtyService : ServiceBase, ITask_HtyService { private readonly IRouterService _routerService; private readonly ITaskExecuteDetailService _taskExecuteDetailService; private readonly ITaskExecuteDetailRepository _taskExecuteDetailRepository; private readonly IMapper _mapper; public Task_HtyService(ITask_HtyRepository BaseDal, IRouterService routerService, ITaskExecuteDetailService taskExecuteDetailService, ITaskExecuteDetailRepository taskExecuteDetailRepository, IMapper mapper) : base(BaseDal) { _routerService = routerService; _taskExecuteDetailService = taskExecuteDetailService; _taskExecuteDetailRepository = taskExecuteDetailRepository; _mapper = mapper; } public static List MaterialCuttingOutletList = new List() { "B102", "B202" , "B402" , "A203" , "A403", "A603", "A803"}; public static List EdgeBandingCuttingOutletList = new List() { "F20", "F21"}; public static List EdgeSandingCuttingOutletList = new List() { "C13", "F14" }; public static List DrillingCuttingPositionList = new List() { "Z13", "Z14" }; #region 第四板块 /// /// 5日内的出入库 /// /// public WebResponseContent fifteenTotal_quantityndex() { WebResponseContent content = new WebResponseContent(); var startDate = DateTime.Today.AddDays(-5); var today = DateTime.Today; var dateRange = Enumerable.Range(0, 5).Select(offset => today.AddDays(-offset)); var data2 = BaseDal.QueryData(x => x.CreateDate >= startDate && x.CreateDate < today.AddDays(1)).ToList(); var result = dateRange.Reverse().Select(date => { // 统计板材下料口 //var MaterialCuttingOutlet = data2.Where(x => x.CreateDate >= date && x.CreateDate < date.AddDays(1) && MaterialCuttingOutletList.Contains(x.SourceAddress)).Count(); var MaterialCuttingOutlet = 50; // 统计封边下料口 //var EdgeBandingCuttingOutlet = data2.Where(x => x.CreateDate >= date && x.CreateDate < date.AddDays(1) && EdgeBandingCuttingOutletList.Contains(x.SourceAddress)).Count(); var EdgeBandingCuttingOutlet = 40; // 统计砂边下料口 //var EdgeSandingCuttingOutlet = data2.Where(x => x.CreateDate >= date && x.CreateDate < date.AddDays(1) && EdgeSandingCuttingOutletList.Contains(x.SourceAddress)).Count(); var EdgeSandingCuttingOutlet = 80; // 统计钻孔下料位 //var DrillingCuttingPosition = data2.Where(x => x.CreateDate >= date && x.CreateDate < date.AddDays(1) && DrillingCuttingPositionList.Contains(x.SourceAddress)).Count(); var DrillingCuttingPosition = 30; return new { Date = date.ToString("MM-dd"), MaterialCuttingOutlets = MaterialCuttingOutlet, EdgeBandingCuttingOutlets = EdgeBandingCuttingOutlet, EdgeSandingCuttingOutlets = EdgeSandingCuttingOutlet, DrillingCuttingPositions = DrillingCuttingPosition, }; }); var datat = new { Daily_statistics = result.ToList(), }; return content.OK(data: datat); } #endregion } }