private SqlParameter Param(enumDBFields dbField, object value)
{
SqlParameter dbParam = null;
string paramName = null;
SqlDbType paramType = default(SqlDbType);
int paramSize = 0;
ParameterDirection paramDirection = ParameterDirection.Input;
switch (dbField)
{
case enumDBFields.t935_idcategoriaprofesional:
paramName = "@t935_idcategoriaprofesional";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.t941_idcolectivo:
paramName = "@t941_idcolectivo";
paramType = SqlDbType.Int;
paramSize = 4;
break;
}
dbParam = cDblib.dbParameter(paramName, paramType, paramSize);
dbParam.Direction = paramDirection;
if (paramDirection == ParameterDirection.Input | paramDirection == ParameterDirection.InputOutput)
{
dbParam.Value = value;
}
return(dbParam);
}
private SqlParameter Param(enumDBFields dbField, object value)
{
SqlParameter dbParam = null;
string paramName = null;
SqlDbType paramType = default(SqlDbType);
int paramSize = 0;
ParameterDirection paramDirection = ParameterDirection.Input;
switch (dbField)
{
case enumDBFields.MostrarInactivos:
paramName = "@bMostrarInactivos";
paramType = SqlDbType.Bit;
paramSize = 1;
break;
}
dbParam = cDblib.dbParameter(paramName, paramType, paramSize);
dbParam.Direction = paramDirection;
if (paramDirection == ParameterDirection.Input | paramDirection == ParameterDirection.InputOutput)
{
dbParam.Value = value;
}
return(dbParam);
}
private SqlParameter Param(enumDBFields dbField, object value)
{
SqlParameter dbParam = null;
string paramName = null;
SqlDbType paramType = default(SqlDbType);
int paramSize = 0;
ParameterDirection paramDirection = ParameterDirection.Input;
switch (dbField)
{
case enumDBFields.t001_idficepi:
paramName = "@t001_idficepi";
paramType = SqlDbType.SmallInt;
paramSize = 2;
break;
case enumDBFields.parentesco:
paramName = "@parentesco";
paramType = SqlDbType.SmallInt;
paramSize = 2;
break;
}
dbParam = cDblib.dbParameter(paramName, paramType, paramSize);
dbParam.Direction = paramDirection;
if (paramDirection == ParameterDirection.Input | paramDirection == ParameterDirection.InputOutput)
{
dbParam.Value = value;
}
return(dbParam);
}
private SqlParameter Param(enumDBFields dbField, object value)
{
SqlParameter dbParam = null;
string paramName = null;
SqlDbType paramType = default(SqlDbType);
int paramSize = 0;
ParameterDirection paramDirection = ParameterDirection.Input;
switch (dbField)
{
case enumDBFields.t332_idtarea:
paramName = "@t332_idtarea";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.t410_idaccion:
paramName = "@t410_idaccion";
paramType = SqlDbType.Int;
paramSize = 4;
break;
}
dbParam = cDblib.dbParameter(paramName, paramType, paramSize);
dbParam.Direction = paramDirection;
if (paramDirection == ParameterDirection.Input | paramDirection == ParameterDirection.InputOutput)
{
dbParam.Value = value;
}
return(dbParam);
}
private SqlParameter Param(enumDBFields dbField, object value)
{
SqlParameter dbParam = null;
string paramName = null;
SqlDbType paramType = default(SqlDbType);
int paramSize = 0;
ParameterDirection paramDirection = ParameterDirection.Input;
switch (dbField)
{
case enumDBFields.sIDRED:
paramName = "@sIDRED";
paramType = SqlDbType.VarChar;
paramSize = 15;
break;
case enumDBFields.t314_idusuario:
paramName = "@t314_idusuario";
paramType = SqlDbType.Int;
paramSize = 4;
break;
}
dbParam = cDblib.dbParameter(paramName, paramType, paramSize);
dbParam.Direction = paramDirection;
if (paramDirection == ParameterDirection.Input | paramDirection == ParameterDirection.InputOutput)
{
dbParam.Value = value;
}
return(dbParam);
}
private SqlParameter Param(enumDBFields dbField, object value)
{
SqlParameter dbParam = null;
string paramName = null;
SqlDbType paramType = default(SqlDbType);
int paramSize = 0;
ParameterDirection paramDirection = ParameterDirection.Input;
switch (dbField)
{
case enumDBFields.ta209_idconceptotareapendiente:
paramName = "@ta209_idconceptotareapendiente";
paramType = SqlDbType.TinyInt;
paramSize = 1;
break;
case enumDBFields.ta209_denominacion:
paramName = "@ta209_denominacion";
paramType = SqlDbType.VarChar;
paramSize = 50;
break;
}
dbParam = cDblib.dbParameter(paramName, paramType, paramSize);
dbParam.Direction = paramDirection;
if (paramDirection == ParameterDirection.Input | paramDirection == ParameterDirection.InputOutput)
{
dbParam.Value = value;
}
return(dbParam);
}
private SqlParameter Param(enumDBFields dbField, object value)
{
SqlParameter dbParam = null;
string paramName = null;
SqlDbType paramType = default(SqlDbType);
int paramSize = 0;
ParameterDirection paramDirection = ParameterDirection.Input;
switch (dbField)
{
case enumDBFields.ta205_idtipoaccionpreventa:
paramName = "@ta205_idtipoaccionpreventa";
paramType = SqlDbType.SmallInt;
paramSize = 2;
break;
case enumDBFields.ta205_denominacion:
paramName = "@ta205_denominacion";
paramType = SqlDbType.VarChar;
paramSize = 50;
break;
case enumDBFields.ta205_origen_on:
paramName = "@ta205_origen_on";
paramType = SqlDbType.Bit;
paramSize = 1;
break;
case enumDBFields.ta205_origen_partida:
paramName = "@ta205_origen_partida";
paramType = SqlDbType.Bit;
paramSize = 1;
break;
case enumDBFields.ta205_origen_super:
paramName = "@ta205_origen_super";
paramType = SqlDbType.Bit;
paramSize = 1;
break;
case enumDBFields.ta205_estadoactiva:
paramName = "@ta205_estadoactiva";
paramType = SqlDbType.Bit;
paramSize = 1;
break;
}
dbParam = cDblib.dbParameter(paramName, paramType, paramSize);
dbParam.Direction = paramDirection;
if (paramDirection == ParameterDirection.Input | paramDirection == ParameterDirection.InputOutput)
{
dbParam.Value = value;
}
return(dbParam);
}
private SqlParameter Param(enumDBFields dbField, object value)
{
SqlParameter dbParam = null;
string paramName = null;
SqlDbType paramType = default(SqlDbType);
int paramSize = 0;
ParameterDirection paramDirection = ParameterDirection.Input;
switch (dbField)
{
case enumDBFields.t314_idusuario:
paramName = "@t314_idusuario";
paramType = SqlDbType.VarChar;
paramSize = 8000;
break;
case enumDBFields.t302_idcliente:
paramName = "@t302_idcliente";
paramType = SqlDbType.VarChar;
paramSize = 8000;
break;
case enumDBFields.t305_idproyectosubnodo:
paramName = "@t305_idproyectosubnodo";
paramType = SqlDbType.VarChar;
paramSize = 8000;
break;
case enumDBFields.facturable:
paramName = "@facturable";
paramType = SqlDbType.Bit;
paramSize = 1;
break;
case enumDBFields.t337_fecha_desde:
paramName = "@t337_fecha_desde";
paramType = SqlDbType.SmallDateTime;
paramSize = 8;
break;
case enumDBFields.t337_fecha_hasta:
paramName = "@t337_fecha_hasta";
paramType = SqlDbType.SmallDateTime;
paramSize = 8;
break;
}
dbParam = cDblib.dbParameter(paramName, paramType, paramSize);
dbParam.Direction = paramDirection;
if (paramDirection == ParameterDirection.Input | paramDirection == ParameterDirection.InputOutput)
{
dbParam.Value = value;
}
return(dbParam);
}
private SqlParameter Param(enumDBFields dbField, object value)
{
SqlParameter dbParam = null;
string paramName = null;
SqlDbType paramType = default(SqlDbType);
int paramSize = 0;
ParameterDirection paramDirection = ParameterDirection.Input;
switch (dbField)
{
case enumDBFields.t423_idmotivo:
paramName = "@t423_idmotivo";
paramType = SqlDbType.TinyInt;
paramSize = 1;
break;
case enumDBFields.t423_denominacion:
paramName = "@t423_denominacion";
paramType = SqlDbType.VarChar;
paramSize = 50;
break;
case enumDBFields.t423_estado:
paramName = "@t423_estado";
paramType = SqlDbType.Bit;
paramSize = 1;
break;
case enumDBFields.t423_cuenta:
paramName = "@t423_cuenta";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.nOrden:
paramName = "@nOrden";
paramType = SqlDbType.TinyInt;
paramSize = 1;
break;
case enumDBFields.nAscDesc:
paramName = "@nAscDesc";
paramType = SqlDbType.TinyInt;
paramSize = 1;
break;
}
dbParam = cDblib.dbParameter(paramName, paramType, paramSize);
dbParam.Direction = paramDirection;
if (paramDirection == ParameterDirection.Input | paramDirection == ParameterDirection.InputOutput)
{
dbParam.Value = value;
}
return(dbParam);
}
private SqlParameter Param(enumDBFields dbField, object value)
{
SqlParameter dbParam = null;
string paramName = null;
SqlDbType paramType = default(SqlDbType);
int paramSize = 0;
ParameterDirection paramDirection = ParameterDirection.Input;
switch (dbField)
{
case enumDBFields.ta200_idareapreventa:
paramName = "@ta200_idareapreventa";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.ta200_denominacion:
paramName = "@ta200_denominacion";
paramType = SqlDbType.VarChar;
paramSize = 50;
break;
case enumDBFields.ta200_estadoactiva:
paramName = "@ta200_estadoactiva";
paramType = SqlDbType.Bit;
paramSize = 1;
break;
case enumDBFields.t001_idficepi_responsable:
paramName = "@t001_idficepi_responsable";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.ta199_idunidadpreventa:
paramName = "@ta199_idunidadpreventa";
paramType = SqlDbType.SmallInt;
paramSize = 2;
break;
case enumDBFields.t331_idpt:
paramName = "@t331_idpt";
paramType = SqlDbType.Int;
paramSize = 4;
break;
}
dbParam = cDblib.dbParameter(paramName, paramType, paramSize);
dbParam.Direction = paramDirection;
if (paramDirection == ParameterDirection.Input | paramDirection == ParameterDirection.InputOutput)
{
dbParam.Value = value;
}
return(dbParam);
}
private SqlParameter Param(enumDBFields dbField, object value)
{
SqlParameter dbParam = null;
string paramName = null;
SqlDbType paramType = default(SqlDbType);
int paramSize = 0;
ParameterDirection paramDirection = ParameterDirection.Input;
switch (dbField)
{
case enumDBFields.ta212_idorganizacioncomercial:
paramName = "@ta212_idorganizacioncomercial";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.t001_idficepi_comercial:
paramName = "@t001_idficepi_comercial";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.t331_idpt:
paramName = "@t331_idpt";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.ta212_activa:
paramName = "@ta212_activa";
paramType = SqlDbType.Bit;
paramSize = 1;
break;
case enumDBFields.bMostrarProfBaja:
paramName = "@bMostrarProfBaja";
paramType = SqlDbType.Bit;
paramSize = 1;
break;
case enumDBFields.ta213_nocambioautomatico:
paramName = "@ta213_nocambioautomatico";
paramType = SqlDbType.Bit;
paramSize = 1;
break;
}
dbParam = cDblib.dbParameter(paramName, paramType, paramSize);
dbParam.Direction = paramDirection;
if (paramDirection == ParameterDirection.Input | paramDirection == ParameterDirection.InputOutput)
{
dbParam.Value = value;
}
return(dbParam);
}
private SqlParameter Param(enumDBFields dbField, object value)
{
SqlParameter dbParam = null;
string paramName = null;
SqlDbType paramType = default(SqlDbType);
int paramSize = 0;
ParameterDirection paramDirection = ParameterDirection.Input;
switch (dbField)
{
case enumDBFields.t314_idusuario:
paramName = "@t314_idusuario";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.t332_idtarea:
paramName = "@t332_idtarea";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.t336_ete:
paramName = "@t336_ete";
paramType = SqlDbType.Float;
paramSize = 8;
break;
case enumDBFields.t336_ffe:
paramName = "@t336_ffe";
paramType = SqlDbType.DateTime;
paramSize = 4;
break;
case enumDBFields.t336_comentario:
paramName = "@t336_comentario";
paramType = SqlDbType.Text;
paramSize = 2147483647;
break;
case enumDBFields.t336_completado:
paramName = "@t336_completado";
paramType = SqlDbType.Bit;
paramSize = 1;
break;
}
dbParam = cDblib.dbParameter(paramName, paramType, paramSize);
dbParam.Direction = paramDirection;
if (paramDirection == ParameterDirection.Input | paramDirection == ParameterDirection.InputOutput)
{
dbParam.Value = value;
}
return(dbParam);
}
private SqlParameter Param(enumDBFields dbField, object value)
{
SqlParameter dbParam = null;
string paramName = null;
SqlDbType paramType = default(SqlDbType);
int paramSize = 0;
ParameterDirection paramDirection = ParameterDirection.Input;
switch (dbField)
{
case enumDBFields.t937_comentario_respdestino:
paramName = "@t937_comentario_respdestino";
paramType = SqlDbType.VarChar;
paramSize = 750;
break;
case enumDBFields.estado:
paramName = "@estado";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.idpeticion:
paramName = "@t937_idpetcambioresp";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.idficepi_fin:
paramName = "@t001_idficepi_fin";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.t001_idficepi:
paramName = "@t001_idficepi";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.listapeticiones:
paramName = "@listapeticiones";
paramType = SqlDbType.VarChar;
break;
}
dbParam = cDblib.dbParameter(paramName, paramType, paramSize);
dbParam.Direction = paramDirection;
if (paramDirection == ParameterDirection.Input | paramDirection == ParameterDirection.InputOutput)
{
dbParam.Value = value;
}
return(dbParam);
}
private SqlParameter Param(enumDBFields dbField, object value)
{
SqlParameter dbParam = null;
string paramName = null;
SqlDbType paramType = default(SqlDbType);
int paramSize = 0;
ParameterDirection paramDirection = ParameterDirection.Input;
switch (dbField)
{
case enumDBFields.idficepiVisualizador:
paramName = "@t001_idficepi_visualizador";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.idficepiVisualizado:
paramName = "@t001_idficepi_visualizado";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.tabla:
paramName = "@tabla";
paramType = SqlDbType.Char;
paramSize = 1;
break;
case enumDBFields.accion:
paramName = "@t949_accion";
paramType = SqlDbType.Char;
paramSize = 1;
break;
case enumDBFields.datatable:
paramName = "@TMPVISUALIZADOS";
paramType = SqlDbType.Structured;
paramSize = 4;
break;
case enumDBFields.visualizador:
paramName = "@visualizador";
paramType = SqlDbType.Int;
paramSize = 4;
break;
}
dbParam = cDblib.dbParameter(paramName, paramType, paramSize);
dbParam.Direction = paramDirection;
if (paramDirection == ParameterDirection.Input | paramDirection == ParameterDirection.InputOutput)
{
dbParam.Value = value;
}
return(dbParam);
}
private SqlParameter Param(enumDBFields dbField, object value)
{
SqlParameter dbParam = null;
string paramName = null;
SqlDbType paramType = default(SqlDbType);
int paramSize = 0;
ParameterDirection paramDirection = ParameterDirection.Input;
switch (dbField)
{
case enumDBFields.t067_dia:
paramName = "@t067_dia";
paramType = SqlDbType.DateTime;
paramSize = 8;
break;
case enumDBFields.nIdCal:
paramName = "@nIdCal";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.dUMC:
paramName = "@dUMC";
paramType = SqlDbType.DateTime;
paramSize = 8;
break;
case enumDBFields.t066_idcal:
paramName = "@t066_idcal";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.diaDesde:
paramName = "@diadesde";
paramType = SqlDbType.Date;
paramSize = 8;
break;
case enumDBFields.diaHasta:
paramName = "@diahasta";
paramType = SqlDbType.Date;
paramSize = 8;
break;
}
dbParam = cDblib.dbParameter(paramName, paramType, paramSize);
dbParam.Direction = paramDirection;
if (paramDirection == ParameterDirection.Input | paramDirection == ParameterDirection.InputOutput)
{
dbParam.Value = value;
}
return(dbParam);
}
private SqlParameter Param(enumDBFields dbField, object value)
{
SqlParameter dbParam = null;
string paramName = null;
SqlDbType paramType = default(SqlDbType);
int paramSize = 0;
ParameterDirection paramDirection = ParameterDirection.Input;
switch (dbField)
{
case enumDBFields.t409_idasunto:
paramName = "@t409_idasunto";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.t416_estado:
paramName = "@t416_codestado";
paramType = SqlDbType.TinyInt;
paramSize = 1;
break;
//case enumDBFields.Estado:
// paramName = "@Estado";
// paramType = SqlDbType.VarChar;
// paramSize = 10;
// break;
//case enumDBFields.t416_fecha:
// paramName = "@t416_fecha";
// paramType = SqlDbType.DateTime;
// paramSize = 8;
// break;
case enumDBFields.t314_idusuario:
paramName = "@t314_idusuario";
paramType = SqlDbType.Int;
paramSize = 4;
break;
//case enumDBFields.nomRecurso:
// paramName = "@nomRecurso";
// paramType = SqlDbType.VarChar;
// paramSize = 73;
// break;
}
dbParam = cDblib.dbParameter(paramName, paramType, paramSize);
dbParam.Direction = paramDirection;
if (paramDirection == ParameterDirection.Input | paramDirection == ParameterDirection.InputOutput)
{
dbParam.Value = value;
}
return(dbParam);
}
private SqlParameter Param(enumDBFields dbField, object value)
{
SqlParameter dbParam = null;
string paramName = null;
SqlDbType paramType = default(SqlDbType);
int paramSize = 0;
ParameterDirection paramDirection = ParameterDirection.Input;
switch (dbField)
{
case enumDBFields.t331_idpt:
paramName = "@t331_idpt";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.t305_idproyectosubnodo:
paramName = "@t305_idproyectosubnodo";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.t301_idproyecto:
paramName = "@t301_idproyecto";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.t331_despt:
paramName = "@t331_despt";
paramType = SqlDbType.VarChar;
paramSize = 50;
break;
case enumDBFields.t301_denominacion:
paramName = "@t301_denominacion";
paramType = SqlDbType.VarChar;
paramSize = 70;
break;
}
dbParam = cDblib.dbParameter(paramName, paramType, paramSize);
dbParam.Direction = paramDirection;
if (paramDirection == ParameterDirection.Input | paramDirection == ParameterDirection.InputOutput)
{
dbParam.Value = value;
}
return(dbParam);
}
/// <summary>
/// Inserta un JornadaCalendario
/// </summary>
/* internal int Insert(Models.JornadaCalendario oJornadaCalendario)
* {
* try
* {
* SqlParameter[] dbparams = new SqlParameter[8] {
* Param(enumDBFields.dia, oJornadaCalendario.dia),
* Param(enumDBFields.estilo_festivo, oJornadaCalendario.estilo_festivo),
* Param(enumDBFields.esfuerzo, oJornadaCalendario.esfuerzo),
* Param(enumDBFields.horas_estandar, oJornadaCalendario.horas_estandar),
* Param(enumDBFields.dia_entero, oJornadaCalendario.dia_entero),
* Param(enumDBFields.horas_planificadas, oJornadaCalendario.horas_planificadas),
* Param(enumDBFields.dia_festivo, oJornadaCalendario.dia_festivo),
* Param(enumDBFields.dia_vacaciones, oJornadaCalendario.dia_vacaciones)
* };
*
* return (int)cDblib.Execute("SUPER.IAP30_JornadaCalendario_INS", dbparams);
* }
* catch (Exception ex)
* {
* throw ex;
* }
* }
*
* /// <summary>
* /// Obtiene un JornadaCalendario a partir del id
* /// </summary>
* internal Models.JornadaCalendario Select()
* {
* Models.JornadaCalendario oJornadaCalendario = null;
* IDataReader dr = null;
*
* try
* {
*
*
* dr = cDblib.DataReader("SUPER.IAP30_JornadaCalendario_SEL", dbparams);
* if (dr.Read())
* {
* oJornadaCalendario = new Models.JornadaCalendario();
* if(!Convert.IsDBNull(dr["dia"]))
* oJornadaCalendario.dia=Convert.ToInt32(dr["dia"]);
* oJornadaCalendario.estilo_festivo=Convert.ToInt32(dr["estilo_festivo"]);
* oJornadaCalendario.esfuerzo=Convert.ToDouble(dr["esfuerzo"]);
* oJornadaCalendario.horas_estandar=Convert.ToSingle(dr["horas_estandar"]);
* oJornadaCalendario.dia_entero=Convert.ToDateTime(dr["dia_entero"]);
* oJornadaCalendario.horas_planificadas=Convert.ToDouble(dr["horas_planificadas"]);
* oJornadaCalendario.dia_festivo=Convert.ToInt32(dr["dia_festivo"]);
* oJornadaCalendario.dia_vacaciones=Convert.ToInt32(dr["dia_vacaciones"]);
*
* }
* return oJornadaCalendario;
*
* }
* catch (Exception ex)
* {
* throw ex;
* }
* finally
* {
* if (dr != null)
* {
* if (!dr.IsClosed) dr.Close();
* dr.Dispose();
* }
* }
* }
*
* /// <summary>
* /// Actualiza un JornadaCalendario a partir del id
* /// </summary>
* internal int Update(Models.JornadaCalendario oJornadaCalendario)
* {
* try
* {
* SqlParameter[] dbparams = new SqlParameter[8] {
* Param(enumDBFields.dia, oJornadaCalendario.dia),
* Param(enumDBFields.estilo_festivo, oJornadaCalendario.estilo_festivo),
* Param(enumDBFields.esfuerzo, oJornadaCalendario.esfuerzo),
* Param(enumDBFields.horas_estandar, oJornadaCalendario.horas_estandar),
* Param(enumDBFields.dia_entero, oJornadaCalendario.dia_entero),
* Param(enumDBFields.horas_planificadas, oJornadaCalendario.horas_planificadas),
* Param(enumDBFields.dia_festivo, oJornadaCalendario.dia_festivo),
* Param(enumDBFields.dia_vacaciones, oJornadaCalendario.dia_vacaciones)
* };
*
* return (int)cDblib.Execute("SUPER.IAP30_JornadaCalendario_UPD", dbparams);
* }
* catch (Exception ex)
* {
* throw ex;
* }
* }
*
* /// <summary>
* /// Elimina un JornadaCalendario a partir del id
* /// </summary>
* internal int Delete()
* {
* try
* {
*
*
* return (int)cDblib.Execute("SUPER.IAP30_JornadaCalendario_DEL", dbparams);
* }
* catch (Exception ex)
* {
* throw ex;
* }
* }
*/
#endregion
#region funciones privadas
private SqlParameter Param(enumDBFields dbField, object value)
{
SqlParameter dbParam = null;
string paramName = null;
SqlDbType paramType = default(SqlDbType);
int paramSize = 0;
ParameterDirection paramDirection = ParameterDirection.Input;
switch (dbField)
{
case enumDBFields.codUsu:
paramName = "@t314_idusuario";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.idficepi:
paramName = "@idFicepi";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.codCal:
paramName = "@t066_idcal";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.mes:
paramName = "@nMes";
paramType = SqlDbType.TinyInt;
paramSize = 4;
break;
case enumDBFields.anno:
paramName = "@nAnno";
paramType = SqlDbType.SmallInt;
paramSize = 4;
break;
}
dbParam = cDblib.dbParameter(paramName, paramType, paramSize);
dbParam.Direction = paramDirection;
if (paramDirection == ParameterDirection.Input | paramDirection == ParameterDirection.InputOutput)
{
dbParam.Value = value;
}
return(dbParam);
}
private SqlParameter Param(enumDBFields dbField, object value)
{
SqlParameter dbParam = null;
string paramName = null;
SqlDbType paramType = default(SqlDbType);
int paramSize = 0;
ParameterDirection paramDirection = ParameterDirection.Input;
switch (dbField)
{
case enumDBFields.idPT:
paramName = "@t331_idpt";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.t305_idproyectosubnodo:
paramName = "@t305_idproyectosubnodo";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.sNomPT:
paramName = "@sNomPT";
paramType = SqlDbType.VarChar;
paramSize = 50;
break;
case enumDBFields.t314_idusuario:
paramName = "@t314_idusuario";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.tipoBusq:
paramName = "@sTipoBusq";
paramType = SqlDbType.Char;
paramSize = 1;
break;
}
dbParam = cDblib.dbParameter(paramName, paramType, paramSize);
dbParam.Direction = paramDirection;
if (paramDirection == ParameterDirection.Input | paramDirection == ParameterDirection.InputOutput)
{
dbParam.Value = value;
}
return(dbParam);
}
//#endregion
#region funciones privadas
private SqlParameter Param(enumDBFields dbField, object value)
{
SqlParameter dbParam = null;
string paramName = null;
SqlDbType paramType = default(SqlDbType);
int paramSize = 0;
ParameterDirection paramDirection = ParameterDirection.Input;
switch (dbField)
{
case enumDBFields.t419_anno:
paramName = "@t419_anno";
paramType = SqlDbType.SmallInt;
paramSize = 2;
break;
case enumDBFields.t419_fdesde:
paramName = "@t419_fdesde";
paramType = SqlDbType.DateTime;
paramSize = 8;
break;
case enumDBFields.t419_fhasta:
paramName = "@t419_fhasta";
paramType = SqlDbType.DateTime;
paramSize = 8;
break;
case enumDBFields.t001_idficepi:
paramName = "@t001_idficepi";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.t419_fmodif:
paramName = "@t419_fmodif";
paramType = SqlDbType.DateTime;
paramSize = 8;
break;
}
dbParam = cDblib.dbParameter(paramName, paramType, paramSize);
dbParam.Direction = paramDirection;
if (paramDirection == ParameterDirection.Input | paramDirection == ParameterDirection.InputOutput)
{
dbParam.Value = value;
}
return(dbParam);
}
private SqlParameter Param(enumDBFields dbField, object value)
{
SqlParameter dbParam = null;
string paramName = null;
SqlDbType paramType = default(SqlDbType);
int paramSize = 0;
ParameterDirection paramDirection = ParameterDirection.Input;
switch (dbField)
{
case enumDBFields.t302_denominacion:
paramName = "@t302_denominacion";
paramType = SqlDbType.VarChar;
paramSize = 100;
break;
case enumDBFields.sTipoBusqueda:
paramName = "@sTipoBusqueda";
paramType = SqlDbType.Char;
paramSize = 1;
break;
case enumDBFields.bSoloActivos:
paramName = "@bSoloActivos";
paramType = SqlDbType.Bit;
paramSize = 1;
break;
case enumDBFields.bInternos:
paramName = "@bInternos";
paramType = SqlDbType.Bit;
paramSize = 1;
break;
case enumDBFields.t314_idusuario:
paramName = "@t314_idusuario";
paramType = SqlDbType.Int;
paramSize = 4;
break;
}
dbParam = cDblib.dbParameter(paramName, paramType, paramSize);
dbParam.Direction = paramDirection;
if (paramDirection == ParameterDirection.Input | paramDirection == ParameterDirection.InputOutput)
{
dbParam.Value = value;
}
return(dbParam);
}
//internal List<Models.FormacionDemandada> catFormacionDemandadaExcel(Int32 idficepi, Int32 desde, Int32 hasta, Nullable<Int16> t941_idcolectivo)
//{
// Models.FormacionDemandada oFormacionDemandada = new Models.FormacionDemandada();
// // List<Models.FormacionDemandada> lista = new List<Models.FormacionDemandada>();
// //Parámetros de salida
// SqlParameter nevaluaciones = null;
// Models.FormacionDemandadaSelect1 oFDS1 = null;
// IDataReader dr = null;
// try
// {
// SqlParameter[] dbparams = new SqlParameter[5] {
// Param(ParameterDirection.Input, enumDBFields.idficepi, desde.ToString()),
// Param(ParameterDirection.Input, enumDBFields.desde, desde.ToString()),
// Param(ParameterDirection.Input, enumDBFields.hasta, hasta.ToString()),
// Param(ParameterDirection.Input, enumDBFields.idcolectivo, (t941_idcolectivo==null)?null:t941_idcolectivo.ToString()),
// nevaluaciones = Param(ParameterDirection.Output, enumDBFields.nevaluaciones, "0")
// };
// dr = cDblib.DataReader("PRO_FORMACIONDEMANDADA_GET", dbparams);
// while (dr.Read())
// {
// oFDS1 = new Models.FormacionDemandadaSelect1();
// if (!Convert.IsDBNull(dr["evaluador"]))
// oFDS1.Evaluador = dr["evaluador"].ToString();
// if (!Convert.IsDBNull(dr["evaluado"]))
// oFDS1.Evaluado = dr["evaluado"].ToString();
// if (!Convert.IsDBNull(dr["t930_idvaloracion"]))
// oFDS1.T930_idvaloracion = int.Parse(dr["t930_idvaloracion"].ToString());
// if (!Convert.IsDBNull(dr["t930_formacion"]))
// oFDS1.Formacion = dr["t930_formacion"].ToString();
// if (!Convert.IsDBNull(dr["t934_idmodeloformulario"]))
// oFDS1.idformulario = int.Parse(dr["t934_idmodeloformulario"].ToString());
// oFormacionDemandada.FormacionDemandadaS1.Add(oFDS1);
// }
// return oFormacionDemandada;
// }
// catch (Exception ex)
// {
// throw ex;
// }
// finally
// {
// if (dr != null)
// {
// if (!dr.IsClosed) dr.Close();
// dr.Dispose();
// //Hasta no hacer el dispose, no obtienen valor los parámetros de salida
// oFormacionDemandada.Nevaluciones = Int32.Parse(nevaluaciones.Value.ToString());
// }
// }
//}
#region funciones publicas
#endregion
#region funciones privadas
private SqlParameter Param(ParameterDirection paramDirection, enumDBFields dbField, object value)
{
SqlParameter dbParam = null;
string paramName = null;
SqlDbType paramType = default(SqlDbType);
int paramSize = 0;
switch (dbField)
{
case enumDBFields.desde:
paramName = "@desde";
paramType = SqlDbType.Int;
paramSize = 3;
break;
case enumDBFields.hasta:
paramName = "@hasta";
paramType = SqlDbType.Int;
paramSize = 3;
break;
case enumDBFields.idcolectivo:
paramName = "@idcolectivo";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.nevaluaciones:
paramName = "@nevaluaciones";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.idficepi:
paramName = "@t001_idficepi";
paramType = SqlDbType.Int;
paramSize = 4;
break;
}
dbParam = cDblib.dbParameter(paramName, paramType, paramSize);
dbParam.Direction = paramDirection;
if (paramDirection == ParameterDirection.Input | paramDirection == ParameterDirection.InputOutput)
{
dbParam.Value = value;
}
return(dbParam);
}
private SqlParameter Param(enumDBFields dbField, object value)
{
SqlParameter dbParam = null;
string paramName = null;
SqlDbType paramType = default(SqlDbType);
int paramSize = 0;
ParameterDirection paramDirection = ParameterDirection.Input;
switch (dbField)
{
case enumDBFields.Profesionales:
paramName = "@Profesionales";
paramType = SqlDbType.VarChar;
paramSize = 8000;
break;
case enumDBFields.nDesde:
paramName = "@nDesde";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.nHasta:
paramName = "@nHasta";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.tipo:
paramName = "@tipo";
paramType = SqlDbType.Char;
paramSize = 1;
break;
}
dbParam = cDblib.dbParameter(paramName, paramType, paramSize);
dbParam.Direction = paramDirection;
if (paramDirection == ParameterDirection.Input | paramDirection == ParameterDirection.InputOutput)
{
dbParam.Value = value;
}
return(dbParam);
}
///// <summary>
///// Inserta un Historial
///// </summary>
//internal int Insert(Models.Historial oHistorial)
//{
// try
// {
// SqlParameter[] dbparams = new SqlParameter[4] {
// Param(enumDBFields.t431_denominacion, oHistorial.t431_denominacion),
// Param(enumDBFields.t659_fecha, oHistorial.t659_fecha),
// Param(enumDBFields.Profesional, oHistorial.Profesional),
// Param(enumDBFields.t659_motivo, oHistorial.t659_motivo)
// };
// return (int)cDblib.Execute("_Historial_INS", dbparams);
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
///// <summary>
///// Obtiene un Historial a partir del id
///// </summary>
//internal Models.Historial Select()
//{
// Models.Historial oHistorial = null;
// IDataReader dr = null;
// try
// {
// dr = cDblib.DataReader("_Historial_SEL", dbparams);
// if (dr.Read())
// {
// oHistorial = new Models.Historial();
// if(!Convert.IsDBNull(dr["t431_denominacion"]))
// oHistorial.t431_denominacion=Convert.ToString(dr["t431_denominacion"]);
// oHistorial.t659_fecha=Convert.ToDateTime(dr["t659_fecha"]);
// if(!Convert.IsDBNull(dr["Profesional"]))
// oHistorial.Profesional=Convert.ToString(dr["Profesional"]);
// oHistorial.t659_motivo=Convert.ToString(dr["t659_motivo"]);
// }
// return oHistorial;
// }
// catch (Exception ex)
// {
// throw ex;
// }
// finally
// {
// if (dr != null)
// {
// if (!dr.IsClosed) dr.Close();
// dr.Dispose();
// }
// }
//}
///// <summary>
///// Actualiza un Historial a partir del id
///// </summary>
//internal int Update(Models.Historial oHistorial)
//{
// try
// {
// SqlParameter[] dbparams = new SqlParameter[4] {
// Param(enumDBFields.t431_denominacion, oHistorial.t431_denominacion),
// Param(enumDBFields.t659_fecha, oHistorial.t659_fecha),
// Param(enumDBFields.Profesional, oHistorial.Profesional),
// Param(enumDBFields.t659_motivo, oHistorial.t659_motivo)
// };
// return (int)cDblib.Execute("_Historial_UPD", dbparams);
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
///// <summary>
///// Elimina un Historial a partir del id
///// </summary>
//internal int Delete()
//{
// try
// {
// return (int)cDblib.Execute("_Historial_DEL", dbparams);
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
/// <summary>
/// Obtiene todos los Historial
/// </summary>
//internal List<Models.Historial> Catalogo(Models.Historial oHistorialFilter)
//{
// Models.Historial oHistorial = null;
// List<Models.Historial> lst = new List<Models.Historial>();
// IDataReader dr = null;
// try
// {
// SqlParameter[] dbparams = new SqlParameter[4] {
// Param(enumDBFields.t431_denominacion, oTEMP_HistorialFilter.t431_denominacion),
// Param(enumDBFields.t659_fecha, oTEMP_HistorialFilter.t659_fecha),
// Param(enumDBFields.Profesional, oTEMP_HistorialFilter.Profesional),
// Param(enumDBFields.t659_motivo, oTEMP_HistorialFilter.t659_motivo)
// };
// dr = cDblib.DataReader("_Historial_CAT", dbparams);
// while (dr.Read())
// {
// oHistorial = new Models.Historial();
// if (!Convert.IsDBNull(dr["t431_denominacion"]))
// oHistorial.t431_denominacion = Convert.ToString(dr["t431_denominacion"]);
// oHistorial.t659_fecha = Convert.ToDateTime(dr["t659_fecha"]);
// if (!Convert.IsDBNull(dr["Profesional"]))
// oHistorial.Profesional = Convert.ToString(dr["Profesional"]);
// oHistorial.t659_motivo = Convert.ToString(dr["t659_motivo"]);
// lst.Add(oHistorial);
// }
// return lst;
// }
// catch (Exception ex)
// {
// throw ex;
// }
// finally
// {
// if (dr != null)
// {
// if (!dr.IsClosed) dr.Close();
// dr.Dispose();
// }
// }
//}
#endregion
#region funciones privadas
private SqlParameter Param(enumDBFields dbField, object value)
{
SqlParameter dbParam = null;
string paramName = null;
SqlDbType paramType = default(SqlDbType);
int paramSize = 0;
ParameterDirection paramDirection = ParameterDirection.Input;
switch (dbField)
{
case enumDBFields.t431_denominacion:
paramName = "@t431_denominacion";
paramType = SqlDbType.VarChar;
paramSize = 20;
break;
case enumDBFields.t659_fecha:
paramName = "@t659_fecha";
paramType = SqlDbType.DateTime;
paramSize = 8;
break;
case enumDBFields.Profesional:
paramName = "@Profesional";
paramType = SqlDbType.VarChar;
paramSize = 150;
break;
case enumDBFields.t659_motivo:
paramName = "@t659_motivo";
paramType = SqlDbType.VarChar;
paramSize = 500;
break;
}
dbParam = cDblib.dbParameter(paramName, paramType, paramSize);
dbParam.Direction = paramDirection;
if (paramDirection == ParameterDirection.Input | paramDirection == ParameterDirection.InputOutput)
{
dbParam.Value = value;
}
return(dbParam);
}
private SqlParameter Param(enumDBFields dbField, object value)
{
SqlParameter dbParam = null;
string paramName = null;
SqlDbType paramType = default(SqlDbType);
int paramSize = 0;
ParameterDirection paramDirection = ParameterDirection.Input;
switch (dbField)
{
case enumDBFields.ta212_idorganizacioncomercial:
paramName = "@ta212_idorganizacioncomercial";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.ta212_denominacion:
paramName = "@ta212_denominacion";
paramType = SqlDbType.VarChar;
paramSize = 50;
break;
case enumDBFields.ta212_codigoexterno:
paramName = "@ta212_codigoexterno";
paramType = SqlDbType.VarChar;
paramSize = 15;
break;
case enumDBFields.ta212_activa:
paramName = "@ta212_activa";
paramType = SqlDbType.Bit;
paramSize = 1;
break;
}
dbParam = cDblib.dbParameter(paramName, paramType, paramSize);
dbParam.Direction = paramDirection;
if (paramDirection == ParameterDirection.Input | paramDirection == ParameterDirection.InputOutput)
{
dbParam.Value = value;
}
return(dbParam);
}
private SqlParameter Param(enumDBFields dbField, object value)
{
SqlParameter dbParam = null;
string paramName = null;
SqlDbType paramType = default(SqlDbType);
int paramSize = 0;
ParameterDirection paramDirection = ParameterDirection.Input;
switch (dbField)
{
case enumDBFields.t314_idusuario:
paramName = "@t314_idusuario";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.t615_fechoraida:
paramName = "@fec_desde";
paramType = SqlDbType.DateTime;
paramSize = 8;
break;
case enumDBFields.t615_fechoravuelta:
paramName = "@fec_hasta";
paramType = SqlDbType.DateTime;
paramSize = 8;
break;
case enumDBFields.t420_idreferencia:
paramName = "@t420_idreferencia";
paramType = SqlDbType.Int;
paramSize = 4;
break;
}
dbParam = cDblib.dbParameter(paramName, paramType, paramSize);
dbParam.Direction = paramDirection;
if (paramDirection == ParameterDirection.Input | paramDirection == ParameterDirection.InputOutput)
{
dbParam.Value = value;
}
return(dbParam);
}
private SqlParameter Param(enumDBFields dbField, object value)
{
SqlParameter dbParam = null;
string paramName = null;
SqlDbType paramType = default(SqlDbType);
int paramSize = 0;
ParameterDirection paramDirection = ParameterDirection.Input;
switch (dbField)
{
case enumDBFields.filtro:
paramName = "@filtro";
paramType = SqlDbType.VarChar;
paramSize = 250;
break;
case enumDBFields.t001_idficepi:
paramName = "@t001_idficepi";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.tipo_itemorigen:
paramName = "@tipo_itemorigen";
paramType = SqlDbType.Char;
paramSize = 1;
break;
case enumDBFields.actuocomoadministrador:
paramName = "@actuocomoadministrador";
paramType = SqlDbType.Bit;
paramSize = 1;
break;
}
dbParam = cDblib.dbParameter(paramName, paramType, paramSize);
dbParam.Direction = paramDirection;
if (paramDirection == ParameterDirection.Input | paramDirection == ParameterDirection.InputOutput)
{
dbParam.Value = value;
}
return(dbParam);
}
private SqlParameter Param(enumDBFields dbField, object value)
{
SqlParameter dbParam = null;
string paramName = null;
SqlDbType paramType = default(SqlDbType);
int paramSize = 0;
ParameterDirection paramDirection = ParameterDirection.Input;
switch (dbField)
{
case enumDBFields.t314_loginhermes:
paramName = "@t314_loginhermes";
paramType = SqlDbType.VarChar;
paramSize = 25;
break;
case enumDBFields.t001_idficepi:
paramName = "@t001_idficepi";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.itemorigen:
paramName = "@tipo_item";
paramType = SqlDbType.Char;
paramSize = 1;
break;
case enumDBFields.rowid:
paramName = "@rowid";
paramType = SqlDbType.VarChar;
paramSize = 50;
break;
}
dbParam = cDblib.dbParameter(paramName, paramType, paramSize);
dbParam.Direction = paramDirection;
if (paramDirection == ParameterDirection.Input | paramDirection == ParameterDirection.InputOutput)
{
dbParam.Value = value;
}
return(dbParam);
}
private SqlParameter Param(enumDBFields dbField, object value)
{
SqlParameter dbParam = null;
string paramName = null;
SqlDbType paramType = default(SqlDbType);
int paramSize = 0;
ParameterDirection paramDirection = ParameterDirection.Input;
switch (dbField)
{
case enumDBFields.ta201_idsubareapreventa:
paramName = "@ta201_idsubareapreventa";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.t001_idficepi:
paramName = "@t001_idficepi";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.ta203_figura:
paramName = "@ta203_figura";
paramType = SqlDbType.Char;
paramSize = 1;
break;
case enumDBFields.datatable:
paramName = "@TABLAFIGURAS";
paramType = SqlDbType.Structured;
paramSize = 4;
break;
}
dbParam = cDblib.dbParameter(paramName, paramType, paramSize);
dbParam.Direction = paramDirection;
if (paramDirection == ParameterDirection.Input | paramDirection == ParameterDirection.InputOutput)
{
dbParam.Value = value;
}
return(dbParam);
}
private SqlParameter Param(enumDBFields dbField, object value)
{
SqlParameter dbParam = null;
string paramName = null;
SqlDbType paramType = default(SqlDbType);
int paramSize = 0;
ParameterDirection paramDirection = ParameterDirection.Input;
switch (dbField)
{
case enumDBFields.t001_idficepi:
paramName = "@t001_idficepi";
paramType = SqlDbType.Int;
paramSize = 4;
break;
case enumDBFields.profesional:
paramName = "@profesional";
paramType = SqlDbType.VarChar;
paramSize = 50;
break;
case enumDBFields.lista:
paramName = "@lista";
paramType = SqlDbType.VarChar;
break;
case enumDBFields.contenedor:
paramName = "@contenedor";
paramType = SqlDbType.Int;
paramSize = 4;
break;
}
dbParam = cDblib.dbParameter(paramName, paramType, paramSize);
dbParam.Direction = paramDirection;
if (paramDirection == ParameterDirection.Input | paramDirection == ParameterDirection.InputOutput)
{
dbParam.Value = value;
}
return(dbParam);
}
