| | |
|---|
| | | |
|---|
| | | var qsItemOqcReqs = db |
|---|
| | | .Queryable<QsItemOqcReq, MesItems, MesInvItemIns, MesInvTransaction, |
|---|
| | | RKJDaa001, Womdaa, VLineUser,MesDeptUser>( |
|---|
| | | (a, b, c, ca, m, da, z,d) => new JoinQueryInfos( |
|---|
| | | RKJDaa001, Womdaa, VLineUser,MesDeptUser, Womcaa, ExZzCaaFiled>( |
|---|
| | | (a, b, c, ca, m, da, z,d, caa,zf) => new JoinQueryInfos( |
|---|
| | | JoinType.Left, a.ItemNo == b.ItemNo, |
|---|
| | | JoinType.Left, a.BillNo == c.BillNo, |
|---|
| | | JoinType.Left, |
|---|
| | |
|---|
| | | JoinType.Left, c.Id == m.ItemInId && a.ItemNo == m.ItemNo, |
|---|
| | | JoinType.Left, da.Daa001 == c.RbillNo, |
|---|
| | | JoinType.Left, da.Daa015 == z.LineNo, |
|---|
| | | JoinType.Left,c.Bgr == d.UserNo |
|---|
| | | JoinType.Left,c.Bgr == d.UserNo, |
|---|
| | | JoinType.Left, da.Daa021 == caa.Caa020, |
|---|
| | | JoinType.Left, caa.Erpid == zf.Erpid |
|---|
| | | )) |
|---|
| | | // .WhereIF(lineNo != null && lineNo.Length > 0, |
|---|
| | | // (a, b, c, ca, m, da) => lineNo.Contains(da.Daa015)) |
|---|
| | | .WhereIF(!"PL017".Equals(queryObj.createUser), |
|---|
| | | (a, b, c, ca, m, da, z,d) => lineNo.Contains(da.Daa015)) |
|---|
| | | (a, b, c, ca, m, da, z, d, caa, zf) => lineNo.Contains(da.Daa015)) |
|---|
| | | .WhereIF(!string.IsNullOrEmpty(queryObj.id), |
|---|
| | | (a, b, c, ca, m, da, z,d) => a.Id.ToString() == queryObj.id) |
|---|
| | | (a, b, c, ca, m, da, z, d, caa, zf) => a.Id.ToString() == queryObj.id) |
|---|
| | | .WhereIF( |
|---|
| | | StringUtil.IsNotNullOrEmpty(queryObj.result) && |
|---|
| | | "未完成".Equals(queryObj.result), |
|---|
| | | (a, b, c, ca, m, da, z,d) => a.FcheckResu == null) |
|---|
| | | (a, b, c, ca, m, da, z, d, caa, zf) => a.FcheckResu == null) |
|---|
| | | .WhereIF( |
|---|
| | | StringUtil.IsNotNullOrEmpty(queryObj.result) && |
|---|
| | | !"未完成".Equals(queryObj.result), |
|---|
| | | (a, b, c, ca, m, da, z,d) => a.FcheckResu != null) |
|---|
| | | (a, b, c, ca, m, da, z, d, caa, zf) => a.FcheckResu != null) |
|---|
| | | //加筛选条件,根据供应商，物料编码，物料名称搜索 |
|---|
| | | //.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 != "", |
|---|
| | | (a, b, c, ca, m, da, z, d) => b.ItemName.ToLower().Contains(queryObj.SearchValue.ToLower()) |
|---|
| | | (a, b, c, ca, m, da, z, d, caa, zf) => b.ItemName.ToLower().Contains(queryObj.SearchValue.ToLower()) |
|---|
| | | || a.ItemNo.ToLower().Contains(queryObj.SearchValue.ToLower())) |
|---|
| | | .Select((a, b, c, ca, m, da, z,d) => new QsItemOqcReq |
|---|
| | | .Select((a, b, c, ca, m, da, z, d, caa, zf) => new QsItemOqcReq |
|---|
| | | { |
|---|
| | | BillNo = a.BillNo, |
|---|
| | | Fsubmit = a.Fsubmit, |
|---|
| | |
|---|
| | | Daa015 = da.Daa015, |
|---|
| | | LineNo = c.LineNo, |
|---|
| | | Quantity = m.Quantity, |
|---|
| | | Caa015 = caa.Caa015, |
|---|
| | | cust = da.Cust == null ? zf.Cust : da.Cust, |
|---|
| | | Bgr = d.UserName |
|---|
| | | }) |
|---|
| | | .OrderBy(a => a.CreateDate, OrderByType.Desc) |
|---|
