52 lines
1.5 KiB
C#
52 lines
1.5 KiB
C#
using System;
|
|
using System.Data;
|
|
using System.Data.SqlClient;
|
|
using DataLinkMesWork;
|
|
using System.Collections;
|
|
using System.Collections.Specialized;
|
|
using SystemFramework;
|
|
|
|
namespace bizFacade
|
|
{
|
|
/// <summary>
|
|
/// QualityDataSystem 的摘要说明。
|
|
/// </summary>
|
|
public partial class QualityDataSystem
|
|
{
|
|
/// <summary>
|
|
/// 全部数据列表
|
|
/// MES_基本变量_原始数据
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
static public DataTable BasicDataTagValue()
|
|
{
|
|
DataTable dt = null;
|
|
|
|
string sql;
|
|
sql = "SELECT * FROM MES_基本变量_原始数据 where (变量类型代码=101 or 变量类型代码 = 102 or 变量类型代码 = 105) "
|
|
+ " and (是否启用 = 1)"
|
|
+ " and (监控属性代码 = '" + ApplicationConfig.MES_Code.ToString() + "')"
|
|
+ " order by TagID";
|
|
DataAccess.ExecuteDataTable(sql, out dt);
|
|
return dt;
|
|
|
|
}
|
|
|
|
|
|
/// <summary>
|
|
/// MES_基本数据_测量范围
|
|
/// 从数据库服务器获得
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
static public DataTable BasicDataTagValueUpDown()
|
|
{
|
|
DataTable dt = null;
|
|
string sql;
|
|
sql = "SELECT * FROM MES_基本数据_测量范围 order by 发动机型号代码,TagID";
|
|
DataAccess.ExecuteDataTable(sql, out dt);
|
|
return dt;
|
|
}
|
|
|
|
}
|
|
}
|