private void submit_Click(object sender, EventArgs e)
{
string ac = account.Text;
string passwd = password.Text;
string rep = repasswd.Text;
if (passwd == rep)
{
MYSQL mYSQL = new MYSQL();
MySqlConnection conn = mYSQL.Connection();
conn.Open();
string sql = string.Format("INSERT INTO Login VALUES('{0}', 'kkk', '{1}', 'User');", ac, passwd);
MySqlCommand cmd = new MySqlCommand(sql, conn);
cmd.ExecuteNonQuery();
MessageBox.Show("注册成功，即将返回登陆界面...");
login login = new login();
this.Dispose();
login.ShowDialog();
}
else
{
MessageBox.Show("密码不一致，请重新输入！");
}
}
private void admindex_Load(object sender, EventArgs e)
{
AdminIndexTable.Enabled = false;
AdminIndexTable.Visible = false;
MYSQL mYSQL = new MYSQL();
MySqlConnection conn = mYSQL.Connection();
conn.Open();
string [] sql = { "SELECT COUNT(*) Num FROM Person WHERE HealthStatus = 'Sick';",
"SELECT COUNT(*) Num FROM Person WHERE HealthStatus = 'Fever';",
"SELECT COUNT(*) Num FROM Situation WHERE RiskLevel = 'L1';",
"SELECT COUNT(*) Num FROM Login WHERE Type = 'Admin';" };
string[] res = new string[4];
for (int i = 0; i < 4; i++)
{
MySqlCommand cmd = new MySqlCommand(sql[i], conn);
MySqlDataAdapter adapter = new MySqlDataAdapter(cmd);
DataSet dataSet = new DataSet();
adapter.Fill(dataSet);
res[i] = dataSet.Tables[0].Rows[0]["Num"].ToString();
}
conn.Close();
ConfirmedCases.Text += res[0];
LikelyInfection.Text += res[1];
HighRiskArea.Text += res[2];
AdminCounts.Text += res[3];
}
private void Exec_SQL(string sql)
{
MYSQL mYSQL = new MYSQL();
MySqlConnection conn = mYSQL.Connection();
conn.Open();
MySqlCommand cmd = new MySqlCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close();
}
private int Exec_SQL(string sql)
{
MYSQL mYSQL = new MYSQL();
MySqlConnection conn = mYSQL.Connection();
conn.Open();
MySqlCommand cmd = new MySqlCommand(sql, conn);
int res = cmd.ExecuteNonQuery();
conn.Close();
return(res);
}
//登陆
private void button1_Click(object sender, EventArgs e)
{
string account = textBox1.Text;
string type = loginType.Text;
string passwd = textBox2.Text;
MYSQL mYSQL = new MYSQL();
MySqlConnection conn = mYSQL.Connection();
conn.Open();
string sql = string.Format("SELECT * FROM Login WHERE Account='{0}' AND Passwd='{1}';", account, passwd);
MySqlCommand cmd = new MySqlCommand(sql, conn);
object result = cmd.ExecuteScalar();
if (result != null)
{
if (type == "User")
{
user user = new user();
this.Dispose();
user.ShowDialog();
}
else if (type == "Admin")
{
admin admin = new admin();
this.Dispose();
admin.ShowDialog();
}
else
{
MessageBox.Show("请选择账户类型！");
}
}
else
{
MessageBox.Show("账号或密码错误，请重新输入!");
}
conn.Close();
}
