#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<Dt_Task_hty, ITask_HtyRepository>, 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<string> MaterialCuttingOutletList = new List<string>() { "B102", "B202" , "B402" , "A203" , "A403", "A603", "A803"};
|
public static List<string> EdgeBandingCuttingOutletList = new List<string>() { "F20", "F21"};
|
public static List<string> EdgeSandingCuttingOutletList = new List<string>() { "C13", "F14" };
|
public static List<string> DrillingCuttingPositionList = new List<string>() { "Z13", "Z14" };
|
|
#region 第四板块
|
/// <summary>
|
/// 5日内的出入库
|
/// </summary>
|
/// <returns></returns>
|
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
|
|
|
|
}
|
}
|
