using System;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
namespace 企業(yè)人事管理系統(tǒng)
{
/// <summary>
/// FrmLogin 的摘要說明。
/// </summary>
public class FrmLogin : System.Windows.Forms.Form
{
private System.Windows.Forms.PictureBox pictureBox1;
private System.Windows.Forms.Button button1;
private System.Windows.Forms.Button button2;
private System.Windows.Forms.TextBox textBox1;
private System.Windows.Forms.TextBox textBox2;
private System.Windows.Forms.Label label1;
private System.Windows.Forms.Label label2;
private string UserName;
private string PassWord;
private string sql;
private System.Data.OleDb.OleDbDataAdapter oleDbDataAdapter1;
private System.Data.OleDb.OleDbCommand oleDbSelectCommand1;
private System.Data.OleDb.OleDbCommand oleDbInsertCommand1;
private System.Data.OleDb.OleDbCommand oleDbUpdateCommand1;
private System.Data.OleDb.OleDbCommand oleDbDeleteCommand1;
private System.Data.OleDb.OleDbConnection oleDbConnection1;
private 企業(yè)人事管理系統(tǒng).DataSet2 dataSet21;
private System.Windows.Forms.DataGrid dataGrid1;
/// <summary>
/// 必需的設計器變量。
/// </summary>
private System.ComponentModel.Container components = null;
public FrmLogin()
{
//
// Windows 窗體設計器支持所必需的
//
InitializeComponent();
//
// TODO: 在 InitializeComponent 調(diào)用后添加任何構(gòu)造函數(shù)代碼
//
}
/// <summary>
/// 清理所有正在使用的資源。
/// </summary>
protected override void Dispose( bool disposing )
{
if( disposing )
{
if(components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
#region Windows 窗體設計器生成的代碼
/// <summary>
/// 設計器支持所需的方法 - 不要使用代碼編輯器修改
/// 此方法的內(nèi)容。
/// </summary>
private void InitializeComponent()
{
this.pictureBox1 = new System.Windows.Forms.PictureBox();
this.button1 = new System.Windows.Forms.Button();
this.button2 = new System.Windows.Forms.Button();
this.textBox1 = new System.Windows.Forms.TextBox();
this.textBox2 = new System.Windows.Forms.TextBox();
this.label1 = new System.Windows.Forms.Label();
this.label2 = new System.Windows.Forms.Label();
this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbUpdateCommand1 = new System.Data.OleDb.OleDbCommand();
this.dataSet21 = new 企業(yè)人事管理系統(tǒng).DataSet2();
this.dataGrid1 = new System.Windows.Forms.DataGrid();
((System.ComponentModel.ISupportInitialize)(this.dataSet21)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
this.SuspendLayout();
//
// pictureBox1
//
this.pictureBox1.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
this.pictureBox1.Location = new System.Drawing.Point(40, 32);
this.pictureBox1.Name = "pictureBox1";
this.pictureBox1.Size = new System.Drawing.Size(272, 96);
this.pictureBox1.TabIndex = 0;
this.pictureBox1.TabStop = false;
//
// button1
//
this.button1.Location = new System.Drawing.Point(72, 152);
this.button1.Name = "button1";
this.button1.TabIndex = 1;
this.button1.Text = "登錄";
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// button2
//
this.button2.Location = new System.Drawing.Point(200, 152);
this.button2.Name = "button2";
this.button2.TabIndex = 2;
this.button2.Text = "取消";
this.button2.Click += new System.EventHandler(this.button2_Click);
//
// textBox1
//
this.textBox1.Location = new System.Drawing.Point(144, 56);
this.textBox1.Name = "textBox1";
this.textBox1.Size = new System.Drawing.Size(128, 21);
this.textBox1.TabIndex = 3;
this.textBox1.Text = "";
this.textBox1.TextChanged += new System.EventHandler(this.textBox1_TextChanged);
//
// textBox2
//
this.textBox2.Location = new System.Drawing.Point(144, 96);
this.textBox2.Name = "textBox2";
this.textBox2.Size = new System.Drawing.Size(128, 21);
this.textBox2.TabIndex = 4;
this.textBox2.Text = "";
//
// label1
//
this.label1.Location = new System.Drawing.Point(56, 56);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(88, 23);
this.label1.TabIndex = 5;
this.label1.Text = "***名稱";
//
// label2
//
this.label2.Location = new System.Drawing.Point(56, 96);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(88, 23);
this.label2.TabIndex = 6;
this.label2.Text = "***口令";
//
// oleDbDataAdapter1
//
this.oleDbDataAdapter1.DeleteCommand = this.oleDbDeleteCommand1;
this.oleDbDataAdapter1.InsertCommand = this.oleDbInsertCommand1;
this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "管理用戶", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("用戶口令", "用戶口令"),
new System.Data.Common.DataColumnMapping("用戶名稱", "用戶名稱"),
new System.Data.Common.DataColumnMapping("用戶權(quán)限", "用戶權(quán)限")})});
this.oleDbDataAdapter1.UpdateCommand = this.oleDbUpdateCommand1;
//
// oleDbDeleteCommand1
//
this.oleDbDeleteCommand1.CommandText = "DELETE FROM 管理用戶 WHERE (用戶名稱 = ?) AND (用戶口令 = ? OR ? IS NULL AND 用戶口令 IS NULL) AN" +
"D (用戶權(quán)限 = ? OR ? IS NULL AND 用戶權(quán)限 IS NULL)";
this.oleDbDeleteCommand1.Connection = this.oleDbConnection1;
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_用戶名稱", System.Data.OleDb.OleDbType.VarWChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "用戶名稱", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_用戶口令", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "用戶口令", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_用戶口令1", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "用戶口令", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_用戶權(quán)限", System.Data.OleDb.OleDbType.VarWChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "用戶權(quán)限", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_用戶權(quán)限1", System.Data.OleDb.OleDbType.VarWChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "用戶權(quán)限", System.Data.DataRowVersion.Original, null));
//
// oleDbConnection1
//
this.oleDbConnection1.ConnectionString = @"Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Database Password=;Data Source=""g:\document. and Settings\Administrator\My document.\Visual Studio Projects\企業(yè)人事管理系統(tǒng)\企業(yè)人事管理系統(tǒng)\DateBase\DateBase.mdb"";Password=;Jet OLEDB:Engine Type=5;Jet OLEDB:Global Bulk Transactions=1;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:New Database Password=;Jet OLEDB:Create System Database=False;Jet OLEDB:Don‘t Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Encrypt Database=False";
//
// oleDbInsertCommand1
//
this.oleDbInsertCommand1.CommandText = "INSERT INTO 管理用戶(用戶口令, 用戶名稱, 用戶權(quán)限) valueS (?, ?, ?)";
this.oleDbInsertCommand1.Connection = this.oleDbConnection1;
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("用戶口令", System.Data.OleDb.OleDbType.VarWChar, 10, "用戶口令"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("用戶名稱", System.Data.OleDb.OleDbType.VarWChar, 15, "用戶名稱"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("用戶權(quán)限", System.Data.OleDb.OleDbType.VarWChar, 15, "用戶權(quán)限"));
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = "SELECT 用戶口令, 用戶名稱, 用戶權(quán)限 FROM 管理用戶";
this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
//
// oleDbUpdateCommand1
//
this.oleDbUpdateCommand1.CommandText = "UPDATE 管理用戶 SET 用戶口令 = ?, 用戶名稱 = ?, 用戶權(quán)限 = ? WHERE (用戶名稱 = ?) AND (用戶口令 = ? OR ? " +
"IS NULL AND 用戶口令 IS NULL) AND (用戶權(quán)限 = ? OR ? IS NULL AND 用戶權(quán)限 IS NULL)";
this.oleDbUpdateCommand1.Connection = this.oleDbConnection1;
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("用戶口令", System.Data.OleDb.OleDbType.VarWChar, 10, "用戶口令"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("用戶名稱", System.Data.OleDb.OleDbType.VarWChar, 15, "用戶名稱"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("用戶權(quán)限", System.Data.OleDb.OleDbType.VarWChar, 15, "用戶權(quán)限"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_用戶名稱", System.Data.OleDb.OleDbType.VarWChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "用戶名稱", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_用戶口令", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "用戶口令", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_用戶口令1", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "用戶口令", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_用戶權(quán)限", System.Data.OleDb.OleDbType.VarWChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "用戶權(quán)限", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_用戶權(quán)限1", System.Data.OleDb.OleDbType.VarWChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "用戶權(quán)限", System.Data.DataRowVersion.Original, null));
//
// dataSet21
//
this.dataSet21.DataSetName = "DataSet2";
this.dataSet21.Locale = new System.Globalization.CultureInfo("zh-CN");
//
// dataGrid1
//
this.dataGrid1.AlternatingBackColor = System.Drawing.Color.GhostWhite;
this.dataGrid1.BackColor = System.Drawing.Color.GhostWhite;
this.dataGrid1.BackgroundColor = System.Drawing.Color.Lavender;
this.dataGrid1.BorderStyle = System.Windows.Forms.BorderStyle.None;
this.dataGrid1.CaptionBackColor = System.Drawing.Color.RoyalBlue;
this.dataGrid1.CaptionForeColor = System.Drawing.Color.White;
this.dataGrid1.DataMember = "";
this.dataGrid1.DataSource = this.dataSet21.管理用戶;
this.dataGrid1.FlatMode = true;
this.dataGrid1.Font = new System.Drawing.Font("Tahoma", 8F);
this.dataGrid1.ForeColor = System.Drawing.Color.MidnightBlue;
this.dataGrid1.GridLineColor = System.Drawing.Color.RoyalBlue;
this.dataGrid1.HeaderBackColor = System.Drawing.Color.MidnightBlue;
this.dataGrid1.HeaderFont = new System.Drawing.Font("Tahoma", 8F, System.Drawing.FontStyle.Bold);
this.dataGrid1.HeaderForeColor = System.Drawing.Color.Lavender;
this.dataGrid1.LinkColor = System.Drawing.Color.Teal;
this.dataGrid1.Location = new System.Drawing.Point(8, 192);
this.dataGrid1.Name = "dataGrid1";
this.dataGrid1.ParentRowsBackColor = System.Drawing.Color.Lavender;
this.dataGrid1.ParentRowsForeColor = System.Drawing.Color.MidnightBlue;
this.dataGrid1.SelectionBackColor = System.Drawing.Color.Teal;
this.dataGrid1.SelectionForeColor = System.Drawing.Color.PaleGreen;
this.dataGrid1.Size = new System.Drawing.Size(328, 152);
this.dataGrid1.TabIndex = 7;
//
// FrmLogin
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(352, 352);
this.Controls.Add(this.dataGrid1);
this.Controls.Add(this.label2);
this.Controls.Add(this.label1);
this.Controls.Add(this.textBox2);
this.Controls.Add(this.textBox1);
this.Controls.Add(this.button2);
this.Controls.Add(this.button1);
this.Controls.Add(this.pictureBox1);
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None;
this.Name = "FrmLogin";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterParent;
this.Text = "FrmLogin";
((System.ComponentModel.ISupportInitialize)(this.dataSet21)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
this.ResumeLayout(false);
}
#endregion
private void textBox1_TextChanged(object sender, System.EventArgs e)
{
}
public void FillDataSet(DataSet2 dataSet21)
{
//在填充數(shù)據(jù)集前關(guān)閉約束檢查
//這允許適配器填充數(shù)據(jù)集而不用考慮
//表之間的依賴項
dataSet21.EnforceConstraints=false;
try
{
//打開連接
if(this.oleDbConnection1.State!=ConnectionState.Closed)
this.oleDbConnection1.Close();
this.oleDbConnection1.Open();
//嘗試通過 oleDbDataAdapter1 填充數(shù)據(jù)集
this.oleDbDataAdapter1.Fill(dataSet21);
}
catch(Exception fillException)
{
//在此處添加錯誤處理代理
MessageBox.Show(fillException.Message);
}
finally
{
dataSet21.EnforceConstraints=true;
this.oleDbConnection1.Close();
}
}
public void LoadDataSet()
{
//創(chuàng)建一個新數(shù)據(jù)集以保存從FillDataSet 調(diào)用返回的記錄.
//使用了一個臨時數(shù)據(jù)集，這是因為填充現(xiàn)在的數(shù)據(jù)集
//需要重新綁定數(shù)據(jù)綁定
DataSet2 objDataSetTemp=new DataSet2();
try
{
this.FillDataSet(objDataSetTemp);
}
catch(Exception eFillDataSet)
{
MessageBox.Show(eFillDataSet.Message);
}
try
{
this.dataSet21.Clear();
this.dataSet21.Merge(objDataSetTemp);
}
catch(Exception eLoadMerge)
{
MessageBox.Show(eLoadMerge.Message);
}
}
private void button1_Click(object sender, System.EventArgs e)
{
//用戶驗證代碼
UserName=this.textBox1.Text.Trim();
PassWord=this.textBox2.Text.Trim();
if(UserName!=null&&PassWord!=null)
{
sql="SELECT 用戶口令, 用戶名稱, 用戶權(quán)限 FROM 管理用戶 WHERE 用戶名稱 = ‘"+ UserName + "‘ and 用戶口令 =‘" + PassWord + "‘";
}
if(UserName!=null&&PassWord!=null)
{
this.oleDbSelectCommand1.CommandText=sql;
}
try
{
this.LoadDataSet();
DataTable dt=dataSet21.Tables["管理用戶"];
if(dt.Rows.Count!=0)
{
if(dt.Rows[0]["用戶權(quán)限"].ToString()=="Administrators")
//MessageBox.Show("用戶驗證成功");
{
Form1 f1=new Form1();
f1.Show();
this.Close();
}
}
}
// try
// {
// if (UserName!=null&&PassWord!=null)
// {
// logindataSet1=new DataSet();
//
// sql="SELECT 用戶口令, 用戶名稱, 用戶權(quán)限 FROM 管理用戶 where 用戶名稱 = ‘"+ UserName + "‘ and 用戶口令 =‘" + PassWord + "‘";
// oleDbCommand1=new System.Data.OleDb.OleDbCommand();
// oleDbCommand1.CommandText=sql;
// oleDbCommand1.Connection=this.oleDbConnection1;
//
//
// ada=new System.Data.OleDb.OleDbDataAdapter();
// ada.SelectCommand=oleDbCommand1;
// oleDbConnection1.Open();
// ada.Fill(logindataSet1);
//
//
// //ada.Fill(logindataSet1,"管理用戶");
// DataTable dt=logindataSet1.Tables["管理用戶"];
//
// if(dt.Rows.Count!=0)
// {
// if(dt.Rows[0]["用戶權(quán)限"].ToString()=="Administrators")
// {
// MessageBox.Show("用戶正確登陸");
// }
// }
// }
catch(Exception eLogin)
{
MessageBox.Show(eLogin.Message);
}
}
private void button2_Click(object sender, System.EventArgs e)
{
this.Close();
}
private void oleDbDataAdapter1_RowUpdated(object sender, System.Data.OleDb.OleDbRowUpdatedEventArgs e)
{
}
}
}
