HospitalManageSys/Form_Login.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_Login : Form
  15     {
  16         MySqlConnection con;
  17         MySqlCommand cmd;
  18         MySqlDataAdapter ada;
  19         DataSet ds;
  20
  21         public Form_Login(MySqlConnection connector)
  22         {
  23             InitializeComponent();
  24
  25             con = connector;
  26
  27             cmd = new MySqlCommand("", con);
  28             ada = new MySqlDataAdapter(cmd);
  29             ds = new DataSet();
  30         }
  31
  32
  33         private void administrator_Load(object sender, EventArgs e)
  34         {
  35
  36         }
  37
  38         private void button_login_Click(object sender, EventArgs e)
  39         {
  40             con.Close();
  41             con.Open();
  42             cmd.CommandText = "select * from administrator where Admin_ID='" + textBox_ID.Text + "';";
  43             cmd.ExecuteNonQuery();
  44             ada.Fill(ds);
  45             con.Close();
  46
  47             if (ds.Tables[0].Rows.Count != 0)
  48             {
  49                 if (this.textBox_pwd.Text.GetHashCode().Equals(Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[9])))
  50                 {
  51                     HospitalManageSys.SqlCmd.iflogin = true;
  52                     HospitalManageSys.SqlCmd.admin_id     = ds.Tables[0].Rows[0].ItemArray[0].ToString().PadLeft(11, '0');
  53                     HospitalManageSys.SqlCmd.admin_name   = ds.Tables[0].Rows[0].ItemArray[1].ToString();
  54                     HospitalManageSys.SqlCmd.admin_sex    = ds.Tables[0].Rows[0].ItemArray[2].ToString();
  55                     HospitalManageSys.SqlCmd.admin_job    = ds.Tables[0].Rows[0].ItemArray[3].ToString();
  56                     HospitalManageSys.SqlCmd.capab        = (byte)Convert.ToInt16(ds.Tables[0].Rows[0].ItemArray[4]);
  57                     HospitalManageSys.SqlCmd.admin_depart = ds.Tables[0].Rows[0].ItemArray[5].ToString();
  58
  59                     if (ds.Tables[0].Rows[0].ItemArray[8] != System.DBNull.Value)//如果有照片
  60                     {
  61                         byte[] images = (byte[])ds.Tables[0].Rows[0].ItemArray[8];
  62                         HospitalManageSys.SqlCmd.memStream = new MemoryStream(images);//字节流转化为内存流
  63                     }
  64
  65                     this.Close();
  66                 }
  67                 else
  68                 {
  69                     textBox_pwd.Clear();
  70                     MessageBox.Show("输入的密码错误！请重新输入！", "提示", MessageBoxButtons.OK);
  71                 }
  72             }
  73             else
  74             {
  75                 textBox_pwd.Clear();
  76                 MessageBox.Show("账号不存在！请输入正确的账号！", "提示", MessageBoxButtons.OK);
  77
  78                 return;
  79             }
  80         }
  81
  82         private void button_cancel_Click(object sender, EventArgs e)
  83         {
  84             this.Close();
  85         }
  86
  87
  88     }
  89 }