📄 main_xtwh_xtcsh.frm
字号:
VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCTL.OCX"
Begin VB.Form main_xtwh_xtcsh
BorderStyle = 1 'Fixed Single
Caption = "系统维护--【系统初始化】"
ClientHeight = 3660
ClientLeft = 2265
ClientTop = 3765
ClientWidth = 8580
Icon = "main_xtwh_xtcsh.frx":0000
LinkTopic = "Form1"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 3660
ScaleWidth = 8580
StartUpPosition = 1 '所有者中心
Begin VB.CommandButton Comks
Caption = "开始"
Height = 390
Left = 4065
TabIndex = 20
Top = 3165
Width = 1470
End
Begin MSComctlLib.ProgressBar ProgressBar1
Height = 360
Left = 105
TabIndex = 6
Top = 2715
Visible = 0 'False
Width = 8430
_ExtentX = 14870
_ExtentY = 635
_Version = 393216
Appearance = 1
End
Begin VB.CommandButton ComExit
Caption = "退出"
Height = 390
Left = 7035
TabIndex = 5
Top = 3165
Width = 1470
End
Begin VB.CommandButton Comcsh
Caption = "初始化"
Enabled = 0 'False
Height = 390
Left = 5550
TabIndex = 4
Top = 3165
Width = 1470
End
Begin VB.Frame Frame2
Caption = "各种单据"
Height = 1275
Left = 90
TabIndex = 3
Top = 1365
Width = 8430
Begin VB.CheckBox Check1
Caption = "包房消费临时表"
Height = 240
Index = 5
Left = 135
TabIndex = 21
Top = 360
Width = 1560
End
Begin VB.CheckBox Check1
Caption = "权限信息表"
Height = 240
Index = 14
Left = 6780
TabIndex = 19
Top = 780
Width = 1410
End
Begin VB.CheckBox Check1
Caption = "月消费单据表"
Height = 240
Index = 13
Left = 5085
TabIndex = 18
Top = 780
Width = 1410
End
Begin VB.CheckBox Check1
Caption = "月消费信息表"
Height = 240
Index = 12
Left = 3450
TabIndex = 17
Top = 780
Width = 1440
End
Begin VB.CheckBox Check1
Caption = "日消费单据表"
Height = 240
Index = 11
Left = 1815
TabIndex = 16
Top = 780
Width = 1410
End
Begin VB.CheckBox Check1
Caption = "日消费信息表"
Height = 240
Index = 10
Left = 135
TabIndex = 15
Top = 780
Width = 1590
End
Begin VB.CheckBox Check1
Caption = "历史消费单据表"
Height = 240
Index = 9
Left = 6690
TabIndex = 14
Top = 360
Width = 1590
End
Begin VB.CheckBox Check1
Caption = "历史消费信息表"
Height = 240
Index = 8
Left = 5040
TabIndex = 13
Top = 360
Width = 1755
End
Begin VB.CheckBox Check1
Caption = "临时消费信息表"
Height = 240
Index = 7
Left = 3375
TabIndex = 12
Top = 360
Width = 1755
End
Begin VB.CheckBox Check1
Caption = "包房消费历史表"
Height = 240
Index = 6
Left = 1755
TabIndex = 11
Top = 360
Width = 1560
End
End
Begin VB.Frame Frame1
Caption = "基础数据"
Height = 765
Left = 75
TabIndex = 1
Top = 450
Width = 8445
Begin VB.CheckBox Check1
Caption = "箱号信息表"
Height = 240
Index = 4
Left = 6660
TabIndex = 10
Top = 345
Width = 1215
End
Begin VB.CheckBox Check1
Caption = "消费项目价格表"
Height = 240
Index = 3
Left = 4785
TabIndex = 9
Top = 360
Width = 1575
End
Begin VB.CheckBox Check1
Caption = "员工信息表"
Height = 240
Index = 2
Left = 3225
TabIndex = 8
Top = 345
Width = 1215
End
Begin VB.CheckBox Check1
Caption = "包房信息表"
Height = 240
Index = 0
Left = 345
TabIndex = 7
Top = 345
Width = 1440
End
Begin VB.CheckBox Check1
Caption = "单据号表"
Height = 240
Index = 1
Left = 1875
TabIndex = 2
Top = 345
Width = 1065
End
End
Begin VB.Label Label1
BackStyle = 0 'Transparent
Caption = "注意：系统初始化将清空系统数据"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H000000FF&
Height = 285
Left = 210
TabIndex = 0
Top = 75
Width = 4830
End
End
Attribute VB_Name = "main_xtwh_xtcsh"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Form_Activate()
'设置窗体标题栏的内容
Me.Caption = Me.Caption & " 操作员： " & frm_main.St1.Panels(3).Text
End Sub
Private Sub Form_Unload(Cancel As Integer)
frm_main.Enabled = True
End Sub
Private Sub Comks_Click() '开始
Comcsh.Enabled = True
End Sub
Private Sub Comcsh_Click()
Dim rs As ADODB.Recordset '定义数据集对象
Set rs = New ADODB.Recordset
Dim cnn As ADODB.Connection '定义数据连接
Set cnn = New ADODB.Connection
cnn.Open "Provider=MSDASQL.1;Persist Security Info=False;User ID=sa;Data Source=XYGLXT;Initial Catalog=XYGLXT"
Dim connter As Integer '定义一个整型变量
Dim sql, workarea(200) As String '定义字符串变量
ProgressBar1.Visible = True
ProgressBar1.Max = UBound(workarea)
ProgressBar1.Value = ProgressBar1.Min
For Counter = LBound(workarea) To UBound(workarea)
workarea(Counter) = "initial value " & Counter
ProgressBar1.Value = Counter
'清空选定的表中的数据
If Check1(0).Value = 1 Then
sql = "delete 包房信息表 select * from 包房信息表 "
Set rs = cnn.Execute(sql)
End If
If Check1(1).Value = 1 Then
sql = "delete 单据号表 select * from 单据号表 "
Set rs = cnn.Execute(sql)
End If
If Check1(2).Value = 1 Then
sql = "delete 员工信息表 select * from 员工信息表"
Set rs = cnn.Execute(sql)
End If
If Check1(3).Value = 1 Then
sql = "delete 消费项目价格表 select * from 消费项目价格表"
Set rs = cnn.Execute(sql)
End If
If Check1(4).Value = 1 Then
sql = "delete 箱号信息表 select * from 箱号信息表"
Set rs = cnn.Execute(sql)
End If
If Check1(5).Value = 1 Then
sql = "delete 包房消费历史表 select * from 包房消费历史表"
Set rs = cnn.Execute(sql)
End If
If Check1(6).Value = 1 Then
sql = "delete 包房消费临时表 select * from 包房消费临时表"
Set rs = cnn.Execute(sql)
End If
If Check1(7).Value = 1 Then
sql = "delete 临时消费信息表 select * from 临时消费信息表"
Set rs = cnn.Execute(sql)
End If
If Check1(8).Value = 1 Then
sql = "delete 历史消费信息表 select * from 历史消费信息表"
Set rs = cnn.Execute(sql)
End If
If Check1(9).Value = 1 Then
sql = "delete 历史消费单据表 select * from 历史消费单据表"
Set rs = cnn.Execute(sql)
End If
If Check1(10).Value = 1 Then
sql = "delete 日消费信息表 select * from 日消费信息表"
Set rs = cnn.Execute(sql)
End If
If Check1(11).Value = 1 Then
sql = "delete 日消费单据表 select * from 日消费单据表"
Set rs = cnn.Execute(sql)
End If
If Check1(12).Value = 1 Then
sql = "delete 月消费信息表 select * from 月消费信息表"
Set rs = cnn.Execute(sql)
End If
If Check1(13).Value = 1 Then
sql = "delete 月消费单据表 select * from 月消费单据表"
Set rs = cnn.Execute(sql)
End If
If Check1(14).Value = 1 Then
sql = "delete 权限信息表 select * from 权限信息表"
Set rs = cnn.Execute(sql)
End If
Next Counter
ProgressBar1.Visible = False
ProgressBar1.Value = ProgressBar1.Min
cnn.Close
Comcsh.Enabled = False
End Sub
Private Sub ComExit_Click()
frm_main.Enabled = True
Unload Me
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -