public void NewMissionUserList(int count
, NewMissionUserListHeadFootTemplate head
, NewMissionUserListHeadFootTemplate foot
, NewMissionUserListItemTemplate item)
{
UserMissionCollection missionUsers = MissionBO.Instance.GetNewMissionUsers(count);
List <int> userIDs = new List <int>();
foreach (UserMission userMission in missionUsers)
{
userIDs.Add(userMission.UserID);
}
if (userIDs.Count > 0)
{
UserBO.Instance.GetUsers(userIDs, GetUserOption.WithDeletedUser);
}
head(missionUsers.Count > 0);
int i = 0;
foreach (UserMission missionUser in missionUsers)
{
item(i++, missionUser);
}
foot(missionUsers.Count > 0);
}
/// <summary>
/// 任务的参与用户
/// </summary>
/// <param name="missionID"></param>
/// <param name="page"></param>
/// <param name="pageSize"></param>
/// <param name="template"></param>
private void MissionUserList(int missionID, int page, int pageSize
, MissionUserListItemHeadFootTemplate head
, MissionUserListItemHeadFootTemplate foot
, UserMissionTemplate template
, MissionUserListItemTemplate userTemplate)
{
if (page == 0)
{
page = 1;
}
int totalCount;
UserMissionCollection userMissions = MissionBO.Instance.GetMissionUsers(missionID, page, pageSize, out totalCount);
List <int> userIDs = new List <int>();
foreach (UserMission userMission in userMissions)
{
userIDs.Add(userMission.UserID);
}
UserCollection users = UserBO.Instance.GetUsers(userIDs);
head(totalCount > 0, totalCount);
int i = 0;
if (template != null)
{
foreach (UserMission userMission in userMissions)
{
template(i++, userMission);
}
}
if (userTemplate == null)
{
foot(totalCount > 0, totalCount);
return;
}
if (userIDs.Count == 0)
{
foot(totalCount > 0, totalCount);
return;
}
i = 0;
int index = (page - 1) * pageSize;
int userID = UserBO.Instance.GetCurrentUserID();
foreach (User user in users)
{
index++;
userTemplate(i, index, user, i % 2 == 0, user.UserID == userID);
i++;
}
foot(totalCount > 0, totalCount);
}
public override UserMissionCollection GetUserMissions(int userID, int pageNumber, int pageSize, out int totalCount)
{
using (SqlQuery query = new SqlQuery())
{
query.Pager.IsDesc = true;
query.Pager.SortField = "[CreateDate]";
query.Pager.PrimaryKey = "[ID]";
query.Pager.PageNumber = pageNumber;
query.Pager.PageSize = pageSize;
//query.Pager.TotalRecords = totalCount;
query.Pager.SelectCount = true;
query.Pager.TableName = "[bx_UserMissionsView]";
query.Pager.Condition = @"UserID=@UserID AND IsEnable = 1 AND Status <> 1";
query.CreateParameter <int>("@UserID", userID, SqlDbType.Int);
using (XSqlDataReader reader = query.ExecuteReader())
{
UserMissionCollection missions = new UserMissionCollection(reader);
if (reader.NextResult())
{
if (reader.Read())
{
totalCount = reader.GetInt32(0);
}
else
{
totalCount = 0;
}
}
else
{
totalCount = 0;
}
return(missions);
}
}
}
public override UserMissionCollection GetMissionUsers(int missionID, int pageNumber, int pageSize, out int totalUsers)
{
using (SqlQuery query = new SqlQuery())
{
query.Pager.IsDesc = true;
query.Pager.SortField = "[CreateDate]";
query.Pager.PrimaryKey = "[ID]";
query.Pager.PageNumber = pageNumber;
query.Pager.PageSize = pageSize;
query.Pager.SelectCount = true;
query.Pager.TableName = "[bx_UserMissions]";
query.Pager.Condition = @"
[MissionID] = @MissionID AND [Status] <> 3
";
query.CreateParameter <int>("@MissionID", missionID, SqlDbType.Int);
using (XSqlDataReader reader = query.ExecuteReader())
{
UserMissionCollection userMissions = new UserMissionCollection(reader);
if (reader.NextResult())
{
if (reader.Read())
{
totalUsers = reader.Get <int>(0);
}
else
{
totalUsers = 0;
}
}
else
{
totalUsers = 0;
}
return(userMissions);
}
}
}
public override UserMissionCollection GetUserMissions(int userID, int pageNumber, int pageSize, out int totalCount)
{
using (SqlQuery query = new SqlQuery())
{
query.Pager.IsDesc = true;
query.Pager.SortField = "[CreateDate]";
query.Pager.PrimaryKey = "[ID]";
query.Pager.PageNumber = pageNumber;
query.Pager.PageSize = pageSize;
//query.Pager.TotalRecords = totalCount;
query.Pager.SelectCount = true;
query.Pager.TableName = "[bx_UserMissionsView]";
query.Pager.Condition = @"UserID=@UserID AND IsEnable = 1 AND Status <> 1";
query.CreateParameter<int>("@UserID", userID, SqlDbType.Int);
using (XSqlDataReader reader = query.ExecuteReader())
{
UserMissionCollection missions = new UserMissionCollection(reader);
if (reader.NextResult())
{
if (reader.Read())
{
totalCount = reader.GetInt32(0);
}
else
totalCount = 0;
}
else
totalCount = 0;
return missions;
}
}
}
public override UserMissionCollection GetMissionUsers(int missionID, int pageNumber, int pageSize,out int totalUsers)
{
using (SqlQuery query = new SqlQuery())
{
query.Pager.IsDesc = true;
query.Pager.SortField = "[CreateDate]";
query.Pager.PrimaryKey = "[ID]";
query.Pager.PageNumber = pageNumber;
query.Pager.PageSize = pageSize;
query.Pager.SelectCount = true;
query.Pager.TableName = "[bx_UserMissions]";
query.Pager.Condition = @"
[MissionID] = @MissionID AND [Status] <> 3
";
query.CreateParameter<int>("@MissionID", missionID, SqlDbType.Int);
using (XSqlDataReader reader = query.ExecuteReader())
{
UserMissionCollection userMissions = new UserMissionCollection(reader);
if (reader.NextResult())
{
if (reader.Read())
{
totalUsers = reader.Get<int>(0);
}
else
totalUsers = 0;
}
else
totalUsers = 0;
return userMissions;
}
}
}
