using PadApplication.DB;
|
using PadApplication.Entites.DbModels;
|
using PadApplication.Entites.Dto;
|
|
namespace PadApplication.Services;
|
|
/// <summary>
|
/// Womdaa数据管理类,负责工单相关数据的查询和处理
|
/// </summary>
|
public class WomdaaManager : Repository<Womdaa>
|
{
|
/// <summary>
|
/// 根据工程编号获取工单列表
|
/// </summary>
|
/// <param name="query">包含机器编号的查询条件</param>
|
/// <returns>工单列表,按模具ID分组后的第一条记录</returns>
|
public List<VOrder> GetWomdaasByEngineeringNo(OrderMachineDto query)
|
{
|
var list = VOrders(query);
|
var vOrders = list.GroupBy(p => p.moldId)
|
.Select(g => g.First()).ToList();
|
return vOrders;
|
}
|
|
/// <summary>
|
/// 获取工单基础数据
|
/// </summary>
|
/// <param name="query">包含机器编号的查询条件</param>
|
/// <returns>合并后的工单列表</returns>
|
private List<VOrder> VOrders(OrderMachineDto query)
|
{
|
// 查询未完工且实际数量不等于计划数量的工单
|
var list = Db.Queryable<VOrder>()
|
.Where(s => s.Daa018 != "完工" &&
|
s.MachineNo == query.machineNo
|
&& s.Daa011 != s.Daa008
|
)
|
.Select<VOrder>(s => new VOrder
|
{
|
ID = s.ID,
|
moldId = s.moldId,
|
moldName = s.moldName,
|
moldModel = s.moldModel
|
})
|
.ToList();
|
|
// 查询指定机器的工单
|
var orders = Db.Queryable<VOrderA>()
|
.Where(s => s.MachineNo == query.machineNo)
|
.Select<VOrder>(s => new VOrder
|
{
|
ID = s.Id,
|
moldId = s.moldId,
|
moldName = s.moldName,
|
moldModel = s.moldModel
|
})
|
.ToList();
|
|
list.AddRange(orders);
|
return list;
|
}
|
|
/// <summary>
|
/// 根据机器编号和工程编号获取工单列表
|
/// </summary>
|
/// <param name="query">
|
/// 包含机器编号（machineNo）和工程编号（engineeringNo）的查询条件
|
/// </param>
|
/// <returns>
|
/// 返回符合条件的工单（VOrder）列表
|
/// </returns>
|
public List<VOrder> 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.moldId == query.engineeringNo).ToList();
|
|
// 获取筛选后工单的ID集合
|
var ids = vOrders.Select(s => s.ID).ToArray();
|
|
// 查询V_ORDER视图，筛选条件：
|
// 1. 机台编号等于传入的machineNo
|
// 2. 编辑日期为今天或为空
|
// 3. 工单ID在ids集合中
|
return Db.Queryable<VOrder>()
|
.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<VOrder> GetWomdaasByShow(OrderMachineDto query)
|
{
|
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");
|
|
return Db.Queryable<VOrder>()
|
.Where(c =>
|
decimals.Contains(c.ID) &&
|
(c.EditDate == date || c.EditDate == null))
|
.ToList();
|
}
|
|
/// <summary>
|
/// 根据工单ID获取工单详细信息
|
/// </summary>
|
/// <param name="query">包含工单ID和工单号的查询条件</param>
|
/// <returns>工单详细信息</returns>
|
public VOrder GetWomdaaById(OrderMachineDto query)
|
{
|
var date = DateTime.Now.ToString("yyyy-MM-dd");
|
|
var count = Db.Queryable<DeviceStatus>()
|
.Where(b => b.OrderNo == query.orderNo && b.EditDate == date)
|
.Count();
|
|
var vOrder = Db.Queryable<VOrder>()
|
.Where(s => s.ID == query.OrderId)
|
.WhereIF(count > 0, s => s.EditDate == date)
|
.OrderByDescending(s => s.workStartDate).First();
|
|
if (vOrder == null) return null;
|
|
vOrder.YJQTY ??= 0;
|
|
var mesOrderSelect = Db.Queryable<MesOrderSelect>()
|
.Where(a => a.OrderId == vOrder.ID
|
&& a.IsShow == 0).First();
|
|
vOrder.todayRunTime = 0;
|
vOrder.TodayFaultNum = 0;
|
|
if (mesOrderSelect != null)
|
{
|
vOrder.todayRunTime = mesOrderSelect.TjTime;
|
vOrder.TodayFaultNum = mesOrderSelect.TjCount;
|
|
if (mesOrderSelect.TjTime is null or 0)
|
{
|
vOrder.JDL = 100;
|
}
|
else
|
{
|
var round = Math.Round(mesOrderSelect.TjTime.Value / 1440, 2);
|
var round1 = (1 - round) * 100;
|
vOrder.JDL = round1;
|
}
|
}
|
|
vOrder.wjQty = vOrder.Daa008 - vOrder.Daa011;
|
|
//DevMachine
|
var devMachine = Db.Queryable<DevMacBycl>()
|
.Where(s => s.MachineNo == vOrder.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);
|
|
vOrder.finalResult = sqlQuerySingle;
|
|
return vOrder;
|
}
|
|
/// <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();
|
vPrint.RmiPrQty =
|
(int)Math.Ceiling(
|
(double)((vPrint.Bqty - vPrint.SQuantity) / vPrint.Qqty));
|
return vPrint;
|
}
|
}
|
