fawen.ctl

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

Attribute VB_Name = "UFaWen"
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 Declare Function CreatePolygonRgn Lib "gdi32" (lpPoint As POINTAPI, ByVal nCount As Long, ByVal nPolyFillMode As Long) As Long
    Private Declare Function CreateRectRgn Lib "gdi32" (ByVal x1 As Long, ByVal y1 As Long, ByVal X2 As Long, ByVal Y2 As Long) As Long
    Private Declare Function CreateRoundRectRgn Lib "gdi32" (ByVal x1 As Long, ByVal y1 As Long, ByVal X2 As Long, ByVal Y2 As Long, ByVal X3 As Long, ByVal Y3 As Long) As Long
    Private Declare Function CreateEllipticRgn Lib "gdi32" (ByVal x1 As Long, ByVal y1 As Long, ByVal X2 As Long, ByVal Y2 As Long) As Long
    Private Declare Function CombineRgn Lib "gdi32" (ByVal hDestRgn As Long, ByVal hSrcRgn1 As Long, ByVal hSrcRgn2 As Long, ByVal nCombineMode As Long) As Long
    Private Declare Function DeleteObject Lib "gdi32" (ByVal hObject As Long) As Long
    Private Declare Function SetWindowRgn Lib "user32" (ByVal hWnd As Long, ByVal hRgn As Long, ByVal bRedraw As Boolean) As Long
    Private Declare Function ReleaseCapture Lib "user32" () As Long
    Private Type POINTAPI
       x As Long
       y As Long
    End Type
    Private Const RGN_COPY = 5
    Private ResultRegion As Long
    
    Private Const RectXRound As Integer = 5
    Private Const RectYRound As Integer = 5

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
      
      If Not IsNull(Adodc4.Recordset.Fields("事由").Value) Then
        txtFields(4).Text = Adodc4.Recordset.Fields("事由").Value
      End If
      If Not IsNull(Adodc4.Recordset.Fields("主题词").Value) Then
        txtFields(9).Text = Adodc4.Recordset.Fields("主题词").Value
      End If
      If Not IsNull(Adodc4.Recordset.Fields("内容").Value) Then
        txtFields(5).Text = Adodc4.Recordset.Fields("内容").Value
      End If

  End If
  
  
  SSTab1.Tab = 0
End Sub

Private Sub cmdGaoZhi_Click()
  SSTab1.Tab = 3
  
End Sub

Private Sub cmdPrint_Click()
    Dim strSQL As String
    Dim rsTmp As New ADODB.Recordset
    Dim conn As New ADODB.Connection
    Dim oWrd As Object, i As Integer

    Set oWrd = CreateObject("Word.Application")
    oWrd.Visible = True
    oWrd.Activate
    oWrd.Documents.Add

    With oWrd.ActiveDocument.PageSetup
        .TopMargin = 60
        .BottomMargin = 40
        .LeftMargin = 66
        .RightMargin = 66
        .HeaderDistance = 30
        .FooterDistance = 48
        .PageWidth = 595.3
        .PageHeight = 841.9
    End With
    
    With oWrd.Selection
      
      .ParagraphFormat.Alignment = 3
      .Font.Underline = 1
      .Font.Size = 20    '小四
      .Font.Name = "宋体"
      .Font.Bold = True
      .TypeText "文件发送单"
      .Font.Underline = 0
      .Font.Size = 14
      .TypeText Space(36) & txtFields(0).Text & "发" & Format(txtFields(1).Text, "000")
      .TypeParagraph
      
      '部门
      .ParagraphFormat.Alignment = 3
      .ParagraphFormat.SpaceBefore = 24
      .ParagraphFormat.LineSpacing = 20
      .Font.Size = 11    '五号
      .Font.Name = "宋体"
      .Font.Bold = False
      .TypeText "部门名称：" & Space(2) & DataCombo1.Text
      .TypeParagraph
            
      '文件编号
      .ParagraphFormat.Alignment = 3
      .ParagraphFormat.SpaceBefore = 0
      .TypeText "文件编号：" & Space(2) & txtFields(2).Text
      .TypeParagraph
      
      '文件名称
      .ParagraphFormat.Alignment = 3
      .TypeText "文件名称：" & Space(2) & txtFields(4).Text
      .TypeParagraph
      
      '文件日期、发文日期
      .ParagraphFormat.Alignment = 3
      .TypeText "文件日期：" & Space(2) & Format(DTPicker1(0).Value, "yyyy-mm-dd") & Space(10) & "发文日期：" & Space(2) & Format(DTPicker1(1).Value, "yyyy-mm-dd")
      .TypeParagraph
      
      '文件页数、附件数
      .ParagraphFormat.Alignment = 3
      .TypeText "文件页数：" & Space(2) & txtFields(7).Text & Space(19) & "附件数：" & Space(2) & txtFields(8).Text
      .TypeParagraph
      .TypeParagraph
      .Font.Size = 10.5
      .ParagraphFormat.LineSpacing = 15
      
      conn.ConnectionString = pConn
      conn.Open
    
      '签字表格
      strSQL = "select 签发人姓名 from 签发人 order by 签发人排序"
      rsTmp.Open strSQL, conn, adOpenStatic, adLockReadOnly
      rsTmp.MoveLast
      rsTmp.MoveFirst
      i = rsTmp.RecordCount
