public static AlarmLimitModel GetAllLimit(string tagname) { AlarmLimitModel AlarmLimit = new AlarmLimitModel(); //string sqlStr = "SELECT department_name,FullTagName,FDC_Tag,Limit_Max,Limit_Max_Type,IsHiEnable,Limit_Min,Limit_Min_Type,IsLoEnable,delayTime FROM vw_eq_limit where fulltagName = '" + tagname + "'"; //DataSet DeptDS = DBConnector.executeQuery("Intouch", sqlStr); //AlarmLimit = (from dept in DeptDS.Tables[0].AsEnumerable() // select new AlarmLimitModel // { // department_name = dept.Field<string>("department_name"), // FullTagName = dept.Field<string>("FullTagName"), // FDC_Tag = dept.Field<string>("FDC_Tag"), // Limit_Max = dept.Field<double?>("Limit_Max"), // Limit_Max_Type = dept.Field<double?>("Limit_Max_Type"), // IsHiEnable = dept.Field<bool?>("IsHiEnable"), // Limit_Min = dept.Field<double?>("Limit_Min"), // Limit_Min_Type = dept.Field<double?>("Limit_Min_Type"), // IsLoEnable = dept.Field<bool?>("IsLoEnable"), // DelayTime = dept.Field<int>("delayTime") // }).FirstOrDefault(); AlarmLimit.FullTagName = tagname; AlarmLimit.FDC_Tag = tagname; AlarmLimit.Limit_Max = 32766; AlarmLimit.Limit_Min = -32767; AlarmLimit.DelayTime = 0; AlarmLimit.IsHiEnable = true; AlarmLimit.IsLoEnable = true; return(AlarmLimit); }
public static AlarmLimitModel GetLimit(string tagname) { AlarmLimitModel AlarmLimit = new AlarmLimitModel(); string sqlStr = "SELECT department_name,FullTagName,FDC_Tag,Limit_Max,Limit_Max_Type,IsHiEnable,Limit_Min,Limit_Min_Type,IsLoEnable,delayTime FROM vw_eq_limit where fulltagName = '" + tagname + "'"; DataSet DeptDS = DBConnector.executeQuery("Intouch", sqlStr); AlarmLimit = (from dept in DeptDS.Tables[0].AsEnumerable() select new AlarmLimitModel { department_name = dept.Field <string>("department_name"), FullTagName = dept.Field <string>("FullTagName"), FDC_Tag = dept.Field <string>("FDC_Tag"), Limit_Max = dept.Field <double?>("Limit_Max"), Limit_Max_Type = dept.Field <double?>("Limit_Max_Type"), IsHiEnable = dept.Field <bool?>("IsHiEnable"), Limit_Min = dept.Field <double?>("Limit_Min"), Limit_Min_Type = dept.Field <double?>("Limit_Min_Type"), IsLoEnable = dept.Field <bool?>("IsLoEnable"), DelayTime = dept.Field <int>("delayTime") }).FirstOrDefault(); return(AlarmLimit); }