| | |
|---|
| | | // 添加评审状态 |
|---|
| | | PSZT = a.PSZT |
|---|
| | | }) |
|---|
| | | .OrderBy("CASE WHEN EMERGENCY = 1 THEN 0 ELSE 1 END, CASE WHEN STATUS = '已提交' THEN 0 ELSE 1 END, IQC_DATE desc, ID asc") |
|---|
| | | .OrderBy("CASE WHEN EMERGENCY = 1 AND STATUS = '未提交' THEN 0 ELSE 1 END, CASE WHEN STATUS = '未提交' AND (SELECT COUNT(*) FROM MES_QA_ITEMS_DETECT_DETAIL5 WHERE RELEASE_NO = A.RELEASE_NO) = 0 THEN 0 ELSE 1 END, CASE WHEN STATUS = '未提交' THEN A.CREATE_DATE ASC ELSE NULL END, CASE WHEN STATUS = '已提交' THEN A.IQC_DATE DESC ELSE NULL END") |
|---|
| | | .ToPageList(queryObj.PageIndex, queryObj.Limit, ref totalCount); |
|---|
| | | |
|---|
| | | // 批量获取检验项目数量，避免N+1查询问题 |
|---|
| | |
|---|
| | | FcheckItemDesc = a.FspecRequ, |
|---|
| | | Funit = a.Funit, |
|---|
| | | Meom = a.Meom, |
|---|
| | | }).ToList(); |
|---|
| | | }).OrderBy(a => SqlFunc.IIF(a.Fstand != null, 0, 1)).OrderBy(a => a.FcheckItem, OrderByType.Desc).ToList(); |
|---|
| | | } |
|---|
| | | |
|---|
| | | public int SetQSItemDetail(MesQaItemsDetectDetail12 detail) |
|---|
