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

namespace bizFacade
{
    partial class BaseDataSystemMES
    {
        /// <summary>
        /// [MES_计划BOM_发动机号]
        /// SET 是否装配代码=1
        /// </summary>
        /// <returns></returns>
        public static bool BaseData_tagTable_EngineID_UpDate(string EngineID)
        {
            string sql;
            sql = "UPDATE MES_计划BOM_发动机号 "
                + "SET 是否装配代码=1"
                + " ,装配日期=CDATE('" + DateTime.Now.ToString("G") 
                + "') "
                + " WHERE 发动机号='" + EngineID + "'";
            return DataAccess.ExecuteSQL_OleDb_Access(sql);
        }

        /// <summary>
        /// [MES_装配数据_工件到位离开时间_保留本地]
        /// 计算当前日期装配的发动机数量
        /// </summary>
        /// <returns></returns>
        public static int BaseData_tagTable_EngineID_Count()
        {
            int count;
            string sql;
            sql = "SELECT COUNT(*) FROM  [MES_装配数据_工件到位离开时间_保留本地] "
                + "WHERE 计数日期=CDATE('" + DateTime.Now.ToString("d") + "')"
                + " AND 是否合格 = 1";
            DataAccess.ExecuteOutNum_OleDb_Access(sql, out  count);
            return count;
        }


        //static public void ProduceCountInsert()
        //{
        //    string sql;
        //    sql = "INSERT INTO MES_装配数据_实际产量(实际产量) VALUES(1)";
        //    DataAccess.ExecuteSQL_OleDb_Access(sql);
        //}        
        //static public void ProduceCountDelete()
        //{
        //    string sql;
        //    sql = "DELETE FROM MES_装配数据_实际产量 WHERE 生产日期<>CDATE('" + DateTime.Now.ToString("d") + "')";
        //    DataAccess.ExecuteSQL_OleDb_Access(sql);
        //}
        //static public void ProduceCountSelect(out DataTable dt)
        //{
        //    string sql;
        //    sql = "SELECT * FROM MES_装配数据_实际产量 WHERE 生产日期=CDATE('" + DateTime.Now.ToString("d") + "')";
        //    DataAccess.ExecuteDataTable_OleDb_Access(sql, out dt);
        //}
        //static public void ProduceCountUpdate(int count)
        //{
        //    string sql;
        //    sql = "UPDATE MES_装配数据_实际产量 "
        //        + " SET 实际产量=" + count.ToString()
        //    + " WHERE 生产日期=CDATE('" + DateTime.Now.ToString("d") + "')";
        //    DataAccess.ExecuteSQL_OleDb_Access(sql);
        //}
    }
}