public List <V_BatCurve> GetMaxValues(EnmBatStatus type, EnmBatPoint ptype, DateTime start, DateTime end)
{
SqlParameter[] parms = { new SqlParameter("@Type", SqlDbType.Int),
new SqlParameter("@PType", SqlDbType.Int),
new SqlParameter("@Start", SqlDbType.DateTime),
new SqlParameter("@End", SqlDbType.DateTime) };
parms[0].Value = (int)type;
parms[1].Value = (int)ptype;
parms[2].Value = SqlTypeConverter.DBNullDateTimeChecker(start);
parms[3].Value = SqlTypeConverter.DBNullDateTimeChecker(end);
var entities = new List <V_BatCurve>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_V_BatCurve_Repository_GetMaxValues, parms)) {
while (rdr.Read())
{
var entity = new V_BatCurve();
entity.AreaId = SqlTypeConverter.DBNullStringHandler(rdr["AreaId"]);
entity.StationId = SqlTypeConverter.DBNullStringHandler(rdr["StationId"]);
entity.RoomId = SqlTypeConverter.DBNullStringHandler(rdr["RoomId"]);
entity.DeviceId = SqlTypeConverter.DBNullStringHandler(rdr["DeviceId"]);
entity.PointId = SqlTypeConverter.DBNullStringHandler(rdr["PointId"]);
entity.PackId = SqlTypeConverter.DBNullInt32Handler(rdr["PackId"]);
entity.Type = SqlTypeConverter.DBNullBatStatusHandler(rdr["Type"]);
entity.PType = SqlTypeConverter.DBNullBatPointHandler(rdr["PType"]);
entity.StartTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["StartTime"]);
entity.Value = SqlTypeConverter.DBNullDoubleHandler(rdr["Value"]);
entity.ValueTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["ValueTime"]);
entity.ProcTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["ProcTime"]);
entities.Add(entity);
}
}
return(entities);
}
public List <V_BatCurve> GetMaxValues(EnmBatStatus type, EnmBatPoint ptype, DateTime start, DateTime end)
{
return(_repository.GetMaxValues(type, ptype, start, end));
}
public List <V_BatTime> GetValues(DateTime start, DateTime end, EnmBatStatus status)
{
return(_repository.GetValues(start, end, status));
}
