/// <summary> /// 查询车间(分页) /// </summary> /// <param name="parm"></param> /// <returns></returns> public PagedInfo <WorkShopVM> QueryWorkShopPages(WorkShopQueryDto parm) { var source = Db.Queryable <Base_WorkShop, Sys_DataRelation, Base_Factory>((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.WorkShopNo.Contains(parm.QueryText) || a.WorkShopName.Contains(parm.QueryText)) .Select((a, b, c) => new WorkShopVM { ID = a.ID, WorkShopNo = a.WorkShopNo, WorkShopName = a.WorkShopName, Remark = a.Remark, Enable = a.Enable, FactoryUID = c.ID, FactoryNo = c.FactoryNo, FactoryName = c.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] WorkShopQueryDto parm) { var response = _workShopService.QueryWorkShopPages(parm); return(toResponse(response)); }