// #region 加载评论 public JsonResult CommentList(string articleid, string currentpage) { List <CommentData> myCommentDataList = new List <CommentData>(); // using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作 { #region 翻页属性 int recordCount = 0; int pageCount = 0; string orderbyfiled = "AddDate"; bool isDesc = false;//倒序 //当前页 int sqlCurrentpage = 1; if (!String.IsNullOrWhiteSpace(currentpage)) { bool isOk = int.TryParse(currentpage, out sqlCurrentpage); if (!isOk) { sqlCurrentpage = 1; } } //页大小 int sqlPagesize = 10; #endregion IQueryable <Teacher_Article_Comment> myIQueryable = null; if (!String.IsNullOrWhiteSpace(articleid)) { long myLong = 0; bool isOk = long.TryParse(articleid, out myLong); if (isOk) { myIQueryable = myOperating.Teacher_Article_Comment.Where(p => p.AboutId == myLong && p.Status == 200); } else { myIQueryable = null; } } else { myIQueryable = myOperating.Teacher_Article_Comment.Where(p => p.Status == 200); } // if (myIQueryable != null) { var EfDataTable = QueryableExtensions.OrderBy(myIQueryable, orderbyfiled, out recordCount, out pageCount, ref sqlCurrentpage, sqlPagesize, isDesc).Select(s => new { CommentId = s.CommentId, Detail = s.Detail, AddDate = s.AddDate, MobilePhone = s.MobilePhone }).ToList(); // int PageFloor = (sqlCurrentpage - 1) * sqlPagesize; //楼层计基数 int myFloor = 0; //楼层 if (EfDataTable != null) { for (int i = 0; i < EfDataTable.Count(); i++) { myFloor = PageFloor + i + 1;//楼层 #region 昵称和头像 string dataMobilePhone = EfDataTable[i].MobilePhone; DataMethodClass myDataMethodClass = new DataMethodClass(); string myHeadImage = StaticVarClass.DefaultHeadImage; //头像 string myNickName = "匿名"; //昵称 myDataMethodClass.GetNickNameAndPic(dataMobilePhone, out myNickName, out myHeadImage); #endregion CommentData myCommentData = new CommentData(); myCommentData.CommentId = EfDataTable[i].CommentId; myCommentData.Detail = EfDataTable[i].Detail; DateTime myDateTime = DateTime.Now; DateTime.TryParse(EfDataTable[i].AddDate.ToString(), out myDateTime); myCommentData.DateDate = myDateTime.ToString("yyyy-MM-dd"); myCommentData.TimeDate = myDateTime.ToString("HH-mm"); myCommentData.NickName = myNickName; myCommentData.HeadImage = myHeadImage; myCommentData.FloorNum = myFloor; myCommentData.PageCount = pageCount; myCommentDataList.Add(myCommentData); } } } } return(Json(myCommentDataList)); }
public JsonResult ArticleContent(string articleid) { string mobilePhone = ""; // // StatusData myStatusData = new StatusData(); //返回状态 // #region 检查授权 AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance(); AuthCodeClass myAuthCodeClass = new AuthCodeClass(); bool checkAuthCodeBool = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance); if (checkAuthCodeBool) { mobilePhone = myAuthCodeInstance.mobilePhone; } #endregion using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作 { DiscoverDataContent myDiscoverDataContent = new DiscoverDataContent(); long myLong = 0;//文章主键 bool isLong = long.TryParse(articleid, out myLong); if (isLong) { Discover_Article myTable = myOperating.Discover_Article.FirstOrDefault(p => p.ArticlId == myLong && p.Status == 200); if (myTable != null) { #region 昵称和头像 string dataMobilePhone = myTable.MobilePhone; DataMethodClass myDataMethodClass = new DataMethodClass(); string myHeadImage = StaticVarClass.DefaultHeadImage; //头像 string myNickName = "匿名"; //昵称 myDataMethodClass.GetNickNameAndPic(dataMobilePhone, out myNickName, out myHeadImage); #endregion int myCommentTimes = 0;//评论次数 myDiscoverDataContent.ArticleId = myTable.ArticlId; myDiscoverDataContent.ArticleTitle = myTable.ArticleTitle; myDiscoverDataContent.ArticleImages = FunctionClass.GetFileUrl(myTable.ArticleImages); myDiscoverDataContent.ArticleVideo = FunctionClass.GetFileUrl(myTable.ArticleVideo); myDiscoverDataContent.ArticleContent = myTable.ArticleContent; myDiscoverDataContent.AddDate = myTable.AddDate; myDiscoverDataContent.ReadTimes = myTable.ReadTimes; myCommentTimes = myOperating.Discover_Article_Comment.Count(p => p.AboutId == myLong); // myDiscoverDataContent.CommentTimes = myCommentTimes; myDiscoverDataContent.HeadImage = myHeadImage; myDiscoverDataContent.NickName = myNickName; // #region 阅读次数加一 if (myTable.ReadTimes != null) { myTable.ReadTimes = myTable.ReadTimes + 1; } else { myTable.ReadTimes = 1; } myOperating.SaveChanges(); #endregion } myStatusData.dataTable = myDiscoverDataContent; } myStatusData.operateStatus = 200; } return(Json(myStatusData)); }
public JsonResult CommentList(string articleid, string currentpage, string pagesize) { string mobilePhone = ""; // // StatusData myStatusData = new StatusData(); //返回状态 // #region 检查授权 AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance(); AuthCodeClass myAuthCodeClass = new AuthCodeClass(); bool checkAuthCodeBool = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance); if (checkAuthCodeBool) { mobilePhone = myAuthCodeInstance.mobilePhone; } #endregion using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作 { #region 翻页属性 int recordCount = 0; int pageCount = 0; string orderbyfiled = "AddDate"; bool isDesc = true;//倒序 //当前页 int sqlCurrentpage = 1; if (!String.IsNullOrWhiteSpace(currentpage)) { bool isOk = int.TryParse(currentpage, out sqlCurrentpage); if (!isOk) { sqlCurrentpage = 1; } } //页大小 int sqlPagesize = 10; if (!String.IsNullOrWhiteSpace(pagesize)) { bool isOk = int.TryParse(pagesize, out sqlPagesize); if (!isOk) { sqlPagesize = 10; } } #endregion IQueryable <Teacher_Article_Comment> myIQueryable = null; if (!String.IsNullOrWhiteSpace(articleid)) { long myLong = 0; bool isOk = long.TryParse(articleid, out myLong); if (isOk) { myIQueryable = myOperating.Teacher_Article_Comment.Where(p => p.AboutId == myLong && p.Status == 200); } else { myIQueryable = null; } } else { myIQueryable = myOperating.Teacher_Article_Comment.Where(p => p.Status == 200); } // if (myIQueryable != null) { List <CommentData> myCommentDataList = new List <CommentData>(); var EfDataTable = QueryableExtensions.OrderBy(myIQueryable, orderbyfiled, out recordCount, out pageCount, ref sqlCurrentpage, sqlPagesize, isDesc).Select(s => new { CommentId = s.CommentId, Detail = s.Detail, AddDate = s.AddDate, MobilePhone = s.MobilePhone }).ToList(); // if (EfDataTable != null) { for (int i = 0; i < EfDataTable.Count(); i++) { #region 昵称和头像 string dataMobilePhone = EfDataTable[i].MobilePhone; DataMethodClass myDataMethodClass = new DataMethodClass(); string myHeadImage = StaticVarClass.DefaultHeadImage; //头像 string myNickName = "匿名"; //昵称 myDataMethodClass.GetNickNameAndPic(dataMobilePhone, out myNickName, out myHeadImage); #endregion CommentData myCommentData = new CommentData(); myCommentData.CommentId = EfDataTable[i].CommentId; myCommentData.Detail = EfDataTable[i].Detail; myCommentData.AddDate = EfDataTable[i].AddDate; myCommentData.NickName = myNickName; myCommentData.HeadImage = myHeadImage; myCommentDataList.Add(myCommentData); } } // myStatusData.dataPageCount = pageCount; myStatusData.dataRecordCount = recordCount; myStatusData.dataTable = myCommentDataList; } myStatusData.operateStatus = 200; } return(Json(myStatusData)); }
public JsonResult ArticleList(string currentpage, string pagesize) { string mobilePhone = ""; // // StatusData myStatusData = new StatusData(); //返回状态 // #region 检查授权 AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance(); AuthCodeClass myAuthCodeClass = new AuthCodeClass(); bool checkAuthCodeBool = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance); if (checkAuthCodeBool) { mobilePhone = myAuthCodeInstance.mobilePhone; } #endregion using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作 { #region 翻页属性 int recordCount = 0; int pageCount = 0; string orderbyfiled = "ArticlId"; bool isDesc = true;//倒序 //当前页 int sqlCurrentpage = 1; if (!String.IsNullOrWhiteSpace(currentpage)) { bool isOk = int.TryParse(currentpage, out sqlCurrentpage); if (!isOk) { sqlCurrentpage = 1; } } //页大小 int sqlPagesize = 10; if (!String.IsNullOrWhiteSpace(pagesize)) { bool isOk = int.TryParse(pagesize, out sqlPagesize); if (!isOk) { sqlPagesize = 10; } } #endregion IQueryable <Discover_Article> myIQueryable = null; myIQueryable = myOperating.Discover_Article.Where(p => p.Status == 200); // if (myIQueryable != null) { List <DiscoverDataItem> DiscoverDataItemList = new List <DiscoverDataItem>(); var EfDataTable = QueryableExtensions.OrderBy(myIQueryable, orderbyfiled, out recordCount, out pageCount, ref sqlCurrentpage, sqlPagesize, isDesc).Select(s => new { ArticlId = s.ArticlId, ArticleTitle = s.ArticleTitle, ArticleImages = s.ArticleImages, AddDate = s.AddDate, ReadTimes = s.ReadTimes, MobilePhone = s.MobilePhone }).ToList(); if (EfDataTable != null) { for (int i = 0; i < EfDataTable.Count(); i++) { #region 昵称和头像 string dataMobilePhone = EfDataTable[i].MobilePhone; DataMethodClass myDataMethodClass = new DataMethodClass(); string myHeadImage = StaticVarClass.DefaultHeadImage; //头像 string myNickName = "匿名"; //昵称 myDataMethodClass.GetNickNameAndPic(dataMobilePhone, out myNickName, out myHeadImage); #endregion int myCommentTimes = 0; //评论次数 long myArticlId = 0; //文章主键 myArticlId = EfDataTable[i].ArticlId; DiscoverDataItem myDiscoverDataItem = new DiscoverDataItem(); myDiscoverDataItem.ArticleId = myArticlId; myDiscoverDataItem.ArticleTitle = EfDataTable[i].ArticleTitle; myDiscoverDataItem.ReadTimes = EfDataTable[i].ReadTimes; myDiscoverDataItem.AddDate = EfDataTable[i].AddDate; // myDiscoverDataItem.NickName = myNickName; myDiscoverDataItem.HeadImage = myHeadImage; // myCommentTimes = myOperating.Discover_Article_Comment.Count(p => p.AboutId == myArticlId); // myDiscoverDataItem.CommentTimes = myCommentTimes; // DiscoverDataItemList.Add(myDiscoverDataItem); } } myStatusData.dataPageCount = pageCount; myStatusData.dataRecordCount = recordCount; myStatusData.dataTable = DiscoverDataItemList; } myStatusData.operateStatus = 200; } return(Json(myStatusData)); }