user_add.aspx.cs

该商品销售管理系统是一个基于WEB的适应于小型企业的管理系统！可以实现商品基本信息的查询。添加

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;
using LoginCheckClass;


public partial class 系统设置_Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)    //检查页面是否登陆过
    {
        LoginCheck a = new LoginCheck();
        a.check();
    }



    protected void Button2_Click(object sender, EventArgs e) //定义Button_2添加按钮得click事件
    {
        try
        {
            using (SqlConnection conn = new SqlConnection(_connectString))  //连接数据库
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = "SELECT COUNT(*) FROM tb_User WHERE username=@username";  //检查输入在textbox1中的用户名在数据库中是否已存在
                    cmd.Parameters.Add("@username", SqlDbType.VarChar, 50).Value = this.TextBox1 .Text;
                    SqlDataReader reader = cmd.ExecuteReader();
                    reader.Read();
                    int rowselected = Convert.ToInt32(reader[0]);
                    reader.Close();
                    if (rowselected == 0)   //利用返回行数判定是否已存在输入得用户名,如果等于0,那么说明不存在输入的用户名,可以添加
                    {
                        code codeuser_add = new code();
                        string InitialData = this.TextBox2 .Text; 
                        string Finaldata = codeuser_add.Encrypt(InitialData);
                        cmd.Parameters.Clear();
                        cmd.CommandText = "INSERT INTO tb_User(tb_User.username,tb_User.userpwd,tb_User.AddTime) VALUES (@username,@password,@AddTime)";    //根据输入数据插入usename,userpwd,addtime三项数据
                        cmd.Parameters.Add("@username", SqlDbType.VarChar, 50).Value = this.TextBox1 .Text;
                        cmd.Parameters.Add("@password", SqlDbType.VarChar, 50).Value = Finaldata;
                        cmd.Parameters.Add("@AddTime", SqlDbType.DateTime).Value = DateTime.Now.ToLongTimeString();
                        cmd.ExecuteNonQuery();
                        Response.Write("<script>alert('添加用户成功！');</script>");
                        this.TextBox1.Text = "";   //添加后自动清空textbox对话框得信息
                        this.TextBox2 .Text = "";
                    }
                    else  //利用if...else...判定另一种情况,就是所输入用户名已存在,显示对话框信息为"该用户已存在,请再次输入!"
                    {
                        Response.Write("<script>alert('该用户已存在，请再次输入！');</script>");
                        this.TextBox1 .Text = "";
                        this.TextBox2 .Text = "";
                    }
                }
            }
        }
        catch (Exception ex)
        {

        }
    }
    private static readonly string _connectString = System.Configuration.ConfigurationManager.ConnectionStrings["db_sellConnectionString"].ConnectionString;

}