sys_xtts.frm

基于SQL2000的企业管理MRPII,包含进销存,财务,报关等组件,VB6开发,带文档说明.

VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCTL.OCX"
Begin VB.Form sys_xtts 
   BorderStyle     =   3  'Fixed Dialog
   Caption         =   "系统数据整理"
   ClientHeight    =   1185
   ClientLeft      =   45
   ClientTop       =   330
   ClientWidth     =   5205
   Icon            =   "sys_xtts.frx":0000
   LinkTopic       =   "Form1"
   LockControls    =   -1  'True
   MaxButton       =   0   'False
   MinButton       =   0   'False
   Moveable        =   0   'False
   ScaleHeight     =   1185
   ScaleWidth      =   5205
   ShowInTaskbar   =   0   'False
   StartUpPosition =   2  '屏幕中心
   Begin VB.CommandButton Command2 
      Caption         =   "返回"
      Height          =   375
      Left            =   4440
      TabIndex        =   2
      Top             =   360
      Width           =   675
   End
   Begin VB.CommandButton Command1 
      Caption         =   "确认"
      Height          =   375
      Left            =   3690
      TabIndex        =   1
      Top             =   360
      Width           =   645
   End
   Begin MSComctlLib.ProgressBar ProgressBar1 
      Height          =   255
      Left            =   120
      Negotiate       =   -1  'True
      TabIndex        =   0
      Top             =   840
      Width           =   4995
      _ExtentX        =   8811
      _ExtentY        =   450
      _Version        =   393216
      Appearance      =   1
      Max             =   1000
   End
   Begin VB.Label L1 
      Height          =   225
      Left            =   150
      TabIndex        =   4
      Top             =   150
      Width           =   5025
   End
   Begin VB.Label Label1 
      Caption         =   "系统优化进度提示:"
      Height          =   195
      Left            =   150
      TabIndex        =   3
      Top             =   630
      Width           =   1875
   End
End
Attribute VB_Name = "sys_xtts"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim clsj As Recordset
Private Sub Command1_Click()
L1.Caption = "请稍候,正在处理数据.........."
L1.Refresh
Dim CP_bH As String
Dim i As Integer
Me.Refresh
Set clsj = New Recordset
clsj.Open "select * from yy_khzl", DB, adOpenStatic
clsj.ActiveConnection.Execute "delete from yy_khzl where khbh is null or khmc is null"
ProgressBar1.Value = 400
clsj.ActiveConnection.Execute "delete from yy_cpxsdt where xsfph is null or khbh is null"
ProgressBar1.Value = 800
clsj.ActiveConnection.Execute "delete from yy_cpxsd where xsfph is null or khbh is null"

ProgressBar1.Value = 1000


L1.Caption = "数据处理完毕!欢迎定期优化,可排除录入错误!"
L1.Refresh
ProgressBar1.Value = 0
End Sub

Private Sub Command1_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
L1.Caption = "请稍候.........."
L1.Refresh
End Sub

Private Sub Command2_Click()
Unload Me
End Sub