/// <summary> /// 查询工厂(分页) /// </summary> /// <param name="parm"></param> /// <param name="Async"></param> /// <returns></returns> public PagedInfo <FactoryVM> QueryFactoryPages(FactoryQueryDto parm) { var source = Db.Queryable <Base_Factory, Sys_DataRelation, Base_Company>((a, b, c) => new object[] { JoinType.Inner, a.ID == b.Form, JoinType.Inner, b.To == c.ID, }).WhereIF(!string.IsNullOrEmpty(parm.QueryText), (a, b, c) => a.FactoryName.Contains(parm.QueryText) || a.FactoryNo.Contains(parm.QueryText)) .Select((a, b, c) => new FactoryVM { ID = a.ID, FactoryNo = a.FactoryNo, FactoryName = a.FactoryName, Remark = a.Remark, Enable = a.Enable, CompanyUID = c.ID, CompanyNo = c.CompanyNo, CompanyName = c.CompanyName, 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] FactoryQueryDto parm) { var response = _factoryService.QueryFactoryPages(parm); return(toResponse(response)); }