/// <summary>
/// 删除一条记录
/// </summary>
public override void delete()
{
if (this.gridList.CurrentRow != null)
{
if (MessageBox.Show("是否要删除!", "信息提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information) == DialogResult.OK)
{
try
{
int oilInfoID = this.gridList.CurrentRow != null?int.Parse(this.gridList.CurrentRow.Cells["ID"].Value.ToString()) : -1;
string crudeIndex = this.gridList.CurrentRow.Cells["原油编号"].Value.ToString();
string frmName = this.gridList.CurrentRow.Cells["原油编号"].Value.ToString() + "B";
OilBll.delete(oilInfoID, LibraryType.LibraryB); //删除数据
this._sqlWhere = "1=1";
dgvHeader.SetMangerDataBaseBColHeader(this.gridList, Visible);
InitGridListBind(false);
FrmMain frmMain = (FrmMain)this.MdiParent;
if (frmMain == null)
{
return;
}
Form from = frmMain.GetChildFrm(frmName); //关闭被删除数据的窗口
if (from != null)
{
from.Close();
}
DatabaseC.FrmOpenC openC = (DatabaseC.FrmOpenC)frmMain.GetChildFrm("FrmOpenC");
if (openC != null)
{
openC.refreshGridList();
}
DatabaseC.FrmOilDataC child = (DatabaseC.FrmOilDataC)frmMain.GetChildFrm(crudeIndex + "C");
if (child != null)
{
child.Close();
}
}
catch (Exception ex)
{
Log.Error("数据管理" + ex);
}
}
}
}
/// <summary>
/// 鼠标双击-打开一条原油
/// </summary>
public void openOil()
{
try
{
//this.IsBusy = true;
int oilInfoId = int.Parse(this.gridList.CurrentRow.Cells["ID"].Value.ToString());
string crudeIndex = this.gridList.CurrentRow.Cells["原油编号"].Value.ToString();
FrmMain frmMain = this.MdiParent as FrmMain;
DatabaseC.FrmOilDataC child = (DatabaseC.FrmOilDataC)frmMain.GetChildFrm(crudeIndex + "C");
if (child == null)
{
DatabaseC.FrmOilDataC form = new DatabaseC.FrmOilDataC(oilInfoId);
form.MdiParent = frmMain;
form.Text = "查询库原油数据-" + crudeIndex;
form.Name = crudeIndex + "C";
form.Show();
//form.BringToFront();
form.Activate();
}
else
{
child.Activate();
}
}
catch (Exception ex)
{
//MessageBox.Show(oilInfoId.ToString());
Log.Error(ex.ToString());
}
finally
{
//this.IsBusy = 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);
}
}
