protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["id"] == null) { Response.Redirect("./Film.aspx?id=1"); } int id = int.Parse(Request.QueryString["id"]); film = filmsService.GetFilmInfo(id); if (film == null) { Response.Redirect("./Film.aspx?id=1"); } dir = dirService.GetDirIntroduction(id); StringBuilder sb = new StringBuilder(); List <ActorsService.actorIntroduction> actorsList; actorsList = actorsService.GetActorIntroductions(id); foreach (var actor in actorsList) { sb.Append("<li class='celebrity'>"); sb.Append("<img src='" + actor.actorPic + "' onclick=\"window.open('./Celebrity.aspx?actor=" + actor.actorId + "','_self')\" />"); sb.Append("<div>"); sb.Append("<a href='./Celebrity.aspx?actor=" + actor.actorId + "'>" + actor.actorName + "</a>"); if (actor.actorRole != null) { sb.Append("<br />"); sb.Append("<span>饰:" + actor.actorRole + "</span>"); } sb.Append("</div></li>"); } ActorsList = sb.ToString(); sb.Clear(); List <CommentsService.Comment> commentList; commentList = commentsService.GetFilmComments(id); foreach (var comment in commentList) { sb.Append("<li class='comment-container'>"); sb.Append("<div class='comment-container-img'>"); sb.Append("<img src='" + comment.userPic + "' />"); sb.Append("</div>"); sb.Append("<div class='comment-container-body'>"); sb.Append("<p>" + comment.userComment.userName + "</p>"); sb.Append("<span>" + comment.userComment.commentDate + "</span>"); sb.Append("<div class='comment-container-body-rate' id='" + comment.userComment.userName + "'></div>"); sb.Append("<br />"); sb.Append("<p>" + comment.userComment.filmComment + "</p>"); sb.Append("</div></li>"); } CommentList = sb.ToString(); sb.Clear(); foreach (var comment in commentList) { sb.Append("var " + comment.userComment.userName + "=rate.render({elem:'#" + comment.userComment.userName + "',value:" + (float)comment.userComment.userRate / 2 + ",half: true,readonly: true});"); } ScriptList = sb.ToString(); }
private void UpdateRate(int filmId) { var sum = (from f in db.userComment where f.filmId == filmId select f.userRate).Sum(); var num = (from f in db.userComment where f.filmId == filmId select f.userRate).Count(); filmInfo film = (from f in db.filmInfo where f.filmId == filmId select f).Single(); film.filmRating = (decimal)sum / num; film.filmRatingNum = num; db.SubmitChanges(); }