📄 frm_sjql.frm

📁 固定资产及设备管理系统
💻 FRM
📖 第 1 页 / 共 3 页
字号:
上一页 1 23
         Strikethrough   =   0   'False
      EndProperty
      ColumnCount     =   2
      BeginProperty Column00 
         DataField       =   ""
         Caption         =   ""
         BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED} 
            Type            =   0
            Format          =   ""
            HaveTrueFalseNull=   0
            FirstDayOfWeek  =   0
            FirstWeekOfYear =   0
            LCID            =   2052
            SubFormatType   =   0
         EndProperty
      EndProperty
      BeginProperty Column01 
         DataField       =   ""
         Caption         =   ""
         BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED} 
            Type            =   0
            Format          =   ""
            HaveTrueFalseNull=   0
            FirstDayOfWeek  =   0
            FirstWeekOfYear =   0
            LCID            =   2052
            SubFormatType   =   0
         EndProperty
      EndProperty
      SplitCount      =   1
      BeginProperty Split0 
         BeginProperty Column00 
         EndProperty
         BeginProperty Column01 
         EndProperty
      EndProperty
   End
   Begin VB.Frame Frame2 
      Height          =   735
      Left            =   120
      TabIndex        =   5
      Top             =   2040
      Width           =   7095
      Begin VB.CommandButton Command2 
         Caption         =   "取消"
         Height          =   375
         Left            =   5880
         TabIndex        =   8
         Top             =   240
         Width           =   975
      End
      Begin VB.CommandButton Command1 
         Caption         =   "开始清理"
         Height          =   375
         Left            =   4680
         TabIndex        =   7
         Top             =   240
         Width           =   1095
      End
      Begin VB.Label Label1 
         BackColor       =   &H00FFC0FF&
         BackStyle       =   0  'Transparent
         Caption         =   "当前状态： 未清理"
         ForeColor       =   &H00C000C0&
         Height          =   375
         Left            =   240
         TabIndex        =   6
         Top             =   240
         Width           =   4335
      End
   End
   Begin VB.Frame Frame1 
      Caption         =   "数据清理平台"
      Height          =   1935
      Left            =   120
      TabIndex        =   0
      Top             =   120
      Width           =   7095
      Begin VB.OptionButton Option5 
         Caption         =   "清理资产/设备折旧信息表"
         Height          =   375
         Left            =   3480
         TabIndex        =   17
         Top             =   840
         Width           =   2655
      End
      Begin VB.OptionButton Option4 
         Caption         =   "清理资产/设备借出归还、信息表"
         Height          =   375
         Left            =   480
         TabIndex        =   4
         Top             =   1440
         Width           =   3000
      End
      Begin VB.OptionButton Option3 
         Caption         =   "清理资产/设备移动信息表"
         Height          =   375
         Left            =   3480
         TabIndex        =   3
         Top             =   300
         Width           =   3135
      End
      Begin VB.OptionButton Option2 
         Caption         =   "清理资产/设备维修信息表"
         Height          =   255
         Left            =   480
         TabIndex        =   2
         Top             =   920
         Width           =   3015
      End
      Begin VB.OptionButton Option1 
         Caption         =   "清理资产/设备基本信息表"
         Height          =   375
         Left            =   480
         TabIndex        =   1
         Top             =   300
         Width           =   2895
      End
   End
   Begin MSDataGridLib.DataGrid DataGrid4 
      Bindings        =   "frm_SJQL.frx":0054
      Height          =   3405
      Left            =   120
      TabIndex        =   12
      Top             =   2880
      Visible         =   0   'False
      Width           =   7095
      _ExtentX        =   12515
      _ExtentY        =   6006
      _Version        =   393216
      HeadLines       =   1
      RowHeight       =   15
      BeginProperty HeadFont {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
         Name            =   "宋体"
         Size            =   9
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
         Name            =   "宋体"
         Size            =   9
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ColumnCount     =   2
      BeginProperty Column00 
         DataField       =   ""
         Caption         =   ""
         BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED} 
            Type            =   0
            Format          =   ""
            HaveTrueFalseNull=   0
            FirstDayOfWeek  =   0
            FirstWeekOfYear =   0
            LCID            =   2052
            SubFormatType   =   0
         EndProperty
      EndProperty
      BeginProperty Column01 
         DataField       =   ""
         Caption         =   ""
         BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED} 
            Type            =   0
            Format          =   ""
            HaveTrueFalseNull=   0
            FirstDayOfWeek  =   0
            FirstWeekOfYear =   0
            LCID            =   2052
            SubFormatType   =   0
         EndProperty
      EndProperty
      SplitCount      =   1
      BeginProperty Split0 
         BeginProperty Column00 
         EndProperty
         BeginProperty Column01 
         EndProperty
      EndProperty
   End
