public async Task <List <DatabaseGDR> > GetList(EnableEnum status) { try { var databaseGDRList = dbSet .Include(y => y.DatabaseType) .Include(x => x.ReportDatabaseGDR) .ThenInclude(x => x.Report) .AsQueryable(); if (status != EnableEnum.All) { databaseGDRList = databaseGDRList.Where(x => x.Enable == status); } await log.SaveLogApplicationMessage(ControllerName, "Lista de bancos de dados retornada"); return(await databaseGDRList.OrderBy(x => x.Name).ToListAsync()); } catch (Exception error) { await log.SaveLogApplicationError(ControllerName, "Erro ao buscar lista de bancos de dados: " + error.ToString()); return(null); } }
public async Task <List <Report> > GetList(EnableEnum status) { var teste = dbSet.ToList(); try { var report = dbSet .Include(x => x.ReportDatabaseGDR) .ThenInclude(x => x.DatabaseGDR) .Include(x => x.ReportPermissionGroup) .ThenInclude(x => x.PermissionGroup) .AsQueryable(); if (status != EnableEnum.All) { report = report.Where(x => x.Enable == status); } await log.SaveLogApplicationMessage(ControllerName, "Lista de relatórios retornada"); return(await report.OrderBy(x => x.Name).ToListAsync()); } catch (Exception error) { await log.SaveLogApplicationError(ControllerName, "Erro ao buscar relatórios de dados: " + error.ToString()); return(null); } }
private void Set(EnableEnum feature, bool enable) { switch (feature) { case EnableEnum.Blur: Singleton <BlurRunner> .Instance.SetBlur(enable); break; case EnableEnum.GameView: if (Camera.main != null) { Camera.main.farClipPlane = ((!enable) ? 1 : 200); } if (Singleton <EnableObjectsRunner> .Instance != null) { Singleton <EnableObjectsRunner> .Instance.GameView.Value = enable; } break; case EnableEnum.SmallCurrencyHeader: if (Singleton <EnableObjectsRunner> .Instance != null) { Singleton <EnableObjectsRunner> .Instance.SmallCurrencyHeader.Value = enable; } break; case EnableEnum.Popup: if (Singleton <EnableObjectsRunner> .Instance != null) { Singleton <EnableObjectsRunner> .Instance.Popup.Value = enable; } break; case EnableEnum.DelayedCurrencyHeader: if (Singleton <EnableObjectsRunner> .Instance != null) { Singleton <EnableObjectsRunner> .Instance.DelayedCurrencyHeader.Value = enable; } break; case EnableEnum.MapCloseButton: if (Singleton <EnableObjectsRunner> .Instance != null) { Singleton <EnableObjectsRunner> .Instance.MapCloseButton.Value = enable; } break; } }
public void changeParam(EnableEnum enable) { if (!emitter) { return; } if (enable == EnableEnum.NoChange) { return; } else if (enable == EnableEnum.Enable && emitter) { emitter.SetParameter(paramater, 1f); } else if (enable == EnableEnum.Disable && emitter) { emitter.SetParameter(paramater, 0f); } }
public Page<User> QueryByPage(string userName, EnableEnum state, int pageIdex , int pageSize = 20 ) { Page<User> page = new Page<User>(); page.PageIdx = pageIdex; page.PageSize = pageSize; string where = " 1=1 "; if(! string.IsNullOrEmpty ( userName )) { userName = userName.Replace("'", ""); where += string.Format( " and username like '%{0}%'" , userName ); } if( state != EnableEnum.ALL ) { where += string.Format ( " and enable ={0}" , (int)state ); } string pageString = string.Format ( " limit {0},{1}" , pageIdex < 1 ? 0 : (pageIdex-1) * pageSize , pageSize ) ; string orderby = string.Format(" order by modifytime desc"); string sql = string.Format( "select count(1) from t_user where {0} " , where ); object obj = MySqlHelper.GetSingle(sql); int totalRecords = 0; if (obj == null) totalRecords = 0; int.TryParse(obj.ToString(), out totalRecords); int totalPages = totalRecords / pageSize; totalPages += totalRecords % pageSize == 0 ? 0 : 1; page.TotalPages = totalPages; page.TotalRecords = totalRecords; if (totalRecords == 0) { page.Data = null; return page; } sql = string.Format("select * from t_user where {0} {1} {2}", where , orderby , pageString ); DataSet result = MySqlHelper.Query(sql); if (result == null || result.Tables.Count < 1 || result.Tables[0].Rows.Count < 1) return null; List<User> list = new List<User>(); for (int i = 0; i < result.Tables[0].Rows.Count; i++) { User model= DataRowToUser( result.Tables[0].Rows[i]); list.Add(model); } page.Data = list; return page; }