private void PlayTimeListView_MouseDoubleClick(object sender, MouseButtonEventArgs e) { var listView = (ListView)sender; var item = listView.ContainerFromElement((DependencyObject)e.OriginalSource) as ListViewItem; if (item != null) { TimeSummary g = (TimeSummary)PlayTimeListView.SelectedItem; if (g.time != 0) { List <GameTimeSummary> glist = new List <GameTimeSummary>(); using (SQLiteCommand command = conn.CreateCommand()) { conn.Open(); command.CommandText = @"SELECT g.title, p.playtime FROM games g,playtime p WHERE g.uid=p.game AND p.datetime=date('" + g.d.ToString("yyyy-MM-dd") + @"') "; using (SQLiteDataReader reader = command.ExecuteReader()) { while (reader.Read()) { glist.Add(new GameTimeSummary(reader["title"].ToString(), Convert.ToInt32(reader["playtime"].ToString()))); } } } conn.Close(); Dialog.GameTimeGraph gtg = new GameTimeGraph(glist, g.d.ToString("yyyy-MM-dd")); gtg.Owner = Window.GetWindow(this); if (gtg.ShowDialog() == true) { } } } }
private void PlayTimeListView_MouseDoubleClick(object sender, MouseButtonEventArgs e) { var listView = (ListView)sender; var item = listView.ContainerFromElement((DependencyObject)e.OriginalSource) as ListViewItem; if (item != null) { TimeSummary g = (TimeSummary)PlayTimeListView.SelectedItem; if (g.time != 0) { List <GameTimeSummary> glist = new List <GameTimeSummary>(); using (SQLiteCommand command = conn.CreateCommand()) { string hideNukige = ""; if (Settings.Default.hideNukige) { hideNukige = @" AND g.nukige = 0 "; } conn.Open(); command.CommandText = @"SELECT g.title,SUM(p.playtime) playtime FROM games g,playtime p WHERE g.uid=p.game " + hideNukige + @" AND p.datetime BETWEEN date('" + g.d.ToString("yyyy-MM-dd") + @"') AND date('" + g.d.AddMonths(1).AddDays(-1).ToString("yyyy-MM-dd") + @"') GROUP BY g.uid" ; using (SQLiteDataReader reader = command.ExecuteReader()) { while (reader.Read()) { glist.Add(new GameTimeSummary(reader["title"].ToString(), Convert.ToInt32(reader["playtime"].ToString()))); } } } conn.Close(); Dialog.GameTimeGraph gtg = new GameTimeGraph(glist, g.d.ToString("yyyy-MM-dd") + "~" + g.d.AddMonths(1).AddDays(-1).ToString("yyyy-MM-dd"), GraphType.Monthly); gtg.Owner = Window.GetWindow(this); if (gtg.ShowDialog() == true) { } } } }