【VB开源代码栏目提醒】：网学会员鉴于大家对VB开源代码十分关注，论文会员在此为大家搜集整理了“FrmDiscard.frm”一文，供大家参考学习

    VERSION 5.00
    Object = "{67397AA1-7FB1-11D0-B148-00A0C922E820}#6.0#0"; "msadodc.ocx"
    Object = "{CDE57A40-8B86-11D0-B3C6-00A0C90AEA82}#1.0#0"; "MSDatGrd.ocx"
    Begin VB.Form FrmDiscard 
       Caption         =   "设备报废申请管理"
       ClientHeight    =   4785
       ClientLeft      =   60
       ClientTop       =   345
       ClientWidth     =   8940
       LinkTopic       =   "Form1"
       ScaleHeight     =   4785
       ScaleWidth      =   8940
       StartUpPosition =   2  '屏幕中心
       Begin VB.CommandButton Cmd_Submit 
          Caption         =   "提 交"
          Height          =   375
          Left            =   5610
          TabIndex        =   8
          Top             =   4320
          Width           =   1095
       End
       Begin VB.CommandButton Cmd_Search 
          Caption         =   "查 找"
          Height          =   375
          Left            =   2520
          TabIndex        =   7
          Top             =   80
          Width           =   855
       End
       Begin VB.CommandButton Cmd_Exit 
          Caption         =   "退 出"
          Height          =   375
          Left            =   7320
          TabIndex        =   6
          Top             =   4320
          Width           =   1095
       End
       Begin VB.CommandButton Cmd_Del 
          Caption         =   "删 除"
          Height          =   375
          Left            =   3900
          TabIndex        =   5
          Top             =   4320
          Width           =   1095
       End
       Begin VB.CommandButton Cmd_Modi 
          Caption         =   "修 改"
          Height          =   375
          Left            =   2190
          TabIndex        =   4
          Top             =   4320
          Width           =   1095
       End
       Begin VB.CommandButton Cmd_Add 
          Caption         =   "申 请"
          Height          =   375
          Left            =   480
          TabIndex        =   3
          Top             =   4320
          Width           =   1095
       End
       Begin VB.TextBox txtName 
          Height          =   270
          Left            =   1200
          TabIndex        =   2
          Top             =   120
          Width           =   975
       End
       Begin MSAdodcLib.Adodc Adodc1 
          Height          =   375
          Left            =   0
          Top             =   4440
          Visible         =   0   'False
          Width           =   2055
          _ExtentX        =   3625
          _ExtentY        =   661
          ConnectMode     =   0
          CursorLocation  =   3
          IsolationLevel  =   -1
          ConnectionTimeout=   15
          CommandTimeout  =   30
          CursorType      =   3
          LockType        =   3
          CommandType     =   8
          CursorOptions   =   0
          CacheSize       =   50
          MaxRecords      =   0
          BOFAction       =   0
          EOFAction       =   0
          ConnectStringType=   1
          Appearance      =   1
          BackColor       =   -2147483643
          ForeColor       =   -2147483640
          Orientation     =   0
          Enabled         =   -1
          Connect         =   ""
          OLEDBString     =   ""
          OLEDBFile       =   ""
          DataSourceName  =   ""
          OtherAttributes =   ""
          UserName        =   ""
          Password        =   ""
          RecordSource    =   ""
          Caption         =   "Adodc1"
          BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
             Name            =   "宋体"
             Size            =   9
             Charset         =   134
             Weight          =   400
             Underline       =   0   'False
             Italic          =   0   'False
             Strikethrough   =   0   'False
          EndProperty
          _Version        =   393216
       End
       Begin MSDataGridLib.DataGrid DataGrid1 
          Height          =   3735
          Left            =   120
          TabIndex        =   0
          Top             =   480
          Width           =   8655
          _ExtentX        =   15266
          _ExtentY        =   6588
          _Version        =   393216
          AllowUpdate     =   0   'False
          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 
             MarqueeStyle    =   3
             AllowRowSizing  =   -1  'True
             AllowSizing     =   -1  'True
             BeginProperty Column00 
             EndProperty
             BeginProperty Column01 
             EndProperty
          EndProperty
       End
       Begin VB.Label Label1 
          AutoSize        =   -1  'True
          Caption         =   "设备名称"
          Height          =   180
          Left            =   240
          TabIndex        =   1
          Top             =   120
          Width           =   720
       End
    End
    Attribute VB_Name = "FrmDiscard"
    Attribute VB_GlobalNameSpace = False
    Attribute VB_Creatable = False
    Attribute VB_PredeclaredId = True
    Attribute VB_Exposed = False
    Public SchCnd As String
    Private Sub Cmd_Add_Click()
      '将Modify变量设置为False，表示当前状态为插入新记录
      FrmDiscardEdit.Modify = False
      '初始化FrmDiscardEdit信息
      FrmDiscardEdit.txtCreateDate = Date
      FrmDiscardEdit.txtUserName = Trim(CurUser.UserName)
      FrmDiscardEdit.txtId = ""
      FrmDiscardEdit.txtName = ""
      FrmDiscardEdit.txtModel = ""
      FrmDiscardEdit.txtTypeName = ""
      FrmDiscardEdit.txtUnit = ""
      FrmDiscardEdit.txtDCount = 1
      FrmDiscardEdit.txtDSum = 0
      FrmDiscardEdit.txtReason = ""
      FrmDiscardEdit.txtChecker = ""
      FrmDiscardEdit.txtChkDate = ""
      FrmDiscardEdit.txtResult = ""
      '启动编辑窗体
      FrmDiscardEdit.Show 1
      '刷新DataGrid表格的内容
      GridRefresh
    End Sub
    
    Private Sub Cmd_Del_Click()
      If Adodc1.Recordset.EOF = True Then
        MsgBox "请选择记录"
        Exit Sub
      End If
      If MsgBox("是否确定要删除 ", vbYesNo, "请确认") = vbNo Then
        Exit Sub
      End If
      MyDiscard.Delete (Adodc1.Recordset.Fields(0))
      GridRefresh
    End Sub
    
    Private Sub Cmd_Exit_Click()
      Unload Me
    End Sub
    
    Private Sub GridRefresh()
      If Len(Trim(txtName)) = 0 Then
        SchCnd = ""
      Els