<!-- #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
%>