frmdiscardedit.frm

银行设备管理系统,采用VB+SQL实现,包含源程序及数据库备份,完美运行,完整无缺.

VERSION 5.00
Object = "{86CF1D34-0C5F-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCT2.OCX"
Begin VB.Form FrmDiscardEdit 
   Caption         =   "编辑设备报废信息"
   ClientHeight    =   4755
   ClientLeft      =   60
   ClientTop       =   345
   ClientWidth     =   5910
   LinkTopic       =   "Form1"
   ScaleHeight     =   4755
   ScaleWidth      =   5910
   StartUpPosition =   2  '屏幕中心
   Begin VB.Frame Frame1 
      Caption         =   "设备信息"
      Height          =   1695
      Left            =   120
      TabIndex        =   10
      Top             =   600
      Width           =   5655
      Begin VB.TextBox txtEnterprise 
         Enabled         =   0   'False
         Height          =   330
         Left            =   960
         TabIndex        =   16
         Top             =   765
         Width           =   1575
      End
      Begin VB.TextBox txtModel 
         Enabled         =   0   'False
         Height          =   330
         Left            =   3840
         TabIndex        =   15
         Top             =   765
         Width           =   1575
      End
      Begin VB.TextBox txtBranch 
         Enabled         =   0   'False
         Height          =   330
         Left            =   960
         TabIndex        =   14
         Top             =   1200
         Width           =   1575
      End
      Begin VB.TextBox txtPlace 
         Enabled         =   0   'False
         Height          =   330
         Left            =   3840
         TabIndex        =   13
         Top             =   1200
         Width           =   1575
      End
      Begin VB.TextBox txtDevNo 
         Enabled         =   0   'False
         Height          =   330
         Left            =   960
         TabIndex        =   12
         Top             =   285
         Width           =   1575
      End
      Begin VB.CommandButton Cmd_DeviceSel 
         Caption         =   "选择"
         Height          =   375
         Left            =   2760
         TabIndex        =   11
         Top             =   285
         Width           =   735
      End
      Begin VB.Label Label1 
         AutoSize        =   -1  'True
         Caption         =   "设备品牌"
         Height          =   180
         Left            =   120
         TabIndex        =   21
         Top             =   840
         Width           =   720
      End
      Begin VB.Label Label3 
         AutoSize        =   -1  'True
         Caption         =   "布放地点"
         Height          =   180
         Left            =   3000
         TabIndex        =   20
         Top             =   1245
         Width           =   720
      End
      Begin VB.Label Label5 
         AutoSize        =   -1  'True
         Caption         =   "设备型号"
         Height          =   180
         Left            =   3000
         TabIndex        =   19
         Top             =   840
         Width           =   720
      End
      Begin VB.Label Label8 
         AutoSize        =   -1  'True
         Caption         =   "属性支行"
         Height          =   180
         Left            =   120
         TabIndex        =   18
         Top             =   1275
         Width           =   720
      End
      Begin VB.Label Label4 
         AutoSize        =   -1  'True
         Caption         =   "设备编号"
         Height          =   180
         Left            =   120
         TabIndex        =   17
         Top             =   360
         Width           =   720
      End
   End
   Begin VB.Frame Frame2 
      Caption         =   "报废信息"
      Height          =   1575
      Left            =   120
      TabIndex        =   4
      Top             =   2400
      Width           =   5655
      Begin VB.TextBox txtDSum 
         Height          =   330
         Left            =   960
         TabIndex        =   6
         Text            =   "0"
         Top             =   240
         Width           =   1575
      End
      Begin VB.TextBox txtReason 
         Height          =   690
         Left            =   960
         TabIndex        =   5
         Top             =   720
         Width           =   4455
      End
      Begin VB.Label Label11 
         AutoSize        =   -1  'True
         Caption         =   "报废原因"
         Height          =   180
         Left            =   120
         TabIndex        =   8
         Top             =   720
         Width           =   720
      End
      Begin VB.Label Label10 
         AutoSize        =   -1  'True
         Caption         =   "折算金额"
         Height          =   180
         Left            =   120
         TabIndex        =   7
         Top             =   315
         Width           =   720
      End
   End
   Begin VB.TextBox txtUserName 
      Height          =   330
      Left            =   3960
      TabIndex        =   2
      Top             =   165
      Width           =   1575
   End
   Begin VB.CommandButton Cmd_Cancel 
      Caption         =   "取 消"
      Height          =   375
      Left            =   3368
      TabIndex        =   1
      Top             =   4200
      Width           =   1215
   End
   Begin VB.CommandButton Cmd_OK 
      Caption         =   "确 定"
      Height          =   375
      Left            =   1328
      TabIndex        =   0
      Top             =   4200
      Width           =   1215
   End
   Begin MSComCtl2.DTPicker dtCreateDate 
      Height          =   330
      Left            =   1080
      TabIndex        =   22
      Top             =   165
      Width           =   1575
      _ExtentX        =   2778
      _ExtentY        =   582
      _Version        =   393216
      Format          =   24838145
      CurrentDate     =   38704
   End
   Begin VB.Label Label12 
      AutoSize        =   -1  'True
      Caption         =   "申请日期"
      Height          =   180
      Left            =   240
      TabIndex        =   9
      Top             =   240
      Width           =   720
   End
   Begin VB.Label Label9 
      AutoSize        =   -1  'True
      Caption         =   "申 请 人"
      Height          =   180
      Left            =   3120
      TabIndex        =   3
      Top             =   240
      Width           =   720
   End
End
Attribute VB_Name = "FrmDiscardEdit"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Public Modify As Boolean '插入=false,修改=true
Public OriId As Long  '报废编号

Private Sub Cmd_Cancel_Click()
  Unload Me
End Sub

Private Sub Cmd_DeviceSel_Click()
  FrmDeviceSel.Show 1      '设备选择窗体
  '读取指定对象信息
  txtDevNo = Trim(MyDeviceSel.DevNo)        '设备编号
  MyBase.GetInfo (MyDeviceSel.EnterpriseID) '设备品牌
  txtEnterprise = Trim(MyBase.InfoName)
  txtModel = Trim(MyDeviceSel.Model)        '设备型号
  MyBase.GetInfo (MyDeviceSel.BranchID)
  txtBranch = Trim(MyBase.InfoName)         '属性支行
  txtPlace = Trim(MyDeviceSel.Place)        '布放地点
End Sub

Private Sub Cmd_OK_Click()
  '如果为申请，则需要检查用户录入数据的有效性
  If Len(Trim(txtDevNo)) = 0 Then
    MsgBox ("请选择设备")
    Cmd_DeviceSel.SetFocus
    Exit Sub
  End If
  If Len(Trim(txtUserName)) = 0 Then
    MsgBox "请输入申请人"
    txtUserName.SetFocus
    Exit Sub
  End If
  If Len(Trim(txtReason)) = 0 Then
    MsgBox "请输入报废原因"
    txtReason.SetFocus
    Exit Sub
  End If
  '把用户录入的数据赋值到数据库对象变量中
  With MyDiscard
  .DevNo = MakeStr(txtDevNo)
  .CreateDate = Format(dtCreateDate.Value, "yyyy-mm-dd")
  .DisSum = Val(txtDSum)
  .UserName = MakeStr(txtUserName)
  .Status = "申请"
  .Reason = MakeStr(txtReason)
  '根据变量Modify的值，决定是插入新数据，还是修改已有的数据
  If Modify = False Then
    .Insert
  Else
    .Update (OriId)
  End If
  End With
  '关闭窗口
  Unload Me
End Sub