📄 yk_ybb.frm
字号:
VERSION 5.00
Object = "{00028C01-0000-0000-0000-000000000046}#1.0#0"; "DBGRID32.OCX"
Object = "{C932BA88-4374-101B-A56C-00AA003668DC}#1.1#0"; "MSMASK32.OCX"
Object = "{F6125AB1-8AB1-11CE-A77F-08002B2F4E98}#2.0#0"; "MSRDC20.OCX"
Object = "{FE0065C0-1B7B-11CF-9D53-00AA003C9CB6}#1.1#0"; "COMCT232.OCX"
Begin VB.Form yk_ybb
BackColor = &H00C0C0C0&
Caption = "月报表"
ClientHeight = 6825
ClientLeft = 60
ClientTop = 345
ClientWidth = 9480
ControlBox = 0 'False
LinkTopic = "Form1"
Moveable = 0 'False
ScaleHeight = 6825
ScaleWidth = 9480
StartUpPosition = 3 '窗口缺省
WindowState = 2 'Maximized
Begin VB.Frame Frame1
Height = 1275
Left = 45
TabIndex = 0
Top = 0
Width = 9405
Begin ComCtl2.UpDown UpDown2
Height = 390
Left = 8445
TabIndex = 12
Top = 225
Width = 270
_ExtentX = 423
_ExtentY = 688
_Version = 327681
End
Begin ComCtl2.UpDown UpDown1
Height = 375
Left = 5355
TabIndex = 11
Top = 240
Width = 270
_ExtentX = 423
_ExtentY = 661
_Version = 327681
End
Begin VB.ComboBox drug_kind
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 360
Left = 1410
Style = 2 'Dropdown List
TabIndex = 4
Top = 240
Width = 1155
End
Begin VB.CommandButton quit
Caption = "退出"
BeginProperty Font
Name = "隶书"
Size = 14.25
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 450
Left = 6270
TabIndex = 3
Top = 705
Width = 1950
End
Begin VB.CommandButton print_com
Caption = "打印"
BeginProperty Font
Name = "隶书"
Size = 14.25
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 450
Left = 3705
TabIndex = 2
Top = 705
Width = 1950
End
Begin VB.CommandButton browse
Caption = "浏览"
BeginProperty Font
Name = "隶书"
Size = 14.25
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 450
Left = 1140
TabIndex = 1
Top = 705
Width = 1950
End
Begin MSMask.MaskEdBox yp_date2
Height = 375
Left = 7155
TabIndex = 6
Top = 240
Width = 1305
_ExtentX = 2302
_ExtentY = 661
_Version = 393216
BackColor = 12640511
MaxLength = 10
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Mask = "####-##-##"
PromptChar = "_"
End
Begin MSMask.MaskEdBox yp_date1
Height = 375
Left = 4065
TabIndex = 7
Top = 240
Width = 1305
_ExtentX = 2302
_ExtentY = 661
_Version = 393216
BackColor = 12640511
MaxLength = 10
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Mask = "####-##-##"
PromptChar = "_"
End
Begin VB.Label Label1
BackColor = &H00C0C0C0&
BackStyle = 0 'Transparent
Caption = "药品类型"
BeginProperty Font
Name = "黑体"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 375
Index = 1
Left = 195
TabIndex = 5
Top = 315
Width = 1335
End
Begin VB.Label Label2
BackColor = &H00C0C0C0&
BackStyle = 0 'Transparent
Caption = "结束日期："
BeginProperty Font
Name = "黑体"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 375
Left = 6105
TabIndex = 9
Top = 315
Width = 1335
End
Begin VB.Label Label1
BackColor = &H00C0C0C0&
BackStyle = 0 'Transparent
Caption = "起始日期："
BeginProperty Font
Name = "黑体"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 375
Index = 0
Left = 3000
TabIndex = 8
Top = 315
Width = 1335
End
End
Begin MSRDC.MSRDC biao
Height = 330
Left = 660
Top = 3390
Visible = 0 'False
Width = 1200
_ExtentX = 2117
_ExtentY = 582
_Version = 393216
Options = 0
CursorDriver = 1
BOFAction = 0
EOFAction = 0
RecordsetType = 1
LockType = 3
QueryType = 0
Prompt = 3
Appearance = 1
QueryTimeout = 30
RowsetSize = 100
LoginTimeout = 15
KeysetSize = 0
MaxRows = 0
ErrorThreshold = -1
BatchSize = 15
BackColor = -2147483643
ForeColor = -2147483640
Enabled = -1 'True
ReadOnly = 0 'False
Appearance = -1 'True
DataSourceName = ""
RecordSource = ""
UserName = ""
Password = ""
Connect = ""
LogMessages = ""
Caption = "biao"
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
End
Begin MSDBGrid.DBGrid DBGrid1
Bindings = "yk_ybb.frx":0000
Height = 5355
Left = 90
OleObjectBlob = "yk_ybb.frx":000F
TabIndex = 10
Top = 1320
Width = 9345
End
End
Attribute VB_Name = "yk_ybb"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim m1 As String
Dim M2 As String
Dim mkind_code As String
Dim mkind_text As String
Private Sub drug_kind_Click()
If drug_kind.Text = "西 药" Then mkind_code = "A"
If drug_kind.Text = "中成药" Then mkind_code = "B"
If drug_kind.Text = "饮 片" Then mkind_code = "C"
If drug_kind.Text = "卫 材" Then mkind_code = "D"
If drug_kind.Text = " " Then mkind_code = "%"
End Sub
Private Sub print_com_Click()
biao.Refresh
If biao.Resultset.EOF And biao.Resultset.BOF Then
MsgBox "现在库里没有记录,请先输入日期,浏览之后再打印", , "注意"
print_COM.Enabled = False
Text1.SetFocus
Exit Sub
End If
biao.Resultset.MoveFirst
'Printer.PaperSize = 256
Printer.Height = 8000
Printer.Width = 30000
Printer.FontName = "宋体"
Printer.FontSize = 16
Printer.Print " " + yuanming
Printer.FontSize = 14
Printer.Print " 药库药品销售统计(" + mkind_text + ")"
Printer.FontSize = 9
Printer.Print " "
Printer.Print " 日期范围:" + m1 + " ---" + M2
biao.Resultset.MoveFirst
Printer.FontSize = 13.5
'打印之后将库存药品动态报表清空
Printer.Print "┌──────┬───────┐"
Printer.Print "│ 项 目 │ 批 发 额 │"
For i = 0 To 9
Printer.Print "├──────┼───────┤"
Printer.Print "│" + biao.Resultset!xm_name + "│" + biao.Resultset!price + "│"
biao.Resultset.MoveNext
Next
Printer.Print "└──────┴───────┘"
Printer.FontSize = 12
Printer.Print " 药库负责人:" + Space(10) + "审核:"
Printer.Print " "
Printer.Print " 药品会计:" + Space(8) + "财务科长:"
Printer.Print " "
Printer.Print " 打印日期:" + CStr(Date) + " " + CStr(Time)
Printer.EndDoc
MsgBox "打印结束", , "注意"
End Sub
Private Sub browse_Click()
Dim sss As String
If Not IsDate(yp_date1.Text) Then
MsgBox "起始日期错误", , "错误"
yp_date1.Text = Date
yp_date1.Text = DateAdd("m", -1, yp_date1.Text)
yp_date1.Text = DateAdd("d", 1, yp_date1.Text)
yp_date1.SetFocus
Exit Sub
End If
If Not IsDate(yp_date2.Text) Then
MsgBox "终止日期错误", , "错误"
yp_date2.Text = Date
yp_date2.SetFocus
Exit Sub
End If
If yp_date2 < yp_date1 Then
MsgBox "结束日期应晚于起始日期，请重输日期！", vbInformation, "提示"
yp_date1.Text = Date
yp_date1.Text = DateAdd("m", -1, yp_date1.Text)
yp_date2.Text = Date
yp_date1.Text = DateAdd("d", 1, yp_date1.Text)
yp_date1.SetFocus
Exit Sub
End If
If yp_date1.Text > "2099-12-31" Or yp_date1.Text < "2000-01-01" Then
MsgBox "输入年限超出范围", , "提示"
yp_date1.SetFocus
Exit Sub
End If
If yp_date2.Text > "2099-12-31" Or yp_date2.Text < "2000-01-01" Then
MsgBox "输入年限超出范围", , "提示"
yp_date2.SetFocus
Exit Sub
End If
mkind_text = drug_kind.Text
m1 = yp_date1.Text
M2 = yp_date2.Text
sss = "yk1_month'" + CStr(yp_date1.Text) + "','" + CStr(yp_date2.Text) + "','" + mkind_code + "'"
biao.SQL = sss
biao.Refresh
print_COM.Enabled = True
End Sub
Private Sub Form_Load()
yp_date1.Text = Date
yp_date1.Text = DateAdd("m", -1, yp_date1.Text)
yp_date2.Text = Date
yp_date2.Text = DateAdd("d", -1, yp_date2.Text)
Dim dbfstr As String
dbfstr = "ODBC;DATABASE=netba;UID=zc;PWD=1234"
biao.DataSourceName = "207his"
biao.Connect = dbfstr
drug_kind.AddItem "西 药"
drug_kind.AddItem "中成药"
drug_kind.AddItem "饮 片"
drug_kind.AddItem "卫 材"
drug_kind.AddItem " "
drug_kind.Text = " "
print_COM.Enabled = False
Screen.MousePointer = vbDefault
End Sub
Private Sub quit_Click()
Unload Me
Form3.Show
End Sub
Private Sub yp_date1_LostFocus()
If Not IsDate(yp_date1) Then
MsgBox "起始日期输入错误，请重输！", vbInformation, "提示"
yp_date1.Text = Date - 30
yp_date1.SetFocus
End If
End Sub
Private Sub yp_date2_LostFocus()
If Not IsDate(yp_date2) Then
MsgBox "结束日期输入错误，请重输！", vbInformation, "提示"
yp_date2.Text = Date - 30
yp_date2.SetFocus
End If
End Sub
Private Sub UpDown1_DownClick()
'日期下调一天
If IsDate(yp_date1.Text) Then
yp_date1.Text = CStr(CDate(yp_date1.Text) - 1)
End If
End Sub
Private Sub UpDown1_UpClick()
'日期上调一天
If IsDate(yp_date1.Text) Then
yp_date1.Text = CStr(CDate(yp_date1.Text) + 1)
End If
End Sub
Private Sub UpDown2_DownClick()
'日期下调一天
If IsDate(yp_date2.Text) Then
yp_date2.Text = CStr(CDate(yp_date2.Text) - 1)
End If
End Sub
Private Sub UpDown2_UpClick()
'日期上调一天
If IsDate(yp_date2.Text) Then
yp_date2.Text = CStr(CDate(yp_date2.Text) + 1)
End If
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -