ufahan_display.ctl

公文管理系统》是一套通过行文收发

               HaveTrueFalseNull=   0
               FirstDayOfWeek  =   0
               FirstWeekOfYear =   0
               LCID            =   2052
               SubFormatType   =   0
            EndProperty
         EndProperty
         BeginProperty Column14 
            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 
            BeginProperty Column00 
               ColumnWidth     =   734.74
            EndProperty
            BeginProperty Column01 
               ColumnWidth     =   734.74
            EndProperty
            BeginProperty Column02 
               ColumnWidth     =   1094.74
            EndProperty
            BeginProperty Column03 
               ColumnWidth     =   2085.166
            EndProperty
            BeginProperty Column04 
               ColumnWidth     =   1890.142
            EndProperty
            BeginProperty Column05 
               ColumnWidth     =   2085.166
            EndProperty
            BeginProperty Column06 
               ColumnWidth     =   2085.166
            EndProperty
            BeginProperty Column07 
               ColumnWidth     =   794.835
            EndProperty
            BeginProperty Column08 
               ColumnWidth     =   615.118
            EndProperty
            BeginProperty Column09 
               ColumnWidth     =   2085.166
            EndProperty
            BeginProperty Column10 
               ColumnWidth     =   2085.166
            EndProperty
            BeginProperty Column11 
               ColumnWidth     =   1365.165
            EndProperty
            BeginProperty Column12 
               ColumnWidth     =   1094.74
            EndProperty
            BeginProperty Column13 
               ColumnWidth     =   2085.166
            EndProperty
            BeginProperty Column14 
               ColumnWidth     =   2085.166
            EndProperty
         EndProperty
      End
   End
   Begin VB.Label lblLabels 
      AutoSize        =   -1  'True
      BackColor       =   &H80000005&
      BackStyle       =   0  'Transparent
      Caption         =   "共有记录数:"
      Height          =   330
      Index           =   15
      Left            =   2400
      TabIndex        =   24
      Top             =   5100
      Width           =   990
   End
   Begin VB.Label lbl记录数 
      Alignment       =   2  'Center
      BackColor       =   &H00FFF8E7&
      Caption         =   "0"
      Height          =   330
      Left            =   3570
      TabIndex        =   23
      Top             =   5040
      Width           =   615
   End
End
Attribute VB_Name = "UFaWen_Display"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = True
Attribute VB_PredeclaredId = False
Attribute VB_Exposed = False
Option Explicit
Public pIP As String
Public pConn As String
Dim strUserName As String
Private Sub cmdAll_Click()
    datPrimaryRS.Recordset.Filter = ""
    datPrimaryRS.Refresh
    SSTab1.Tab = 1
End Sub

Private Sub cmdCancel_Click()
    SSTab1.Tab = 1
End Sub

'Private Sub cmdFaWen_Click()
'  If Not (Adodc4.Recordset.EOF Or Adodc4.Recordset.BOF) Then
'      txtFields(4).Text = Adodc4.Recordset.Fields("事由").Value
'      txtFields(9).Text = Adodc4.Recordset.Fields("主题词").Value
'      txtFields(5).Text = Adodc4.Recordset.Fields("内容").Value
'
'  End If
'
'
'  SSTab1.Tab = 0
'End Sub

