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

using System;
using System.Data;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Threading;
using CoreFS.CA06;

using Infragistics.Win.UltraWinMaskedEdit;
using System.IO;
using System.Diagnostics;
using Core.Mes.Client.Common;
using Infragistics.Win.UltraWinGrid;

namespace Core.LgMes.Client.LgIntegrationQuery
{
    /// <summary>
    /// FrmIronEleQry 的摘要说明。
    /// </summary>
    public class FrmIronEleQry : Core.Mes.Client.Common.frmStyleBase
    {
        private Infragistics.Win.UltraWinMaskedEdit.UltraMaskedEdit ultraMaskedEdit1;
        private System.Windows.Forms.Label label2;
        private Infragistics.Win.UltraWinDataSource.UltraDataSource ultraDataSource1;
        private Infragistics.Win.UltraWinGrid.UltraGrid ultraGrid1;
        private Infragistics.Win.Misc.UltraGroupBox ultraGroupBox1;
        private Infragistics.Win.UltraWinEditors.UltraDateTimeEditor uldtEndTime;
        private Infragistics.Win.UltraWinGrid.ExcelExport.UltraGridExcelExporter ultraGridExcelExporter1;
        private CheckBox chkTime;
        private Infragistics.Win.UltraWinEditors.UltraDateTimeEditor uldtBeginTime;
        private Label label4;
        private IContainer components;

        string strStartTime = "";
        private CheckBox chkRefresh;
        string strEndTime = "";

        public FrmIronEleQry()
        {
            //
            // Windows 窗体设计器支持所必需的
            //
            InitializeComponent();

            //
            // TODO: 在 InitializeComponent 调用后添加任何构造函数代码
            //
        }

        /// <summary>
        /// 清理所有正在使用的资源。
        /// </summary>
        protected override void Dispose(bool disposing)
        {
            try
            {
                if (_getDataThread != null)
                    _getDataThread.Abort();
            }
            catch { }
            if (disposing)
            {
                if (components != null)
                {
                    components.Dispose();
                }
            }
            base.Dispose(disposing);
        }

