mp-ap/Areas/Api/Controllers/v1/Activity/ActivityRecommendKingController.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Data;
using Microsoft.AspNetCore.Mvc;
using Microsoft.AspNetCore.Http;
using Microsoft.Extensions.Logging;
using Microsoft.Extensions.Options;
using Microsoft.AspNetCore.Authorization;
using System.Web;
using MySystem.MainModels;
using LitJson;
using Library;

namespace MySystem.Areas.Api.Controllers.v1
{
    [Area("Api")]
    [Route("Api/v1/[controller]/[action]")]
    public class ActivityRecommendKingController : BaseController
    {
        public ActivityRecommendKingController(IHttpContextAccessor accessor, ILogger<BaseController> logger, IOptions<Setting> setting) : base(accessor, logger, setting)
        {
            OtherMySqlConn.connstr = Library.ConfigurationManager.AppSettings["SqlConnStr"].ToString();
        }

        #region 创客-开机王
        [Authorize]
        public JsonResult List(string value)
        {
            value = DesDecrypt(value);
            JsonData data = JsonMapper.ToObject(value);
            Dictionary<string, object> Other = new Dictionary<string, object>();
            List<Dictionary<string, object>> Obj = ListDo(value, out Other);
            return Json(new AppResultJson() { Status = "1", Info = "", Data = Obj, Other = Other });
        }

        public List<Dictionary<string, object>> ListDo(string value, out Dictionary<string, object> Other)
        {
            JsonData data = JsonMapper.ToObject(value);
            List<Dictionary<string, object>> Obj = new List<Dictionary<string, object>>();
            int PageSize = int.Parse(function.CheckInt(data["PageSize"].ToString()));
            int PageNum = int.Parse(function.CheckInt(data["PageNum"].ToString()));
            int SkipNum = PageSize * (PageNum - 1);
            var days = (int)DateTime.Now.DayOfWeek - 1;
            DateTime start = DateTime.Parse(DateTime.Now.AddDays(-days).ToString("yyyy-MM-dd") + " 00:00:00");
            DateTime end = start.AddDays(6);
            Other = new Dictionary<string, object>();
            Other.Add("StratTime", start.ToString("yyyy-MM-dd"));
            Other.Add("EndTime", end.ToString("yyyy-MM-dd"));
            string check = RedisDbconn.Instance.Get<string>("ActivityRecommendKing");
            if(!string.IsNullOrEmpty(check))
            {
                return Newtonsoft.Json.JsonConvert.DeserializeObject<List<Dictionary<string, object>>>(check);
            }
            var a = Convert.ToInt32(start.ToString("yyyyMMdd"));
            var b = Convert.ToInt32(end.ToString("yyyyMMdd"));
            DataTable dt = OtherMySqlConn.dtable("SELECT UserId,sum(ActiveBuddyMerStatus) Sum FROM UserTradeMonthSummary where SeoKeyword >= '" + a + "' and SeoKeyword <= '" + b + "'and SeoTitle='self' GROUP BY UserId ORDER BY Sum DESC LIMIT " + SkipNum + "," + PageSize + "");
            foreach (DataRow item in dt.Rows)
            {
                Dictionary<string, object> obj = new Dictionary<string, object>();
                var query = maindb.Users.FirstOrDefault(m => m.Id == (int)item["UserId"]);
                obj.Add("HeadPhoto", DefaultPic(query.HeadPhoto));
                obj.Add("RealName", PublicFunction.SetSensitiveName(query.RealName));
                obj.Add("MakerCode", query.MakerCode);
                obj.Add("OpenCount", int.Parse(item["Sum"].ToString()));
                Obj.Add(obj);
            }
            RedisDbconn.Instance.Set("ActivityRecommendKing", Newtonsoft.Json.JsonConvert.SerializeObject(Obj), 1800);
            return Obj;

        }
        #endregion

    }
}