Private Sub cmdFilter_Click()
    Dim strFilter As String
    '生成filter字符串
    strFilter = ""
    If Trim(txtFields(5).Text) <> "" Then
        strFilter = "年度=" & Trim(txtFields(5).Text)
    End If
    If Trim(txtFields(6).Text) <> "" Then
        If strFilter = "" Then
            strFilter = "序号=" & Trim(txtFields(6).Text)
        Else
            strFilter = strFilter & " and 序号=" & Trim(txtFields(6).Text)
        End If
    End If
    If DataCombo4.BoundText <> "" Then
        If strFilter = "" Then
            strFilter = "部门ID=" & DataCombo4.BoundText
        Else
            strFilter = strFilter & " and 部门ID=" & DataCombo4.BoundText
        End If
    End If
    If Not IsNull(DTPicker1(2).Value) Then
        If strFilter = "" Then
            strFilter = "发文日期 >= #" & Format(DTPicker1(2).Value, "Short Date") & "#"
        Else
            strFilter = strFilter & " and 发文日期 >= #" & Format(DTPicker1(2).Value, "Short Date") & "#"
        End If
    End If
    If Not IsNull(DTPicker1(3).Value) Then
        If strFilter = "" Then
            strFilter = "发文日期 <= #" & Format(DTPicker1(3).Value, "Short Date") & "#"
        Else
            strFilter = strFilter & " and 发文日期 <= #" & Format(DTPicker1(3).Value, "Short Date") & "#"
        End If
    End If
    If txtFields(10).Text <> "" Then
        If strFilter = "" Then
            strFilter = "主题词 like '%" & txtFields(10).Text & "%'"
        Else
            strFilter = strFilter & " and 主题词 like '%" & txtFields(10).Text & "%'"
        End If
    End If
    datPrimaryRS.Recordset.Filter = ""               'adFilterNone
    datPrimaryRS.Recordset.Filter = strFilter
    SSTab1.Tab = 1
End Sub

'Private Sub cmdGaoZhi_Click()
'  SSTab1.Tab = 3
'
'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 = CStr(datPrimaryRS.Recordset.AbsolutePosition)
  lbl记录数.Caption = CStr(datPrimaryRS.Recordset.RecordCount)

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
'  Dim n年度 As Integer, n序号 As Integer
'
'  datPrimaryRS.Recordset.MoveLast
'  n年度 = datPrimaryRS.Recordset.Fields("年度").Value
'  n序号 = datPrimaryRS.Recordset.Fields("序号").Value + 1
'
'  datPrimaryRS.Recordset.AddNew
'
'  txtFields(0).Text = n年度
'  txtFields(1).Text = n序号
'
'  Exit Sub
'AddErr:
'  MsgBox Err.Description
'End Sub
'
'Private Sub cmdDelete_Click()
'  On Error GoTo DeleteErr
'
'    Dim nYN As Byte
'
'     nYN = MsgBox("您正准备删除当前记录。" & Chr(13) & Chr(13) & _
'        "假如您单击“是”，您将不能撤消这个删除操作。" & Chr(13) & _
'        "您确认删除这条记录吗?", vbExclamation + vbYesNo)
'
'    If nYN = vbYes Then
'      With datPrimaryRS.Recordset
'            If .EOF And .BOF Then Exit Sub
'            .Delete
'            .MoveNext
'
'            If .RecordCount > 0 And .EOF Then
'                .MoveLast
'                ElseIf .RecordCount = 0 Then .MovePrevious
'            End If
'      End With
'    End If
'
'  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 cmdRefresh1_Click()
'  '只有多用户应用程序需要
'  On Error GoTo RefreshErr
'  Adodc4.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 txtFields_Change(Index As Integer)
  
  If datPrimaryRS.Recordset Is Nothing Then Exit Sub
  If datPrimaryRS.Recordset.EOF Or datPrimaryRS.Recordset.BOF Then Exit Sub
    
  If datPrimaryRS.Recordset.EditMode = adEditAdd And Index < 2 Then
  
    txtFields(2).Text = "" & Adodc1.Recordset.Fields("部门简称").Value & "字[" & txtFields(0).Text & "]" & Format(txtFields(1).Text, "000") & "号"
  End If
  
End Sub


Private Sub UserControl_Initialize()
    pConn = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=OA;Data Source=lzy"
    strUserName = GetSetting("JGYOA", "Login", "UserName", "")

    With datPrimaryRS
        .ConnectionString = pConn
        .RecordSource = "select 年度,序号,部门ID,文件编号,文件名称,发送单位,文件日期,发文日期,文件页数,附件数,主题词,抄送,签发人ID,文件分类ID,相关文件 from 发函登记"
        .Refresh
    End With
    With Adodc1
        .ConnectionString = pConn
        .RecordSource = "部门"
        .Refresh
    End With
    With Adodc2
        .ConnectionString = pConn
        .RecordSource = "签发人"
        .Refresh
    End With
    With Adodc3
        .ConnectionString = pConn
        .RecordSource = "文件分类"
        .Refresh
    End With
    
End Sub