regit.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;

public partial class ascx_Regit : System.Web.UI.UserControl
{
        protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)     //对用户角色的邦定
        {
        //    string connstr = "server=localhost;Database=library1;User ID=sa;Password=''";
        //    SqlConnection conn = new SqlConnection(connstr);
        //    conn.Open();
            DataControl.ConnectionControl conn = new DataControl.ConnectionControl();
            conn.DataConnetion();
            SqlCommand cmd= conn.DataCmd("select * from [Role] ");
            //SqlCommand cmd = new SqlCommand("select * from [Role] ", conn);
            RoleList.DataSource = cmd.ExecuteReader();
            RoleList.DataTextField = "RoleName";
            RoleList.DataValueField = "RoleID";
            RoleList.DataBind();
            conn.Close();

        }
    }
    protected void Inregit_Click(object sender, EventArgs e)//插入数据，不通过存储过程，参数太多。
    {     
        //string connstr = "server=localhost;Database=library1;User ID=sa;Password=''";
        //SqlConnection conn = new SqlConnection(connstr);
        //SqlCommand cmd = new SqlCommand();    
        //cmd.CommandText = "insert into UserInfo(UserID,Password,Email,RoleID,Class,Sex)values('" + tbUserName.Text.Trim() + "','" + tbUserPassword.Text.Trim() + "','" + tbEmail.Text.Trim() + "','" + RoleList.SelectedValue.Trim() + "','" + tbClass.Text.Trim() + "','" + SexList.SelectedValue.Trim()+ "')";
        //cmd.Connection = conn;
        DataControl.ConnectionControl conn = new DataControl.ConnectionControl();
        conn.DataConnetion();
        SqlCommand cmd= conn.DataCmd("insert into UserInfo(UserID,Password,Email,RoleID,Class,Sex)values('" + tbUserName.Text.Trim() + "','" + tbUserPassword.Text.Trim() + "','" + tbEmail.Text.Trim() + "','" + RoleList.SelectedValue.Trim() + "','" + tbClass.Text.Trim() + "','" + SexList.SelectedValue.Trim()+ "')");
        SqlDataReader dr;
        try
        {
            //conn.Open();
            if (RadioButtonList1.SelectedItem.Value == "yes")
            {
                dr = cmd.ExecuteReader();
                if (dr.RecordsAffected != 0)
                    Mes.Text = "注册成功！";//返回注册结果
            }
            else
            {
                // Response.Write("注册不成功！");
                Mes.Text = "注册不成功！";
            }
        }
        catch (Exception e2)
        {
            Response.Write(e2.Message.ToString());
        }
        finally
        {
            conn.Close();
        }

    }

    protected void Button1_Click(object sender, EventArgs e)  //验证用户名是否可用。
    {
      //string connstr = "server=localhost;Database=library1;User ID=sa;Password=''";
      //  //string strconn = ConfigurationSettings.AppSettings["library1ConnectionString"];
      //  SqlConnection conn = new SqlConnection(connstr);
      //  SqlCommand cmd = new SqlCommand("select UserID from UserInfo",conn);
        DataControl.ConnectionControl conn = new DataControl.ConnectionControl();
        conn.DataConnetion();
        SqlCommand cmd = conn.DataCmd("select UserID from UserInfo");
        try
        {
            //conn.Open();
            SqlDataReader dr = cmd.ExecuteReader();
            bool marks = true;
            while(dr.Read())
            {
                if (dr.GetString(0).Trim().Equals(tbUserName.Text))
                {
                  //Label2.Text= dr.GetString(0).Trim();
                 // bool n = dr.GetString(0).Trim().Equals(tbUserName.Text);
                  //Response.Write(n + "    " + dr.GetString(0));
                    marks = false;
                    Label2.Text = "用户名不可以被使用！"; //返回信息
                    break;
                }                
            }
            if (marks)
                Label2.Text = "用户名可以被使用";
        }
        catch (Exception es)
        {
            Response.Write(es.Message.ToString());
        }
        finally
        {
            conn.Close();
           
        }
    }
}