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>
        /// 
        /// </summary>
        /// <param name="lineType"></param>
        /// <param name="transferLineType"></param>
        /// <param name="dt"></param>
        //public static void GetOpNameByLineType(string lineType,string transferLineType, DataTable dt)
        //{
        //    dt = null;
        //    string sql;
        //    sql = "SELECT * FROM MES_计划BOM_工位与名称 WHERE PC=1 "
        //        + " AND 线体类型 ='"+transferLineType+"'";
        //    DataAccess.ExecuteDataTable_OleDb_Access(sql, out dt);

        //}
        /// <summary>
        /// 获得上线工位对应线体类型的工位文件列表
        /// </summary>
        /// <param name="opName"></param>
        /// <param name="fileNameList"></param>
        //public static void GetFileNameListByOpName(string opName, out string[] fileNameList)
        //{
        //    string transferLineType;
        //    fileNameList = null;
        //    DataTable dt = null;
        //    string sql;
        //    sql = "SELECT 线体类型 FROM MES_计划BOM_工位与名称 WHERE 工位号='" + opName + "'";
        //    DataAccess.ExecuteDataTable_OleDb_Access(sql, out dt);
        //    if (dt != null)
        //    {
        //        if (dt.Rows.Count > 0)
        //        {
        //            transferLineType = dt.Rows[0]["线体类型"].ToString();
        //            sql = "SELECT 文件名称 FROM MES_计划BOM_工位与名称 WHERE 线体类型 ='" + transferLineType + "'"
        //                + " AND 工位号<>'" + opName+"'";
        //            DataAccess.ExecuteDataTable_OleDb_Access(sql, out dt);
        //            if (dt != null)
        //            {
        //                if (dt.Rows.Count > 0)
        //                {
        //                    fileNameList = new string[dt.Rows.Count];
        //                    for (int i = 0; i < dt.Rows.Count; i++)
        //                    {
        //                        fileNameList[i] = dt.Rows[i]["文件名称"].ToString();
        //                    }
        //                }
        //            }
        //        }
        //    }
        //}
    }
}
