/// <summary> /// 根据表名获取记录 /// </summary> /// <param name="TableName"></param> /// <returns></returns> public static Models.DB.RoleInfoModel SelectRoleInfoModel(string TableName) { Models.DB.RoleInfoModel RoleInfo = new Models.DB.RoleInfoModel(); RoleInfo.TableName = TableName; System.Data.DataTable dt = DAL.Select.GetList(RoleInfo, "TableName"); if (dt.Rows.Count > 0) { RoleInfo.Id = Convert.ToInt32(dt.Rows[0]["Id"]); RoleInfo.Name = dt.Rows[0]["Name"].ToString(); RoleInfo.TableName = dt.Rows[0]["TableName"].ToString(); RoleInfo.RoleId = Convert.ToInt32(dt.Rows[0]["RoleId"]); RoleInfo.AdminDirectory = dt.Rows[0]["AdminDirectory"].ToString(); } return(RoleInfo); }
/// <summary> /// 根据Enable获取数据 /// </summary> /// <param name="Enable"></param> /// <param name="pagesize"></param> /// <param name="currentPage"></param> /// <returns></returns> public static List <Models.DB.StudentInfoModel> SelectByEnable(string Enable, int pagesize, int currentPage) { List <Models.DB.StudentInfoModel> Students = new List <Models.DB.StudentInfoModel>(); bool enable = true; if (string.IsNullOrEmpty(Enable)) { return(Students); } try { enable = Convert.ToBoolean(Enable); } catch { return(Students); } Models.DB.StudentInfoModel Student = new Models.DB.StudentInfoModel(); Models.DB.User User = new Models.DB.User(); Models.DB.RoleInfoModel Model = BLL.RoleInfoModel.SelectRoleInfoModel("Tb_StudentInfoModel"); List <Models.DB.Role> Roles = BLL.Role.SelectRole(Model.Id); if (Roles.Count <= 0) { return(Students); } User.Enable = enable; User.RoleId = Roles[0].ID; string[] targets = { "RoleId", "Enable" }; System.Data.DataTable dt = DAL.Select.GetSome(User, targets, pagesize, currentPage, "ID", ""); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { Student = BLL.StudentInfoModel.SelectOneByUserId(dt.Rows[i]["Id"].ToString()); Students.Add(Student); } } return(Students); }
private void initRoles() { Models.DB.RoleInfoModel RoleInfo = BLL.RoleInfoModel.SelectRoleInfoModel("Tb_AdminModel"); Roles = BLL.Role.SelectRole(RoleInfo.Id); }