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 CRptInput : FrmBase
    {
        public CRptInput()
        {
            
            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 (chkHeatNo.Checked && string.IsNullOrEmpty(this.cmbHeatNo.Text))
            {
                MessageUtil.ShowTips("请输入炉号!");
                this.cmbHeatNo.Focus();
                return;
            }
            
            string dtStartTime = "";
            string dtEndTime = "";
            string order = "";
            string heatNo = "";
            string produceFlag = "";
            ArrayList list = new ArrayList();
            string strSql = "";
            string strGroup = "";
            string strOut = "";
            string bathYear = "";
            string userid = UserInfo.GetDeptid();
            string userMent = BaseMethod.GetDepartIdBySectionId(UserInfo.GetDeptid(), ob);//部门
            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 t.IN_TIME_F >= to_date('" + dtStartTime + "', 'yyyy-MM-dd HH24:mi:ss') and t.IN_TIME_F < to_date('" + dtEndTime + "', 'yyyy-MM-dd HH24:mi:ss')";
            }
            if (chkOrder.Checked)
            {
                order = this.cmbOrder.Text.Trim();
                strOut += " and t.ORDER_NO like '%'|| '" + order + "'|| '%'";
            }
            if (chkProudceFlag.Checked)
            {
                produceFlag = this.cmbProduceFlag.Value.ToString2();
                strOut += " and t.PRODUCT_FLAG = '" + produceFlag + "'";
            }
            if (chkHeatNo.Checked)
            {
                heatNo = this.cmbHeatNo.Text.Trim();
                strOut += " and t.JUDGE_STOVE_NO like '%'|| '" + heatNo + "'|| '%'";
            }
            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";
                        }
                        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("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("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("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) ? "" : ",") + "t.CREATE_TIME";
                        }
                        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
                        {
                            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();
            string[] arr = new string[0];
            List<string> arrlist = arr.ToList();
            switch (this.CustomInfo)
            {
                case "STORAGE_NO":
                    IQueryable<UltraGridRow> checkMagRows = this.ultraGrid2.Rows.AsQueryable().Where(" CHK = 'True'");
                    if (checkMagRows.Count() == 0)
                    {
                        MessageUtil.ShowTips("请选择对应的仓库!");
                        return;
                    }
                    foreach (UltraGridRow uRow in checkMagRows)
                    {
                        arrlist.Add(uRow.Cells["STORAGE_NO"].Value.ToString());
                    }
                    arr = arrlist.ToArray();
                    ds = ServerHelper.GetData("com.steering.pss.ydm.Report.FrmRptInput.queryInListDataC", new object[] { list, arr, "0" }, this.ob);
                    GridHelper.CopyDataToDatatable(ref ds, ref this.dataTable4, true);
                    break;
                case "BELONG_CODE":
                    //arr = BaseMethod.getRoleValidPurviewBelong(userid, userMent, this.ob);
                    IQueryable<UltraGridRow> checkMagRows1 = this.ultraGrid3.Rows.AsQueryable().Where(" CHK1 = 'True'");
                    if (checkMagRows1.Count() == 0)
                    {
                        MessageUtil.ShowTips("请选择对应的所属权!");
                        return;
                    }
                    foreach (UltraGridRow uRow in checkMagRows1)
                    {
                        arrlist.Add(uRow.Cells["DEPARTMENT_CODE"].Value.ToString());
                    }
                    arr = arrlist.ToArray();
                    ds = ServerHelper.GetData("com.steering.pss.ydm.Report.FrmRptInput.queryInListDataB", new object[] { list, arr, "0" }, 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");
                    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)
        {
            //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"));
            BaseMethod.InitProducFlagCom(cmbProduceFlag,ob);
            switch (this.CustomInfo)
            {
                case "STORAGE_NO":
                    this.cmbStorgeNo.Visible = true;
                    this.ultraLabel2.Visible = true;
                    this.cmbBelog.Visible = false;
                    this.ultraLabel3.Visible = false;
                    BaseMethod.InitStorageCom(cmbStorgeNo, dataTable1, this.ValidDataPurviewIds, this.ob);
                    break;
                case "BELONG_CODE":
                     this.cmbStorgeNo.Visible = false;
                    this.ultraLabel2.Visible = false;
                    this.cmbBelog.Visible = true;
                    this.ultraLabel3.Visible = true;
                    BaseMethod.InitStorageBelog(cmbBelog, dataTable2, 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");
                
                //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 chkHeatNo_CheckedChanged(object sender, EventArgs e)
        {
            this.cmbHeatNo.Enabled = this.chkHeatNo.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;
        }

        private void cmbStorgeNo_AfterDropDown(object sender, EventArgs e)
        {
            Point p = ultraGroupBox1.PointToScreen(cmbStorgeNo.Location);
            p.Y += 22;
            this.ultraPopupControlContainer1.Show(p);
        }

        private void cmbBelog_AfterDropDown(object sender, EventArgs e)
        {
            Point p = ultraGroupBox1.PointToScreen(cmbBelog.Location);
            p.Y += 22;
            this.ultraPopupControlContainer2.Show(p);
        }

        private void chkProudceFlag_CheckedChanged(object sender, EventArgs e)
        {
            cmbProduceFlag.Enabled = chkProudceFlag.Checked;
        }


        private void ultraPopupControlContainer1_Closed(object sender, EventArgs e)
        {
            this.ultraLabel4.Text = "";
            foreach(UltraGridRow uRow in this.ultraGrid2.Rows)
            {
                if (uRow.Cells["CHK"].Value.ToString() == "True")
                {
                    this.ultraLabel4.Text += uRow.Cells["STORAGE_NAME"].Text + "  ";
                }
            }
        }

        private void ultraPopupControlContainer2_Closed(object sender, EventArgs e)
        {
            this.ultraLabel4.Text = "";
            foreach (UltraGridRow uRow in this.ultraGrid3.Rows)
            {
                if (uRow.Cells["CHK1"].Value.ToString() == "True")
                {
                    this.ultraLabel4.Text += uRow.Cells["DEPARTMENT_DESC"].Text + "  ";
                }
            }
        }
    }
}