📄 main_xtsz_xtcsh.frm
字号:
VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCTL.OCX"
Begin VB.Form main_xtsz_xtcsh
BorderStyle = 1 'Fixed Single
Caption = "系统设置-【系统初始化】"
ClientHeight = 3255
ClientLeft = 2265
ClientTop = 3765
ClientWidth = 7830
Icon = "main_xtsz_xtcsh.frx":0000
LinkTopic = "Form1"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 3255
ScaleWidth = 7830
StartUpPosition = 1 '所有者中心
Begin VB.CommandButton CmdStart
Caption = "开始"
Height = 390
Left = 900
TabIndex = 15
Top = 2760
Width = 1995
End
Begin MSComctlLib.ProgressBar ProgressBar1
Height = 360
Left = 75
TabIndex = 6
Top = 2280
Visible = 0 'False
Width = 7680
_ExtentX = 13547
_ExtentY = 635
_Version = 393216
Appearance = 1
End
Begin VB.CommandButton ComExit
Caption = "退出"
Height = 390
Left = 4890
TabIndex = 5
Top = 2760
Width = 1995
End
Begin VB.CommandButton Comcsh
Caption = "初始化"
Enabled = 0 'False
Height = 390
Left = 2895
TabIndex = 4
Top = 2760
Width = 1995
End
Begin VB.Frame Frame2
Caption = "各种单据"
Height = 765
Left = 75
TabIndex = 3
Top = 1365
Width = 7680
Begin VB.CheckBox Check1
Caption = "客户账款信息"
Height = 240
Index = 6
Left = 5175
TabIndex = 21
Top = 360
Width = 1410
End
Begin VB.CheckBox Check1
Caption = "销售退货信息"
Height = 240
Index = 5
Left = 3450
TabIndex = 20
Top = 360
Width = 1410
End
Begin VB.CheckBox Check1
Caption = "销售单据信息"
Height = 240
Index = 4
Left = 1785
TabIndex = 19
Top = 360
Width = 1410
End
Begin VB.CheckBox Check1
Caption = "销售信息"
Height = 240
Index = 3
Left = 495
TabIndex = 18
Top = 360
Width = 1410
End
Begin VB.CheckBox Check1
Caption = "报溢票号"
Height = 240
Index = 16
Left = 4980
TabIndex = 17
Top = 1440
Visible = 0 'False
Width = 1200
End
Begin VB.CheckBox Check1
Caption = "报溢单"
Height = 240
Index = 15
Left = 3975
TabIndex = 16
Top = 1425
Visible = 0 'False
Width = 1200
End
Begin VB.CheckBox Check1
Caption = "报损票号"
Height = 240
Index = 14
Left = 2805
TabIndex = 14
Top = 1425
Visible = 0 'False
Width = 1200
End
Begin VB.CheckBox Check1
Caption = "退货返厂票号"
Height = 240
Index = 13
Left = 315
TabIndex = 13
Top = 1425
Visible = 0 'False
Width = 1410
End
Begin VB.CheckBox Check1
Caption = "报损单"
Height = 240
Index = 12
Left = 1815
TabIndex = 12
Top = 1425
Visible = 0 'False
Width = 870
End
Begin VB.CheckBox Check1
Caption = "退货返厂"
Height = 240
Index = 11
Left = 6000
TabIndex = 11
Top = 1410
Visible = 0 'False
Width = 1050
End
Begin VB.CheckBox Check1
Caption = "销售退货票号"
Height = 240
Index = 8
Left = 3420
TabIndex = 10
Top = 1275
Visible = 0 'False
Width = 1890
End
Begin VB.CheckBox Check1
Caption = "销售退单"
Height = 240
Index = 7
Left = 2235
TabIndex = 9
Top = 1275
Visible = 0 'False
Width = 1065
End
End
Begin VB.Frame Frame1
Caption = "基础数据"
Height = 765
Left = 75
TabIndex = 1
Top = 450
Width = 7680
Begin VB.CheckBox Check1
Caption = "客户基本信息"
Height = 240
Index = 2
Left = 4620
TabIndex = 8
Top = 345
Width = 1410
End
Begin VB.CheckBox Check1
Caption = "商品基本信息"
Height = 240
Index = 0
Left = 540
TabIndex = 7
Top = 345
Width = 1440
End
Begin VB.CheckBox Check1
Caption = "销售员基本信息"
Height = 240
Index = 1
Left = 2490
TabIndex = 2
Top = 345
Width = 2085
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_xtsz_xtcsh"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Form_Unload(Cancel As Integer)
frm_main.Enabled = True
End Sub
Private Sub CmdStart_Click() '开始
Comcsh.Enabled = True
End Sub
Private Sub Comcsh_Click()
Dim rs As New ADODB.Recordset '定义数据集对象
Dim Cnn As New ADODB.Connection '定义数据连接
Dim connter As Integer '定义一个整型变量
Dim sql, workarea(200) As String '定义字符串变量
Cnn.Open "Provider=MSDASQL.1;Persist Security Info=False;User ID=sa;Data Source=xsgl;Initial Catalog=xsgl"
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 from 商品信息表 "
Set rs = Cnn.Execute(sql)
End If
If Check1(1).Value = 1 Then
sql = "delete from 销售人员信息表"
Set rs = Cnn.Execute(sql)
End If
If Check1(2).Value = 1 Then
sql = "delete from 客户信息表"
Set rs = Cnn.Execute(sql)
End If
If Check1(3).Value = 1 Then
sql = "delete from 销售信息表"
Set rs = Cnn.Execute(sql)
End If
If Check1(4).Value = 1 Then
sql = "delete from 销售单据信息表"
Set rs = Cnn.Execute(sql)
End If
If Check1(5).Value = 1 Then
sql = "delete from 销售退货信息表"
Set rs = Cnn.Execute(sql)
End If
If Check1(6).Value = 1 Then
sql = "delete 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()
Call CmdEnd(Me)
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -