public void MyGetBankList()
{
TreeView1.Nodes.Clear();
DataTable datatable = QuestionBankManage.GetBankList();
if (datatable.Rows.Count > 0)
{
foreach (DataRow row in datatable.Rows)
{
string sId = row["BankId"].ToString();
string sName = row["BankName"].ToString();
string sText = "<strong style='color:#473C8B'>" + sId + "_" + sName + "</strong>";
TreeNode node = new TreeNode(sText, sId);
this.MyGetTypeList(node);
TreeView1.Nodes.Add(node);
}
}
}
public void MyGetTypeList(TreeNode parentNode)
{
DataTable datatable = QuestionTypeManage.GetQuestionTypeList();
parentNode.ChildNodes.Clear();
if (datatable.Rows.Count > 0)
{
foreach (DataRow row in datatable.Rows)
{
string sId = row["TypeId"].ToString();
string sName = row["TypeName"].ToString();
string sCount = QuestionManage.MyGetQuestionCount(parentNode.Value, sId);
string sText = "<strong style='color:#B22222'>" + sId + "_" + sName + sCount + "</strong>";
TreeNode node = new TreeNode(sText, sId);
this.MyGetQuestionList(node, parentNode.Value, node.Value);
parentNode.ChildNodes.Add(node);
}
}
}
public void MyGetQuestionList(TreeNode parentNode, string sBankId, string sTypeId)
{
string sSql = string.Format("select * from Question where BankId='{0}' and TypeId='{1}'", sBankId, sTypeId);
DataTable table = CommClass.GetDataTable(sSql);
if (table.Rows.Count > 0)
{
parentNode.ChildNodes.Clear();
foreach (DataRow row in table.Rows)
{
string sId = row["QuestionId"].ToString();
string sName = row["Subject"].ToString();
TreeNode node = new TreeNode(sId + "_" + sName, sId);
string sUrl = string.Format("QuestionMark.aspx?action=1&did={0}", row["Did"].ToString());
node.NavigateUrl = sUrl;
parentNode.ChildNodes.Add(node);
}
}
}