📄 frminitnew.frm
字号:
VERSION 5.00
Object = "{F9043C88-F6F2-101A-A3C9-08002B2F49FB}#1.2#0"; "COMDLG32.OCX"
Object = "{BDC217C8-ED16-11CD-956C-0000C04E4C0A}#1.1#0"; "TABCTL32.OCX"
Begin VB.Form frmInitnew
BorderStyle = 3 'Fixed Dialog
Caption = "系统参数设置"
ClientHeight = 4575
ClientLeft = 45
ClientTop = 330
ClientWidth = 7140
LinkTopic = "Form1"
MaxButton = 0 'False
MDIChild = -1 'True
MinButton = 0 'False
ScaleHeight = 4575
ScaleWidth = 7140
ShowInTaskbar = 0 'False
Begin TabDlg.SSTab SSTab1
Height = 4425
Left = 60
TabIndex = 3
Top = 90
Width = 7020
_ExtentX = 12383
_ExtentY = 7805
_Version = 393216
Tabs = 2
TabsPerRow = 2
TabHeight = 520
BackColor = -2147483644
TabCaption(0) = "代码维护"
TabPicture(0) = "frmInitnew.frx":0000
Tab(0).ControlEnabled= -1 'True
Tab(0).Control(0)= "txtValue"
Tab(0).Control(0).Enabled= 0 'False
Tab(0).Control(1)= "Frame5"
Tab(0).Control(1).Enabled= 0 'False
Tab(0).Control(2)= "cmdValueAdd"
Tab(0).Control(2).Enabled= 0 'False
Tab(0).Control(3)= "cmdcmdValueDel"
Tab(0).Control(3).Enabled= 0 'False
Tab(0).Control(4)= "cmdEx"
Tab(0).Control(4).Enabled= 0 'False
Tab(0).ControlCount= 5
TabCaption(1) = "代码类型维护"
TabPicture(1) = "frmInitnew.frx":001C
Tab(1).ControlEnabled= 0 'False
Tab(1).Control(0)= "Label23"
Tab(1).Control(0).Enabled= 0 'False
Tab(1).Control(1)= "Label22"
Tab(1).Control(1).Enabled= 0 'False
Tab(1).Control(2)= "Frame6"
Tab(1).Control(2).Enabled= 0 'False
Tab(1).Control(3)= "txtDMLX"
Tab(1).Control(3).Enabled= 0 'False
Tab(1).Control(4)= "txtDMLB"
Tab(1).Control(4).Enabled= 0 'False
Tab(1).Control(5)= "cmdAddLX"
Tab(1).Control(5).Enabled= 0 'False
Tab(1).Control(6)= "cmdClose"
Tab(1).Control(6).Enabled= 0 'False
Tab(1).ControlCount= 7
Begin VB.CommandButton cmdEx
Caption = "关 闭"
Height = 390
Left = 5160
TabIndex = 18
Top = 3810
Width = 1020
End
Begin VB.CommandButton cmdcmdValueDel
Caption = "删 除"
Height = 390
Left = 4005
TabIndex = 17
Top = 3810
Width = 1020
End
Begin VB.CommandButton cmdValueAdd
Caption = "添 加"
Height = 390
Left = 2820
TabIndex = 16
Top = 3810
Width = 1020
End
Begin VB.CommandButton cmdClose
Caption = "关 闭"
Height = 435
Left = -69810
TabIndex = 15
Top = 3795
Width = 945
End
Begin VB.CommandButton cmdAddLX
Caption = "添 加"
Height = 435
Left = -71370
TabIndex = 14
Top = 3795
Width = 945
End
Begin VB.TextBox txtDMLB
Appearance = 0 'Flat
BackColor = &H80000018&
Height = 330
Left = -74760
MaxLength = 20
TabIndex = 1
Top = 3930
Width = 645
End
Begin VB.TextBox txtDMLX
Appearance = 0 'Flat
BackColor = &H80000018&
Height = 330
Left = -73560
MaxLength = 20
TabIndex = 2
Top = 3930
Width = 1725
End
Begin VB.Frame Frame5
Height = 3105
Left = 150
TabIndex = 4
Top = 495
Width = 6720
Begin VB.CommandButton cmdRollParam
Caption = "导入代码"
Height = 375
Left = 4530
TabIndex = 8
ToolTipText = "把指定的文本文件中代码列表导入数据库中"
Top = 285
Width = 885
End
Begin VB.CommandButton cmdBakParam
Caption = "输出代码"
Height = 375
Left = 3390
TabIndex = 7
ToolTipText = "把数据库中代码列表输出到指定的文本文件中"
Top = 285
Width = 885
End
Begin VB.ListBox lstDM
BackColor = &H80000018&
Height = 2040
Left = 270
TabIndex = 6
Top = 840
Width = 5535
End
Begin VB.ComboBox cboDMlist
BackColor = &H80000018&
Height = 300
Left = 1365
TabIndex = 5
Text = "代码名称列表"
Top = 315
Width = 1575
End
Begin MSComDlg.CommonDialog CommonDialog1
Left = 0
Top = 0
_ExtentX = 847
_ExtentY = 847
_Version = 393216
End
Begin VB.Label Label18
BackStyle = 0 'Transparent
Caption = "代码类别"
Height = 240
Left = 285
TabIndex = 9
Top = 375
Width = 960
End
End
Begin VB.TextBox txtValue
Appearance = 0 'Flat
BackColor = &H80000018&
Height = 330
Left = 825
MaxLength = 20
TabIndex = 0
Top = 3855
Width = 1485
End
Begin VB.Frame Frame6
Caption = "代码类别"
Height = 3105
Left = -74835
TabIndex = 10
Top = 495
Width = 6705
Begin VB.ListBox lstDMLX
BackColor = &H80000018&
Height = 2580
Left = 630
TabIndex = 11
Top = 360
Width = 4815
End
End
Begin VB.Label Label22
BackStyle = 0 'Transparent
Caption = "代码类型"
Height = 255
Left = -74760
TabIndex = 13
Top = 3705
Width = 735
End
Begin VB.Label Label23
BackStyle = 0 'Transparent
Caption = "代码类别名称"
Height = 255
Left = -73560
TabIndex = 12
Top = 3705
Width = 1095
End
End
End
Attribute VB_Name = "frmInitnew"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Private Sub cmdAddLX_Click()
Dim rsList As ADODB.Recordset
Dim kk As Integer
On Error GoTo ErrAddLX
Set rsList = New ADODB.Recordset
rsList.Open "[parameters]", gCnn, adOpenStatic, adLockOptimistic, adCmdTable
rsList.AddNew
rsList("Paratype").Value = Val(txtDMLB.Text)
rsList("DESCRIPTION").Value = Trim(txtDMLX.Text)
rsList("ValueID").Value = 0
rsList("Value").Value = ""
rsList("ValueName") = ""
rsList("Alias") = ""
rsList.Update
Set rsList = Nothing
Call Form_Load
txtDMLB.Text = ""
txtDMLX.Text = ""
txtDMLB.SetFocus
Exit Sub
ErrAddLX:
MsgBox Err.Description, vbCritical, "系统提示"
Set rsList = Nothing
End Sub
Private Sub cmdEx_Click()
Unload Me
End Sub
Private Sub cmdValueAdd_Click()
Dim rsList As ADODB.Recordset
Dim I As Integer
On Error GoTo endlAdd
Set rsList = New ADODB.Recordset
If cboDMlist.Text = "部门1" Then '增加新的单位代码，见批文录入部分之‘新增批文’
rsList.Open "Select Max(BMBH) From BMXX", gCnn, adOpenStatic, adLockReadOnly
gCnn.Execute "Insert BMXX(BMBH,BMMC,BMJC,BMFZR) Values(" & Val(rsList.Fields(0).Value & "") + 1 & ",'" & Trim(txtValue.Text) & "','" & Left(Trim(txtValue.Text), 8) & "','FZR')"
Else
rsList.Open "Select top 1 ValueID, PARATYPE from [Parameters] where [DESCRIPTION]='" & Trim(cboDMlist.Text) & "' order by ValueID DESC", gCnn, adOpenStatic, adLockReadOnly
If rsList.Fields("ValueID").Value >= 32767 Then MsgBox "请联系管理员！更正后再试！", vbCritical, "系统提示": Set rsList = Nothing: Exit Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -