public List <V_Bat> GetValues(DateTime start, DateTime end)
{
SqlParameter[] parms = { new SqlParameter("@Start", SqlDbType.DateTime),
new SqlParameter("@End", SqlDbType.DateTime) };
parms[0].Value = SqlTypeConverter.DBNullDateTimeHandler(start);
parms[1].Value = SqlTypeConverter.DBNullDateTimeHandler(end);
var entities = new List <V_Bat>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_V_Bat_Repository_GetValues, parms)) {
while (rdr.Read())
{
var entity = new V_Bat();
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.StartTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["StartTime"]);
entity.Value = SqlTypeConverter.DBNullDoubleHandler(rdr["Value"]);
entity.ValueTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["ValueTime"]);
entities.Add(entity);
}
}
return(entities);
}
public List <V_Bat> GetProcDetails(string device, int pack, EnmBatType type, DateTime start, DateTime end)
{
SqlParameter[] parms = { new SqlParameter("@DeviceId", SqlDbType.VarChar, 100),
new SqlParameter("@PackId", SqlDbType.Int),
new SqlParameter("@Type", SqlDbType.Int),
new SqlParameter("@Start", SqlDbType.DateTime),
new SqlParameter("@End", SqlDbType.DateTime) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(device);
parms[1].Value = SqlTypeConverter.DBNullInt32Checker(pack);
parms[2].Value = (int)type;
parms[3].Value = SqlTypeConverter.DBNullDateTimeChecker(start);
parms[4].Value = SqlTypeConverter.DBNullDateTimeChecker(end);
var entities = new List <V_Bat>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_V_Bat_Repository_GetProcDetails, parms)) {
while (rdr.Read())
{
var entity = new V_Bat();
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.DBNullBatTypeHandler(rdr["Type"]);
entity.StartTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["StartTime"]);
entity.Value = SqlTypeConverter.DBNullDoubleHandler(rdr["Value"]);
entity.ValueTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["ValueTime"]);
entities.Add(entity);
}
}
return(entities);
}
