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;

namespace 人事管理
{
    public partial class login : Form
    {
        data da = new data();
        public login()
        {
            InitializeComponent();
        }

        private void logininbtn_Click(object sender, EventArgs e)
        {
                string a = null, b = null;
                SqlCommand sqlcomm = new SqlCommand("select * from Worker where WorkerLogin='" + loginnametxt.Text + "'", da.link());
                SqlDataReader reader = sqlcomm.ExecuteReader();
                reader.Read();
                try
                {
                    a = reader.GetValue(2).ToString();
                    b = reader.GetValue(3).ToString();
                }
                catch
                {

                }
                if (a == loginnametxt.Text)
                {
                    if (b == passwordtxt.Text)
                    {
                        DateTime dt=DateTime.Now;
                        string aa = dt.ToString("yyyy-MM-dd hh:mm:ss");
                        DataSet ds = new DataSet();
                        SqlDataAdapter sqlda = new SqlDataAdapter("select * from SystemEventView", da.link());
                        //添加
                        SqlCommand sqlcomm1 = new SqlCommand("insert SystemEvent (EventDepict,EventHappenTime) values(@EventDepict,@EventHappenTime)", da.link());
                        sqlcomm1.Parameters.AddWithValue("@EventDepict", "用户" + loginnametxt.Text + "登陆");
                        sqlcomm1.Parameters.AddWithValue("@EventHappenTime", aa);

                        sqlda.InsertCommand = sqlcomm1;
                        sqlda.InsertCommand.ExecuteNonQuery();
                        main main = new main();
                        if (a == "admin")
                        {
                            main.button7.Visible = true;
                        }
                        main.ShowDialog();
                        
                    }
                    else
                    {
                        MessageBox.Show("密码错误!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                        passwordtxt.Text = "";
                    }
                }
                else
                {
                    MessageBox.Show("登录名错误!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    passwordtxt.Text = "";
                }
        }
        //修改密码
        private void resetpasswordbtn_Click(object sender, EventArgs e)
        {
            if (loginnametxt.Text == "" || passwordtxt.Text == "")
            {
                MessageBox.Show("请将登录名、密码填写完整!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
            else
            {
                changepassword chapa = new changepassword();
                chapa.ShowDialog();
            }
        }
        //取消
        private void outbtn_Click(object sender, EventArgs e)
        {
            DialogResult sss = MessageBox.Show("请确认要退出!", "请确认要退出!", MessageBoxButtons.YesNo);
            if (sss == DialogResult.Yes)
            {
                this.Close();
            }
        }
    }
}