HospitalManageSys/Form_Charge.cs

   1 using System;
   2 using System.Collections.Generic;
   3 using System.ComponentModel;
   4 using System.Data;
   5 using System.Drawing;
   6 using System.Linq;
   7 using System.Text;
   8 using System.Windows.Forms;
   9 using MySql.Data.MySqlClient;
  10
  11 namespace HospitalManageSys
  12 {
  13     public partial class Form_Charge : Form
  14     {
  15         MySqlConnection conne;
  16         MainForm mf;
  17
  18         public Form_Charge(MySqlConnection connector,MainForm mainform)
  19         {
  20             InitializeComponent();
  21
  22             conne = connector;
  23             mf = mainform;
  24         }
  25         //string myconnect = "Server = localhost;Database=HospitalManageSys;User Id = barry;Password = zixue788634; ";
  26         //保存按钮
  27         private void button1_Click(object sender, EventArgs e)
  28         {
  29             //MySqlConnection conne = new MySqlConnection(myconnect);
  30             MySqlCommand cmd;
  31             conne.Open();
  32             try
  33             {
  34                 if(textBox1.Text.Trim().ToString().Length == 0)
  35                 {
  36                     MessageBox.Show("请输入单号");
  37                     return;
  38                 }else if(comboBox1.Text.Trim().ToString().Length == 0){
  39                     MessageBox.Show("收费人编号不能为空");
  40                     return;
  41                 }
  42                 else if (textBox3.Text.Trim().ToString().Length == 0) {
  43                     MessageBox.Show("请输入中药费用，如果没有请输入0.00");
  44                     return;
  45                 }
  46                 else if (textBox4.Text.Trim().ToString().Length == 0) {
  47                     MessageBox.Show("请输入西药费用，如果没有请输入0.00");
  48                     return;
  49                 }
  50                 else if (textBox2.Text.Trim().ToString().Length == 0) {
  51                     MessageBox.Show("请输入相关中药名称与数量，没有输入“无”");
  52                     return;
  53                 }
  54                 else if (textBox5.Text.Trim().ToString().Length == 0) {
  55                     MessageBox.Show("请输入相关中药名称与数量，没有输入“无”");
  56                     return;
  57                 }
  58
  59
  60                 decimal tex = decimal.Parse(textBox3.Text) + decimal.Parse(textBox4.Text);
  61                 cmd = conne.CreateCommand();
  62                 cmd.CommandText = "INSERT INTO charge(charge_count,charge_admin,charge_tcmname,charge_tcm,charge_twmname,charge_twm,charge_sum,charge_date)VALUES(@charge_count,@charge_admin,@charge_tcmname,@charge_tcm,@charge_twmname,@charge_twm,@charge_sum,@charge_date)";
  63                 cmd.Parameters.AddWithValue("@charge_count", textBox1.Text);
  64                 cmd.Parameters.AddWithValue("@charge_admin", int.Parse(comboBox1.SelectedItem.ToString()));
  65                 cmd.Parameters.AddWithValue("@charge_tcm", textBox3.Text);
  66                 cmd.Parameters.AddWithValue("@charge_twm", textBox4.Text);
  67                 cmd.Parameters.AddWithValue("@charge_sum", tex);
  68                 cmd.Parameters.AddWithValue("@charge_date", System.DateTime.Now.ToString());
  69                 cmd.Parameters.AddWithValue("@charge_tcmname", textBox2.Text);
  70                 cmd.Parameters.AddWithValue("@charge_twmname", textBox5.Text);
  71                 cmd.ExecuteNonQuery();
  72
  73                 conne.Close();
  74             }
  75             catch (Exception)
  76             {
  77                 throw;
  78             }
  79             finally {
  80                 if (conne.State == ConnectionState.Open)
  81                 {
  82                     conne.Close();
  83                     LoadData();
  84                 }
  85             }
  86         }
  87         private void LoadData() {
  88             MySqlConnection connection = conne;
  89             connection.Open();
  90             try
  91             {
  92                 MySqlCommand cmd = connection.CreateCommand();
  93                 cmd.CommandText = "SELECT * FROM charge";
  94                 MySqlDataAdapter adap = new MySqlDataAdapter(cmd);
  95                 DataSet ds = new DataSet();
  96                 adap.Fill(ds);
  97                 dataGridView1.DataSource = ds.Tables[0].DefaultView;
  98
  99             }
 100             catch (Exception)
 101             {
 102                 throw;
 103             }
 104             finally {
 105                 if (connection.State == ConnectionState.Open)
 106                 {
 107                     connection.Close();
 108                 }
 109             }
 110         }
 111
 112         private void textBox2_TextChanged(object sender, EventArgs e)
 113         {
 114
 115         }
 116         //查询按钮
 117         private void button2_Click(object sender, EventArgs e)
 118         {
 119             //MySqlConnection conne = new MySqlConnection(myconnect);
 120
 121             MySqlCommand cmd;
 122             conne.Open();
 123             try
 124             {
 125
 126             }
 127             catch (Exception)
 128             {
 129                 throw;
 130             }
 131             finally
 132             {
 133                 if (conne.State == ConnectionState.Open)
 134                 {
 135                     conne.Close();
 136                     ReLoadData();
 137                 }
 138             }
 139         }
 140         private void ReLoadData()
 141         {
 142             MySqlConnection connection = conne;
 143             connection.Open();
 144             try
 145             {
 146                 if (comboBox1.Text.Trim().ToString().Length == 0)
 147                 {
 148                     MessageBox.Show("请选择要查询的收费人编号");
 149                     return;
 150                 }
 151                 MySqlCommand cmd = connection.CreateCommand();
 152                 cmd.CommandText = string.Format("SELECT charge_count,charge_admin,charge_tcmname,charge_tcm,charge_twmname,charge_twm,charge_sum,charge_date FROM charge where charge_admin = {0} ", comboBox1.Text); ;
 153                 MySqlDataAdapter adap = new MySqlDataAdapter(cmd.CommandText, connection);
 154                 DataSet ds = new DataSet();
 155                 adap.Fill(ds);
 156                 dataGridView1.DataSource = ds.Tables[0].DefaultView;
 157
 158             }
 159             catch (Exception)
 160             {
 161                 throw;
 162             }
 163             finally
 164             {
 165                 if (connection.State == ConnectionState.Open)
 166                 {
 167                     connection.Close();
 168                 }
 169             }
 170         }
 171
 172         private void Form_Charge_Load(object sender, EventArgs e)
 173         {
 174
 175         }
 176     }
 177 }