📄 frmsys_vote.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"
Object = "{65E121D4-0C60-11D2-A9FC-0000F8754DA1}#2.0#0"; "mschrt20.ocx"
Begin VB.Form frmSys_vote
Caption = "活动投票管理"
ClientHeight = 4455
ClientLeft = 60
ClientTop = 345
ClientWidth = 8580
LinkTopic = "Form1"
LockControls = -1 'True
MaxButton = 0 'False
ScaleHeight = 4455
ScaleWidth = 8580
StartUpPosition = 3 '窗口缺省
Begin VB.Frame Frame3
Height = 4095
Left = 45
TabIndex = 0
Top = 240
Width = 8475
Begin MSAdodcLib.Adodc adoVote
Height = 330
Left = 5055
Top = 1890
Visible = 0 'False
Width = 2025
_ExtentX = 3572
_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 = ""
OLEDBString = ""
OLEDBFile = ""
DataSourceName = ""
OtherAttributes = ""
UserName = ""
Password = ""
RecordSource = ""
Caption = "adoVote"
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.CommandButton cmdChar
Caption = "显示图表"
Height = 330
Left = 6870
TabIndex = 10
Top = 210
Width = 1350
End
Begin MSChart20Lib.MSChart MSChart1
Height = 3060
Left = 45
OleObjectBlob = "frmSys_vote.frx":0000
TabIndex = 9
Top = 960
Visible = 0 'False
Width = 8340
End
Begin VB.CommandButton cmdClear
Caption = "清除投票记录"
Height = 330
Left = 5535
TabIndex = 1
Top = 210
Width = 1350
End
Begin VB.TextBox txtVoteMemo
Height = 300
Left = 1080
TabIndex = 4
Top = 570
Width = 7215
End
Begin VB.CommandButton cmdVoteDel
Caption = "删除"
Height = 330
Left = 4590
TabIndex = 3
Top = 210
Width = 960
End
Begin VB.TextBox txtVote
Height = 285
Left = 1080
TabIndex = 2
Top = 240
Width = 2325
End
Begin MSDataGridLib.DataGrid DataGrid2
Height = 3030
Left = 75
TabIndex = 5
Top = 945
Width = 8310
_ExtentX = 14658
_ExtentY = 5345
_Version = 393216
AllowUpdate = 0 'False
HeadLines = 1
RowHeight = 15
BeginProperty HeadFont {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ColumnCount = 2
BeginProperty Column00
DataField = ""
Caption = ""
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column01
DataField = ""
Caption = ""
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
SplitCount = 1
BeginProperty Split0
MarqueeStyle = 4
BeginProperty Column00
EndProperty
BeginProperty Column01
EndProperty
EndProperty
End
Begin VB.CommandButton cmdVoteAdd
Caption = "添加"
Height = 330
Left = 3645
TabIndex = 6
Top = 210
Width = 960
End
Begin VB.Label Label19
AutoSize = -1 'True
Caption = "活动描述："
Height = 180
Left = 150
TabIndex = 8
Top = 600
Width = 900
End
Begin VB.Label Label18
AutoSize = -1 'True
Caption = "活动名称："
Height = 180
Left = 150
TabIndex = 7
Top = 300
Width = 900
End
End
End
Attribute VB_Name = "frmSys_vote"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub cmdChar_Click()
If cmdChar.Caption = "显示图表" Then
cmdChar.Caption = "显示列表"
MSChart1.Visible = True
DataGrid2.Visible = False
adoVote.RecordSource = "select vote_subject as 活动名称,vote_qty as 投票数量 from tbOA_vote"
adoVote.Refresh
Set MSChart1.DataSource = adoVote
ElseIf cmdChar.Caption = "显示列表" Then
cmdChar.Caption = "显示图表"
MSChart1.Visible = False
DataGrid2.Visible = True
adoVote.RecordSource = "select * from tbOA_vote order by vote_qty desc"
adoVote.Refresh
DataGrid2.Columns(0).Caption = "序号"
DataGrid2.Columns(1).Caption = "活动名称"
DataGrid2.Columns(2).Caption = "活动描述"
DataGrid2.Columns(3).Caption = "活动票数"
End If
End Sub
Private Sub cmdVoteAdd_Click()
adoVote.RecordSource = "select * from tbOA_vote order by vote_qty desc"
adoVote.Refresh
If txtVote.Text = "" Then MsgBox "活动名称不能为空！", vbInformation: txtVote.SetFocus: Exit Sub
adoVote.Recordset.AddNew
adoVote.Recordset.Fields(1).Value = txtVote.Text
adoVote.Recordset.Fields(2).Value = txtVoteMemo.Text
adoVote.Recordset.Update
DataGrid2.Columns(0).Caption = "序号"
DataGrid2.Columns(1).Caption = "活动名称"
DataGrid2.Columns(2).Caption = "活动描述"
DataGrid2.Columns(3).Caption = "活动票数"
MsgBox "添加成功", vbInformation
End Sub
Private Sub cmdVoteDel_Click()
On Error Resume Next
adoVote.Recordset.Delete
DataGrid2.Columns(0).Caption = "序号"
DataGrid2.Columns(1).Caption = "活动名称"
DataGrid2.Columns(2).Caption = "活动描述"
DataGrid2.Columns(3).Caption = "活动票数"
End Sub
Private Sub cmdClear_Click()
adoVote.RecordSource = "select * from tbOA_vote"
adoVote.Refresh
If adoVote.Recordset.RecordCount > 0 Then
For i = 0 To adoVote.Recordset.RecordCount - 1
adoVote.Recordset.Fields(3).Value = 0
adoVote.Recordset.MoveNext
Next i
End If
Dim con As ADODB.Connection
Dim rs As ADODB.Recordset
Set con = New ADODB.Connection
con.ConnectionString = PublicStr
con.Open
Set rs = New ADODB.Recordset
Set rs = con.Execute("DELETE FROM tbOA_voteRecord")
con.Close
DataGrid2.Columns(0).Caption = "序号"
DataGrid2.Columns(1).Caption = "活动名称"
DataGrid2.Columns(2).Caption = "活动描述"
DataGrid2.Columns(3).Caption = "活动票数"
MsgBox "数据清除成功！", vbInformation
End Sub
Private Sub Form_Load()
'///投票活动设置
adoVote.ConnectionString = PublicStr
adoVote.RecordSource = "select * from tbOA_vote order by vote_qty desc"
adoVote.Refresh
Set DataGrid2.DataSource = adoVote
DataGrid2.Columns(0).Caption = "序号"
DataGrid2.Columns(1).Caption = "活动名称"
DataGrid2.Columns(2).Caption = "活动描述"
DataGrid2.Columns(3).Caption = "活动票数"
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -