📄 form_cjxt11.frm
字号:
Object.Tag = "Exit"
EndProperty
EndProperty
End
Begin MSComctlLib.Toolbar Toolbar1
Align = 1 'Align Top
Height = 420
Left = 0
TabIndex = 4
Top = 0
Width = 13680
_ExtentX = 24130
_ExtentY = 741
ButtonWidth = 1032
Appearance = 1
ImageList = "ImageList1"
_Version = 393216
BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628}
NumButtons = 1
BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628}
Key = "Exit"
Object.ToolTipText = "退出"
ImageIndex = 1
EndProperty
EndProperty
End
Begin VB.CommandButton Command_Next
Caption = "下一步"
Height = 585
Left = 9090
Picture = "Form_CJXT11.frx":04B6
Style = 1 'Graphical
TabIndex = 3
Top = 8640
Width = 1215
End
Begin VB.CommandButton Command_UP
Caption = "上一步"
Height = 585
Left = 2070
Picture = "Form_CJXT11.frx":063A
Style = 1 'Graphical
TabIndex = 2
Top = 8640
Width = 1215
End
Begin MSDataGridLib.DataGrid DataGrid_XZ
Bindings = "Form_CJXT11.frx":07BE
Height = 3885
Left = 30
TabIndex = 0
Top = 780
Width = 12675
_ExtentX = 22357
_ExtentY = 6853
_Version = 393216
AllowUpdate = -1 'True
HeadLines = 1
RowHeight = 23
FormatLocked = -1 'True
AllowAddNew = -1 'True
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 = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ColumnCount = 8
BeginProperty Column00
DataField = "ID"
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 = "score"
Caption = "分数"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column02
DataField = "difficult"
Caption = "难度系数"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column03
DataField = "content"
Caption = "题目"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column04
DataField = "optionA"
Caption = "选项A"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column05
DataField = "optionB"
Caption = "选项B"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column06
DataField = "optionC"
Caption = "选项C"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column07
DataField = "optionD"
Caption = "选项D"
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
BeginProperty Column00
WrapText = -1 'True
ColumnWidth = 1214.929
EndProperty
BeginProperty Column01
ColumnWidth = 524.976
EndProperty
BeginProperty Column02
ColumnWidth = 884.976
EndProperty
BeginProperty Column03
ColumnWidth = 3254.74
EndProperty
BeginProperty Column04
ColumnWidth = 1574.929
EndProperty
BeginProperty Column05
ColumnWidth = 1604.976
EndProperty
BeginProperty Column06
ColumnWidth = 1544.882
EndProperty
BeginProperty Column07
ColumnWidth = 1560.189
EndProperty
EndProperty
End
Begin VB.Label Label2
Caption = "所选题目的编号："
BeginProperty Font
Name = "楷体_GB2312"
Size = 10.5
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 990
TabIndex = 11
Top = 4740
Width = 1845
End
Begin VB.Label Label3
Caption = "要删除题目的编号："
BeginProperty Font
Name = "楷体_GB2312"
Size = 10.5
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 225
Left = 6480
TabIndex = 10
Top = 4740
Width = 2055
End
Begin VB.Label LabeL1
Caption = "所 有 单 选 题"
BeginProperty Font
Name = "楷体_GB2312"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 5400
TabIndex = 1
Top = 450
Width = 1845
End
End
Attribute VB_Name = "Form_CJXT11"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command_chongzhi_Click()
ret = MsgBox("是否要删除该题目!", 4 + 32 + 256 + 4096, "确定")
If ret = vbYes Then
Cmd.CommandType = adCmdText
Cmd.CommandText = "delete from shijuan where ID='" & Text2.Text & "'"
Cmd.Execute
ret = MsgBox("恭喜您，你已经成功删除该题目！")
Adodc_shijuan.Refresh
DataGrid_shijuan.Refresh
Else
Form_CJXT12.Show
End If
End Sub
Private Sub Command_queding_Click()
ret = MsgBox("是否要选择该题目!", 4 + 32 + 256 + 4096, "确定")
If ret = vbYes Then
Cmd.CommandType = adCmdText
Cmd.CommandText = "insert into shijuan(ID,score,difficult,content, opA, opB, opC, opD ) select ID,score,difficult,content,optionA,optionB,optionC,optionD from singlerselection where ID='" & Text1.Text & "'"
Cmd.Execute
ret = MsgBox("恭喜您，你已经成功选择该题目！")
Adodc_shijuan.Refresh
DataGrid_shijuan.Refresh
Else
Form_CJXT12.Show
End If
End Sub
Private Sub Command_Next_Click()
Form_CJXT12.Show
Form_CJXT11.Hide
End Sub
Private Sub Command_Up_Click()
Form_CJXT11.Hide
End Sub
Private Sub DataGrid_XZ_Click()
With DataGrid_XZ
If .Col = 0 And .Row >= 0 Then
Text1.Text = .Text
End If
End With
End Sub
Private Sub DataGrid_shijuan_Click()
With DataGrid_shijuan
If .Col = 0 And .Row >= 0 Then
Text2.Text = .Text
End If
End With
End Sub
Private Sub Form_Load()
Height = 9800
Width = 13000
Left = 2400
Top = 1200
End Sub
Private Sub Toolbar1_ButtonClick(ByVal Button As MSComctlLib.Button)
Select Case Button.Key
Case "Exit"
Unload Me
End Select
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -