Dim Chart As WinForm.Chart
Dim Series As WinForm.ChartSeries
Dim t As Table = Tables("停机处置")
Chart = Forms("报表").Controls("Chart1")
Chart.ChartType = ChartTypeEnum.Bar
Chart.SeriesList.Clear()
Chart.AxisX.ClearValueLabel
For Each c As Col In t.cols
Select Case c.Name
Case "待派工耗时M","待维修耗时M","维修耗时M","待检验耗时M","检验耗时M","处置停机总耗时M"
Series = Chart.SeriesList.Add()
Series.Text = c.Name
Series.Length = 12
Dim td As Date = new Date(Date.Today.Year, Date.Today.Month, 1)
For i As Integer = 0 To 11
Dim d = td.AddMonths(-i)
Series.X(i) = i
Series.Y(i) = val(t.Compute("Avg(" & c.Name & ")", "申请时间 >= #" & d & "# and 申请时间 < #" & d.AddMonths(1) & "#"))
Chart.AxisX.SetValueLabel(i, Format(d, "yyyy-MM"))
Next
End Select
Next
Chart.AxisX.AnnoWithLabels = True
Chart.VisualEffect = True
Chart.LegendVisible = True
Chart.LegendCompass= CompassEnum.South