login.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.IO;
using System.Configuration;
using System.Runtime.InteropServices;



namespace BlueHill_Win_
{
    public partial class Login : Form
    {
        public Login()
        {
            InitializeComponent();
        }

        private void BtnCancel_Click(object sender, EventArgs e)
        {
            DialogResult = MessageBox.Show("你真的不打算登录南山人事管理系统吗? ", "南山人事管理系统提示你", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);

            if (DialogResult == DialogResult.OK)
            {
                Application.ExitThread();
                //Application.Exit();
            }
        }

        private void button1_Click(object sender, EventArgs e)
        {
            if (TxtUserName.Text.Trim() == "")
            {
                DialogResult = MessageBox.Show("请先输入你的用户名！", "提示");
            }
            else
            {
                SqlConnection con = DB.connection();
                con.Open();
                SqlCommand cmd = new SqlCommand("select count(*) from 员工表 where 员工登录名='" + TxtUserName.Text.ToString().Trim() + "'", con);
                int count = Convert.ToInt32(cmd.ExecuteScalar());
                if (count == 0)
                {
                    con.Close();
                    DialogResult = MessageBox.Show("该用户不存在！", "提示");
                    TxtUserName.Text = "";
                    TxtPassword.Text = "";
                    TxtUserName.Focus();
                }
                else
                {
                    //this.Hide();
                    DB.setA = TxtUserName.Text;
                    EditPassword EP = new EditPassword();
                    EP.Show();
                }
            }
        }

        private void BtnOK_Click(object sender, EventArgs e)
        {
            if (TxtUserName.Text.Trim() == "")
            {
               DialogResult= MessageBox.Show("请输入你的用户名！","提示");
               TxtUserName.Focus();
            }
            else
            {
                if (TxtPassword.Text.Trim() == "")
                {
                    DialogResult = MessageBox.Show("请输入你的密码！", "提示");
                    TxtPassword.Focus();
                }
                else
                {
                    try
                    {
                        SqlConnection con = DB.connection();
                        con.Open();
                        SqlCommand cmd = new SqlCommand("select count(*) from 员工表 where 员工登录名='" + TxtUserName.Text.ToString().Trim() + "' and 员工职位名称='人事部经理' or 员工职位名称='人事部经理助理'", con);
                        int count = Convert.ToInt32(cmd.ExecuteScalar());
                        if (count == 0)
                        {
                            con.Close();
                            DialogResult = MessageBox.Show("对不起！\r\n该用户不存在或你不是人事部管理人员！", "郑重提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                            TxtUserName.Text = "11";
                            TxtPassword.Text = "11";
                            TxtUserName.Focus();
                        }
                        else
                        {
                            SqlCommand cmd1 = new SqlCommand("select count(*) from 员工表 where 员工登录名='" + TxtUserName.Text.ToString().Trim() + "'and 员工密码='" + TxtPassword.Text.ToString().Trim() + "'", con);
                            int count1 = Convert.ToInt32(cmd1.ExecuteScalar());
                            if (count1 > 0)
                            {
                                con.Close();
                                DB.setA = TxtUserName.Text;
                                this.Hide();
                                Main M = new Main();
                                M.Show();
                            }
                            else
                            {
                                con.Close();
                                DialogResult = MessageBox.Show("密码不正确！", "提示");
                                //TxtUserName.Text = "";
                                TxtPassword.Text = "";
                                TxtPassword.Focus();

                            }
                        }
                    }
                    catch (Exception EV)
                    {
                        DialogResult = MessageBox.Show("未能连接到数据库，请先查看数据库是否正常!", "提示",MessageBoxButtons.OK,MessageBoxIcon.Error);
                    }
                    
                }
            }
            
        }

        private void Login_FormClosing(object sender, FormClosingEventArgs e)
        {
            e.Cancel = true;
            //DialogResult = MessageBox.Show("你真的不打算登录南山人事管理系统吗? ", "南山人事管理系统提示你", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);

            //if (DialogResult == DialogResult.OK)
            //{
            //    Application.ExitThread();
            //}
            //Win32.AnimateWindow(this.Handle, 2000, Win32.AW_BLEND);

        }

        private void Login_Load(object sender, EventArgs e)
        {
            Win32.AnimateWindow(this.Handle, 2000, Win32.AW_BLEND);
        }  
    }
}