HospitalManageSys/Form_Adminisrtator.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 using System.IO;
  11
  12 namespace HospitalManageSys
  13 {
  14     public partial class Form_Adminisrtator : Form
  15     {
  16         MySqlConnection conn;
  17         MainForm mf;
  18
  19         public Form_Adminisrtator(MySqlConnection connector, MainForm mainform)
  20         {
  21             InitializeComponent();
  22
  23             conn = connector;
  24             mf = mainform;
  25         }
  26
  27 //        string strcon = @"Data Source=localhost;Database=hospitalmanagesys;User Id=root;
  28 //            Password=123456;Allow User Variables=True";
  29         string FileNamePath = "";
  30         /// <summary>
  31         /// 员工查询
  32         /// </summary>
  33         /// <param name="sender"></param>
  34         /// <param name="e"></param>
  35         private void button1_Click(object sender, EventArgs e)
  36         {
  37             if (tb_id.Text == "")
  38             {
  39                 MessageBox.Show("请输入员工编号！");
  40                 return;
  41             }
  42             //MySqlConnection conn = new MySqlConnection(strcon);//新建数据库连接对象
  43             string StrSelcet = @"SELECT Admin_name,Admin_password,Admin_sex,Admin_job,Admin_department,Admin_fee,
  44 Admin_photo,Admin_comment,Admin_capability FROM Administrator WHERE Admin_ID='" + tb_id.Text + "'";//sql查找语句
  45             MySqlCommand cmd = new MySqlCommand(StrSelcet, conn);
  46             try
  47             {
  48                 conn.Open();//打开数据库
  49                 MySqlDataReader sdr = cmd.ExecuteReader();
  50                 MemoryStream memStream = null;//定义一个内存流
  51                 if (sdr.HasRows)//如果有记录
  52                 {
  53                     sdr.Read();//读取第一行记录
  54                     tb_name.Text = sdr["Admin_name"].ToString();//读取姓名
  55                     //tb_password.Text = sdr["Admin_password"].ToString();//读取密码
  56                     cb_sex.Text = sdr["Admin_sex"].ToString();//读取性别
  57                     cb_job.Text = sdr["Admin_job"].ToString();//读取职位
  58                     cb_department.Text = sdr["Admin_department"].ToString();//读取科室
  59                     tb_fee.Text = sdr["Admin_fee"].ToString();//读取挂号费
  60                     tb_comment.Text = sdr["Admin_comment"].ToString();//读取备注
  61                     if (this.pb_photo.Image != null)//原有图片销毁
  62                         pb_photo.Image = null;
  63                     if (sdr["Admin_photo"] != System.DBNull.Value)//如果有照片
  64                     {
  65                         byte[] images = (byte[])sdr["Admin_photo"];
  66                         memStream = new MemoryStream(images);//字节流转化为内存流
  67                         pb_photo.Image = Image.FromStream(memStream);//内存流转换为照片
  68                         memStream.Close();
  69                     }
  70                     int a = Convert.ToInt32(sdr["Admin_capability"].ToString());//读取职能转化为int类型
  71                     if ((a & 1) != 0)
  72                         check_1.Checked = true;
  73                     else
  74                         check_1.Checked = false;
  75                     if ((a & 2) != 0)
  76                         check_2.Checked = true;
  77                     else
  78                         check_2.Checked = false;
  79                     if ((a & 4) != 0)
  80                         check_3.Checked = true;
  81                     else
  82                         check_3.Checked = false;
  83                     if ((a & 8) != 0)
  84                         check_4.Checked = true;
  85                     else
  86                         check_4.Checked = false;
  87                     if ((a & 16) != 0)
  88                         check_5.Checked = true;
  89                     else
  90                         check_5.Checked = false;
  91                     if ((a & 32) != 0)
  92                         check_6.Checked = true;
  93                     else
  94                         check_6.Checked = false;
  95                 }
  96                 else
  97                     MessageBox.Show("没有此员工！");
  98
  99                 if (!sdr.IsClosed)//关闭sdr
 100                     sdr.Close();
 101             }
 102             catch (Exception ex)
 103             {
 104                 MessageBox.Show(ex.Message);
 105             }
 106             finally
 107             {
 108                 if (conn.State == ConnectionState.Open)//如果数据处于连接状态，关闭连接
 109                     conn.Close();
 110             }
 111         }
 112         /// <summary>
 113         /// 员工添加
 114         /// </summary>
 115         /// <param name="sender"></param>
 116         /// <param name="e"></param>
 117         private void button2_Click(object sender, EventArgs e)
 118         {
 119             if (tb_id.Text == "" || tb_name.Text == "" || cb_job.Text == "" || cb_sex.Text == "")
 120             {
 121                 MessageBox.Show("请输入完整信息");
 122                 return;
 123             }
 124             string StrInsert;
 125             //MySqlConnection conn = new MySqlConnection(strcon);//新建数据库连接对象
 126             if (FileNamePath != "")
 127             {
 128                 StrInsert = @"INSERT INTO Administrator(Admin_ID,Admin_name,Admin_sex,Admin_job,Admin_department,
 129 Admin_fee,Admin_photo,Admin_comment,Admin_capability,Admin_password) VALUES (@Admin_ID,@Admin_name,@Admin_sex,@Admin_job,@Admin_department,
 130 @Admin_fee,@Admin_photo,@Admin_comment,@Admin_capability,@Admin_password)";
 131             }
 132             else
 133             {
 134                 StrInsert = @"INSERT INTO Administrator(Admin_ID,Admin_name,Admin_sex,Admin_job,Admin_department,
 135 Admin_fee,Admin_comment,Admin_capability,Admin_password) VALUES (@Admin_ID,@Admin_name,@Admin_sex,@Admin_job,@Admin_department,
 136 @Admin_fee,@Admin_comment,@Admin_capability,@Admin_password)";
 137             }
 138             MySqlCommand cmd = new MySqlCommand(StrInsert, conn);
 139             //添加参数
 140             cmd.Parameters.Add("@Admin_ID", MySqlDbType.VarChar, 11).Value = tb_id.Text;
 141             cmd.Parameters.Add("@Admin_name", MySqlDbType.VarChar, 20).Value = tb_name.Text;
 142             cmd.Parameters.Add("@Admin_password", MySqlDbType.Int32,11).Value = tb_password.Text.GetHashCode();
 143             cmd.Parameters.Add("@Admin_sex", MySqlDbType.VarChar, 2).Value = cb_sex.Text;
 144             cmd.Parameters.Add("@Admin_job", MySqlDbType.VarChar, 20).Value = cb_job.Text;
 145             cmd.Parameters.Add("@Admin_department", MySqlDbType.VarChar, 50).Value = cb_department.Text;
 146             cmd.Parameters.Add("@Admin_fee", MySqlDbType.Decimal).Value = tb_fee.Text;
 147             cmd.Parameters.Add("@Admin_comment", MySqlDbType.VarChar, 100).Value = tb_comment.Text;
 148             if (FileNamePath != "")//如果照片不为空，添加照片
 149             {
 150                 FileStream fs = null;//以文件流方式读取照片
 151                 fs = new FileStream(FileNamePath, FileMode.Open, FileAccess.Read);
 152                 byte[] imageBytes = new byte[Convert.ToInt32(fs.Length)];//定义照片长度数组
 153                 BinaryReader br = new BinaryReader(fs);
 154                 imageBytes = br.ReadBytes(Convert.ToInt32(fs.Length));//图片转换成二进制流
 155                 fs.Close();
 156                 cmd.Parameters.Add("@Admin_photo", MySqlDbType.MediumBlob);//选择MediumBlob类型
 157                 cmd.Parameters["@Admin_photo"].Value = imageBytes;//给@Admin_photo参数赋值
 158             }
 159             int ability;//定义职能
 160             int a1 = check_1.Checked ? 1 : 0;
 161             int a2 = check_2.Checked ? 2 : 0;
 162             int a3 = check_3.Checked ? 4 : 0;
 163             int a4 = check_4.Checked ? 8 : 0;
 164             int a5 = check_5.Checked ? 16 : 0;
 165             int a6 = check_6.Checked ? 32 : 0;
 166             ability = a1 | a2 | a3 | a4 | a5 | a6;
 167             cmd.Parameters.Add("@Admin_capability", MySqlDbType.Bit, 8);
 168             cmd.Parameters["@Admin_capability"].Value = ability;
 169
 170             try
 171             {
 172                 conn.Open();//打开数据库连接
 173                 cmd.ExecuteNonQuery();//执行sql语句
 174                 MessageBox.Show("保存成功！");
 175             }
 176             catch (Exception ex)
 177             {
 178                 MessageBox.Show("出错！" + ex.Message);
 179             }
 180             finally
 181             {
 182                 conn.Close();//关闭数据库连接
 183                 FileNamePath = "";
 184             }
 185         }
 186         /// <summary>
 187         /// 员工删除
 188         /// </summary>
 189         /// <param name="sender"></param>
 190         /// <param name="e"></param>
 191         private void button3_Click(object sender, EventArgs e)
 192         {
 193             if (tb_id.Text == "")
 194             {
 195                 MessageBox.Show("请输入员工编号");
 196                 return;
 197             }
 198             //MySqlConnection conn = new MySqlConnection(strcon);////新建数据库连接对象
 199             string StrDel = "DELETE FROM Administrator WHERE Admin_ID=@Admin_ID";
 200             MySqlCommand cmd = new MySqlCommand(StrDel, conn);
 201             cmd.Parameters.Add("@Admin_ID", MySqlDbType.VarChar, 11).Value = tb_id.Text;
 202             try
 203             {
 204                 conn.Open();//打开数据库连接
 205                 int a = cmd.ExecuteNonQuery();//执行sql语句
 206                 if (a == 1)//如果受影响的行数为1，则删除成功
 207                     MessageBox.Show("删除成功！");
 208                 else
 209                     MessageBox.Show("数据库中没有此员工！");
 210             }
 211             catch (Exception ex)
 212             {
 213                 MessageBox.Show(ex.Message);
 214             }
 215             finally
 216             {
 217                 conn.Close();//关闭数据库连接
 218             }
 219         }
 220         /// <summary>
 221         /// 员工修改
 222         /// </summary>
 223         /// <param name="sender"></param>
 224         /// <param name="e"></param>
 225         private void button4_Click(object sender, EventArgs e)
 226         {
 227             if (tb_id.Text == "")
 228             {
 229                 MessageBox.Show("请输入员工编号");
 230                 return;
 231             }
 232             //MySqlConnection conn = new MySqlConnection(strcon);
 233             string StrUpdate = "UPDATE Administrator SET ";
 234             StrUpdate += "Admin_name='" + tb_name.Text + "',";//修改姓名
 235             //StrUpdate += "Admin_password='" + tb_password.Text + "',";//修改密码
 236             StrUpdate += "Admin_sex='" + cb_sex.Text + "',";//修改性别
 237             StrUpdate += "Admin_job='" + cb_job.Text + "',";//修改职位
 238             StrUpdate += "Admin_department='" + cb_department.Text + "',";//修改科室
 239             StrUpdate += "Admin_fee='" + tb_fee.Text + "',";//修改挂号费
 240
 241             if (FileNamePath != "")//如果选择了照片
 242             {
 243                 FileStream fs = null;
 244                 fs = new FileStream(FileNamePath, FileMode.Open, FileAccess.Read);
 245                 byte[] imageBytes = new byte[fs.Length];
 246                 BinaryReader br = new BinaryReader(fs);
 247                 imageBytes = br.ReadBytes(Convert.ToInt32(fs.Length));//图片转换成二进制流
 248                 fs.Close();
 249                 StrUpdate += "Admin_photo='" + imageBytes + "',";
 250             }
 251             int ability;//定义职能
 252             int a1 = check_1.Checked ? 1 : 0;
 253             int a2 = check_2.Checked ? 2 : 0;
 254             int a3 = check_3.Checked ? 4 : 0;
 255             int a4 = check_4.Checked ? 8 : 0;
 256             int a5 = check_5.Checked ? 16 : 0;
 257             int a6 = check_6.Checked ? 32 : 0;
 258             ability = a1 | a2 | a3 | a4 | a5 | a6;
 259             StrUpdate += "Admin_capability='" + ability + "',";//修改职能
 260             StrUpdate += "Admin_comment='" + tb_comment.Text + "'";//修改备注
 261             StrUpdate += "WHERE Admin_ID='" + tb_id.Text + "'";
 262             MySqlCommand cmd = new MySqlCommand(StrUpdate, conn);
 263             try
 264             {
 265                 conn.Open();
 266                 int b = cmd.ExecuteNonQuery();
 267                 if (b == 1)
 268                     MessageBox.Show("修改成功！");
 269                 else
 270                     MessageBox.Show("数据库中没有此员工！");
 271             }
 272             catch (Exception ex)
 273             {
 274                 MessageBox.Show("出错，没有完成修改！" + ex.Message);
 275             }
 276             finally
 277             {
 278                 conn.Close();
 279                 FileNamePath = "";
 280             }
 281
 282         }
 283         /// <summary>
 284         /// 选择照片
 285         /// </summary>
 286         /// <param name="sender"></param>
 287         /// <param name="e"></param>
 288         private void pb_photo_Click(object sender, EventArgs e)
 289         {
 290             OpenFileDialog ofd = new OpenFileDialog();//实例化打开文件对话框
 291             ofd.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Personal);
 292             ofd.Filter = "jpg 图片|*.jpg|gif 图片|*.gif|所有文件(*.*)|*.*";//设置打开文件类型
 293             if (ofd.ShowDialog(this) == DialogResult.OK)
 294             {
 295                 FileNamePath = ofd.FileName;//获取文件路径
 296                 pb_photo.Image = Image.FromFile(FileNamePath);//将照片显示在pb_photo中
 297             }
 298         }
 299         /// <summary>
 300         /// 清空操作
 301         /// </summary>
 302         /// <param name="sender"></param>
 303         /// <param name="e"></param>
 304         private void button5_Click(object sender, EventArgs e)
 305         {
 306             tb_id.Text = "";
 307             tb_name.Text = "";
 308             tb_password.Text = "";
 309             cb_department.Text = "";
 310             tb_fee.Text = "";
 311             tb_comment.Text = "";
 312             cb_sex.Text = "";
 313             cb_job.Text = "";
 314             pb_photo.Image = null;
 315             check_1.Checked = false;
 316             check_2.Checked = false;
 317             check_3.Checked = false;
 318             check_4.Checked = false;
 319             check_5.Checked = false;
 320             check_6.Checked = false;
 321         }
 322         /// <summary>
 323         /// 显示所有员工信息
 324         /// </summary>
 325         /// <param name="sender"></param>
 326         /// <param name="e"></param>
 327         private void button6_Click(object sender, EventArgs e)
 328         {
 329             string StrSelcet = @"SELECT Admin_ID,Admin_name,Admin_sex,Admin_job,Admin_department,Admin_comment FROM Administrator";//sql查找语句
 330             //MySqlConnection conn = new MySqlConnection(strcon);
 331             try
 332             {
 333                 conn.Open();
 334                 MySqlDataAdapter msda = new MySqlDataAdapter(StrSelcet, conn);
 335                 DataSet dataSet = new DataSet("Syxx");
 336                 msda.Fill(dataSet);
 337                 dataGridView1.DataSource = dataSet.Tables[0];
 338             }
 339             catch (Exception ex)
 340             {
 341                 MessageBox.Show("出错" + ex.Message);
 342             }
 343             finally
 344             {
 345                 conn.Close();
 346             }
 347         }
 348
 349         private void Form_Adminisrtator_Load(object sender, EventArgs e)
 350         {
 351
 352         }
 353     }
 354 }