<!-- #include virtual="/sj4web/include.asp" --> <% '<!-- '################################################ ' 名称 :受発信文書 ' 作成日:2002/11/05 ' 作成者:山崎 ' 目的 :受発信文書の一覧を表示する ' 概要 : '################################################ '--> ' %> <% main() Sub main() If Not(SessionCheck()) Then Exit Sub End If Dim PageType, RouteType, UserID PageType = Request("PageType") RouteType = Request("RouteType") UserID = Request("UserID") if UserID <> "" then Session("UserID") = UserID end if Dim ShowDel ShowDel = Request("ShowDel") 'Response.Write("UserID:" & UserID & "<br>") 'Response.Write("EnshuCD:" & EnshuCD & "<br>") 'Response.Write("GB_GakuseiNo:" & GB_GakuseiNo & "<br>") 'Response.Write("UserID:" & Session("UserID") & "<br>") 'Response.Write("PageType:" & PageType & "<br>") 'Response.Write("RouteType:" & RouteType & "<br>") %> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=shift_jis"> <meta http-equiv="Pragma" content="no-cache"> <meta http-equiv="Cache-Control" content="no-cache"> <meta http-equiv="Expires" content="-1"> <link href="/sj4web/binx/sj3web.css" rel="stylesheet" type="text/css"> <title><% = AppTitle %></title> <script language="JScript" src="/sj4web/include.js"></script> <script language="JScript" src="/sj4web/includesj.js"></script> <script language="JScript.Encode" src="/sj4web/include_enc.js"></script> <script language="JScript.Encode" src="/sj4web/includesj_enc.js"></script> </head> <SCRIPT LANGUAGE="JavaScript"> <!-- ExitFlg = 1; --> </SCRIPT> <body onkeydown="if(ExitFlg==2)ExitFlg=3;" onBeforeUnload="window.event.returnValue = ExitMsg(ExitFlg)" bgcolor="#8D9BCC" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"> <form OnKeyDown="FormKeyDown(this)" name="form1" method="POST" action="fn_jyuhasshinbunsyo_bin.asp"> <input type="hidden" name="SendValue" value=""> <input type="hidden" name="PageType" value="<% = PageType %>"> <input type="hidden" name="RouteType" value="<% = RouteType%>"> <% If InStr(RouteType, "MailOnly") > 0 Then Response.Write(HtmlDesign(6)) ElseIf InStr(RouteType, "ViewOnly") > 0 Then Response.Write(HtmlDesign(6)) Else Response.Write(HtmlDesign(1)) End If Response.Write(HttpL1(3)) If InStr(RouteType, "MailOnly") > 0 Then Response.Write(HttpL2("受発信文書ウィンドウ" ,"", "", "", "", "", "", "", "", "", "", "")) ElseIf InStr(RouteType, "ViewOnly") > 0 And InStr(RouteType, "RMail") > 0 Then Response.Write(HttpL2("照会・集計ウィンドウ" ,"tblbtn( '/sj4web/user/bk/menu_s_viewonly.asp')", "受発信文書", "", "受信文書", "", "", "", "", "", "", "")) ElseIf InStr(RouteType, "ViewOnly") > 0 And InStr(RouteType, "SMail") > 0 Then Response.Write(HttpL2("照会・集計ウィンドウ" ,"tblbtn( '/sj4web/user/bk/menu_s_viewonly.asp')", "受発信文書", "", "発信文書", "", "", "", "", "", "", "")) ElseIf InStr(RouteType, "ViewOnly") > 0 Then Response.Write(HttpL2("照会・集計ウィンドウ" ,"tblbtn( '/sj4web/user/bk/menu_s_viewonly.asp')", "受発信文書", "", "", "", PageType, "", "", "", "", "")) ElseIf GB_Gyosyu <> "B" Then Response.Write(HttpL2("会社選択" ,"tblbtn( '/sj4web/user/bk/')", GB_GyosyuMeisyo, "tblbtn( '/sj4web/user/bk/menu_" & GB_Gyosyu & ".asp')", "社長室・総務部", "tblbtn( '/sj4web/user/bk/menu_s4.asp')", "受発信文書", "tblbtn( '/sj4web/user/bk/jyuhasshinbunsyo/')", PageType , "", "", "")) Else Response.Write(HttpL2("会社選択" ,"tblbtn( '/sj4web/user/bk/')", ConvKubunMeisyo("業種CD", GB_Gyosyu) , "tblbtn( '/sj4web/user/bk/menu_" & GB_Gyosyu & ".asp')", "受発信文書", "tblbtn( '/sj4web/user/bk/jyuhasshinbunsyo/')", PageType, "", "", "", "", "")) End If Response.Write(HttpL3("", "", "", "", "", "", "", "" ,"", "", "", "", "", "", "", "")) If InStr(RouteType, "ViewOnly") > 0 Or InStr(RouteType, "MailOnly") > 0 Then Response.Write(HttpL3_1("照会", "syokaibtn()", "再表示", "tblbtn('" & Request.ServerVariables("PATH_INFO") & "?" & Request.ServerVariables("QUERY_STRING") & "')", "", "", "", "", "", "")) Else Response.Write(HttpL3_1("照会", "syokaibtn()", "削除", "SubmitCheck()", "再表示", "tblbtn('" & Request.ServerVariables("PATH_INFO") & "?" & Request.ServerVariables("QUERY_STRING") & "')", "", "", "", "")) End If If InStr(RouteType, "MailOnly") > 0 Then If PageType = "発信文書" Then ' Response.Write(HttpL3_2("受信文書", "tblbtn( '/sj4web/admin/mail/fn_jyuhasshinbunsyo.asp?PageType=受信文書&RouteType=" & RouteType & "')", "発信文書", "", "メール作成", "tblbtn( '/sj4web/admin/mail/fn_mailsakusei.asp?RouteType=" & RouteType & "')", "受信メール", "tblbtn( '/sj4web/admin/mail/fn_mailsakusei_ichiran.asp?PageType=受信メール&RouteType=" & RouteType & "')" ,"送信メール", "tblbtn( '/sj4web/admin/mail/fn_mailsakusei_ichiran.asp?PageType=送信メール&RouteType=" & RouteType & "')")) Response.Write(HttpL3_3("受信文書", "tblbtn( '/sj4web/admin/mail/fn_jyuhasshinbunsyo.asp?PageType=受信文書&RouteType=" & RouteType & "')", "発信文書", "", "", "", "受信メール", "tblbtn( '/sj4web/admin/mail/fn_mailsakusei_ichiran.asp?PageType=受信メール&RouteType=" & RouteType & "')" ,"送信メール", "tblbtn( '/sj4web/admin/mail/fn_mailsakusei_ichiran.asp?PageType=送信メール&RouteType=" & RouteType & "')")) Else ' Response.Write(HttpL3_2("受信文書", "", "発信文書", "tblbtn( '/sj4web/admin/mail/fn_jyuhasshinbunsyo.asp?PageType=発信文書&RouteType=" & RouteType & "')", "メール作成", "tblbtn( '/sj4web/admin/mail/fn_mailsakusei.asp?RouteType=" & RouteType & "')", "受信メール", "tblbtn( '/sj4web/admin/mail/fn_mailsakusei_ichiran.asp?PageType=受信メール&RouteType=" & RouteType & "')" ,"送信メール", "tblbtn( '/sj4web/admin/mail/fn_mailsakusei_ichiran.asp?PageType=送信メール&RouteType=" & RouteType & "')")) Response.Write(HttpL3_3("受信文書", "", "発信文書", "tblbtn( '/sj4web/admin/mail/fn_jyuhasshinbunsyo.asp?PageType=発信文書&RouteType=" & RouteType & "')", "", "", "受信メール", "tblbtn( '/sj4web/admin/mail/fn_mailsakusei_ichiran.asp?PageType=受信メール&RouteType=" & RouteType & "')" ,"送信メール", "tblbtn( '/sj4web/admin/mail/fn_mailsakusei_ichiran.asp?PageType=送信メール&RouteType=" & RouteType & "')")) End If Else If PageType = "発信文書" Then Response.Write(HttpL3_2("", "", "", "", "", "", "", "", "", "")) ElseIf ShowDel = "1" Then Response.Write(HttpL3_2("削除済みを非表示", "tblbtn( 'fn_jyuhasshinbunsyo.asp?PageType=" & PageType & "&RouteType=" & RouteType & "')", "", "", "", "", "", "", "", "")) Else Response.Write(HttpL3_2("削除済みを表示", "tblbtn( 'fn_jyuhasshinbunsyo.asp?PageType=" & PageType & "&RouteType=" & RouteType & "&ShowDel=1')", "", "", "", "", "", "", "", "")) End If End If Response.Write(HttpL4(PageType , "")) %> <div id="L0" style="position: absolute; visibility: hidden; left: 0px; top: -2000px;"> <table width="100%" height="100%" border="0" cellpadding="0" cellspacing="5"> <tr> <td align="center" valign="middle"> <table width="680" height="100%" border="0" cellspacing="5" cellpadding="15" bgcolor="#ffffff" style="border:1px solid #000000"> <tr> <td align="center" background="/sj4web/images/window_bk.gif"> <table width="600" height="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td valign="middle"> <object classid="clsid:5220cb21-c88d-11cf-b347-00aa00a28331"> <param name="lpkpath" value="spread6.lpk"> </object> <object width="600" height="100%" onMouseOver="SubmitFlg=1" classid="clsid:41f841c1-ae16-11d5-8817-0050da6ef5e5" codebase="/<% = HomeAlias %>/binx/spr32x60.cab#version=1,1,1,1" id="vaSpread1" border="0"> </object> </td> </tr> </table> </td> </tr> </table> </td> </tr> </table> </div> </form> </body> <SCRIPT LANGUAGE="JavaScript"> function syokaibtn() { if(document.vaSpread1.ActiveRow >= 1) { document.vaSpread1.Col = 1; document.vaSpread1.Row = document.vaSpread1.ActiveRow; tblbtn(document.vaSpread1.Text); } else { alert("選択されていません"); } } function SubmitCheck() { form1.SendValue.value = ""; document.vaSpread1.Row = document.vaSpread1.ActiveRow; document.vaSpread1.Col = 2; var Text1; Text1 = document.vaSpread1.Text; if(Text1 == "") { alert("削除する文書を選択してください") return; } if(confirm("この操作は元に戻す事が出来ません。\r\n削除をしてもよろしいですか?")) { form1.SendValue.value = Text1; SubmitReal(form1); } return true; } function SpreadInit(fpSpread) { fpSpread.MaxRows = 0; <% Dim Query Dim Content Dim ii ii = 1 If PageType = "受信文書" Then Query = "exec SPN学生受信文書一覧 '" & GB_SystemCD & "','" & EnshuCD & "', '" & Session("UserID") & "'" ElseIf PageType = "発信文書" Then Query = "exec SPN学生発信文書一覧 '" & GB_SystemCD & "','" & EnshuCD & "', '" & Session("UserID") & "'" End If Set Content = OpenQuery(Query) ' Response.Write("Query:" & Query & "<br>") ' Exit Sub Dim TorihikisakiMeisyo,KaisyaCD Dim SakujyoFlg Dim NextUrl, Param Dim SakuseiKaisyaCD, SojyushinKubun Do While Not(Content.BOF Or Content.EOF) If ShowDel = 1 Or (ShowDel <> 1 And Content.Fields("削除フラグ") = 0) Then If PageType = "受信文書" Then ' TorihikisakiMeisyo = Content.Fields("作成会社名称") TorihikisakiMeisyo = Content.Fields("取引先名称") KaisyaCD = Content.Fields("会社CD") ElseIf PageType = "発信文書" Then TorihikisakiMeisyo = Content.Fields("取引先名称") KaisyaCD = Content.Fields("会社CD") End If SakuseiKaisyaCD = Content.Fields("作成会社CD") SojyushinKubun = Content.Fields("送受信区分") SakujyoFlg = ConvFlagMeisyo(Content.Fields("削除フラグ"), 4) If PageType = "受信文書" Then NextUrl = Content.Fields("アドレス") & Content.Fields("文書内容CD") & "&RouteType=MailOnlyRMail&SakuseiKaisyaCD=" & SakuseiKaisyaCD & "&PageType=" & PageType & "&KaisyaCD1=" & KaisyaCD Else NextUrl = Content.Fields("アドレス") & Content.Fields("文書内容CD") & "&RouteType=MailOnlySMail&SakuseiKaisyaCD=" & SakuseiKaisyaCD & "&PageType=" & PageType & "&KaisyaCD1=" & KaisyaCD End If Param = Content.Fields("作成会社CD") & "," & Content.Fields("文書種類CD") & "," & Content.Fields("文書内容CD") Response.Write(" SpreadAddItem(fpSpread);" & vbCrLf) Response.Write(" fpSpread.Row = " & ii & ";" & vbCrLf) Response.Write(" fpSpread.Col = 1;" & vbCrLf) Response.Write(" fpSpread.Text = """ & NextUrl & """;" & vbCrLf) Response.Write(" fpSpread.Col = 2;" & vbCrLf) Response.Write(" fpSpread.Text = """ & Param & """;" & vbCrLf) Response.Write(" fpSpread.Col = 3;" & vbCrLf) Response.Write(" fpSpread.Text = """ & SakujyoFlg & """;" & vbCrLf) Response.Write(" fpSpread.Col = 4;" & vbCrLf) Response.Write(" fpSpread.Text = """ & Content.Fields("処理日") & """;" & vbCrLf) Response.Write(" fpSpread.Col = 5;" & vbCrLf) Response.Write(" fpSpread.Text = """ & TorihikisakiMeisyo & """;" & vbCrLf) Response.Write(" fpSpread.Col = 6;" & vbCrLf) Response.Write(" fpSpread.Text = """ & Content.Fields("文書名称") & """;" & vbCrLf) If PageType = "受信文書" Then Response.Write(" fpSpread.Col = 7;" & vbCrLf) Response.Write(" fpSpread.Text = """ & ConvFlagMeisyo(Content.Fields("開封フラグ"), 2) & """;" & vbCrLf) End If Response.Write(" fpSpread.Col = 0;" & vbCrLf) Response.Write(" fpSpread.Text = "" "";" & vbCrLf) ii = ii + 1 End If Content.MoveNext Loop %> } </SCRIPT> <SCRIPT FOR="vaSpread1" EVENT="KeyDown(KeyAsciiCode, KeyShift)" LANGUAGE="JavaScript"> SpreadKeyDown(this, KeyAsciiCode, KeyShift); </SCRIPT> <SCRIPT FOR="vaSpread1" EVENT="ScriptLeaveCell(ColNo, RowNo, NewColNo, NewRowNo, Cancel)" LANGUAGE="VBScript"> Dim tmp tmp = SpreadChange(Me, ColNo, RowNo) If tmp = "ERR" Then Cancel = true SpreadReFocus(Me) End If </SCRIPT> <SCRIPT FOR="vaSpread1" EVENT="Click(ColNo, RowNo)" LANGUAGE="JavaScript"> // ヘッダー列クリック時にソートしない場合にはコメントアウトする SpreadClick(this, ColNo, RowNo); </SCRIPT> <SCRIPT FOR="vaSpread1" EVENT="EditMode(Col, Row, Mode, ChangeMade)" LANGUAGE="JavaScript"> this.Col = Col; this.Row = Row; if(this.CellType == 12) { if(!Mode) { this.TypeCurrencyLeadingZero = 2; } } this.focus(); </SCRIPT> <SCRIPT FOR="window" EVENT="onload" LANGUAGE="JavaScript"> // SpreadInit 第 3n + 1 引数 (nは整数) // 0:日付型 1:文字型 8:コンボボックス型 10:チェックボックス型 12:通貨型 13:数値型 21:勘定科目 22:摘要 document.vaSpread1.Redraw = false; <% If PageType = "受信文書" Then %> SpreadLoad(document.vaSpread1, "", 1 ,3, "", 1 ,3, " ", 1 ,3, "処理日", 0, 12, "取引先", 1, 24, "文書名称", 1, 26, "開封", 1, 4); <% Else %> SpreadLoad(document.vaSpread1, "", 1 ,3, "", 1 ,3, " ", 1 ,3, "処理日", 0, 12, "取引先", 1, 24, "文書名称", 1, 30); <% End If %> document.vaSpread1.ScriptEnhanced = true; //その他の Spread に関する設定はここに入れる document.vaSpread1.OperationMode = 2; document.vaSpread1.Col = 1; document.vaSpread1.ColHidden = true; document.vaSpread1.TypeMaxEditLen = 200; document.vaSpread1.Col = 2; document.vaSpread1.ColHidden = true; document.vaSpread1.TypeMaxEditLen = 200; document.vaSpread1.Row = -1; document.vaSpread1.Col = -1; document.vaSpread1.BackColor = 0xE6E6E6; document.vaSpread1.Lock = true; SpreadInit(document.vaSpread1); document.vaSpread1.Redraw = true; </SCRIPT> <% = HtmlFooter %> </html> <% End Sub %>