% ' %> <% main() Sub main() If Not(SessionCheck()) Then Exit Sub End If Dim DbSyainNo Dim SyainNo DbSyainNo = Request("DbSyainNo") SyainNo = Request("SyainNo") Dim Seq Seq = Request("Seq") Dim Shikyubi Dim ShikyuKubun Dim Shimei, Birthday Dim Action , NRflg , ErrMSG Dim FuyoNinzu, Yakusyoku '扶養家族人数、役職、基本給 Dim Kihonkyu, Jikangai, JikangaiTeate, SyokumuTeate, JyutakuTeate, SeikinTeate, KaikinTeate Dim SonotaTeate Dim kazokuTeate Dim TukinTeate, Soshikyugaku, KenkoHoken, KoseiNenkin, NenkinKikin, KoyoHoken Dim SyakaiHokenGokei Dim KazeiTaisyogaku, Syotokuzei, Jyuminzei, SozeiGokei, Sokojyogaku, SashikihiShikyugaku Dim ZangyoTeate Dim KaigoHoken Dim Query Dim Content Dim Genkin, Toza Dim GakuseiShimei Dim GakuseiBango Dim Nengetu, Gatudo NRflg = Request("nr") Action = Request("Action") ErrMSG = Request("ErrMSG") If NRflg = "r" then Shimei = Request("Shimei") FuyoNinzu = Request("FuyoNinzu") Yakusyoku = Request("Yakusyoku") Birthday = Request("Birthday") Kihonkyu = Request("Kihonkyu") Jikangai = Request("Jikangai") JikangaiTeate = Request("JikangaiTeate") SyokumuTeate = Request("SyokumuTeate") kazokuTeate = Request("kazokuTeate") JyutakuTeate = Request("JyutakuTeate") TukinTeate = Request("TukinTeate") SeikinTeate = Request("SeikinTeate") KaikinTeate = Request("KaikinTeate") SonotaTeate = Request("SonotaTeate") TukinTeate = Request("TukinTeate") KenkoHoken = Request("KenkoHoken") KoseiNenkin = Request("KoseiNenkin") NenkinKikin = Request("NenkinKikin") KoyoHoken = Request("KoyoHoken") KaigoHoken = Request("KaigoHoken") Syotokuzei = Request("Syotokuzei") Jyuminzei = Request("Jyuminzei") ShikyuKubun = Request("ShikyuKubun") Seq = Request("Seq") Else Query = "exec SPK社員台帳取得2 '" & GB_SystemCD & "' ,'" & EnshuCD & "', '" & KaisyaCD & "', " & DbSyainNo Set Content = OpenQuery(Query) If Not(Content.BOF Or Content.EOF) Then SyainNo = Content.Fields("社員番号ラベル") Shimei = Content.Fields("氏名") FuyoNinzu = Content.Fields("扶養家族人数") Yakusyoku = Content.Fields("役職") Birthday = SetTimeYYYYMMDD(Content.Fields("生年月日")) Kihonkyu = Content.Fields("基本給") SyokumuTeate = Content.Fields("職務手当") kazokuTeate = Content.Fields("家族手当") JyutakuTeate = Content.Fields("住宅手当") TukinTeate = Content.Fields("通勤手当") SeikinTeate = Content.Fields("精勤手当") KaikinTeate = Content.Fields("皆勤手当") TukinTeate = Content.Fields("通勤手当") KenkoHoken = Content.Fields("健康保険") KoseiNenkin = Content.Fields("厚生年金") NenkinKikin = Content.Fields("年金基金") KoyoHoken = Content.Fields("雇用保険") KaigoHoken = Content.Fields("介護保険") End If If Action <> "add" Then Query = "exec SPK給与明細取得 '" & GB_SystemCD & "' ,'" & EnshuCD & "', '" & KaisyaCD & "', " & DbSyainNo & ", " & Seq Set Content = OpenQuery(Query) If Not(Content.BOF Or Content.EOF) Then ShikyuKubun = "" & Content.Fields("支給区分") Shikyubi = SetTimeYYYYMMDD(Content.Fields("支給年月日")) Kihonkyu = Content.Fields("基本給") Jikangai = Content.Fields("時間外時間") JikangaiTeate = Content.Fields("時間外手当") SyokumuTeate = Content.Fields("職務手当") kazokuTeate = Content.Fields("家族手当") JyutakuTeate = Content.Fields("住宅手当") TukinTeate = Content.Fields("通勤手当") SeikinTeate = Content.Fields("精勤手当") KaikinTeate = Content.Fields("皆勤手当") SonotaTeate = Content.Fields("その他手当") TukinTeate = Content.Fields("通勤手当") KenkoHoken = Content.Fields("健康保険") KoseiNenkin = Content.Fields("厚生年金") NenkinKikin = Content.Fields("年金基金") KoyoHoken = Content.Fields("雇用保険") KaigoHoken = Content.Fields("介護保険") Syotokuzei = Content.Fields("所得税") Jyuminzei = Content.Fields("住民税") End If End If ' If Kihonkyu = "" Then Kihonkyu = 0 End If ' If Jikangai = "" Then Jikangai = 0 End If ' If JikangaiTeate = "" Then JikangaiTeate = 0 End If ' If SyokumuTeate = "" Then SyokumuTeate = 0 End If ' If kazokuTeate = "" Then kazokuTeate = 0 End If ' If JyutakuTeate = "" Then JyutakuTeate = 0 End If ' If SeikinTeate = "" Then SeikinTeate = 0 End If ' If KaikinTeate = "" Then KaikinTeate = 0 End If ' If SonotaTeate = "" Then SonotaTeate = 0 End If ' If TukinTeate = "" Then TukinTeate = 0 End If ' If Soshikyugaku = "" Then Soshikyugaku = 0 End If ' If KenkoHoken = "" Then KenkoHoken = 0 End If ' If KoseiNenkin = "" Then KoseiNenkin = 0 End If ' If NenkinKikin = "" Then NenkinKikin = 0 End If ' If KoyoHoken = "" Then KoyoHoken = 0 End If ' If KaigoHoken = "" Then KaigoHoken = 0 End If ' If Syotokuzei = "" Then Syotokuzei = 0 End If ' If Jyuminzei = "" Then Jyuminzei = 0 End If End If Soshikyugaku = Kihonkyu + JikangaiTeate + SyokumuTeate + kazokuTeate + JyutakuTeate + SeikinTeate + KaikinTeate + SonotaTeate + TukinTeate SyakaiHokenGokei = KenkoHoken + KoseiNenkin + NenkinKikin + KoyoHoken + KaigoHoken '通勤手当が100000以下なら課税対象から差し引く If TukinTeate > 100000 Then KazeiTaisyogaku = Soshikyugaku - SyakaiHokenGokei Else KazeiTaisyogaku = Soshikyugaku - SyakaiHokenGokei - TukinTeate End If SozeiGokei = Syotokuzei + Jyuminzei Sokojyogaku = SyakaiHokenGokei + SozeiGokei SashikihiShikyugaku = Soshikyugaku - Sokojyogaku %>