'        .Tables.Add Range:=.Range, NumRows:=Int(i / 2 + 0.5) + 1, NumColumns:=8, DefaultTableBehavior:=1, AutoFitBehavior:=0
      .Tables.Add Range:=.Range, NumRows:=Int(i / 2 + 0.5) + 1, NumColumns:=8   ', AutoFitBehavior:=0
'      .Cells.VerticalAlignment = 1
      .Tables(1).Columns(1).SetWidth ColumnWidth:=51, RulerStyle:=0
      .Tables(1).Columns(2).SetWidth ColumnWidth:=56.7, RulerStyle:=0
      .Tables(1).Columns(3).SetWidth ColumnWidth:=68, RulerStyle:=0
      .Tables(1).Columns(4).SetWidth ColumnWidth:=68, RulerStyle:=0
      .Tables(1).Columns(5).SetWidth ColumnWidth:=51, RulerStyle:=0
      .Tables(1).Columns(6).SetWidth ColumnWidth:=56.7, RulerStyle:=0
      .Tables(1).Columns(7).SetWidth ColumnWidth:=68, RulerStyle:=0
      .Tables(1).Columns(8).SetWidth ColumnWidth:=68, RulerStyle:=0
      .ParagraphFormat.Alignment = 1
      .TypeText Text:="院领导"
      .MoveRight unit:=12
      .ParagraphFormat.Alignment = 1
      .TypeText Text:="签字"
      .MoveRight unit:=12
      .ParagraphFormat.Alignment = 1
      .TypeText Text:="送文日期"
      .MoveRight unit:=12
      .ParagraphFormat.Alignment = 1
      .TypeText Text:="还文日期"
      .MoveRight unit:=12
      .ParagraphFormat.Alignment = 1
      .TypeText Text:="院领导"
      .MoveRight unit:=12
      .ParagraphFormat.Alignment = 1
      .TypeText Text:="签字"
      .MoveRight unit:=12
      .ParagraphFormat.Alignment = 1
      .TypeText Text:="送文日期"
      .MoveRight unit:=12
      .ParagraphFormat.Alignment = 1
      .TypeText Text:="还文日期"
      .MoveRight unit:=12
      If Not rsTmp.EOF Then
        .TypeText Text:=rsTmp.Fields("签发人姓名").Value
        rsTmp.MoveNext
      End If
      Do While Not rsTmp.EOF
        .MoveRight unit:=12, Count:=4
        .TypeText Text:=rsTmp.Fields("签发人姓名").Value
        rsTmp.MoveNext
      Loop
      
      .MoveDown unit:=5, Count:=1
      .TypeParagraph
    
      '部门表格
      strSQL = "select 部门名称 from 部门 order by 部门名称"
      rsTmp.Close
      rsTmp.Open strSQL, conn, adOpenStatic, adLockReadOnly
      rsTmp.MoveLast
      rsTmp.MoveFirst
      i = rsTmp.RecordCount
      .Tables.Add Range:=.Range, NumRows:=i + 2, NumColumns:=5   ', AutoFitBehavior:=0
