Esempio n. 1
0
        /// <summary>
        /// 获取作品内容并获取上一篇,下一篇的id
        /// </summary>
        /// <param name="state">2初赛,3半决赛,4决赛</param>
        /// <param name="article_id"></param>
        /// <returns></returns>
        public ApiResult GetArticleInfoByAdmin(int state, int article_id)
        {
            ApiPageResult apiResult   = new ApiPageResult();
            var           checkResult = Util.CheckParameters(
                new Parameter {
                Value = state.ToString(), Msg = "state 不能为空值"
            },
                new Parameter {
                Value = state.ToString(), Msg = "state 必须是数字类型", Regex = @"^[1-9]\d*$"
            },
                new Parameter {
                Value = article_id.ToString(), Msg = "article_id 不能为空值"
            },
                new Parameter {
                Value = article_id.ToString(), Msg = "article_id 必须是数字类型", Regex = @"^[1-9]\d*$"
            }
                );

            if (!checkResult.OK)
            {
                apiResult.success = false;
                apiResult.status  = ApiStatusCode.InvalidParam;
                apiResult.message = checkResult.Msg;
                return(apiResult);
            }
            ArticleBLL bll = new ArticleBLL();

            return(bll.GetArticleInfoByAdmin(state, article_id));
        }
        public async Task <ApiPageResult> GetUsers([FromBody] UserSearchCriteria criteria)
        {
            var result = new ApiPageResult();
            var page   = await _userService.GetPageAsync(criteria);

            result.Code    = 200;
            result.Message = "获取用户列表成功";
            result.Page    = page;

            return(result);
        }
Esempio n. 3
0
        public async Task <ApiPageResult> GetNotificationsForManager([FromBody] NotificationSearchCriteria criteria)
        {
            var page = await _notificationService.GetPageAsync(criteria);

            var result = new ApiPageResult
            {
                Code    = 200,
                Message = "获取通知列表成功",
                Page    = page,
            };

            return(result);
        }
Esempio n. 4
0
        public async Task <ApiPageResult <NotificationUser> > GetNotifications([FromBody] NotificationPageSearchCriteria criteria)
        {
            criteria.ToUserId = HttpContext.User.GetUserId();
            var page = await _notificationService.GetPageAsync(criteria);

            var result = new ApiPageResult <NotificationUser>
            {
                Code    = 200,
                Message = "获取通知列表成功",
                Page    = page,
            };

            return(result);
        }
Esempio n. 5
0
        /// <summary>
        /// 获取作品列表
        /// </summary>
        /// <param name="zone_id">赛区id</param>
        /// <param name="keyword">作品编号/标题/作者</param>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public ApiPageResult GetArticleList(int uid, int zone_id, int competiontion_season_id, string keyword = null, int pageIndex = GloabManager.PAGEINDEX, int pageSize = GloabManager.PAGESIZE)
        {
            ApiPageResult apiResult = new ApiPageResult();

            apiResult.pageIndex = pageIndex;
            apiResult.pageSize  = pageSize;
            //作品列表(必须是审核通过了的)
            var article_list = from a in db.Set <articles>()
                               join b in db.Set <article_competition_season>() on a.article_id equals b.article_id
                               into ab1 from ab in ab1.DefaultIfEmpty()
                               where ab.competiontion_season_id == competiontion_season_id
                               join c in db.Set <author_info>() on a.uid equals c.uid
                               join d in db.Set <article_states>() on a.article_id equals d.article_id
                               where d.article_state >= 2
                               select new { a.article_id, ab.zone_id, a.article_no, a.article_pic, a.article_title, a.uid, c.user_name };

            if (!string.IsNullOrEmpty(keyword))
            {
                article_list = article_list.Where(o => o.article_no.Contains(keyword) || o.article_title.Contains(keyword) || o.user_name.Contains(keyword));
            }
            if (zone_id > 0)
            {
                article_list = article_list.Where(o => o.zone_id == zone_id);
            }
            //票数计算
            var vote_count = from a in db.Set <vote_record>() group a by a.article_id into b select new { b.Key, vote_count = (int?)b.Count() };
            int count      = article_list.Count();
            var _data      = article_list.OrderByDescending(o => o.article_id).Skip((pageIndex - 1) * pageSize).Take(pageSize);
            var data       = from a in _data join b in vote_count on a.article_id equals b.Key into ab1 from ab in ab1.DefaultIfEmpty() select new { article = a, vote_count = ab.vote_count ?? 0 };
            //我的票数
            DateTime start = DateTime.Now.Date;
            DateTime end   = DateTime.Now.AddDays(1).Date;
            //我的投票数
            var my_vote_count = from a in db.Set <vote_record>() where a.create_time >= start && a.create_time < end group a by a.uid into b where b.Key == uid select new { vote_count = (int?)b.Count() };
            //我对哪些作品投票了,投了多少票
            var my_vote_article_count = from a in db.Set <vote_record>()
                                        where a.create_time >= start && a.create_time < end && a.uid == uid
                                        group a by a.article_id into b
                                        select new { article_id = b.Key, vote_count = (int?)b.Count() };
            var list = from a in data
                       join b in my_vote_article_count on a.article.article_id equals b.article_id
                       into ab1 from ab in ab1.DefaultIfEmpty()
                       select new { data = a, my_vote_article_count = ab.vote_count };

            apiResult.success    = true;
            apiResult.message    = "获取作品列表";
            apiResult.data       = new { list, my_vote_count };
            apiResult.totalCount = count;
            return(apiResult);
        }
