XinYu_LG2MES/ClientSolution/Core.LgMes.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.Mes.Client.Common;

namespace Core.LgMes.Client.LgIntegrationQuery
{
    public partial class frmPerformanceLog : Core.Mes.Client.Common.frmStyleBase
    {

        public frmPerformanceLog()
        {
            InitializeComponent();
        }
        public string _devNum = "";

        private void frmPerformanceLog_Load(object sender, EventArgs e)
        {
            this.uldtBeginTime.Value = DateTime.Today.ToString("yyyy-MM-dd") + " 00:00";
            this.uldtEndTime.Value = DateTime.Today.ToString("yyyy-MM-dd") + " 23:59";
            this.ultraMaskedEdit1.Enabled = false;
            this.cmbPosition.Enabled = false;
            chkTime.Checked = true;
            //初始化UltraDropDown控件
            //InitUltraDropDown();
            cmbPosition.SelectedIndex = 0;
            QueryData();
        }
        private void ckbTime_CheckedChanged(object sender, EventArgs e)
        {
            uldtBeginTime.Enabled = chkTime.Checked;
            uldtEndTime.Enabled = chkTime.Checked;
        }
        private void chkSmeltId_CheckedChanged(object sender, EventArgs e)
        {
            ultraMaskedEdit1.Enabled = chkSmeltId.Checked;
        
        }
        private void chkPosition_CheckedChanged(object sender, EventArgs e)
        {  
               cmbPosition.Enabled = chkPosition.Checked;
        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    QueryData();
                    break;
                case "Export":
                    if (ultraGrid.Rows.Count > 0)
                    {
                        ExportExcel();
                    }
                    else
                        MessageBox.Show("没有实绩修改信息。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    break;
                case "Exit":
                    this.Close();
                    break;
                default:
                    break;
            }
            
        }
       
        /// <summary>
        /// 获取渣样信息   
        /// </summary>
        private void QueryData()
        {
            if (uldtEndTime.DateTime.Date.Subtract(uldtBeginTime.DateTime.Date).Days > 180)
            {
                MessageBox.Show("查询时间不可超过6个月。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }
            if (uldtBeginTime.DateTime > uldtEndTime.DateTime)
            {
                MessageBox.Show("查询起始时间不能大于结束时间！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }
            string strStartTime = "";
            string strEndTime = "";
            string strHeatno = "";
            string strStacode = "";
            string strErr = "";

            if (chkTime.Checked == true)
            {
                if (Convert.ToDateTime(uldtBeginTime.Value) > Convert.ToDateTime(uldtEndTime.Value))
                {
                    MessageBox.Show("时间条件的开始时间不能大于结束时间！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    return;
                }
                else
                {

                    strStartTime = this.uldtBeginTime.DateTime.ToString("yyyy-MM-dd");
                    strEndTime = this.uldtEndTime.DateTime.ToString("yyyy-MM-dd");
                }
            }
            if (chkSmeltId.Checked == true)  
            {
                if (this.ultraMaskedEdit1.Text == "")
                {
                    MessageBox.Show("熔炼号不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    return;
                }
                else
                {
                    if (!string.IsNullOrEmpty(ultraMaskedEdit1.Text))
                        strHeatno = ultraMaskedEdit1.Text.ToString();
                }
            }
            //if (chkPosition.Checked == true)
            //{
            //    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(_devNum);
            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();                      //清空原有行

            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();
                    dataSet.Tables[0].Rows.Add(dr1);
                }
            }
        }
        private void ultraMaskedEdit1_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
        {
            UltraMaskedEdit ume = (UltraMaskedEdit)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;
                    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;
            }
        }
        //==========================================================
        // 获取子窗体弹出的位置坐标
        //==========================================================
        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);
        }
        /// <summary>
        /// 导出Excel
        /// </summary>
        private void ExportExcel()
        {
            try
            {
                string StrfileName = System.Windows.Forms.Application.StartupPath + "\\Report\\实绩修改日志.xls";
                this.ultraGridExcelExporter1.Export(this.ultraGrid, StrfileName);
                ProcessStartInfo p = new ProcessStartInfo(StrfileName);
                p.WindowStyle = System.Diagnostics.ProcessWindowStyle.Maximized;
                p.WorkingDirectory = Path.GetDirectoryName(StrfileName);
                Process.Start(p);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

        }
        /// <summary>
        /// 初始化UltraDropDown控件(岗位)
        /// </summary>
        private void InitUltraDropDown()
        {
            string strErr = "";

            ArrayList arry = new ArrayList();
            arry.Add("FrmYCJJB_Process.select");

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

            if (strErr == "" && ds != null)
            {
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    cmbPosition.Items.Add(i);
                    cmbPosition.Items[i].DisplayText = ds.Tables[0].Rows[i]["DESCRIPTION"].ToString();
                    cmbPosition.Items[i].DataValue = ds.Tables[0].Rows[i]["NAME_"].ToString();
                }
            }
        }

        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();
        }
    }
}