/// <summary>
/// 查询产线（分页）
/// </summary>
/// <param name="parm"></param>
/// <returns></returns>
public PagedInfo <ProductLineVM> QueryLinePages(ProductLineQueryDto parm)
{
var source = Db.Queryable <Base_ProductLine, Sys_DataRelation, Base_ProductProcess, Sys_DataRelation, Base_WorkShop, Sys_DataRelation, Base_Factory>((a, b, c, d, e, f, g) => 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,
JoinType.Inner, e.ID == f.Form,
JoinType.Inner, f.To == g.ID
})
.WhereIF(!string.IsNullOrEmpty(parm.QueryText), (a, b, c, d, e, f, g) => a.LineNo.Contains(parm.QueryText) || a.LineName.Contains(parm.QueryText))
.Select((a, b, c, d, e, f, g) => new ProductLineVM
{
ID = a.ID,
LineNo = a.LineNo,
LineName = a.LineName,
Remark = a.Remark,
Enable = a.Enable,
ProcessUID = c.ID,
ProcessNo = c.ProcessNo,
ProcessName = c.ProcessName,
WorkShopUID = e.ID,
WorkShopNo = e.WorkShopNo,
WorkShopName = e.WorkShopName,
FactoryUID = g.ID,
FactoryNo = g.FactoryNo,
FactoryName = g.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] ProductLineQueryDto parm)
{
var response = _lineService.QueryLinePages(parm);
return(toResponse(response));
}
