/// <summary> /// 用户评论 /// </summary> /// <param name="model"></param> /// <returns></returns> public int PingLunTiTiao(Mldel.Contents.CommentModel model) { try { using (TransactionScope scope = new TransactionScope()) { using (qds105749277_dbEntities db = new qds105749277_dbEntities()) { var sql1 = db.Comment.Where(c => c.ContentId == model.ContentId).ToList(); int louceng = 1; if (sql1.Count > 0) { if (sql1.Count == 1) { louceng++; } else if (sql1.Count == 2) { louceng += 2; } else if (sql1.Count == 3) { louceng += 3; } else { louceng = (int)sql1[sql1.Count - 1].LouCeng + louceng; } } Comment cm = new Comment() { Text = model.Text, ContentId = model.ContentId, Time = model.Time, UserId = model.UserId, ZhiChi = model.ZhiChi, FanDui = model.FanDui, LouCeng = louceng }; //文章表的评论字段加一 var sql = db.Content.Where(c => c.Id == model.ContentId).FirstOrDefault(); if (sql != null) { sql.CommentNum += 1; } db.Comment.Add(cm); int res = db.SaveChanges(); scope.Complete(); return(res); } } } catch (Exception) { throw; } }
/// <summary> /// 用户评论 /// </summary> /// <param name="model"></param> /// <returns></returns> public int PingLunTiTiao(Mldel.Contents.CommentModel model) { try { ContentDAL dal = new ContentDAL(); return(dal.PingLunTiTiao(model)); } catch (Exception) { throw; } }