/// <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>
/// 导入到B库
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void toolStripBtnIn_Click(object sender, EventArgs e)
{
this.gridList.EndEdit();
OilInfoBAccess oilInfoAccess = new OilInfoBAccess();
LibManageBll libManageBll = new LibManageBll();
string alert = "未导入的原油：";
foreach (DataGridViewRow row in this.gridList.Rows)
{
if (bool.Parse(row.Cells["select"].Value.ToString()) == true)
{
int oilInfoId = int.Parse(row.Cells["ID"].Value.ToString());
OilInfoOut oilInfoOut = this._outLib.oilInfoOuts.Where(c => c.ID == oilInfoId).FirstOrDefault();
OilInfoBEntity oilInfoBEntity = new OilInfoBEntity();
libManageBll.toOilInfoEntity(ref oilInfoBEntity, oilInfoOut); //转换为OilInfoEntity
oilInfoBEntity.ID = OilBll.saveInfo(oilInfoBEntity);
if (oilInfoBEntity.ID == -1)
{
try
{
#region "原油冲突"
DialogResult r = MessageBox.Show(oilInfoBEntity.crudeIndex + "原油已存在！是否要更新", "提示信息", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (r == DialogResult.Yes)
{
oilInfoAccess.Delete("crudeIndex='" + oilInfoBEntity.crudeIndex + "'"); //删除原油信息数据
oilInfoBEntity.ID = OilBll.save(oilInfoBEntity); //重新插入原油信息
libManageBll.toOilDatas(ref oilInfoBEntity, oilInfoOut, this._outLib.oilTableRows, this._outLib.oilTableCols);
OilBll.saveTables(oilInfoBEntity);
libManageBll.toCurve(ref oilInfoBEntity, oilInfoOut.curves, _outLib.curveTypes);
OilBll.saveCurves(oilInfoBEntity);
libManageBll.toOilDataSearchs(ref oilInfoBEntity, oilInfoOut);
OilBll.saveSearchTable(oilInfoBEntity.OilDataSearchs);
DatabaseB.FrmOpenB frmOpenB = (DatabaseB.FrmOpenB)GetChildFrm("frmOpenB");
if (frmOpenB != null) //如果打开原油库B的窗口存在，则更新
{
frmOpenB.refreshGridList(false);
}
DatabaseC.FrmOpenC frmOpenC = (DatabaseC.FrmOpenC)GetChildFrm("frmOpenC");
if (frmOpenC != null) //如果打开原油库C的窗口存在，则更新
{
frmOpenC.refreshGridList();
}
}
else
{
alert += oilInfoBEntity.crudeIndex + " ";
}
#endregion
}
catch (Exception ex)
{
Log.Error("原油导入错误！" + ex.ToString());
return;
}
MessageBox.Show(oilInfoBEntity.crudeName + "原油导入成功！");
}
else
{
#region "原油无冲突"
try
{
libManageBll.toOilDatas(ref oilInfoBEntity, oilInfoOut, this._outLib.oilTableRows, this._outLib.oilTableCols);
OilBll.saveTables(oilInfoBEntity);
libManageBll.toCurve(ref oilInfoBEntity, oilInfoOut.curves, _outLib.curveTypes);
OilBll.saveCurves(oilInfoBEntity);
libManageBll.toOilDataSearchs(ref oilInfoBEntity, oilInfoOut);
OilBll.saveSearchTable(oilInfoBEntity.OilDataSearchs);
DatabaseB.FrmOpenB frmOpenB = (DatabaseB.FrmOpenB)GetChildFrm("frmOpenB");
if (frmOpenB != null) //如果打开原油库A的窗口存在，则更新
{
frmOpenB.refreshGridList(false);
}
}
catch (Exception ex)
{
Log.Error("原油导入错误！" + ex.ToString());
return;
}
MessageBox.Show(oilInfoBEntity.crudeName + "原油导入成功！");
#endregion
}
}
}
}