using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using DataLinkMesWork;

using SystemFramework;

namespace bizFacade
{
    partial class BaseDataSystemMES
    {
        /// <summary>
        /// 机床报警变量
        /// 103
        /// </summary>
        /// <returns></returns>
        public static DataTable BaseData_tagTable_Alarm()
        {
            //string errorMessage;
            DataTable dt;
            string sql;
            sql = "SELECT  TagID,0 as TagValue,TagName,工位号,数据来源,TagTypeID,TagLong,列位置,测量位置,变量类型代码,测量项目,TagAdr,TagAdrDemo   FROM [MES_基本变量_原始数据] where 变量类型代码 = 103 and 是否启用 = 1"
                + " and (监控属性代码 = '" + ApplicationConfig.MES_Code.ToString() + "')";
            DataAccess.ExecuteDataTable(sql, out dt);
            return dt;
        }
    }
}