/// <summary>
/// 查询设备（分页）
/// </summary>
/// <param name="parm"></param>
/// <returns></returns>
public PagedInfo <EquipmentVM> QueryEquipPages(EquipmentQueryDto parm)
{
var source = Db.Queryable <Base_Equipment, Sys_DataRelation, Base_ProductLine, Sys_DataRelation, Base_ProductProcess, Sys_DataRelation, Base_WorkShop, Sys_DataRelation, Base_Factory>((a, b, c, d, e, f, g, h, j) => new object[] {
JoinType.Inner, a.ID == b.Form,
JoinType.Inner, b.To == c.ID,
JoinType.Inner, c.ID == d.Form,
JoinType.Inner, d.To == e.ID,
JoinType.Inner, e.ID == f.Form,
JoinType.Inner, f.To == g.ID,
JoinType.Inner, g.ID == h.Form,
JoinType.Inner, h.To == j.ID,
})
.WhereIF(!string.IsNullOrEmpty(parm.QueryText), (a, b, c, d, e, f, g, h, j) => a.EquipNo.Contains(parm.QueryText) || a.EquipName.Contains(parm.QueryText))
.Select((a, b, c, d, e, f, g, h, j) => new EquipmentVM
{
ID = a.ID,
EquipNo = a.EquipNo,
EquipName = a.EquipName,
Remark = a.Remark,
Enable = a.Enable,
LineUID = c.ID,
LineNo = c.LineNo,
LineName = c.LineName,
ProcessUID = e.ID,
ProcessNo = e.ProcessNo,
ProcessName = e.ProcessName,
WorkShopUID = g.ID,
WorkShopNo = g.WorkShopNo,
WorkShopName = g.WorkShopName,
FactoryUID = j.ID,
FactoryNo = j.FactoryNo,
FactoryName = j.FactoryName,
CreateTime = a.CreateTime,
UpdateTime = a.UpdateTime,
CreateID = a.CreateID,
CreateName = a.CreateName,
UpdateID = a.UpdateID,
UpdateName = a.UpdateName
})
.MergeTable();
return(source.ToPage(new PageParm {
PageIndex = parm.PageIndex, PageSize = parm.PageSize, OrderBy = parm.OrderBy, Sort = parm.Sort
}));
}
public IActionResult Query([FromBody] EquipmentQueryDto parm)
{
var response = _equipmentService.QueryEquipPages(parm);
return(toResponse(response));
}
