top.ascx.cs

在线小说阅读

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

namespace novel
{
    public partial class top : System.Web.UI.UserControl
    {
        DB_Class pbc = new DB_Class();
        protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void Button_Submit_Click(object sender, EventArgs e)
        {
           SqlDataReader dr = pbc.Reader("select * from novel_user1 where username='" + Text_User.Text + "'and password='" + Text_Password.Text + "'and RoleName='" + RoleName.SelectedValue + "'");
            if (dr.Read())
            {
                if (RoleName.Text == "管理员")
                {
                    Session["user"] = Text_User.Text;
                    Response.Redirect("novel.htm");
                }
                else if (RoleName.Text == "普通用户")
                {
                    Session["user"] = Text_User.Text;
                    Response.Redirect("novel2.aspx");
                }
                else
                {
                    Session["user"] = Text_User.Text;
                    Response.Redirect("novel3.aspx");
                }
            }
            else
            {
                Response.Write("<script>alert('用户名、密码或者角色错误');</script>");
            }
            dr.Close();
        }

        protected void Button_Get_Click(object sender, EventArgs e)
        {

        }

        protected void Select_Click(object sender, EventArgs e)
        {
            /*string sqlstr = null;
            if (Select_Type.Text == "0")
            {
                sqlstr = "select * from novel_topic where title  like '%" + Text_Search.Text + "%'";
            }
            else
                
                sqlstr = "select * from novel_topic where title  like '%" + Text_Search.Text + "%' and  title like '%" + Select_Type.SelectedValue + "%'";
            if (sqlstr.Read())
            {
                Response.Redirect("novel.aspc");
            }
            else
            {
                Response.Write("<script>alert('不存在此本书，请重新输入！');</script>");
            }*/

        }

    }
}