Imports GrapeCity.ActiveReports
Imports GrapeCity.ActiveReports.Document
Imports fbr00500.frmfbr00500
Public Class ACRFBR00500
Inherits GrapeCity.ActiveReports.SectionReport
Private Sub ActiveReport_DataInitialize()
Fields.Add("arMsi_Seq")
Fields.Add("arMsi_Hnbn")
Fields.Add("arMsi_Hnmi")
Fields.Add("arMsi_HnmiKn")
Fields.Add("arMsi_KkkSnp")
Fields.Add("arMsi_BhnKbn")
Fields.Add("arMsi_KsiKbn")
Fields.Add("arMsi_AtkaiKbn")
Fields.Add("arMsi_TshoNo")
Fields.Add("arMsi_ChkKbn")
Fields.Add("arMsi_KohoKbn")
Fields.Add("arMsi_SkiYsn")
Fields.Add("arMsi_MaeHnbn")
Fields.Add("arMsi_GTnk")
Fields.Add("arMsi_HnbKgn")
Fields.Add("arMsi_ZkBrKbn")
flngLpCnt = 0
flngPageCnt = 0
Exit Sub
End Sub
Private Sub ActiveReport_FetchData(EOF As Boolean, ByRef paraHash As Hashtable)
If flngLpCnt < flngLpEnd Then
flngLpCnt = flngLpCnt + 1
EOF = False
Else
EOF = True
Exit Sub
End If
Dim intRow As Integer
For intRow = 0 To CInt(flngLpEnd - 1)
With paraHash.Item("spsList")
'.Row = flngLpCnt
'Fields("arMsi_Seq").Value = CStr(flngLpCnt)
'.Col = SP_COL_HNBN
'Fields("arMsi_Hnbn").Value = .Text
'.Col = SP_COL_HNMI
'Fields("arMsi_Hnmi").Value = .Text
'.Col = SP_COL_HNMI_KN
'Fields("arMsi_HnmiKn").Value = .Text
'.Col = SP_COL_KKK_SNP_KN
'Fields("arMsi_KkkSnp").Value = .Text
'.Col = SP_COL_BHN_KBN
'Fields("arMsi_BhnKbn").Value = .Text
'.Col = SP_COL_KOSEI_KBN
'Fields("arMsi_KsiKbn").Value = .Text
'.Col = SP_COL_ATKAI_KBN
'Fields("arMsi_AtkaiKbn").Value = .Text
'.Col = SP_COL_NNY_TSY_NO
'Fields("arMsi_TshoNo").Value = .Text
'.Col = SP_COL_CHIK_KBN
'Fields("arMsi_ChkKbn").Value = .Text
'.Col = SP_COL_KOHO_KBN
'Fields("arMsi_KohoKbn").Value = .Text
'.Col = SP_COL_SKKI_YSN
'Fields("arMsi_SkiYsn").Value = .Text
'.Col = SP_COL_METIO_HNBN1
'Fields("arMsi_MaeHnbn").Value = .Text
'.Col = SP_COL_G_TNK
'Fields("arMsi_GTnk").Value = .Text
'.Col = SP_COL_HNB_KGN_F
'Fields("arMsi_HnbKgn").Value = .Text
'.Col = SP_COL_ZKBR_KBN
'Fields("arMsi_ZkBrKbn").Value = .Text
Fields.Item("arMsi_Seq").Value = CStr(intRow + 1)
Fields("arMsi_Hnbn").Value = .ActiveSheet.Cells(intRow, SP_COL_HNBN).Text
Fields("arMsi_Hnmi").Value = .ActiveSheet.Cells(intRow, SP_COL_HNMI).Text
Fields("arMsi_HnmiKn").Value = .ActiveSheet.Cells(intRow, SP_COL_HNMI_KN).Text
Fields("arMsi_KkkSnp").Value = .ActiveSheet.Cells(intRow, SP_COL_KKK_SNP_KN).Text
Fields("arMsi_BhnKbn").Value = .ActiveSheet.Cells(intRow, SP_COL_BHN_KBN).Text
Fields("arMsi_KsiKbn").Value = .ActiveSheet.Cells(intRow, SP_COL_KOSEI_KBN).Text
Fields("arMsi_AtkaiKbn").Value = .ActiveSheet.Cells(intRow, SP_COL_ATKAI_KBN).Text
Fields("arMsi_TshoNo").Value = .ActiveSheet.Cells(intRow, SP_COL_NNY_TSY_NO).Text
Fields("arMsi_ChkKbn").Value = .ActiveSheet.Cells(intRow, SP_COL_CHIK_KBN).Text
Fields("arMsi_KohoKbn").Value = .ActiveSheet.Cells(intRow, SP_COL_KOHO_KBN).Text
Fields("arMsi_SkiYsn").Value = .ActiveSheet.Cells(intRow, SP_COL_SKKI_YSN).Text
Fields("arMsi_MaeHnbn").Value = .ActiveSheet.Cells(intRow, SP_COL_METIO_HNBN1).Text
Fields("arMsi_GTnk").Value = .ActiveSheet.Cells(intRow, SP_COL_G_TNK).Text
Fields("arMsi_HnbKgn").Value = .ActiveSheet.Cells(intRow, SP_COL_HNB_KGN_F).Text
Fields("arMsi_ZkBrKbn").Value = .ActiveSheet.Cells(intRow, SP_COL_ZKBR_KBN).Text
End With
Next
Exit Sub
End Sub
Private Sub ActiveReport_ReportStart(ByRef paraHash As Hashtable)
flngLpEnd = CLng(paraHash.Item("spsList").ActiveSheet.NonEmptyRowCount)
arDate_RH.Text = paraHash.Item("lblDate")
arKianNo_RH.Text = paraHash.Item("imtKian_no")
arKianMei_RH.Text = paraHash.Item("imtKnmi_kj")
arBmnCd_RH.Text = paraHash.Item("imtBmn_code")
arBmnMei_RH.Text = paraHash.Item("imtBmn_mei")
arTanto_RH.Text = paraHash.Item("imtSyain_mei_kj")
arGKygiBi_RH.Text = paraHash.Item("txtGKygiBi")
arHnkKbn_RH.Text = paraHash.Item("txtHnkKbn")
arHnbnSu_Ssn_RH.Text = Format(flngSsnCnt, "##,###")
arHnbnSu_Szi_RH.Text = Format(CLng(paraHash.Item("lblCntHnbn")) - flngSsnCnt, "##,###")
arHnbnSu_Kei_RH.Text = paraHash.Item("lblCntHnbn")
arHnbKgn1_RH.Text = paraHash.Item("txtHnbKgn0")
arHnbKgn2_RH.Text = paraHash.Item("txtHnbKgn1")
arHnbKgn3_RH.Text = paraHash.Item("txtHnbKgn2")
arNhnKgn1_RH.Text = paraHash.Item("txtNhnKgn0")
arNhnKgn2_RH.Text = paraHash.Item("txtNhnKgn1")
arNhnKgn3_RH.Text = paraHash.Item("txtNhnKgn2")
Exit Sub
End Sub
Private Sub PageHeader_Format(ByRef paraHash As Hashtable)
arDate.Text = paraHash.Item("lblDate")
arKianNo.Text = paraHash.Item("imtKian_no")
arKianMei.Text = paraHash.Item("imtKnmi_kj")
arBmnCd.Text = paraHash.Item("imtBmn_code")
arBmnMei.Text = paraHash.Item("imtBmn_mei")
arTanto.Text = paraHash.Item("imtSyain_mei_kj")
arPage.Text = CStr(flngPageCnt) & " / " & CStr(paraHash.Item("lblCnt_page"))
flngPageCnt = flngPageCnt + 1
Exit Sub
End Sub
Public Overloads Sub run(ByRef paraHash As Hashtable)
ActiveReport_DataInitialize()
ActiveReport_ReportStart(paraHash)
ActiveReport_FetchData(True, paraHash)
PageHeader_Format(paraHash)
run()
Exit Sub
End Sub
End Class |
|