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_BatCurve> GetValues(string device, int pack, EnmBatPoint ptype, DateTime start, DateTime end) { return(_repository.GetValues(device, pack, ptype, start, end)); }