public PaginationEntity <FullUserInfo> Query(UserQueryForm form) { PaginationEntity <FullUserInfo> result = new PaginationEntity <FullUserInfo>(); var mapper = Common.GetMapper(); UserDao userdao = new UserDao(mapper); User_BoardGroupDao ubdao = new User_BoardGroupDao(mapper); BoardGroupDao bgdao = new BoardGroupDao(mapper); var users = userdao.Query(form); var userids = (from u in users select u.ID).ToList(); var ubs = ubdao.Query(new User_BoardGroupQueryForm { UserIDs = userids }); var allboards = bgdao.Query(new BoardGroupQueryForm { Enabled = true }); List <FullUserInfo> list = new List <FullUserInfo>(); users.ForEach(u => { var boards = (from ub in ubs join b in allboards on ub.BoardGroupID equals b.ID where ub.UserID == u.ID select b).ToList(); var fulluser = new FullUserInfo(); u.CopyTo <FullUserInfo>(fulluser); fulluser.Boards = boards; list.Add(fulluser); }); result.RecordCount = form.RecordCount; result.List = list; return(result); }
public List <BoardGroup> GetMyBoardGroupList() { LoginBLL login = new LoginBLL(); var mapper = Common.GetMapper(); var me = login.GetMe(); BoardGroupDao bgdao = new BoardGroupDao(mapper); User_BoardGroupDao ubgdao = new User_BoardGroupDao(mapper); var boards = ubgdao.Query(new User_BoardGroupQueryForm { UserID = me.ID }); var boardids = (from b in boards select b.ID).ToList(); var boardGroups = bgdao.Query(new BoardGroupQueryForm { Enabled = true, IDs = boardids }); return(boardGroups); }
public IndexPage Index(int pageSize) { LoginBLL loginbll = new LoginBLL(); TopicBLL topicbll = new TopicBLL(); var mapper = Common.GetMapper(); UserDao userdao = new UserDao(mapper); User_BoardGroupDao utgdao = new User_BoardGroupDao(mapper); BoardGroupDao tgdao = new BoardGroupDao(mapper); TopicDao topicdao = new TopicDao(mapper); var me = loginbll.GetMe(); if (me == null) { throw new XinLuClubException(100, "token过期,请重新登录"); } var utgs = utgdao.Query(new User_BoardGroupQueryForm { UserID = me.ID }); var groups = new List <BoardGroup>(); var topicinfos = new PaginationEntity <FullTopicInfo>(); if (utgs.Count > 0) { var groupIDs = (from u in utgs select u.BoardGroupID).ToList(); groups = tgdao.Query(new BoardGroupQueryForm { IDs = groupIDs, Enabled = true, OrderBy = OrderBy.DESC, OrderByColumn = "LastUpdateTime" }); topicinfos = topicbll.GetFullTopicList(new TopicQueryForm { PageSize = pageSize, CurrentIndex = 1, OrderBy = OrderBy.DESC, OrderByColumn = "LastUpdateTime", OwnerID = me.ID }); } IndexPage page = new IndexPage { //ActiveTopics = activeTopic, NewestTopics = topicinfos, BoardGroups = groups, }; return(page); }
public PaginationEntity <FullTopicInfo> GetFullTopicList(TopicQueryForm form) { var mapper = Common.GetMapper(); TopicDao topicdao = new TopicDao(mapper); User_BoardGroupDao udgdao = new User_BoardGroupDao(mapper); var paging = new PaginationEntity <FullTopicInfo>(); var boards = udgdao.Query(new User_BoardGroupQueryForm { UserID = form.OwnerID }); var boardids = (from b in boards select b.BoardGroupID).ToList(); form.OwnerID = null; form.BoardGroupIDs = boardids; var topics = topicdao.QueryFullTopicInfo(form); paging.List = topics; paging.RecordCount = form.RecordCount; return(paging); }
public PaginationEntity <FullTopicInfo> GetFullTopicListByBoard(TopicQueryForm form) { var mapper = Common.GetMapper(); TopicDao topicdao = new TopicDao(mapper); User_BoardGroupDao udgdao = new User_BoardGroupDao(mapper); var paging = new PaginationEntity <FullTopicInfo>(); var boards = udgdao.Query(new User_BoardGroupQueryForm { UserID = form.OwnerID, BoardGroupID = form.BoardGroupID }); if (boards.Count == 0) { throw new XinLuClubException(202, "你没有查看该板块的权限,请联系管理员"); } var topics = topicdao.QueryFullTopicInfo(new TopicQueryForm { Enabled = true, BoardGroupID = form.BoardGroupID }); paging.List = topics; paging.RecordCount = form.RecordCount; return(paging); }