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