📄 cleardb.frm
字号:
VERSION 5.00
Object = "{D07CD9D2-ECE9-493F-86F2-186659945889}#1.0#0"; "Xpbutton.ocx"
Object = "{625E61B9-D59C-4612-89FC-D10614DC5873}#1.0#0"; "CoolBoySkin1.2(修正版).ocx"
Begin VB.Form cleardb
BackColor = &H00FFFFFF&
BorderStyle = 0 'None
Caption = "神龙科技(网吧库管)"
ClientHeight = 4020
ClientLeft = 0
ClientTop = 0
ClientWidth = 5130
LinkTopic = "Form1"
LockControls = -1 'True
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 4020
ScaleWidth = 5130
ShowInTaskbar = 0 'False
StartUpPosition = 2 '屏幕中心
Begin 工程1.xpcmdbutton xpcmdbutton2
Height = 375
Left = 3345
TabIndex = 9
Top = 3135
Width = 1020
_ExtentX = 1799
_ExtentY = 661
Caption = "取消"
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
End
Begin VB.CheckBox Check6
BackColor = &H80000009&
Caption = "临时表"
Height = 285
Left = 825
TabIndex = 8
Top = 3375
Width = 2085
End
Begin 工程1.xpcmdbutton xpcmdbutton1
Height = 420
Left = 3360
TabIndex = 7
Top = 2595
Width = 960
_ExtentX = 1693
_ExtentY = 741
Caption = "清 除"
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
End
Begin VB.CheckBox Check5
BackColor = &H80000009&
Caption = "商品信息表"
Height = 240
Left = 825
TabIndex = 4
Top = 2925
Width = 2100
End
Begin VB.CheckBox Check4
BackColor = &H80000009&
Caption = "库存表"
Height = 450
Left = 825
TabIndex = 3
Top = 2265
Width = 1725
End
Begin VB.CheckBox Check3
BackColor = &H80000009&
Caption = "领出表"
Height = 300
Left = 825
TabIndex = 2
Top = 1740
Width = 1650
End
Begin VB.CheckBox Check2
BackColor = &H80000009&
Caption = "入库表"
Height = 225
Left = 825
TabIndex = 1
Top = 1305
Width = 1785
End
Begin VB.CheckBox Check1
BackColor = &H80000009&
Caption = "用户表"
Height = 270
Left = 825
TabIndex = 0
Top = 825
Width = 2145
End
Begin CoolBoySkinForVB6.CoolBoySkin CoolBoySkin1
Height = 1845
Left = 585
TabIndex = 10
Top = 225
Width = 3405
_ExtentX = 6006
_ExtentY = 3254
Caption = "神龙科技(网吧库管)"
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "Arial"
Size = 9.75
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
MenuBackColor = 16777215
End
Begin VB.Shape Shape1
BackColor = &H000000FF&
BorderColor = &H000000FF&
Height = 3165
Left = 330
Top = 570
Width = 4545
End
Begin VB.Label Label2
BackStyle = 0 'Transparent
Caption = "此部工作将清除所有数据，而且不能恢复，请慎重操作"
ForeColor = &H000000FF&
Height = 1155
Left = 2925
TabIndex = 6
Top = 1260
Width = 1860
End
Begin VB.Label Label1
BackStyle = 0 'Transparent
Caption = "注意："
ForeColor = &H000000FF&
Height = 285
Left = 3165
TabIndex = 5
Top = 810
Width = 1785
End
End
Attribute VB_Name = "cleardb"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Form_Load()
loaddb
frmbb.Enabled = False
End Sub
Private Sub Form_Unload(Cancel As Integer)
frmbb.Enabled = True
End Sub
Private Sub xpcmdbutton1_Click()
If Check1.Value Then
If rs.State Then rs.Close
rs.Open "delete [user] where username not in ('管理员') DWS='" & gsname & "'", cn, 3, 3
End If
If Check2.Value Then
If rs.State Then rs.Close
rs.Open "delete rk WHERE DWS='" & gsname & "'", cn, 3, 3
End If
If Check3.Value Then
If rs.State Then rs.Close
rs.Open "delete ck WHERE DWS='" & gsname & "'", cn, 3, 3
End If
If Check4.Value Then
If rs.State Then rs.Close
rs.Open "delete spkc WHERE DWS='" & gsname & "'", cn, 3, 3
End If
If Check5.Value Then
If rs.State Then rs.Close
rs.Open "delete spxx WHERE DWS='" & gsname & "'", cn, 3, 3
End If
If Check6.Value Then
If rs.State Then rs.Close
rs.Open "delete mytabel WHERE DWS='" & gsname & "'", cn, 3, 3
End If
If rs.State Then rs.Close
loaddb
MsgBox "数据清理完成！确定后重新登录系统", vbInformation + vbOKOnly, "清理数据"
End
End Sub
Public Sub loaddb()
If rs.State Then rs.Close
rs.Open "select count(*) from [user] WHERE DWS='" & gsname & "'", cn, 1, 1
Check1.Caption = "用户表 (" & rs.Fields(0).Value - 1 & ")"
If rs.State Then rs.Close
rs.Open "select count(*) from rk WHERE DWS='" & gsname & "'", cn, 1, 1
Check2.Caption = "入库表 (" & rs.Fields(0).Value & ")"
If rs.State Then rs.Close
rs.Open "select count(*) from ck WHERE DWS='" & gsname & "'", cn, 1, 1
Check3.Caption = "领出表 (" & rs.Fields(0).Value & ")"
If rs.State Then rs.Close
rs.Open "select count(*) from spkc WHERE DWS='" & gsname & "'", cn, 1, 1
Check4.Caption = "库存表 (" & rs.Fields(0).Value & ")"
If rs.State Then rs.Close
rs.Open "select count(*) from spxx WHERE DWS='" & gsname & "'", cn, 1, 1
Check5.Caption = "商品信息表 (" & rs.Fields(0).Value & ")"
If rs.State Then rs.Close
rs.Open "select count(*) from mytabel WHERE DWS='" & gsname & "'", cn, 1, 1
Check6.Caption = "临时表 (" & rs.Fields(0).Value & ")"
End Sub
Private Sub xpcmdbutton2_Click()
Unload Me
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -