public async Task <IActionResult> AddNewsCommnet(NewsCommentDto newsCommentDto)
{
BaseDataResultDto baseDataResultDto = new BaseDataResultDto();
baseDataResultDto.Code = 1;
if (!ModelState.IsValid)
{
baseDataResultDto.Code = 1;
baseDataResultDto.Msg = "评论的格式不对";
}
else
{
//获取登录用户的userId
var claim = GetClaim(HttpContext.User.Claims, ClaimTypes.Sid);
if (claim != null)
{
newsCommentDto.PostId = int.Parse(claim.Value);
}
if (await this._newsCommentService.AddNewsComment(newsCommentDto))
{
baseDataResultDto.Code = 0;
baseDataResultDto.Msg = "添加评论成功";
await _newsService.UpdateCommentNum(newsCommentDto.NewsId, 1);
}
}
return(Json(baseDataResultDto));
}
/// <summary>
/// 创建评论回复界面
/// </summary>
/// <param name="newsCommentDto"></param>
/// <returns></returns>
private string CreateCommentOperator(NewsCommentDto newsCommentDto, string userName)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.AppendLine("<div class='comment_operator'>");
//stringBuilder.AppendLine($" <span class='comment_reply'>回复</span>");
stringBuilder.AppendLine(" <div class='replyBox' style='display: none'>");
//stringBuilder.AppendLine($" <span id = 'repalyId{blogCommentDto.BCId}' class='commentId' style='display: none'>{blogCommentDto.BCId}</span>");
stringBuilder.AppendLine(" <div class='comment_replyer'>");
if (string.IsNullOrEmpty(userName))
{
stringBuilder.AppendLine(" 昵称：<input class='repalyTitle' type='text' value='匿名用户' />");
}
else
{
stringBuilder.AppendLine($" 昵称：<input class='repalyTitle' type='text' readonly='readonly' value='{userName}' />");
}
stringBuilder.AppendLine(" </div>");
stringBuilder.AppendLine(" <div class='comment_replycontent'>");
stringBuilder.AppendLine(" <textarea maxlength='800' cols='80' rows='5' class='repalyContent' ></textarea>");
stringBuilder.AppendLine(" </div>");
stringBuilder.AppendLine(" <div class='comment_replybutton'>");
stringBuilder.AppendLine($" <input class='repalyButton' refid='{newsCommentDto.NId}' type='button' value='发表' /><input class='closeButton' refid='{newsCommentDto.NId}' type='button' value='关闭' />");
stringBuilder.AppendLine(" </div>");
stringBuilder.AppendLine(" </div>");
stringBuilder.AppendLine("</div>");
return(stringBuilder.ToString());
}
/// <summary>
/// 添加博客评论
/// </summary>
/// <param name="blogDto"></param>
/// <returns></returns>
public async Task <bool> AddNewsComment(NewsCommentDto newsCommentDto)
{
string sql = "insert into `newscomment`(NewsId,ReferenceId,PostId,PostName,Content,PostDate) VALUES(@NewsId,@ReferenceId,@PostId,@PostName,@Content,@PostDate)";
using (var connect = CreateConnection())
{
return(await connect.ExecuteAsync(sql, new { NewsId = newsCommentDto.NewsId, ReferenceId = newsCommentDto.ReferenceId, PostId = newsCommentDto.PostId, PostName = newsCommentDto.PostName, Content = newsCommentDto.Content, PostDate = DateTime.Now }) > 0);
}
}
// 向quoteList中添加 符合条件的Comment
private void AddComment(List <NewsCommentDto> list, List <NewsCommentDto> quoteList, NewsCommentDto newsCommentDto)
{
NewsCommentDto fncd = list.FirstOrDefault(p => p.NId == newsCommentDto.ReferenceId);
if (fncd != null)
{
quoteList.Add(fncd);
AddComment(list, quoteList, fncd); // 递归调用，只要ReferenceId不为零，就加入到引用评论列表
}
}
public ActionResult NewsFormPartial(NewsCommentDto model)
{
var result = new QsResult();
if (!Request.IsAjaxRequest())
{
return(new EmptyResult());
}
model.CreateTime = DateTime.Now;
model.UniqueKey = Utilities.GetRamCodeOnDate();
if (System.Web.HttpContext.Current.Request.IsAuthenticated)
{
var curUser = CustomAuthorizeAttribute.GetUser();
if (curUser.UserId == model.IsMember)
{
if (ModelState.IsValid)
{
//result.Success = true;
//result.Message = @"用户登陆状态下验证成功";
_commentService.AddNewsComment(model);
var newModel = _commentService.GetNewestCommentInNewsWithFilter(model.UniqueKey);
return(PartialView("_SegmentPartial", newModel));
}
result.Success = false;
result.Message = @"用户登陆状态下验证失败~~";
return(Json(result));
}
result.Success = false;
result.Message = @"用户的编号在客户端被修改，导致内容不一致";
return(Json(result));
}
if (ModelState.IsValid)
{
//result.Success = true;
//result.Message = @"游客状态下验证成功";
//return Json(result);
if (String.IsNullOrEmpty(model.NickName))
{
model.NickName = @"[匿名用户]";
}
_commentService.AddNewsComment(model);
var newModel = _commentService.GetNewestCommentInNewsWithFilter(model.UniqueKey);
return(PartialView("_SegmentPartial", newModel));
}
result.Success = false;
result.Message = @"游客状态下验证失败";
return(Json(result));
}
public ActionResult _NewsFormPartial(Int64 id)
{
var model = new NewsCommentDto {
NewsId = id
};
if (!System.Web.HttpContext.Current.Request.IsAuthenticated)
{
return(PartialView(model));
}
var curUser = CustomAuthorizeAttribute.GetUser();
model.IsMember = curUser.UserId;
model.NickName = curUser.UserName;
model.Email = curUser.Email;
return(PartialView(model));
}
//private string CreateComment_Detail(BlogCommentDto blogCommentDto, string userName, string reference)
//{
// StringBuilder stringBuilder = new StringBuilder();
// stringBuilder.AppendLine("<div class='comment_detail'>");
// stringBuilder.AppendLine($" <div class='comment_title'>{blogCommentDto.PostName}<span class='comment_date'>发表于：{blogCommentDto.PostDate}</span></div>");
// if (string.IsNullOrEmpty(reference))
// {
// stringBuilder.AppendLine($" <div class='comment_content'>{blogCommentDto.Content}</div>");
// }
// else
// {
// stringBuilder.AppendLine($" <div class='comment_content'>{reference}</div>");
// stringBuilder.AppendLine($" <div class='comment_content'>{blogCommentDto.Content}</div>");
// }
// //回复界面
// stringBuilder.AppendLine(CreateCommentOperator(blogCommentDto, userName));
// stringBuilder.AppendLine("</div>");
// return stringBuilder.ToString();
//}
///// <summary>
///// 创建评论回复界面
///// </summary>
///// <param name="blogCommentDto"></param>
///// <returns></returns>
//private string CreateCommentOperator(BlogCommentDto blogCommentDto, string userName)
//{
// StringBuilder stringBuilder = new StringBuilder();
// stringBuilder.AppendLine("<div class='comment_operator'>");
// stringBuilder.AppendLine($" <span class='comment_reply' id='comment_reply{blogCommentDto.BCId}' commentid='{blogCommentDto.BCId}'>回复</span>");
// stringBuilder.AppendLine(" <div class='replyBox' style='display: none'>");
// //stringBuilder.AppendLine($" <span id = 'repalyId{blogCommentDto.BCId}' class='commentId' style='display: none'>{blogCommentDto.BCId}</span>");
// stringBuilder.AppendLine(" <div class='comment_replyer'>");
// if (string.IsNullOrEmpty(userName))
// {
// stringBuilder.AppendLine($" 昵称：<input id = 'repalyTitle{blogCommentDto.BCId}' class='repalyTitle' type='text' value='匿名用户' />");
// }
// else
// {
// stringBuilder.AppendLine($" 昵称：<input id = 'repalyTitle{blogCommentDto.BCId}' class='repalyTitle' type='text' readonly='readonly' value='{userName}' />");
// }
// stringBuilder.AppendLine(" </div>");
// stringBuilder.AppendLine(" <div class='comment_replycontent'>");
// stringBuilder.AppendLine($" <textarea id = 'repalyContent{blogCommentDto.BCId}' class='repalyContent' maxlength'800' cols='80' rows='5'></textarea>");
// stringBuilder.AppendLine(" </div>");
// stringBuilder.AppendLine(" <div class='comment_replybutton'>");
// stringBuilder.AppendLine($" <input id = 'repalyButton{blogCommentDto.BCId}' class='repalyButton' refid='{blogCommentDto.BCId}' type='button' value='发表' /><input id = 'closeButton{blogCommentDto.BCId}' class='closeButton' refid='{blogCommentDto.BCId}' type='button' value='关闭' />");
// stringBuilder.AppendLine(" </div>");
// stringBuilder.AppendLine(" </div>");
// stringBuilder.AppendLine("</div>");
// return stringBuilder.ToString();
//}
private string CreateComment_Detail(NewsCommentDto newsCommentDto, string userName, string reference)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.AppendLine("<div class='comment_detail'>");
stringBuilder.AppendLine($" <div class='comment_title'>{newsCommentDto.PostName}<span class='comment_date'>发表于：{newsCommentDto.PostDate}</span><span class='comment_reply'>回复</span></div>");
//stringBuilder.AppendLine(" <span class='comment_reply'>回复</span>");
if (string.IsNullOrEmpty(reference))
{
stringBuilder.AppendLine($" <div class='comment_content'>{newsCommentDto.Content}</div>");
}
else
{
stringBuilder.AppendLine($" <div class='comment_content'>{reference}</div>");
stringBuilder.AppendLine($" <div class='comment_content'>{newsCommentDto.Content}</div>");
}
//回复界面
stringBuilder.AppendLine(CreateCommentOperator(newsCommentDto, userName));
stringBuilder.AppendLine("</div>");
return(stringBuilder.ToString());
}
/// <summary>
/// 获取新闻所有评论
/// </summary>
/// <param name="newsId"></param>
/// <returns></returns>
public async Task <DataResultDto <List <NewsCommentDto> > > GetList(long newsId)
{
DataResultDto <List <NewsCommentDto> > dataResultDto = new DataResultDto <List <NewsCommentDto> >();
List <NewsCommentDto> list = new List <NewsCommentDto>();
string sql = "select NId,NewsId,ReferenceId,PostId,PostName,Content,PostDate,user.UserName,user.UserId from newscomment left join user on user.UserId=newscomment.PostId where NewsId=@NewsId and newscomment.IsDelete=0";
IEnumerable <NewsComment> bClist = null;
using (var connection = CreateConnection())
{
bClist = await connection.QueryAsync <NewsComment, User, NewsComment>(sql, (qNewsComment, quser) =>
{
qNewsComment.User = quser;
return(qNewsComment);
}
, new { NewsId = newsId }
, splitOn : "UserName");
}
NewsCommentDto newsCommentDto = null;
foreach (var ibc in bClist)
{
newsCommentDto = Mapper.Map <NewsComment, NewsCommentDto>(ibc);
if (ibc.PostId != 0)
{
newsCommentDto.PostId = ibc.User.UserId;
newsCommentDto.PostName = ibc.User.UserName;
}
else
{
newsCommentDto.PostId = ibc.PostId;
newsCommentDto.PostName = ibc.PostName;
}
list.Add(newsCommentDto);
}
dataResultDto.Code = 0;
dataResultDto.DataList = list;
return(dataResultDto);
}
/// <summary>
/// 获取用户博客的 最新的 几条博客
/// </summary>
/// <param name="userId"></param>
/// <param name="topCount"></param>
/// <returns></returns>
public async Task <DataResultDto <List <NewsCommentDto> > > GetNewsCommentByUserId(int topCount)
{
DataResultDto <List <NewsCommentDto> > dataResultDto = new DataResultDto <List <NewsCommentDto> >();
string sql = $"select NId,NewsId,ReferenceId,PostId,PostName,Content,PostDate from newscomment where IsDelete=0 order by PostDate desc limit 0,{topCount}";
IEnumerable <NewsComment> bClist = null;
using (var connection = CreateConnection())
{
bClist = await connection.QueryAsync <NewsComment>(sql);
}
List <NewsCommentDto> list = new List <NewsCommentDto>();
NewsCommentDto newsCommentDto = null;
foreach (var ibc in bClist)
{
newsCommentDto = Mapper.Map <NewsComment, NewsCommentDto>(ibc);
list.Add(newsCommentDto);
}
dataResultDto.Code = 0;
dataResultDto.DataList = list;
return(dataResultDto);
}
public void AddNewsComment(NewsCommentDto commentDto)
{
_newsRepository.Add(QsMapper.CreateMap <NewsCommentDto, NewsComment>(commentDto));
_newsRepository.UnitOfWork.Commit();
IncreaseCommentNumsOf("News", commentDto.NewsId);
}
