📄 form1.vb
字号:
Public Class Form1
Inherits System.Windows.Forms.Form
#Region " Windows 窗体设计器生成的代码 "
Public Sub New()
MyBase.New()
'该调用是 Windows 窗体设计器所必需的。
InitializeComponent()
'在 InitializeComponent() 调用之后添加任何初始化
End Sub
'窗体重写处置以清理组件列表。
Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)
If disposing Then
If Not (components Is Nothing) Then
components.Dispose()
End If
End If
MyBase.Dispose(disposing)
End Sub
'Windows 窗体设计器所必需的
Private components As System.ComponentModel.IContainer
'注意:以下过程是 Windows 窗体设计器所必需的
'可以使用 Windows 窗体设计器修改此过程。
'不要使用代码编辑器修改它。
Friend WithEvents TabControl1 As System.Windows.Forms.TabControl
Friend WithEvents TabPage1 As System.Windows.Forms.TabPage
Friend WithEvents TabPage2 As System.Windows.Forms.TabPage
Friend WithEvents TabPage3 As System.Windows.Forms.TabPage
Friend WithEvents Button1 As System.Windows.Forms.Button
Friend WithEvents Button2 As System.Windows.Forms.Button
Friend WithEvents Button3 As System.Windows.Forms.Button
Friend WithEvents Button4 As System.Windows.Forms.Button
Friend WithEvents MainMenu1 As System.Windows.Forms.MainMenu
Friend WithEvents MenuItem1 As System.Windows.Forms.MenuItem
Friend WithEvents MenuItem2 As System.Windows.Forms.MenuItem
Friend WithEvents MenuItem3 As System.Windows.Forms.MenuItem
Friend WithEvents MenuItem4 As System.Windows.Forms.MenuItem
Friend WithEvents MenuItem5 As System.Windows.Forms.MenuItem
Friend WithEvents MenuItem6 As System.Windows.Forms.MenuItem
Friend WithEvents MenuItem7 As System.Windows.Forms.MenuItem
Friend WithEvents MenuItem8 As System.Windows.Forms.MenuItem
Friend WithEvents MenuItem9 As System.Windows.Forms.MenuItem
Friend WithEvents MenuItem10 As System.Windows.Forms.MenuItem
Friend WithEvents MenuItem11 As System.Windows.Forms.MenuItem
Friend WithEvents MenuItem12 As System.Windows.Forms.MenuItem
Friend WithEvents MenuItem13 As System.Windows.Forms.MenuItem
Friend WithEvents MenuItem14 As System.Windows.Forms.MenuItem
Friend WithEvents MenuItem15 As System.Windows.Forms.MenuItem
Friend WithEvents MenuItem16 As System.Windows.Forms.MenuItem
Friend WithEvents Button5 As System.Windows.Forms.Button
Friend WithEvents OleDbSelectCommand1 As System.Data.OleDb.OleDbCommand
Friend WithEvents OleDbInsertCommand1 As System.Data.OleDb.OleDbCommand
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
Me.TabControl1 = New System.Windows.Forms.TabControl()
Me.TabPage1 = New System.Windows.Forms.TabPage()
Me.Button2 = New System.Windows.Forms.Button()
Me.Button1 = New System.Windows.Forms.Button()
Me.TabPage2 = New System.Windows.Forms.TabPage()
Me.Button4 = New System.Windows.Forms.Button()
Me.Button3 = New System.Windows.Forms.Button()
Me.TabPage3 = New System.Windows.Forms.TabPage()
Me.Button5 = New System.Windows.Forms.Button()
Me.MainMenu1 = New System.Windows.Forms.MainMenu()
Me.MenuItem1 = New System.Windows.Forms.MenuItem()
Me.MenuItem13 = New System.Windows.Forms.MenuItem()
Me.MenuItem14 = New System.Windows.Forms.MenuItem()
Me.MenuItem16 = New System.Windows.Forms.MenuItem()
Me.MenuItem15 = New System.Windows.Forms.MenuItem()
Me.MenuItem2 = New System.Windows.Forms.MenuItem()
Me.MenuItem7 = New System.Windows.Forms.MenuItem()
Me.MenuItem9 = New System.Windows.Forms.MenuItem()
Me.MenuItem10 = New System.Windows.Forms.MenuItem()
Me.MenuItem8 = New System.Windows.Forms.MenuItem()
Me.MenuItem11 = New System.Windows.Forms.MenuItem()
Me.MenuItem12 = New System.Windows.Forms.MenuItem()
Me.MenuItem3 = New System.Windows.Forms.MenuItem()
Me.MenuItem6 = New System.Windows.Forms.MenuItem()
Me.MenuItem4 = New System.Windows.Forms.MenuItem()
Me.MenuItem5 = New System.Windows.Forms.MenuItem()
Me.OleDbSelectCommand1 = New System.Data.OleDb.OleDbCommand()
Me.OleDbInsertCommand1 = New System.Data.OleDb.OleDbCommand()
Me.TabControl1.SuspendLayout()
Me.TabPage1.SuspendLayout()
Me.TabPage2.SuspendLayout()
Me.TabPage3.SuspendLayout()
Me.SuspendLayout()
'
'TabControl1
'
Me.TabControl1.Controls.AddRange(New System.Windows.Forms.Control() {Me.TabPage1, Me.TabPage2, Me.TabPage3})
Me.TabControl1.Name = "TabControl1"
Me.TabControl1.SelectedIndex = 0
Me.TabControl1.Size = New System.Drawing.Size(408, 64)
Me.TabControl1.TabIndex = 0
'
'TabPage1
'
Me.TabPage1.Controls.AddRange(New System.Windows.Forms.Control() {Me.Button2, Me.Button1})
Me.TabPage1.Location = New System.Drawing.Point(4, 22)
Me.TabPage1.Name = "TabPage1"
Me.TabPage1.Size = New System.Drawing.Size(400, 38)
Me.TabPage1.TabIndex = 0
Me.TabPage1.Text = "收入"
'
'Button2
'
Me.Button2.FlatStyle = System.Windows.Forms.FlatStyle.Flat
Me.Button2.Location = New System.Drawing.Point(96, 0)
Me.Button2.Name = "Button2"
Me.Button2.Size = New System.Drawing.Size(80, 32)
Me.Button2.TabIndex = 1
Me.Button2.Text = "收入记录"
'
'Button1
'
Me.Button1.FlatStyle = System.Windows.Forms.FlatStyle.Flat
Me.Button1.Name = "Button1"
Me.Button1.Size = New System.Drawing.Size(80, 32)
Me.Button1.TabIndex = 0
Me.Button1.Text = "收入项目"
'
'TabPage2
'
Me.TabPage2.Controls.AddRange(New System.Windows.Forms.Control() {Me.Button4, Me.Button3})
Me.TabPage2.Location = New System.Drawing.Point(4, 22)
Me.TabPage2.Name = "TabPage2"
Me.TabPage2.Size = New System.Drawing.Size(400, 38)
Me.TabPage2.TabIndex = 1
Me.TabPage2.Text = "支出"
'
'Button4
'
Me.Button4.FlatStyle = System.Windows.Forms.FlatStyle.Flat
Me.Button4.Name = "Button4"
Me.Button4.Size = New System.Drawing.Size(80, 32)
Me.Button4.TabIndex = 2
Me.Button4.Text = "支出项目"
'
'Button3
'
Me.Button3.FlatStyle = System.Windows.Forms.FlatStyle.Flat
Me.Button3.Location = New System.Drawing.Point(96, 0)
Me.Button3.Name = "Button3"
Me.Button3.Size = New System.Drawing.Size(80, 32)
Me.Button3.TabIndex = 1
Me.Button3.Text = "支出记录"
'
'TabPage3
'
Me.TabPage3.Controls.AddRange(New System.Windows.Forms.Control() {Me.Button5})
Me.TabPage3.Location = New System.Drawing.Point(4, 22)
Me.TabPage3.Name = "TabPage3"
Me.TabPage3.Size = New System.Drawing.Size(400, 38)
Me.TabPage3.TabIndex = 2
Me.TabPage3.Text = "财务分析"
'
'Button5
'
Me.Button5.FlatStyle = System.Windows.Forms.FlatStyle.Flat
Me.Button5.Name = "Button5"
Me.Button5.Size = New System.Drawing.Size(80, 32)
Me.Button5.TabIndex = 3
Me.Button5.Text = "财务状况"
'
'MainMenu1
'
Me.MainMenu1.MenuItems.AddRange(New System.Windows.Forms.MenuItem() {Me.MenuItem1, Me.MenuItem2, Me.MenuItem3, Me.MenuItem4})
'
'MenuItem1
'
Me.MenuItem1.Index = 0
Me.MenuItem1.MenuItems.AddRange(New System.Windows.Forms.MenuItem() {Me.MenuItem13, Me.MenuItem14, Me.MenuItem16, Me.MenuItem15})
Me.MenuItem1.Text = "系统"
'
'MenuItem13
'
Me.MenuItem13.Index = 0
Me.MenuItem13.Text = "用户登陆"
'
'MenuItem14
'
Me.MenuItem14.Index = 1
Me.MenuItem14.Text = "修改密码"
'
'MenuItem16
'
Me.MenuItem16.Index = 2
Me.MenuItem16.Text = "-"
'
'MenuItem15
'
Me.MenuItem15.Index = 3
Me.MenuItem15.Text = "退出系统"
'
'MenuItem2
'
Me.MenuItem2.Index = 1
Me.MenuItem2.MenuItems.AddRange(New System.Windows.Forms.MenuItem() {Me.MenuItem7, Me.MenuItem8})
Me.MenuItem2.Text = "收入支出"
'
'MenuItem7
'
Me.MenuItem7.Index = 0
Me.MenuItem7.MenuItems.AddRange(New System.Windows.Forms.MenuItem() {Me.MenuItem9, Me.MenuItem10})
Me.MenuItem7.Text = "收入"
'
'MenuItem9
'
Me.MenuItem9.Index = 0
Me.MenuItem9.Text = "收入项目"
'
'MenuItem10
'
Me.MenuItem10.Index = 1
Me.MenuItem10.Text = "收入记录"
'
'MenuItem8
'
Me.MenuItem8.Index = 1
Me.MenuItem8.MenuItems.AddRange(New System.Windows.Forms.MenuItem() {Me.MenuItem11, Me.MenuItem12})
Me.MenuItem8.Text = "支出"
'
'MenuItem11
'
Me.MenuItem11.Index = 0
Me.MenuItem11.Text = "支出项目"
'
'MenuItem12
'
Me.MenuItem12.Index = 1
Me.MenuItem12.Text = "支出记录"
'
'MenuItem3
'
Me.MenuItem3.Index = 2
Me.MenuItem3.MenuItems.AddRange(New System.Windows.Forms.MenuItem() {Me.MenuItem6})
Me.MenuItem3.Text = "财务分析"
'
'MenuItem6
'
Me.MenuItem6.Index = 0
Me.MenuItem6.Text = "财务状况"
'
'MenuItem4
'
Me.MenuItem4.Index = 3
Me.MenuItem4.MenuItems.AddRange(New System.Windows.Forms.MenuItem() {Me.MenuItem5})
Me.MenuItem4.Text = "帮助"
'
'MenuItem5
'
Me.MenuItem5.Index = 0
Me.MenuItem5.Text = "关于"
'
'OleDbSelectCommand1
'
Me.OleDbSelectCommand1.CommandText = "SELECT Name, PPM FROM Income"
'
'OleDbInsertCommand1
'
Me.OleDbInsertCommand1.CommandText = "INSERT INTO Income(Name, PPM) VALUES (?, ?)"
Me.OleDbInsertCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Name", System.Data.OleDb.OleDbType.VarWChar, 15, "Name"))
Me.OleDbInsertCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("PPM", System.Data.OleDb.OleDbType.VarWChar, 10, "PPM"))
'
'Form1
'
Me.AutoScaleBaseSize = New System.Drawing.Size(5, 13)
Me.ClientSize = New System.Drawing.Size(248, 57)
Me.Controls.AddRange(New System.Windows.Forms.Control() {Me.TabControl1})
Me.Menu = Me.MainMenu1
Me.Name = "Form1"
Me.Text = "家庭财务管理系统"
Me.TabControl1.ResumeLayout(False)
Me.TabPage1.ResumeLayout(False)
Me.TabPage2.ResumeLayout(False)
Me.TabPage3.ResumeLayout(False)
Me.ResumeLayout(False)
End Sub
#End Region
'响应菜单中的About
Private Sub MenuItem5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem5.Click
'继承Form2,定义变量form2
Dim form2 As New Form2()
'显示Form2,功能是About对话框
form2.ShowDialog()
End Sub
'响应菜单中的退出
Private Sub MenuItem15_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem15.Click
'退出程序
Me.Close()
End Sub
'响应按钮的收入项目
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
'继承Form3,定义变量form3
Dim form3 As New Form3()
'显示Form3,功能是收入项目对话框
form3.ShowDialog()
End Sub
'响应按钮的收入记录
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
'继承Form4,定义变量form4
Dim form4 As New Form4()
'显示Form4,功能是收入记录对话框
form4.ShowDialog()
End Sub
'响应按钮的支出项目
Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
'继承Form5,定义变量form5
Dim form5 As New Form5()
'显示Form5,功能是支出项目对话框
form5.ShowDialog()
End Sub
'响应按钮的支出记录
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
'继承Form6,定义变量form6
Dim form6 As New Form6()
'显示Form6,功能是支出记录对话框
form6.ShowDialog()
End Sub
'响应菜单中的收入项目
Private Sub MenuItem9_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem9.Click
'继承Form3,定义变量form3
Dim form3 As New Form3()
'显示Form3,功能是收入项目对话框
form3.ShowDialog()
End Sub
'响应菜单中的收入记录
Private Sub MenuItem10_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem10.Click
'继承Form4,定义变量form4
Dim form4 As New Form4()
'显示Form4,功能是收入记录对话框
form4.ShowDialog()
End Sub
'响应菜单中的支出项目
Private Sub MenuItem11_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem11.Click
'继承Form5,定义变量form5
Dim form5 As New Form5()
'显示Form5,功能是支出项目对话框
form5.ShowDialog()
End Sub
'响应菜单中的支出记录
Private Sub MenuItem12_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem12.Click
'继承Form6,定义变量form6
Dim form6 As New Form6()
'显示Form6,功能是支出记录对话框
form6.ShowDialog()
End Sub
'响应按钮的财务状况
Private Sub Button5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button5.Click
'继承Form7,定义变量form7
Dim form7 As New Form7()
'显示Form7,功能是财务状况对话框
form7.ShowDialog()
End Sub
'响应菜单中的财务状况
Private Sub MenuItem6_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem6.Click
'继承Form7,定义变量form7
Dim form7 As New Form7()
'显示Form7,功能是财务状况对话框
form7.ShowDialog()
End Sub
End Class
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -