public int uspINS_RRHH_FORMATIVO_FICHA(BE_RRHH_FORMATIVO_FICHA obj)
{
object[] Parametros = new[] {
(object)UC_FormWeb.mSQLFieldOrNull(obj.IDE_FICHA, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(obj.APELLIDOS, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.NOMBRES, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.DNI, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.FECHA_NACIMIENTO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.IDE_PROGRAMA, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(obj.IDE_CARRERA, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(obj.IDE_UNIVERSIDAD, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(obj.IDE_NIVEL, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(obj.NUM_COLEGIATURA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.RESIDENCIA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.ESTADO_CIVIL, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(obj.TUTOR, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.TUTOR_CORREO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.CARGO_TUTOR, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.INT_SEGMENTACION, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.FIN_CONTRATO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.FORTALEZA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.OPORTUNIDAD, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.USER_REGISTRO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.FOTO_RUTA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.FOTO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.CORREO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.TELEFONO, tgSQLFieldType.TEXT),
};
return(Convert.ToInt32(new Utilitarios().ExecuteScalar("uspINS_RRHH_FORMATIVO_FICHA", Parametros)));
}
public int Mant_Insert_Requerimiento(BE_REQUERIMIENTO oBERequerimiento)
{
object[] Parametros = new[] {
(object)UC_FormWeb.mSQLFieldOrNull(oBERequerimiento.EMPRESA_ORIGEN, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBERequerimiento.CENTRO_COSTO_ORIGEN, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBERequerimiento.CENTRO_COSTO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBERequerimiento.NUMERO_REQUISICION, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(oBERequerimiento.SECUENCIA, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(oBERequerimiento.TIPO_TRABAJADOR, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBERequerimiento.FECHA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBERequerimiento.OBRA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBERequerimiento.CATEGORIA_OBRERO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBERequerimiento.ESPECIALIDAD_TRABAJADOR, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBERequerimiento.USUARIO_CREACION, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBERequerimiento.USUARIO_ACTUALIZACION, tgSQLFieldType.TEXT),
//oBERequerimiento.EMPRESA_ORIGEN = (ddlEmpresas.SelectedValue);
// oBERequerimiento.CENTRO_COSTO_ORIGEN = (ddlCentro.SelectedValue);
// oBERequerimiento.CENTRO_COSTO = (ddlCentro.SelectedValue);
// oBERequerimiento.NUMERO_REQUISICION = Convert.ToInt32(txtRequerimiento.Text);
// oBERequerimiento.TIPO_TRABAJADOR = (ddlCentro.SelectedValue);
// oBERequerimiento.FECHA = Convert.ToDateTime(txtFechaAprobacion.Text);
};
return(Convert.ToInt32(new Utilitarios().ExecuteScalar("USP_INS_TMP_REQUERIMIENTO_PERSONA", Parametros)));
}
public int INS_RRHH_SOL_FORMATIVO(BE_RRHH_SOL_FORMATIVO obj)
{
object[] Parametros = new[] {
(object)UC_FormWeb.mSQLFieldOrNull(obj.IDE_FORMATIVO, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(obj.NOMBRE_PROYECTO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.CENTRO_COSTO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.SUPERVISOR_DIRECTO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.UBICACION, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.ESP_FORMACION, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(obj.CANTIDAD, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(obj.USER_SOLICITA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.B_OBJETIVOS, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.B_ENTREGABLES, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.B_INDICADORES, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.C_INCLUYE, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.C_NO_INCLUYE, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.C_RIESGO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.C_RESTRICCIONES, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.D_REQUISITOS, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.D_COSTO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.D_BENEFICIOS, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.DURACION, tgSQLFieldType.TEXT),
};
return(Convert.ToInt32(new Utilitarios().ExecuteScalar("uspINS_RRHH_SOL_FORMATIVO", Parametros)));
}
//MOD
public int Mant_Insert_registroPersonalMOD_DA(BE_PERSONAL oBEPersonal)
{
object[] Parametros = new[] {
(object)UC_FormWeb.mSQLFieldOrNull(oBEPersonal.i_IDE_EMPLEADO_E, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(oBEPersonal.v_DES_NOMBRE_E, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBEPersonal.v_DES_APEPAT_E, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBEPersonal.v_DES_APEMAT_E, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBEPersonal.f_FEC_FECHA_NACIMIENTO_E, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBEPersonal.f_FEC_FECHA_INGRESO_E, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBEPersonal.v_DES_TELEFONO_E, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBEPersonal.v_DES_CORREO_E, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBEPersonal.v_DES_DIRECCION_E, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBEPersonal.i_DES_ESTADO_CIVIL_E, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(oBEPersonal.b_foto_e, tgSQLFieldType.Binary),
(object)UC_FormWeb.mSQLFieldOrNull(oBEPersonal.i_DES_TIPO_DOCUMENTO_E, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(oBEPersonal.v_DES_DNI_E, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBEPersonal.v_DES_USUARIO_CREACION_E, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBEPersonal.v_DES_CARGO_E, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(oBEPersonal.v_DES_ESPECIALIDAD_E, tgSQLFieldType.NUMERIC),
};
return(Convert.ToInt32(new Utilitarios().ExecuteScalar("USP_REGISTRAR_PERSONAL_RRHH_MOD", Parametros)));
}
public int uspINS_TBL_RequerimientoSubDetalle_PDC_OBSERVA(BE_TBL_RequerimientoSubDetalle oBE)
{
object[] Parametros = new[] {
(object)UC_FormWeb.mSQLFieldOrNull(oBE.Requ_Numero, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.Reqd_CodLinea, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.Reqs_Correlativo, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.D_FECHA_ENVIO_OBRA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.D_CODIGO_CARE, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.D_COMENTARIOS, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.D_OBSERVACION_RUTA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.D_GUIA_RUTA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.D_ESTADO_PROCESO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.D_FECHA_SALE_OBRA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.D_OBSERVACION_FILE, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.D_GUIA_FILE, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.D_HRAS_MIN, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.D_COSTO_HORA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.A_GUIA_INGRESO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.A_SERIE, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.A_PLACA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.A_GUIA_SALIDA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.USUARIO_ATIENDE, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.FECHA_DESPACHO, tgSQLFieldType.TEXT),
};
return(Convert.ToInt32(new UtilCareMenor().ExecuteScalar("uspINS_TBL_RequerimientoSubDetalle_PDC_OBSERVA", Parametros)));
}
public int uspINS_valorizar_equipoMenor(BE_valorizar_equipoMenor oBESOl)
{
object[] Parametros = new[] {
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.IDE_VAL, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.MES, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.ANIO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.Requ_Numero, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.Reqd_CodLinea, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.Reqs_Correlativo, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.Proy_Codigo, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.Prov_RUC, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.FECHA_INICIO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.FECHA_FIN, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.IDE_MONEDA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.PRECIO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.DIA_TRABAJO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.DIA_DSCTO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.TOTAL, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.DESCUENTO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.FLG_FASES, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.USER_VALORIZA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.ide_valor, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.OBSERVA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.HES, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.PERIODO_INICIO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.PERIODO_FIN, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.UNIDAD_TARIFA, tgSQLFieldType.TEXT),
};
return(Convert.ToInt32(new UtilCareMenor().ExecuteScalar("uspINS_valorizar_equipoMenor", Parametros)));
}
public int uspUPD_MOD_REQUERIMIENTO_PERSONAL(BE_MOD_REQUERIMIENTO_PERSONAL oBE)
{
object[] Parametros = new[] {
(object)UC_FormWeb.mSQLFieldOrNull(oBE.REQ_PERSONAL, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.IDE_RESPONSABLE, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.IDE_ETAPAS, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.DNI, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.APE_PATERNO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.APE_MATERNO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.NOMBRES, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.FEC_NACIMIENTO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.UBIGEO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.TELEFONOS, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.IDE_MANO_OBRA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.IDE_CONDICION, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.FEC_EXA_MEDICO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.FEC_CHARLA_TR, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.FEC_CHARLA_SSK, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.FEC_CHARLA_ALTURA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.FEC_CHARLA_ESP_CONFINADO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.FEC_CHARL_CALIENTE, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.FEC_ENTREGA_FILE_TR, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.FEC_ACCESO_PLANTA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.IDE_FOTOCHECK, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.OBSERVACIONES, tgSQLFieldType.TEXT),
};
return(Convert.ToInt32(new Utilitarios().ExecuteScalar("uspUPD_MOD_REQUERIMIENTO_PERSONAL", Parametros)));
}
public int MANT_TBSOLICITUD_PERMISOS_DIA_INSERT_DATOS(BE_TBSOLICITUD_PERMISOS_DIA obj)
{
object[] Parametro = new[] {
(object)UC_FormWeb.mSQLFieldOrNull(obj.Ide_detalle, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(obj.Ide_permiso, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(obj.Fecha, tgSQLFieldType.TEXT),
};
return(Convert.ToInt32(new Utilitarios().ExecuteScalar("dbo.SP_TBSOLICITUD_PERMISOS_DIA_INSERT_DATOS", Parametro)));
}
public int Insertar_Personal_Minuta(BE_OPE_MINUTA objInsertaParticipantes)
{
object[] Parametros = new[] {
(object)UC_FormWeb.mSQLFieldOrNull(objInsertaParticipantes.M_id_minuta, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(objInsertaParticipantes.Dsc_reunion, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(objInsertaParticipantes.Dsc_proyecto, tgSQLFieldType.TEXT),
};
return(Convert.ToInt32(new Utilitarios().ExecuteScalar("USP_INSERTAR_PERSONAL_MINUTA", Parametros)));
}
public int uspINS_RRHH_DESEMPENIO_ETAPAS(BE_RRHH_DESEMPENIO_ETAPAS oBE)
{
object[] Parametros = new[] {
(object)UC_FormWeb.mSQLFieldOrNull(oBE.ANIO, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.USER_REGISTRO, tgSQLFieldType.TEXT),
};
return(Convert.ToInt32(new Utilitarios().ExecuteScalar("uspINS_RRHH_DESEMPENIO_ETAPAS", Parametros)));
}
public DataTable uspINS_RRHH_SOLICITUD_ASIGNACION(BE_RRHH_SOLICITUD_ASIGNACION oBESOl)
{
object[] Parametros = new[] {
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.IDE_ASIGNACION, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.IDE_POSTULANTE, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.COD_CENTRO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.IDE_CARGO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.AREA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.JEFE_DNI, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.UBICACION, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.TIPO_PROCESO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.ORIGEN_POSICION, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.TIPO_RECLUT_OBRA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.TIPO_RECLUT_LIMA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.PISO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.IDE_NIVEL_ACADEMICO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.IDE_CARRERA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.CARRERA_COMENTARIOS, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.NRO_COLEGIATURA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.FLG_COLEGIATURA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.NIVEL_EXP_INGLES, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.FLG_MAESTRIA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.NIVEL_EXP_SOFTWARE, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.IDE_SEXO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.IDE_ESTADO_CIVIL, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.FUNCIONES_PUESTO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.SUELDO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.COMISIONES, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.FLG_GRATIFICACIONES, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.FLG_PREMIO_OBRA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.INICIO_CONTRATO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.TERMINO_CONTRATO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.FLG_VALE_ALIMENTO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.FLG_SEGURO_VIDA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.FLG_ASIG_MOVILIDAD, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.OTROS_BENEFICIOS, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.REGIMEN_TRABAJO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.HORARIO_TRABAJO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.FLG_BONO_DESTAQUE, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.IDE_PASAJE, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.COMENTARIOS_GNRAL, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.IDE_SOLICITANTE, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.IDE_GERENTE, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.USER_REGISTRO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.IDE_GERENCIA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.DNI_TMP, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.NOMBRE_TMP, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.APE_PAT_TMP, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.APE_MAT_TMP, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.ID_EMPRESA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.FILE_SOL, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.FILE_URL, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.FILE_DIR, tgSQLFieldType.TEXT),
};
return(new Utilitarios().EjecutaDatatable("uspINS_RRHH_SOLICITUD_ASIGNACION", Parametros));
}
public int Man_Insert_Datos_Personal_Data(BE_OPE_DETALLE_PERSONAL objDatosParticipante)
{
object[] Parametros = new[] {
(object)UC_FormWeb.mSQLFieldOrNull(objDatosParticipante.Detalle_personal, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(objDatosParticipante.Id_dni, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(objDatosParticipante.Id_minuta, tgSQLFieldType.TEXT),
//(object)UC_FormWeb.mSQLFieldOrNull(objDatosParticipante.Centro_Costo,tgSQLFieldType.TEXT),
};
return(Convert.ToInt32(new Utilitarios().ExecuteScalar("dbo.SP_INSERTAR_DATOS_PARTICIPANTES", Parametros)));
}
public int MANT_USP_AGREGAR_COMENTARIO_DA(BE_OPE_DETALLE_ACUERDOS objAcu)
{
object[] Param = new[] {
(object)UC_FormWeb.mSQLFieldOrNull(objAcu.Id_temas, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(objAcu.Dsc_descripcion, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(objAcu.Est_estado, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(objAcu.Dsc_observacion, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(objAcu.InicialUsuario, tgSQLFieldType.NUMERIC),
};
return(Convert.ToInt32(new Utilitarios().ExecuteScalar("dbo.USP_AGREGAR_COMENTARIO", Param)));
}
public int uspINS_RRHH_ESTRELLA_NOMINACION_VARIOS_OBRA(BE_RRHH_ESTRELLA_NOMINACION_OBRA oBE)
{
object[] Parametros = new[] {
(object)UC_FormWeb.mSQLFieldOrNull(oBE.IDE_NOMINACION, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.DNI_EVALUADO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.DNI_SUPERVISOR, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.FACTORES, tgSQLFieldType.TEXT),
};
return(Convert.ToInt32(new Utilitarios().ExecuteScalar("uspINS_RRHH_ESTRELLA_NOMINACION_VARIOS_OBRA", Parametros)));
}
public int uspINS_RRHH_FORMATIVO_PLANES(BE_RRHH_FORMATIVO_PLANES obj)
{
object[] Parametros = new[] {
(object)UC_FormWeb.mSQLFieldOrNull(obj.IDE_PLANES, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(obj.DURACION, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.DESCRIPCION, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.IDE_FICHA, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(obj.USER_REGISTRO, tgSQLFieldType.TEXT),
};
return(Convert.ToInt32(new Utilitarios().ExecuteScalar("uspINS_RRHH_FORMATIVO_PLANES", Parametros)));
}
public int Mant_Insert_Reconocimiento(BE_RRHH_COMPETENCIAS_EVAL oBE)
{
object[] Parametros = new[] {
(object)UC_FormWeb.mSQLFieldOrNull(oBE.IDE_COMPETENCIA, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.DNI_EVALUADO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.DNI_SUPERVISOR, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.IDE_FACTOR, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.SUSTENTO, tgSQLFieldType.TEXT),
};
return(Convert.ToInt32(new Utilitarios().ExecuteScalar("uspINS_RRHH_COMPETENCIAS_EVAL", Parametros)));
}
public int uspINS_EQUIPO_TRABAJO(BE_EQUIPO_TRABAJO oBE)
{
object[] Parametros = new[] {
(object)UC_FormWeb.mSQLFieldOrNull(oBE.IDE_EQUIPO, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.FLG_ESTADO, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.USER_REGISTRA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.IDE_RESPONSABLE, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.DNI_TRABAJADOR, tgSQLFieldType.NUMERIC),
};
return(Convert.ToInt32(new Utilitarios().ExecuteScalar("uspINS_EQUIPO_TRABAJO", Parametros)));
}
public int Mant_Insert_Asignacion(BE_ASIGNACION_RECURSOS oBE)
{
object[] Parametros = new[] {
(object)UC_FormWeb.mSQLFieldOrNull(oBE.IDE_ASIGNACION, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.ID_DETALLE_REQUERIMIENTO_PERSONAL, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.DES_OBSERVACIONES, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.FLG_ESTADO, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.IDE_UBICACION, tgSQLFieldType.NUMERIC),
};
return(Convert.ToInt32(new Utilitarios().ExecuteScalar("uspINS_ASIGNACION_RECURSOS", Parametros)));
}
public int Mant_Insertar_AcuerdosData(BE_OPE_DETALLE_ACUERDOS objAcuerdos)
{
object[] Parametro = new[] {
(object)UC_FormWeb.mSQLFieldOrNull(objAcuerdos.Id_detalle_acuerdo, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(objAcuerdos.Id_temas, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(objAcuerdos.Dsc_descripcion, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(objAcuerdos.Est_estado, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(objAcuerdos.Dsc_observacion, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(objAcuerdos.Usuario, tgSQLFieldType.TEXT),
};
return(Convert.ToInt32(new Utilitarios().ExecuteScalar("dbo.USP_INSERT_ACUERDOS", Parametro)));
}
public int uspINS_CARTA_COBRAZAS_FILE(BE_CARTA_COBRAZAS_FILE oBE)
{
object[] Parametros = new[] {
(object)UC_FormWeb.mSQLFieldOrNull(oBE.IDE_FILE, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.ARCHIVO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.RUTA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.IDE_CARTA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.NOMBRE_ORIGINAL, tgSQLFieldType.TEXT),
};
return(Convert.ToInt32(new Utilitarios().ExecuteScalar("uspINS_CARTA_COBRAZAS_FILE", Parametros)));
}
public DataTable uspINS_RequerimientoMovil(BE_RequerimientoMovil oBESOl)
{
object[] Parametros = new[] {
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.IdRequerimiento, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.FechaSolicitud, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.IdEmpresaPK, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.centro_costo, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.Requ_Numero, tgSQLFieldType.TEXT),
};
return(new UtilCareMenor().EjecutaDatatable("uspINS_RequerimientoMovil", Parametros));
}
public int INS_LOG_SOLPED_DETALLE(BE_LOG_SOLPED_DETALLE oBE)
{
object[] Parametros = new[] {
(object)UC_FormWeb.mSQLFieldOrNull(oBE.IDE_PEDIDO, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.MATERIAL, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.CANTIDAD, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.COD_PEDIDO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.IDE_SOLICITUD, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.PEP, tgSQLFieldType.TEXT),
};
return(Convert.ToInt32(new Utilitarios().ExecuteScalar("uspINS_LOG_SOLPED_DETALLE", Parametros)));
}
public int uspINS_TAREO(BE_TAREO oBESOl)
{
object[] Parametros = new[] {
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.IDE_TAREO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.FECHA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.IDE_LOTE, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.HRS, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBESOl.IDE_PERSONA, tgSQLFieldType.TEXT),
};
return(Convert.ToInt32(new Util().ExecuteScalar("uspINS_TAREO", Parametros)));
}
public int uspINS_MOD_REQUERIMIENTO(BE_MOD_REQUERIMIENTO oBE)
{
object[] Parametros = new[] {
(object)UC_FormWeb.mSQLFieldOrNull(oBE.IDE_MOD, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.CODIGO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.FECHA_REQUERIMIENTO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.IP_CENTRO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.CENTRO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.USER_REGISTRO, tgSQLFieldType.TEXT),
};
return(Convert.ToInt32(new Utilitarios().ExecuteScalar("uspINS_MOD_REQUERIMIENTO", Parametros)));
}
public int uspINS_RRHH_FORMATIVO_EXAM_CARTILLA(BE_RRHH_FORMATIVO_EXAM_CARTILLA obj)
{
object[] Parametros = new[] {
(object)UC_FormWeb.mSQLFieldOrNull(obj.IDE_EXAMEN, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(obj.IDE_PREGUNTA, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(obj.IDE_NOTA, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(obj.EVALUADOR, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.EVALUADO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.IDE_EVAL_EXAMEN, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(obj.IDE_PROGRAMA, tgSQLFieldType.NUMERIC),
};
return(Convert.ToInt32(new Utilitarios().ExecuteScalar("uspINS_RRHH_FORMATIVO_EXAM_CARTILLA", Parametros)));
}
public int uspINS_CARTA_COBRAZAS_APROBACIONES(BE_CARTA_COBRAZAS_APROBACIONES oBE)
{
object[] Parametros = new[] {
(object)UC_FormWeb.mSQLFieldOrNull(oBE.IDE_APROBACION, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.IDE_CARTA, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.D_IPE_CENTRO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.D_CENTRO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.DNI_APRUEBA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.TIPO_CARGO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.CARGO, tgSQLFieldType.TEXT),
};
return(Convert.ToInt32(new Utilitarios().ExecuteScalar("uspINS_CARTA_COBRAZAS_APROBACIONES", Parametros)));
}
public int uspSEL_RRHH_DESEMPENIO_INSERT_VARIOS(BE_RRHH_DESEMPENIO_FICHA oBE)
{
object[] Parametros = new[] {
(object)UC_FormWeb.mSQLFieldOrNull(oBE.CCENTRO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.CODIGO_GERENCIA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.IP_CENTRO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.ANIO, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.DNI_JEFE, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.DNI_GERENTE, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.USER_REGISTRA, tgSQLFieldType.TEXT),
};
return(Convert.ToInt32(new Utilitarios().ExecuteScalar("uspSEL_RRHH_DESEMPENIO_INSERT_VARIOS", Parametros)));
}
public int uspINS_MOD_REQUERIMIENTO_DETALLE(BE_MOD_REQUERIMIENTO_DETALLE oBE)
{
object[] Parametros = new[] {
(object)UC_FormWeb.mSQLFieldOrNull(oBE.IDE_REQUERIMIENTO, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.IDE_MOD, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.IDE_CATEGORIA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.IDE_ESPECIALIDAD, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.CANTIDAD, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.IP_CENTRO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.USER_REGISTRO, tgSQLFieldType.TEXT),
};
return(Convert.ToInt32(new Utilitarios().ExecuteScalar("uspINS_MOD_REQUERIMIENTO_DETALLE", Parametros)));
}
public int INS_RRHH_SOL_HITO(BE_RRHH_SOL_HITO obj)
{
object[] Parametros = new[] {
(object)UC_FormWeb.mSQLFieldOrNull(obj.IDE_HITOS, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(obj.IDE_FORMATIVO, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(obj.DESCRIPCION, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.FECHA_HITO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.TIPO, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(obj.HOLDER, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.ROL, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(obj.INTERACCION, tgSQLFieldType.TEXT),
};
return(Convert.ToInt32(new Utilitarios().ExecuteScalar("uspINS_RRHH_SOL_HITO", Parametros)));
}
public int uspINS_TBL_RequerimientoSubDetalle_PDC_AMPLIACION(BE_TBL_RequerimientoSubDetalle oBE)
{
object[] Parametros = new[] {
(object)UC_FormWeb.mSQLFieldOrNull(oBE.Requ_Numero, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.Reqd_CodLinea, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.Reqs_Correlativo, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.D_PDC, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.D_PDC_MONTO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.D_PDC_MONTO_TOTAL, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.D_PDC_MONTO_MOVIL, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.GUID, tgSQLFieldType.TEXT),
};
return(Convert.ToInt32(new UtilCareMenor().ExecuteScalar("uspINS_TBL_RequerimientoSubDetalle_PDC_AMPLIACION", Parametros)));
}
