76 lines
2.1 KiB
C#
76 lines
2.1 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Text;
|
|
using System.Data;
|
|
using System.Data.SqlClient;
|
|
using DataLinkMesWork;
|
|
|
|
|
|
//using SystemFramework;
|
|
|
|
namespace bizFacade
|
|
{
|
|
public partial class BaseDataSystemMES
|
|
{
|
|
/// <summary>
|
|
/// 获得用户名和密码，验证登录信息。
|
|
/// </summary>
|
|
/// <param name="dt"></param>
|
|
/// <returns></returns>
|
|
//public static bool GetWorkSheet(out DataTable dt)
|
|
//{
|
|
// //string errorMessage;
|
|
// string sql;
|
|
// sql = "SELECT * FROM [MES_操作着_生产班次] ";
|
|
// return DataAccess.ExecuteDataTable_OleDb_Access(sql, out dt);
|
|
|
|
//}
|
|
/// <summary>
|
|
///
|
|
/// </summary>
|
|
/// <param name="operatorCode"></param>
|
|
/// <param name="dt"></param>
|
|
/// <returns></returns>
|
|
//public static bool GetOperatorCode(string operatorCode,out DataTable dt)
|
|
//{
|
|
// //string errorMessage;
|
|
// string sql;
|
|
// sql = "SELECT * FROM [MES_操作者_用户] "
|
|
// + " WHERE 操作者工号='" + operatorCode+"'";
|
|
// return DataAccess.ExecuteDataTable_OleDb_Access(sql, out dt);
|
|
|
|
//}
|
|
/// <summary>
|
|
/// 是否是：操作者工号
|
|
/// </summary>
|
|
/// <param name="operatorCode"></param>
|
|
/// <returns></returns>
|
|
//public static bool GetOperatorCode(string operatorCode)
|
|
//{
|
|
// //string errorMessage;
|
|
// DataTable dt;
|
|
// string sql;
|
|
|
|
|
|
// sql = "SELECT * FROM [MES_操作者_用户] "
|
|
// + " WHERE 操作者工号='" + operatorCode + "'";
|
|
|
|
// if (DataAccess.ExecuteDataTable_OleDb_Access(sql, out dt))
|
|
// {
|
|
// if (dt.Rows.Count > 0)
|
|
// {
|
|
// return true;
|
|
// }
|
|
// else
|
|
// {
|
|
// return false;
|
|
// }
|
|
// }
|
|
// else
|
|
// {
|
|
// return false;
|
|
// }
|
|
//}
|
|
}
|
|
}
|