MES_Client/TGMES/Core.StlMes.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 Core.Mes.Client.Comm.Control;

namespace Core.StlMes.Client.LgIntegrationQuery
{
	/// <summary>
	/// FrmIronEleQry 的摘要说明。
	/// </summary>
    public class FrmIronEleQry : Core.StlMes.Client.LgCommon.frmStyleBase
    {
		private System.Windows.Forms.Label label2;
        private Infragistics.Win.UltraWinDataSource.UltraDataSource ultraDataSource1;
        private Infragistics.Win.Misc.UltraGroupBox ultraGroupBox1;
        private Infragistics.Win.UltraWinEditors.UltraDateTimeEditor uldtEndTime;
        private Infragistics.Win.UltraWinEditors.UltraDateTimeEditor uldtBeginTime;
        private Label label4;
        private IContainer components;

        string strStartTime = "";
        private CheckBox chkRefresh;
        private CheckBox checkBox1;
        private Label label1;
        private TextBox ultraMaskedEdit1;
        private Infragistics.Win.UltraWinGrid.UltraGrid ultraGrid1;
        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.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("C");
            Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn5 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("SI");
            Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn6 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("MN");
            Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn7 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("P");
            Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn8 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("S");
            Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn9 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("Asn");
            Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn10 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("Cu");
            Infragistics.Win.UltraWinDataSource.UltraDataColumn ultraDataColumn11 = new Infragistics.Win.UltraWinDataSource.UltraDataColumn("Ti");
            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 appearance21 = new Infragistics.Win.Appearance();
            Infragistics.Win.Appearance appearance22 = new Infragistics.Win.Appearance();
            Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn2 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("SAMPLINGID");
            Infragistics.Win.Appearance appearance23 = new Infragistics.Win.Appearance();
            Infragistics.Win.Appearance appearance24 = new Infragistics.Win.Appearance();
            Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn3 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("SAMPLINGTIME");
            Infragistics.Win.Appearance appearance25 = new Infragistics.Win.Appearance();
            Infragistics.Win.Appearance appearance26 = new Infragistics.Win.Appearance();
            Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn4 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("C");
            Infragistics.Win.Appearance appearance27 = new Infragistics.Win.Appearance();
            Infragistics.Win.Appearance appearance28 = new Infragistics.Win.Appearance();
            Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn5 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("SI");
            Infragistics.Win.Appearance appearance29 = new Infragistics.Win.Appearance();
            Infragistics.Win.Appearance appearance30 = new Infragistics.Win.Appearance();
            Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn6 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("MN");
            Infragistics.Win.Appearance appearance31 = new Infragistics.Win.Appearance();
            Infragistics.Win.Appearance appearance32 = new Infragistics.Win.Appearance();
            Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn7 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("P");
            Infragistics.Win.Appearance appearance33 = new Infragistics.Win.Appearance();
            Infragistics.Win.Appearance appearance34 = new Infragistics.Win.Appearance();
            Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn8 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("S");
            Infragistics.Win.Appearance appearance35 = new Infragistics.Win.Appearance();
            Infragistics.Win.Appearance appearance36 = new Infragistics.Win.Appearance();
            Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn9 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("Asn");
            Infragistics.Win.Appearance appearance37 = new Infragistics.Win.Appearance();
            Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn10 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("Cu");
            Infragistics.Win.Appearance appearance38 = new Infragistics.Win.Appearance();
            Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn11 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("Ti");
            Infragistics.Win.Appearance appearance39 = new Infragistics.Win.Appearance();
            Infragistics.Win.Appearance appearance40 = new Infragistics.Win.Appearance();
            Infragistics.Win.Appearance appearance41 = new Infragistics.Win.Appearance();
            Infragistics.Win.Appearance appearance42 = new Infragistics.Win.Appearance();
            Infragistics.Win.Appearance appearance43 = new Infragistics.Win.Appearance();
            Infragistics.Win.Appearance appearance5 = new Infragistics.Win.Appearance();
            this.label2 = new System.Windows.Forms.Label();
            this.ultraDataSource1 = new Infragistics.Win.UltraWinDataSource.UltraDataSource(this.components);
            this.ultraGrid1 = new Infragistics.Win.UltraWinGrid.UltraGrid();
            this.ultraGroupBox1 = new Infragistics.Win.Misc.UltraGroupBox();
            this.ultraMaskedEdit1 = new System.Windows.Forms.TextBox();
            this.label1 = new System.Windows.Forms.Label();
            this.checkBox1 = new System.Windows.Forms.CheckBox();
            this.chkRefresh = new System.Windows.Forms.CheckBox();
            this.label4 = new System.Windows.Forms.Label();
            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(429, 20);
            this.label2.Name = "label2";
            this.label2.Size = new System.Drawing.Size(0, 12);
            this.label2.TabIndex = 51;
            // 
            // ultraDataSource1
            // 
            this.ultraDataSource1.Band.Columns.AddRange(new object[] {
            ultraDataColumn1,
            ultraDataColumn2,
            ultraDataColumn3,
            ultraDataColumn4,
            ultraDataColumn5,
            ultraDataColumn6,
            ultraDataColumn7,
            ultraDataColumn8,
            ultraDataColumn9,
            ultraDataColumn10,
            ultraDataColumn11});
            // 
            // ultraGrid1
            // 
            this.ultraGrid1.DataSource = this.ultraDataSource1;
            ultraGridColumn1.CellActivation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
            appearance21.TextVAlignAsString = "Middle";
            ultraGridColumn1.CellAppearance = appearance21;
            appearance22.TextHAlignAsString = "Center";
            ultraGridColumn1.Header.Appearance = appearance22;
            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.ActivateOnly;
            appearance23.TextVAlignAsString = "Middle";
            ultraGridColumn2.CellAppearance = appearance23;
            appearance24.TextHAlignAsString = "Center";
            ultraGridColumn2.Header.Appearance = appearance24;
            ultraGridColumn2.Header.Caption = "样点";
            ultraGridColumn2.Header.VisiblePosition = 1;
            ultraGridColumn2.RowLayoutColumnInfo.OriginX = 2;
            ultraGridColumn2.RowLayoutColumnInfo.OriginY = 0;
            ultraGridColumn2.RowLayoutColumnInfo.SpanX = 2;
            ultraGridColumn2.RowLayoutColumnInfo.SpanY = 2;
            ultraGridColumn2.Width = 63;
            ultraGridColumn3.CellActivation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
            appearance25.TextVAlignAsString = "Middle";
            ultraGridColumn3.CellAppearance = appearance25;
            appearance26.TextHAlignAsString = "Center";
            ultraGridColumn3.Header.Appearance = appearance26;
            ultraGridColumn3.Header.Caption = "采样时间";
            ultraGridColumn3.Header.VisiblePosition = 2;
            ultraGridColumn3.RowLayoutColumnInfo.OriginX = 4;
            ultraGridColumn3.RowLayoutColumnInfo.OriginY = 0;
            ultraGridColumn3.RowLayoutColumnInfo.SpanX = 2;
            ultraGridColumn3.RowLayoutColumnInfo.SpanY = 2;
            ultraGridColumn3.Width = 158;
            ultraGridColumn4.CellActivation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
            appearance27.TextVAlignAsString = "Middle";
            ultraGridColumn4.CellAppearance = appearance27;
            appearance28.TextHAlignAsString = "Center";
            ultraGridColumn4.Header.Appearance = appearance28;
            ultraGridColumn4.Header.VisiblePosition = 3;
            ultraGridColumn4.RowLayoutColumnInfo.OriginX = 6;
            ultraGridColumn4.RowLayoutColumnInfo.OriginY = 0;
            ultraGridColumn4.RowLayoutColumnInfo.SpanX = 2;
            ultraGridColumn4.RowLayoutColumnInfo.SpanY = 2;
            ultraGridColumn4.Width = 65;
            ultraGridColumn5.CellActivation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
            appearance29.TextVAlignAsString = "Middle";
            ultraGridColumn5.CellAppearance = appearance29;
            appearance30.TextHAlignAsString = "Center";
            ultraGridColumn5.Header.Appearance = appearance30;
            ultraGridColumn5.Header.Caption = "Si";
            ultraGridColumn5.Header.VisiblePosition = 4;
            ultraGridColumn5.RowLayoutColumnInfo.OriginX = 8;
            ultraGridColumn5.RowLayoutColumnInfo.OriginY = 0;
            ultraGridColumn5.RowLayoutColumnInfo.SpanX = 2;
            ultraGridColumn5.RowLayoutColumnInfo.SpanY = 2;
            ultraGridColumn5.Width = 83;
            ultraGridColumn6.CellActivation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
            appearance31.TextVAlignAsString = "Middle";
            ultraGridColumn6.CellAppearance = appearance31;
            appearance32.TextHAlignAsString = "Center";
            ultraGridColumn6.Header.Appearance = appearance32;
            ultraGridColumn6.Header.Caption = "Mn";
            ultraGridColumn6.Header.VisiblePosition = 5;
            ultraGridColumn6.RowLayoutColumnInfo.OriginX = 10;
            ultraGridColumn6.RowLayoutColumnInfo.OriginY = 0;
            ultraGridColumn6.RowLayoutColumnInfo.SpanX = 2;
            ultraGridColumn6.RowLayoutColumnInfo.SpanY = 2;
            ultraGridColumn6.Width = 84;
            ultraGridColumn7.CellActivation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
            appearance33.TextVAlignAsString = "Middle";
            ultraGridColumn7.CellAppearance = appearance33;
            appearance34.TextHAlignAsString = "Center";
            ultraGridColumn7.Header.Appearance = appearance34;
            ultraGridColumn7.Header.VisiblePosition = 7;
            ultraGridColumn7.RowLayoutColumnInfo.OriginX = 12;
            ultraGridColumn7.RowLayoutColumnInfo.OriginY = 0;
            ultraGridColumn7.RowLayoutColumnInfo.SpanX = 2;
            ultraGridColumn7.RowLayoutColumnInfo.SpanY = 2;
            ultraGridColumn7.Width = 86;
            ultraGridColumn8.CellActivation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
            appearance35.TextVAlignAsString = "Middle";
            ultraGridColumn8.CellAppearance = appearance35;
            appearance36.TextHAlignAsString = "Center";
            ultraGridColumn8.Header.Appearance = appearance36;
            ultraGridColumn8.Header.VisiblePosition = 6;
            ultraGridColumn8.RowLayoutColumnInfo.OriginX = 14;
            ultraGridColumn8.RowLayoutColumnInfo.OriginY = 0;
            ultraGridColumn8.RowLayoutColumnInfo.SpanX = 2;
            ultraGridColumn8.RowLayoutColumnInfo.SpanY = 2;
            ultraGridColumn8.Width = 85;
            ultraGridColumn9.CellActivation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
            appearance37.TextVAlignAsString = "Middle";
            ultraGridColumn9.CellAppearance = appearance37;
            ultraGridColumn9.Header.VisiblePosition = 9;
            ultraGridColumn9.RowLayoutColumnInfo.OriginX = 18;
            ultraGridColumn9.RowLayoutColumnInfo.OriginY = 0;
            ultraGridColumn9.RowLayoutColumnInfo.SpanX = 2;
            ultraGridColumn9.RowLayoutColumnInfo.SpanY = 2;
            ultraGridColumn9.Width = 83;
            ultraGridColumn10.CellActivation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
            appearance38.TextVAlignAsString = "Middle";
            ultraGridColumn10.CellAppearance = appearance38;
            ultraGridColumn10.Header.VisiblePosition = 8;
            ultraGridColumn10.RowLayoutColumnInfo.OriginX = 16;
            ultraGridColumn10.RowLayoutColumnInfo.OriginY = 0;
            ultraGridColumn10.RowLayoutColumnInfo.SpanX = 2;
            ultraGridColumn10.RowLayoutColumnInfo.SpanY = 2;
            ultraGridColumn10.Width = 89;
            ultraGridColumn11.CellActivation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
            appearance39.TextVAlignAsString = "Middle";
            ultraGridColumn11.CellAppearance = appearance39;
            ultraGridColumn11.Header.VisiblePosition = 10;
            ultraGridColumn11.RowLayoutColumnInfo.OriginX = 20;
            ultraGridColumn11.RowLayoutColumnInfo.OriginY = 0;
            ultraGridColumn11.RowLayoutColumnInfo.SpanX = 2;
            ultraGridColumn11.RowLayoutColumnInfo.SpanY = 2;
            ultraGridColumn11.Width = 80;
            ultraGridBand1.Columns.AddRange(new object[] {
            ultraGridColumn1,
            ultraGridColumn2,
            ultraGridColumn3,
            ultraGridColumn4,
            ultraGridColumn5,
            ultraGridColumn6,
            ultraGridColumn7,
            ultraGridColumn8,
            ultraGridColumn9,
            ultraGridColumn10,
            ultraGridColumn11});
            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);
            appearance40.BackColor = System.Drawing.SystemColors.ActiveBorder;
            appearance40.BackColor2 = System.Drawing.SystemColors.ControlDark;
            appearance40.BackGradientStyle = Infragistics.Win.GradientStyle.Vertical;
            appearance40.BorderColor = System.Drawing.SystemColors.Window;
            this.ultraGrid1.DisplayLayout.GroupByBox.Appearance = appearance40;
            appearance41.ForeColor = System.Drawing.SystemColors.GrayText;
            this.ultraGrid1.DisplayLayout.GroupByBox.BandLabelAppearance = appearance41;
            this.ultraGrid1.DisplayLayout.GroupByBox.BorderStyle = Infragistics.Win.UIElementBorderStyle.Solid;
            this.ultraGrid1.DisplayLayout.GroupByBox.Hidden = true;
            appearance42.BackColor = System.Drawing.SystemColors.ControlLightLight;
            appearance42.BackColor2 = System.Drawing.SystemColors.Control;
            appearance42.BackGradientStyle = Infragistics.Win.GradientStyle.Horizontal;
            appearance42.ForeColor = System.Drawing.SystemColors.GrayText;
            this.ultraGrid1.DisplayLayout.GroupByBox.PromptAppearance = appearance42;
            this.ultraGrid1.DisplayLayout.MaxColScrollRegions = 1;
            this.ultraGrid1.DisplayLayout.MaxRowScrollRegions = 1;
            appearance43.FontData.SizeInPoints = 9F;
            this.ultraGrid1.DisplayLayout.Override.CellAppearance = appearance43;
            this.ultraGrid1.DisplayLayout.Override.CellPadding = 0;
            this.ultraGrid1.Dock = System.Windows.Forms.DockStyle.Fill;
            this.ultraGrid1.Font = new System.Drawing.Font("宋体", 9F);
            this.ultraGrid1.Location = new System.Drawing.Point(0, 47);
            this.ultraGrid1.Name = "ultraGrid1";
            this.ultraGrid1.Size = new System.Drawing.Size(884, 446);
            this.ultraGrid1.TabIndex = 19;
            // 
            // ultraGroupBox1
            // 
            this.ultraGroupBox1.Controls.Add(this.ultraMaskedEdit1);
            this.ultraGroupBox1.Controls.Add(this.label1);
            this.ultraGroupBox1.Controls.Add(this.checkBox1);
            this.ultraGroupBox1.Controls.Add(this.chkRefresh);
            this.ultraGroupBox1.Controls.Add(this.label4);
            this.ultraGroupBox1.Controls.Add(this.uldtBeginTime);
            this.ultraGroupBox1.Controls.Add(this.uldtEndTime);
            this.ultraGroupBox1.Controls.Add(this.label2);
            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(884, 47);
            this.ultraGroupBox1.TabIndex = 21;
            // 
            // ultraMaskedEdit1
            // 
            this.ultraMaskedEdit1.Enabled = false;
            this.ultraMaskedEdit1.Location = new System.Drawing.Point(465, 13);
            this.ultraMaskedEdit1.MaxLength = 10;
            this.ultraMaskedEdit1.Name = "ultraMaskedEdit1";
            this.ultraMaskedEdit1.Size = new System.Drawing.Size(100, 21);
            this.ultraMaskedEdit1.TabIndex = 287;
            // 
            // label1
            // 
            this.label1.AutoSize = true;
            this.label1.Location = new System.Drawing.Point(23, 17);
            this.label1.Name = "label1";
            this.label1.Size = new System.Drawing.Size(77, 12);
            this.label1.TabIndex = 286;
            this.label1.Text = "采样时间　从";
            // 
            // checkBox1
            // 
            this.checkBox1.AutoSize = true;
            this.checkBox1.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
            this.checkBox1.Font = new System.Drawing.Font("宋体", 9F);
            this.checkBox1.Location = new System.Drawing.Point(404, 14);
            this.checkBox1.Name = "checkBox1";
            this.checkBox1.Size = new System.Drawing.Size(57, 16);
            this.checkBox1.TabIndex = 285;
            this.checkBox1.Text = "取样号";
            this.checkBox1.UseVisualStyleBackColor = true;
            this.checkBox1.CheckedChanged += new System.EventHandler(this.checkBox1_CheckedChanged);
            // 
            // chkRefresh
            // 
            this.chkRefresh.Font = new System.Drawing.Font("宋体", 9F);
            this.chkRefresh.Location = new System.Drawing.Point(595, 12);
            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("宋体", 9F);
            this.label4.Location = new System.Drawing.Point(243, 16);
            this.label4.Name = "label4";
            this.label4.Size = new System.Drawing.Size(17, 12);
            this.label4.TabIndex = 284;
            this.label4.Text = "到";
            // 
            // 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.FormatProvider = new System.Globalization.CultureInfo("en-US");
            this.uldtBeginTime.FormatString = "";
            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);
            // 
            // 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 = "";
            this.uldtEndTime.Location = new System.Drawing.Point(264, 12);
            this.uldtEndTime.MaskInput = "yyyy-mm-dd hh:mm";
            this.uldtEndTime.Name = "uldtEndTime";
            this.uldtEndTime.Size = new System.Drawing.Size(127, 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(884, 493);
            this.Controls.Add(this.ultraGrid1);
            this.Controls.Add(this.ultraGroupBox1);
            this.Name = "FrmIronEleQry";
            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 String strProduceSys = "";

        private void FrmIronEleQry_Load(object sender, System.EventArgs e)
        {
            this.uldtBeginTime.Value = DateTime.Today.ToString("yyyy-MM-dd") + " 00:00:00";
            this.uldtEndTime.Value = DateTime.Today.ToString("yyyy-MM-dd") + " 23:59:00";
            strProduceSys = this.CustomInfo;  //获取工序所属产线
            this.Text = strProduceSys + "#炼钢铁水成分查询";
            GetData();
            StartGetDataThread();
        }

        // 查询条件1
        /// <summary>
        /// 查询条件1
        /// </summary>
        /// <returns></returns>
        private string BuildSQLWhere1()
        {
            string sqlWhere = "";
            if (this.checkBox1.Checked && this.ultraMaskedEdit1.Text.Trim().Length > 0)
            {
                sqlWhere += string.Format("  and a.hudwid like '%{0}%'", this.ultraMaskedEdit1.Text.Trim());
            }
            sqlWhere += string.Format("  and to_char(b.ASSAYDATE, 'yyyyMMddHH24Miss') between '" + strStartTime + "' and '" + strEndTime + "'");
            
            return sqlWhere;
        }

        // 查询条件
        /// <summary>
        /// 查询条件
        /// </summary>
        /// <returns></returns>
        private string BuildSQLWhere()
        {
            string station = "";
            if (strProduceSys == "1")
            {
                station = "A01";
            }
            else
            {
                station = "A00";
            }
            string sqlWhere = " where stationcode='" + station + "'";
            if (this.checkBox1.Checked && this.ultraMaskedEdit1.Text.Trim().Length > 0)
            {
                sqlWhere += string.Format("  and heatno like '%{0}%'", this.ultraMaskedEdit1.Text.Trim());
            }
            sqlWhere += string.Format("  and to_char(ASSAYDATE, 'yyyyMMddHH24Miss') between '" + strStartTime + "' and '" + strEndTime + "'");

            return sqlWhere;
        }

        // 查询铁水成分
        /// <summary>
        /// 查询铁水成分
        /// </summary>
		private void GetData()
		{
            if (Convert.ToDateTime(uldtBeginTime.Value) > Convert.ToDateTime(uldtEndTime.Value))
            {
                MessageBox.Show("时间条件的开始时间不能大于结束时间！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                return;
            }
            else
            {
                strStartTime = this.uldtBeginTime.DateTime.ToString("yyyyMMddHHmmss");
                strEndTime = this.uldtEndTime.DateTime.ToString("yyyyMMddHHmmss");
            }
            if (checkBox1.Checked)
            {
                if (ultraMaskedEdit1.Text.Length == 0)
                {
                    MessageBox.Show("取样号不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    ultraMaskedEdit1.Focus();
                    return;
                }
            }
			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.ExecuteSortResultByQueryToDataTable(CCP_JJBQuery, CoreInvokeType.Internal);
				
				SetDataToGrid(dt);

			}
			catch {}
		}

        // 将查询的数据绑定到Grid
        /// <summary>
        /// 将查询的数据绑定到Grid
        /// </summary>
        /// <param name="dt"></param>
		private void SetDataToGrid(DataTable dt)
		{
			this.ultraDataSource1.Rows.Clear();
			if (dt == null) return;

			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(),
																   dr["C"].ToString(),
																   dr["SI"].ToString(),
																   dr["MN"].ToString(),
																   dr["P"].ToString(),
																   dr["S"].ToString(),
																   dr["Cu"].ToString(),
																   dr["Asn"].ToString(),
																   dr["Ti"].ToString()
															   });					
				}                         
				catch{}
			}
            //PublicMethod.RefreshAndAutoSize(ultraGrid1);
		}

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    GetData();
                    break;
                case "Export":
                    try
                    {
                       // Core.Mes.Client.Common.Globals.ulGridToExcel(ultraGrid1,Text);
                        GridHelper.ulGridToExcel(ultraGrid1, Text);
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message);
                    }
                    break;
                case "Exit":
                    this.Close();
                    break;
                default:
                    break;
            }
        }

        #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;
            if (chkRefresh.Checked)
            {
                checkBox1.Checked = false;
                checkBox1.Enabled = false;
            }
            else
            {
                checkBox1.Enabled = true;
            }
        }

        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 checkBox1_CheckedChanged(object sender, EventArgs e)
        {
            this.ultraMaskedEdit1.Enabled = this.checkBox1.Checked;
            if (!ultraMaskedEdit1.Enabled)
            {
                ultraMaskedEdit1.BackColor = Color.WhiteSmoke;
            }
        }
    }
}