<% ' main() Sub main() If Not(SessionCheck()) Then Exit Sub End If Dim HyojiFlg Dim NRflg , ErrMSG , Action Dim KanriKubun Dim EnshuName Dim Kaisyamei , KaisyaKanamei '会社コード、会社名称、会社カナ名称 Dim ZipCode , Adr1 , Adr2 '郵便番号、住所1、住所2 Dim Tel , Fax , GyosyuCD , GyosyuName 'Tel、Fax、業種CD、業種名称 Dim KaisyaRyakumei '会社略名称 Dim Query Dim Content Dim GakuseiBango, JisyaFlg Dim SetteiFlg Dim ShijyoCD Dim DaityoTorishimariyaku, Shihonkin Dim DaityoTorishimariyakuJyusyo Dim Torishimariyaku1, Torishimariyaku2, Mokuteki Dim Torishimariyaku1Jyusyo, Torishimariyaku2Jyusyo Dim BunsyoNaiyoCD Dim TantosyaCD Dim KanKatsu Dim DaihyoSyain TantosyaCD = "" '061122追加 Dim Kitakuriyou, KitakuKaisyaCD, KitakuKaisyaMei '070207追加 Dim OldKitakuKaisyaCD Dim Hokkinin4 Dim Hokkinin5 Dim Hokkinin4Jusho Dim Hokkinin5Jusho Dim Kabushiki1 Dim Kabushiki2 Dim Kabushiki3 Dim Kabushiki4 Dim Kabushiki5 Dim Gakumen Dim SeitoJisha SetteiFlg = Request("SetteiFlg") KaisyaCD = Request("KaisyaCD") NRflg = Request("nr") Action = Request("Action") ErrMSG = Request("ErrMSG") HyojiFlg = Request("HyojiFlg") Dim SortMode SortMode = Request("SortMode") Dim ShijoCD ShijoCD = Request("ShijoCD") Dim CopyMoto CopyMoto = Request("CopyMoto") 'Response.Write("Action:" & Action) '演習名称GET EnshuName = ConvEnshuMeisyo(EnshuCD) If NRflg = "r" then Kaisyamei = Request("Kaisyamei") KaisyaRyakumei = Request("KaisyaRyakumei") KaisyaKanamei = Request("KaisyaKanamei") ZipCode = Request("ZipCode") Adr1 = Request("Adr1") Adr2 = Request("Adr2") Tel = Request("Tel") Fax = Request("Fax") GyosyuCD = Request("GyosyuCD") ErrMsg = Request("ErrMsg") GakuseiBango = Request("GakuseiBango") JisyaFlg = Request("JisyaFlg") KitakuKaisyaCD = Request("KitakuKaisyaCD") ShijyoCD = Request("ShijyoCD") DaityoTorishimariyaku = Request("DaityoTorishimariyaku") DaityoTorishimariyakuJyusyo = Request("DaityoTorishimariyakuJyusyo") Torishimariyaku1 = Request("Torishimariyaku1") Torishimariyaku1Jyusyo = Request("Torishimariyaku1Jyusyo") Torishimariyaku2 = Request("Torishimariyaku2") Torishimariyaku2Jyusyo = Request("Torishimariyaku2Jyusyo") Hokkinin4 = Request("Hokkinin4") Hokkinin5 = Request("Hokkinin5") Hokkinin4Jusho = Request("Hokkinin4Jusho") Hokkinin5Jusho = Request("Hokkinin5Jusho") Kabushiki1 = Request("Kabushiki1") If Kabushiki1 = "null" Then Kabushiki1 = "" End If Kabushiki2 = Request("Kabushiki2") If Kabushiki2 = "null" Then Kabushiki2 = "" End If Kabushiki3 = Request("Kabushiki3") If Kabushiki3 = "null" Then Kabushiki3 = "" End If Kabushiki4 = Request("Kabushiki4") If Kabushiki4 = "null" Then Kabushiki4 = "" End If Kabushiki5 = Request("Kabushiki5") If Kabushiki5 = "null" Then Kabushiki5 = "" End If Gakumen = Request("Gakumen") If Gakumen = "null" Then Gakumen = "" End If Shihonkin = Request("Shihonkin") If Shihonkin = "null" Then Shihonkin = "" End If Mokuteki = Request("Mokuteki") DaihyoSyain = Request("DaihyoSyain") SeitoJisha = Request("SeitoJisha") Else If CopyMoto <> "" Then Query = "exec SPM会社取得 '" & GB_SystemCD & "','" & EnshuCD & "','" & CopyMoto & "'" Else Query = "exec SPM会社取得 '" & GB_SystemCD & "','" & EnshuCD & "','" & KaisyaCD & "'" End If Set Content = OpenQuery(Query) If Not(Content.BOF Or Content.EOF) Then ShijyoCD = Content.Fields("市場CD") Kaisyamei = Content.Fields("会社名称") KaisyaRyakumei = Content.Fields("会社略名称") KaisyaKanamei = Content.Fields("会社カナ名称") ZipCode = Content.Fields("郵便番号") Adr1 = Content.Fields("住所1") Adr2 = Content.Fields("住所2") Tel = Content.Fields("TEL") Fax = Content.Fields("FAX") GyosyuCD = Content.Fields("業種CD") GakuseiBango = Content.Fields("学生番号") JisyaFlg = Content.Fields("自社フラグ") KitakuKaisyaCD = "" & Content.Fields("寄託会社CD") DaityoTorishimariyaku = Content.Fields("代表取締役") DaityoTorishimariyakuJyusyo = Content.Fields("代表取締役住所") Torishimariyaku1 = Content.Fields("取締役1") Torishimariyaku2 = Content.Fields("取締役2") Torishimariyaku1Jyusyo = Content.Fields("取締役1住所") Torishimariyaku2Jyusyo = Content.Fields("取締役2住所") Hokkinin4 = Content.Fields("発起人4") Hokkinin5 = Content.Fields("発起人5") Hokkinin4Jusho = Content.Fields("発起人4住所") Hokkinin5Jusho = Content.Fields("発起人5住所") Kabushiki1 = Content.Fields("発起人1株式数") Kabushiki2 = Content.Fields("発起人2株式数") Kabushiki3 = Content.Fields("発起人3株式数") Kabushiki4 = Content.Fields("発起人4株式数") Kabushiki5 = Content.Fields("発起人5株式数") Gakumen = Content.Fields("株式の額面") Shihonkin = Content.Fields("資本金") Mokuteki = "" & Content.Fields("事業目的") If Mokuteki <> "" Then Mokuteki = Replace(Mokuteki , "
", vbCrLf) Mokuteki = Server.HTMLEncode(Mokuteki) End If If CopyMoto = "" Then SeitoJisha = "" & Content.Fields("同時同業生徒自社") End If Query = "exec SPK社員台帳一覧2 '" & GB_SystemCD & "','" & EnshuCD & "', '" & KaisyaCD & "'" Set Content = OpenQuery(Query) Do While Not(Content.BOF Or Content.EOF) If "" & Content.Fields("代表取締役フラグ") = "1" Then DaihyoSyain = "" & Content.Fields("氏名") Exit Do End If Content.MoveNext Loop End If End If If "" & Gakumen = "" Then Gakumen = 50000 End If Dim MotoShihonkin MotoShihonkin = "" & ConvIntToMoney(Shihonkin, false, false) OldKitakuKaisyaCD = KitakuKaisyaCD 'Response.Write("NRflg:" & NRflg & "
") 'Response.Write("GakuseiBango:" & GakuseiBango & "
") 'Response.Write("KitakuKaisyaCD:" & KitakuKaisyaCD & "
") If JisyaFlg = "" Then JisyaFlg = 0 End If If GakuseiBango <> "" Then KitakuKaisyaCD = Replace(KitakuKaisyaCD, "-" & GakuseiBango, "") End If Dim RouteType RouteType = Request("RouteType") 'サイバー会計で代表取締役氏名が存在しない場合はTTA社員台帳Mから取得(初回会社選択時に作成されている) If PackageMode = "1" Then If DaityoTorishimariyaku = "" Then DaityoTorishimariyaku = DaihyoSyain End If End If ''''''''繰越金額を調べるここから Dim Kingaku Dim KurikoshiZandakaKingaku Dim GenkinKingaku, SyohinKingaku, GinkoKingaku Dim SyohinSu, ContentKoza Dim NyusyukoBango, QueryNyusyuko, ContentNyusyuko Dim QueryKoza GenkinKingaku = 0 SyohinKingaku = 0 GinkoKingaku = 0 Query = "exec SPK現金入出金取得 '" & GB_SystemCD & "','" & EnshuCD & "', '" & KaisyaCD & "', 0, 0" Set Content = OpenQuery(Query) If Not(Content.BOF Or Content.EOF) Then GenkinKingaku = Content.Fields("金額") End If QueryNyusyuko = "exec SPD入出庫一覧 '" & GB_SystemCD & "','" & EnshuCD & "', '" & KaisyaCD & "', '', 'S'" Set ContentNyusyuko = OpenQuery(QueryNyusyuko) Do While Not(ContentNyusyuko.BOF Or ContentNyusyuko.EOF) If ContentNyusyuko.Fields("処理時期区分") = 0 Then NyusyukoBango = ContentNyusyuko.Fields("文書内容CD") End If ContentNyusyuko.MoveNext Loop QueryNyusyuko = "exec SPD入出庫取得 '" & GB_SystemCD & "','" & EnshuCD & "', '" & KaisyaCD & "', '', 'S', '" & NyusyukoBango & "'" Set ContentNyusyuko = OpenQuery(QueryNyusyuko) Do While Not(ContentNyusyuko.BOF Or ContentNyusyuko.EOF) SyohinKingaku = SyohinKingaku + ContentNyusyuko.Fields("数量") * ContentNyusyuko.Fields("単価") ContentNyusyuko.MoveNext Loop If KaisyaCD <> "" Then QueryKoza = "exec SPB銀行口座一覧 '" & GB_SystemCD & "','" & EnshuCD & "', '" & KaisyaCD & "', '', ''" Set ContentKoza = OpenQuery(QueryKoza) Do While Not(ContentKoza.BOF Or ContentKoza.EOF) Dim MyGinkoCD, MyKozaKubun MyGinkoCD = "" MyKozaKubun = "" If Not(ContentKoza.BOF Or ContentKoza.EOF) Then MyGinkoCD = ContentKoza.Fields("銀行CD") MyKozaKubun = ContentKoza.Fields("口座区分") End If Query = "exec SPB銀行口座入出金一覧 '" & GB_SystemCD & "','" & EnshuCD & "', '" & KaisyaCD & "', '" & MyGinkoCD & "', '" & MyKozaKubun & "', ''" Set Content = OpenQuery(Query) Do While Not(Content.BOF Or Content.EOF) If Content.Fields("処理時期区分") = 0 Then Kingaku = Content.Fields("金額") End If Content.MoveNext Loop GinkoKingaku = GinkoKingaku + Kingaku ContentKoza.MoveNext Loop End If KurikoshiZandakaKingaku = GenkinKingaku + SyohinKingaku + GinkoKingaku ''''''''繰越金額を調べるここまで ''''''''勘定残高行数を調べるここから Dim KanjyoZandakaShiwakeGyosu, KanjyoZandaka KanjyoZandakaShiwakeGyosu = 0 Query = "exec SPK伝票_振替伝票取得 '" & GB_SystemCD & "','" & EnshuCD & "', '" & KaisyaCD & "', '0000000', '" & ConvKaisyaGyosyuKubun(KaisyaCD) & "'" Set Content = OpenQuery(Query) Do While Not(Content.BOF Or Content.EOF) KanjyoZandakaShiwakeGyosu = KanjyoZandakaShiwakeGyosu + 1 KanjyoZandaka = KanjyoZandaka + Content.Fields("借方金額") Content.MoveNext Loop ''''''''勘定残高行数を調べるここまで Query = "exec SPM演習取得 '" & GB_SystemCD & "','" & EnshuCD & "'" Set Content = OpenQuery(Query) If Not(Content.BOF Or Content.EOF) Then Kitakuriyou = Content.Fields("寄託倉庫利用") End If KitakuKaisyaCD = "" Query = "exec SPM寄託会社取得 '" & GB_SystemCD & "','" & EnshuCD & "', '" & KaisyaCD & "'" Set Content = OpenQuery(Query) If Not(Content.BOF Or Content.EOF) Then KitakuKaisyaMei = Content.Fields("会社名称") Query = "exec SPK契約書一覧 '" & GB_SystemCD & "', '" & EnshuCD & "', '" & KaisyaCD & "', 'XK', 'S'" '自社が甲の寄託契約書一覧 Set Content = OpenQuery(Query) Do While Not(Content.BOF Or Content.EOF) If "" & Content.Fields("削除フラグ") <> "1" Then BunsyoNaiyoCD = Content.Fields("文書内容CD") Query = "exec SPK契約書取得 '" & GB_SystemCD & "', '" & EnshuCD & "', '" & KaisyaCD & "', 'XK', '" & BunsyoNaiyoCD & "', '" & KaisyaCD & "', 'S'" Set Content = OpenQuery(Query) If Not(Content.BOF Or Content.EOF) Then KitakuKaisyaCD = "" & Content.Fields("取引先CD") TantosyaCD = "" & Content.Fields("甲担当者CD") Kankatsu = Content.Fields("管轄裁判所") End If End If Content.MoveNext Loop End If Dim ZaikoChkFlag Query = "exec SPD在庫チェック '" & GB_SystemCD & "','" & EnshuCD & "','" & KaisyaCD & "'" Set Content = OpenQuery(Query) ZaikoChkFlag = Content.Fields(0) 'Dim Syuryobi 'Syuryobi = GB_KaikeiSyuryobi 'Query = "exec SPR入出庫在庫 '" & GB_SystemCD & "','" & EnshuCD & "', '" & KaisyaCD & "','" & Syuryobi & "'" 'Set Content = OpenQuery(Query) 'If Not(Content.BOF Or Content.EOF) Then ' ZaikoChkFlag = "1" 'Else ' ZaikoChkFlag = "0" 'End If 'Response.Write("Query:" & Query & "
") 'Response.Write("ZaikoChkFlag:" & ZaikoChkFlag & "
") %> <% = HtmlHeader("") %> onLoad="ShowKitakuForm()"<% End If %> bgcolor="#5C70B6" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<% Dim PageTitle PageTitle = "会社マスター" Response.Write(HtmlDesign(1)) If RouteType = "syatyo" Then Response.Write(HttpL1(3)) Response.Write(HttpL2("会社選択" ,"tblbtn( '/" & HomeAlias & "/user/bk/')", GB_GyosyuMeisyo, "tblbtn( '/" & HomeAlias & "/user/bk/menu_" & GB_Gyosyu & ".asp')", "社長室・総務部", "tblbtn('/" & HomeAlias & "/user/bk/menu_s4.asp')", "定款", "", "", "", "", "")) Else Response.Write(HttpL1(4)) If GB_Admin >= 1 Then Response.Write(HttpL2("運用管理メニュー" ,"tblbtn( '/" & HomeAlias & "/admin/admenu_w.asp')", "マスター管理", "tblbtn( '/" & HomeAlias & "/admin/master/fm_master_select.asp')", PageTitle, "", "", "", "", "", "", "")) Else PageTitle = "自社情報" Response.Write(HttpL2("メインメニュー" ,"tblbtn('/" & HomeAlias & "/user/bk/menu_cyac.asp')", PageTitle, "", "", "", "", "", "", "", "", "")) End If End If Response.Write(HttpL3("", "" ,"", "", "", "", "", "", "", "", "", "", "", "", "", "")) Response.Write(HttpL3_1("保存", "SubmitCheck()", "", "", "", "", "", "", "", "")) If RouteType = "syatyo" Then Response.Write(HttpL3_2("戻る", "tblbtn('/" & HomeAlias & "/user/bk/menu_s4.asp')", "", "", "", "", "", "", "", "")) ElseIf Setteiflg = 1 Then If Action = 1 Then Response.Write(HttpL3_2("戻る", "tblbtn('fm_kaisya_ichiran.asp?HyojiFlg=" & HyojiFlg & "&SortMode=" & SortMode & "&ShijoCD=" & ShijoCD & "&KaisyaCD=" & KaisyaCD & "')", "", "", "", "", "", "", "", "")) Else Response.Write(HttpL3_2("戻る", "tblbtn('fm_kaisya_view.asp?HyojiFlg=" & HyojiFlg & "&SortMode=" & SortMode & "&ShijoCD=" & ShijoCD & "&KaisyaCD=" & KaisyaCD & "')", "一覧表示", "tblbtn( 'fm_kaisya_ichiran.asp?HyojiFlg=" & HyojiFlg & "&SortMode=" & SortMode & "&ShijoCD=" & ShijoCD & "&KaisyaCD=" & KaisyaCD & "')", "", "", "", "", "", "")) End If ElseIf GB_Admin >= 1 Then If Action = 1 Then Response.Write(HttpL3_2("戻る", "tblbtn('fm_kaisya_ichiran.asp?HyojiFlg=" & HyojiFlg & "&SortMode=" & SortMode & "&ShijoCD=" & ShijoCD & "&KaisyaCD=" & KaisyaCD & "')", "高度な設定", "if(confirm('メンテナンス時以外では高度な設定は利用しません\r\n高度な設定のページに移動しますか?'))tblbtn('fm_Kaisya.asp?SetteiFlg=1&ShijoCD=" & ShijoCD & "&KaisyaCD=" & KaisyaCD & "&CopyMoto=" & CopyMoto & "&Action=" & Action & "')", "", "", "", "", "", "")) Else Response.Write(HttpL3_2("戻る", "tblbtn('fm_kaisya_view.asp?HyojiFlg=" & HyojiFlg & "&SortMode=" & SortMode & "&ShijoCD=" & ShijoCD & "&KaisyaCD=" & KaisyaCD & "')", "一覧表示", "tblbtn('fm_kaisya_ichiran.asp?HyojiFlg=" & HyojiFlg & "&SortMode=" & SortMode & "&ShijoCD=" & ShijoCD & "&KaisyaCD=" & KaisyaCD & "')", "高度な設定", "if(confirm('メンテナンス時以外では高度な設定は利用しません\r\n高度な設定のページに移動しますか?'))tblbtn('fm_Kaisya.asp?SetteiFlg=1&ShijoCD=" & ShijoCD & "&KaisyaCD=" & KaisyaCD & "&CopyMoto=" & CopyMoto & "&Action=" & Action & "')", "", "", "", "")) End If Else Response.Write(HttpL3_2("戻る", "tblbtn('fm_kaisya_view.asp?HyojiFlg=" & HyojiFlg & "&SortMode=" & SortMode & "&ShijoCD=" & ShijoCD & "&KaisyaCD=" & KaisyaCD & "')", "一覧表示", "tblbtn( 'fm_kaisya_ichiran.asp?HyojiFlg=" & HyojiFlg & "&SortMode=" & SortMode & "&ShijoCD=" & ShijoCD & "&KaisyaCD=" & KaisyaCD & "')", "", "", "", "", "", "")) End If If RouteType = "syatyo" Then Response.Write(HttpL4("会社情報", "修正")) ElseIf Action = 1 Then Response.Write(HttpL4(PageTitle, "追加")) Else Response.Write(HttpL4(PageTitle, "修正")) End If Response.Write(HttpL5(ErrMsg)) %>
<% = HtmlFooter %> <% End Sub %>