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