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 QCM030509 : FrmBase { public QCM030509() { InitializeComponent(); } public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "Query": this.DoQuery(); break; case "Judge": Operate(); break; case "Exit": this.Close(); break; case "Export": this.DoExport(); break; } } private void DoQuery() { if (this.ultraTabControl1.Tabs[0].Selected) //待判信息 { DoQueryMe(); } if (this.ultraTabControl1.Tabs[1].Selected) //判定记录 { DoQueryRe(); } } private void DoQueryMe() { //查询探伤待检信息（轧批号、计划号） try { this.dataSet3.Clear(); dataSet6.Clear(); string starttime = ""; string endtime = ""; if (checkBox2.Checked) { starttime = this.dateTimePicker1.Value.ToString("yyyyMMdd"); endtime = this.dateTimePicker2.Value.AddDays(1).ToString("yyyyMMdd"); } string material_no = textBox2.Text.ToString(); if (!checkBox2.Checked && !checkBox3.Checked) { MessageBox.Show("时间与产品序号必须选择其中一个条件！"); return; } string orderno = this.textBox4.Text.Trim();// 订单号 string prodline = this.comboBox3.Text.ToString(); string processes = this.comboBox5.Text.ToString(); string isjudge = this.comboBox4.Text.ToString(); if (processes == "") { MessageBox.Show("请选择工序！"); return; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0303.QcmJudgeMeasureServiceImpl"; ccp.MethodName = "doQueryMaterialDetailsY1"; ccp.ServerParams = new object[] { starttime, endtime, material_no, orderno, "B", prodline, isjudge, processes }; ccp.SourceDataTable = this.dataSet3.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0305.QcmJudgeSurfaceServiceImpl"; ccp.MethodName = "findFlawDataY"; ccp.ServerParams = new object[] { prodline }; ccp.SourceDataTable = this.dataSet6.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); this.ultraCombo1.DataSource = ccp.SourceDataTable; this.ultraGrid4.DisplayLayout.Bands[0].Columns["FLAW_DESC"].EditorComponent = ultraCombo1; } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); MessageBox.Show("系统出错，请联系管理人员", "警告"); } } private void DoQueryRe() { //查询判定记录 try { this.dataSet2.Clear(); string starttime = ""; string endtime = ""; if (checkBox2.Checked) { starttime = this.dateTimePicker1.Value.ToString("yyyyMMdd"); endtime = this.dateTimePicker2.Value.ToString("yyyyMMdd"); } string material_no = textBox2.Text.ToString(); if (!checkBox2.Checked && !checkBox3.Checked) { MessageBox.Show("时间与产品序号必须选择其中一个条件！"); return; } string orderno = textBox4.Text.Trim(); string prodline = this.comboBox3.Text.ToString(); string processes = this.comboBox5.Text.ToString(); if (processes == "") { MessageBox.Show("请选择工序！"); return; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0305.QcmJudgeSurfaceServiceImpl"; ccp.MethodName = "GetSurfaceInfoY"; ccp.ServerParams = new object[] { starttime, endtime, material_no, orderno, prodline, processes }; ccp.SourceDataTable = this.dataSet2.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); MessageBox.Show("系统出错，请联系管理人员", "警告"); } } private void Operate() { string material_no = ""; try { UltraGridRow ugr = this.ultraGrid3.ActiveRow; if (ugr == null) return; CoreClientParam ccp = new CoreClientParam(); foreach (UltraGridRow ugrs in this.ultraGrid4.Rows) { if (ugrs.Cells["CHECKBOX"].Text.ToString() == "True") { string surfaceid = ugrs.Cells["SURFACE_ID"].Value.ToString(); string username = this.UserInfo.GetUserName(); string userorder = this.UserInfo.GetUserOrderText(); string usergroup = this.UserInfo.GetUserGroupText(); string flag = ""; if(ugrs.Cells["PRIMARY_FLAG"].Text.ToString().Contains("是")) { flag = "1"; } else { flag = "0"; } ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0305.QcmJudgeSurfaceServiceImpl"; ccp.MethodName = "repairFlaw"; ccp.ServerParams = new object[] { surfaceid, ugrs.Cells["FLAW_SEQ"].Value.ToString(), flag, username, userorder, usergroup }; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); } } this.dataSet4.Clear(); string surface_id = ugr.Cells["SURFACE_ID"].Value.ToString(); ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0305.QcmJudgeSurfaceServiceImpl"; ccp.MethodName = "findNameByMN"; ccp.ServerParams = new object[] { surface_id }; ccp.SourceDataTable = this.dataSet4.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); MessageBox.Show("系统出错，请联系管理人员", "警告"); } } private void label9_Click(object sender, EventArgs e) { try { List lists = new List(); foreach (UltraGridRow ugr in ultraGrid3.Rows) { if (ugr.Cells["CHECK"].Text.ToString() == "True") { ArrayList list1 = new ArrayList(); List list2 = new List(); if (comboBox2.Text.Trim() == "") { MessageBox.Show("请输入质量等级！"); return; } string is_pass = ""; string is_zl = ""; if (comboBox1.Text.ToString() == "合格") { is_pass = "1"; } else if (comboBox1.Text.ToString() == "不合格") { is_pass = "2"; } else if (comboBox1.Text.ToString() == "判次") { is_pass = "3"; } else if (comboBox1.Text.ToString() == "判废") { is_pass = "4"; } else { is_pass = ""; } list1.Add(ugr.Cells["MATERIAL_NO"].Value.ToString()); list1.Add(is_pass);//检验结果代码 list1.Add(comboBox1.Text.Trim().ToString());//检验结果 list1.Add(comboBox2.Text.Trim().ToString());//质量等级代码 list1.Add(comboBox2.Text.Trim().ToString());//质量等级名称 list1.Add(textBox5.Text.ToString().Trim()); list1.Add(this.UserInfo.GetUserName());//操作人 list1.Add(this.UserInfo.GetUserOrderText());//班次 list1.Add(this.UserInfo.GetUserGroupText());//班组 int count = 0; int i = 0; int j = 1; foreach (UltraGridRow ugrs in this.ultraGrid4.Rows) { if (ugrs.Cells["CHECKBOX"].Text.ToString() == "True") { ArrayList list = new ArrayList(); if (ugrs.Cells["PRIMARY_FLAG"].Value.ToString() == "1" || ugrs.Cells["PRIMARY_FLAG"].Value.ToString() == "" || ugrs.Cells["PRIMARY_FLAG"].Text.ToString() == "是") { list.Add("1"); } else { list.Add("0"); } list.Add(j); if (ugrs.Cells["FLAW_DESC"].Text.ToString() == "") { list.Add(ugrs.Cells["FLAW_DESC"].Text.ToString()); } else { list.Add(ugrs.Cells["FLAW_DESC"].Value.ToString()); } list.Add(ugrs.Cells["FLAW_DESC"].Text.ToString()); if (ugrs.Cells["FLAW_DESC"].Text.ToString() == "") { MessageBox.Show("已选择的请录入缺陷信息！"); return; } if (ugrs.Cells["FLAW_AREA"].Text.ToString() == "上表面") { list.Add("U"); } else if (ugrs.Cells["FLAW_AREA"].Text.ToString() == "下表面") { list.Add("D"); } else if (ugrs.Cells["FLAW_AREA"].Text.ToString() == "边部") { list.Add("E"); } else { list.Add(""); } //list.Add(ugrs.Cells["FLAW_TYPE_DESC"].Value.ToString()); //list.Add(ugrs.Cells["FLAW_TYPE_DESC"].Text.ToString()); if (ugrs.Cells["FLAW_POS_DESC"].Text.ToString() == "") { list.Add(ugrs.Cells["FLAW_POS_DESC"].Text.ToString()); } else { list.Add(ugrs.Cells["FLAW_POS_DESC"].Value.ToString()); } list.Add(ugrs.Cells["FLAW_POS_DESC"].Text.ToString()); if (ugrs.Cells["FLAW_DIR_DESC"].Text.ToString() == "") { list.Add(ugrs.Cells["FLAW_DIR_DESC"].Text.ToString()); } else { list.Add(ugrs.Cells["FLAW_DIR_DESC"].Value.ToString()); } list.Add(ugrs.Cells["FLAW_DIR_DESC"].Text.ToString()); if (ugrs.Cells["FLAW_SIZE_DESC"].Text.ToString() == "") { list.Add(ugrs.Cells["FLAW_SIZE_DESC"].Text.ToString()); } else { list.Add(ugrs.Cells["FLAW_SIZE_DESC"].Value.ToString()); } list.Add(ugrs.Cells["FLAW_SIZE_DESC"].Text.ToString()); if (ugrs.Cells["FLAW_LV_DESC"].Text.ToString() == "") { list.Add(ugrs.Cells["FLAW_LV_DESC"].Text.ToString()); } else { list.Add(ugrs.Cells["FLAW_LV_DESC"].Value.ToString()); } list.Add(ugrs.Cells["FLAW_LV_DESC"].Text.ToString()); //if (ugrs.Cells["FLAW_QUANTITY"].Text == "") //{ // MessageBox.Show("请输入数量！"); // return; //} list.Add(ugrs.Cells["FLAW_QUANTITY"].Text.ToString()); list.Add(ugrs.Cells["MEMO"].Text.ToString()); list.Add("0"); count++; j++; list2.Add(list); } } if (count == 0 && comboBox1.Text.ToString() == "不合格") { MessageBox.Show("请录入缺陷信息并选择！"); return; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0305.QcmJudgeSurfaceServiceImpl"; ccp.MethodName = "doAddFlawY"; ccp.ServerParams = new object[] { list2, list1 }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode == -1) { return; } lists.Add(ugr); } } for (int i = 0; i < lists.Count; i++) { lists[i].Delete(false); } // DoQuery(); MessageBox.Show("登记成功！"); }catch(Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); MessageBox.Show("系统出错，请联系管理人员", "警告"); } } private void QCM0305_Load(object sender, EventArgs e) { this.comboBox3.SelectedIndex = 0; this.comboBox4.SelectedIndex = 0; string prodline = comboBox3.Text.ToString(); this.ultraGrid1.DisplayLayout.Override.FilterUIType = FilterUIType.HeaderIcons; this.ultraGrid3.DisplayLayout.Override.FilterUIType = FilterUIType.HeaderIcons; this.dateTimePicker1.Value = System.DateTime.Now.AddDays(-7); this.ultraGrid1.DisplayLayout.Bands[0].Header.Appearance.BackColor = Color.LightBlue; this.ultraGrid3.DisplayLayout.Bands[0].Header.Appearance.BackColor = Color.LightBlue; this.ultraGrid4.DisplayLayout.Bands[0].Header.Appearance.BackColor = Color.LightBlue; ValueList vis_repair = new ValueList(); vis_repair.ValueListItems.Add("0", "待修复"); vis_repair.ValueListItems.Add("1", "已修复"); this.ultraGrid4.DisplayLayout.Bands[0].Columns["IS_REPAIR"].ValueList = vis_repair; ValueList vprimary_flag = new ValueList(); vprimary_flag.ValueListItems.Add("1", "是"); vprimary_flag.ValueListItems.Add("0", "否"); this.ultraGrid4.DisplayLayout.Bands[0].Columns["PRIMARY_FLAG"].ValueList = vprimary_flag; ValueList vFLAW_DESC = new ValueList(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0305.QcmJudgeSurfaceServiceImpl"; ccp.MethodName = "findFlawArea"; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); for (int i = 0; i < ccp.SourceDataTable.Rows.Count; i++) { vFLAW_DESC.ValueListItems.Add(ccp.SourceDataTable.Rows[i]["SM_CD"].ToString(), ccp.SourceDataTable.Rows[i]["SM_CFNM"].ToString()); } this.ultraGrid4.DisplayLayout.Bands[0].Columns["FLAW_AREA"].ValueList = vFLAW_DESC; ValueList vsflv = new ValueList(); ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0305.QcmJudgeSurfaceServiceImpl"; ccp.MethodName = "findSfLvY"; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); for (int i = 0; i < ccp.SourceDataTable.Rows.Count; i++) { vsflv.ValueListItems.Add(ccp.SourceDataTable.Rows[i]["SM_CD"].ToString(), ccp.SourceDataTable.Rows[i]["SM_CFNM"].ToString()); } this.comboBox2.DataSource = vsflv.ValueListItems; ValueList vflaw_pos_desc = new ValueList(); ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0305.QcmJudgeSurfaceServiceImpl"; ccp.MethodName = "findFlawPosDesc"; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); for (int i = 0; i < ccp.SourceDataTable.Rows.Count; i++) { vflaw_pos_desc.ValueListItems.Add(ccp.SourceDataTable.Rows[i]["SM_CD"].ToString(), ccp.SourceDataTable.Rows[i]["SM_CFNM"].ToString()); } this.ultraGrid4.DisplayLayout.Bands[0].Columns["FLAW_POS_DESC"].ValueList = vflaw_pos_desc; ValueList VFLAW_SIZE_DESC = new ValueList(); ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0305.QcmJudgeSurfaceServiceImpl"; ccp.MethodName = "findFlawSizeDesc"; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); for (int i = 0; i < ccp.SourceDataTable.Rows.Count; i++) { VFLAW_SIZE_DESC.ValueListItems.Add(ccp.SourceDataTable.Rows[i]["SM_CD"].ToString(), ccp.SourceDataTable.Rows[i]["SM_CFNM"].ToString()); } this.ultraGrid4.DisplayLayout.Bands[0].Columns["FLAW_SIZE_DESC"].ValueList = VFLAW_SIZE_DESC; ValueList VFLAW_LV_DESC = new ValueList(); ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0305.QcmJudgeSurfaceServiceImpl"; ccp.MethodName = "findFlawLvDesc"; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); for (int i = 0; i < ccp.SourceDataTable.Rows.Count; i++) { VFLAW_LV_DESC.ValueListItems.Add(ccp.SourceDataTable.Rows[i]["SM_CD"].ToString(), ccp.SourceDataTable.Rows[i]["SM_CFNM"].ToString()); } this.ultraGrid4.DisplayLayout.Bands[0].Columns["FLAW_LV_DESC"].ValueList = VFLAW_LV_DESC; ValueList VFLAW_DIR_DESC = new ValueList(); ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0305.QcmJudgeSurfaceServiceImpl"; ccp.MethodName = "findFlawDirDesc"; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); for (int i = 0; i < ccp.SourceDataTable.Rows.Count; i++) { VFLAW_DIR_DESC.ValueListItems.Add(ccp.SourceDataTable.Rows[i]["SM_CD"].ToString(), ccp.SourceDataTable.Rows[i]["SM_CFNM"].ToString()); } this.ultraGrid4.DisplayLayout.Bands[0].Columns["FLAW_DIR_DESC"].ValueList = VFLAW_DIR_DESC; ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0305.QcmJudgeSurfaceServiceImpl"; ccp.MethodName = "findFlawDataY"; ccp.ServerParams = new object[] { prodline }; ccp.SourceDataTable = this.dataSet6.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); //ValueList VDEFECT_DESC = new ValueList(); //for (int i = 0; i < ccp.SourceDataTable.Rows.Count; i++) //{ // VDEFECT_DESC.ValueListItems.Add(ccp.SourceDataTable.Rows[i]["DEFECT_CODE"].ToString(), ccp.SourceDataTable.Rows[i]["DEFECT_DESC"].ToString()); //} //this.ultraGrid4.DisplayLayout.Bands[0].Columns["FLAW_DESC"].ValueList = VDEFECT_DESC; ultraCombo1.DataSource = ccp.SourceDataTable; this.ultraGrid4.DisplayLayout.Bands[0].Columns["FLAW_DESC"].EditorComponent = ultraCombo1; string userid = this.UserInfo.GetUserID(); if (userid.Equals("X15797") || userid.Equals("X15798") || userid.Equals("X15801") || userid.Equals("X15804") || userid.Equals("X15805") || userid.Equals("X15815") || userid.Equals("X15806") || userid.Equals("X15795")) { for (int i = 0; comboBox5.Items.Count > 0; ) { comboBox5.Items.RemoveAt(0); } comboBox5.Items.Add("酸洗机组"); } else if (userid.Equals("X15724") || userid.Equals("X15833") || userid.Equals("X15816") || userid.Equals("X15734") || userid.Equals("X15827") || userid.Equals("X15830")) { for (int i = 0; comboBox5.Items.Count > 0; ) { comboBox5.Items.RemoveAt(0); } comboBox5.Items.Add("轧机机组"); } else if (userid.Equals("X15824") || userid.Equals("X15818") || userid.Equals("X15825") || userid.Equals("X15826") || userid.Equals("X15817")) { for (int i = 0; comboBox5.Items.Count > 0; ) { comboBox5.Items.RemoveAt(0); } comboBox5.Items.Add("退火炉宝信"); comboBox5.Items.Add("退火炉南方D"); comboBox5.Items.Add("退火炉艾伯纳"); comboBox5.Items.Add("退火炉南方G"); } else if (userid.Equals("X15763") || userid.Equals("X15764") || userid.Equals("X15760") || userid.Equals("X15736")) { for (int i = 0; comboBox5.Items.Count > 0; ) { comboBox5.Items.RemoveAt(0); } comboBox5.Items.Add("平整机组"); } else if (userid.Equals("X15720") || userid.Equals("X15719") || userid.Equals("X15726") || userid.Equals("X15743")) { for (int i = 0; comboBox5.Items.Count > 0; ) { comboBox5.Items.RemoveAt(0); } comboBox5.Items.Add("4mm分条机组"); comboBox5.Items.Add("12mm分条机组"); comboBox5.Items.Add("3mm横剪机组"); } //DoQuery(); } private void ultraGrid3_AfterRowActivate(object sender, EventArgs e) { try { UltraGridRow ugr = this.ultraGrid3.ActiveRow; this.dataSet4.Clear(); //this.dataSet4.Clear(); //string surface_id = ugr.Cells["SURFACE_ID"].Value.ToString(); //if (surface_id != "") //{ // CoreClientParam ccp = new CoreClientParam(); // ccp.ServerName = "QCM.QCM03.QCM0305.QcmJudgeSurfaceServiceImpl"; // ccp.MethodName = "findNameByMN"; // ccp.ServerParams = new object[] { surface_id }; // ccp.SourceDataTable = this.dataSet4.Tables[0]; // this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); //} string design_key = ugr.Cells["DESIGN_KEY"].Value.ToString(); if (design_key != "") { CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0303.QcmJudgeMeasureServiceImpl"; ccp.MethodName = "GetMemo"; ccp.ServerParams = new object[] { design_key }; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); if (ccp.SourceDataTable.Rows.Count == 0) { this.textBox6.Text = ""; } else { this.textBox6.Text = ccp.SourceDataTable.Rows[0]["MEMO"].ToString(); } } //this.ultraGrid4.DisplayLayout.Bands[0].Columns["FLAW_DESC"].EditorComponent = ultraCombo1; //foreach (UltraGridRow ugrs in this.ultraGrid4.Rows) //{ // if (ugrs.Cells["IS_REPAIR"].Text.ToString().Contains("已修复")) // { // ugrs.Appearance.BackColor = Color.Pink; // } //} } 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 == null) return; this.dataSet5.Clear(); string surface_id = ugr.Cells["SURFACE_ID"].Value.ToString(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0305.QcmJudgeSurfaceServiceImpl"; ccp.MethodName = "findNameByMN"; ccp.ServerParams = new object[] { surface_id }; ccp.SourceDataTable = this.dataSet5.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); foreach (UltraGridRow ugrs in this.ultraGrid5.Rows) { if (ugrs.Cells["IS_REPAIR"].Text.ToString().Contains("已修复")) { ugrs.Appearance.BackColor = Color.Pink; } } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); MessageBox.Show("系统出错，请联系管理人员", "警告"); } } private void checkBox1_CheckedChanged(object sender, EventArgs e) { foreach (UltraGridRow ugr in this.ultraGrid3.Rows.Where(p => p.IsFilteredOut == false).ToList()) { if (checkBox1.Checked) { ugr.Cells["CHECK"].Value = "True"; } else { ugr.Cells["CHECK"].Value = "False"; } } } private void ultraTabControl1_Click(object sender, EventArgs e) { if (this.ultraTabControl1.Tabs[1].Selected) //判定记录 { this.label11.Visible = false; this.comboBox4.Visible = false; this.label12.Text = "判定时间"; } if (this.ultraTabControl1.Tabs[0].Selected) //判定记录 { this.label11.Visible = true; this.comboBox4.Visible = true; this.label12.Text = "生产时间"; } } private void DoExport() { 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()); } } } }