예제 #1
0
파일: Home.xaml.cs 프로젝트: yhhno/Adhesive
 /// <summary>
 /// 数据量统计方式呈现数据
 /// </summary>
 private void StatView()
 {
     string categoryName = "";
     string databaseName = "";
     var databasePrefix = GetDatabasePrefix(ref categoryName, ref databaseName);
     if (databasePrefix != null)
     {
         var tableNames = GetTableNames(false);
         if (tableNames != null)
         {
             if (tableNames.Count > 10)
             {
                 MessageBox.Show("对于数据量统计方式呈现最多只能选择10个表");
                 return;
             }
             var beginTime = GetBeginTime();
             if (beginTime != null)
             {
                 var endTime = GetEndTime();
                 if (endTime != null)
                 {
                     var filters = GetFilters();
                     var sc = new SearchCondition
                     {
                         DatabasePrefix = databasePrefix,
                         TableNames = tableNames,
                         Filters = filters,
                         BeginTime = beginTime.Value,
                         EndTime = endTime.Value,
                     };
                     ShowStatView(sc, categoryName, databaseName);
                 }
             }
         }
     }
 }
예제 #2
0
파일: Home.xaml.cs 프로젝트: yhhno/Adhesive
 private void ShowStatView(SearchCondition sc, string categoryName, string databaseName)
 {
     var root = Application.Current.RootVisual as FrameworkElement;
     ViewStatData c = new ViewStatData();
     c.SearchCondition = sc;
     c.Width = root.ActualWidth * 0.98;
     c.Height = root.ActualHeight * 0.98;
     c.HorizontalAlignment = HorizontalAlignment.Center;
     c.VerticalAlignment = VerticalAlignment.Center;
     c.Show();
     foreach (var tableName in sc.TableNames)
     {
         service.LogAsync(new OperationLog
         {
             AccountName = Data.AdminConfigurationItem.UserName,
             AccountRealName = Data.AdminConfigurationItem.RealName,
             CategoryName = categoryName,
             DatabaseName = databaseName,
             TableName = tableName,
             Action = "查看统计视图",
             ActionMemo = string.Format("开始时间:{0} 结束时间:{1} 过滤条件:{2}",
             sc.BeginTime,
             sc.EndTime,
             sc.Filters.GetFilterText())
         });
     }
 }
예제 #3
0
파일: Home.xaml.cs 프로젝트: yhhno/Adhesive
 /// <summary>
 /// 分组统计方式呈现数据
 /// </summary>
 private void GroupView()
 {
     string categoryName = "";
     string databaseName = "";
     var databasePrefix = GetDatabasePrefix(ref categoryName, ref databaseName);
     if (databasePrefix != null)
     {
         var tableNames = GetTableNames(false);
         if (tableNames != null)
         {
             var beginTime = GetBeginTime();
             if (beginTime != null)
             {
                 var endTime = GetEndTime();
                 if (endTime != null)
                 {
                     var filters = GetFilters();
                     var sc = new SearchCondition
                     {
                         DatabasePrefix = databasePrefix,
                         TableNames = tableNames,
                         Filters = filters,
                         BeginTime = beginTime.Value,
                         EndTime = endTime.Value,
                     };
                     ShowGroupView(sc, categoryName, databaseName);
                 }
             }
         }
     }
 }