/// <summary> /// Obtiene todos los Documentos segun parametros /// </summary> /// <param name="pTipoDoc"></param> /// <returns></returns> public ArrayList Listar(int pCodigoTipoDocumento) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_ID_TIPO_DOCUMENTO", DbType.Int32, ParameterDirection.Input), new DAABRequest.Parameter("P_DOCUMENTO", DbType.Object, ParameterDirection.Output) }; for (int i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } arrParam[0].Value = pCodigoTipoDocumento; //-- BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.PKG_SISACT_ACUERDO + ".DOCUMENTO_LISTAR"; obRequest.Parameters.AddRange(arrParam); ArrayList filas = new ArrayList(); IDataReader dr = null; try { dr = obRequest.Factory.ExecuteReader(ref obRequest).ReturnDataReader; while (dr.Read()) { Documento item = new Documento(); item.CODIGO = Funciones.CheckInt(dr["ID_DOCUMENTO"]); item.NOMBRE = Funciones.CheckStr(dr["NOMBRE"]); 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); }
//ldrz public bool EliminarPaquete3Play(string P_PRDC_CODIGO, string P_PAQTV_CODIGO, string P_USUARIO_CREA) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_PRDC_CODIGO", DbType.String, 5, ParameterDirection.Input), new DAABRequest.Parameter("P_PAQTV_CODIGO", DbType.String, 5, ParameterDirection.Input), new DAABRequest.Parameter("P_USUARIO_CREA", DbType.String, 10, ParameterDirection.Input), new DAABRequest.Parameter("K_RESULTADO", DbType.Int32, ParameterDirection.Output) }; int i = 0; for (i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } arrParam[0].Value = P_PRDC_CODIGO; arrParam[1].Value = P_PAQTV_CODIGO; arrParam[2].Value = P_USUARIO_CREA; 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_DEL_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 Eliminar en Paquete 3Play. \nMensaje : " + ex.Message; throw ex; } finally { obRequest.Factory.Dispose(); } return(salida); }
public int InsertarActualizaDatosNivelesAprobacionXtipo(string strPerfilVin, string strTipo, string strEstado, string strPerfilDesc, string strCantidad, string strUsuario, ref string codError, ref string msgError) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("K_NAN_PERFIL_VINCULADO", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("K_NAC_TIPO", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("K_NAC_ESTADO", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("K_NAV_PERFIL_DESC", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("K_NAC_CANTIDAD", DbType.Int32, ParameterDirection.Input), new DAABRequest.Parameter("K_NAV_USUAC_MODI", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_CODIGO_RESPUESTA", DbType.String, ParameterDirection.Output), new DAABRequest.Parameter("P_MENSAJE_RESPUESTA", DbType.String, ParameterDirection.Output), }; arrParam[0].Value = strPerfilVin; arrParam[1].Value = strTipo; arrParam[2].Value = strEstado; arrParam[3].Value = strPerfilDesc; arrParam[4].Value = strCantidad; arrParam[5].Value = strUsuario; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); obRequest.Parameters.Clear(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.SISACT_PKG_MANT_LIMITE_AUT + ".sisactsi_niv_autorizacion"; obRequest.Parameters.AddRange(arrParam); obRequest.Transactional = true; try { obRequest.Factory.ExecuteNonQuery(ref obRequest); obRequest.Factory.CommitTransaction(); codError = Funciones.CheckStr(((IDataParameter)obRequest.Parameters[6]).Value); msgError = Funciones.CheckStr(((IDataParameter)obRequest.Parameters[7]).Value); } catch (Exception ex) { codError = "-9"; msgError = "Error oracle. Consultar administrador."; obRequest.Factory.RollBackTransaction(); } finally { obRequest.Factory.Dispose(); } return(0); }
public void ConsultarDatosDireccion(string idDepartamento, string idProvincia, string idDistrito, ref string strDepartamento, ref string strProvincia, ref string strDistrito) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_CUR_DIR", DbType.Object, ParameterDirection.Output), new DAABRequest.Parameter("P_DEPARTAMENTO", DbType.String, 4,ParameterDirection.Input), new DAABRequest.Parameter("P_PROVINCIA", DbType.String, 4,ParameterDirection.Input), new DAABRequest.Parameter("P_DISTRITO", DbType.String, 4,ParameterDirection.Input) }; arrParam[1].Value = idDepartamento; arrParam[2].Value = idProvincia; arrParam[3].Value = idDistrito; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest objRequest = obj.CreaRequest(); objRequest.CommandType = CommandType.StoredProcedure; objRequest.Command = BaseDatos.PKG_SISACT_CONSULTA_BRMS + ".SP_CON_DATOS_DISTRITO"; objRequest.Parameters.AddRange(arrParam); IDataReader dr = null; try { dr = objRequest.Factory.ExecuteReader(ref objRequest).ReturnDataReader; while (dr.Read()) { strDepartamento = Funciones.CheckStr(dr["DEPAV_DESCRIPCION"]); strProvincia = Funciones.CheckStr(dr["PROVV_DESCRIPCION"]); strDistrito = Funciones.CheckStr(dr["DISTV_DESCRIPCION"]); } } catch (Exception ex) { throw ex; } finally { if (dr != null && dr.IsClosed == false) { dr.Close(); } objRequest.Parameters.Clear(); objRequest.Factory.Dispose(); } }
public ArrayList ListarNivelesDeAprobacionMeses(string v_tipo) { DataTable dtResultado = new DataTable(); DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("V_NAC_TIPO", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("cv_1", DbType.Object, ParameterDirection.Output) }; arrParam[0].Value = v_tipo; IDataReader dr = null; ArrayList lista = new ArrayList(); BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); obRequest.Parameters.Clear(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.SISACT_PKG_MANT_LIMITE_AUT + ".SISACTSS_NIV_APROB_X_TIPO"; obRequest.Parameters.AddRange(arrParam); try { dr = obRequest.Factory.ExecuteReader(ref obRequest).ReturnDataReader; NivelAprobacion item; while (dr.Read()) { item = new NivelAprobacion(); item.CODIGO = Funciones.CheckStr(dr["NAN_PERFIL_VINCULADO"]); item.ESTADO = Funciones.CheckStr(dr["NAC_ESTADO"]); item.CANAL = Funciones.CheckStr(dr["NAV_PERFIL_DESC"]); item.DIASMINIMO = Funciones.CheckStr(dr["NAC_CANTIDAD"]); lista.Add(item); } } catch (Exception) { } finally { obRequest.Factory.Dispose(); } return(lista); }
/// <summary> /// Recupera el Nombre de archivo digitalizado de un Documento SEC /// </summary> /// <param name="pIDDOcumentoSEC"></param> /// <returns></returns> public string ObtenerNombreArchivo(long pIDDOcumentoSEC) { //--inicializa dato a devolver string strNombreArchivo = ""; //--define parametros DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_ID_DOCUMENTO_SEC", DbType.Int64, 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 (!pIDDOcumentoSEC.Equals(-1)) { arrParam[0].Value = pIDDOcumentoSEC; } BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest objRequest = obj.CreaRequest(); objRequest.CommandType = CommandType.StoredProcedure; objRequest.Command = BaseDatos.PKG_SISACT_ACUERDO + ".DOCUMENTO_SEC_DeterminaArchivo"; objRequest.Parameters.AddRange(arrParam); try { Funciones.CheckStr(objRequest.Factory.ExecuteScalar(ref objRequest)); } catch (Exception e) { throw e; } finally { IDataParameter parSalida1; parSalida1 = (IDataParameter)objRequest.Parameters[1]; strNombreArchivo = Funciones.CheckStr(parSalida1.Value); objRequest.Factory.Dispose(); objRequest.Parameters.Clear(); } return(strNombreArchivo); }
public string ObtenerRUC_Asociado(long pCOD_SEC) { //--inicializa dato a devolver string sRUC; //--define parametros DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_COD_SEC", DbType.Int64, ParameterDirection.Input), new DAABRequest.Parameter("P_RUC", DbType.String, ParameterDirection.Output) }; for (int i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } if (pCOD_SEC > 0) { arrParam[0].Value = pCOD_SEC; } BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest objRequest = obj.CreaRequest(); objRequest.CommandType = CommandType.StoredProcedure; objRequest.Command = BaseDatos.PKG_SISACT_ACUERDO + ".CLIENTE_Obt_RUC_Asociado"; objRequest.Parameters.AddRange(arrParam); try { Funciones.CheckInt(objRequest.Factory.ExecuteScalar(ref objRequest)); //--- IDataParameter parSalida1; parSalida1 = (IDataParameter)objRequest.Parameters[1]; sRUC = Funciones.CheckStr(parSalida1.Value); } catch (Exception e) { throw e; } finally { objRequest.Factory.Dispose(); objRequest.Parameters.Clear(); } //--- return(sRUC); }
// public void ConsultaCierreCajaPVU(string pFecha,string pUsuario, string poficina, out string CierreReal) // { // DAABRequest.Parameter[] arrParam = // { // new DAABRequest.Parameter("P_FECHA", DbType.String, ParameterDirection.Input), // new DAABRequest.Parameter("P_USUARIO", DbType.String, ParameterDirection.Input), // new DAABRequest.Parameter("P_OFICINA", DbType.String, ParameterDirection.Input), // new DAABRequest.Parameter("C_DATOS", DbType.Object, ParameterDirection.Output) }; // int i = 0; // for (i=0; i < arrParam.Length; i++) // arrParam[i].Value = DBNull.Value; // // arrParam[0].Value = pFecha; // arrParam[1].Value = pUsuario; // arrParam[2].Value = poficina; // // BDSICAR obj = new BDSICAR(BaseDatos.BD_SICAR); // DAABRequest obRequest = obj.CreaRequest(); // obRequest.CommandType = CommandType.StoredProcedure; // obRequest.Command = BaseDatos.PCK_SICAR_OFF_SAP + ".MIG_ObtenerCajaAsignada"; // obRequest.Parameters.AddRange(arrParam); // CierreReal = ""; // ItemGenerico item = new ItemGenerico(); // IDataReader dr = null; // try // { // dr = obRequest.Factory.ExecuteReader(ref obRequest).ReturnDataReader; // if (dr != null) // { // while (dr.Read()) // { // item.Codigo = Funciones.CheckStr(dr["CAJA_CERRADA"]); // } // CierreReal =item.Codigo; // } // } // catch (Exception ex) // { // throw (ex); // } // finally // { // if (dr != null && dr.IsClosed == false) // dr.Close(); // obRequest.Parameters.Clear(); // obRequest.Factory.Dispose(); // } // } public ArrayList ConsultaEquiposAlternativos() { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_RESULT_SET", DbType.Object, ParameterDirection.Output) }; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.PKG_MATERIAL_LISTA + ".SSAPSS_MATERIAL_LISTA_T"; 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.Codigo = Funciones.CheckStr(dr["MATEC_CODMATERIAL"]); item.Descripcion = Funciones.CheckStr(dr["MATEV_DESCMATERIAL"]); 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 int Manten_Periodo_Renov(int Cantidad, int Periodo) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_RESULTADO", DbType.Int32, ParameterDirection.Output), new DAABRequest.Parameter("P_CANTIDAD", DbType.Int32, ParameterDirection.Input), new DAABRequest.Parameter("P_PERIODO", DbType.Int32, ParameterDirection.Input) }; int i = 0; for (i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } arrParam[0].Value = 0; arrParam[1].Value = Cantidad; arrParam[2].Value = Periodo; int salida; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.PKG_SISACT_MANT_PLN + ".SISACT_MANT_PERIODO_RENOV"; obRequest.Parameters.AddRange(arrParam); obRequest.Transactional = true; try { obRequest.Factory.ExecuteNonQuery(ref obRequest); IDataParameter parSalida1; parSalida1 = (IDataParameter)obRequest.Parameters[0]; salida = Funciones.CheckInt16(parSalida1.Value); } catch (Exception ex) { obRequest.Factory.RollBackTransaction(); throw ex; } finally { obRequest.Parameters.Clear(); obRequest.Factory.Dispose(); } return(salida); }
public ArrayList ConsultarDetalleDecoxKIT(string idKIT) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_CUR_EQUIPO", DbType.Object, ParameterDirection.Output), new DAABRequest.Parameter("P_KIT", DbType.Int64, ParameterDirection.Input) } ; arrParam[1].Value = idKIT; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest objRequest = obj.CreaRequest(); objRequest.CommandType = CommandType.StoredProcedure; objRequest.Command = BaseDatos.PKG_SISACT_CONSULTA_BRMS + ".SP_CON_EQUIPO_DECO_KIT"; objRequest.Parameters.AddRange(arrParam); ArrayList objLista = new ArrayList(); EquipoBRMS objItem; IDataReader dr = null; try { dr = objRequest.Factory.ExecuteReader(ref objRequest).ReturnDataReader; while (dr.Read()) { objItem = new EquipoBRMS(); objItem.kit = Funciones.CheckStr(dr["KITV_DESCRIPCION"]); objItem.modelo = Funciones.CheckStr(dr["MATV_DESCRIPCION"]); objItem.tipoDeDeco = Funciones.CheckStr(dr["TIPO_DECO"]); objLista.Add(objItem); } } catch (Exception ex) { throw ex; } finally { if (dr != null && dr.IsClosed == false) { dr.Close(); } objRequest.Factory.Dispose(); } return(objLista); }
public bool InsertarPlanEqui3Play(PlanServ3Play oPlanServ3Play) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_RESULTADO", DbType.Int32, ParameterDirection.Output), new DAABRequest.Parameter("P_PLNV_CODIGO", DbType.String, 4,ParameterDirection.Input), new DAABRequest.Parameter("P_CADENA", DbType.String, 4000,ParameterDirection.Input) }; int i = 0; for (i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } arrParam[1].Value = oPlanServ3Play.PLNV_CODIGO; arrParam[2].Value = oPlanServ3Play.SERVV_CODIGO; 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 + ".MANTSS_INS_MATERIAL3P_X_PLAN"; 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 Insertar en Plan Equipo 3Play. \nMensaje : " + ex.Message; throw ex; } finally { obRequest.Factory.Dispose(); } return(salida); }
//**************************************** INICIO WHZR **************************************************** public string ListarOpcionVas(int intCodigoVas) { string strOpcionVas = ""; DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_CODIGO_VAS", DbType.Int32, 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 = intCodigoVas; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.PKG_SISACT_SERVICIO_VAS + ".SISACT_OPCION_VAS"; obRequest.Parameters.AddRange(arrParam); ArrayList filas = new ArrayList(); IDataReader dr = null; try { dr = obRequest.Factory.ExecuteReader(ref obRequest).ReturnDataReader; while (dr.Read()) { //ServicioVas itm = new ServicioVas(); strOpcionVas = Funciones.CheckStr(dr["VPAQV_NOM_OPCION"]); } } catch (Exception e) { throw e; } finally { if (dr != null && dr.IsClosed == false) { dr.Close(); } obRequest.Parameters.Clear(); obRequest.Factory.Dispose(); } return(strOpcionVas); }
public ArrayList ListarParametroGeneral(string strCodigo) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_CODIGO", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_CURSOR", DbType.Object, ParameterDirection.Output) }; arrParam[0].Value = strCodigo; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest objRequest = obj.CreaRequest(); objRequest.CommandType = CommandType.StoredProcedure; objRequest.Command = BaseDatos.PKG_SISACT_GENERAL + ".SP_CON_PARAM_GENERAL"; objRequest.Parameters.AddRange(arrParam); ArrayList objLista = new ArrayList(); ItemGenerico objItem; IDataReader dr = null; try { dr = objRequest.Factory.ExecuteReader(ref objRequest).ReturnDataReader; while (dr.Read()) { objItem = new ItemGenerico(); objItem.Codigo = Funciones.CheckStr(dr["PCONI_CODIGO"]); objItem.Descripcion = Funciones.CheckStr(dr["PCONV_DESCRIPCION"]); //objItem.Valor = Funciones.CheckStr(dr["PCONV_VALOR"]); PENDIENTE LUIS objItem.Valor2 = Funciones.CheckStr(dr["PCONV_VALOR"]); //JAZ objLista.Add(objItem); } } catch (Exception ex) { throw ex; } finally { if (dr != null && dr.IsClosed == false) { dr.Close(); } objRequest.Factory.Dispose(); } return(objLista); }
public virtual long ExisteSolicitud(long pNroSolicitudSEC) { //--inicializa dato a devolver long intExiste = 0; //- 0= NO existe //--define parametros DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_NroSolicitud", DbType.Int64, ParameterDirection.Input), new DAABRequest.Parameter("P_Existe", DbType.Int32, ParameterDirection.Output) }; for (int i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } if (!pNroSolicitudSEC.Equals(-1)) { arrParam[0].Value = pNroSolicitudSEC; } BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest objRequest = obj.CreaRequest(); objRequest.CommandType = CommandType.StoredProcedure; objRequest.Command = BaseDatos.PKG_SISACT_ACUERDO + ".SECT_SOLICITUD_Existe"; objRequest.Parameters.AddRange(arrParam); try { intExiste = Funciones.CheckInt(objRequest.Factory.ExecuteScalar(ref objRequest)); } catch (Exception e) { throw e; } finally { IDataParameter parSalida1; parSalida1 = (IDataParameter)objRequest.Parameters[1]; intExiste = Funciones.CheckInt64(parSalida1.Value); objRequest.Factory.Dispose(); objRequest.Parameters.Clear(); } return(intExiste); }
public int Validar_BlackWhiteList(string strTipDoc, string strDocumento, string strTipoOper, string strFecha, string strTipoLista) { int intValidar = 0; DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_VALIDAR", DbType.Int32, ParameterDirection.Output), new DAABRequest.Parameter("P_TIPODOCU", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_NRODOCU", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_FECHA", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_OPCION", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_TFLUJO", DbType.String, ParameterDirection.Input) }; for (int i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } arrParam[0].Value = System.DBNull.Value; arrParam[1].Value = strTipDoc; arrParam[2].Value = strDocumento; arrParam[3].Value = strFecha; arrParam[4].Value = strTipoLista; arrParam[5].Value = strTipoOper; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.SISACT_VALIDARWHITEBLACKLIST; obRequest.Parameters.AddRange(arrParam); try { obRequest.Factory.ExecuteNonQuery(ref obRequest); } catch (Exception e) { throw e; } finally { IDataParameter parSalida1; parSalida1 = (IDataParameter)obRequest.Parameters[0]; intValidar = Funciones.CheckInt(parSalida1.Value); obRequest.Factory.Dispose(); } return(intValidar); }
public Usuario ConsultaDatosUsuario(string p_cta_red) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_CTA_RED", DbType.String, 20, 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 = p_cta_red; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.PKG_SISACT_EVALUACION_UNI + ".SP_CONSULTA_PDV_USUARIO"; obRequest.Parameters.AddRange(arrParam); Usuario oUsuario = new Usuario(); IDataReader dr = null; try { dr = obRequest.Factory.ExecuteReader(ref obRequest).ReturnDataReader; while (dr.Read()) { oUsuario.UsuarioId = Funciones.CheckInt64(dr["USUAN_CODIGO"]); oUsuario.TipoOficinaId = Funciones.CheckStr(dr["TOFIC_CODIGO"]); oUsuario.OficinaId = Funciones.CheckStr(dr["OVENC_CODIGO"]); } } catch (Exception e) { throw e; } finally { obRequest.Parameters.Clear(); obRequest.Factory.Dispose(); } return(oUsuario); }
public bool EnvioMPxSec(int intSec, string strUsuario) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_SOLIN_CODIGO", DbType.Int64, ParameterDirection.Input), new DAABRequest.Parameter("P_SOPOV_USUARIO_CREA", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_RESPUESTA", DbType.Int32, ParameterDirection.Output) }; for (int i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } arrParam[0].Value = intSec; arrParam[1].Value = strUsuario; bool salida = false; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.PKG_PORTABILIDAD + ".SP_ENVIO_MP_X_SEC"; 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 AutoAsignarSEC. \nMensaje : " + ex.Message; throw ex; } finally { IDataParameter parSalida1; parSalida1 = (IDataParameter)obRequest.Parameters[2]; //sEstado = Funciones.CheckInt(parSalida1.Value); obRequest.Factory.Dispose(); } return(salida); }
public string ListaPrefijosApellidoCompuesto() { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("K_CUR_SALIDA", DbType.Object, ParameterDirection.Output) }; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest objRequest = obj.CreaRequest(); objRequest.CommandType = CommandType.StoredProcedure; objRequest.Command = BaseDatos.PKG_SISACT_CONSULTAS + ".SISACT_LIST_PREFIJO_APELLIDO"; objRequest.Parameters.AddRange(arrParam); string cadTokens = ""; IDataReader dr = null; try { dr = objRequest.Factory.ExecuteReader(ref objRequest).ReturnDataReader; while (dr.Read()) { if (cadTokens.Length == 0) { cadTokens = cadTokens + Funciones.CheckStr(dr["PREFIJOAP"]); } else { cadTokens = cadTokens + "," + Funciones.CheckStr(dr["PREFIJOAP"]); } } } catch (Exception ex) { throw ex; } finally { if (dr != null && dr.IsClosed == false) { dr.Close(); } objRequest.Factory.Dispose(); } return(cadTokens); }
public ArrayList ListarTipoDocumento() { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_CURSOR", DbType.Object, ParameterDirection.Output) }; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest objRequest = obj.CreaRequest(); objRequest.CommandType = CommandType.StoredProcedure; objRequest.Command = BaseDatos.PKG_SISACT_GENERAL + ".SP_CON_TIPO_DOCUMENTO"; objRequest.Parameters.AddRange(arrParam); ArrayList objLista = new ArrayList(); TipoDocumento objItem; IDataReader dr = null; try { dr = objRequest.Factory.ExecuteReader(ref objRequest).ReturnDataReader; while (dr.Read()) { objItem = new TipoDocumento(); objItem.ID_SISACT = Funciones.CheckStr(dr["DOCC_CODIGO"]) == AppSettings.Key_codigoDocPasaporte08 ? AppSettings.Key_codigoDocPasaporte07 : Funciones.CheckStr(dr["DOCC_CODIGO"]); /*PROY-31636 - RENTESEG*/ objItem.TDOCV_DESCRIPCION = Funciones.CheckStr(dr["DOCV_DESCRIPCION"]); objItem.ID_BSCS = Funciones.CheckInt(dr["DOCC_COD_BSCS"]); objItem.COD_SGA = Funciones.CheckStr(dr["DOCC_COD_SGA"]); objItem.ID_DC_CORP = Funciones.CheckStr(dr["DOCC_COD_DC"]); objLista.Add(objItem); } } catch (Exception ex) { throw ex; } finally { if (dr != null && dr.IsClosed == false) { dr.Close(); } objRequest.Factory.Dispose(); } return(objLista); }
public DataTable ConsultaVentaCuotas(string strTipoDocumento, string strNroDocumento, string strIMEI, string strLinea) { DataTable dtResultado = new DataTable(); DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_CURSOR", DbType.Object, ParameterDirection.Output), new DAABRequest.Parameter("P_TIPODOC", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_NRODOC", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_LINEA", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_IMEI", DbType.String, ParameterDirection.Input) }; int i = 0; for (i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } arrParam[1].Value = strTipoDocumento; arrParam[2].Value = strNroDocumento; arrParam[3].Value = strLinea; arrParam[4].Value = strIMEI; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest objRequest = obj.CreaRequest(); objRequest.CommandType = CommandType.StoredProcedure; objRequest.Command = BaseDatos.PKG_SISACT_REPORTE + ".sp_con_venta_cuotas"; objRequest.Parameters.AddRange(arrParam); try { dtResultado = objRequest.Factory.ExecuteDataset(ref objRequest).Tables[0]; } catch (Exception ex) { throw ex; } finally { objRequest.Factory.Dispose(); } return(dtResultado); }
public PuntoVenta ValidarOficinaVenta(string strOficinaVenta) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_OFICINA_VENTA", DbType.String, 20, ParameterDirection.Input), new DAABRequest.Parameter("P_RESULTADO", DbType.Object, ParameterDirection.Output) }; for (int i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } arrParam[0].Value = strOficinaVenta; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.PKG_SISACT_VENTA_EXPRESS + ".SP_VALIDAR_OFICINA"; obRequest.Parameters.AddRange(arrParam); PuntoVenta oPuntoVenta = new PuntoVenta(); IDataReader dr = null; try { dr = obRequest.Factory.ExecuteReader(ref obRequest).ReturnDataReader; while (dr.Read()) { oPuntoVenta.OVENC_PDV_RENOV = Funciones.CheckStr(dr["OVENC_PDV_RENOV"]); oPuntoVenta.OVENC_PDV_REPOS = Funciones.CheckStr(dr["OVENC_PDV_REPOS"]); oPuntoVenta.OVENV_DESCRIPCION = Funciones.CheckStr(dr["OVENV_DESCRIPCION"]); } } catch (Exception e) { throw e; } finally { obRequest.Parameters.Clear(); obRequest.Factory.Dispose(); } return(oPuntoVenta); }
//Renovacion //Validación BlackList Cliente Comisiones public string ConsultaClienteBlackList(string p_tipo_doc, string p_nro_doc) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_EXISTE", DbType.String, ParameterDirection.Output), new DAABRequest.Parameter("P_TIPO_DOC", DbType.String, 2,ParameterDirection.Input), new DAABRequest.Parameter("P_NRO_DOC", DbType.String, 16,ParameterDirection.Input) }; string retorno = "0"; for (int i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } arrParam[1].Value = p_tipo_doc; arrParam[2].Value = p_nro_doc; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Transactional = true; obRequest.Parameters.Clear(); obRequest.Command = BaseDatos.PKG_SISACT_EVALUACION_UNI + ".SP_CON_BLACKLIST_COMISIONES"; obRequest.Parameters.AddRange(arrParam); try { obRequest.Factory.ExecuteNonQuery(ref obRequest); } catch (Exception e) { throw e; } finally { IDataParameter parSalida1; parSalida1 = (IDataParameter)obRequest.Parameters[0]; retorno = (Funciones.CheckInt(parSalida1.Value) > 0)? "S" : "N"; obRequest.Factory.Dispose(); obRequest.Parameters.Clear(); } return(retorno); }
public string ObtieneUsrSisact(string vUsrNT) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("K_CUR_SALIDA", DbType.Object, ParameterDirection.Output), new DAABRequest.Parameter("P_USUAC_CTARED", DbType.String, ParameterDirection.Input) }; string codigo_usuario = ""; int i = 0; arrParam[i].Value = DBNull.Value; arrParam[1].Value = vUsrNT; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.PKG_SISACT_DATAENTRY + ".SISACT_DATOSUSUARIO"; obRequest.Parameters.AddRange(arrParam); IDataReader dr = null; try { dr = obRequest.Factory.ExecuteReader(ref obRequest).ReturnDataReader; while (dr.Read()) { codigo_usuario = Funciones.CheckStr(dr["usuan_codigo"]).Trim(); } } catch (Exception ex) { obRequest.Factory.RollBackTransaction(); throw ex; } finally { if (dr != null) { dr.Close(); } obRequest.Factory.Dispose(); } return(codigo_usuario); }
public string ObtienePeriodoRenov() { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("K_CUR_SALIDA", DbType.Object, ParameterDirection.Output) }; string lista = ""; int i = 0; arrParam[i].Value = DBNull.Value; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.PKG_SISACT_MANT_PLN + ".SISACT_CONSULTA_PER_RENOV"; obRequest.Parameters.AddRange(arrParam); IDataReader dr = null; try { dr = obRequest.Factory.ExecuteReader(ref obRequest).ReturnDataReader; while (dr.Read()) { string cantidad = Funciones.CheckStr(dr["TABLN_CANTIDAD"]).Trim(); string periodo = Funciones.CheckStr(dr["TABLN_PERIODO"]).Trim(); lista = cantidad + "," + periodo; } } catch (Exception ex) { obRequest.Factory.RollBackTransaction(); throw ex; } finally { if (dr != null) { dr.Close(); } obRequest.Factory.Dispose(); } return(lista); }
public bool Guardar_CodigoSMS(string strNroTelefonico, string strClaveSMS, DateTime dttFecha) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("K_RESULTADO", DbType.String, 1, ParameterDirection.Output), new DAABRequest.Parameter("P_TELEFONO", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_CLAVESMS", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_FEC_REGISTRO", DbType.DateTime, ParameterDirection.Input) }; for (int i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } arrParam[0].Value = DBNull.Value; arrParam[1].Value = strNroTelefonico; arrParam[2].Value = strClaveSMS; arrParam[3].Value = dttFecha; bool salida = false; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest objRequest = obj.CreaRequest(); objRequest.CommandType = CommandType.StoredProcedure; objRequest.Command = BaseDatos.SISACT_ENVIARSMS; objRequest.Parameters.AddRange(arrParam); objRequest.Transactional = true; try { objRequest.Factory.ExecuteNonQuery(ref objRequest); objRequest.Factory.CommitTransaction(); salida = true; } catch (Exception e) { throw e; } finally { IDataParameter parSalida1; parSalida1 = (IDataParameter)objRequest.Parameters[0]; salida = Funciones.CheckBoo(Funciones.CheckInt(parSalida1.Value)); objRequest.Factory.Dispose(); } return(salida); }
public ArrayList ListarTipoCuota() { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_CURSOR", DbType.Object, ParameterDirection.Output) }; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest objRequest = obj.CreaRequest(); objRequest.CommandType = CommandType.StoredProcedure; objRequest.Command = BaseDatos.PKG_SISACT_GENERAL + ".SP_CON_TIPO_CUOTA"; objRequest.Parameters.AddRange(arrParam); ArrayList objLista = new ArrayList(); Cuota objItem = null; IDataReader dr = null; try { dr = objRequest.Factory.ExecuteReader(ref objRequest).ReturnDataReader; while (dr.Read()) { objItem = new Cuota(); objItem.idCuota = Funciones.CheckStr(dr["CUOC_CODIGO"]); objItem.cuota = Funciones.CheckStr(dr["CUOV_DESCRIPCION"]); objItem.nroCuota = Funciones.CheckInt(dr["CUON_VIGENCIA"]); objLista.Add(objItem); } } catch (Exception ex) { throw ex; } finally { if (dr != null && dr.IsClosed == false) { dr.Close(); } objRequest.Factory.Dispose(); } return(objLista); }
//ldrz public DataTable ListarPaquete3Play(string P_PRDC, string P_PAQTV_CODIGO, string P_PAQTV_DESCRIPCION, string P_ESTADO) { DataTable dtResultado = new DataTable(); DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_PRDC", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_PAQTV_CODIGO", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_PAQTV_DESCRIPCION", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_ESTADO", 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_PRDC; arrParam[1].Value = P_PAQTV_CODIGO; arrParam[2].Value = P_PAQTV_DESCRIPCION; arrParam[3].Value = P_ESTADO; BDSISACT oBDSISACT = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest oDAABRequest = oBDSISACT.CreaRequest(); oDAABRequest.CommandType = CommandType.StoredProcedure; oDAABRequest.Command = BaseDatos.PKG_SISACT_MANTENIMIENTO_3PLAY + ".SISACT_SEL_PAQUETE_3PLAY"; oDAABRequest.Parameters.AddRange(arrParam); try { dtResultado = oDAABRequest.Factory.ExecuteDataset(ref oDAABRequest).Tables[0]; } catch (Exception ex) { throw ex; } finally { oDAABRequest.Parameters.Clear(); oDAABRequest.Factory.Dispose(); } return(dtResultado); }
//Renovacion public void Actualizar_DC_Historico(string numOperacion, string validarCliente) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_NUM_OPERACION", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_VALIDAR_CLIENTE", DbType.String, ParameterDirection.Input) }; int intCont = 0; for (intCont = 0; intCont < arrParam.Length; intCont++) { arrParam[intCont].Value = DBNull.Value; } if (!numOperacion.Equals("")) { arrParam[0].Value = numOperacion; } if (!validarCliente.Equals("")) { arrParam[1].Value = validarCliente; } BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.PKG_SISACT_EVALUACION_CONS_2 + ".SISACT_UPD_VALIDAR_NOMBRES"; 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(); } }
/// <summary> /// Actualiza la operaciòn de canje de puntos Claro Club, cuando se efectuo el pago de la nota de crèdito. /// </summary> /// <remarks> /// Autor: E77568 /// PS - Automatización de canje y nota de crédito /// RF-04 /// </remarks> public void ActualizarCanjePuntos(CanjePuntos objCanjePuntos) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_NRO_DOC_SAP_NC", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_USUARIO_CANJE", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_FLAG_CANJE", DbType.String, ParameterDirection.Input) }; int i = 0; for (i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } arrParam[0].Value = objCanjePuntos.NRO_DOC_SAP_NC; arrParam[1].Value = objCanjePuntos.USUARIO_CANJE; arrParam[2].Value = objCanjePuntos.FLAG_CANJE; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.SISACT_PKG_PROCESOS + ".MANTSU_UPDATE_CANJE_PUNTOS"; 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 { obRequest.Factory.Dispose(); } }
public string ObtenerValorContingenciaDC(int codParametro) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_CODPARAMETRO", DbType.Int64, ParameterDirection.Input), new DAABRequest.Parameter("K_VALOR", DbType.String, ParameterDirection.Output) }; int i = 0; for (i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } i = 0; arrParam[i].Value = codParametro; string salida = ""; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.PCK_MANT_TABLAS + ".MANTSS_OBTENER_VALOR_CONT_DC"; obRequest.Parameters.AddRange(arrParam); obRequest.Transactional = true; int bb; try { bb = Convert.ToInt16(obRequest.Factory.ExecuteScalar(ref obRequest)); obRequest.Factory.CommitTransaction(); } catch (Exception ex) { obRequest.Factory.RollBackTransaction(); throw ex; } finally { IDataParameter parSalida1; parSalida1 = (IDataParameter)obRequest.Parameters[1]; salida = Funciones.CheckStr(parSalida1.Value); obRequest.Factory.Dispose(); } return(salida); }