frmlogin

using System;
using System.Collections.Generic;
using https://www.wendangku.net/doc/2c7114254.html,ponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace WindowsFormsApplication1
{

public partial class FrmLogin : Form
{
string path = Application.StartupPath + "\\" + "DbSet.ini";
FrmPassword ob_FrmPassword;
public FrmLogin()
{
InitializeComponent();
}
///

/// 登陆窗体的载入事件代码
///

///
///
private void FrmLogin_Load(object sender, EventArgs e)
{
try
{
if (File.Exists(path))
{
StreamReader sr = new StreamReader(path, Encoding.GetEncoding("GB2312"));
CDataBase.connStr = sr.ReadLine();
sr.Close();

}
else
{
MessageBox.Show("初次使用本软件，请先配置数据库", "提示");
this.Height = 450;
txtUserName.Enabled = false;
txtUserPassword.Enabled = false;
btnLogin.Enabled = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}

}

///

/// 登录按钮的单击事件代码
///

///
///
private void btnLogin_Click(object sender, EventArgs e)
{
try
{

if (txtUserName.Text.Trim() == "")
{

MessageBox.Show("用户名不能为空！");
txtUserName.Focus();
return;
}
else if (txtUserPassword.Text.Trim() == "")
{

MessageBox.Show("密码不能为空！");
txtUserPassword.Focus();
return;
}
this.Text = "正在验证...";
this.Cursor = System.Windows.Forms.Cursors.WaitCursor;
string psw = CPublic.GetMd5Str(txtUserPassword.Text.Trim());
string sqlStr = "select userPassword, userPurview,firstLogin from tbl_User where userName='" + txtUserName.Text.Trim() + "'";


CDataBase.conn.ConnectionString = CDataBase.connStr;
CDataBase.conn.Open();
SqlCommand cmd =new SqlCommand (sqlStr,CDataBase.conn);
SqlDataReader sdr = cmd.ExecuteReader();
if (!sdr.Read())
//SqlDataAdapter adapter = new SqlDataAdapter(sqlSt

r, CDataBase.conn);
//adapter.Fill(ds);
//if (ds.Tables[0].Rows.Count == 0)
{

MessageBox.Show("用户名错误，请重新输入！");
this.Cursor = System.Windows.Forms.Cursors.Arrow;
this.Text = "用户登录";
txtUserName.Text = "";
txtUserPassword.Text = "";
txtUserName.Focus();
}
//else if (ds.Tables[0].Rows[0].ItemArray[0].ToString().Trim() == txtUserPassword.Text.Trim())
else if (sdr["userPassword"].ToString().Trim() ==psw.Trim())
{
FrmMain ob_FrmMain = new FrmMain();
https://www.wendangku.net/doc/2c7114254.html,erInfo[0] = txtUserName.Text.Trim();
https://www.wendangku.net/doc/2c7114254.html,erInfo[1] = psw.Trim();
//https://www.wendangku.net/doc/2c7114254.html,erInfo[2] =
// ds.Tables[0].Rows[0].ItemArray[1].ToString().Trim();
//https://www.wendangku.net/doc/2c7114254.html,erInfo[3] =
// ds.Tables[0].Rows[0].ItemArray[2].ToString().Trim();
https://www.wendangku.net/doc/2c7114254.html,erInfo[2] = sdr["userPurview"].ToString().Trim();
https://www.wendangku.net/doc/2c7114254.html,erInfo[3] = sdr["firstLogin"].ToString().Trim();
this.Cursor = System.Windows.Forms.Cursors.Arrow;
this.Text = "用户登录";
ob_FrmMain.Show();
this.Hide();

//第一次登陆提醒设置个人信息
CDataBase.conn.Close();
if (https://www.wendangku.net/doc/2c7114254.html,erInfo[3] == "是")
{
MessageBox.Show("未设置个人信息，请先设置，否者一旦忘记密码将无法找回!","严重警告",MessageBoxButtons.OK,MessageBoxIcon.Warning);
FrmInformation ob_FrmInformation = new FrmInformation();
ob_FrmInformation.Show();
}
}
else
{
MessageBox.Show("密码错误，请重新输入！");
this.Cursor = System.Windows.Forms.Cursors.Arrow;
this.Text = "用户登录";
txtUserPassword.Text = "";
txtUserPassword.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "登陆异常！");
this.Cursor = System.Windows.Forms.Cursors.Arrow;
this.Text = "用户登录";
txtUserName.Text = "";
txtUserPassword.Text = "";
txtUserName.Focus();

}
finally
{
CDataBase.conn.Close();
}
}
///

/// 取消按钮的单击事件代码
///

///

///
private void btnCancel_Click(object sender, EventArgs e)
{
Application.Exit();
}

///

/// 文本框txtUserPassword的KeyDown事件
///

///
///
private void txtUserPassword_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
btnLogin_Click (sender,e);
}
}

///

/// 窗体FrmLogin的FormClosed事件
///

///
///
private void FrmLogin_KeyDown(object sender, KeyEventArgs e)
{
Application.Exit();
}

//private void textBox5_TextChanged(object sender, EventArgs e)
//{

//}
///

/// 【配置】按钮的单击事件代码
///

///
///
private void btnSet_Click(object sender, EventArgs e)
{
if (this.Height == 230)
{
this.Height = 450;
txtUserName.Enabled = false;
txtUserPassword.Enabled = false;
btnLogin.Enabled = false;
txtServerWin.Focus();
}
else
{
this.Height = 230;
txtUserName.Enabled = true;
txtUserPassword.Enabled = true;
btnLogin.Enabled = true;
txtUserName.Focus();
}
}

///

/// Windows 身份验证模式的【确定】按钮的单击事件代码
///

///
///
private void btnOkWin_Click(object sender, EventArgs e)
{
try
{
if (txtServerWin.Text.Trim() == "")
{
MessageBox.Show("请输入数据库服务器名称！","提示");
txtServerWin.Focus();
}
else if (txtDataBaseWin.Text.Trim() == "")
{
MessageBox.Show("请输入数据库名称！");
txtDataBaseWin.Focus();
}
else
{
this.Height = 230;
StreamWriter sw = new StreamWriter(path,false,Encoding.GetEncoding("GB2312"));
string connStr = "server=" + txtServerWin.Text.Trim() + ";database=" + txtDataBaseWin.Text.Trim() + ";Integrated Security=True";
sw.WriteLine(connStr);
sw.Close();
txtUserName.Enabled = true;
txtUserP

assword.Enabled = true;
btnLogin.Enabled = true;
txtUserName.Focus();
CDataBase.connStr = connStr;

}
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
}

///

/// Windows 身份验证模式的【取消】按钮的单击事件代码
///

///
///
private void btnCancelWin_Click(object sender, EventArgs e)
{
this.Height = 230;
txtUserName.Enabled = true;
txtUserPassword.Enabled = true;
btnLogin.Enabled = true;
txtUserName.Focus();
}
///

/// SQL Server 身份验证模式的【确定】按钮的单击事件代码
///

///
///
private void btnOkSql_Click(object sender, EventArgs e)
{
try
{
if (txtServerSql.Text.Trim() == "")
{
MessageBox.Show("请输入数据库服务器名称！", "提示");
txtServerSql.Focus();
}
else if (txtDataBaseSql.Text.Trim() == "")
{
MessageBox.Show("请输入数据库名称！");
txtDataBaseSql.Focus();
}
else
{
this.Height = 230;
StreamWriter sw = new StreamWriter(path, false, Encoding.GetEncoding("GB2312"));
string connStr = "server=" + txtServerSql.Text.Trim() + ";database=" + txtDataBaseSql.Text.Trim() + ";uid"+txtUserSql.Text.Trim() + ";pwd=" +txtPasswordSql.Text.Trim();
sw.WriteLine(connStr);
sw.Close();
txtUserName.Enabled = true;
txtUserPassword.Enabled = true;
btnLogin.Enabled = true;
txtUserName.Focus();
CDataBase.connStr = connStr;

}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}

///

/// SQL Server 身份验证模式的【取消】按钮的单击事件代码
///

///
///
private void btnCancelSql_Click(object sender, EventArgs e)
{
this.Height = 230;
txtUserName.Enabled = true;
txtUserPassword.Enabled = true;
btnLogin.Enabled = true;
txtUserName.Focus();
}

///

/// 选项卡控件的SelectedIndexCh

anged事件代码
///

///
///
private void tbcSet_SelectedIndexChanged_1(object sender, EventArgs e)
{
if (tbcSet.SelectedIndex == 0)
{
txtServerWin.Focus();
}
else
{
txtServerSql.Focus();
}
}

///

/// 【忘记密码？】链接
///

///
///
private void lblForgetPassword_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
if (ob_FrmPassword == null || ob_FrmPassword.IsDisposed)
{
ob_FrmPassword = new FrmPassword();
ob_FrmPassword.Show();
}
else
{
ob_FrmPassword.Activate();
}
}

///

/// 窗体FrmLogin的FormClosedFormClosed事件代码
///

///
///
private void FrmLogin_FormClosed(object sender, FormClosedEventArgs e)
{
Application.Exit();
}


}
}