public frmReader()
{
InitializeComponent();
dt = readerBLL.GetAllReaderType();
foreach (DataRow dr in dt.Rows)
{
cmbTypeForQry.Items.Add(dr["rdType"].ToString() + "--" + dr["rdTypeName"].ToString());
cmbType.Items.Add(dr["rdType"].ToString() + "--" + dr["rdTypeName"].ToString());
}
SetStatus(opStatus.inSelect);
dt = readerBLL.GetReader(0, "", "");
ShowData();
}
private void btnLogin_Click(object sender, EventArgs e)
{
loginTimes++;
int rdID;
rddID = Convert.ToInt32(txtUserID.Text.Trim());
reader = readerBLL.GetReader(rdID);
if (reader == null)
{
txtUserID.Focus();
lblReaderInfo.Text = "登录信息：查无此人..{" + loginTimes.ToString() + "}";
}
else
{
if (reader.rdPwd == txtUserPwd.Text)
{
this.DialogResult = DialogResult.OK;//登录成功
}
else
{
txtUserPwd.Text = "";
txtUserPwd.Focus();
lblReaderInfo.Text = "登录信息：..密码错误！{" + loginTimes.ToString() + "}";
}
}
}
private void dgvReader_SelectionChanged(object sender, EventArgs e)//选择行操作
{
if (dgvReader.CurrentCell == null)
{
return;
}
reader = ReaderAdmin.GetReader((int)dgvReader["rdID", dgvReader.CurrentCell.RowIndex].Value);
SetReaderToText();
}
private void btnLogin_Click(object sender, EventArgs e)
{
loginTimes++;
int rdID;
rdID = Convert.ToInt32(txtUserID.Text.Trim());
reader = ReaderAdmin.GetReader(rdID);
if (reader == null)
{
txtUserID.Focus();
lblReaderInfo.Text = "登录信息：查无此人..{" + loginTimes.ToString() + "}";
}
else
{
if (reader.rdPwd == txtUserPwd.Text)
{
this.DialogResult = DialogResult.OK;//登录成功
}
else
{
txtUserPwd.Text = "";
txtUserPwd.Focus();
lblReaderInfo.Text = "登录信息：..密码错误！{" + loginTimes.ToString() + "}";
}
}
//使用下面方法会导致数据库注入登录，不安全
//SqlConnection conn = new SqlConnection("server=.; database=bookLibrary; integrated security=true");
//conn.Open();
//SqlCommand cmd = conn.CreateCommand();
//cmd.CommandText = string.Format("select count(*) from reader where rdid={0} and rdPwd='{1}'", txtUserID.Text, txtUserPwd.Text);
//int count = Convert.ToInt32(cmd.ExecuteScalar());
//if (count == 0)
//{
// MessageBox.Show("用户登录失败！");
//}
//else
//{
// MessageBox.Show("嘿嘿，登录成功！");
//}
}
