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.Collections; namespace Core.LZMes.Client.UIB { public partial class CUIB030110 : FrmBase { //public delegate void ddd();//定义委托 //public event ddd frmdoquery; public CUIB030110() { InitializeComponent(); } private void ultraGrid1_InitializeLayout(object sender, Infragistics.Win.UltraWinGrid.InitializeLayoutEventArgs e) { } public void DoQuery() { try { ArrayList alt = new ArrayList(); alt.Add("UIB030110_02.SELECT"); this.dataSet1.Tables[0].Clear(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.COM.ComDBQuery"; ccp.MethodName = "doSimpleQuery"; ccp.ServerParams = new object[] { alt }; ccp.SourceDataTable = this.dataSet1.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); //foreach (UltraGridRow ugr in this.ultraGrid1.Rows) //{ // if(Convert.ToString(ugr.Cells["SM_CD"].Text.Substring(0,1)) == "A") // { // } //} } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } private void CIB020310_Load(object sender, EventArgs e) { //DoQuery(); CoreClientParam ccp = new CoreClientParam(); ArrayList list = new ArrayList(); ArrayList al = new ArrayList(); al = new ArrayList(); al.Add("UIB030110_02.SELECT"); list.Add(al); al = new ArrayList(); al.Add("UIB030110_02_01.SELECT"); list.Add(al); al = new ArrayList(); al.Add("UIB030110_02_02.SELECT"); list.Add(al); al = new ArrayList(); al.Add("UIB030110_02_03.SELECT"); list.Add(al); al = new ArrayList(); al.Add("UIB030110_02_04.SELECT"); list.Add(al); al = new ArrayList(); al.Add("UIB030110_02_05.SELECT"); list.Add(al); al = new ArrayList(); al.Add("UIB030110_02_06.SELECT"); list.Add(al); al = new ArrayList(); al.Add("UIB030110_02_07.SELECT"); list.Add(al); al = new ArrayList(); al.Add("UIB030110_02_08.SELECT"); list.Add(al); ccp.ServerName = "UIB.COM.ComDBQuery"; ccp.MethodName = "doContinuousQluery"; 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[0].Clear(); System.Data.DataTable tab0 = Common.FixDBManager.ConvertToDataTable(aList[0] as ArrayList, this.dataSet1.Tables[0]); tab0.TableName = "Table1"; this.dataSet1.Tables["Table1"].Merge(tab0); } if (aList[1] != null)//哪一面 { this.dataSet2.Tables[0].Clear(); System.Data.DataTable tab0 = Common.FixDBManager.ConvertToDataTable(aList[1] as ArrayList, this.dataSet2.Tables[0]); tab0.TableName = "Table1"; this.dataSet2.Tables["Table1"].Merge(tab0); } if (aList[2] != null)//哪一侧 { this.dataSet2.Tables["Table2"].Clear(); System.Data.DataTable tab0 = Common.FixDBManager.ConvertToDataTable(aList[2] as ArrayList, this.dataSet2.Tables["Table2"]); tab0.TableName = "Table2"; this.dataSet2.Tables["Table2"].Merge(tab0); } if (aList[3] != null)//哪一头 { this.dataSet2.Tables["Table3"].Clear(); System.Data.DataTable tab0 = Common.FixDBManager.ConvertToDataTable(aList[3] as ArrayList, this.dataSet2.Tables["Table3"]); tab0.TableName = "Table3"; this.dataSet2.Tables["Table3"].Merge(tab0); } if (aList[4] != null)//大小 { this.dataSet2.Tables["Table4"].Clear(); System.Data.DataTable tab0 = Common.FixDBManager.ConvertToDataTable(aList[4] as ArrayList, this.dataSet2.Tables["Table4"]); tab0.TableName = "Table4"; this.dataSet2.Tables["Table4"].Merge(tab0); } if (aList[5] != null)//多少 { this.dataSet2.Tables["Table5"].Clear(); System.Data.DataTable tab0 = Common.FixDBManager.ConvertToDataTable(aList[5] as ArrayList, this.dataSet2.Tables["Table5"]); tab0.TableName = "Table5"; this.dataSet2.Tables["Table5"].Merge(tab0); } if (aList[6] != null)//手感 { this.dataSet2.Tables["Table6"].Clear(); System.Data.DataTable tab0 = Common.FixDBManager.ConvertToDataTable(aList[6] as ArrayList, this.dataSet2.Tables["Table6"]); tab0.TableName = "Table6"; this.dataSet2.Tables["Table6"].Merge(tab0); } if (aList[7] != null)//视觉 { this.dataSet2.Tables["Table7"].Clear(); System.Data.DataTable tab0 = Common.FixDBManager.ConvertToDataTable(aList[7] as ArrayList, this.dataSet2.Tables["Table7"]); tab0.TableName = "Table7"; this.dataSet2.Tables["Table7"].Merge(tab0); } if (aList[8] != null)//其它 { this.dataSet2.Tables["Table8"].Clear(); System.Data.DataTable tab0 = Common.FixDBManager.ConvertToDataTable(aList[8] as ArrayList, this.dataSet2.Tables["Table8"]); tab0.TableName = "Table8"; this.dataSet2.Tables["Table8"].Merge(tab0); } } //if (frmdoquery != null) // frmdoquery(); } //private int currentDef = 0;//当前缺陷个数 //private int maxDef = 5;//最多5个缺陷 public SortedList al = null;//存入选中的钢卷缺陷 private void button1_Click(object sender, EventArgs e) { try { al = new SortedList(); string strMian = ""; string strCe = ""; string strTou = ""; string strDaxiao = ""; string strDuoshao = ""; string strShougan = ""; string strShijue = ""; string strQita = ""; foreach (UltraGridRow ugr in this.ultraGrid1.Rows) { if (ugr.Cells["CHK"].Text.ToLower() == "true") { if (ugr.Cells["QUEXIAN_TP"].Value == null) { MessageBox.Show("请选择缺陷来源次！" , "提示"); return; } strMian = ugr.Cells["MIAN_DESC"].Value.ToString() == "" ? "-" : ugr.Cells["MIAN_DESC"].Value.ToString(); strCe = ugr.Cells["CE_DESC"].Value.ToString() == "" ? "-" : ugr.Cells["CE_DESC"].Value.ToString(); strTou = ugr.Cells["TOU_DESC"].Value.ToString() == "" ? "-" : ugr.Cells["TOU_DESC"].Value.ToString(); strDaxiao = ugr.Cells["DAXIAO_DESC"].Value.ToString() == "" ? "-" : ugr.Cells["DAXIAO_DESC"].Value.ToString(); strDuoshao = ugr.Cells["DUOSHAO_DESC"].Value.ToString() == "" ? "-" : ugr.Cells["DUOSHAO_DESC"].Value.ToString(); strShougan = ugr.Cells["SHOUGAN_DESC"].Value.ToString() == "" ? "-" : ugr.Cells["SHOUGAN_DESC"].Value.ToString(); strShijue = ugr.Cells["SHIJUE_DESC"].Value.ToString() == "" ? "-" : ugr.Cells["SHIJUE_DESC"].Value.ToString(); strQita = ugr.Cells["QITA_DESC"].Value.ToString() == "" ? "-" : ugr.Cells["QITA_DESC"].Value.ToString(); al.Add(ugr.Cells["NUMX"].Text, ugr.Cells["SM_CD"].Value.ToString() + ugr.Cells["QUEXIAN_TP"].Value.ToString() + "【" + ugr.Cells["MIAN_DESC"].Text + "；" + ugr.Cells["CE_DESC"].Text + "；" + ugr.Cells["TOU_DESC"].Text + "；" + ugr.Cells["DAXIAO_DESC"].Text + "；" + ugr.Cells["DUOSHAO_DESC"].Text + ugr.Cells["SHOUGAN_DESC"].Text + "；" + ugr.Cells["SHIJUE_DESC"].Text + "；" + ugr.Cells["QITA_DESC"].Text + "】" + " 【" + ugr.Cells["SM_CD"].Value.ToString() + strMian + strCe + strTou + strDaxiao + strDuoshao + strShougan + strShijue + strQita + "】"); } } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } this.DialogResult = DialogResult.OK; } private int iflag = 1; private void ultraGrid1_CellChange(object sender, CellEventArgs e) { if (e.Cell.Column.Key == "CHK") { if (e.Cell.Text.ToLower() == "true") { this.ultraGrid1.ActiveRow.Cells["NUMX"].Value = iflag.ToString(); iflag++; } else { this.ultraGrid1.ActiveRow.Cells["NUMX"].Value = ""; } } this.ultraGrid1.UpdateData(); } private void button2_Click(object sender, EventArgs e) { this.Close(); } private void ultraGrid1_AfterHeaderCheckStateChanged(object sender, AfterHeaderCheckStateChangedEventArgs e) { } } }