public ClubMemberStatus?GetClubMemberStatus(int clubID, int userID)
{
if (userID <= 0)
{
return(null);
}
string cachekey = GetCacheKeyForClubMemberStatus(userID, clubID);
ClubMemberStatus cache = ClubMemberStatus.Normal;
if (CacheUtil.TryGetValue <ClubMemberStatus>(cachekey, out cache))
{
return(cache);
}
ClubMemberStatus?result = ClubDao.Instance.GetClubMemberStatus(clubID, userID);
if (result != null)
{
CacheUtil.Set <ClubMemberStatus>(cachekey, result.Value);
}
return(result);
}
public override void UpdateClubMemberStatus(int clubID, int[] userIDs, ClubMemberStatus status)
{
using (SqlQuery db = new SqlQuery())
{
db.CommandText = "UPDATE bx_ClubMembers SET Status = @Status WHERE ClubID = @ClubID AND UserID IN (@UserIDs);";
db.CreateParameter <int>("@ClubID", clubID, SqlDbType.Int);
db.CreateParameter <ClubMemberStatus>("@Status", status, SqlDbType.TinyInt);
db.CreateInParameter <int>("@UserIDs", userIDs);
db.ExecuteNonQuery();
}
}
/// <summary> /// 批量修改群组成员的身份 /// </summary> /// <param name="clubID"></param> /// <param name="userIDs"></param> /// <param name="status"></param> public abstract void UpdateClubMemberStatus(int clubID, int[] userIDs, ClubMemberStatus status);
public override void UpdateClubMemberStatus(int clubID, int[] userIDs, ClubMemberStatus status)
{
using (SqlQuery db = new SqlQuery())
{
db.CommandText = "UPDATE bx_ClubMembers SET Status = @Status WHERE ClubID = @ClubID AND UserID IN (@UserIDs);";
db.CreateParameter<int>("@ClubID", clubID, SqlDbType.Int);
db.CreateParameter<ClubMemberStatus>("@Status", status, SqlDbType.TinyInt);
db.CreateInParameter<int>("@UserIDs", userIDs);
db.ExecuteNonQuery();
}
}
public override ClubMemberCollection GetClubMembers(int clubID, int pageSize, int pageNumber, ClubMemberStatus? status)
{
using (SqlQuery db = new SqlQuery())
{
db.Pager.TableName = "bx_ClubMembers";
db.Pager.SortField = "SortOrder";
db.Pager.PageSize = pageSize;
db.Pager.PageNumber = pageNumber;
db.Pager.Condition = "ClubID = @ClubID";
db.Pager.SelectCount = true;
if (status != null)
{
db.Pager.Condition += " AND Status = @Status";
db.CreateParameter<ClubMemberStatus>("@Status", status.Value, SqlDbType.TinyInt);
}
else
{
db.Pager.Condition += " AND Status <> 1 AND Status <> 2";
}
db.CreateParameter<int>("@ClubID", clubID, SqlDbType.Int);
using (XSqlDataReader reader = db.ExecuteReader())
{
ClubMemberCollection result = new ClubMemberCollection(reader);
reader.NextResult();
reader.Read();
result.TotalRecords = reader.Get<int>(0);
return result;
}
}
}
public bool UpdateClubMemberStatus(AuthUser operatorUser, int clubID, int[] userIDs, ClubMemberStatus status)
{
Club club = GetClubForEdit(operatorUser, clubID);
if (club == null)
{
return(false);
}
ClubDao.Instance.UpdateClubMemberStatus(clubID, userIDs, status);
foreach (int userID in userIDs)
{
ClearClubMemberStatusCache(userID, clubID);
}
return(true);
}
protected void Page_Load(object sender, EventArgs e)
{
int?clubID = _Request.Get <int>("id");
if (clubID.HasValue)
{
if (_Request.IsClick("update"))
{
using (ErrorScope es = new ErrorScope())
{
MessageDisplay md = CreateMessageDisplay();
string[] ids = _Request.Get("MemberIDs", Method.Post, string.Empty).Split(',');
if (ids.Length == 1 && ids[0] == string.Empty)
{
md.AddError("请至少选择一个用户");
}
else
{
int[] userIDs = new int[ids.Length];
for (int i = 0; i < ids.Length; i++)
{
userIDs[i] = int.Parse(ids[i]);
}
if (_Request.Get("SetStatus", Method.Post) == "Delete")
{
ClubBO.Instance.RemoveClubMembers(My, clubID.Value, userIDs);
}
else
{
ClubMemberStatus?setStatus = _Request.Get <ClubMemberStatus>("SetStatus", Method.Post, ClubMemberStatus.Normal);
if (setStatus != null)
{
if (ClubBO.Instance.UpdateClubMemberStatus(My, clubID.Value, userIDs, setStatus.Value))
{
BbsRouter.JumpToCurrentUrl(); //.JumpTo(BbsRouter.GetCurrentUrl());
}
else
{
es.CatchError <ErrorInfo>(delegate(ErrorInfo error)
{
md.AddError(error);
});
}
}
}
}
}
}
ClubMemberStatus status = _Request.Get <ClubMemberStatus>("status", ClubMemberStatus.Normal);
int page = _Request.Get <int>("page", 1);
int pageSize = 30;
m_ClubMemberList = ClubBO.Instance.GetClubMembersForEdit(My, clubID.Value, status, page, pageSize);
if (m_ClubMemberList == null)
{
ShowError("群组不存在或没权限管理");
}
m_TotalClubMemberCount = m_ClubMemberList.TotalRecords;
UserBO.Instance.WaitForFillSimpleUsers <ClubMember>(m_ClubMemberList);
}
else
{
ShowError("群组不存在");
}
}
