MES_Client/TGMES/Core.StlMes.Client.ZGMil/Report/FrmMilControlLog.cs

using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Tool;
using Core.StlMes.Client.ZGMil.Common;
using Core.StlMes.Client.ZGMil.Entity;
using Core.StlMes.Client.ZGMil.ResultConrtrol;
using Core.StlMes.Client.ZGMil.Signature;
using CoreFS.CA06;
using Infragistics.Win;
using Infragistics.Win.UltraWinGrid;
using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace Core.StlMes.Client.ZGMil.Report
{
    public partial class FrmMilControlLog : FrmBase
    {
        private string departm = "";
        private string plineCode = "";
        private string[] plineCodes = { };
        public FrmMilControlLog()
        {
            InitializeComponent();
            this.IsLoadUserView = true;
        }

        private void FrmMilControlLog_Load(object sender, EventArgs e)
        {
            cmbDate.Value = DateTime.Parse(DateTime.Today.ToString());
            NativeMethodNew na = new NativeMethodNew(this.ob);
            departm = UserInfo.GetDepartment();
            plineCode = na.GetPCode(departm);//获取 用户 对应的产线
            plineCodes = BaseMethod.GetPlineCode(ValidDataPurviewIds, ob);

            if (plineCode.Equals("C008") || plineCode.Equals("C009") || plineCode.Equals("C010") || plineCode.Equals("C017"))
            {
                ultraCheckEditor2.Visible = false;
                ultraComboEditor1.Visible = false;
            }

            DateTime now = DateTime.Now;
            DateTime date = new DateTime(now.Year,now.Month,1);
            cmbDate.Value = DateTime.Parse(date.ToString("yyyy-MM-dd"));
            cmbEndDate.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd"));

            dateBAL_YEAR_MONTH.Text = now.ToString("yyyy年MM月");
            dateTimePicker2.Text = now.ToString("yyyy年MM月");

            TubeRoll.SetComboItemHeight(cmbBc);
            TubeRoll.SetComboItemHeight(cmbBz);
        }

        /// <summary>
        /// 重写基类方法
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="ToolbarKey"></param>
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    doQuery();
                    break;
                case "DoQuery":
                    doQuery2();
                    break;
                case "Query3":
                    doQuery3();
                    break;
                case "Update":
                    updateHrCapcty();
                    break;
                case "Print":
                    doPrint();
                    break;
                case "Export":
                    ExportData();
                    break;
                case "Close":
                    this.Close();
                    break;
            }
        }

        /// <summary>
        /// 回报小时能力
        /// </summary>
        private void updateHrCapcty()
        {
            ArrayList listAll = new ArrayList();
            if (ultraGrid2.Rows.Count > 0)
            {
                foreach (UltraGridRow ugr in ultraGrid2.Rows)
                {
                    ArrayList list = new ArrayList();
                    list.Add(ugr.Cells["XSJZ"].Value.ToString());
                    list.Add(ugr.Cells["QUALIFIED_NUM"].Value.ToString());
                    list.Add(ugr.Cells["INWL_ID"].Value.ToString());
                    list.Add(ugr.Cells["OUTWL_ID"].Value.ToString());
                    list.Add(ugr.Cells["PLINE_CODE"].Value.ToString());
                    listAll.Add(list);
                }
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.zgmil.report.FrmMilDateStatistics";
            ccp.MethodName = "updateMilControlLog";
            ccp.ServerParams = new object[] { listAll };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            MessageUtil.ShowTips(ccp.ReturnInfo);
        }

        /// <summary>
        /// 停机汇总
        /// </summary>
        private void doQuery3()
        {
            string time = "";
            string plineCode = "";
            if (ultraCheckEditor1.Checked)
            {
                if (dateTimePicker2.Text.Trim() == "")
                {
                    time = "";
                }
                else
                {
                    time = dateTimePicker2.Value.ToString("yyyyMM");
                }
            }

            if (getPlineCode().Equals(""))
            {
                if (ultraCheckEditor2.Checked)
                {
                    if (ultraComboEditor1.Text.Trim() == "")
                    {
                        plineCode = "";
                    }
                    else
                    {
                        plineCode = ultraComboEditor1.Value.ToString();
                    }
                }
            }
            else {

                plineCode = getPlineCode();
            }


            DataTable dt = ServerHelper.GetData("com.steering.mes.zgmil.report.FrmMilDateStatistics.getMilControlLog3", new Object[] { time, plineCodes }, this.ob);
            GridHelper.CopyDataToDatatable(dt, this.dataTable3, true);
            GridHelper.RefreshAndAutoSize(this.ultraGrid3);

        }

        /// <summary>
        /// 调  度  统  计(小时能力)查询
        /// </summary>
        private void doQuery2()
        {
            string time = "";
            if (ckBAL_YEAR_MONTH.Checked)
            {
                if (dateBAL_YEAR_MONTH.Text.Trim() == "")
                {
                    time = "";
                }
                else
                {
                    time = dateBAL_YEAR_MONTH.Value.ToString("yyyyMM");
                }
            }

            DataTable dt = ServerHelper.GetData("com.steering.mes.zgmil.report.FrmMilDateStatistics.getMilControlLog2", new Object[] { time, plineCodes }, this.ob);
            GridHelper.CopyDataToDatatable(dt, this.dataTable2, true);
            GridHelper.RefreshAndAutoSize(this.ultraGrid2);
            
        }


        private void chkDate_CheckedChanged(object sender, EventArgs e)
        {
            if (chkDate.Checked) { cmbDate.Enabled = true; } else { cmbDate.Enabled = false; }
            if (chkDate.Checked) { cmbEndDate.Enabled = true; } else { cmbEndDate.Enabled = false; }
            if (chkBc.Checked) { cmbBc.Enabled = true; } else { cmbBc.Enabled = false; }
            if (chkBz.Checked) { cmbBz.Enabled = true; } else { cmbBz.Enabled = false; }
            if (chkLH.Checked) { cmbLH.Enabled = true; } else { cmbLH.Enabled = false; }
            if (ckBAL_YEAR_MONTH.Checked) { dateBAL_YEAR_MONTH.Enabled = true; } else { dateBAL_YEAR_MONTH.Enabled = false; }
            if (ultraCheckEditor1.Checked) { dateTimePicker2.Enabled = true; } else { dateTimePicker2.Enabled = false; }
            if (ultraCheckEditor2.Checked) { ultraComboEditor1.Enabled = true; } else { ultraComboEditor1.Enabled = false; }
        }

        /// <summary>
        /// 查询
        /// </summary>
        private void doQuery()
        {

            //ArrayList list = new ArrayList();
            string date = "";
            string endDate = "";
            string judgeStoveNo = "";
            string bc = "";
            string bz = "";
            if (chkDate.Checked)
            {
                if (cmbDate.Text.Trim() == "")
                {
                    date = "";
                }
                else
                {
                    date = cmbDate.Value.ToString("yyyyMMdd");
                    //date = date.Replace("-","");
                }
            }
            if (chkDate.Checked)
            {
                if (cmbEndDate.Text.Trim() == "")
                {
                    endDate = "";
                }
                else
                {
                    endDate = cmbEndDate.Value.ToString("yyyyMMdd");
                    //date = date.Replace("-","");
                }
            }
            if (chkLH.Checked)
            {
                if (cmbLH.Text.Trim() == "")
                {
                    judgeStoveNo = "";
                }
                else
                {
                    judgeStoveNo = cmbLH.Value.ToString();
                }
            }
            if (chkBz.Checked)
            {
                if (cmbBz.Text.Trim() == "")
                {
                    bz = "";
                }
                else
                {
                    bz = cmbBz.Value.ToString();
                }
            }
            if (chkBc.Checked)
            {
                if (cmbBc.Text.Trim() == "")
                {
                    bc = "";
                }
                else
                {
                    bc = cmbBc.Value.ToString();
                }
            }

            DataTable dt = ServerHelper.GetData("com.steering.mes.zgmil.report.FrmMilDateStatistics.getMilControlLog", new Object[] { date, endDate, judgeStoveNo, bc, bz, plineCodes }, this.ob);
            GridHelper.CopyDataToDatatable(dt, this.dataTable1, true);
            GridHelper.RefreshAndAutoSize(this.ultraGrid1);
 
        }


        /// <summary>
        /// 打印
        /// </summary>
        private void doPrint()
        {
            string date = "";
            string endDate = "";
            string judgeStoveNo = "";
            string bc = "";
            string bz = "";
            if (chkDate.Checked)
            {
                if (cmbDate.Text.Trim() == "")
                {
                    date = "";
                }
                else
                {
                    date = cmbDate.Value.ToString("yyyyMMdd");
                    //date = date.Replace("-","");
                }
            }
            if (chkDate.Checked)
            {
                if (cmbEndDate.Text.Trim() == "")
                {
                    endDate = "";
                }
                else
                {
                    endDate = cmbEndDate.Value.ToString("yyyyMMdd");
                    //date = date.Replace("-","");
                }
            }
            if (chkLH.Checked)
            {
                if (cmbLH.Text.Trim() == "")
                {
                    judgeStoveNo = "";
                }
                else
                {
                    judgeStoveNo = cmbLH.Value.ToString();
                }
            }
            if (chkBz.Checked)
            {
                if (cmbBz.Text.Trim() == "")
                {
                    bz = "";
                }
                else
                {
                    bz = cmbBz.Value.ToString();
                }
            }
            if (chkBc.Checked)
            {
                if (cmbBc.Text.Trim() == "")
                {
                    //MessageUtil.ShowTips("班次不能为空！");
                    //return;
                    bc = "";
                }
                else
                {
                    bc = cmbBc.Value.ToString();
                }
            }
            doQuery();

            string url = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepMilControlLog.cpt&format=pdf&__bypagesize__=false&PRO_BC=" + bc + "&PRO_BZ=" + bz + "&PROC_DATE=" + date + "&endDate=" + endDate + "&JUDGE_STOVE_NO=" + judgeStoveNo + "&PLINE_CODE=" + plineCode;
            
            FrmRepExcel fre = new FrmRepExcel(this.ob, url);
            //fre.AutoSize = true;
            fre.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
            fre.Text = "调度统计";
            fre.ShowDialog();
        }

        /// <summary>
        /// 非250、258、168、460的产线代码都为空
        /// </summary>
        /// <returns></returns>
        private string getPlineCode()
        {
            if (plineCode.Equals("C008") || plineCode.Equals("C009") || plineCode.Equals("C010") || plineCode.Equals("C017"))
            {
                return plineCode;
            }
            else
            {
                return "";
            }
        }

        /// <summary>
        /// 导出
        /// </summary>
        private void ExportData()
        {
            if (ultraTabControl1.SelectedTab.Key == "0")
            {
                GridHelper.ulGridToExcel(ultraGrid1, "调度统计");
            }
            else if (ultraTabControl1.SelectedTab.Key == "2")
            {
                GridHelper.ulGridToExcel(ultraGrid3, "停机汇总");
            }
            
        }


        private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            if (toolMenu == null) return;
            if (ultraTabControl1.SelectedTab.Key == "0")
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Query"))
                {
                    toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("DoQuery"))
                {
                    toolMenu.Toolbars[0].Tools["DoQuery"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Query3"))
                {
                    toolMenu.Toolbars[0].Tools["Query3"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Update"))
                {
                    toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Export"))
                {
                    toolMenu.Toolbars[0].Tools["Export"].InstanceProps.Visible = DefaultableBoolean.True;
                }
            }
            else if (ultraTabControl1.SelectedTab.Key == "1")
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Query"))
                {
                    toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("DoQuery"))
                {
                    toolMenu.Toolbars[0].Tools["DoQuery"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Query3"))
                {
                    toolMenu.Toolbars[0].Tools["Query3"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Update"))
                {
                    toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Export"))
                {
                    toolMenu.Toolbars[0].Tools["Export"].InstanceProps.Visible = DefaultableBoolean.False;
                }
            }
            else if (ultraTabControl1.SelectedTab.Key == "2")
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Query"))
                {
                    toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("DoQuery"))
                {
                    toolMenu.Toolbars[0].Tools["DoQuery"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Query3"))
                {
                    toolMenu.Toolbars[0].Tools["Query3"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Update"))
                {
                    toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Export"))
                {
                    toolMenu.Toolbars[0].Tools["Export"].InstanceProps.Visible = DefaultableBoolean.True;
                }
            }

        }

        private void FrmMilControlLog_Shown(object sender, EventArgs e)
        {
            if (toolMenu == null) return;
            if (toolMenu.Toolbars[0].Tools.Exists("DoQuery"))
            {
                toolMenu.Toolbars[0].Tools["DoQuery"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("Update"))
            {
                toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("Query3"))
            {
                toolMenu.Toolbars[0].Tools["Query3"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            
        }
    }
}