private void InitData()
{
CheckUser();
string loginName = Session["userID"].ToString();
Users user = new Users();
user.LoadData(loginName);
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);
}
/// 查询用户
public static DataTable QueryUsers(Hashtable queryItems)
{
string where = SQLString.GetConditionClause(queryItems);
string sql = "Select * From [Users],[Role] " + where;
if (where == "")
sql += " Where";
else
sql += " And";
sql +=" [Users].RoleId=[Role].RoleId";
DataBase DB = new DataBase();
return DB.GetDataTable(sql);
}
/// <summary>
/// ���ݲ�ѯ������ϣ��,��ѯ����
/// </summary>
/// <param name="queryItems">��ѯ������ϣ��</param>
/// <returns>��ѯ�������DataTable</returns>
public static DataTable Query(Hashtable queryItems)
{
string where = SQLString.GetConditionClause(queryItems);
string sql = "Select * From [Role] where RoleId!=1 and RoleId!=5 order by RoleId" + where;//ɾ����top 2���ƺʹ����˲���admin��ʾ����ֹ�û���С�ĸ���adminȨ���½����˺�̨
DataBase db = new DataBase();
return db.GetDataTable(sql);
}
