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

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

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

        private void frmIronElementsInfo_Load(object sender, EventArgs e)
        {
            this.dateTimePicker1.Text = System.DateTime.Now.AddHours(-8).ToString("yyyy-MM-dd HH:mm") ;
            this.dateTimePicker2.Text = System.DateTime.Now.AddHours(1).ToString("yyyy-MM-dd HH:mm");
            this.cbbMis.SelectedIndex = 2;
            RefreshGridIronIn();
        }

        private string BuildSqlString()
        {
            string strBegTime = Convert.ToDateTime(this.dateTimePicker1.Value).ToString("yyyy-MM-dd HH:mm");
            string strEndTime = Convert.ToDateTime(this.dateTimePicker2.Value).ToString("yyyy-MM-dd HH:mm");
            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 to_char(TAPHOLESTARTTIME,'yyyy-MM-dd HH24:mi')>= '{0}' and " + 
                                         " to_char(TAPHOLESTARTTIME,'yyyy-MM-dd HH24:mi')<='{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}' ", (this.cbogroup.SelectedIndex + 1));
                else
                    strWhere = string.Format(" where substr(SHIFTCODE, length(SHIFTCODE),1) = '{0}' ", (this.cbogroup.SelectedIndex + 1));
            }
            else
            {
                　//strWhere += string.Format(" order by MISID desc");
            }

            return strWhere;
        }


        private void RefreshGridIronIn()
        {
            string htWhere = BuildSqlString();
            string strWsID = "";
            if (this.cbbMis.Value.ToString() == "1")
                strWsID =" and WsID ='H1'";
            else if (this.cbbMis.Value.ToString() == "2")
                strWsID = " and WsID ='Z1'";

            try
            {
                //hengxing
                //CallingMessage par = new CallingMessage();
                //par.ServerName = "lgIntegrationQuery";
                //par.AssemblyName = "Core.LgMes.Server.LgIntegrationQuery";
                //par.ClassName = "Core.LgMes.Server.lgIntegrationQuery.LgGeneralInfo";
                //par.MethodName = "GetIronElementsInfo";
                //par.args = new object[] { htWhere, strWsID };

                DataSet ds = null;//hengxing (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["MOLIRNLEAVE"].ToString(),
                                                        dr["IRONWRAPID"].ToString(),
                                                        dr["IRONPOTGROSSWGT"].ToString(),
                                                        dr["IRONPOTWGT"].ToString(),
                                                        dr["IRONPOTTAREWGT"].ToString(),
                                                        dr["IRONTEMPERATURE"].ToString(),
                                                        dr["TAPHOLESTARTTIME"].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(),
                                                        dr["IRONWRAPAGE"].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 != "")
            {
                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 = 3; i < 5; 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;
            }
        }
    }
}