| | |
|---|
| | | WHERE C.parent_guid = A.guid), 0) AS [YbslIn] |
|---|
| | | FROM [MES_QA_ITEMS_DETECT_DETAIL5] [a] |
|---|
| | | Left JOIN [MES_QA_ITEMS_DETECT_DETAIL12] [b] ON ([a].[guid] = [b].[parent_guid]) |
|---|
| | | WHERE ([a].[release_no] = N'{0}' AND IS_GWSCAN = 1) |
|---|
| | | WHERE ([a].[release_no] = N'{0}') |
|---|
| | | 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], [a].stationName, |
|---|
| | | [a].IS_GWSCAN |
|---|
| | | ORDER BY [a].[forder] ASC", releaseNo); |
|---|
| | | ORDER BY [a].[forder] , [a].[fcheck_item] ASC", releaseNo); |
|---|
| | | |
|---|
| | | var Ybsl_In = Db.Ado.SqlQuery<dynamic>(sql).ToList(); |
|---|
| | | |
|---|
