MES_Client/TGMES/Core.StlMes.Client.Mcp.VRP/Vrp/FrmProcessQurey.cs

using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Tool;
using Core.StlMes.Client.Mcp.Control;
using CoreFS.CA06;
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.Mcp.VRP.Vrp
{
    public partial class FrmProcessQurey : FrmBase
    {
        private string plineCode = "";
        private string manageNmae = ""; //科室名称
        private string stationCode = "";//工序代码
        public FrmProcessQurey()
        {
            InitializeComponent();
            this.IsLoadUserView = true;
        }

        private void FrmProcessQurey_Load(object sender, EventArgs e)
        {
            StartTime.Value = DateTime.Parse(DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd 21:00"));
            EndTime.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 20:59"));

            manageNmae = UserInfo.GetDepartment();

            comm.InitDropPlinePower("E", txt_PlinCode, this.ValidDataPurviewIds, this.ob);
            txt_PlinCode.SelectedIndex = 0;

        }
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            //base.ToolBar_Click(sender, ToolbarKey);
            switch (ToolbarKey)
            {
                case "Query":
                    DoQuery();
                    break;
                case "Export":
                    GridHelper.ulGridToExcel(ultraGrid1, "镦拔扩进程数据统计");
                    break;
                case "Close":
                    this.Close();
                    break;
            }
        }
        /// <summary>
        /// 查询
        /// </summary>
        /// <returns></returns>
        private void DoQuery()
        {
            string judgeNo = "";
            string batchNo = "";
            string orderNo = "";
            if (!CheckQuery()) return;
            string staTime = "";
            string endTime = "";

            if (chkTim.Checked)
            {
                staTime = StartTime.Value.ToString();
                endTime = EndTime.Value.ToString();
            }
            if(chkLotNo.Checked)
            {
                batchNo = this.txtLotNo.Text.Trim();
            }
            if(chkJugeHeatNo.Checked)
            {
                judgeNo = this.txtJugeNo.Text.Trim();
            }
            if(chkOrder.Checked)
            {
                orderNo = this.txtOrder.Text.Trim();
            }
            ArrayList list = new ArrayList();
            list.Add(staTime);
            list.Add(endTime);
            list.Add(judgeNo);
            list.Add(batchNo);
            list.Add(orderNo);
            DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.Report.FrmDBKPerformance.doQueryPort", new object[] { list, plineCode,stationCode }, ob);
            GridHelper.CopyDataToDatatable(ref dt1, ref dataTable1, true);
        }

        private void chkTim_CheckedChanged(object sender, EventArgs e)
        {
            if (chkTim.Checked) { StartTime.Enabled = true; EndTime.Enabled = true; } else { StartTime.Enabled = false; EndTime.Enabled = false; }
            if (chkJugeHeatNo.Checked) { txtJugeNo.Enabled = true; } else { txtJugeNo.Enabled = false; }
            if (chkLotNo.Checked) { txtLotNo.Enabled = true; } else { txtLotNo.Enabled = false; }
            if (chkOrder.Checked) { txtOrder.Enabled = true; }
            else
            {
                txtOrder.Enabled = false;
            }
        }
        /// <summary>
        /// 数据验证
        /// </summary>
        /// <returns></returns>
        private bool CheckQuery()
        {
            if (DataTimeUtil.JudgeTime(DateTime.Parse(StartTime.Value.ToString()), DateTime.Parse(EndTime.Value.ToString())) == 0)
            {
                MessageUtil.ShowTips("您所选择的日期区域不对,请重新选择！");
                return false;
            }
            if (this.chkJugeHeatNo.Checked && string.IsNullOrEmpty(this.txtJugeNo.Text.Trim()))
            {
                MessageUtil.ShowWarning("请输入炉号！");
                return false;
            }
            if (this.chkLotNo.Checked && string.IsNullOrEmpty(this.txtLotNo.Text.Trim()))
            {
                MessageUtil.ShowWarning("请输入批号！");
                return false;
            }
            if (this.chkOrder.Checked && string.IsNullOrEmpty(this.txtOrder.Text.Trim()))
            {
                MessageUtil.ShowWarning("请输入合同号！");
                return false;
            }
            return true;
        }

        private void txt_PlinCode_TextChanged(object sender, EventArgs e)
        {
            plineCode = txt_PlinCode.SelectedItem.DataValue.ToString();
            if (plineCode.Equals("C018"))//720
            {
                stationCode = "650101";
                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup7"].Hidden = true;//测量点
                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup12"].Hidden = true;//热扩表检
                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup11"].Hidden = true;//镦粗表检
                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup13"].Hidden = true;//冷拔冷轧表检 

                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup6"].Hidden = false;//旋扩
                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup8"].Hidden = false;//均整
                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup9"].Hidden = false;//定径
                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup10"].Hidden = false;//旋扩表检 
            }
            else if (plineCode.Equals("C021"))//镦粗 
            {
                stationCode = "650401";
                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup6"].Hidden = true;//旋扩
                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup8"].Hidden = true;//均整
                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup9"].Hidden = true;//定径
                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup10"].Hidden = true;//旋扩表检
                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup12"].Hidden = true;//热扩表检
                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup13"].Hidden = true;//冷拔冷轧表检

                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup7"].Hidden = false;//测量点
                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup11"].Hidden = false;//镦粗表检
            }
            else if (plineCode.Equals("C014"))//冷拔机组 
            {
                stationCode = "650501";
                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup6"].Hidden = true;//旋扩
                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup8"].Hidden = true;//均整
                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup9"].Hidden = true;//定径
                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup10"].Hidden = true;//旋扩表检
                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup12"].Hidden = true;//热扩表检
                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup11"].Hidden = true;//镦粗表检

                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup7"].Hidden = false;//测量点
                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup13"].Hidden = false;//冷拔冷轧表检
            }
            else if (plineCode.Equals("C013"))//冷轧机组
            {
                stationCode = "650601";
                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup6"].Hidden = true;//旋扩
                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup8"].Hidden = true;//均整
                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup9"].Hidden = true;//定径
                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup10"].Hidden = true;//旋扩表检
                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup12"].Hidden = true;//热扩表检
                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup11"].Hidden = true;//镦粗表检

                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup7"].Hidden = false;//测量点
                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup13"].Hidden = false;//冷拔冷轧表检
            }
            else if (plineCode.Equals("C070"))//热扩
            {
                stationCode = "650701";
                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup6"].Hidden = true;//旋扩
                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup8"].Hidden = true;//均整
                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup9"].Hidden = true;//定径
                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup10"].Hidden = true;//旋扩表检
                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup11"].Hidden = true;//镦粗表检
                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup13"].Hidden = true;//冷拔冷轧表检

                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup7"].Hidden = false;//测量点
                ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup12"].Hidden = false;//热扩
            }
        }
    }
}