private void apCgrid1_OnSort(NgridSortEventArgs ar) { string strSQL = string.Empty; if (ar.TimeSort) { strSQL = "SELECT tbAPC.SET_TIME, tbAPC.H_GLASSID, tbAPC.JOBID, tbAPC.RECIPE, tbAPC_Sub.P_PARM_NAME, tbAPC_Sub.P_PARM_VALUE, IIF(tbAPC.[APC_STATE]='1', 'Waiting', IIF(tbAPC.[APC_STATE]= '2', 'Running', IIF(tbAPC.[APC_STATE]='3', 'Done', '9'))) AS APC_STATE, tbAPC.Operation, tbAPC_Sub.isCenter FROM tbAPC INNER JOIN tbAPC_Sub ON tbAPC.[H_GLASSID] = tbAPC_Sub.[H_GLASSID] ORDER BY tbAPC.SET_TIME, tbAPC_Sub.P_PARM_NAME ASC;"; //, tbAPC_Sub.P_PARM_NAME } else { strSQL = "SELECT tbAPC.SET_TIME, tbAPC.H_GLASSID, tbAPC.JOBID, tbAPC.RECIPE, tbAPC_Sub.P_PARM_NAME, tbAPC_Sub.P_PARM_VALUE, IIF(tbAPC.[APC_STATE]='1', 'Waiting', IIF(tbAPC.[APC_STATE]= '2', 'Running', IIF(tbAPC.[APC_STATE]='3', 'Done', '9'))) AS APC_STATE, tbAPC.Operation, tbAPC_Sub.isCenter FROM tbAPC INNER JOIN tbAPC_Sub ON tbAPC.[H_GLASSID] = tbAPC_Sub.[H_GLASSID] ORDER BY tbAPC.APC_STATE DESC, tbAPC.SET_TIME, tbAPC_Sub.P_PARM_NAME ASC;"; //, tbAPC_Sub.P_PARM_NAME } DataTable dDataTable = DBAct.clsDBAct.funSelectQuery(strSQL); apcGrid.DataSource = dDataTable; }
private void apCgrid1_OnSort(NgridSortEventArgs ar) { string strSQL = string.Empty; if (ar.TimeSort) { strSQL = "SELECT tbPPC.SET_TIME, tbPPC.H_GLASSID, tbPPC.JOBID, tbPPC_Sub.P_MODULEID, tbPPC_Sub.P_ORDER, IIF(tbPPC_Sub.[P_STATE] ='1', 'Waiting', IIF(tbPPC_Sub.[P_STATE] = '2', 'Running', IIF(tbPPC_Sub.[P_STATE] = '3', 'Done', '9'))) AS P_STATE, tbPPC.Operation, tbPPC_Sub.isCenter, tbPPC.isRun FROM tbPPC INNER JOIN tbPPC_Sub ON tbPPC.[H_GLASSID] = tbPPC_Sub.[H_GLASSID] ORDER BY tbPPC.SET_TIME, tbPPC_Sub.P_ORDER ASC;"; } else { strSQL = "SELECT tbPPC.SET_TIME, tbPPC.H_GLASSID, tbPPC.JOBID, tbPPC_Sub.P_MODULEID, tbPPC_Sub.P_ORDER, IIF(tbPPC_Sub.[P_STATE] ='1', 'Waiting', IIF(tbPPC_Sub.[P_STATE] = '2', 'Running', IIF(tbPPC_Sub.[P_STATE] = '3', 'Done', '9'))) AS P_STATE, tbPPC.Operation, tbPPC_Sub.isCenter, tbPPC.isRun FROM tbPPC INNER JOIN tbPPC_Sub ON tbPPC.[H_GLASSID] = tbPPC_Sub.[H_GLASSID] ORDER BY tbPPC.isRun, tbPPC.SET_TIME, tbPPC_Sub.P_ORDER ASC;"; } DataTable dDataTable = DBAct.clsDBAct.funSelectQuery(strSQL); ppcGrid.DataSource = dDataTable; }
private void rpCgrid1_OnSort(NgridSortEventArgs ar) { string strSQL = string.Empty; if (ar.TimeSort) { strSQL = "SELECT tbRPC.SET_TIME, tbRPC.H_GLASSID, tbRPC.JOBID, tbRPC.RPC_PPID, tbRPC.ORIGINAL_PPID, IIF(tbRPC.[RPC_STATE] ='1', 'Waiting', IIF(tbRPC.[RPC_STATE] = '2', 'Running', IIF(tbRPC.[RPC_STATE] = '3', 'Done', '9'))) AS RPC_STATE, tbRPC.Operation FROM tbRPC ORDER BY tbRPC.SET_TIME ASC;"; } else { strSQL = "SELECT tbRPC.SET_TIME, tbRPC.H_GLASSID, tbRPC.JOBID, tbRPC.RPC_PPID, tbRPC.ORIGINAL_PPID, IIF(tbRPC.[RPC_STATE] ='1', 'Waiting', IIF(tbRPC.[RPC_STATE] = '2', 'Running', IIF(tbRPC.[RPC_STATE] = '3', 'Done', '9'))) AS RPC_STATE, tbRPC.Operation FROM tbRPC ORDER BY tbRPC.RPC_STATE DESC, tbRPC.SET_TIME ASC;"; } DataTable dDataTable = DBAct.clsDBAct.funSelectQuery(strSQL); rpcGrid.DataSource = dDataTable; }