using System; using System.Drawing; using System.Collections; using System.ComponentModel; using System.Windows.Forms; using System.Data; using CoreFS.CA06; using Infragistics.Win; using Infragistics.Win.UltraWinGrid; namespace Core.LgMes.Client.LgIntegrationQuery { /// /// ElementsForm 的摘要说明。 /// public class frmLgEleConfig : Core.Mes.Client.Common.frmStyleBase { private System.Data.DataSet dataSet1; private System.Data.DataTable dataTable1; private System.Data.DataColumn dataColumn1; private System.Data.DataColumn dataColumn2; private System.Data.DataColumn dataColumn3; private System.ComponentModel.IContainer components; public static string StrHic; public static string StrT; private UltraGrid ultraGrid1; private string m_szGW = ""; public static string szEleStd = ""; private Infragistics.Win.Misc.UltraGroupBox ultraGroupBox1; private Label lblSteel; private Label lblHeatID; private Label label2; private Label label1; private DataColumn dataColumn4; //化学成分标准列名 public static string strSteelCode = ""; public string Hic { get { return StrHic; } set { StrHic=value; } } public string Bzhi { get { return StrT; } set { StrT=value; } } public frmLgEleConfig( string StrHic, string StrT, string szGW) { // // Windows 窗体设计器支持所必需的 // InitializeComponent(); //this.Remoting =Remotingh; this.Hic=StrHic; this.Bzhi=StrT; m_szGW = szGW; } /// /// 清理所有正在使用的资源。 /// protected override void Dispose( bool disposing ) { if( disposing ) { if(components != null) { components.Dispose(); } } base.Dispose( disposing ); } #region Windows 窗体设计器生成的代码 /// /// 设计器支持所需的方法 - 不要使用代码编辑器修改 /// 此方法的内容。 /// private void InitializeComponent() { Infragistics.Win.Appearance appearance1 = new Infragistics.Win.Appearance(); Infragistics.Win.UltraWinGrid.UltraGridBand ultraGridBand1 = new Infragistics.Win.UltraWinGrid.UltraGridBand("Table1", -1); Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn1 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("序号"); Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn2 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("项目名称"); Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn3 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("标准范围"); Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn4 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("std_dc"); this.dataSet1 = new System.Data.DataSet(); this.dataTable1 = new System.Data.DataTable(); this.dataColumn1 = new System.Data.DataColumn(); this.dataColumn2 = new System.Data.DataColumn(); this.dataColumn3 = new System.Data.DataColumn(); this.dataColumn4 = new System.Data.DataColumn(); this.ultraGrid1 = new Infragistics.Win.UltraWinGrid.UltraGrid(); this.ultraGroupBox1 = new Infragistics.Win.Misc.UltraGroupBox(); this.lblSteel = new System.Windows.Forms.Label(); this.lblHeatID = new System.Windows.Forms.Label(); this.label2 = new System.Windows.Forms.Label(); this.label1 = new System.Windows.Forms.Label(); ((System.ComponentModel.ISupportInitialize)(this.dataSet1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dataTable1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.ultraGrid1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.ultraGroupBox1)).BeginInit(); this.ultraGroupBox1.SuspendLayout(); this.SuspendLayout(); // // dataSet1 // this.dataSet1.DataSetName = "NewDataSet"; this.dataSet1.Locale = new System.Globalization.CultureInfo("zh-CN"); this.dataSet1.Tables.AddRange(new System.Data.DataTable[] { this.dataTable1}); // // dataTable1 // this.dataTable1.Columns.AddRange(new System.Data.DataColumn[] { this.dataColumn1, this.dataColumn2, this.dataColumn3, this.dataColumn4}); this.dataTable1.TableName = "Table1"; // // dataColumn1 // this.dataColumn1.ColumnName = "序号"; // // dataColumn2 // this.dataColumn2.ColumnName = "项目名称"; // // dataColumn3 // this.dataColumn3.ColumnName = "标准范围"; // // dataColumn4 // this.dataColumn4.Caption = "标准类型"; this.dataColumn4.ColumnName = "std_dc"; // // ultraGrid1 // this.ultraGrid1.DataMember = "Table1"; this.ultraGrid1.DataSource = this.dataSet1; appearance1.BackGradientStyle = Infragistics.Win.GradientStyle.None; this.ultraGrid1.DisplayLayout.Appearance = appearance1; ultraGridColumn1.CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultraGridColumn1.Header.VisiblePosition = 0; ultraGridColumn1.Hidden = true; ultraGridColumn1.Width = 42; ultraGridColumn2.Header.VisiblePosition = 1; ultraGridColumn2.RowLayoutColumnInfo.PreferredCellSize = new System.Drawing.Size(60, 0); ultraGridColumn3.CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultraGridColumn3.Header.VisiblePosition = 2; ultraGridColumn3.RowLayoutColumnInfo.PreferredCellSize = new System.Drawing.Size(103, 0); ultraGridColumn3.Width = 117; ultraGridColumn4.Header.VisiblePosition = 3; ultraGridColumn4.RowLayoutColumnInfo.PreferredCellSize = new System.Drawing.Size(74, 0); ultraGridBand1.Columns.AddRange(new object[] { ultraGridColumn1, ultraGridColumn2, ultraGridColumn3, ultraGridColumn4}); ultraGridBand1.RowLayoutStyle = Infragistics.Win.UltraWinGrid.RowLayoutStyle.ColumnLayout; this.ultraGrid1.DisplayLayout.BandsSerializer.Add(ultraGridBand1); this.ultraGrid1.Dock = System.Windows.Forms.DockStyle.Fill; this.ultraGrid1.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.ultraGrid1.Location = new System.Drawing.Point(0, 49); this.ultraGrid1.Name = "ultraGrid1"; this.ultraGrid1.Size = new System.Drawing.Size(298, 304); this.ultraGrid1.TabIndex = 6; // // ultraGroupBox1 // this.ultraGroupBox1.Controls.Add(this.lblSteel); this.ultraGroupBox1.Controls.Add(this.lblHeatID); this.ultraGroupBox1.Controls.Add(this.label2); this.ultraGroupBox1.Controls.Add(this.label1); 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(298, 49); this.ultraGroupBox1.TabIndex = 7; // // lblSteel // this.lblSteel.AutoSize = true; this.lblSteel.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.lblSteel.ForeColor = System.Drawing.Color.Blue; this.lblSteel.Location = new System.Drawing.Point(191, 18); this.lblSteel.Name = "lblSteel"; this.lblSteel.Size = new System.Drawing.Size(0, 12); this.lblSteel.TabIndex = 3; // // lblHeatID // this.lblHeatID.AutoSize = true; this.lblHeatID.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.lblHeatID.ForeColor = System.Drawing.Color.Blue; this.lblHeatID.Location = new System.Drawing.Point(63, 18); this.lblHeatID.Name = "lblHeatID"; this.lblHeatID.Size = new System.Drawing.Size(0, 12); this.lblHeatID.TabIndex = 2; // // label2 // this.label2.AutoSize = true; this.label2.Location = new System.Drawing.Point(150, 18); this.label2.Name = "label2"; this.label2.Size = new System.Drawing.Size(41, 12); this.label2.TabIndex = 1; this.label2.Text = "钢种:"; // // label1 // this.label1.AutoSize = true; this.label1.Location = new System.Drawing.Point(21, 18); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(41, 12); this.label1.TabIndex = 0; this.label1.Text = "炉号:"; // // frmLgEleConfig // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F); this.ClientSize = new System.Drawing.Size(298, 353); this.Controls.Add(this.ultraGrid1); this.Controls.Add(this.ultraGroupBox1); this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedDialog; this.MaximizeBox = false; this.MinimizeBox = false; this.Name = "frmLgEleConfig"; this.SizeGripStyle = System.Windows.Forms.SizeGripStyle.Show; this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen; this.Text = "成分标准"; this.Load += new System.EventHandler(this.ElementsForm_Load); ((System.ComponentModel.ISupportInitialize)(this.dataSet1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dataTable1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.ultraGrid1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.ultraGroupBox1)).EndInit(); this.ultraGroupBox1.ResumeLayout(false); this.ultraGroupBox1.PerformLayout(); this.ResumeLayout(false); } #endregion private void ElementsForm_Load(object sender, System.EventArgs e) { lblHeatID.Text = StrHic.Substring(0, 10); lblSteel.Text = strSteelCode; //this.RemotingHelp =Remoting; GetTAM_StandardElement(); //ElementsForm.ActiveForm .WindowState =0; //ElementsForm.ActiveForm.StartPosition =System.Windows .Forms .FormStartPosition.CenterParent; // ElementsForm.ActiveForm.Width =224; // ElementsForm.ActiveForm.Height =360; } public void GetTAM_StandardElement()/// 查询判定牌号成分 { string err = ""; string szWhere = ""; object obj = new object(); szWhere = Hic.Substring(0, 10); //条件 string szCrfStd = "('L02001','L02005') "; if (!string.IsNullOrEmpty(szEleStd)) { szEleStd = "('" + szEleStd.Substring(3, szEleStd.Length - 3) + "')"; //获取成分标准 obj = null;//hengxing ClientCommon._RemotingHelp.ExecuteMethod("lgJobMgt", // "Core.LgMes.Server.lgJobMgt.classCommonModule", // "GetProcStandardValue", new object[] { szWhere, szEleStd, szCrfStd }, out err); } if (err != "") { MessageBox.Show(err); } else if (obj != null) { ArrayList ar = new ArrayList(); ar = obj as ArrayList; DataSet dsStandard = ar[0] as DataSet; if (dsStandard.Tables[0].Rows.Count > 0) { int RowId = 1; DataRow newRow = null;//dataTable1.NewRow(); foreach (DataRow Drow in dsStandard.Tables[0].Rows) { newRow = dataTable1.NewRow(); newRow[0] = RowId; newRow[1] = Drow["basename"].ToString(); if (Drow["ITEM1MIN"].ToString() != "" && Drow["ITEM1MAX"].ToString() != "") newRow[2] = Drow["ITEM1MIN"].ToString() + " - " + Drow["ITEM1MAX"].ToString(); else if (Drow["ITEM1MIN"].ToString() != "" && Drow["ITEM1MAX"].ToString() == "") newRow[2] = "> " + Drow["ITEM1MIN"].ToString(); else if (Drow["ITEM1MIN"].ToString() == "" && Drow["ITEM1MAX"].ToString() != "") newRow[2] = "≤ " + Drow["ITEM1MAX"].ToString(); newRow[3] = Drow["std_dc"].ToString() == "1" ? "国标" : "内控"; dataTable1.Rows.Add(newRow); RowId++; } } } } private void ultraGrid1_InitializeLayout(object sender, Infragistics.Win.UltraWinGrid.InitializeLayoutEventArgs e) { ultraGrid1.DisplayLayout .Bands [0].Columns [0].Width =30; ultraGrid1.DisplayLayout .Bands [0].Columns [1].Width =40; ultraGrid1.DisplayLayout .Bands [0].Columns [2].Width =120; } } }