public JsonResult AddComment(string articleid, string content)
{
StatusData myStatusData = new StatusData(); //返回的类型
string mobilePhone = ""; //
//
#region 检查授权
AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance();
AuthCodeClass myAuthCodeClass = new AuthCodeClass();
bool checkAuthCodeBool = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance);
#endregion
if (checkAuthCodeBool)
{
mobilePhone = myAuthCodeInstance.mobilePhone;
using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
{
Teacher_Article_Comment myRecord = new Teacher_Article_Comment();
long myLong = 0;//要评论的文章
bool isOk = long.TryParse(articleid, out myLong);
if (isOk)
{
try
{
myRecord.AboutId = myLong;
myRecord.Detail = content;
myRecord.MobilePhone = mobilePhone;
myRecord.NickName = "";
myRecord.AddDate = DateTime.Now;
myRecord.Status = 200;
myOperating.Teacher_Article_Comment.Add(myRecord);
myOperating.SaveChanges();
myStatusData.operateStatus = 200;
}
catch
{
myStatusData.operateStatus = -1;
}
}
else
{
myStatusData.operateStatus = 400;
myStatusData.operateMsg = "参数错误";
}
}
}
else
{
myStatusData.operateStatus = 5;
}
return(Json(myStatusData.operateMsg));
}
//---------------------CommentList
#region 评论列表
public ActionResult CommentList(int currentpage = 1, long aboutid = 0, long del = 0)
{
#region 翻页定义
ViewBag.CurrentPage = 0; //当前页
ViewBag.PPage = 0; //上一页
ViewBag.NPage = 0; //下一页
ViewBag.PageCount = 0; //总页数
ViewBag.RecordCount = 0; //记录总数
ViewBag.IsFirstPage = ""; //第一条记录，禁用首页和上一页
ViewBag.IsEndPage = ""; //最后条记录，禁用首页和下一页
#endregion
//
ViewBag.Headline = "评论管理";//栏目主题
//
ViewBag.DataList = null;
ViewBag.RecordItem = null;
//
StatusData myStatusData = new StatusData(); //返回状态
//
using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities()) //数据库操作
{
#region 除
if (del > 0)
{
Teacher_Article_Comment myDelRecord = myOperating.Teacher_Article_Comment.FirstOrDefault(p => p.CommentId == del);
if (myDelRecord != null)
{
myOperating.Teacher_Article_Comment.Remove(myDelRecord);
myOperating.SaveChanges();
}
}
#endregion
//
#region 翻页属性
int recordCount = 0;
int pageCount = 0;
string orderbyfiled = "CommentId";
//
//当前页
int sqlCurrentpage = currentpage;
if (sqlCurrentpage < 1)
{
sqlCurrentpage = 1;
}
//页大小
int sqlPagesize = 10;
#endregion
//
#region 取出内容
IQueryable <Teacher_Article_Comment> myIQueryable = null;
if (aboutid > 0)
{
myIQueryable = myOperating.Teacher_Article_Comment.Where(p => p.AboutId == aboutid);
}
else
{
myIQueryable = myOperating.Teacher_Article_Comment;
}
//
if (myIQueryable != null)
{
List <Teacher_Article_Comment> BookTable = QueryableExtensions.OrderBy(myIQueryable, orderbyfiled, out recordCount, out pageCount, ref sqlCurrentpage, sqlPagesize, true).ToList();
//
ViewBag.DataList = BookTable;
#region 页数取值
ViewBag.CurrentPage = sqlCurrentpage;
ViewBag.PageCount = pageCount;
ViewBag.RecordCount = recordCount;
if (sqlCurrentpage > 1)
{
ViewBag.PPage = sqlCurrentpage - 1;
}
else
{
ViewBag.IsFirstPage = "disabled";
ViewBag.PPage = 1;
}
if (sqlCurrentpage < pageCount)
{
ViewBag.NPage = sqlCurrentpage + 1;
}
else
{
ViewBag.NPage = sqlCurrentpage;
ViewBag.IsEndPage = "disabled";
}
#endregion
}
#endregion
//
}
return(View());
}