public DetalleTarjetaLugarList GetDetalleTarjetaLugarPaginacion(int IdProyecto, Paginacion oPaginacion, out int RowCount) { DetalleTarjetaLugarList olista = new DetalleTarjetaLugarList(); DbCommand oDbCommand = oDatabase.GetStoredProcCommand(DetalleTarjetaLugar.Proc.Paginacion.Str()); oDatabase.AddInParameter(oDbCommand, "@IdProyecto", DbType.Int32, IdProyecto); oDatabase = Pagination.DefaultParams(oDatabase, oDbCommand, oPaginacion); using (IDataReader oIDataReader = oDatabase.ExecuteReader(oDbCommand)) { int i1 = oIDataReader.GetOrdinal("IdDetTarjetaLugar"); int i2 = oIDataReader.GetOrdinal("IdProyecto"); int i3 = oIDataReader.GetOrdinal("SubRackId"); int i4 = oIDataReader.GetOrdinal("Slot"); int i5 = oIDataReader.GetOrdinal("BoardType"); while (oIDataReader.Read()) { DetalleTarjetaLugar obj = new DetalleTarjetaLugar(); obj.IdDetalleTarjetaLugar = DataUtil.DbValueToDefault <Int32>(oIDataReader[i1]); obj.IdProyecto = DataUtil.DbValueToDefault <Int32>(oIDataReader[i2]); obj.SubRackId = DataUtil.DbValueToDefault <String>(oIDataReader[i3]); obj.Slot = DataUtil.DbValueToDefault <String>(oIDataReader[i4]); obj.BoardType = DataUtil.DbValueToDefault <String>(oIDataReader[i5]); olista.Add(obj); } } RowCount = Convert.ToInt32(oDatabase.GetParameterValue(oDbCommand, "@RowCount")); return(olista); }
public int RegistrarDetalleTarjetaLugar(DetalleTarjetaLugar oDetalleTarjetaLugar) { DbCommand oDbCommand = oDatabase.GetStoredProcCommand(DetalleTarjetaLugar.Proc.Insertar.Str()); oDatabase.AddInParameter(oDbCommand, "@IdProyecto", DbType.Int32, oDetalleTarjetaLugar.IdProyecto); oDatabase.AddInParameter(oDbCommand, "@SubRackId", DbType.String, oDetalleTarjetaLugar.SubRackId); oDatabase.AddInParameter(oDbCommand, "@Slot", DbType.String, oDetalleTarjetaLugar.Slot); oDatabase.AddInParameter(oDbCommand, "@BoardType", DbType.String, oDetalleTarjetaLugar.BoardType); oDatabase.AddInParameter(oDbCommand, "@BiosVersion", DbType.String, oDetalleTarjetaLugar.BiosVersion); oDatabase.AddInParameter(oDbCommand, "@SoftVersion", DbType.String, oDetalleTarjetaLugar.SoftVersion); oDatabase.AddInParameter(oDbCommand, "@LogicVersion", DbType.String, oDetalleTarjetaLugar.LogicVersion); oDatabase.AddInParameter(oDbCommand, "@PCBVersion", DbType.String, oDetalleTarjetaLugar.PCBVersion); oDatabase.AddInParameter(oDbCommand, "@SerialNumber", DbType.String, oDetalleTarjetaLugar.SerialNumber); return(Convert.ToInt32(oDatabase.ExecuteScalar(oDbCommand))); }