/// <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)); }