医保.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
    {
        
        DataSet ds;
        SqlConnection cn = new SqlConnection();

        public 医保()
        {
            InitializeComponent();
        }

        private void Form14_Load(object sender, EventArgs e)
        {
            cn.ConnectionString = "Data Source=sclab76\\SQLEXPRESS;Initial Catalog=医院管理系统;User id=sa;Password=niit#1234";
            cn.Open();
            ds = new DataSet();
            SqlDataAdapter da = new SqlDataAdapter();
            SqlCommand cmd = new SqlCommand("Select * from calculator", cn);
            da.SelectCommand = cmd;
            da.Fill(ds, "calculator");

            dataGridView1.DataSource = ds;
            dataGridView1.DataMember = "calculator";

            SqlCommand cmd1 = new SqlCommand("Select IPID from calculator", cn);
            SqlDataReader dr = cmd1.ExecuteReader();

            while (dr.Read())
            {
                comboBox1.Items.Add(dr["IPID"].ToString());
            }

            cn.Close();
        }

        private void button3_Click(object sender, EventArgs e)
        {
            cn.ConnectionString = "Data Source=sclab76\\SQLEXPRESS;Initial Catalog=医院管理系统;User id=sa;Password=niit#1234";
            cn.Open();
            ds = new DataSet();
            SqlDataAdapter da = new SqlDataAdapter();
            SqlCommand cmd = new SqlCommand("Select * from calculator where IPID=@ipid", cn);
            cmd.Parameters.Add(new SqlParameter("@ipid", comboBox1.Text));
            da.SelectCommand = cmd;
            da.Fill(ds, "calculator");

            dataGridView1.DataSource = ds;
            dataGridView1.DataMember = "calculator";


            SqlCommand cmd2 = new SqlCommand("Select Insurance_Type,disaccount,Degree from Insurance", cn);
            SqlDataAdapter da2 = new SqlDataAdapter();
            da2.SelectCommand = cmd2;
            da2.Fill(ds, "Insurance");

            dataGridView2.DataSource = ds;
            dataGridView2.DataMember = "Insurance";


            SqlCommand cmd1 = new SqlCommand("Select Insuranve_Type,Degree from Patient where IPID=@ipid", cn);
            cmd1.Parameters.Add(new SqlParameter("@ipid", comboBox1.Text));
            SqlDataReader dr = cmd1.ExecuteReader();

            while (dr.Read())
            {
                textBox1.Text = dr[0].ToString();
                textBox2.Text = dr[1].ToString();
            }
            //cmd1.EndExecuteReader();

            cn.Close();

        }

        private void button1_Click(object sender, EventArgs e)
        {
            double a, b, temp;
            a = Convert.ToDouble(textBox4.Text);
            b = Convert.ToDouble(textBox5.Text);
            temp = a * b * 0.1;
            textBox6.Text = Convert.ToString(temp);


            string connectString = "Initial Catalog=医院管理系统;Data Source=sclab76\\SQLEXPRESS;User id=sa;Password=niit#1234";
            SqlConnection cn = new SqlConnection();
            cn.ConnectionString = connectString;
            cn.Open();
            SqlTransaction tran = null;
            try
            {
                tran = cn.BeginTransaction();
                SqlCommand cmd1 = new SqlCommand("UPDATE calculator SET Cheaper=@cheaper WHERE IPID=@IPID", cn, tran);
                cmd1.Parameters.Add(new SqlParameter("@cheaper", textBox6.Text));
                cmd1.Parameters.Add(new SqlParameter("@IPID", comboBox1.Text));
                cmd1.ExecuteNonQuery();

                tran.Commit();
                MessageBox.Show("Save success!!");
            }
            catch (SqlException ex)
            {
                tran.Rollback();
                MessageBox.Show(ex.Message);
            }
            catch (System.Exception ex)
            {
                MessageBox.Show(ex.Message);

            }
            finally
            {
                cn.Close();
            }
        }

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