private void setupDurationContent(Table table) { //依照不同Function呼叫不同的Function string strSQL = ""; switch (strFunction) { case "0": //Author,Case , Class strSQL = mySQL.getCaseClassDuration(strPaperID, strCaseID, strClass); break; case "1": //Author , Case , Group strSQL = mySQL.getCaseGroupDuration(strPaperID, strCaseID, strGroup); break; case "2": //Author , Case strSQL = mySQL.getCaseDuration(strPaperID, strCaseID); break; case "3": //Author , Class //strSQL = mySQL.getSelectionSummaryByAuthorClass(strPaperID , strQID , strSelectionID , strAuthorID , strClass); break; case "4": //Author , Group //strSQL = mySQL.getSelectionSummaryByAuthorGroup(strPaperID , strQID , strSelectionID , strAuthorID , strGroup); break; case "5": //Author //strSQL = mySQL.getSelectionSummaryByAuthor(strPaperID , strQID , strSelectionID , strAuthorID); break; case "6": //Case , Class strSQL = mySQL.getCaseClassDuration(strPaperID, strCaseID, strClass); break; case "7": //Case , Group strSQL = mySQL.getCaseGroupDuration(strPaperID, strCaseID, strGroup); break; case "8": //Case strSQL = mySQL.getCaseDuration(strPaperID, strCaseID); break; case "9": //Class //strSQL = mySQL.getSelectionSummaryByClass(strPaperID , strQID , strSelectionID , strClass); break; case "10": //Group //strSQL = mySQL.getSelectionSummaryByGroup(strPaperID , strQID , strSelectionID , strGroup); break; } if (strSQL.Trim().Length == 0) { tdDurationTable.Controls.Clear(); } else { if (strFunction == "0" || strFunction == "1" || strFunction == "2" || strFunction == "6" || strFunction == "7" || strFunction == "8") { //只有單一教案的情形 setupSingleCaseDuration(strSQL, table); } else { //多個教案的情形 } } }