/// <summary>
/// 查询工序（分页）
/// </summary>
/// <param name="parm"></param>
/// <returns></returns>
public PagedInfo <ProductProcessVM> QueryProcessPages(ProductProcessQueryDto parm)
{
var source = Db.Queryable <Base_ProductProcess, Sys_DataRelation, Base_WorkShop, Sys_DataRelation, Base_Factory>((a, b, c, d, e) => 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
})
.WhereIF(!string.IsNullOrEmpty(parm.QueryText), (a, b, c, d, e) => a.ProcessNo.Contains(parm.QueryText) || a.ProcessName.Contains(parm.QueryText))
.Select((a, b, c, d, e) => new ProductProcessVM
{
ID = a.ID,
ProcessNo = a.ProcessNo,
ProcessName = a.ProcessName,
Remark = a.Remark,
Enable = a.Enable,
WorkShopUID = c.ID,
WorkShopNo = c.WorkShopNo,
WorkShopName = c.WorkShopName,
FactoryUID = e.ID,
FactoryNo = e.FactoryNo,
FactoryName = e.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] ProductProcessQueryDto parm)
{
var response = _processService.QueryProcessPages(parm);
return(toResponse(response));
}
