Пример #1
0
    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 ReportTreeMenu Where [Duty] in (";

        foreach (string duty in user.Duties)
        {
            sql += SQLString.GetQuotedString(duty) + ",";
        }
        sql += "'#')";

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

        Tree2 tree = new Tree2("------------ Kypera Report Lists ------------");

        LabelTree.Text += tree.CreateTree2(dt);
    }