clgl.frm

煤炭销售管理系统.完成煤炭销售的日常管理工作,和重车计量系统空车计量系统配合使用.

         BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED} 
            Type            =   0
            Format          =   ""
            HaveTrueFalseNull=   0
            FirstDayOfWeek  =   0
            FirstWeekOfYear =   0
            LCID            =   2052
            SubFormatType   =   0
         EndProperty
      EndProperty
      BeginProperty Column05 
         DataField       =   "dh"
         Caption         =   "dh"
         BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED} 
            Type            =   0
            Format          =   ""
            HaveTrueFalseNull=   0
            FirstDayOfWeek  =   0
            FirstWeekOfYear =   0
            LCID            =   2052
            SubFormatType   =   0
         EndProperty
      EndProperty
      BeginProperty Column06 
         DataField       =   "dz"
         Caption         =   "dz"
         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 
            ColumnWidth     =   1454.74
         EndProperty
         BeginProperty Column01 
            ColumnWidth     =   2025.071
         EndProperty
         BeginProperty Column02 
            ColumnWidth     =   2220.094
         EndProperty
         BeginProperty Column03 
            ColumnWidth     =   1454.74
         EndProperty
         BeginProperty Column04 
            ColumnWidth     =   2025.071
         EndProperty
         BeginProperty Column05 
            ColumnWidth     =   1170.142
         EndProperty
         BeginProperty Column06 
            ColumnWidth     =   2220.094
         EndProperty
      EndProperty
   End
   Begin VB.Label lblLabels 
      Caption         =   "家庭住址:"
      Height          =   252
      Index           =   6
      Left            =   360
      TabIndex        =   12
      Top             =   2400
      Width           =   972
   End
   Begin VB.Label lblLabels 
      Caption         =   "联系电话:"
      Height          =   252
      Index           =   5
      Left            =   5880
      TabIndex        =   10
      Top             =   1860
      Width           =   972
   End
   Begin VB.Label lblLabels 
      Caption         =   "身份证号:"
      Height          =   252
      Index           =   4
      Left            =   3240
      TabIndex        =   8
      Top             =   1860
      Width           =   852
   End
   Begin VB.Label lblLabels 
      Caption         =   "车主姓名:"
      Height          =   252
      Index           =   3
      Left            =   360
      TabIndex        =   6
      Top             =   1860
      Width           =   972
   End
   Begin VB.Label lblLabels 
      Caption         =   "核定载重:"
      Height          =   252
      Index           =   2
      Left            =   5880
      TabIndex        =   4
      Top             =   1320
      Width           =   972
   End
   Begin VB.Label lblLabels 
      Caption         =   "车型:"
      Height          =   252
      Index           =   1
      Left            =   3240
      TabIndex        =   2
      Top             =   1320
      Width           =   852
   End
   Begin VB.Label lblLabels 
      Caption         =   "车号:"
      Height          =   252
      Index           =   0
      Left            =   360
      TabIndex        =   0
      Top             =   1320
      Width           =   972
   End
   Begin VB.Menu tdata 
      Caption         =   "数据管理"
      Begin VB.Menu tadd 
         Caption         =   "添加"
      End
      Begin VB.Menu tsaver 
         Caption         =   "保存"
      End
      Begin VB.Menu tdele 
         Caption         =   "删除"
      End
      Begin VB.Menu trefresh 
         Caption         =   "刷新"
      End
      Begin VB.Menu tclos 
         Caption         =   "关闭"
      End
   End
   Begin VB.Menu tcx 
      Caption         =   "查询"
      Begin VB.Menu tchcx 
         Caption         =   "按车号查询"
      End
      Begin VB.Menu tczcx 
         Caption         =   "按车主查询"
      End
   End
End
Attribute VB_Name = "clgl"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False

Private Sub Form_MouseUp(Button As Integer, Shift As Integer, x As Single, y As Single)
If Button = 2 Then
Me.PopupMenu tdata, , x, y
End If

End Sub

Private Sub Form_Unload(Cancel As Integer)
  Screen.MousePointer = vbDefault
End Sub

Private Sub datPrimaryRS_Error(ByVal ErrorNumber As Long, Description As String, ByVal Scode As Long, ByVal Source As String, ByVal HelpFile As String, ByVal HelpContext As Long, fCancelDisplay As Boolean)
  '错误处理程序代码置于此处
  '想要忽略错误，注释掉下一行
  '想要捕获它们，在此添加代码以处理它们
  MsgBox "Data error event hit err:" & Description
End Sub

Private Sub datPrimaryRS_MoveComplete(ByVal adReason As ADODB.EventReasonEnum, ByVal pError As ADODB.Error, adStatus As ADODB.EventStatusEnum, ByVal pRecordset As ADODB.Recordset)
  '为这个 recordset 显示当前记录位置
  datPrimaryRS.Caption = "Record: " & CStr(datPrimaryRS.Recordset.AbsolutePosition)
End Sub

Private Sub datPrimaryRS_WillChangeRecord(ByVal adReason As ADODB.EventReasonEnum, ByVal cRecords As Long, adStatus As ADODB.EventStatusEnum, ByVal pRecordset As ADODB.Recordset)
  '验证代码置于此处
  '下列动作发生时该事件被调用
  Dim bCancel As Boolean

  Select Case adReason
  Case adRsnAddNew
  Case adRsnClose
  Case adRsnDelete
  Case adRsnFirstChange
  Case adRsnMove
  Case adRsnRequery
  Case adRsnResynch
  Case adRsnUndoAddNew
  Case adRsnUndoDelete
  Case adRsnUndoUpdate
  Case adRsnUpdate
  End Select

  If bCancel Then adStatus = adStatusCancel
End Sub

Private Sub cmdAdd_Click()
  On Error GoTo AddErr
  datPrimaryRS.Recordset.AddNew

  Exit Sub
AddErr:
  MsgBox err.Description
End Sub

Private Sub cmdDelete_Click()
  On Error GoTo DeleteErr
  With datPrimaryRS.Recordset
    .delete
    .MoveNext
    If .EOF Then .MoveLast
  End With
  Exit Sub
DeleteErr:
  MsgBox err.Description
End Sub

Private Sub cmdRefresh_Click()
  '只有多用户应用程序需要
  On Error GoTo RefreshErr
  datPrimaryRS.refresh
  Exit Sub
RefreshErr:
  MsgBox err.Description
End Sub

Private Sub cmdUpdate_Click()
  On Error GoTo UpdateErr

  datPrimaryRS.Recordset.UpdateBatch adAffectAll
  Exit Sub
UpdateErr:
  MsgBox err.Description
End Sub

Private Sub cmdClose_Click()
  Unload Me
End Sub

Private Sub tadd_Click()
cmdAdd_Click
End Sub

Private Sub tchcx_Click()
Dim ch As String
ch = InputBox("请输入要查询的车号", "车号查询")
Me.datPrimaryRS.RecordSource = "SHAPE {select ch,cx,hdzz,cz,sfz,dh,dz from clgl where ch like '%" & Trim(ch) & "%' Order by ch} AS ParentCMD APPEND ({select ch,cx,hdzz,cz,sfz,dh,dz from clgl Order by ch } AS ChildCMD RELATE ch TO ch) AS ChildCMD"
Me.datPrimaryRS.refresh
End Sub

Private Sub tclos_Click()
cmdClose_Click
End Sub

Private Sub tdele_Click()
cmdUpdate_Click
End Sub

Private Sub trefresh_Click()
cmdRefresh_Click
End Sub

Private Sub tsaver_Click()
cmdUpdate_Click
End Sub