public ActionResult TwoPlAddJson()
{
//var user = Session["User"] as User;
//User user1 = new User();
//if (user == null)
//{
var userName = "******";
var userId = Guid.Parse("9393ed42-7b3f-e711-afa3-002564ba5c19");
//}
string Content = Request.Form["Content"];
Guid ToTwoCommentsId = Guid.Parse(Request.Form["ToTwoCommentsId"]);
Guid ToCommentsId = Guid.Parse("00000000-0000-0000-0000-000000000000");
if (!string.IsNullOrEmpty(Request.Form["ChildId"]))
{
ToCommentsId = Guid.Parse(Request.Form["ChildId"]);
}
ServiceComments service = new ServiceComments();
bool isWhere = service.GetTwoPlAdd(ToCommentsId, ToTwoCommentsId, Content, userId, userName);
int ReplyNum = 0;
if (isWhere == true)
{
//新增回复数量
service.GetGetTwoReplyNum(ToCommentsId);
using (CupcakeEntities db = new CupcakeEntities())
{
ReplyNum = db.Comments.Where(m => m.Id == ToCommentsId && m.IsDelete == false).SingleOrDefault().ReplyNum;
}
}
return(Json(new { isWhere = isWhere, ReplyNum = ReplyNum }));
}
//首次加载显示所有评论数量
public ActionResult AllReplyNum()
{
if (Baseid == Guid.Parse("00000000-0000-0000-0000-000000000000"))
{
return(Json(null));
}
ServiceComments service = new ServiceComments();
int count = service.GetReplyNum(Baseid);
return(Json(count));
}
//评论列表
public ActionResult PlListJson(int PgaeIndex, string sort, Guid?ChildId)
{
//把id赋值给全局信息id
if (ChildId != null)
{
Baseid = ChildId;
}
Baseid = Guid.Parse("8bab4317-63a5-4955-bfc4-05e39b6eef07");
if (Baseid == Guid.Parse("00000000-0000-0000-0000-000000000000"))
{
return(Json(null));
}
int PageSize = 5;
using (CupcakeEntities db = new CupcakeEntities())
{
ServiceComments service = new ServiceComments();
var model = db.Comments.GroupJoin(
db.Comments_Praise,
ListCommentsModel => ListCommentsModel.Id,
b => b.ChildId,
(ListCommentsModel, b) => new
{
ListCommentsModel,
b
}).Select(m => m).ToList();
var list = model.Where(m => m.ListCommentsModel.ChildId == Baseid).OrderByDescending(m => m.ListCommentsModel.PraiseNum).ThenByDescending(m => m.ListCommentsModel.PublicDate)
.Skip((PgaeIndex - 1) * PageSize).Take(PageSize).ToList();
if (sort == "PublicDate")
{
list = model.Where(m => m.ListCommentsModel.ChildId == Baseid).OrderByDescending(m => m.ListCommentsModel.PublicDate).ThenByDescending(m => m.ListCommentsModel.PraiseNum)
.Skip((PgaeIndex - 1) * PageSize).Take(PageSize).ToList();
}
else if (sort == "PraiseNum")
{
list = model.Where(m => m.ListCommentsModel.ChildId == Baseid).OrderByDescending(m => m.ListCommentsModel.PraiseNum).ThenByDescending(m => m.ListCommentsModel.PublicDate)
.Skip((PgaeIndex - 1) * PageSize).Take(PageSize).ToList();
}
CommentsModel models = new CommentsModel();
models.PageTotal = model.Where(m => m.ListCommentsModel.ChildId == Baseid).Count();
models.PageIndex = PgaeIndex;
models.PageSize = PageSize;
return(Json(new { list = list, models = models }, JsonRequestBehavior.AllowGet));
}
}
//二级评论列表
public ActionResult TwoPlShowJson(Guid Childid)
{
using (CupcakeEntities db = new CupcakeEntities())
{
ServiceComments service = new ServiceComments();
var model = db.Comments.GroupJoin(
db.Comments_Praise,
ListCommentsModel => ListCommentsModel.Id,
b => b.ChildId,
(ListCommentsModel, b) => new
{
ListCommentsModel,
b
}).Select(m => m).ToList();
var list = model.Where(m => m.ListCommentsModel.ToCommentsId == Childid).OrderByDescending(m => m.ListCommentsModel.PublicDate).ToList();
return(Json(list, JsonRequestBehavior.AllowGet));
}
}
//点赞
public ActionResult PraiseJson(string Userid, string ChildId)
{
//result=1 点赞成功
//result=2 取消点赞
//result=3 用户未登录
int result2 = 0;
Userid = "9393ed42-7b3f-e711-afa3-002564ba5c19";
int num = 0;
if (Userid != "" && ChildId != "")
{
ServiceComments_Praise ServiceComments_Praise = new Services.ServiceComments_Praise();
Comments_Praise Comments_Praise = new Comments_Praise();
Comments_Praise.UserId = Guid.Parse(Userid);
Comments_Praise.ChildId = Guid.Parse(ChildId);
int result1 = ServiceComments_Praise.PraiseAdd(Comments_Praise);
if (result1 > 0)
{
ServiceComments ServiceComments = new ServiceComments();
result2 = ServiceComments.PraisePlusOne(Guid.Parse(ChildId), result1);
}
using (CupcakeEntities db = new CupcakeEntities())
{
Guid uid = Guid.Parse(Userid);
Guid cid = Guid.Parse(ChildId);
if (db.Comments.Where(m => m.Id == cid).Count() > 0)
{
num = db.Comments.Where(m => m.Id == cid).SingleOrDefault().PraiseNum;
}
};
}
else
{
result2 = 3;
}
return(Json(new { result = result2, num = num }, JsonRequestBehavior.AllowGet));
}
public ActionResult PartialPlAddd()
{
if (Baseid == Guid.Parse("00000000-0000-0000-0000-000000000000"))
{
return(Json(null));
}
var JsonData = Request.Form["JsonData"];
//var user = Session["User"] as User;
//User user1 = new User();
//if (user == null)
//{
var userName = "******";
var userId = Guid.Parse("9393ed42-7b3f-e711-afa3-002564ba5c19");
//}
string Content = Request.Form["Content"];
string Title = Request.Form["title"];
ServiceComments service = new ServiceComments();
bool isWhere = service.GetPlAdd(Baseid, Content, userId, userName, Title);
int count = service.GetReplyNum(Baseid);
return(Json(new { isWhere = isWhere, count = count }));
}
