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 QCM030504 : FrmBase { public QCM030504() { InitializeComponent(); } public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "Query": this.DoQuery(); break; case "Judge": Operate(); break; case "Cancel_Judge": cancel_judge(); 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(); string heatno = this.textBox1.Text.Trim(); string prod_type = this.comboBox3.Text.ToString(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0301.QcmJhyElementsServiceImpl"; ccp.MethodName = "getLgSRejudgeInfo"; ccp.ServerParams = new object[] { this.dateTimePicker1.Value.ToString("yyyy-MM-dd"), this.dateTimePicker2.Value.ToString("yyyy-MM-dd"), heatno, "4001LGX", prod_type, "S" }; 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 ebatchno = textBox1.Text.Trim(); string prod_type = this.comboBox3.Text.ToString(); string isvalid = "0"; if (checkBox2.Checked) { isvalid = "1"; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0301.QcmJhyElementsServiceImpl"; ccp.MethodName = "getLgSjudgeInfo"; ccp.ServerParams = new object[] { this.dateTimePicker1.Value.ToString("yyyy-MM-dd"), this.dateTimePicker2.Value.ToString("yyyy-MM-dd"), ebatchno, "4001LGX", prod_type, "S",isvalid }; 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 fixed_type_desc = ugrs.Cells["FIXED_TYPE_DESC"].Text.ToString(); if (fixed_type_desc == "") { MessageBox.Show("请输入修磨结果!"); return; } if (ugrs.Cells["FIXED_TYPE_DESC"].Text.ToString() == "全剥好" && ugrs.Cells["FIXED_THICK"].Text.ToString() == "") { MessageBox.Show("请输入修改后厚度！"); return; } string fixed_thick = ugrs.Cells["FIXED_THICK"].Text.ToString(); 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 = "LgrepairFlaw"; ccp.ServerParams = new object[] { surfaceid, ugrs.Cells["FLAW_SEQ"].Value.ToString(), flag, username, userorder, usergroup, fixed_type_desc, fixed_thick }; 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 = "findNameByMNLg"; 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 cancel_judge() { try { UltraGridRow ugr = this.ultraGrid3.ActiveRow; if (ugr == null) return; if (MessageBox.Show("是否确认撤销表面判定！", "提示", MessageBoxButtons.YesNo) == DialogResult.No) return; ArrayList list1 = new ArrayList(); list1.Add("4001LGX"); list1.Add(ugr.Cells["PROD_NAME"].Value.ToString()); list1.Add(ugr.Cells["MATERIAL_NO"].Value.ToString()); list1.Add(this.UserInfo.GetUserName());//操作人 CoreClientParam ccp = new CoreClientParam(); ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0305.QcmJudgeSurfaceServiceImpl"; ccp.MethodName = "cancelSurfaceJudge"; ccp.ServerParams = new object[] { list1 }; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); this.DoQuery(); } 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 (comboBox1.Text.Trim() == "") { MessageBox.Show("请输入检验结果！"); return; } if (comboBox2.Text.Trim() == "") { MessageBox.Show("请输入质量等级！"); return; } string is_pass = ""; string is_zl = ""; if (comboBox1.Text.ToString() == "合格") { is_pass = "1"; } else { is_pass = "2"; } if (comboBox2.Text.ToString() == "正品") { is_zl = "512601"; } else if (comboBox2.Text.ToString() == "次品") { is_zl = "512602"; } else if (comboBox2.Text.ToString() == "废品") { is_zl = "512603"; } else if (comboBox2.Text.ToString() == "协议品") { is_zl = "512604"; } else if (comboBox2.Text.ToString() == "订单外") { is_zl = "512605"; } else if (comboBox2.Text.ToString() == "待处理") { is_zl = "512606"; } list1.Add(ugr.Cells["MATERIAL_NO"].Value.ToString()); list1.Add(is_pass);//检验结果代码 list1.Add(comboBox1.Text.Trim().ToString());//检验结果 list1.Add(is_zl);//质量等级代码 list1.Add(comboBox2.Text.Trim().ToString());//质量等级名称 list1.Add(this.comboBox4.Text.ToString().Trim()); list1.Add(this.UserInfo.GetUserName());//操作人 list1.Add(this.UserInfo.GetUserOrderText());//班次 list1.Add(this.UserInfo.GetUserGroupText());//班组 list1.Add("4001LGX"); list1.Add(ugr.Cells["PROD_NAME"].Value.ToString()); list1.Add(textBox2.Text.ToString().Trim()); list1.Add(textBox3.Text.ToString().Trim()); list1.Add(textBox4.Text.ToString().Trim()); int count = 0; int i = 0; foreach (UltraGridRow ugrs in this.ultraGrid4.Rows) { if (ugrs.Cells["CHECKBOX"].Text.ToString() == "True") { int j = 2; ArrayList list = new ArrayList(); if (ugrs.Cells["PRIMARY_FLAG"].Value.ToString() == "1") i++; list.Add(ugrs.Cells["PRIMARY_FLAG"].Value.ToString()); if (ugrs.Cells["PRIMARY_FLAG"].Value.ToString() == "1") { list.Add("1"); j = j - 1; } else { 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() == "") //{ // MessageBox.Show("请输入检验位置！"); // return; //} list.Add(ugrs.Cells["FLAW_AREA"].Value.ToString()); //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()); count++; j++; list2.Add(list); } } if (count == 0 && comboBox1.Text.ToString() == "不合格") { MessageBox.Show("请录入缺陷信息并选择！"); return; } //if (i == 0 && comboBox1.Text.ToString() == "不合格") //{ // MessageBox.Show("请录入主要缺陷！"); // return; //} if (comboBox1.Text.ToString() == "合格" && list2.Count > 0) { MessageBox.Show("已录入缺陷，与所选检验结果不一致！"); return; } if (i > 1) { MessageBox.Show("请不要录入多条主要缺陷！"); return; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0305.QcmJudgeSurfaceServiceImpl"; ccp.MethodName = "doLgAddFlaw"; 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.comboBox2.Visible = false; this.ultraGrid1.DisplayLayout.Override.FilterUIType = FilterUIType.HeaderIcons; this.ultraGrid3.DisplayLayout.Override.FilterUIType = FilterUIType.HeaderIcons; this.dateTimePicker1.Value = System.DateTime.Now.AddDays(-3); this.comboBox3.SelectedIndex = 0; 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 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 vsflv = new ValueList(); ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0305.QcmJudgeSurfaceServiceImpl"; ccp.MethodName = "findSfLv"; 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_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; ValueList VFIXED_TYPE_DESC = new ValueList(); ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0305.QcmJudgeSurfaceServiceImpl"; ccp.MethodName = "GetXmResult"; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); for (int i = 0; i < ccp.SourceDataTable.Rows.Count; i++) { VFIXED_TYPE_DESC.ValueListItems.Add(ccp.SourceDataTable.Rows[i]["XMRESULT"].ToString(), ccp.SourceDataTable.Rows[i]["XMRESULT"].ToString()); } this.ultraGrid4.DisplayLayout.Bands[0].Columns["FIXED_TYPE_DESC"].ValueList = VFIXED_TYPE_DESC; ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0305.QcmJudgeSurfaceServiceImpl"; ccp.MethodName = "findFlawDataLg"; ccp.ServerParams = new object[] { "LG2" }; 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; UltraCombo uc; this.ultraCombo1.DataSource = ccp.SourceDataTable; //uc.DisplayMember = ccp.SourceDataTable.Columns["DEFECT_NAME"].ToString(); //uc.ValueMember = ccp.SourceDataTable.Columns["DEFECT_CODE"].ToString(); this.ultraGrid4.DisplayLayout.Bands[0].Columns["FLAW_DESC"].EditorComponent = ultraCombo1; DoQuery(); } private void ultraGrid3_AfterRowActivate(object sender, EventArgs e) { try { UltraGridRow ugr = this.ultraGrid3.ActiveRow; if (ugr == null) return; this.dataSet4.Clear(); string surface_id = ugr.Cells["SURFACE_ID"].Value.ToString(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0305.QcmJudgeSurfaceServiceImpl"; ccp.MethodName = "findNameByMNLg"; 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("系统出错，请联系管理人员", "警告"); } 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; } } } 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 = "findNameByMNLg"; 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) { 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.checkBox2.Visible = true; this.label11.Text = "判定时间"; } if (this.ultraTabControl1.Tabs[0].Selected) //判定记录 { this.checkBox2.Visible = false; this.label11.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()); } } } }