📄 form3.frm
字号:
VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCTL.OCX"
Begin VB.Form Form3
BackColor = &H0080C0FF&
Caption = "库存浏览\价格设定"
ClientHeight = 5790
ClientLeft = 60
ClientTop = 465
ClientWidth = 9765
ControlBox = 0 'False
LinkTopic = "Form3"
MDIChild = -1 'True
Picture = "Form3.frx":0000
ScaleHeight = 5790
ScaleWidth = 9765
WindowState = 2 'Maximized
Begin VB.Timer Timer1
Interval = 5
Left = 2520
Top = 1560
End
Begin VB.PictureBox Picture1
Appearance = 0 'Flat
BackColor = &H00404040&
BorderStyle = 0 'None
ForeColor = &H80000008&
Height = 615
Left = 0
ScaleHeight = 615
ScaleWidth = 9615
TabIndex = 2
Top = 120
Width = 9615
Begin VB.PictureBox Picture3
Appearance = 0 'Flat
BackColor = &H00404040&
BorderStyle = 0 'None
ForeColor = &H80000008&
Height = 375
Left = 3960
ScaleHeight = 375
ScaleWidth = 5895
TabIndex = 4
Top = 120
Width = 5895
Begin VB.TextBox Text1
Appearance = 0 'Flat
BackColor = &H00404040&
BorderStyle = 0 'None
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = -1 'True
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FFFFC0&
Height = 375
Left = 0
Locked = -1 'True
TabIndex = 5
Top = 0
Width = 4935
End
End
Begin VB.Image Image1
Height = 480
Left = 240
Picture = "Form3.frx":292DD2
Top = 80
Width = 480
End
Begin VB.Label Label2
BackStyle = 0 'Transparent
Caption = "设置定价"
BeginProperty Font
Name = "宋体"
Size = 15.75
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H8000000A&
Height = 375
Left = 960
TabIndex = 3
Top = 140
Width = 4575
End
End
Begin MSComctlLib.ImageList ImageList1
Left = 1200
Top = 1800
_ExtentX = 1005
_ExtentY = 1005
BackColor = -2147483643
ImageWidth = 16
ImageHeight = 16
MaskColor = 12632256
_Version = 393216
BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628}
NumListImages = 4
BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Form3.frx":2930DC
Key = "p1"
EndProperty
BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Form3.frx":293476
Key = "p2"
EndProperty
BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Form3.frx":293810
Key = "p3"
EndProperty
BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Form3.frx":293BAA
Key = "p4"
EndProperty
EndProperty
End
Begin MSComctlLib.ListView ListView1
Height = 255
Left = 360
TabIndex = 0
TabStop = 0 'False
Top = 1440
Width = 855
_ExtentX = 1508
_ExtentY = 450
View = 3
LabelEdit = 1
Sorted = -1 'True
LabelWrap = 0 'False
HideSelection = -1 'True
AllowReorder = -1 'True
FullRowSelect = -1 'True
_Version = 393217
Icons = "ImageList1"
SmallIcons = "ImageList1"
ColHdrIcons = "ImageList1"
ForeColor = -2147483640
BackColor = 16777215
BorderStyle = 1
Appearance = 0
NumItems = 9
BeginProperty ColumnHeader(1) {BDD1F052-858B-11D1-B16A-00C0F0283628}
Text = "药品名称"
Object.Width = 2540
EndProperty
BeginProperty ColumnHeader(2) {BDD1F052-858B-11D1-B16A-00C0F0283628}
SubItemIndex = 1
Text = "类别"
Object.Width = 2540
EndProperty
BeginProperty ColumnHeader(3) {BDD1F052-858B-11D1-B16A-00C0F0283628}
SubItemIndex = 2
Text = "生产厂家"
Object.Width = 2540
EndProperty
BeginProperty ColumnHeader(4) {BDD1F052-858B-11D1-B16A-00C0F0283628}
SubItemIndex = 3
Text = "出厂日期"
Object.Width = 2540
EndProperty
BeginProperty ColumnHeader(5) {BDD1F052-858B-11D1-B16A-00C0F0283628}
SubItemIndex = 4
Text = "保质期"
Object.Width = 2540
EndProperty
BeginProperty ColumnHeader(6) {BDD1F052-858B-11D1-B16A-00C0F0283628}
SubItemIndex = 5
Text = "库存数量"
Object.Width = 2540
EndProperty
BeginProperty ColumnHeader(7) {BDD1F052-858B-11D1-B16A-00C0F0283628}
SubItemIndex = 6
Text = "进药价格"
Object.Width = 2540
EndProperty
BeginProperty ColumnHeader(8) {BDD1F052-858B-11D1-B16A-00C0F0283628}
SubItemIndex = 7
Text = "pk"
Object.Width = 0
EndProperty
BeginProperty ColumnHeader(9) {BDD1F052-858B-11D1-B16A-00C0F0283628}
SubItemIndex = 8
Text = "进药单位"
Object.Width = 2540
EndProperty
End
Begin VB.Image Image2
Height = 240
Left = 600
Picture = "Form3.frx":293F44
Stretch = -1 'True
Top = 960
Width = 240
End
Begin VB.Label Label1
BackColor = &H00E0E0E0&
BackStyle = 0 'Transparent
Caption = "双击药品信息设置或修改药品定价"
BeginProperty Font
Name = "隶书"
Size = 18
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00404000&
Height = 375
Left = 1080
TabIndex = 1
Top = 840
Width = 6735
End
End
Attribute VB_Name = "Form3"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim k%
Private Sub Form_Load()
Text1.Text = "欢迎使用医药销售系统 今日时间：" & Date
k = 10
ListView1.ListItems.Clear
Call adoopen
sql = "select yaopinjbxx.pk,namezidian.yno,namezidian.yname,leibiezidian.leiname,changjiazidian.cname,kucunjilu.chuchangdate,baozhiqi,kunum,dname,danjia from yaopinjbxx,namezidian,leibiezidian,kucunjilu,danweizidian,changjiazidian where yaopinjbxx.yno=namezidian.yno and yaopinjbxx.lno=leibiezidian.lno and yaopinjbxx.dno=danweizidian.dno and yaopinjbxx.cno=changjiazidian.cno and yaopinjbxx.pk=kucunjilu.pk"
Call rs(sql)
If Not adors.EOF Then
While Not adors.EOF
Set a = ListView1.ListItems.Add()
a.SmallIcon = 4
a.Text = Trim$(adors.Fields("yname"))
a.SubItems(1) = Trim$(adors.Fields("leiname"))
a.SubItems(2) = Trim$(adors.Fields("cname"))
a.SubItems(3) = Trim$(adors.Fields("chuchangdate"))
a.SubItems(4) = Trim$(adors.Fields("baozhiqi"))
a.SubItems(5) = Trim$(adors.Fields("kunum"))
a.SubItems(6) = Trim$(adors.Fields("danjia"))
a.SubItems(7) = Trim$(adors.Fields("pk"))
a.SubItems(8) = Trim$(adors.Fields("dname"))
adors.MoveNext
Wend
End If
Call adoclose
End Sub
Private Sub Form_Resize()
If Me.Width > 1000 Then ListView1.Width = Me.Width - 1000
If Me.Height > 2700 Then ListView1.Height = Me.Height - 2700
Picture1.Width = Width
End Sub
Private Sub ListView1_DblClick()
Dim j As Long
j = ListView1.SelectedItem.Index
Dim Item As ListItem
Set Item = ListView1.SelectedItem
change(0) = Item.Text
For i = 1 To 7
change(i) = Item.SubItems(i)
Next i
Form4.Show 1
End Sub
Private Sub Timer1_Timer()
If Text1.Left >= -Text1.Width Then
Text1.Left = Text1.Left - k
Else
Text1.Left = Picture3.Width
End If
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -