using Furion.DatabaseAccessor;
|
using Furion.DatabaseAccessor.Extensions;
|
using Furion.DependencyInjection;
|
using Furion.DynamicApiController;
|
using Furion.FriendlyException;
|
using Furion.JsonSerialization;
|
using iWare.Wms.Core;
|
using iWare.Wms.Core.Util;
|
using Mapster;
|
using Microsoft.AspNetCore.Mvc;
|
using Microsoft.EntityFrameworkCore;
|
using Microsoft.EntityFrameworkCore.Internal;
|
using Newtonsoft.Json;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Linq.Dynamic.Core;
|
using System.Text;
|
using System.Web;
|
|
namespace iWare.Wms.Application
|
{
|
/// <summary>
|
/// 质量数据查询服务
|
/// </summary>
|
[ApiDescriptionSettings("数据查询服务", Name = "QualityDataInfo", Order = 100)]
|
[Route("api/[Controller]")]
|
public class QualityDataInfoService : IQualityDataInfoService, IDynamicApiController, ITransient
|
{
|
private readonly IRepository<QualityDataInfo, MasterDbContextLocator> _qualityDataInfoRep;
|
private readonly IRepository<EquipmentBaseInfo, MasterDbContextLocator> _equipmentBaseInfoRep;
|
private readonly IRepository<SysDictType, MasterDbContextLocator> _sysDictTypeRep;
|
private readonly IRepository<SysDictData, MasterDbContextLocator> _sysDictDataRep;
|
private readonly IRepository<AccessInterfaceLog, MasterDbContextLocator> _accessInterfaceLogRep;
|
|
/// <summary>
|
/// 质量数据查询构造
|
/// </summary>
|
/// <param name="qualityDataInfoRep"></param>
|
/// <param name="equipmentBaseInfoRep"></param>
|
/// <param name="sysDictTypeRep"></param>
|
/// <param name="sysDictDataRep"></param>
|
public QualityDataInfoService(
|
IRepository<QualityDataInfo, MasterDbContextLocator> qualityDataInfoRep,
|
IRepository<EquipmentBaseInfo, MasterDbContextLocator> equipmentBaseInfoRep,
|
IRepository<SysDictType, MasterDbContextLocator> sysDictTypeRep,
|
IRepository<SysDictData, MasterDbContextLocator> sysDictDataRep,
|
IRepository<AccessInterfaceLog, MasterDbContextLocator> accessInterfaceLogRep)
|
{
|
_qualityDataInfoRep = qualityDataInfoRep;
|
_equipmentBaseInfoRep = equipmentBaseInfoRep;
|
_sysDictTypeRep = sysDictTypeRep;
|
_sysDictDataRep = sysDictDataRep;
|
_sysDictDataRep = sysDictDataRep;
|
_accessInterfaceLogRep = accessInterfaceLogRep;
|
}
|
/// <summary>
|
/// 根据质量ID获取SPC质量信息
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpGet("GetQualityInfoSPCForID")]
|
public async Task<AddQualityDataInfoInputV2> GetQualityInfoSPCForID([FromQuery] QualityDataInfoSearch2 input)
|
{
|
var interfaceLog = _accessInterfaceLogRep.DetachedEntities.Where(o => o.Id == input.QualityDataInfoID).FirstOrDefault();
|
if (interfaceLog == null || interfaceLog.Id < 1)
|
{//没有查询到
|
throw Oops.Oh($"当前工件{input.WorkPieceID ?? ""}没有SPC反馈信息！");
|
}
|
var output = JsonConvert.DeserializeObject<AddQualityDataInfoInputV2>(interfaceLog.ParaJSON);
|
return output;
|
}
|
/// <summary>
|
/// 根据质量ID获取质量信息
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpGet("GetQualityInfoForID")]
|
public async Task<QualityDataInfoOutput> GetQualityInfoForID([FromQuery] QualityDataInfoSearch2 input)
|
{
|
QualityDataInfoOutput qualityDataInfo = new QualityDataInfoOutput();
|
if (input == null || string.IsNullOrEmpty(input.OperationType))
|
{
|
throw Oops.Oh("传参异常！");
|
}
|
if (input.OperationType.Equals("SPC"))
|
{
|
|
}
|
else
|
{
|
qualityDataInfo = await _qualityDataInfoRep.DetachedEntities
|
.Join(_equipmentBaseInfoRep.DetachedEntities, a => a.EquipmentID, b => b.EquipmentId, (a, b) => new { a, b })
|
//.Join(_sysDictDataRep.DetachedEntities, e => e.a.QualityState.ToString(), f => f.Code, (e, f) => new { e, f })
|
//.Join(_sysDictTypeRep.DetachedEntities, g => g.f.TypeId, h => h.Id, (f, g) => new { f, g })
|
//.Where(x => (x.g.Code.Equals("quality_state")))
|
.Where(input.WorkPieceID != null, w => w.a.WorkPieceID.Equals(input.WorkPieceID))
|
.Select(m => new QualityDataInfoOutput
|
{
|
Id = m.a.Id,
|
WorkPieceID = m.a.WorkPieceID,
|
EquipmentName = m.b.EquipmentName,
|
WorkingProcedure = m.a.WorkingProcedure,
|
QualityState = m.a.QualityState,
|
//QualityStateName = m.f.f.Value,
|
QualityStateUpdateMode = m.a.QualityStateUpdateMode,
|
QualityStateUpdateUser = m.a.QualityStateUpdateUser,
|
QualityReceiveTime = m.a.QualityReceiveTime,
|
OfflineTime = m.a.OfflineTime,
|
QualityOP10To1 = m.a.QualityOP10To1,
|
QualityOP40To1 = m.a.QualityOP40To1,
|
QualityOP20To1 = m.a.QualityOP20To1,
|
QualityOP30To1 = m.a.QualityOP30To1,
|
QualityOP30To2 = m.a.QualityOP30To2,
|
QualityOP30To3 = m.a.QualityOP30To3,
|
QualityOP30To4 = m.a.QualityOP30To4,
|
QualityOP30To5 = m.a.QualityOP30To5,
|
QualityOP30To6 = m.a.QualityOP30To6,
|
QualityOP30To7 = m.a.QualityOP30To7,
|
QualityOP30To8 = m.a.QualityOP30To8,
|
QualityOP30To9 = m.a.QualityOP30To9,
|
QualityOP30To10 = m.a.QualityOP30To10,
|
QualityOP30To11 = m.a.QualityOP30To11,
|
QualityOP35To1 = m.a.QualityOP35To1,
|
QualityOP35To2 = m.a.QualityOP35To2,
|
QualityOP60To1 = m.a.QualityOP60To1,
|
QualityOP60To2 = m.a.QualityOP60To2,
|
QualityOP70To1 = m.a.QualityOP70To1,
|
QualityOP70To2 = m.a.QualityOP70To2,
|
QualityOP70To3 = m.a.QualityOP70To3,
|
QualityOP80To1 = m.a.QualityOP80To1,
|
QualityOP80To2 = m.a.QualityOP80To2,
|
QualityOP80To3 = m.a.QualityOP80To3,
|
QualityOP80To4 = m.a.QualityOP80To4,
|
QualityOP80To5 = m.a.QualityOP80To5,
|
QualityOP80To6 = m.a.QualityOP80To6,
|
QualityOP80To7 = m.a.QualityOP80To7,
|
QualityOP80To8 = m.a.QualityOP80To8,
|
QualityOP80To9 = m.a.QualityOP80To9,
|
QualityOP80To10 = m.a.QualityOP80To10,
|
|
//新增OP80的一些质量数据 【Editby shaocx,2024 - 06 - 13】
|
QualityOP80_Houdu = m.a.QualityOP80_Houdu,
|
QualityOP80_ZXJ = m.a.QualityOP80_ZXJ,
|
QualityOP80_DTKYZD = m.a.QualityOP80_DTKYZD,
|
QualityOP80_XTSMYD = m.a.QualityOP80_XTSMYD,
|
QualityOP80_XTXMYD = m.a.QualityOP80_XTXMYD,
|
QualityOP80_D_TKZJ = m.a.QualityOP80_D_TKZJ,
|
QualityOP80_D_S_X = m.a.QualityOP80_D_S_X,
|
QualityOP80_D_S_Y = m.a.QualityOP80_D_S_Y,
|
QualityOP80_D_X_X = m.a.QualityOP80_D_X_X,
|
QualityOP80_D_X_Y = m.a.QualityOP80_D_X_Y,
|
QualityOP80_X_TKZJ = m.a.QualityOP80_X_TKZJ,
|
QualityOP80_X_S_X = m.a.QualityOP80_X_S_X,
|
QualityOP80_X_S_Y = m.a.QualityOP80_X_S_Y,
|
QualityOP80_X_X_X = m.a.QualityOP80_X_X_X,
|
QualityOP80_X_X_Y = m.a.QualityOP80_X_X_Y,
|
|
Remarks = m.a.Remarks,
|
})
|
//.OrderBy(PageInputOrder.OrderBuilder<QualityDataInfoSearch>(input))
|
.ProjectToType<QualityDataInfoOutput>()
|
.FirstOrDefaultAsync();
|
}
|
|
return qualityDataInfo;
|
}
|
|
/// <summary>
|
/// 分页查询质量数据查询
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpGet("page")]
|
public async Task<PageResult<QualityDataInfoOutput>> Page([FromQuery] QualityDataInfoSearch input)
|
{
|
if (!input.StartTime.HasValue || !input.EndTime.HasValue || input.StartTime > input.EndTime)
|
{
|
throw Oops.Oh("传参异常:日期范围必须传值！");
|
}
|
if (string.IsNullOrEmpty(input.EquipmentID))
|
{
|
throw Oops.Oh("传参异常:设备编号必须传参！");
|
}
|
|
//if (!string.IsNullOrEmpty(input.EquipmentID) && input.EquipmentID.Equals("EOP10") && string.IsNullOrEmpty(input.WorkingProcedure))
|
//{
|
// throw Oops.Oh("传参异常:工序必须传值！");
|
//}
|
var qualityDataInfos = await _qualityDataInfoRep.DetachedEntities
|
.Join(_equipmentBaseInfoRep.DetachedEntities, a => a.EquipmentID, b => b.EquipmentId, (a, b) => new { a, b })
|
//.Where(o => o.a.CreatedTime.Value.Date >= input.StartTime.Value)
|
//.Where(o => o.a.UpdatedTime.Value.Date <= input.EndTime.Value)
|
.Where(!string.IsNullOrEmpty(input.WorkPieceID), w => w.a.WorkPieceID.Contains(input.WorkPieceID))
|
.Where(input.EquipmentID.Equals("EOP10") && string.IsNullOrEmpty(input.WorkingProcedure), o => (o.a.OP10QualityReceiveTime.Value.Date >= input.StartTime.Value
|
&& o.a.OP10QualityReceiveTime.Value.Date <= input.EndTime.Value && o.a.OP10QualityState == (input.QualityState.HasValue ? input.QualityState.ToString() : o.a.OP10QualityState)) || (o.a.OP40QualityReceiveTime.Value.Date >= input.StartTime.Value && o.a.OP40QualityReceiveTime.Value.Date <= input.EndTime.Value && o.a.OP40QualityState == (input.QualityState.HasValue ? input.QualityState.ToString() : o.a.OP40QualityState)))
|
.Where(input.EquipmentID.Equals("EOP10") && !string.IsNullOrEmpty(input.WorkingProcedure) && input.WorkingProcedure.Equals("OP10"), o => (o.a.OP10QualityReceiveTime.Value.Date >= input.StartTime.Value && o.a.OP10QualityReceiveTime.Value.Date <= input.EndTime.Value && o.a.OP10QualityState == (input.QualityState.HasValue ? input.QualityState.ToString() : o.a.OP10QualityState)))
|
.Where(input.EquipmentID.Equals("EOP10") && !string.IsNullOrEmpty(input.WorkingProcedure) && input.WorkingProcedure.Equals("OP40"), o => (o.a.OP40QualityReceiveTime.Value.Date >= input.StartTime.Value && o.a.OP40QualityReceiveTime.Value.Date <= input.EndTime.Value && o.a.OP40QualityState == (input.QualityState.HasValue ? input.QualityState.ToString() : o.a.OP40QualityState)))
|
.Where(input.EquipmentID.Equals("EOP20"), o => o.a.OP20QualityReceiveTime.Value.Date >= input.StartTime.Value && o.a.OP20QualityReceiveTime.Value.Date <= input.EndTime.Value && o.a.OP20QualityState == (input.QualityState.HasValue ? input.QualityState.ToString() : o.a.OP20QualityState))
|
.Where(input.EquipmentID.Equals("EOP30"), o => o.a.OP30QualityReceiveTime.Value.Date >= input.StartTime.Value && o.a.OP30QualityReceiveTime.Value.Date <= input.EndTime.Value && o.a.OP30QualityState == (input.QualityState.HasValue ? input.QualityState.ToString() : o.a.OP30QualityState))
|
.Where(input.EquipmentID.Equals("EOP35"), o => o.a.OP35QualityReceiveTime.Value.Date >= input.StartTime.Value && o.a.OP35QualityReceiveTime.Value.Date <= input.EndTime.Value && o.a.OP35QualityState == (input.QualityState.HasValue ? input.QualityState.ToString() : o.a.OP35QualityState))
|
.Where(input.EquipmentID.Equals("EOP60"), o => o.a.OP60QualityReceiveTime.Value.Date >= input.StartTime.Value && o.a.OP60QualityReceiveTime.Value.Date <= input.EndTime.Value && o.a.OP60QualityState == (input.QualityState.HasValue ? input.QualityState.ToString() : o.a.OP60QualityState))
|
.Where(input.EquipmentID.Equals("EOP80"), o => o.a.OP80QualityReceiveTime.Value.Date >= input.StartTime.Value && o.a.OP80QualityReceiveTime.Value.Date <= input.EndTime.Value && o.a.OP80QualityState == (input.QualityState.HasValue ? input.QualityState.ToString() : o.a.OP80QualityState))
|
.Where(o => !string.IsNullOrEmpty(o.a.WorkPieceID))
|
.Select(m => new QualityDataInfoOutput
|
{
|
Id = m.a.Id,
|
WorkPieceID = m.a.WorkPieceID,
|
EquipmentID = input.EquipmentID,
|
//EquipmentName = m.b.EquipmentName,
|
WorkingProcedure = input.WorkingProcedure,
|
QualityState = m.a.QualityState,
|
//QualityStateName = m.a.f.f.Value,
|
QualityStateUpdateMode = m.a.QualityStateUpdateMode,
|
QualityStateUpdateUser = m.a.QualityStateUpdateUser,
|
QualityReceiveTime = m.a.QualityReceiveTime,
|
OfflineTime = m.a.OfflineTime,
|
QualityOP10To1 = m.a.QualityOP10To1,
|
QualityOP40To1 = m.a.QualityOP40To1,
|
QualityOP20To1 = m.a.QualityOP20To1,
|
QualityOP30To1 = m.a.QualityOP30To1,
|
QualityOP30To2 = m.a.QualityOP30To2,
|
QualityOP30To3 = m.a.QualityOP30To3,
|
QualityOP30To4 = m.a.QualityOP30To4,
|
QualityOP30To5 = m.a.QualityOP30To5,
|
QualityOP30To6 = m.a.QualityOP30To6,
|
QualityOP30To7 = m.a.QualityOP30To7,
|
QualityOP30To8 = m.a.QualityOP30To8,
|
QualityOP30To9 = m.a.QualityOP30To9,
|
QualityOP30To10 = m.a.QualityOP30To10,
|
QualityOP30To11 = m.a.QualityOP30To11,
|
QualityOP35To1 = m.a.QualityOP35To1,
|
QualityOP35To2 = m.a.QualityOP35To2,
|
QualityOP60To1 = m.a.QualityOP60To1,
|
QualityOP60To2 = m.a.QualityOP60To2,
|
QualityOP70To1 = m.a.QualityOP70To1,
|
QualityOP70To2 = m.a.QualityOP70To2,
|
QualityOP70To3 = m.a.QualityOP70To3,
|
QualityOP80To1 = m.a.QualityOP80To1,
|
QualityOP80To2 = m.a.QualityOP80To2,
|
QualityOP80To3 = m.a.QualityOP80To3,
|
QualityOP80To4 = m.a.QualityOP80To4,
|
QualityOP80To5 = m.a.QualityOP80To5,
|
QualityOP80To6 = m.a.QualityOP80To6,
|
QualityOP80To7 = m.a.QualityOP80To7,
|
QualityOP80To8 = m.a.QualityOP80To8,
|
QualityOP80To9 = m.a.QualityOP80To9,
|
QualityOP80To10 = m.a.QualityOP80To10,
|
OP10QualityReceiveTime = m.a.OP10QualityReceiveTime,
|
OP20QualityReceiveTime = m.a.OP20QualityReceiveTime,
|
OP30QualityReceiveTime = m.a.OP30QualityReceiveTime,
|
OP35QualityReceiveTime = m.a.OP35QualityReceiveTime,
|
OP40QualityReceiveTime = m.a.OP40QualityReceiveTime,
|
OP60QualityReceiveTime = m.a.OP60QualityReceiveTime,
|
OP80QualityReceiveTime = m.a.OP80QualityReceiveTime,
|
OP10QualityState = m.a.OP10QualityState,
|
OP20QualityState = m.a.OP20QualityState,
|
OP30QualityState = m.a.OP30QualityState,
|
OP40QualityState = m.a.OP40QualityState,
|
OP35QualityState = m.a.OP35QualityState,
|
OP60QualityState = m.a.OP60QualityState,
|
OP80QualityState = m.a.OP80QualityState,
|
|
OP30QualityStateCH3 = m.a.OP30QualityStateCH3,
|
OP30QualityStateCH4 = m.a.OP30QualityStateCH4,
|
OP30QualityStateCH5 = m.a.OP30QualityStateCH5,
|
OP30QualityStateCH6 = m.a.OP30QualityStateCH6,
|
|
//新增OP80的一些质量数据 【Editby shaocx,2024 - 06 - 13】
|
QualityOP80_Houdu = m.a.QualityOP80_Houdu,
|
QualityOP80_ZXJ = m.a.QualityOP80_ZXJ,
|
QualityOP80_DTKYZD = m.a.QualityOP80_DTKYZD,
|
QualityOP80_XTSMYD = m.a.QualityOP80_XTSMYD,
|
QualityOP80_XTXMYD = m.a.QualityOP80_XTXMYD,
|
QualityOP80_D_TKZJ = m.a.QualityOP80_D_TKZJ,
|
QualityOP80_D_S_X = m.a.QualityOP80_D_S_X,
|
QualityOP80_D_S_Y = m.a.QualityOP80_D_S_Y,
|
QualityOP80_D_X_X = m.a.QualityOP80_D_X_X,
|
QualityOP80_D_X_Y = m.a.QualityOP80_D_X_Y,
|
QualityOP80_X_TKZJ = m.a.QualityOP80_X_TKZJ,
|
QualityOP80_X_S_X = m.a.QualityOP80_X_S_X,
|
QualityOP80_X_S_Y = m.a.QualityOP80_X_S_Y,
|
QualityOP80_X_X_X = m.a.QualityOP80_X_X_X,
|
QualityOP80_X_X_Y = m.a.QualityOP80_X_X_Y,
|
|
Remarks = m.a.Remarks,
|
UpdateTime = m.a.UpdatedTime,
|
})
|
.ProjectToType<QualityDataInfoOutput>().ToListAsync();
|
|
if (input.EquipmentID.Equals("EOP10") && !string.IsNullOrEmpty(input.WorkingProcedure) && input.WorkingProcedure.Equals("OP10"))
|
{
|
qualityDataInfos = qualityDataInfos.OrderByDescending(x => x.OP10QualityReceiveTime).ToList();
|
}
|
else if (input.EquipmentID.Equals("EOP10") && !string.IsNullOrEmpty(input.WorkingProcedure) && input.WorkingProcedure.Equals("OP40"))
|
{
|
qualityDataInfos = qualityDataInfos.OrderByDescending(x => x.OP40QualityReceiveTime).ToList();
|
}
|
else if (input.EquipmentID.Equals("EOP20"))
|
{
|
qualityDataInfos = qualityDataInfos.OrderByDescending(x => x.OP20QualityReceiveTime).ToList();
|
}
|
else if (input.EquipmentID.Equals("EOP30"))
|
{
|
qualityDataInfos = qualityDataInfos.OrderByDescending(x => x.OP30QualityReceiveTime).ToList();
|
}
|
else if (input.EquipmentID.Equals("EOP60"))
|
{
|
qualityDataInfos = qualityDataInfos.OrderByDescending(x => x.OP60QualityReceiveTime).ToList();
|
}
|
else if (input.EquipmentID.Equals("EOP80"))
|
{
|
qualityDataInfos = qualityDataInfos.OrderByDescending(x => x.OP80QualityReceiveTime).ToList();
|
}
|
|
var retData = qualityDataInfos.ToADPagedList(input.PageNo, input.PageSize);
|
return retData;
|
}
|
|
|
|
/// <summary>
|
/// 根据质量数据导出Excel
|
/// </summary>
|
/// <param name="input">质量数据传入信息</param>
|
/// <returns>导出的Excel文件</returns>
|
[HttpGet("toExcel")]
|
public async Task<IActionResult> ToExcelAsync([FromQuery] QualityDataInfoSearch input)
|
{
|
if (!input.StartTime.HasValue || !input.EndTime.HasValue || input.StartTime > input.EndTime)
|
{
|
throw Oops.Oh("传参异常:日期范围必须传值！");
|
}
|
if (string.IsNullOrEmpty(input.EquipmentID))
|
{
|
throw Oops.Oh("传参异常:设备编号必须传参！");
|
}
|
|
var qualityDataInfos = await _qualityDataInfoRep.DetachedEntities
|
.Join(_equipmentBaseInfoRep.DetachedEntities, a => a.EquipmentID, b => b.EquipmentId, (a, b) => new { a, b })
|
//.Where(o => o.a.CreatedTime.Value.Date >= input.StartTime.Value)
|
//.Where(o => o.a.UpdatedTime.Value.Date <= input.EndTime.Value)
|
.Where(!string.IsNullOrEmpty(input.WorkPieceID), w => w.a.WorkPieceID.Contains(input.WorkPieceID))
|
.Where(input.EquipmentID.Equals("EOP10") && string.IsNullOrEmpty(input.WorkingProcedure), o => (o.a.OP10QualityReceiveTime.Value.Date >= input.StartTime.Value
|
&& o.a.OP10QualityReceiveTime.Value.Date <= input.EndTime.Value && o.a.OP10QualityState == (input.QualityState.HasValue ? input.QualityState.ToString() : o.a.OP10QualityState)) || (o.a.OP40QualityReceiveTime.Value.Date >= input.StartTime.Value && o.a.OP40QualityReceiveTime.Value.Date <= input.EndTime.Value && o.a.OP40QualityState == (input.QualityState.HasValue ? input.QualityState.ToString() : o.a.OP40QualityState)))
|
.Where(input.EquipmentID.Equals("EOP10") && !string.IsNullOrEmpty(input.WorkingProcedure) && input.WorkingProcedure.Equals("OP10"), o => (o.a.OP10QualityReceiveTime.Value.Date >= input.StartTime.Value && o.a.OP10QualityReceiveTime.Value.Date <= input.EndTime.Value && o.a.OP10QualityState == (input.QualityState.HasValue ? input.QualityState.ToString() : o.a.OP10QualityState)))
|
.Where(input.EquipmentID.Equals("EOP10") && !string.IsNullOrEmpty(input.WorkingProcedure) && input.WorkingProcedure.Equals("OP40"), o => (o.a.OP40QualityReceiveTime.Value.Date >= input.StartTime.Value && o.a.OP40QualityReceiveTime.Value.Date <= input.EndTime.Value && o.a.OP40QualityState == (input.QualityState.HasValue ? input.QualityState.ToString() : o.a.OP40QualityState)))
|
.Where(input.EquipmentID.Equals("EOP20"), o => o.a.OP20QualityReceiveTime.Value.Date >= input.StartTime.Value && o.a.OP20QualityReceiveTime.Value.Date <= input.EndTime.Value && o.a.OP20QualityState == (input.QualityState.HasValue ? input.QualityState.ToString() : o.a.OP20QualityState))
|
.Where(input.EquipmentID.Equals("EOP30"), o => o.a.OP30QualityReceiveTime.Value.Date >= input.StartTime.Value && o.a.OP30QualityReceiveTime.Value.Date <= input.EndTime.Value && o.a.OP30QualityState == (input.QualityState.HasValue ? input.QualityState.ToString() : o.a.OP30QualityState))
|
.Where(input.EquipmentID.Equals("EOP35"), o => o.a.OP35QualityReceiveTime.Value.Date >= input.StartTime.Value && o.a.OP35QualityReceiveTime.Value.Date <= input.EndTime.Value && o.a.OP35QualityState == (input.QualityState.HasValue ? input.QualityState.ToString() : o.a.OP35QualityState))
|
.Where(input.EquipmentID.Equals("EOP60"), o => o.a.OP60QualityReceiveTime.Value.Date >= input.StartTime.Value && o.a.OP60QualityReceiveTime.Value.Date <= input.EndTime.Value && o.a.OP60QualityState == (input.QualityState.HasValue ? input.QualityState.ToString() : o.a.OP60QualityState))
|
.Where(input.EquipmentID.Equals("EOP80"), o => o.a.OP80QualityReceiveTime.Value.Date >= input.StartTime.Value && o.a.OP80QualityReceiveTime.Value.Date <= input.EndTime.Value && o.a.OP80QualityState == (input.QualityState.HasValue ? input.QualityState.ToString() : o.a.OP80QualityState))
|
.Where(o => !string.IsNullOrEmpty(o.a.WorkPieceID))
|
.Select(m => new QualityDataInfoOutput
|
{
|
Id = m.a.Id,
|
WorkPieceID = m.a.WorkPieceID,
|
EquipmentID = input.EquipmentID,
|
//EquipmentName = m.b.EquipmentName,
|
WorkingProcedure = input.WorkingProcedure,
|
QualityState = m.a.QualityState,
|
//QualityStateName = m.a.f.f.Value,
|
QualityStateUpdateMode = m.a.QualityStateUpdateMode,
|
QualityStateUpdateUser = m.a.QualityStateUpdateUser,
|
QualityReceiveTime = m.a.QualityReceiveTime,
|
OfflineTime = m.a.OfflineTime,
|
QualityOP10To1 = m.a.QualityOP10To1,
|
QualityOP40To1 = m.a.QualityOP40To1,
|
QualityOP20To1 = m.a.QualityOP20To1,
|
QualityOP30To1 = m.a.QualityOP30To1,
|
QualityOP30To2 = m.a.QualityOP30To2,
|
QualityOP30To3 = m.a.QualityOP30To3,
|
QualityOP30To4 = m.a.QualityOP30To4,
|
QualityOP30To5 = m.a.QualityOP30To5,
|
QualityOP30To6 = m.a.QualityOP30To6,
|
QualityOP30To7 = m.a.QualityOP30To7,
|
QualityOP30To8 = m.a.QualityOP30To8,
|
QualityOP30To9 = m.a.QualityOP30To9,
|
QualityOP30To10 = m.a.QualityOP30To10,
|
QualityOP30To11 = m.a.QualityOP30To11,
|
QualityOP35To1 = m.a.QualityOP35To1,
|
QualityOP35To2 = m.a.QualityOP35To2,
|
QualityOP60To1 = m.a.QualityOP60To1,
|
QualityOP60To2 = m.a.QualityOP60To2,
|
QualityOP70To1 = m.a.QualityOP70To1,
|
QualityOP70To2 = m.a.QualityOP70To2,
|
QualityOP70To3 = m.a.QualityOP70To3,
|
QualityOP80To1 = m.a.QualityOP80To1,
|
QualityOP80To2 = m.a.QualityOP80To2,
|
QualityOP80To3 = m.a.QualityOP80To3,
|
QualityOP80To4 = m.a.QualityOP80To4,
|
QualityOP80To5 = m.a.QualityOP80To5,
|
QualityOP80To6 = m.a.QualityOP80To6,
|
QualityOP80To7 = m.a.QualityOP80To7,
|
QualityOP80To8 = m.a.QualityOP80To8,
|
QualityOP80To9 = m.a.QualityOP80To9,
|
QualityOP80To10 = m.a.QualityOP80To10,
|
OP10QualityReceiveTime = m.a.OP10QualityReceiveTime,
|
OP20QualityReceiveTime = m.a.OP20QualityReceiveTime,
|
OP30QualityReceiveTime = m.a.OP30QualityReceiveTime,
|
OP35QualityReceiveTime = m.a.OP35QualityReceiveTime,
|
OP40QualityReceiveTime = m.a.OP40QualityReceiveTime,
|
OP60QualityReceiveTime = m.a.OP60QualityReceiveTime,
|
OP80QualityReceiveTime = m.a.OP80QualityReceiveTime,
|
OP10QualityState = m.a.OP10QualityState,
|
OP20QualityState = m.a.OP20QualityState,
|
OP30QualityState = m.a.OP30QualityState,
|
OP40QualityState = m.a.OP40QualityState,
|
OP35QualityState = m.a.OP35QualityState,
|
OP60QualityState = m.a.OP60QualityState,
|
OP80QualityState = m.a.OP80QualityState,
|
|
//新增OP80的一些质量数据 【Editby shaocx,2024 - 06 - 13】
|
QualityOP80_Houdu = m.a.QualityOP80_Houdu,
|
QualityOP80_ZXJ = m.a.QualityOP80_ZXJ,
|
QualityOP80_DTKYZD = m.a.QualityOP80_DTKYZD,
|
QualityOP80_XTSMYD = m.a.QualityOP80_XTSMYD,
|
QualityOP80_XTXMYD = m.a.QualityOP80_XTXMYD,
|
QualityOP80_D_TKZJ = m.a.QualityOP80_D_TKZJ,
|
QualityOP80_D_S_X = m.a.QualityOP80_D_S_X,
|
QualityOP80_D_S_Y = m.a.QualityOP80_D_S_Y,
|
QualityOP80_D_X_X = m.a.QualityOP80_D_X_X,
|
QualityOP80_D_X_Y = m.a.QualityOP80_D_X_Y,
|
QualityOP80_X_TKZJ = m.a.QualityOP80_X_TKZJ,
|
QualityOP80_X_S_X = m.a.QualityOP80_X_S_X,
|
QualityOP80_X_S_Y = m.a.QualityOP80_X_S_Y,
|
QualityOP80_X_X_X = m.a.QualityOP80_X_X_X,
|
QualityOP80_X_X_Y = m.a.QualityOP80_X_X_Y,
|
|
Remarks = m.a.Remarks,
|
UpdateTime = m.a.UpdatedTime,
|
})
|
.ProjectToType<QualityDataInfoOutput>()
|
.OrderByDescending(o => o.UpdateTime)
|
.ToListAsync()
|
;
|
|
MemoryStream ms = new();
|
List<string> headers = new List<string>();
|
List<List<object>> data = new List<List<object>>();
|
string sheetName = "";
|
|
switch (input.EquipmentID)
|
{
|
case "EOP10":
|
//var lstOP10 = EntityPropHelper.Mapper<QualityDataOP1040Output, QualityDataInfoOutput>(qualityDataInfos);
|
var lstOP10 = qualityDataInfos.Adapt<List<QualityDataOP1040Output>>();
|
DataConvertUtil.ToExcelData(lstOP10, _sysDictTypeRep, _sysDictDataRep, out headers,
|
out data, out sheetName);
|
break;
|
case "EOP20":
|
var lstOP20 = qualityDataInfos.Adapt<List<QualityDataOP20Output>>();
|
DataConvertUtil.ToExcelData(lstOP20, _sysDictTypeRep, _sysDictDataRep, out headers,
|
out data, out sheetName);
|
break;
|
case "EOP30":
|
var lstOP30 = qualityDataInfos.Adapt<List<QualityDataOP30Output>>();
|
|
DataConvertUtil.ToExcelData(lstOP30, _sysDictTypeRep, _sysDictDataRep, out headers,
|
out data, out sheetName);
|
break;
|
case "EOP35":
|
var lstOP35 = qualityDataInfos.Adapt<List<QualityDataOP35Output>>();
|
|
DataConvertUtil.ToExcelData(lstOP35, _sysDictTypeRep, _sysDictDataRep, out headers,
|
out data, out sheetName);
|
break;
|
case "EOP40":
|
break;
|
case "EOP60":
|
var lstOP60 = qualityDataInfos.Adapt<List<QualityDataOP60Output>>();
|
|
DataConvertUtil.ToExcelData(lstOP60, _sysDictTypeRep, _sysDictDataRep, out headers,
|
out data, out sheetName);
|
break;
|
case "EOP70":
|
break;
|
case "EOP80":
|
var lstOP80 = qualityDataInfos.Adapt<List<QualityDataOP80Output>>();
|
|
DataConvertUtil.ToExcelData(lstOP80, _sysDictTypeRep, _sysDictDataRep, out headers,
|
out data, out sheetName);
|
break;
|
default:
|
DataConvertUtil.ToExcelData(qualityDataInfos, _sysDictTypeRep, _sysDictDataRep, out headers,
|
out data, out sheetName);
|
break;
|
}
|
|
ExcelUtil.ToExcel(headers, data, sheetName, ms);
|
ms.Position = 0;
|
var fileName = HttpUtility.UrlEncode($"{sheetName}[{DateTimeOffset.Now:yyyy-MM-dd}].xlsx", Encoding.GetEncoding("UTF-8"));
|
return new FileStreamResult(ms, "application/octet-stream") { FileDownloadName = fileName };
|
}
|
|
}
|
}
|