        #region Windows 窗体设计器生成的代码
        /// <summary>
        /// 设计器支持所需的方法 - 不要使用代码编辑器修改
        /// 此方法的内容。
        /// </summary>
        private void InitializeComponent()
        {
            this.components = new System.ComponentModel.Container();
            Infragistics.Win.UltraWinEditors.EditorButton editorButton1 = new Infragistics.Win.UltraWinEditors.EditorButton("edit");
            Infragistics.Win.UltraWinEditors.EditorButton editorButton2 = new Infragistics.Win.UltraWinEditors.EditorButton("clear");
            Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn1 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("SMELTINGID");
            Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn2 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("SAMPLINGID");
            Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn3 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("SAMPLINGTIME");
            Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn4 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("seconds");
            Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn5 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("C");
            Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn6 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("SI");
            Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn7 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("MN");
            Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn8 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("P");
            Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn9 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("S");
            Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn10 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("Cu");
            Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn11 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("Asn");
            Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn12 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("Ti");
            Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn13 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("Cr");
            Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn14 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("Sn");
            Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn15 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("Ni");
            Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn16 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("V");
            Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn17 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("Nb");
            Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn18 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("VHEATNO");
            Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn19 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("AIM_GRADE_CODE");
            Infragistics.Win.UltraWinGrid.UltraGridBand ultraGridBand1 = new Infragistics.Win.UltraWinGrid.UltraGridBand("Band 0", -1);
            Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn1 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("SMELTINGID");
            Infragistics.Win.Appearance appearance83 = new Infragistics.Win.Appearance();
            Infragistics.Win.Appearance appearance84 = new Infragistics.Win.Appearance();
            Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn2 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("SAMPLINGID");
            Infragistics.Win.Appearance appearance85 = new Infragistics.Win.Appearance();
            Infragistics.Win.Appearance appearance86 = new Infragistics.Win.Appearance();
            Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn3 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("SAMPLINGTIME");
            Infragistics.Win.Appearance appearance87 = new Infragistics.Win.Appearance();
            Infragistics.Win.Appearance appearance88 = new Infragistics.Win.Appearance();
            Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn4 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("seconds");
            Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn5 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("C");
            Infragistics.Win.Appearance appearance89 = new Infragistics.Win.Appearance();
            Infragistics.Win.Appearance appearance90 = new Infragistics.Win.Appearance();
            Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn6 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("SI");
            Infragistics.Win.Appearance appearance91 = new Infragistics.Win.Appearance();
            Infragistics.Win.Appearance appearance92 = new Infragistics.Win.Appearance();
            Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn7 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("MN");
            Infragistics.Win.Appearance appearance93 = new Infragistics.Win.Appearance();
            Infragistics.Win.Appearance appearance94 = new Infragistics.Win.Appearance();
            Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn8 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("P");
            Infragistics.Win.Appearance appearance95 = new Infragistics.Win.Appearance();
            Infragistics.Win.Appearance appearance96 = new Infragistics.Win.Appearance();
            Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn9 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("S");
            Infragistics.Win.Appearance appearance97 = new Infragistics.Win.Appearance();
            Infragistics.Win.Appearance appearance98 = new Infragistics.Win.Appearance();
            Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn10 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("Cu");
            Infragistics.Win.Appearance appearance99 = new Infragistics.Win.Appearance();
            Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn11 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("Asn");
            Infragistics.Win.Appearance appearance100 = new Infragistics.Win.Appearance();
            Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn12 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("Ti");
            Infragistics.Win.Appearance appearance101 = new Infragistics.Win.Appearance();
            Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn13 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("Cr");
            Infragistics.Win.Appearance appearance102 = new Infragistics.Win.Appearance();
            Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn14 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("Sn");
            Infragistics.Win.Appearance appearance103 = new Infragistics.Win.Appearance();
            Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn15 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("Ni");
            Infragistics.Win.Appearance appearance104 = new Infragistics.Win.Appearance();
            Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn16 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("V");
            Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn17 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("Nb");
            Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn18 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("VHEATNO");
            Infragistics.Win.Appearance appearance105 = new Infragistics.Win.Appearance();
            Infragistics.Win.Appearance appearance106 = new Infragistics.Win.Appearance();
            Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn19 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("AIM_GRADE_CODE");
            Infragistics.Win.Appearance appearance107 = new Infragistics.Win.Appearance();
            Infragistics.Win.Appearance appearance108 = new Infragistics.Win.Appearance();
            Infragistics.Win.Appearance appearance70 = new Infragistics.Win.Appearance();
            Infragistics.Win.Appearance appearance71 = new Infragistics.Win.Appearance();
            Infragistics.Win.Appearance appearance72 = new Infragistics.Win.Appearance();
            Infragistics.Win.Appearance appearance73 = new Infragistics.Win.Appearance();
            Infragistics.Win.Appearance appearance74 = new Infragistics.Win.Appearance();
            Infragistics.Win.Appearance appearance75 = new Infragistics.Win.Appearance();
            Infragistics.Win.Appearance appearance76 = new Infragistics.Win.Appearance();
            Infragistics.Win.Appearance appearance77 = new Infragistics.Win.Appearance();
            Infragistics.Win.Appearance appearance78 = new Infragistics.Win.Appearance();
            Infragistics.Win.Appearance appearance79 = new Infragistics.Win.Appearance();
            Infragistics.Win.Appearance appearance80 = new Infragistics.Win.Appearance();
            Infragistics.Win.Appearance appearance5 = new Infragistics.Win.Appearance();
            this.label2 = new System.Windows.Forms.Label();
            this.ultraMaskedEdit1 = new Infragistics.Win.UltraWinMaskedEdit.UltraMaskedEdit();
            this.ultraDataSource1 = new Infragistics.Win.UltraWinDataSource.UltraDataSource(this.components);
            this.ultraGridExcelExporter1 = new Infragistics.Win.UltraWinGrid.ExcelExport.UltraGridExcelExporter(this.components);
            this.ultraGrid1 = new Infragistics.Win.UltraWinGrid.UltraGrid();
            this.ultraGroupBox1 = new Infragistics.Win.Misc.UltraGroupBox();
            this.chkRefresh = new System.Windows.Forms.CheckBox();
            this.label4 = new System.Windows.Forms.Label();
            this.chkTime = new System.Windows.Forms.CheckBox();
            this.uldtBeginTime = new Infragistics.Win.UltraWinEditors.UltraDateTimeEditor();
            this.uldtEndTime = new Infragistics.Win.UltraWinEditors.UltraDateTimeEditor();
            ((System.ComponentModel.ISupportInitialize)(this.ultraDataSource1)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.ultraGrid1)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.ultraGroupBox1)).BeginInit();
            this.ultraGroupBox1.SuspendLayout();
            ((System.ComponentModel.ISupportInitialize)(this.uldtBeginTime)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.uldtEndTime)).BeginInit();
            this.SuspendLayout();
            // 
            // label2
            // 
            this.label2.AutoSize = true;
            this.label2.Location = new System.Drawing.Point(413, 18);
            this.label2.Name = "label2";
            this.label2.Size = new System.Drawing.Size(41, 12);
            this.label2.TabIndex = 51;
            this.label2.Text = "脱硫号";
            // 
            // ultraMaskedEdit1
            // 
            editorButton1.Key = "edit";
            editorButton2.Key = "clear";
            this.ultraMaskedEdit1.ButtonsRight.Add(editorButton1);
            this.ultraMaskedEdit1.ButtonsRight.Add(editorButton2);
            this.ultraMaskedEdit1.DataMode = Infragistics.Win.UltraWinMaskedEdit.MaskMode.Raw;
            this.ultraMaskedEdit1.Location = new System.Drawing.Point(461, 11);
            this.ultraMaskedEdit1.Name = "ultraMaskedEdit1";
            this.ultraMaskedEdit1.PromptChar = ' ';
            this.ultraMaskedEdit1.RightToLeft = System.Windows.Forms.RightToLeft.Yes;
            this.ultraMaskedEdit1.Size = new System.Drawing.Size(117, 21);
            this.ultraMaskedEdit1.TabIndex = 49;
            this.ultraMaskedEdit1.UseFlatMode = Infragistics.Win.DefaultableBoolean.True;
            this.ultraMaskedEdit1.EditorButtonClick += new Infragistics.Win.UltraWinEditors.EditorButtonEventHandler(this.ultraMaskedEdit1_EditorButtonClick);
            // 
            // ultraDataSource1
            // 
            this.ultraDataSource1.Band.Columns.AddRange(new object[] {
            ultraDataColumn1,
            ultraDataColumn2,
            ultraDataColumn3,
            ultraDataColumn4,
            ultraDataColumn5,
            ultraDataColumn6,
            ultraDataColumn7,
            ultraDataColumn8,
            ultraDataColumn9,
            ultraDataColumn10,
            ultraDataColumn11,
            ultraDataColumn12,
            ultraDataColumn13,
            ultraDataColumn14,
            ultraDataColumn15,
            ultraDataColumn16,
            ultraDataColumn17,
            ultraDataColumn18,
            ultraDataColumn19});
            // 
            // ultraGrid1
            // 
            this.ultraGrid1.DataSource = this.ultraDataSource1;
            ultraGridColumn1.CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
            appearance83.TextVAlignAsString = "Middle";
            ultraGridColumn1.CellAppearance = appearance83;
            appearance84.TextHAlignAsString = "Center";
            ultraGridColumn1.Header.Appearance = appearance84;
            ultraGridColumn1.Header.Caption = "脱硫号";
            ultraGridColumn1.Header.VisiblePosition = 0;
            ultraGridColumn1.RowLayoutColumnInfo.OriginX = 0;
            ultraGridColumn1.RowLayoutColumnInfo.OriginY = 0;
            ultraGridColumn1.RowLayoutColumnInfo.SpanX = 2;
            ultraGridColumn1.RowLayoutColumnInfo.SpanY = 2;
            ultraGridColumn1.Width = 102;
            ultraGridColumn2.CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
            appearance85.TextVAlignAsString = "Middle";
            ultraGridColumn2.CellAppearance = appearance85;
            appearance86.TextHAlignAsString = "Center";
            ultraGridColumn2.Header.Appearance = appearance86;
            ultraGridColumn2.Header.Caption = "样点";
            ultraGridColumn2.Header.VisiblePosition = 1;
            ultraGridColumn2.RowLayoutColumnInfo.OriginX = 6;
            ultraGridColumn2.RowLayoutColumnInfo.OriginY = 0;
            ultraGridColumn2.RowLayoutColumnInfo.SpanX = 2;
            ultraGridColumn2.RowLayoutColumnInfo.SpanY = 2;
            ultraGridColumn2.Width = 63;
            ultraGridColumn3.CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
            appearance87.TextVAlignAsString = "Middle";
            ultraGridColumn3.CellAppearance = appearance87;
            appearance88.TextHAlignAsString = "Center";
            ultraGridColumn3.Header.Appearance = appearance88;
            ultraGridColumn3.Header.Caption = "采样时间";
            ultraGridColumn3.Header.VisiblePosition = 2;
            ultraGridColumn3.RowLayoutColumnInfo.OriginX = 8;
            ultraGridColumn3.RowLayoutColumnInfo.OriginY = 0;
            ultraGridColumn3.RowLayoutColumnInfo.SpanX = 2;
            ultraGridColumn3.RowLayoutColumnInfo.SpanY = 2;
            ultraGridColumn3.Width = 158;
            ultraGridColumn4.Header.Caption = "化验时间差";
            ultraGridColumn4.Header.VisiblePosition = 11;
            ultraGridColumn4.RowLayoutColumnInfo.OriginX = 10;
            ultraGridColumn4.RowLayoutColumnInfo.OriginY = 0;
            ultraGridColumn4.RowLayoutColumnInfo.PreferredCellSize = new System.Drawing.Size(101, 0);
            ultraGridColumn4.RowLayoutColumnInfo.SpanX = 2;
            ultraGridColumn4.RowLayoutColumnInfo.SpanY = 2;
            ultraGridColumn5.CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
            appearance89.TextVAlignAsString = "Middle";
            ultraGridColumn5.CellAppearance = appearance89;
            appearance90.TextHAlignAsString = "Center";
            ultraGridColumn5.Header.Appearance = appearance90;
            ultraGridColumn5.Header.VisiblePosition = 3;
            ultraGridColumn5.RowLayoutColumnInfo.OriginX = 12;
            ultraGridColumn5.RowLayoutColumnInfo.OriginY = 0;
            ultraGridColumn5.RowLayoutColumnInfo.PreferredCellSize = new System.Drawing.Size(65, 0);
            ultraGridColumn5.RowLayoutColumnInfo.SpanX = 2;
            ultraGridColumn5.RowLayoutColumnInfo.SpanY = 2;
            ultraGridColumn5.Width = 65;
            ultraGridColumn6.CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
            appearance91.TextVAlignAsString = "Middle";
            ultraGridColumn6.CellAppearance = appearance91;
            appearance92.TextHAlignAsString = "Center";
            ultraGridColumn6.Header.Appearance = appearance92;
            ultraGridColumn6.Header.Caption = "Si";
            ultraGridColumn6.Header.VisiblePosition = 4;
            ultraGridColumn6.RowLayoutColumnInfo.OriginX = 14;
            ultraGridColumn6.RowLayoutColumnInfo.OriginY = 0;
            ultraGridColumn6.RowLayoutColumnInfo.PreferredCellSize = new System.Drawing.Size(83, 0);
            ultraGridColumn6.RowLayoutColumnInfo.SpanX = 2;
            ultraGridColumn6.RowLayoutColumnInfo.SpanY = 2;
            ultraGridColumn6.Width = 83;
            ultraGridColumn7.CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
            appearance93.TextVAlignAsString = "Middle";
            ultraGridColumn7.CellAppearance = appearance93;
            appearance94.TextHAlignAsString = "Center";
            ultraGridColumn7.Header.Appearance = appearance94;
            ultraGridColumn7.Header.Caption = "Mn";
            ultraGridColumn7.Header.VisiblePosition = 5;
            ultraGridColumn7.RowLayoutColumnInfo.OriginX = 16;
            ultraGridColumn7.RowLayoutColumnInfo.OriginY = 0;
            ultraGridColumn7.RowLayoutColumnInfo.PreferredCellSize = new System.Drawing.Size(72, 0);
            ultraGridColumn7.RowLayoutColumnInfo.SpanX = 2;
            ultraGridColumn7.RowLayoutColumnInfo.SpanY = 2;
            ultraGridColumn7.Width = 84;
            ultraGridColumn8.CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
            appearance95.TextVAlignAsString = "Middle";
            ultraGridColumn8.CellAppearance = appearance95;
            appearance96.TextHAlignAsString = "Center";
            ultraGridColumn8.Header.Appearance = appearance96;
            ultraGridColumn8.Header.VisiblePosition = 7;
            ultraGridColumn8.RowLayoutColumnInfo.OriginX = 18;
            ultraGridColumn8.RowLayoutColumnInfo.OriginY = 0;
            ultraGridColumn8.RowLayoutColumnInfo.SpanX = 2;
            ultraGridColumn8.RowLayoutColumnInfo.SpanY = 2;
            ultraGridColumn8.Width = 86;
            ultraGridColumn9.CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
            appearance97.TextVAlignAsString = "Middle";
            ultraGridColumn9.CellAppearance = appearance97;
            appearance98.TextHAlignAsString = "Center";
            ultraGridColumn9.Header.Appearance = appearance98;
            ultraGridColumn9.Header.VisiblePosition = 6;
            ultraGridColumn9.RowLayoutColumnInfo.OriginX = 20;
            ultraGridColumn9.RowLayoutColumnInfo.OriginY = 0;
            ultraGridColumn9.RowLayoutColumnInfo.SpanX = 2;
            ultraGridColumn9.RowLayoutColumnInfo.SpanY = 2;
            ultraGridColumn9.Width = 85;
            appearance99.TextVAlignAsString = "Middle";
            ultraGridColumn10.CellAppearance = appearance99;
            ultraGridColumn10.Header.VisiblePosition = 8;
            ultraGridColumn10.RowLayoutColumnInfo.OriginX = 22;
            ultraGridColumn10.RowLayoutColumnInfo.OriginY = 0;
            ultraGridColumn10.RowLayoutColumnInfo.SpanX = 2;
            ultraGridColumn10.RowLayoutColumnInfo.SpanY = 2;
            ultraGridColumn10.Width = 89;
            appearance100.TextVAlignAsString = "Middle";
            ultraGridColumn11.CellAppearance = appearance100;
            ultraGridColumn11.Header.Caption = "As";
            ultraGridColumn11.Header.VisiblePosition = 9;
            ultraGridColumn11.RowLayoutColumnInfo.OriginX = 24;
            ultraGridColumn11.RowLayoutColumnInfo.OriginY = 0;
            ultraGridColumn11.RowLayoutColumnInfo.SpanX = 2;
            ultraGridColumn11.RowLayoutColumnInfo.SpanY = 2;
            ultraGridColumn11.Width = 83;
            appearance101.TextVAlignAsString = "Middle";
            ultraGridColumn12.CellAppearance = appearance101;
            ultraGridColumn12.Header.VisiblePosition = 10;
            ultraGridColumn12.RowLayoutColumnInfo.OriginX = 26;
            ultraGridColumn12.RowLayoutColumnInfo.OriginY = 0;
            ultraGridColumn12.RowLayoutColumnInfo.SpanX = 2;
            ultraGridColumn12.RowLayoutColumnInfo.SpanY = 2;
            ultraGridColumn12.Width = 80;
            ultraGridColumn13.CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
            appearance102.TextVAlignAsString = "Middle";
            ultraGridColumn13.CellAppearance = appearance102;
            ultraGridColumn13.Header.VisiblePosition = 12;
            ultraGridColumn13.RowLayoutColumnInfo.OriginX = 28;
            ultraGridColumn13.RowLayoutColumnInfo.OriginY = 0;
            ultraGridColumn13.RowLayoutColumnInfo.PreferredCellSize = new System.Drawing.Size(79, 0);
            ultraGridColumn13.RowLayoutColumnInfo.SpanX = 2;
            ultraGridColumn13.RowLayoutColumnInfo.SpanY = 2;
            ultraGridColumn14.CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
            appearance103.TextVAlignAsString = "Middle";
            ultraGridColumn14.CellAppearance = appearance103;
            ultraGridColumn14.Header.VisiblePosition = 13;
            ultraGridColumn14.RowLayoutColumnInfo.OriginX = 30;
            ultraGridColumn14.RowLayoutColumnInfo.OriginY = 0;
            ultraGridColumn14.RowLayoutColumnInfo.PreferredCellSize = new System.Drawing.Size(86, 0);
            ultraGridColumn14.RowLayoutColumnInfo.SpanX = 2;
            ultraGridColumn14.RowLayoutColumnInfo.SpanY = 2;
            ultraGridColumn15.CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
            appearance104.TextVAlignAsString = "Middle";
            ultraGridColumn15.CellAppearance = appearance104;
            ultraGridColumn15.Header.VisiblePosition = 14;
            ultraGridColumn15.RowLayoutColumnInfo.OriginX = 32;
            ultraGridColumn15.RowLayoutColumnInfo.OriginY = 0;
            ultraGridColumn15.RowLayoutColumnInfo.PreferredCellSize = new System.Drawing.Size(72, 0);
            ultraGridColumn15.RowLayoutColumnInfo.SpanX = 2;
            ultraGridColumn15.RowLayoutColumnInfo.SpanY = 2;
            ultraGridColumn16.Header.VisiblePosition = 15;
            ultraGridColumn16.RowLayoutColumnInfo.OriginX = 34;
            ultraGridColumn16.RowLayoutColumnInfo.OriginY = 0;
            ultraGridColumn16.RowLayoutColumnInfo.PreferredCellSize = new System.Drawing.Size(63, 0);
            ultraGridColumn16.RowLayoutColumnInfo.SpanX = 2;
            ultraGridColumn16.RowLayoutColumnInfo.SpanY = 2;
            ultraGridColumn17.Header.VisiblePosition = 16;
            ultraGridColumn17.RowLayoutColumnInfo.OriginX = 36;
            ultraGridColumn17.RowLayoutColumnInfo.OriginY = 0;
            ultraGridColumn17.RowLayoutColumnInfo.PreferredCellSize = new System.Drawing.Size(61, 0);
            ultraGridColumn17.RowLayoutColumnInfo.SpanX = 2;
            ultraGridColumn17.RowLayoutColumnInfo.SpanY = 2;
            ultraGridColumn18.CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
            appearance105.TextVAlignAsString = "Middle";
            ultraGridColumn18.CellAppearance = appearance105;
            appearance106.TextHAlignAsString = "Center";
            ultraGridColumn18.Header.Appearance = appearance106;
            ultraGridColumn18.Header.Caption = "炉号";
            ultraGridColumn18.Header.VisiblePosition = 17;
            ultraGridColumn18.RowLayoutColumnInfo.OriginX = 2;
            ultraGridColumn18.RowLayoutColumnInfo.OriginY = 0;
            ultraGridColumn18.RowLayoutColumnInfo.PreferredCellSize = new System.Drawing.Size(92, 0);
            ultraGridColumn18.RowLayoutColumnInfo.SpanX = 2;
            ultraGridColumn18.RowLayoutColumnInfo.SpanY = 2;
            ultraGridColumn19.CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
            appearance107.TextVAlignAsString = "Middle";
            ultraGridColumn19.CellAppearance = appearance107;
            appearance108.TextHAlignAsString = "Center";
            ultraGridColumn19.Header.Appearance = appearance108;
            ultraGridColumn19.Header.Caption = "牌号";
            ultraGridColumn19.Header.VisiblePosition = 18;
            ultraGridColumn19.RowLayoutColumnInfo.OriginX = 4;
            ultraGridColumn19.RowLayoutColumnInfo.OriginY = 0;
            ultraGridColumn19.RowLayoutColumnInfo.SpanX = 2;
            ultraGridColumn19.RowLayoutColumnInfo.SpanY = 2;
            ultraGridBand1.Columns.AddRange(new object[] {
            ultraGridColumn1,
            ultraGridColumn2,
            ultraGridColumn3,
            ultraGridColumn4,
            ultraGridColumn5,
            ultraGridColumn6,
            ultraGridColumn7,
            ultraGridColumn8,
            ultraGridColumn9,
            ultraGridColumn10,
            ultraGridColumn11,
            ultraGridColumn12,
            ultraGridColumn13,
            ultraGridColumn14,
            ultraGridColumn15,
            ultraGridColumn16,
            ultraGridColumn17,
            ultraGridColumn18,
            ultraGridColumn19});
            ultraGridBand1.Override.AllowRowLayoutCellSizing = Infragistics.Win.UltraWinGrid.RowLayoutSizing.Horizontal;
            ultraGridBand1.Override.AllowRowLayoutLabelSizing = Infragistics.Win.UltraWinGrid.RowLayoutSizing.Horizontal;
            ultraGridBand1.RowLayoutStyle = Infragistics.Win.UltraWinGrid.RowLayoutStyle.ColumnLayout;
            this.ultraGrid1.DisplayLayout.BandsSerializer.Add(ultraGridBand1);
            appearance70.TextHAlignAsString = "Left";
            this.ultraGrid1.DisplayLayout.CaptionAppearance = appearance70;
            appearance71.BackColor = System.Drawing.SystemColors.ActiveBorder;
            appearance71.BackColor2 = System.Drawing.SystemColors.ControlDark;
            appearance71.BackGradientStyle = Infragistics.Win.GradientStyle.Vertical;
            appearance71.BorderColor = System.Drawing.SystemColors.Window;
            this.ultraGrid1.DisplayLayout.GroupByBox.Appearance = appearance71;
            appearance72.ForeColor = System.Drawing.SystemColors.GrayText;
            this.ultraGrid1.DisplayLayout.GroupByBox.BandLabelAppearance = appearance72;
            this.ultraGrid1.DisplayLayout.GroupByBox.BorderStyle = Infragistics.Win.UIElementBorderStyle.Solid;
            this.ultraGrid1.DisplayLayout.GroupByBox.Hidden = true;
            appearance73.BackColor = System.Drawing.SystemColors.ControlLightLight;
            appearance73.BackColor2 = System.Drawing.SystemColors.Control;
            appearance73.BackGradientStyle = Infragistics.Win.GradientStyle.Horizontal;
            appearance73.ForeColor = System.Drawing.SystemColors.GrayText;
            this.ultraGrid1.DisplayLayout.GroupByBox.PromptAppearance = appearance73;
            this.ultraGrid1.DisplayLayout.MaxColScrollRegions = 1;
            this.ultraGrid1.DisplayLayout.MaxRowScrollRegions = 1;
            appearance74.BackColor = System.Drawing.SystemColors.Window;
            appearance74.ForeColor = System.Drawing.SystemColors.ControlText;
            this.ultraGrid1.DisplayLayout.Override.ActiveCellAppearance = appearance74;
            appearance75.BackColor = System.Drawing.SystemColors.Highlight;
            appearance75.ForeColor = System.Drawing.SystemColors.HighlightText;
            this.ultraGrid1.DisplayLayout.Override.ActiveRowAppearance = appearance75;
            this.ultraGrid1.DisplayLayout.Override.BorderStyleCell = Infragistics.Win.UIElementBorderStyle.RaisedSoft;
            this.ultraGrid1.DisplayLayout.Override.BorderStyleRow = Infragistics.Win.UIElementBorderStyle.None;
            appearance76.BackColor = System.Drawing.SystemColors.Window;
            this.ultraGrid1.DisplayLayout.Override.CardAreaAppearance = appearance76;
            appearance77.FontData.SizeInPoints = 10F;
            appearance77.TextTrimming = Infragistics.Win.TextTrimming.EllipsisCharacter;
            this.ultraGrid1.DisplayLayout.Override.CellAppearance = appearance77;
            this.ultraGrid1.DisplayLayout.Override.CellClickAction = Infragistics.Win.UltraWinGrid.CellClickAction.EditAndSelectText;
            this.ultraGrid1.DisplayLayout.Override.CellPadding = 0;
            this.ultraGrid1.DisplayLayout.Override.DefaultRowHeight = 25;
            appearance78.BackColor = System.Drawing.SystemColors.Control;
            appearance78.BackColor2 = System.Drawing.SystemColors.ControlDark;
            appearance78.BackGradientAlignment = Infragistics.Win.GradientAlignment.Element;
            appearance78.BackGradientStyle = Infragistics.Win.GradientStyle.Horizontal;
            appearance78.BorderColor = System.Drawing.SystemColors.Window;
            this.ultraGrid1.DisplayLayout.Override.GroupByRowAppearance = appearance78;
            appearance79.TextHAlignAsString = "Left";
            this.ultraGrid1.DisplayLayout.Override.HeaderAppearance = appearance79;
            this.ultraGrid1.DisplayLayout.Override.HeaderClickAction = Infragistics.Win.UltraWinGrid.HeaderClickAction.SortMulti;
            this.ultraGrid1.DisplayLayout.Override.HeaderStyle = Infragistics.Win.HeaderStyle.Standard;
            this.ultraGrid1.DisplayLayout.Override.RowSelectorNumberStyle = Infragistics.Win.UltraWinGrid.RowSelectorNumberStyle.RowIndex;
            this.ultraGrid1.DisplayLayout.Override.RowSelectorWidth = 25;
            appearance80.BackColor = System.Drawing.SystemColors.ControlLight;
            this.ultraGrid1.DisplayLayout.Override.TemplateAddRowAppearance = appearance80;
            this.ultraGrid1.DisplayLayout.ScrollBounds = Infragistics.Win.UltraWinGrid.ScrollBounds.ScrollToFill;
            this.ultraGrid1.DisplayLayout.ScrollStyle = Infragistics.Win.UltraWinGrid.ScrollStyle.Immediate;
            this.ultraGrid1.DisplayLayout.ViewStyleBand = Infragistics.Win.UltraWinGrid.ViewStyleBand.OutlookGroupBy;
            this.ultraGrid1.Dock = System.Windows.Forms.DockStyle.Fill;
            this.ultraGrid1.Font = new System.Drawing.Font("Tahoma", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
            this.ultraGrid1.Location = new System.Drawing.Point(0, 47);
            this.ultraGrid1.Name = "ultraGrid1";
            this.ultraGrid1.Size = new System.Drawing.Size(1094, 446);
            this.ultraGrid1.TabIndex = 19;
            this.ultraGrid1.InitializeRow += new Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(this.ultraGrid1_InitializeRow);
            // 
            // ultraGroupBox1
            // 
            this.ultraGroupBox1.Controls.Add(this.chkRefresh);
            this.ultraGroupBox1.Controls.Add(this.label4);
            this.ultraGroupBox1.Controls.Add(this.chkTime);
            this.ultraGroupBox1.Controls.Add(this.uldtBeginTime);
            this.ultraGroupBox1.Controls.Add(this.uldtEndTime);
            this.ultraGroupBox1.Controls.Add(this.label2);
            this.ultraGroupBox1.Controls.Add(this.ultraMaskedEdit1);
            this.ultraGroupBox1.Dock = System.Windows.Forms.DockStyle.Top;
            this.ultraGroupBox1.Location = new System.Drawing.Point(0, 0);
            this.ultraGroupBox1.Name = "ultraGroupBox1";
            this.ultraGroupBox1.Size = new System.Drawing.Size(1094, 47);
            this.ultraGroupBox1.TabIndex = 21;
            // 
            // chkRefresh
            // 
            this.chkRefresh.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
            this.chkRefresh.Location = new System.Drawing.Point(599, 9);
            this.chkRefresh.Name = "chkRefresh";
            this.chkRefresh.Size = new System.Drawing.Size(82, 24);
            this.chkRefresh.TabIndex = 72;
            this.chkRefresh.Text = "自动刷新";
            this.chkRefresh.CheckedChanged += new System.EventHandler(this.chkRefresh_CheckedChanged);
            // 
            // label4
            // 
            this.label4.AutoSize = true;
            this.label4.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
            this.label4.Location = new System.Drawing.Point(243, 16);
            this.label4.Name = "label4";
            this.label4.Size = new System.Drawing.Size(21, 14);
            this.label4.TabIndex = 284;
            this.label4.Text = "到";
            // 
            // chkTime
            // 
            this.chkTime.AutoSize = true;
            this.chkTime.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
            this.chkTime.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
            this.chkTime.Location = new System.Drawing.Point(21, 14);
            this.chkTime.Name = "chkTime";
            this.chkTime.Size = new System.Drawing.Size(79, 18);
            this.chkTime.TabIndex = 283;
            this.chkTime.Text = "时间　从";
            this.chkTime.UseVisualStyleBackColor = true;
            this.chkTime.CheckedChanged += new System.EventHandler(this.chkTime_CheckedChanged);
            // 
            // uldtBeginTime
            // 
            appearance5.BorderAlpha = Infragistics.Win.Alpha.UseAlphaLevel;
            appearance5.BorderColor = System.Drawing.Color.Black;
            this.uldtBeginTime.ButtonAppearance = appearance5;
            this.uldtBeginTime.DateTime = new System.DateTime(2008, 1, 12, 0, 0, 0, 0);
            this.uldtBeginTime.Enabled = false;
            this.uldtBeginTime.FormatProvider = new System.Globalization.CultureInfo("en-US");
            this.uldtBeginTime.FormatString = "yyyy-MM-dd HH:mm";
            this.uldtBeginTime.Location = new System.Drawing.Point(104, 14);
            this.uldtBeginTime.MaskInput = "yyyy-mm-dd hh:mm";
            this.uldtBeginTime.Name = "uldtBeginTime";
            this.uldtBeginTime.Size = new System.Drawing.Size(133, 19);
            this.uldtBeginTime.TabIndex = 282;
            this.uldtBeginTime.UseFlatMode = Infragistics.Win.DefaultableBoolean.True;
            this.uldtBeginTime.Value = new System.DateTime(2008, 1, 12, 0, 0, 0, 0);
            this.uldtBeginTime.ValueChanged += new System.EventHandler(this.uldtBeginTime_ValueChanged);
            // 
            // uldtEndTime
            // 
            this.uldtEndTime.DateTime = new System.DateTime(2008, 11, 24, 0, 0, 0, 0);
            this.uldtEndTime.FormatProvider = new System.Globalization.CultureInfo("en-US");
            this.uldtEndTime.FormatString = "yyyy-MM-dd HH:mm";
            this.uldtEndTime.Location = new System.Drawing.Point(271, 12);
            this.uldtEndTime.MaskInput = "yyyy-mm-dd hh:mm";
            this.uldtEndTime.Name = "uldtEndTime";
            this.uldtEndTime.Size = new System.Drawing.Size(136, 21);
            this.uldtEndTime.TabIndex = 281;
            this.uldtEndTime.Value = new System.DateTime(2008, 11, 24, 0, 0, 0, 0);
            // 
            // FrmIronEleQry
            // 
            this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F);
            this.ClientSize = new System.Drawing.Size(1094, 493);
            this.Controls.Add(this.ultraGrid1);
            this.Controls.Add(this.ultraGroupBox1);
            this.Name = "FrmIronEleQry";
            this.StatusCustomInfo = "F1:用户视图 F2:表格拖选统计";
            this.Text = "铁水成分";
            this.Load += new System.EventHandler(this.FrmIronEleQry_Load);
            ((System.ComponentModel.ISupportInitialize)(this.ultraDataSource1)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.ultraGrid1)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.ultraGroupBox1)).EndInit();
            this.ultraGroupBox1.ResumeLayout(false);
            this.ultraGroupBox1.PerformLayout();
            ((System.ComponentModel.ISupportInitialize)(this.uldtBeginTime)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.uldtEndTime)).EndInit();
            this.ResumeLayout(false);

        }
        #endregion

        private DataSet _dsIron;

        private void GetData()
        {

            if (this.chkTime.Checked == true)
            {
                if (Convert.ToDateTime(uldtEndTime.Value).Date.Subtract(Convert.ToDateTime(uldtBeginTime.Value).Date).Days > 180)
                {
                    MessageBox.Show("查询时间不可超过6个月。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    return;
                }
                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");
                }
            }

            try
            {
                _dsIron = null;

                //定义一个ArrayList集合存储变量[参数]值 
                ArrayList arry = new ArrayList();
                ArrayList sqlList = new ArrayList();

                arry.Add("FrmIronEleQry.select");//此ID为XML文件ID
                sqlList.Add(BuildSQLWhere());
                sqlList.Add(BuildSQLWhere());

                //调用服务端方法
                CoreClientParam CCP_JJBQuery = new CoreClientParam();
                DataTable dt = new DataTable();
                CCP_JJBQuery.ServerName = "Core.LgMes.Server.Common.ComDBQuery";
                CCP_JJBQuery.MethodName = "doQuery";
                CCP_JJBQuery.ServerParams = new object[] { arry, sqlList };
                CCP_JJBQuery.SourceDataTable = dt;
                this.ExecuteQueryToDataTable(CCP_JJBQuery, CoreInvokeType.Internal);


                SetDataToGrid(dt);

            }
            catch { }
        }
        private void SetDataToGrid(DataTable dt)
        {
            this.ultraDataSource1.Rows.Clear();
            if (dt == null) return;

            DataTable tb = SampTimeDifference();

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                try
                {
                    DataRow dr = dt.Rows[i];
                    this.ultraDataSource1.Rows.Add(new object[]{
																   dr["heatno"].ToString(),
																   dr["ASSAYTYPECODE"].ToString(),                                                                   
                                                                   dr["ASSAYDATE"].ToString(), 
                                                                   CalTimeDefferent(dr,tb,dr["ASSAYDATE"].ToString()),
																   dr["C"].ToString(),
																   dr["SI"].ToString(),
																   dr["MN"].ToString(),
																   dr["P"].ToString(),
																   dr["S"].ToString(),
																   dr["Cu"].ToString(),
                                                                   dr["Asn"].ToString(),
																   dr["Ti"].ToString(),
                                                                   dr["Cr"].ToString(),
																   dr["Sn"].ToString(),
																   dr["Ni"].ToString(),
                                                                   dr["V"].ToString(),
                                                                   dr["Nb"].ToString(),
                                                                   dr["VHEATNO"].ToString(),
                                                                   dr["AIM_GRADE_CODE"].ToString()
															   });
                }
                catch { }
            }
        }

        private string CalTimeDefferent(DataRow dr, DataTable tb, string strAssaydate)
        {
            if (tb != null && tb.Select("heatno = '" + dr["heatno"].ToString() + "'").Length != 0)
            {
                string strSenconds = tb.Select("heatno = '" + dr["heatno"].ToString() + "'")[0]["seconds"].ToString();
                //(Convert.ToDateTime(strAssaydate) - Convert.ToDateTime(strSenconds)).Seconds;

                return Math.Abs((Convert.ToDateTime(strAssaydate) - Convert.ToDateTime(strSenconds)).Minutes) + "m" + Math.Abs((Convert.ToDateTime(strAssaydate) - Convert.ToDateTime(strSenconds)).Seconds) + "s";
            }
            else
            {
                return "";
            }


        }

        public DataTable SampTimeDifference()//查询送样时间差
        {
            try
            {

                string strErr = "";
                string strsql = "select s.heatno,s.sample_date1 Seconds from ("
                                   + " select t.*, row_number() over(partition by t.heatno order by t.sample_date1 desc) rn "
                                    + "   from STL_AIR_SAMPLESIGNAL t "
                                   + "   where  "
                                   + "   t.strpos like 'HMP%' "
                                   + "   union  "
                                   + "  select j.*, row_number() over(partition by j.heatno order by j.sample_date1 desc) rn "
                                   + "    from J#STL_AIR_SAMPLESIGNAL j "
                                   + "   where  "
                                    + "  j.strpos like 'HMP%'  "
                                  + "   ) s where s.sample_date1 between to_date('" + this.uldtBeginTime.DateTime.AddDays(-1).ToString("yyyy-MM-dd") + "','yyyy-mm-dd') and to_date('" + this.uldtEndTime.DateTime.AddDays(1).ToString("yyyy-MM-dd") + "','yyyy-mm-dd') and s.rn=1 ";
                CommonClientToServer cctos = new CommonClientToServer();
                cctos.ob = this.ob;
                DataTable tb = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBExecute",
                                                           "doSimpleQuery", strsql, out strErr).Tables[0];
                if (!(strErr == "" && tb != null && tb.Rows.Count > 0))
                    return null;
                return tb;
            }
            catch { }
            return null;
        }

        private void FrmIronEleQry_Load(object sender, System.EventArgs e)
        {
            this.uldtBeginTime.Value = DateTime.Today.ToString("yyyy-MM-dd") + " 00:00";
            this.uldtEndTime.Value = DateTime.Today.ToString("yyyy-MM-dd") + " 23:59";
            chkTime.Checked = true;
            this.ultraGrid1.Font = new System.Drawing.Font("Tahoma", 9F, FontStyle.Bold);
            GetData();

            StartGetDataThread();
        }
        private string BuildSQLWhere()
        {


            if (this.ultraMaskedEdit1.Text.Trim().Length > 0)
            {
                return string.Format(" where (ASSAYTYPECODE like  'B%' or ASSAYTYPECODE like  'Y%')  and heatno like '%{0}%'", this.ultraMaskedEdit1.Text.Trim());
            }
            else
            {
                return string.Format(" where (ASSAYTYPECODE like  'B%' or ASSAYTYPECODE like  'Y%') and to_char(ASSAYDATE, 'yyyy-MM-dd') between '" + strStartTime + "' and '" + strEndTime + "'");
            }
        }

        private void button1_Click(object sender, System.EventArgs e)
        {

        }

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

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    GetData();
                    break;
                case "Export":
                    if (ultraGrid1.Rows.Count > 0)
                    {
                        ExportData();
                    }
                    else
                        MessageBox.Show("没有化学成分信息。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    break;
                case "Exit":
                    this.Close();
                    break;
                default:
                    break;
            }
        }

        private void ExportData()
        {
            try
            {
                string StrfileName = System.Windows.Forms.Application.StartupPath + "\\Report\\铁水成分明细.xls";
                //this.GridExcelExporter.Export(this.EMGrid, StrfileName);
                ultraGridExcelExporter1.Export(ultraGrid1, 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 + "\n处理方法：查看(" + System.Windows.Forms.Application.StartupPath + ")目录下是否有[ Report文件夹 ],如果没有请手动创建！");
            }
        }

        private void chkTime_CheckedChanged(object sender, EventArgs e)
        {
            uldtBeginTime.Enabled = chkTime.Checked;
            uldtEndTime.Enabled = chkTime.Checked;
        }

        private void uldtBeginTime_ValueChanged(object sender, EventArgs e)
        {

        }

        #region "Auto Refresh"
        private Thread _getDataThread;
        private bool On_Off_GetDataThread = false;
        private delegate void getDataFromAllDelegate();

        private void chkRefresh_CheckedChanged(object sender, EventArgs e)
        {
            On_Off_GetDataThread = this.chkRefresh.Checked;
        }

        private void StartGetDataThread()
        {
            try
            {
                ThreadStart ts = new ThreadStart(GetDataThread);
                _getDataThread = new Thread(ts);
                _getDataThread.Name = "GetDataThread ";

                _getDataThread.Start();
            }
            catch { }
        }

        private void GetDataThread()
        {
        ReStartGetDataThread:
            while (true)
            {
                if (!this.On_Off_Thread || !On_Off_GetDataThread)
                {
                    System.Threading.Thread.Sleep(500);
                    continue;
                }
                try
                {
                    this.Invoke(new getDataFromAllDelegate(GetData));

                    System.Threading.Thread.Sleep(3000);
                }
                catch
                { }
            }
            goto ReStartGetDataThread;
        }
        #endregion

        private void ultraGrid1_InitializeRow(object sender, InitializeRowEventArgs e)
        {
            if (e.Row.Cells["Si"].Text.Trim() != "" && Convert.ToDouble(e.Row.Cells["Si"].Text.Trim()) > 1)
                e.Row.Cells["Si"].Appearance.BackColor = Color.Red;
            if (e.Row.Cells["S"].Text.Trim() != "" && Convert.ToDouble(e.Row.Cells["S"].Text.Trim()) > 0.04)
                e.Row.Cells["S"].Appearance.BackColor = Color.Red;
        }
    }
}