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(); }