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