📄 frmxtsz.frm
字号:
VERSION 5.00
Object = "{BDC217C8-ED16-11CD-956C-0000C04E4C0A}#1.1#0"; "TABCTL32.OCX"
Begin VB.Form frmXTSZ
BorderStyle = 1 'Fixed Single
Caption = "Form1"
ClientHeight = 4500
ClientLeft = 45
ClientTop = 435
ClientWidth = 7965
BeginProperty Font
Name = "Arial"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
LinkTopic = "Form1"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 4500
ScaleWidth = 7965
StartUpPosition = 2 '屏幕中心
Begin VB.CommandButton cmdSC
Caption = "删除"
Height = 330
Left = 6720
TabIndex = 7
Top = 3960
Width = 1095
End
Begin VB.CommandButton cmdJR
Caption = "加入"
Height = 330
Left = 5400
TabIndex = 6
Top = 3960
Width = 1095
End
Begin VB.TextBox txtZ
Height = 330
Left = 3480
TabIndex = 3
Top = 3960
Width = 1695
End
Begin VB.TextBox txtXM
Enabled = 0 'False
Height = 330
Left = 960
Locked = -1 'True
TabIndex = 2
Top = 3960
Width = 1575
End
Begin VB.PictureBox Picture1
BackColor = &H8000000D&
BorderStyle = 0 'None
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 495
Left = 0
ScaleHeight = 495
ScaleWidth = 8415
TabIndex = 1
Top = 0
Width = 8415
Begin VB.Label Label3
BackStyle = 0 'Transparent
Caption = "系统参数设置"
BeginProperty Font
Name = "Arial"
Size = 10.5
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FFFFFF&
Height = 255
Left = 240
TabIndex = 8
Top = 120
Width = 1695
End
End
Begin TabDlg.SSTab SSTab1
Height = 375
Left = 120
TabIndex = 0
Top = 600
Width = 7725
_ExtentX = 13626
_ExtentY = 661
_Version = 393216
Style = 1
Tabs = 11
TabsPerRow = 11
TabHeight = 520
TabCaption(0) = "民族"
TabPicture(0) = "frmXTSZ.frx":0000
Tab(0).ControlEnabled= -1 'True
Tab(0).ControlCount= 0
TabCaption(1) = "政治面貌"
TabPicture(1) = "frmXTSZ.frx":001C
Tab(1).ControlEnabled= 0 'False
Tab(1).ControlCount= 0
TabCaption(2) = "职工类型"
TabPicture(2) = "frmXTSZ.frx":0038
Tab(2).ControlEnabled= 0 'False
Tab(2).ControlCount= 0
TabCaption(3) = "学历"
TabPicture(3) = "frmXTSZ.frx":0054
Tab(3).ControlEnabled= 0 'False
Tab(3).ControlCount= 0
TabCaption(4) = "岗位"
TabPicture(4) = "frmXTSZ.frx":0070
Tab(4).ControlEnabled= 0 'False
Tab(4).ControlCount= 0
TabCaption(5) = "岗别"
TabPicture(5) = "frmXTSZ.frx":008C
Tab(5).ControlEnabled= 0 'False
Tab(5).ControlCount= 0
TabCaption(6) = "档次"
TabPicture(6) = "frmXTSZ.frx":00A8
Tab(6).ControlEnabled= 0 'False
Tab(6).ControlCount= 0
TabCaption(7) = "职务"
TabPicture(7) = "frmXTSZ.frx":00C4
Tab(7).ControlEnabled= 0 'False
Tab(7).ControlCount= 0
TabCaption(8) = "职称"
TabPicture(8) = "frmXTSZ.frx":00E0
Tab(8).ControlEnabled= 0 'False
Tab(8).ControlCount= 0
TabCaption(9) = "来源"
TabPicture(9) = "frmXTSZ.frx":00FC
Tab(9).ControlEnabled= 0 'False
Tab(9).ControlCount= 0
TabCaption(10) = "用工形式"
TabPicture(10) = "frmXTSZ.frx":0118
Tab(10).ControlEnabled= 0 'False
Tab(10).ControlCount= 0
End
Begin VB.Frame Frame1
Height = 2895
Left = 120
TabIndex = 9
Top = 840
Width = 7725
Begin VB.ListBox List1
Height = 2535
ItemData = "frmXTSZ.frx":0134
Left = 120
List = "frmXTSZ.frx":0136
TabIndex = 10
Top = 240
Width = 7455
End
End
Begin VB.Label Label2
Caption = "名称"
Height = 255
Left = 3000
TabIndex = 5
Top = 4000
Width = 495
End
Begin VB.Label Label1
Caption = "项目"
Height = 255
Left = 480
TabIndex = 4
Top = 4000
Width = 375
End
End
Attribute VB_Name = "frmXTSZ"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'****************************************************************************
'人人为我，我为人人
'枕善居收藏整理
'发布日期：2007/12/17
'描 述：企事业单位人事管理系统 Ver 2007
'网 站：http://www.Mndsoft.com/ (VB6源码博客)
'网 站：http://www.VbDnet.com/ (VB.NET源码博客,主要基于.NET2005)
'e-mail ：Mndsoft@163.com
'e-mail ：Mndsoft@126.com
'OICQ ：88382850
' 如果您有新的好的代码别忘记给枕善居哦!
'****************************************************************************
Private Sub cmdJR_Click() '新增系统参数
If Me.txtZ.Text = "" Or Me.txtXM.Text = "" Then
MsgBox "请填写数据后再加入！", 48, "提示"
Exit Sub
End If
For i = 0 To Me.List1.ListCount '验证是否有重复
If Me.txtZ.Text = Me.List1.List(i) Then
MsgBox "该项数据已经存在！", 48, "提示"
Exit Sub
End If
Next
Call OpenConn
SQL = "select * from 参数设置表"
rs.Open SQL, cn, 3, 3
rs.AddNew
rs!项目 = Me.txtXM.Text
rs!值 = Me.txtZ.Text
rs.Update
Call CloseConn
Me.txtZ.Text = ""
Call addLIST(Me.txtXM.Text) '刷新list
End Sub
Private Sub cmdSC_Click()
If List1.Text = "" Then
MsgBox "请选择要删除的项目！", 48, "提示"
Exit Sub
End If
Call OpenConn
cn.Execute ("delete * from 参数设置表 where 项目='" & Me.txtXM.Text & "' and 值='" & Me.List1.Text & "'")
Call CloseConn
Me.txtZ.Text = ""
Call addLIST(Me.txtXM.Text)
End Sub
Private Sub Form_Initialize()
Call InitCommonControls 'XP效果
End Sub
Private Sub Form_Load()
Me.Caption = gXtmc
Me.Icon = MDIfrm.Icon '图标
Me.txtXM.Text = "民族"
Call OpenConn
SQL = "select 值 from 参数设置表 where 项目='民族'"
rs.Open SQL, cn, 1, 1
Do While Not rs.EOF
Me.List1.AddItem rs!值
rs.MoveNext
Loop
Call CloseConn
End Sub
Private Sub List1_Click()
Me.txtZ.Text = Me.List1.Text
End Sub
Private Sub SSTab1_Click(PreviousTab As Integer)
Me.txtXM.Text = Me.SSTab1.Caption
Me.txtZ.Text = ""
Call addLIST(Me.SSTab1.Caption) '刷新list
End Sub
Private Sub addLIST(SSTString As String) 'list刷新过程
Me.List1.Clear
Call OpenConn
SQL = "select 值 from 参数设置表 where 项目='" & SSTString & "'"
rs.Open SQL, cn, 1, 1
Do While Not rs.EOF
Me.List1.AddItem rs!值
rs.MoveNext
Loop
Call CloseConn
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -