/// <summary> /// 查询产线(分页) /// </summary> /// <param name="parm"></param> /// <returns></returns> public PagedInfo <ProductLineVM> QueryLinePages(ProductLineQueryDto parm) { var source = Db.Queryable <Base_ProductLine, Sys_DataRelation, Base_ProductProcess, Sys_DataRelation, Base_WorkShop, Sys_DataRelation, Base_Factory>((a, b, c, d, e, f, g) => 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 }) .WhereIF(!string.IsNullOrEmpty(parm.QueryText), (a, b, c, d, e, f, g) => a.LineNo.Contains(parm.QueryText) || a.LineName.Contains(parm.QueryText)) .Select((a, b, c, d, e, f, g) => new ProductLineVM { ID = a.ID, LineNo = a.LineNo, LineName = a.LineName, Remark = a.Remark, Enable = a.Enable, ProcessUID = c.ID, ProcessNo = c.ProcessNo, ProcessName = c.ProcessName, WorkShopUID = e.ID, WorkShopNo = e.WorkShopNo, WorkShopName = e.WorkShopName, FactoryUID = g.ID, FactoryNo = g.FactoryNo, FactoryName = g.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] ProductLineQueryDto parm) { var response = _lineService.QueryLinePages(parm); return(toResponse(response)); }