using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using CoreFS.CA06; using Infragistics.Win.UltraWinGrid; using System.Diagnostics; using System.Collections; using Newtonsoft.Json; namespace Core.LZMes.Client.QCM { public partial class QCM030604 : FrmBase { public QCM030604() { InitializeComponent(); } public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "Query": this.DoQuery(); break; case "Judge": this.Judge(); break; case "Cancel": this.canceljudge(); break; case "Ex_warehouse": this.Ex_warehouse(); break; case "Cancel_Ex_warehouse": this.Cancel_Ex_warehouse(); break; case "Send_memo": this.sendMemo(); break; case "Exit": this.Close(); break; case "Export": this.DoExport(); break; case "JudgedLG"://判定记录中的待判 this.JudgedLG(); break; case "CancelJudged"://判定记录中的取消待判 this.CancelJudged(); break; } } private void CancelJudged() { try { if (this.ultraTabControl1.SelectedTab.Index == 1) { UltraGridRow ugr = this.ultraGrid5.ActiveRow; string heatNo = ugr.Cells["HEAT_NO"].Value.ToString();//炉号 string userName = this.UserInfo.GetUserName();//操作人 int num = 0; string MATERIAL_NO = "["; foreach (UltraGridRow ugr1 in this.ultraGrid2.Rows) { if (ugr1.Cells["checked"].Text.ToString() == "True") { if (num == 0) { MATERIAL_NO += '"' + ugr1.Cells["MATERIAL_NO"].Value.ToString() + '"'; } if (num != 0) { MATERIAL_NO += "," + '"' + ugr1.Cells["MATERIAL_NO"].Value.ToString() + '"'; } num++; } } MATERIAL_NO += "]"; if (num == 0) { this.alert("未勾选待判数据"); return; } Dictionary openWith = new Dictionary(); openWith.Add("FLAG", "1");//取消待判 openWith.Add("HEAT_NO", heatNo); openWith.Add("USER_NAME", userName); openWith.Add("MATERIAL_NO", MATERIAL_NO); string sbb = JsonConvert.SerializeObject(openWith).ToString(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0302.QcmJudgePhysicalServiceImpl"; ccp.MethodName = "JudgedLG"; ccp.ServerParams = new object[] { sbb }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode == -1) { return; } MessageBox.Show("取消待判成功！"); DoQuery(); } else { var dataSource = new List(); string heatNo = ""; string userName = this.UserInfo.GetUserName();//操作人 int num = 0; string MATERIAL_NO = "["; foreach (UltraGridRow ugr1 in this.ultraGrid1.Rows) { if (ugr1.Cells["checked"].Text.ToString() == "True") { heatNo = ugr1.Cells["HEAT_NO"].Value.ToString();//炉号 dataSource.Add(heatNo); if (num == 0) { MATERIAL_NO += '"' + ugr1.Cells["MATERIAL_NO"].Value.ToString() + '"'; } if (num != 0) { MATERIAL_NO += "," + '"' + ugr1.Cells["MATERIAL_NO"].Value.ToString() + '"'; } num++; } } MATERIAL_NO += "]"; if (num == 0) { this.alert("未勾选待判数据"); return; } var uniqueData = dataSource.Distinct(); int unum = 0; foreach (var item in uniqueData) { unum = unum + 1; } if (unum >= 2) { this.alert("只能勾选同炉号请核实数据!"); return; } Dictionary openWith = new Dictionary(); openWith.Add("FLAG", "1");//取消待判 openWith.Add("HEAT_NO", heatNo); openWith.Add("USER_NAME", userName); openWith.Add("MATERIAL_NO", MATERIAL_NO); string sbb = JsonConvert.SerializeObject(openWith).ToString(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0302.QcmJudgePhysicalServiceImpl"; ccp.MethodName = "JudgedLG"; ccp.ServerParams = new object[] { sbb }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode == -1) { return; } MessageBox.Show("取消待判成功！"); DoQuery(); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); MessageBox.Show("系统出错，请联系管理人员", "警告"); } } private void JudgedLG() { try { if (this.ultraTabControl1.SelectedTab.Index == 1) { UltraGridRow ugr = this.ultraGrid5.ActiveRow; string heatNo = ugr.Cells["HEAT_NO"].Value.ToString();//炉号 string userName = this.UserInfo.GetUserName();//操作人 //ArrayList material_no = new ArrayList(); int num = 0; string MATERIAL_NO = "["; foreach (UltraGridRow ugr1 in this.ultraGrid2.Rows) { if (ugr1.Cells["checked"].Text.ToString() == "True") { if (num==0) { MATERIAL_NO += '"'+ugr1.Cells["MATERIAL_NO"].Value.ToString()+'"'; } if (num != 0) { MATERIAL_NO +=","+ '"' + ugr1.Cells["MATERIAL_NO"].Value.ToString() + '"'; } num++; } } MATERIAL_NO += "]"; if (num==0) { this.alert("未勾选待判数据"); return; } Dictionary openWith = new Dictionary(); openWith.Add("FLAG", "0");//待判 openWith.Add("HEAT_NO", heatNo); openWith.Add("USER_NAME", userName); openWith.Add("MATERIAL_NO", MATERIAL_NO); string sbb = JsonConvert.SerializeObject(openWith).ToString(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0302.QcmJudgePhysicalServiceImpl"; ccp.MethodName = "JudgedLG"; ccp.ServerParams = new object[] { sbb }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode == -1) { return; } MessageBox.Show("待判成功！"); DoQuery(); } else { var dataSource = new List(); string heatNo = ""; string userName = this.UserInfo.GetUserName();//操作人 int num = 0; string MATERIAL_NO = "["; foreach (UltraGridRow ugr1 in this.ultraGrid1.Rows) { if (ugr1.Cells["checked"].Text.ToString() == "True") { heatNo = ugr1.Cells["HEAT_NO"].Value.ToString();//炉号 dataSource.Add(heatNo); if (num == 0) { MATERIAL_NO += '"' + ugr1.Cells["MATERIAL_NO"].Value.ToString() + '"'; } if (num != 0) { MATERIAL_NO += "," + '"' + ugr1.Cells["MATERIAL_NO"].Value.ToString() + '"'; } num++; } } MATERIAL_NO += "]"; if (num == 0) { this.alert("未勾选待判数据"); return; } var uniqueData = dataSource.Distinct(); int unum = 0; foreach (var item in uniqueData) { unum = unum + 1; } if (unum >= 2) { this.alert("只能勾选同炉号请核实数据!"); return; } Dictionary openWith = new Dictionary(); openWith.Add("FLAG", "0");//待判 openWith.Add("HEAT_NO", heatNo); openWith.Add("USER_NAME", userName); openWith.Add("MATERIAL_NO", MATERIAL_NO); string sbb = JsonConvert.SerializeObject(openWith).ToString(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0302.QcmJudgePhysicalServiceImpl"; ccp.MethodName = "JudgedLG"; ccp.ServerParams = new object[] { sbb }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode == -1) { return; } MessageBox.Show("待判成功！"); DoQuery(); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); MessageBox.Show("系统出错，请联系管理人员", "警告"); } } private void Ex_warehouse() { ArrayList material_no = new ArrayList(); foreach (UltraGridRow ugr in this.ultraGrid2.Rows) { if (ugr.Cells["checked"].Text.ToString() == "True") { //if (ugr.Cells["ISFX"].Text.ToString() == "是") //{ // MessageBox.Show("物料号" + ugr.Cells["MATERIAL_NO"].Value.ToString() + "已经出库放行！"); // return; //} material_no.Add(ugr.Cells["MATERIAL_NO"].Value.ToString()); } } string username = this.UserInfo.GetUserName(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0302.QcmJudgePhysicalServiceImpl"; ccp.MethodName = "ex_warehouse"; ccp.ServerParams = new object[] { username, material_no, "4001LGX", "J" }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode == -1) { MessageBox.Show("出库放行失败！"); return; } MessageBox.Show("出库放行成功！"); DoQuery(); } private void Cancel_Ex_warehouse() { ArrayList material_no = new ArrayList(); foreach (UltraGridRow ugr in this.ultraGrid2.Rows) { if (ugr.Cells["checked"].Text.ToString() == "True") { if (ugr.Cells["ISFX"].Text.ToString() != "是") { MessageBox.Show("物料号" + ugr.Cells["MATERIAL_NO"].Value.ToString() + "未出库！"); return; } material_no.Add(ugr.Cells["MATERIAL_NO"].Value.ToString()); } } string username = this.UserInfo.GetUserName(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0302.QcmJudgePhysicalServiceImpl"; ccp.MethodName = "cancel_ex_warehouse"; ccp.ServerParams = new object[] { username, material_no, "4001LGX", "J" }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode == -1) { MessageBox.Show("撤销出库放行失败！"); return; } MessageBox.Show("撤销出库放行成功！"); DoQuery(); } private void Judge() { try { ArrayList material_no = new ArrayList(); string username = this.UserInfo.GetUserName(); ArrayList prod_name = new ArrayList(); foreach (UltraGridRow ugr in this.ultraGrid1.Rows) { if (ugr.Cells["checked"].Text.ToString() == "True") { material_no.Add(ugr.Cells["MATERIAL_NO"].Value.ToString()); prod_name.Add(ugr.Cells["PROD_NAME"].Value.ToString()); } } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0302.QcmJudgePhysicalServiceImpl"; ccp.MethodName = "LgultimateJudgeAuto"; ccp.ServerParams = new object[] { material_no, username, "4001LGX", prod_name }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode == -1) { return; } MessageBox.Show("综合判定成功！"); DoQuery(); } catch (Exception EX) { MessageBox.Show(EX.ToString()); } } private void canceljudge() { try { ArrayList material_no = new ArrayList(); string username = this.UserInfo.GetUserName(); string again_judge_type = ""; foreach (UltraGridRow ugr in this.ultraGrid2.Rows) { if (ugr.Cells["checked"].Text.ToString() == "True") { material_no.Add(ugr.Cells["MATERIAL_NO"].Value.ToString()); } } if (material_no.Count == 0) { MessageBox.Show("请在判定记录中选择需要撤销判定的产品！"); return; } QCM030605 frm = new QCM030605(); if (frm.ShowDialog() == DialogResult.OK) { again_judge_type = frm.Results; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0302.QcmJudgePhysicalServiceImpl"; ccp.MethodName = "cancelLgUltimateJudge"; ccp.ServerParams = new object[] { username, material_no, again_judge_type }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); DoQuery(); } } catch (Exception EX) { MessageBox.Show(EX.ToString()); } } private void sendMemo() { try { if (this.ultraTabControl1.Tabs[0].Selected) //待判信息 { ArrayList material_no = new ArrayList(); string username = this.UserInfo.GetUserName(); foreach (UltraGridRow ugr in this.ultraGrid1.Rows) { if (ugr.Cells["checked"].Text.ToString() == "True") { material_no.Add(ugr.Cells["MATERIAL_NO"].Value.ToString()); } } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0302.QcmJudgePhysicalServiceImpl"; ccp.MethodName = "findLg2_1"; ccp.ServerParams = new object[] { }; ccp = this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); DataTable table1 = ccp.SourceDataTable; ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0302.QcmJudgePhysicalServiceImpl"; ccp.MethodName = "findLg2_2"; ccp.ServerParams = new object[] { }; ccp = this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); DataTable table2 = ccp.SourceDataTable; QCM030606 frm = new QCM030606(table1, table2); if (frm.ShowDialog() == DialogResult.OK) { ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0302.QcmJudgePhysicalServiceImpl"; ccp.MethodName = "ex_remark"; ccp.ServerParams = new object[] { username, material_no, "4001LGX", "板坯", frm._noRedSendReason, frm._noRedirectSendReason, frm._ischk, frm._memo }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); DoQuery(); } } if (this.ultraTabControl1.Tabs[1].Selected) //判定记录 { ArrayList material_no = new ArrayList(); ArrayList utm_id = new ArrayList(); string username = this.UserInfo.GetUserName(); foreach (UltraGridRow ugr in this.ultraGrid2.Rows) { if (ugr.Cells["checked"].Text.ToString() == "True") { material_no.Add(ugr.Cells["MATERIAL_NO"].Value.ToString()); utm_id.Add(ugr.Cells["UTM_ID"].Value.ToString()); } } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0302.QcmJudgePhysicalServiceImpl"; ccp.MethodName = "findLg2_1"; ccp.ServerParams = new object[] { }; ccp = this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); DataTable table1 = ccp.SourceDataTable; ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0302.QcmJudgePhysicalServiceImpl"; ccp.MethodName = "findLg2_2"; ccp.ServerParams = new object[] { }; ccp = this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); DataTable table2 = ccp.SourceDataTable; QCM030606 frm = new QCM030606(table1, table2); if (frm.ShowDialog() == DialogResult.OK) { ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0302.QcmJudgePhysicalServiceImpl"; ccp.MethodName = "ex_remark1"; ccp.ServerParams = new object[] { username, material_no, utm_id, "4001LGX", "板坯", frm._noRedSendReason, frm._noRedirectSendReason, frm._ischk, frm._memo }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); DoQuery(); } } } catch (Exception EX) { MessageBox.Show(EX.ToString()); } } private void DoQuery() { if (this.ultraTabControl1.Tabs[0].Selected) //待判信息 { DoQueryMe(); } if (this.ultraTabControl1.Tabs[1].Selected) //判定记录 { DoQueryRe(); } } //查询待判信息 private void DoQueryMe() { try { this.dataSet1.Clear(); string bbatchno = textBox1.Text.Trim(); string prod_name = this.comboBox2.Text.ToString(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0301.QcmJhyElementsServiceImpl"; ccp.MethodName = "getLgZRejudgeInfo"; ccp.ServerParams = new object[] { this.dateTimePicker1.Value.ToString("yyyy-MM-dd"), this.dateTimePicker2.Value.ToString("yyyy-MM-dd"), bbatchno, "4001LGX", prod_name, "J" }; ccp.SourceDataTable = this.dataSet1.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); foreach (UltraGridRow ugr in this.ultraGrid1.Rows) { if (ugr.Cells["SURFACERESULT_DESC"].Text.ToString() == "") { ugr.Cells["SURFACERESULT_DESC"].Appearance.BackColor = Color.Red; } if (ugr.Cells["R_CHEMRESULT_DESC"].Text.ToString() == "") { ugr.Cells["R_CHEMRESULT_DESC"].Appearance.BackColor = Color.Red; } } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); MessageBox.Show("系统出错，请联系管理人员", "警告"); } } //查询判定记录 private void DoQueryRe() { try { this.dataSet14.Clear(); string bbatchno = textBox1.Text.Trim(); //string prod_name = this.comboBox2.Text.ToString(); //string isvalid = "0"; //this.label20.Text = ""; //if (checkBox1.Checked) //{ // isvalid = "1"; //} CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0301.QcmJhyElementsServiceImpl"; ccp.MethodName = "GetHeatProcessInfo"; ccp.ServerParams = new object[] { this.dateTimePicker1.Value.ToString("yyyy-MM-dd"), this.dateTimePicker2.Value.ToString("yyyy-MM-dd"), bbatchno, "4001LGX"}; ccp.SourceDataTable = this.dataSet14.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); //for (int i = 0; i < ccp.SourceDataTable.Rows.Count; i++) //{ // foreach (UltraGridRow ugr2 in this.ultraGrid2.Rows) // { // if (ugr2.Cells["UTM_RESULT_DESC"].Value.ToString() == "合格") // { // ugr2.Cells["UTM_RESULT_DESC"].Appearance.BackColor = Color.FromArgb(185, 235, 204); // ugr2.Cells["UTM_RESULT_DESC"].Appearance.ForeColor = Color.Black; // } // else // { // ugr2.Cells["UTM_RESULT_DESC"].Appearance.BackColor = Color.FromArgb(249, 198, 186); // ugr2.Cells["UTM_RESULT_DESC"].Appearance.ForeColor = Color.Black; // } // } //} } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); MessageBox.Show("系统出错，请联系管理人员", "警告"); } } private void ultraGrid1_AfterRowActivate(object sender, EventArgs e) { DoQueryR(); DoQueryS();//表面信息 } private void DoQueryS() { try { UltraGridRow ugr = this.ultraGrid1.ActiveRow; if (ugr == null) return; this.dataSet7.Clear(); if (ugr.Cells["SURFACEID"].Text.ToString() == "") { return; } string surface_id = ugr.Cells["SURFACEID"].Value.ToString(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0305.QcmJudgeSurfaceServiceImpl"; ccp.MethodName = "findNameByMN"; ccp.ServerParams = new object[] { surface_id }; ccp.SourceDataTable = this.dataSet7.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); MessageBox.Show("系统出错，请联系管理人员", "警告"); } } private void DoQueryR() { try { UltraGridRow ugr = this.ultraGrid1.ActiveRow; if (ugr == null) return; this.dataSet9.Clear(); if (ugr.Cells["R_CHEMID"].Text.ToString() == "") { return; } string cic_id = ugr.Cells["R_CHEMID"].Value.ToString(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0301.QcmJhyElementsServiceImpl"; ccp.MethodName = "GetLgRChemeResult"; ccp.ServerParams = new object[] { cic_id }; ccp.SourceDataTable = this.dataSet9.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); //ccp = new CoreClientParam(); //ccp.ServerName = "QCM.QCM03.QCM0301.QcmJhyElementsServiceImpl"; //ccp.MethodName = "GetCheme"; //ccp.ServerParams = new object[] { cic_id }; //this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); //for (int i = 0; i < ccp.SourceDataTable.Rows.Count; i++) //{ // foreach (UltraGridRow ugr5 in this.ultraGrid10.Rows) // { // if (ugr5.Cells[ccp.SourceDataTable.Rows[i]["phy_code_s"].ToString()].Value.ToString().Contains(ccp.SourceDataTable.Rows[i]["stdmin"].ToString()) && ugr5.Cells[ccp.SourceDataTable.Rows[i]["phy_code_s"].ToString()].Value.ToString().Contains(ccp.SourceDataTable.Rows[i]["stdmax"].ToString())) // { // ugr5.Cells[ccp.SourceDataTable.Rows[i]["phy_code_s"].ToString()].Appearance.BackColor = Color.Red; // } // } //} UltraGridRow judge_row = null; foreach (UltraGridRow ugst in this.ultraGrid10.Rows) { if (ccp.ReturnInfo.Contains(ugst.Cells["STD_TYPE"].Text.ToString()) && ugr.Cells["R_CHEMRESULT_DESC"].Text.ToString().Trim() != "") { ugst.Appearance.BackColor = Color.Green; } if (!ugst.Cells["STD_TYPE"].Text.ToString().Contains("标准") && !ugst.Cells["STD_TYPE"].Text.ToString().Contains("要求")) { judge_row = ugst; } if (judge_row != null) { foreach (UltraGridRow ugs in this.ultraGrid10.Rows) { if (!string.IsNullOrEmpty(ugs.Cells["STD_TYPE"].Text) && (ugs.Cells["STD_TYPE"].Text.ToString() == "放行标准(熔炼)" || ugs.Cells["STD_TYPE"].Text.ToString() == "交付标准(熔炼)" || ugs.Cells["STD_TYPE"].Text.ToString() == "特殊要求(熔炼)")) { for (int i = 0; i < ugs.Cells.Count; i++) { if (!string.IsNullOrEmpty(ugs.Cells[i].Text) && ugs.Cells[i].Text.ToString().Contains(" ")) { string[] str_arr = ugs.Cells[i].Text.ToString().Replace(" ", "#").Split('#'); if (str_arr.Length == 1) { if (str_arr[0].Contains("<=") && !string.IsNullOrEmpty(judge_row.Cells[i].Text)) { if (double.Parse(str_arr[0].Replace("<=", "")) < double.Parse(judge_row.Cells[i].Text.ToString())) { judge_row.Cells[i].Appearance.BackColor = Color.Red; judge_row.Cells["STD_TYPE"].Appearance.BackColor = Color.Red; if (ugs.Cells["STD_TYPE"].Text.ToString() == "特殊要求(熔炼)") { ugs.Cells["STD_TYPE"].Appearance.BackColor = Color.Red; } } } else if (str_arr[0].Contains(">=") && !string.IsNullOrEmpty(judge_row.Cells[i].Text)) { if (double.Parse(str_arr[0].Replace(">=", "")) > double.Parse(judge_row.Cells[i].Text.ToString())) { judge_row.Cells[i].Appearance.BackColor = Color.Red; judge_row.Cells["STD_TYPE"].Appearance.BackColor = Color.Red; if (ugs.Cells["STD_TYPE"].Text.ToString() == "特殊要求(熔炼)") { ugs.Cells["STD_TYPE"].Appearance.BackColor = Color.Red; } } } else if (string.IsNullOrEmpty(judge_row.Cells[i].Text)) { judge_row.Cells[i].Appearance.BackColor = Color.Red; judge_row.Cells["STD_TYPE"].Appearance.BackColor = Color.Red; if (ugs.Cells["STD_TYPE"].Text.ToString() == "特殊要求(熔炼)") { ugs.Cells["STD_TYPE"].Appearance.BackColor = Color.Red; } } } else if (str_arr.Length == 2) { if (str_arr[0].Contains("<=") && !string.IsNullOrEmpty(judge_row.Cells[i].Text)) { if (double.Parse(str_arr[0].Replace("<=", "")) < double.Parse(judge_row.Cells[i].Text.ToString())) { judge_row.Cells[i].Appearance.BackColor = Color.Red; judge_row.Cells["STD_TYPE"].Appearance.BackColor = Color.Red; if (ugs.Cells["STD_TYPE"].Text.ToString() == "特殊要求(熔炼)") { ugs.Cells["STD_TYPE"].Appearance.BackColor = Color.Red; } } } else if (str_arr[0].Contains(">=") && !string.IsNullOrEmpty(judge_row.Cells[i].Text)) { if (double.Parse(str_arr[0].Replace(">=", "")) > double.Parse(judge_row.Cells[i].Text.ToString())) { judge_row.Cells[i].Appearance.BackColor = Color.Red; judge_row.Cells["STD_TYPE"].Appearance.BackColor = Color.Red; if (ugs.Cells["STD_TYPE"].Text.ToString() == "特殊要求(熔炼)") { ugs.Cells["STD_TYPE"].Appearance.BackColor = Color.Red; } } } if (str_arr[1].Contains("<=") && !string.IsNullOrEmpty(judge_row.Cells[i].Text)) { if (double.Parse(str_arr[1].Replace("<=", "")) < double.Parse(judge_row.Cells[i].Text.ToString())) { judge_row.Cells[i].Appearance.BackColor = Color.Red; judge_row.Cells["STD_TYPE"].Appearance.BackColor = Color.Red; if (ugs.Cells["STD_TYPE"].Text.ToString() == "特殊要求(熔炼)") { ugs.Cells["STD_TYPE"].Appearance.BackColor = Color.Red; } } } else if (str_arr[1].Contains(">=") && !string.IsNullOrEmpty(judge_row.Cells[i].Text)) { if (double.Parse(str_arr[1].Replace(">=", "")) > double.Parse(judge_row.Cells[i].Text.ToString())) { judge_row.Cells[i].Appearance.BackColor = Color.Red; judge_row.Cells["STD_TYPE"].Appearance.BackColor = Color.Red; if (ugs.Cells["STD_TYPE"].Text.ToString() == "特殊要求(熔炼)") { ugs.Cells["STD_TYPE"].Appearance.BackColor = Color.Red; } } } else if (string.IsNullOrEmpty(judge_row.Cells[i].Text)) { judge_row.Cells[i].Appearance.BackColor = Color.Red; judge_row.Cells["STD_TYPE"].Appearance.BackColor = Color.Red; if (ugs.Cells["STD_TYPE"].Text.ToString() == "特殊要求(熔炼)") { ugs.Cells["STD_TYPE"].Appearance.BackColor = Color.Red; } } } } } } } } } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); MessageBox.Show("系统出错，请联系管理人员", "警告"); } } private void QCM030604_Load(object sender, EventArgs e) { this.comboBox2.SelectedIndex = 0; this.checkBox1.Checked = true; this.checkBox1.Visible = false; this.label19.Visible = false; this.label20.Visible = false; this.ultraGrid1.DisplayLayout.Override.FilterUIType = FilterUIType.HeaderIcons; this.ultraGrid2.DisplayLayout.Override.FilterUIType = FilterUIType.HeaderIcons; this.dateTimePicker1.Value = System.DateTime.Now.AddDays(-3); } private void ultraGrid2_AfterRowActivate(object sender, EventArgs e) { DoQueryR1(); DoQueryS1();//表面信息 } private void DoQueryS1() { try { UltraGridRow ugr = this.ultraGrid2.ActiveRow; if (ugr == null) return; this.dataSet12.Clear(); if (ugr.Cells["SFU_ID"].Text.ToString() == "") { return; } string surface_id = ugr.Cells["SFU_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.dataSet12.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); MessageBox.Show("系统出错，请联系管理人员", "警告"); } } private void DoQueryR1() { try { UltraGridRow ugr = this.ultraGrid2.ActiveRow; if (ugr == null) return; this.dataSet13.Clear(); if (ugr.Cells["R_CIC_ID"].Text.ToString() == "") { return; } string cic_id = ugr.Cells["R_CIC_ID"].Value.ToString(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0301.QcmJhyElementsServiceImpl"; ccp.MethodName = "GetLgRChemeResult"; ccp.ServerParams = new object[] { cic_id }; ccp.SourceDataTable = this.dataSet13.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); //ccp = new CoreClientParam(); //ccp.ServerName = "QCM.QCM03.QCM0301.QcmJhyElementsServiceImpl"; //ccp.MethodName = "GetCheme"; //ccp.ServerParams = new object[] { cic_id }; //this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); //for (int i = 0; i < ccp.SourceDataTable.Rows.Count; i++) //{ // foreach (UltraGridRow ugr5 in this.ultraGrid10.Rows) // { // if (ugr5.Cells[ccp.SourceDataTable.Rows[i]["phy_code_s"].ToString()].Value.ToString().Contains(ccp.SourceDataTable.Rows[i]["stdmin"].ToString()) && ugr5.Cells[ccp.SourceDataTable.Rows[i]["phy_code_s"].ToString()].Value.ToString().Contains(ccp.SourceDataTable.Rows[i]["stdmax"].ToString())) // { // ugr5.Cells[ccp.SourceDataTable.Rows[i]["phy_code_s"].ToString()].Appearance.BackColor = Color.Red; // } // } //} UltraGridRow judge_row = null; foreach (UltraGridRow ugst in this.ultraGrid4.Rows) { if (ccp.ReturnInfo.Contains(ugst.Cells["STD_TYPE"].Text.ToString())) { ugst.Appearance.BackColor = Color.Green; } if (!ugst.Cells["STD_TYPE"].Text.ToString().Contains("标准") && !ugst.Cells["STD_TYPE"].Text.ToString().Contains("要求")) { judge_row = ugst; } if (judge_row != null) { foreach (UltraGridRow ugs in this.ultraGrid4.Rows) { if (!string.IsNullOrEmpty(ugs.Cells["STD_TYPE"].Text) && (ugs.Cells["STD_TYPE"].Text.ToString() == "放行标准(熔炼)" || ugs.Cells["STD_TYPE"].Text.ToString() == "交付标准(熔炼)" || ugs.Cells["STD_TYPE"].Text.ToString() == "特殊要求(熔炼)")) { for (int i = 0; i < ugs.Cells.Count; i++) { if (!string.IsNullOrEmpty(ugs.Cells[i].Text) && ugs.Cells[i].Text.ToString().Contains(" ")) { string[] str_arr = ugs.Cells[i].Text.ToString().Replace(" ", "#").Split('#'); if (str_arr.Length == 1) { if (str_arr[0].Contains("<=") && !string.IsNullOrEmpty(judge_row.Cells[i].Text)) { if (double.Parse(str_arr[0].Replace("<=", "")) < double.Parse(judge_row.Cells[i].Text.ToString())) { judge_row.Cells[i].Appearance.BackColor = Color.Red; if (ugs.Cells["STD_TYPE"].Text.ToString() == "特殊要求(熔炼)") { ugs.Cells["STD_TYPE"].Appearance.BackColor = Color.Red; } } } else if (str_arr[0].Contains(">=") && !string.IsNullOrEmpty(judge_row.Cells[i].Text)) { if (double.Parse(str_arr[0].Replace(">=", "")) > double.Parse(judge_row.Cells[i].Text.ToString())) { judge_row.Cells[i].Appearance.BackColor = Color.Red; if (ugs.Cells["STD_TYPE"].Text.ToString() == "特殊要求(熔炼)") { ugs.Cells["STD_TYPE"].Appearance.BackColor = Color.Red; } } } else if (string.IsNullOrEmpty(judge_row.Cells[i].Text)) { judge_row.Cells[i].Appearance.BackColor = Color.Red; if (ugs.Cells["STD_TYPE"].Text.ToString() == "特殊要求(熔炼)") { ugs.Cells["STD_TYPE"].Appearance.BackColor = Color.Red; } } } else if (str_arr.Length == 2) { if (str_arr[0].Contains("<=") && !string.IsNullOrEmpty(judge_row.Cells[i].Text)) { if (double.Parse(str_arr[0].Replace("<=", "")) < double.Parse(judge_row.Cells[i].Text.ToString())) { judge_row.Cells[i].Appearance.BackColor = Color.Red; if (ugs.Cells["STD_TYPE"].Text.ToString() == "特殊要求(熔炼)") { ugs.Cells["STD_TYPE"].Appearance.BackColor = Color.Red; } } } else if (str_arr[0].Contains(">=") && !string.IsNullOrEmpty(judge_row.Cells[i].Text)) { if (double.Parse(str_arr[0].Replace(">=", "")) > double.Parse(judge_row.Cells[i].Text.ToString())) { judge_row.Cells[i].Appearance.BackColor = Color.Red; if (ugs.Cells["STD_TYPE"].Text.ToString() == "特殊要求(熔炼)") { ugs.Cells["STD_TYPE"].Appearance.BackColor = Color.Red; } } } if (str_arr[1].Contains("<=") && !string.IsNullOrEmpty(judge_row.Cells[i].Text)) { if (double.Parse(str_arr[1].Replace("<=", "")) < double.Parse(judge_row.Cells[i].Text.ToString())) { judge_row.Cells[i].Appearance.BackColor = Color.Red; if (ugs.Cells["STD_TYPE"].Text.ToString() == "特殊要求(熔炼)") { ugs.Cells["STD_TYPE"].Appearance.BackColor = Color.Red; } } } else if (str_arr[1].Contains(">=") && !string.IsNullOrEmpty(judge_row.Cells[i].Text)) { if (double.Parse(str_arr[1].Replace(">=", "")) > double.Parse(judge_row.Cells[i].Text.ToString())) { judge_row.Cells[i].Appearance.BackColor = Color.Red; if (ugs.Cells["STD_TYPE"].Text.ToString() == "特殊要求(熔炼)") { ugs.Cells["STD_TYPE"].Appearance.BackColor = Color.Red; } } } else if (string.IsNullOrEmpty(judge_row.Cells[i].Text)) { judge_row.Cells[i].Appearance.BackColor = Color.Red; if (ugs.Cells["STD_TYPE"].Text.ToString() == "特殊要求(熔炼)") { ugs.Cells["STD_TYPE"].Appearance.BackColor = Color.Red; } } } } } } } } } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); MessageBox.Show("系统出错，请联系管理人员", "警告"); } } private void ultraTabControl1_Click(object sender, EventArgs e) { if (this.ultraTabControl1.Tabs[1].Selected) //判定记录 { this.label4.Text = "判定时间"; this.checkBox1.Visible = true; this.label19.Visible = true; this.label20.Visible = true; this.dateTimePicker1.Value = System.DateTime.Now; } if (this.ultraTabControl1.Tabs[0].Selected) //判定记录 { this.label4.Text = "生产时间"; this.checkBox1.Visible = false; this.label19.Visible = false; this.label20.Visible = false; this.dateTimePicker1.Value = System.DateTime.Now.AddDays(-3); } } private void DoExport() { try { //if (this.ultraGrid2.Rows.Count == 0) //{ // MessageBox.Show("没有可以导出的数据", "提示"); // return; //} this.dataSet2.Clear(); string prod_name = this.comboBox2.Text.ToString(); string isvalid = "0"; if (checkBox1.Checked) { isvalid = "1"; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0301.QcmJhyElementsServiceImpl"; ccp.MethodName = "getLgZjudgeInfo"; ccp.ServerParams = new object[] { this.dateTimePicker1.Value.ToString("yyyy-MM-dd"), this.dateTimePicker2.Value.ToString("yyyy-MM-dd"), "", "4001LGX", prod_name, "J", isvalid }; ccp.SourceDataTable = this.dataSet2.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); 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 label9_Click(object sender, EventArgs e) { CoreClientParam ccp = new CoreClientParam(); foreach (UltraGridRow ugr in this.ultraGrid2.Rows) { if (ugr.Cells["checked"].Text.ToString() == "True") { string material_no = ugr.Cells["MATERIAL_NO"].Value.ToString(); string length = this.textBox4.Text.ToString(); string width = this.textBox3.Text.ToString(); string thick = this.textBox2.Text.ToString(); ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0301.QcmJhyElementsServiceImpl"; ccp.MethodName = "upLGSize"; ccp.ServerParams = new object[] { material_no, length, width, thick }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode == -1) { return; } ugr.Cells["checked"].Value = "False"; } } MessageBox.Show("登记成功"); } private void label8_Click(object sender, EventArgs e) { CoreClientParam ccp = new CoreClientParam(); foreach (UltraGridRow ugr in this.ultraGrid2.Rows) { if (ugr.Cells["checked"].Text.ToString() == "True") { string material_no = ugr.Cells["MATERIAL_NO"].Value.ToString(); string check_remarks = this.checkBoxComboBox2.Text.ToString(); string fix_remarks = this.checkBoxComboBox1.Text.ToString(); string pline = "4001LGX"; string username = this.UserInfo.GetUserName().ToString(); string prod_type = this.comboBox2.Text.ToString(); ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0301.QcmJhyElementsServiceImpl"; ccp.MethodName = "upLGMemo"; ccp.ServerParams = new object[] { material_no, fix_remarks, check_remarks, pline, username, prod_type }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode == -1) { return; } ugr.Cells["checked"].Value = "False"; } } this.checkBoxComboBox2.Text = ""; this.checkBoxComboBox1.Text = ""; MessageBox.Show("登记成功"); } private void label12_Click(object sender, EventArgs e) { CoreClientParam ccp = new CoreClientParam(); foreach (UltraGridRow ugr in this.ultraGrid1.Rows) { if (ugr.Cells["checked"].Text.ToString() == "True") { string material_no = ugr.Cells["MATERIAL_NO"].Value.ToString(); string check_remarks = this.checkBoxComboBox3.Text.ToString(); string fix_remarks = this.checkBoxComboBox4.Text.ToString(); string pline = "4001LGX"; string username = this.UserInfo.GetUserName().ToString(); string prod_type = this.comboBox2.Text.ToString(); ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0301.QcmJhyElementsServiceImpl"; ccp.MethodName = "upLGMemo1"; ccp.ServerParams = new object[] { material_no, fix_remarks, check_remarks, pline, username, prod_type }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode == -1) { return; } ugr.Cells["checked"].Value = "False"; } } this.checkBoxComboBox3.Text = ""; this.checkBoxComboBox4.Text = ""; MessageBox.Show("登记成功"); } private void label16_Click(object sender, EventArgs e) { CoreClientParam ccp = new CoreClientParam(); foreach (UltraGridRow ugr in this.ultraGrid1.Rows) { if (ugr.Cells["checked"].Text.ToString() == "True") { string material_no = ugr.Cells["MATERIAL_NO"].Value.ToString(); string length = this.textBox5.Text.ToString(); string width = this.textBox6.Text.ToString(); string thick = this.textBox7.Text.ToString(); ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0301.QcmJhyElementsServiceImpl"; ccp.MethodName = "upLGSize1"; ccp.ServerParams = new object[] { material_no, length, width, thick }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode == -1) { return; } ugr.Cells["checked"].Value = "False"; } } MessageBox.Show("登记成功"); } private void textBox5_TextChanged(object sender, EventArgs e) { } private void label17_Click(object sender, EventArgs e) { } private void label15_Click(object sender, EventArgs e) { } private void textBox6_TextChanged(object sender, EventArgs e) { } private void textBox7_TextChanged(object sender, EventArgs e) { } private void label18_Click(object sender, EventArgs e) { } private void ultraGrid2_AfterCellUpdate(object sender, CellEventArgs e) { } private void ultraGrid2_BeforeCellUpdate(object sender, BeforeCellUpdateEventArgs e) { } private void ultraGrid2_ClickCell(object sender, ClickCellEventArgs e) { } private void ultraGrid2_CellChange(object sender, CellEventArgs e) { UltraGridRow ugr1 = this.ultraGrid2.ActiveRow; //this.ultraGrid2.DisplayLayout.Bands[0].Header.Column["选择"] string ss = ""; string s1 = ""; if (ugr1.Cells["checked"] == e.Cell) { double sum = 0.0; foreach (UltraGridRow ugr in ultraGrid2.Rows) { if (ugr.Cells["checked"].Text.ToString() == "True") { ss = ugr.Cells["THEORYWEIGHT"].Value.ToString(); s1 = ugr.Cells["THEORYWEIGHT"].Text.ToString(); if (ugr.Cells["THEORYWEIGHT"].Value != null && ugr.Cells["THEORYWEIGHT"].Text.ToString() != "") { sum += Convert.ToDouble(ugr.Cells["THEORYWEIGHT"].Value); this.label20.Text = sum.ToString(); } } else { this.label20.Text = sum.ToString(); } } } } private void ultraGrid2_AfterCellUpdate_1(object sender, CellEventArgs e) { double sum = 0.0; foreach (UltraGridRow ugr in ultraGrid2.Rows) { if (ugr.Cells["checked"].Text.ToString() == "True") { if (ugr.Cells["THEORYWEIGHT"].Value != null && ugr.Cells["THEORYWEIGHT"].Text.ToString() != "") { sum += Convert.ToDouble(ugr.Cells["THEORYWEIGHT"].Value); this.label20.Text = sum.ToString(); } } else { this.label20.Text = sum.ToString(); } } } private void ultraGrid5_AfterRowActivate(object sender, EventArgs e) { try { UltraGridRow ugr = this.ultraGrid5.ActiveRow; this.dataSet2.Clear(); string bbatchno = ugr.Cells["HEAT_NO"].Value.ToString(); string prod_name = ugr.Cells["PLATE_TYPE"].Value.ToString(); string isvalid = "0"; this.label20.Text = ""; if (checkBox1.Checked) { isvalid = "1"; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0301.QcmJhyElementsServiceImpl"; ccp.MethodName = "getLgZjudgeInfo"; ccp.ServerParams = new object[] { "", "", bbatchno, "4001LGX", prod_name, "J", isvalid }; ccp.SourceDataTable = this.dataSet2.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); //for (int i = 0; i < ccp.SourceDataTable.Rows.Count; i++) //{ // foreach (UltraGridRow ugr2 in this.ultraGrid2.Rows) // { // if (ugr2.Cells["UTM_RESULT_DESC"].Value.ToString() == "合格") // { // ugr2.Cells["UTM_RESULT_DESC"].Appearance.BackColor = Color.FromArgb(185, 235, 204); // ugr2.Cells["UTM_RESULT_DESC"].Appearance.ForeColor = Color.Black; // } // else // { // ugr2.Cells["UTM_RESULT_DESC"].Appearance.BackColor = Color.FromArgb(249, 198, 186); // ugr2.Cells["UTM_RESULT_DESC"].Appearance.ForeColor = Color.Black; // } // } //} } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); MessageBox.Show("系统出错，请联系管理人员", "警告"); } } } }