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 System.Collections; using System.Text.RegularExpressions;//正则表达式所在空间 using Infragistics.Win.UltraWinGrid; namespace Core.LZMes.Client.UIB { public partial class UIB100220 : FrmBase { public UIB100220() { InitializeComponent(); } public override void ToolBar_Click(object sender, string ToolbarKey) { try { switch (ToolbarKey.ToString()) { case "Query": this.DoQuery(); break; case "Send": this.DoSend(); break; case "Export": this.DoExport(); break; case "OnFile": this.DoOnFile(); break; } } catch (System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } private string strLine = null;//产线 private string strArea = null;//地点 private string strSendTP = null;//是否已发送 private string strWtbh = null;//委托编号 private int Data1Table5Count = 0;//DataSet1.Table["Table5"]的列数 public void DoQuery() { try { if (this.comboBox1.Text.Trim() == "" || this.comboBox2.Text.Trim() == "") { MessageBox.Show("请选择产线和实验地点", "提示"); return; } OperateConditionRecode.WriteCondition("UIB100220_BOX1", this.comboBox1.Text); OperateConditionRecode.WriteCondition("UIB100220_BOX2", this.comboBox2.Text); OperateConditionRecode.WriteCondition("UIB100220_BOX3", this.comboBox3.Text); ArrayList al = new ArrayList(); //产线 if (this.comboBox1.Text == "热轧") { al.Add("UIB100220_01_01.SELECT"); strLine = "R"; } else if (this.comboBox1.Text == "连退") { al.Add("UIB100220_01_01.SELECT"); strLine = "L"; } else if (this.comboBox1.Text == "中板") { al.Add("UIB100220_01.SELECT"); strLine = "ZB"; } else if (this.comboBox1.Text == "厚板") { al.Add("UIB100220_01.SELECT"); strLine = "HB"; } else if (this.comboBox1.Text == "高棒") { al.Add("UIB100220_01.SELECT"); strLine = "GB"; } else if (this.comboBox1.Text == "高线") { al.Add("UIB100220_01.SELECT"); strLine = "GX"; } al.Add(strLine); //地点 if (this.comboBox2.Text.Trim() == "力学") { strArea = "LX"; } else if (this.comboBox2.Text.Trim() == "金相") { strArea = "JX"; } else { MessageBox.Show("请区分力学与金相", "提示"); return; } al.Add(strArea); //是否已发送 if (this.comboBox3.Text.Trim() == "未发送") { strSendTP = "0"; al.Add(strArea); al.Add(strSendTP); } else if (this.comboBox3.Text.Trim() == "已发送") { strSendTP = "1"; al.Add(strArea); al.Add(strSendTP); } else if (this.comboBox3.Text.Trim() == "全部") { strSendTP = ""; al.Add(""); al.Add(""); } else { MessageBox.Show("请选择发送状态"); return; } //委托时间 al.Add(this.dateTimePicker1.Value.Date.ToString("yyyyMMdd")+"000000"); al.Add(this.dateTimePicker2.Value.Date.ToString("yyyyMMdd") + "999999"); this.dataSet1.Tables[0].Clear(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.JHY.JHYComQuery"; ccp.MethodName = "doSimpleQuery"; ccp.ServerParams = new object[] { al }; ccp.SourceDataTable = this.dataSet1.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); //发送、完成状态颜色显示，发送状态优先 foreach (UltraGridRow ugr in this.ultraGrid1.Rows) { if (ugr.Cells["SEND_STAT"].Text.Substring(0, 1) == "0")//是否已发送，未发送则蓝色 { ugr.Cells["SEND_STAT"].Appearance.BackColor = Color.Blue; } if (ugr.Cells["WORK_STATS"].Text == "XX")//是否已完成，未完成则显示黄色 { ugr.RowSelectorAppearance.BackColor = Color.Yellow; } } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } public void DoSave() { } //发送 public void DoSend() { try { string strSMPNO = null; string strSMPCUTLOC = null; string strSMPTNOTYPE = null; string strMat = null;//物料号 int SPLITNUM = 3; string splitStr = null; int coilNum = 0; foreach (UltraGridRow ugr in this.ultraGrid1.Rows) { if (ugr.Cells["CHK"].Text == "True") { strSMPNO = strSMPNO + ugr.Cells["SMP_NO"].Text; strSMPCUTLOC = strSMPCUTLOC + ugr.Cells["SMP_CUT_LOC"].Text; strSMPTNOTYPE = strSMPTNOTYPE + ugr.Cells["SMP_NO_TYPE"].Text; if (strMat != null) { coilNum++; if (coilNum % SPLITNUM == 0) { splitStr = "\n"; } else {splitStr = ",";} } strMat = strMat + splitStr + ugr.Cells["COIL_NO"].Text; } // this.ultraGrid5.Rows[colNum].Cells["QLTY_VAL"].Value = al[0].ToString(); } if (strSMPNO == null) return; if (MessageBox.Show("确定发送以下批号：\n" + strMat, "提示", MessageBoxButtons.OKCancel) == DialogResult.Cancel) return; Hashtable ht = new Hashtable(); ht.Add("i1", strSMPNO); ht.Add("i2", strSMPCUTLOC); ht.Add("i3", strSMPTNOTYPE); ht.Add("i4", strArea); ht.Add("i5", this.UserInfo.GetUserName()); ht.Add("o6", ""); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.JHY.JHyComCallProc"; ccp.MethodName = "doSimpleProc"; ccp.ServerParams = new object[] { "UIB100203_04.CALL", ht }; CoreClientParam rccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); //计算结果返回 ArrayList al = rccp.ReturnObject as ArrayList; if (al[0] == null) { MessageBox.Show("发送异常!"); return; } if (al[0].ToString() == "XX"){ MessageBox.Show("部分钢卷发送失败!", "提示");} else{MessageBox.Show("发送成功!", "提示");} this.DoQuery(); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } public void DoExport() { try { string strMat = "";//物料号 string strWtbh = "";//委托单号 foreach (UltraGridRow ugr in this.ultraGrid1.Rows) { if (ugr.Cells["CHK"].Text == "True") { strMat = strMat + ugr.Cells["MATERIAL_NO"].Text; strWtbh = strWtbh + ugr.Cells["WEITO_NO"].Text; } } ArrayList al = new ArrayList(); if (this.comboBoxExp.Text == "拉力原始记录") { this.dataSetExport.Tables["Table1"].Clear(); al.Add("UIB100220_01.EXPORT.SELECT"); al.Add(strMat); al.Add(strWtbh); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.JHY.JHYComQuery"; ccp.MethodName = "doSimpleQuery"; ccp.ServerParams = new object[] { al }; ccp.SourceDataTable = this.dataSetExport.Tables["Table1"]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); JhyOpe jo = new JhyOpe(); jo.Export(this.dataSetExport.Tables["Table1"], this.textBoxPath.Text, "热轧拉力试验原始记录表", "HostLaLi.xls");//拉力导出 } else if (this.comboBoxExp.Text == "冲击原始记录") { //查询出所需要导出卷的信息 this.dataSetExport.Tables["Table2"].Clear(); al.Add("UIB100220_02.EXPORT.SELECT"); al.Add(strMat); al.Add(strWtbh); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.JHY.JHYComQuery"; ccp.MethodName = "doSimpleQuery"; ccp.ServerParams = new object[] { al }; ccp.SourceDataTable = this.dataSetExport.Tables["Table2"]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); JhyOpe jo = new JhyOpe(); jo.Export(this.dataSetExport.Tables["Table2"], this.textBoxPath.Text, "热轧冲击试验原始记录表", "HostChongJi.xls");//拉力导出 } MessageBox.Show("导出成功" , "提示"); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } public void DoOnFile() { } private void UIB100220_Load(object sender, EventArgs e) { try { /** * 1、查询条件初始化 * 2、过程编码初始化 * 3、材质代码初始化，用于grid4中的绑定材质代码 * 4、DataSet1.Table["Table5"]的列数 * **/ //查询条件初始化 this.comboBox1.Text = OperateConditionRecode.ReadCondition("UIB100220_BOX1"); this.comboBox2.Text = OperateConditionRecode.ReadCondition("UIB100220_BOX2"); this.comboBox3.Text = OperateConditionRecode.ReadCondition("UIB100220_BOX3"); this.textBoxPath.Text = OperateConditionRecode.ReadCondition("UIB100220_PATH"); this.comboBoxExp.SelectedIndex = 0; //DataSet1.Table["Table5"]的列数 Data1Table5Count = this.dataSet1.Tables["Table5"].Columns.Count; //过程编码和材质代码初始化 ArrayList list = new ArrayList(); ArrayList al = new ArrayList(); al.Add("UIB100220_03.SELECT"); list.Add(al); al.Add(""); al = new ArrayList(); al.Add("UIB100220_01.INITSELECT"); list.Add(al); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.JHY.JHYComQuery"; ccp.MethodName = "doContQluery"; ccp.ServerParams = new object[] { list }; CoreClientParam ccpList = this.ExecuteQuery(ccp, CoreInvokeType.Internal); if (ccpList.ReturnInfo.Length == 0) { ArrayList aList = ccpList.ReturnObject as ArrayList; if (aList[0] != null) { this.dataSet2.Tables["Table1"].Clear(); System.Data.DataTable tab0 = Common.FixDBManager.ConvertToDataTable(aList[0] as System.Collections.ArrayList, this.dataSet2.Tables["Table1"]); tab0.TableName = "Table1"; this.dataSet2.Tables["Table1"].Merge(tab0); } if (aList[1] != null) { this.dataSet2.Tables["Table2"].Clear(); System.Data.DataTable tab0 = Common.FixDBManager.ConvertToDataTable(aList[1] as System.Collections.ArrayList, this.dataSet2.Tables["Table2"]); tab0.TableName = "Table2"; this.dataSet2.Tables["Table2"].Merge(tab0); } }//end if } catch (Exception ex) { MessageBox.Show("系统缺少必要信息，请重新加载","提示"); //System.Diagnostics.Debug.WriteLine(ex.ToString()); } } private void checkBox1_CheckedChanged(object sender, EventArgs e) { try { this.textBox1.Enabled = this.checkBox1.Checked; } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } //对grid5动态行的处理 public void grid5ColumnChange(string strQltyCD2, string strQltyCD3 , string strQltyCD) { // SETUP2：添加动态过程项目到table中 for (int i = 0; i < this.dataSet2.Tables["Table3"].Rows.Count; i++) { this.dataSet1.Tables["Table5"].Columns.Add(this.dataSet2.Tables["Table3"].Rows[i]["QLTY_OPE_CFNM"].ToString()); } // SETUP3：对grid5进行操作 CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.JHY.UIB100220"; ccp.MethodName = "doQltyCdQuery"; ccp.ServerParams = new object[] { strQltyCD2, strQltyCD3, strWtbh, this.strArea, this.strSendTP == null ? "" : this.strSendTP, strQltyCD }; ccp.SourceDataTable = this.dataSet1.Tables["Table5"]; //this.ultraGrid5.Refresh(); this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); //设置列宽和不可编辑属性 int index = Data1Table5Count + 1; for (int nextCol = Data1Table5Count; nextCol < this.ultraGrid5.DisplayLayout.Bands[0].Columns.Count; nextCol++) { this.ultraGrid5.DisplayLayout.Bands[0].Columns[nextCol].Width = 40;//设置列宽 this.ultraGrid5.DisplayLayout.Bands[0].Columns[nextCol].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;//不可编辑 } } private void ultraGrid6_KeyDown(object sender, KeyEventArgs e) { try { /** * * 回车后，首先区分数据已变、未变的情况；未变时需要光标跳动，已变后需要处理数据问题以及光标跳动 * * 针对已变逻辑如下： * SETUP1：保存数据，返回修约后的结果和是否合格的标识，回填到隐藏Table * SETUP2：从该项开始进行循环，有计算公式的，进行保存计算，回填到隐藏Table * SETUP3：通过隐藏的Table，回填到grid5和grid6 * * SETUPA： 如果grid6未到行末，则grid6调到下一行；若grid6到达行末，对grid5换行，并执行查询；需要使得grid6首行的列处于可编辑状态 * 注意 ：DataSet1的Table6和DataSet2的Table4字段是相同的，DataSet2.Tables["Table4"]便是对grid6的隐藏Table * **/ if (e.KeyCode != Keys.Enter) return; if (this.ultraGrid6.ActiveCell == null) return; if (this.ultraGrid6.ActiveCell.DataChanged == true) { //数据禁止修改，或数据不符合格式 string strVal = this.ultraGrid6.ActiveRow.Cells["QLTY_VAL"].Text.Trim() == "" ? "0" : this.ultraGrid6.ActiveRow.Cells["QLTY_VAL"].Text.Trim(); if (this.ultraGrid6.ActiveRow.Cells["EDIT_TP"].Text == "N" || JhyOpe.DcsDouble(strVal) == false) { MessageBox.Show("数据禁止修改或格式错误", "提示"); //恢复数据 this.ultraGrid6.ActiveRow.Cells["QLTY_VAL"].Value = this.ultraGrid6.ActiveRow.Cells["QLTY_VAL"].Value.ToString(); this.ultraGrid6.UpdateData(); return; } //数据处理问题 Grid6KeyDown(); } //光标跳动处理 CursorMove(); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } //grid6的回车事件 private void Grid6KeyDown() { ArrayList rsList = null; //SETUP1.OF 保存数据 rsList = this.DoUpdate(this.ultraGrid5.ActiveRow.Cells["SMP_NO"].Text, this.ultraGrid5.ActiveRow.Cells["SMP_CUT_LOC"].Text , this.ultraGrid5.ActiveRow.Cells["SMP_NO_TYPE"].Text, this.ultraGrid5.ActiveRow.Cells["QLTY_CD_2"].Text , this.ultraGrid6.ActiveRow.Cells["QLTY_OPE_CD"].Text, "" , this.ultraGrid6.ActiveRow.Cells["QLTY_DIS_LEN"].Text, this.ultraGrid6.ActiveRow.Cells["CRCT_REG"].Text.ToUpper() , "", this.ultraGrid6.ActiveRow.Cells["QLTY_VAL"].Text); //SETUP1 OF 回填到隐藏的Table int rowTable4 = 0; for (int i = 0; i < this.dataSet2.Tables["Table4"].Rows.Count; i++) { if (this.dataSet2.Tables["Table4"].Rows[i]["QLTY_OPE_CD"].ToString() == this.ultraGrid6.ActiveRow.Cells["QLTY_OPE_CD"].Text) { this.setValHiddenTable(i, rsList);//回填数据到隐藏的Table rowTable4 = i; break; } } //SETUP2 OF 有计算公式的进行保存计算 for (int i = rowTable4; i < this.dataSet2.Tables["Table4"].Rows.Count; i++) { string strCompVal = this.dataSet2.Tables["Table4"].Rows[i]["COMP_CAL"].ToString();//提取计算公式，如“a*b” if (strCompVal == "") continue; strCompVal = this.DoCompVal(strCompVal);//返回替换值后的计算公式，如 “12*13” rsList = this.DoUpdate(this.ultraGrid5.ActiveRow.Cells["SMP_NO"].Text, this.ultraGrid5.ActiveRow.Cells["SMP_CUT_LOC"].Text , this.ultraGrid5.ActiveRow.Cells["SMP_NO_TYPE"].Text, this.ultraGrid5.ActiveRow.Cells["QLTY_CD_2"].Text , this.dataSet2.Tables["Table4"].Rows[i]["QLTY_OPE_CD"].ToString(), strCompVal , this.dataSet2.Tables["Table4"].Rows[i]["QLTY_DIS_LEN"].ToString(), this.dataSet2.Tables["Table4"].Rows[i]["CRCT_REG"].ToString().ToUpper() , "", this.dataSet2.Tables["Table4"].Rows[i]["QLTY_VAL"].ToString()); //SETUP2 OF 回填到隐藏的Table this.setValHiddenTable(i, rsList); } //SETUP3 回填到grid5、grid6 for (int i = 0; i < this.dataSet2.Tables["Table4"].Rows.Count; i++) { //SETUP3.通过隐藏的Table，回填到grid5 //grid5的动态变化字段，与table的操作编码对应 setValGrid5(this.dataSet2.Tables["Table4"].Rows[i]["QLTY_OPE_CFNM"].ToString() , this.dataSet2.Tables["Table4"].Rows[i]["QLTY_VAL"].ToString()); if (this.dataSet2.Tables["Table4"].Rows[i]["QLTY_CD"].ToString() == this.ultraGrid5.ActiveRow.Cells["QLTY_CD"].Text ) { //实绩值字段 setValGrid5("QLTY_VAL", this.dataSet2.Tables["Table4"].Rows[i]["QLTY_VAL"].ToString()); //判定结果字段 setValGrid5("QLTY_DCS_RST", this.dataSet2.Tables["Table4"].Rows[i]["QLTY_DCS_RST"].ToString()); } //SETUP3.通过隐藏的Table，回填到grid6 setValGrid6(this.dataSet2.Tables["Table4"].Rows[i]["QLTY_OPE_CD"].ToString(), this.dataSet2.Tables["Table4"].Rows[i]["QLTY_VAL"].ToString()); } this.ultraGrid5.UpdateData(); this.ultraGrid6.UpdateData(); this.dataSet2.Tables["Table4"].AcceptChanges(); //不合格颜色提示 string dcsRst = setColor("A" , this.ultraGrid5); if (dcsRst == "不合格") { MessageBox.Show("数据不合格" , "提示"); } } //光标跳动处理 private void CursorMove() { //换行，并编辑 int grid6CurRow = this.ultraGrid6.ActiveRow.Index + 1;//下一行的序号 for (int i = grid6CurRow; i < this.ultraGrid6.Rows.Count; i++) { //SETUPA OF 如果grid6未到行末，则grid6调到下一行 if (i + 1 != this.ultraGrid6.Rows.Count) { if (this.ultraGrid6.Rows[i].Cells["EDIT_TP"].Text == "N") { i++;//执行i++后，可能到达了行末，所以后面需要重新判断是否到达行末 } else { //this.ultraGrid6.PerformAction(Infragistics.Win.UltraWinGrid.UltraGridAction.NextRow); this.ultraGrid6.Rows[i].Activate(); this.ultraGrid6.ActiveRow.Cells["QLTY_VAL"].Activated = true; this.ultraGrid6.PerformAction(Infragistics.Win.UltraWinGrid.UltraGridAction.EnterEditMode); break; } } if (i + 1 == this.ultraGrid6.Rows.Count)// SETUPA OF 如果grid6到达行末，对grid5换行，并执行查询；需要使得grid6首行处于可编辑状态 { this.ultraGrid5.PerformAction(Infragistics.Win.UltraWinGrid.UltraGridAction.NextRow); //this.ultraGrid5_ClickCell(null, null); this.ultraGrid6.Rows[0].Activate(); this.ultraGrid6.ActiveRow.Cells["QLTY_VAL"].Activated = true; this.ultraGrid6.PerformAction(Infragistics.Win.UltraWinGrid.UltraGridAction.EnterEditMode); this.ultraGrid6.PerformAction(Infragistics.Win.UltraWinGrid.UltraGridAction.EnterEditMode);//不明白为什么要写两次才可以进入回车编辑状态 break; } } } private ArrayList DoUpdate(string smpNo, string smpCutLoc, string smpNoType, string qltyCd2 ,string qltyOpeCd, string strCompVal, string qltyDisLen, string crctReg ,string flag, string qltyVal) { ArrayList al = null; try { Hashtable ht = null; ht = new Hashtable(); ht.Add("i1", smpNo); ht.Add("i2", smpCutLoc); ht.Add("i3", smpNoType); ht.Add("i4", qltyCd2); ht.Add("i5", qltyOpeCd); ht.Add("i6", strCompVal);//计算公式 ht.Add("i7", qltyDisLen);//保留位数 ht.Add("i8", crctReg);//修约规则 ht.Add("i9", flag);//特殊处理 ht.Add("i10", qltyVal); ht.Add("i11", this.UserInfo.GetUserName()); ht.Add("o12", ""); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.JHY.JHyComCallProc"; ccp.MethodName = "doSimpleProc"; ccp.ServerParams = new object[] { "UIB100203_01.CALL", ht }; CoreClientParam rccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); al = rccp.ReturnObject as ArrayList; if (al[0] == null) { al = new ArrayList(); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } return al; } private string DoCompVal(string strCompVal) { try { for (int i = 0; i < this.dataSet2.Tables["Table4"].Rows.Count; i++) { strCompVal = strCompVal.Replace(this.dataSet2.Tables["Table4"].Rows[i]["QLTY_OPE_CD"].ToString() , this.dataSet2.Tables["Table4"].Rows[i]["QLTY_VAL"].ToString()); //判断公式的字符串是否已经替换完成，未替换完成，则不进行任何操作，进入下一次循环 Regex r = new Regex(@"[A-Z,a-z]"); Match m = r.Match(strCompVal); if (m.Success) continue; strCompVal = strCompVal.Replace("√", "SQRT").Replace("=", "");//开根号处理 break; } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } return strCompVal; } //回填实绩值、判定结果到隐藏的Table private void setValHiddenTable(int num , ArrayList al) { try { string[] str = al[0].ToString().Split(';'); this.dataSet2.Tables["Table4"].Rows[num]["QLTY_VAL"] = str[0];//回填值 this.dataSet2.Tables["Table4"].Rows[num]["QLTY_DCS_RST"] = str[1];//回填判定结果 } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } //回填实绩值、判定结果到grid5 private void setValGrid5(string coluMnName , string val) { try { if (coluMnName != "") this.ultraGrid5.ActiveRow.Cells[coluMnName].Value = val; } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } //回填实绩值、判定结果到grid6 private void setValGrid6(string qltyOpeCd, string val) { try { for (int j = 0; j < this.dataSet1.Tables["Table6"].Rows.Count; j++) { if (this.dataSet1.Tables["Table6"].Rows[j]["QLTY_OPE_CD"].ToString() == qltyOpeCd) { this.dataSet1.Tables["Table6"].Rows[j]["QLTY_VAL"] = val; break; } } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } //颜色提示，A为不合格颜色 private string setColor(string flag , Infragistics.Win.UltraWinGrid.UltraGrid grid) { string dcsRst = "";//不合格为真，合格为假 if (flag == "A") { foreach (UltraGridRow ugr in grid.Rows) { if (ugr.Cells["QLTY_DCS_RST"].Text == "不合格") { ugr.RowSelectorAppearance.BackColor = Color.Red; dcsRst = "不合格"; //ugr.Appearance.ForeColor = Color.Red; } else { ugr.RowSelectorAppearance.BackColor = Color.White; } } } return dcsRst; } private void ultraGrid1_ClickCell(object sender, ClickCellEventArgs e) { try { if (this.ultraGrid1.ActiveRow == null) return; strWtbh = this.ultraGrid1.ActiveRow.Cells["WEITO_NO"].Text;//委托编号，全局变量 ArrayList al = new ArrayList(); DataTable dt = new DataTable(); //if (this.ultraTabControl1.SelectedTab.Text == "结果录入") if (this.ultraTabControl1.Tabs[3].Selected) { al.Add("UIB100220_02.SELECT"); al.Add(this.strArea); al.Add(this.ultraGrid1.ActiveRow.Cells["WEITO_NO"].Text); this.dataSet1.Tables["Table3"].Clear(); dt = this.dataSet1.Tables["Table3"]; } else if (this.ultraTabControl1.SelectedTab.Text == "检验结果") { al.Add("UIB100220_06.SELECT"); al.Add(this.strArea);//检测中心和理化楼区分 al.Add(this.ultraGrid1.ActiveRow.Cells["WEITO_NO"].Text); if (this.ultraGrid1.ActiveCell.Column.Key == "MATERIAL_NO") {al.Add(this.ultraGrid1.ActiveCell.Value.ToString());} else {al.Add("");} this.dataSet1.Tables["Table2"].Clear(); dt = this.dataSet1.Tables["Table2"]; } else if (this.ultraTabControl1.SelectedTab.Text == "基本信息") { al.Add("UIB100220_08.SELECT"); al.Add(this.strArea); al.Add(this.ultraGrid1.ActiveRow.Cells["WEITO_NO"].Text); this.dataSet1.Tables["Table7"].Clear(); dt = this.dataSet1.Tables["Table7"]; } else if (this.ultraTabControl1.SelectedTab.Text == "异常处理") { this.textWtbh.Text = this.ultraGrid1.ActiveRow.Cells["WEITO_NO"].Text; this.textGyh.Text = this.ultraGrid1.ActiveRow.Cells["SMP_STEEL_NO"].Text; return; } else { return; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.JHY.JHYComQuery"; ccp.MethodName = "doSimpleQuery"; ccp.ServerParams = new object[] { al }; ccp.SourceDataTable = dt; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); //不合格颜色提示 if (this.ultraTabControl1.SelectedTab.Text == "检验结果") setColor("A", this.ultraGrid2); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } private void ultraGrid4_ClickCell(object sender, ClickCellEventArgs e) { if (this.ultraGrid4.ActiveRow == null) return; this.dataSet1.Tables["Table5"].Clear(); this.dataSet1.Tables["Table6"].Clear(); //清除添加的列 for (int i = this.dataSet1.Tables["Table5"].Columns.Count; i > Data1Table5Count; i--) { this.dataSet1.Tables["Table5"].Columns.Remove(this.dataSet1.Tables["Table5"].Columns[i - 1]); } grid5ColumnChange(this.ultraGrid4.ActiveRow.Cells["QLTY_CD_2"].Text , this.ultraGrid4.ActiveRow.Cells["QLTY_CD_3"].Text ,this.ultraGrid4.ActiveRow.Cells["QLTY_CD"].Text ); this.ultraTabControl1.Tabs[3].Text = this.ultraGrid4.Rows[0].Cells["QLTY_CD_CFNM"].Text; } private void ultraGrid7_AfterRowActivate(object sender, EventArgs e) { try { this.textBoxRmkSB.Text = this.ultraGrid7.ActiveRow.Cells["RMK_1"].Text;//备注 this.textBoxRmkBZ.Text = this.ultraGrid7.ActiveRow.Cells["RMK_2"].Text;//设备编号 this.textBoxRmk3.Text = "检测备注"; } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } private void comboBox6_SelectedIndexChanged(object sender, EventArgs e) { try { foreach (UltraGridRow ugr in this.ultraGrid5.Rows) { if(ugr.Selected) { Hashtable ht = new Hashtable(); ht.Add("i1", ugr.Cells["SMP_NO"].Text); ht.Add("i2", ugr.Cells["SMP_CUT_LOC"].Text); ht.Add("i3", ugr.Cells["SMP_NO_TYPE"].Text); ht.Add("i4", ugr.Cells["QLTY_CD"].Text); ht.Add("i5", this.comboBox6.Text.Trim()); ht.Add("i6", this.UserInfo.GetUserName()); ht.Add("o7", ""); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.JHY.JHyComCallProc"; ccp.MethodName = "doSimpleProc"; ccp.ServerParams = new object[] { "UIB100203_02.CALL", ht }; CoreClientParam rccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); ArrayList al = rccp.ReturnObject as ArrayList; if (al[0] == null) return; if (al[0].ToString() == "XX") return; MessageBox.Show("修改成功" , "提示"); //ugr.Cells["QLTY_CD_CFNM"].Value = al[0].ToString(); } } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } //设备 private void textBoxRmkSB_KeyDown(object sender, KeyEventArgs e) { try { if (e.KeyCode != Keys.Enter) return; ArrayList al = new ArrayList(); al.Add("UIB100220_01.UPDATE"); al.Add(this.textBoxRmkSB.Text.Trim().ToString()); al.Add(this.textBoxRmkSB.Text.Trim().ToString()); al.Add(this.ultraGrid7.ActiveRow.Cells["SMP_NO"].Text); al.Add(this.ultraGrid7.ActiveRow.Cells["SMP_CUT_LOC"].Text); al.Add(this.ultraGrid7.ActiveRow.Cells["SMP_NO_TYPE"].Text); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.JHY.JHYComSave"; ccp.ServerParams = new object[] { al }; ccp.MethodName = "doSimpleSave"; this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); this.ultraGrid7.ActiveRow.Cells["RMK_2"].Value = this.textBoxRmkSB.Text.ToString(); this.ultraGrid7.UpdateData(); if (sender != null) this.textBoxRmkBZ.Focus(); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } //备注 private void textBoxRmkBZ_KeyDown(object sender, KeyEventArgs e) { try { if (e.KeyCode != Keys.Enter) return; this.ultraGrid7.ActiveRow.Cells["RMK_1"].Value = this.textBoxRmkBZ.Text.ToString(); textBoxRmkSB_KeyDown(null, e); this.ultraGrid7.PerformAction(Infragistics.Win.UltraWinGrid.UltraGridAction.NextRow); this.textBoxRmkSB.Focus(); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } //委托单号变更 private void textWtbh_KeyDown(object sender, KeyEventArgs e) { try { ArrayList al = new ArrayList(); al.Add("UIB100220_02.UPDATE"); al.Add(this.textWtbh.Text.ToString()); al.Add(this.ultraGrid1.ActiveRow.Cells["WEITO_NO"].Text); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.JHY.JHYComSave"; ccp.ServerParams = new object[] { al }; ccp.MethodName = "doSimpleSave"; this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } private void textGyh_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode != Keys.Enter) return;//回车时，才保存数据 try { Hashtable ht = new Hashtable(); ht.Add("i1", this.ultraGrid1.ActiveRow.Cells["COIL_NO"].Text); ht.Add("i2", this.ultraGrid1.ActiveRow.Cells["SMP_NO"].Text); ht.Add("i3", this.ultraGrid1.ActiveRow.Cells["SMP_CUT_LOC"].Text); ht.Add("i4", this.ultraGrid1.ActiveRow.Cells["SMP_NO_TYPE"].Text); ht.Add("i5", this.textGyh.Text.Trim()); ht.Add("o6", ""); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.JHY.JHyComCallProc"; ccp.MethodName = "doSimpleProc"; ccp.ServerParams = new object[] { "UIB100203_03.CALL", ht }; CoreClientParam rccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); //计算结果返回 ArrayList al = rccp.ReturnObject as ArrayList; if (al[0] == null) return; MessageBox.Show(al[0].ToString(), "提示"); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } //导出路径修改 private void button1_Click(object sender, EventArgs e) { try { string path = null; if (this.folderBrowserDialog1.ShowDialog() == DialogResult.OK) { path = this.folderBrowserDialog1.SelectedPath; this.textBoxPath.Text = path; OperateConditionRecode.WriteCondition("UIB100220_PATH", this.textBoxPath.Text); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } Boolean blChkci = false; private void label13_Click(object sender, EventArgs e) { blChkci = !blChkci; foreach (UltraGridRow ugr in this.ultraGrid1.Rows) { ugr.Cells["CHK"].Value = blChkci; } this.ultraGrid1.UpdateData(); } private void ultraTabControl1_MouseClick(object sender, MouseEventArgs e) { ultraGrid1_ClickCell(null ,null); } private void ultraGrid3_AfterRowActivate(object sender, EventArgs e) { try { /* * 由于SQL语句查询出来的动态的列，在界面上显示时并不是按照SQL语句中字段的先后顺序排列的。故： * SETUP1：查询出检验大类（如拉力）所需要的过程项目（Lo，So等），SQL的ID为UIB100220_03.SELECT * SETUP2：将查询出来的过程项目添加到grid5的数据源dataset1.Table5中 * SETUP2-1：每次点击都需要添加过程项目，故而每次要先删除被添加的项目，否则第二次添加将会出错 * SETUP2-2：删除dataset1.Table5中添加项，必须知道有多少列是固定的=>在界面初始化时获取固定列 * SETUP3：对grid5进行操作，给动态列“设置列宽”和“设置可编辑属性” * **/ if (this.ultraGrid3.ActiveRow == null) return; //int GRIDCOLS = this.ultraGrid3.DisplayLayout.Bands[0].Columns.Count; string strQltyCD2 = this.ultraGrid3.ActiveRow.Cells["QLTY_CD_2"].Text;//二级编码，如拉力，冲击 string strQltyCD3 = this.ultraGrid3.ActiveRow.Cells["QLTY_CD_3"].Text;//三级编码，如屈服强度，伸长率 this.dataSet1.Tables["Table4"].Clear(); this.dataSet1.Tables["Table6"].Clear(); this.dataSet1.Tables["Table5"].Clear(); //清除添加的列 for (int i = this.dataSet1.Tables["Table5"].Columns.Count; i > Data1Table5Count; i--) { this.dataSet1.Tables["Table5"].Columns.Remove(this.dataSet1.Tables["Table5"].Columns[i - 1]); } this.dataSet2.Tables["Table3"].Clear(); this.dataSet2.Tables["Table4"].Clear(); //SETUP1：初始化工作完成后，进行查询过程项目 ArrayList list = new ArrayList(); ArrayList al = new ArrayList(); al.Add("UIB100220_03.SELECT");//查询大类（如拉力）所对应的操作编码，对应this.dataSet2.Tables["Table3"].Clear(); al.Add(strQltyCD2); list.Add(al); al = new ArrayList(); al.Add("UIB100220_07.SELECT");//查询具体项目名称和编码，对应this.dataSet1.Tables["Table4"].Clear(); al.Add(strQltyCD2); al.Add(strQltyCD3); al.Add(strWtbh); list.Add(al); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.JHY.JHYComQuery"; ccp.MethodName = "doContQluery"; ccp.ServerParams = new object[] { list }; CoreClientParam ccpList = this.ExecuteQuery(ccp, CoreInvokeType.Internal); if (ccpList.ReturnInfo.Length == 0) { ArrayList aList = ccpList.ReturnObject as ArrayList; if (aList[0] != null) { this.dataSet2.Tables["Table3"].Clear(); System.Data.DataTable tab0 = Common.FixDBManager.ConvertToDataTable(aList[0] as System.Collections.ArrayList, this.dataSet2.Tables["Table3"]); tab0.TableName = "Table3"; this.dataSet2.Tables["Table3"].Merge(tab0); } if (aList[1] != null) { this.dataSet1.Tables["Table4"].Clear(); System.Data.DataTable tab0 = Common.FixDBManager.ConvertToDataTable(aList[1] as System.Collections.ArrayList, this.dataSet1.Tables["Table4"]); tab0.TableName = "Table4"; this.dataSet1.Tables["Table4"].Merge(tab0); } }//end if this.ultraTabControl1.Tabs[3].Text = this.ultraGrid4.Rows[0].Cells["QLTY_CD_CFNM"].Text; grid5ColumnChange(strQltyCD2, strQltyCD3, "");//对grid5动态行的处理 //不合格颜色提示 setColor("A", this.ultraGrid5); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } private void ultraGrid5_AfterRowActivate(object sender, EventArgs e) { try { ///* ///录入数据的grid6的需求决定了grid5的查询 /// ///*/ if (this.ultraGrid5.ActiveRow == null) return; this.dataSet1.Tables["Table6"].Clear(); this.dataSet2.Tables["Table4"].Clear(); ArrayList list = new ArrayList(); //grid6的显示，只显示相关过程项目 ArrayList al = new ArrayList(); al.Add("UIB100220_05.SELECT"); al.Add(this.strLine); al.Add(this.ultraGrid5.ActiveRow.Cells["SMP_NO"].Text); al.Add(this.ultraGrid5.ActiveRow.Cells["SMP_CUT_LOC"].Text); al.Add(this.ultraGrid5.ActiveRow.Cells["SMP_NO_TYPE"].Text); al.Add(this.ultraGrid5.ActiveRow.Cells["QLTY_CD_3"].Text); al.Add(this.ultraGrid5.ActiveRow.Cells["QLTY_CD_2"].Text); list.Add(al); //grid6的隐藏Table，获取所有大类（如拉力）中的过程项目，并放入this.dataSet2.Tables["Table4"] al = new ArrayList(); al.Add("UIB100220_05.SELECT"); al.Add(this.strLine); al.Add(this.ultraGrid5.ActiveRow.Cells["SMP_NO"].Text); al.Add(this.ultraGrid5.ActiveRow.Cells["SMP_CUT_LOC"].Text); al.Add(this.ultraGrid5.ActiveRow.Cells["SMP_NO_TYPE"].Text); al.Add(""); al.Add(this.ultraGrid5.ActiveRow.Cells["QLTY_CD_2"].Text); list.Add(al); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.JHY.JHYComQuery"; ccp.MethodName = "doContQluery"; ccp.ServerParams = new object[] { list }; CoreClientParam ccpList = this.ExecuteQuery(ccp, CoreInvokeType.Internal); if (ccpList.ReturnInfo.Length == 0) { ArrayList aList = ccpList.ReturnObject as ArrayList; if (aList[0] != null) { this.dataSet1.Tables["Table6"].Clear(); System.Data.DataTable tab0 = Common.FixDBManager.ConvertToDataTable(aList[0] as System.Collections.ArrayList, this.dataSet1.Tables["Table6"]); tab0.TableName = "Table6"; this.dataSet1.Tables["Table6"].Merge(tab0); } if (aList[1] != null) { this.dataSet2.Tables["Table4"].Clear(); System.Data.DataTable tab0 = Common.FixDBManager.ConvertToDataTable(aList[1] as System.Collections.ArrayList, this.dataSet2.Tables["Table4"]); tab0.TableName = "Table4"; this.dataSet2.Tables["Table4"].Merge(tab0); } }//if end foreach (UltraGridRow ugr in this.ultraGrid6.Rows) { if (ugr.Cells["QLTY_OPE_CD"].Text == "FX")//与试样方向绑定 { ugr.Cells["QLTY_VAL"].EditorComponent = this.ultraComboEditor3; } else if (ugr.Cells["QLTY_OPE_CD"].Text == "CB")//与冷弯值绑定 { ugr.Cells["QLTY_VAL"].EditorComponent = this.ultraComboEditor2; } else if (ugr.Cells["QLTY_OPE_CD"].Text == "MJGG")//与剪切面积绑定 { ugr.Cells["QLTY_VAL"].EditorComponent = this.ultraComboEditor4; } } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } }//Class end }//namespace end