📄 sys_xtyh.frm
字号:
VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCTL.OCX"
Begin VB.Form Sys_XTYh
BorderStyle = 3 'Fixed Dialog
Caption = "系统数据库优化处理"
ClientHeight = 2730
ClientLeft = 45
ClientTop = 330
ClientWidth = 5865
Icon = "Sys_Xtyh.frx":0000
LinkTopic = "Form1"
MaxButton = 0 'False
MinButton = 0 'False
Moveable = 0 'False
ScaleHeight = 2730
ScaleWidth = 5865
ShowInTaskbar = 0 'False
StartUpPosition = 2 '屏幕中心
Begin VB.PictureBox Picture1
Appearance = 0 'Flat
BackColor = &H8000000B&
BorderStyle = 0 'None
ForeColor = &H80000008&
Height = 615
Left = 120
Picture = "Sys_Xtyh.frx":030A
ScaleHeight = 615
ScaleWidth = 615
TabIndex = 5
Top = 240
Width = 615
End
Begin VB.CommandButton Command2
Caption = "退出"
BeginProperty Font
Name = "宋体"
Size = 11.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 435
Left = 4800
TabIndex = 2
Top = 1830
Width = 885
End
Begin VB.CommandButton Command1
Caption = "优化"
BeginProperty Font
Name = "宋体"
Size = 11.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 435
Left = 3870
TabIndex = 1
Top = 1830
Width = 885
End
Begin MSComctlLib.ProgressBar ProgressBar1
Height = 255
Left = 30
Negotiate = -1 'True
TabIndex = 0
Top = 2370
Width = 5835
_ExtentX = 10292
_ExtentY = 450
_Version = 393216
Appearance = 1
End
Begin VB.Label L1
Caption = "注：定期优化数据可以，改正录入错误，增强系统稳定性。"
BeginProperty Font
Name = "宋体"
Size = 11.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00000000&
Height = 465
Left = 960
TabIndex = 4
Top = 480
Width = 4665
End
Begin VB.Label Label1
Caption = "优化进程提示:"
BeginProperty Font
Name = "宋体"
Size = 11.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H8000000D&
Height = 315
Left = 90
TabIndex = 3
Top = 1950
Width = 1635
End
End
Attribute VB_Name = "Sys_XTYh"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
Me.Refresh
ProgressBar1.Max = 1000
L1.Caption = "正在整理数据.......... "
L1.Refresh
Dim clsj As Recordset
Set clsj = New Recordset
clsj.Open "select * from sys_gzry", DB, adOpenStatic
clsj.ActiveConnection.Execute "delete from sys_gzry where name='' or name is null"
ProgressBar1.Value = 50
clsj.ActiveConnection.Execute "delete from sys_bmsz where bmmc is null or bmmc=''"
clsj.ActiveConnection.Execute "delete from sys_gsmc where yymc is null or yymc='' or jybm is null or jybm=''"
ProgressBar1.Value = 100
clsj.ActiveConnection.Execute "delete from ck_cprk_h where rkdh is null or rkdh=''"
clsj.ActiveConnection.Execute "delete from ck_cprk_b where rkdh not in(select distinct rkdh from ck_cprk_h)"
clsj.ActiveConnection.Execute "delete from ck_bcprk_h where rkdh is null or rkdh=''"
clsj.ActiveConnection.Execute "delete from ck_bcprk_B where rkdh not in(select distinct rkdh from ck_bcprk_h)"
clsj.ActiveConnection.Execute "delete from ck_ccprk_h where rkdh is null or rkdh=''"
clsj.ActiveConnection.Execute "delete from ck_ccprk_b where rkdh not in(select distinct rkdh from ck_ccprk_h)"
ProgressBar1.Value = 200
clsj.ActiveConnection.Execute "delete from ck_ylrk_h where rkdh is null or rkdh=''"
clsj.ActiveConnection.Execute "delete from ck_ylrk_B where rkdh not in(select distinct rkdh from ck_ylrk_h)"
ProgressBar1.Value = 600
clsj.ActiveConnection.Execute "delete from ck_ylck_h where ckdh is null or ckdh=''"
clsj.ActiveConnection.Execute "delete from ck_ylck_B where ckdh not in(select distinct ckdh from ck_ylck_h)"
clsj.ActiveConnection.Execute "delete from ck_cpck_h where ckdh is null or ckdh=''"
clsj.ActiveConnection.Execute "delete from ck_cpck_B where ckdh not in(select distinct ckdh from ck_cpck_h)"
ProgressBar1.Value = 800
clsj.ActiveConnection.Execute "delete from ck_ccpck_h where ckdh is null or ckdh=''"
clsj.ActiveConnection.Execute "delete from ck_ccpck_B where ckdh not in(select distinct ckdh from ck_ccpck_h)"
clsj.ActiveConnection.Execute "delete from ck_bcpck_h where ckdh is null or ckdh=''"
clsj.ActiveConnection.Execute "delete from ck_bcpck_B where ckdh not in(select distinct ckdh from ck_bcpck_h)"
ProgressBar1.Value = 1000
clsj.ActiveConnection.Execute "delete from sys_jldw where jldw='' or jldw is null"
clsj.ActiveConnection.Execute "delete from yy_bzdj where cpbh is null or cpbh=''"
clsj.ActiveConnection.Execute "delete from yy_bzdj_B where cpbh not in(select distinct cpbh from yy_bzdj)"
clsj.ActiveConnection.Execute "delete from sys_ylmc_h where cpbh is null or cpbh=''"
clsj.ActiveConnection.Execute "delete from sys_ylmc_B where cpbh not in(select distinct cpbh from sys_ylmc_H)"
L1.Caption = "系统优化处理完毕！欢迎使用。"
ProgressBar1.Value = 0
End Sub
Private Sub Command1_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
L1.Caption = "请稍侯.........."
End Sub
Private Sub Command2_Click()
Unload Me
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -