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 QCM030305RZ : FrmBase { public QCM030305RZ() { InitializeComponent(); } private string prodline = ""; public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "Query": this.DoQuery(); break; /*case "Judge": Operate(); break;*/ case "FB": fb(); break; case "Cancel_FB": cancel_fb(); break; case "Exit": this.Close(); break; case "Export": this.DoExport(); break; case "Export1": this.DoExport1(); break; case "Export2": this.DoExport2(); break; case "Cold_End": this.DoCold_End(); 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(); //dataSet6.Clear(); string starttime = ""; string endtime = ""; if (checkBox2.Checked) { starttime = this.dateTimePicker1.Value.ToString("yyyyMMdd"); endtime = this.dateTimePicker2.Value.AddDays(1).ToString("yyyyMMdd"); if (this.comboBox4.Text.ToString() == "全部") { if (this.dateTimePicker2.Value.AddDays(1).Subtract(this.dateTimePicker1.Value).Days > 30) { MessageBox.Show("时间范围较大，请缩小范围"); return; } } } 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 plan_no = ""; if (checkBox4.Checked) { plan_no = textBox3.Text.Trim(); //轧辊单元 } if (!checkBox2.Checked && !checkBox3.Checked && !checkBox4.Checked) { MessageBox.Show("时间、轧批号、轧辊单元必须选择其中一个条件！"); return; } string orderno = this.textBox4.Text.Trim();// 订单号 string stellname = this.textBox7.Text.Trim(); //string prodline = "连退"; string isjudge = this.comboBox4.Text.ToString(); //string stellname = this.textBox7.Text.Trim(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0303.QcmJudgeMeasureServiceImpl"; ccp.MethodName = "doQueryMaterialDetailsJ2N"; ccp.ServerParams = new object[] { starttime, endtime, sbatchno, ebatchno, orderno, plan_no, "MB", prodline, isjudge, stellname }; ccp.SourceDataTable = this.dataSet3.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); foreach (UltraGridRow ugr in this.ultraGrid3.Rows) { if (ugr.Cells["WEIGHT"].Value.ToString() == "" || ugr.Cells["WEIGHT_WGT"].Value.ToString()=="") { ugr.Cells["SIZE_QUALITY_GRD"].Appearance.BackColor = Color.Yellow; ugr.Cells["EXTSHAPE_QUALITY_GRD"].Appearance.BackColor = Color.Yellow; } else if (double.Parse(ugr.Cells["WEIGHT"].Value.ToString()) > double.Parse(ugr.Cells["WEIGHT_WGT"].Value.ToString()))//卷重大于磅重 { ugr.Cells["SIZE_QUALITY_GRD"].Appearance.BackColor = Color.Orange; ugr.Cells["EXTSHAPE_QUALITY_GRD"].Appearance.BackColor = Color.Orange; } } /*this.ultraGrid3.DisplayLayout.Bands[0].Columns["PLAN"].SortIndicator = SortIndicator.Ascending; this.ultraGrid3.DisplayLayout.Bands[0].Columns["PLAN_2"].SortIndicator = SortIndicator.Ascending;*/ /*ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0305.QcmJudgeSurfaceServiceImpl"; ccp.MethodName = "findFlawDataJ"; ccp.ServerParams = new object[] { prodline }; ccp.SourceDataTable = this.dataSet6.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);*/ /*ultraCombo1.DataSource = ccp.SourceDataTable; this.ultraGrid4.DisplayLayout.Bands[0].Columns["FLAW_DESC"].EditorComponent = ultraCombo1; this.ultraGrid4.DisplayLayout.Bands[0].Columns["FLAW_DESC"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDown; this.ultraGrid4.DisplayLayout.Bands[0].Columns["FLAW_DESC"].AutoCompleteMode = Infragistics.Win.AutoCompleteMode.SuggestAppend; this.ultraGrid4.DisplayLayout.Bands[0].Columns["FLAW_DESC"].FilterOperandDropDownItems = FilterOperandDropDownItems.CellValues;*/ //this.ultraGrid4.DisplayLayout.Bands[0].Columns["FLAW_DESC"].AllowRowFiltering = Infragistics.Win.AutoCompleteMode.Append; } 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 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(); }*/ } if (!checkBox2.Checked && !checkBox3.Checked) { MessageBox.Show("时间与轧批号必须选择其中一个条件！"); return; } string orderno = textBox4.Text.Trim(); string plan_no = ""; if (checkBox4.Checked) { plan_no = textBox3.Text.Trim(); //轧辊单元 } string stellname = this.textBox7.Text.Trim(); //string prodline = "连退"; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0305.QcmJudgeSurfaceServiceImpl"; ccp.MethodName = "GetSurfaceInfoJ"; ccp.ServerParams = new object[] { starttime, endtime, sbatchno, ebatchno, orderno, plan_no, prodline, stellname }; 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.dataSet9.Clear(); string starttime = ""; string endtime = ""; if (checkBox2.Checked) { starttime = this.dateTimePicker1.Value.ToString("yyyyMMdd"); endtime = this.dateTimePicker2.Value.ToString("yyyyMMdd"); } 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(); }*/ } if (!checkBox2.Checked && !checkBox3.Checked) { MessageBox.Show("时间与轧批号必须选择其中一个条件！"); return; } string orderno = this.textBox4.Text.Trim();// 订单号 string plan_no = ""; //产品描述 if (checkBox4.Checked) { plan_no = textBox3.Text.Trim(); //轧辊单元 } string stellname = this.textBox7.Text.Trim(); //string prodline = "连退"; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0303.QcmJudgeMeasureServiceImpl"; ccp.MethodName = "GetMeasureInfoJ"; ccp.ServerParams = new object[] { starttime, endtime, sbatchno, ebatchno, orderno, plan_no, prodline, stellname }; ccp.SourceDataTable = this.dataSet9.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); MessageBox.Show("系统出错，请联系管理人员", "警告"); } } private void DoCold_End() { foreach (UltraGridRow ugr in ultraGrid3.Rows) { if (ugr.Cells["CHECK"].Text.ToString() == "True") { CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0303.QcmJudgeMeasureServiceImpl"; ccp.MethodName = "upCold_End"; ccp.ServerParams = new object[] { ugr.Cells["MATERIAL_NO"].Value.ToString(), this.UserInfo.GetUserName().ToString() }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode == -1) { return; } ugr.Cells["CHECK"].Value = "False"; } } 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 fb() { try { List lists = new List(); foreach (UltraGridRow ugr in ultraGrid3.Rows) { if (ugr.Cells["CHECK"].Text.ToString() == "True") { if (ugr.Cells["DLIV_DIRNO"].Value.ToString() != "") { MessageBox.Show(ugr.Cells["MATERIAL_NO"].Value.ToString()+"卷已有货运指示号，不可进行封闭操作！"); return; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0303.QcmJudgeMeasureServiceImpl"; ccp.MethodName = "coiljudge_status_call_commit"; ccp.ServerParams = new object[] { ugr.Cells["PLINE_CODE"].Value.ToString() , ugr.Cells["MATERIAL_NO"].Value.ToString() , "" , "" , "" , "" , "" , "Y" , ugr.Cells["FB_REASON"].Text.ToString(),""}; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode == -1) { return; } string remark = "封闭"; CoreClientParam ccp1 = new CoreClientParam(); ccp1.ServerName = "QCM.QCM03.QCM0303.QcmJudgeMeasureServiceImpl"; ccp1.MethodName = "RZ_Record1"; ccp1.ServerParams = new object[] { ugr.Cells["MATERIAL_NO"].Value.ToString(), this.UserInfo.GetUserName().ToString(), remark, ugr.Cells["FB_REASON"].Text.ToString() }; ccp1 = this.ExecuteNonQuery(ccp1, CoreInvokeType.Internal); if (ccp1.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 cancel_fb() { try { List lists = new List(); foreach (UltraGridRow ugr in ultraGrid3.Rows) { if (ugr.Cells["CHECK"].Text.ToString() == "True") { if (ugr.Cells["DLIV_DIRNO"].Value.ToString() != "") { MessageBox.Show(ugr.Cells["MATERIAL_NO"].Value.ToString() + "卷已有货运指示号，不可进行封闭操作！"); return; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0303.QcmJudgeMeasureServiceImpl"; ccp.MethodName = "coiljudge_status_call_commit"; ccp.ServerParams = new object[] { ugr.Cells["PLINE_CODE"].Value.ToString() , ugr.Cells["MATERIAL_NO"].Value.ToString() , "" , "" , "" , "" , "" , "N" , ugr.Cells["FB_REASON"].Text.ToString(),""}; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode == -1) { return; } string remark = "取消封闭"; CoreClientParam ccp1 = new CoreClientParam(); ccp1.ServerName = "QCM.QCM03.QCM0303.QcmJudgeMeasureServiceImpl"; ccp1.MethodName = "RZ_Record1"; ccp1.ServerParams = new object[] { ugr.Cells["MATERIAL_NO"].Value.ToString(), this.UserInfo.GetUserName().ToString(), remark, ugr.Cells["FB_REASON"].Text.ToString() }; ccp1 = this.ExecuteNonQuery(ccp1, CoreInvokeType.Internal); if (ccp1.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 label9_Click(object sender, EventArgs e) { } public static bool IsNumberal(string input) { bool flag = true; int count = 0; int count1 = 0; if (input.Length == 0) { flag = false; } else { char[] x = input.ToCharArray(); for (int i = 0; i < input.Length; i++) { if (!char.IsNumber(x[i]) && x[i] != '.' && x[i] != '-') { flag = false; break; } if (x[i] == '.') { count++; if (i == 0 || i == input.Length - 1) flag = false; } if (x[i] == '-') { count1++; if (i > 1) flag = false; } } if (count > 1 || count1 > 1) flag = false; } return flag; } public void initCoilDefect() { try { //缺陷 ArrayList alt = new ArrayList(); alt.Add("UIB030110_021N.SELECT"); //alt.Add("UIB030110_022.SELECT"); this.ultraCombo1Dataset.Tables[0].Clear(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.COMMUNAL.ComDBQueryQCM"; ccp.MethodName = "doSimpleQuery"; ccp.ServerParams = new object[] { alt }; ccp.SourceDataTable = this.ultraCombo1Dataset.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); //ccp.SourceDataTable = this.ultraCombo1Dataset.Tables[0].Merge(this.ultraCombo1Dataset.Tables[2]); //进程 alt = new ArrayList(); alt.Add("UIB030110_01.INIT_SELECT"); this.dataSet11.Tables[0].Clear(); ccp = new CoreClientParam(); ccp.ServerName = "QCM.COMMUNAL.ComDBQueryQCM"; ccp.MethodName = "doSimpleQuery"; ccp.ServerParams = new object[] { alt }; ccp.SourceDataTable = this.dataSet11.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } private void QCM030305RZ_Load(object sender, EventArgs e) { //获取自定义参数 if (!this.CustomInfo.Equals("")) { prodline = this.CustomInfo; } //this.comboBox3.SelectedIndex = 0; this.comboBox4.SelectedIndex = 0; //string prodline = "连退"; this.ultraGrid1.DisplayLayout.Override.FilterUIType = FilterUIType.HeaderIcons; this.ultraGrid3.DisplayLayout.Override.FilterUIType = FilterUIType.HeaderIcons; this.dateTimePicker1.Value = System.DateTime.Now.AddDays(-3); 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; initCoilDefect(); if (this.UserInfo.GetUserID().ToString() == "X07755" || this.UserInfo.GetUserID().ToString() == "llei" || this.UserInfo.GetUserID().ToString() == "X07743" || this.UserInfo.GetUserID().ToString() == "X07748" || this.UserInfo.GetUserID().ToString() == "X07745" || this.UserInfo.GetUserID().ToString() == "X07793" || this.UserInfo.GetUserID().ToString() == "X00437" || this.UserInfo.GetUserID().ToString() == "X07842" || this.UserInfo.GetUserID().ToString() == "X35126" || this.UserInfo.GetUserID().ToString() == "X07797" || this.UserInfo.GetUserID().ToString() == "X22746" || this.UserInfo.GetUserID().ToString() == "1") { this.button4.Visible = true; } else { this.button4.Visible = false; } if (this.UserInfo.GetUserID().ToString() == "X07832" || this.UserInfo.GetUserID().ToString() == "X07784" || this.UserInfo.GetUserID().ToString() == "X07799" || this.UserInfo.GetUserID().ToString() == "X07809" || this.UserInfo.GetUserID().ToString() == "X07835" || this.UserInfo.GetUserID().ToString() == "X07816" || this.UserInfo.GetUserID().ToString() == "X07823" || this.UserInfo.GetUserID().ToString() == "X07802") { this.button4.Visible = false; this.button1.Visible = false; this.button2.Visible = false; this.button3.Visible = false; } ValueList spm_appoint = new ValueList(); spm_appoint.ValueListItems.Add("",""); spm_appoint.ValueListItems.Add("1", "平整"); spm_appoint.ValueListItems.Add("2", "分卷"); spm_appoint.ValueListItems.Add("3","平整分卷"); spm_appoint.ValueListItems.Add("4", "重卷"); spm_appoint.ValueListItems.Add("5", "开卷检查"); spm_appoint.ValueListItems.Add("D", "完成"); spm_appoint.ValueListItems.Add("S", "综合判定"); this.ultraGrid3.DisplayLayout.Bands[0].Columns["SPM_APPOINT_SYS"].ValueList = spm_appoint; ValueList ponpse_unit = new ValueList(); ponpse_unit.ValueListItems.Add("操作类", "操作类"); ponpse_unit.ValueListItems.Add("设备类", "设备类"); ponpse_unit.ValueListItems.Add("生产计划类", "生产计划类"); ponpse_unit.ValueListItems.Add("工艺类", "工艺类"); ponpse_unit.ValueListItems.Add("其他类", "其他类"); this.ultraGrid3.DisplayLayout.Bands[0].Columns["RSEPON_UNIT"].ValueList = ponpse_unit; /* 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 = "findJFlawArea"; 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 = "findJFlawPosDesc"; 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 vsflv1 = 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++) { vsflv1.ValueListItems.Add(ccp.SourceDataTable.Rows[i]["SM_CD"].ToString(), ccp.SourceDataTable.Rows[i]["SM_CFNM"].ToString()); } this.ultraGrid3.DisplayLayout.Bands[0].Columns["SIZE_QUALITY_GRD"].ValueList = vsflv1; ValueList vsflv2 = 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++) { vsflv2.ValueListItems.Add(ccp.SourceDataTable.Rows[i]["SM_CD"].ToString(), ccp.SourceDataTable.Rows[i]["SM_CFNM"].ToString()); } this.ultraGrid3.DisplayLayout.Bands[0].Columns["EXTSHAPE_QUALITY_GRD"].ValueList = vsflv2; /*ValueList VFLAW_SIZE_DESC = new ValueList(); ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0305.QcmJudgeSurfaceServiceImpl"; ccp.MethodName = "findJFlawSizeDesc"; 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 = "findJFlawLvDesc"; 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 = "findJFlawDirDesc"; 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 = "findFlawDataJ"; //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; ////this.ultraGrid4.DisplayLayout.Bands[0].Columns["FLAW_DESC"].EditorComponent = VDEFECT_DESC; //UltraCombo uc; //uc = new UltraCombo(); //uc.BindingContext = this.BindingContext; //uc.DataSource = ccp.SourceDataTable; //this.ultraGrid4.DisplayLayout.Bands[0].Columns["FLAW_DESC"].ValueList = new BindableValueList(ccp.SourceDataTable, "", "DEFECT_NAME", "DEFECT_CODE", this.ultraGrid4); //DoQuery(); /*this.ultraGrid3.DisplayLayout.UseFixedHeaders = true; this.ultraGrid3.DisplayLayout.Bands[0].Columns[1].Header.Fixed = true; this.ultraGrid3.DisplayLayout.Bands[0].Columns[1].Header.FixedHeaderIndicator = FixedHeaderIndicator.None; /*this.ultraGrid3.DisplayLayout.Override.AllowRowSummaries = AllowRowSummaries.True; this.ultraGrid3.DisplayLayout.Override.SummaryDisplayArea =SummaryDisplayAreas.GroupByRowsFooter | SummaryDisplayAreas.TopFixed;*/ } private void ultraGrid3_AfterRowActivate(object sender, EventArgs e) { try { UltraGridRow ugr = this.ultraGrid3.ActiveRow; 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.dataSet7.Clear(); string material_no = ugr.Cells["MATERIAL_NO"].Value.ToString(); CoreClientParam ccp1 = new CoreClientParam(); ccp1.ServerName = "QCM.QCM03.QCM0303.QcmJudgeMeasureServiceImpl"; ccp1.MethodName = "getToleranceJ"; ccp1.ServerParams = new object[] { design_key, material_no }; ccp1.SourceDataTable = this.dataSet7.Tables[0]; this.ExecuteQueryToDataTable(ccp1, CoreInvokeType.Internal); /*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.ultraTabControl1.Tabs[2].Selected) //判定记录 { this.label11.Visible = false; this.comboBox4.Visible = false; this.label12.Text = "判定时间"; /*this.label5.Visible = false; this.textBox3.Visible = false; this.checkBox4.Visible = false;*/ } if (this.ultraTabControl1.Tabs[0].Selected) //判定记录 { /*this.label5.Visible = true; this.textBox3.Visible = true;*/ this.label11.Visible = true; this.comboBox4.Visible = true; this.label12.Text = "生产时间"; //this.checkBox4.Visible = true; } } 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()); } } private void button1_Click(object sender, EventArgs e) { //DoQuery(); } private void ultraGrid4_InitializeLayout(object sender, InitializeLayoutEventArgs e) { } private void ultraGrid2_AfterRowActivate(object sender, EventArgs e) { try { UltraGridRow ugr = this.ultraGrid2.ActiveRow; if (ugr == null) return; this.dataSet10.Clear(); string sic = ugr.Cells["SIC_ID"].Value.ToString(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0303.QcmJudgeMeasureServiceImpl"; ccp.MethodName = "getToleranceInfoNew"; ccp.ServerParams = new object[] { sic }; ccp.SourceDataTable = this.dataSet10.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); this.dataSet8.Clear(); ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0303.QcmJudgeMeasureServiceImpl"; ccp.MethodName = "getQcmJudgeMeasureJ"; ccp.ServerParams = new object[] { sic }; ccp.SourceDataTable = this.dataSet8.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); MessageBox.Show("系统出错，请联系管理人员", "警告"); } } private void ultraGrid2_InitializeLayout(object sender, InitializeLayoutEventArgs e) { } private void DoExport1() { 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 DoExport2() { 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()); } } private void button3_Click(object sender, EventArgs e) { try { /*int count = 0; foreach (UltraGridRow ugr in this.ultraGrid3.Rows) { if (ugr.Cells["CHECK"].Text.ToString() == "True") { count++; } }*/ List lists = new List(); foreach (UltraGridRow ugr in ultraGrid3.Rows) { int x = 1; if (ugr.Cells["CHECK"].Text.ToString() == "True") { ArrayList list4 = new ArrayList(); List list5 = new List(); string ss = ugr.Cells["EXTSHAPE_QUALITY_GRD"].Text.ToString(); if (ugr.Cells["EXTSHAPE_QUALITY_GRD"].Text.ToString() == "") { MessageBox.Show("请选择表面质量等级"); return; } //if (comboBox2.Text.Trim() == "") //{ // MessageBox.Show("请输入质量等级！"); // return; //} string is_pass = ""; string is_zl = ""; string result_extshape = ""; /*if (comboBox3.Text.ToString() == "合格") { is_pass = "1"; } else if (comboBox3.Text.ToString() == "不合格") { is_pass = "2"; } else if (comboBox3.Text.ToString() == "待判") { is_pass = "0"; } else { is_pass = ""; } if (comboBox5.Text.ToString() == "正品") { is_zl = "512601"; } else if (comboBox5.Text.ToString() == "次品") { is_zl = "512602"; } else if (comboBox5.Text.ToString() == "废品") { is_zl = "512603"; } else if (comboBox5.Text.ToString() == "协议品") { is_zl = "512604"; } else if (comboBox5.Text.ToString() == "订单外") { is_zl = "512605"; } else if (comboBox5.Text.ToString() == "待处理") { is_zl = "512606"; }*/ if (ugr.Cells["EXTSHAPE_QUALITY_GRD"].Text.ToString() == "正品") { is_pass = "1"; is_zl = "512601"; result_extshape = "合格"; } else if (ugr.Cells["EXTSHAPE_QUALITY_GRD"].Text.ToString() == "次品") { is_zl = "512602"; is_pass = "2"; result_extshape = "不合格"; } else if (ugr.Cells["EXTSHAPE_QUALITY_GRD"].Text.ToString() == "废品") { is_zl = "512603"; is_pass = "2"; result_extshape = "不合格"; } else if (ugr.Cells["EXTSHAPE_QUALITY_GRD"].Text.ToString() == "协议品") { is_zl = "512604"; is_pass = "2"; result_extshape = "不合格"; } else if (ugr.Cells["EXTSHAPE_QUALITY_GRD"].Text.ToString() == "订单外") { is_zl = "512605"; is_pass = "2"; result_extshape = "不合格"; } else if (ugr.Cells["EXTSHAPE_QUALITY_GRD"].Text.ToString() == "待处理") { is_zl = "512606"; is_pass = "0"; result_extshape = "待判"; } string is_zl_gc = ""; if (ugr.Cells["SIZE_QUALITY_GRD"].Text.ToString() == "正品") { is_zl_gc = "512601"; } else if (ugr.Cells["SIZE_QUALITY_GRD"].Text.ToString() == "次品") { is_zl_gc = "512602"; } else if (ugr.Cells["SIZE_QUALITY_GRD"].Text.ToString() == "废品") { is_zl_gc = "512603"; } else if (ugr.Cells["SIZE_QUALITY_GRD"].Text.ToString() == "协议品") { is_zl_gc = "512604"; } else if (ugr.Cells["SIZE_QUALITY_GRD"].Text.ToString() == "订单外") { is_zl_gc = "512605"; } else if (ugr.Cells["SIZE_QUALITY_GRD"].Text.ToString() == "待处理") { is_zl_gc = "512606"; } if (/*!((ugr.Cells["EXTSHAPE_QUALITY_GRD"].Text.ToString() == "正品" && ugr.Cells["SIZE_QUALITY_GRD"].Text.ToString() == "正品") || (ugr.Cells["EXTSHAPE_QUALITY_GRD"].Text.ToString() == "待处理" && ugr.Cells["SIZE_QUALITY_GRD"].Text.ToString() == "待处理") ||*/ !((is_zl == "512601" || is_zl == "512606") && (is_zl_gc == "512601" || is_zl_gc == "512606")) && (ugr.Cells["CRK_CD1"].Text.ToString() == "" || ugr.Cells["CRK_CD1"].Value == null)) { MessageBox.Show(ugr.Cells["MATERIAL_NO"].Value.ToString() + "卷质量等级不合格，请选择缺陷", "提示"); return; } list4.Add(ugr.Cells["MATERIAL_NO"].Value.ToString()); list4.Add(is_pass);//检验结果代码 list4.Add(result_extshape);//检验结果 list4.Add(is_zl);//质量等级代码 list4.Add(ugr.Cells["EXTSHAPE_QUALITY_GRD"].Text.ToString());//质量等级名称 list4.Add(""); list4.Add(this.UserInfo.GetUserName());//操作人 list4.Add(this.UserInfo.GetUserOrderText());//班次 list4.Add(this.UserInfo.GetUserGroupText());//班组 int count1 = 0; int i = 0; if (ugr.Cells["CRK_YN"].Text.ToString() == "Y") { for (int c1 = 1; c1 < 6 && ugr.Cells["CRK_CD" + c1].Text.ToString()!=""; c1++) { ArrayList list = new ArrayList(); if (ugr.Cells["QUEXIAN_TP"].Value.ToString() == "") { MessageBox.Show("请选择缺陷来源次！", "提示"); return; } list.Add(""); list.Add(c1); list.Add(ugr.Cells["CRK_CD" + c1].Text.ToString() == "" ? ugr.Cells["CRK_CD" + c1].Text.ToString() : ugr.Cells["CRK_CD" + c1].Value.ToString()); list.Add(ugr.Cells["CRK_CD" + c1].Text.ToString()); list.Add(""); list.Add(""); list.Add(""); list.Add(""); list.Add(""); list.Add(""); list.Add(""); list.Add(""); list.Add(""); list.Add(""); list.Add(""); list.Add(""); list.Add(ugr.Cells["QUEXIAN_TP"].Value.ToString()); list5.Add(list); } } /*foreach (UltraGridRow ugrs in this.ultraGrid4.Rows) { if (ugrs.Cells["CHECKBOX"].Text.ToString() == "True") { int j = 2; ArrayList list = new ArrayList(); if (ugrs.Cells["QUEXIAN_TP"].Value.ToString() == "") { MessageBox.Show("请选择缺陷来源次！", "提示"); return; } 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() == "上表面") { 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 if (ugrs.Cells["FLAW_AREA"].Text.ToString() == "钢卷侧面") { list.Add("A"); } else if (ugrs.Cells["FLAW_AREA"].Text.ToString() == "上下表面都有，且不对称") { list.Add("N"); } else if (ugrs.Cells["FLAW_AREA"].Text.ToString() == "上下表面都有，且对称") { list.Add("S"); } else if (ugrs.Cells["FLAW_AREA"].Text.ToString() == "上凸下凹") { list.Add("T"); } else if (ugrs.Cells["FLAW_AREA"].Text.ToString() == "上凹下凸") { list.Add("B"); } else if (ugrs.Cells["FLAW_AREA"].Text.ToString() == "已跟踪去重卷切除") { list.Add("C"); } 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 (!IsNumberal(ugrs.Cells["FLAW_QUANTITY"].Text)) //{ // MessageBox.Show("数量请输入数字！"); // return; //} list.Add(ugrs.Cells["FLAW_QUANTITY"].Text.ToString()); list.Add(ugrs.Cells["MEMO"].Text.ToString()); if (ugrs.Cells["IS_REPAIR"].Text.ToString() == "") { list.Add("0"); } else { list.Add(ugrs.Cells["IS_REPAIR"].Value.ToString()); } list.Add(ugrs.Cells["QUEXIAN_TP"].Value.ToString()); count1++; j++; list5.Add(list); ugr.Cells["CRK_CD" + x++].Value = ugrs.Cells["FLAW_DESC"].Text.ToString() == "" ? ugrs.Cells["FLAW_DESC"].Text.ToString() : ugrs.Cells["FLAW_DESC"].Value.ToString(); } }*/ /*if (count1 == 0 && comboBox3.Text.ToString() == "不合格") { MessageBox.Show("请录入缺陷信息并选择！"); return; } if (i == 0 && comboBox3.Text.ToString() == "不合格") { MessageBox.Show("请录入主要缺陷！"); return; }*/ //if (i > 1) //{ // MessageBox.Show("请不要录入多条主要缺陷！"); // return; //} /*if ((comboBox3.Text.ToString() == "合格" && comboBox5.Text.ToString() != "正品") || (comboBox3.Text.ToString() == "不合格" && comboBox5.Text.ToString() == "正品")) { MessageBox.Show("检验结果与质量等级不一致！"); return; }*/ CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0305.QcmJudgeSurfaceServiceImpl"; ccp.MethodName = "doAddFlawJ"; ccp.ServerParams = new object[] { list5, list4 }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode == -1) { return; } } if (ugr.Cells["CHECK"].Text.ToString() == "True" && ugr.Cells["CRK_YN"].Text.ToString() == "Y") { int jx = 1; CoreClientParam ccp = new CoreClientParam(); Hashtable ht = new Hashtable(); ht.Add("i" + jx, ugr.Cells["MATERIAL_NO"].Text.ToString()); jx++;//钢卷号 if (true.Equals(IsNumberal(ugr.Cells["CRK_CD1"].Value.ToString()))) { ht.Add("i" + jx, ugr.Cells["CRK_CD1"].Value.ToString()); jx++; //缺陷1 } else { ht.Add("i" + jx, ""); jx++; //缺陷1 } if (true.Equals(IsNumberal(ugr.Cells["CRK_CD2"].Value.ToString()))) { ht.Add("i" + jx, ugr.Cells["CRK_CD2"].Value.ToString()); jx++; //缺陷2 } else { ht.Add("i" + jx, ""); jx++; //缺陷2 } if (true.Equals(IsNumberal(ugr.Cells["CRK_CD3"].Value.ToString()))) { ht.Add("i" + jx, ugr.Cells["CRK_CD3"].Value.ToString()); jx++; //缺陷3 } else { ht.Add("i" + jx, ""); jx++; //缺陷3 } if (true.Equals(IsNumberal(ugr.Cells["CRK_CD4"].Value.ToString()))) { ht.Add("i" + jx, ugr.Cells["CRK_CD4"].Value.ToString()); jx++; //缺陷4 } else { ht.Add("i" + jx, ""); jx++; //缺陷4 } if (true.Equals(IsNumberal(ugr.Cells["CRK_CD5"].Value.ToString()))) { ht.Add("i" + jx, ugr.Cells["CRK_CD5"].Value.ToString()); jx++; //缺陷5 } else { ht.Add("i" + jx, ""); jx++; //缺陷5 } /*ht.Add("i" + jx, ugr.Cells["CRK_CD1"].Value.ToString()); jx++; //缺陷1 ht.Add("i" + jx, ugr.Cells["CRK_CD2"].Value.ToString()); jx++; //缺陷2 ht.Add("i" + jx, ugr.Cells["CRK_CD3"].Value.ToString()); jx++; //缺陷3 ht.Add("i" + jx, ugr.Cells["CRK_CD4"].Value.ToString()); jx++; //缺陷4 ht.Add("i" + jx, ugr.Cells["CRK_CD5"].Value.ToString()); jx++; //缺陷5*/ ht.Add("i" + jx, "热轧缺陷录入"); jx++;//操作标志 ht.Add("o" + jx, ""); jx = 1; ccp.ServerName = "QCM.COMMUNAL.ComDBProcedureQCM"; ccp.MethodName = "doXmlProcedure"; ccp.ServerParams = new object[] { "UIB030110_RZQXLR.CALL", ht }; this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); ArrayList all = ccp.ReturnObject as ArrayList; if (all[0].ToString() != "YY")//确认是否存在问题 { MessageBox.Show(all[0].ToString(), "提示"); } } /* if (ugr.Cells["EXTSHAPE_YN"].Text.ToString() == "Y") { int jx = 1; CoreClientParam ccp = new CoreClientParam(); Hashtable ht = new Hashtable(); string ss = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss").Replace("/", "").Replace(":", "").Replace("-", "").Replace(".", "").Replace(" ", ""); ht.Add("i" + jx, ugr.Cells["MATERIAL_NO"].Text); jx++;//钢卷号 ht.Add("i" + jx, ugr.Cells["EXTSHAPE_QUALITY_GRD"].Value.ToString()); ht.Add("i" + jx, ""); ht.Add("i" + jx, this.UserInfo.GetUserName().ToString()); jx++;//操作人 ht.Add("i" + jx, ss); jx++;// ht.Add("i" + jx, "热轧外观质量等级录入"); jx++;//操作标志 ht.Add("o" + jx, ""); jx = 1; ccp.ServerName = "QCM.COMMUNAL.ComDBProcedureQCM"; ccp.MethodName = "doXmlProcedure"; ccp.ServerParams = new object[] { "UIB030110_RZSJXG.CALL", ht }; this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); ugr.Cells["EXTSHAPE_YN"].Value = ""; ArrayList all = ccp.ReturnObject as ArrayList; if (all[0].ToString() != "YY")//确认是否存在问题 { MessageBox.Show(all[0].ToString(), "提示"); } }*/ if (ugr.Cells["CHECK"].Text.ToString() == "True") { string ss = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss").Replace("/", "").Replace(":", "").Replace("-", "").Replace(".", "").Replace(" ", ""); int jx = 1; CoreClientParam ccp = new CoreClientParam(); Hashtable ht = new Hashtable(); ht.Add("i" + jx, "热轧"); jx++;//产线 ht.Add("i" + jx, ugr.Cells["MATERIAL_NO"].Text); jx++;//钢卷号 ht.Add("i" + jx, this.UserInfo.GetUserName().ToString()); jx++;// ht.Add("i" + jx, ss); jx++;// ht.Add("o" + jx, ""); jx = 1; ccp.ServerName = "QCM.COMMUNAL.ComDBProcedureQCM"; ccp.MethodName = "doXmlProcedure"; ccp.ServerParams = new object[] { "UIB030110_WAIGUAN.CALL", ht }; this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); ArrayList all = ccp.ReturnObject as ArrayList; if (all[0].ToString() != "YY")//确认是否存在问题 { MessageBox.Show(all[0].ToString(), "提示"); } } } foreach (UltraGridRow ugr in this.ultraGrid3.Rows) { if (ugr.Cells["CHECK"].Text.ToString() == "True") { if ((ugr.Cells["VAL"].Value.ToString() != "" && ugr.Cells["VAL_2"].Value.ToString() != "") && (ugr.Cells["VAL2"].Value.ToString() != "" && ugr.Cells["VAL2_2"].Value.ToString() != "")) { ArrayList list1 = new ArrayList(); List list2 = new List(); List list3 = new List(); list1.Add(ugr.Cells["DESIGN_KEY"].Value.ToString()); list1.Add(ugr.Cells["MATERIAL_NO"].Value.ToString()); if (ugr.Cells["SIZE_QUALITY_GRD"].Text.ToString() == "待处理") { list1.Add("0"); list1.Add("待判"); } else if (ugr.Cells["SIZE_QUALITY_GRD"].Text.ToString() == "正品") { list1.Add(""); list1.Add(""); } else { list1.Add("2"); list1.Add("不合格"); } //else //{ // if (comboBox1.Text.ToString() == "合格") // { // list1.Add("1"); // list1.Add("合格"); // } // else if (comboBox1.Text.ToString() == "不合格") // { // list1.Add("2"); // list1.Add("不合格"); // } // else // { // list1.Add("0"); // list1.Add("待判"); // } //} string ss = ugr.Cells["SIZE_QUALITY_GRD"].Text.ToString(); if (ugr.Cells["SIZE_QUALITY_GRD"].Text.ToString() == "") { MessageBox.Show("请选择公差质量等级", "提示"); return; } string is_zl = ""; if (ugr.Cells["SIZE_QUALITY_GRD"].Text.ToString() == "正品") { is_zl = "512601"; } else if (ugr.Cells["SIZE_QUALITY_GRD"].Text.ToString() == "次品") { is_zl = "512602"; } else if (ugr.Cells["SIZE_QUALITY_GRD"].Text.ToString() == "废品") { is_zl = "512603"; } else if (ugr.Cells["SIZE_QUALITY_GRD"].Text.ToString() == "协议品") { is_zl = "512604"; } else if (ugr.Cells["SIZE_QUALITY_GRD"].Text.ToString() == "订单外") { is_zl = "512605"; } else if (ugr.Cells["SIZE_QUALITY_GRD"].Text.ToString() == "待处理") { is_zl = "512606"; } list1.Add(""); list1.Add(this.UserInfo.GetUserName()); list1.Add(this.UserInfo.GetUserOrderText()); list1.Add(this.UserInfo.GetUserGroupText()); list1.Add(is_zl);//质量等级代码 list1.Add(ugr.Cells["SIZE_QUALITY_GRD"].Text.ToString());//质量等级名称 ArrayList list = new ArrayList(); if (ugr.Cells["BIAS_CODE"].Text.ToString() == "" || ugr.Cells["BIAS_CODE_2"].Text.ToString() == "") { MessageBox.Show(ugr.Cells["MATERIAL_NO"].Value.ToString() + "卷没有判定标准"); return; } list.Add(ugr.Cells["BIAS_CODE"].Text.ToString()); list.Add(ugr.Cells["VAL"].Text.ToString()); list.Add(ugr.Cells["BIAS_NAME"].Text.ToString()); list.Add(ugr.Cells["PLAN"].Text.ToString()); list.Add(ugr.Cells["VAL2"].Text.ToString()); list2.Add(list); list = new ArrayList(); list.Add(ugr.Cells["BIAS_CODE_2"].Text.ToString()); list.Add(ugr.Cells["VAL_2"].Text.ToString()); list.Add(ugr.Cells["BIAS_NAME_2"].Text.ToString()); list.Add(ugr.Cells["PLAN_2"].Text.ToString()); list.Add(ugr.Cells["VAL2_2"].Text.ToString()); list2.Add(list); ArrayList listc1 = new ArrayList(); listc1.Add("传动侧"); listc1.Add(ugr.Cells["THICK_VAL1"].Text.ToString()); listc1.Add(ugr.Cells["H_VAL1"].Value.ToString()); listc1.Add(ugr.Cells["M_VAL1"].Value.ToString()); listc1.Add(ugr.Cells["R_VAL1"].Value.ToString()); list3.Add(listc1); listc1 = new ArrayList(); listc1.Add("中间"); listc1.Add(ugr.Cells["THICK_VAL2"].Text.ToString()); listc1.Add(ugr.Cells["H_VAL2"].Value.ToString()); listc1.Add(ugr.Cells["M_VAL2"].Value.ToString()); listc1.Add(ugr.Cells["R_VAL2"].Value.ToString()); list3.Add(listc1); listc1 = new ArrayList(); listc1.Add("操作侧"); listc1.Add(ugr.Cells["THICK_VAL3"].Text.ToString()); listc1.Add(ugr.Cells["H_VAL3"].Value.ToString()); listc1.Add(ugr.Cells["M_VAL3"].Value.ToString()); listc1.Add(ugr.Cells["R_VAL3"].Value.ToString()); list3.Add(listc1); /*if ((comboBox1.Text.ToString() == "合格" && comboBox2.Text.ToString() != "正品") || (comboBox1.Text.ToString() == "不合格" && comboBox2.Text.ToString() == "正品")) { MessageBox.Show("检验结果与质量等级不一致！"); return; }*/ CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0303.QcmJudgeMeasureServiceImpl"; ccp.MethodName = "judgeByHumanRZ"; ccp.ServerParams = new object[] { list1, list2, list3 }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode == -1) { return; } lists.Add(ugr); } else { MessageBox.Show("没有公差判定值，公差暂未判定"); return; /*else { if (comboBox1.Text.ToString() == "合格") { list1.Add("1"); list1.Add("合格"); } else if (comboBox1.Text.ToString() == "待判") { list1.Add("0"); list1.Add("待判"); } else { list1.Add("2"); list1.Add("不合格"); } } string is_zl = ""; 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"; } list1.Add(textBox5.Text.Trim().ToString()); list1.Add(this.UserInfo.GetUserName()); list1.Add(this.UserInfo.GetUserOrderText()); list1.Add(this.UserInfo.GetUserGroupText()); list1.Add(is_zl);//质量等级代码 list1.Add(comboBox2.Text.Trim().ToString());//质量等级名称 ArrayList listc1 = new ArrayList(); listc1.Add("传动侧"); listc1.Add(ugr.Cells["THICK_VAL1"].Text.ToString()); listc1.Add(ugr.Cells["H_VAL1"].Value.ToString()); listc1.Add(ugr.Cells["M_VAL1"].Value.ToString()); listc1.Add(ugr.Cells["R_VAL1"].Value.ToString()); list3.Add(listc1); listc1 = new ArrayList(); listc1.Add("中间"); listc1.Add(ugr.Cells["THICK_VAL2"].Text.ToString()); listc1.Add(ugr.Cells["H_VAL2"].Value.ToString()); listc1.Add(ugr.Cells["M_VAL2"].Value.ToString()); listc1.Add(ugr.Cells["R_VAL2"].Value.ToString()); list3.Add(listc1); listc1 = new ArrayList(); listc1.Add("操作侧"); listc1.Add(ugr.Cells["THICK_VAL3"].Text.ToString()); listc1.Add(ugr.Cells["H_VAL3"].Value.ToString()); listc1.Add(ugr.Cells["M_VAL3"].Value.ToString()); listc1.Add(ugr.Cells["R_VAL3"].Value.ToString()); list3.Add(listc1); if ((comboBox1.Text.ToString() == "合格" && comboBox2.Text.ToString() != "正品") || (comboBox1.Text.ToString() == "不合格" && comboBox2.Text.ToString() == "正品")) { MessageBox.Show("检验结果与质量等级不一致！"); return; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0303.QcmJudgeMeasureServiceImpl"; ccp.MethodName = "judgeByHumanJ"; ccp.ServerParams = new object[] { list1, list3 }; 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); } MessageBox.Show("表面公差检验登记成功！"); } catch (Exception EX) { MessageBox.Show(EX.ToString()); } } private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { } private void ultraGrid3_InitializeLayout(object sender, InitializeLayoutEventArgs e) { } private void button1_Click_1(object sender, EventArgs e) { try { int count = 0; List lists = new List(); foreach (UltraGridRow ugr in this.ultraGrid3.Rows) { if (ugr.Cells["CHECK"].Text.ToString() == "True") { if ((ugr.Cells["VAL"].Value.ToString() != "" && ugr.Cells["VAL_2"].Value.ToString() != "") && (ugr.Cells["VAL2"].Value.ToString() != "" && ugr.Cells["VAL2_2"].Value.ToString() != "")) { ArrayList list1 = new ArrayList(); List list2 = new List(); List list3 = new List(); list1.Add(ugr.Cells["DESIGN_KEY"].Value.ToString()); list1.Add(ugr.Cells["MATERIAL_NO"].Value.ToString()); if (ugr.Cells["SIZE_QUALITY_GRD"].Text.ToString() == "待处理") { list1.Add("0"); list1.Add("待判"); } else if (ugr.Cells["SIZE_QUALITY_GRD"].Text.ToString() == "正品") { list1.Add(""); list1.Add(""); } else { list1.Add("2"); list1.Add("不合格"); } //else //{ // if (comboBox1.Text.ToString() == "合格") // { // list1.Add("1"); // list1.Add("合格"); // } // else if (comboBox1.Text.ToString() == "不合格") // { // list1.Add("2"); // list1.Add("不合格"); // } // else // { // list1.Add("0"); // list1.Add("待判"); // } //} string ss = ugr.Cells["SIZE_QUALITY_GRD"].Text.ToString(); if (ugr.Cells["SIZE_QUALITY_GRD"].Text.ToString() == "") { MessageBox.Show("请选择公差质量等级","提示"); return; } string is_zl = ""; if (ugr.Cells["SIZE_QUALITY_GRD"].Text.ToString() == "正品") { is_zl = "512601"; } else if (ugr.Cells["SIZE_QUALITY_GRD"].Text.ToString() == "次品") { is_zl = "512602"; } else if (ugr.Cells["SIZE_QUALITY_GRD"].Text.ToString() == "废品") { is_zl = "512603"; } else if (ugr.Cells["SIZE_QUALITY_GRD"].Text.ToString() == "协议品") { is_zl = "512604"; } else if (ugr.Cells["SIZE_QUALITY_GRD"].Text.ToString() == "订单外") { is_zl = "512605"; } else if (ugr.Cells["SIZE_QUALITY_GRD"].Text.ToString() == "待处理") { is_zl = "512606"; } if (!(ugr.Cells["SIZE_QUALITY_GRD"].Text.ToString() == "正品"||ugr.Cells["SIZE_QUALITY_GRD"].Text.ToString() == "待处理") && ugr.Cells["CRK_CD1" ].Text.ToString() == "") { MessageBox.Show(ugr.Cells["MATERIAL_NO"].Value.ToString() + "卷公差质量等级不合格，请选择尺寸缺陷","提示"); return; } if (ugr.Cells["CRK_YN"].Text.ToString() == "Y") { int jx = 1; CoreClientParam ccp1 = new CoreClientParam(); Hashtable ht = new Hashtable(); ht.Add("i" + jx, ugr.Cells["MATERIAL_NO"].Text.ToString()); jx++;//钢卷号 /*ht.Add("i" + jx, ugr.Cells["CRK_CD1"].Value.ToString()); jx++; //缺陷1 ht.Add("i" + jx, ugr.Cells["CRK_CD2"].Value.ToString()); jx++; //缺陷2 ht.Add("i" + jx, ugr.Cells["CRK_CD3"].Value.ToString()); jx++; //缺陷3 ht.Add("i" + jx, ugr.Cells["CRK_CD4"].Value.ToString()); jx++; //缺陷4 ht.Add("i" + jx, ugr.Cells["CRK_CD5"].Value.ToString()); jx++; //缺陷5 */ if (true.Equals(IsNumberal(ugr.Cells["CRK_CD1"].Value.ToString()))) { ht.Add("i" + jx, ugr.Cells["CRK_CD1"].Value.ToString()); jx++; //缺陷1 } else { ht.Add("i" + jx, ""); jx++; //缺陷1 } if (true.Equals(IsNumberal(ugr.Cells["CRK_CD2"].Value.ToString()))) { ht.Add("i" + jx, ugr.Cells["CRK_CD2"].Value.ToString()); jx++; //缺陷2 } else { ht.Add("i" + jx, ""); jx++; //缺陷2 } if (true.Equals(IsNumberal(ugr.Cells["CRK_CD3"].Value.ToString()))) { ht.Add("i" + jx, ugr.Cells["CRK_CD3"].Value.ToString()); jx++; //缺陷3 } else { ht.Add("i" + jx, ""); jx++; //缺陷3 } if (true.Equals(IsNumberal(ugr.Cells["CRK_CD4"].Value.ToString()))) { ht.Add("i" + jx, ugr.Cells["CRK_CD4"].Value.ToString()); jx++; //缺陷4 } else { ht.Add("i" + jx, ""); jx++; //缺陷4 } if (true.Equals(IsNumberal(ugr.Cells["CRK_CD5"].Value.ToString()))) { ht.Add("i" + jx, ugr.Cells["CRK_CD5"].Value.ToString()); jx++; //缺陷5 } else { ht.Add("i" + jx, ""); jx++; //缺陷5 } ht.Add("i" + jx, "热轧缺陷录入"); jx++;//操作标志 ht.Add("o" + jx, ""); jx = 1; ccp1.ServerName = "QCM.COMMUNAL.ComDBProcedureQCM"; ccp1.MethodName = "doXmlProcedure"; ccp1.ServerParams = new object[] { "UIB030110_RZQXLR.CALL", ht }; this.ExecuteNonQuery(ccp1, CoreInvokeType.Internal); ugr.Cells["CRK_YN"].Value = ""; ArrayList all = ccp1.ReturnObject as ArrayList; if (all[0].ToString() != "YY")//确认是否存在问题 { MessageBox.Show(all[0].ToString(), "提示"); return; } } list1.Add(""); list1.Add(this.UserInfo.GetUserName()); list1.Add(this.UserInfo.GetUserOrderText()); list1.Add(this.UserInfo.GetUserGroupText()); list1.Add(is_zl);//质量等级代码 list1.Add(ugr.Cells["SIZE_QUALITY_GRD"].Text.ToString());//质量等级名称 ArrayList list = new ArrayList(); if (ugr.Cells["BIAS_CODE"].Text.ToString() == "" || ugr.Cells["BIAS_CODE_2"].Text.ToString() == "") { MessageBox.Show(ugr.Cells["MATERIAL_NO"].Value.ToString() + "卷没有判定标准"); return; } if (ugr.Cells["CRK_YN"].Text.ToString() == "Y") { for (int c1 = 1; c1 < 6 && ugr.Cells["CRK_CD" + c1].Text.ToString() != ""; c1++) { } } list.Add(ugr.Cells["BIAS_CODE"].Text.ToString()); list.Add(ugr.Cells["VAL"].Text.ToString()); list.Add(ugr.Cells["BIAS_NAME"].Text.ToString()); list.Add(ugr.Cells["PLAN"].Text.ToString()); list.Add(ugr.Cells["VAL2"].Text.ToString()); list2.Add(list); list = new ArrayList(); list.Add(ugr.Cells["BIAS_CODE_2"].Text.ToString()); list.Add(ugr.Cells["VAL_2"].Text.ToString()); list.Add(ugr.Cells["BIAS_NAME_2"].Text.ToString()); list.Add(ugr.Cells["PLAN_2"].Text.ToString()); list.Add(ugr.Cells["VAL2_2"].Text.ToString()); list2.Add(list); ArrayList listc1 = new ArrayList(); listc1.Add("传动侧"); listc1.Add(ugr.Cells["THICK_VAL1"].Text.ToString()); listc1.Add(ugr.Cells["H_VAL1"].Value.ToString()); listc1.Add(ugr.Cells["M_VAL1"].Value.ToString()); listc1.Add(ugr.Cells["R_VAL1"].Value.ToString()); list3.Add(listc1); listc1 = new ArrayList(); listc1.Add("中间"); listc1.Add(ugr.Cells["THICK_VAL2"].Text.ToString()); listc1.Add(ugr.Cells["H_VAL2"].Value.ToString()); listc1.Add(ugr.Cells["M_VAL2"].Value.ToString()); listc1.Add(ugr.Cells["R_VAL2"].Value.ToString()); list3.Add(listc1); listc1 = new ArrayList(); listc1.Add("操作侧"); listc1.Add(ugr.Cells["THICK_VAL3"].Text.ToString()); listc1.Add(ugr.Cells["H_VAL3"].Value.ToString()); listc1.Add(ugr.Cells["M_VAL3"].Value.ToString()); listc1.Add(ugr.Cells["R_VAL3"].Value.ToString()); list3.Add(listc1); /*if ((comboBox1.Text.ToString() == "合格" && comboBox2.Text.ToString() != "正品") || (comboBox1.Text.ToString() == "不合格" && comboBox2.Text.ToString() == "正品")) { MessageBox.Show("检验结果与质量等级不一致！"); return; }*/ CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0303.QcmJudgeMeasureServiceImpl"; ccp.MethodName = "judgeByHumanRZ"; ccp.ServerParams = new object[] { list1, list2, list3 }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode == -1) { return; } lists.Add(ugr); } else { ArrayList list1 = new ArrayList(); List list3 = new List(); list1.Add(ugr.Cells["DESIGN_KEY"].Value.ToString()); list1.Add(ugr.Cells["MATERIAL_NO"].Value.ToString()); if (ugr.Cells["SIZE_QUALITY_GRD"].Text.ToString() != "") { MessageBox.Show("请输入公差判定值！"); return; } } } /* if (ugr.Cells["CHECK"].Text.ToString() == "True" && ugr.Cells["SIZE_YN"].Text.ToString() == "Y") { int jx = 1; CoreClientParam ccp = new CoreClientParam(); Hashtable ht = new Hashtable(); string ss = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss").Replace("/", "").Replace(":", "").Replace("-", "").Replace(".", "").Replace(" ", ""); ht.Add("i" + jx, ugr.Cells["MATERIAL_NO"].Text); jx++;//钢卷号 ht.Add("i" + jx, ugr.Cells["SIZE_QUALITY_GRD"].Value.ToString()); ht.Add("i" + jx, ""); ht.Add("i" + jx, this.UserInfo.GetUserName().ToString()); jx++;//操作人 ht.Add("i" + jx, ss); jx++;// ht.Add("i" + jx, "热轧公差质量等级录入"); jx++;//操作标志 ht.Add("o" + jx, ""); jx = 1; ccp.ServerName = "QCM.COMMUNAL.ComDBProcedureQCM"; ccp.MethodName = "doXmlProcedure"; ccp.ServerParams = new object[] { "UIB030110_RZSJXG.CALL", ht }; this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); ugr.Cells["SIZE_YN"].Value = ""; ArrayList all = ccp.ReturnObject as ArrayList; if (all[0].ToString() != "YY")//确认是否存在问题 { MessageBox.Show(all[0].ToString(), "提示"); } }*/ } for (int i = 0; i < lists.Count; i++) { lists[i].Delete(false); } MessageBox.Show("公差检验登记成功！"); } catch (Exception EX) { MessageBox.Show(EX.ToString()); } } private void button2_Click(object sender, EventArgs e) { try { /*int count = 0; foreach (UltraGridRow ugr in this.ultraGrid3.Rows) { if (ugr.Cells["CHECK"].Text.ToString() == "True") { count++; } }*/ List lists = new List(); foreach (UltraGridRow ugr in ultraGrid3.Rows) { //int x = 1; if (ugr.Cells["CHECK"].Text.ToString() == "True") { /*if ((ugr.Cells["VAL"].Value.ToString() == "" || ugr.Cells["VAL_2"].Value.ToString() == "") || (ugr.Cells["VAL2"].Value.ToString() == "" || ugr.Cells["VAL2_2"].Value.ToString() == "")) { MessageBox.Show("公差判定值为空，请对判定值进行输机操作再判定或者单独进行表面判定","提示"); return; }*/ ArrayList list4 = new ArrayList(); List list5 = new List(); string ss = ugr.Cells["EXTSHAPE_QUALITY_GRD"].Text.ToString(); if (ugr.Cells["EXTSHAPE_QUALITY_GRD"].Text.ToString() == "") { MessageBox.Show("请选择表面质量等级"); return; } //if (comboBox2.Text.Trim() == "") //{ // MessageBox.Show("请输入质量等级！"); // return; //} string is_pass = ""; string is_zl = ""; string result_extshape = ""; /*if (comboBox3.Text.ToString() == "合格") { is_pass = "1"; } else if (comboBox3.Text.ToString() == "不合格") { is_pass = "2"; } else if (comboBox3.Text.ToString() == "待判") { is_pass = "0"; } else { is_pass = ""; }*/ if (ugr.Cells["EXTSHAPE_QUALITY_GRD"].Text.ToString() == "正品") { is_pass = "1"; is_zl = "512601"; result_extshape = "合格"; } else if (ugr.Cells["EXTSHAPE_QUALITY_GRD"].Text.ToString() == "次品") { is_zl = "512602"; is_pass = "2"; result_extshape = "不合格"; } else if (ugr.Cells["EXTSHAPE_QUALITY_GRD"].Text.ToString() == "废品") { is_zl = "512603"; is_pass = "2"; result_extshape = "不合格"; } else if (ugr.Cells["EXTSHAPE_QUALITY_GRD"].Text.ToString() == "协议品") { is_zl = "512604"; is_pass = "2"; result_extshape = "不合格"; } else if (ugr.Cells["EXTSHAPE_QUALITY_GRD"].Text.ToString() == "订单外") { is_zl = "512605"; is_pass = "2"; result_extshape = "不合格"; } else if (ugr.Cells["EXTSHAPE_QUALITY_GRD"].Text.ToString() == "待处理") { is_zl = "512606"; is_pass = "0"; result_extshape = "待判"; } if (!(ugr.Cells["EXTSHAPE_QUALITY_GRD"].Text.ToString() == "正品" || ugr.Cells["EXTSHAPE_QUALITY_GRD"].Text.ToString() == "待处理" || is_zl == "512601" || is_zl == "512606" ) && (ugr.Cells["CRK_CD1"].Text.ToString() == "" || ugr.Cells["CRK_CD1"].Value == null)) { MessageBox.Show(ugr.Cells["MATERIAL_NO"].Value.ToString() + "卷表面质量等级不合格，请选择外观缺陷", "提示"); return; } list4.Add(ugr.Cells["MATERIAL_NO"].Value.ToString()); list4.Add(is_pass);//检验结果代码 list4.Add(result_extshape);//检验结果 list4.Add(is_zl);//质量等级代码 list4.Add(ugr.Cells["EXTSHAPE_QUALITY_GRD"].Text.ToString());//质量等级名称 list4.Add("");//检验备注 list4.Add(this.UserInfo.GetUserName());//操作人 list4.Add(this.UserInfo.GetUserOrderText());//班次 list4.Add(this.UserInfo.GetUserGroupText());//班组 list4.Add("新表面公差检验管理(热轧)的表面检验登记按钮"); int count1 = 0; int i = 0; if (ugr.Cells["CRK_YN"].Text.ToString()=="Y") { for (int c1 = 1; c1 < 6 && ugr.Cells["CRK_CD" + c1].Text.ToString() != ""; c1++) { ArrayList list = new ArrayList(); if (ugr.Cells["QUEXIAN_TP"].Value.ToString() == "") { MessageBox.Show("请选择缺陷来源次！", "提示"); return; } list.Add(""); list.Add(c1); list.Add(ugr.Cells["CRK_CD"+c1].Text.ToString()==""?ugr.Cells["CRK_CD"+c1].Text.ToString():ugr.Cells["CRK_CD"+c1].Value.ToString()); list.Add(ugr.Cells["CRK_CD"+c1].Text.ToString()); list.Add(""); list.Add(""); list.Add(""); list.Add(""); list.Add(""); list.Add(""); list.Add(""); list.Add(""); list.Add(""); list.Add(""); list.Add(""); list.Add(""); list.Add(ugr.Cells["QUEXIAN_TP"].Value.ToString()); list5.Add(list); } } /*foreach (UltraGridRow ugrs in this.ultraGrid4.Rows) { if (ugrs.Cells["CHECKBOX"].Text.ToString() == "True") { int j = 2; ArrayList list = new ArrayList(); if ( ugrs.Cells["QUEXIAN_TP"].Value.ToString() == "") { MessageBox.Show("请选择缺陷来源次！", "提示"); return; } 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() == "上表面") { 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 if (ugrs.Cells["FLAW_AREA"].Text.ToString() == "钢卷侧面") { list.Add("A"); } else if (ugrs.Cells["FLAW_AREA"].Text.ToString() == "上下表面都有，且不对称") { list.Add("N"); } else if (ugrs.Cells["FLAW_AREA"].Text.ToString() == "上下表面都有，且对称") { list.Add("S"); } else if (ugrs.Cells["FLAW_AREA"].Text.ToString() == "上凸下凹") { list.Add("T"); } else if (ugrs.Cells["FLAW_AREA"].Text.ToString() == "上凹下凸") { list.Add("B"); } else if (ugrs.Cells["FLAW_AREA"].Text.ToString() == "已跟踪去重卷切除") { list.Add("C"); } 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 (!IsNumberal(ugrs.Cells["FLAW_QUANTITY"].Text)) //{ // MessageBox.Show("数量请输入数字！"); // return; //} list.Add(ugrs.Cells["FLAW_QUANTITY"].Text.ToString()); list.Add(ugrs.Cells["MEMO"].Text.ToString()); if (ugrs.Cells["IS_REPAIR"].Text.ToString() == "") { list.Add("0"); } else { list.Add(ugrs.Cells["IS_REPAIR"].Value.ToString()); } list.Add(ugrs.Cells["QUEXIAN_TP"].Value.ToString()); count1++; j++; list5.Add(list); ugr.Cells["CRK_CD" + x++].Value = ugrs.Cells["FLAW_DESC"].Text.ToString() == "" ? ugrs.Cells["FLAW_DESC"].Text.ToString() : ugrs.Cells["FLAW_DESC"].Value.ToString(); } }*/ /*if (count1 == 0 && comboBox3.Text.ToString() == "不合格") { MessageBox.Show("请录入缺陷信息并选择！"); return; }*/ /*if (i == 0 && comboBox3.Text.ToString() == "不合格") { MessageBox.Show("请录入主要缺陷！"); return; }*/ //if (i > 1) //{ // MessageBox.Show("请不要录入多条主要缺陷！"); // return; //} /*if ((comboBox3.Text.ToString() == "合格" && comboBox5.Text.ToString() != "正品") || (comboBox3.Text.ToString() == "不合格" && comboBox5.Text.ToString() == "正品")) { MessageBox.Show("检验结果与质量等级不一致！"); return; }*/ CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0305.QcmJudgeSurfaceServiceImpl"; ccp.MethodName = "doAddFlawJ"; ccp.ServerParams = new object[] { list5, list4 }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode == -1) { return; } lists.Add(ugr); } if (ugr.Cells["CHECK"].Text.ToString() == "True" && ugr.Cells["CRK_YN"].Text.ToString() == "Y") { int jx = 1; CoreClientParam ccp = new CoreClientParam(); Hashtable ht = new Hashtable(); ht.Add("i" + jx, ugr.Cells["MATERIAL_NO"].Text.ToString()); jx++;//钢卷号 /*ht.Add("i" + jx, ugr.Cells["CRK_CD1"].Value.ToString()); jx++; //缺陷1 ht.Add("i" + jx, ugr.Cells["CRK_CD2"].Value.ToString()); jx++; //缺陷2 ht.Add("i" + jx, ugr.Cells["CRK_CD3"].Value.ToString()); jx++; //缺陷3 ht.Add("i" + jx, ugr.Cells["CRK_CD4"].Value.ToString()); jx++; //缺陷4 ht.Add("i" + jx, ugr.Cells["CRK_CD5"].Value.ToString()); jx++; //缺陷5 */ if (true.Equals(IsNumberal(ugr.Cells["CRK_CD1"].Value.ToString()))) { ht.Add("i" + jx, ugr.Cells["CRK_CD1"].Value.ToString()); jx++; //缺陷1 } else { ht.Add("i" + jx, ""); jx++; //缺陷1 } if (true.Equals(IsNumberal(ugr.Cells["CRK_CD2"].Value.ToString()))) { ht.Add("i" + jx, ugr.Cells["CRK_CD2"].Value.ToString()); jx++; //缺陷2 } else { ht.Add("i" + jx, ""); jx++; //缺陷2 } if (true.Equals(IsNumberal(ugr.Cells["CRK_CD3"].Value.ToString()))) { ht.Add("i" + jx, ugr.Cells["CRK_CD3"].Value.ToString()); jx++; //缺陷3 } else { ht.Add("i" + jx, ""); jx++; //缺陷3 } if (true.Equals(IsNumberal(ugr.Cells["CRK_CD4"].Value.ToString()))) { ht.Add("i" + jx, ugr.Cells["CRK_CD4"].Value.ToString()); jx++; //缺陷4 } else { ht.Add("i" + jx, ""); jx++; //缺陷4 } if (true.Equals(IsNumberal(ugr.Cells["CRK_CD5"].Value.ToString()))) { ht.Add("i" + jx, ugr.Cells["CRK_CD5"].Value.ToString()); jx++; //缺陷5 } else { ht.Add("i" + jx, ""); jx++; //缺陷5 } ht.Add("i" + jx, "热轧缺陷录入"); jx++;//操作标志 ht.Add("o" + jx, ""); jx = 1; ccp.ServerName = "QCM.COMMUNAL.ComDBProcedureQCM"; ccp.MethodName = "doXmlProcedure"; ccp.ServerParams = new object[] { "UIB030110_RZQXLR.CALL", ht }; this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); ugr.Cells["CRK_YN"].Value = ""; ArrayList all = ccp.ReturnObject as ArrayList; if (all[0].ToString() != "YY")//确认是否存在问题 { MessageBox.Show(all[0].ToString(), "提示"); return; } } /*--if (ugr.Cells["CHECK"].Text.ToString() == "True" && ugr.Cells["EXTSHAPE_YN"].Text.ToString() == "Y") { int jx = 1; CoreClientParam ccp = new CoreClientParam(); Hashtable ht = new Hashtable(); string ss = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss").Replace("/", "").Replace(":", "").Replace("-", "").Replace(".", "").Replace(" ", ""); ht.Add("i" + jx, ugr.Cells["MATERIAL_NO"].Text); jx++;//钢卷号 ht.Add("i"+jx ,ugr.Cells["EXTSHAPE_QUALITY_GRD"].Value.ToString()); ht.Add("i"+jx ,""); ht.Add("i" + jx, this.UserInfo.GetUserName().ToString()); jx++;//操作人 ht.Add("i" + jx, ss); jx++;// ht.Add("i" + jx, "热轧外观质量等级录入"); jx++;//操作标志 ht.Add("o" + jx, ""); jx = 1; ccp.ServerName = "QCM.COMMUNAL.ComDBProcedureQCM"; ccp.MethodName = "doXmlProcedure"; ccp.ServerParams = new object[] { "UIB030110_RZSJXG.CALL", ht }; this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); ugr.Cells["EXTSHAPE_YN"].Value = ""; ArrayList all = ccp.ReturnObject as ArrayList; if (all[0].ToString() != "YY")//确认是否存在问题 { MessageBox.Show(all[0].ToString(), "提示"); } }*/ if (ugr.Cells["CHECK"].Text.ToString() == "True") { string ss = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss").Replace("/", "").Replace(":", "").Replace("-", "").Replace(".", "").Replace(" ", ""); int jx = 1; CoreClientParam ccp = new CoreClientParam(); Hashtable ht = new Hashtable(); ht.Add("i" + jx, "热轧"); jx++;//产线 ht.Add("i" + jx, ugr.Cells["MATERIAL_NO"].Text.ToString()); jx++;//钢卷号 ht.Add("i" + jx, this.UserInfo.GetUserName().ToString()); jx++;// ht.Add("i" + jx, ss); jx++;// ht.Add("o" + jx, ""); jx = 1; ccp.ServerName = "QCM.COMMUNAL.ComDBProcedureQCM"; ccp.MethodName = "doXmlProcedure"; ccp.ServerParams = new object[] { "UIB030110_WAIGUAN.CALL", ht }; this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); ArrayList all = ccp.ReturnObject as ArrayList; if (all[0].ToString() != "YY")//确认是否存在问题 { MessageBox.Show(all[0].ToString(), "提示"); return; } } } 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 button4_Click(object sender, EventArgs e) { try { foreach (UltraGridRow ugr in ultraGrid3.Rows) { if (ugr.Cells["CHECK"].Text.ToString() == "True") { /*ArrayList list4 = new ArrayList(); List list5 = new List(); list4.Add(ugr.Cells["CJ_REMARK"].Text.ToString()); list4.Add(ugr.Cells["CPCJ_REMARK"].Text.ToString()); list4.Add(ugr.Cells["SPM_RMK"].Text.ToString()); list4.Add(ugr.Cells["DEAL_REMARK"].Text.ToString()); list4.Add(ugr.Cells["MATERIAL_NO"].Text.ToString()); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0303.QcmJudgeMeasureServiceImpl"; ccp.MethodName = "upRemarks"; ccp.ServerParams = new object[] { list4 }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode == -1) { return; }*/ int jx = 1; CoreClientParam ccp = new CoreClientParam(); Hashtable ht = new Hashtable(); ht.Add("i" + jx, ugr.Cells["MATERIAL_NO"].Text.ToString()); jx++;//钢卷号 if (true.Equals(IsNumberal(ugr.Cells["CRK_CD1"].Value.ToString()))) { ht.Add("i" + jx, ugr.Cells["CRK_CD1"].Value.ToString()); jx++; //缺陷1 } else { ht.Add("i" + jx, ""); jx++; //缺陷1 } if (true.Equals(IsNumberal(ugr.Cells["CRK_CD2"].Value.ToString()))) { ht.Add("i" + jx, ugr.Cells["CRK_CD2"].Value.ToString()); jx++; //缺陷2 } else { ht.Add("i" + jx, ""); jx++; //缺陷2 } if (true.Equals(IsNumberal(ugr.Cells["CRK_CD3"].Value.ToString()))) { ht.Add("i" + jx, ugr.Cells["CRK_CD3"].Value.ToString()); jx++; //缺陷3 } else { ht.Add("i" + jx, ""); jx++; //缺陷3 } if (true.Equals(IsNumberal(ugr.Cells["CRK_CD4"].Value.ToString()))) { ht.Add("i" + jx, ugr.Cells["CRK_CD4"].Value.ToString()); jx++; //缺陷4 } else { ht.Add("i" + jx, ""); jx++; //缺陷4 } if (true.Equals(IsNumberal(ugr.Cells["CRK_CD5"].Value.ToString()))) { ht.Add("i" + jx, ugr.Cells["CRK_CD5"].Value.ToString()); jx++; //缺陷5 } else { ht.Add("i" + jx, ""); jx++; //缺陷5 } /*ht.Add("i" + jx, ugr.Cells["CRK_CD1"].Value.ToString()); jx++; //缺陷1 ht.Add("i" + jx, ugr.Cells["CRK_CD2"].Value.ToString()); jx++; //缺陷2 ht.Add("i" + jx, ugr.Cells["CRK_CD3"].Value.ToString()); jx++; //缺陷3 ht.Add("i" + jx, ugr.Cells["CRK_CD4"].Value.ToString()); jx++; //缺陷4 ht.Add("i" + jx, ugr.Cells["CRK_CD5"].Value.ToString()); jx++; //缺陷5*/ //ht.Add("i" + jx, ugr.Cells["QUEXIAN_TP"].Value.ToString()); jx++; //缺陷来源次 ht.Add("i" + jx, "热轧缺陷录入"); jx++;//操作标志 ht.Add("o" + jx, ""); jx = 1; ccp.ServerName = "QCM.COMMUNAL.ComDBProcedureQCM"; ccp.MethodName = "doXmlProcedure"; ccp.ServerParams = new object[] { "UIB030110_RZQXLR.CALL", ht }; this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); ugr.Cells["CRK_YN"].Value = ""; ArrayList all = ccp.ReturnObject as ArrayList; if (all[0].ToString() != "YY")//确认是否存在问题 { MessageBox.Show(all[0].ToString(), "提示"); return; } } } MessageBox.Show("缺陷录入成功"); //DoQuery(); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); MessageBox.Show("系统出错，请联系管理人员", "警告"); } } /*public static bool IsNumberal(string input) { bool flag = true; int count = 0; int count1 = 0; if (input.Length == 0) { flag = false; } else { char[] x = input.ToCharArray(); for (int i = 0; i < input.Length; i++) { if (!char.IsNumber(x[i]) && x[i] != '.' && x[i] != '-') { flag = false; break; } if (x[i] == '.') { count++; if (i == 0 || i == input.Length - 1) flag = false; } if (x[i] == '-') { count1++; if (i > 1) flag = false; } } if (count > 1 || count1 > 1) flag = false; } return flag; }*/ private void ultraGrid3_KeyDown(object sender, KeyEventArgs e) { try { if (e.KeyCode != Keys.Enter) return; //只对回车事件操作 if (this.ultraGrid3.ActiveCell==null) { MessageBox.Show("请选择具体的单元格再按回车", "提示"); return; } if (this.ultraGrid3.ActiveCell.Column.Key != "VAL"//只对判定厚度、判定宽度、备注等操作 && this.ultraGrid3.ActiveCell.Column.Key != "VAL_2" && this.ultraGrid3.ActiveCell.Column.Key != "CPCJ_REMARK" && this.ultraGrid3.ActiveCell.Column.Key != "CJ_REMARK" && this.ultraGrid3.ActiveCell.Column.Key != "DEAL_REMARK" && this.ultraGrid3.ActiveCell.Column.Key != "SPM_RMK" //20231113新增责任归属单位录入 && this.ultraGrid3.ActiveCell.Column.Key != "RSEPON_UNIT" && this.ultraGrid3.ActiveCell.Column.Key != "DETAINFO" ) return; if (this.ultraGrid3.ActiveCell.DataChanged == false) return;//无数据变更时不做修改操作 if (this.ultraGrid3.ActiveCell.Column.Key == "RSEPON_UNIT" || this.ultraGrid3.ActiveCell.Column.Key == "DETAINFO") { int jx1; jx1 = 1; CoreClientParam ccp1 = new CoreClientParam(); Hashtable ht1 = new Hashtable(); ht1.Add("i" + jx1, this.ultraGrid3.ActiveRow.Cells["MATERIAL_NO"].Text.ToString()); jx1++; //钢卷号 ht1.Add("i" + jx1, this.ultraGrid3.ActiveRow.Cells["RSEPON_UNIT"].Text.ToString()); jx1++; //责任单位 ht1.Add("i" + jx1, this.UserInfo.GetUserName().ToString()); jx1++; //录入人 ht1.Add("i" + jx1, this.ultraGrid3.ActiveRow.Cells["DETAINFO"].Text.ToString()); jx1++; //详细信息 DETAINFO ht1.Add("i" + jx1, "1"); jx1++; //缺陷5 ht1.Add("i" + jx1, "1"); jx1++; //缺陷5 //ht.Add("i" + jx, ugr.Cells["QUEXIAN_TP"].Value.ToString()); jx++; //缺陷来源次 ht1.Add("i" + jx1, "卷板责任归属单位"); jx1++;//操作标志 ht1.Add("o" + jx1, ""); jx1 = 1; ccp1.ServerName = "QCM.COMMUNAL.ComDBProcedureQCM"; ccp1.MethodName = "doXmlProcedure"; ccp1.ServerParams = new object[] { "UIB030110_RZQXLR.CALL", ht1 }; this.ExecuteNonQuery(ccp1, CoreInvokeType.Internal); ArrayList all = ccp1.ReturnObject as ArrayList; if (all[0].ToString() != "YY")//确认是否存在问题 { MessageBox.Show(all[0].ToString(), "提示"); return; } MessageBox.Show("责任归属单位录入成功"); } int jx; jx = 1; CoreClientParam ccp = new CoreClientParam(); Hashtable ht = new Hashtable(); if (this.ultraGrid3.ActiveCell.Column.Key == "VAL" || this.ultraGrid3.ActiveCell.Column.Key == "VAL_2") { string ss = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss").Replace("/", "").Replace(":", "").Replace("-", "").Replace(".", "").Replace(" ", ""); ht.Add("i" + jx, this.ultraGrid3.ActiveRow.Cells["MATERIAL_NO"].Text.ToString()); jx++;//钢卷号 ht.Add("i" + jx, this.ultraGrid3.ActiveRow.Cells["VAL"].Text); jx++;//录入厚度 ht.Add("i" + jx, this.ultraGrid3.ActiveRow.Cells["VAL_2"].Text); jx++;//录入宽度 ht.Add("i" + jx, this.UserInfo.GetUserName().ToString()); jx++;//操作人 ht.Add("i" + jx, ss); jx++; ht.Add("i" + jx, "热轧判定规格录入"); jx++;//操作标志 ht.Add("o" + jx, ""); jx = 1; ccp.ServerName = "QCM.COMMUNAL.ComDBProcedureQCM"; ccp.MethodName = "doXmlProcedure"; ccp.ServerParams = new object[] { "UIB030110_RZSJXG.CALL", ht }; this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); ArrayList all = ccp.ReturnObject as ArrayList; if (all[0].ToString() != "YY")//确认是否存在问题 { MessageBox.Show(all[0].ToString(), "提示"); } int currentColIndex = this.ultraGrid3.ActiveCell.Column.Index;//换行前获取当前列的列序号 this.ultraGrid3.PerformAction(Infragistics.Win.UltraWinGrid.UltraGridAction.NextRow); this.ultraGrid3.ActiveRow.Cells[currentColIndex].Activate(); this.ultraGrid3.PerformAction(UltraGridAction.EnterEditMode); } if (this.ultraGrid3.ActiveCell.Column.Key == "CPCJ_REMARK" || this.ultraGrid3.ActiveCell.Column.Key == "CJ_REMARK" || this.ultraGrid3.ActiveCell.Column.Key == "DEAL_REMARK" || this.ultraGrid3.ActiveCell.Column.Key == "SPM_RMK") { ArrayList list4 = new ArrayList(); List list5 = new List(); list4.Add(this.ultraGrid3.ActiveRow.Cells["CJ_REMARK"].Text.ToString()); list4.Add(this.ultraGrid3.ActiveRow.Cells["CPCJ_REMARK"].Text.ToString()); list4.Add(this.ultraGrid3.ActiveRow.Cells["SPM_RMK"].Text.ToString()); list4.Add(this.ultraGrid3.ActiveRow.Cells["DEAL_REMARK"].Text.ToString()); list4.Add(this.ultraGrid3.ActiveRow.Cells["MATERIAL_NO"].Text.ToString()); list4.Add(this.UserInfo.GetUserName().ToString()); ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0303.QcmJudgeMeasureServiceImpl"; ccp.MethodName = "upRemarks"; ccp.ServerParams = new object[] { list4 }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode == -1) { return; } MessageBox.Show("备注修改成功"); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); System.Diagnostics.Debug.WriteLine(ex.ToString()); } } private void ultraGrid3_CellChange(object sender, CellEventArgs e) { try { //string MES = ""; foreach (UltraGridRow ugr in this.ultraGrid3.Rows) { if (Convert.ToBoolean(ugr.Cells["CHECK"].Value)) { if (ugr.Cells["SPM_APPOINT_SYS"] == e.Cell) { if (this.UserInfo.GetUserID().ToString() == "X07832" || this.UserInfo.GetUserID().ToString() == "X07784" || this.UserInfo.GetUserID().ToString() == "X07799" || this.UserInfo.GetUserID().ToString() == "X07809" || this.UserInfo.GetUserID().ToString() == "X07835" || this.UserInfo.GetUserID().ToString() == "X07816" || this.UserInfo.GetUserID().ToString() == "X07823" || this.UserInfo.GetUserID().ToString() == "X07802") { MessageBox.Show("该账号没有平整权限", "提示"); return; } if ("Y".Equals(ugr.Cells["FB_YN"].Value.ToString())) { MessageBox.Show("该卷已封闭，请取消封闭后再进行平整操作", "提示"); return; } if (ugr.Cells["CUR_PROG_CD"].Value.ToString() == "SPA" || ugr.Cells["CUR_PROG_CD"].Value.ToString() == "SED" || ugr.Cells["CUR_PROG_CD"].Value.ToString() == "SPB") { CoreClientParam ccp = new CoreClientParam(); Hashtable ht = new Hashtable(); string spm_appoint ; if (ugr.Cells["SPM_APPOINT_SYS"].Text.ToString()=="平整") { spm_appoint = "1"; } else if (ugr.Cells["SPM_APPOINT_SYS"].Text.ToString() == "分卷") { spm_appoint = "2"; } else if (ugr.Cells["SPM_APPOINT_SYS"].Text.ToString() == "平整分卷") { spm_appoint = "3"; } else if (ugr.Cells["SPM_APPOINT_SYS"].Text.ToString() == "重卷") { spm_appoint = "4"; } else if (ugr.Cells["SPM_APPOINT_SYS"].Text.ToString() == "开卷检查") { spm_appoint = "5"; } else if (ugr.Cells["SPM_APPOINT_SYS"].Text.ToString() == "完成") { spm_appoint = "D"; } else if (ugr.Cells["SPM_APPOINT_SYS"].Text.ToString() == "综合判定") { spm_appoint = "S"; } else { spm_appoint = ""; } ugr.Cells["SPM_APPOINT_SYS"].Value.ToString(); ht.Add("i1", ugr.Cells["COIL_NO"].Text.ToString());//流水钢卷号 ht.Add("i2", spm_appoint);//平整分卷 ht.Add("i3", this.UserInfo.GetUserName().ToString());//操作人 ht.Add("i4", ugr.Cells["SPM_RMK"].Text.ToString());//平整备注 ht.Add("o5", ""); ccp.ServerName = "QCM.COMMUNAL.ComDBProcedureQCM"; ccp.MethodName = "doXmlProcedure"; ccp.ServerParams = new object[] { "SPM_APPOINT.CALL", ht }; this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); ArrayList all = ccp.ReturnObject as ArrayList; if (spm_appoint == "D") { string remark = "平整完成"; CoreClientParam ccp1 = new CoreClientParam(); ccp1.ServerName = "QCM.QCM03.QCM0303.QcmJudgeMeasureServiceImpl"; ccp1.MethodName = "RZ_Record"; ccp1.ServerParams = new object[] { ugr.Cells["MATERIAL_NO"].Value.ToString(), this.UserInfo.GetUserName().ToString(), remark }; ccp1 = this.ExecuteNonQuery(ccp1, CoreInvokeType.Internal); if (ccp1.ReturnCode == -1) { return; } } else if (spm_appoint == "5") { string remark = "开卷检查"; CoreClientParam ccp1 = new CoreClientParam(); ccp1.ServerName = "QCM.QCM03.QCM0303.QcmJudgeMeasureServiceImpl"; ccp1.MethodName = "RZ_Record"; ccp1.ServerParams = new object[] { ugr.Cells["MATERIAL_NO"].Value.ToString(), this.UserInfo.GetUserName().ToString(), remark }; ccp1 = this.ExecuteNonQuery(ccp1, CoreInvokeType.Internal); if (ccp1.ReturnCode == -1) { return; } } else if (spm_appoint == "4") { string remark = "重卷"; CoreClientParam ccp1 = new CoreClientParam(); ccp1.ServerName = "QCM.QCM03.QCM0303.QcmJudgeMeasureServiceImpl"; ccp1.MethodName = "RZ_Record"; ccp1.ServerParams = new object[] { ugr.Cells["MATERIAL_NO"].Value.ToString(), this.UserInfo.GetUserName().ToString(), remark }; ccp1 = this.ExecuteNonQuery(ccp1, CoreInvokeType.Internal); if (ccp1.ReturnCode == -1) { return; } } else if (spm_appoint == "3") { string remark = "平整分卷"; CoreClientParam ccp1 = new CoreClientParam(); ccp1.ServerName = "QCM.QCM03.QCM0303.QcmJudgeMeasureServiceImpl"; ccp1.MethodName = "RZ_Record"; ccp1.ServerParams = new object[] { ugr.Cells["MATERIAL_NO"].Value.ToString(), this.UserInfo.GetUserName().ToString(), remark }; ccp1 = this.ExecuteNonQuery(ccp1, CoreInvokeType.Internal); if (ccp1.ReturnCode == -1) { return; } } else if (spm_appoint == "2") { string remark = "分卷"; CoreClientParam ccp1 = new CoreClientParam(); ccp1.ServerName = "QCM.QCM03.QCM0303.QcmJudgeMeasureServiceImpl"; ccp1.MethodName = "RZ_Record"; ccp1.ServerParams = new object[] { ugr.Cells["MATERIAL_NO"].Value.ToString(), this.UserInfo.GetUserName().ToString(), remark }; ccp1 = this.ExecuteNonQuery(ccp1, CoreInvokeType.Internal); if (ccp1.ReturnCode == -1) { return; } } else if (spm_appoint == "1") { string remark = "平整"; CoreClientParam ccp1 = new CoreClientParam(); ccp1.ServerName = "QCM.QCM03.QCM0303.QcmJudgeMeasureServiceImpl"; ccp1.MethodName = "RZ_Record"; ccp1.ServerParams = new object[] { ugr.Cells["MATERIAL_NO"].Value.ToString(), this.UserInfo.GetUserName().ToString(), remark }; ccp1 = this.ExecuteNonQuery(ccp1, CoreInvokeType.Internal); if (ccp1.ReturnCode == -1) { return; } } else if (spm_appoint == "S") { string remark = "平整综合判定"; CoreClientParam ccp1 = new CoreClientParam(); ccp1.ServerName = "QCM.QCM03.QCM0303.QcmJudgeMeasureServiceImpl"; ccp1.MethodName = "RZ_Record"; ccp1.ServerParams = new object[] { ugr.Cells["MATERIAL_NO"].Value.ToString(), this.UserInfo.GetUserName().ToString(), remark }; ccp1 = this.ExecuteNonQuery(ccp1, CoreInvokeType.Internal); if (ccp1.ReturnCode == -1) { return; } } /*if (all[0].ToString() == "XX")//确认是否存在问题 { MessageBox.Show(all[0].ToString(), "提示"); }*/ MessageBox.Show("平整指定成功", "提示"); //DoQuery(); } else { MessageBox.Show("当前卷号进程不可平整指定", "提示"); } } if (ugr.Cells["CRK_CD1"] == e.Cell || ugr.Cells["CRK_CD2"] == e.Cell || ugr.Cells["CRK_CD3"] == e.Cell || ugr.Cells["CRK_CD4"] == e.Cell || ugr.Cells["CRK_CD5"] == e.Cell) { ugr.Cells["CRK_YN"].Value = "Y"; } /*if (ugr.Cells["CRK_CD1"] == e.Cell && this.ultraCombo2Dataset != null) { ugr.Cells["CRK_CD1"].EditorComponent = this.ultraCombo2; ugr.Cells["CRK_YN"].Value = "Y"; } if (ugr.Cells["CRK_CD2"] == e.Cell && this.ultraCombo2Dataset != null) { ugr.Cells["CRK_CD2"].EditorComponent = this.ultraCombo2; ugr.Cells["CRK_YN"].Value = "Y"; } if (ugr.Cells["CRK_CD3"] == e.Cell && this.ultraCombo2Dataset != null) { ugr.Cells["CRK_CD3"].EditorComponent = this.ultraCombo2; ugr.Cells["CRK_YN"].Value = "Y"; } if (ugr.Cells["CRK_CD4"] == e.Cell && this.ultraCombo2Dataset != null) { ugr.Cells["CRK_CD4"].EditorComponent = this.ultraCombo2; ugr.Cells["CRK_YN"].Value = "Y"; } if (ugr.Cells["CRK_CD5"] == e.Cell && this.ultraCombo2Dataset != null) { ugr.Cells["CRK_CD5"].EditorComponent = this.ultraCombo2; ugr.Cells["CRK_YN"].Value = "Y"; }*/ if (ugr.Cells["QUEXIAN_TP"] == e.Cell) { string lb; if (ugr.Cells["QUEXIAN_TP"].Text.ToString() == "钢质次(A)") { lb = "钢质"; } else { lb = "轧制"; } ArrayList alt = new ArrayList(); alt.Add("UIB030110_021N1.SELECT"); alt.Add(lb); //alt.Add("UIB030110_022.SELECT"); this.ultraCombo1Dataset.Tables[0].Clear(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.COMMUNAL.ComDBQueryQCM"; ccp.MethodName = "doSimpleQuery"; ccp.ServerParams = new object[] { alt }; ccp.SourceDataTable = this.ultraCombo1Dataset.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); } /*if (ugr.Cells["SIZE_QUALITY_GRD"] == e.Cell ) { ugr.Cells["EXTSHAPE_YN"].Value = "Y"; } if (ugr.Cells["EXTSHAPE_QUALITY_GRD"] == e.Cell) { ugr.Cells["SIZE_YN"].Value = "Y"; }*/ } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); System.Diagnostics.Debug.WriteLine(ex.ToString()); } } private void button5_Click(object sender, EventArgs e) { try { //缺陷 ArrayList alt = new ArrayList(); alt.Add("UIB030110_021N.SELECT"); //alt.Add("UIB030110_022.SELECT"); this.ultraCombo1Dataset.Tables[0].Clear(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.COMMUNAL.ComDBQueryQCM"; ccp.MethodName = "doSimpleQuery"; ccp.ServerParams = new object[] { alt }; ccp.SourceDataTable = this.ultraCombo1Dataset.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } /*private void ultraGrid4_CellChanged(object sender, CellEventArgs e) { try { Hashtable ht = new Hashtable(); int x = 1, x1 = 1; foreach (UltraGridRow ugrs in this.ultraGrid4.Rows) { if (ugrs.Cells["CHECKBOX"].Text.ToString() == "True") { if (ugrs.Cells["FLAW_DESC"] == e.Cell) { ht.Add("i" + x++, ugrs.Cells["FLAW_DESC"].Value.ToString()); ht.Add("i" + x++, ugrs.Cells["FLAW_DESC"].Text.ToString()); } } } /*string crk_cd1 = ""; string crk_cd2 = ""; string crk_cd3 = ""; string crk_cd4 = ""; string crk_cd5 = ""; Hashtable ht = new Hashtable(); int x = 1,x1 = 1; foreach (UltraGridRow ugrs in this.ultraGrid4.Rows) { if (ugrs.Cells["CHECKBOX"].Text.ToString() == "True") { if (ugrs.Cells["FLAW_DESC"] == e.Cell) { ht.Add("i"+x++, ugrs.Cells["FLAW_DESC"].Value.ToString());//流水钢卷号 } } } foreach (UltraGridRow ugr in this.ultraGrid3.Rows) { if (ugr.Cells["CHECK"].Text.ToString() == "True") { foreach (DictionaryEntry hl in ht) //获取文件 { //string Key = hl.Key.ToString(); //Key string Value = (string)hl.Value.ToString(); //Value ugr.Cells["CRK_CD" + (x1++)].Value = Value; } } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); System.Diagnostics.Debug.WriteLine(ex.ToString()); } } */ /*private void ultraGrid3_KeyUp(object sender, KeyEventArgs e) { int currentColIndex = this.ultraGrid3.ActiveCell.Column.Index; switch (e.KeyCode) { case Keys.Up: this.ultraGrid3.PerformAction(UltraGridAction.ExitEditMode); this.ultraGrid3.PerformAction(UltraGridAction.AboveRow); this.ultraGrid3.ActiveRow.Cells[currentColIndex].Activate(); e.Handled = true; this.ultraGrid3.PerformAction(UltraGridAction.EnterEditMode); break; case Keys.Down: this.ultraGrid3.PerformAction(UltraGridAction.ExitEditMode); this.ultraGrid3.PerformAction(UltraGridAction.NextRow); this.ultraGrid3.ActiveRow.Cells[currentColIndex].Activate(); e.Handled = true; this.ultraGrid3.PerformAction(UltraGridAction.EnterEditMode); break; case Keys.Right: this.ultraGrid3.PerformAction(UltraGridAction.ExitEditMode); this.ultraGrid3.PerformAction(UltraGridAction.NextCell); e.Handled = true; this.ultraGrid3.PerformAction(UltraGridAction.EnterEditMode); break; case Keys.Left: this.ultraGrid3.PerformAction(UltraGridAction.ExitEditMode); this.ultraGrid3.PerformAction(UltraGridAction.PrevCell); e.Handled = true; this.ultraGrid3.PerformAction(UltraGridAction.EnterEditMode); break; } }*/ } }