?? 打印報表.frm
字號:
VERSION 5.00
Object = "{67397AA1-7FB1-11D0-B148-00A0C922E820}#6.0#0"; "MSADODC.OCX"
Object = "{CDE57A40-8B86-11D0-B3C6-00A0C90AEA82}#1.0#0"; "MSDATGRD.OCX"
Begin VB.Form Form19
Caption = "打印報表"
ClientHeight = 5730
ClientLeft = 1365
ClientTop = 1500
ClientWidth = 9525
LinkTopic = "Form19"
MDIChild = -1 'True
ScaleHeight = 5730
ScaleWidth = 9525
Begin VB.CommandButton Command1
Caption = "打印"
Height = 615
Left = 7680
TabIndex = 17
Top = 3960
Width = 1335
End
Begin VB.TextBox Text10
DataField = "應退款"
DataSource = "Adodc5"
Height = 375
Left = 8280
TabIndex = 16
Top = 5040
Visible = 0 'False
Width = 255
End
Begin VB.TextBox Text9
DataField = "票價"
DataSource = "Adodc5"
Height = 375
Left = 8040
TabIndex = 15
Top = 5040
Visible = 0 'False
Width = 255
End
Begin VB.TextBox Text8
DataField = "應退款"
DataSource = "Adodc4"
Height = 375
Left = 7560
TabIndex = 14
Top = 4800
Visible = 0 'False
Width = 255
End
Begin VB.TextBox Text7
DataField = "票價"
DataSource = "Adodc4"
Height = 375
Left = 7320
TabIndex = 13
Top = 4800
Visible = 0 'False
Width = 255
End
Begin MSAdodcLib.Adodc Adodc5
Height = 330
Left = 7320
Top = 5400
Visible = 0 'False
Width = 1200
_ExtentX = 2117
_ExtentY = 582
ConnectMode = 0
CursorLocation = 3
IsolationLevel = -1
ConnectionTimeout= 15
CommandTimeout = 30
CursorType = 3
LockType = 3
CommandType = 8
CursorOptions = 0
CacheSize = 50
MaxRecords = 0
BOFAction = 0
EOFAction = 0
ConnectStringType= 1
Appearance = 1
BackColor = -2147483643
ForeColor = -2147483640
Orientation = 0
Enabled = -1
Connect = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=車站售票管理系統;Data Source=sta30"
OLEDBString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=車站售票管理系統;Data Source=sta30"
OLEDBFile = ""
DataSourceName = ""
OtherAttributes = ""
UserName = ""
Password = ""
RecordSource = "select sum(票價) as 票價 ,sum(應退款) as 應退款 from 退票表 where datepart(month,退票時間)=datepart(month,getdate())"
Caption = "Adodc5"
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋體"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
_Version = 393216
End
Begin MSAdodcLib.Adodc Adodc4
Height = 330
Left = 5760
Top = 5400
Visible = 0 'False
Width = 1200
_ExtentX = 2117
_ExtentY = 582
ConnectMode = 0
CursorLocation = 3
IsolationLevel = -1
ConnectionTimeout= 15
CommandTimeout = 30
CursorType = 3
LockType = 3
CommandType = 8
CursorOptions = 0
CacheSize = 50
MaxRecords = 0
BOFAction = 0
EOFAction = 0
ConnectStringType= 1
Appearance = 1
BackColor = -2147483643
ForeColor = -2147483640
Orientation = 0
Enabled = -1
Connect = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=車站售票管理系統;Data Source=sta30"
OLEDBString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=車站售票管理系統;Data Source=sta30"
OLEDBFile = ""
DataSourceName = ""
OtherAttributes = ""
UserName = ""
Password = ""
RecordSource = "select sum(票價)as 票價, sum(應退款) as 應退款 from 退票表 where datepart(day,退票時間)=datepart(day,getdate())"
Caption = ""
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋體"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
_Version = 393216
End
Begin VB.TextBox Text6
Height = 495
Left = 5760
TabIndex = 12
Top = 4800
Width = 1215
End
Begin VB.TextBox Text5
Height = 495
Left = 2400
TabIndex = 10
Top = 4800
Width = 1095
End
Begin MSAdodcLib.Adodc Adodc3
Height = 375
Left = 600
Top = 5280
Visible = 0 'False
Width = 1200
_ExtentX = 2117
_ExtentY = 661
ConnectMode = 0
CursorLocation = 3
IsolationLevel = -1
ConnectionTimeout= 15
CommandTimeout = 30
CursorType = 3
LockType = 3
CommandType = 8
CursorOptions = 0
CacheSize = 50
MaxRecords = 0
BOFAction = 0
EOFAction = 0
ConnectStringType= 1
Appearance = 1
BackColor = -2147483643
ForeColor = -2147483640
Orientation = 0
Enabled = -1
Connect = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=車站售票管理系統;Data Source=sta30"
OLEDBString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=車站售票管理系統;Data Source=sta30"
OLEDBFile = ""
DataSourceName = ""
OtherAttributes = ""
UserName = ""
Password = ""
RecordSource = $"打印報表.frx":0000
Caption = "Adodc3"
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋體"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
_Version = 393216
End
Begin MSAdodcLib.Adodc Adodc2
Height = 375
Left = 3840
Top = 5400
Visible = 0 'False
Width = 1200
_ExtentX = 2117
_ExtentY = 661
ConnectMode = 0
CursorLocation = 3
IsolationLevel = -1
ConnectionTimeout= 15
CommandTimeout = 30
CursorType = 3
LockType = 3
CommandType = 8
CursorOptions = 0
CacheSize = 50
MaxRecords = 0
BOFAction = 0
EOFAction = 0
ConnectStringType= 1
Appearance = 1
BackColor = -2147483643
ForeColor = -2147483640
Orientation = 0
Enabled = -1
Connect = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=車站售票管理系統;Data Source=sta30"
OLEDBString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=車站售票管理系統;Data Source=sta30"
OLEDBFile = ""
DataSourceName = ""
OtherAttributes = ""
UserName = ""
Password = ""
RecordSource = $"打印報表.frx":008C
Caption = "Adodc2"
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋體"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
_Version = 393216
End
Begin VB.TextBox Text4
DataField = "總營業額"
DataSource = "Adodc3"
Height = 495
Left = 5760
Locked = -1 'True
TabIndex = 8
Top = 4320
Width = 1215
End
Begin VB.TextBox Text3
DataField = "營業額"
DataSource = "Adodc2"
Height = 495
Left = 2400
Locked = -1 'True
TabIndex = 6
Top = 4320
Width = 1095
End
Begin VB.TextBox Text2
DataField = "售票數"
DataSource = "Adodc3"
Height = 495
Left = 5760
Locked = -1 'True
TabIndex = 4
Top = 3720
Width = 1215
End
Begin VB.TextBox Text1
DataField = "售票數"
DataSource = "Adodc2"
Height = 495
Left = 2400
Locked = -1 'True
TabIndex = 2
Top = 3720
Width = 1095
End
Begin MSAdodcLib.Adodc Adodc1
Height = 375
Left = 2160
Top = 5400
Visible = 0 'False
Width = 1200
_ExtentX = 2117
_ExtentY = 661
ConnectMode = 0
CursorLocation = 3
IsolationLevel = -1
ConnectionTimeout= 15
CommandTimeout = 30
CursorType = 3
LockType = 3
CommandType = 8
CursorOptions = 0
CacheSize = 50
MaxRecords = 0
BOFAction = 0
EOFAction = 0
ConnectStringType= 1
Appearance = 1
BackColor = -2147483643
ForeColor = -2147483640
Orientation = 0
Enabled = -1
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -