private void button2_Click(object sender, EventArgs e)
{
int num = Convert.ToInt32(txbNum2.Text);
int rep = Convert.ToInt32(txbRep2.Text);
this.button2.Text = "Working";
this.button2.Enabled = false;
ThreadStart start2 = () =>
{
OilInfoAccess oc = new OilInfoAccess();
var oil = new OilInfoEntity()
{
crudeIndex = DateTime.Now.ToString("yyyyMMddHHmmssfff"),
crudeName = DateTime.Now.ToString("yyyyMMddHHmmssfff")
};
oil.ID = oc.Insert(oil);
for (int i = 0; i < num; i++)
{
var item = new OilDataEntity()
{
calData = RIPP.Lib.Security.SecurityTool.MyEncrypt(i.ToString()),
labData = i.ToString(),
oilInfoID = oil.ID,
oilTableColID = i,
oilTableRowID = i
};
oil.OilDatas.Add(item);
}
OilBll.saveTables(oil);
this.richTextBox2.AppendText(string.Format("已经插入一条原油数据到数据库 {0}\n", DateTime.Now.ToString()));
double[] r = new double[rep];
for (int k = 0; k < rep; k++)
{
DateTime dt = DateTime.Now;
var ooo = OilBll.GetOilById(oil.ID);
foreach (var d in ooo.OilDatas)
{
var ssss = RIPP.Lib.Security.SecurityTool.MyDecrypt(d.calData);
}
r[k] = (DateTime.Now - dt).TotalMilliseconds;
}
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);
}
/// <summary>
/// 打开选中的原油A
/// </summary>
public override void openOil()
{
int oilInfoId = this.gridList.CurrentRow != null?int.Parse(this.gridList.CurrentRow.Cells["ID"].Value.ToString()) : 0;
OilInfoEntity oil = OilBll.GetOilById(oilInfoId);
if (oil == null)
{
return;
}
if (isOilOpening)
{
return;
}
isOilOpening = true;
try
{
FrmMain frmMain = this.MdiParent as FrmMain;
DatabaseA.FrmOilDataA child = (DatabaseA.FrmOilDataA)frmMain.GetChildFrm(oil.crudeIndex + "A");
if (child == null)
{
DatabaseA.FrmOilDataA form = new DatabaseA.FrmOilDataA(oil);
form.MdiParent = frmMain;
form.Show();
Application.DoEvents();
}
else
{
child.Activate();
}
}
finally
{
isOilOpening = false;
}
}
/// <summary>
/// 生成C库
/// </summary>
public override void newC()
{
string strID = this.gridList.CurrentRow.Cells["ID"].Value.ToString();
string crudeIndex = this.gridList.CurrentRow.Cells["原油编号"].Value.ToString();
int ID = 0;
if (int.TryParse(strID, out ID))
{
OilDataSearchAccess dataSearchAccess = new OilDataSearchAccess();
List <OilDataSearchEntity> dataList = dataSearchAccess.Get("oilInfoID =" + ID).ToList();
if (dataList.Count > 0)
{
DialogResult r = MessageBox.Show("原油" + crudeIndex + "的查询库数据已经存在是否替换？", "提示信息", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (r == DialogResult.Yes)
{
dataSearchAccess.deleteData("Delete from OilDataSearch where oilInfoID =" + ID);
OilInfoBEntity oilB = OilBll.GetOilByCrudeIndex(crudeIndex);
OilInfoEntity oilA = OilBll.GetOilById(crudeIndex);
if (oilA == null)
{
OilBll.SaveC(oilB);
}
else
{
OilBll.SaveC(oilA, oilB);
}
MessageBox.Show("原油" + crudeIndex + "生成查询库成功！", "提示信息", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
FrmMain frmMain = this.MdiParent as FrmMain;
DatabaseC.FrmOilDataC child = (DatabaseC.FrmOilDataC)frmMain.GetChildFrm(crudeIndex + "C");
if (child != null)
{
MessageBox.Show("原油" + crudeIndex + "的数据窗体需关闭重新打开才有效！", "提示信息", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
}
}
}
else
{
DialogResult r = MessageBox.Show("是否保存数据到快速查询库！", "提示信息", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (r == DialogResult.Yes)
{
dataSearchAccess.deleteData("Delete from OilDataSearch where oilInfoID =" + ID);
OilInfoBEntity oilB = OilBll.GetOilByCrudeIndex(crudeIndex);
OilInfoEntity oilA = OilBll.GetOilById(crudeIndex);
if (oilA == null)
{
OilBll.SaveC(oilB);
}
else
{
OilBll.SaveC(oilA, oilB);
}
MessageBox.Show("原油" + crudeIndex + "生成查询库成功！", "提示信息", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
FrmMain frmMain = this.MdiParent as FrmMain;
DatabaseC.FrmOilDataC child = (DatabaseC.FrmOilDataC)frmMain.GetChildFrm(crudeIndex + "C");
if (child != null)
{
MessageBox.Show("原油" + crudeIndex + "的数据窗体需关闭重新打开才有效！", "提示信息", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
}
}
}
}
else
{
MessageBox.Show("应用库无此条原油！", "警告信息", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
/// <summary>
/// 初始化表，给表头、行头和单元格赋值
/// </summary>
public virtual void InitTable(string oilId, EnumTableType tableType, string dropDownTypeCode = null)
{
var oil = OilBll.GetOilById(oilId);
InitTable(oil, tableType, dropDownTypeCode);
}
/// <summary>
/// 初始化表，给表头、行头和单元格赋值
/// </summary>
public void InitTable(string oilId)
{
var oil = OilBll.GetOilById(oilId);
InitTable(oil);
}
void Test_Load(object sender, EventArgs e)
{
OilInfoEntity oil = OilBll.GetOilById("test原油1");
var dd = oil.OilDatas;
}
/// <summary>
/// 初始化表，给表头、行头和单元格赋值
/// </summary>
public void InitTable(string oilId, GridOilViewA gdvWide)
{
var oil = OilBll.GetOilById(oilId);
InitTable(oil, gdvWide);
}
