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
{
//多個教案的情形
}
}
}
