public override SimpleUserCollection GetBannedUsers(int ForumID, int pageSize, int pageNumber, out int totalCount) { totalCount = 0; using (SqlQuery query = new SqlQuery()) { query.Pager.TableName = "bx_SimpleUser"; query.Pager.PageNumber = pageNumber; query.Pager.PageSize = pageSize; query.Pager.SelectCount = true; query.Pager.SelectCount = true; query.Pager.PrimaryKey = "[UserID]"; query.Pager.Condition = " UserID IN(SELECT UserID FROM bx_BannedUsers WHERE ForumID = @ForumID AND EndDate > GETDATE())"; query.CreateParameter <int>("@ForumID", ForumID, SqlDbType.Int); using (XSqlDataReader reader = query.ExecuteReader()) { SimpleUserCollection users = new SimpleUserCollection(reader); if (reader.NextResult()) { while (reader.Read()) { totalCount = reader.GetInt32(0); } } return(users); } } }
public static SimpleUserContainer PrepareUsers() { SimpleUserContainer container = new SimpleUserContainer(); SimpleUserCollection users = new SimpleUserCollection(); users.Add(new SimpleUser() { ID = "sz", Name = "沈峥" }); users.Add(new SimpleUser() { ID = "sr", Name = "沈嵘" }); users.Add(new SimpleUser() { ID = "za", Name = "张岸" }); users.Add(new SimpleUser() { ID = "sjb", Name = "史江波" }); container.Users = users; return(container); }
protected void Page_Load(object sender, EventArgs e) { m_UserIdsToAddText = _Request.Get("uid"); m_UserIdsToAdd = StringUtil.Split<int>(m_UserIdsToAddText, ','); if (m_UserIdsToAdd.Length == 0) ShowError(new NotSelectedUserError("uid")); if (_Request.IsClick("add")) { Add(); } m_UserListToAdd = UserBO.Instance.GetSimpleUsers(m_UserIdsToAdd); if (m_UserListToAdd.Count == 0) ShowError(new NotSelectedUserError("uid")); }
protected void Page_Load(object sender, EventArgs e) { m_UserIdsToAddText = _Request.Get("uid"); m_UserIdsToAdd = StringUtil.Split <int>(m_UserIdsToAddText, ','); if (m_UserIdsToAdd.Length == 0) { ShowError(new NotSelectedUserError("uid")); } if (_Request.IsClick("add")) { Add(); } m_UserListToAdd = UserBO.Instance.GetSimpleUsers(m_UserIdsToAdd); if (m_UserListToAdd.Count == 0) { ShowError(new NotSelectedUserError("uid")); } }
public int AddUsersToRole(AuthUser operatorUser, IEnumerable <int> userIds, Role role, DateTime beginDate, DateTime enddate) { RoleUserCollection roleusers = new RoleUserCollection(); RoleUser ru; SimpleUserCollection users = UserBO.Instance.GetSimpleUsers(userIds); SimpleUser user; foreach (int i in userIds) { if (users.TryGetValue(i, out user)) { ru = new RoleUser(); ru.UserID = i; ru.RoleID = role.RID; ru.BeginDate = beginDate; ru.EndDate = enddate; roleusers.Add(ru); } } return(Math.Abs(RoleDao.Instance.AddUsersToRoles(roleusers))); }
public override SimpleUserCollection GetBannedUsers(int ForumID, int pageSize, int pageNumber, out int totalCount) { totalCount = 0; using (SqlQuery query = new SqlQuery()) { query.Pager.TableName = "bx_SimpleUser"; query.Pager.PageNumber = pageNumber; query.Pager.PageSize = pageSize; query.Pager.SelectCount = true; query.Pager.SelectCount = true; query.Pager.PrimaryKey = "[UserID]"; query.Pager.Condition = " UserID IN(SELECT UserID FROM bx_BannedUsers WHERE ForumID = @ForumID AND EndDate > GETDATE())"; query.CreateParameter<int>("@ForumID", ForumID, SqlDbType.Int); using (XSqlDataReader reader = query.ExecuteReader()) { SimpleUserCollection users = new SimpleUserCollection(reader); if (reader.NextResult()) { while (reader.Read()) totalCount = reader.GetInt32(0); } return users; } } }