/// <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}'");
}
