public float getLastData(Model.CasicTemp tempInfo)
{
using (OracleConnection conn = new OracleConnection(OracleHelper.ConnectionStringOrderDistributedTransaction))
{
String SQL = " SELECT DATA " +
" FROM " +
" (SELECT * " +
" FROM ALARM_TEMPERATURE " +
" WHERE DEVCODE = :devCode " +
" and UPTIME < :uptime " +
" order by UPTIME desc) " +
" where rownum=1 ";
/*
* String SQL = " SELECT DATA " +
* " FROM ALARM_TEMPERATURE " +
* " WHERE DEVCODE = :devCode " +
* " and UPTIME < :uptime " +
* " and rownum=1 " +
* " order by UPTIME desc ";
* */
OracleParameter[] oraParams = new OracleParameter[] {
new OracleParameter(":devCode", tempInfo.DEVCODE),
new OracleParameter(":uptime", tempInfo.UpTime)
};
DataTable dt = OracleHelper.ExecuteDataset(conn, CommandType.Text, SQL, oraParams).Tables[0];
if (dt.Rows.Count > 0)
{
float lastData = float.Parse(dt.Rows[0]["DATA"].ToString());
return(lastData);
}
}
return(-1);
}
/// <summary>
/// An internal function to bind values parameters for insert
/// </summary>
/// <param name="parms">Database parameters</param>
/// <param name="noise">Values to bind to parameters</param>
private void SetAdapterParameters(OracleParameter[] parms, Model.CasicTemp casicTemp)
{
parms[0].Value = casicTemp.DEVCODE;
if (null != casicTemp.Data)
{
parms[1].Value = casicTemp.Data;
}
else
{
parms[1].Value = DBNull.Value;
}
if (null != casicTemp.LogTime)
{
parms[2].Value = casicTemp.LogTime;
}
else
{
parms[2].Value = DBNull.Value;
}
if (null != casicTemp.UpTime)
{
parms[3].Value = casicTemp.UpTime;
}
else
{
parms[3].Value = DBNull.Value;
}
if (null != casicTemp.Cell)
{
parms[4].Value = casicTemp.Cell;
}
else
{
parms[4].Value = DBNull.Value;
}
}
private AlarmRecordInfo getAlarmRecord(AlarmRuleInfo alarmRuleInfo, Model.CasicTemp tempInfo)
{
if (null != alarmRuleInfo)
{
float curValue = float.Parse(tempInfo.Data);
IDevice deviceDal = SensorHub.DALFactory.Device.Create();
ICasicTemp tempDal = SensorHub.DALFactory.CasicTemp.Create();
AlarmRecordInfo alarmRecordInfo = new AlarmRecordInfo();
alarmRecordInfo.ACTIVE = true;
alarmRecordInfo.DEVICE_CODE = tempInfo.DEVCODE;
alarmRecordInfo.DEVICE_ID = alarmRuleInfo.DeviceId;
alarmRecordInfo.DEVICE_TYPE_NAME = deviceDal.getDevTypeByCode(tempInfo.DEVCODE);
alarmRecordInfo.ITEMNAME = "温度值";
alarmRecordInfo.ITEMVALUE = curValue.ToString();
alarmRecordInfo.MESSAGE_STATUS = 0;
alarmRecordInfo.RECORDCODE = "";
alarmRecordInfo.RECORDDATE = System.DateTime.Now;
if (alarmRuleInfo.HighValue != 0 && curValue > alarmRuleInfo.HighValue)
{
alarmRecordInfo.MESSAGE = "温度超限";
return(alarmRecordInfo);
}
if (alarmRuleInfo.Saltation != 0)
{
float lastData = tempDal.getLastData(tempInfo);
if (-1 != lastData && Math.Abs(curValue - lastData) > alarmRuleInfo.Saltation)
{
alarmRecordInfo.MESSAGE = "温度突变";
return(alarmRecordInfo);
}
}
}
return(null);
}
public float getLastData(Model.CasicTemp casicTemp)
{
return(SensorHub.DALFactory.CasicTemp.Create().getLastData(casicTemp));
}
