/// <summary> /// 查询 DC_REAL_DATA /// </summary> /// <returns></returns> public List <DC_REAL_DATA> GetRealDatas() { string sql = $@"SELECT * FROM DC.DC_REAL_DATA WHERE UPDATED=1"; OracleDataReader reader = OracleDataHelper.ExecuteReader(sql); List <DC_REAL_DATA> lst = new List <DC_REAL_DATA>(); while (reader.Read()) { DC_REAL_DATA data = new DC_REAL_DATA() { ID = Convert.ToInt32(reader["ID"]), DATA_CONFIG_ID = GetValue(reader, "DATA_CONFIG_ID"), QUALITY = GetValue(reader, "QUALITY"), VALUE = GetValue(reader, "VALUE"), UPDATED = GetValue(reader, "UPDATED"), TIME_STAMP = GetValue(reader, "TIME_STAMP"), READ_TIME = GetValue(reader, "READ_TIME"), UPDATE_TIME = GetValue(reader, "UPDATE_TIME"), FIELD1 = reader["FIELD1"].ToString(), FIELD2 = reader["FIELD2"].ToString(), FIELD3 = reader["FIELD3"].ToString(), }; lst.Add(data); } reader.Close(); return(lst); }
/// <summary> /// 校验质量 /// </summary> /// <param name="data"></param> /// <returns></returns> private bool ValidateValueQuality(DC_REAL_DATA data) { if (data.QUALITY.ToUpper() == "GOOD") { return(true); } return(false); }
/// <summary> /// 值的字符串 /// </summary> /// <param name="config"></param> /// <param name="data"></param> /// <returns></returns> private string GetValueStr(DC_DATA_CONFIG config, DC_REAL_DATA data) { if (string.IsNullOrEmpty(data.VALUE)) { return("null"); } string type = config.FIELD_DATA_TYPE.ToUpper(); if (type == "DATE") { return($"TO_DATE('{data.VALUE}','yyyy/mm/dd hh24:mi:ss')"); } return($"'{data.VALUE}'"); }