using PadApplication.DB;
|
using PadApplication.Entites.DbModels;
|
using PadApplication.Entites.Dto;
|
using SqlSugar;
|
|
namespace PadApplication.Services;
|
|
/// <summary>
|
/// Womdaa数据管理类,负责工单相关数据的查询和处理
|
/// </summary>
|
public class WomdaaManager : Repository<Womdaa>
|
{
|
/// <summary>
|
/// 根据工程编号和工单状态获取工单列表
|
/// </summary>
|
/// <param name="query">包含机器编号和工单状态的查询条件</param>
|
/// <returns>工单列表</returns>
|
public List<VOrderBycl> GetWomdaasByEngineeringNo(OrderMachineDto query)
|
{
|
var list = VOrders(query);
|
|
// 按工单状态筛选
|
if (query.OrderStatus != null && query.OrderStatus.Any())
|
{
|
list = list.Where(p => p.Daa018 != null && query.OrderStatus.Contains(p.Daa018)).ToList();
|
}
|
|
//// 分组逻辑（如需分组，按刀具ID分组取第一条）
|
//var vOrders = list.GroupBy(p => p.cutterId)
|
// .Select(g => g.First()).ToList();
|
|
//return vOrders;
|
// 如需分组可加分组逻辑，否则直接返回
|
return list;
|
}
|
|
/// <summary>
|
/// 获取工单基础数据
|
/// </summary>
|
/// <param name="query">包含机器编号的查询条件</param>
|
/// <returns>合并后的工单列表</returns>
|
private List<VOrderBycl> VOrders(OrderMachineDto query)
|
{
|
var list = Db.Queryable<VOrderBycl>()
|
.Where(s => s.Daa018 != "完工" &&
|
s.MachineNo == query.machineNo)
|
.ToList();
|
|
var orders = Db.Queryable<VOrderABycl>()
|
.Where(s => s.MachineNo == query.machineNo)
|
.Select<VOrderBycl>()
|
.ToList();
|
|
list.AddRange(orders);
|
return list;
|
}
|
|
/// <summary>
|
/// 根据机器编号和工程编号获取工单列表
|
/// </summary>
|
/// <param name="query">
|
/// 包含机器编号（machineNo）和工程编号（engineeringNo）的查询条件
|
/// </param>
|
/// <returns>
|
/// 返回符合条件的工单（VOrdreBycl）列表
|
/// </returns>
|
public List<VOrderBycl> GetWomdaasByMachine(OrderMachineDto query)
|
{
|
// 获取当前日期字符串，格式为 yyyy-MM-dd
|
var date = DateTime.Now.ToString("yyyy-MM-dd");
|
|
// 获取指定机器下未完工且实际数量不等于计划数量的工单（合并VOrder和VOrderA）
|
var list = VOrders(query);
|
// 根据工程编号（engineeringNo）筛选出对应的工单（moldId == engineeringNo）
|
var vOrders = list.Where(s => s.cutterId == query.engineeringNo).ToList();
|
// 获取筛选后工单的ID集合
|
var ids = vOrders.Select(s => s.ID).ToArray();
|
|
// 查询V_ORDER视图，筛选条件：
|
// 1. 机台编号等于传入的machineNo
|
// 2. 编辑日期为今天或为空
|
// 3. 工单ID在ids集合中
|
return Db.Queryable<VOrderBycl>()
|
.Where(s =>
|
s.MachineNo == query.machineNo
|
&& (s.EditDate == date || s.EditDate == null)
|
&& ids.Contains(s.ID))
|
.ToList();
|
}
|
|
/// <summary>
|
/// 获取需要显示的工单列表
|
/// </summary>
|
/// <param name="query">包含机器编号的查询条件</param>
|
/// <returns>需要显示的工单列表</returns>
|
public List<VOrderBycl> GetWomdaasByShow(OrderMachineDto query)
|
{
|
// 查询需要显示的工单ID
|
var ids = Db.Queryable<MesOrderSelect>()
|
.Where(b => b.MachineNo == query.machineNo
|
&& b.IsShow == 0)
|
.Select(s => s.OrderId)
|
.ToList();
|
|
// 去重
|
var decimals = ids.Distinct().ToList();
|
var date = DateTime.Now.ToString("yyyy-MM-dd");
|
|
// 如果没有工单ID，直接返回空列表
|
if (decimals.Count == 0)
|
return new List<VOrderBycl>();
|
|
// 查询工单视图，筛选出需要显示的工单
|
return Db.Queryable<VOrderBycl>()
|
.Where(c =>
|
decimals.Contains(c.ID) &&
|
(c.EditDate == date || c.EditDate == null))
|
.ToList();
|
}
|
|
/// <summary>
|
/// 根据工单ID获取工单详细信息
|
/// </summary>
|
/// <param name="query">包含工单ID和工单号的查询条件</param>
|
/// <returns>工单详细信息</returns>
|
public VOrderBycl GetWomdaaById(OrderMachineDto query)
|
{
|
var date = DateTime.Now.ToString("yyyy-MM-dd");
|
|
var count = Db.Queryable<DeviceStatusBycl>()
|
.Where(b => b.OrderNo == query.orderNo && b.EditDate == date)
|
.Count();
|
|
var VOrdrerBycl = Db.Queryable<VOrderBycl>()
|
.Where(s => s.ID == query.OrderId)
|
.WhereIF(count > 0, s => s.EditDate == date)
|
.OrderByDescending(s => s.workStartDate).First();
|
|
if (VOrdrerBycl == null) return null;
|
|
VOrdrerBycl.YJQTY ??= 0;
|
|
var mesOrderSelect = Db.Queryable<MesOrderSelect>()
|
.Where(a => a.OrderId == VOrdrerBycl.ID
|
&& a.IsShow == 0).First();
|
|
VOrdrerBycl.todayRunTime = 0;
|
VOrdrerBycl.TodayFaultNum = 0;
|
|
if (mesOrderSelect != null)
|
{
|
VOrdrerBycl.todayRunTime = mesOrderSelect.TjTime;
|
VOrdrerBycl.TodayFaultNum = mesOrderSelect.TjCount;
|
|
if (mesOrderSelect.TjTime is null or 0)
|
{
|
VOrdrerBycl.JDL = 100;
|
}
|
else
|
{
|
var round = Math.Round(mesOrderSelect.TjTime.Value / 1440, 2);
|
var round1 = (1 - round) * 100;
|
VOrdrerBycl.JDL = round1;
|
}
|
}
|
|
VOrdrerBycl.wjQty = VOrdrerBycl.Daa008 - VOrdrerBycl.Daa011;
|
|
//DevMachine
|
var devMachine = Db.Queryable<DevMacBycl>()
|
.Where(s => s.MachineNo == VOrdrerBycl.MachineNo)
|
.First();
|
|
|
var sql = string.Format(
|
"select FINAL_RESULT from MES_EQ_SPOT_CHECKS where department_no = 'XS0101' and EQ_NO = '{0}' and substr(SUBMIT_DATE, 1, 10) = to_char(sysdate, 'yyyy-mm-dd')",
|
devMachine.UniqueBarcode);
|
|
var sqlQuerySingle = Db.Ado.SqlQuerySingle<string>(sql);
|
|
VOrdrerBycl.finalResult = sqlQuerySingle;
|
|
return VOrdrerBycl;
|
}
|
|
/// <summary>
|
/// 根据工单ID获取报工信息
|
/// </summary>
|
/// <param name="query">包含工单ID的查询条件</param>
|
/// <returns>工单报工信息</returns>
|
public VPrint GetWomdaaPrintById(OrderMachineDto query)
|
{
|
var vPrint = Db.Queryable<VPrint>()
|
.Where(s => s.Id == query.OrderId)
|
.First();
|
|
if (vPrint == null)
|
return null;
|
|
// 防止除零和空值异常
|
var bqty = vPrint.Bqty ?? 0;
|
var sQuantity = vPrint.SQuantity ?? 0;
|
var qqty = vPrint.Qqty ?? 0;
|
|
if (qqty == 0)
|
{
|
vPrint.RmiPrQty = 0;
|
}
|
else
|
{
|
// 剩余可打印张数 = (可打印总数量 - 已打印数量) / 标准包装数，向上取整
|
var remain = bqty - sQuantity;
|
vPrint.RmiPrQty = remain > 0 ? (int)Math.Ceiling((double)remain / (double)qqty) : 0;
|
}
|
|
return vPrint;
|
}
|
|
public (List<MesReportingBgDto> tbBillList, int totalCount) GetByBillNoBG(
|
string billNo, string machineNo, DateTime? from, DateTime? to, int pageIndex, int pageSize)
|
{
|
var query = Db.Queryable<MesReporting>()
|
.Where(x => x.BillNo == billNo);
|
|
if (!string.IsNullOrWhiteSpace(machineNo))
|
query = query.Where(x => x.MachineNo == machineNo);
|
|
if (from.HasValue)
|
query = query.Where(x => x.BgDate >= from.Value);
|
|
if (to.HasValue)
|
query = query.Where(x => x.BgDate < to.Value.AddDays(1));
|
|
var totalCount = query.Count();
|
|
var tbBillList = query.OrderBy(x => x.BgDate, OrderByType.Desc)
|
.Select(x => new MesReportingBgDto
|
{
|
Id = (long)x.Id,
|
BillNo = x.BillNo,
|
ItemNo = x.ItemNo,
|
MachineNo = x.MachineNo,
|
StaffNo = x.BgPerson,
|
StaffName = x.BgPerson, // 如有独立姓名字段可替换
|
BgDate = x.BgDate,
|
KgQty = SqlFunc.ToInt32(x.CjQty),
|
InitialValue = SqlFunc.ToInt32(x.CsQty),
|
ProductionCount = SqlFunc.ToInt32(x.CjQty),
|
SQuantity = SqlFunc.ToInt32(x.OkQty),
|
OkQty = SqlFunc.ToInt32(x.OkQty),
|
NgQty = SqlFunc.ToInt32(x.BfQty)
|
})
|
.ToPageList((pageIndex < 1 ? 1 : pageIndex), (pageSize < 1 ? 200 : (pageSize > 1000 ? 1000 : pageSize)), ref totalCount);
|
|
return (tbBillList, totalCount);
|
}
|
}
|
