public DataTable fdtbListarTipoOficina() { DataTable dtResultado = new DataTable(); DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_CONSULTA", DbType.Object, ParameterDirection.Output) }; arrParam[0].Value = DBNull.Value; BDSISMANT obj = new BDSISMANT(BaseDatos.BD_SISACT); DAABRequest objRequest = obj.CreaRequest(); objRequest.CommandType = CommandType.StoredProcedure; objRequest.Command = BaseDatos.SISACT_PKG_PLAN_TARIFARIO + ".MANTSS_LISTAR_TIPO_OFIC"; 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 ArrayList Listar_Portal() { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_CONSULTA", DbType.Object, ParameterDirection.Output) }; int i; for (i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } BDSISMANT obj = new BDSISMANT(BaseDatos.BD_SISACT); DAABRequest objRequest = obj.CreaRequest(); objRequest.CommandType = CommandType.StoredProcedure; objRequest.Command = BaseDatos.PCK_MANT_TABLAS + ".MANTSS_LISTAR_PORTAL_TEMP"; objRequest.Parameters.AddRange(arrParam); IDataReader dr = null; ArrayList filas = new ArrayList(); try { dr = objRequest.Factory.ExecuteReader(ref objRequest).ReturnDataReader; while (dr.Read()) { ItemGenerico item = new ItemGenerico(); item.Codigo = dr["PTRUI_CODIGO"].ToString(); item.Descripcion = dr["PTRUV_DESCRIPCION"].ToString(); item.Descripcion2 = dr["PTRUV_RUTA"].ToString(); filas.Add(item); } } catch (Exception e) { throw e; } finally { if (dr != null && dr.IsClosed == false) { dr.Close(); } objRequest.Parameters.Clear(); objRequest.Factory.Dispose(); } return(filas); }
public ArrayList ListarPDV(string pstrCanales, string pstrCodigo, string pstrDescripcion) { DataTable dtResultado = new DataTable(); ArrayList ListaPdv = new ArrayList(); PuntoVenta oPuntoVenta; //=new PuntoVenta(); DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_CONSULTA", DbType.Object, ParameterDirection.Output), new DAABRequest.Parameter("P_CANALES", DbType.String, 50,ParameterDirection.Input), new DAABRequest.Parameter("P_CODIGO", DbType.String, 4,ParameterDirection.Input), new DAABRequest.Parameter("P_DESCRIPCION", DbType.String, 40,ParameterDirection.Input) }; arrParam[0].Value = DBNull.Value; arrParam[1].Value = pstrCanales; arrParam[2].Value = pstrCodigo; arrParam[3].Value = pstrDescripcion; BDSISMANT obj = new BDSISMANT(BaseDatos.BD_SISACT); DAABRequest objRequest = obj.CreaRequest(); objRequest.CommandType = CommandType.StoredProcedure; objRequest.Command = BaseDatos.SISACT_PKG_PLAN_TARIFARIO + ".MANTSS_LISTAR_PDV_TOTAL"; objRequest.Parameters.AddRange(arrParam); try { dtResultado = objRequest.Factory.ExecuteDataset(ref objRequest).Tables[0]; foreach (DataRow dr in dtResultado.Rows) { oPuntoVenta = new PuntoVenta(); oPuntoVenta.OVENC_CODIGO = Funciones.CheckStr(dr["OVENC_CODIGO"]); oPuntoVenta.OVENV_DESCRIPCION = Funciones.CheckStr(dr["OVENV_DESCRIPCION"]); oPuntoVenta.CANAC_CODIGO = Funciones.CheckStr(dr["CANAC_CODIGO"]); ListaPdv.Add(oPuntoVenta); } } catch (Exception ex) { throw ex; } finally { objRequest.Factory.Dispose(); } return(ListaPdv); }