using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using DataLinkMesWork;
using System.Security.Cryptography;
//using SystemFramework;

namespace bizFacade
{
    public partial class MES1
    {
        /// <summary>
        /// 测量数据工位_监控系统_MOBY_查询
        /// </summary>
        /// <param name="opName"></param>
        /// <param name="IsAllowWork"></param>
        /// <returns></returns>
        public static void Moby_Select(string opName, out string OrderForm,
            out int EngineTypeID, out string EngineType, out string EngineID, out string PartPallet_Code,
            out int IsrepairBarcode, out string repairBarcode)
        {
            DataTable dt= new DataTable();
            OrderForm = "";
            EngineTypeID = 0;
            EngineType = "";
            EngineID = "";
            PartPallet_Code = "";
            IsrepairBarcode = 0;
            repairBarcode = "";
            try
            {
                string procedureName;
                procedureName = "北汽福田工位状态监控MOBY_查询_订单下达用";
                SqlParameter[] thisParms = new SqlParameter[1];
                thisParms[0] = new System.Data.SqlClient.SqlParameter("@工位号", opName);

                DataAccess.ExecuteStoredProcedure(procedureName, ref thisParms,out dt);
                if(dt.Rows.Count > 0 )
                {
                    OrderForm = dt.Rows[0][MobyTagType.OrderForm_MES].ToString();
                    EngineTypeID = Convert.ToInt32(dt.Rows[0][MobyTagType.EngineTypeID_MES]); ;
                    EngineType = dt.Rows[0][MobyTagType.EngineType_MES].ToString();
                    EngineID = dt.Rows[0][MobyTagType.EngineID_MES].ToString();
                    PartPallet_Code = dt.Rows[0][MobyTagType.PartPallet_Code].ToString();
                }
            }
            catch
            {
                OrderForm = "";
                EngineTypeID = 0;
                EngineType = "";
                EngineID = "";
                PartPallet_Code = "";
                IsrepairBarcode = 0;
                repairBarcode = "";
            }
        }
    }
}