コード例 #1
0
        public DataTable SearchCount(aspnet_RolesEntityFilter EntityFilter)
        {
            DbCommand storedProcCommand = this.DataBase.GetStoredProcCommand("aspnet_Roles_SearchCount");

            try
            {
                using (storedProcCommand)
                {
                    this.DataBase.AddInParameter(storedProcCommand, "WhereExtendido", DbType.String, (object)EntityFilter.WhereExtendido);
                    this.DataBase.AddInParameter(storedProcCommand, "OrdenDeRegistros", DbType.String, (object)EntityFilter.OrderBy);
                    this.DataBase.AddInParameter(storedProcCommand, "OpeApplicationId", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeApplicationId));
                    this.DataBase.AddInParameter(storedProcCommand, "ApplicationId", DbType.Guid, (object)EntityFilter.ApplicationId);
                    this.DataBase.AddInParameter(storedProcCommand, "OpeRoleId", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeRoleId));
                    this.DataBase.AddInParameter(storedProcCommand, "RoleId", DbType.Guid, (object)EntityFilter.RoleId);
                    this.DataBase.AddInParameter(storedProcCommand, "OpeRoleName", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeRoleName));
                    this.DataBase.AddInParameter(storedProcCommand, "RoleName", DbType.String, (object)EntityFilter.RoleName);
                    this.DataBase.AddInParameter(storedProcCommand, "OpeLoweredRoleName", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeLoweredRoleName));
                    this.DataBase.AddInParameter(storedProcCommand, "LoweredRoleName", DbType.String, (object)EntityFilter.LoweredRoleName);
                    this.DataBase.AddInParameter(storedProcCommand, "OpeDescription", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeDescription));
                    this.DataBase.AddInParameter(storedProcCommand, "Description", DbType.String, (object)EntityFilter.Description);
                    this.DataBase.AddInParameter(storedProcCommand, "OpeLongDescription", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeLongDescription));
                    this.DataBase.AddInParameter(storedProcCommand, "LongDescription", DbType.AnsiString, (object)EntityFilter.LongDescription);
                    return(this.DataBase.ExecuteDataSet(storedProcCommand).Tables[0]);
                }
            }
            catch (SqlException ex)
            {
                throw ex;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #2
0
 public aspnet_RolesEntityInfo.aspnet_RolesEntityInfoList Search(aspnet_RolesEntityFilter EntityFilter, bool NoUtilizar)
 {
     try
     {
         return(this.DataTableToListOfEntityInfo(this.CreateDataAccess().Search(EntityFilter)));
     }
     catch (Exception ex)
     {
         Helpers.Logger.Logger.LogExceptionStatic(ex);
         throw ex;
     }
 }
コード例 #3
0
 public DataTable SearchCount(aspnet_RolesEntityFilter EntityFilter)
 {
     try
     {
         return(this.CreateDataAccess().SearchCount(EntityFilter));
     }
     catch (Exception ex)
     {
         Helpers.Logger.Logger.LogExceptionStatic(ex);
         throw ex;
     }
 }
コード例 #4
0
 public void Search(aspnet_RolesEntityFilter EntityFilter, out aspnet_RolesEntityInfo.aspnet_RolesEntityInfoList listaAGenerar)
 {
     try
     {
         listaAGenerar = this.DataTableToListOfEntityInfo(this.CreateDataAccess().Search(EntityFilter));
     }
     catch (Exception ex)
     {
         Helpers.Logger.Logger.LogExceptionStatic(ex);
         throw ex;
     }
 }