public void RefreshForm()
{
dataGridView1.DataSource = Cdatabase.GetDataFromDB("select * from caseBook").Tables[0];
dataGridView2.DataSource = Cdatabase.GetDataFromDB("select * from volume").Tables[0];
}
private void btlogin_Click(object sender, EventArgs e)
{
if (uname.Text == "" || upwd.Text == "")
{
MessageBox.Show("用户名和密码不能为空");
}
else
{
this.Text = "正在验证...";
this.Cursor = System.Windows.Forms.Cursors.WaitCursor;
string sqlStr = "select * from admin where adminID='" + uname.Text.Trim() + "'";
DataSet ds = new DataSet();
Cdatabase.conn.ConnectionString = Cdatabase.connStr;
Cdatabase.conn.Open();
SqlDataAdapter adapter = new SqlDataAdapter(sqlStr, Cdatabase.conn);
adapter.Fill(ds);
Cdatabase.conn.Close();
if (!(ds.Tables[0].Rows.Count == 0))
{
string sqlad = "select * from admin where adminID='" + uname.Text.Trim() + "'";
DataSet ad = Cdatabase.GetDataFromDB(sqlad);
if (ad != null)
{
if (ad.Tables[0].Rows[0]["adminPwd"].ToString() == upwd.Text.ToString())
{
UserPublic.userInfo[0] = uname.Text.Trim();
UserPublic.userInfo[1] = ad.Tables[0].Rows[0]["adminName"].ToString();
UserPublic.userInfo[2] = ad.Tables[0].Rows[0]["adminPwd"].ToString();
this.Hide();
mainForm adm = new mainForm();
adm.Show();
}
else
{
MessageBox.Show("密码错误,请重新输入!", "错误");
this.Cursor = System.Windows.Forms.Cursors.Arrow;
this.Text = "登录";
//uname.Text = "";
upwd.Text = "";
uname.Focus();
}
}
else
{
MessageBox.Show("用户名错误,请重新输入!", "错误");
this.Cursor = System.Windows.Forms.Cursors.Arrow;
this.Text = "登录";
uname.Text = "";
upwd.Text = "";
uname.Focus();
}
}
else
{
MessageBox.Show("用户名不存在", "错误");
this.Cursor = System.Windows.Forms.Cursors.Arrow;
this.Text = "登录";
uname.Text = "";
upwd.Text = "";
uname.Focus();
}
}
}
public void RefreshForm()
{
dataGridView1.DataSource = Cdatabase.GetDataFromDB("select * from reader").Tables[0];
}