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