/// <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 override void openOil() { int oilInfoID = this.gridList.CurrentRow != null?int.Parse(this.gridList.CurrentRow.Cells["ID"].Value.ToString()) : -1; OilInfoBEntity oil = OilBll.GetOilBByID(oilInfoID); if (oil == null) { return; } if (isOilOpening) { return; } isOilOpening = true; try { FrmMain frmMain = this.MdiParent as FrmMain; DatabaseB.FrmOilDataB child = (DatabaseB.FrmOilDataB)frmMain.GetChildFrm(oil.crudeIndex + "B"); if (child == null) { FrmOilDataB form = new FrmOilDataB(oil); form.MdiParent = frmMain; form.Show(); } else { child.Activate(); } } finally { isOilOpening = false; } }
/// <summary> /// 删除选中的原油 /// </summary> public override void delete() { if (this.gridList.CurrentRow != null) { if (MessageBox.Show("是否要删除!", "信息提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information) == DialogResult.OK) { try { int oilInfoId = int.Parse(this.gridList.CurrentRow.Cells["ID"].Value.ToString()); string frmName = this.gridList.CurrentRow.Cells["原油编号"].Value.ToString() + "A"; OilBll.delete(oilInfoId, LibraryType.LibraryA); //删除数据 this._sqlWhere = "1=1"; dgvHeader.SetMangerDataBaseAColHeader(this.gridList, false); InitGridListBind(false); FrmMain frmMain = (FrmMain)this.MdiParent; if (frmMain == null) { return; } Form from = frmMain.GetChildFrm(frmName); //关闭被删除数据的窗口 if (from != null) { from.Close(); } } catch (Exception ex) { Log.Error("数据管理" + ex); } } } }
/// <summary> /// 关闭窗口时保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void FrmOilDataB_FormClosing(object sender, FormClosingEventArgs e) { if (this.isChanged == true) { DialogResult r = MessageBox.Show("是否保存" + this._oilB.crudeIndex + "数据到应用库?", "提示信息", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (r == DialogResult.Yes) { this.SaveB(); FrmMain frmMain = (FrmMain)this.MdiParent; DatabaseB.FrmOpenB frmOpenB = (DatabaseB.FrmOpenB)frmMain.GetChildFrm("frmOpenB"); if (frmOpenB != null) //如果打开原油库B的窗口存在,则更新 { frmOpenB.refreshGridList(false); } this.isChanged = false; } } }
/// <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> /// 鼠标双击-打开一条原油 /// </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> /// 关闭窗体的保存提示 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void FrmOilDataC_FormClosing(object sender, FormClosingEventArgs e) { if (IsChange()) { DialogResult r = MessageBox.Show("是否保存数据!", "提示信息", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Information); if (r == DialogResult.Yes) { this.SaveC(); if (this._isValueChange) { var oilInfoB = new OilInfoBAccess().Get(this._oilInfoID); oilInfoB.updataDate = DateTime.Now.ToString(LongDateFormat); OilBll.updateOilInfoB(oilInfoB); FrmMain frmMain = (FrmMain)this.MdiParent; FrmOpenC frmOpenC = (FrmOpenC)frmMain.GetChildFrm("frmOpenC"); if (frmOpenC != null) //如果打开原油库A的窗口存在,则更新 { frmOpenC.refreshGridList(); } this._isValueChange = false; } this._isChange = false; } else if (r == DialogResult.No) { this._isChange = false; } else if (r == DialogResult.Cancel) { e.Cancel = true; } } }
/// <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); } }