using MES.Service.DB;
|
using MES.Service.Modes;
|
using SqlSugar;
|
|
namespace MES.Service.service.QC;
|
|
public class SuspendService
|
{
|
private readonly string[] statusArray = ["开工", "待开工"];
|
|
public List<SysDepartment> getDept()
|
{
|
var db = SqlSugarHelper.GetInstance();
|
//return db.Queryable<SysDepartment>().ToList();
|
return db
|
.Queryable<Womdaa, MesLine, QsQaItemXj,
|
SysDepartment>((a, b, c, d) =>
|
new JoinQueryInfos(JoinType.Left,
|
a.Daa002 == b.Id.ToString(),
|
JoinType.Inner, a.Daa001 == c.BillNo,
|
JoinType.Left, b.Departmentcode == d.Departmentcode))
|
.Where((a, b, c, d) => b.LineName != null &&
|
statusArray.Contains(a.Daa018))
|
.GroupBy((a, b, c, d) => new
|
{
|
b.Departmentcode,
|
d.Departmentname
|
})
|
.Select((a, b, c, d) => new SysDepartment
|
{
|
Departmentcode = b.Departmentcode,
|
Departmentname = d.Departmentname
|
}).ToList();
|
}
|
|
public List<MesLine> GetLines(string deptCode)
|
{
|
var db = SqlSugarHelper.GetInstance();
|
var mesLines = db.Queryable<Womdaa, MesLine, QsQaItemXj>((a, b, c) =>
|
new JoinQueryInfos(JoinType.Left,
|
a.Daa002 == b.Id.ToString(),
|
JoinType.Inner, a.Daa001 == c.BillNo))
|
.Where((a, b, c) => b.LineName != null &&
|
statusArray.Contains(a.Daa018)
|
&& b.Departmentcode == deptCode)
|
.GroupBy((a, b, c) => new
|
{
|
b.LineNo,
|
b.LineName
|
})
|
.Select((a, b, c) => new MesLine
|
{
|
LineNo = b.LineNo,
|
LineName = b.LineName
|
}).ToList();
|
|
var mesQsSuspends = db.Queryable<MesQsSuspend>()
|
.Where(s => s.IsSuspend == 0).ToList();
|
|
return mesLines.Where(p => mesQsSuspends.All(e => e.LineNo != p.LineNo))
|
.ToList();
|
}
|
|
public int save(MesQsSuspend entity)
|
{
|
entity.CreateDate = DateTime.Now;
|
return SqlSugarHelper.UseTransactionWithOracle(db =>
|
db.Insertable(entity).ExecuteCommand());
|
}
|
|
public List<MesQsSuspend> getAllByDeptNo(string deptNo)
|
{
|
var db = SqlSugarHelper.GetInstance();
|
return db.Queryable<MesQsSuspend>()
|
.Where(a => a.DeptNo == deptNo && a.IsSuspend == 0).ToList();
|
}
|
|
public List<MesQsSuspend> getOpenDept()
|
{
|
var db = SqlSugarHelper.GetInstance();
|
return db.Queryable<MesQsSuspend>().GroupBy(a => new
|
{
|
a.DeptNo,
|
a.DeptName
|
}).Select<MesQsSuspend>(a => new MesQsSuspend
|
{
|
DeptNo = a.DeptNo,
|
DeptName = a.DeptName
|
}).ToList();
|
}
|
|
public List<MesQsSuspend> getOpenLine(string deptNo)
|
{
|
var db = SqlSugarHelper.GetInstance();
|
return db.Queryable<MesQsSuspend>()
|
.Where(a => a.DeptNo == deptNo && a.IsSuspend == 0)
|
.GroupBy(a => new
|
{
|
a.LineNo,
|
a.LineName
|
}).Select<MesQsSuspend>(a => new MesQsSuspend
|
{
|
LineNo = a.LineNo,
|
LineName = a.LineName
|
}).ToList();
|
}
|
|
public int UpdateById(MesQsSuspend entity)
|
{
|
return SqlSugarHelper.UseTransactionWithOracle(db =>
|
{
|
return db.Updateable<MesQsSuspend>()
|
.SetColumns(a => a.IsSuspend == entity.IsSuspend)
|
.SetColumns(a => a.OpenDate == DateTime.Now)
|
.SetColumns(a => a.TimeDifference == entity.TimeDifference)
|
.Where(a => a.Id == entity.Id)
|
.ExecuteCommand();
|
});
|
}
|
}
|
