XinYu_LZMES_Client/Core.LZMes.Client.QCM/ChildWindows/CUIB030110.cs

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<SortedList> 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)
        {

        }


    }
}