public Response Execute(User currentUser, string request)
{
var req = JsonConvert.DeserializeObject <Request <Activity> >(request);
var cmd = CommandHelper.CreateProcedure <Activity>(text: "sp_GetActivity");
cmd.Params.Add("@userId", currentUser.Id);
cmd.Params.Add("@activityId", req.Filter.Id);
var result = DbContext.GetInstance().Execute(cmd);
var activity = result.FirstEntity <Activity>();
activity.ActivityUserList = new List <ActivityUser>();
GetActivityUserListFilter userFilter = new GetActivityUserListFilter();
userFilter.ActivityId = req.Filter.Id;
userFilter.PageIndex = 1;
userFilter.PageSize = 10;//此处写死10个用做头像列表用
var tempResult = ActivityHelper.GetActivityUserList(userFilter);
tempResult.Entities.ForEach(p => activity.ActivityUserList.Add(p as ActivityUser));
activity.ActivityUserTotal = tempResult.RowCount;
activity.TryGetFiles();
return(result);
}
public static Response GetActivityUserList(GetActivityUserListFilter filter)
{
var cmd = CommandHelper.CreateProcedure <ActivityUser>(text: "sp_GetActivityUserList");
cmd.Params.Add(CommandHelper.CreateParam("@activityId", filter.ActivityId));
cmd.Params.Add(CommandHelper.CreateParam("@petName", filter.PetName));
cmd.CreateParamPager(filter);
var result = DbContext.GetInstance().Execute(cmd);
result.SetRowCount();
return(result);
}
//设置每个活动的成员列表
public void SetActivityUserList(Response result)
{
GetActivityUserListFilter userFilter = new GetActivityUserListFilter();
userFilter.PageIndex = 1;
userFilter.PageSize = 10;//此处写死10个用做头像列表用
foreach (var item in result.Entities)
{
var activity = item as Activity;
userFilter.ActivityId = activity.Id;
var tempResult = ActivityHelper.GetActivityUserList(userFilter);
activity.ActivityUserList = tempResult.Entities.ToList <EntityBase, ActivityUser>();
activity.ActivityUserTotal = tempResult.RowCount;
}
}
