public List <DivSwitElecSour> GetEntities()
{
var entities = new List <DivSwitElecSour>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_DivSwitElecSour_Repository_GetEntities, null)) {
while (rdr.Read())
{
var entity = new DivSwitElecSour();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Code = SqlTypeConverter.DBNullStringHandler(rdr["Code"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.SysName = SqlTypeConverter.DBNullStringHandler(rdr["SysName"]);
entity.SysCode = SqlTypeConverter.DBNullStringHandler(rdr["SysCode"]);
entity.Type = new DeviceType {
Id = SqlTypeConverter.DBNullStringHandler(rdr["DeviceTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["DeviceTypeName"])
};
entity.SubType = new SubDeviceType {
Id = SqlTypeConverter.DBNullStringHandler(rdr["SubDeviceTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["SubDeviceTypeName"])
};
entity.Model = SqlTypeConverter.DBNullStringHandler(rdr["Model"]);
entity.ProdId = SqlTypeConverter.DBNullStringHandler(rdr["ProdId"]);
entity.BrandId = SqlTypeConverter.DBNullStringHandler(rdr["BrandId"]);
entity.SuppId = SqlTypeConverter.DBNullStringHandler(rdr["SuppId"]);
entity.SubCompId = SqlTypeConverter.DBNullStringHandler(rdr["SubCompId"]);
entity.StartTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["StartTime"]);
entity.ScrapTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["ScrapTime"]);
entity.StatusId = SqlTypeConverter.DBNullInt32Handler(rdr["StatusId"]);
entity.Contact = SqlTypeConverter.DBNullStringHandler(rdr["Contact"]);
entity.AreaId = SqlTypeConverter.DBNullStringHandler(rdr["AreaId"]);
entity.StationId = SqlTypeConverter.DBNullStringHandler(rdr["StationId"]);
entity.StationName = SqlTypeConverter.DBNullStringHandler(rdr["StationName"]);
entity.RoomId = SqlTypeConverter.DBNullStringHandler(rdr["RoomId"]);
entity.RoomName = SqlTypeConverter.DBNullStringHandler(rdr["RoomName"]);
entity.FsuId = SqlTypeConverter.DBNullStringHandler(rdr["FsuId"]);
entity.FsuCode = SqlTypeConverter.DBNullStringHandler(rdr["FsuCode"]);
entity.ProtocolId = SqlTypeConverter.DBNullStringHandler(rdr["ProtocolId"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
entity.RatedOutputVolt = SqlTypeConverter.DBNullDoubleHandler(rdr["RatedOutputVolt"]);
entity.MoniModuleModel = SqlTypeConverter.DBNullStringHandler(rdr["MoniModuleModel"]);
entity.ExisRModuleCount = SqlTypeConverter.DBNullStringHandler(rdr["ExisRModuleCount"]);
entity.RModuleModel = SqlTypeConverter.DBNullStringHandler(rdr["RModuleModel"]);
entity.RModuleRatedWorkVolt = SqlTypeConverter.DBNullInt32Handler(rdr["RModuleRatedWorkVolt"]);
entity.SingRModuleRatedOPCap = SqlTypeConverter.DBNullStringHandler(rdr["SingRModuleRatedOPCap"]);
entity.SingGBattGFuseCap = SqlTypeConverter.DBNullStringHandler(rdr["SingGBattGFuseCap"]);
entity.BattGFuseGNumber = SqlTypeConverter.DBNullInt32Handler(rdr["BattGFuseGNumber"]);
entity.OPDistBoardModel = SqlTypeConverter.DBNullStringHandler(rdr["OPDistBoardModel"]);
entity.OPDistBoardNumber = SqlTypeConverter.DBNullInt32Handler(rdr["OPDistBoardNumber"]);
entities.Add(entity);
}
}
return(entities);
}
public List <DivSwitElecSour> GetEntities()
{
var entities = new List <DivSwitElecSour>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_DivSwitElecSour_Repository_GetEntities, null)) {
while (rdr.Read())
{
var entity = new DivSwitElecSour();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.Type = new DeviceType {
Id = SqlTypeConverter.DBNullStringHandler(rdr["DeviceTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["DeviceTypeName"])
};
entity.SubType = new SubDeviceType {
Id = SqlTypeConverter.DBNullStringHandler(rdr["SubDeviceTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["SubDeviceTypeName"])
};
entity.AreaId = SqlTypeConverter.DBNullStringHandler(rdr["AreaId"]);
entity.AreaName = SqlTypeConverter.DBNullStringHandler(rdr["AreaName"]);
entity.StationId = SqlTypeConverter.DBNullStringHandler(rdr["StationId"]);
entity.StationName = SqlTypeConverter.DBNullStringHandler(rdr["StationName"]);
entity.StationType = new StationType {
Id = SqlTypeConverter.DBNullStringHandler(rdr["StationTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["StationTypeName"])
};
entity.RoomId = SqlTypeConverter.DBNullStringHandler(rdr["RoomId"]);
entity.RoomName = SqlTypeConverter.DBNullStringHandler(rdr["RoomName"]);
entity.FsuId = SqlTypeConverter.DBNullStringHandler(rdr["FsuId"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]);
entity.RatedOutputVolt = SqlTypeConverter.DBNullDoubleHandler(rdr["RatedOutputVolt"]);
entity.MoniModuleModel = SqlTypeConverter.DBNullStringHandler(rdr["MoniModuleModel"]);
entity.RModuleModel = SqlTypeConverter.DBNullStringHandler(rdr["RModuleModel"]);
entity.RModuleRatedWorkVolt = SqlTypeConverter.DBNullInt32Handler(rdr["RModuleRatedWorkVolt"]);
entity.BattGFuseGNumber = SqlTypeConverter.DBNullInt32Handler(rdr["BattGFuseGNumber"]);
entity.OPDistBoardModel = SqlTypeConverter.DBNullStringHandler(rdr["OPDistBoardModel"]);
entity.OPDistBoardNumber = SqlTypeConverter.DBNullInt32Handler(rdr["OPDistBoardNumber"]);
int exisRModuleCount; double singRModuleRatedOPCap, singGBattGFuseCap;
if (int.TryParse(SqlTypeConverter.DBNullStringHandler(rdr["ExisRModuleCount"]), out exisRModuleCount))
{
entity.ExisRModuleCount = exisRModuleCount;
}
else
{
entity.ExisRModuleCount = 0;
}
if (double.TryParse(SqlTypeConverter.DBNullStringHandler(rdr["SingRModuleRatedOPCap"]), out singRModuleRatedOPCap))
{
entity.SingRModuleRatedOPCap = singRModuleRatedOPCap;
}
else
{
entity.SingRModuleRatedOPCap = 0;
}
if (double.TryParse(SqlTypeConverter.DBNullStringHandler(rdr["SingGBattGFuseCap"]), out singGBattGFuseCap))
{
entity.SingGBattGFuseCap = singGBattGFuseCap;
}
else
{
entity.SingGBattGFuseCap = 0;
}
entities.Add(entity);
}
}
return(entities);
}
