using System;
using System.Data;
using System.Data.SqlClient;
using DataLinkMesWork;
using System.Collections;
using System.Collections.Specialized;
using SystemFramework;

namespace bizFacade
{
    /// <summary>
    /// 电子看板信息系统
    /// </summary>
    public partial class BaseDataSystemMES
    {
        
        /// <summary>
        /// 测量数据合格索引_分线数据_删除
        /// </summary>
        /// <param name="engineID"></param>
        /// <param name="opName"></param>
        /// <returns></returns>
        public static bool BaseData_tagTable_QualityData_B5A_SubTable_Delete
                                                    (string engineID,string opName)
        {
            string procedureName;
            procedureName = "测量数据合格索引_分线数据_删除";
            SqlParameter[] thisParms = new SqlParameter[2];
            thisParms[0] = new System.Data.SqlClient.SqlParameter("@EngineID", engineID);
            thisParms[1] = new System.Data.SqlClient.SqlParameter("@工位号", opName);
            return DataAccess.ExecuteStoredProcedure(procedureName, ref  thisParms);
        }

       
        /// <summary>
        /// alter     PROCEDURE [dbo].[测量数据合格_手动拧紧_增加]
        ///@EngineTypeID int =null,
        ///@EngineType nvarchar(50)=null,
        ///@EngineID nvarchar(100)=null,
        ///@TagValue nvarchar(100)=null,
        ///@合格标志 int=null,
        ///@工位号 nvarchar(50)=null,
        ///@托盘编号 nvarchar(50)=null,
        ///@TagID int=null,
        ///@TagID_CF int=null
        /// </summary>
        /// <param name="engineTypeID"></param>
        /// <param name="engineType"></param>
        /// <param name="engineID"></param>
        /// <param name="tagValue"></param>
        /// <param name="isGoodBad"></param>
        /// <param name="opName"></param>
        /// <param name="partPallet"></param>
        /// <param name="tagID"></param>
        /// <param name="tagID_CF"></param>
        /// <returns></returns>
        public static bool BaseData_tagTable_QualityData_B5A_Insert
(int engineTypeID, string engineType, string engineID,
            string tagValue, int isGoodBad,
            string opName, string partPallet, int tagID, int tagID_CF)
        {
            string procedureName;
            procedureName = "测量数据合格_手动拧紧_增加";
            SqlParameter[] thisParms = new SqlParameter[9];
            thisParms[0] = new System.Data.SqlClient.SqlParameter("@EngineTypeID", engineTypeID);
            thisParms[1] = new System.Data.SqlClient.SqlParameter("@EngineType", engineType);
            thisParms[2] = new System.Data.SqlClient.SqlParameter("@EngineID", engineID);
            thisParms[3] = new System.Data.SqlClient.SqlParameter("@TagValue", tagValue);
            thisParms[4] = new System.Data.SqlClient.SqlParameter("@合格标志", isGoodBad);
            thisParms[5] = new System.Data.SqlClient.SqlParameter("@工位号", opName);
            thisParms[6] = new System.Data.SqlClient.SqlParameter("@托盘编号", partPallet);
            thisParms[7] = new System.Data.SqlClient.SqlParameter("@TagID", tagID);
            thisParms[8] = new System.Data.SqlClient.SqlParameter("@TagID_CF", tagID_CF);
            return DataAccess.ExecuteStoredProcedure(procedureName, ref  thisParms);
        }
      
        /// <summary>
        /// ALTER           PROCEDURE [dbo].[电子看板_发动机号_总合格标志_增加] 
        ///@工位号 nvarchar(50) = null,
        ///@发动机号 nvarchar(50) = null,
        ///@合格标志 int = 0测量数据合格索引_增加
        ///0合格；1不合格
        /// </summary>
        /// <param name="opName"></param>
        /// <param name="EngineID"></param>
        /// <param name="isOK"></param>
        /// <returns></returns>
        public static bool BaseData_tagTable_Engine_IsOK_Insert
            (string opName, string EngineID, int isOK)
        {
            string procedureName;
            procedureName = "电子看板_发动机号_总合格标志_增加";
            SqlParameter[] thisParms = new SqlParameter[3];
            thisParms[0] = new System.Data.SqlClient.SqlParameter("@工位号", opName);
            thisParms[1] = new System.Data.SqlClient.SqlParameter("@发动机号", EngineID);
            thisParms[2] = new System.Data.SqlClient.SqlParameter("@合格标志", isOK);

            if (DataAccess.ExecuteStoredProcedure(procedureName, ref thisParms))
            {
                return true;
            }
            return false;
        }
        

        /// <summary>
        /// 电子看板_发动机号_不合格放行_查询
        /// </summary>
        /// <param name="opName"></param>
        /// <param name="EngineID"></param>
        /// <param name="dt"></param>
        /// <returns></returns>
        public static bool BaseData_tagTable_Engine_IsNG_Select
    (string opName, string EngineID, out DataTable  dt)
        {
            string procedureName;
            procedureName = "电子看板_发动机号_不合格放行_查询";
            SqlParameter[] thisParms = new SqlParameter[2];
            thisParms[0] = new System.Data.SqlClient.SqlParameter("@工位号", opName);
            thisParms[1] = new System.Data.SqlClient.SqlParameter("@发动机号", EngineID);

            if (DataAccess.ExecuteStoredProcedure(procedureName, ref thisParms,out dt))
            {
                if (dt != null)
                {
                    if(dt.Rows.Count==1)
                        return true;
                }
                return false;
            }
            return false;
        }
        /// <summary>
        /// 电子看板_发动机号_不合格放行_增加
        /// </summary>
        /// <param name="opName"></param>
        /// <param name="EngineID"></param>
        /// <param name="worker"></param>
        /// <param name="text"></param>
        /// <returns></returns>
        public static bool BaseData_tagTable_Engine_IsNG_Insert
    (string opName, string EngineID, string worker,string text)
        {
            string procedureName;
            procedureName = "电子看板_发动机号_不合格放行_增加";
            SqlParameter[] thisParms = new SqlParameter[4];
            thisParms[0] = new System.Data.SqlClient.SqlParameter("@工位号", opName);
            thisParms[1] = new System.Data.SqlClient.SqlParameter("@发动机号", EngineID);
            thisParms[2] = new System.Data.SqlClient.SqlParameter("@操作者编号", worker);
            thisParms[3] = new System.Data.SqlClient.SqlParameter("@不合格原因", text);

            if (DataAccess.ExecuteStoredProcedure(procedureName, ref thisParms))
            {
                return true;
            }
            return false;
        }
        /// <summary>
        /// 电子看板_发动机号_不合格放行_删除
        /// </summary>
        /// <param name="opName"></param>
        /// <param name="EngineID"></param>
        /// <returns></returns>
        public static bool BaseData_tagTable_Engine_IsNG_Delete
(string opName, string EngineID)
        {
            string procedureName;
            procedureName = "电子看板_发动机号_不合格放行_删除";
            SqlParameter[] thisParms = new SqlParameter[2];
            thisParms[0] = new System.Data.SqlClient.SqlParameter("@工位号", opName);
            thisParms[1] = new System.Data.SqlClient.SqlParameter("@发动机号", EngineID);

            return DataAccess.ExecuteStoredProcedure(procedureName, ref thisParms);
        }
        

    }
}