📄 qjgl.frm
字号:
VERSION 5.00
Begin VB.Form Form11
BorderStyle = 3 'Fixed Dialog
Caption = "请假管理"
ClientHeight = 3255
ClientLeft = 45
ClientTop = 435
ClientWidth = 5175
LinkTopic = "Form11"
MaxButton = 0 'False
MDIChild = -1 'True
MinButton = 0 'False
ScaleHeight = 3255
ScaleWidth = 5175
ShowInTaskbar = 0 'False
Begin VB.TextBox Text8
BeginProperty Font
Name = "楷体_GB2312"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 1080
TabIndex = 1
Top = 2750
Width = 1300
End
Begin VB.CommandButton Command2
Cancel = -1 'True
Caption = "不批准"
BeginProperty Font
Name = "楷体_GB2312"
Size = 10.5
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 450
Left = 3960
TabIndex = 3
Top = 2700
Width = 1000
End
Begin VB.CommandButton Command1
Caption = "批 准"
Default = -1 'True
BeginProperty Font
Name = "楷体_GB2312"
Size = 10.5
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 450
Left = 2640
TabIndex = 2
Top = 2700
Width = 1000
End
Begin VB.Frame Frame1
Height = 2175
Left = 120
TabIndex = 5
Top = 460
Width = 4935
Begin VB.TextBox Text6
Enabled = 0 'False
BeginProperty Font
Name = "楷体_GB2312"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 360
Left = 4200
TabIndex = 17
Top = 960
Width = 600
End
Begin VB.TextBox Text5
Enabled = 0 'False
BeginProperty Font
Name = "楷体_GB2312"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 360
Left = 4200
TabIndex = 16
Top = 330
Width = 600
End
Begin VB.TextBox Text4
Enabled = 0 'False
BeginProperty Font
Name = "楷体_GB2312"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 360
Left = 1320
TabIndex = 15
Top = 1680
Width = 3495
End
Begin VB.TextBox Text3
Enabled = 0 'False
BeginProperty Font
Name = "楷体_GB2312"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 360
Left = 1320
TabIndex = 14
Top = 1200
Width = 1300
End
Begin VB.TextBox Text2
Enabled = 0 'False
BeginProperty Font
Name = "楷体_GB2312"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 360
Left = 1320
TabIndex = 13
Top = 705
Width = 1300
End
Begin VB.TextBox Text1
Enabled = 0 'False
BeginProperty Font
Name = "楷体_GB2312"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 360
Left = 1320
TabIndex = 12
Top = 210
Width = 1300
End
Begin VB.Label Label8
Caption = "请假事由："
BeginProperty Font
Name = "楷体_GB2312"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 120
TabIndex = 11
Top = 1733
Width = 1305
End
Begin VB.Label Label7
Caption = "请假类型："
BeginProperty Font
Name = "楷体_GB2312"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 3000
TabIndex = 10
Top = 390
Width = 1305
End
Begin VB.Label Label5
Caption = "结束日期："
BeginProperty Font
Name = "楷体_GB2312"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 120
TabIndex = 9
Top = 1253
Width = 1305
End
Begin VB.Label Label4
Caption = "班 次："
BeginProperty Font
Name = "楷体_GB2312"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 3000
TabIndex = 8
Top = 1005
Width = 1305
End
Begin VB.Label Label3
Caption = "起始日期："
BeginProperty Font
Name = "楷体_GB2312"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 120
TabIndex = 7
Top = 758
Width = 1305
End
Begin VB.Label Label2
Caption = "姓 名："
BeginProperty Font
Name = "楷体_GB2312"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 120
TabIndex = 6
Top = 263
Width = 1305
End
End
Begin VB.ComboBox Combo1
Height = 300
Left = 2880
Style = 2 'Dropdown List
TabIndex = 0
Top = 100
Width = 1215
End
Begin VB.Label Label9
Caption = "批准人："
BeginProperty Font
Name = "楷体_GB2312"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 120
TabIndex = 18
Top = 2810
Width = 1050
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 = 960
TabIndex = 4
Top = 123
Width = 2040
End
End
Attribute VB_Name = "Form11"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Combo1_Click()
rst.Open "select * from koulingbiao where 工号=" & Val(Combo1.Text) & "", con
Text1.Text = rst!姓名
rst.Close
rst.Open "select * from qingjiabiao where 工号=" & Val(Combo1.Text) & "", con
Text2.Text = rst!开始日期
Text3.Text = rst!结束日期
Text4.Text = rst!事由
Text5.Text = rst!请假类型
Text6.Text = rst!班次
rst.Close
End Sub
Private Sub Command1_Click()
Text8.Text = Trim(Text8.Text)
If Text8.Text = "" Then MsgBox "请输入你的工号！", 48, 消息框: Exit Sub
my = "update qingjiabiao set 是否批准=" & -1 & ",批准工号= '" & Val(Text8.Text) & "' where 工号=" & Combo1.Text & ""
con.BeginTrans
con.Execute my
r = MsgBox("确定要批准吗？", vbYesNo + vbQuestion)
If r = vbYes Then
con.CommitTrans
Else
con.RollbackTrans
End If
End Sub
Private Sub Command2_Click()
Unload Me
End Sub
Private Sub Form_Load()
rst.Open "select * from qingjiabiao where 是否批准=" & 0 & "", con
Do While Not rst.EOF
Combo1.AddItem rst!工号
rst.MoveNext
Loop
rst.Close
Form11.Top = MDIForm1.Height / 5
Form11.Left = MDIForm1.Width / 4
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -