public SortieStatisticViewModel() { var rTimeSpans = Enumerable.Range(0, 6).Select(r => new SortieStatisticDefaultTimeSpanGroupViewModel(this, (SortieStatisticTimeSpanType)r)).ToList <SortieStatisticTimeSpanGroupViewModel>(); rTimeSpans.Add(CustomTimeSpan = new SortieStatisticCustomTimeSpanGroupViewModel(this)); TimeSpans = rTimeSpans.ToArray(); r_SelectedTimeSpan = TimeSpans[0]; using (var rCommand = RecordService.Instance.CreateCommand()) { rCommand.CommandText = "SELECT group_concat(DISTINCT map / 10) FROM sortie WHERE id >= strftime('%s', 'now', 'localtime', 'start of month', '-1 month', 'utc') AND map NOT IN (" + string.Join(", ", KanColleGame.Current.MasterInfo.Maps.Keys) + ");"; var rPastAreas = rCommand.ExecuteScalar(); if (rPastAreas != DBNull.Value) { PastAreas = (string)rPastAreas; } var rAreas = KanColleGame.Current.MasterInfo.MapAreas.Values.Select(r => new SortieStatisticAreaViewModel(r) { IsSelectedChangedCallback = Load }).ToList(); if (PastAreas != null) { rAreas.Add(new SortieStatisticAreaViewModel(null) { IsSelectedChangedCallback = Load }); } Areas = rAreas.ToArray(); rCommand.CommandText = "SELECT min(id) FROM sortie_consumption;"; CustomTimeSpan.MinDisplayDateStart = DateTimeUtil.FromUnixTime((long)rCommand.ExecuteScalar()).ToOffset(DateTimeOffset.Now.Offset).DateTime.Date; } }
public SortieStatisticViewModel() { var rTimeSpans = Enumerable.Range(0, 6).Select(r => new SortieStatisticDefaultTimeSpanGroupViewModel(this, (SortieStatisticTimeSpanType)r)).ToList<SortieStatisticTimeSpanGroupViewModel>(); rTimeSpans.Add(CustomTimeSpan = new SortieStatisticCustomTimeSpanGroupViewModel(this)); TimeSpans = rTimeSpans.ToArray(); r_SelectedTimeSpan = TimeSpans[0]; using (var rCommand = RecordService.Instance.CreateCommand()) { rCommand.CommandText = "SELECT group_concat(DISTINCT map / 10) FROM sortie WHERE id >= strftime('%s', 'now', 'localtime', 'start of month', '-1 month', 'utc') AND map NOT IN (" + string.Join(", ", KanColleGame.Current.MasterInfo.Maps.Keys) + ");"; var rPastAreas = rCommand.ExecuteScalar(); if (rPastAreas != DBNull.Value) PastAreas = (string)rPastAreas; var rAreas = KanColleGame.Current.MasterInfo.MapAreas.Values.Select(r => new SortieStatisticAreaViewModel(r) { IsSelectedChangedCallback = Load }).ToList(); if (PastAreas != null) rAreas.Add(new SortieStatisticAreaViewModel(null) { IsSelectedChangedCallback = Load }); Areas = rAreas.ToArray(); rCommand.CommandText = "SELECT min(id) FROM sortie_consumption;"; CustomTimeSpan.MinDisplayDateStart = DateTimeUtil.FromUnixTime((long)rCommand.ExecuteScalar()).ToOffset(DateTimeOffset.Now.Offset).DateTime.Date; } }
public SortieStatisticViewModel() { TimeSpans = Enumerable.Range(0, 6).Select(r => new SortieStatisticTimeSpanGroupViewModel((SortieStatisticTimeSpanType)r)).ToArray(); r_SelectedTimeSpan = TimeSpans[0]; }
protected override void DisposeManagedResources() { SelectedTimeSpan = null; TimeSpans = null; }