53 lines
1.6 KiB
C#
53 lines
1.6 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>
|
||
/// 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);
|
||
//}
|
||
}
|
||
}
|