End
Attribute VB_Name = "frm_SJQL"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim a
Private Sub Command1_Click()
If Option1.Value = True Then
a = MsgBox("确认要清除当前记录表中的记录么?", 49, "通用固定资产及设备管理系统")
If a = vbOK Then
If Text1.Text = "" Then
MsgBox "当前表中的记录已经为空,已经无记录可删除"
Else
Adodc1.Recordset.MoveFirst
Do While Adodc1.Recordset.EOF = False
Label1.Caption = "当前状态：正在删除资产或设备名称为 " + Text1.Text + " 的记录"
Adodc1.Recordset.Delete
Adodc1.Recordset.MoveNext
Loop

a = MsgBox("当前数据表的记录已经清理完成", 48, "通用固定资产及设备管理系统")
End If
Else
End If
ElseIf Option2.Value = True Then
a = MsgBox("确认要清除当前记录表中的记录么?", 49, "通用固定资产及设备管理系统")
If a = vbOK Then
If Text2.Text = "" Then
MsgBox "当前表中的记录已经为空,已经无记录可删除"
Else
Adodc2.Recordset.MoveFirst
Do While Adodc2.Recordset.EOF = False
Label1.Caption = "当前状态：正在删除资产或设备名称为 " + Text2.Text + "的记录"
Adodc2.Recordset.Delete
Adodc2.Recordset.MoveNext
Loop
a = MsgBox("当前数据表的记录已经清理完成", 48, "通用固定资产及设备管理系统")
End If
Else
End If
ElseIf Option3.Value = True Then
a = MsgBox("确认要清除当前记录表中的记录么?", 49, "通用固定资产及设备管理系统")
If a = vbOK Then
If Text3.Text = "" Then
MsgBox "当前表中的记录已经为空,已经无记录可删除"
Else
Adodc3.Recordset.MoveFirst
Do While Adodc3.Recordset.EOF = False
Label1.Caption = "当前状态：正在删除资产或设备名称为 " + Text3.Text + "的记录"
Adodc3.Recordset.Delete
Adodc3.Recordset.MoveNext
Loop
a = MsgBox("当前数据表的记录已经清理完成", 48, "通用固定资产及设备管理系统")
End If
Else
End If
ElseIf Option4.Value = True Then
a = MsgBox("确认要清除当前记录表中的记录么?", 49, "通用固定资产及设备管理系统")
If a = vbOK Then
If Text4.Text = "" Then
MsgBox "当前表中的记录已经为空,已经无记录可删除"
Else
Adodc4.Recordset.MoveFirst
Do While Adodc4.Recordset.EOF = False
Label1.Caption = "当前状态：正在删除资产或设备名称为 " + Text4.Text + "的记录"
Adodc4.Recordset.Delete
Adodc4.Recordset.MoveNext
Loop
a = MsgBox("当前数据表的记录已经清理完成", 48, "通用固定资产及设备管理系统")
End If
Else
End If
ElseIf Option5.Value = True Then
a = MsgBox("确认要清除当前记录表中的记录么?", 49, "通用固定资产及设备管理系统")
If a = vbOK Then
If Text5.Text = "" Then
MsgBox "当前表中的记录已经为空,已经无记录可删除"
Else
Adodc5.Recordset.MoveFirst
Do While Adodc5.Recordset.EOF = False
Label1.Caption = "当前状态：正在删除资产或设备名称为 " + Text5.Text + "的记录"
Adodc5.Recordset.Delete
Adodc5.Recordset.MoveNext
Loop
a = MsgBox("当前数据表的记录已经清理完成", 48, "通用固定资产及设备管理系统")
End If
Else
End If
Else
End If
Label1.Caption = "当前状态： 未删除"
Adodc1.Refresh
Adodc2.Refresh
Adodc3.Refresh
Adodc4.Refresh
End Sub

Private Sub Command2_Click()
frm_SJQL.Hide
End Sub

Private Sub Form_Activate()
Adodc1.Refresh
Adodc2.Refresh
Adodc3.Refresh
Adodc4.Refresh
Adodc5.Refresh
End Sub

Private Sub Option1_Click()
DataGrid1.Visible = True
DataGrid2.Visible = False
DataGrid3.Visible = False
DataGrid4.Visible = False
DataGrid5.Visible = False
End Sub

Private Sub Option2_Click()
DataGrid1.Visible = False
DataGrid2.Visible = True
DataGrid3.Visible = False
DataGrid4.Visible = False
DataGrid5.Visible = False
End Sub

Private Sub Option3_Click()
DataGrid1.Visible = False
DataGrid2.Visible = False
DataGrid3.Visible = True
DataGrid4.Visible = False
DataGrid5.Visible = False
End Sub

Private Sub Option4_Click()
DataGrid1.Visible = False
DataGrid2.Visible = False
DataGrid3.Visible = False
DataGrid4.Visible = True
DataGrid5.Visible = False
End Sub

Private Sub Option5_Click()
DataGrid1.Visible = False
DataGrid2.Visible = False
DataGrid3.Visible = False
DataGrid4.Visible = False
DataGrid5.Visible = True
End Sub
上一页 1 23
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -