Dim dp As WinForm.DateTimePicker = e.Form.Controls("DateTimePicker1")
Dim da As Date = dp.Value
Dim da2 As Date = Date.Today
Dim g As New GroupTableBuilder("统计表1", DataTables("表A"))
g.Groups.AddDef("人名")
g.Totals.AddDef("数量")
g.Filter = "[日期] >= #" & da & "# and [日期] <= #" & da2 & "# "
g.Build()
MainTable = Tables("统计表1")
Dim Chart As WinForm.Chart '定义一个图表变量
Dim Series As WinForm.ChartSeries '定义一个图系变量
Dim dt As DataTable = DataTables("统计表1") '定义一个变量t引用数据表
Chart= e.Form.Controls("Chart1") ' 引用窗口中的图表
Chart.AxisX.ClearValueLabel
Chart.VisualEffect = True '加上这一行,让你的图表更漂亮
Chart.ChartType = ChartTypeEnum.Bar '图表类型该为Bar(条形)
Chart.SeriesList.Clear() '清除图表原来的图系
Chart.VisualEffect = True '加上这一行,让你的图表更漂亮
Chart.ChartType = ChartTypeEnum.Bar '图表类型该为Bar(条形)
Series = Chart.SeriesList.Add() '增加一个图系
Series.Length = dt.dataRows.Count '设置图系的长度
Dim rs As List(Of DataRow) = dt.Select("", "数量 desc")
For i As Integer = 0 To rs.count - 1 '指定每个数据点的位置
Series.X(i) = i '指定水平坐标
Series.Y(i) = rs(i)("数量") '指定垂直坐标
Chart.AxisX.SetValueLabel(i, rs(i)("人名")) '指定字符表示
Next
Chart.LegendVisible = True '显示图列
Chart.LegendCompass= CompassEnum.South '图列显示在南方(底端)
Chart.AxisX.AnnoWithLabels = True '启用字符标示