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