F_BuMenPeiXunJiHua.frm
资源名称:dbbase.rar [点击查看]
上传用户:xiao_xia32
上传日期:2022-07-21
资源大小:1174k
文件大小:62k
源码类别:
企业管理
开发平台:
Visual Basic
- VERSION 5.00
- Object = "{86CF1D34-0C5F-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCT2.OCX"
- Object = "{CDE57A40-8B86-11D0-B3C6-00A0C90AEA82}#1.0#0"; "MSDATGRD.OCX"
- Object = "{BDC217C8-ED16-11CD-956C-0000C04E4C0A}#1.1#0"; "TABCTL32.OCX"
- Object = "{67397AA1-7FB1-11D0-B148-00A0C922E820}#6.0#0"; "MSADODC.OCX"
- Object = "{0BA686C6-F7D3-101A-993E-0000C0EF6F5E}#1.0#0"; "THREED32.OCX"
- Begin VB.Form F_BuMenPeiXunJiHua
- BorderStyle = 3 'Fixed Dialog
- Caption = "部门培训计划登记"
- ClientHeight = 8625
- ClientLeft = 1050
- ClientTop = 1200
- ClientWidth = 12045
- ControlBox = 0 'False
- KeyPreview = -1 'True
- LinkTopic = "Form1"
- LockControls = -1 'True
- MaxButton = 0 'False
- MinButton = 0 'False
- Moveable = 0 'False
- ScaleHeight = 8625
- ScaleWidth = 12045
- ShowInTaskbar = 0 'False
- StartUpPosition = 2 '屏幕中心
- Begin TabDlg.SSTab SSTab1
- Height = 8625
- Left = 120
- TabIndex = 39
- Top = 0
- Width = 11775
- _ExtentX = 20770
- _ExtentY = 15214
- _Version = 393216
- Style = 1
- Tabs = 2
- TabHeight = 520
- BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
- Name = "宋体"
- Size = 9
- Charset = 134
- Weight = 400
- Underline = 0 'False
- Italic = 0 'False
- Strikethrough = 0 'False
- EndProperty
- TabCaption(0) = "编 辑"
- TabPicture(0) = "F_BuMenPeiXunJiHua.frx":0000
- Tab(0).ControlEnabled= -1 'True
- Tab(0).Control(0)= "lblLabels(1)"
- Tab(0).Control(0).Enabled= 0 'False
- Tab(0).Control(1)= "lblLabels(0)"
- Tab(0).Control(1).Enabled= 0 'False
- Tab(0).Control(2)= "lblLabels(26)"
- Tab(0).Control(2).Enabled= 0 'False
- Tab(0).Control(3)= "Frame10"
- Tab(0).Control(3).Enabled= 0 'False
- Tab(0).Control(4)= "Frame5"
- Tab(0).Control(4).Enabled= 0 'False
- Tab(0).Control(5)= "txtFields(1)"
- Tab(0).Control(5).Enabled= 0 'False
- Tab(0).Control(6)= "DTPickers(0)"
- Tab(0).Control(6).Enabled= 0 'False
- Tab(0).Control(7)= "Frame12"
- Tab(0).Control(7).Enabled= 0 'False
- Tab(0).Control(8)= "Frame13"
- Tab(0).Control(8).Enabled= 0 'False
- Tab(0).Control(9)= "Frame8"
- Tab(0).Control(9).Enabled= 0 'False
- Tab(0).Control(10)= "Frame9"
- Tab(0).Control(10).Enabled= 0 'False
- Tab(0).Control(11)= "Frame7"
- Tab(0).Control(11).Enabled= 0 'False
- Tab(0).Control(12)= "Frame6"
- Tab(0).Control(12).Enabled= 0 'False
- Tab(0).Control(13)= "Frame4"
- Tab(0).Control(13).Enabled= 0 'False
- Tab(0).Control(14)= "Frame3"
- Tab(0).Control(14).Enabled= 0 'False
- Tab(0).Control(15)= "Frame2"
- Tab(0).Control(15).Enabled= 0 'False
- Tab(0).Control(16)= "Frame1"
- Tab(0).Control(16).Enabled= 0 'False
- Tab(0).Control(17)= "txtFields(20)"
- Tab(0).Control(17).Enabled= 0 'False
- Tab(0).Control(18)= "Adodc1"
- Tab(0).Control(18).Enabled= 0 'False
- Tab(0).Control(19)= "Picture1"
- Tab(0).Control(19).Enabled= 0 'False
- Tab(0).ControlCount= 20
- TabCaption(1) = "列 表"
- TabPicture(1) = "F_BuMenPeiXunJiHua.frx":001C
- Tab(1).ControlEnabled= 0 'False
- Tab(1).Control(0)= "Frame11"
- Tab(1).ControlCount= 1
- Begin VB.PictureBox Picture1
- Appearance = 0 'Flat
- BorderStyle = 0 'None
- BeginProperty Font
- Name = "MS Sans Serif"
- Size = 8.25
- Charset = 0
- Weight = 400
- Underline = 0 'False
- Italic = 0 'False
- Strikethrough = 0 'False
- EndProperty
- ForeColor = &H80000008&
- Height = 660
- Left = 4440
- ScaleHeight = 660
- ScaleWidth = 7080
- TabIndex = 90
- Top = 7920
- Width = 7080
- Begin Threed.SSCommand cmdClose
- Height = 330
- Left = 5640
- TabIndex = 33
- Top = 240
- Width = 1095
- _Version = 65536
- _ExtentX = 1931
- _ExtentY = 573
- _StockProps = 78
- Caption = "&Q.关 闭"
- Font3D = 1
- End
- Begin Threed.SSCommand cmdRefresh
- Height = 330
- Left = 4440
- TabIndex = 32
- Top = 240
- Width = 1095
- _Version = 65536
- _ExtentX = 1931
- _ExtentY = 573
- _StockProps = 78
- Caption = "&R.刷 新"
- Font3D = 1
- End
- Begin Threed.SSCommand CmdAdd
- Height = 330
- Left = 840
- TabIndex = 29
- Top = 240
- Width = 1095
- _Version = 65536
- _ExtentX = 1931
- _ExtentY = 582
- _StockProps = 78
- Caption = "&A.增 加"
- Font3D = 1
- Picture = "F_BuMenPeiXunJiHua.frx":0038
- End
- Begin Threed.SSCommand cmdEdit
- Height = 330
- Left = 2040
- TabIndex = 30
- Top = 240
- Width = 1095
- _Version = 65536
- _ExtentX = 1931
- _ExtentY = 573
- _StockProps = 78
- Caption = "&E.编 辑"
- Font3D = 1
- End
- Begin Threed.SSCommand CmdDelete
- Height = 330
- Left = 3240
- TabIndex = 31
- Top = 240
- Width = 1095
- _Version = 65536
- _ExtentX = 1931
- _ExtentY = 573
- _StockProps = 78
- Caption = "&D.删 除"
- Font3D = 1
- End
- Begin Threed.SSCommand cmdCancel
- Height = 330
- Left = 5640
- TabIndex = 91
- Top = 240
- Width = 1095
- _Version = 65536
- _ExtentX = 1931
- _ExtentY = 573
- _StockProps = 78
- Caption = "&C.取消"
- Font3D = 1
- End
- Begin Threed.SSCommand cmdUpdate
- Height = 330
- Left = 4440
- TabIndex = 92
- Top = 240
- Width = 1095
- _Version = 65536
- _ExtentX = 1931
- _ExtentY = 573
- _StockProps = 78
- Caption = "&Y.保存"
- Font3D = 1
- End
- End
- Begin MSAdodcLib.Adodc Adodc1
- Height = 330
- Left = 390
- Top = 8190
- Visible = 0 'False
- Width = 1200
- _ExtentX = 2117
- _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= 3
- Appearance = 1
- BackColor = -2147483643
- ForeColor = -2147483640
- Orientation = 0
- Enabled = -1
- Connect = "DSN=RS"
- OLEDBString = ""
- OLEDBFile = ""
- DataSourceName = "RS"
- OtherAttributes = ""
- UserName = "sa"
- Password = ""
- RecordSource = "select * from 部门培训计划登记 where 1>2"
- Caption = "Adodc1"
- 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.TextBox txtFields
- Appearance = 0 'Flat
- DataField = "培训计划编号"
- Height = 285
- Index = 20
- Left = 1920
- TabIndex = 0
- Top = 400
- Width = 1695
- End
- Begin VB.Frame Frame1
- BeginProperty Font
- Name = "MS Sans Serif"
- Size = 8.25
- Charset = 0
- Weight = 400
- Underline = 0 'False
- Italic = 0 'False
- Strikethrough = 0 'False
- EndProperty
- Height = 1335
- Left = 720
- TabIndex = 69
- Top = 720
- Width = 10695
- Begin VB.ComboBox Combo2
- Appearance = 0 'Flat
- DataField = "培训对象"
- Height = 300
- Left = 8760
- TabIndex = 5
- Top = 240
- Width = 1695
- End
- Begin VB.ComboBox Combo1
- Appearance = 0 'Flat
- DataField = "培训种类"
- Height = 300
- Left = 5400
- TabIndex = 4
- Top = 240
- Width = 1695
- End
- Begin MSComCtl2.DTPicker DTPickers
- DataField = "举办日期"
- Height = 300
- Index = 1
- Left = 1200
- TabIndex = 9
- Top = 960
- Width = 1695
- _ExtentX = 2990
- _ExtentY = 529
- _Version = 393216
- CheckBox = -1 'True
- DateIsNull = -1 'True
- Format = 26869761
- CurrentDate = 36186
- End
- Begin VB.TextBox txtFields
- Appearance = 0 'Flat
- DataField = "项目名称"
- Height = 285
- Index = 2
- Left = 1200
- TabIndex = 3
- Top = 240
- Width = 1695
- End
- Begin VB.TextBox txtFields
- Appearance = 0 'Flat
- DataField = "参加人数"
- Height = 285
- Index = 5
- Left = 1200
- TabIndex = 6
- Top = 600
- Width = 1695
- End
- Begin VB.TextBox txtFields
- Appearance = 0 'Flat
- DataField = "地点"
- Height = 285
- Index = 7
- Left = 8760
- TabIndex = 8
- Top = 600
- Width = 1695
- End
- Begin VB.TextBox txtFields
- Appearance = 0 'Flat
- DataField = "培训时数"
- Height = 285
- Index = 8
- Left = 5400
- TabIndex = 7
- Top = 600
- Width = 1695
- End
- Begin VB.TextBox txtFields
- Appearance = 0 'Flat
- DataField = "师资来源"
- Height = 285
- Index = 9
- Left = 5400
- TabIndex = 10
- Top = 960
- Width = 1695
- End
- Begin VB.Label lblLabels
- Appearance = 0 'Flat
- BackColor = &H8000000A&
- Caption = "项目名称"
- ForeColor = &H80000008&
- Height = 255
- Index = 2
- Left = 240
- TabIndex = 77
- Top = 240
- Width = 855
- End
- Begin VB.Label lblLabels
- Caption = "培训种类"
- Height = 255
- Index = 3
- Left = 4080
- TabIndex = 76
- Top = 240
- Width = 855
- End
- Begin VB.Label lblLabels
- Caption = "培训对象"
- Height = 255
- Index = 4
- Left = 7680
- TabIndex = 75
- Top = 240
- Width = 855
- End
- Begin VB.Label lblLabels
- Caption = "参加人数"
- Height = 255
- Index = 5
- Left = 240
- TabIndex = 74
- Top = 600
- Width = 855
- End
- Begin VB.Label lblLabels
- Caption = "举办日期"
- Height = 255
- Index = 6
- Left = 240
- TabIndex = 73
- Top = 960
- Width = 855
- End
- Begin VB.Label lblLabels
- Caption = "地 点"
- Height = 255
- Index = 7
- Left = 7680
- TabIndex = 72
- Top = 600
- Width = 615
- End
- Begin VB.Label lblLabels
- Caption = "培训时数"
- Height = 255
- Index = 8
- Left = 4080
- TabIndex = 71
- Top = 600
- Width = 855
- End
- Begin VB.Label lblLabels
- Caption = "师资来源"
- Height = 255
- Index = 9
- Left = 4080
- TabIndex = 70
- Top = 960
- Width = 735
- End
- End
- Begin VB.Frame Frame2
- BeginProperty Font
- Name = "MS Sans Serif"
- Size = 8.25
- Charset = 0
- Weight = 400
- Underline = 0 'False
- Italic = 0 'False
- Strikethrough = 0 'False
- EndProperty
- Height = 1215
- Left = 720
- TabIndex = 88
- Top = 1920
- Width = 10695
- Begin VB.TextBox txtFields
- Appearance = 0 'Flat
- DataField = "培训目的"
- Height = 1095
- Index = 6
- Left = 0
- MultiLine = -1 'True
- ScrollBars = 2 'Vertical
- TabIndex = 11
- Top = 120
- Width = 10695
- End
- End
- Begin VB.Frame Frame3
- BeginProperty Font
- Name = "MS Sans Serif"
- Size = 8.25
- Charset = 0
- Weight = 400
- Underline = 0 'False
- Italic = 0 'False
- Strikethrough = 0 'False
- EndProperty
- Height = 855
- Left = 720
- TabIndex = 60
- Top = 3000
- Width = 10695
- Begin VB.TextBox txtFields
- Appearance = 0 'Flat
- DataField = "课时费"
- Height = 285
- Index = 11
- Left = 120
- TabIndex = 12
- Top = 480
- Width = 735
- End
- Begin VB.TextBox txtFields
- Appearance = 0 'Flat
- DataField = "租用费"
- Height = 285
- Index = 12
- Left = 1560
- TabIndex = 13
- Top = 495
- Width = 735
- End
- Begin VB.TextBox txtFields
- Appearance = 0 'Flat
- DataField = "招待费"
- Height = 285
- Index = 13
- Left = 2880
- TabIndex = 14
- Top = 480
- Width = 735
- End
- Begin VB.TextBox txtFields
- Appearance = 0 'Flat
- DataField = "交通费"
- Height = 285
- Index = 14
- Left = 4200
- TabIndex = 15
- Top = 480
- Width = 735
- End
- Begin VB.TextBox txtFields
- Appearance = 0 'Flat
- DataField = "教材费"
- Height = 285
- Index = 15
- Left = 5640
- TabIndex = 16
- Top = 480
- Width = 735
- End
- Begin VB.TextBox txtFields
- Appearance = 0 'Flat
- DataField = "工时占用费"
- Height = 285
- Index = 16
- Left = 6840
- TabIndex = 17
- Top = 480
- Width = 735
- End
- Begin VB.TextBox txtFields
- Appearance = 0 'Flat
- DataField = "其他费用"
- Height = 285
- Index = 17
- Left = 8160
- TabIndex = 18
- Top = 480
- Width = 735
- End
- Begin VB.TextBox txtFields
- Appearance = 0 'Flat
- DataField = "预算费用合计"
- Enabled = 0 'False
- Height = 285
- Index = 18
- Left = 9480
- TabIndex = 19
- Top = 480
- Width = 735
- End
- Begin VB.Label lblLabels
- Caption = "课时费"
- Height = 255
- Index = 11
- Left = 120
- TabIndex = 68
- Top = 240
- Width = 825
- End
- Begin VB.Label lblLabels
- Caption = "租用费"
- Height = 255
- Index = 12
- Left = 1560
- TabIndex = 67
- Top = 240
- Width = 615
- End
- Begin VB.Label lblLabels
- Caption = "招待费"
- Height = 255
- Index = 13
- Left = 2880
- TabIndex = 66
- Top = 255
- Width = 795
- End
- Begin VB.Label lblLabels
- Caption = "交通费"
- Height = 255
- Index = 14
- Left = 4200
- TabIndex = 65
- Top = 240
- Width = 705
- End
- Begin VB.Label lblLabels
- Caption = "教材费"
- Height = 255
- Index = 15
- Left = 5640
- TabIndex = 64
- Top = 240
- Width = 765
- End
- Begin VB.Label lblLabels
- Caption = "工时占用费"
- Height = 255
- Index = 16
- Left = 6720
- TabIndex = 63
- Top = 240
- Width = 1155
- End
- Begin VB.Label lblLabels
- Caption = "其他费用"
- Height = 255
- Index = 17
- Left = 8160
- TabIndex = 62
- Top = 240
- Width = 855
- End
- Begin VB.Label lblLabels
- Caption = "合 计"
- Height = 255
- Index = 18
- Left = 9480
- TabIndex = 61
- Top = 240
- Width = 855
- End
- End
- Begin VB.Frame Frame4
- BackColor = &H8000000A&
- BeginProperty Font
- Name = "MS Sans Serif"
- Size = 8.25
- Charset = 0
- Weight = 400
- Underline = 0 'False
- Italic = 0 'False
- Strikethrough = 0 'False
- EndProperty
- Height = 1455
- Left = 720
- TabIndex = 55
- Top = 3720
- Width = 10695
- Begin VB.TextBox txtFields
- DataField = "培训内容"
- Height = 855
- Index = 10
- Left = 0
- MultiLine = -1 'True
- ScrollBars = 2 'Vertical
- TabIndex = 20
- Top = 120
- Width = 10695
- End
- Begin VB.CheckBox Check1
- Caption = "口 试"
- DataField = "口试"
- Height = 255
- Left = 2400
- TabIndex = 58
- Top = 1080
- Width = 1335
- End
- Begin VB.CheckBox Check2
- Caption = "笔 试"
- DataField = "笔试"
- Height = 255
- Left = 4800
- TabIndex = 57
- Top = 1080
- Width = 1335
- End
- Begin VB.CheckBox Check3
- Caption = "实际操作"
- DataField = "实际操作"
- Height = 255
- Left = 7320
- TabIndex = 56
- Top = 1080
- Width = 1215
- End
- Begin VB.Label lblLabels
- Caption = "考核方式"
- Height = 255
- Index = 20
- Left = 240
- TabIndex = 59
- Top = 1080
- Width = 855
- End
- End
- Begin VB.Frame Frame6
- BeginProperty Font
- Name = "MS Sans Serif"
- Size = 8.25
- Charset = 0
- Weight = 400
- Underline = 0 'False
- Italic = 0 'False
- Strikethrough = 0 'False
- EndProperty
- Height = 1335
- Left = 240
- TabIndex = 48
- Top = 720
- Width = 495
- Begin VB.Label Label1
- Caption = "项 目 信 息"
- Height = 855
- Left = 120
- TabIndex = 49
- Top = 240
- Width = 255
- End
- End
- Begin VB.Frame Frame7
- BeginProperty Font
- Name = "MS Sans Serif"
- Size = 8.25
- Charset = 0
- Weight = 400
- Underline = 0 'False
- Italic = 0 'False
- Strikethrough = 0 'False
- EndProperty
- Height = 1215
- Left = 240
- TabIndex = 46
- Top = 1920
- Width = 495
- Begin VB.Label Label2
- Caption = "培训目的"
- Height = 855
- Left = 120
- TabIndex = 47
- Top = 240
- Width = 255
- End
- End
- Begin VB.Frame Frame9
- BeginProperty Font
- Name = "MS Sans Serif"
- Size = 8.25
- Charset = 0
- Weight = 400
- Underline = 0 'False
- Italic = 0 'False
- Strikethrough = 0 'False
- EndProperty
- Height = 855
- Left = 240
- TabIndex = 42
- Top = 3000
- Width = 495
- Begin VB.Label Label5
- Caption = "费用"
- Height = 495
- Left = 120
- TabIndex = 43
- Top = 240
- Width = 255
- End
- End
- Begin VB.Frame Frame8
- BeginProperty Font
- Name = "MS Sans Serif"
- Size = 8.25
- Charset = 0
- Weight = 400
- Underline = 0 'False
- Italic = 0 'False
- Strikethrough = 0 'False
- EndProperty
- Height = 1455
- Left = 240
- TabIndex = 44
- Top = 3720
- Width = 495
- Begin VB.Label Label4
- Caption = "培训内容"
- Height = 855
- Left = 120
- TabIndex = 45
- Top = 240
- Width = 255
- End
- End
- Begin VB.Frame Frame13
- BeginProperty Font
- Name = "MS Sans Serif"
- Size = 8.25
- Charset = 0
- Weight = 400
- Underline = 0 'False
- Italic = 0 'False
- Strikethrough = 0 'False
- EndProperty
- Height = 1815
- Left = 240
- TabIndex = 85
- Top = 5040
- Width = 495
- Begin VB.Label Label7
- Caption = "人 员"
- Height = 1245
- Left = 120
- TabIndex = 86
- Top = 510
- Width = 255
- End
- End
- Begin VB.Frame Frame12
- BeginProperty Font
- Name = "MS Sans Serif"
- Size = 8.25
- Charset = 0
- Weight = 400
- Underline = 0 'False
- Italic = 0 'False
- Strikethrough = 0 'False
- EndProperty
- Height = 1815
- Left = 720
- TabIndex = 83
- Top = 5040
- Width = 10695
- Begin MSDataGridLib.DataGrid DataGrid1
- Height = 1695
- Left = 0
- TabIndex = 84
- Top = 120
- Width = 10695
- _ExtentX = 18865
- _ExtentY = 2990
- _Version = 393216
- AllowUpdate = 0 'False
- HeadLines = 1
- RowHeight = 14
- TabAction = 2
- FormatLocked = -1 'True
- BeginProperty HeadFont {0BE35203-8F91-11CE-9DE3-00AA004BB851}
- Name = "MS Sans Serif"
- Size = 8.25
- Charset = 0
- 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 = 3
- 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
- BeginProperty Column02
- 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
- BeginProperty Column00
- ColumnWidth = 1140.095
- EndProperty
- BeginProperty Column01
- ColumnWidth = 1739.906
- EndProperty
- BeginProperty Column02
- ColumnWidth = 1739.906
- EndProperty
- EndProperty
- End
- End
- Begin MSComCtl2.DTPicker DTPickers
- DataField = "时间"
- Height = 300
- Index = 0
- Left = 9480
- TabIndex = 2
- Top = 400
- Width = 1695
- _ExtentX = 2990
- _ExtentY = 529
- _Version = 393216
- CheckBox = -1 'True
- Format = 26869761
- CurrentDate = 36186
- End
- Begin VB.Frame Frame11
- BeginProperty Font
- Name = "MS Sans Serif"
- Size = 8.25
- Charset = 0
- Weight = 400
- Underline = 0 'False
- Italic = 0 'False
- Strikethrough = 0 'False
- EndProperty
- Height = 7575
- Left = -74760
- TabIndex = 80
- Top = 480
- Width = 11175
- Begin MSDataGridLib.DataGrid DataGrid2
- Height = 6975
- Left = 240
- TabIndex = 81
- Top = 360
- Width = 10695
- _ExtentX = 18865
- _ExtentY = 12303
- _Version = 393216
- AllowUpdate = 0 'False
- HeadLines = 1
- RowHeight = 14
- BeginProperty HeadFont {0BE35203-8F91-11CE-9DE3-00AA004BB851}
- Name = "MS Sans Serif"
- Size = 8.25
- Charset = 0
- 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
- BeginProperty Column00
- EndProperty
- BeginProperty Column01
- EndProperty
- EndProperty
- End
- End
- Begin VB.TextBox txtFields
- Appearance = 0 'Flat
- DataField = "部门"
- Height = 285
- Index = 1
- Left = 6120
- TabIndex = 1
- Top = 400
- Width = 1695
- End
- Begin VB.Frame Frame5
- BeginProperty Font
- Name = "MS Sans Serif"
- Size = 8.25
- Charset = 0
- Weight = 400
- Underline = 0 'False
- Italic = 0 'False
- Strikethrough = 0 'False
- EndProperty
- Height = 1215
- Left = 720
- TabIndex = 50
- Top = 6720
- Width = 10695
- Begin VB.TextBox txtFields
- Appearance = 0 'Flat
- DataField = "部门申请人签字"
- Height = 285
- Index = 0
- Left = 8520
- Locked = -1 'True
- TabIndex = 24
- Top = 480
- Width = 1695
- End
- Begin MSComCtl2.DTPicker DTPickers
- DataField = "总经理签字时间"
- Height = 300
- Index = 4
- Left = 6240
- TabIndex = 27
- Top = 840
- Width = 1695
- _ExtentX = 2990
- _ExtentY = 529
- _Version = 393216
- CheckBox = -1 'True
- Format = 26869761
- CurrentDate = 36186
- End
- Begin MSComCtl2.DTPicker DTPickers
- DataField = "财务部经理签字时间"
- Height = 300
- Index = 3
- Left = 3720
- TabIndex = 26
- Top = 840
- Width = 1695
- _ExtentX = 2990
- _ExtentY = 529
- _Version = 393216
- CheckBox = -1 'True
- Format = 26869761
- CurrentDate = 36186
- End
- Begin MSComCtl2.DTPicker DTPickers
- DataField = "人力资源部签字时间"
- Height = 300
- Index = 2
- Left = 1080
- TabIndex = 25
- Top = 840
- Width = 1695
- _ExtentX = 2990
- _ExtentY = 529
- _Version = 393216
- CheckBox = -1 'True
- Format = 26869761
- CurrentDate = 36186
- End
- Begin VB.TextBox txtFields
- Appearance = 0 'Flat
- DataField = "人力资源部经理签字"
- Height = 285
- Index = 21
- Left = 1080
- Locked = -1 'True
- TabIndex = 21
- Top = 480
- Width = 1695
- End
- Begin VB.TextBox txtFields
- Appearance = 0 'Flat
- DataField = "财务部经理签字"
- Height = 285
- Index = 23
- Left = 3720
- Locked = -1 'True
- TabIndex = 22
- Top = 480
- Width = 1695
- End
- Begin VB.TextBox txtFields
- Appearance = 0 'Flat
- DataField = "总经理签字"
- Height = 285
- Index = 25
- Left = 6240
- Locked = -1 'True
- TabIndex = 23
- Top = 480
- Width = 1695
- End
- Begin MSComCtl2.DTPicker DTPickers
- DataField = "部门申请人签字时间"
- Height = 300
- Index = 5
- Left = 8520
- TabIndex = 28
- Top = 840
- Width = 1695
- _ExtentX = 2990
- _ExtentY = 529
- _Version = 393216
- CheckBox = -1 'True
- Format = 26869761
- CurrentDate = 36186
- End
- Begin VB.Label lblLabels
- Caption = "经 理"
- Height = 255
- Index = 19
- Left = 120
- TabIndex = 87
- Top = 480
- Width = 975
- End
- Begin VB.Label lblLabels
- Caption = "部门申请人"
- Height = 255
- Index = 10
- Left = 8520
- TabIndex = 82
- Top = 240
- Width = 1335
- End
- Begin VB.Label lblLabels
- Caption = "人力资源部:"
- Height = 255
- Index = 21
- Left = 1080
- TabIndex = 54
- Top = 240
- Width = 975
- End
- Begin VB.Label lblLabels
- Caption = "财务部"
- Height = 255
- Index = 23
- Left = 3720
- TabIndex = 53
- Top = 240
- Width = 1455
- End
- Begin VB.Label lblLabels
- Caption = "总经理"
- Height = 255
- Index = 25
- Left = 6240
- TabIndex = 52
- Top = 240
- Width = 1335
- End
- Begin VB.Label lblLabels
- Caption = "签字时间"
- Height = 255
- Index = 24
- Left = 120
- TabIndex = 51
- Top = 840
- Width = 975
- End
- End
- Begin VB.Frame Frame10
- BeginProperty Font
- Name = "MS Sans Serif"
- Size = 8.25
- Charset = 0
- Weight = 400
- Underline = 0 'False
- Italic = 0 'False
- Strikethrough = 0 'False
- EndProperty
- Height = 1215
- Left = 240
- TabIndex = 40
- Top = 6720
- Width = 495
- Begin VB.Label Label6
- Caption = "呈核"
- Height = 735
- Left = 120
- TabIndex = 41
- Top = 360
- Width = 255
- End
- End
- Begin VB.Label lblLabels
- Caption = "计划编号"
- Height = 255
- Index = 26
- Left = 720
- TabIndex = 89
- Top = 480
- Width = 975
- End
- Begin VB.Label lblLabels
- Caption = "时 间"
- Height = 255
- Index = 0
- Left = 8400
- TabIndex = 79
- Top = 480
- Width = 735
- End
- Begin VB.Label lblLabels
- Caption = "部 门"
- Height = 255
- Index = 1
- Left = 4800
- TabIndex = 78
- Top = 480
- Width = 615
- End
- End
- Begin VB.TextBox txtFields
- DataField = "部门申请人签字时间"
- BeginProperty Font
- Name = "MS Sans Serif"
- Size = 8.25
- Charset = 0
- Weight = 400
- Underline = 0 'False
- Italic = 0 'False
- Strikethrough = 0 'False
- EndProperty
- Height = 285
- Index = 28
- Left = 2040
- TabIndex = 37
- Top = 9020
- Width = 3375
- End
- Begin VB.TextBox txtFields
- DataField = "部门申请人签字"
- BeginProperty Font
- Name = "MS Sans Serif"
- Size = 8.25
- Charset = 0
- Weight = 400
- Underline = 0 'False
- Italic = 0 'False
- Strikethrough = 0 'False
- EndProperty
- Height = 285
- Index = 27
- Left = 2040
- TabIndex = 35
- Top = 8700
- Width = 3375
- End
- Begin MSDataGridLib.DataGrid grdDataGrid
- Height = 1300
- Left = 0
- TabIndex = 38
- Top = 9340
- Width = 5765
- _ExtentX = 10160
- _ExtentY = 2275
- _Version = 393216
- AllowUpdate = 0 'False
- HeadLines = 1
- RowHeight = 15
- BeginProperty HeadFont {0BE35203-8F91-11CE-9DE3-00AA004BB851}
- Name = "MS Sans Serif"
- Size = 8.25
- Charset = 0
- Weight = 400
- Underline = 0 'False
- Italic = 0 'False
- Strikethrough = 0 'False
- EndProperty
- BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
- Name = "MS Sans Serif"
- Size = 8.25
- Charset = 0
- 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
- BeginProperty Column00
- EndProperty
- BeginProperty Column01
- EndProperty
- EndProperty
- End
- Begin VB.Label lblLabels
- Caption = "部门申请人签字时间:"
- BeginProperty Font
- Name = "MS Sans Serif"
- Size = 8.25
- Charset = 0
- Weight = 400
- Underline = 0 'False
- Italic = 0 'False
- Strikethrough = 0 'False
- EndProperty
- Height = 255
- Index = 28
- Left = 120
- TabIndex = 36
- Top = 9020
- Width = 1815
- End
- Begin VB.Label lblLabels
- Caption = "部门申请人签字:"
- BeginProperty Font
- Name = "MS Sans Serif"
- Size = 8.25
- Charset = 0
- Weight = 400
- Underline = 0 'False
- Italic = 0 'False
- Strikethrough = 0 'False
- EndProperty
- Height = 255
- Index = 27
- Left = 120
- TabIndex = 34
- Top = 8700
- Width = 1815
- End
- End
- Attribute VB_Name = "F_BuMenPeiXunJiHua"
- Attribute VB_GlobalNameSpace = False
- Attribute VB_Creatable = False
- Attribute VB_PredeclaredId = True
- Attribute VB_Exposed = False
- Dim WithEvents adoPrimaryRS As Recordset
- Attribute adoPrimaryRS.VB_VarHelpID = -1
- Dim mvBookMark As Variant
- Dim mbEditFlag As Boolean
- Dim mbAddNewFlag As Boolean
- Private Function UpdateData() As Boolean
- Dim strTemp As String
- Dim adochild As ADODB.Recordset
- On Error GoTo UpdateErr
- '更新父表
- adoPrimaryRS.UpdateBatch adAffectCurrent
- '检查子表的有效性
- Set adochild = New Recordset
- Set adochild = adoPrimaryRS("ChildCMD").UnderlyingValue
- If Not (adochild.BOF And adochild.EOF) Then
- adochild.MoveFirst
- End If
- 'While Not adochild.EOF
- ' If Trim(adochild.Fields("单价")) = "" Or IsNull(adochild.Fields("单价")) Or Not IsNumeric(adochild.Fields("单价")) Then
- ' MsgBox "请在单价中输入数字!", vbExclamation + vbOKOnly, "警告"
- ' adochild.Close
- ' Set adochild = Nothing
- 'Exit Function
- 'End If
- 'If Trim(adochild.Fields("数量")) = "" Or IsNull(adochild.Fields("数量")) Or Not IsNumeric(adochild.Fields("单价")) Then
- ' MsgBox "请在数量中输入数字!", vbExclamation + vbOKOnly, "警告"
- ' adochild.Close
- ' Set adochild = Nothing
- 'Exit Function
- ' End If
- ' adochild.MoveNext
- ' Wend
- '更新子表
- adochild.UpdateBatch adAffectAllChapters
- adochild.Close
- Set adochild = Nothing
- ' strTemp = txtFields(0).Text
- ' Set grdDataGrid.DataSource = Nothing
- 'adoPrimaryRS.Requery
- 'adoPrimaryRS.Find "目的港='" & strTemp & "'", 0, adSearchForward
- 'Set grdDataGrid.DataSource = adoPrimaryRS("ChildCMD").UnderlyingValue
- UpdateData = True
- If mbAddNewFlag Then
- adoPrimaryRS.MoveLast 'move to the new record
- End If
- mbEditFlag = False
- mbAddNewFlag = False
- SetButtons True
- Exit Function
- UpdateErr:
- UpdateData = False
- End Function
- Private Sub Combo1_KeyPress(KeyAscii As Integer)
- If KeyAscii = vbKeyReturn Then '
- SendKeys "{TAB}"
- End If
- End Sub
- Private Sub Combo2_KeyUp(KeyCode As Integer, Shift As Integer)
- If KeyAscii = vbKeyReturn Then '
- SendKeys "{TAB}"
- End If
- End Sub
- Private Sub DataGrid1_AfterColUpdate(ByVal ColIndex As Integer)
- On Error Resume Next
- If ColIndex = 1 Then
- t = DataGrid1.Row
- DataGrid1.Col = 1
- DataGrid1.Row = t
- bbh = DataGrid1.Text
- Sql = "select 姓名 ,岗位名称 from 员工基本信息 where 员工号 =" & bbh & ""
- Set RS = db.Execute(Sql)
- DataGrid1.Col = 2
- DataGrid1.Row = t
- DataGrid1.Text = Trim(RS("姓名"))
- DataGrid1.Col = 3
- DataGrid1.Row = t
- DataGrid1.Text = Trim(RS("岗位名称"))
- End If
- End Sub
- Private Sub DataGrid1_Error(ByVal DataError As Integer, Response As Integer)
- Response = 0
- MsgBox "输入数据不合法,请输入合法数据!", vbExclamation + vbOKOnly, pTitle
- End Sub
- Private Sub DTPickers_KeyPress(Index As Integer, KeyAscii As Integer)
- If KeyAscii = vbKeyReturn Then '
- SendKeys "{TAB}"
- End If
- End Sub
- Private Sub Form_Load()
- Set adoPrimaryRS = New Recordset
- adoPrimaryRS.Open "SHAPE {select 培训计划编号,时间,部门,项目名称,培训种类,培训对象,参加人数,举办日期,地点,培训时数,师资来源,培训目的,课时费,租用费,招待费,交通费,教材费,工时占用费,其他费用,预算费用合计,培训内容,口试,笔试,实际操作,人力资源部经理签字,人力资源部签字时间,财务部经理签字,财务部经理签字时间,总经理签字,总经理签字时间,部门申请人签字,部门申请人签字时间 from 部门培训计划登记} AS ParentCMD APPEND ({select 部门培训计划编号,员工号,姓名,岗位名称 from 部门培训计划人员 } AS ChildCMD RELATE 培训计划编号 TO 部门培训计划编号) AS ChildCMD", db1, adOpenStatic, adLockBatchOptimistic
- Dim oText As TextBox
- 'Bind the text boxes to the data provider
- If GANGWEI <> "总经理" Then
- For Each oText In Me.txtFields
- Set oText.DataSource = adoPrimaryRS
- Next
- Else
- End If
- SetButtons True
- If adoPrimaryRS.RecordCount <> 0 Then
- Set DataGrid1.DataSource = adoPrimaryRS("ChildCMD").UnderlyingValue
- End If
- Dim oDTP As DTPicker
- 'Bind the DTPicker to the data provider
- For Each oDTP In Me.DTPickers
- Set oDTP.DataSource = adoPrimaryRS
- Next
- Set DataGrid2.DataSource = adoPrimaryRS
- Set Combo1.DataSource = adoPrimaryRS
- Set Combo2.DataSource = adoPrimaryRS
- Set Check1.DataSource = adoPrimaryRS
- Set Check2.DataSource = adoPrimaryRS
- Set Check3.DataSource = adoPrimaryRS
- mbDataChanged = False
- Combo1.AddItem "入职培训"
- Combo1.AddItem "在职培训"
- Combo1.AddItem "脱产学习"
- Combo1.AddItem "业余学习"
- Combo2.AddItem "全员"
- Combo2.AddItem "骨干"
- Combo2.AddItem "特殊人才"
- Combo2.AddItem "管理人员"
- 'pxy add 99/6/2
- If GANGWEI = "总经理" Then
- Sql = "select * from 工作联络单 where 编号=" & LLDBH & ""
- Set RS = ConnWZ.Execute(Sql)
- For Each oText In Me.txtFields
- Set oText.DataSource = Adodc1
- Next
- jhbh = RS("公文编号")
- Adodc1.RecordSource = "select * from 部门培训计划登记 where 培训计划编号='" & jhbh & "'"
- Adodc1.Refresh
- txtFields(25).Enabled = True
- txtFields(25).Locked = False
- End If
- Dim i As Integer
- For i = 0 To 5
- Me.DTPickers(i).Value = Format(Now, "yyyy年mm月dd日")
- Next i
- End Sub
- Private Sub Form_Unload(Cancel As Integer)
- Screen.MousePointer = vbDefault
- End Sub
- Private Sub cmdadd_Click()
- On Error GoTo AddErr
- With adoPrimaryRS
- If Not (.BOF And .EOF) Then
- mvBookMark = .Bookmark
- End If
- .AddNew
- mbAddNewFlag = True
- SetButtons False
- End With
- On Error GoTo 0
- Exit Sub
- AddErr:
- MsgBox "增加操作有错误", vbExclamation + vbOKOnly, pTitle
- End Sub
- Private Sub cmddelete_Click()
- Dim adochild As ADODB.Recordset
- On Error GoTo DeleteErr
- RESULT = MsgBox("此操作将删除此记录所有信息,你真的要删除吗?", vbExclamation + vbYesNo + vbDefaultButton2, "提示")
- If RESULT = 6 Then '选择YES
- '删除子表记录
- Set adochild = New Recordset
- Set adochild = adoPrimaryRS("ChildCMD").UnderlyingValue
- While Not adochild.EOF
- adochild.Delete
- adochild.MoveNext
- Wend
- adochild.UpdateBatch adAffectAll
- adochild.Close
- Set adochild = Nothing
- '删除父表的当前记录
- With adoPrimaryRS
- .Delete
- .UpdateBatch adAffectCurrent
- .MoveNext
- If .EOF Then .MoveLast
- End With
- End If
- On Error GoTo 0
- Exit Sub
- DeleteErr:
- MsgBox "删除数据失败!", vbExclamation + vbOKOnly, "Ptitle"
- End Sub
- Private Sub cmdRefresh_Click()
- 'This is only needed for multi user apps
- On Error GoTo RefreshErr
- adoPrimaryRS.Requery
- On Error GoTo 0
- Exit Sub
- RefreshErr:
- MsgBox "刷新操作有错误", vbExclamation + vbOKOnly, pTitle
- End Sub
- Private Sub cmdedit_Click()
- On Error GoTo EditErr
- mbEditFlag = True
- SetButtons False
- On Error GoTo 0
- Exit Sub
- EditErr:
- MsgBox "更改操作有错误", vbExclamation + vbOKOnly, pTitle
- End Sub
- Private Sub cmdCancel_Click()
- ' On Error Resume Next
- On Error GoTo CancelErr
- mbEditFlag = False
- mbAddNewFlag = False
- adoPrimaryRS.CancelUpdate
- If mvBookMark > 0 Then
- adoPrimaryRS.Bookmark = mvBookMark
- Else
- adoPrimaryRS.MoveFirst
- End If
- SetButtons True
- Exit Sub
- CancelErr:
- MsgBox "取消操作有错误", vbExclamation + vbOKOnly, pTitle
- End Sub
- Private Sub cmdUpdate_Click()
- Dim blnUpdateFlag As Boolean
- blnUpdateFlag = UpdateData
- If blnUpdateFlag = True Then
- MsgBox "数据保存成功!", vbInformation + vbOKOnly, "提示"
- Sql = "insert 工作联络单 (发件人,发件人地址,收件人,发件时间,公文类别,阅读状态,是否审批,审批状态,公文编号) values('" & YGXM & "','" & YJBM & "','危红英','" & Now & "','培训','未阅读','是','已审批'," & Val(txtFields(20)) & ")"
- Set RS = ConnWZ.Execute(Sql)
- Else
- MsgBox "数据保存失败!", vbExclamation + vbOKOnly, "警告"
- End If
- End Sub
- Private Sub cmdClose_Click()
- If GANGWEI <> "总经理" Then
- RSGL.Enabled = True
- Unload Me
- Else
- FRM_ZJLCX.Enabled = True
- Unload Me
- End If
- End Sub
- Private Sub SetButtons(bVal As Boolean)
- Dim oText As TextBox
- cmdAdd.Visible = bVal
- cmdEdit.Visible = bVal
- cmdUpdate.Visible = Not bVal
- cmdCancel.Visible = Not bVal
- cmdDelete.Visible = bVal
- cmdClose.Visible = bVal
- cmdRefresh.Visible = bVal
- For Each oText In Me.txtFields
- oText.Enabled = Not bVal
- Next
- Combo1.Enabled = Not bVal
- Combo2.Enabled = Not bVal
- Check1.Enabled = Not bVal
- Check2.Enabled = Not bVal
- Check3.Enabled = Not bVal
- If bVal Then
- Set DataGrid2.DataSource = adoPrimaryRS
- Else
- Set DataGrid2.DataSource = Nothing
- End If
- If Not bVal Then
- If mbEditFlag Then
- DataGrid1.AllowAddNew = True
- DataGrid1.AllowDelete = True
- DataGrid1.AllowUpdate = True
- End If
- Else
- DataGrid1.AllowAddNew = False
- DataGrid1.AllowDelete = False
- DataGrid1.AllowUpdate = False
- End If
- End Sub
- Private Sub txtFields_Change(Index As Integer)
- If IsNumeric(txtFields(11).Text) And IsNumeric(txtFields(12).Text) And IsNumeric(txtFields(13).Text) And IsNumeric(txtFields(14).Text) And IsNumeric(txtFields(15).Text) And IsNumeric(txtFields(16).Text) And IsNumeric(txtFields(17).Text) Then
- txtFields(18) = CDbl(txtFields(11)) + CDbl(txtFields(12)) + CDbl(txtFields(13)) + CDbl(txtFields(14)) + CDbl(txtFields(15)) + CDbl(txtFields(16)) + CDbl(txtFields(17))
- End If
- End Sub
- Private Sub txtFields_KeyPress(Index As Integer, KeyAscii As Integer)
- If KeyAscii = vbKeyReturn Then '
- SendKeys "{TAB}"
- End If
- End Sub
- Private Sub txtFields_LostFocus(Index As Integer)
- Select Case Index
- Case 20
- If Not IsNull(Trim(txtFields(20).Text)) Then
- 'txtFields(20).Locked = True
- End If
- Case 5
- If Not IsNumeric(txtFields(5).Text) And (txtFields(5).Text <> "") Then
- MsgBox "请在“参加人数”中输入数字", vbExclamation + vbOKOnly, pTitle
- txtFields(5).SetFocus
- txtFields(5).SelStart = 0
- txtFields(5).SelLength = Len(txtFields(5))
- Exit Sub
- End If
- Case 8
- If Not IsNumeric(txtFields(8).Text) And (txtFields(8).Text <> "") Then
- MsgBox "请在“培训时数”中输入数字", vbExclamation + vbOKOnly, pTitle
- txtFields(8).SetFocus
- txtFields(8).SelStart = 0
- txtFields(8).SelLength = Len(txtFields(8))
- End If
- Case 11
- If Not IsNumeric(txtFields(11).Text) And (txtFields(11).Text <> "") Then
- MsgBox "请在“课时费”中输入数字", vbExclamation + vbOKOnly, pTitle
- txtFields(11).SetFocus
- txtFields(11).SelStart = 0
- txtFields(11).SelLength = Len(txtFields(11))
- End If
- Case 12
- If Not IsNumeric(txtFields(12).Text) And (txtFields(12).Text <> "") Then
- MsgBox "请在“租用费”中输入数字", vbExclamation + vbOKOnly, pTitle
- txtFields(12).SetFocus
- txtFields(12).SelStart = 0
- txtFields(12).SelLength = Len(txtFields(12))
- End If
- Case 13
- If Not IsNumeric(txtFields(13).Text) And (txtFields(13).Text <> "") Then
- MsgBox "请在“招待费”中输入数字", vbExclamation + vbOKOnly, pTitle
- txtFields(13).SetFocus
- txtFields(13).SelStart = 0
- txtFields(13).SelLength = Len(txtFields(13))
- End If
- Case 14
- If Not IsNumeric(txtFields(14).Text) And (txtFields(14).Text <> "") Then
- MsgBox "请在“交通费”中输入数字", vbExclamation + vbOKOnly, pTitle
- txtFields(14).SetFocus
- txtFields(14).SelStart = 0
- txtFields(14).SelLength = Len(txtFields(14))
- End If
- Case 15
- If Not IsNumeric(txtFields(15).Text) And (txtFields(15).Text <> "") Then
- MsgBox "请在“教材费”中输入数字", vbExclamation + vbOKOnly, pTitle
- txtFields(15).SetFocus
- txtFields(15).SelStart = 0
- txtFields(15).SelLength = Len(txtFields(15))
- End If
- Case 16
- If Not IsNumeric(txtFields(16).Text) And (txtFields(16).Text <> "") Then
- MsgBox "请在“工时占用费”中输入数字", vbExclamation + vbOKOnly, pTitle
- txtFields(16).SetFocus
- txtFields(16).SelStart = 0
- txtFields(16).SelLength = Len(txtFields(16))
- End If
- Case 17
- If Not IsNumeric(txtFields(17).Text) And (txtFields(17).Text <> "") Then
- MsgBox "请在“其他费用”中输入数字", vbExclamation + vbOKOnly, pTitle
- txtFields(17).SetFocus
- txtFields(17).SelStart = 0
- txtFields(17).SelLength = Len(txtFields(17))
- End If
- End Select
- txtFields(20).Locked = True
- End Sub