MES_Client/TGMES/Core.StlMes.Client.YdmPipeReport/08炉批收发存汇总报表/rptStoveBatchStorage.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.Mes.Client.Comm.Tool;
using System.Collections;
using Core.Mes.Client.Comm.Server;
using Core.StlMes.Client.YdmBase;
using Core.StlMes.Client.YdmPipeManage.Tool;
using Core.StlMes.Client.YdmPipeManage;
using Infragistics.Win.UltraWinGrid;

namespace Core.StlMes.Client.YdmPipeReport
{
    public partial class rptStoveBatchStorage : FrmBase
    {
        public rptStoveBatchStorage()
        {
            this.IsLoadUserView = true;
            InitializeComponent();
        }
        private Hashtable ShapeRelation = null;
        /// <summary>
        /// 重写基类方法
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="ToolbarKey"></param>
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    Querydata();
                    break;
                case "Export":
                    ExportData();
                    break;
                case"adjust":
                    adjustData();
                    break;
                case "Close":
                    this.Close();
                    break;
            }
        }

        private string strOutbound = "800603";//出库类型编码
        private string strInMemo = "";//入库简码
        /// <summary>
        /// 批量调差
        /// </summary>
        private void adjustData()
        {
            UltraGridRow row = this.ultraGrid1.ActiveRow;
            ArrayList parm = new ArrayList();
            if (row == null || row.Index < 0)
            {
                MessageUtil.ShowTips("无调差数据!");
                return;
            }
            string custom = this.CustomInfo;
            if (!chkGl.Checked)
            {
                MessageUtil.ShowTips("请先筛选出0支非0吨的数据,再进行调差!");
                return;
            }
            int days = DateTime.DaysInMonth(int.Parse(endTime.Value.ToString("yyyy")), int.Parse(endTime.Value.ToString("MM")));
            //if (!StatTime.Value.ToString("yyyyMM").Equals(endTime.Value.ToString("yyyyMM")))
            //{
            //    MessageUtil.ShowTips("批量调差的数据必须是同一年月的!");
            //    return;
            //}
            //if (!StatTime.Value.ToString("dd").Equals("01") || !endTime.Value.ToString("dd").Equals(days.ToString()))
            //{
            //    MessageUtil.ShowTips("批量调差的数据必须为每月第一天到最后一天!");
            //    return;
            //}
            DataTable dtMemo = ClsLoad.getComTypeInfo(strOutbound, ob);
            if (dtMemo.Rows.Count >= 1)
            {
                strInMemo = dtMemo.Rows[0]["MEMO"].ToString();
            }
            string manNo = ClsBaseInfo.GetDepartIdBySectionId(UserInfo.GetDeptid(), this.ob);
            string manName = ClsBaseInfo.GetDepartBySectionId(UserInfo.GetDeptid(), this.ob);
            foreach (UltraGridRow uRow in this.ultraGrid1.Rows)
            {
                ArrayList list = new ArrayList();
                list.Add(uRow.Cells["JUDGE_STOVE_NO"].Text);
                list.Add(uRow.Cells["BATCH_NO"].Text);
                list.Add(uRow.Cells["BATCH_GROUD_NO"].Text);
                list.Add(uRow.Cells["QUANTITYWGT"].Value.ToString());
                list.Add(strOutbound);
                //ArrayList pram = new ArrayList();
                //pram.Clear();
                //pram.Add(DateTime.Now.ToString("yyyy/MM/dd"));
                //pram.Add(strOutbound);
                //DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipemanage.FrmPipeAdjust.queryAdjustList", new object[] { pram }, ob);
                //string str = "";
                //if (dt.Rows.Count >= 1)
                //{
                //    str = dt.Rows[0]["STOCKTAKING_DOC"].ToString();
                //}

              
                list.Add(strInMemo);
                list.Add(manNo);
                list.Add(manName);
                list.Add(this.UserInfo.GetDeptid());
                list.Add(this.UserInfo.GetDepartment());
                list.Add(this.UserInfo.GetUserName());
                list.Add(uRow.Cells["BELONG_CODE"].Text.ToString());
                parm.Add(list);
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.Report.FrmrptStoveBatchStorage";
            ccp.MethodName = "insertAdjustData";
            ccp.ServerParams = new object[] { parm, BaseMethod.InitPermissions(this.ValidDataPurviewIds, ob), custom };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("调差成功!"))
                {
                    Querydata();            
                }
            }
        }

        /// <summary>
        /// 查询
        /// </summary>
        private void QueryData()
        {
            string[] arr = BaseMethod.InitPermissions(this.ValidDataPurviewIds, ob);
            if (this.StatTime.Value > this.endTime.Value)
            {
                MessageUtil.ShowTips("起始日期不能大于结束日期!");
                this.endTime.Focus();
                return;
            }
            //if (this.StatTime.Value.ToString().Substring(5, 2) != this.endTime.Value.ToString().Substring(5, 2))
            //{
            //    MessageUtil.ShowTips("起始日期和结束日期需在同月!");
            //    return;
            //}
            if (chkStorge.Checked &&string.IsNullOrEmpty(this.cmbStorgeNo.Text.Trim()))
            {
                MessageUtil.ShowTips("请输入仓库名称!");
                this.cmbStorgeNo.Focus();
                return;
            }
            string strDateFrom = this.StatTime.Value.ToString("yyyyMM");
            string strDateTo = this.endTime.Value.ToString("yyyyMMdd");
            try
            {
                this.Cursor = Cursors.WaitCursor;          //控制鼠标的样式为等待
                if (Constant.WaitingForm == null)
                {
                    Constant.WaitingForm = new WaitingForm();
                }
                Constant.WaitingForm.ShowToUser = true;
                Constant.WaitingForm.Show();
                Constant.WaitingForm.Update();
                //string strOriginal = string.Format("{0:yyyyMMdd}", DateTime.Now.AddDays(-DateTime.Now.Day + 1));
                //string strOriginalLast = string.Format("{0:yyyyMMdd}", DateTime.Now.AddDays(-DateTime.Now.Day + 1));
                string strOriginal = this.StatTime.Value.ToString("yyyyMM");
                string strOriginalLast = this.StatTime.Value.ToString("yyyyMMdd");
                string strWhere1 = "", strWhere2 = "", strWhere3 = "", strWhere4 = "";
                if (chkStorge.Checked)
                {
                    strWhere1 += " and t.STORAGE_NO like '%'||'" + this.cmbStorgeNo.Value.ToString() + "'||'%'";
                    strWhere2 += " and t.STORAGE_NO like '%'||'" + this.cmbStorgeNo.Value.ToString() + "'||'%'";
                    strWhere3 += " and t.STORAGE_NO like '%'||'" + this.cmbStorgeNo.Value.ToString() + "'||'%'";
                    strWhere4 += " and s.STORAGE_NO like '%'||'" + this.cmbStorgeNo.Value.ToString() + "'||'%'";
                }

                //上期期初
                DataTable table1 = null;
                if (!this.GetOriginalLast(strOriginalLast, strWhere1, out table1, arr))
                {
                    //return;
                }
                //上期入库量
                //DataTable table2 = null;
                //if (!this.GetLastIn(strOriginalLast, strDateFrom, strWhere1, out table2, arr))
                //{
                //   // return;
                //}
                ////上期出库量
                //DataTable table3 = null;
                //if (!this.GetLastOut(strOriginalLast, strDateFrom, strWhere1, out table3, arr))
                //{
                //   // return;
                //}

                //本期入库量
                DataTable table4 = null;
                if (!this.GetThisIn(strOriginal, strDateFrom, strDateTo, strWhere1, out table4, arr))
                {
                    //return;
                }
                //本期出库量
                DataTable table5 = null;
                if (!this.GetThisOut(strOriginal, strDateFrom, strDateTo, strWhere1, out table5, arr))
                {
                    //return;
                }
                //调差
                DataTable table6 = null;
                if (!this.GetAdjust(strDateFrom, strDateTo, strWhere1, out table6, arr))
                {

                }
                //实时库存
                DataTable table7 = null;
                if (!this.GetMatData(strDateFrom, strDateTo, strWhere4, out table7, arr))
                {

                }
                string[] strMergeColumns = new string[] { "JUDGE_STOVE_NO", "BATCH_NO", "BATCH_GROUD_NO" };

                DataTable table = table1.DefaultView.ToTable(true, strMergeColumns);
                //if (table2 != null)
                //{
                //    table.Merge(table2.DefaultView.ToTable(true, strMergeColumns));
                //}
                //if (table3 != null)
                //{
                //    table.Merge(table3.DefaultView.ToTable(true, strMergeColumns));
                //}
                if (table4 != null)
                {
                    table.Merge(table4.DefaultView.ToTable(true, strMergeColumns));
                }
                if (table5 != null)
                {
                    table.Merge(table5.DefaultView.ToTable(true, strMergeColumns));
                }
                if (table6 != null)
                {
                    table.Merge(table6.DefaultView.ToTable(true, strMergeColumns));
                }
                if (table7 != null)
                {
                    table.Merge(table7.DefaultView.ToTable(true, strMergeColumns));
                }

                table.DefaultView.Sort = "JUDGE_STOVE_NO, BATCH_NO, BATCH_GROUD_NO";
                table = table.DefaultView.ToTable(true, strMergeColumns);


                string strSort = "", strHeatNo = "", strBactchNo = "", strGroupNo = "";

                DataRow newrow;
                DataRow[] rows;
                this.dataTable1.Rows.Clear();

                decimal dWgt = 0.0M, dLastIn = 0.0M, dLastOut = 0.0M, dLastAdjust = 0.0M, dMatWgt = 0.0M;
                int dCount = 0, dLastInCount = 0, dLastOutCount = 0, dLastAjustCount = 0, dMatCount = 0;
                decimal dThisIn_Day = 0.0M, dThisOut_Day = 0.00M;
                int dThisIn_DayCount = 0, dThisOut_DayCount = 0;
                decimal dThisIn_Month = 0.0M, dThisOut_Month = 0.00M;
                int dThisIn_MonthCount = 0, dThisOut_MonthCount = 0;
                //decimal dThisIn_Year = 0.0M, dThisOut_Year = 0.00M;

                string strRowFilters = "";
                for (int i = 0; i < table.Rows.Count; i++)
                {
                    newrow = this.dataTable1.NewRow();
                    try
                    {
                        strHeatNo = Convert.ToString(table.Rows[i]["JUDGE_STOVE_NO"]);//炉号
                        strBactchNo = Convert.ToString(table.Rows[i]["BATCH_NO"]);//批号
                        strGroupNo = Convert.ToString(table.Rows[i]["BATCH_GROUD_NO"]);//组号

                        strRowFilters = string.IsNullOrEmpty(strHeatNo) ? " JUDGE_STOVE_NO is null " : " JUDGE_STOVE_NO = '" + strHeatNo + "' ";
                        strRowFilters += string.IsNullOrEmpty(strBactchNo) ? " and BATCH_NO is null " : " and BATCH_NO = '" + strBactchNo + "' ";
                        strRowFilters += string.IsNullOrEmpty(strGroupNo) ? " and BATCH_GROUD_NO is null " : " and BATCH_GROUD_NO = '" + strGroupNo + "' ";
                        try
                        {
                            table1.CaseSensitive = true;
                            rows = table1.Select(strRowFilters);

                            if (rows.Length > 0)
                            {
                                try
                                {
                                    dWgt = decimal.Parse(Convert.ToString(rows[0]["WEIGHT"]));
                                    dCount = int.Parse(Convert.ToString(rows[0]["COUNT"]));
                                }
                                catch
                                {
                                    dWgt = 0.0M;
                                    dCount = 0;
                                }
                            }
                            else
                            {
                                dWgt = 0.0M;
                                dCount = 0;
                            }
                        }
                        catch
                        {
                            dWgt = 0.0M;
                            dCount = 0;
                        }

                        //try
                        //{
                        //    rows = table2.Select(strRowFilters);

                        //    if (rows.Length > 0)
                        //    {
                        //        try
                        //        {
                        //            dLastIn = decimal.Parse(Convert.ToString(rows[0]["WEIGHT"]));
                        //            dLastInCount = int.Parse(Convert.ToString(rows[0]["COUNT"]));
                        //        }
                        //        catch
                        //        {
                        //            dLastIn = 0.0M;
                        //            dLastInCount = 0;
                        //        }
                        //    }
                        //    else
                        //    {
                        //        dLastIn = 0.0M;
                        //        dLastInCount = 0;
                        //    }
                        //}
                        //catch
                        //{
                        //    dLastIn = 0.0M;
                        //    dLastInCount = 0;
                        //}

                        //try
                        //{
                        //    rows = table3.Select(strRowFilters);

                        //    if (rows.Length > 0)
                        //    {
                        //        try
                        //        {
                        //            dLastOut = decimal.Parse(Convert.ToString(rows[0]["WEIGHT"]));
                        //            dLastOutCount = int.Parse(Convert.ToString(rows[0]["COUNT"]));
                        //        }
                        //        catch
                        //        {
                        //            dLastOut = 0.0M;
                        //            dLastOutCount = 0;
                        //        }
                        //    }
                        //    else
                        //    {
                        //        dLastOut = 0.0M;
                        //        dLastOutCount = 0;
                        //    }
                        //}
                        //catch
                        //{
                        //    dLastOut = 0.0M;
                        //    dLastOutCount = 0;
                        //}

                        try
                        {
                            table4.CaseSensitive = true;
                            rows = table4.Select(strRowFilters);

                            if (rows.Length > 0)
                            {
                                try
                                {
                                    dThisIn_Day = decimal.Parse(Convert.ToString(rows[0]["WEIGHT_DAY"]));
                                    dThisIn_DayCount = int.Parse(Convert.ToString(rows[0]["WEIGHT_DAYCOUNT"]));
                                }
                                catch
                                {
                                    dThisIn_Day = 0.0M;
                                    dThisIn_DayCount = 0;
                                }

                                try
                                {
                                    dThisIn_Month = decimal.Parse(Convert.ToString(rows[0]["WEIGHT_MONTH"]));
                                    dThisIn_MonthCount = int.Parse(Convert.ToString(rows[0]["WEIGHT_MONTHCOUNT"]));
                                }
                                catch
                                {
                                    dThisIn_Month = 0.0M;
                                    dThisIn_MonthCount = 0;
                                }

                                //try
                                //{
                                //    dThisIn_Year = decimal.Parse(Convert.ToString(rows[0]["WEIGHT_YEAR"]));
                                //}
                                //catch
                                //{
                                //    dThisIn_Year = 0.0M;
                                //}
                            }
                            else
                            {
                                dThisIn_Day = 0.0M;
                                dThisIn_Month = 0.0M;
                                dThisIn_DayCount = 0;
                                dThisIn_MonthCount = 0;
                                //dThisIn_Year = 0.0M;
                            }
                        }
                        catch
                        {
                            dThisIn_Day = 0.0M;
                            dThisIn_Month = 0.0M;
                            dThisIn_DayCount = 0;
                            dThisIn_MonthCount = 0;
                            //dThisIn_Year = 0.0M;
                        }

                        try
                        {
                            table6.CaseSensitive = true;
                            rows = table6.Select(strRowFilters);

                            if (rows.Length > 0)
                            {
                                try
                                {
                                    dLastAdjust = decimal.Parse(Convert.ToString(rows[0]["AWEIGHT"]));
                                }
                                catch
                                {
                                    dLastAdjust = 0.0M;
                                }
                            }
                            else
                            {
                                dLastAdjust = 0.0M;
                            }
                        }
                        catch
                        {
                            dLastAdjust = 0.0M;
                        }

                        try
                        {
                            table7.CaseSensitive = true;
                            rows = table7.Select(strRowFilters);

                            if (rows.Length > 0)
                            {
                                try
                                {
                                    dMatWgt = decimal.Parse(Convert.ToString(rows[0]["AWEIGHT"]));
                                    dMatCount = int.Parse(Convert.ToString(rows[0]["COUNT"]));
                                }
                                catch
                                {
                                    dMatWgt = 0.0M;
                                    dMatCount = 0;
                                }
                            }
                            else
                            {
                                dMatWgt = 0.0M;
                                dMatCount = 0;
                            }
                        }
                        catch
                        {
                            dMatWgt = 0.0M;
                            dMatCount = 0;
                        }

                        try
                        {
                            table5.CaseSensitive = true;
                            rows = table5.Select(strRowFilters);

                            if (rows.Length > 0)
                            {
                                try
                                {
                                    dThisOut_Day = decimal.Parse(Convert.ToString(rows[0]["WEIGHT_DAY"]));
                                    dThisOut_DayCount = int.Parse(Convert.ToString(rows[0]["weight_daycount"]));
                                }
                                catch
                                {
                                    dThisOut_Day = 0.0M;
                                    dThisOut_DayCount = 0;
                                }

                                try
                                {
                                    dThisOut_Month = decimal.Parse(Convert.ToString(rows[0]["WEIGHT_MONTH"]));
                                    dThisOut_MonthCount = int.Parse(Convert.ToString(rows[0]["weight_monthcount"]));
                                }
                                catch
                                {
                                    dThisOut_Month = 0.0M;
                                    dThisOut_MonthCount = 0;
                                }

                                //try
                                //{
                                //    dThisOut_Year = decimal.Parse(Convert.ToString(rows[0]["WEIGHT_YEAR"]));
                                //}
                                //catch
                                //{
                                //    dThisOut_Year = 0.0M;
                                //}
                            }
                            else
                            {
                                dThisOut_Day = 0.0M;
                                dThisOut_Month = 0.0M;
                                //dThisOut_Year = 0.0M;
                                dThisOut_DayCount = 0;
                                dThisOut_MonthCount = 0;
                            }
                        }
                        catch
                        {
                            dThisOut_Day = 0.0M;
                            dThisOut_Month = 0.0M;
                            //dThisOut_Year = 0.0M;
                            dThisOut_DayCount = 0;
                            dThisOut_MonthCount = 0;
                        }



                        try
                        {
                            newrow["JUDGE_STOVE_NO"] = strHeatNo;
                            newrow["BATCH_NO"] = strBactchNo;
                            newrow["BATCH_GROUD_NO"] = strGroupNo;
                            //newrow["ORIGINAL_AMOUNT"] = Convert.ToString(dWgt + dLastIn - dLastOut).Trim();
                            newrow["ORIGINAL_AMOUNT"] = Convert.ToString(dWgt).Trim();
                            newrow["ORIGINAL_COUNT"] = Convert.ToString(dCount).Trim();
                            newrow["DAY_1"] = dThisIn_Day.ToString().Trim();
                            newrow["DAY_1COUNT"] = dThisIn_DayCount.ToString().Trim();
                            newrow["MONTH_1"] = dThisIn_Month.ToString().Trim();
                            newrow["MONTH_1COUNT"] = dThisIn_MonthCount.ToString().Trim();
                            //newrow["YEAR_1"] = dThisIn_Year.ToString().Trim();

                            newrow["DAY_2"] = dThisOut_Day.ToString().Trim();
                            newrow["DAY_2COUNT"] = dThisOut_DayCount.ToString().Trim();
                            newrow["MONTH_2"] = dThisOut_Month.ToString().Trim();
                            newrow["MONTH_2COUNT"] = dThisOut_MonthCount.ToString().Trim();
                            //newrow["YEAR_2"] = dThisOut_Year.ToString().Trim();
                            newrow["AWEIGHT"] = dLastAdjust;
                            //newrow["END_AMOUNT"] = Convert.ToString((dWgt + dLastIn - dLastOut  + dThisIn_Month - dThisOut_Month)-dLastAdjust).Trim();
                            newrow["END_AMOUNT"] = Convert.ToString(dWgt + dThisIn_Month - dThisOut_Month + dLastAdjust).Trim();
                            newrow["END_COUNT"] = Convert.ToString(dCount + dThisIn_MonthCount - dThisOut_MonthCount).Trim();
                            newrow["MATWGT"] = dMatWgt.ToString().Trim();
                            newrow["MATCOUNT"] = dMatCount.ToString().Trim();
                            newrow["QUANTITYCOUNT"] = Convert.ToString(dCount + dThisIn_MonthCount - dThisOut_MonthCount - dMatCount).Trim();
                            newrow["QUANTITYWGT"] = Convert.ToString(dWgt + dThisIn_Month - dThisOut_Month + dLastAdjust - dMatWgt).Trim();
                            try
                            {
                                if (ShapeRelation.Contains(strHeatNo))
                                {
                                    strSort = ShapeRelation[strHeatNo].ToString();
                                }
                                else
                                {
                                    strSort = "";
                                }
                            }
                            catch
                            {
                                strSort = "";
                            }

                            //newrow["PRODUCT_SORT"] = strSort;
                            this.dataSet1.Tables[0].Rows.Add(newrow);
                        }
                        catch { }
                    }
                    catch { }

                }
                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>
        /// 查询1
        /// </summary>
        private void Querydata()
        {
            string[] arr = BaseMethod.InitPermissions(this.ValidDataPurviewIds, ob);
            if (this.StatTime.Value > this.endTime.Value)
            {
                MessageUtil.ShowTips("起始日期不能大于结束日期!");
                this.endTime.Focus();
                return;
            }
            //if (this.StatTime.Value.ToString().Substring(5, 2) != this.endTime.Value.ToString().Substring(5, 2))
            //{
            //    MessageUtil.ShowTips("起始日期和结束日期需在同月!");
            //    return;
            //}
            if (chkStorge.Checked && string.IsNullOrEmpty(this.cmbStorgeNo.Text.Trim()))
            {
                MessageUtil.ShowTips("请输入仓库名称!");
                this.cmbStorgeNo.Focus();
                return;
            }
            string strDateFrom = this.StatTime.Value.ToString("yyyyMM");
            string strDateTo = this.endTime.Value.ToString("yyyyMMdd");
            string time = this.StatTime.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();
                //string strOriginal = string.Format("{0:yyyyMMdd}", DateTime.Now.AddDays(-DateTime.Now.Day + 1));
                //string strOriginalLast = string.Format("{0:yyyyMMdd}", DateTime.Now.AddDays(-DateTime.Now.Day + 1));
                string strOriginal = this.StatTime.Value.ToString("yyyyMM");
                string strOriginalLast = this.endTime.Value.ToString("yyyyMMdd");
                string strWhere1 = "", strWhere2 = "", strWhere3 = "", strWhere4 = "";
                string supplyUnit = this.CustomInfo;
                DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.Report.FrmrptStoveBatchStorage.getTest", new object[] { strOriginal, strOriginalLast, time, arr, supplyUnit, checkssq.Checked ? "0" : "1" }, ob);
                GridHelper.CopyDataToDatatable(ref dt, 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;
            }

        }
        
        private void SetStaticsInfo()
        {
            try
            {
                if (this.ultraGrid1.Rows.Count == 0)
                {
                    this.ultraGrid1.DisplayLayout.Bands[0].Summaries.Clear();
                }
                else
                {
                    ArrayList alist = new ArrayList();
                    alist.Add("ORIGINAL_AMOUNT");
                    alist.Add("ORIGINAL_COUNT");
                    alist.Add("DAY_1");
                    alist.Add("DAY_1COUNT");
                    alist.Add("MONTH_1");
                    alist.Add("MONTH_1COUNT");
                    //alist.Add("YEAR_1");
                    alist.Add("DAY_2");
                    alist.Add("DAY_2COUNT");
                    alist.Add("MONTH_2");
                    alist.Add("MONTH_2COUNT");
                    //alist.Add("YEAR_2");
                    alist.Add("AWEIGHT");
                    alist.Add("END_AMOUNT");
                    alist.Add("END_COUNT");
                    alist.Add("MATWGT");
                    alist.Add("MATCOUNT");
                    alist.Add("QUANTITYCOUNT");
                    alist.Add("QUANTITYWGT");
                    CommonMethod.SetStaticsInfoSum(ref this.ultraGrid1, alist, true);
                }
            }
            catch { }
        }
        //实时库存
        private bool GetMatData(string strDateFrom, string strDateTo, string strWhere, out DataTable table, string[] arr)
        {
            table = null;
            DataSet set = new DataSet();
            DataTable ds = ServerHelper.GetData("com.steering.pss.ydm.Report.FrmrptStoveBatchStorage.getMatData", new object[] { strDateFrom, strDateTo, strWhere, arr }, this.ob);
            if (ds != null && ds.Rows.Count > 0)
            {
                set.Tables.Add(ds);
                table = set.Tables[0];
                return true;
            }
            return false;
        }
        //本期调差量
        private bool GetAdjust(string strDateFrom, string strDateTo, string strWhere, out DataTable table,string[] arr)
        {
            table = null;
            DataSet set = new DataSet();
            DataTable ds = ServerHelper.GetData("com.steering.pss.ydm.Report.FrmrptStoveBatchStorage.getAdjust", new object[] { strDateFrom, strDateTo, strWhere,arr }, this.ob);
            if (ds != null && ds.Rows.Count > 0)
            {
                set.Tables.Add(ds);
                table = set.Tables[0];
                return true;
            }
            return false;
        }
        //本期出库量
        private bool GetThisOut(string strOriginal, string strDateFrom, string strDateTo, string strWhere, out DataTable table,string[] arr)
        {
            table = null;
            DataSet set = new DataSet();
            DataTable ds = ServerHelper.GetData("com.steering.pss.ydm.Report.FrmrptStoveBatchStorage.getThisOut", new object[] { strOriginal, strDateFrom, strDateTo, strWhere,arr }, this.ob);

            if (ds != null && ds.Rows.Count > 0)
            {
                set.Tables.Add(ds);
                table = set.Tables[0];
                return true;
            }

            return false;
        }
        //本期入库量
        private bool GetThisIn(string strOriginal, string strDateFrom, string strDateTo, string strWhere, out DataTable table,string[] arr)
        {
            table = null;

            DataSet set = new DataSet();
            DataTable ds = ServerHelper.GetData("com.steering.pss.ydm.Report.FrmrptStoveBatchStorage.getThisIn", new object[] { strOriginal, strDateFrom, strDateTo, strWhere,arr }, this.ob);

            if (ds != null && ds.Rows.Count > 0)
            {
                set.Tables.Add(ds);
                table = set.Tables[0];
                return true;
            }

            return false;
        }


        //上期出库量
        private bool GetLastOut(string strOriginalLast, string strDateFrom, string strWhere, out DataTable table,string[] arr)
        {
            table = null;
            DataSet set = new DataSet();
            DataTable ds = ServerHelper.GetData("com.steering.pss.ydm.Report.FrmrptStoveBatchStorage.getLastOut", new object[] { strOriginalLast, strDateFrom, strWhere,arr }, this.ob);

            if (ds != null && ds.Rows.Count > 0)
            {
                set.Tables.Add(ds);
                table = set.Tables[0];
                return true;
            }

            return false;
        }

        //上期入库量
        private bool GetLastIn(string strOriginalLast, string strDateFrom, string strWhere, out DataTable table,string[] arr)
        {
            table = null;
            DataSet set = new DataSet();
            DataTable ds = ServerHelper.GetData("com.steering.pss.ydm.Report.FrmrptStoveBatchStorage.getLastIn", new object[] { strOriginalLast, strDateFrom, strWhere,arr }, this.ob);
            if (ds != null && ds.Rows.Count > 0)
            {
                set.Tables.Add(ds);
                table = set.Tables[0];
                return true;
            }

            return false;
        }

        //期初
        private bool GetOriginalLast(string strOriginalLast, string strWhere, out DataTable table,string[] arr)
        {
            table = null;
            DataSet set = new DataSet();
            //string time = string.Format("{0:yyyyMM}", DateTime.Now.AddDays(-DateTime.Now.Day + 1));
            string time = this.StatTime.Value.ToString("yyyyMM");
            DataTable ds = ServerHelper.GetData("com.steering.pss.ydm.Report.FrmrptStoveBatchStorage.getOriginalLast", new object[] { time, strWhere,arr }, this.ob);

            if (ds != null && ds.Rows.Count > 0)
            {
                 set.Tables.Add(ds);
                 table = set.Tables[0];
                return true;
            }

            return false;
        }

        private const string ORIGINAL_DATE = "20150902";
        private string[] GetLastOriginalDate(string strDateFrom)
        {
            ArrayList list = new ArrayList();
            string[] strRet = new string[] { "", "" };
            list.Add(strDateFrom);
            list.Add(strDateFrom);
            DataTable ds = ServerHelper.GetData("com.steering.pss.ydm.Report.FrmrptStoveBatchStorage.getOriginaldate", new object[] { list }, this.ob);
            try
            {
                if (ds != null && ds.Rows.Count > 0)
                {
                    strRet[0] = Convert.ToString(ds.Rows[0]["original_date1"]);
                    strRet[1] = Convert.ToString(ds.Rows[0]["original_date_last"]);

                    if (string.IsNullOrEmpty(strRet[0]))
                    {
                        strRet[0] = Convert.ToString(ds.Rows[0]["original_date"]);
                    }

                    if (string.IsNullOrEmpty(strRet[0]))
                    {
                        strRet[0] = ORIGINAL_DATE;
                    }

                    if (string.IsNullOrEmpty(strRet[1]))
                    {
                        strRet[1] = ORIGINAL_DATE;
                    }
                }
                else
                {
                    strRet[0] = ORIGINAL_DATE;
                    strRet[1] = ORIGINAL_DATE;
                }
            }
            catch
            {
                strRet[0] = ORIGINAL_DATE;
                strRet[1] = ORIGINAL_DATE;
            }

            return strRet;
        }

        /// <summary>
        /// 导出
        /// </summary>
        private void ExportData()
        {
           
            GridHelper.ulGridToExcel(ultraGrid1,"炉批收发存汇总");
        }

        private void chkStorge_CheckedChanged(object sender, EventArgs e)
        {
            this.cmbStorgeNo.Enabled = this.chkStorge.Checked;
        }

        //private void chkMertailName_CheckedChanged(object sender, EventArgs e)
        //{
        //    this.cmbMertailName.Enabled = this.chkMertailName.Checked;
        //}

        //private void chkGj_CheckedChanged(object sender, EventArgs e)
        //{
        //    this.cmbGj.Enabled = this.chkGj.Checked;
        //}

        //private void chkGG_CheckedChanged(object sender, EventArgs e)
        //{
        //    this.cmbGg.Enabled = this.chkGG.Checked;
        //}

        private void rptProductStorage_Load(object sender, EventArgs e)
        {
            StatTime.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM") + "-01" + " 00:00:00");
            endTime.Value = DateTime.Today.AddDays(1).AddSeconds(-1);
                //DateTime.Parse(DateTime.Now.AddMonths(1).AddDays(1 - DateTime.Now.Day).AddHours(-24).ToString("yyyy-MM-dd") + " 23:59:59");
            YdmBaseClass.InitComboEditor(cmbStorgeNo, "com.steering.pss.ydm.pipemanage.CorePipeInTemp.getStorageDetail", "STORAGE_NO", this.ob, false);
        }

        private void cmbStorgeNo_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyValue == 13)
            {
                QueryData();
            }
        }

        private void cmbGj_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyValue == 13)
            {
                QueryData();
            }
        }

        private void cmbMertailName_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyValue == 13)
            {
                QueryData();
            }
        }

        private void cmbGg_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyValue == 13)
            {
                QueryData();
            }
        }

        private void chkGl_CheckedChanged(object sender, EventArgs e)
        {
            ultraGrid1.DataSource = dataTable1.DefaultView;
            if (chkGl.Checked)
            {
                dataTable1.DefaultView.RowFilter = "QUANTITYCOUNT = 0 and QUANTITYWGT <> 0 and MATCOUNT = 0";
            }
            else
            {
                dataTable1.DefaultView.RowFilter = "";
            }
            ultraGrid1.Refresh();
            ultraGrid1.Update();
            //DataRow[] drs = dataTable1.Select("QUANTITYCOUNT != '0' and QUANTITYWGT !='0.000'");
            //foreach (DataRow dr in drs)
            //{
            //    dataTable1.Rows.Remove(dr);
            //}
        }

    }
}