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.OleDb;
namespace 专科医院门诊系统_眼科_
{
public partial class 挂号界面 : Form
{
OleDbDataAdapter adapter;
DataTable table = new DataTable();
string str = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=E:\design\vc\project\专科医院门诊系统(眼科)\db1.accdb";
OleDbConnection con = new OleDbConnection();
public 挂号界面()
{
InitializeComponent();
button1.Click += new EventHandler(button1_Click);
button2.Click += new EventHandler(button2_Click);
button3.Click += new EventHandler(button3_Click);
}
private void button1_Click(object sender, EventArgs e)
{
挂号缴费选择界面 frm = new 挂号缴费选择界面();
frm.Show();
Hide();
}
private void button2_Click(object sender, EventArgs e)
{
if (textBox1.Text != "" && textBox2.Text != "" && textBox3.Text != "" && textBox4.Text != "" && textBox5.Text != "" && textBox6.Text != "")
{
string a = textBox1.Text;
string b = textBox2.Text;
string c = textBox3.Text;
string d = textBox4.Text;
string f = textBox5.Text;
string g = textBox6.Text;
string sql = @"insert into patient (ID,姓名,年龄,性别,电话号码,科室) values('" + a + "','" + b + "','" + c + "','" + d + "','" + f + "','" + g + "')";
adapter = new OleDbDataAdapter(sql, str);//创建adapter
OleDbCommandBuilder buider = new OleDbCommandBuilder(adapter);//创建command
adapter.InsertCommand = buider.GetInsertCommand();//设置进行插入操作的command
table.Clear();//清空已有的table
adapter.Fill(table);//根据sql填充table
if (table.Rows.Count > 0)//如果记录数大于0
{
MessageBox.Show("挂号成功");
}
else
{
MessageBox.Show("请输入完整的挂号信息");
}
}
}
private void button3_Click(object sender, EventArgs e)
{
textBox1.Text = textBox2.Text = textBox3.Text = textBox4.Text = textBox5.Text = string.Empty;
}
private void 挂号界面_Load(object sender, EventArgs e)
{
}
}
}