登录按钮与方法:
private void button1_Click(object sender, EventArgs e)
{
sysAdmin sysAdmin = new sysAdmin()
{
LoginName = this.textBox1.Text,
LoninPwd = this.textBox2.Text
};
sysAdmin = ckAdmin(sysAdmin);
if (sysAdmin == null)
{
MessageBox.Show("账号或农密码错误");
}
else
{
this.DialogResult = DialogResult.OK;
}
}
private sysAdmin ckAdmin(sysAdmin sysAdmin)
{
string sql = "Select LoginId,Role from SysAdmin where LoginName='{0}'and LoginPwd='{1}'";
sql = string.Format(sql, sysAdmin.LoginName, sysAdmin.LoninPwd);
DataSet dataSet = SQLHelper.GetDataSet(sql);
if (dataSet !=null & dataSet.Tables.Count == 1)
{
if (dataSet.Tables[0].Rows.Count > 0)
{
sysAdmin.LoginId =Convert.ToInt32( dataSet.Tables[0].Rows[0]["LoginId"]);
sysAdmin.Role = Convert.ToInt32(dataSet.Tables[0].Rows[0]["Role"]);
return sysAdmin;
}
else
{
return null;
}
}
else
{
return null;
}
}