?? 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("請確認(rèn)要退出!", "請確認(rèn)要退出!", MessageBoxButtons.YesNo);
if (sss == DialogResult.Yes)
{
this.Close();
}
}
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -