MES_Client/TGMES/Core.StlMes.Client.LgIntegrationQuery/frmPerformanceLog.cs

using System;
using System.Collections;
using System.ComponentModel;
using System.IO;
using System.Diagnostics;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using CoreFS.CA06;
using Infragistics.Win.UltraWinMaskedEdit;
using Infragistics.Win.UltraWinGrid;
using Infragistics.Win;
using Core.StlMes.Client.LgCommon;
using Core.Mes.Client.Comm.Control;

namespace Core.StlMes.Client.LgIntegrationQuery
{
    public partial class frmPerformanceLog : frmStyleBase
    {
        public string _devNum = "";
        public string workShopNo = "";
        public frmPerformanceLog()
        {
            InitializeComponent();
        }


        private void frmPerformanceLog_Load(object sender, EventArgs e)
        {
            workShopNo = this.CustomInfo;
            this.uldtBeginTime.Value = DateTime.Today.ToString("yyyy-MM-dd") + " 00:00";
            this.uldtEndTime.Value = DateTime.Today.ToString("yyyy-MM-dd") + " 23:59";
            this.ultraMaskedEdit2.Enabled = false;
            this.cmbPosition.Enabled = false;
            initPos();
            cmbPosition.SelectedIndex = 0;
            QueryData();
        }

        // 初始化岗位
        /// <summary>
        /// 初始化岗位
        /// </summary>
        public void initPos()
        {
            cmbPosition.Items.Clear();
            cmbPosition.Items.Add("B01", "1#脱硫站");
            cmbPosition.Items.Add("C01", "1#转炉");
            cmbPosition.Items.Add("C02", "2#转炉");
            cmbPosition.Items.Add("C03", "3#转炉");
            cmbPosition.Items.Add("C04", "4#转炉");
            cmbPosition.Items.Add("C05", "5#转炉");
            cmbPosition.Items.Add("D01", "1#吹氩站");
            cmbPosition.Items.Add("D02", "2#吹氩站");
            cmbPosition.Items.Add("D03", "3#吹氩站");
            cmbPosition.Items.Add("D04", "4#吹氩站");
            cmbPosition.Items.Add("D05", "5#吹氩站");
            cmbPosition.Items.Add("E01", "1#精炼炉");
            cmbPosition.Items.Add("E02", "2#精炼炉");
            cmbPosition.Items.Add("E03", "3#精炼炉");
            cmbPosition.Items.Add("G01", "1#连铸机");
            cmbPosition.Items.Add("G02", "2#连铸机");
            cmbPosition.Items.Add("G03", "3#连铸机");
            cmbPosition.Items.Add("G04", "4#连铸机");
            cmbPosition.Items.Add("G05", "5#连铸机");
            //if (workShopNo == "1")
            //{
            //    cmbPosition.Items.Add("A01", "1#脱硫站");
            //    cmbPosition.Items.Add("B01", "1#转炉");
            //    cmbPosition.Items.Add("B02", "2#转炉");
            //    cmbPosition.Items.Add("E01", "1#吹氩站");
            //    cmbPosition.Items.Add("E02", "2#吹氩站");
            //    cmbPosition.Items.Add("F01", "1#精炼炉");
            //    cmbPosition.Items.Add("G01", "1#连铸机");
            //    cmbPosition.Items.Add("G02", "2#连铸机");
            //}
            //else
            //{
            //    cmbPosition.Items.Add("B03", "3#转炉");
            //    cmbPosition.Items.Add("B04", "4#转炉");
            //    cmbPosition.Items.Add("B05", "5#转炉");
            //    cmbPosition.Items.Add("E03", "3#吹氩站");
            //    cmbPosition.Items.Add("E04", "4#吹氩站");
            //    cmbPosition.Items.Add("E05", "5#吹氩站");
            //    cmbPosition.Items.Add("F02", "2#精炼炉");
            //    cmbPosition.Items.Add("F03", "3#精炼炉");
            //    cmbPosition.Items.Add("G03", "3#连铸机");
            //    cmbPosition.Items.Add("G04", "4#连铸机");
            //    cmbPosition.Items.Add("G05", "5#连铸机");
            //}
        }

        // 根据编码获得岗位信息
        /// <summary>
        /// 根据编码获得岗位信息
        /// </summary>
        /// <returns></returns>
        public Hashtable getPos()
        {
            Hashtable pos_table = new Hashtable();
            pos_table.Clear();
            pos_table.Add("B01", "1#脱硫站");
            pos_table.Add("B02", "2#脱硫站");
            pos_table.Add("C01", "1#转炉");
            pos_table.Add("C02", "2#转炉");
            pos_table.Add("C03", "3#转炉");
            pos_table.Add("C04", "4#转炉");
            pos_table.Add("C05", "5#转炉");
            pos_table.Add("D01", "1#吹氩站");
            pos_table.Add("D02", "2#吹氩站");
            pos_table.Add("D03", "3#吹氩站");
            pos_table.Add("D04", "4#吹氩站");
            pos_table.Add("D05", "5#吹氩站");
            pos_table.Add("E01", "1#精炼炉");
            pos_table.Add("E02", "2#精炼炉");
            pos_table.Add("E03", "3#精炼炉");
            pos_table.Add("G01", "1#连铸机");
            pos_table.Add("G02", "2#连铸机");
            pos_table.Add("G03", "3#连铸机");
            pos_table.Add("G04", "4#连铸机");
            pos_table.Add("G05", "5#连铸机");
            return pos_table;
        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    QueryData();
                    break;
                case "Export":
                    try
                    {
                        //Core.Mes.Client.Common.Globals.ulGridToExcel(ultraGrid, Text);
                        GridHelper.ulGridToExcel(ultraGrid, Text);

                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message);
                    }
                    break;
                case "Exit":
                    this.Close();
                    break;
                default:
                    break;
            }
            
        }

        // 获取实绩修改信息 
        /// <summary>
        /// 获取实绩修改信息   
        /// </summary>
        private void QueryData()
        {
            try
            {
                string strStartTime = "";
                string strEndTime = "";
                string strHeatno = "";
                string strStacode = "";
                string strErr = "";

       
                if (Convert.ToDateTime(uldtBeginTime.Value) > Convert.ToDateTime(uldtEndTime.Value))
                {
                    MessageBox.Show("时间条件的开始时间不能大于结束时间！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    return;
                }
                else
                {
                    strStartTime = this.uldtBeginTime.DateTime.ToString("yyyyMMddHHmmss");
                    strEndTime = this.uldtEndTime.DateTime.ToString("yyyyMMddHHmmss");
                }
                
                if (chkSmeltId.Checked == true)
                {
                    if (this.ultraMaskedEdit2.Text == "")
                    {
                        ultraMaskedEdit2.Focus();
                        MessageBox.Show("熔炼号不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                        return;
                    }
                    else
                    {
                        if (!string.IsNullOrEmpty(ultraMaskedEdit2.Text))
                            strHeatno = ultraMaskedEdit2.Text.ToString();
                    }
                }
                if (chkPosition.Checked)
                {
                    if (this.cmbPosition.SelectedIndex<0)
                    {
                        cmbPosition.Focus();
                        MessageBox.Show("岗位不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                        return;
                    }
                    strStacode = cmbPosition.Value.ToString();
                }


                //获取实绩修改日志信息
                string NowTime = DateTime.Now.ToString("yyyy-MM-dd");
                ArrayList arry = new ArrayList();
                arry.Add("frmPerformanceLog.select");
                arry.Add(strHeatno);
                arry.Add(strStacode);
                arry.Add(strStartTime == "" ? NowTime : strStartTime);
                arry.Add(strEndTime == "" ? NowTime : strEndTime);

                CommonClientToServer cctos = new CommonClientToServer();
                cctos.ob = this.ob;
                DataSet ds = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery",
                                            "doSimpleQuery", arry, out strErr);


                dataSet.Clear();                      //清空原有行
                Hashtable p_table = getPos();
                if (strErr == "" && ds != null)
                {
                    foreach (DataRow Dr in ds.Tables[0].Rows)
                    {
                        DataRow dr1 = dataSet.Tables[0].NewRow();
                        dr1["HEATNO"] = Dr["HEATNO"].ToString();
                        dr1["DISPOSALTIME"] = Dr["DISPOSALTIME"].ToString();
                        //dr1["DESCRIPTION"] = Dr["DESCRIPTION"].ToString();
                        dr1["MODIFYNAME"] = Dr["MODIFYNAME"].ToString();
                        dr1["MODIFYDATE"] = Dr["MODIFYDATE"].ToString();
                        dr1["ID"] = Dr["ID"].ToString();
                        dr1["MODIFYCOLUMNCAPTION"] = Dr["MODIFYCOLUMNCAPTION"].ToString();
                        dr1["MODIFYBEFORE"] = Dr["MODIFYBEFORE"].ToString();
                        dr1["MODIFYAFTER"] = Dr["MODIFYAFTER"].ToString();
                        dr1["MODIFYCOLUMNNAME"] = Dr["MODIFYCOLUMNNAME"].ToString();
                        if (p_table.Contains(Dr["STATIONCODE"].ToString()))
                        {
                            dr1["STATIONCODE"] = p_table[Dr["STATIONCODE"].ToString()].ToString();
                        }
                        else
                        {
                            dr1["STATIONCODE"] = Dr["STATIONCODE"].ToString();
                        }
                        dataSet.Tables[0].Rows.Add(dr1);
                    }
                }
                PublicMethod.RefreshAndAutoSize(ultraGrid);
            }
            catch (Exception e)
            {
                MessageBox.Show(e.Message);
            }
        }

        private void ultraMaskedEdit1_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
        {
            Infragistics.Win.UltraWinEditors.UltraTextEditor ume = (Infragistics.Win.UltraWinEditors.UltraTextEditor)sender;
            switch (e.Button.Key)
            {
                case "edit":
                    frmNumberWriter frm = new frmNumberWriter();
                    frm._strText = ume.Text.Trim();
                    frm.Location = GetChildWindowLocation(frm.Size);
                    frm.ShowDialog();
                    ume.Text = frm._strText;
                    ultraMaskedEdit2.SelectionStart = ultraMaskedEdit2.Text.ToString().Length;
                    break;
                case "clear":
                    if (ume.Text.Trim().Length > 0)
                    {
                        ume.Tag = ume.Text.Trim();
                        ume.Text = "";
                    }
                    else
                    {
                        if (ume.Tag != null)
                            ume.Text = ume.Tag.ToString();
                    }
                    break;
            }
        }
        
        // 获取子窗体弹出的位置坐标
        /// <summary>
        /// 获取子窗体弹出的位置坐标
        /// </summary>
        private Point GetChildWindowLocation(Size ChildWindowSize)
        {
            int width = Cursor.Position.X + ChildWindowSize.Width - Screen.PrimaryScreen.Bounds.Width;
            int height = Cursor.Position.Y + ChildWindowSize.Height - Screen.PrimaryScreen.Bounds.Height + 30;

            if (width > 0)
                width = Cursor.Position.X - width;
            else
                width = Cursor.Position.X;
            if (height > 0)
                height = Cursor.Position.Y - height + 10;
            else
                height = Cursor.Position.Y + 10;

            return new Point(width, height);
        }
        

        private void cmbPosition_ValueChanged(object sender, EventArgs e)
        {
            switch (this.cmbPosition.SelectedIndex)             //edit on 2009-04-23
            {
                case 0:
                    _devNum = "X00"; //调度岗位
                    break;
                case 1:
                    _devNum = "B01";
                    break;
                case 2:
                    _devNum = "B02";
                    break;
                case 3:
                    _devNum = "C01";
                    break;
                case 4:
                    _devNum = "C02";
                    break;
                case 5:
                    _devNum = "D01";
                    break;
                case 6:
                    _devNum = "D02";
                    break;
                case 7:
                    _devNum = "E01";
                    break;
                case 8:
                    _devNum = "E02";
                    break;
                case 9:
                    _devNum = "F01";
                    break;
                case 10:
                    _devNum = "I01";
                    break;
                case 11:
                    _devNum = "G01";
                    break;
                case 12:
                    _devNum = "G02";
                    break;
                case 13:
                    _devNum = "G03";
                    break;
                default:
                    break;
            }

            QueryData();
        }

        private void chkSmeltId_CheckedChanged(object sender, EventArgs e)
        {
            ultraMaskedEdit2.Enabled = chkSmeltId.Checked;
            if (ultraMaskedEdit2.Enabled == false)
            {
                ultraMaskedEdit2.BackColor = Color.WhiteSmoke;
            }

        }
        private void chkPosition_CheckedChanged(object sender, EventArgs e)
        {
            cmbPosition.Enabled = chkPosition.Checked;
        }

        private void ultraMaskedEdit1_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (!(Char.IsNumber(e.KeyChar) || e.KeyChar == '\b'))
            {
                e.Handled = true;
            }
        }
    }
}