XinYu_LZMES_Client/Core.LZMes.Client.UIB/B03/UIB030130.cs

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