main_xtgl_sjcsh.frm
来自「商品进销存管理系统 采用VB和SQL2000开发 具有很强的实用性」· FRM 代码 · 共 236 行
FRM
236 行
VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCTL.OCX"
Begin VB.Form main_xtgl_sjcsh
BorderStyle = 3 'Fixed Dialog
Caption = "系统管理-【数据初始化】"
ClientHeight = 3495
ClientLeft = 2265
ClientTop = 3765
ClientWidth = 8640
Icon = "main_xtgl_sjcsh.frx":0000
LinkTopic = "Form1"
LockControls = -1 'True
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 3495
ScaleWidth = 8640
ShowInTaskbar = 0 'False
StartUpPosition = 1 '所有者中心
Tag = "数据初始化"
Begin VB.CommandButton cmdStart
Caption = "开始"
Height = 390
Left = 3780
TabIndex = 13
Top = 2895
Width = 1470
End
Begin MSComctlLib.ProgressBar ProgressBar1
Height = 360
Left = 120
TabIndex = 6
Top = 2340
Visible = 0 'False
Width = 8430
_ExtentX = 14870
_ExtentY = 635
_Version = 393216
Appearance = 1
End
Begin VB.CommandButton cmdExit
Caption = "退出"
Height = 390
Left = 6750
TabIndex = 5
Top = 2895
Width = 1470
End
Begin VB.CommandButton cmdIniti
Caption = "初始化"
Enabled = 0 'False
Height = 390
Left = 5265
TabIndex = 4
Top = 2895
Width = 1470
End
Begin VB.Frame Frame2
Caption = "各种单据"
Height = 765
Left = 75
TabIndex = 3
Top = 1320
Width = 8445
Begin VB.CheckBox Check1
Caption = "库存信息"
Height = 240
Index = 8
Left = 5595
TabIndex = 14
Top = 360
Width = 1410
End
Begin VB.CheckBox Check1
Caption = "入库退单"
Height = 240
Index = 7
Left = 4170
TabIndex = 12
Top = 360
Width = 1125
End
Begin VB.CheckBox Check1
Caption = "入库单"
Height = 240
Index = 6
Left = 3030
TabIndex = 11
Top = 360
Width = 855
End
Begin VB.CheckBox Check1
Caption = "销售单"
Height = 240
Index = 4
Left = 420
TabIndex = 10
Top = 360
Width = 885
End
Begin VB.CheckBox Check1
Caption = "销售退单"
Height = 240
Index = 5
Left = 1635
TabIndex = 9
Top = 360
Width = 1410
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 = 3
Left = 3750
TabIndex = 8
Top = 330
Width = 1410
End
Begin VB.CheckBox Check1
Caption = "供应商信息管理"
Height = 240
Index = 2
Left = 2040
TabIndex = 7
Top = 330
Width = 1890
End
Begin VB.CheckBox Check1
Caption = "员工信息管理"
Height = 240
Index = 1
Left = 390
TabIndex = 2
Top = 330
Width = 1410
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_xtgl_sjcsh"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'*************************************************************************
'**模 块 名:main_xtgl_sjcsh
'**版权说明:吉林省明日科技有限公司享有本软件的所有版权,如果本软件用于商
'** 业用途,必须经过吉林省明日科技有限公司授权。如果提供网上免费
'** 下载,必须经过吉林省明日科技有限公司授权,并保证程序的完整,
'** 不得修改代码、注释和相关内容,否则,我公司将追究其法律责任
'**网 址:www.mingrisoft.com 价值无限,服务无限
'**电 话:(0431)84978981,84978982
'**创 建 人:明日科技
'**日 期:2007-10-31
'**修 改 人:MRLBB
'**日 期:2007-10-31
'**描 述:
'*************************************************************************
Private Sub cmdStart_Click() '开始
cmdIniti.Enabled = True
End Sub
Private Sub cmdIniti_Click()
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
'清空选定的表中的数据tb_bank
' If Check1(0).Value = 1 Then
' Cnn.Execute ("delete from tb_myunits")
' End If
If Check1(1).Value = 1 Then
Cnn.Execute ("delete from tb_employe")
End If
If Check1(2).Value = 1 Then
Cnn.Execute ("delete from tb_gys")
End If
If Check1(3).Value = 1 Then
Cnn.Execute ("delete from tb_kh")
End If
If Check1(4).Value = 1 Then
Cnn.Execute ("delete from tb_xsd")
End If
If Check1(5).Value = 1 Then
Cnn.Execute ("delete from tb_xstd")
End If
If Check1(6).Value = 1 Then
Cnn.Execute ("delete from tb_rkd")
End If
If Check1(7).Value = 1 Then
Cnn.Execute ("delete from tb_rktd")
End If
If Check1(8).Value = 1 Then
Cnn.Execute ("delete from tb_kc")
End If
Next Counter
ProgressBar1.Visible = False
ProgressBar1.Value = ProgressBar1.Min
cmdIniti.Enabled = False
RegInfo Me
End Sub
Private Sub cmdExit_Click()
Unload Me
End Sub
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?