lefttree.ascx.cs

发一个功能比较全面的考试系统（VS2005+SQL2000）本系统开发环境是VS2005+SQL2000,是我在实习单位时独立做的一个项目

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

using OnLineExam.DataAccessLayer;
using OnLineExam.DataAccessHelper;
using OnLineExam.BusinessLogicLayer;
using OnLineExam.CommonComponent;

public partial class Controls_lefttree : System.Web.UI.UserControl
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            InitData();
        }
    }
    private void InitData()
    {
       CheckUser();

       string loginName = Session["userID"].ToString();

       Users user = new Users();
        user.LoadData(loginName);
        //LabelTree.Text = "您好:" + user.UserName + "<hr>";

        string sql = "Select * from [TreeMenu] Where [Duty] in (";
        foreach (string duty in user.Duties)
        {
            sql += SQLString.GetQuotedString(duty) + ",";
        }
        sql += "'#')";

        DataBase db = new DataBase();
        DataTable dt = db.GetDataTable(sql);

        Tree tree = new Tree();
        LabelTree.Text += tree.CreateTree(dt);
    }

   
  private void CheckUser()
  {
       if (Session["userID"]==null)
           Response.Redirect("Login.aspx");
  }
}