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