using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace 在线预约
{
    public partial class frm_userzc : Form
    {
        public frm_userzc()
        {
            InitializeComponent();
        }

        private void label1_Click(object sender, EventArgs e)
        {

        }

        private void textBox2_TextChanged(object sender, EventArgs e)
        {

        }

        private void frm_userzc_Load(object sender, EventArgs e)
        {

        }

        private void textBox6_TextChanged(object sender, EventArgs e)
        {

        }

        private void textBox7_TextChanged(object sender, EventArgs e)
        {

        }

        private void btn_zc_Click(object sender, EventArgs e)
        {
            if (this.txtbx_id.Text.Trim() == "")                                                      //若用户号文本框为空；
            {
                MessageBox.Show("帐号不能为空！");                                                    //给出错误提示；
                this.txtbx_id.Focus();                                                                //用户号文本框获得焦点；
                return;                                                                                 //返回；
            }
            if (this.txtbx_psw.Text.Trim() == "")                                                    
            {
                MessageBox.Show("密码不能为空！");                                                    
                this.txtbx_psw.Focus();                                                              
                return;                                                                              
            }
            if (this.txtbx_pswagain.Text.Trim() == "")
            {
                MessageBox.Show("确认密码不能为空！");
                this.txtbx_pswagain.Focus();
                return;
            }
            if (this.txtbx_name.Text.Trim() == "")
            {
                MessageBox.Show("姓名不能为空！");
                this.txtbx_name.Focus();
                return;
            }
            if (this.txtbx_phone.Text.Trim() == "")
            {
                MessageBox.Show("电话不能为空！");
                this.txtbx_phone.Focus();
                return;
            }
            if (this.txtbx_psw.Text.Trim() != this.txtbx_pswagain.Text.Trim()) {
                MessageBox.Show("密码和确认密码要一致！");
            }
            SqlConnection sqlConnection = new SqlConnection();                                          //声明并实例化SQL连接；
            sqlConnection.ConnectionString =
                "Server=(local);Database=ZXYY;Integrated Security=sspi";                         //在字符串变量中，描述连接字符串所需的服务器地址、数据库名称、集成安全性（即是否使用Windows验证）；
            SqlCommand sqlCommand = sqlConnection.CreateCommand();                                      //调用SQL连接的方法CreateCommand来创建SQL命令；该命令将绑定SQL连接；
            sqlCommand.CommandText =
                "INSERT 会员 (帐号,密码,姓名,性别,年龄,介绍,地址,联系电话) VALUES(@帐号,HASHBYTES('MD5',@密码),@姓名,@性别,@年龄,@介绍,@地址,@联系电话);";                 //指定SQL命令的命令文本；命令文本包含参数；
            sqlCommand.Parameters.AddWithValue("@帐号", this.txtbx_id.Text.Trim());                     //向SQL命令的参数集合添加参数的名称、值；
            sqlCommand.Parameters.AddWithValue("@密码", this.txtbx_psw.Text.Trim());
            sqlCommand.Parameters.AddWithValue("@姓名", this.txtbx_name.Text.Trim());
            sqlCommand.Parameters["@密码"].SqlDbType = SqlDbType.VarChar;  
            //将密码参数的类型设为变长字符串；
            if (radiobtn_f.Checked == true)
            {
                sqlCommand.Parameters.AddWithValue("@性别", this.radiobtn_f.Text.Trim());
            }
            if (radiobtn_m.Checked == true)
            {
                sqlCommand.Parameters.AddWithValue("@性别", this.radiobtn_m.Text.Trim());
            }
            sqlCommand.Parameters.AddWithValue("@年龄", this.txtbx_old.Text.Trim());
            sqlCommand.Parameters.AddWithValue("@介绍", this.txtbx_js.Text.Trim());
            sqlCommand.Parameters.AddWithValue("@地址", this.txtbx_address.Text.Trim());
            sqlCommand.Parameters.AddWithValue("@联系电话", this.txtbx_phone.Text.Trim());
            sqlConnection.Open();                                                                       //打开SQL连接；
            int rowAffected = sqlCommand.ExecuteNonQuery();                                             //调用SQL命令的方法ExecuteNonQuery来执行命令，向数据库写入数据，并返回受影响行数；
            sqlConnection.Close();                                                                      //关闭SQL连接；
            if (rowAffected == 1)                                                                       //若成功写入1行记录；
            {
                MessageBox.Show("注册成功。");
                this.txtbx_id.Text = "";
                this.txtbx_psw.Text = "";
                this.txtbx_name.Text = "";
                this.txtbx_old.Text = "";
                this.txtbx_js.Text = "";
                this.txtbx_address.Text = "";
                this.txtbx_phone.Text = "";
            }
            else                                                                                        //否则；
            {
                MessageBox.Show("注册失败！");                                                          //给出错误提示；
            }
        }

        private void btn_return_Click(object sender, EventArgs e)
        {
            Application.Run(new frm_userlogin());
            this.Hide();
        }
    }
}