HospitalManageSys/Form_DrugEx.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_DrugEx : Form
  14     {
  15         MainForm mf;
  16         MySqlConnection conn;
  17
  18         public Form_DrugEx(MySqlConnection connector, MainForm mainform)
  19         {
  20             InitializeComponent();
  21
  22             mf = mainform;
  23             conn = connector;
  24         }
  25
  26         private void button1_Click(object sender, EventArgs e)
  27         {
  28             String strConn = "server=localhost;uid=root;pwd=dongyz1130 ;database=hospitalmanagesys";
  29             //MySqlConnection conn = new MySqlConnection(strConn);
  30             String sqlId = "Select * from drugex where DrugEx_registration = '" + textBox1.Text + "'and Drug_state='未发' ";
  31             conn.Open();
  32             MySqlCommand cmd = new MySqlCommand(sqlId, conn);
  33             MySqlDataAdapter da = new MySqlDataAdapter(cmd);
  34             DataSet ds = new DataSet();
  35             da.Fill(ds, "USER");
  36             dataGridView1.DataSource = ds.Tables[0];
  37
  38
  39         }
  40
  41         private void button2_Click(object sender, EventArgs e)
  42         {
  43             String strConn = "server=localhost;uid=root;pwd=dongyz1130 ;database=hospitalmanagesys";
  44             //MySqlConnection conn = new MySqlConnection();
  45             conn.ConnectionString = strConn;
  46             //2、准备新增sql命令
  47             string strcommand = "update drugex set Drug_state = '已发' where DrugEx_registration = '" + textBox1.Text + "' ";
  48             //3、新建命令对象，并前告诉它走那条路，做什么事情
  49             MySqlCommand cmd = new MySqlCommand(strcommand, conn);
  50             //4、打开通道
  51             conn.Open();
  52             //5、执行sql语句
  53             int intres = -1;
  54             intres = cmd.ExecuteNonQuery();
  55             //6、关闭连接通道
  56             conn.Close();
  57             if (intres > 0)
  58             {
  59                 Console.WriteLine("修改成功");
  60             }
  61             else
  62             {
  63                 Console.WriteLine("修改失败");
  64             }
  65
  66         }
  67
  68
  69
  70         private void button3_Click(object sender, EventArgs e)
  71         {
  72             String strConn = "server=localhost;uid=root;pwd=dongyz1130 ;database=hospitalmanagesys";
  73             //MySqlConnection conn = new MySqlConnection(strConn);
  74             String sqlId = "Select * from drugex where DrugEx_date = '" + dateTimePicker1.Text + "'and Drug_state='已发' ";
  75             conn.Open();
  76             MySqlCommand cmd = new MySqlCommand(sqlId, conn);
  77             MySqlDataAdapter da = new MySqlDataAdapter(cmd);
  78             DataSet ds = new DataSet();
  79             da.Fill(ds, "USER");
  80             dataGridView2.DataSource = ds.Tables[0];
  81
  82             conn.Close();
  83
  84         }
  85
  86         private void button4_Click(object sender, EventArgs e)
  87         {
  88             String strConn = "server=localhost;uid=root;pwd=dongyz1130 ;database=hospitalmanagesys";
  89             //MySqlConnection conn = new MySqlConnection(strConn);
  90             String sqlId = "Select * from drugex where DrugEx_date = '" + dateTimePicker1.Text + "'and Drug_state='未发' ";
  91             conn.Open();
  92             MySqlCommand cmd = new MySqlCommand(sqlId, conn);
  93             MySqlDataAdapter da = new MySqlDataAdapter(cmd);
  94             DataSet ds = new DataSet();
  95             da.Fill(ds, "USER");
  96             dataGridView2.DataSource = ds.Tables[0];
  97
  98             conn.Close();
  99
 100
 101         }
 102
 103         private void button5_Click(object sender, EventArgs e)
 104         {
 105             String strConn = "server=localhost;uid=root;pwd=dongyz1130 ;database=hospitalmanagesys";
 106             //MySqlConnection conn = new MySqlConnection(strConn);
 107             String sqlId = "Select * from drugex where DrugEx_registration = '" + textBox2.Text + "' ";
 108             conn.Open();
 109             MySqlCommand cmd = new MySqlCommand(sqlId, conn);
 110             MySqlDataAdapter da = new MySqlDataAdapter(cmd);
 111             DataSet ds = new DataSet();
 112             da.Fill(ds, "USER");
 113             dataGridView2.DataSource = ds.Tables[0];
 114
 115         }
 116
 117
 118
 119         private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
 120         {
 121             String strConn = "server=localhost;uid=root;pwd=dongyz1130 ;database=hospitalmanagesys";
 122             //MySqlConnection conn = new MySqlConnection();
 123             conn.ConnectionString = strConn;
 124             //2、准备新增sql命令
 125             String sqlId = "Select Drugex_quantity from drugex where Drug_name = '" + textBox3.Text + "'";
 126             MySqlCommand cmd = new MySqlCommand(sqlId, conn);
 127             conn.Open();
 128             MySqlDataReader myReader = cmd.ExecuteReader();
 129             while (myReader.Read())
 130            {
 131                 textBox4.Text  = myReader.GetValue(0).ToString();
 132             }
 133             myReader.Close();
 134            conn.Close();
 135         }
 136
 137         private void button6_Click(object sender, EventArgs e)
 138         {
 139             String strConn = "server=localhost;uid=root;pwd=dongyz1130 ;database=hospitalmanagesys";
 140             //MySqlConnection conn = new MySqlConnection();
 141             conn.ConnectionString = strConn;
 142             //2、准备新增sql命令
 143             string strcommand = "update drug set Drug_remain = Drug_remain-'" + textBox4.Text + "' where Drug_name = '" + textBox3.Text + "' ";
 144             //3、新建命令对象，并前告诉它走那条路，做什么事情
 145             MySqlCommand cmd = new MySqlCommand(strcommand, conn);
 146             //4、打开通道
 147             conn.Open();
 148             //5、执行sql语句
 149             int intres = -1;
 150             intres = cmd.ExecuteNonQuery();
 151             //6、关闭连接通道
 152             conn.Close();
 153             if (intres > 0)
 154             {
 155                 Console.WriteLine("修改成功");
 156             }
 157             else
 158             {
 159                 Console.WriteLine("修改失败");
 160             }
 161         }
 162
 163         private void label1_Click(object sender, EventArgs e)
 164         {
 165
 166         }
 167
 168         private void Form_DrugEx_Load(object sender, EventArgs e)
 169         {
 170
 171         }
 172         }
 173     }
 174