XinYu_LG2MES/ClientSolution/Core.LgMes.Client.lgIntegrationQuery/frmZYInfo.cs

using System;
using System.Collections.Generic;
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;

namespace Core.LgMes.Client.LgIntegrationQuery
{
    public partial class frmZYInfo : Core.Mes.Client.Common.frmStyleBase
    {
        public frmZYInfo()
        {
            InitializeComponent();
        }

        private void frmZYInfo_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.cmbxShiftQuery.Enabled = false;
            this.comboBox1.SelectedIndex = -1;
            this.comboBox1.Enabled = false;
            this.comboBox2.Enabled = false;
            uldtBeginTime.Enabled = true ;
            uldtEndTime.Enabled = true;

            QueryData();
        }
        private void ckbTime_CheckedChanged(object sender, EventArgs e)
        {
            uldtBeginTime.Enabled = chkTime.Checked;
            uldtEndTime.Enabled = chkTime.Checked;
        }
        private void chkShift_CheckedChanged(object sender, EventArgs e)
        {
            cmbxShiftQuery.Enabled = chkShift.Checked;
            //if (chkShift.Checked == true)
            //{
            //    string ShiftCode = "", str = "";
            //    ShiftCode = ((string)ClientCommon._RemotingHelp.ExecuteMethod("lgIntegrationQuery",
            //                                         "Core.LgMes.Server.lgIntegrationQuery.SchedulingShift", "BanCiBanBie", null, out str)).Trim().ToString();
            //    if (!string.IsNullOrEmpty(ShiftCode))
            //    {
            //        cmbxShiftQuery.SelectedIndex = Convert.ToInt16(ShiftCode.Substring(1, 1)) - 1;
            //    }
            //}
            //else
            //{
            //    cmbxShiftQuery.Text = "";
            //}
        }

        private void checkBox1_CheckedChanged(object sender, EventArgs e)
        {
            comboBox1.Enabled = checkBox1.Checked;
            comboBox2.Enabled = checkBox1.Checked;
        }
        private void ultbrMain_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
        {
            switch (e.Tool.Key)
            {
                case "Select":
                    QueryData();
                    break;
                case "OutExcel":
                    if (ultraGrid.Rows.Count > 0)
                    {
                        ExportExcel();
                    }
                    else
                        MessageBox.Show("没有渣样信息。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    break;
                case "Close":
                    this.Close();
                    break;
                default:
                    break;
            }
        }

        private string proc_GetStationCode()
        {
            if (checkBox1.Checked && comboBox1.SelectedIndex > -1 && comboBox2.SelectedIndex > -1)
            {
                string str = "";
                switch (comboBox1.SelectedIndex)
                {
                    case 0:
                        {
                            switch (comboBox2.SelectedIndex)
                            {
                                case 0:
                                    {
                                        str = "substr(STATIONCODE,1,1) = 'C'";
                                        break;
                                    }
                                case 1:
                                    {
                                        str = "STATIONCODE = 'C01'";
                                        break;
                                    }
                                case 2:
                                    {
                                        str = "STATIONCODE = 'C02'";
                                        break;
                                    }
                                case 3:
                                    {
                                        str = "STATIONCODE = 'C03'";
                                        break;
                                    }
                            }
                            break;
                        }
                    case 1:
                        {
                            switch (comboBox2.SelectedIndex)
                            {
                                case 0:
                                    {
                                        str = "substr(STATIONCODE,1,1) = 'E'";
                                        break;
                                    }
                                case 1:
                                    {
                                        str = "STATIONCODE = 'E01'";
                                        break;
                                    }
                                case 2:
                                    {
                                        str = "STATIONCODE = 'E02'";
                                        break;
                                    }
                            }
                            break;
                        }
                }

                return str;
            }

            return "";
        }

        /// <summary>
        /// 获取渣样信息
        /// </summary>
        private void QueryData()
        {
            string strWhere = "";
            if (chkTime.Checked == true)
            {
                if (Convert.ToDateTime(uldtBeginTime.Value) > Convert.ToDateTime(uldtEndTime.Value))
                {
                    MessageBox.Show("时间条件的开始时间不能大于结束时间！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    return;
                }
                else
                    strWhere = " and ASSAYDATE >=to_date('" + uldtBeginTime.Value.ToString() +
                                           "','yyyy-MM-dd HH24:mi:ss') and ASSAYDATE <=to_date('" +
                                           uldtEndTime.Value.ToString() + "','yyyy-MM-dd HH24:mi:ss') ";
            }
            if (chkShift.Checked == true && cmbxShiftQuery.SelectedIndex != 4)
            {
                strWhere += " and SUBSTR(SHIFTCODE,1,1) - 1 = '" + cmbxShiftQuery.SelectedIndex + "'";
            }
            string strStation = proc_GetStationCode();
            if (strStation.Length > 0)
            {
                strWhere += " and " + strStation + " ";
            }
            DataSet ds = null;//hengxing (DataSet)ClientCommon._RemotingHelp.ExecuteMethod("lgIntegrationQuery",
                                          //            "Core.LgMes.Server.lgIntegrationQuery.SchedulingShift",
                                          //            "QueryKingData", new object[] { strWhere }, out strErr);
            dataSet.Clear();                        //清空原有行
            if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
            {
                foreach (DataRow Dr in ds.Tables[0].Rows)
                {
                    DataRow dr1 = dataSet.Tables[0].NewRow();
                    dr1["HeatNO"] = Dr["HeatNO"].ToString();
                    dr1["SteelName"] = Dr["SteelName"].ToString();
                    dr1["CaO"] = Dr["CaO"].ToString();
                    dr1["SiO2"] = Dr["SiO2"].ToString();
                    dr1["Al2O3"] = Dr["Al2O3"].ToString();
                    dr1["TFe"] = Dr["TFe"].ToString();
                    dr1["MnO"] = Dr["MnO"].ToString();
                    dr1["S"] = Dr["S"].ToString();
                    dr1["MgO"] = Dr["MgO"].ToString();
                    dr1["P2O5"] = Dr["P2O5"].ToString();
                    dr1["JD"] = Dr["JD"].ToString();
                    dr1["ASSAYDATE"] = Dr["ASSAYDATE"].ToString();
                    dr1["FEO"] = Dr["FEO"].ToString();
                    dataSet.Tables[0].Rows.Add(dr1);
                }
            }
        }
        /// <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);
            }
        }


        private object[] GetComboBox2Items(int index)
        {
            switch (index)
            {
                case 0:
                    return new object[] { "所有", "1#转炉", "2#转炉", "3#转炉" };
                case 1:
                    return new object[] { "所有", "1#精炼炉", "2#精炼炉" };
                default:
                    return new object[] { };
            }
        }

        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            this.comboBox2.Items.Clear();
            this.comboBox2.Items.AddRange(GetComboBox2Items(comboBox1.SelectedIndex));
            this.comboBox2.SelectedIndex = 0;
        }
    }
}