//修改变更申请
private void barButtonItem6_ItemClick(object sender, ItemClickEventArgs e)
{
var view = dgvCtny.MainView;
view.PostEditor();
DataView dv = (DataView)view.DataSource;
List <string> listID = C2M.SelectedParamEntityIds(dv, "ID");
if (listID.Count > 1)
{
MessageBox.Show(String.Format("每次只能操作一条记录，您选择了{0}条！", listID.Count), "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (listID.Count == 0)
{
MessageBox.Show("请选择要操作的数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (listID.Count == 1)
{
string ID = (string)listID[0];
ChangeAddXtraForm caxf = new ChangeAddXtraForm(ID);
caxf.Show();
}
}
/// <summary>
/// 选择选中数据
/// </summary>
/// <returns></returns>
private DataView GetCheckData()
{
var gridControl = (GridControl)((GroupBox)this.xtraTabControl1.SelectedTabPage.Controls[0]).Controls[0];
var view = gridControl.MainView;
view.PostEditor();
DataView vins = C2M.SelectedParamEntityDataView((DataView)view.DataSource, "check");
DataTable TempDt = new DataTable();
if (vins != null)
{
switch (radioGroup1.SelectedIndex)
{
case 0:
TempDt = compareUtils.C2E(compareUtils.dictCTNY, vins.Table, MitsUtils.CTNY);
break;
case 1:
TempDt = compareUtils.C2E(compareUtils.dictFCDSHHDL, vins.Table, MitsUtils.FCDSHHDL);
break;
}
}
vins = TempDt.DefaultView;
return(vins);
}
//选择选中数据
private List <string> GetCheckData()
{
var view = dgvCtny.MainView;
view.PostEditor();
DataView dv = (DataView)view.DataSource;
return(C2M.SelectedParamEntityIds(dv, "ID"));
}
/// <summary>
/// 选择选中数据
/// </summary>
/// <returns></returns>
private DataView GetCheckData()
{
var view = gcCljbxx.MainView;
view.PostEditor();
DataView dv = (DataView)view.DataSource;
return(C2M.SelectedParamEntityDataView(dv, "check"));
}
/// <summary>
/// 选择选中数据
/// </summary>
/// <returns></returns>
private DataView GetCheckData()
{
var gridControl = (GridControl)this.xtraTabControl1.SelectedTabPage.Controls[0];
var view = gridControl.MainView;
view.PostEditor();
DataView dv = (DataView)view.DataSource;
return(C2M.SelectedParamEntityDataView(dv, "check"));
}
/// <summary>
/// 选择选中数据
/// </summary>
/// <returns></returns>
private List <string> GetCheckString()
{
var gridControl = (GridControl)((GroupBox)this.xtraTabControl1.SelectedTabPage.Controls[0]).Controls[0];
var view = gridControl.MainView;
view.PostEditor();
DataView dv = (DataView)view.DataSource;
var selectedParamEntityIds = C2M.SelectedParamEntityIds(dv, "VIN车架号");
if (selectedParamEntityIds.Count > 0)
{
return(selectedParamEntityIds);
}
return(null);
}
/// <summary>
/// 选择选中数据
/// </summary>
/// <returns></returns>
private DataView GetCheckData()
{
if (!this.xtraTabControl1.SelectedTabPage.Text.Equals("比对数据"))
{
var gridControl = (GridControl)this.xtraTabControl1.SelectedTabPage.Controls[0];
if (gridControl.Name == "gcTable2")
{
var view = gridControl.MainView;
view.PostEditor();
DataView dv = (DataView)view.DataSource;
return(C2M.SelectedParamEntityDataView(dv, "check"));
}
else
{
return(null);
}
}
else
{
DataView dv = new DataView();
return(dv);
}
}
//数据处理
private void barButtonItem6_ItemClick(object sender, ItemClickEventArgs e)
{
try
{
SplashScreenManager.ShowForm(typeof(DevWaitForm));
if (this.xtraTabControl1.SelectedTabPage.Text.Equals("比对数据"))
{
MessageBox.Show("请选择要操作的数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
//获取选中的处理数据
var gridControl = (GridControl)this.xtraTabControl1.SelectedTabPage.Controls[0];
var view = gridControl.MainView;
view.PostEditor();
DataView dv = C2M.SelectedParamEntityDataView((DataView)view.DataSource, "check");
if (dv == null)
{
MessageBox.Show("请选择要操作的数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
else if (dv != null && dv.Table.Rows.Count == 0)
{
MessageBox.Show("请选择要操作的数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (this.xtraTabControl1.SelectedTabPage.Text == "补传数据")
{
//将选中的处理数据更改状态
foreach (DataRow dr in dv.Table.Rows)
{
OracleHelper.ExecuteNonQuery(OracleHelper.conn, string.Format("UPDATE FC_CLJBXX SET STATUS = '1' where vin='{0}'", dr["VIN"]), null);
}
//打开补传待上报窗体显示处理后数据
foreach (Form f in Application.OpenForms)
{
if (f.Name == "SearchLocalOTForm")
{
f.Activate();
((SearchLocalOTForm)f).LocalData(dv);
((MainForm)this.MdiParent).Ribbon.SelectedPage = ((SearchLocalOTForm)f).Ribbon.Pages[0];
return;
}
}
SearchLocalOTForm slo = new SearchLocalOTForm()
{
MdiParent = this.MdiParent
};
slo.LocalData(dv);
((MainForm)this.MdiParent).Ribbon.SelectedPage = slo.Ribbon.Pages[0];
slo.Show();
}
if (this.xtraTabControl1.SelectedTabPage.Text == "撤销数据")
{
//将选中的处理数据更改状态
foreach (DataRow dr in dv.Table.Rows)
{
OracleHelper.ExecuteNonQuery(OracleHelper.conn, String.Format("DELETE FROM FC_CLJBXX WHERE VIN = '{0}'", dr["VIN"]), null);
OracleHelper.ExecuteNonQuery(OracleHelper.conn, String.Format("DELETE FROM RLLX_PARAM_ENTITY WHERE VIN ='{0}'", dr["VIN"]), null);
OracleHelper.ExecuteNonQuery(OracleHelper.conn, String.Format("INSERT INTO FC_CLJBXX (VIN,HGSPBM,USER_ID,QCSCQY,JKQCZJXS,CLXH,CLZL,RLLX,ZCZBZL,ZGCS,LTGG,ZJ,CLZZRQ,UPLOADDEADLINE,TYMC,YYC,ZWPS,ZDSJZZL,EDZK,LJ,QDXS,CREATETIME,UPDATETIME,STATUS,JYJGMC,JYBGBH,QTXX,V_ID) SELECT VIN,HGSPBM,USER_ID,QCSCQY,JKQCZJXS,CLXH,CLZL,RLLX,ZCZBZL,ZGCS,LTGG,ZJ,CLZZRQ,UPLOADDEADLINE,TYMC,YYC,ZWPS,ZDSJZZL,EDZK,LJ,QDXS,CREATETIME,UPDATETIME,STATUS,JYJGMC,JYBGBH,QTXX,V_ID FROM FC_CLJBXX_ADC WHERE VIN='{0}'", dr["VIN"]), null);
OracleHelper.ExecuteNonQuery(OracleHelper.conn, string.Format("UPDATE FC_CLJBXX SET STATUS='3',USER_ID='{0}' WHERE VIN='{1}'", Utils.localUserId, dr["VIN"]), null);
OracleHelper.ExecuteNonQuery(OracleHelper.conn, string.Format("INSERT INTO RLLX_PARAM_ENTITY (PARAM_CODE,VIN,PARAM_VALUE,V_ID) SELECT PARAM_CODE,VIN,PARAM_VALUE,V_ID FROM RLLX_PARAM_ENTITY_ADC WHERE VIN='{0}'", dr["VIN"]), null);
}
//打开已上报窗体显示需要撤销的数据
foreach (Form f in Application.OpenForms)
{
if (f.Name == "SearchLocalUploadedForm")
{
f.Activate();
((SearchLocalUploadedForm)f).LocalData(dv);
((MainForm)this.MdiParent).Ribbon.SelectedPage = ((SearchLocalUploadedForm)f).Ribbon.Pages[0];
return;
}
}
SearchLocalUploadedForm sluf = new SearchLocalUploadedForm()
{
MdiParent = this.MdiParent
};
sluf.LocalData(dv);
((MainForm)this.MdiParent).Ribbon.SelectedPage = sluf.Ribbon.Pages[0];
sluf.Show();
}
if (this.xtraTabControl1.SelectedTabPage.Text == "修改数据")
{
//将选中的处理数据更改状态
foreach (DataRow dr in dv.Table.Rows)
{
OracleHelper.ExecuteNonQuery(OracleHelper.conn, string.Format("UPDATE FC_CLJBXX SET STATUS = '2' where vin='{0}'", dr["VIN"]), null);
}
//打开已修改未上报窗体显示处理后数据
foreach (Form f in Application.OpenForms)
{
if (f.Name == "SearchLocalUpdateForm")
{
f.Activate();
((SearchLocalUpdateForm)f).LocalData(dv);
((MainForm)this.MdiParent).Ribbon.SelectedPage = ((SearchLocalUpdateForm)f).Ribbon.Pages[0];
return;
}
}
SearchLocalUpdateForm suf = new SearchLocalUpdateForm()
{
MdiParent = this.MdiParent
};
suf.LocalData(dv);
((MainForm)this.MdiParent).Ribbon.SelectedPage = suf.Ribbon.Pages[0];
suf.Show();
}
}
catch (Exception ex)
{
MessageBox.Show("处理出现错误：" + ex.Message, "异常", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
SplashScreenManager.CloseForm();
}
}
