% ' ' %> <% main() Sub main() If Not(SessionCheck()) Then Exit Sub End If Dim LabelSoumu Dim LabelTanto Dim LabelKakari LabelSoumu = "" LabelTanto = "" LabelKakari = "係 印" If MHMINRANLEFT <> "" Then LabelSoumu = MHMINRANLEFT End If If MHMINRANCENTER <> "" Then LabelTanto = MHMINRANCENTER End If If MHMINRANRIGHT <> "" Then LabelKakari = MHMINRANRIGHT End If Dim PageType PageType = "決算整理仕訳" '決算振替仕訳にトグルするためのフラグ(081021小野) Dim Kimatsu Kimatsu = Request("Kimatsu") If Kimatsu = "Kurikoshi" Then PageType = "決算振替仕訳" End If Dim DenpyoNo, Torihikibi, DenpyoTekiyo '伝票番号、取引日、伝票摘要 Dim KanjyoCD(10) '勘定科目コード Dim Kanjyomei(10) '勘定科目名称 Dim Kingaku(10) '金額 Dim Tekiyo(10) '摘要 Dim TekiyoCD(10) '取引先CD Dim KarikataGokei, KashikataGokei '借方合計、貸方合計 Dim OldDenpyoNo Dim Query Dim Content Dim GakuseiShimei Dim GakuseiBango Dim DenpyoSyoriKubun DenpyoNo = Request("DenpyoNo") KashikataGokei = 0 KarikataGokei = 0 Dim TmpCnt Dim ErrorFlg ErrorFlg = Request("ErrorFlg") '追加モードでリジェクトされた場合はクエリを取得(090528小野) If ErrorFlg <> "" Then DenpyoNo = Request("DenpyoNo") Torihikibi = Request("Torihikibi") DenpyoTekiyo = Request("DenpyoTekiyo") For TmpCnt = 1 To 10 KanjyoCD(TmpCnt) = Request("KanjyoCD" & CStr(TmpCnt)) Kanjyomei(TmpCnt) = ConvKanjyoMeisyoDx(GB_SystemCD, GB_EnshuCD, KanjyoCD(TmpCnt)) Kingaku(TmpCnt) = Request("Kingaku" & CStr(TmpCnt)) TekiyoCD(TmpCnt) = Request("TekiyoCD" & CStr(TmpCnt)) Tekiyo(TmpCnt) = Request("Tekiyo" & CStr(TmpCnt)) If Kingaku(TmpCnt) <> "" Then If TmpCnt Mod 2 = 0 Then KashikataGokei = KashikataGokei + CLng(Kingaku(TmpCnt)) Else KarikataGokei = KarikataGokei + CLng(Kingaku(TmpCnt)) End If End If Next '修正モード ElseIf DenpyoNo <> "" Then OldDenpyoNo = DenpyoNo 'この場合のみOldDenpyoNoを持たせる(090528小野) Query = "exec SPK伝票_振替伝票取得 '" & GB_SystemCD & "','" & EnshuCD & "', '" & KaisyaCD & "', '" & DenpyoNo & "', '" & ConvKaisyaGyosyuKubun(KaisyaCD) & "'" Set Content = OpenQuery(Query) If Not(Content.BOF Or Content.EOF) Then Torihikibi = Content.Fields("取引日") DenpyoTekiyo = Content.Fields("伝票摘要") GakuseiShimei = Content.Fields("氏名") GakuseiBango = Content.Fields("学生番号") DenpyoSyoriKubun = Content.Fields("伝票処理区分") Do While Not(Content.BOF Or Content.EOF) Dim DenpyoSEQ DenpyoSEQ = Content.Fields("伝票SEQ") KanjyoCD(DenpyoSEQ) = Content.Fields("勘定CD") Kanjyomei(DenpyoSEQ) = ConvKanjyoMeisyo(Content.Fields("勘定CD")) If DenpyoSEQ mod 2 = 0 Then Kingaku(DenpyoSEQ) = Content.Fields("貸方金額") KashikataGokei = KashikataGokei + Content.Fields("貸方金額") Else Kingaku(DenpyoSEQ) = Content.Fields("借方金額") KarikataGokei = KarikataGokei + Content.Fields("借方金額") End If TekiyoCD(DenpyoSEQ) = Content.Fields("摘要CD") Tekiyo(DenpyoSEQ) = Content.Fields("摘要") Content.MoveNext Loop End If End If Dim TekiyoCDs Query = "exec SPM摘要表示一覧 '" & GB_SystemCD & "','" & EnshuCD & "', '" & KaisyaCD & "'" Set Content = OpenQuery(Query) Do While Not(Content.BOF Or Content.EOF) If TekiyoCDs <> "" Then TekiyoCDs = TekiyoCDs & "," End If TekiyoCDs = TekiyoCDs & Content.Fields("摘要CD") Content.MoveNext Loop ' Dim JidoBangoDenpyo ' JidoBangoDenpyo = GetEnshuParam(EnshuCD, "自動番号伝票") '自動番号伝票・振替伝票表示行数フラグ取得 Dim JidoBangoDenpyo Dim Gyousu Query = "exec SPM演習取得 '" & GB_SystemCD & "','" & EnshuCD & "'" Set Content = OpenQuery(Query) If Not(Content.BOF Or Content.EOF) Then JidoBangoDenpyo = "" & Content.Fields("自動番号伝票") Gyousu = Content.Fields("振替伝票表示行数") End If Dim SenColor SenColor = "#015B23" If Kimatsu = "Kurikoshi" Then SenColor = "#885522" End If Dim KouriRiyo KouriRiyo = KourihanbaiRiyo() If Gyousu = 0 Or "" & Gyousu = "" Then Gyousu = 5 End If Dim GyouHeight Dim GyouHeight2 Dim GyouHeight3 Dim GyouHaichi If Gyousu = 1 Then GyouHeight = 300 GyouHeight2 = 100 GyouHeight3 = 200 GyouHaichi = "middle" ElseIf Gyousu = 2 Then GyouHeight = 150 GyouHeight2 = 50 GyouHeight3 = 100 GyouHaichi = "bottom" ElseIf Gyousu = 3 Then GyouHeight = 100 GyouHeight2 = 40 GyouHeight3 = 60 GyouHaichi = "bottom" ElseIf Gyousu = 4 Then GyouHeight = 75 GyouHeight2 = 30 GyouHeight3 = 45 GyouHaichi = "bottom" Else GyouHeight = 60 GyouHeight2 = 26 GyouHeight3 = 34 GyouHaichi = "bottom" End If '摘要配列作成 Dim TekiyoCDA Dim TekiyoNameA Dim TekiyoShijoA ReDim TekiyoCDA(0) ReDim TekiyoNameA(0) ReDim TekiyoShijoA(0) Query = "exec SPM摘要表示一覧 '" & GB_SystemCD & "','" & EnshuCD & "', '" & KaisyaCD & "'" Set Content = OpenQuery(Query) Do While Not(Content.BOF Or Content.EOF) If Not(Content.Fields("摘要区分") = "K" AND Content.Fields("摘要CD") = KaisyaCD) Then ReDim PreServe TekiyoCDA(UBound(TekiyoCDA) + 1) '配列数+1 ReDim PreServe TekiyoNameA(UBound(TekiyoCDA)) ReDim PreServe TekiyoShijoA(UBound(TekiyoCDA)) TekiyoCDA(UBound(TekiyoCDA)) = "" & Content.Fields("摘要CD") TekiyoNameA(UBound(TekiyoCDA)) = "" & Content.Fields("摘要") TekiyoShijoA(UBound(TekiyoCDA)) = "" & Content.Fields("市場CD") End If Content.MoveNext Loop If KouriRiyo > 0 Then ReDim PreServe TekiyoCDA(UBound(TekiyoCDA) + 1) '配列数+1 ReDim PreServe TekiyoNameA(UBound(TekiyoCDA)) ReDim PreServe TekiyoShijoA(UBound(TekiyoCDA)) TekiyoCDA(UBound(TekiyoCDA)) = "SJ4KOURIHANBAI" TekiyoNameA(UBound(TekiyoCDA)) = "" & ConvKaisyaMeisyo("SJ4KOURIHANBAI") TekiyoShijoA(UBound(TekiyoCDA)) = "" End If Dim ii %> <% = HtmlHeader("") %>
<% = HtmlFooter %>