67 lines
2.3 KiB
C#
67 lines
2.3 KiB
C#
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();
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|