using AutoMapper;
|
using Magicodes.ExporterAndImporter.Core;
|
using Magicodes.ExporterAndImporter.Excel;
|
using MailKit.Search;
|
using OfficeOpenXml.FormulaParsing.Excel.Functions.Text;
|
using SqlSugar;
|
using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Diagnostics.CodeAnalysis;
|
using System.Linq;
|
using System.Reflection;
|
using System.Reflection.Metadata;
|
using System.Text;
|
using System.Threading.Tasks;
|
using WIDESEA_Core;
|
using WIDESEA_Core.Attributes;
|
using WIDESEA_Core.BaseRepository;
|
using WIDESEA_Core.BaseServices;
|
using WIDESEA_Core.Enums;
|
using WIDESEA_Core.Helper;
|
using WIDESEA_DTO.Inbound;
|
using WIDESEA_DTO.Stock;
|
using WIDESEA_IBasicRepository;
|
using WIDESEA_IBasicService;
|
using WIDESEA_IInboundService;
|
using WIDESEA_IOutboundRepository;
|
using WIDESEA_IOutboundService;
|
using WIDESEA_IRecordService;
|
using WIDESEA_IStockRepository;
|
using WIDESEA_IStockService;
|
using WIDESEA_ITaskInfoRepository;
|
using WIDESEA_ITaskInfoService;
|
using WIDESEA_Model.Models;
|
using WIDESEA_TaskInfoRepository;
|
using OrderByType = SqlSugar.OrderByType;
|
|
namespace WIDESEA_TaskInfoService;
|
|
public class Task_HtyService : ServiceBase<Dt_Task_Hty, ITask_HtyRepository>, ITask_HtyService
|
{
|
|
public Task_HtyService(ITask_HtyRepository BaseDal
|
) : base(BaseDal)
|
{
|
|
}
|
|
/// <summary>
|
/// 添加历史任务
|
/// </summary>
|
/// <param name="task">历史任务Model</param>
|
/// <returns>成功/失败</returns>
|
public bool InsertTask(Dt_Task_Hty task)
|
{
|
return BaseDal.InsertTask(task);
|
}
|
public WebResponseContent AddTaskHty(Dt_Task task)
|
{
|
WebResponseContent content = new WebResponseContent();
|
Dt_Task_Hty task_Hty = new Dt_Task_Hty()
|
{
|
TaskNum = task.TaskNum,
|
PalletCode = task.PalletCode,
|
Roadway = task.Roadway,
|
TaskType = task.TaskType,
|
TaskStatus = task.TaskStatus,
|
SourceAddress = task.SourceAddress,
|
TargetAddress = task.TargetAddress,
|
CurrentAddress = task.CurrentAddress,
|
NextAddress = task.NextAddress,
|
Grade = task.Grade,
|
Dispatchertime = task.Dispatchertime,
|
Creater =task.Creater,
|
CreateDate = task.CreateDate,
|
ModifyDate = DateTime.Now,
|
Modifier = task.Modifier,
|
Remark = task.Remark,
|
PLCTo=task.PLCTo,
|
PalletCodequantity=task.PalletCodequantity,
|
MaterialType = task.MaterialType
|
};
|
BaseDal.AddData(task_Hty);
|
return content;
|
}
|
|
public bool CrueeTaskHty(string TargetAddress)
|
{
|
Dt_Task_Hty task_Hty = BaseDal.QueryData(x => x.TargetAddress == TargetAddress).OrderByDescending(x => x.CreateDate).FirstOrDefault();
|
if (task_Hty == null) return false;
|
|
if(task_Hty.TaskType== TaskTypeEnum.Inbound.ObjToInt() || task_Hty.TaskType == TaskTypeEnum.Relocation.ObjToInt() || task_Hty.TaskType == TaskTypeEnum.PalletInbound.ObjToInt()) return true;
|
|
return false;
|
}
|
|
//导出
|
public override WebResponseContent Export(PageDataOptions options)
|
{
|
WebResponseContent content = new WebResponseContent();
|
try
|
{
|
string savePath = AppDomain.CurrentDomain.BaseDirectory + $"ExcelExport";
|
IExporter exporter = new ExcelExporter();
|
//添加条件
|
string wheres = options.ValidatePageOptions(TProperties);
|
//获取排序字段
|
Dictionary<string, OrderByType> orderbyDic = options.GetPageDataSort(TProperties);
|
List<Dt_Task_Hty> entities = BaseDal.QueryData(wheres, orderbyDic);
|
/*var stockdct = entities
|
.GroupBy(x => new { x.TaskType,x.MaterialType })
|
.Select(g => new Dt_Task_Htyt
|
{
|
MaterialType = g.Key.MaterialType.ToString() == "0" ? "原材料" : "成品", // 这里赋值给 MaterielCode
|
TaskType= g.Key.TaskType.ToString() == "100" ? "出库" : "入库",
|
PalletCodequantity = g.Count(),
|
})
|
.ToList();
|
|
byte[] data = exporter.ExportAsByteArray(stockdct).Result;*/
|
|
var stockdct = entities
|
.Select(g => new Dt_Task_Htykt
|
{
|
TaskNum = g.TaskNum,
|
PalletCode = g.PalletCode,
|
Roadway = g.Roadway,
|
TaskType = g.TaskType.ToString() == "100" ? "出库" : g.TaskType.ToString() == "104" ? "出空托" : g.TaskType.ToString() == "200" ? "入库" : "移库",
|
TaskStatus = g.TaskStatus.ToString()=="290"?"入库完成":"出库完成", // 或者可以根据具体状态码转换
|
SourceAddress = g.SourceAddress,
|
TargetAddress = g.TargetAddress,
|
Remark = g.Remark,
|
Creater = g.Creater,
|
CreateDate = g.CreateDate,
|
Modifier = g.Modifier,
|
ModifyDate = g.ModifyDate,
|
MaterialType = g.MaterialType.ToString() == "0" ? "原材料" : "成品",
|
PalletCodequantity = g.PalletCodequantity.ToString(), // 转换为字符串
|
PLCTo = g.PLCTo.ToString(), // 或者可以根据具体值转换
|
OperateType = g.OperateType.ToString()
|
})
|
.ToList();
|
|
byte[] data = exporter.ExportAsByteArray(stockdct).Result;
|
|
string fileName = "1.xlsx";
|
|
FileHelper.WriteFile(savePath, fileName, data);
|
|
content = WebResponseContent.Instance.OK(data: savePath + "\\" + fileName);
|
}
|
catch (Exception ex)
|
{
|
content = WebResponseContent.Instance.Error(ex.Message);
|
}
|
return content;
|
}
|
|
public class Dt_Task_Htyt
|
{
|
[ExporterHeader(DisplayName = "物料类型")]
|
public string MaterialType { get; set;}
|
[ExporterHeader(DisplayName = "任务类型")]
|
public string TaskType { get; set; }
|
[ExporterHeader(DisplayName = "数量")]
|
public int PalletCodequantity { get; set; }
|
}
|
|
|
public class Dt_Task_Htykt
|
{
|
[ExporterHeader(DisplayName = "任务号")]
|
public int TaskNum { get; set; }
|
|
[ExporterHeader(DisplayName = "托盘编号")]
|
public string PalletCode { get; set; }
|
|
[ExporterHeader(DisplayName = "巷道号")]
|
public string Roadway { get; set; }
|
|
[ExporterHeader(DisplayName = "任务类型")]
|
public string TaskType { get; set; }
|
|
[ExporterHeader(DisplayName = "任务状态")]
|
public string TaskStatus { get; set; }
|
|
[ExporterHeader(DisplayName = "起始地址")]
|
public string SourceAddress { get; set; }
|
|
[ExporterHeader(DisplayName = "目标地址")]
|
public string TargetAddress { get; set; }
|
|
[ExporterHeader(DisplayName = "备注")]
|
public string Remark { get; set; }
|
|
[ExporterHeader(DisplayName = "创建人")]
|
public string Creater { get; set; }
|
|
[ExporterHeader(DisplayName = "创建时间")]
|
public DateTime CreateDate { get; set; }
|
|
[ExporterHeader(DisplayName = "修改人")]
|
public string Modifier { get; set; }
|
|
[ExporterHeader(DisplayName = "修改日期")]
|
public DateTime? ModifyDate { get; set; }
|
|
[ExporterHeader(DisplayName = "物料类型")]
|
public string MaterialType { get; set; }
|
|
[ExporterHeader(DisplayName = "托盘数量")]
|
public string PalletCodequantity { get; set; }
|
|
[ExporterHeader(DisplayName = "原材料去向")]
|
public string PLCTo { get; set; }
|
|
[ExporterHeader(DisplayName = "完成情况")]
|
public string OperateType { get; set; }
|
}
|
}
|
