MES_Client/TGMES/Core.StlMes.Client.YdmPipeReport/14出库明细汇总表/FrmOutBoundSum.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 Core.StlMes.Client.YdmPipeManage.Tool;
using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Tool;
using CoreFS.CA06;
using Core.Mes.Client.Comm.Server;
using Infragistics.Win.UltraWinGrid;

namespace Core.StlMes.Client.YdmPipeReport
{
    public partial class FrmOutBoundSum : FrmBase
    {
        private string[] _salgPermissions;
        public FrmOutBoundSum()
        {
            InitializeComponent();
        }

        private void FrmOutBoundSum_Load(object sender, EventArgs e)
        {
            DateTime now = DateTime.Now;
            DateTime dt1 = new DateTime(now.Year, now.Month, 1);//当月第一天
            DateTime dt2 = dt1.AddMonths(1).AddDays(-1);//当月最后一天
            StartTime.Value = DateTime.Parse(dt1.ToString("yyyy-MM-dd") + " 00:00:00");
            EndTime.Value = DateTime.Parse(dt2.ToString("yyyy-MM-dd") + " 23:59:59");
            BaseMethod.InitMonth(cmbMonth);
            BaseMethod.InitYear(cmbYear);
            cmbMonth.Value = string.Format("{0:00}", DateTime.Now.Month);
            cmbYear.Value = DateTime.Now.Year.ToString();

            _salgPermissions = BaseMethod.InitPermissions(this.ValidDataPurviewIds, ob);
        }
        /// <summary>
        /// 重写基类方法
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="ToolbarKey"></param>
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    doQuery();
                    break;
                case "Export"://导出
                    GridHelper.ulGridToExcel(ultraGrid1, "出库明细汇总表");            
                    break;
                case "Close":
                    this.Close();
                    break;
            }
        }
        private void doQuery() 
        {
            if (!ValidQuery()) return;
            string strStartTime = "";//开始时间
            string strEntTime = "";//结束时间
            string beginTime = "";
            string order = "";
            string juNo = "";
            string supplyUnit = this.CustomInfo;
            if (ChcTime.Checked)
            {
                beginTime = cmbYear.Text.Trim() + cmbMonth.Text.Trim();
            }
            if (chkJudge.Checked) { juNo = cmbJudge.Text.Trim(); }
            if (chkOrder.Checked) { order = cmbOrder.Text.Trim(); }
            if (ultraCheckEditor5.Checked) { strStartTime = StartTime.Value.ToString(); strEntTime = EndTime.Value.ToString(); }

            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.Report.FrmOutBoundSum.getGpDataB", new object[] { strStartTime, strEntTime, beginTime, juNo, order, _salgPermissions , supplyUnit }, ob);
            GridHelper.CopyDataToDatatable(dt, this.dataTable1, true);
            //UltraGridColumn[] col = new UltraGridColumn[] { ultraGrid1.DisplayLayout.Bands[0].Columns["MATERIAL_NAME"], ultraGrid1.DisplayLayout.Bands[0].Columns["STD_NAME"] };
            //GridHelper.RefreshAndAutoSizeExceptColumns(ultraGrid1, col);
        }

        private void ultraCheckEditor5_CheckedChanged(object sender, EventArgs e)
        {
            if (ultraCheckEditor5.Checked) { StartTime.Enabled = true; EndTime.Enabled = true; } else { StartTime.Enabled = false; EndTime.Enabled = false; }
            if (ChcTime.Checked) { cmbYear.Enabled = true; cmbMonth.Enabled = true; } else { cmbYear.Enabled = false; cmbMonth.Enabled = false; }
            if (chkOrder.Checked) { cmbOrder.Enabled = true; } else { cmbOrder.Enabled = false; }
            if (chkJudge.Checked) { cmbJudge.Enabled = true; } else { cmbJudge.Enabled = false; }
        }
        /// <summary>
        /// 查询时验证必填项
        /// </summary>
        /// <returns></returns>
        private bool ValidQuery()
        {
            if (ultraCheckEditor5.Checked)
            {
                if (DataTimeUtil.JudgeTime(DateTime.Parse(StartTime.Value.ToString()), DateTime.Parse(EndTime.Value.ToString())) == 0)
                {
                    MessageUtil.ShowTips("您所选择的日期区域不对,请重新选择！");
                    return false;
                }
            }
            if (chkOrder.Checked && string.IsNullOrEmpty(cmbOrder.Text.Trim()))
            {
                MessageBox.Show("请输入合同号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return false;
            }
            if (chkJudge.Checked && string.IsNullOrEmpty(cmbJudge.Text.Trim()))
            {
                MessageBox.Show("请输入炉号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return false;
            }
            return true;
        }
    }
}