XinYu_LZMES_Client/.svn/pristine/40/40737ba3e4a5b60f5182c0d69503e43c3ead2991.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;

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

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    this.DoQuery();
                    break;
                case "Export":
                    this.DoExport();
                    break;
            }
        }

        public void init()
        {
            this.regFromDTime.Value = DateTime.Today;
            this.regToDTime.Value = DateTime.Today;
            string commCodeCd = "A01004";
            DataTable dt = new DataTable();
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "UIB.COM.ComDBQuery";
            ccp.MethodName = "doSimpleQuery";
            ArrayList paramArray = new ArrayList();
            paramArray.Add("UIECOMM00_SELECT.COMM_CODE");
            paramArray.Add(commCodeCd);
            ccp.ServerParams = new object[] { paramArray };
            ccp.SourceDataTable = dt;
            this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
            Core.LZMes.Client.UIE.UIE041.UIEBase.Init_ComboControl(this.ComboMatType, ref dt, "A01004");
        }

        private void DoQuery()
        {
            try
            {
                string bfOrdNO = Convert.ToString(Common.FixDBManager.CheckNullStr(this.uptBfOrdNO.Text));
                string bfOrdSeq = Convert.ToString(Common.FixDBManager.CheckNullStr(this.uptBfOrdSeq.Value));
                string bkOrdNO = Convert.ToString(Common.FixDBManager.CheckNullStr(this.uptAftOrdNO.Text));
                string bkOrdSeq = Convert.ToString(Common.FixDBManager.CheckNullStr(this.uptAftOrdSeq.Value));
                string matType = Convert.ToString(Common.FixDBManager.CheckNullStr(this.ComboMatType.Value));
                string matNO = Convert.ToString(Common.FixDBManager.CheckNullStr(this.textMatNO.Text));
                string regFrmTime = Convert.ToString(Common.FixDBManager.CheckNullStr(this.regFromDTime.DateTime.ToString("yyyyMMdd")));
                string regToTime = Convert.ToString(Common.FixDBManager.CheckNullStr(this.regToDTime.DateTime.ToString("yyyyMMdd")));
                this.dataSet1.Tables[0].Clear();

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIB.COM.ComDBQuery";
                ccp.MethodName = "doSimpleQuery";
                ArrayList paramArray = new ArrayList();
                paramArray.Add("UIE043040.select");
                paramArray.Add(matNO);
                paramArray.Add(matType);
                paramArray.Add(regFrmTime);
                paramArray.Add(regToTime);
                paramArray.Add(bfOrdNO);
                paramArray.Add(bfOrdSeq);
                paramArray.Add(bkOrdNO);
                paramArray.Add(bkOrdSeq);
                ccp.ServerParams = new object[] { paramArray };
                ccp.SourceDataTable = this.dataSet1.Tables[0];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                Console.WriteLine(this.dataSet1.Tables[0].ToString());
            }
            catch (Exception EX)
            {
                MessageBox.Show(EX.ToString());
            }
        }
        private void DoExport()
        {
            try
            {
                if (this.saveFileDialog1.ShowDialog(this) == DialogResult.OK)
                {
                    string fileName = this.saveFileDialog1.FileName;
                    ultraGridExcelExporter1.Export(ultraGrid1, fileName);
                    System.Diagnostics.Process.Start(fileName);
                }
            }
            catch (Exception EX)
            {
                MessageBox.Show(EX.ToString());
            }
        }
        private void uptAftOrdNO_TextChanged(object sender, EventArgs e)
        {
            //A01007 订单用途   A01004 产品类型  A01001 订单类型 B01016 表面等级
            //string ordNO = this.uptAftOrdNO.Text;
            //DataTable dt = new DataTable();
            //CoreClientParam ccp = new CoreClientParam();
            //ccp.ServerName = "UIB.COM.ComDBQuery";
            //ccp.MethodName = "doSimpleQuery";
            //ArrayList paramArray = new ArrayList();
            //paramArray.Add("SELECT.ORD_SEQ");
            //paramArray.Add(ordNO);
            //ccp.ServerParams = new object[] { paramArray };
            //ccp.SourceDataTable = dt;
            //this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
            //Core.LZMes.Client.UIE.UIE041.UIEBase.Init_ComboControl(this.uptAftOrdSeq, ref dt, "ORD_SEQ");
        }

        private void uptBfOrdNO_TextChanged(object sender, EventArgs e)
        {
            //A01007 订单用途   A01004 产品类型  A01001 订单类型 B01016 表面等级
            //string ordNO = this.uptBfOrdNO.Text;
            //DataTable dt = new DataTable();
            //CoreClientParam ccp = new CoreClientParam();
            //ccp.ServerName = "UIB.COM.ComDBQuery";
            //ccp.MethodName = "doSimpleQuery";
            //ArrayList paramArray = new ArrayList();
            //paramArray.Add("SELECT.ORD_SEQ");
            //paramArray.Add(ordNO);
            //ccp.ServerParams = new object[] { paramArray };
            //ccp.SourceDataTable = dt;
            //this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
            //Core.LZMes.Client.UIE.UIE041.UIEBase.Init_ComboControl(this.uptBfOrdSeq, ref dt, "ORD_SEQ");
        }

        private void uptAftOrdNO_Leave(object sender, EventArgs e)
        {
            //A01007 订单用途   A01004 产品类型  A01001 订单类型 B01016 表面等级
            string ordNO = this.uptAftOrdNO.Text;
            DataTable dt = new DataTable();
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "UIB.COM.ComDBQuery";
            ccp.MethodName = "doSimpleQuery";
            ArrayList paramArray = new ArrayList();
            paramArray.Add("UIECOMM00_SELECT.ORD_SEQ");
            paramArray.Add(ordNO);
            ccp.ServerParams = new object[] { paramArray };
            ccp.SourceDataTable = dt;
            this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
            Core.LZMes.Client.UIE.UIE041.UIEBase.Init_ComboControl(this.uptAftOrdSeq, ref dt, "ORD_SEQ");
        }

        private void uptBfOrdNO_Leave(object sender, EventArgs e)
        {
            //A01007 订单用途   A01004 产品类型  A01001 订单类型 B01016 表面等级
            string ordNO = this.uptBfOrdNO.Text;
            DataTable dt = new DataTable();
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "UIB.COM.ComDBQuery";
            ccp.MethodName = "doSimpleQuery";
            ArrayList paramArray = new ArrayList();
            paramArray.Add("UIECOMM00_SELECT.ORD_SEQ");
            paramArray.Add(ordNO);
            ccp.ServerParams = new object[] { paramArray };
            ccp.SourceDataTable = dt;
            this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
            Core.LZMes.Client.UIE.UIE041.UIEBase.Init_ComboControl(this.uptBfOrdSeq, ref dt, "ORD_SEQ");
        }

        private void UIE043040_Load(object sender, EventArgs e)
        {
            init();
        }

    }
        
}