XinYu_LG2MES/ClientSolution/Core.LgMes.Client.LgDeviceManager/.svn/text-base/FrmToolBaseInfoNew.cs.svn-base

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 Core.Mes.ClientFrameWork;

namespace Core.LgMes.Client.LgDeviceManager
{
    public partial class FrmToolBaseInfoNew : Form
    {
        public FrmToolBaseInfoNew()
        {
            InitializeComponent();
        }
        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 = null;// 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 btnQuery_Click(object sender, EventArgs e)
        {
            this.QueryData(this.cboQType.SelectedItem.ToString());
        }

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

        private void btnRepairPos_Click(object sender, EventArgs e)
        {
            //FrmToolRepairPositionInfo fr = new FrmToolRepairPositionInfo();
            //fr.Tag = this;
            //fr.dt = (DataTable)this.cboQToolType.DataSource;
            //fr.ShowDialog();
        }

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