📄 form10.frm
字号:
Size = 15.75
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00000000&
Height = 495
Left = 1200
TabIndex = 33
Top = 240
Width = 3855
End
Begin VB.Label Label9
BackStyle = 0 'Transparent
BeginProperty Font
Name = "隶书"
Size = 18
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00E0E0E0&
Height = 495
Left = 2760
TabIndex = 31
Top = 1800
Width = 5415
End
Begin VB.Label Label7
BackStyle = 0 'Transparent
Caption = "月份"
ForeColor = &H00FFFFFF&
Height = 255
Left = 9840
TabIndex = 29
Top = 6720
Width = 375
End
Begin VB.Label Label6
BackStyle = 0 'Transparent
Caption = "销售比率"
ForeColor = &H00FFFFFF&
Height = 255
Left = 360
TabIndex = 28
Top = 6240
Width = 735
End
Begin VB.Label Label5
BackStyle = 0 'Transparent
Caption = "销售金额(元)"
ForeColor = &H00FFFFFF&
Height = 255
Left = 360
TabIndex = 27
Top = 6720
Width = 1095
End
Begin VB.Label Label4
BackColor = &H00C0C000&
ForeColor = &H00000000&
Height = 255
Index = 11
Left = 8040
TabIndex = 26
Top = 6720
Width = 495
End
Begin VB.Label Label4
BackColor = &H00C0C000&
ForeColor = &H00000000&
Height = 255
Index = 10
Left = 7440
TabIndex = 25
Top = 6720
Width = 495
End
Begin VB.Label Label4
BackColor = &H00C0C000&
ForeColor = &H00000000&
Height = 255
Index = 9
Left = 6840
TabIndex = 24
Top = 6720
Width = 495
End
Begin VB.Label Label4
BackColor = &H00C0C000&
ForeColor = &H00000000&
Height = 255
Index = 8
Left = 6240
TabIndex = 23
Top = 6720
Width = 495
End
Begin VB.Label Label4
BackColor = &H00C0C000&
ForeColor = &H00000000&
Height = 255
Index = 7
Left = 5640
TabIndex = 22
Top = 6720
Width = 495
End
Begin VB.Label Label4
BackColor = &H00C0C000&
ForeColor = &H00000000&
Height = 255
Index = 6
Left = 5040
TabIndex = 21
Top = 6720
Width = 495
End
Begin VB.Label Label4
BackColor = &H00C0C000&
ForeColor = &H00000000&
Height = 255
Index = 5
Left = 4440
TabIndex = 20
Top = 6720
Width = 495
End
Begin VB.Label Label4
BackColor = &H00C0C000&
ForeColor = &H00000000&
Height = 255
Index = 4
Left = 3840
TabIndex = 19
Top = 6720
Width = 495
End
Begin VB.Label Label4
BackColor = &H00C0C000&
ForeColor = &H00000000&
Height = 255
Index = 3
Left = 3240
TabIndex = 18
Top = 6720
Width = 495
End
Begin VB.Label Label4
BackColor = &H00C0C000&
ForeColor = &H00000000&
Height = 255
Index = 2
Left = 2640
TabIndex = 17
Top = 6720
Width = 495
End
Begin VB.Label Label4
BackColor = &H00C0C000&
ForeColor = &H00000000&
Height = 255
Index = 1
Left = 2040
TabIndex = 16
Top = 6720
Width = 495
End
Begin VB.Label Label4
BackColor = &H00C0C000&
ForeColor = &H00000000&
Height = 255
Index = 0
Left = 1440
TabIndex = 15
Top = 6720
Width = 495
End
Begin VB.Line Line6
BorderColor = &H000040C0&
BorderWidth = 3
X1 = 10080
X2 = 9960
Y1 = 6600
Y2 = 6720
End
Begin VB.Line Line5
BorderColor = &H000040C0&
BorderWidth = 3
X1 = 10080
X2 = 9960
Y1 = 6600
Y2 = 6480
End
Begin VB.Line Line4
BorderColor = &H000040C0&
BorderWidth = 3
X1 = 1200
X2 = 1320
Y1 = 2280
Y2 = 2400
End
Begin VB.Line Line3
BorderColor = &H000040C0&
BorderWidth = 3
X1 = 1200
X2 = 1080
Y1 = 2280
Y2 = 2400
End
Begin VB.Label Label1
BackColor = &H00808080&
Caption = "1月 2月 3月 4月 5月 6月 7月 8月 9月 10月 11月 12月"
ForeColor = &H00E0E0E0&
Height = 240
Left = 1440
TabIndex = 0
Top = 7080
Width = 7215
End
Begin VB.Line Line2
BorderColor = &H000040C0&
BorderWidth = 3
X1 = 1200
X2 = 10080
Y1 = 6600
Y2 = 6600
End
Begin VB.Line Line1
BorderColor = &H000040C0&
BorderWidth = 3
X1 = 1200
X2 = 1200
Y1 = 2280
Y2 = 6600
End
Begin VB.Label Label8
BackStyle = 0 'Transparent
Caption = "比例情况"
ForeColor = &H00FFFFFF&
Height = 735
Left = 840
TabIndex = 30
Top = 2520
Width = 255
End
End
Attribute VB_Name = "Form10"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
If Combo1.Text = "" Then
MsgBox "请选择或填写药品名称！", vbOKOnly + vbInformation, "提示"
Combo1.SetFocus
Exit Sub
End If
sql = "select * from yaopinjbxx,xiaoshou,namezidian where yaopinjbxx.pk=xiaoshou.pk and yaopinjbxx.yno=namezidian.yno and tyinf=0 and yname='" & Combo1.Text & "'"
Call adoopen
Call rs(sql)
If adors.EOF Then
MsgBox "未曾销售该药品", vbOKOnly + vbInformation, "提示"
Combo1.Text = ""
Combo1.SetFocus
Call adoclose
Exit Sub
End If
Call adoclose
Label9.Caption = Year(Date) & "年度 " & Combo1.Text & "月销售情况"
Dim tj(12) As Single
For i = 1 To 11
Call adoopen
sql = "select * from xiaosdingjia,xiaoshou,yaopinjbxx,changjiazidian,namezidian where yaopinjbxx.pk=xiaosdingjia.pk and yaopinjbxx.pk=xiaoshou.pk and namezidian.yno=yaopinjbxx.yno and yname='" & Combo1.Text & "'and shoushi between '" & Year(Date) & "-" & i & "-1' and '" & Year(Date) & "-" & (i + 1) & "-1'"
Call rs(sql)
If Not adors.EOF Then
Call adoclose
Call adoopen
sql = "select sum(zonge) as zonge from xiaosdingjia,xiaoshou,yaopinjbxx,changjiazidian,namezidian where yaopinjbxx.pk=xiaosdingjia.pk and yaopinjbxx.pk=xiaoshou.pk and namezidian.yno=yaopinjbxx.yno and yname='" & Combo1.Text & "'and shoushi between '" & Year(Date) & "-" & i & "-1' and '" & Year(Date) & "-" & (i + 1) & "-1'"
Call rs(sql)
'If Not adors.EOF Then
tj(i - 1) = Val(adors.Fields("zonge"))
Call adoclose
Else
tj(i - 1) = 0
Call adoclose
End If
Text1 = Text1 & " " & tj(i - 1)
Next i
Call adoopen
sql = "select * from xiaosdingjia,xiaoshou,yaopinjbxx,changjiazidian,namezidian where yaopinjbxx.pk=xiaosdingjia.pk and yaopinjbxx.pk=xiaoshou.pk and namezidian.yno=yaopinjbxx.yno and yname='" & Combo1.Text & "'and shoushi between '" & Year(Date) & "-12-1' and '" & Year(Date) + 1 & "-1-1'"
Call rs(sql)
If Not adors.EOF Then
Call adoclose
Call adoopen
sql = "select sum(zonge) as zonge from xiaosdingjia,xiaoshou,yaopinjbxx,changjiazidian,namezidian where yaopinjbxx.pk=xiaosdingjia.pk and yaopinjbxx.pk=xiaoshou.pk and namezidian.yno=yaopinjbxx.yno and yname='" & Combo1.Text & "'and shoushi between '" & Year(Date) & "-12-1' and '" & Year(Date) + 1 & "-1-1'"
Call rs(sql)
tj(12) = Val(adors.Fields("zonge"))
Call adoclose
Else
tj(12) = 0
Call adoclose
End If
Text1 = Text1 & " " & tj(12)
For i = 0 To 11
tjsum = tjsum + tj(i)
Next i
For i = 0 To 11
Label3(i).Caption = (Format$(Str$(tj(i) / tjsum), "0.0%"))
Shape1(i).Top = Picture2.Height - tj(i) / tjsum * (Picture2.Height - Label3(i).Height)
Shape1(i).Height = tj(i) / tjsum * (Picture2.Height - Label3(i).Height)
Label3(i).Top = Shape1(i).Top - Label3(i).Height
Label4(i).Caption = tj(i)
Label4(i).BackColor = &HC0C0FF
Next i
End Sub
Private Sub Command2_Click()
Unload Me
End Sub
Private Sub Form_Load()
Move MDIForm1.Left + (MDIForm1.Width - Me.Width) / 2, MDIForm1.Top + 2000
sql = "select distinct yname from yaopinjbxx,xiaoshou,namezidian where yaopinjbxx.pk=xiaoshou.pk and yaopinjbxx.yno=namezidian.yno"
Call comadd(sql, "yname", Combo1)
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -