frmreturndetail.frm

这是用不VB+SQLSERVER2000开发的.

VERSION 5.00
Begin VB.Form FrmReturnDetail 
   BorderStyle     =   1  'Fixed Single
   Caption         =   "图书续借-归还-丢失信息"
   ClientHeight    =   2970
   ClientLeft      =   45
   ClientTop       =   330
   ClientWidth     =   6675
   Icon            =   "FrmReturnDetail.frx":0000
   LinkTopic       =   "Form1"
   LockControls    =   -1  'True
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   2970
   ScaleWidth      =   6675
   StartUpPosition =   2  '屏幕中心
   Begin VB.ComboBox cob_Status 
      Height          =   300
      ItemData        =   "FrmReturnDetail.frx":0442
      Left            =   1320
      List            =   "FrmReturnDetail.frx":044F
      TabIndex        =   15
      Text            =   "归还"
      Top             =   1800
      Width           =   1335
   End
   Begin VB.TextBox txtGDate 
      Height          =   330
      Left            =   3960
      TabIndex        =   13
      Top             =   765
      Width           =   1455
   End
   Begin VB.CommandButton Cmd_Cancel 
      Caption         =   "返 回"
      Height          =   375
      Left            =   3750
      TabIndex        =   11
      Top             =   2400
      Width           =   1215
   End
   Begin VB.CommandButton Cmd_OK 
      Caption         =   "确 定"
      Height          =   375
      Left            =   1710
      TabIndex        =   10
      Top             =   2400
      Width           =   1215
   End
   Begin VB.TextBox txtForfeit 
      Height          =   330
      Left            =   3960
      TabIndex        =   9
      Text            =   "0"
      Top             =   1245
      Width           =   1455
   End
   Begin VB.TextBox txtRRDate 
      Height          =   330
      Left            =   1320
      TabIndex        =   7
      Top             =   1245
      Width           =   1455
   End
   Begin VB.TextBox txtReturnDate 
      Enabled         =   0   'False
      Height          =   330
      Left            =   1320
      TabIndex        =   5
      Top             =   765
      Width           =   1455
   End
   Begin VB.TextBox txtBookName 
      Enabled         =   0   'False
      Height          =   330
      Left            =   3960
      TabIndex        =   3
      Top             =   285
      Width           =   2535
   End
   Begin VB.TextBox txtBookNo 
      Enabled         =   0   'False
      Height          =   330
      Left            =   1320
      TabIndex        =   1
      Top             =   285
      Width           =   1455
   End
   Begin VB.Label Label7 
      AutoSize        =   -1  'True
      Caption         =   "更改状态"
      Height          =   180
      Left            =   480
      TabIndex        =   14
      Top             =   1800
      Width           =   720
   End
   Begin VB.Label Label6 
      AutoSize        =   -1  'True
      Caption         =   "续借日期"
      Height          =   180
      Left            =   3120
      TabIndex        =   12
      Top             =   840
      Width           =   720
   End
   Begin VB.Label Label5 
      AutoSize        =   -1  'True
      Caption         =   "罚 金"
      Height          =   180
      Left            =   3390
      TabIndex        =   8
      Top             =   1320
      Width           =   450
   End
   Begin VB.Label Label4 
      AutoSize        =   -1  'True
      Caption         =   "实际归还日期"
      Height          =   180
      Left            =   120
      TabIndex        =   6
      Top             =   1320
      Width           =   1080
   End
   Begin VB.Label Label3 
      AutoSize        =   -1  'True
      Caption         =   "应归还日期"
      Height          =   180
      Left            =   300
      TabIndex        =   4
      Top             =   840
      Width           =   900
   End
   Begin VB.Label Label2 
      AutoSize        =   -1  'True
      Caption         =   "图书名称"
      Height          =   180
      Left            =   3120
      TabIndex        =   2
      Top             =   360
      Width           =   720
   End
   Begin VB.Label Label1 
      AutoSize        =   -1  'True
      Caption         =   "图书编号"
      Height          =   180
      Left            =   480
      TabIndex        =   0
      Top             =   360
      Width           =   720
   End
End
Attribute VB_Name = "FrmReturnDetail"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Public OriId As Long   '明细编号
Public nAddDays As Integer '最大允许续借天数
Public ClickOK As Boolean

Private Sub Cmd_Cancel_Click()
  Unload Me
End Sub

Private Sub Cmd_OK_Click()
  If MsgBox("确认 归还\续借\丢失 图书?", vbYesNo, "确认") = vbNo Then
    Exit Sub
  End If
  
  '如果为归还，则判断归还日期是否为空
  If Trim(cob_Status.Text) = "归还" Then
    If Len(Trim(txtRRDate)) = 0 Then
      MsgBox ("归还日期不能为空")
      txtRRDate.SetFocus
      Exit Sub
    End If
    With MyBorrowList
      .RealReturnDate = Trim(txtRRDate)
      .GDate = Trim(txtGDate)
      .Forfeit = Val(txtForfeit)
      .Status = Trim(cob_Status.Text)
      .UpdateStatus (OriId)
      '更改库存数量，参数1表示归还数量
      MyBookInfo.UpdateTotal Trim(txtBookNo), 1
    End With
  '如果为续借，则判断续借日期是否为空
  ElseIf Trim(cob_Status.Text) = "续借" Then
    If Len(Trim(txtGDate)) = 0 Then
      MsgBox ("续借日期不能为空")
      txtGDate.SetFocus
      Exit Sub
    End If
    With MyBorrowList
      .ReturnDate = Trim(txtReturnDate)
      .GDate = Trim(txtGDate)
      .RealReturnDate = Trim(txtRRDate)
      .Forfeit = Val(txtForfeit)
      .Status = Trim(cob_Status.Text)
      .UpdateStatus (OriId)
    End With
  ElseIf Trim(cob_Status.Text) = "丢失" Then
    With MyBorrowList
      .GDate = Trim(txtGDate)
      .RealReturnDate = Trim(txtRRDate)
      .Forfeit = Val(txtForfeit)
      .Status = Trim(cob_Status.Text)
      .UpdateStatus (OriId)
    End With
  End If
  ClickOK = True
  Unload Me
End Sub

Private Sub Form_Load()
  ClickOK = False
End Sub

Private Sub txtGDate_Change()
  '更改应归还日期
  txtReturnDate = CStr(DateAdd("d", nAddDays, CDate(txtGDate)))
End Sub