Esempio n. 6
0
        /// <summary>
        /// 获取所有开启大赛公告
        /// </summary>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public ApiPageResult GetAllNotices(int pageIndex = GloabManager.PAGEINDEX, int pageSize = GloabManager.PAGESIZE)
        {
            ApiPageResult apiResult = new ApiPageResult();

            apiResult.pageIndex = pageIndex;
            apiResult.pageSize  = pageSize;
            BaseBLL <competition_notice> bll = new BaseBLL <competition_notice>();
            var list  = bll.FindList <int>(o => o.is_delete == 0 && o.is_open == 1);
            int count = list.Count();

            list = list.OrderBy(o => new { o.topsize, o.competition_season_id }).Skip((pageIndex - 1) * pageSize).Take(pageSize);
            apiResult.success    = true;
            apiResult.message    = "获取所有大赛公告";
            apiResult.data       = list;
            apiResult.totalCount = count;
            return(apiResult);
        }
Esempio n. 7
0
        /// <summary>
        /// 获取作品列表(小程序,必须是审核过的)
        /// </summary>
        /// <param name="uid">赛区id</param>
        /// <param name="zone_id">赛区id</param>
        /// <param name="keyword">作品编号/标题/作者</param>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public ApiPageResult GetArticleList(int uid, int zone_id = 0, string keyword = null, int pageIndex = GloabManager.PAGEINDEX, int pageSize = GloabManager.PAGESIZE)
        {
            ApiPageResult apiResult   = new ApiPageResult();
            var           checkResult = Util.CheckParameters(
                new Parameter {
                Value = uid.ToString(), Msg = "uid 不能为空值"
            },
                new Parameter {
                Value = uid.ToString(), Msg = "uid 必须是数字类型", Regex = @"^[1-9]\d*$"
            },
                new Parameter {
                Value = zone_id.ToString(), Msg = "zone_id 不能为空值"
            },
                new Parameter {
                Value = zone_id.ToString(), Msg = "zone_id 必须是数字类型", Regex = @"^[0-9]\d*$"
            }
                );

            if (!checkResult.OK)
            {
                apiResult.success = false;
                apiResult.status  = ApiStatusCode.InvalidParam;
                apiResult.message = checkResult.Msg;
                return(apiResult);
            }
            //查到当前默认开启的赛季
            BaseBLL <competition_notice> notice_bll = new BaseBLL <competition_notice>();
            var competion_season        = notice_bll.Find(o => o.is_delete == 0 && o.is_open == 1);
            int competiontion_season_id = competion_season?.competition_season_id ?? 0;

            if (competiontion_season_id == 0)
            {
                return(new ApiPageResult()
                {
                    success = false,
                    message = "当前没有开启任何赛季"
                });
            }
            ArticleBLL bll = new ArticleBLL();

            return(bll.GetArticleList(uid, zone_id, competiontion_season_id, keyword, pageIndex, pageSize));
        }
