XinYu_LG2MES/ClientSolution/Core.LgMes.Client.LgJobMgt/01混铁炉作业/frmRequryhtInIron.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using Core.LgMes.Client.LgResMgt;
using System.Threading;
using Core.LgMes.Client.lgClassModel;
using System.Collections;
using System.Reflection;
using CoreFS.CA06;
using System.Diagnostics;
using System.IO;
using Infragistics.Win.UltraWinGrid;

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

        private void frmRequryhtInIron_Load(object sender, EventArgs e)
        {
            this.dateTimePicker1.Text = System.DateTime.Today.ToString("yyyy-MM-dd") + " 00:00";
            this.dateTimePicker2.Text = System.DateTime.Today.ToString("yyyy-MM-dd") + " 23:59";
            RefreshGridIronIn();
        }

        private string BuildSqlString()
        {
            string strBegTime =Convert.ToDateTime(this.dateTimePicker1.Value).ToString("yyyy-MM-dd");
            string strEndTime = Convert.ToDateTime(this.dateTimePicker2.Value).ToString("yyyy-MM-dd");
            string strWhere = "";

            if (this.rdocheck.Checked)
            {

                if (Convert.ToDateTime(this.dateTimePicker1.Value) > Convert.ToDateTime(this.dateTimePicker2.Value))
                {
                    MessageBox.Show("开始时间不能大于结束时间！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    return "";
                }

                strWhere = string.Format(" where ARRIVETIME between " +
                    "to_date('{0}', 'yyyy-MM-dd') and " +
                    "to_date('{1}', 'yyyy-MM-dd')+1 ",
                    strBegTime, strEndTime);
            }

            if (this.cbbMis.SelectedIndex == 0 )
            {
                if (strWhere.IndexOf("where", 0) >= 0)
                    strWhere += string.Format(" and WSID = '{0}' ", this.cbbMis.SelectedIndex + 1);
                else
                    strWhere = string.Format(" where WSID = '{0}' ", this.cbbMis.SelectedIndex + 1);
            }

            if (this.cbogroup.SelectedIndex != 4 && this.cbogroup.SelectedIndex != -1)
            {
                if (strWhere.IndexOf("where", 0) >= 0)
                    strWhere += string.Format(" and substr(SHIFTCODE, length(SHIFTCODE),1) = '{0}' order by MISID desc", (this.cbogroup.SelectedIndex + 1));
                else
                    strWhere = string.Format(" where substr(SHIFTCODE, length(SHIFTCODE),1) = '{0}' order by MISID desc", (this.cbogroup.SelectedIndex + 1));
            }
            else
            {
                strWhere += string.Format(" order by MISID desc");
            }

            return strWhere;
        }


        private void RefreshGridIronIn()
        {
            string err = "";
            string htWhere = BuildSqlString();
            try
            {
                //hengxing
                //CallingMessage par = new CallingMessage();
                //par.ServerName = "lgJobMgt";
                //par.AssemblyName = "Core.LgMes.Server.lgJobMgt";
                //par.ClassName = "Core.LgMes.Server.lgJobMgt.classIronJob";
                //par.MethodName = "SelectHtMidInIronhistoryData";
                //par.args = new object[] { htWhere };

                DataSet ds = null;// (DataSet)ClientCommon._RemotingHelp.ExecuteMethod(par, out err);


                ultraDataSource1.Rows.Clear();
                if (ds.Tables.Count > 0)
                {
                    foreach (DataRow dr in ds.Tables[0].Rows)
                    {
                        ultraDataSource1.Rows.Add(new object[] {
                                                        dr["MISID"].ToString(),
                                                        dr["MOLIRNSOURCE"].ToString(),
                                                        dr["STOVEID"].ToString(),
                                                        dr["TFPOTID"].ToString(),
                                                        dr["TFPOTGROSSWGT"].ToString(),
                                                        dr["TFPOTTAREWGT"].ToString(),
                                                        dr["TFPOTWGT"].ToString(),
                                                        dr["IRONTEMPERATURE"].ToString(),
                                                        dr["ARRIVETIME"].ToString(),
                                                        dr["C"].ToString(),
                                                        dr["SI"].ToString(),                                                   
                                                        dr["MN"].ToString(),
                                                        dr["P"].ToString(),
                                                        dr["S"].ToString(),
                                                        dr["ASN"].ToString(),
                                                        ConvertShift("1",dr["SHIFTCODE"].ToString())+ ConvertShift("2",dr["SHIFTCODE"].ToString()),
                                                        dr["OPTPERSONNEL"].ToString(),
                                                        });
                    }
                    SetIronSum();
                }

            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }

        }

        private string ConvertShift(string flag, string shift)
        {
            string StrReturn = "";
            if (flag == "1" & shift != "")
            {
                switch (shift.Substring(0, 1))
                {
                    case "1":
                        StrReturn = "白";
                        break;
                    case "2":
                        StrReturn = "中";
                        break;
                    case "3":
                        StrReturn = "夜";
                        break;

                }



            }
            else if (flag == "2" & shift != "")
            {
                switch (shift.Substring(1, 1))
                {
                    case "1":
                        StrReturn = "甲";
                        break;
                    case "2":
                        StrReturn = "乙";
                        break;
                    case "3":
                        StrReturn = "丙";
                        break;
                    case "4":
                        StrReturn = "丁";
                        break;
                }

            }
            else if (flag == "3" & shift != "")
            {
                switch (shift.Trim())
                {
                    case "白":
                        StrReturn = "1";
                        break;
                    case "中":
                        StrReturn = "2";
                        break;
                    case "夜":
                        StrReturn = "3";
                        break;
                }

            }
            else if (flag == "4" & shift != "")
            {
                switch (shift.Trim())
                {
                    case "甲":
                        StrReturn = "1";
                        break;
                    case "乙":
                        StrReturn = "2";
                        break;
                    case "丙":
                        StrReturn = "3";
                        break;
                    case "丁":
                        StrReturn = "4";
                        break;
                }

            }

            return StrReturn;
        }

        private void ulbtnRef_Click(object sender, EventArgs e)
        {
           
        }

        private void ultraButton1_Click(object sender, EventArgs e)
        {
            
        }

        /// <summary>
        /// 统计铁水重量
        /// </summary>
        private void SetIronSum()
        {
            UltraGridBand band = this.ultraGrid1.DisplayLayout.Bands[0];
                        
            band.Summaries.Clear();

            SummarySettings summary = band.Summaries.Add(SummaryType.Count, band.Columns[1]);
            summary.SummaryPosition = SummaryPosition.UseSummaryPositionColumn;
            summary.DisplayFormat = "合计：";

            for (int i = 5; i < 7; i++)
            {
                summary = band.Summaries.Add(SummaryType.Sum, band.Columns[i]);

                summary.SummaryPosition = SummaryPosition.UseSummaryPositionColumn;

                summary.DisplayFormat = " {0:#####.00}";

                summary.Appearance.TextHAlign = Infragistics.Win.HAlign.Center;
                summary.Appearance.ForeColor = Color.DarkBlue;
                summary.Appearance.BackColor = Color.White;
            }


            band.Override.SummaryFooterCaptionVisible = Infragistics.Win.DefaultableBoolean.False;
        }

        private void panel1_Fill_Panel_Paint(object sender, PaintEventArgs e)
        {

        }

        private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
        {
            switch (e.Tool.Key)
            {
                case "Query":
                    RefreshGridIronIn();
                    break;
                case "Output":
                    try
                    {
                        if (ultraGrid1.Rows.Count > 0)
                        {
                           Infragistics.Win.UltraWinGrid.ExcelExport.UltraGridExcelExporter ulGridExt = new Infragistics.Win.UltraWinGrid.ExcelExport.UltraGridExcelExporter();
                            
                           string StrfileName = string.Format(System.Windows.Forms.Application.StartupPath + "\\{0}.xls", "混铁炉进铁记录");
                           ulGridExt.Export(this.ultraGrid1, StrfileName);
                           Core.Mes.Client.Common.Globals.ulGridToExcel(ultraGrid1, "11");
                           ProcessStartInfo p = new ProcessStartInfo(StrfileName);
                           p.WorkingDirectory = Path.GetDirectoryName(StrfileName);
                           Process.Start(p);
                            
                        }
                        else
                        {
                            MessageBox.Show("没有数据可导出！");
                            return;
                        }
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message);
                    }
                    break;
                case "Close":
                    this.Close();
                    break;                    
                default:
                    break;
            }
        }
    }
}