| | |
|---|
| | | .WhereIF(UtilityHelper.CheckGuid(parsedGuid), |
|---|
| | | a => a.guid == parsedGuid ) |
|---|
| | | .Where(a => (a.fsubmit ?? 0) == 0) |
|---|
| | | .OrderByDescending(a => a.CreateDate) |
|---|
| | | // 使用 OrderBy 的多条件排序 |
|---|
| | | //.OrderBy(it => SqlFunc.IIF((it.fsubmit ?? 0) == 0, 0, 1)) |
|---|
| | | .OrderBy(it => SqlFunc.IIF((it.UrgentFlag ?? 0) == 1, 0, 1)) |
|---|
| | | .OrderByDescending(a => a.CreateDate) |
|---|
| | | .ToPageList(queryObj.PageIndex, queryObj.Limit, ref totalCount); |
|---|
| | | |
|---|
| | | return (pageList, totalCount); |
|---|
| | |
|---|
| | | GROUP BY [a].[guid], [a].[parent_guid], [a].[release_no], [a].[fac_level], [a].[fcheck_item], [a].[fcheck_tool], |
|---|
| | | [a].[fdown_allow], [a].[fcheck_level], [a].[fstand], [a].[fup_allow], [a].[sample_size_no], [a].[fspec_requ], |
|---|
| | | [a].[fre_qty], [a].[check_qyt], [a].[fcheck_resu], [a].[forder], [a].[ybsl] |
|---|
| | | ORDER BY [a].[forder] ASC", releaseNo); |
|---|
| | | ORDER BY [a].[forder] , [a].[GUID] ASC", releaseNo); |
|---|
| | | |
|---|
| | | var Ybsl_In = Db.Ado.SqlQuery<MesQaItemsDetectDetail5>(sql).ToList(); |
|---|
| | | |
|---|