Esempio n. 8
0
        /// <summary>
        /// 作品管理查询
        /// </summary>
        /// <param name="keyword">查询的关键字:作品编号/标题/作者</param>
        /// <param name="state">-1全部,0初始,1审核不通过,2审核通过,3半决赛,4决赛</param>
        /// <param name="zone_id">0全部</param>
        /// <param name="start">开始时间</param>
        /// <param name="end">结束时间</param>
        /// <param name="orderby">排序字段:vote按票数顺序排,votedesc按票数倒叙排,date按投稿时间顺序排,datedesc按投稿时间倒叙排</param>
        /// <param name="pageIndex">1</param>
        /// <param name="pageSize">10</param>
        /// <returns></returns>
        public ApiPageResult GetArticleList(string keyword = null, int state = -1, int zone_id = 0, DateTime?start = null, DateTime?end = null, string orderby = null, int pageIndex = GloabManager.PAGEINDEX, int pageSize = GloabManager.PAGESIZE)
        {
            ApiPageResult apiResult = new ApiPageResult();
            //赛季
            BaseBLL <competition_notice> notice_bll = new BaseBLL <competition_notice>();
            var notice = notice_bll.Find(o => o.is_delete == 0 && o.is_open == 1);

            if (notice?.competition_season_id > 0)
            {
                CompetitionBLL bll = new CompetitionBLL();
                return(bll.GetArticleList(keyword, state, notice.competition_season_id, zone_id, start, end, orderby, pageIndex, pageSize));
            }
            else
            {
                return(new ApiPageResult()
                {
                    success = false,
                    message = "当前没有开启的赛季"
                });
            }
        }
Esempio n. 9
0
        /// <summary>
        /// 我的投票记录
        /// </summary>
        /// <param name="uid"></param>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public ApiPageResult GetMyVoteRecord(int uid, int pageIndex = GloabManager.PAGEINDEX, int pageSize = GloabManager.PAGESIZE)
        {
            ApiPageResult apiResult   = new ApiPageResult();
            var           checkResult = Util.CheckParameters(
                new Parameter {
                Value = uid.ToString(), Msg = "zone_id 不能为空值"
            },
                new Parameter {
                Value = uid.ToString(), Msg = "zone_id 必须是数字类型", Regex = @"^[1-9]\d*$"
            }
                );

            if (!checkResult.OK)
            {
                apiResult.success = false;
                apiResult.status  = ApiStatusCode.InvalidParam;
                apiResult.message = checkResult.Msg;
                return(apiResult);
            }
            UsersBLL bll = new UsersBLL();

            return(bll.GetMyVoteRecord(uid, pageIndex, pageSize));
        }
Esempio n. 10
0
        /// <summary>
        /// 我的投票记录
        /// </summary>
        /// <param name="uid"></param>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public ApiPageResult GetMyVoteRecord(int uid, int pageIndex = GloabManager.PAGEINDEX, int pageSize = GloabManager.PAGESIZE)
        {
            ApiPageResult apiResult = new ApiPageResult();

            apiResult.pageIndex = pageIndex;
            apiResult.pageSize  = pageSize;
            var article = from a in db.Set <vote_record>()
                          join b in db.Set <articles>() on a.article_id equals b.article_id
                          join c in db.Set <author_info>() on b.uid equals c.uid
                          into ac1 from ac in ac1.DefaultIfEmpty()
                          where a.uid == uid
                          select new { b.article_id, b.article_pic, b.article_title, b.article_content, ac.user_name };
            int count      = article.Distinct().Count();
            var _data      = article.Distinct().OrderBy(o => o.article_id).Skip((pageIndex - 1) * pageSize).Take(pageSize);
            var vote_count = from a in db.Set <vote_record>()  group a by a.article_id into b select new { b.Key, vote_count = (int?)b.Count() };
            var data       = from a in _data join b in vote_count on a.article_id equals b.Key into ab1 from ab in ab1.DefaultIfEmpty() select new { article = a, vote_count = ab.vote_count ?? 0 };

            apiResult.data       = data;
            apiResult.success    = true;
            apiResult.message    = "我的投票记录";
            apiResult.totalCount = count;
            return(apiResult);
        }
