XinYu_LG2MES/ClientSolution/Core.LgMes.Client.LgDeviceManager/出钢口/FrmToolBaseInfo.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using CoreFS.CA06;
//using Core.Mes.ClientFrameWork;

namespace Core.LgMes.Client.LgDeviceManager
{
    public partial class FrmToolBaseInfo : FrmBase
    {
        public FrmToolBaseInfo()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            FrmToolStuffBaseInfo fs = new FrmToolStuffBaseInfo();
            fs.Tag = this;
            fs.ShowDialog();
        }

        private void button2_Click(object sender, EventArgs e)
        {
            FrmToolRepairPositionInfo fr = new FrmToolRepairPositionInfo();
            fr.Tag = this;
            fr.dt  = (DataTable )  this.cboQToolType.DataSource;
            fr.ShowDialog();
        }
        private void InitCmbBox()
        {
            //初始化查询类别
            this.cboQType.Items.Clear();
            this.cboQType.Items.Add("材料基本信息");
            this.cboQType.Items.Add("维修位置信息");
            cboQType.SelectedIndex = 0;
            //初始化工器具类型
            this.cboQToolType.Items.Clear();
            Core.Mes.IBaseInterface.CallingMessage par = new Core.Mes.IBaseInterface.CallingMessage();
            par.AssemblyName = "Core.LgMes.Server.LgDeviceManager";
            par.ClassName = "Core.LgMes.Server.LgDeviceManager.LadleManager";
            par.ServerName = "LgDeviceManager";
            par.args = new object[] { "8001", "" };
            par.MethodName = "GetComboBoxData";
            

            System.Data.DataSet ds = new DataSet();
            string StrOut = "";
            object  ob = Core.Mes.ClientFrameWork.ClientCommon._RemotingHelp.ExecuteMethod(par, out StrOut);
            ds = (DataSet)ob;
           
            this.cboQToolType.DataSource = ds.Tables[0];
            this.cboQToolType.DisplayMember = "基础名称";
        }
        private void QueryData(string strType)
        {
            Core.Mes.IBaseInterface.CallingMessage par = new Core.Mes.IBaseInterface.CallingMessage();

            par.AssemblyName = "Core.LgMes.Server.LgDeviceManager";
            par.ClassName = "Core.LgMes.Server.LgDeviceManager.LadleManager";
            par.ServerName = "LgDeviceManager";
            par.MethodName = "ReturnTable";
            string SQL;
            if (strType == "材料基本信息")
            {
                SQL = "SELECT ItemTypeID AS 材料类型编号,ItemTypeName AS 材料类型名称,Factory AS 制造厂家,ToolType 工具类型,ParaID AS 参数类型编号,Memo AS 备注 FROM DEV_Item_Type_Info ";
            }
            else
            {
                SQL = "SELECT  ItemTypeID AS 材料类型编号,ToolPos AS 适用工具位置, ToolType AS 工具类型,Memo as 备注 " +
                        " FROM DEV_Item_In_Tool_Pos ";

            }
            if (this.chkQToolType.Checked)
            {
                SQL = SQL + " WHERE tooltype='" + this.cboQToolType.Text.Replace("'", "''") + "'";
            }
            SQL += " order by ToolType ";
            par.args = new object[] { SQL };
            string StrOut = "";

            object obj = Core.Mes.ClientFrameWork.ClientCommon._RemotingHelp.ExecuteMethod(par, out StrOut);
            DataSet ds = (DataSet)obj;
            this.ulgrid.DataSource = ds;

            ulgrid.DataBind();
            if (ulgrid.Rows.Count > 0)
            {
                //this.ulgrid.Selected.Rows.AddRange(this.ulgrid.Rows.GetRowAtVisibleIndex(0));
                this.ulgrid.ActiveRow = this.ulgrid.Rows.GetRowAtVisibleIndex(0);
                
            }
        }
        private void FrmToolBaseInfo_Load(object sender, EventArgs e)
        {
            this.InitCmbBox();           
        }

        private void btnQuery_Click(object sender, EventArgs e)
        {
            this.QueryData(this.cboQType.SelectedItem.ToString() );
        }

        private void chkQToolType_CheckedChanged(object sender, EventArgs e)
        {
            if (chkQToolType.Checked)
            {
                cboQToolType.Enabled = true;
            }
            else
            {
                cboQToolType.Enabled = false;
            }
        }

        private void ulgrid_InitializeLayout(object sender, Infragistics.Win.UltraWinGrid.InitializeLayoutEventArgs e)
        {

        }
    }
}