XinYu_ZHBMES_BJNEWS/Client/Core.XgMes.Client.JGKC.MaterialManager/FrmMaterialLBDaioage.cs

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using Core.Mes.ClientFrameWork;
using Core.Mes.IBaseInterface;
using System.Data;
using System.Runtime.InteropServices;
using Core.XgMes.Client.JGKC.TurnoffSendManager;
namespace Core.XgMes.Client.JGKC.MaterialManager
{
    public partial class FrmMaterialLBDaioage : Mes.ClientFrameWork.FrmBase
    {

        public string strwzdm = "";
        public string strwzmc = "";
        public string strgg = "";
        public string strcz = "";
        public string strjldw = "";
        public string strdz = "";
        public string strckcode = "";
        public string strckmc = "";
        public string strcklb = "";
        public FrmMaterialLBDaioage()
        {
            InitializeComponent();
        }
        public void Init()
        {
            string err = "";
            string sql = "SELECT MATERIAL__LB_CODE,MATERIAL__LB_NAME FROM MATERIA_LBL_CODE_MANAGE ";
            DataSet ds = (DataSet)ClientCommon._RemotingHelp.ExecuteMethod("BJZWStuff", "Core.XgMes.Server.JGKC.SteelPlateManager.Common", "GetDataSet", new object[] { sql }, out err);
            if (err == "")
            {
                ultraGrid1.DataSource = ds;
            }
        }

        private void btnQR_Click(object sender, EventArgs e)
        {
         
           Infragistics.Win.UltraWinGrid.UltraGridRow row = ultraGrid1.ActiveRow;
           if (row.Selected) return;
           strwzdm = row.Cells["MATERIAL__LB_CODE"].Value.ToString();
           strwzmc = row.Cells["MATERIAL__LB_NAME"].Value.ToString();
          /*strgg = row.Cells["SPEC"].Value.ToString();
          strcz = row.Cells["MATERIAL"].Value.ToString();
          strjldw = row.Cells["UNITS"].Value.ToString();
          strdz = row.Cells["SUBSTANCE"].Value.ToString();
          strckcode = row.Cells["DEPOTID"].Value.ToString();
          strckmc = row.Cells["DEPOTNAME"].Value.ToString();
          strcklb = row.Cells["STOCK_CODE"].Value.ToString();*/
           this.Close();
        }

        private void FrmMaterialLBDaioage_Load(object sender, EventArgs e)
        {
            Init();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            string strWhere = "";
            string sql = "";
            string err = "";
            if (Chk_WZDM.Checked && txt_wzdm.Text.Trim().Length > 0)
            {
                strWhere += " AND MATERIAL__LB_CODE LIKE '%" + txt_wzdm.Text.Trim().ToString() + "%' ";
            }
            if (chk_wz.Checked && txt_wz.Text.Trim().Length > 0)
            {
                strWhere += " AND MATERIAL__LB_NAME LIKE '%" + txt_wz.Text.Trim().ToString() + "%' ";
            }
            sql = "SELECT MATERIAL__LB_CODE,MATERIAL__LB_NAME FROM MATERIA_LBL_CODE_MANAGE" + strWhere
                        + " ORDER BY MATERIAL__LB_NAME  ASC ";
            DataSet ds = (DataSet)ClientCommon._RemotingHelp.ExecuteMethod("BJZWStuff", "Core.XgMes.Server.JGKC.SteelPlateManager.Common", "GetDataSet", new object[] { sql }, out err);
            if (err == "")
            {
                ultraGrid1.DataSource = ds;
            }
        }

        private void Chk_WZDM_CheckedChanged(object sender, EventArgs e)
        {
            txt_wzdm.Enabled = Chk_WZDM.Checked;
        }

        private void chk_wz_CheckedChanged(object sender, EventArgs e)
        {
            txt_wz.Enabled = chk_wz.Checked;
        }
    }
}