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 Infragistics.Win.UltraWinGrid; using Infragistics.Win; using System.Collections; using CoreFS.CA06; using System.Diagnostics; namespace Core.LZMes.Client.QCM { public partial class QCM030508 : FrmBase { public QCM030508() { InitializeComponent(); } public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "Query": this.DoQuery(); break; case "Export": this.DoExport(); break; case "Save": this.DoSave(); break; } } private void DoQuery() { if (this.ultraTabControl1.Tabs[0].Selected) //待判信息 { DoQueryMe(); } if (this.ultraTabControl1.Tabs[1].Selected) //判定记录 { DoQueryRe(); } if (this.ultraTabControl1.Tabs[2].Selected) //判定记录 { DoQueryRe1(); } } private void DoQueryMe() { try { this.dataSet3.Clear(); string sbatchno = ""; string ebatchno = ""; if (checkBox3.Checked) { sbatchno = this.textBox2.Text.Trim(); if (textBox1.Text.ToString() == "") { ebatchno = this.textBox2.Text.Trim(); } else { ebatchno = this.textBox1.Text.Trim(); } } string ord_no = ""; if (checkBox1.Checked) { ord_no = textBox4.Text.Trim(); } string ord_no2 = ""; if(this.checkBox4.Checked){ ord_no2 = this.textBox3.Text.Trim(); } /*if (!checkBox1.Checked && !checkBox3.Checked ) { MessageBox.Show("轧批号、计划订单号必须选择其中一个条件!"); return; }*/ CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0302.QcmJudgePhysicalServiceImpl"; ccp.MethodName = "GetKcZReport1"; ccp.ServerParams = new object[] { sbatchno, ebatchno, ord_no, ord_no2 }; ccp.SourceDataTable = this.dataSet3.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); MessageBox.Show("系统出错,请联系管理人员", "警告"); } } private void DoQueryRe() { try { this.dataSet2.Clear(); string sbatchno = ""; string ebatchno = ""; if (checkBox3.Checked) { sbatchno = this.textBox2.Text.Trim(); if (textBox1.Text.ToString() == "") { ebatchno = this.textBox2.Text.Trim(); } else { ebatchno = this.textBox1.Text.Trim(); } } string ord_no = ""; if (checkBox1.Checked) { ord_no = textBox4.Text.Trim(); //轧辊单元 } string ord_no2 = ""; if (this.checkBox4.Checked) { ord_no2 = this.textBox3.Text.Trim(); } /*if (!checkBox1.Checked && !checkBox3.Checked) { MessageBox.Show("轧批号、计划订单号必须选择其中一个条件!"); return; }*/ CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0302.QcmJudgePhysicalServiceImpl"; ccp.MethodName = "GetKcHReport1"; ccp.ServerParams = new object[] { sbatchno, ebatchno, ord_no, ord_no2 }; ccp.SourceDataTable = this.dataSet2.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); MessageBox.Show("系统出错,请联系管理人员", "警告"); } } private void DoQueryRe1() { try { this.dataSet7.Clear(); string sbatchno = ""; string ebatchno = ""; if (checkBox3.Checked) { sbatchno = this.textBox2.Text.Trim(); if (textBox1.Text.ToString() == "") { ebatchno = this.textBox2.Text.Trim(); } else { ebatchno = this.textBox1.Text.Trim(); } } string ord_no = ""; if (checkBox1.Checked) { ord_no = textBox4.Text.Trim(); //轧辊单元 } string ord_no2 = ""; if (this.checkBox4.Checked) { ord_no2 = this.textBox3.Text.Trim(); } /*if (!checkBox1.Checked && !checkBox3.Checked) { MessageBox.Show("轧批号、计划订单号必须选择其中一个条件!"); return; }*/ CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0302.QcmJudgePhysicalServiceImpl"; ccp.MethodName = "GetBJReport1"; ccp.ServerParams = new object[] { sbatchno, ebatchno, ord_no, ord_no2 }; ccp.SourceDataTable = this.dataSet7.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); MessageBox.Show("系统出错,请联系管理人员", "警告"); } } private void DoSave() { if (this.ultraTabControl1.Tabs[0].Selected) { foreach (UltraGridRow ugr in ultraGrid3.Rows) { if (ugr.Cells["CHECK"].Text.ToString() == "True") { CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0302.QcmJudgePhysicalServiceImpl"; ccp.MethodName = "in_Judgereason"; ccp.ServerParams = new object[] { ugr.Cells["子板号"].Value.ToString(), ugr.Cells["JUDGE_REASON"].Text.ToString(), ugr.Cells["JUDGE_REG"].Text.ToString(),ugr.Cells["PTIME"].Text.ToString(),ugr.Cells["COIL_STAT"].Text.ToString() }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode == -1) { return; } ugr.Cells["CHECK"].Value = "False"; } } MessageBox.Show("录入成功"); } else if (this.ultraTabControl1.Tabs[1].Selected) { foreach (UltraGridRow ugr in ultraGrid1.Rows) { if (ugr.Cells["CHECK"].Text.ToString() == "True") { CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0302.QcmJudgePhysicalServiceImpl"; ccp.MethodName = "in_Judgereason"; ccp.ServerParams = new object[] { ugr.Cells["子板号"].Value.ToString(), ugr.Cells["JUDGE_REASON"].Text.ToString(), ugr.Cells["JUDGE_REG"].Text.ToString(),ugr.Cells["PTIME"].Text.ToString(),ugr.Cells["COIL_STAT"].Text.ToString() }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode == -1) { return; } ugr.Cells["CHECK"].Value = "False"; } } MessageBox.Show("录入成功"); } else if (this.ultraTabControl1.Tabs[2].Selected) { foreach (UltraGridRow ugr in ultraGrid2.Rows) { if (ugr.Cells["CHECK"].Text.ToString() == "True") { CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0302.QcmJudgePhysicalServiceImpl"; ccp.MethodName = "in_Judgereason"; ccp.ServerParams = new object[] { ugr.Cells["子板号"].Value.ToString(), ugr.Cells["JUDGE_REASON"].Text.ToString(), ugr.Cells["JUDGE_REG"].Text.ToString(),ugr.Cells["PTIME"].Text.ToString(),ugr.Cells["COIL_STAT"].Text.ToString() }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode == -1) { return; } ugr.Cells["CHECK"].Value = "False"; } } MessageBox.Show("录入成功"); } } private void DoExport() { if (this.ultraTabControl1.Tabs[0].Selected) //待判信息 { this.saveFileDialog1.FileName = "中板线待检信息"; try { if (this.ultraGrid3.Rows.Count == 0) { MessageBox.Show("没有可以导出的数据", "提示"); return; } if (this.saveFileDialog1.ShowDialog(this) == DialogResult.OK) { string fName = this.saveFileDialog1.FileName; this.ultraGridExcelExporter1.Export(this.ultraGrid3, fName); Process.Start(fName); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } if (this.ultraTabControl1.Tabs[1].Selected) //判定记录 { this.saveFileDialog1.FileName = "厚板线待检信息"; try { if (this.ultraGrid1.Rows.Count == 0) { MessageBox.Show("没有可以导出的数据", "提示"); return; } if (this.saveFileDialog1.ShowDialog(this) == DialogResult.OK) { string fName = this.saveFileDialog1.FileName; this.ultraGridExcelExporter1.Export(this.ultraGrid1, fName); Process.Start(fName); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } if (this.ultraTabControl1.Tabs[2].Selected) //判定记录 { this.saveFileDialog1.FileName = "板加待检信息"; try { if (this.ultraGrid2.Rows.Count == 0) { MessageBox.Show("没有可以导出的数据", "提示"); return; } if (this.saveFileDialog1.ShowDialog(this) == DialogResult.OK) { string fName = this.saveFileDialog1.FileName; this.ultraGridExcelExporter1.Export(this.ultraGrid2, fName); Process.Start(fName); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } } private void QCM030508_Load(object sender, EventArgs e) { this.ultraGrid1.DisplayLayout.Override.FilterUIType = FilterUIType.HeaderIcons; this.ultraGrid3.DisplayLayout.Override.FilterUIType = FilterUIType.HeaderIcons; } private void checkBox2_CheckedChanged(object sender, EventArgs e) { if (this.ultraTabControl1.Tabs[0].Selected) { foreach (UltraGridRow ugr in this.ultraGrid3.Rows.Where(p => p.IsFilteredOut == false).ToList()) { if (checkBox2.Checked) { ugr.Cells["CHECK"].Value = "True"; } else { ugr.Cells["CHECK"].Value = "False"; } } } else if (this.ultraTabControl1.Tabs[1].Selected) { foreach (UltraGridRow ugr in this.ultraGrid1.Rows.Where(p => p.IsFilteredOut == false).ToList()) { if (checkBox2.Checked) { ugr.Cells["CHECK"].Value = "True"; } else { ugr.Cells["CHECK"].Value = "False"; } } } else { foreach (UltraGridRow ugr in this.ultraGrid2.Rows.Where(p => p.IsFilteredOut == false).ToList()) { if (checkBox2.Checked) { ugr.Cells["CHECK"].Value = "True"; } else { ugr.Cells["CHECK"].Value = "False"; } } } } private void ultraGrid3_AfterRowActivate(object sender, EventArgs e) { try { UltraGridRow ugr = this.ultraGrid3.ActiveRow; if (ugr.Cells["CHECK"].Text.ToString() == "True") { ugr.Cells["CHECK"].Value = "False"; } else { ugr.Cells["CHECK"].Value = "True"; } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); MessageBox.Show("系统出错,请联系管理人员", "警告"); } } private void ultraGrid1_AfterRowActivate(object sender, EventArgs e) { try { UltraGridRow ugr = this.ultraGrid1.ActiveRow; if (ugr.Cells["CHECK"].Text.ToString() == "True") { ugr.Cells["CHECK"].Value = "False"; } else { ugr.Cells["CHECK"].Value = "True"; } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); MessageBox.Show("系统出错,请联系管理人员", "警告"); } } private void ultraGrid2_AfterRowActivate(object sender, EventArgs e) { } private void ultraGrid1_AfterRowActivate22(object sender, EventArgs e) { try { UltraGridRow ugr = this.ultraGrid1.ActiveRow; if (ugr.Cells["CHECK"].Text.ToString() == "True") { ugr.Cells["CHECK"].Value = "False"; } else { ugr.Cells["CHECK"].Value = "True"; } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); MessageBox.Show("系统出错,请联系管理人员", "警告"); } } private void ultraGrid1_InitializeRow(object sender, InitializeRowEventArgs e) { this.ultraGrid1.ActiveRow = null; } } }