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