Form5.frm
资源名称:2005.rar [点击查看]
上传用户:salesll
上传日期:2014-07-25
资源大小:2665k
文件大小:5k
源码类别:
交通/航空行业
开发平台:
Others
- VERSION 5.00
- Begin VB.Form Form5
- BackColor = &H00FF80FF&
- Caption = "车辆运营添加"
- ClientHeight = 3645
- ClientLeft = 60
- ClientTop = 420
- ClientWidth = 7215
- LinkTopic = "Form5"
- ScaleHeight = 3645
- ScaleWidth = 7215
- StartUpPosition = 3 '窗口缺省
- Begin VB.TextBox Text5
- Height = 495
- Left = 1320
- TabIndex = 11
- Top = 2160
- Width = 5655
- End
- Begin VB.CommandButton Command2
- Caption = "取消"
- Height = 495
- Left = 4680
- TabIndex = 9
- Top = 2880
- Width = 1215
- End
- Begin VB.CommandButton Command1
- BackColor = &H00FFFFFF&
- Caption = "添加"
- Height = 495
- Left = 720
- TabIndex = 8
- Top = 2880
- Width = 1215
- End
- Begin VB.TextBox Text4
- Height = 495
- Left = 4560
- TabIndex = 7
- Top = 1320
- Width = 2415
- End
- Begin VB.TextBox Text3
- Height = 495
- Left = 4560
- TabIndex = 6
- Top = 360
- Width = 2415
- End
- Begin VB.TextBox Text2
- Height = 495
- Left = 1320
- TabIndex = 5
- Top = 1320
- Width = 2055
- End
- Begin VB.TextBox Text1
- Height = 495
- Left = 1320
- TabIndex = 4
- Top = 360
- Width = 2055
- End
- Begin VB.Label Label5
- BackColor = &H00FF80FF&
- Caption = "使用单位:"
- BeginProperty Font
- Name = "宋体"
- Size = 12
- Charset = 134
- Weight = 400
- Underline = 0 'False
- Italic = 0 'False
- Strikethrough = 0 'False
- EndProperty
- Height = 495
- Left = 120
- TabIndex = 10
- Top = 2160
- Width = 1215
- End
- Begin VB.Label Label4
- BackColor = &H00FF80FF&
- Caption = "运营收入:"
- BeginProperty Font
- Name = "宋体"
- Size = 12
- Charset = 134
- Weight = 400
- Underline = 0 'False
- Italic = 0 'False
- Strikethrough = 0 'False
- EndProperty
- Height = 495
- Left = 3480
- TabIndex = 3
- Top = 1440
- Width = 1215
- End
- Begin VB.Label Label3
- BackColor = &H00FF80FF&
- Caption = "运营时间:"
- BeginProperty Font
- Name = "宋体"
- Size = 12
- Charset = 134
- Weight = 400
- Underline = 0 'False
- Italic = 0 'False
- Strikethrough = 0 'False
- EndProperty
- Height = 495
- Left = 3480
- TabIndex = 2
- Top = 480
- Width = 1215
- End
- Begin VB.Label Label2
- BackColor = &H00FF80FF&
- Caption = "运营日期:"
- BeginProperty Font
- Name = "宋体"
- Size = 12
- Charset = 134
- Weight = 400
- Underline = 0 'False
- Italic = 0 'False
- Strikethrough = 0 'False
- EndProperty
- Height = 495
- Left = 120
- TabIndex = 1
- Top = 1440
- Width = 1215
- End
- Begin VB.Label Label1
- BackColor = &H00FF80FF&
- Caption = "车牌号码:"
- BeginProperty Font
- Name = "宋体"
- Size = 12
- Charset = 134
- Weight = 400
- Underline = 0 'False
- Italic = 0 'False
- Strikethrough = 0 'False
- EndProperty
- Height = 495
- Left = 120
- TabIndex = 0
- Top = 480
- Width = 1215
- End
- End
- Attribute VB_Name = "Form5"
- Attribute VB_GlobalNameSpace = False
- Attribute VB_Creatable = False
- Attribute VB_PredeclaredId = True
- Attribute VB_Exposed = False
- Private Sub Command1_Click()
- Dim rs As ADODB.Command
- Dim str As String
- Set rs = New ADODB.Command
- Call open_db
- str = "update 车辆档案 set 运营日期='" & Text2 & "',运营时间='" & Text3 & "',运营收入='" & Text4 & "',使用单位或人='" & Text5 & "' where 车牌号码= '" & Text1 & "'"
- Set rs.ActiveConnection = adocon
- rs.CommandText = str
- rs.Execute
- Set rs = Nothing
- adocon.Close
- Set adocon = Nothing
- Call close_db
- MsgBox "添加成功!", , vbOKOnly
- End Sub
- Private Sub Command2_Click()
- Unload Me
- End Sub