登录界面.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;
using System.Collections;

namespace 图书管理
{
    public partial class 登录界面 : System.Windows.Forms.Form
    {
      
	

        public 登录界面()        {
            InitializeComponent();
        }

        private void UserID_Click(object sender, EventArgs e)
        {
           
        }

        private void 登录界面_Load(object sender, EventArgs e)
        {
            // TODO: 这行代码将数据加载到表“bookManager1DataSet2.User”中。您可以根据需要移动或移除它。
            //this.userTableAdapter.Fill(this.bookManager1DataSet2.User);
            this.sqlConnection1.Open();
          this.sqlDataAdapter1.Fill(this.dataSet1dl1);
        }

        private void pictureBox1_Click(object sender, EventArgs e)
        {

        }

        private void textUserID_TextChanged(object sender, EventArgs e)
        {
            
        }

        private void textUserPassword_TextChanged(object sender, EventArgs e)
        {

        }

        private void UserPassword_Click(object sender, EventArgs e)
        {

        }

        private void button1_Click(object sender, EventArgs e)
        {
            if (UserCheck(this.textUserID.Text, this.textUserPassword.Text) == "system")
            {

                this.Visible = false;
                Form mainform = new 主界面();
                mainform.ShowDialog();
                this.Close();
            }
            else if (UserCheck(this.textUserID.Text, this.textUserPassword.Text) == "user")
            {
                this.Visible = false;
                Form mainform = new 主界面();
                mainform.ShowDialog();
                this.Close();

            }
            else
            {
                if (MessageBox.Show("输入用户密码有误，是否重新登陆", "输入有误", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
                {
                    this.textUserID.Clear();
                    this.textUserPassword.Clear();
                    //this.textUserID.();
                }
                else
                {
                    this.Close();
                }
            }


		        }

        string UserCheck(string username, string userpassword)
        {
            string txtSql, usersort;
            usersort = "nobody";
            //txtSql = "select count(*) from User where UserID="+this.textUserID.Text+" and UserPassword="+this.textUserPassword.Text;
            txtSql = "SELECT * FROM [User]";
            //			txtSql = "SELECT * FROM ManagerUser";
            SqlCommand checkuser = new SqlCommand(txtSql, this.sqlConnection1);
            try
            {
                this.sqlConnection1.Open();
                SqlDataReader sqlreader = checkuser.ExecuteReader();
                while (sqlreader.Read())
                {
                    if ((sqlreader[0].ToString().Trim() == username) && (sqlreader[1].ToString().Trim() == userpassword))
                    {
                        usersort = sqlreader[2].ToString().Trim();
                        //this.sqlConnection1.Close();
                        break;
                    }
                }
            }
            catch (Exception e)
            {
                //Console.WriteLine(e.ToString());
                MessageBox.Show(e.ToString());
            }
            sqlConnection1.Close();
            //return "nobody";	
            return usersort;
        }


        private void button2_Click(object sender, EventArgs e)
        {
            this.textUserID.Text = "";
            this.textUserPassword.Text = "";
          
}

        private void lblUser_Click(object sender, EventArgs e)
        {

        }

        private void lblPassword_Click(object sender, EventArgs e)
        {

        }

        private void textUserPassword_TextChanged_1(object sender, EventArgs e)
        {

        }

        private void textUserID_TextChanged_1(object sender, EventArgs e)
        {

        }
    }
}