using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using CoreFS.CA06; using System.Collections; namespace Core.LZMes.Client.UIK { public partial class UIK030020 : FrmBase { public UIK030020() { InitializeComponent(); } public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "Query": this.DoQuery(); break; case "Insert": this.DoInsert(); break; case "Update": this.DoUpdate(); break; case "SQQueRen": this.DoQueRen(); break; case "SQQuXiao": this.DoQuXiao(); break; } } private void DoQuery() { if (this.ultraCalendarENDTIME.Enabled == false && this.ultraCalendarSTRATTIME.Enabled == false) { this.ultraCalendarENDTIME.Text = ""; this.ultraCalendarSTRATTIME.Text = ""; } try { string mc_id = this.ultraTextMC_ID.Text.ToString(); string starttiem = this.ultraCalendarSTRATTIME.Text.ToString(); string endtime = this.ultraCalendarENDTIME.Text.ToString(); bool flag = false; CoreClientParam ccp = new CoreClientParam(); DataTable dt = new DataTable(); if (mc_id == "" && starttiem == "" && endtime == "" && this.ultraCheckAll.Checked == false) { MessageBox.Show("请选择查询条件！"); } else { if (this.ultraCheckAll.Checked) { this.ultraCheckAll.Checked = false; ccp.ServerName = "UIK.UIK03.UIK030020"; ccp.MethodName = "DoQuery"; ccp.ServerParams = new object[] { mc_id, starttiem, endtime, flag }; ccp.SourceDataTable = dt; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); this.ultraGrid1.DataSource = dt; if (dt.Rows.Count <= 0) { MessageBox.Show("暂无记录！"); } this.ultraCalendarENDTIME.Enabled = false; this.ultraCalendarSTRATTIME.Enabled = false; return; } else { flag = true; if (this.ultraTextMC_ID.Text != "" || this.ultraCheckEditor1.Checked == true) { if (this.ultraTextMC_ID.Text == "") { this.ultraTextMC_ID.Clear(); this.ultraCheckEditor1.Checked = false; this.ultraCheckAll.Checked = false; ccp.ServerName = "UIK.UIK03.UIK030020"; ccp.MethodName = "DoQuery"; ccp.ServerParams = new object[] { mc_id, starttiem, endtime, flag }; ccp.SourceDataTable = dt; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); this.ultraGrid1.DataSource = dt; if (dt.Rows.Count <= 0) { MessageBox.Show("该时间内没有入库信息！"); } this.ultraCalendarENDTIME.Enabled = false; this.ultraCalendarSTRATTIME.Enabled = false; return; } if (this.ultraCheckEditor1.Checked == false) { this.ultraTextMC_ID.Clear(); this.ultraCheckAll.Checked = false; ccp.ServerName = "UIK.UIK03.UIK030020"; ccp.MethodName = "DoQuery"; ccp.ServerParams = new object[] { mc_id, starttiem, endtime, flag }; ccp.SourceDataTable = dt; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); this.ultraGrid1.DataSource = dt; if (dt.Rows.Count <= 0) { MessageBox.Show("该设备编号不存在！"); } this.ultraCalendarENDTIME.Enabled = false; this.ultraCalendarSTRATTIME.Enabled = false; return; } if (this.ultraTextMC_ID.Text != "" && this.ultraCheckEditor1.Checked == true) { this.ultraTextMC_ID.Clear(); this.ultraCheckEditor1.Checked = false; this.ultraCheckAll.Checked = false; ccp.ServerName = "UIK.UIK03.UIK030020"; ccp.MethodName = "DoQuery"; ccp.ServerParams = new object[] { mc_id, starttiem, endtime, flag }; ccp.SourceDataTable = dt; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); this.ultraGrid1.DataSource = dt; if (dt.Rows.Count <= 0) { MessageBox.Show("记录不存在，请查证后查询！"); } this.ultraCalendarENDTIME.Enabled = false; this.ultraCalendarSTRATTIME.Enabled = false; return; } } } } } catch (Exception Ex) { MessageBox.Show(Ex.ToString()); } } private void UIK030020_Load(object sender, EventArgs e) { this.ultraCalendarENDTIME.Enabled = false; this.ultraCalendarSTRATTIME.Enabled = false; this.ultraCalendarMC_IN_DTIME.Text = ""; this.ultraCalendarMC_USE_TIME.Text = ""; this.ultraCalendarREG_IN_DTIME.Text = ""; } private void ultraCheckEditor1_CheckedChanged(object sender, EventArgs e) { if (this.ultraCheckEditor1.Checked) { this.ultraCalendarENDTIME.Enabled = true; this.ultraCalendarSTRATTIME.Enabled = true; } if (!this.ultraCheckEditor1.Checked) { this.ultraCalendarENDTIME.Enabled = false; this.ultraCalendarSTRATTIME.Enabled = false; this.ultraCalendarSTRATTIME.Text = ""; this.ultraCalendarENDTIME.Text = ""; } } private void ultraCheckAll_CheckedChanged(object sender, EventArgs e) { try { if (this.ultraCheckAll.Checked) { this.ultraTextMC_ID.Enabled = false; this.ultraCalendarSTRATTIME.Enabled = false; this.ultraCalendarENDTIME.Enabled = false; } if (!this.ultraCheckAll.Checked) { this.ultraTextMC_ID.Enabled = true; this.ultraCalendarSTRATTIME.Enabled = true; this.ultraCalendarENDTIME.Enabled = true; } } catch (Exception Ex) { MessageBox.Show(Ex.ToString()); } } private void ultraGrid1_CellChange(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e) { if (e.Cell.Column.Key == "SELECT_ITEM") { if (e.Cell.Text == "True") { string mcid, IREG_IN_DTIME; ultraTextMCID2.Text = e.Cell.Row.Cells["MC_ID"].Text; this.ultraTextMCID2.Text = e.Cell.Row.Cells["MC_ID"].Text; mcid = e.Cell.Row.Cells["MC_ID"].Text; this.ultraTextMCID2.Enabled = false; IREG_IN_DTIME = e.Cell.Row.Cells["REG_IN_DTIME"].Text; DataTable dt = new DataTable(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIK.UIK03.UIK030020"; ccp.MethodName = "DoSelect"; ccp.ServerParams = new object[] { IREG_IN_DTIME }; ccp.SourceDataTable = dt; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); foreach (DataRow dr in dt.Rows) { this.ultraTextMC_NAME.Text = dr["MC_NAME"].ToString(); this.ultraTextMC_MODEL.Text = dr["MC_MODEL"].ToString(); this.ultraTextMC_SPEC.Text = dr["MC_SPEC"].ToString(); this.ultraTextMC_FACTORY.Text = dr["MC_FACTORY"].ToString(); this.ultraCalendarMC_IN_DTIME.Text = dr["MC_IN_DTIME"].ToString(); this.ultraTextMC_PRICE.Text = dr["MC_PRICE"].ToString(); this.ultraTextMC_CARE_SECTOR.Text = dr["MC_CARE_SECTOR"].ToString(); this.ultraTextMC_NOM_CAP.Text = dr["MC_NOM_CAP"].ToString(); this.ultraTextMC_UNIT.Text = dr["MC_UNIT"].ToString(); this.ultraTextMC_TAI.Text = dr["MC_TAI"].ToString(); this.ultraTextMC_ACT.Text = dr["MC_ACT"].ToString(); this.ultraTextMC_MFACTUR_UNITS.Text = dr["MC_MFACTUR_UNITS"].ToString(); this.ultraTextMC_USE_YEAR.Text = dr["MC_USE_YEAR"].ToString(); this.ultraCalendarMC_USE_TIME.Text = dr["MC_USE_TIME"].ToString(); this.ultraTextMC_INSTAL_LOCAL.Text = dr["MC_INSTAL_LOCAL"].ToString(); this.ultraComboMC_REG_OUT_STAT.Text = dr["MC_REG_OUT_STAT"].ToString(); this.ultraComboMC_STAT.Text = dr["MC_STAT"].ToString(); this.ultraCalendarREG_IN_DTIME.Text = dr["REG_OUT_DTIME"].ToString(); this.ultraTextREG_IN_ID.Text = dr["REG_OUT_ID"].ToString(); this.ultraTextMAIN_MC_NAME.Text = dr["MAIN_MC_NAME"].ToString(); } } else { this.ultraTextMCID2.Enabled = true; this.ultraTextMCID2.Clear(); this.ultraTextMC_NAME.Clear(); this.ultraTextMC_MODEL.Clear(); this.ultraTextMC_SPEC.Clear(); this.ultraTextMC_FACTORY.Clear(); this.ultraCalendarMC_IN_DTIME.Text = ""; this.ultraTextMC_PRICE.Clear(); this.ultraTextMC_CARE_SECTOR.Clear(); this.ultraTextMC_NOM_CAP.Clear(); this.ultraTextMC_UNIT.Clear(); this.ultraTextMC_TAI.Clear(); this.ultraTextMC_ACT.Clear(); this.ultraTextMC_MFACTUR_UNITS.Clear(); this.ultraTextMC_USE_YEAR.Clear(); this.ultraCalendarMC_USE_TIME.Text = ""; this.ultraTextMC_INSTAL_LOCAL.Clear(); this.ultraComboMC_REG_OUT_STAT.Clear(); this.ultraComboMC_STAT.Clear(); this.ultraCalendarREG_IN_DTIME.Text = ""; this.ultraTextREG_IN_ID.Clear(); this.ultraTextMAIN_MC_NAME.Clear(); } } } private void DoUpdate() { if (MessageBox.Show("您确认要修改？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { try { Infragistics.Win.UltraWinGrid.UltraGridRow ugr = this.ultraGrid1.ActiveRow; if (ugr.Cells["SELECT_ITEM"].Text.ToString() == "True") { string mcid, IREG_IN_DTIME, IMC_NAME, IMC_MODEL, IMC_SPEC, IMC_FACTORY, IMC_IN_DTIME, IMC_PRICE, IMC_CARE_SECTOR, IMC_NOM_CAP, IMC_UNIT, IMC_TAI, IMC_ACT, IMC_MFACTUR_UNITS, IMC_USE_YEAR, IMC_USE_TIME, IMC_INSTAL_LOCAL, IMC_REG_OUT_STAT, IMC_STAT, IREG_OUT_DTIME, IREG_OUT_ID, IMAIN_MC_NAME; mcid = ugr.Cells["MC_ID"].Value.ToString(); this.ultraTextMCID2.Enabled = false; IREG_IN_DTIME = ugr.Cells["REG_IN_DTIME"].Value.ToString(); IMC_NAME = this.ultraTextMC_NAME.Text; IMC_MODEL = this.ultraTextMC_MODEL.Text; IMC_SPEC = this.ultraTextMC_SPEC.Text; IMC_FACTORY = this.ultraTextMC_FACTORY.Text; IMC_IN_DTIME = this.ultraCalendarMC_IN_DTIME.Text; IMC_PRICE = this.ultraTextMC_PRICE.Text; IMC_CARE_SECTOR = this.ultraTextMC_CARE_SECTOR.Text; IMC_NOM_CAP = this.ultraTextMC_NOM_CAP.Text; IMC_UNIT = this.ultraTextMC_UNIT.Text; IMC_TAI = this.ultraTextMC_TAI.Text; IMC_ACT = this.ultraTextMC_ACT.Text; IMC_MFACTUR_UNITS = this.ultraTextMC_MFACTUR_UNITS.Text; IMC_USE_YEAR = this.ultraTextMC_USE_YEAR.Text; IMC_USE_TIME = this.ultraCalendarMC_USE_TIME.Text; IMC_INSTAL_LOCAL = this.ultraTextMC_INSTAL_LOCAL.Text; IMC_REG_OUT_STAT = this.ultraComboMC_REG_OUT_STAT.Text; IMC_STAT = this.ultraComboMC_STAT.Text; IREG_OUT_DTIME = this.ultraCalendarREG_IN_DTIME.Text; IREG_OUT_ID = this.ultraTextREG_IN_ID.Text; IMAIN_MC_NAME = this.ultraTextMAIN_MC_NAME.Text; CoreClientParam ccp2 = new CoreClientParam(); ccp2.ServerName = "UIK.UIK03.UIK030020"; ccp2.MethodName = "DoUpdate"; ccp2.ServerParams = new object[] { IMC_NAME, IMC_MODEL, IMC_SPEC, IMC_FACTORY, IMC_IN_DTIME, IMC_PRICE, IMC_CARE_SECTOR, IMC_NOM_CAP, IMC_UNIT, IMC_TAI, IMC_ACT, IMC_MFACTUR_UNITS, IMC_USE_YEAR, IMC_USE_TIME, IMC_INSTAL_LOCAL, IMC_REG_OUT_STAT, IMC_STAT, IREG_OUT_DTIME, IREG_OUT_ID,IMAIN_MC_NAME, IREG_IN_DTIME }; ccp2 = this.ExecuteNonQuery(ccp2, CoreInvokeType.Internal); if (0 != ccp2.ReturnCode) { MessageBox.Show("修改失败！"); } else { MessageBox.Show("修改成功！"); this.ultraTextMCID2.Enabled = true; this.ultraTextMCID2.Clear(); this.ultraTextMC_NAME.Clear(); this.ultraTextMC_MODEL.Clear(); this.ultraTextMC_SPEC.Clear(); this.ultraTextMC_FACTORY.Clear(); this.ultraCalendarMC_IN_DTIME.Text = ""; this.ultraTextMC_PRICE.Clear(); this.ultraTextMC_CARE_SECTOR.Clear(); this.ultraTextMC_NOM_CAP.Clear(); this.ultraTextMC_UNIT.Clear(); this.ultraTextMC_TAI.Clear(); this.ultraTextMC_ACT.Clear(); this.ultraTextMC_MFACTUR_UNITS.Clear(); this.ultraTextMC_USE_YEAR.Clear(); this.ultraCalendarMC_USE_TIME.Text = ""; this.ultraTextMC_INSTAL_LOCAL.Clear(); this.ultraComboMC_REG_OUT_STAT.Clear(); this.ultraComboMC_STAT.Clear(); this.ultraCalendarREG_IN_DTIME.Text = ""; this.ultraTextREG_IN_ID.Clear(); this.ultraTextMAIN_MC_NAME.Clear(); } } else { MessageBox.Show("请选择修改行！"); } } catch (Exception Ex) { MessageBox.Show(Ex.ToString()); } } } private void DoInsert() { if (MessageBox.Show("您确认要添加信息吗？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { string mcid, IMC_NAME, IMC_MODEL, IMC_SPEC, IMC_FACTORY, IMC_IN_DTIME, IMC_PRICE, IMC_CARE_SECTOR, IMC_NOM_CAP, IMC_UNIT, IMC_TAI, IMC_ACT, IMC_MFACTUR_UNITS, IMC_USE_YEAR, IMC_USE_TIME, IMC_INSTAL_LOCAL, IMC_REG_OUT_STAT, IMC_STAT, IREG_OUT_DTIME, IREG_OUT_ID, IMAIN_MC_NAME, IREG_IN_DTIME; mcid = this.ultraTextMCID2.Text; IMC_NAME = this.ultraTextMC_NAME.Text; IMC_MODEL = this.ultraTextMC_MODEL.Text; IMC_SPEC = this.ultraTextMC_SPEC.Text; IMC_FACTORY = this.ultraTextMC_FACTORY.Text; IMC_IN_DTIME = this.ultraCalendarMC_IN_DTIME.Text; IMC_PRICE = this.ultraTextMC_PRICE.Text; IMC_CARE_SECTOR = this.ultraTextMC_CARE_SECTOR.Text; IMC_NOM_CAP = this.ultraTextMC_NOM_CAP.Text; IMC_UNIT = this.ultraTextMC_UNIT.Text; IMC_TAI = this.ultraTextMC_TAI.Text; IMC_ACT = this.ultraTextMC_ACT.Text; IMC_MFACTUR_UNITS = this.ultraTextMC_MFACTUR_UNITS.Text; IMC_USE_YEAR = this.ultraTextMC_USE_YEAR.Text; IMC_USE_TIME = this.ultraCalendarMC_USE_TIME.Text; IMC_INSTAL_LOCAL = this.ultraTextMC_INSTAL_LOCAL.Text; IMC_REG_OUT_STAT = this.ultraComboMC_REG_OUT_STAT.Text; IMC_STAT = this.ultraComboMC_STAT.Text; IREG_OUT_DTIME = this.ultraCalendarREG_IN_DTIME.Text; IREG_OUT_ID = this.ultraTextREG_IN_ID.Text; IMAIN_MC_NAME = this.ultraTextMAIN_MC_NAME.Text; IREG_IN_DTIME = DateTime.Now.ToString(); DataTable dt = new DataTable(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIK.UIK03.UIK030020"; ccp.MethodName = "DoSelect"; ccp.ServerParams = new object[] { IREG_IN_DTIME }; ccp.SourceDataTable = dt; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); if (dt.Rows.Count > 0) { MessageBox.Show("该编设备号已经存在，请重新输入"); } else { CoreClientParam ccp2 = new CoreClientParam(); ccp2.ServerName = "UIK.UIK03.UIK030020"; ccp2.MethodName = "DoInsert"; ccp2.ServerParams = new object[] { mcid, IMC_NAME, IMC_MODEL, IMC_SPEC, IMC_FACTORY, IMC_IN_DTIME, IMC_PRICE, IMC_CARE_SECTOR, IMC_NOM_CAP, IMC_UNIT, IMC_TAI, IMC_ACT, IMC_MFACTUR_UNITS, IMC_USE_YEAR, IMC_USE_TIME, IMC_INSTAL_LOCAL, IMC_REG_OUT_STAT, IMC_STAT, IREG_OUT_DTIME, IREG_OUT_ID, IMAIN_MC_NAME, IREG_IN_DTIME }; ccp2 = this.ExecuteNonQuery(ccp2, CoreInvokeType.Internal); if (0 != ccp2.ReturnCode) { MessageBox.Show("添加失败！"); } else { MessageBox.Show("添加成功！"); this.ultraTextMCID2.Enabled = true; this.ultraTextMCID2.Clear(); this.ultraTextMC_NAME.Clear(); this.ultraTextMC_MODEL.Clear(); this.ultraTextMC_SPEC.Clear(); this.ultraTextMC_FACTORY.Clear(); this.ultraCalendarMC_IN_DTIME.Text = ""; this.ultraTextMC_PRICE.Clear(); this.ultraTextMC_CARE_SECTOR.Clear(); this.ultraTextMC_NOM_CAP.Clear(); this.ultraTextMC_UNIT.Clear(); this.ultraTextMC_TAI.Clear(); this.ultraTextMC_ACT.Clear(); this.ultraTextMC_MFACTUR_UNITS.Clear(); this.ultraTextMC_USE_YEAR.Clear(); this.ultraCalendarMC_USE_TIME.Text = ""; this.ultraTextMC_INSTAL_LOCAL.Clear(); this.ultraComboMC_REG_OUT_STAT.Clear(); this.ultraComboMC_STAT.Clear(); this.ultraCalendarREG_IN_DTIME.Text = ""; this.ultraTextREG_IN_ID.Clear(); this.ultraTextMAIN_MC_NAME.Clear(); } } } } private void ultraButtonShengQing_Click(object sender, EventArgs e) { try { Infragistics.Win.UltraWinGrid.UltraGridRow ugr = this.ultraGrid1.ActiveRow; if (ugr.Cells["SELECT_ITEM"].Text.ToString() == "True") { string IREG_IN_DTIME, IMC_REG_OUT_STAT = "", IMC_PROCESS_REG; IREG_IN_DTIME = ugr.Cells["REG_IN_DTIME"].Value.ToString(); DataTable dt = new DataTable(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIK.UIK03.UIK030020"; ccp.MethodName = "DoSelect"; ccp.ServerParams = new object[] { IREG_IN_DTIME }; ccp.SourceDataTable = dt; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); foreach (DataRow dr in dt.Rows) { IMC_REG_OUT_STAT = dr["MC_REG_OUT_STAT"].ToString(); } if (IMC_REG_OUT_STAT == "已报废") { MessageBox.Show("设备已报废，无法申请报废！"); } else { if (MessageBox.Show("您确认要申请报废吗？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { IMC_PROCESS_REG = "申请报废中"; CoreClientParam ccp3 = new CoreClientParam(); ccp3.ServerName = "UIK.UIK03.UIK030020"; ccp3.MethodName = "DoUpdateMC_REG_OUT_STAT"; ccp3.ServerParams = new object[] { IMC_PROCESS_REG, IREG_IN_DTIME }; ccp3 = this.ExecuteNonQuery(ccp3, CoreInvokeType.Internal); if (0 != ccp3.ReturnCode) { MessageBox.Show("申请失败！"); } else { MessageBox.Show("申请成功，请等待处理！"); } } } } else { MessageBox.Show("请选择申请报废行！"); } } catch (Exception Ex) { MessageBox.Show(Ex.ToString()); } } private void DoQueRen() { try { Infragistics.Win.UltraWinGrid.UltraGridRow ugr = this.ultraGrid1.ActiveRow; if (ugr.Cells["SELECT_ITEM"].Text.ToString() == "True") { string IREG_IN_DTIME, IMC_PROCESS_REG = "", IMC_REG_OUT_STAT, IMC_STAT, IREG_OUT_DTIME; IREG_IN_DTIME = ugr.Cells["REG_IN_DTIME"].Value.ToString(); IREG_OUT_DTIME = System.DateTime.Now.ToString(); DataTable dt = new DataTable(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIK.UIK03.UIK030020"; ccp.MethodName = "DoSelect"; ccp.ServerParams = new object[] { IREG_IN_DTIME }; ccp.SourceDataTable = dt; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); foreach (DataRow dr in dt.Rows) { IMC_PROCESS_REG = dr["MC_PROCESS_REG"].ToString(); } if (IMC_PROCESS_REG != "申请报废中") { MessageBox.Show("该项没有报废申请，请查证后操作"); } if (IMC_PROCESS_REG == "申请报废中") { if (MessageBox.Show("您确认要申请报废吗？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { IMC_REG_OUT_STAT = "已报废"; IMC_STAT = "已报废"; IMC_PROCESS_REG = "已处理"; CoreClientParam ccp2 = new CoreClientParam(); ccp2.ServerName = "UIK.UIK03.UIK030020"; ccp2.MethodName = "DoUpdateMC_PROCESS_REG"; ccp2.ServerParams = new object[] { IMC_REG_OUT_STAT, IMC_STAT, IMC_PROCESS_REG, IREG_IN_DTIME }; ccp2 = this.ExecuteNonQuery(ccp2, CoreInvokeType.Internal); if (0 != ccp2.ReturnCode) { MessageBox.Show("处理失败！"); } else { CoreClientParam ccp3 = new CoreClientParam(); ccp3.ServerName = "UIK.UIK03.UIK030020"; ccp3.MethodName = "DoUpdateREG_OUT_DTIME"; ccp3.ServerParams = new object[] { IREG_OUT_DTIME, IREG_IN_DTIME }; ccp2 = this.ExecuteNonQuery(ccp3, CoreInvokeType.Internal); if (0 != ccp3.ReturnCode) { MessageBox.Show("处理失败！"); } else { MessageBox.Show("处理成功！"); } } } } } else { MessageBox.Show("请选择处理申请报废行！"); } } catch (Exception Ex) { MessageBox.Show(Ex.ToString()); } } private void DoQuXiao() { try { Infragistics.Win.UltraWinGrid.UltraGridRow ugr = this.ultraGrid1.ActiveRow; if (ugr.Cells["SELECT_ITEM"].Text.ToString() == "True") { //string mcid, IMC_PROCESS_REG = "", IMC_REG_OUT_STAT, IMC_STAT; string IREG_IN_DTIME, IMC_PROCESS_REG = "", IMC_REG_OUT_STAT; IREG_IN_DTIME = ugr.Cells["REG_IN_DTIME"].Value.ToString(); DataTable dt = new DataTable(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIK.UIK03.UIK030020"; ccp.MethodName = "DoSelect"; ccp.ServerParams = new object[] { IREG_IN_DTIME }; ccp.SourceDataTable = dt; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); foreach (DataRow dr in dt.Rows) { IMC_PROCESS_REG = dr["MC_PROCESS_REG"].ToString(); } if (IMC_PROCESS_REG != "申请报废中") { MessageBox.Show("该项没有报废申请，请查证后操作"); } if (IMC_PROCESS_REG == "申请报废中") { if (MessageBox.Show("您确认要取消报废申请吗？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { IMC_REG_OUT_STAT = "未报废"; IMC_PROCESS_REG = "等待"; CoreClientParam ccp2 = new CoreClientParam(); ccp2.ServerName = "UIK.UIK03.UIK030020"; ccp2.MethodName = "DoUpdateQUXIAO"; ccp2.ServerParams = new object[] { IMC_REG_OUT_STAT, IMC_PROCESS_REG, IREG_IN_DTIME }; ccp2 = this.ExecuteNonQuery(ccp2, CoreInvokeType.Internal); if (0 != ccp2.ReturnCode) { MessageBox.Show("取消失败！"); } else { MessageBox.Show("取消成功！"); } } } } else { MessageBox.Show("请选择处理申请报废行！"); } } catch (Exception Ex) { MessageBox.Show(Ex.ToString()); } } } }