/// <summary> /// Obtiene la Lista de los items de documentos de de una Solicitud, desde la BD /// </summary> /// <param name="pNroSolicitudSEC">Nro de Solicitud</param> /// <returns></returns> public ArrayList ListarItemsDoc(long pNroSolicitudSEC) { //--parametro de salida DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_COD_SEC", DbType.Int64, ParameterDirection.Input), new DAABRequest.Parameter("P_ITEMS_DOC", DbType.Object, ParameterDirection.Output) }; if (!pNroSolicitudSEC.Equals(-1)) { arrParam[0].Value = pNroSolicitudSEC; } BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.PKG_SISACT_ACUERDO + ".DOCUMENTO_SEC_Listar_X_SEC"; obRequest.Parameters.AddRange(arrParam); ArrayList filas = new ArrayList(); IDataReader dr = null; try { dr = obRequest.Factory.ExecuteReader(ref obRequest).ReturnDataReader; while (dr.Read()) { DocumentoSEC_Desc item = new DocumentoSEC_Desc(); item.ID_DOCUMENTO_SEC = Funciones.CheckInt64(dr["ID_DOCUMENTO_SEC"]); item.COD_SEC = Funciones.CheckInt64(dr["COD_SEC"]); item.ID_DOCUMENTO = Funciones.CheckInt(dr["ID_DOCUMENTO"]); item.DESC_TIPO_DOCUMENTO = Funciones.CheckStr(dr["DESC_TIPO_DOCUMENTO"]); item.DESC_DOCUMENTO = Funciones.CheckStr(dr["DESC_DOCUMENTO"]); item.NOMBRE_GLOSA = Funciones.CheckStr(dr["NOMBRE_GLOSA"]); item.COD_ESTADO = Funciones.CheckStr(dr["COD_ESTADO"]); item.DESC_ESTADO = Funciones.CheckStr(dr["DESC_ESTADO"]); item.TIPO_CREACION = Funciones.CheckStr(dr["TIPO_CREACION"]); item.DESC_TIPO_CREACION = Funciones.CheckStr(dr["DESC_TIPO_CREACION"]); item.FECHA_CREACION = Funciones.CheckDate(dr["FECHA_CREACION"]); item.NOMBRE_ARCHIVO = Funciones.CheckStr(dr["NOMBRE_ARCHIVO"]); //agregado 25-05-2010 //--agrega item filas.Add(item); } } catch (Exception e) { throw e; } finally { if (dr != null && dr.IsClosed == false) { dr.Close(); } obRequest.Parameters.Clear(); obRequest.Factory.Dispose(); } return(filas); }
public bool MantenimientoPlan3Play(string strAccion, Plan3Play oPlan) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_RESULTADO", DbType.Int32, ParameterDirection.Output), new DAABRequest.Parameter("P_ACCION", DbType.String, 2,ParameterDirection.Input), new DAABRequest.Parameter("P_PARAM_GENERALES", DbType.String, 4000,ParameterDirection.Input), new DAABRequest.Parameter("P_PLAZOS", DbType.String, 4000,ParameterDirection.Input), new DAABRequest.Parameter("P_SERVICIOS", DbType.String, 4000,ParameterDirection.Input), new DAABRequest.Parameter("P_ALQUILER", DbType.String, 4000,ParameterDirection.Input), new DAABRequest.Parameter("P_PLNV_USUARIO_CREA", DbType.String, 4000,ParameterDirection.Input) }; int i = 0; for (i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } i = 1; arrParam[i].Value = strAccion; i++; arrParam[i].Value = oPlan.PARAM_GENERALES; i++; arrParam[i].Value = oPlan.PLAZOS; i++; arrParam[i].Value = oPlan.SERVICIOS; i++; arrParam[i].Value = oPlan.ALQUILER; i++; arrParam[i].Value = oPlan.PLNV_USUARIO_CREA; bool blnOK = false; int resultado; BDSISACT oBDSISACT = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = oBDSISACT.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.PKG_SISACT_MANTENIMIENTO_3PLAY + ".SP_MAN_PLAN"; obRequest.Parameters.AddRange(arrParam); obRequest.Transactional = true; try { obRequest.Factory.ExecuteNonQuery(ref obRequest); obRequest.Factory.CommitTransaction(); IDataParameter parSalida1 = (IDataParameter)obRequest.Parameters[0]; resultado = Funciones.CheckInt(parSalida1.Value); if (resultado == 1) { blnOK = true; } } catch (Exception ex) { obRequest.Factory.RollBackTransaction(); throw ex; } finally { obRequest.Factory.Dispose(); } return(blnOK); }
public ArrayList ConsultarPerfilesMonto(string v_tipo, double v_cantidad) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("V_NAC_TIPO", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("V_NAC_CANTIDAD", DbType.Double, ParameterDirection.Input), new DAABRequest.Parameter("K_PERFILES", DbType.Object, ParameterDirection.Output) }; int i = 0; for (i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } i = 0; arrParam[i].Value = v_tipo; ++i; arrParam[i].Value = v_cantidad; //BDSISMANT obj = new BDSISMANT(BaseDatos.BD_SISACT); BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.PKG_SISACT_VENTA_EXPRESS + ".SISACTSS_PERFILES_X_MONTO"; obRequest.Parameters.AddRange(arrParam); ArrayList Filas = new ArrayList(); IDataReader dr = null; try { dr = obRequest.Factory.ExecuteReader(ref obRequest).ReturnDataReader; if (dr != null) { while (dr.Read()) { ItemGenerico item = new ItemGenerico(); item.Descripcion2 = Funciones.CheckStr(dr["NAN_PERFIL_VINCULADO"]); item.Descripcion = Funciones.CheckStr(dr["NAV_PERFIL_DESC"]); item.Monto = Funciones.CheckDbl(dr["NAC_CANTIDAD"]); Filas.Add(item); } } } catch (Exception ex) { throw ex; } finally { if (dr != null && dr.IsClosed == false) { dr.Close(); } obRequest.Parameters.Clear(); obRequest.Factory.Dispose(); } return(Filas); }
// ldrz, maquino public DataTable fdtbListarProductos() { DataTable dtResultado = new DataTable(); DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_CURSOR", DbType.Object, ParameterDirection.Output) }; arrParam[0].Value = DBNull.Value; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest objRequest = obj.CreaRequest(); objRequest.CommandType = CommandType.StoredProcedure; objRequest.Command = BaseDatos.PKG_SISACT_MANT_POSTVENTA + ".SP_CON_TIPO_PRODUCTO"; objRequest.Parameters.AddRange(arrParam); try { dtResultado = objRequest.Factory.ExecuteDataset(ref objRequest).Tables[0]; } catch (Exception ex) { throw ex; } finally { objRequest.Factory.Dispose(); } return(dtResultado); }
//PROY-24740 public string ConsultarTextoRangoLC(string strTipoDocumento, string strNroDocumento, double dblLC) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_COMENTARIO_LC", DbType.String, 50, ParameterDirection.Output), new DAABRequest.Parameter("P_TIPO_DOC", DbType.String, 2, ParameterDirection.Input), new DAABRequest.Parameter("P_LC", DbType.Double, ParameterDirection.Input) } ; int i; i = 1; arrParam[i].Value = strTipoDocumento; i++; arrParam[i].Value = dblLC; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest objRequest = obj.CreaRequest(); objRequest.CommandType = CommandType.StoredProcedure; objRequest.Command = string.Format("{0}{1}", BaseDatos.PKG_SISACT_EVALUACION_UNI, ".SP_CON_TEXTO_RANGO_LC"); objRequest.Parameters.AddRange(arrParam); string strTextoLC = string.Empty; try { objRequest.Factory.ExecuteNonQuery(ref objRequest); strTextoLC = Funciones.CheckStr(((IDataParameter)objRequest.Parameters[0]).Value); } finally { objRequest.Factory.Dispose(); } return(strTextoLC); }
public int consultarPeriodoRenovaciones(string linea) { DAABRequest.Parameter[] arrParam = { new DAAB.DAABRequest.Parameter("P_LINEA", DbType.String, 20, linea, ParameterDirection.Input), new DAAB.DAABRequest.Parameter("K_RESULTADO", DbType.Int32, ParameterDirection.Output) }; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.PKG_SISACT_MANT_PLN + ".SISACT_LISTA_RENOVACIONES_SEL"; obRequest.Parameters.AddRange(arrParam); ArrayList lista = new ArrayList(); int resultado; try { obRequest.Factory.ExecuteNonQuery(ref obRequest); IDataParameter parSalida1; parSalida1 = (IDataParameter)obRequest.Parameters[obRequest.Parameters.Count - 1]; resultado = Funciones.CheckInt(parSalida1.Value); } catch (Exception) { resultado = 0; } finally { obRequest.Factory.Dispose(); } return(resultado); }
public ArrayList ListarTipoOferta(string strTipoDocumento) { ArrayList filas = null; DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_CURSOR", DbType.Object, ParameterDirection.Output) }; arrParam[0].Value = DBNull.Value; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.PKG_SISACT_RENOVACION + ".SP_CON_TIPO_OFERTA"; obRequest.Parameters.AddRange(arrParam); filas = new ArrayList(); IDataReader dr = null; try { dr = obRequest.Factory.ExecuteReader(ref obRequest).ReturnDataReader; while (dr.Read()) { ItemGenerico oItem = new ItemGenerico(); oItem.Codigo = Funciones.CheckStr(dr["TOFC_CODIGO"]); oItem.Descripcion = Funciones.CheckStr(dr["TOFV_DESCRIPCION"]); if (strTipoDocumento != System.Configuration.ConfigurationSettings.AppSettings["TipoDocumentoRUC"].ToString()) { filas.Add(oItem); } else { if (oItem.Codigo != System.Configuration.ConfigurationSettings.AppSettings["constCodTipoProductoB2E"].ToString()) { filas.Add(oItem); } } } } catch (Exception e) { throw e; } finally { if (dr != null && dr.IsClosed == false) { dr.Close(); } obRequest.Parameters.Clear(); obRequest.Factory.Dispose(); } return(filas); }
public bool ActualizarPaquete3Play(Paquete3Play oPaquete3Play) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_PAQTV_CODIGO", DbType.String, 5, ParameterDirection.Input), new DAABRequest.Parameter("P_PAQTV_DESCRIPCION", DbType.String, 50, ParameterDirection.Input), new DAABRequest.Parameter("P_TPAQTV_CODIGO", DbType.Int32, ParameterDirection.Input), new DAABRequest.Parameter("P_TPROC_CODIGO", DbType.String, 2, ParameterDirection.Input), new DAABRequest.Parameter("P_PLANC_CODIGO", DbType.String, 3, ParameterDirection.Input), new DAABRequest.Parameter("P_TPDOC_CODIGO", DbType.String, 2, ParameterDirection.Input), new DAABRequest.Parameter("P_PRDC_CODIGO", DbType.String, 2, ParameterDirection.Input), new DAABRequest.Parameter("K_RESULTADO", DbType.Int32, ParameterDirection.Output), new DAABRequest.Parameter("P_ESTADO", DbType.String, 1, ParameterDirection.Input) }; int i = 0; for (i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } arrParam[0].Value = oPaquete3Play.PAQTV_CODIGO; arrParam[1].Value = oPaquete3Play.PAQTV_DESCRIPCION; arrParam[2].Value = oPaquete3Play.TPAQTV_CODIGO; arrParam[3].Value = oPaquete3Play.TPROC_CODIGO; arrParam[4].Value = oPaquete3Play.PLANC_CODIGO; arrParam[5].Value = oPaquete3Play.TPDOC_CODIGO; arrParam[6].Value = oPaquete3Play.PRDC_CODIGO; arrParam[8].Value = oPaquete3Play.PAQTC_ESTADO; bool salida = false; BDSISACT oBDSISACT = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = oBDSISACT.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.PKG_SISACT_MANTENIMIENTO_3PLAY + ".SISACT_UPD_PAQUETE_3PLAY"; obRequest.Parameters.AddRange(arrParam); obRequest.Transactional = true; try { obRequest.Factory.ExecuteNonQuery(ref obRequest); obRequest.Factory.CommitTransaction(); salida = true; } catch (Exception ex) { obRequest.Factory.RollBackTransaction(); string rMsg = "Error al Modificar en Paquete 3Play. \nMensaje : " + ex.Message; throw ex; } finally { obRequest.Factory.Dispose(); } return(salida); }
public bool ActualizarNivelesDeAprobacion(int v_codigo, string v_estado, int v_cantidad, string v_usuario) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("V_NAN_CODIGO", DbType.Int64, ParameterDirection.Input), new DAABRequest.Parameter("V_NAC_ESTADO", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("V_NAC_CANTIDAD", DbType.Int64, ParameterDirection.Input), new DAABRequest.Parameter("V_NAV_USUAC_MODI", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("V_VALOR_RETORNO", DbType.Int64, ParameterDirection.Output) }; int i = 0; for (i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } i = 0; arrParam[i].Value = v_codigo; ++i; arrParam[i].Value = v_estado; ++i; arrParam[i].Value = v_cantidad; ++i; arrParam[i].Value = v_usuario; bool salida = false; //BDSISMANT obj = new BDSISMANT(BaseDatos.BD_SISACT); BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.PKG_SISACT_VENTA_EXPRESS + ".SISACTSU_NIV_APROB"; obRequest.Parameters.AddRange(arrParam); obRequest.Transactional = true; try { obRequest.Factory.ExecuteNonQuery(ref obRequest); obRequest.Factory.CommitTransaction(); } catch (Exception ex) { obRequest.Factory.RollBackTransaction(); throw ex; } finally { IDataParameter parSalida1; parSalida1 = (IDataParameter)obRequest.Parameters[obRequest.Parameters.Count - 1]; obRequest.Factory.Dispose(); if (parSalida1.Value.ToString() == "0") { salida = false; } else { salida = true; } } return(salida); }
public bool RegistrarAlumno(string sTipoDoc, string sNroDoc, Int64 iCodInst, string sCodPersona, string sUsuario, ref string sCodMensaje, ref string sMensaje) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("pin_tipo_documento", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("pin_nro_documento", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("pin_cod_institucion", DbType.Int64, ParameterDirection.Input), new DAABRequest.Parameter("pin_cod_persona", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("pin_usuario", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("pout_respuesta_codigo", DbType.Int64, ParameterDirection.Output), new DAABRequest.Parameter("pout_respuesta_mensaje", DbType.String, ParameterDirection.Output) }; bool salida = false; for (int i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } arrParam[0].Value = sTipoDoc; arrParam[1].Value = sNroDoc; arrParam[2].Value = iCodInst; arrParam[3].Value = sCodPersona; arrParam[4].Value = sUsuario; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.PKG_SISACT_CAMPANA_ESPECIAL + ".sisacsiu_log_whitelist"; obRequest.Parameters.AddRange(arrParam); obRequest.Transactional = true; try { obRequest.Factory.ExecuteNonQuery(ref obRequest); IDataParameter pSalida1, pSalida2; pSalida1 = (IDataParameter)obRequest.Parameters[5]; pSalida2 = (IDataParameter)obRequest.Parameters[6]; sCodMensaje = Funciones.CheckStr(pSalida1.Value); sMensaje = Funciones.CheckStr(pSalida2.Value); obRequest.Factory.CommitTransaction(); salida = true; } catch (Exception ex) { obRequest.Factory.RollBackTransaction(); sCodMensaje = "-1"; sMensaje = "ERROR AL EJECUTAR SP: " + BaseDatos.PKG_SISACT_CAMPANA_ESPECIAL + ".sisacsiu_log_whitelist - " + ex.Message.ToString(); } finally { obRequest.Factory.Dispose(); } return(salida); }
/// <summary> /// Obtiene la Lista los Analistas de Creditos y Activaciones por Area, desde la BD /// </summary> /// <param name="pCodArea">Código de Área</param> /// <returns>Lista de Analistas</returns> public ArrayList listaAnalistasCyA_p_Rederivar(string pLoginUsuarioDerivador) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_LOGIN_DERIVADOR", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_OUT", DbType.Object, ParameterDirection.Output) }; for (int i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } if (pLoginUsuarioDerivador.Length > 0) { arrParam[0].Value = pLoginUsuarioDerivador; } BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.PKG_EVALUACION_SEC + ".ANALISTAS_CYA_Lista_X_Derivad"; obRequest.Parameters.AddRange(arrParam); ArrayList salida = new ArrayList(); IDataReader dr = null; try { dr = obRequest.Factory.ExecuteReader(ref obRequest).ReturnDataReader; ItemGenerico item = null; while (dr.Read()) { item = new ItemGenerico(); item.Codigo = Funciones.CheckStr(dr["CYA_USERNT"]); item.Descripcion = Funciones.CheckStr(dr["CYA_NOMCOM"]); salida.Add(item); } } catch (Exception e) { throw e; } finally { if (dr != null && dr.IsClosed == false) { dr.Close(); } obRequest.Parameters.Clear(); obRequest.Factory.Dispose(); } return(salida); }
public ArrayList ListaPaqueteVas(int vas_codigo) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_VSERN_COD_VAS", DbType.Int64, ParameterDirection.Input), new DAABRequest.Parameter("K_CUR_SALIDA", DbType.Object, ParameterDirection.Output) }; for (int i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } if (!vas_codigo.Equals("")) { arrParam[0].Value = vas_codigo; } BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.PKG_SISACT_SERVICIO_VAS + ".SISACT_CONS_PAQUETE"; obRequest.Parameters.AddRange(arrParam); ArrayList filas = new ArrayList(); IDataReader dr = null; try { dr = obRequest.Factory.ExecuteReader(ref obRequest).ReturnDataReader; while (dr.Read()) { TipoPaqueteVas item = new TipoPaqueteVas(); item.VASN_CODIGO = Funciones.CheckInt(dr["VSERN_COD_PAQ"]); item.DESV_PAQUETE = Funciones.CheckStr(dr["VPAQV_DES_PAQ"]); item.DESV_DET_PAQUETE = Funciones.CheckStr(dr["DETALLE_PAQUETE"]); item.COSTN_SERVICIO = Funciones.CheckDbl(dr["VSERN_COS_SERV"]); item.FRECV_TIEMPO = Funciones.CheckStr(dr["VSERV_FRECUENCIA"]); filas.Add(item); } } catch (Exception e) { throw e; } finally { if (dr != null && dr.IsClosed == false) { dr.Close(); } obRequest.Parameters.Clear(); obRequest.Factory.Dispose(); } return(filas); }
public bool InsertarDetaClaroPuntos(Int64 ID_CANJE_PUNTOS, string SERIE_ARTICULO, Int64 PUNTOS_USADOS, decimal SOLES_DESCUENTO, ref string CODIGO_RESPUESTA, ref string MENSAJE_RESPUESTA) { bool resultado = false; DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_ID_CANJE_PUNTO", DbType.Int64, ParameterDirection.Input), new DAABRequest.Parameter("P_SERIE_ARTICULO", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_PUNTOS_USADOS", DbType.Int64, ParameterDirection.Input), new DAABRequest.Parameter("P_SOLES_DESCUENTO", DbType.Decimal, ParameterDirection.Input), new DAABRequest.Parameter("P_CODIGO_RESPUESTA", DbType.String, ParameterDirection.Output), new DAABRequest.Parameter("P_MENSAJE_RESPUESTA", DbType.String, 100, ParameterDirection.Output) }; int i; for (i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } arrParam[0].Value = ID_CANJE_PUNTOS; arrParam[1].Value = SERIE_ARTICULO; arrParam[2].Value = PUNTOS_USADOS; arrParam[3].Value = SOLES_DESCUENTO; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.SISACT_PKG_PROCESOS + Constantes.SisactInsertarDetaClaroPuntos; obRequest.Parameters.AddRange(arrParam); IDataReader dr = null; try { obRequest.Factory.ExecuteNonQuery(ref obRequest); CODIGO_RESPUESTA = Funciones.CheckStr(((IDataParameter)obRequest.Parameters[4]).Value); MENSAJE_RESPUESTA = Funciones.CheckStr(((IDataParameter)obRequest.Parameters[5]).Value); if (CODIGO_RESPUESTA == "0") { resultado = true; } } finally { if (dr != null && dr.IsClosed == false) { dr.Close(); } obRequest.Parameters.Clear(); obRequest.Factory.Dispose(); } return(resultado); }
public void Insertar_Correccion_Nombres(Vista_Correccion_Nombres oItem) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_TIPO_DOCUMENTO", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_NRO_DOCUMENTO", DbType.String, 11,ParameterDirection.Input), new DAABRequest.Parameter("P_NOMBRE_ANTERIOR", DbType.String, 40,ParameterDirection.Input), new DAABRequest.Parameter("P_AP_PAT_ANTERIOR", DbType.String, 40,ParameterDirection.Input), new DAABRequest.Parameter("P_AP_MAT_ANTERIOR", DbType.String, 40,ParameterDirection.Input), new DAABRequest.Parameter("P_NOMBRE_NUEVO", DbType.String, 40,ParameterDirection.Input), new DAABRequest.Parameter("P_AP_PAT_NUEVO", DbType.String, 40,ParameterDirection.Input), new DAABRequest.Parameter("P_AP_MAT_NUEVO", DbType.String, 40,ParameterDirection.Input), new DAABRequest.Parameter("P_SOLIN_CODIGO", DbType.Int64, ParameterDirection.Input), new DAABRequest.Parameter("P_TERMINAL", DbType.String, 20,ParameterDirection.Input), new DAABRequest.Parameter("P_USU_CREA", DbType.String, 10,ParameterDirection.Input), new DAABRequest.Parameter("P_CLIED_FEC_NAC", DbType.Date, ParameterDirection.Input) }; int i = 0; for (i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } arrParam[0].Value = oItem.SIVNC_TIPO_DOCUMENTO; arrParam[1].Value = oItem.SIVNV_NUM_DOCUMENTO; arrParam[2].Value = oItem.SIVNV_NOMBRE_ANTERIOR; arrParam[3].Value = oItem.SIVNV_APE_PATERNO_ANT; arrParam[4].Value = oItem.SIVNV_APE_MATERNO_ANT; arrParam[5].Value = oItem.SIVNV_NOMBRE_NUEVO; arrParam[6].Value = oItem.SIVNV_APE_PATERNO_NUEVO; arrParam[7].Value = oItem.SIVNV_APE_MATERNO_NUEVO; arrParam[8].Value = oItem.SIVNV_SOLIN_CODIGO; arrParam[9].Value = oItem.SIVNV_TERMINAL; arrParam[10].Value = oItem.SIVNV_USUARIO_CREACION; arrParam[11].Value = oItem.FECHA_NACIMIENTO; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.PKG_SISACT_EVALUACION_CONS_2 + ".SP_ACTUALIZAR_NOMBRES_DC"; obRequest.Parameters.AddRange(arrParam); obRequest.Transactional = true; try { obRequest.Factory.ExecuteNonQuery(ref obRequest); obRequest.Factory.CommitTransaction(); } catch (Exception e) { obRequest.Factory.RollBackTransaction(); throw e; } finally { obRequest.Factory.Dispose(); obRequest.Parameters.Clear(); } }
public void ObtenerCantidadMaxMinAutorizacion(ref double nCantidadMaxima, ref double nCantidadMinima) { double nCanMax = 0.0; double nCanMin = 0.0; DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("p_cantidad_max", DbType.Int32, ParameterDirection.Output), new DAABRequest.Parameter("p_cantidad_min", DbType.Int32, ParameterDirection.Output) }; for (int i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.SISACT_PKG_MANT_LIMITE_AUT + ".SP_CANTMAX_MIN_AUTORIZA"; obRequest.Parameters.AddRange(arrParam); IDataReader dr = null; try { dr = obRequest.Factory.ExecuteReader(ref obRequest).ReturnDataReader; IDataParameter parSalida1; IDataParameter parSalida2; parSalida1 = (IDataParameter)obRequest.Parameters[0]; parSalida2 = (IDataParameter)obRequest.Parameters[1]; nCanMax = Funciones.CheckDbl(parSalida1.Value); nCanMin = Funciones.CheckDbl(parSalida2.Value); obRequest.Factory.Dispose(); } catch (Exception e) { throw e; } finally { if (dr != null && dr.IsClosed == false) { dr.Close(); } obRequest.Parameters.Clear(); obRequest.Factory.Dispose(); } nCantidadMaxima = nCanMax; nCantidadMinima = nCanMin; }
public ArrayList ListarPorCodigoEvaluacionCodSEC(int codevaluacion, long codsec) { //me lista acciones segun el codigo de evaluacion DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("codsec", DbType.Int64, ParameterDirection.Input), new DAABRequest.Parameter("codevaluacion", DbType.Int32, ParameterDirection.Input), new DAABRequest.Parameter("P_CONSULTA", DbType.Object, ParameterDirection.Output) }; for (int i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } arrParam[0].Value = codsec; arrParam[1].Value = codevaluacion; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.PKG_EVALUACION_SEC + ".ListarAcuerdosEvalPorSec"; obRequest.Parameters.AddRange(arrParam); ArrayList salida = new ArrayList(); IDataReader dr = null; try { dr = obRequest.Factory.ExecuteReader(ref obRequest).ReturnDataReader; while (dr.Read()) { Acuerdo item = new Acuerdo(); item.COD_ACUERDO = Funciones.CheckInt(dr["cod_acuerdo"]); salida.Add(item); } } catch (Exception e) { throw e; } finally { if (dr != null && dr.IsClosed == false) { dr.Close(); } obRequest.Parameters.Clear(); obRequest.Factory.Dispose(); } return(salida); }
public ArrayList ListaPDVUsuario(Int64 cod_usuario, string cod_producto) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("K_USUAN_CODIGO", DbType.Int64, ParameterDirection.Input), new DAABRequest.Parameter("K_TPROC_CODIGO", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("K_CUR_SALIDA", DbType.Object, ParameterDirection.Output) }; for (int i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } if (cod_usuario > 0) { arrParam[0].Value = cod_usuario; } arrParam[1].Value = cod_producto; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.PKG_SISACT_CONSULTAS + ".SECSS_CON_PDV_X_USUARIO"; obRequest.Parameters.AddRange(arrParam); ArrayList filas = new ArrayList(); IDataReader dr = null; try { dr = obRequest.Factory.ExecuteReader(ref obRequest).ReturnDataReader; while (dr.Read()) { PuntoVenta item = new PuntoVenta(); item.OVENC_CODIGO = Funciones.CheckStr(dr["OVENC_CODIGO"]); item.OVENV_DESCRIPCION = Funciones.CheckStr(dr["OVENV_DESCRIPCION"]) + " - " + Funciones.CheckStr(dr["OVENC_CODIGO"]); item.TOFIC_CODIGO = Funciones.CheckStr(dr["TOFIC_CODIGO"]); item.CANAC_CODIGO = Funciones.CheckStr(dr["CANAC_CODIGO"]); item.OVENC_REGION = Funciones.CheckStr(dr["OVENC_REGION"]); filas.Add(item); } } catch (Exception e) { throw e; } finally { if (dr != null && dr.IsClosed == false) { dr.Close(); } obRequest.Parameters.Clear(); obRequest.Factory.Dispose(); } return(filas); }
public bool ObtenerPerfilPorMonto(string v_tipo, double v_cantidad, ref string v_perfil_codigo, ref string v_perfil_descripcion) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("V_NAC_TIPO", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("V_NAC_CANTIDAD", DbType.Double, ParameterDirection.Input), new DAABRequest.Parameter("V_NAN_PERFIL_VINCULADO", DbType.String, ParameterDirection.Output), new DAABRequest.Parameter("V_NAV_PERFIL_DESC", DbType.String, ParameterDirection.Output) }; int i = 0; for (i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } i = 0; arrParam[i].Value = v_tipo; ++i; arrParam[i].Value = v_cantidad; bool salida = false; //BDSISMANT obj = new BDSISMANT(BaseDatos.BD_SISACT); BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.PKG_SISACT_VENTA_EXPRESS + ".SISACTSS_PERFIL_X_MONTO_TIPO"; obRequest.Parameters.AddRange(arrParam); obRequest.Transactional = true; try { obRequest.Factory.ExecuteNonQuery(ref obRequest); obRequest.Factory.CommitTransaction(); salida = true; } catch (Exception ex) { obRequest.Factory.RollBackTransaction(); throw ex; } finally { IDataParameter parSalida1; IDataParameter parSalida2; parSalida1 = (IDataParameter)obRequest.Parameters[obRequest.Parameters.Count - 2]; parSalida2 = (IDataParameter)obRequest.Parameters[obRequest.Parameters.Count - 1]; v_perfil_codigo = Funciones.CheckStr(parSalida1.Value); v_perfil_descripcion = Funciones.CheckStr(parSalida2.Value); obRequest.Factory.Dispose(); } return(salida); }
public bool InsertarPlanSolicitud_DTH(PlanDetalleConsumer objDetalle, ref string rMsg) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_RESULTADO", DbType.Int64, ParameterDirection.Output), new DAABRequest.Parameter("P_SOLIN_CODIGO", DbType.Int64, ParameterDirection.Input), new DAABRequest.Parameter("P_SOPLC_MONTO_TOTAL", DbType.Double, ParameterDirection.Input), new DAABRequest.Parameter("P_SOPLN_MONTO_UNIT", DbType.Double, ParameterDirection.Input), new DAABRequest.Parameter("P_PLANC_CODIGO", DbType.String, 4,ParameterDirection.Input), new DAABRequest.Parameter("P_TPROC_CODIGO", DbType.String, 2,ParameterDirection.Input), new DAABRequest.Parameter("P_SOPLN_CANTIDAD", DbType.Int64, ParameterDirection.Input) }; for (int i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } arrParam[1].Value = objDetalle.SOLIN_CODIGO; arrParam[2].Value = objDetalle.SOPLC_MONTO_TOTAL; arrParam[3].Value = objDetalle.SOPLN_MONTO_UNIT; arrParam[4].Value = objDetalle.PLANC_CODIGO; arrParam[5].Value = objDetalle.TPROC_CODIGO; arrParam[6].Value = objDetalle.SOPLN_CANTIDAD; bool salida = false; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.PKG_SISACT_DTH + ".SISACT_INSERTAR_SOL_PLANES_DTH"; obRequest.Parameters.AddRange(arrParam); obRequest.Transactional = true; try { obRequest.Factory.ExecuteNonQuery(ref obRequest); obRequest.Factory.CommitTransaction(); salida = true; } catch (Exception ex) { obRequest.Factory.RollBackTransaction(); rMsg = "Error al Insertar la Solicitud. \nMensaje : " + ex.Message; throw ex; } finally { IDataParameter pSalida1; pSalida1 = (IDataParameter)obRequest.Parameters[0]; rMsg = Funciones.CheckStr(pSalida1.Value); obRequest.Factory.Dispose(); } return(salida); }
//PROY-26366 - FASE II - INICIO public ArrayList ListarDatosNCxDocSAP(string P_DOCUMENTO_SAP) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_DOCUMENTO_SAP", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("K_CUR_SALIDA", DbType.Object, ParameterDirection.Output) }; for (int i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } arrParam[0].Value = P_DOCUMENTO_SAP; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.SISACT_PKG_PROCESOS + Constantes.SisactListarDatosNCxDocSAP; obRequest.Parameters.AddRange(arrParam); ArrayList filas = new ArrayList(); IDataReader dr = null; try { dr = obRequest.Factory.ExecuteReader(ref obRequest).ReturnDataReader; Parametro item; while (dr.Read()) { item = new Parametro(); item.Codigo = Funciones.CheckInt64(dr["ID_CANJE_PUNTOS"]); filas.Add(item); } } catch (Exception ex) { throw (ex); } finally { if (dr != null && dr.IsClosed == false) { dr.Close(); } obRequest.Parameters.Clear(); obRequest.Factory.Dispose(); } return(filas); }
public ArrayList ListaTipoDocumento(string flag_ruc) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_FLAG_CON", DbType.String, 1, ParameterDirection.Input), new DAABRequest.Parameter("K_CUR_SALIDA", DbType.Object, ParameterDirection.Output) }; for (int i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } if (flag_ruc != "") { arrParam[0].Value = flag_ruc; } BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.PKG_SISACT_CONSULTAS + ".SISACT_CON_TIPO_DOC"; obRequest.Parameters.AddRange(arrParam); ArrayList filas = new ArrayList(); IDataReader dr = null; try { dr = obRequest.Factory.ExecuteReader(ref obRequest).ReturnDataReader; while (dr.Read()) { ItemGenerico item = new ItemGenerico(); item.Codigo = Funciones.CheckStr(dr["TDOCC_CODIGO"]); item.Descripcion = Funciones.CheckStr(dr["TDOCV_DESCRIPCION"]); item.Codigo2 = Funciones.CheckStr(dr["ID_CCLUB"]); filas.Add(item); } } catch (Exception e) { throw e; } finally { if (dr != null && dr.IsClosed == false) { dr.Close(); } obRequest.Parameters.Clear(); obRequest.Factory.Dispose(); } return(filas); }
public void actualizar(Documento objDocumento, out int resultado) { ArrayList comandosTran = new ArrayList(); DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("v_id_documento", DbType.Int32, ParameterDirection.Input), new DAABRequest.Parameter("v_nombre", DbType.String, 255,ParameterDirection.Input), new DAABRequest.Parameter("v_tipodoc", DbType.Int32, ParameterDirection.Input), new DAABRequest.Parameter("v_orden", DbType.Int16, ParameterDirection.Input), new DAABRequest.Parameter("v_usuario_modificacion", DbType.String, 15,ParameterDirection.Input), new DAABRequest.Parameter("K_RESULTADO", DbType.Int32, ParameterDirection.Output) }; for (int i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } arrParam[0].Value = objDocumento.CODIGO; arrParam[1].Value = objDocumento.NOMBRE; arrParam[2].Value = objDocumento.TIPO_DOCUMENTO.CODIGO; arrParam[3].Value = objDocumento.REGISTRO.ORDEN; arrParam[4].Value = objDocumento.REGISTRO.USUARIO_MODIFICACION; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.PKG_EVALUACION_SEC + ".Mant_actualizarDocumento"; obRequest.Parameters.AddRange(arrParam); obRequest.Transactional = true; try { obRequest.Factory.ExecuteNonQuery(ref obRequest); obRequest.Factory.CommitTransaction(); } catch (Exception) { resultado = 1; obRequest.Factory.RollBackTransaction(); } finally { IDataParameter parSalida1; parSalida1 = (IDataParameter)obRequest.Parameters[5]; resultado = int.Parse(parSalida1.Value.ToString()); obRequest.Parameters.Clear(); obRequest.Factory.Dispose(); } }
public ArrayList ListarParametroConfig(int intCodigoParametro) { ArrayList lisRetorno = new ArrayList(); DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_CODIGO", DbType.Int64, ParameterDirection.Input), new DAABRequest.Parameter("P_CURSOR", DbType.Object, ParameterDirection.Output) }; for (int i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } arrParam[0].Value = intCodigoParametro; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.PKG_SISACT_SERVICIO_VAS + ".SISACT_CONFIG_PARAM"; obRequest.Parameters.AddRange(arrParam); IDataReader dr = null; try { dr = obRequest.Factory.ExecuteReader(ref obRequest).ReturnDataReader; while (dr.Read()) { ParametroConsumer itm = new ParametroConsumer(); itm.PCONI_CODIGO = dr["PCONI_CODIGO"].ToString(); itm.PCONV_DESCRIPCION = dr["PCONV_DESCRIPCION"].ToString(); itm.PCONV_VALOR = dr["PCONV_VALOR"].ToString(); itm.PCONV_MENSAJE = dr["PCONV_MENSAJE"].ToString(); lisRetorno.Add(itm); } } catch (Exception e) { throw e; } finally { if (dr != null && dr.IsClosed == false) { dr.Close(); } obRequest.Parameters.Clear(); obRequest.Factory.Dispose(); } return(lisRetorno); }
public bool InsertarPlan3Play(Plan3Play oPlan3Play, ref string sCodigoPlan, ref string rMsg) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("K_RESULTADO", DbType.Int32, ParameterDirection.Output), new DAABRequest.Parameter("P_PLNV_DESCRIPCION", DbType.String, 50,ParameterDirection.Input), new DAABRequest.Parameter("P_PLNC_ESTADO", DbType.String, 1,ParameterDirection.Input), new DAABRequest.Parameter("P_TPROC_CODIGO", DbType.String, 2,ParameterDirection.Input), new DAABRequest.Parameter("P_PLNV_USUARIO_CREA", DbType.String, 10,ParameterDirection.Input), new DAABRequest.Parameter("P_PLNV_CODIGO_BSCS", DbType.String, 4,ParameterDirection.Input) }; int i = 0; for (i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } i = 1; arrParam[i].Value = oPlan3Play.PLNV_DESCRIPCION; i++; arrParam[i].Value = oPlan3Play.PLNC_ESTADO; i++; arrParam[i].Value = oPlan3Play.TPROC_CODIGO; i++; arrParam[i].Value = oPlan3Play.PLNV_USUARIO_CREA; i++; arrParam[i].Value = oPlan3Play.PLNV_CODIGO_BSCS; bool salida = false; BDSISACT oBDSISACT = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = oBDSISACT.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.PKG_SISACT_MANTENIMIENTO_3PLAY + ".SISACT_INS_PLAN_3PLAY"; obRequest.Parameters.AddRange(arrParam); obRequest.Transactional = true; try { obRequest.Factory.ExecuteNonQuery(ref obRequest); obRequest.Factory.CommitTransaction(); salida = true; } catch (Exception ex) { obRequest.Factory.RollBackTransaction(); rMsg = "Error al Insertar Plan 3Play. \nMensaje : " + ex.Message; throw ex; } finally { IDataParameter parSalida1; parSalida1 = (IDataParameter)obRequest.Parameters[0]; sCodigoPlan = Funciones.CheckStr(parSalida1.Value); obRequest.Factory.Dispose(); } return(salida); }
public ArrayList ObtenerFactxProducto(string p_planes) { ArrayList filas = null; DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_LISTA_PLANES", DbType.String, 4000, ParameterDirection.Input), new DAABRequest.Parameter("C_PRODUCTO_FACT", DbType.Object, ParameterDirection.Output) }; for (int i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } arrParam[0].Value = p_planes; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.PKG_SISACT_EVALUACION_UNI + ".SP_CALCULO_FACTURA_X_PROD_RP"; obRequest.Parameters.AddRange(arrParam); filas = new ArrayList(); IDataReader dr = null; try { dr = obRequest.Factory.ExecuteReader(ref obRequest).ReturnDataReader; while (dr.Read()) { ItemGenerico oItem = new ItemGenerico(); oItem.Codigo = Funciones.CheckStr(dr["CODIGO"]); oItem.Descripcion = Funciones.CheckStr(dr["DESCRIPCION"]); oItem.Valor = Funciones.CheckDbl(dr["VALOR"]); filas.Add(oItem); } } catch (Exception e) { throw new Exception("ObtenerLCxProducto@" + e.StackTrace + "@" + e.Message); } finally { if (dr != null && dr.IsClosed == false) { dr.Close(); } obRequest.Parameters.Clear(); obRequest.Factory.Dispose(); } return(filas); }
//PROY-24740 public ArrayList ObtenerBilleteraxPlan(string strListaPlan) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_PLANES", DbType.String, 4000, ParameterDirection.Input), new DAABRequest.Parameter("P_CURSOR", DbType.Object, ParameterDirection.Output) }; arrParam[0].Value = strListaPlan; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest objRequest = obj.CreaRequest(); objRequest.CommandType = CommandType.StoredProcedure; objRequest.Command = string.Format("{0}{1}", BaseDatos.PKG_SISACT_EVALUACION_UNI, ".SP_PLAN_X_PRODUCTO"); objRequest.Parameters.AddRange(arrParam); ArrayList objLista = new ArrayList(); ArrayList objListaPlan = new ArrayList(); PlanBilletera objItem; Billetera objBilletera; string plan; IDataReader dr = null; try { dr = objRequest.Factory.ExecuteReader(ref objRequest).ReturnDataReader; while (dr.Read()) { plan = Funciones.CheckStr(dr["PLAN"]); objBilletera = new Billetera(Funciones.CheckInt(dr["PRODUCTO"]), Funciones.CheckStr(dr["DESCRIPCION"])); if (!objListaPlan.Contains(plan)) { objItem = new PlanBilletera(); objItem.Plan = plan; objItem.oBilletera = new ArrayList(); objItem.oBilletera.Add(objBilletera); objLista.Add(objItem); objListaPlan.Add(plan); } } } finally { if (dr != null && dr.IsClosed == false) { dr.Close(); } objRequest.Parameters.Clear(); objRequest.Factory.Dispose(); } return(objLista); }
/// <summary> /// Pobla la entidad correspondiente la registro Acuerdo dela Base de Datos /// </summary> /// <param name="idrd"></param> /// <returns>Entidad Acuerdo</returns> public long ObtenerCodigo_X_SEC_DOC(long pNroSolicitudSEC, int pIdDocumento) { //--inicializa dato a devolver long iCodigo = -1; //--define parametros DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_COD_SEC", DbType.Int64, ParameterDirection.Input), new DAABRequest.Parameter("P_ID_DOCUMENTO", DbType.Int32, ParameterDirection.Input), new DAABRequest.Parameter("P_COD_ACUERDO", DbType.Int32, ParameterDirection.Output) }; int i; for (i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } if (!pNroSolicitudSEC.Equals(-1)) { arrParam[0].Value = pNroSolicitudSEC; } if (!pIdDocumento.Equals(-1)) { arrParam[1].Value = pIdDocumento; } BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest objRequest = obj.CreaRequest(); objRequest.CommandType = CommandType.StoredProcedure; objRequest.Command = BaseDatos.PKG_SISACT_ACUERDO + ".ACUERDO_ObtenerCod_X_SEC_DOC"; objRequest.Parameters.AddRange(arrParam); try { Funciones.CheckStr(objRequest.Factory.ExecuteScalar(ref objRequest)); } catch (Exception e) { throw e; } finally { IDataParameter parSalida1; parSalida1 = (IDataParameter)objRequest.Parameters[2]; iCodigo = Funciones.CheckInt(parSalida1.Value); objRequest.Factory.Dispose(); objRequest.Parameters.Clear(); } //--- return(iCodigo); }
public bool ValidarAlumno(string sTipoDoc, string sNroDoc, ref string sCodMensaje, ref string sMensaje) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("pin_tipo_documento", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("pin_nro_documento", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("pout_respuesta_codigo", DbType.Int64, ParameterDirection.Output), new DAABRequest.Parameter("pout_respuesta_mensaje", DbType.String, ParameterDirection.Output) }; bool salida = false; for (int i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } arrParam[0].Value = sTipoDoc; arrParam[1].Value = sNroDoc; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.PKG_SISACT_CAMPANA_ESPECIAL + ".sisacss_whitelist_x_doc"; obRequest.Parameters.AddRange(arrParam); obRequest.Transactional = true; try { obRequest.Factory.ExecuteNonQuery(ref obRequest); IDataParameter pSalida1, pSalida2; pSalida1 = (IDataParameter)obRequest.Parameters[2]; pSalida2 = (IDataParameter)obRequest.Parameters[3]; sCodMensaje = Funciones.CheckStr(pSalida1.Value); sMensaje = Funciones.CheckStr(pSalida2.Value); if (sCodMensaje == "1") //cliente SI se encuentra en el whitelist.'; { salida = true; } } catch (Exception ex) { obRequest.Factory.RollBackTransaction(); sCodMensaje = "-1"; sMensaje = "ERROR AL EJECUTAR SP: " + BaseDatos.PKG_SISACT_CAMPANA_ESPECIAL + ".sisacss_whitelist_x_doc - " + ex.Message.ToString(); } finally { obRequest.Factory.Dispose(); } return(salida); }
public bool Actualizar_Logs(ref AuditoriaLogs _pAuditoriaLog) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("K_AUDII_ITEM", DbType.Int32, ParameterDirection.Input), new DAABRequest.Parameter("K_AUDIV_NROEQUIPO", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("K_AUDII_NROENVIOSMS", DbType.Int32, ParameterDirection.Input), new DAABRequest.Parameter("K_AUDII_NROINTENTO", DbType.Int32, ParameterDirection.Input), new DAABRequest.Parameter("K_AUDII_NROINDICADOR", DbType.Int32, ParameterDirection.Input), new DAABRequest.Parameter("K_AUDII_DISPONIBLESMS", DbType.Int32, ParameterDirection.Input), new DAABRequest.Parameter("K_AUDIV_COMENTARIO", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("K_AUDII_PDV", DbType.Int32, ParameterDirection.Input), new DAABRequest.Parameter("K_AUDIV_IPSERVICIO", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("K_AUDIV_USUARIO_MODI", DbType.String, ParameterDirection.Input) }; for (int i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } arrParam[0].Value = _pAuditoriaLog.AUDII_ITEM; arrParam[1].Value = _pAuditoriaLog.AUDIV_NROEQUIPO; arrParam[2].Value = _pAuditoriaLog.AUDII_NROENVIOSMS; arrParam[3].Value = _pAuditoriaLog.AUDII_NROINTENTO; arrParam[4].Value = _pAuditoriaLog.AUDII_NROINDICADOR; arrParam[5].Value = _pAuditoriaLog.AUDII_DISPONIBLESMS; arrParam[6].Value = _pAuditoriaLog.AUDIV_COMENTARIO; arrParam[7].Value = _pAuditoriaLog.AUDII_PDV; arrParam[8].Value = _pAuditoriaLog.AUDIV_IPSERVICIO; arrParam[9].Value = _pAuditoriaLog.AUDIV_USUARIO_MODI; bool salida = false; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest objRequest = obj.CreaRequest(); objRequest.CommandType = CommandType.StoredProcedure; objRequest.Command = BaseDatos.SISACT_ACTUALIZARLOGS; objRequest.Parameters.AddRange(arrParam); objRequest.Transactional = true; try { objRequest.Factory.ExecuteNonQuery(ref objRequest); objRequest.Factory.CommitTransaction(); salida = true; } catch (Exception e) { throw e; } finally { objRequest.Factory.Dispose(); } return(salida); }
public string ObtenerNombreArchivoIngreso(long pNroSolicitud, int pIdDocumento) { //--inicializa dato a devolver string strNombreArchivo = ""; //--define parametros DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_COD_SEC", DbType.Int64, ParameterDirection.Input), new DAABRequest.Parameter("P_ID_DOCUMENTO", DbType.Int32, ParameterDirection.Input), new DAABRequest.Parameter("P_NOMBRE_ARCHIVO", DbType.String, ParameterDirection.Output) }; int i; for (i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } if (!pNroSolicitud.Equals(-1)) { arrParam[0].Value = pNroSolicitud; } if (!pIdDocumento.Equals(-1)) { arrParam[1].Value = pIdDocumento; } BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest objRequest = obj.CreaRequest(); objRequest.CommandType = CommandType.StoredProcedure; objRequest.Command = BaseDatos.PKG_SISACT_ACUERDO + ".DOCUMENTO_SEC_DeterminaArchIng"; objRequest.Parameters.AddRange(arrParam); try { Funciones.CheckStr(objRequest.Factory.ExecuteScalar(ref objRequest)); } catch (Exception e) { throw e; } finally { IDataParameter parSalida1; parSalida1 = (IDataParameter)objRequest.Parameters[2]; strNombreArchivo = Funciones.CheckStr(parSalida1.Value); objRequest.Factory.Dispose(); objRequest.Parameters.Clear(); } return(strNombreArchivo); }