//错误页面404 public ActionResult Error() { var list = booksbll.LoadEntities(c => true).ToList(); int[] arr = new int[] { 22, 26, 29, 49, 55, 57, 58, 59, 64, 65, 66, 67, 69, 70, 71, 74, 75, 76, 77, 89, 91, 92, 94, 95, 96, 97, 98, 100, 101 }; double[] rat = new double[] { 0.5, 1, 1.5, 2, 2.5, 3, 3.5, 4, 4.5, 5 }; int [] book = new int [list.Count]; foreach (var item in list) { book[list.IndexOf(item)] = item.Id; } Random r = new Random(); for (int i = 0; i < book.Length; i++) { int bid = book[i]; int uid = arr[r.Next(arr.Length)]; double rid = rat[r.Next(rat.Length)]; recommend_rating rmodel = new recommend_rating(); rmodel.bookID = bid; rmodel.userID = uid; rmodel.stars = rid; rmodel.addTime = DateTime.Now; ratingbll.AddEntity(rmodel); } //foreach (var item in list) //{ // int fi1 = arr[r.Next(arr.Length)]; // item.Discount = fi1; // booksbll.UpdateEntity(item); //} return(Content("ok")); }
//添加评论 public ActionResult AddComment() { int bookid = Convert.ToInt32(Request["bookid"]); if (UserInfo != null) { var bookmodel = bookbll.LoadEntities(c => c.Id == bookid).FirstOrDefault(); if (bookmodel == null) { return(Content("no:亲,该图书不存在或已被删除!")); } //首先查询 是否有资格评论 必须购买过才能评论 var isorder = orderbookbll.LoadEntities(c => c.Orders.UserId == UserInfo.Id && c.BookID == bookid).Count(); if (isorder > 0) { var iscomment = commentbll.LoadEntities(c => c.UserId == UserInfo.Id && c.BookId == bookid).Count(); if (iscomment < isorder)//可以评论 { string rating = Request["rating"]; if (string.IsNullOrEmpty(rating)) { return(Content("no:亲,请您先为该书评分,谢谢!")); } else { //查询是否评过分 var israting = ratingbll.LoadEntities(c => c.userID == UserInfo.Id && c.bookID == bookid).FirstOrDefault(); if (israting != null) { israting.stars = Convert.ToDouble(rating); israting.updateTime = DateTime.Now; ratingbll.UpdateEntity(israting); } else { recommend_rating ratingmodel = new recommend_rating(); ratingmodel.bookID = bookid; ratingmodel.userID = UserInfo.Id; ratingmodel.stars = Convert.ToDouble(rating); ratingmodel.addTime = DateTime.Now; ratingbll.AddEntity(ratingmodel); } } string msg = Request["Msg"]; if (string.IsNullOrEmpty(msg)) { return(Content("no:亲,您评论的内容不能为空哦!")); } msg = msg.Replace("<", "<").Replace(">", ">"); //替换危险字符 if (abll.CheckBanndWord(msg)) //过滤 { return(Content("no:亲,您评论的内容含有禁用词哦!")); } else if (abll.CheckModWord(msg)) { return(Content("no:亲,您评论的内容含有审查词哦!")); } else { BookComment model = new BookComment(); model.BookId = bookid; model.UserId = UserInfo.Id; model.Msg = msg; model.RegTime = DateTime.Now; commentbll.AddEntity(model); //更新图书的总体评分 var ratinglist = ratingbll.LoadEntities(c => c.bookID == bookid); double pinfen = 0; if (ratinglist.Count() > 0) { pinfen = Math.Round((double)ratinglist.Sum(c => c.stars) / (double)ratinglist.Count(), 1); } bookmodel.rating = pinfen; bookbll.UpdateEntity(bookmodel); //添加推荐日志 logbll.AddUserOperationLog(UserInfo.Id, bookid, "商品评论", "时间:" + DateTime.Now + " 地点:商品详情", "", ""); return(Content("ok:评论成功!")); } } else { return(Content("no:亲,您需要再次购买才能评论哦!:")); } } else { return(Content("no:亲,您还没有购买此商品哦!:")); } } else { return(Content("nologin:亲,登录以后才能评论哦!:" + HttpUtility.UrlEncode("/Home/ShopDetails?id=" + bookid))); } }