MES_Client/TGMES/Core.StlMes.Client.Plan.Order/FrmProcessOrder.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 CoreFS.SA06;
using System.Collections;
using Core.Mes.Client.Comm.Control;
using Infragistics.Win.UltraWinGrid;
using Infragistics.Win;
using Infragistics.Win.UltraWinGrid.ExcelExport;
using System.IO;
using Infragistics.Excel;
using System.Diagnostics;
using Core.Mes.Client.Comm;
using Core.Mes.Client.Comm.Server;

namespace Core.StlMes.Client.Plan.Order
{
    /// <summary>
    /// 工序合同查询界面
    /// @author：杨天海
    /// @version：v1.1
    /// @date:2015.05.28 
    /// </summary>
    public partial class FrmProcessOrder : FrmBase
    {
        public FrmProcessOrder()
        {
            InitializeComponent();
        }

        private void FrmProcessOrder_Load(object sender, EventArgs e)
        {
            dtIssuedDateFrom.DateTime = DateTime.Now.AddMonths(-1);
            dtIssuedDateEnd.DateTime = DateTime.Now;
            querySale();
        }

        /// <summary>
        /// 菜单选择事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="ToolbarKey"></param>
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            base.ToolBar_Click(sender, ToolbarKey);
            switch (ToolbarKey)
            {
                case "QuerySale":
                    querySale();
                    break;
                case "QueryBl":
                    queryBl();
                    break;
                case "Close":
                    this.Close();
                    break;
            }
        }

