book.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;

namespace BookMS
{
    public partial class bookpage : System.Web.UI.Page
    {
        public Book book;
        public BookType bookType;
        protected void Page_Load(object sender, EventArgs e)
        {
            int id=Convert.ToInt32(Request["id"]);
            BookDao bookDao = new BookDao();
            book = bookDao.GetBookById(id);
            if (book.Id == -1)
                Response.Redirect("error.aspx");
            else
            {
                book.Hot += 1;
                bookDao.UpdateBook(book);
                BookTypeDao bookTypeDao = new BookTypeDao();
                bookType=bookTypeDao.GetBookTypeById(book.Typeid);
                DataInit();
            }
            if(Session["visitor"]==null)
                div_discussbox.InnerHtml = "<div class='alert alert-warning' role='alert'>登录后可发表评论。请点击 <a class='warnlogin' data-toggle='modal' data-target='#loginModal'>登录</a></div>";
        }

        protected void DataInit() {
            string sql = "SELECT * FROM discuss INNER JOIN visitor ON discuss.visitorid = visitor.id WHERE discuss.bookid="+book.Id+" order by time DESC";
            Connect connect = new Connect();
            DataSet ds = new DataSet();
            connect.FillDataSet(ds,sql,"discusslist");
            rep_disscusslist.DataSource = ds;
            rep_disscusslist.DataBind();
            ds = new DataSet();
            connect.FillDataSet(ds, "select top 5 *,booktype.name type from book LEFT OUTER JOIN booktype ON (book.typeid=booktype.id) order by hot DESC ", "hotbook");
            rep_hotbook.DataSource = ds;
            rep_hotbook.DataBind();
            lab_script.Text = "";
        }

        protected void btn_submit_Click(object sender, EventArgs e)
        {
            Discuss discuss = new Discuss();
            DiscussDao discussDao = new DiscussDao();
            Visitor visitor = (Visitor)Session["visitor"];
            discuss.Visitorid =visitor.Id;
            discuss.Bookid = book.Id;
            discuss.Main = txt_disscuss.Value;
            discuss.Time = DateTime.Now;
            discussDao.AddDiscuss(discuss);
            txt_disscuss.Value = "";
            DataInit();
            lab_script.Text = "<script>$('#tabclick').click(); alert('发表评论成功'); </script>";