XinYu_LG2MES/ClientSolution/Core.LgMes.Client.LgJobMgt/弹出窗体/frmMtrBatchChem.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 System.IO;
using Infragistics.Win.UltraWinGrid;

namespace Core.LgMes.Client.LgJobMgt
{
    public partial class frmMtrBatchChem : Form
    {
        public frmMtrBatchChem(string strMaterielCode,string strMsnumId, string strStationCode)
        {
            InitializeComponent();
            _strMsnumId = strMsnumId;
            _strStationCode = strStationCode;
            _strMaterielCode = strMaterielCode;
        }

        private string _strMsnumId;
        private string _strStationCode;
        private string _strMaterielCode;

        /// <summary>
        /// 获取料仓物料批次信息
        /// </summary>
        /// <param name="szWhere"></param>
        private void GetDataSource(string szWhere)
        {
            string szOut = "";
            dataSet1.Tables[0].Clear();
            object obj = null;// RemotingHelp.ExecuteMethod(
                              //     "lgIntegrationQuery",
                              //     "Core.LgMes.Server.lgIntegrationQuery.LgGeneralInfo",
                             //      "GetMaterielBatchChem", new object[] { szWhere }, out szOut);

            if (szOut == "" && obj != null)
            {
                DataTable dw = ((DataSet)obj).Tables[0];

                int i;

                for (i = 0; i < dw.Rows.Count; i++)//dataTable1.Rows.Count; i++)
                {
                    DataRow dr = dataTable1.NewRow();
                    dr["Flag"] = false;
                    dr["MaterielCode"] = dw.Rows[i]["MaterielCode"];
                    dr["MaterielName"] = dw.Rows[i]["MaterielName"];
                    dr["MaterielforShort"] = dw.Rows[i]["MaterielName"];
                    dr["MaterielType"] = dw.Rows[i]["MaterielType"];
                    dr["BATCHNO"] = dw.Rows[i]["BATCHNO"];
                    dr["inweight"] = dw.Rows[i]["inweight"];
                    dr["C"] = dw.Rows[i]["C"];
                    dr["SI"] = dw.Rows[i]["SI"];
                    dr["MN"] = dw.Rows[i]["MN"];
                    dr["P"] = dw.Rows[i]["P"];
                    dr["S"] = dw.Rows[i]["S"];
                    dr["Asn"] = dw.Rows[i]["Asn"];
                    dr["surplus"] = dw.Rows[i]["surplus"];
                    dataTable1.Rows.Add(dr);
                }
            }
        }
                        
        private void frmScrapSteel_Load(object sender, EventArgs e)
        {
            string strWhere = "";
            strWhere = " and  msnumid  =  '" + _strMsnumId + "' and  t.materielcode  =  '" + _strMaterielCode + "' and craftposid='" + _strStationCode + "' and SURPLUS > 0";
            GetDataSource(strWhere);
        }
    }
}