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