'      .Cells.VerticalAlignment = 1
      .Tables(1).Columns(1).SetWidth ColumnWidth:=100, RulerStyle:=0
      .Tables(1).Columns(2).SetWidth ColumnWidth:=73.7, RulerStyle:=0
      .Tables(1).Columns(3).SetWidth ColumnWidth:=120, RulerStyle:=0
      .Tables(1).Columns(4).SetWidth ColumnWidth:=73.7, RulerStyle:=0
      .Tables(1).Columns(5).SetWidth ColumnWidth:=120, RulerStyle:=0
      .TypeText Text:="部门"
      .MoveRight unit:=12
      .TypeText Text:="送文"
      .MoveRight unit:=12, Count:=2
      .TypeText Text:="还文"
      .MoveRight unit:=12, Count:=3
      .ParagraphFormat.Alignment = 1
      .TypeText Text:="签字"
      .MoveRight unit:=12
      .ParagraphFormat.Alignment = 1
      .TypeText Text:="日期"
      .MoveRight unit:=12
      .ParagraphFormat.Alignment = 1
      .TypeText Text:="签字"
      .MoveRight unit:=12
      .ParagraphFormat.Alignment = 1
      .TypeText Text:="日期"
      .MoveUp unit:=5, Count:=1
      .MoveLeft unit:=1, Count:=1, Extend:=1
      .Cells.Merge
      .ParagraphFormat.Alignment = 1
      .MoveLeft unit:=1, Count:=2
      .MoveLeft unit:=1, Count:=1, Extend:=1
      .Cells.Merge
      .ParagraphFormat.Alignment = 1
      .MoveLeft unit:=1, Count:=2
      .MoveDown unit:=5, Count:=1, Extend:=1
      .ParagraphFormat.Alignment = 1
      .Cells.Merge
      Do While Not rsTmp.EOF
        .MoveDown unit:=5
        .TypeText Text:=rsTmp.Fields("部门名称").Value
        rsTmp.MoveNext
      Loop
      
      .HomeKey unit:=6

    End With

    Set oWrd = Nothing
    Set conn = Nothing
    Set rsTmp = Nothing
    
'    Set 打印文件发送单.Report = Nothing
'    打印文件发送单.Report.TextBM.SetText DataCombo1.Text
'    打印文件发送单.Report.TextWJBH.SetText txtFields(2).Text
'    打印文件发送单.Report.TextWJMC.SetText txtFields(4).Text
'    打印文件发送单.Report.TextWJRQ.SetText Format(DTPicker1(0).Value, "yyyy-mm-dd")
'    打印文件发送单.Report.TextSWRQ.SetText Format(DTPicker1(1).Value, "yyyy-mm-dd")
'    打印文件发送单.Report.TextWJYS.SetText txtFields(7).Text
'    打印文件发送单.Report.TextFJS.SetText txtFields(8).Text
'    打印文件发送单.Show vbModal
  
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 DataCombo1_LostFocus()

  If datPrimaryRS.Recordset Is Nothing Or datPrimaryRS.Recordset.EditMode <> adEditAdd Then Exit Sub
    
'  Adodc1.Recordset.Find "部门id=" & datPrimaryRS.Recordset.Fields("部门id").Value
    
    Adodc1.Recordset.Find "部门id=" & DataCombo1.BoundText
  
  txtFields(2).Text = "交规" & Adodc1.Recordset.Fields("部门简称").Value & "字[" & txtFields(0).Text & "]" & Format(txtFields(1).Text, "000") & "号"
  
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 =