private void 除测试数据ToolStripMenuItem_Click(object sender, EventArgs e)
{
OleDbBase.DB db = new OleDbBase.DB();
db.Exec("delete * from TW");
BuildDGV();
}
private void 生成测试数据ToolStripMenuItem_Click(object sender, EventArgs e)
{
string tempstr = "";
OleDbBase.DB db = new OleDbBase.DB();
Random rd = new Random();
int tw = 0;
DateTime d1 = DateTime.Parse(DateTime.Now.AddDays(-4).ToShortDateString() + " 06:00:00");
for (int i = 0; i < 5; i++)
{
d1 = d1.AddDays(i);
for (int ii = 0; ii < 18; ii++)
{
d1 = d1.AddHours(ii);
switch (ii + 6)
{
case 6:
case 7:
tw = rd.Next(3);
break;
case 14:
case 15:
tw = rd.Next(2, 5);
break;
default:
tw = rd.Next(4, 8);
break;
}
tempstr += "insert into TW (UserName,PutDateTime,Weather,TW) values ('柳永法',#" + d1 + "#,'晴',36." + tw + "0)" + "\r";
d1 = d1.AddHours(ii * (-1));
}
d1 = d1.AddDays(i * (-1));
}
db.Exec(tempstr.Split('\r'));
BuildDGV();
}
private void button1_Click(object sender, EventArgs e)
{
OleDbBase.DB db = new OleDbBase.DB();
db.Exec("insert into TW (UserName,PutDateTime,Weather,TW) values ('" + UserName.Text + "',#" + PutDateTime.Value + "#,'" + Weather.Text + "'," + TW.Text + ")");
BuildDGV();
}