private void button2_Click(object sender, EventArgs e) { int num = Convert.ToInt32(txbNum2.Text); int rep = Convert.ToInt32(txtRep2.Text); var db = new model.OilDataManageEntities(); this.button2.Text = "Working"; this.button2.Enabled = false; ThreadStart start2 = () => { double[] r = new double[rep]; for (int k = 0; k < rep; k++) { DateTime dt = DateTime.Now; var aa = db.OilData.Take(num).ToArray(); r[k] = (DateTime.Now - dt).TotalMilliseconds; } db.Dispose(); for (int k = 0; k < rep; k++) { this.richTextBox2.AppendText(string.Format("读取 {0} 条, 第 {2} 次花费 {1} ms \n", num, r[k], k + 1)); } this.button2.Text = "Run"; this.button2.Enabled = true; this.richTextBox2.AppendText("\n"); }; this.Invoke(start2); }
private void button3_Click(object sender, EventArgs e) { int num = Convert.ToInt32(txtNum3.Text); int rep = Convert.ToInt32(txtRep3.Text); //先搞一条原油数据 this.button3.Text = "Working"; this.button3.Enabled = false; ThreadStart start2 = () => { var db = new model.OilDataManageEntities(); double[] r = new double[rep]; for (int k = 0; k < rep; k++) { var oil = new model.OilInfo() { crudeIndex = DateTime.Now.ToString("yyyyMMddHHmmssfff"), crudeName = DateTime.Now.ToString("yyyyMMddHHmmssfff"), }; db.OilInfo.AddObject(oil); db.SaveChanges(); DateTime dt = DateTime.Now; for (int i = 0; i < num; i++) { var item = new model.OilData() { calData = i.ToString(), labData = i.ToString(), oilInfoID = oil.ID, oilTableColID = i, oilTableRowID = i }; db.OilData.AddObject(item); } db.SaveChanges(); r[k] = (DateTime.Now - dt).TotalMilliseconds; } for (int k = 0; k < rep; k++) { this.richTextBox3.AppendText(string.Format("插入 {0} 条, 第 {2} 次花费 {1} ms \n", num, r[k], k + 1)); } this.button3.Text = "Run"; this.button3.Enabled = true; this.richTextBox3.AppendText("\n"); db.Dispose(); }; this.Invoke(start2); }