MES_Client/TGMES/Core.StlMes.Client.SaleOrder/Dialog/frmProWell.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 Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Control;
using Infragistics.Win.UltraWinGrid;

namespace Core.StlMes.Client.SaleOrder.Dialog
{
    public partial class frmProWell : FrmBase
    {
        public frmProWell()
        {
            InitializeComponent();
        }

        private void frmProWell_Load(object sender, EventArgs e)
        {
            InitYear();
            InitMonth();
            bindCmbProcess();
            //this.ultraChart1.DataSource = this.slmWell;
            //this.ultraChart1.DataBind();
        }

        /// <summary>
        /// 工序
        /// </summary>
        private void bindCmbProcess()
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.CoreProWell.bindCmbProcess", null, this.ob);

            DataRow row = dt.NewRow();
            row["PROCESS_CODE"] = "0";
            row["PROCESS_DESC"] = "所有工序";
            dt.Rows.Add(row);

            cmbProcess.DataSource = dt;
            cmbProcess.ValueMember = "PROCESS_CODE";
            cmbProcess.DisplayMember = "PROCESS_DESC";
            cmbProcess.SelectedIndex = 0;
            
            
            //ComboBoxHelper.FillUltraComboItems(cmbProcess, dt);
            //cmbProcess.SelectedIndex = 0;

        }

        /// <summary>
        /// 年
        /// </summary>
        private void InitYear()
        {
            DataTable dt = new DataTable();
            dt.Columns.Add("YEAR", Type.GetType("System.Int32"));
            for (int i = 2000; i <= 2100; i++)
                dt.Rows.Add(new object[] { i });
            cmbYear.DataSource = dt;
            cmbYear.ValueMember = "YEAR";
            cmbYear.DisplayMember = "YEAR";
            cmbYear.SelectedIndex = 0;
        }

        /// <summary>
        /// 月
        /// </summary>
        private void InitMonth()
        {
            DataTable dt = new DataTable();
            dt.Columns.Add("MONTH", Type.GetType("System.Int32"));
            for (int i = 1; i <= 12; i++)
                dt.Rows.Add(new object[] { i });
            cmbMonth.DataSource = dt;
            cmbMonth.ValueMember = "MONTH";
            cmbMonth.DisplayMember = "MONTH";
            cmbMonth.SelectedIndex = 0;
        }


        /// <summary>
        /// 重写基类toolBar方法
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="ToolbarKey"></param>
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "doQuery":
                    doQuery();
                    break;
                case "doClose":
                    this.Close();
                    break;
            }
        }

        private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
        {
            switch (e.Tool.Key)
            { 
                case "doQuery":
                    doQuery();
                    break;
                case "doClose":
                    this.Close();
                    break;
            }
        }

        private string year = "";
        private string month = "";

        /// <summary>
        /// 查询
        /// </summary>
        private void doQuery()
        {
            year = cmbYear.Value.ToString();
            month = cmbMonth.Value.ToString();

            string processCode = cmbProcess.Value.ToString();
            //所有工序功能
            //if ("0".Equals(cmbProcess.Value.ToString()))
            //{
                
            //}

            DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.CoreProWell.doQuery", new Object[] { year, month, processCode }, this.ob);
            GridHelper.CopyDataToDatatable(ref dt, ref this.slmWell, true);

            if (dt.Rows.Count > 0)
            {
                this.ultraChart1.DataSource = this.slmWell;
                this.ultraChart1.DataBind();
                //指定标签列
                this.ultraChart1.Data.UseRowLabelsColumn = true;
                this.ultraChart1.Data.RowLabelsColumn = 5;
            }
            else
            {
                this.ultraChart1.DataSource = this.ultraDataSource1;
                this.ultraChart1.DataBind();

                this.slmWellDelivery.Clear();
            }
            //自适应
            //GridHelper.RefreshAndAutoSizeExceptColumns(ultraGrid1, new UltraGridColumn[] {
            //});
            
        }

        /// <summary>
        /// 选中事件。
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            string wellCode = ultraGrid1.ActiveRow.Cells["WELL_CODE"].Value.ToString();

            try
            {
                DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.CoreProWell.GetWellDelivery", new Object[] { year, month, wellCode }, this.ob);
                GridHelper.CopyDataToDatatable(ref dt, ref this.slmWellDelivery, true);
            }
            catch (Exception ex){
                MessageBox.Show(ex.Message.ToString());
            }
            
            //自适应
            GridHelper.RefreshAndAutoSizeExceptColumns(ultraGrid2, new UltraGridColumn[] {
            });
        }
    }
}