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