using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using CoreFS.CA06; using Infragistics.Win.UltraWinGrid; namespace Core.LZMes.Client.UIB { public partial class UIB030130 : FrmBase { public UIB030130() { InitializeComponent(); } public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "Query": this.DoQuery(); break; } } private void DoQuery() { int initTableCount = 5;//dataTable1初始有5列 //清除datatable中查询时增加的列 if (this.dataTable1.Columns.Count > initTableCount) { for (int i = this.dataTable1.Columns.Count; i > initTableCount; i--) this.dataSet1.Tables[0].Columns.Remove(this.dataTable1.Columns[i - 1]); } if (this.comboBox3.Text == "") { MessageBox.Show("请选择产线!", "提示"); return; } this.dataSet1.Tables[0].Clear(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.UIB03.UIB030130"; ccp.MethodName = "queryCoilQltyValue"; ccp.ServerParams = new object[] { this.ultraDateTimeEditor1.DateTime.ToString("yyyyMMdd") + "000000" , this.ultraDateTimeEditor2.DateTime.ToString("yyyyMMdd") + "999999",this.comboBox3.Text}; ccp.SourceDataTable = this.dataSet1.Tables[0]; this.ExecuteQueryToDataTable(ccp , CoreInvokeType.Internal); //设置新查询出来的列为不可编辑 for (int i = initTableCount; i < this.dataTable1.Columns.Count; i++) { this.ultraGrid1.DisplayLayout.Bands[0].Columns[i].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; this.ultraGrid1.DisplayLayout.Bands[0].Columns[i].Width = 80;//设置列宽 } } private void UIB030130_Load(object sender, EventArgs e) { this.comboBox3.SelectedIndex = 0; } } }