XinYu_LG2MES/ClientSolution/Core.LgMes.Client.LgJobMgt/混铁炉作业/frmRequryInIron.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 frmRequryInIron : Core.Mes.Client.Common.frmStyleBase
    {
        public frmRequryInIron()
        {
            InitializeComponent();

        }
        private void frmRequryInIron_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();
           // cbbMis.SelectedIndex = nMixNo - 1;
        }

        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.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 = "SelectHtInIronhistoryData";
                //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(),
                                                        });
                    }
                    if (ultraDataSource1.Rows.Count > 0)
                        SetIronSum();
                }

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

        }

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

        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.Length>1)
            {
                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 ultraButton1_Click(object sender, EventArgs e)
        {
            try
            {
                if (ultraGrid1.Rows.Count > 0)
                {
                    string StrfileName = string.Format(System.Windows.Forms.Application.StartupPath + "\\{0}.xls", "铁运进铁记录");
                    this.ultraGridExcelExporter1.Export(this.ultraGrid1, StrfileName);
                    ProcessStartInfo p = new ProcessStartInfo(StrfileName);
                    p.WorkingDirectory = Path.GetDirectoryName(StrfileName);
                    Process.Start(p);
                }
                else
                {
                    MessageBox.Show("没有数据可导出！");
                    return;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        /// <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 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)
                        {
                            string StrfileName = string.Format(System.Windows.Forms.Application.StartupPath + "\\{0}.xls", "混铁炉进铁记录");
                            this.ultraGridExcelExporter1.Export(this.ultraGrid1, StrfileName);
                            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;
            }
        }
    }
}