📄 falmsum.frm
字号:
Begin MSComctlLib.ImageList ImageList1
Left = 0
Top = 3120
_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 = "falmsum.frx":001F
Key = ""
EndProperty
BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "falmsum.frx":007D
Key = ""
EndProperty
BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "falmsum.frx":00DB
Key = ""
EndProperty
BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "falmsum.frx":0139
Key = ""
EndProperty
EndProperty
End
Begin MSAdodcLib.Adodc Adodc2
Height = 372
Left = 3960
Top = 4680
Width = 1932
_ExtentX = 3413
_ExtentY = 661
ConnectMode = 0
CursorLocation = 3
IsolationLevel = -1
ConnectionTimeout= 15
CommandTimeout = 30
CursorType = 3
LockType = 3
CommandType = 1
CursorOptions = 0
CacheSize = 50
MaxRecords = 0
BOFAction = 0
EOFAction = 0
ConnectStringType= 1
Appearance = 1
BackColor = -2147483643
ForeColor = -2147483640
Orientation = 0
Enabled = -1
Connect = ""
OLEDBString = ""
OLEDBFile = ""
DataSourceName = ""
OtherAttributes = ""
UserName = ""
Password = ""
RecordSource = "select sum(出售数量)as 出售总数量,sum(销售总价)as 总金额 from 影碟销售表 "
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 MSAdodcLib.Adodc Adodc1
Height = 372
Left = 5520
Top = 3840
Visible = 0 'False
Width = 1692
_ExtentX = 2990
_ExtentY = 661
ConnectMode = 0
CursorLocation = 3
IsolationLevel = -1
ConnectionTimeout= 15
CommandTimeout = 30
CursorType = 3
LockType = 3
CommandType = 1
CursorOptions = 0
CacheSize = 50
MaxRecords = 0
BOFAction = 0
EOFAction = 0
ConnectStringType= 1
Appearance = 1
BackColor = -2147483643
ForeColor = -2147483640
Orientation = 0
Enabled = -1
Connect = ""
OLEDBString = ""
OLEDBFile = ""
DataSourceName = ""
OtherAttributes = ""
UserName = ""
Password = ""
RecordSource = "select 盘号,影碟名,sum(出售数量) as 销售总量,sum(销售总价) as 总金额 from 影碟销售表 group by 盘号,影碟名"
Caption = "Adodc1"
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 MSComctlLib.Toolbar Toolbar1
Align = 1 'Align Top
Height = 420
Left = 0
TabIndex = 12
Top = 0
Width = 9885
_ExtentX = 17436
_ExtentY = 741
ButtonWidth = 1138
ButtonHeight = 582
Appearance = 1
TextAlignment = 1
ImageList = "ImageList1"
HotImageList = "ImageList1"
_Version = 393216
BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628}
NumButtons = 4
BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628}
Key = "exit"
Object.ToolTipText = "返回"
ImageIndex = 1
EndProperty
BeginProperty Button2 {66833FEA-8583-11D1-B16A-00C0F0283628}
Key = "datacopy"
Object.ToolTipText = "数据备份"
ImageIndex = 2
EndProperty
BeginProperty Button3 {66833FEA-8583-11D1-B16A-00C0F0283628}
Key = "datareturn"
Object.ToolTipText = "数据还原"
ImageIndex = 3
EndProperty
BeginProperty Button4 {66833FEA-8583-11D1-B16A-00C0F0283628}
Key = "print"
Object.ToolTipText = "打印"
ImageIndex = 4
EndProperty
EndProperty
BorderStyle = 1
Begin MSComCtl2.DTPicker DTPicker1
Height = 372
Left = 7440
TabIndex = 13
Top = 0
Width = 2292
_ExtentX = 4048
_ExtentY = 661
_Version = 393216
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "楷体_GB2312"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Format = 24510464
CurrentDate = 36679
End
End
Begin VB.Label Label1
Caption = "当日销售情况统计信息"
BeginProperty Font
Name = "楷体_GB2312"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 372
Left = 120
TabIndex = 11
Top = 480
Width = 2532
End
End
Attribute VB_Name = "falmsum1"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command2_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
MDIForm1.StatusBar1.Panels(1) = "当日影碟销售数据备份"
End Sub
Private Sub Command3_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
MDIForm1.StatusBar1.Panels(1) = "当日影碟销售数据还原"
End Sub
Private Sub Command4_Click()
MDIForm1.StatusBar1.Panels(1) = "打印当日销售的影碟数据"
falmsumprint.Show
End Sub
Private Sub Command4_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
MDIForm1.StatusBar1.Panels(1) = "打印当日销售的影碟数据"
End Sub
Private Sub DataGrid1_Click()
MDIForm1.StatusBar1.Panels(1) = "选定一条销售记录"
End Sub
Private Sub DataGrid1_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
MDIForm1.StatusBar1.Panels(1) = "影碟销售情况统计"
End Sub
Private Sub Form_GotFocus()
MDIForm1.Combo1.Text = "[影碟销售统计]"
DTPicker1.Value = Date
Adodc1.CommandType = adCmdText
Adodc1.RecordSource = "select 盘号,影碟名,sum(出售数量) as 销售总量,sum(销售总价) as 总金额 from 影碟销售表 group by 盘号,影碟名"
Adodc1.Refresh
Adodc2.CommandType = adCmdText
Adodc2.RecordSource = "select sum(出售数量)as 出售总数量,sum(销售总价)as 总金额 from 影碟销售表 "
Adodc2.Refresh
End Sub
Private Sub Form_Load()
MDIForm1.Combo1.Text = "[影碟销售统计]"
DTPicker1.Value = Date
Adodc1.CommandType = adCmdText
Adodc1.RecordSource = "select 盘号,影碟名,sum(出售数量) as 销售总量,sum(销售总价) as 总金额 from 影碟销售表 group by 盘号,影碟名"
Adodc1.Refresh
Adodc2.CommandType = adCmdText
Adodc2.RecordSource = "select sum(出售数量)as 出售总数量,sum(销售总价)as 总金额 from 影碟销售表 "
Adodc2.Refresh
End Sub
Private Sub Form_LostFocus()
Unload Me
End Sub
Private Sub Form_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
MDIForm1.StatusBar1.Panels(1) = ""
End Sub
Private Sub Text1_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
MDIForm1.StatusBar1.Panels(1) = "当日影碟总销量"
End Sub
Private Sub Text2_GotFocus()
MDIForm1.StatusBar1.Panels(1) = "查找当日所销售的一张歌碟"
End Sub
Private Sub Text2_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then
Adodc1.Recordset.Find "影碟名='" & Text2.Text & "'"
End If
If Adodc1.Recordset.EOF = True Then
MDIForm1.StatusBar1.Panels(1) = "本日没有销售此影碟"
MsgBox "本日没有销售此影碟", 64, "未发现"
End If
End Sub
Private Sub Text2_LostFocus()
Adodc1.Recordset.Find "影碟名='" & Text2.Text & "'"
If Adodc1.Recordset.EOF = True Then
MDIForm1.StatusBar1.Panels(1) = "本日没有销售此影碟"
MsgBox "本日没有销售此影碟", 64, "未发现"
End If
Text2.Text = ""
End Sub
Private Sub Text2_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
MDIForm1.StatusBar1.Panels(1) = "查找当日所销售的一张歌碟"
End Sub
Private Sub Text3_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
MDIForm1.StatusBar1.Panels(1) = "当日影碟总销售额"
End Sub
Private Sub Toolbar1_ButtonClick(ByVal Button As MSComctlLib.Button)
Select Case Button.Index
Case 1:
falmsum1.Hide
MDIForm1.StatusBar1.Panels(1) = "影碟销售"
formpayout.Show
formpayout.Combo1.Text = "影碟销售"
Set falmsum = Nothing
End Select
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -