public BattGroup GetEntity(string device) { SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.VarChar, 100) }; parms[0].Value = SqlTypeConverter.DBNullStringChecker(device); BattGroup entity = null; using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_BattGroup_Repository_GetEntity, parms)) { if (rdr.Read()) { entity = new BattGroup(); 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"]); var cap = SqlTypeConverter.DBNullStringHandler(rdr["SingGroupCap"]); entity.SingGroupCap = string.IsNullOrWhiteSpace(cap) ? 0d : double.Parse(cap); entity.SingVoltGrade = SqlTypeConverter.DBNullInt32Handler(rdr["SingVoltGrade"]); var num = SqlTypeConverter.DBNullStringHandler(rdr["SingGroupBattNumber"]); entity.SingGroupBattNumber = string.IsNullOrWhiteSpace(num) ? 0 : int.Parse(num); } } return(entity); }
public List <BattGroup> GetEntities() { var entities = new List <BattGroup>(); using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_BattGroup_Repository_GetEntities, null)) { while (rdr.Read()) { var entity = new BattGroup(); 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"]); var cap = SqlTypeConverter.DBNullStringHandler(rdr["SingGroupCap"]); entity.SingGroupCap = string.IsNullOrWhiteSpace(cap) ? 0d : double.Parse(cap); entity.SingVoltGrade = SqlTypeConverter.DBNullInt32Handler(rdr["SingVoltGrade"]); var num = SqlTypeConverter.DBNullStringHandler(rdr["SingGroupBattNumber"]); entity.SingGroupBattNumber = string.IsNullOrWhiteSpace(num) ? 0 : int.Parse(num); entities.Add(entity); } } return(entities); }