public bool Is_likely(MYSQL mYSQL, string city, string area, string st, string et) //看是否有与确诊病例接触的可能
{
string sql = string.Format("SELECT Pname, City, Area, StartTime, EndTime, SickTime FROM Patient_Record WHERE City = '{0}' AND Area = '{1}' AND StartTime <= '{2}' AND EndTime > '{3}';", city, area, st, st);
DataTable table = mYSQL.GetMessage(sql);
if (table.Rows.Count > 0)
{
Stable.DataSource = table;
return(true);
}
else
{
return(false);
}
}
public bool Is_fever(MYSQL mYSQL, string id)
{
string sql = string.Format("SELECT * FROM Fever WHERE Pid = '{0}';", id);
DataTable table = mYSQL.GetMessage(sql);
if (table.Rows.Count > 0)
{
Stable.DataSource = table;
return(true);
}
else
{
return(false);
}
}
private void LikelyInfection_Click(object sender, EventArgs e)
{
if (state)
{
AdminIndexTable.Enabled = true;
AdminIndexTable.Visible = true;
MYSQL mYSQL = new MYSQL();
string sql = "SELECT Pname, HealthStatus, SickTime FROM Person WHERE HealthStatus = 'Fever' LIMIT 0, 10;";
DataTable dataTable = mYSQL.GetMessage(sql);
AdminIndexTable.DataSource = dataTable;
}
else
{
AdminIndexTable.Enabled = false;
AdminIndexTable.Visible = false;
}
state = !state;
}
private void HighRiskArea_Click(object sender, EventArgs e)
{
if (state)
{
AdminIndexTable.Enabled = true;
AdminIndexTable.Visible = true;
MYSQL mYSQL = new MYSQL();
string sql = "SELECT City, Area, RiskLevel FROM Situation WHERE RiskLevel = 'L1';";
DataTable dataTable = mYSQL.GetMessage(sql);
AdminIndexTable.DataSource = dataTable;
}
else
{
AdminIndexTable.Enabled = false;
AdminIndexTable.Visible = false;
}
state = !state;
}
private void AdminCounts_Click(object sender, EventArgs e)
{
if (state)
{
AdminIndexTable.Enabled = true;
AdminIndexTable.Visible = true;
MYSQL mYSQL = new MYSQL();
string sql = "SELECT Account, Name FROM Login WHERE Type = 'Admin';";
DataTable dataTable = mYSQL.GetMessage(sql);
AdminIndexTable.DataSource = dataTable;
}
else
{
AdminIndexTable.Enabled = false;
AdminIndexTable.Visible = false;
}
state = !state;
}
private void Delete_Click(object sender, EventArgs e)
{
string id = actID.Text;
string city = actCity.Text;
string area = actArea.Text;
string st = Ast.Text;
string et = Aet.Text;
string sql = string.Format("DELETE FROM Record WHERE Pid = '{0}' AND City = '{1}' AND Area = '{2}' AND StartTime >= '{3}' AND EndTime <= '{4}';", id, city, area, st, et);
Exec_SQL(sql);
sql = string.Format("SELECT * FROM Record WHERE Pid = '{0}' AND City = '{1}' AND Area = '{2}' AND StartTime >= '{3}' AND EndTime <= '{4}'; ", id, city, area, st, et);
MYSQL mYSQL = new MYSQL();
DataTable table = mYSQL.GetMessage(sql);
ActRecordTable.DataSource = table;
MessageBox.Show("Delete Done!");
}
private void modify_Click(object sender, EventArgs e)
{
//怎么实现全码的更改?
string id = actID.Text;
string city = actCity.Text;
string area = actArea.Text;
string st = Ast.Text;
string et = Aet.Text;
//string sql = string.Format("UPDATE Record WHERE Pid = '{0}' AND City = '{1}' AND Area = '{2}' AND StartTime = '{3}' AND EndTime = '{4}';", id, city, area, st, et);
string sql = string.Format("INSERT INTO Record VALUES('{0}', '{1}', '{2}', '{3}', '{4}');", id, city, area, st, et);
Exec_SQL(sql);
sql = string.Format("SELECT * FROM Record WHERE Pid = '{0}' AND City = '{1}' AND Area = '{2}' AND StartTime >= '{3}' AND EndTime <= '{4}'; ", id, city, area, st, et);
MYSQL mYSQL = new MYSQL();
DataTable table = mYSQL.GetMessage(sql);
ActRecordTable.DataSource = table;
MessageBox.Show("Update Done!");
}
private void confirm_Click(object sender, EventArgs e)
{
string id, name;
//string fevertime, sicktime;
string sqlR, sqlC, sqlP;
MYSQL mYSQL = new MYSQL();
if (searchType1.Text == "身份证号")
{
id = searchCondition.Text;
if (searchType2.Text == "发热")
{
sqlR = string.Format("SELECT City, Area, StartTime, EndTime FROM Fever_Record " +
"WHERE Pid = '{0}' AND EndTime < SickTime ORDER BY(StartTime);", id);
sqlC = string.Format("SELECT Pname, HealthStatus, Fever_Patient_Record.City, Fever_Patient_Record.Area, Fever_Patient_Record.StartTime, Fever_Patient_Record.EndTime " +
"FROM Fever_Patient_Record, " +
"(SELECT Pid, City, Area, StartTime, EndTime " +
"FROM Fever_Record " +
"WHERE Pid = '{0}' AND EndTime < SickTime" +
")AS R1 " +
"WHERE Fever_Patient_Record.Pid <> R1.Pid AND (Fever_Patient_Record.StartTime <= R1.StartTime AND Fever_Patient_Record.EndTime >= R1.EndTime) " +
"AND (Fever_Patient_Record.City = R1.City AND Fever_Patient_Record.Area = R1.Area) AND SickTime < R1.EndTime;", id);
sqlP = string.Format("SELECT Pname, HealthStatus, Health_Record.City, Health_Record.Area, Health_Record.StartTime, Health_Record.EndTime " +
"FROM Health_Record, " +
"(SELECT Pid, City, Area, StartTime, EndTime " +
"FROM Fever_Record " +
"WHERE Pid = '{0}' AND EndTime < SickTime" +
")AS R1 " +
"WHERE Health_Record.Pid <> R1.Pid AND (Health_Record.StartTime >= R1.StartTime AND Health_Record.EndTime <= R1.EndTime) " +
"AND (Health_Record.City = R1.City AND Health_Record.Area = R1.Area);", id);
rTable = mYSQL.GetMessage(sqlR);
cTable = mYSQL.GetMessage(sqlC);
ptable = mYSQL.GetMessage(sqlP);
}
else if (searchType2.Text == "已确诊")
{
sqlR = string.Format("SELECT City, Area, StartTime, EndTime FROM Patient_Record " +
"WHERE Pid = '{0}' AND EndTime < SickTime ORDER BY(StartTime);", id);
sqlC = string.Format("SELECT Pname, HealthStatus, Fever_Patient_Record.City, Fever_Patient_Record.Area, Fever_Patient_Record.StartTime, Fever_Patient_Record.EndTime " +
"FROM Fever_Patient_Record, " +
"(SELECT Pid, City, Area, StartTime, EndTime " +
"FROM Patient_Record " +
"WHERE Pid = '{0}' AND EndTime < SickTime" +
")AS R1 " +
"WHERE Fever_Patient_Record.Pid <> R1.Pid AND (Fever_Patient_Record.StartTime <= R1.StartTime AND Fever_Patient_Record.EndTime >= R1.EndTime) " +
"AND (Fever_Patient_Record.City = R1.City AND Fever_Patient_Record.Area = R1.Area) AND SickTime < R1.EndTime;", id);
sqlP = string.Format("SELECT Pname, HealthStatus, Health_Record.City, Health_Record.Area, Health_Record.StartTime, Health_Record.EndTime " +
"FROM Health_Record, " +
"(SELECT Pid, City, Area, StartTime, EndTime " +
"FROM Patient_Record " +
"WHERE Pid = '{0}' AND EndTime < SickTime" +
")AS R1 " +
"WHERE Health_Record.Pid <> R1.Pid AND (Health_Record.StartTime >= R1.StartTime AND Health_Record.EndTime <= R1.EndTime) " +
"AND (Health_Record.City = R1.City AND Health_Record.Area = R1.Area);", id);
rTable = mYSQL.GetMessage(sqlR);
cTable = mYSQL.GetMessage(sqlC);
ptable = mYSQL.GetMessage(sqlP);
}
else
{
MessageBox.Show("请选择查询关键字！");
}
}
else if (searchType1.Text == "姓名")
{
name = searchCondition.Text;
if (searchType2.Text == "发热")
{
sqlR = string.Format("SELECT City, Area, StartTime, EndTime FROM Fever_Record " +
"WHERE Pname = '{0}' AND EndTime < SickTime ORDER BY(StartTime);", name);
sqlC = string.Format("SELECT Pname, HealthStatus, Fever_Patient_Record.City, Fever_Patient_Record.Area, Fever_Patient_Record.StartTime, Fever_Patient_Record.EndTime " +
"FROM Fever_Patient_Record, " +
"(SELECT Pid, City, Area, StartTime, EndTime " +
"FROM Fever_Record " +
"WHERE Pname = '{0}' AND EndTime < SickTime" +
")AS R1 " +
"WHERE Fever_Patient_Record.Pid <> R1.Pid AND (Fever_Patient_Record.StartTime <= R1.StartTime AND Fever_Patient_Record.EndTime >= R1.EndTime) " +
"AND (Fever_Patient_Record.City = R1.City AND Fever_Patient_Record.Area = R1.Area) AND SickTime < R1.EndTime;", name);
sqlP = string.Format("SELECT Pname, HealthStatus, Health_Record.City, Health_Record.Area, Health_Record.StartTime, Health_Record.EndTime " +
"FROM Health_Record, " +
"(SELECT Pid, City, Area, StartTime, EndTime " +
"FROM Fever_Record " +
"WHERE Pname = '{0}' AND EndTime < SickTime" +
")AS R1 " +
"WHERE Health_Record.Pid <> R1.Pid AND (Health_Record.StartTime >= R1.StartTime AND Health_Record.EndTime <= R1.EndTime) " +
"AND (Health_Record.City = R1.City AND Health_Record.Area = R1.Area);", name);
rTable = mYSQL.GetMessage(sqlR);
cTable = mYSQL.GetMessage(sqlC);
ptable = mYSQL.GetMessage(sqlP);
}
else if (searchType2.Text == "已确诊")
{
sqlR = string.Format("SELECT City, Area, StartTime, EndTime FROM Patient_Record " +
"WHERE Pname = '{0}' AND EndTime < SickTime ORDER BY(StartTime);", name);
sqlC = string.Format("SELECT Pname, HealthStatus, Fever_Patient_Record.City, Fever_Patient_Record.Area, Fever_Patient_Record.StartTime, Fever_Patient_Record.EndTime " +
"FROM Fever_Patient_Record, " +
"(SELECT Pid, City, Area, StartTime, EndTime " +
"FROM Patient_Record " +
"WHERE Pname = '{0}' AND EndTime < SickTime" +
")AS R1 " +
"WHERE Fever_Patient_Record.Pid <> R1.Pid AND (Fever_Patient_Record.StartTime <= R1.StartTime AND Fever_Patient_Record.EndTime >= R1.EndTime) " +
"AND (Fever_Patient_Record.City = R1.City AND Fever_Patient_Record.Area = R1.Area) AND SickTime < R1.EndTime;", name);
sqlP = string.Format("SELECT Pname, HealthStatus, Health_Record.City, Health_Record.Area, Health_Record.StartTime, Health_Record.EndTime " +
"FROM Health_Record, " +
"(SELECT Pid, City, Area, StartTime, EndTime " +
"FROM Patient_Record " +
"WHERE Pname = '{0}' AND EndTime < SickTime" +
")AS R1 " +
"WHERE Health_Record.Pid <> R1.Pid AND (Health_Record.StartTime >= R1.StartTime AND Health_Record.EndTime <= R1.EndTime) " +
"AND (Health_Record.City = R1.City AND Health_Record.Area = R1.Area);", name);
rTable = mYSQL.GetMessage(sqlR);
cTable = mYSQL.GetMessage(sqlC);
ptable = mYSQL.GetMessage(sqlP);
}
else
{
MessageBox.Show("请选择查询关键字！");
}
}
else
{
MessageBox.Show("请选择查询关键字！");
}
}