using PadApplication.DB;
|
using PadApplication.Entites.DbModels;
|
using PadApplication.Entites.Dto;
|
|
namespace PadApplication.Services;
|
|
/// <summary>
|
/// 工单选择管理类,负责工单选择相关的数据操作
|
/// 继承自Repository<MesOrderSelect>基类,包含基础的CRUD操作
|
/// </summary>
|
public class MesOrderSelectManager : Repository<MesOrderSelect>
|
{
|
private readonly WomdaaManager _womdaaManager = new();
|
|
|
public bool AddMesOrderSelect(OrderSelectDto dto)
|
{
|
var query = new OrderMachineDto
|
{
|
machineNo = dto.MachineNo
|
};
|
var womdaasByShow = _womdaaManager.GetWomdaasByShow(query);
|
var date = DateTime.Now.ToString("yyyy-MM-dd");
|
foreach (var vOrder in womdaasByShow)
|
{
|
var count = Db.Queryable<MesOrderSelect>()
|
.Where(s => s.OrderId == vOrder.ID
|
&& s.EditDate == date).Count();
|
|
if (count > 0) continue;
|
|
// 设置基础信息
|
var mesOrderSelect = new MesOrderSelect
|
{
|
OrderId = vOrder.ID,
|
OrderNo = vOrder.Daa001,
|
EditDate = date,
|
MachineNo = dto.MachineNo,
|
IsShow = 0,
|
TjCount = 0,
|
TjTime = 0
|
};
|
|
// 插入记录,如果失败则返回false
|
if (!Insert(mesOrderSelect)) return false;
|
}
|
|
return true;
|
}
|
|
/// <summary>
|
/// 添加工单选择记录
|
/// </summary>
|
/// <param name="dto">工单选择数据传输对象,包含工单列表和基础信息</param>
|
/// <returns>添加是否成功</returns>
|
public bool Add(OrderSelectDto dto)
|
{
|
// 先删除该机器的现有选择记录
|
Remove(dto);
|
|
// 获取第一个工单的工单号
|
var orderNo = dto.Item[0].OrderNo;
|
var query = new OrderMachineDto();
|
query.orderNo = orderNo;
|
|
// 检查是否为新工单
|
var isN = isNew(query);
|
|
// 遍历工单列表,添加每个工单的选择记录
|
foreach (var mesOrderSelect in dto.Item)
|
{
|
var count = Db.Queryable<MesOrderSelect>()
|
.Where(s => s.OrderId == mesOrderSelect.OrderId
|
&& s.EditDate == dto.EditDate).Count();
|
|
if (count > 0)
|
{
|
Db.Updateable<MesOrderSelect>()
|
.SetColumns(s => s.IsShow == 0)
|
.Where(s => s.OrderId == mesOrderSelect.OrderId
|
&& s.EditDate == dto.EditDate)
|
.ExecuteCommand();
|
}
|
else
|
{
|
// 设置基础信息
|
mesOrderSelect.EditDate = dto.EditDate;
|
mesOrderSelect.MachineNo = dto.MachineNo;
|
mesOrderSelect.IsShow = 0;
|
mesOrderSelect.TjCount = 0;
|
mesOrderSelect.TjTime = 0;
|
|
// 插入记录,如果失败则返回false
|
if (!Insert(mesOrderSelect)) return false;
|
}
|
|
var womdaa = Db.Queryable<Womdaa>()
|
.Where(s => s.Daa001 == mesOrderSelect.OrderNo).First();
|
|
if (womdaa == null) continue;
|
|
var equals = womdaa.Daa018.Equals("暂停");
|
|
//// 更新工单状态表中的换模开始时间
|
//Db.Updateable<MesOrderSta>()
|
// .SetColumnsIF(equals, s => s.MaShoutTime == null)
|
// .SetColumnsIF(equals, s => s.MaEndTime == null)
|
// .Where(s => s.OrderNo == mesOrderSelect.OrderNo)
|
// .ExecuteCommand();
|
}
|
|
return isN;
|
}
|
|
/// <summary>
|
/// 删除指定机器的工单选择记录
|
/// </summary>
|
/// <param name="dto">包含机器编号的数据传输对象</param>
|
/// <returns>删除的记录数</returns>
|
public int Remove(OrderSelectDto dto)
|
{
|
// 删除该机器所有未显示的工单选择记录
|
return Db.Deleteable<MesOrderSelect>()
|
.Where(s => s.MachineNo == dto.MachineNo
|
&& s.IsShow == 0)
|
.ExecuteCommand();
|
}
|
|
/// <summary>
|
/// 检查是否为新工单
|
/// </summary>
|
/// <param name="query">包含工单号的查询条件</param>
|
/// <returns>true表示是新工单,false表示已存在</returns>
|
public bool isNew(OrderMachineDto query)
|
{
|
// 获取当前日期
|
var date = DateTime.Now.ToString("yyyy-MM-dd");
|
|
// 查询当天是否存在该工单的选择记录
|
var count = Db.Queryable<MesOrderSelect>()
|
.Where(s => s.OrderNo == query.orderNo
|
&& s.EditDate == date).Count();
|
|
// 如果记录数为0,则为新工单
|
return count <= 0;
|
}
|
}
|
