using System;
using System.Collections.Generic;
using System.Text;
using System.Collections;

using System.Data;
using System.Data.SqlClient;
using DataLinkMesWork;
//using BizDataAccess;

namespace MesServerFunctions
{
    partial class Functions_BASE_10
    {
        //针对“MIS.BizFacade.Dll”中没有的存储过程，在此类中新建
        //新建原则：所有的函数用private,只允许在内部使用
        //针对单个工艺特殊，需要新建存储过程，但是存储过程不能被加入到“MIS.BizFacade.Dll”中

//        DataTable dt_main;
//        BaseDataSystemMES.MaterialMain_Select(OpName, EngineType, out  dt_main);
//                            for (int i = 0; i<dt_main.Rows.Count; i++)
//                            {
//                                string MainMaterial = dt_main.Rows[i]["物料条码"].ToString();

//        BaseDataSystemMES.MailLineAndSubLineData_Insert(EngineID, EngineTypeID, EngineType, MainMaterial);
//                            }

        //返修上线与正常上线区分字段 true 为正常上线  False 为返修上线
        bool IsRepaireStatus = false;


        public bool SelectRepairBarcode(string OpName, string QRcode, out string barcode, out string enigetype)
        {

            barcode = "";
            enigetype = "";
            string procedureName = "电子看板_发动机号_返修线首工位_查询工件编号";
            SqlParameter[] thisParms = new SqlParameter[4];
            thisParms[0] = new System.Data.SqlClient.SqlParameter("@工位号", OpName);
            thisParms[1] = new System.Data.SqlClient.SqlParameter("@barcode_QR", QRcode);
            thisParms[2] = new System.Data.SqlClient.SqlParameter("@barcode", SqlDbType.NVarChar, 50, "barcode");
            thisParms[3] = new System.Data.SqlClient.SqlParameter("@enigetype", SqlDbType.NVarChar, 50, "enigetype");
            thisParms[2].Direction = ParameterDirection.Output;
            thisParms[3].Direction = ParameterDirection.Output;
            if (DataAccess.ExecuteStoredProcedure(procedureName, ref thisParms))
            {
                if (thisParms[2].Value != null)
                {
                    barcode = thisParms[2].Value.ToString();
                    enigetype = thisParms[3].Value.ToString();
                    return true;
                }
                else
                {
                    barcode = "-1";
                    enigetype = "-1";
                    return false;
                }
            }
            else
            {
                return false;
            }

        }

        /// <summary>
        /// 返修上线_返修工位及返修路径_查询
        /// </summary>
        /// <param name="engineID"></param>
        /// <param name="dt"></param>
        static public void GetEngineID_RepairSelect(string engineID, out DataTable dt)
        {
            string procedureName;
            procedureName = "返修上线_返修工位及返修路径_查询";
            SqlParameter[] thisParms = new SqlParameter[1];
            thisParms[0] = new System.Data.SqlClient.SqlParameter("@总成编号", engineID);
            DataAccess.ExecuteStoredProcedure(procedureName, ref thisParms, out dt);
        }

    }
}