public DataTable FILTRARDatos(string sNombreSP, string sNombreParametro, SqlDbType DBType, string svalorparametro)
{
Cls_BD_BLL obj_BD_BLL = new Cls_BD_BLL();
Cls_BD_DAL obj_BD_DAL = new Cls_BD_DAL();
return(obj_BD_BLL.ExecuteDataAdapter(sNombreSP, sNombreParametro, DBType, svalorparametro));
}
//Hecho Por Juan Diego
public DataTable ListarDatos(string sNombreSP)
{
Cls_BD_BLL obj_BD_BLL = new Cls_BD_BLL();
Cls_BD_DAL obj_BD_DAL = new Cls_BD_DAL();
return(obj_BD_BLL.ExecuteDataAdapter(sNombreSP, "", SqlDbType.VarChar, ""));
}
public DataTable ListarDatos(string sNombreSP, ref string SMsError)
{
Cls_BD_BLL obj_BD_BLL = new Cls_BD_BLL();
return(obj_BD_BLL.ExecuteDataAdapter(sNombreSP, "",
SqlDbType.VarChar, "", ref SMsError));
}
public DataTable FiltrarDatos(string sNombreSP, string sNombreParametro,
SqlDbType DbType, string sValrParametro, ref string SMsError)
{
Cls_BD_BLL obj_BD_BLL = new Cls_BD_BLL();
return(obj_BD_BLL.ExecuteDataAdapter(sNombreSP, sNombreParametro,
DbType, sValrParametro, ref SMsError));
}
public DataTable Cargar(string IdPersona, ref string sMsj_error)
{
return(Obj_BD_BLL.ExecuteDataAdapter(Datatable_Cargar(IdPersona, string.Empty, string.Empty, string.Empty, float.MinValue), "[dbo].[sp_search_cargar_membresia]", ref sMsj_error));
}
public DataTable Listar(ref string sMsj_error)
{
return(Obj_BD_BLL.ExecuteDataAdapter(null, "[dbo].[sp_select_TB_Telefonos]", ref sMsj_error));
}
public DataTable Listar(ref string sMsjError)
{
return(Obj_BD_BLL.ExecuteDataAdapter(null, "[dbo].[sp_select_V_Persona]", ref sMsjError));
}
public DataTable Listar(ref string sMsjError)
{
return(Obj_BD_BLL.ExecuteDataAdapter(null, "[dbo].[sp_select_TB_FacturaDetalle]", ref sMsjError));
}