htkk.frm

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

         TabIndex        =   19
         Top             =   2280
         Width           =   1200
      End
      Begin VB.Label lblLabels 
         Caption         =   "发货人:"
         Height          =   255
         Index           =   5
         Left            =   360
         TabIndex        =   17
         Top             =   1965
         Width           =   1200
      End
      Begin VB.Label lblLabels 
         Caption         =   "媒  种:"
         Height          =   255
         Index           =   4
         Left            =   360
         TabIndex        =   15
         Top             =   1635
         Width           =   1200
      End
      Begin VB.Label lblLabels 
         Caption         =   "欠存量:"
         Height          =   255
         Index           =   3
         Left            =   360
         TabIndex        =   13
         Top             =   1320
         Width           =   1200
      End
      Begin VB.Label lblLabels 
         Caption         =   "已发量:"
         Height          =   255
         Index           =   2
         Left            =   360
         TabIndex        =   11
         Top             =   1005
         Width           =   1200
      End
      Begin VB.Label lblLabels 
         Caption         =   "合同量:"
         Height          =   255
         Index           =   1
         Left            =   360
         TabIndex        =   9
         Top             =   675
         Width           =   1200
      End
      Begin VB.Label lblLabels 
         Caption         =   "票  号:"
         Height          =   255
         Index           =   0
         Left            =   360
         TabIndex        =   7
         Top             =   360
         Width           =   1200
      End
   End
   Begin VB.PictureBox picButtons 
      Align           =   2  'Align Bottom
      Appearance      =   0  'Flat
      BorderStyle     =   0  'None
      ForeColor       =   &H80000008&
      Height          =   300
      Left            =   0
      ScaleHeight     =   300
      ScaleWidth      =   9600
      TabIndex        =   0
      Top             =   4845
      Width           =   9600
      Begin VB.CommandButton cmdClose 
         Caption         =   "关闭(&C)"
         Default         =   -1  'True
         Height          =   300
         Left            =   4675
         TabIndex        =   5
         Top             =   0
         Width           =   1095
      End
      Begin VB.CommandButton cmdRefresh 
         Caption         =   "刷新(&R)"
         Height          =   300
         Left            =   3521
         TabIndex        =   4
         Top             =   0
         Width           =   1095
      End
      Begin VB.CommandButton cmdDelete 
         Caption         =   "删除(&D)"
         Height          =   300
         Left            =   2367
         TabIndex        =   3
         Top             =   0
         Visible         =   0   'False
         Width           =   1095
      End
      Begin VB.CommandButton cmdUpdate 
         Caption         =   "更新(&U)"
         Height          =   300
         Left            =   1213
         TabIndex        =   2
         Top             =   0
         Visible         =   0   'False
         Width           =   1095
      End
      Begin VB.CommandButton cmdAdd 
         Caption         =   "添加(&A)"
         Height          =   300
         Left            =   59
         TabIndex        =   1
         Top             =   0
         Visible         =   0   'False
         Width           =   1095
      End
   End
   Begin MSAdodcLib.Adodc datPrimaryRS 
      Align           =   2  'Align Bottom
      Height          =   330
      Left            =   0
      Top             =   5145
      Visible         =   0   'False
      Width           =   9600
      _ExtentX        =   16933
      _ExtentY        =   582
      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=   3
      Appearance      =   1
      BackColor       =   -2147483643
      ForeColor       =   -2147483640
      Orientation     =   0
      Enabled         =   -1
      Connect         =   "DSN=dzqch"
      OLEDBString     =   ""
      OLEDBFile       =   ""
      DataSourceName  =   "dzqch"
      OtherAttributes =   ""
      UserName        =   "sa"
      Password        =   ""
      RecordSource    =   "select hth,htl,yfl,wfl,hwm,fhr,fhdw,qydw,dj,je,sj,bz,htldx,jedx,ysfs,jsfs,fphm,tbr,fzr,sj1,djj from htk"
      Caption         =   " "
      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
End
Attribute VB_Name = "htkk"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False

Private Sub Form_Load()
htkk.datPrimaryRS.ConnectionString = connetstr

htkk.datPrimaryRS.RecordSource = "select hth,htl,yfl,wfl,hwm,fhr,fhdw,qydw,dj,je,sj,bz,htldx,jedx,ysfs,jsfs,fphm,tbr,fzr,sj1,djj from htk where hth = '" & Trim(jl_hth) & "' "
datPrimaryRS.refresh
Call cmdRefresh_Click
Me.Caption = "*****" & hthh & "**详细数据"
'jl_wfl = htkk.datPrimaryRS.Recordset.Fields("wfl")
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()
mainfrm.Show
  Unload Me
End Sub

'"select hth as 票号,htl as  合同量,yfl as 已发量,wfl as 欠存量,hwm as 货物名,fhr as 发货人,fhdw as 发货单位,dj as 单价,je as 金额,sj as 发货时间,ysfs as 运输方式,jsfs as 结算方式,bz as 备注 from htk  where ysfs  not like '%船%' and sj>='" & Format(DTPicker1.Value, "yyyy-mm-dd") & "' and  sj <= '" & Format(DTPicker2.Value, "yyyy-mm-dd") & "'and je>0 order by sj"

Private Sub txtFields_Change(Index As Integer)

End Sub