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;
        }
       
    }
}