MES_Client/TGMES/Core.StlMes.Client.YdmPipeReport/03仓库入库汇总报表/RptInput.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;
using Core.Mes.Client.Comm.Tool;
using System.Collections;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Control;
using Core.StlMes.Client.YdmBase;
using Core.StlMes.Client.YdmPipeManage;
using Core.StlMes.Client.YdmPipeManage.Tool;
using Infragistics.Win.UltraWinGrid;
namespace Core.StlMes.Client.YdmPipeReport
{
    public partial class RptInput : FrmBase
    {
        public RptInput()
        {
            
            InitializeComponent();
        }



        /// <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 "Close":
                    this.Close();
                    break;
            }
        }

        /// <summary>
        /// 查询
        /// </summary>
        private void QueryData()
        {
            if (chkOrder.Checked && string.IsNullOrEmpty(this.cmbOrder.Text))
            {
                MessageUtil.ShowTips("请输入合同号!");
                this.cmbOrder.Focus();
                return;
            }
            //if (chkOrederNo.Checked && string.IsNullOrEmpty(this.cmbOrderNo.Text))
            //{
            //    MessageUtil.ShowTips("请输入合同行号!");
            //    this.cmbOrderNo.Focus();
            //    return;
            //}
            //if (chkOrderSeq.Checked && string.IsNullOrEmpty(this.cmbOrderSeq.Text))
            //{
            //    MessageUtil.ShowTips("请输入交货行!");
            //    this.cmbOrderSeq.Focus();
            //    return;
            //}
            if (chkStorge.Checked && string.IsNullOrEmpty(this.cmbStorgeNo.Text))
            {
                MessageUtil.ShowTips("请输入仓库号");
                this.cmbStorgeNo.Focus();
                return;
            }
            if (chkBactchNo.Checked && string.IsNullOrEmpty(this.cmbBacthNo.Text))
            {
                MessageUtil.ShowTips("请输入批号!");
                this.cmbBacthNo.Focus();
                return;
            }
            if (chkHeatNo.Checked && string.IsNullOrEmpty(this.cmbHeatNo.Text))
            {
                MessageUtil.ShowTips("请输入炉号!");
                this.cmbHeatNo.Focus();
                return;
            }
            if (chkDepartMent.Checked && string.IsNullOrEmpty(this.cmbDepartMent.Text))
            {
                MessageUtil.ShowTips("请输入所属单位!");
                this.cmbDepartMent.Focus();
                return;
            }

            string dtStartTime = "";
            string dtEndTime = "";
            string order = "";
            string orderNo = "";
            string orderSeq = "";
            string storgeNo = "";
            string batchNo = "";
            string heatNo = "";
            string bZ = "";
            string gG = "";
            string kX = "";
            string mertailName = "";
            string gJ = "";
            string departMent = "";
            string lB = "";
            string memo = "";
            ArrayList list = new ArrayList();
            string strSql = "";
            string strGroup = "";
            string strOut = "";
            string bathYear = "";
            if (chkYearMoth.Checked)
            {
                bathYear = this.dtBathYear.Value.ToString("yyyyMM");
                strOut += " and t.BAL_YEAR_MONTH = '" + bathYear + "'";
            }
            if (chkTime.Checked)
            {
                dtStartTime = this.StatTime.Value.ToString();
                dtEndTime = this.endTime.Value.ToString();
                strOut += " and TRUNC(IN_TIME_F) >= TRUNC(to_date('" + dtStartTime + "', 'yyyy-MM-dd HH24:mi:ss')) and TRUNC(t.IN_TIME_F) < TRUNC(to_date('" + dtEndTime + "', 'yyyy-MM-dd HH24:mi:ss'))";
            }
            //else
            //{ 
            //    dtStartTime = DateTime.Now.ToString("yyyy-MM") + "-01" + " 00:00:00";
            //    dtEndTime = DateTime.Now.AddMonths(1).AddDays(1 - DateTime.Now.Day).AddHours(-24).ToString("yyyy-MM-dd") + " 23:59:59";
            //    strOut += " and t.create_time >= to_date('" + dtStartTime + "', 'yyyy-MM-dd HH24:mi:ss') and t.create_time < to_date('" + dtEndTime + "', 'yyyy-MM-dd HH24:mi:ss')";
            //}
            if (chkOrder.Checked)
            {
                order = this.cmbOrder.Text.Trim();
                strOut += " and t.ORDER_NO||'/'||t.ORDER_SEQ like '%'|| '" + order + "'|| '%'";
            }
            if (chkStorge.Checked)
            {
                storgeNo = this.cmbStorgeNo.Value.ToString();
                strOut += " and t.STORAGE_NO like '%'|| '" + storgeNo + "'|| '%'";
            }
            if (chkBactchNo.Checked)
            {
                batchNo = this.cmbBacthNo.Text.Trim();
                strOut += " and t.BATCH_NO like '%'|| '" + batchNo + "'|| '%'";
            }
            if (chkHeatNo.Checked)
            {
                heatNo = this.cmbHeatNo.Text.Trim();
                strOut += " and t.JUDGE_STOVE_NO like '%'|| '" + heatNo + "'|| '%'";
            }
            if (chkDepartMent.Checked)
            {
                departMent = this.cmbDepartMent.Value.ToString();
                strOut += " and t.BELONG_CODE like '%'|| '" + departMent + "'|| '%'";
            }
            string strKey = "";
            CheckBox item;
            for (int i = 0; i < this.myCheckedListBox1.Controls.Count; i++)
            {
                try
                {
                    item = this.myCheckedListBox1.Controls[i] as CheckBox;

                    if (item != null && item.Checked)
                    {
                        strKey = item.Name;

                        if (strKey.Equals("INSTOCK_DOC"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "t.INSTOCK_DOC";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "t.INSTOCK_DOC";
                        }
                        if (strKey.Equals("INSTOCK_TYPE_NAME"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "t.INSTOCK_TYPE_NAME";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "t.INSTOCK_TYPE_NAME";
                        }
                        else if (strKey.Equals("STOVE_NO"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "t.STOVE_NO";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "t.STOVE_NO";
                        }
                        else if (strKey.Equals("JUDGE_STOVE_NO"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "t.JUDGE_STOVE_NO";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "t.JUDGE_STOVE_NO";
                        }
                        else if (strKey.Equals("BATCH_NO"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "t.BATCH_NO";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "t.BATCH_NO";
                        }
                        else if (strKey.Equals("PRODUCNAME"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "t.PRODUCNAME";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "t.PRODUCNAME";
                        }
                        else if (strKey.Equals("PRODUCNAME_TYPE"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "(SELECT T1.PRODUC_DESC FROM COM_BASE_PRODUCT T1 WHERE T1.PRODUCCODE = T.PRODUCCODE)PRODUCNAME_TYPE";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "T.PRODUCCODE";
                        }
                        else if (strKey.Equals("STD_NAME"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "t.STD_NAME";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "t.STD_NAME";
                        }
                        else if (strKey.Equals("STEELNAME"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "t.STEELNAME";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "t.STEELNAME";
                        }
                        else if (strKey.Equals("STD_STYLE_DESC"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "t.STD_STYLE_DESC";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "t.STD_STYLE_DESC";
                        }
                        else if (strKey.Equals("SPEC_NAME"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "t.SPEC_NAME";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "t.SPEC_NAME";
                        }
                        else if (strKey.Equals("MODEL_DESC"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "t.MODEL_DESC";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "t.MODEL_DESC";
                        }
                        else if (strKey.Equals("ACT_DIMATER"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "t.ACT_DIMATER";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "t.ACT_DIMATER";
                        }
                        else if (strKey.Equals("ACT_HEIGHT"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "t.ACT_HEIGHT";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "t.ACT_HEIGHT";
                        }
                        else if (strKey.Equals("ACT_LEN_MIN"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "t.ACT_LEN_MIN";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "t.ACT_LEN_MIN";
                        }
                        else if (strKey.Equals("ACT_LEN_MAX"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "t.ACT_LEN_MAX";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "t.ACT_LEN_MAX";
                        }
                        else if (strKey.Equals("BELONG_NAME"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "t.BELONG_NAME";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "t.BELONG_NAME";
                        }
                        else if (strKey.Equals("STORAGE_NAME"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "s.STORAGE_NAME";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "s.STORAGE_NAME";
                        }
                        else if (strKey.Equals("PIPMEMO"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "t.PIPMEMO";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "t.PIPMEMO";
                        }
                        else if (strKey.Equals("MEMO"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "t.MEMO";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "t.MEMO";
                        }
                        else if (strKey.Equals("CREATE_NAME"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "t.CREATE_NAME";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "t.CREATE_NAME";
                        }
                        else if (strKey.Equals("ORDER_NO"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "t.ORDER_NO";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "t.ORDER_NO";
                        }
                        else if (strKey.Equals("ORDER_SEQ"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "t.ORDER_SEQ";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "t.ORDER_SEQ";
                        }
                        else if (strKey.Equals("DELIVERY_NO"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "t.DELIVERY_NO";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "t.DELIVERY_NO";
                        }
                        else if (strKey.Equals("PRODUCT_FLAG"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "DECODE(t.PRODUCT_FLAG,'801401','在制品','801402','成品','801403','商品')PRODUCT_FLAG";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "t.PRODUCT_FLAG";
                        }
                        else if (strKey.Equals("PLINE_NAME"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "t.PLINE_NAME";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "t.PLINE_NAME";
                        }
                        else if(strKey.Equals("SALE_AREA_DESC"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "d.SALE_AREA_DESC";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "d.SALE_AREA_DESC";
                        }
                        else if (strKey.Equals("ORDERCRATENAME"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "d.CREATE_NAME AS ORDERCRATENAME";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "d.CREATE_NAME";
                        }
                        else if (strKey.Equals("RECEIV_NM"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "g.RECEIV_NM";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "g.RECEIV_NM";
                        }
                        else if (strKey.Equals("CUSTOMER_NM"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "d.CUSTOMER_NM";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "d.CUSTOMER_NM";
                        }
                        else if (strKey.Equals("SORDER"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "t.ORDER_NO ||'/'||t.ORDER_SEQ AS SORDER";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "t.ORDER_NO ||'/'||t.ORDER_SEQ";
                        }
                        else if (strKey.Equals("CREATE_TIME"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "to_char(t.CREATE_TIME,'YYYY-MM-DD') as CREATE_TIME";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "to_char(t.CREATE_TIME,'YYYY-MM-DD')";
                        }
                        else if (strKey.Equals("GRADECODE"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "t.GRADECODE";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "t.GRADECODE";
                        }
                        else if (strKey.Equals("GRADENAME"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "t.GRADENAME";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "t.GRADENAME";
                        }
                        else if (strKey.Equals("BATCH_GROUD_NO"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "t.BATCH_GROUD_NO";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "t.BATCH_GROUD_NO";
                        }
                        else if (strKey.Equals("ASSORTMENT_NAME"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "t1.ASSORTMENT_NAME";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "t1.ASSORTMENT_NAME";
                        }
                        else if (strKey.Equals("FINISHPRO_MOLD"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "DECODE(t.FINISHPRO_MOLD,'801801','合同变更','801802','超交货期','801803','超载甩量','801804','成品备库','801805','质量异议待处理') FINISHPRO_MOLD";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "t.FINISHPRO_MOLD";
                        }
                        else if (strKey.Equals("IN_MOLD"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + " (SELECT BASENAME FROM COM_BASE_INFO WHERE BASECODE = T.IN_MOLD AND ROWNUM = 1) IN_MOLD";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "t.IN_MOLD";
                        }
                        else if (strKey.Equals("IN_TYPE"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + " (SELECT BASENAME FROM COM_BASE_INFO WHERE BASECODE = T.IN_TYPE AND ROWNUM = 1) IN_TYPE";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "t.IN_TYPE";
                        }
                        else if (strKey.Equals("THCP"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "CASE WHEN T.ORDER_NO LIKE 'TH%' THEN '成品' WHEN MAX( ZG.TH_ORDER_NO_SEQ ) = t.ORDER_NO || '/' || t.ORDER_SEQ THEN '半成品' END THCP";
                            strGroup += "";
                        }
                        else if (strKey.Equals("THZZ"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "CASE WHEN T.ORDER_NO LIKE 'TH%' THEN D.CUSTOMER_NM WHEN MAX( ZG.TH_ORDER_NO_SEQ ) = t.ORDER_NO || '/' || t.ORDER_SEQ THEN '天津钢管制造有限公司' END THZZ";
                            strGroup += "";
                        }
                        else if (strKey.Equals("PRIORITY_MEMO"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "MAX((SELECT PRIORITY_MEMO FROM PLN_SALEORD_PROC WHERE ORD_LN_DLY_PK = T.ORD_LN_DLY_PK AND ROWNUM = 1)) PRIORITY_MEMO";
                            strGroup += "";
                        }
                        else if (strKey.Equals("PACK_NO"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "t.PACK_NO";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "t.PACK_NO";
                        }
                        else if (strKey.Equals("PACK_NUM"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "GET_PACK_NUM_IN( t.JUDGE_STOVE_NO ) PACK_NUM";
                            strGroup += "";
                        }
                        else if (strKey.Equals("DOCUMENTARY_NAME"))
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",") + "d.DOCUMENTARY_NAME";
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "" : ",") + "d.DOCUMENTARY_NAME";
                        }
                        else
                        {
                            strSql += (string.IsNullOrEmpty(strSql) ? "t." : ",t.") + strKey;
                            strGroup += (string.IsNullOrEmpty(strGroup) ? "t." : ",t.") + strKey;
                        }
                    }
                }
                catch { }
            }
            strSql += (string.IsNullOrEmpty(strSql) ? "" : ",");
            strGroup = (string.IsNullOrEmpty(strGroup) ? "" : "group by ") + strGroup;
            string _sql = strOut + strGroup;
            list.Add(strSql);
            //list.Add(_sql);
            list.Add(strOut);
            list.Add(strGroup);
            DataTable ds = new DataTable();
            switch (this.CustomInfo)
            {
                case "BELONG_CODE":
                    string[] arr = BaseMethod.InitPermissions(this.ValidDataPurviewIds, this.ob);
                    if (arr == null)
                    {
                        MessageUtil.ShowTips("无销售组织权限!");
                        return;
                    }
                    string supplyUnit = "120501";
                    ds = ServerHelper.GetData("com.steering.pss.ydm.Report.FrmRptInput.queryInListData", new object[] { list, arr, supplyUnit, this.ValidDataPurviewIds }, this.ob);
                    GridHelper.CopyDataToDatatable(ref ds, ref this.dataTable4, true);
                    break;
                case "BELONG_CODE_TH":
                    string[] arr2 = BaseMethod.InitPermissions(this.ValidDataPurviewIds, this.ob);
                    if (arr2 == null)
                    {
                        MessageUtil.ShowTips("无销售组织权限!");
                        return;
                    }
                    string supplyUnit_TH = "120504";
                    ds = ServerHelper.GetData("com.steering.pss.ydm.Report.FrmRptInput.queryInListData", new object[] { list, arr2 , supplyUnit_TH}, this.ob);
                    GridHelper.CopyDataToDatatable(ref ds, ref this.dataTable4, true);
                    break;
                case "STORAGE_NO":
                    string[] arr1 = BaseMethod.WarehousePermissions(this.CustomInfo,this.ValidDataPurviewIds, this.ob);
                    if (arr1 == null)
                    {
                        MessageUtil.ShowTips("无仓库数据权限!");
                        return;
                    }
                    ds = ServerHelper.GetData("com.steering.pss.ydm.Report.FrmRptInput.queryInList", new object[] { list, arr1 }, this.ob);
                    GridHelper.CopyDataToDatatable(ref ds, ref this.dataTable4, true);
                    break;

            }
            

           
            bool bContains = false, bChecked = false;

            for (int i = 0; i < this.ultraGrid1.DisplayLayout.Bands[0].Columns.Count; i++)
            {
                try
                {
                    bContains = false;
                    strKey = this.ultraGrid1.DisplayLayout.Bands[0].Columns[i].Key;

                    for (int j = 0; j < this.myCheckedListBox1.Controls.Count; j++)
                    {
                        try
                        {
                            item = this.myCheckedListBox1.Controls[j] as CheckBox;

                            if (item.Name.Equals(strKey))
                            {
                                bContains = true;
                                bChecked = item.Checked;
                                break;
                            }
                        }
                        catch { }
                    }

                    if (bContains)
                    {
                        this.ultraGrid1.DisplayLayout.Bands[0].Columns[i].Hidden = !bChecked;
                    }
                }
                catch { }
            }

           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("ACT_COUNT");
                    alist.Add("ACT_WEIGHT");
                    alist.Add("ACT_LEN");
                    //alist.Add("PACK_NO");
                    CommonMethod.SetStaticsInfoSum(ref this.ultraGrid1, alist, true);
                }
            }
            catch { }
        }

        /// <summary>
        /// 导出
        /// </summary>
        private void ExportData()
        {
            GridHelper.ulGridToExcel(ultraGrid1,"入库实绩总汇");
        }
        ArrayList alistChecked = null;
        private void RptInput_Load(object sender, EventArgs e)
        {
            if ("BELONG_CODE".Equals(this.CustomInfo))
            {
                this.ultraGrid1.DisplayLayout.Bands[0].Columns["THCP"].Hidden = true;
                this.ultraGrid1.DisplayLayout.Bands[0].Columns["THZZ"].Hidden = true;
            }
            //StatTime.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM") + "-01" + " 00:00:00");
            //endTime.Value = DateTime.Parse(DateTime.Now.AddMonths(1).AddDays(1 - DateTime.Now.Day).AddHours(-24).ToString("yyyy-MM-dd") + " 23:59:59");
            StatTime.Value = DateTime.Parse(new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1).ToString());
            DateTime d1 = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
            endTime.Value = DateTime.Parse(d1.AddMonths(1).AddDays(-1).ToString("yyyy-MM-dd") + " 23:59:59");
            dtBathYear.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM"));
            switch (this.CustomInfo)
            {
                case"BELONG_CODE":
                    YdmBaseClass.InitComboEditor(cmbStorgeNo, "com.steering.pss.ydm.pipemanage.CorePipeInTemp.getStorageDetail", "STORAGE_NO", this.ob, false);
                    break;
                case "STORAGE_NO":
                    BaseMethod.InitStorage(cmbStorgeNo, CustomInfo, this.ValidDataPurviewIds, this.ob);
                    break;

            }
            
            

            try
            {
                alistChecked = new ArrayList();
                alistChecked.Add("PRODUCNAME");
                alistChecked.Add("STD_STYLE_DESC");
                //alistChecked.Add("DELIVERY_NO");
                //alistChecked.Add("STORAGE_NO");
                alistChecked.Add("SPEC_NAME");
                alistChecked.Add("STEELNAME");
                alistChecked.Add("MODEL_DESC");
                alistChecked.Add("BELONG_NAME");
                //alistChecked.Add("BATCH_GROUD_NO");
                //alistChecked.Add("STD_NAME");
                //alistChecked.Add("SPEC_NAME");
                //alistChecked.Add("MODEL_DESC");
               // alistChecked.Add("PRODUCNAME");
                //alistChecked.Add("STEELNAME");
                //alistChecked.Add("BELONG_NAME");
                //alistChecked.Add("PRODUCT_FLAG");
                //alistChecked.Add("MEMO");
            }
            catch { }

            try
            {
                ArrayList alist = new ArrayList();

                alist.Add("ACT_COUNT");
                alist.Add("ACT_WEIGHT");
                alist.Add("ACT_LEN");
               // alist.Add("PACK_NO");
                //foreach (UltraGridColumn column in ultraGrid1.DisplayLayout.Bands[0].Columns)
                //{
                //    if (column.Hidden)
                //    {
                //        continue;
                //    }
                    
                //    CheckBox cb = new CheckBox();
                //    cb.Margin = new Padding(1);
                //    cb.Width = 40;
                //    cb.AutoSize = true;
                //    cb.Text = column.Header.Caption;
                //    cb.Name = column.Key;
                //    this.myCheckedListBox1.Controls.Add(cb);
                //}
               CommonMethod.GeneralCheckedListboxItems(ref this.myCheckedListBox1, ref this.ultraGrid1, alist, alistChecked);
            }
            catch { }

            //this.ultraGrid1.DisplayLayout.Bands[0].Columns["ACT_WEIGHT"].MaskInput = "-nnn,nnn,nnn.nnn";
        }

        /// <summary>
        /// 全选
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void myLinkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
        {
            this.myCheckedListBox1.CheckAll();
        }
        
        /// <summary>
        /// 清除
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void myLinkLabel2_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
        {
            
            this.myCheckedListBox1.UnCheckAll();
        }

        /// <summary>
        /// 默认
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void myLinkLabel3_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
        {
            CheckBox items;

            for (int i = 0; i < this.myCheckedListBox1.Controls.Count; i++)
            {
                try
                {
                    items = this.myCheckedListBox1.Controls[i] as CheckBox;
                    if (alistChecked.Contains(items.Name))
                    {
                        items.Checked = true;
                    }
                    else
                    {
                        items.Checked = false;
                    }
                }
                catch { }
            }

            //this.myCheckedListBox1.ClearSelected();
        }

        private void chkTime_CheckedChanged(object sender, EventArgs e)
        {
            StatTime.Enabled = this.chkTime.Checked;
            endTime.Enabled = this.chkTime.Checked;
        }

        private void chkOrder_CheckedChanged(object sender, EventArgs e)
        {
            cmbOrder.Enabled = this.chkOrder.Checked;
        }

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

        private void chkBactchNo_CheckedChanged(object sender, EventArgs e)
        {
            this.cmbBacthNo.Enabled = this.chkBactchNo.Checked;
        }

        private void chkHeatNo_CheckedChanged(object sender, EventArgs e)
        {
            this.cmbHeatNo.Enabled = this.chkHeatNo.Checked;
        }
        private void chkDepartMent_CheckedChanged(object sender, EventArgs e)
        {
            this.cmbDepartMent.Enabled = this.chkDepartMent.Checked;
        }
        private void cbx_GroupBy_CheckedChanged(object sender, EventArgs e)
        {
            CommonMethod.SetGridGroupBy(ref this.ultraGrid1, cbx_GroupBy.Checked);
            CommonMethod.SetGridSumArea(this.ultraGrid1);
        }

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

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

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

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

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

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

        private void cmbBZ_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 cmbKX_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 cmbGj_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyValue == 13)
            {
                QueryData();
            }
        }

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

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

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

        private void chkYearMoth_CheckedChanged(object sender, EventArgs e)
        {
            this.dtBathYear.Enabled = this.chkYearMoth.Checked;
        }
    }
}