%
'
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("") %>