//修改变更申请 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(); } }