private void btn_Login_Click(object sender, EventArgs e)
{
try
{
sysHandleInfo handleInfo = new sysHandleInfo();
bool b = false;
int jiebie_Id = 0;
string sql = "SELECT * FROM login_user";
DataTable dt = data.Query(sql);
foreach (DataRow dr in dt.Rows)
{
if (this.cboUser.Text == dr["_name"].ToString() && this.txtPassWord.Text == dr["_pass"].ToString())
{
b = true;
_UserName = dr["_name"].ToString();
_PassWord = dr["_pass"].ToString();
jiebie_Id = Convert.ToInt32(dr["_jibieid"]);
string sql_id = "SELECT * FROM jibie where id='" + jiebie_Id + "'";
DataTable dt1 = data.Query(sql_id);
foreach (DataRow dr1 in dt1.Rows)
{
_RCGL = Convert.ToBoolean(dr1["_richang"]);
_FYGL = Convert.ToBoolean(dr1["_fangyuan"]);
_KHGL = Convert.ToBoolean(dr1["_kehu"]);
_NBGL = Convert.ToBoolean(dr1["_neibu"]);
_XTSZ = Convert.ToBoolean(dr1["_xitong"]);
}
}
}
if (b == true)
{
handleInfo.HandlePerson = this.cboUser.Text;
handleInfo.HandleContent = "操作登陆成功";
handleInfo.HandleRemark = this.cboUser.Text + "登陆";
dl.InserHandle(handleInfo);
if (t != true)
{
mainForm main = new mainForm();
main.Show();
this.Visible = false;
}
else
{
this.Visible = false;
}
}
else
{
MessageBox.Show("用户名或者密码不正确！", "Error:", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception)
{
throw;
}
}
public int InserHandle(sysHandleInfo syshandleInfo)
{
string date = DateTime.Now.ToString();
MySqlParameter[] para = { data.MakeInParam("?HandlePerson", MySqlDbType.VarChar, syshandleInfo.HandlePerson),
data.MakeInParam("?HandleContent", MySqlDbType.VarChar, syshandleInfo.HandleContent),
data.MakeInParam("?HandleRemark", MySqlDbType.VarChar, syshandleInfo.HandleRemark),
data.MakeInParam("?date", MySqlDbType.Datetime, date) };
string strsql = "INSERT INTO rizhi ( time, person, concent, remark) VALUES (?date,?HandlePerson,?HandleContent,?HandleRemark)";//在使用MySQL的时候使用mysqlparameters需要将@变成？号
return(data.Runsql(strsql, para));
}
