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

namespace MyProject
{
    public partial class frm_doctorgledit : Form
    {
        public frm_doctorgledit()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection sqlConnection = new SqlConnection();                                              //声明并实例化SQL连接；
            sqlConnection.ConnectionString =
                "Server=(local);Database=ZXYY;Integrated Security=sspi";                             //在字符串变量中，描述连接字符串所需的服务器地址、数据库名称、集成安全性（即是否使用Windows验证）；
            SqlCommand sqlCommand = new SqlCommand();                                                       //声明并实例化SQL命令；
            sqlCommand.Connection = sqlConnection;                                                          //将SQL命令的连接属性指向SQL连接；
            sqlCommand.CommandText =                                                                        //指定SQL命令的命令文本；
                "UPDATE 门诊时间"
                + " SET 门诊时间=@门诊时间,时刻=@时刻,可预约人数=@可预约人数,备注=@备注";
            if(radiobtn_xq1.Checked ==true )
            sqlCommand.Parameters.AddWithValue("@门诊时间", this.radiobtn_xq1.Text.ToString()); 
            //向SQL命令的参数集合添加参数的名称、值；
            if (radioButton2 .Checked==true )
                sqlCommand.Parameters.AddWithValue("@门诊时间", this.radioButton2.Text.ToString());
            if (radioButton3.Checked == true)
                sqlCommand.Parameters.AddWithValue("@门诊时间", this.radioButton3.Text.ToString());
            if (radioButton4.Checked == true)
                sqlCommand.Parameters.AddWithValue("@门诊时间", this.radioButton4.Text.ToString());
            if (radioButton5.Checked == true)
                sqlCommand.Parameters.AddWithValue("@门诊时间", this.radioButton5.Text.ToString());
            if(checkBox1.Checked==true )
                sqlCommand.Parameters.AddWithValue("@时刻", this.checkBox1.Text.Trim());
            if (checkBox2.Checked == true)
                sqlCommand.Parameters.AddWithValue("@时刻", this.checkBox2.Text.Trim());
            sqlCommand.Parameters.AddWithValue("@可预约人数", this.textBox1 .Text.Trim());
            sqlCommand.Parameters.AddWithValue("@备注", this.textBox2 .Text.Trim());

            sqlConnection.Open();                                                                           //打开SQL连接；
            int rowAffected = sqlCommand.ExecuteNonQuery();                                                 //调用SQL命令的方法ExecuteNonQuery来执行命令，向数据库写入数据，并返回受影响行数；
            sqlConnection.Close();                                                                          //关闭SQL连接；
            MessageBox.Show("保存成功" );
        }

        private void button2_Click(object sender, EventArgs e)
        {
            frm_doctordategl frm_doctordategl = new frm_doctordategl();
            frm_doctordategl.Show();
            this.Hide();
        }
    }
}