1,451
社区成员
发帖
与我相关
我的任务
分享
Mschart.Plot.SeriesCollection(1).DataPoints(-1).DataPointLabel.LocationType = VtChLabelLocationTypeRight
Private Sub Form_Load()
Dim pvarPara As Variant, pstrSql As String
Dim precRS As New ADODB.Recordset
Dim pvarValues(1 To 12, 1 To 2), pintI As Integer
Me.Icon = efrmMain.Icon
'分解参数
pvarPara = Split(gstrPara, ";")
'设置标题
Select Case pvarPara(0)
Case "A":
Me.Caption = "生产性供应商欠款走势图"
Case "B":
Me.Caption = "生产性供应商付款走势图"
Case "C":
Me.Caption = "生产性供应商欠款余额走势图"
End Select
MSCData.AllowDynamicRotation = False
MSCData.AllowSelections = False
MSCData.AllowSeriesSelection = False
'数据查询
pstrSql = "exec mprSearchSingleManufPay '" & pvarPara(0) & "','" & pvarPara(1) & "','" & pvarPara(2) & "'"
Set precRS = ufmRecordSet(pstrSql)
If Not precRS.EOF Then
MSCData.TitleText = pvarPara(1) + "年" + precRS.Fields("fldManuFSName").Value + "(" + precRS.Fields("fldCurrencyID").Value + ")"
MSCData.RowCount = 1
For pintI = 1 To 12
pvarValues(pintI, 1) = Trim(Str(pintI)) + "月" '字符串
pvarValues(pintI, 2) = precRS.Fields(pintI).Value '数值
Next
MSCData.ChartData = pvarValues
End If
End Sub