        /// <summary>
        /// 查询销售合同
        /// </summary>
        private void querySale() 
        {
            try
            {
                ArrayList parms = new ArrayList();
                parms.Add(dtIssuedDateFrom.DateTime.ToString("yyyy/MM/dd"));
                parms.Add(dtIssuedDateEnd.DateTime.ToString("yyyy/MM/dd"));

                DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CoreProcessOrder.queryIssSaleOrder",
                        new object[] { parms }, this.ob);
                GridHelper.CopyDataToDatatable(dt, dataTable1, true);
                PlanComm.setGridActivation(ultraGrid1.DisplayLayout.Bands[0]);
            }
            catch (Exception ex)
            {
                if (ex is MESException)
                {
                    MessageBox.Show(((MESException)ex).ExceptionInfo);
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
        }

        /// <summary>
        /// 查询备料需求
        /// </summary>
        private void queryBl()
        {
            try
            {
                ArrayList parms = new ArrayList();
                parms.Add(dtIssuedDateFrom.DateTime.ToString("yyyy/MM/dd"));
                parms.Add(dtIssuedDateEnd.DateTime.ToString("yyyy/MM/dd"));

                DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CoreProcessOrder.queryIssBlNeed",
                            new object[] { parms }, this.ob);
                GridHelper.CopyDataToDatatable(dt, dataTable2, true);
                PlanComm.setGridActivation(ultraGrid2.DisplayLayout.Bands[0]);
            }
            catch (Exception ex)
            {
                if (ex is MESException)
                {
                    MessageBox.Show(((MESException)ex).ExceptionInfo);
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
        }

        private void FrmProcessOrder_Shown(object sender, EventArgs e)
        {
            toolMenu.Toolbars[0].Tools["QuerySale"].InstanceProps.Visible = DefaultableBoolean.True;
            toolMenu.Toolbars[0].Tools["QueryBl"].InstanceProps.Visible = DefaultableBoolean.False;
        }

        /// <summary>
        /// 开始时间小于等于结束时间
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void dtIssuedDateEnd_ValueChanged(object sender, EventArgs e)
        {
            dtIssuedDateFrom.MaxDate = dtIssuedDateEnd.DateTime.AddDays(1).Date.AddSeconds(-1);
        }

        /// <summary>
        /// 结束时间大于等于开始时间
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void dtIssuedDateFrom_ValueChanged(object sender, EventArgs e)
        {
            dtIssuedDateEnd.MinDate = dtIssuedDateFrom.DateTime.Date;
        }

        /// <summary>
        /// 选择tab页时，菜单的变化
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraTabControl2_SelectedTabChanged(object sender, Infragistics.Win.
            UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            if (toolMenu != null)
            {
                if (e.Tab.TabPage == ultraTabPageSale)
                {
                    toolMenu.Toolbars[0].Tools["QuerySale"].InstanceProps.Visible = DefaultableBoolean.True;
                    toolMenu.Toolbars[0].Tools["QueryBl"].InstanceProps.Visible = DefaultableBoolean.False;
                    ultraTabPageControl3.Enabled = true;
                    ultraTabPageJGX.Enabled = true;
                    querySale();
                }
                if (e.Tab.TabPage == ultraTabPageBl)
                {
                    toolMenu.Toolbars[0].Tools["QuerySale"].InstanceProps.Visible = DefaultableBoolean.False;
                    toolMenu.Toolbars[0].Tools["QueryBl"].InstanceProps.Visible = DefaultableBoolean.True;
                    ultraTabPageControl3.Enabled = false;
                    ultraTabPageJGX.Enabled = false;
                    queryBl();
                }
            }
        }

        /// <summary>
        /// 查看销售合同活动行的相关工序
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGrid1_BeforeRowActivate(object sender, RowEventArgs e)
        {
            try
            {
                ArrayList param = new ArrayList();
                param.Add(e.Row.Cells["ORDER_NO"].Value.ToString());
                param.Add(e.Row.Cells["ORDER_SEQ"].Value.ToString());
                param.Add(e.Row.Cells["DELIVERY_NO"].Value.ToString());
                /// 查询轧管工序
                DataTable dt1 = ServerHelper.GetData("com.steering.pss.plan.order.CoreProcessOrder.queryZGbySale", new object[] { param }, this.ob);
                GridHelper.CopyDataToDatatable(dt1, dataTable3, true);
                /// 查询变径工序
                DataTable dt2 = ServerHelper.GetData("com.steering.pss.plan.order.CoreProcessOrder.queryBJbySale", new object[] { param }, this.ob);
                GridHelper.CopyDataToDatatable(dt2, dataTable4, true);
                /// 查询热处理工序
                DataTable dt3 = ServerHelper.GetData("com.steering.pss.plan.order.CoreProcessOrder.queryRCLbySale", new object[] { param }, this.ob);
                GridHelper.CopyDataToDatatable(dt3, dataTable5, true);
                /// 查询加工线工序
                DataTable dt4 = ServerHelper.GetData("com.steering.pss.plan.order.CoreProcessOrder.queryJGXbySale", new object[] { param }, this.ob);
                GridHelper.CopyDataToDatatable(dt4, dataTable6, true);
                /// 查询管坯需求
                DataTable dt5 = ServerHelper.GetData("com.steering.pss.plan.order.CoreProcessOrder.queryGpNeed", new object[] { param }, this.ob);
                GridHelper.CopyDataToDatatable(dt5, dataTable7, true);

                PlanComm.setGridActivation(ultraGrid3.DisplayLayout.Bands[0]);
                PlanComm.setGridActivation(ultraGrid4.DisplayLayout.Bands[0]);
                PlanComm.setGridActivation(ultraGrid5.DisplayLayout.Bands[0]);
                PlanComm.setGridActivation(ultraGrid6.DisplayLayout.Bands[0]);
                PlanComm.setGridActivation(ultraGrid7.DisplayLayout.Bands[0]);
            }
            catch (Exception ex)
            {
                if (ex is MESException)
                {
                    MessageBox.Show(((MESException)ex).ExceptionInfo);
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
        }

        /// <summary>
        /// 查看备料需求活动行的相关工序
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGrid2_BeforeRowActivate(object sender, RowEventArgs e)
        {
            try
            {
                ArrayList param = new ArrayList();
                param.Add(e.Row.Cells["REQ_BL_ID"].Value.ToString());
                /// 查询轧管工序
                DataTable dt1 = ServerHelper.GetData("com.steering.pss.plan.order.CoreProcessOrder.queryZGbyBL", new object[] { param }, this.ob);
                GridHelper.CopyDataToDatatable(dt1, dataTable3, true);
                /// 查询变径工序
                DataTable dt2 = ServerHelper.GetData("com.steering.pss.plan.order.CoreProcessOrder.queryBJbyBL", new object[] { param }, this.ob);
                GridHelper.CopyDataToDatatable(dt2, dataTable4, true);
                /// 查询热处理工序
                DataTable dt3 = ServerHelper.GetData("com.steering.pss.plan.order.CoreProcessOrder.queryRCLbyBL", new object[] { param }, this.ob);
                GridHelper.CopyDataToDatatable(dt3, dataTable5, true);

                PlanComm.setGridActivation(ultraGrid3.DisplayLayout.Bands[0]);
                PlanComm.setGridActivation(ultraGrid4.DisplayLayout.Bands[0]);
                PlanComm.setGridActivation(ultraGrid5.DisplayLayout.Bands[0]);
                PlanComm.setGridActivation(ultraGrid6.DisplayLayout.Bands[0]);
            }
            catch (Exception ex)
            {
                if (ex is MESException)
                {
                    MessageBox.Show(((MESException)ex).ExceptionInfo);
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
        }

    }
}