| | |
|---|
| | | a.SL as Sl, |
|---|
| | | a.FCHECK_BY as StatusUser, |
|---|
| | | a.FCHECK_RESU as Result, |
|---|
| | | a.TJ as Tj, |
|---|
| | | COALESCE(m.ITEM_NAME, '') as ItemName, |
|---|
| | | COALESCE(m.ITEM_MODEL, '') as ItemModel, |
|---|
| | | a.SL as WorkQty, |
|---|
| | |
|---|
| | | parameters.Add(new SugarParameter(":Id", queryObj.Id.Value)); |
|---|
| | | } |
|---|
| | | |
|---|
| | | // 根据状态筛选 |
|---|
| | | if (!string.IsNullOrEmpty(queryObj.Result)) |
|---|
| | | // 根据是否完成筛选（严格按TJ） |
|---|
| | | if (queryObj.Tj.HasValue) |
|---|
| | | { |
|---|
| | | if (queryObj.Result == "未完成") |
|---|
| | | { |
|---|
| | | sql += " AND a.FCHECK_RESU IS NULL"; |
|---|
| | | } |
|---|
| | | else if (queryObj.Result == "已完成") |
|---|
| | | { |
|---|
| | | sql += " AND a.FCHECK_RESU IS NOT NULL"; |
|---|
| | | } |
|---|
| | | if (queryObj.Tj.Value == 1) |
|---|
| | | sql += " AND a.TJ = 1"; |
|---|
| | | else |
|---|
| | | sql += " AND NVL(a.TJ,0) <> 1"; |
|---|
| | | } |
|---|
| | | |
|---|
| | | // 根据检验人筛选 |
|---|
