挂号.cs

本人课程设计时开发的一个医院管理系统

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 WindowsApplication1
{
    public partial class 挂号 : Form
    {
        public 挂号()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            /*string connectionString = "Data Source=TING\\SQLEXPRESS;Initial Catalog= 医院管理系统 ;User id=sa  ;Password=niit#1234 ";
            SqlConnection cn = new SqlConnection();
            cn.ConnectionString = connectionString;
            cn.Open();
            string searchuser = tb_userName.Text;
            String query = "SELECT * FROM Patient WHERE OPID = @opid";
            SqlCommand cmd = new SqlCommand(query, cn);
            cmd.Parameters.Add(new SqlParameter("@opid", searchuser));
            using (SqlDataReader dr = cmd.ExecuteReader())
            {
                dr.Read();
                if (dr[6].ToString() == tb_key.Text)
                {
                    Form1 ob = new Form1();
                    ob.ShowDialog();
                }
                else
                    MessageBox.Show("密码错误");
            }
            cn.Close();*/
        }

        private void btn_tjxx_Click(object sender, EventArgs e)
        {
            添加病人 ob = new 添加病人();
            ob.ShowDialog();
        }

        private void btn_cancel_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void btn_dl_Click(object sender, EventArgs e)
        {
            string connectionString = "Data Source= sclab76\\SQLEXPRESS;Initial Catalog= 医院管理系统 ;User id=sa  ;Password=niit#1234 ";
            SqlConnection cn = new SqlConnection();
            cn.ConnectionString = connectionString;
            cn.Open();
            string searchuser = txt_opid.Text;
            String query = "SELECT * FROM Patient WHERE OPID = @opid";
            SqlCommand cmd = new SqlCommand(query, cn);
            cmd.Parameters.Add(new SqlParameter("@opid", searchuser));
            using (SqlDataReader dr = cmd.ExecuteReader())
            {
                dr.Read();
                if (dr[6].ToString() == txt_password.Text)
                {
                    string message ="病人信息\n"+"OPID: "+ dr[0].ToString ()+ "\n" + "IPID: "+dr[1].ToString() + "\n" +"Name: "+ dr[2].ToString() + "\n" +"Address: "+ dr[3].ToString() + "\n" +"InsuranceType: "+ dr[4].ToString() + "\n" +"Degree: "+ dr[5].ToString();
                    MessageBox.Show(message);
                }
                else
                    MessageBox.Show("密码或用户名错误");
            }
            cn.Close();
        }
    }
}