//
#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));
}