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; using Infragistics.Win; namespace Core.LZMes.Client.QCM { 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 = "QCM.COMMUNAL.ComDBQueryQCM"; 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(); ValueList vis_repair = new ValueList(); vis_repair.ValueListItems.Add("0", "待修复"); vis_repair.ValueListItems.Add("1", "已修复"); this.ultraGrid1.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.ultraGrid1.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.ultraGrid1.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.ultraGrid1.DisplayLayout.Bands[0].Columns["FLAW_POS_DESC"].ValueList = vflaw_pos_desc; ValueList VFLAW_SIZE_DESC = new ValueList(); ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM03.QCM0305.QcmJudgeSurfaceServiceImpl"; ccp.MethodName = "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.ultraGrid1.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.ultraGrid1.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.ultraGrid1.DisplayLayout.Bands[0].Columns["FLAW_DIR_DESC"].ValueList = VFLAW_DIR_DESC; ValueList VFLAW_DESC = new ValueList(); ccp.ServerName = "QCM.QCM03.QCM0305.QcmJudgeSurfaceServiceImpl"; ccp.MethodName = "findFlawDataJ"; ccp.ServerParams = new object[] { "连退" }; VFLAW_DESC.ValueListItems.Add(ccp.SourceDataTable.Rows[1]["SM_CD"].ToString()); CoreClientParam ccpList = this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); //for (int i = 0; i < ccp.SourceDataTable.Rows.Count; i++) //{ // VFLAW_DESC.ValueListItems.Add(ccp.SourceDataTable.Rows[i]["DEFECT_CODE"].ToString(), ccp.SourceDataTable.Rows[i]["DEFECT_DESC"].ToString()); //} //this.ultraGrid1.DisplayLayout.Bands[0].Columns["DEFECT_DESC"].ValueList = VFLAW_DESC; //ccp.SourceDataTable = this.dataSet4.Tables[0]; //this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); ArrayList aList = ccpList.ReturnObject as ArrayList; this.dataSet4.Tables[0].Clear(); System.Data.DataTable tab0 = Common.FixDBManager.ConvertToDataTable(aList as ArrayList, this.dataSet4.Tables[0]); tab0.TableName = "Table1"; this.dataSet4.Tables[0].Merge(tab0); //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;//存入选中的钢卷缺陷 public SortedList a2 = null; public List a3 = null; private void button1_Click(object sender, EventArgs e) { try { al = new SortedList(); a2 = new SortedList(); string strMian = ""; string strCe = ""; string strTou = ""; string strDaxiao = ""; string strDuoshao = ""; string strShougan = ""; string strChengdu = ""; string strMemo = ""; string strRepair = ""; string strRepair_flag = ""; string strShijue = ""; string strQita = ""; string defect_desc = ""; foreach (UltraGridRow ugr in this.ultraGrid1.Rows) { if (ugr.Cells["CHK"].Text.ToLower() == "true" ) { if (currentDef++ >= maxDef) { MessageBox.Show("最多选择5条缺陷，请关闭窗口重新选择！", "提示"); return; } if (ugr.Cells["QUEXIAN_TP"].Text.ToString() == null || ugr.Cells["QUEXIAN_TP"].Text.ToString() == "") { MessageBox.Show("请选择缺陷来源次！", "提示"); return; } string aaa = ugr.Cells["DEFECT_CODE"].Value.ToString(); string aaa1 = ugr.Cells["DEFECT_CODE"].Text.ToString(); string aaa2 = ugr.Cells["DEFECT_DESC"].Text.ToString(); strRepair = ugr.Cells["IS_REPAIR"].Value.ToString(); defect_desc = ugr.Cells["DEFECT_DESC"].Value.ToString(); strRepair_flag = ugr.Cells["PRIMARY_FLAG"].Value.ToString(); strMian = ugr.Cells["FLAW_AREA"].Value.ToString(); strCe = ugr.Cells["FLAW_DIR_DESC"].Value.ToString(); strTou = ugr.Cells["FLAW_POS_DESC"].Value.ToString(); strDaxiao = ugr.Cells["FLAW_SIZE_DESC"].Value.ToString(); strDuoshao = ugr.Cells["FLAW_QUANTITY"].Value.ToString(); strChengdu = ugr.Cells["FLAW_LV_DESC"].Value.ToString(); strMemo = ugr.Cells["MEMO"].Value.ToString(); /*a2.Add(0, ugr.Cells["IS_REPAIR"].Value.ToString()); a2.Add(1, ugr.Cells["NUMX"].Text); a2.Add(2, ugr.Cells["PRIMARY_FLAG"].Value.ToString()); a2.Add(3, ugr.Cells["DEFECT_DESC"].Value.ToString()); a2.Add(4, ugr.Cells["FLAW_AREA"].Value.ToString()); a2.Add(5, ugr.Cells["FLAW_POS_DESC"].Value.ToString()); a2.Add(6, ugr.Cells["FLAW_DIR_DESC"].Value.ToString()); a2.Add(7, ugr.Cells["FLAW_SIZE_DESC"].Value.ToString()); a2.Add(8, ugr.Cells["FLAW_QUANTITY"].Value.ToString()); a2.Add(9, ugr.Cells["FLAW_LV_DESC"].Value.ToString()); a2.Add(10, ugr.Cells["MEMO"].Value.ToString());*/ //a3.Add(a2); if (ugr.Cells["NUMX"].Text.ToString() != "1" && ugr.Cells["PRIMARY_FLAG"].Text.ToString() == "是") { MessageBox.Show("请把序号为1的缺陷选为主要缺陷！"); return; } /*al.Add(ugr.Cells["NUMX"].Text, ugr.Cells["QUEXIAN_TP"].Value.ToString() + "【" + "" + ";" + ugr.Cells["IS_REPAIR"].Text.ToString() + ";" + ugr.Cells["PRIMARY_FLAG"].Text.ToString() + ";" + ugr.Cells["FLAW_AREA"].Text + ";" + ugr.Cells["FLAW_POS_DESC"].Text + ";" + ugr.Cells["FLAW_DIR_DESC"].Text + ";" + ugr.Cells["FLAW_SIZE_DESC"].Text + ";" + ugr.Cells["FLAW_QUANTITY"].Text + ";" + ugr.Cells["FLAW_LV_DESC"].Text + ";" + ugr.Cells["MEMO"].Text + "】" );*/ al.Add(ugr.Cells["NUMX"].Text, ugr.Cells["QUEXIAN_TP"].Value.ToString() + "【" + ugr.Cells["FLAW_AREA"].Text + ";" + ugr.Cells["FLAW_POS_DESC"].Text + ";" + ugr.Cells["FLAW_DIR_DESC"].Text + ";" + ugr.Cells["FLAW_SIZE_DESC"].Text + ";" + ugr.Cells["FLAW_QUANTITY"].Text + ";" + ugr.Cells["FLAW_LV_DESC"].Text + ";" + ugr.Cells["IS_REPAIR"].Text.ToString() + ";" + ugr.Cells["PRIMARY_FLAG"].Text.ToString() + ";" + "" + ";" + ugr.Cells["MEMO"].Text + "】" ); a2.Add(ugr.Cells["NUMX"].Text, "【" + ugr.Cells["DEFECT_CODE"].Value.ToString() + ";" + ugr.Cells["IS_REPAIR"].Value.ToString() + ";" + ugr.Cells["PRIMARY_FLAG"].Value.ToString() + ";" + ugr.Cells["FLAW_AREA"].Value.ToString() + ";" + ugr.Cells["FLAW_POS_DESC"].Value.ToString() + ";" + ugr.Cells["FLAW_DIR_DESC"].Value + ";" + ugr.Cells["FLAW_SIZE_DESC"].Value.ToString() + ";" + ugr.Cells["FLAW_QUANTITY"].Value.ToString() + ";" + ugr.Cells["FLAW_LV_DESC"].Value.ToString() + ";" + ugr.Cells["MEMO"].Value.ToString()+ "】" ); } } } 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) { } private void ultraGrid1_InitializeLayout_1(object sender, InitializeLayoutEventArgs e) { } } }