XinYu_LZMES_Client/Core.LZMes.Client.UIB/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;

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


    }
}