register.aspx.cs

C#编的网上交易站点系统。实现购买

using System;
using System.Data;
using System.Configuration;
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;

public partial class register_aspx
{
    void Button1_Click(object sender, EventArgs e)//该按钮用来插入用户信息
    {
        
        user u=new user();
        u.userid = textusername.Text ;
        u.userpwd = textuserpwd.Text ;
        u.useradd = textuseradd.Text ;
        u.useremail = textuseremail.Text;//从文本框获得用户的各项信息
        string str="select count(*) from 客户信息表 where 用户名='"+u.userid+"';";//查找该用户名是否已存在,存在则返回一
        if (dal.execscalar(str) == 1)//"1"表示用户名已存在
        {
            TextBox2.Visible = true;
            TextBox2.Text = "该用户名已存在,请重新输入用户名";
        }
        else
        {
            string str1 = "insert into 客户信息表  values (" + "'" + u.userid + "'," + "'" + u.userpwd + "'," + "'" + u.useradd + "'," + "'" + u.useremail + "','1','1000') ";//不存在,则将信息插入,提供SQL语句,后面的"1"表示默认用户等级为一,"1000"表示默认用户余额.
            dal.insert(str1);//调用数据连接层,执行插入命令
            Button2.Visible = true;
        }


    }
    
    void Button2_Click(object sender, EventArgs e)//注册完毕,页面转移
    {
            
            Response.Redirect("index.aspx");
        
    }
    void Button3_Click(object sender, EventArgs e)//该按钮用来检测用户名是否已存在
    {
        

        string str = "select count(*) from 客户信息表 where 用户名='" + textusername.Text + "';";
        if (dal.execscalar(str) == 1)//判断用户名是否存在
        {
            TextBox2.Visible = true;
            TextBox2.Text = "该用户名已存在,请重新输入用户名";
        }
        else
        {
            TextBox2.Visible = true;
            TextBox2.Text = "用户名不存在,请继续输入!";
        }


    }


}