XinYu_LZMES_Client/.svn/pristine/f7/f7c3264c3f3212b41e8f17f6efbf84ade62b61ff.svn-base

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 Infragistics.Win.UltraWinGrid;

namespace Core.LZMes.Client.UIK
{
    public partial class UIK040040 : FrmBase
    {
        public UIK040040()
        {
            InitializeComponent();
        }

        string mcID = null;
        string mcIDName = null;
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    this.DoQuery();
                    break;
                case "Save"://保存（上）
                    this.DoSave();
                    break;
                case "Save1"://保存(下)
                    this.DoSave_1();
                    break;
                case "Delete"://上
                    this.DoDelete("S");
                    break;
                case "Delete1"://删除下
                    this.DoDelete("X");
                    break;
            }
        }

        public void DoQuery()
        {
            try
            {
                if (this.ultraTabControl1.SelectedTab.Index == 0)
                {
                    this.dataSet1.Tables[0].Clear();
                    ArrayList al = new ArrayList();
                    
                    al.Add("UIK040040_01.SELECT");
                    al.Add(this.textBox1.Text.ToString().Trim());
                    al.Add(this.textBox2.Text.ToString().Trim());
                    // al.Add(this.comboBox1.SelectedValue.ToString());

                    CoreClientParam ccp = new CoreClientParam();
                    ccp.ServerName = "UIB.COM.ComDBQuery";
                    ccp.MethodName = "doSimpleQuery";
                    ccp.ServerParams = new object[] { al };
                    ccp.SourceDataTable = this.dataSet1.Tables[0];
                    this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                }
                else if (this.ultraTabControl1.SelectedTab.Index == 1)
                {
                    this.dataSet1.Tables[3].Clear();
                    ArrayList al = new ArrayList();
                    al.Add("UIK040040_04.SELECT");
                    al.Add(this.textBox1.Text.ToString().Trim());
                    al.Add(this.textBox2.Text.ToString().Trim());
                    // al.Add(this.comboBox1.SelectedValue.ToString());

                    CoreClientParam ccp = new CoreClientParam();
                    ccp.ServerName = "UIB.COM.ComDBQuery";
                    ccp.MethodName = "doSimpleQuery";
                    ccp.ServerParams = new object[] { al };
                    ccp.SourceDataTable = this.dataSet1.Tables[3];
                    this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                }
                else if (this.ultraTabControl1.SelectedTab.Index == 2)
                {
                    this.dataSet1.Tables[2].Clear();
                    ArrayList al = new ArrayList();
                    al.Add("UIK040040_03.SELECT");
                    al.Add(this.textBox1.Text.ToString().Trim());
                    al.Add(this.textBox2.Text.ToString().Trim());
                    CoreClientParam ccp = new CoreClientParam();
                    ccp.ServerName = "UIB.COM.ComDBQuery";
                    ccp.MethodName = "doSimpleQuery";
                    ccp.ServerParams = new object[] { al };
                    ccp.SourceDataTable = this.dataSet1.Tables[2];
                    this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                }

            }
            catch (Exception ex)
            {
            }
        }

        public void DoSave()
        {
            try
            {
                ArrayList list = null;
                if (this.ultraTabControl1.SelectedTab.Index == 0)
                {
                    foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
                    {
                        if (Convert.ToBoolean(ugr.Cells["CHK"].Value))
                        {
                            if (ugr.Cells["MC_ID_FLAG"].Text == "")//insert
                            {
                                list = new ArrayList();
                                list.Add("UIK040040_01.INSERT");
                                list.Add(ugr.Cells["MC_ID"].Text);
                                list.Add(ugr.Cells["MC_NAME"].Text);
                                list.Add(ugr.Cells["MC_MODEL"].Text);
                                list.Add(ugr.Cells["MC_SPEC"].Text);
                                list.Add(ugr.Cells["MC_STARTTIME"].Text);
                                list.Add(ugr.Cells["MC_CHANGTIME"].Text);
                                list.Add(ugr.Cells["MC_CHECKTIME"].Text);
                                list.Add(ugr.Cells["AREA"].Text);
                                list.Add(ugr.Cells["MC_UNIT"].Text);
                                list.Add(ugr.Cells["MC_STAT"].Text);
                                list.Add(this.UserInfo.GetUserName());
                                list.Add(ugr.Cells["MC_CHECKCYCLE"].Text);
                                list.Add(ugr.Cells["MC_CHANGCYCLE"].Text);
                                list.Add(ugr.Cells["NX_MC_CHECKTIME"].Text);
                                list.Add(ugr.Cells["NX_MC_CHANGTIME"].Text);
                                list.Add(ugr.Cells["SU_MC_ID"].Text);
                                list.Add(ugr.Cells["MAIN_MC_NAME"].Text);
                           //     list.Add(ugr.Cells["DDDD"].Text);
                                CoreClientParam ccp = new CoreClientParam();
                                ccp.ServerName = "UIB.COM.ComDBSave";
                                ccp.ServerParams = new object[] { list };
                                ccp.MethodName = "doXmlSave";
                                this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                            }
                            else if (ugr.Cells["MC_ID_FLAG"].Text != "")//update
                            {
                                list = new ArrayList();
                                list.Add("UIK040040_01.UPDATE");
                              //  list.Add(ugr.Cells["MC_ID"].Text);
                                list.Add(ugr.Cells["MC_NAME"].Text);
                                list.Add(ugr.Cells["MC_MODEL"].Text);
                                list.Add(ugr.Cells["MC_SPEC"].Text);
                                list.Add(ugr.Cells["MC_STARTTIME"].Text);
                                list.Add(ugr.Cells["MC_CHANGTIME"].Text);
                                list.Add(ugr.Cells["MC_CHECKTIME"].Text);
                                list.Add(ugr.Cells["AREA"].Text);
                                //list.Add(ugr.Cells["MC_NOM_CAP"].Text);
                                list.Add(ugr.Cells["MC_UNIT"].Text);
                                list.Add(ugr.Cells["MC_STAT"].Text);
                                list.Add(this.UserInfo.GetUserName());
                                list.Add(ugr.Cells["MC_CHECKCYCLE"].Text);
                                list.Add(ugr.Cells["MC_CHANGCYCLE"].Text);
                                list.Add(ugr.Cells["NX_MC_CHECKTIME"].Text);
                                list.Add(ugr.Cells["NX_MC_CHANGTIME"].Text);
                                list.Add(ugr.Cells["SU_MC_ID"].Text);
                                list.Add(ugr.Cells["MAIN_MC_NAME"].Text);
                                list.Add(ugr.Cells["MC_ID_FLAG"].Text);
                                CoreClientParam ccp = new CoreClientParam();
                                ccp.ServerName = "UIB.COM.ComDBSave";
                                ccp.ServerParams = new object[] { list };
                                ccp.MethodName = "doXmlSave";
                                this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                            }
                        }
                    }
                }
                else if (this.ultraTabControl1.SelectedTab.Index == 1)
                {
                    Hashtable ht = null;
                    foreach (UltraGridRow ugr in this.ultraGrid4.Rows)
                    {
                        if (ugr.Cells["CHK"].Text.ToString() == "True")
                        {
                            if (ugr.Cells["MC_ID_FLAG"].Text == "")//insert
                            {
                                CoreClientParam ccp = new CoreClientParam();
                                ht = new Hashtable();
                                ht.Add("i1", ugr.Cells["MC_ID"].Text);
                                ht.Add("i2", ugr.Cells["MC_NAME"].Text);
                                ht.Add("i3", "");
                                ht.Add("i4", "");
                                ht.Add("i5", "");
                                ht.Add("i6", "");
                                ht.Add("i7", "");
                                ht.Add("i8", "");
                                ht.Add("i9", "");
                                ht.Add("i10", "");
                                ht.Add("i11", "");
                                ht.Add("i12", "");
                                ht.Add("i13", "");
                                ht.Add("i14", "");
                                ht.Add("i15", "");
                                ht.Add("i16", "");
                                ht.Add("i17", "");
                                ht.Add("i18", "");
                                ht.Add("i19", "");
                                ht.Add("i20", ugr.Cells["AREA"].Text);
                                ht.Add("i21", ugr.Cells["MC_ID_FLAG"].Text);
                                ht.Add("i22", "");
                                ht.Add("i23", "AI");
                                ht.Add("i24", ugr.Cells["ZJ_RH_DS1"].Text);
                                ht.Add("i25", ugr.Cells["ZJ_RH_DS2"].Text);
                                ht.Add("i26", ugr.Cells["ZJ_RH_DS3"].Text);
                                ht.Add("i27", ugr.Cells["ND_HYL1"].Text);
                                ht.Add("i28", ugr.Cells["ND_HYL2"].Text);
                                ht.Add("i29", ugr.Cells["ND_HYL3"].Text);
                                ht.Add("o30", "");
                                ccp.ServerName = "UIB.COM.ComDBProcedure";
                                ccp.MethodName = "doXmlProcedure";
                                ccp.ServerParams = new object[] { "UIK040040_01.CALL", ht };
                                this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                            }
                            else//update
                            {
                                CoreClientParam ccp = new CoreClientParam();
                                ht = new Hashtable();
                                ht.Add("i1", ugr.Cells["MC_ID"].Text);
                                ht.Add("i2", ugr.Cells["MC_NAME"].Text);
                                ht.Add("i3", "");
                                ht.Add("i4", "");
                                ht.Add("i5", "");
                                ht.Add("i6", "");
                                ht.Add("i7", "");
                                ht.Add("i8", "");
                                ht.Add("i9", "");
                                ht.Add("i10", "");
                                ht.Add("i11", "");
                                ht.Add("i12", "");
                                ht.Add("i13", "");
                                ht.Add("i14", "");
                                ht.Add("i15", "");
                                ht.Add("i16", "");
                                ht.Add("i17", "");
                                ht.Add("i18", "");
                                ht.Add("i19", "");
                                ht.Add("i20", ugr.Cells["AREA"].Text);
                                ht.Add("i21", ugr.Cells["MC_ID_FLAG"].Text);
                                ht.Add("i22", "");
                                ht.Add("i23", "AU");
                                ht.Add("i24", ugr.Cells["ZJ_RH_DS1"].Text);
                                ht.Add("i25", ugr.Cells["ZJ_RH_DS2"].Text);
                                ht.Add("i26", ugr.Cells["ZJ_RH_DS3"].Text);
                                ht.Add("i27", ugr.Cells["ND_HYL1"].Text);
                                ht.Add("i28", ugr.Cells["ND_HYL2"].Text);
                                ht.Add("i29", ugr.Cells["ND_HYL3"].Text);
                                ht.Add("o30", "");
                                ccp.ServerName = "UIB.COM.ComDBProcedure";
                                ccp.MethodName = "doXmlProcedure";
                                ccp.ServerParams = new object[] { "UIK040040_01.CALL", ht };
                                this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                            }
                        }
                    }
                }
                else if (this.ultraTabControl1.SelectedTab.Index == 2)
                {
                    Hashtable ht = null;
                    foreach (UltraGridRow ugr in this.ultraGrid3.Rows)
                    {
                        if (ugr.Cells["CHK"].Text.ToString() == "True")
                        {
                            if (ugr.Cells["MC_ID_FLAG"].Text == "")//insert
                            {
                                CoreClientParam ccp = new CoreClientParam();
                                ht = new Hashtable();
                                ht.Add("i1", ugr.Cells["MC_ID"].Text);
                                ht.Add("i2", ugr.Cells["MC_NAME"].Text);
                                ht.Add("i3", ugr.Cells["SUB_MC_ID"].Text);
                                ht.Add("i4", ugr.Cells["SUB_MC_NAME"].Text);
                                ht.Add("i5", ugr.Cells["WH_BW"].Text);
                                ht.Add("i6", ugr.Cells["WH_NR"].Text);
                                ht.Add("i7", ugr.Cells["BZ"].Text);
                                ht.Add("i8", ugr.Cells["WH_SJ"].Text);
                                ht.Add("i9", ugr.Cells["XC_WH_SJ"].Text);
                                ht.Add("i10", ugr.Cells["WH_REN"].Text);
                                ht.Add("i11", ugr.Cells["WH_ZQ"].Text);
                                ht.Add("i12", ugr.Cells["MC_ID"].Text);
                                ht.Add("i13", ugr.Cells["SUB_MC_ID"].Text);
                                ht.Add("i14", "A");
                                ht.Add("i15", ugr.Cells["AREA"].Text);
                                ht.Add("o16", "");
                                ccp.ServerName = "UIB.COM.ComDBProcedure";
                                ccp.MethodName = "doXmlProcedure";
                                ccp.ServerParams = new object[] { "UIK040040_02.CALL", ht };
                                this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                            }
                            else//update
                            {
                                CoreClientParam ccp = new CoreClientParam();
                                ht = new Hashtable();
                                ht.Add("i1", ugr.Cells["MC_ID"].Text);
                                ht.Add("i2", ugr.Cells["MC_NAME"].Text);
                                ht.Add("i3", ugr.Cells["SUB_MC_ID"].Text);
                                ht.Add("i4", ugr.Cells["SUB_MC_NAME"].Text);
                                ht.Add("i5", ugr.Cells["WH_BW"].Text);
                                ht.Add("i6", ugr.Cells["WH_NR"].Text);
                                ht.Add("i7", ugr.Cells["BZ"].Text);
                                ht.Add("i8", ugr.Cells["WH_SJ"].Text);
                                ht.Add("i9", ugr.Cells["XC_WH_SJ"].Text);
                                ht.Add("i10", ugr.Cells["WH_REN"].Text);
                                ht.Add("i11", ugr.Cells["WH_ZQ"].Text);
                                ht.Add("i12", ugr.Cells["MC_ID"].Text);
                                ht.Add("i13", ugr.Cells["SUB_MC_ID"].Text);
                                ht.Add("i14", "B");
                                ht.Add("i15", ugr.Cells["AREA"].Text);
                                ht.Add("o16", "");
                                ccp.ServerName = "UIB.COM.ComDBProcedure";
                                ccp.MethodName = "doXmlProcedure";
                                ccp.ServerParams = new object[] { "UIK040040_02.CALL", ht };
                                this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                            }
                        }
                    }
                }
                this.DoQuery();
            }catch(Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }

        public void DoDelete(string str)
        {
            try
            {
                if (MessageBox.Show("确定删除？", "提示", MessageBoxButtons.OKCancel) == DialogResult.Cancel)
                    return;

                 Hashtable ht = null;
                 if (this.ultraTabControl1.SelectedTab.Index == 0)
                 {
                     foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
                     {
                         if (ugr.Cells["CHK"].Text.ToString() == "True")
                         {
                             CoreClientParam ccp = new CoreClientParam();
                             ht = new Hashtable();
                             ht.Add("i1", ugr.Cells["MC_ID"].Text);
                             ht.Add("i2", "");
                             ht.Add("i3", "AX");
                             ht.Add("o4", "");
                             ccp.ServerName = "UIB.COM.ComDBProcedure";
                             ccp.MethodName = "doXmlProcedure";
                             ccp.ServerParams = new object[] { "UIK040040_03.CALL", ht };
                             this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                         }
                     }
                 }
                 else if (this.ultraTabControl1.SelectedTab.Index == 1)
                 {
                     if (str == "S")
                     {
                         foreach (UltraGridRow ugr in this.ultraGrid4.Rows)//删除（上）
                         {
                             if (ugr.Cells["CHK"].Text.ToString() == "True")
                             {
                                 CoreClientParam ccp = new CoreClientParam();
                                 ht = new Hashtable();
                                 ht.Add("i1", ugr.Cells["MC_ID"].Text);
                                 ht.Add("i2", "");
                                 ht.Add("i3", "AS");
                                 ht.Add("o4", "");
                                 ccp.ServerName = "UIB.COM.ComDBProcedure";
                                 ccp.MethodName = "doXmlProcedure";
                                 ccp.ServerParams = new object[] { "UIK040040_03.CALL", ht };
                                 this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                             }
                         }
                     }
                     else if(str == "X")
                     {
                         foreach (UltraGridRow ugr in this.ultraGrid2.Rows)//删除（下）
                         {
                             if (ugr.Cells["CHK"].Text.ToString() == "True")
                             {
                                 CoreClientParam ccp = new CoreClientParam();
                                 ht = new Hashtable();
                                 ht.Add("i1", ugr.Cells["MC_ID"].Text);
                                 ht.Add("i2", ugr.Cells["SUB_MC_ID"].Text);
                                 ht.Add("i3", "AX");
                                 ht.Add("o4", "");
                                 ccp.ServerName = "UIB.COM.ComDBProcedure";
                                 ccp.MethodName = "doXmlProcedure";
                                 ccp.ServerParams = new object[] { "UIK040040_03.CALL", ht };
                                 this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                             }
                         }
                     }
                 }
                 else if (this.ultraTabControl1.SelectedTab.Index == 2)
                 {
                     foreach (UltraGridRow ugr in this.ultraGrid3.Rows)
                     {
                         if (ugr.Cells["CHK"].Text.ToString() == "True")
                         {
                             CoreClientParam ccp = new CoreClientParam();
                             ht = new Hashtable();
                             ht.Add("i1", ugr.Cells["MC_ID"].Text);
                             ht.Add("i2", ugr.Cells["SUB_MC_ID"].Text);
                             ht.Add("i3", "B");
                             ht.Add("o4", "");
                             ccp.ServerName = "UIB.COM.ComDBProcedure";
                             ccp.MethodName = "doXmlProcedure";
                             ccp.ServerParams = new object[] { "UIK040040_03.CALL", ht };
                             this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                         }
                     }
                 }
                 this.DoQuery();
            }
            catch (Exception ex)
            {

            }
        }

        private void ultraGrid1_DoubleClick(object sender, EventArgs e)
        {
            //try
            //{

            //}
            //catch (Exception ex)
            //{
            //}
        }

        private void label1_Click(object sender, EventArgs e)
        {

        }

        public void DoSave_1()
        {
            try
            {
                Hashtable ht = null;
                foreach (UltraGridRow ugr in this.ultraGrid2.Rows)
                {
                    if (ugr.Cells["CHK"].Text.ToString() == "True")
                    {
                        if (ugr.Cells["MC_ID_FLAG"].Text == "")//insert
                        {
                            CoreClientParam ccp = new CoreClientParam();
                            ht = new Hashtable();
                            ht.Add("i1", this.mcID);
                            ht.Add("i2", this.mcIDName);
                            ht.Add("i3", ugr.Cells["SUB_MC_ID"].Text);
                            ht.Add("i4", ugr.Cells["SUB_MC_NAME"].Text);
                            ht.Add("i5", ugr.Cells["RH_BW"].Text);
                            ht.Add("i6", ugr.Cells["RH_DS"].Text);
                            ht.Add("i7", ugr.Cells["RH_HF"].Text);
                            ht.Add("i8", ugr.Cells["RH_YP_TYPE"].Text);
                            ht.Add("i9", ugr.Cells["RH_YP_VALUE"].Text);
                            ht.Add("i10", ugr.Cells["BY_ZQ"].Text);
                            ht.Add("i11", ugr.Cells["BYL"].Text);
                            ht.Add("i12", ugr.Cells["HDY_ZQ"].Text);
                            ht.Add("i13", ugr.Cells["HDYL"].Text);
                            ht.Add("i14", ugr.Cells["HDY_FZR"].Text);
                            ht.Add("i15", ugr.Cells["HDY_SJ"].Text);
                            ht.Add("i16", ugr.Cells["HDY_XC_SJ"].Text);
                            ht.Add("i17", ugr.Cells["BJY_FZR"].Text);
                            ht.Add("i18", ugr.Cells["BJY_SJ"].Text);
                            ht.Add("i19", ugr.Cells["BJY_XC_SJ"].Text);
                            ht.Add("i20", ugr.Cells["AREA"].Text);
                            ht.Add("i21", this.mcID);
                            ht.Add("i22", ugr.Cells["SUB_MC_ID_FLAG"].Text);
                            ht.Add("i23", "B");
                            ht.Add("i24", "");
                            ht.Add("i25", "");
                            ht.Add("i26", "");
                            ht.Add("i27", "");
                            ht.Add("i28", "");
                            ht.Add("i29", "");
                            ht.Add("o30", "");
                            ccp.ServerName = "UIB.COM.ComDBProcedure";
                            ccp.MethodName = "doXmlProcedure";
                            ccp.ServerParams = new object[] { "UIK040040_01.CALL", ht };
                            this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                        }
                        else
                        {
                            CoreClientParam ccp = new CoreClientParam();
                            ht = new Hashtable();
                            ht.Add("i1", ugr.Cells["MC_ID"].Text);
                            ht.Add("i2", ugr.Cells["MC_NAME"].Text);
                            ht.Add("i3", ugr.Cells["SUB_MC_ID"].Text);
                            ht.Add("i4", ugr.Cells["SUB_MC_NAME"].Text);
                            ht.Add("i5", ugr.Cells["RH_BW"].Text);
                            ht.Add("i6", ugr.Cells["RH_DS"].Text);
                            ht.Add("i7", ugr.Cells["RH_HF"].Text);
                            ht.Add("i8", ugr.Cells["RH_YP_TYPE"].Text);
                            ht.Add("i9", ugr.Cells["RH_YP_VALUE"].Text);
                            ht.Add("i10", ugr.Cells["BY_ZQ"].Text);
                            ht.Add("i11", ugr.Cells["BYL"].Text);
                            ht.Add("i12", ugr.Cells["HDY_ZQ"].Text);
                            ht.Add("i13", ugr.Cells["HDYL"].Text);
                            ht.Add("i14", ugr.Cells["HDY_FZR"].Text);
                            ht.Add("i15", ugr.Cells["HDY_SJ"].Text);
                            ht.Add("i16", ugr.Cells["HDY_XC_SJ"].Text);
                            ht.Add("i17", ugr.Cells["BJY_FZR"].Text);
                            ht.Add("i18", ugr.Cells["BJY_SJ"].Text);
                            ht.Add("i19", ugr.Cells["BJY_XC_SJ"].Text);
                            ht.Add("i20", ugr.Cells["AREA"].Text);
                            ht.Add("i21", this.mcID);
                            ht.Add("i22", ugr.Cells["SUB_MC_ID_FLAG"].Text);
                            ht.Add("i23", "C");
                            ht.Add("i24", "");
                            ht.Add("i25", "");
                            ht.Add("i26", "");
                            ht.Add("i27", "");
                            ht.Add("i28", "");
                            ht.Add("i29", "");
                            ht.Add("o30", "");
                            ccp.ServerName = "UIB.COM.ComDBProcedure";
                            ccp.MethodName = "doXmlProcedure";
                            ccp.ServerParams = new object[] { "UIK040040_01.CALL", ht };
                            this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                        }
                    }
                   
                }
            }
            catch (Exception ex)
            {
            }
        }

        private void ultraGrid2_AfterRowActivate(object sender, EventArgs e)
        {
        }

        private void ultraGrid4_AfterRowActivate(object sender, EventArgs e)
        {

            try
            {
                this.dataSet1.Tables[1].Clear();
                ArrayList al = new ArrayList();
                al.Add("UIK040040_02.SELECT");
                al.Add(this.ultraGrid4.ActiveRow.Cells["MC_ID"].Text.ToString());
                // al.Add(this.comboBox1.SelectedValue.ToString());

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIB.COM.ComDBQuery";
                ccp.MethodName = "doSimpleQuery";
                ccp.ServerParams = new object[] { al };
                ccp.SourceDataTable = this.dataSet1.Tables[1];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);

                this.mcID = this.ultraGrid4.ActiveRow.Cells["MC_ID"].Text.ToString();
                this.mcIDName = this.ultraGrid4.ActiveRow.Cells["MC_NAME"].Text.ToString();

            }
            catch (Exception ex)
            {
            }

        }
    }
}