MES_Client/TGMES/Core.StlMes.Client.YdmPipeReport/16收发存综合统计/FrmGeneralStatistics.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.Control;
using Core.StlMes.Client.YdmPipeManage.Tool;
using Core.Mes.Client.Comm.Server;
using Core.StlMes.Client.YdmPipeManage;
using System.Collections;
using Infragistics.Win.UltraWinGrid;

namespace Core.StlMes.Client.YdmPipeReport
{
    public partial class FrmGeneralStatistics : FrmBase
    {
        public FrmGeneralStatistics()
        {
            InitializeComponent();
        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    //queryData();
                    queryDataB();
                    break;
                case "Export":
                    exportData();
                    break;
                case "Close":
                    this.Close();
                    break;

            }
        }

        /// <summary>
        /// 查询
        /// </summary>
        private void queryData()
        {
            string[] arr = null;
            ArrayList parm = new ArrayList();
            string bathYear = dtBathYear.Value.ToString("yyyyMM");
            try
            {
                this.Cursor = Cursors.WaitCursor;          //控制鼠标的样式为等待
                if (Constant.WaitingForm == null)
                {
                    Constant.WaitingForm = new WaitingForm();
                }
                Constant.WaitingForm.ShowToUser = true;
                Constant.WaitingForm.Show();
                Constant.WaitingForm.Update();
                arr = BaseMethod.InitPermissions(this.ValidDataPurviewIds,ob);
                parm.Add(bathYear);
                parm.Add(bathYear);
                parm.Add(bathYear);
                parm.Add(bathYear);
                parm.Add(bathYear);
                parm.Add(bathYear);
                parm.Add(bathYear);
                DataTable ds = ServerHelper.GetData("com.steering.pss.ydm.Report.FrmGeneralStatistics.doQuery", new object[] { parm,arr }, ob);
                GridHelper.CopyDataToDatatable(ref ds,ref dataTable1,true);
                this.SetStaticsInfo();
                CommonMethod.SetGridSumArea(this.ultraGrid1);
                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;
            }
            catch (Exception e)
            {
                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;
            }
        }
        /// <summary>
        /// 查询
        /// </summary>
        private void queryDataB()
        {
            string[] arr = BaseMethod.InitPermissions(this.ValidDataPurviewIds, ob);
            string bathYear = dtBathYear.Value.ToString("yyyyMM");
            DataTable ds = ServerHelper.GetData("com.steering.pss.ydm.Report.FrmGeneralStatistics.doQueryDataB", new object[] { bathYear, arr }, ob);
            GridHelper.CopyDataToDatatable(ref ds, ref dataTable1, true);
            this.SetStaticsInfo();
            CommonMethod.SetGridSumArea(this.ultraGrid1);
        }
        private void SetStaticsInfo()
        {
            try
            {
                if (this.ultraGrid1.Rows.Count == 0)
                {
                    this.ultraGrid1.DisplayLayout.Bands[0].Summaries.Clear();
                }
                else
                {
                    ArrayList alist = new ArrayList();
                    alist.Add("ONDAYINWGT");
                    alist.Add("INALLWGT");
                    alist.Add("ONDAYOUTWGT");
                    alist.Add("SUMWGT");
                    alist.Add("RAILWAYWGT");
                    alist.Add("TARGETWGT");
                    alist.Add("ENDWGT");
                    alist.Add("INCREMENTWGT");
                    CommonMethod.SetStaticsInfoSum(ref this.ultraGrid1, alist, true);
                }
            }
            catch { }
        }

        /// <summary>
        /// 导出
        /// </summary>
        private void exportData()
        {
            GridHelper.ulGridToExcel(this.ultraGrid1, "收发存综合统计");
        }

        private void ultraGrid1_InitializeLayout(object sender, Infragistics.Win.UltraWinGrid.InitializeLayoutEventArgs e)
        {
            e.Layout.Override.DefaultRowHeight = 45;
            e.Layout.Override.RowSizing = RowSizing.Free;
            this.ultraGrid1.DisplayLayout.Override.RowSizing = RowSizing.Free;
        }

        private void FrmGeneralStatistics_Load(object sender, EventArgs e)
        {
            dtBathYear.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM"));
        }
    }
}