using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Data.OleDb;
using DataLinkMesWork;


using SystemFramework;

namespace bizFacade
{
    public partial class BaseDataSystemMES
    {
        /// <summary>
        /// 1、测试发动机号合理：在表[MES_计划BOM_发动机号]中存在
        /// SELECT COUNT(*) FROM MES_计划BOM_发动机号
        /// Access
        /// </summary>
        /// <param name="EngineID"></param>
        /// <param name="count"></param>
        /// <returns></returns>
        public static bool EngineID_Select_Count(string EngineID, out int count)
        {
            count = 0;
            string sql;
            sql = "SELECT COUNT(*) FROM MES_计划BOM_发动机号 "
                + " WHERE 发动机号 = '" + EngineID + "'";
            return DataAccess.ExecuteOutNum_OleDb_Access(sql, out count);
        }



        /// <summary>
        /// 根据订单号，确定订单基本内容
        /// 返回订单对应的一行记录
        /// [MES_计划BOM_订单计划下达]
        /// Access 数据库
        /// </summary>
        /// <param name="orderFrom"></param>
        /// <param name="dt"></param>
        /// <returns></returns>
        public static bool FirstOpNameTableGetOrderFormOnlyOneLine(string orderFrom,out DataTable dt)
        {
            string sql;
            sql = "SELECT TOP 1 * FROM [MES_计划BOM_订单计划下达]"
                + " WHERE 订单号='" + orderFrom + "'";
            return DataAccess.ExecuteDataTable_OleDb_Access(sql, out dt);
        }
    }
}