Esempio n. 11
0
        public ApiPageResult GetAllNotices(DateTime?start = null, DateTime?end = null, int is_show = 1, int pageIndex = GloabManager.PAGEINDEX, int pageSize = GloabManager.PAGESIZE)
        {
            ApiPageResult apiPageResult = new ApiPageResult();

            apiPageResult.pageIndex = pageIndex;
            apiPageResult.pageSize  = pageSize;
            BaseBLL <user_notice> bll = new BaseBLL <user_notice>();
            var list = bll.FindList <int>(notice => true);

            if (is_show == 0)
            {
                list = list.Where(o => o.publish_time <= DateTime.Now);
            }
            if (start.HasValue)
            {
                list = list.Where(notice => notice.update_time > start.Value &&
                                  notice.update_time < (end ?? DateTime.Now));
            }
            int count      = list.Count();
            var top_notice = list.Where(o => o.is_top == 1);

            list = list.OrderByDescending(notice => notice.update_time).Skip((pageIndex - 1) * pageSize).Take(pageSize);
            var result = list.Select(notice => new
            {
                notice.notice_id,
                notice.title,
                notice.content,
                notice.is_top,
                notice.publish_time,
            });

            apiPageResult.success    = true;
            apiPageResult.message    = "获取所有通知";
            apiPageResult.data       = new { result, top_notice };
            apiPageResult.totalCount = count;
            return(apiPageResult);
        }
Esempio n. 12
0
 /// <summary>
 /// 生成一个标准返回对象(返回分页)
 /// </summary>
 /// <typeparam name="TResult">返回类型,基于ApiResult</typeparam>
 /// <param name="request">请求对象</param>
 /// <param name="statusCode">HTTP状态码</param>
 /// <param name="result">返回内容</param>
 /// <returns>HttpResponseMessage对象</returns>
 /// <returns></returns>
 public static ApiResponseMessage <ApiPageResult <TResult> > ToResponse <TResult>(this HttpRequestMessage request, ApiPageResult <TResult> result, HttpStatusCode statusCode = HttpStatusCode.OK)
 {
     if (result == null)
     {
         return(new ApiResponseMessage <ApiPageResult <TResult> >(statusCode)
         {
             RequestMessage = request
         });
     }
     return(new ApiResponseMessage <ApiPageResult <TResult> >(result, statusCode)
     {
         RequestMessage = request
     });
 }
