/// <summary>
/// 查询 DC_WRITE_DATA
/// </summary>
/// <returns></returns>
public List <DC_WRITE_DATA> GetWriteDatasUpdated()
{
string sql = $@"SELECT * FROM DC.DC_WRITE_DATA WHERE UPDATED=1";
OracleDataReader reader = OracleDataHelper.ExecuteReader(sql);
List <DC_WRITE_DATA> lst = new List <DC_WRITE_DATA>();
while (reader.Read())
{
DC_WRITE_DATA data = new DC_WRITE_DATA()
{
ID = Convert.ToInt32(reader["ID"]),
DATA_CONFIG_ID = GetValue(reader, "DATA_CONFIG_ID"),
VALUE = GetValue(reader, "VALUE"),
UPDATED = GetValue(reader, "UPDATED"),
WRITE_TIME = GetValue(reader, "WRITE_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);
}
public void Request(List <DC_WRITE_DATA> datas)
{
DC_WRITE_DATA wData = null;
foreach (var data in datas)
{
if (data.DATA_CONFIG_ID == Config.ID)
{
wData = data;
break;
}
}
if (wData != null)
{
Operator.Write(Config, wData.VALUE); //写入plc
dC_Service.UpdateWriteDataFlag(wData.ID); //更新标志
}
}
