| | |
|---|
| | | |
|---|
| | | return db |
|---|
| | | .Queryable<QsQaItemXj, Womdaa, MesLine, |
|---|
| | | MesItems>((s, a, c, b) => |
|---|
| | | MesItems,Womcaa, ExZzCaaFiled>((s, a, c, b,ca,zf) => |
|---|
| | | new JoinQueryInfos( |
|---|
| | | JoinType.Inner, s.BillNo == a.Daa001, |
|---|
| | | JoinType.Left, a.Daa015 == c.LineNo, |
|---|
| | | JoinType.Left, s.ItemId == b.Id |
|---|
| | | JoinType.Left, s.ItemId == b.Id, |
|---|
| | | JoinType.Left, a.Daa021 == ca.Caa020, |
|---|
| | | JoinType.Left, ca.Erpid == zf.Erpid |
|---|
| | | ) |
|---|
| | | ) |
|---|
| | | .WhereIF(lineNo != null && lineNo.Length > 0, |
|---|
| | | (s, a, c, b) => lineNo.Contains(c.LineNo)) |
|---|
| | | (s, a, c, b, ca, zf) => lineNo.Contains(c.LineNo)) |
|---|
| | | .WhereIF( |
|---|
| | | StringUtil.IsNotNullOrEmpty(queryObj.result) && |
|---|
| | | "未完成".Equals(queryObj.result), |
|---|
| | | (s, a, c, b) => s.FcheckResu == null) |
|---|
| | | (s, a, c, b, ca, zf) => s.FcheckResu == null) |
|---|
| | | .WhereIF( |
|---|
| | | StringUtil.IsNotNullOrEmpty(queryObj.result) && |
|---|
| | | !"未完成".Equals(queryObj.result), |
|---|
| | | (s, a, c, b) => s.FcheckResu != null) |
|---|
| | | .WhereIF(id > 0, (s, a, c, b) => s.Id == id) |
|---|
| | | (s, a, c, b, ca, zf) => s.FcheckResu != null) |
|---|
| | | .WhereIF(id > 0, (s, a, c, b, ca, zf) => s.Id == id) |
|---|
| | | //加筛选条件,根据供应商，物料编码，物料名称搜索 |
|---|
| | | //.WhereIF(queryObj.SearchValue!=null && queryObj.SearchValue!="", (a) => a.SuppName == queryObj.SearchValue|| a.ItemName == queryObj.SearchValue || a.ItemNo == queryObj.SearchValue ) |
|---|
| | | .WhereIF(queryObj.SearchValue != null && queryObj.SearchValue != "", |
|---|
| | | (s,a,c,b) => (b.ItemName.ToLower().Contains(queryObj.SearchValue.ToLower()) |
|---|
| | | (s, a, c, b, ca, zf) => (b.ItemName.ToLower().Contains(queryObj.SearchValue.ToLower()) |
|---|
| | | || b.ItemNo.ToLower().Contains(queryObj.SearchValue.ToLower()))) |
|---|
| | | .Select((s, a, c, b) => new QsQaItemXj |
|---|
| | | .Select((s, a, c, b, ca, zf) => new QsQaItemXj |
|---|
| | | { |
|---|
| | | Daa020 = c.LineNo, |
|---|
| | | Id = s.Id, |
|---|
| | |
|---|
| | | ItemModel = b.ItemModel, |
|---|
| | | FcheckBy = s.FcheckBy, |
|---|
| | | FcheckResu = s.FcheckResu, |
|---|
| | | Caa015 = ca.Caa015, |
|---|
| | | cust = a.Cust == null ? zf.Cust : a.Cust, |
|---|
| | | Remarks = s.Remarks |
|---|
| | | }).OrderBy(s => s.CreateDate, OrderByType.Desc) |
|---|
| | | .ToPageList(queryObj.PageIndex, queryObj.Limit); |
|---|
