using System; using System.Collections.Generic; using System.Linq; 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 SchoolMorningMeetController : BaseController { public SchoolMorningMeetController(IHttpContextAccessor accessor, ILogger logger, IOptions setting) : base(accessor, logger, setting) { } #region 商学院-每日晨会 [Authorize] public JsonResult List(string value) { value = DesDecrypt(value); JsonData data = JsonMapper.ToObject(value); List> dataList = ListDo(value); return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList }); } public List> ListDo(string value) { JsonData data = JsonMapper.ToObject(value); int UserId = int.Parse(function.CheckInt(data["UserId"].ToString())); //创客Id string Month = data["Month"].ToString(); //月份 int PageSize = int.Parse(function.CheckInt(data["PageSize"].ToString())); int PageNum = int.Parse(function.CheckInt(data["PageNum"].ToString())); List> dataList = new List>(); IQueryable query = maindb.SchoolMorningMeet.Where(m => m.Status > -1); DateTime start = DateTime.Parse(Month.Substring(0, 4) + "-" + Month.Substring(4, 2) + "-01 00:00:00"); DateTime end = start.AddMonths(1); var s = function.ConvertDateTimeInt(start) / 60; var e = function.ConvertDateTimeInt(end) / 60; if (!string.IsNullOrEmpty(data["Month"].ToString())) { query = query.Where(m => m.Sort >= s && m.QueryCount < e); } int TotalCount = query.Count(); query = query.OrderByDescending(m => m.Sort).ThenByDescending(m => m.Id); if (PageNum == 1) { query = query.Take(PageSize); } else { int skipNum = PageSize * (PageNum - 1); query = query.Skip(skipNum).Take(PageSize); } var mydata = query.ToList(); foreach (var subdata in mydata) { int IsStudy = 0; var Info = maindb.SchoolMorningMeetLog.FirstOrDefault(m => m.MeetId == subdata.Id && m.UserId == UserId); if (Info != null) { IsStudy = 1; } var starts = subdata.Sort; var ends = subdata.QueryCount; long StartDate = (long)starts * 60000L; long EndDate = (long)ends * 60000L; Dictionary curData = new Dictionary(); curData.Add("Title", subdata.Title); //标题 curData.Add("Contents", subdata.Contents); //内容 curData.Add("StartDate", StartDate); //开始时间 curData.Add("EndDate", EndDate); //结束时间 curData.Add("Lecturer", subdata.Lecturer); //主讲 curData.Add("Photo", StudyOrMeetDefaultPic(subdata.Photo)); //照片 curData.Add("StudyPerson", subdata.StudyPerson); //学习人数 curData.Add("Url", subdata.Url); //APP外链 curData.Add("XCXId", subdata.SeoTitle); //小程序外链Id curData.Add("XCXUrl", subdata.SeoKeyword); //小程序外链 curData.Add("Again", subdata.SeoDescription); //再次观看路径 curData.Add("IsStudy", IsStudy); //是否学习 curData.Add("Id", subdata.Id); //Id curData.Add("CreateDate", subdata.CreateDate == null ? "" : subdata.CreateDate.Value.ToString("MM-dd")); //CreateDate dataList.Add(curData); } return dataList; } #endregion #region 检查签名是否合法,合法返回1,不合法返回提示信息 /// /// 检查签名是否合法,合法返回1,不合法返回提示信息 /// /// 请求的参数(json字符串) /// 要签名的字段 /// private string CheckSign(string value, string[] signField) { JsonData json = JsonMapper.ToObject(value); Dictionary dic = new Dictionary(); for (int i = 0; i < signField.Length; i++) { dic.Add(signField[i], json[signField[i]].ToString()); } string sign = json["sign"].ToString(); //客户端签名字符串 return new Sign().sign(dic, sign); } #endregion } }