/// <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);
}