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); }