Esempio n. 13
0
        /// <summary>
        /// 作品管理查询
        /// </summary>
        /// <param name="keyword">查询的关键字:作品编号/标题/作者</param>
        /// <param name="state">-1全部,0初始,1审核不通过,2审核通过,3半决赛,4决赛</param>
        /// <param name="zone_id">0全部</param>
        /// <param name="start">开始时间</param>
        /// <param name="end">结束时间</param>
        /// <param name="orderby">排序字段:vote 按票数顺序排,votedesc 按票数倒叙排,date 按投稿时间顺序排,datedesc 按投稿时间倒叙排</param>
        /// <param name="pageIndex">1</param>
        /// <param name="pageSize">10</param>
        /// <returns></returns>
        public ApiPageResult GetArticleList(string keyword = null, int state = -1, int competition_season_id = 0, int zone_id = 0, DateTime?start = null, DateTime?end = null, string orderby = null, int pageIndex = GloabManager.PAGEINDEX, int pageSize = GloabManager.PAGESIZE)
        {
            ApiPageResult apiResult = new ApiPageResult();

            apiResult.pageIndex = pageIndex;
            apiResult.pageSize  = pageSize;
            var article_list = from a in db.Set <articles>()
                               join b in db.Set <author_info>() on a.uid equals b.uid
                               join c in db.Set <article_states>() on a.article_id equals c.article_id
                               join d in db.Set <article_competition_season>() on a.article_id equals d.article_id
                               where d.competiontion_season_id == competition_season_id
                               select new { a.article_id, d.zone_id, a.article_no, a.article_title, b.user_name, a.create_time, c.article_state, c.adviser_score, c.expert_score, c.expert_name, c.return_tag, c.return_remark };

            if (state >= 0)
            {
                article_list = article_list.Where(o => o.article_state == state);
            }
            else
            {
                article_list = article_list.Where(o => o.article_state <= 2);
            }
            if (!string.IsNullOrEmpty(keyword))
            {
                article_list = article_list.Where(o => o.article_no.Contains(keyword) || o.user_name.Contains(keyword) || o.article_title.Contains(keyword));
            }
            if (zone_id > 0)
            {
                article_list = article_list.Where(o => o.zone_id == zone_id);
            }
            if (start != null)
            {
                article_list = article_list.Where(o => o.create_time >= start);
            }
            if (end != null)
            {
                end          = end.Value.AddDays(1);
                article_list = article_list.Where(o => o.create_time < end);
            }
            var vote_count = from a in db.Set <vote_record>() group a by a.article_id into b select new { article_id = b.Key, vote_count = (int?)b.Count() };
            var data       = from a in article_list join b in vote_count on a.article_id equals b.article_id into ab1 from ab in ab1.DefaultIfEmpty() select new { article = a, vote_count = ab.vote_count ?? 0, banjuesai = a.adviser_score * 0.6 + ab.vote_count ?? 0 * 0.4 };
            int count      = data.Count();

            //初赛作品
            if (state <= 2)
            {
                if (orderby == "vote")
                {
                    data = data.OrderBy(o => o.vote_count).Skip((pageIndex - 1) * pageSize).Take(pageSize);
                }
                else if (orderby == "votedesc")
                {
                    data = data.OrderByDescending(o => o.vote_count).Skip((pageIndex - 1) * pageSize).Take(pageSize);
                }
                else if (orderby == "date")
                {
                    data = data.OrderBy(o => o.article.create_time).Skip((pageIndex - 1) * pageSize).Take(pageSize);
                }
                else if (orderby == "datedesc")
                {
                    data = data.OrderByDescending(o => o.article.create_time).Skip((pageIndex - 1) * pageSize).Take(pageSize);
                }
                else
                {
                    data = data.OrderBy(o => o.article.article_id).Skip((pageIndex - 1) * pageSize).Take(pageSize);
                }
                apiResult.success    = true;
                apiResult.message    = "作品管理查询";
                apiResult.data       = data;
                apiResult.totalCount = count;
            }
            //半决赛
            else if (state == 3)
            {
                var _data = data.AsEnumerable().OrderByDescending(o => o.banjuesai).Select((o, index) => new { row = index + 1, data = o });
                if (orderby == "vote")
                {
                    _data = _data.OrderBy(o => o.data.vote_count).Skip((pageIndex - 1) * pageSize).Take(pageSize);
                }
                else if (orderby == "votedesc")
                {
                    _data = _data.OrderByDescending(o => o.data.vote_count).Skip((pageIndex - 1) * pageSize).Take(pageSize);
                }
                else if (orderby == "date")
                {
                    _data = _data.OrderBy(o => o.data.article.create_time).Skip((pageIndex - 1) * pageSize).Take(pageSize);
                }
                else if (orderby == "datedesc")
                {
                    _data = _data.OrderByDescending(o => o.data.article.create_time).Skip((pageIndex - 1) * pageSize).Take(pageSize);
                }
                else
                {
                    _data = _data.Skip((pageIndex - 1) * pageSize).Take(pageSize);
                }
                apiResult.success    = true;
                apiResult.message    = "作品管理查询";
                apiResult.data       = _data;
                apiResult.totalCount = count;
            }
            //决赛
            else if (state == 4)
            {
                var _data = data.AsEnumerable().OrderByDescending(o => o.article.expert_score).Select((o, index) => new { row = index + 1, data = o });
                if (orderby == "vote")
                {
                    _data = _data.OrderBy(o => o.data.vote_count).Skip((pageIndex - 1) * pageSize).Take(pageSize);
                }
                else if (orderby == "votedesc")
                {
                    _data = _data.OrderByDescending(o => o.data.vote_count).Skip((pageIndex - 1) * pageSize).Take(pageSize);
                }
                else if (orderby == "date")
                {
                    _data = _data.OrderBy(o => o.data.article.create_time).Skip((pageIndex - 1) * pageSize).Take(pageSize);
                }
                else if (orderby == "datedesc")
                {
                    _data = _data.Skip((pageIndex - 1) * pageSize).Take(pageSize);
                }

                apiResult.success    = true;
                apiResult.message    = "作品管理查询";
                apiResult.data       = _data;
                apiResult.totalCount = count;
            }
            else
            {
                return(new ApiPageResult()
                {
                    success = false,
                    message = "参数错误"
                });
            }

            return(apiResult);
        }