//错误页面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)));
}
}
