/// <summary>
/// 保存到数据库
/// </summary>
public void Save()
{
var data = GetAllData();
var ass = new OilDataAccess();
OilBll.updateTables2(data);
}
private void button1_Click(object sender, EventArgs e)
{
int num = Convert.ToInt32(txbNum1.Text);
int rep = Convert.ToInt32(txbRep1.Text);
this.button1.Text = "Working";
this.button1.Enabled = false;
ThreadStart start2 = () =>
{
double[] r = new double[rep];
for (int k = 0; k < rep; k++)
{
var oo = new OilDataAccess();
DateTime dt = DateTime.Now;
var a = oo.Get("1=1", num, " id desc");
r[k] = (DateTime.Now - dt).TotalMilliseconds;
}
for (int k = 0; k < rep; k++)
{
this.richTextBox1.AppendText(string.Format("读取 {0} 条, 第 {2} 次花费 {1} ms \n", num, r[k], k + 1));
}
this.button1.Text = "Run";
this.button1.Enabled = true;
this.richTextBox1.AppendText("\n");
};
this.Invoke(start2);
}
private void button1_Click(object sender, EventArgs e)
{
OilDataAccess access = new OilDataAccess();
int num = Convert.ToInt32(txbNum1.Text);
int rep = Convert.ToInt32(txbRep1.Text);
//先搞一条原油数据
OilInfoAccess oc = new OilInfoAccess();
var oil = new OilInfoEntity()
{
crudeIndex = DateTime.Now.ToString("yyyyMMddHHmmss"),
crudeName = DateTime.Now.ToString("yyyyMMddHHmmss")
};
oil.ID = oc.Insert(oil);
this.button1.Text = "Working";
this.button1.Enabled = false;
ThreadStart start2 = () =>
{
double[] r = new double[rep];
for (int k = 0; k < rep; k++)
{
DateTime dt = DateTime.Now;
for (int i = 0; i < num; i++)
{
var item = new OilDataEntity()
{
calData = i.ToString(),
labData = i.ToString(),
oilInfoID = oil.ID,
oilTableColID = i,
oilTableRowID = i
};
access.Insert(item);
}
r[k] = (DateTime.Now - dt).TotalMilliseconds;
}
for (int k = 0; k < rep; k++)
{
this.richTextBox1.AppendText(string.Format("插入 {0} 条, 第 {2} 次花费 {1} ms \n", num, r[k], k + 1));
}
this.button1.Text = "Run";
this.button1.Enabled = true;
this.richTextBox1.AppendText("\n");
};
this.Invoke(start2);
}
