<!-- #include file="../../include.asp" -->
<%
'<!--
'################################################
' 名称 ：出入庫一覧表示
' 作成日 ：2013/05/17
' 作成者 ：小野
' 目的 ：出入庫を一覧表示する。
' 概要 ：入出庫整合性有り演習でのみ利用
'################################################
'-->
%>
<%
main()
Sub main()
If Not(SessionCheck()) Then
Exit Sub
End If
Dim Query
Dim Content
Dim Content2
Dim EnshuCD
Dim EnshuName
EnshuCD = Request("EnshuCD")
If EnshuCD <> "" Then
Query = "exec SPM演習取得 '" & GB_SystemCD & "', '" & EnshuCD & "'"
Set Content = OpenQuery(Query)
If Not(Content.BOF Or Content.EOF) Then
EnshuName = Content.Fields("演習名称")
End If
End If
%>
<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="../../binx/sj3web.css?<% = TimeUniq() %>" rel="stylesheet" type="text/css">
<title><% = AppTitle %></title>
<script language="JScript" src="../../include.js?<% = TimeUniq() %>"></script>
<script language="JScript" src="../../includesj.js?<% = TimeUniq() %>"></script>
<script language="JScript.Encode" src="../../include_enc.js?<% = TimeUniq() %>"></script>
<script language="JScript.Encode" src="../../includesj_enc.js?<% = TimeUniq() %>"></script>
<script type="text/javascript" src="../../javascript.js?<% = TimeUniq() %>"></script>
</head>
<SCRIPT LANGUAGE="JavaScript">
<!--
HomeAlias = "<% = HomeAlias %>";
HomeAliasSL = "<% = HomeAliasSL %>";
ExitFlg = 0;
-->
</SCRIPT>
<SCRIPT LANGUAGE="JavaScript">
<!--
//メッセージ格納変数
var Message = "";
var lsURL="#"
function syokaibtn() {
if (lsURL == "#") {
alert("選択されていません");
} else {
if (confirm("以下の出入庫を組戻してよろしいですか？ \n\n" + Message)) {
tblbtn(lsURL);
}
}
}
//TRselect & URLset
function celsel(rw,selURL) {
var trw;
trw=rw;
lsURL=selURL;
for (k=0; k<document.all['SyoukaiList'].rows.length; k++) {
document.all['SyoukaiList'].rows[k].style.backgroundColor ="";
}//セル色クリア
document.all['SyoukaiList'].rows[rw].style.backgroundColor ="#ffcdde";//選択行色変更
//メッセージ格納変数に代入する
Message = "";
<%
Dim RowCnt
RowCnt = 0
Dim TmpMes
Query = "exec SPK演習出庫連動入庫一覧 '" & GB_SystemCD & "', '" & EnshuCD & "'"
Set Content = OpenQuery(Query)
Do While Not(Content.BOF Or Content.EOF)
TmpMes = ""
If ConvEnshuKubun(EnshuCD) = "P" Then
TmpMes = TmpMes & "学生氏名:" & ConvGakuseiShimei(ConvKaisyaGakuseiNo(EnshuCD, Content.Fields("作成会社CD"))) & "\n"
Else
TmpMes = TmpMes & "会社コード:" & Content.Fields("作成会社CD") & "\n"
End If
TmpMes = TmpMes & "出庫会社:" & Content.Fields("出庫会社名称") & "\n"
If Content.Fields("文書種類CD") = "SU" Then
TmpMes = TmpMes & "区分:通常" & " "
Else
TmpMes = TmpMes & "区分:返品" & " "
End If
TmpMes = TmpMes & "出庫No:" & Content.Fields("文書内容CD") & " "
TmpMes = TmpMes & "出庫日:" & Content.Fields("処理日") & "\n"
TmpMes = TmpMes & "取引先:" & Content.Fields("取引先名称") & "\n"
Query = "exec SPD入出庫取得 '" & GB_SystemCD & "','" & EnshuCD & "', '" & Content.Fields("会社CD") & "', '" & Content.Fields("作成会社CD") & "', '" & Content.Fields("文書種類CD") & "', '" & Content.Fields("文書内容CD") & "'"
Set Content2 = OpenQuery(Query)
Do While Not(Content2.BOF Or Content2.EOF)
TmpMes = TmpMes & "\n" & ConvSyohinMeisyo(Content2.Fields("商品CD"))
TmpMes = TmpMes & " 数量" & SetMoney(Content2.Fields("数量"), false, true)
TmpMes = TmpMes & " 単価" & SetMoney(Content2.Fields("単価"), false, true)
Content2.MoveNext
Loop
Response.Write(" if (rw == " & RowCnt & ") {" & vbCrLf)
Response.Write(" Message = """ & TmpMes & """;" & vbCrLf)
' Response.Write(" alert(Message);" & vbCrLf)
Response.Write(" }" & vbCrLf)
RowCnt = RowCnt + 1
Content.MoveNext
Loop
%>
}
//-->
</SCRIPT>
</head>
<body onkeydown="if(ExitFlg==2)ExitFlg=3;" onBeforeUnload="window.event.returnValue = ExitMsg(ExitFlg)" bgcolor="#5C70B6" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<form OnKeyDown="FormKeyDown(this)" name="form1" method="GET" action="fm_kityochk_ichiran.asp" onSubmit="return SubmitCheck();">
<%
Response.Write(HtmlDesign(1))
Response.Write(HttpL1(4))
If GB_Admin = 1 Then
Response.Write(HttpL2("運用管理メニュー" ,"tblbtn( '/" & HomeAlias & "/admin/admenu_w.asp')", "演習管理", "tblbtn( '/" & HomeAlias & "/admin/enshu/fm_enshu_ichiran.asp?EnshuCD=" & EnshuCD & "')", "演習コントロール", "tblbtn( '/" & HomeAlias & "/admin/enshu/fm_enshucontrol.asp?EnshuCD=" & EnshuCD & "')", "出入庫組戻し", "", "", "", "", ""))
Else
Response.Write(HttpL2("運用管理メニュー" ,"tblbtn( '/" & HomeAlias & "/admin/admenu_w.asp')", "演習管理", "tblbtn( '/" & HomeAlias & "/admin/enshu/fm_enshu1_view.asp?EnshuCD=" & EnshuCD & "')", "演習コントロール", "tblbtn( '/" & HomeAlias & "/admin/enshu/fm_enshucontrol.asp?En6shuCD=" & EnshuCD & "')", "出入庫組戻し", "", "", "", "", ""))
End If
Response.Write(HttpL3("","" ,"", "", "", "", "", "", "", "", "", "", "", "", "", ""))
Response.Write(HttpL3_1("印刷", "PrintoutRealInline('" & Replace(Request.ServerVariables("URL"), ".asp", "_print.asp") & "?EnshuCD=" & EnshuCD & "');", " 出入庫を組戻す ", "syokaibtn()", "", "", "", "", "", ""))
'Response.Write(HttpL3_1("", "", "", "", "", "", "", "", "", ""))
Response.Write(HttpL3_2("戻る", "tblbtn( '/" & HomeAlias & "/admin/enshu/fm_enshucontrol.asp?EnshuCD=" & EnshuCD & "')", "", "", "", "", "", "", "", ""))
Response.Write(HttpL4("演習コントロール", "出入庫組戻し"))
'Response.Write(HttpL5("未入庫の出庫を表示しています"))
Response.Write(HttpL5(""))
%>
<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">
<table width="650" height="100%" border="0" cellspacing="5" cellpadding="5" bgcolor="#ffffff" style="border:1px solid #000000">
<tr>
<td align="center" background="/<% = HomeAlias %>/images/window_bk.gif?<% = GB_STU %>">
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="5">
<tr>
<td valign="top">
<TABLE WIDTH="819" HEIGHT="30" BORDER="1" CELLPADDING="0" CELLSPACING="0" BORDERCOLOR="#000000" BGCOLOR="#FFFFCC" CLASS="tx1416" STYLE="border-collapse: collapse">
<TR ALIGN="CENTER">
<TD width="90" align="center">対象演習名</TD>
<TD align="center">
<% = EnshuMeisyo %>
</TD>
</TR>
</table>
<table BORDER="0" CELLPADDING="0" CELLSPACING="0">
<TR>
<TD VALIGN="TOP">
<DIV ID="Layer1" STYLE="position:relative; left:0px; top:0px; width:840px; height:480px; z-index:1; border: 1px none #000000; overflow: auto;">
<TABLE ID="SyoukaiList" BORDER="0" WIDTH="819" CELLSPACING="0" CELLPADDING="0" BGCOLOR="#FFFFFF" CLASS="tx1416" STYLE="border-collapse: collapse" BORDERCOLOR="#000000">
<%
Dim ii
ii = 0
' Query = "exec SPK演習出庫非受付一覧 '" & GB_SystemCD & "', '" & EnshuCD & "'"
Query = "exec SPK演習出庫連動入庫一覧 '" & GB_SystemCD & "', '" & EnshuCD & "'"
Set Content = OpenQuery(Query)
Do While Not(Content.BOF Or Content.EOF)
Response.Write("<TR ALIGN=""CENTER"" style=""cursor:hand"" onClick=""celsel(" & ii & ",'fm_enshucontrol02_bin.asp?EnshuCD=" & Content.Fields("演習CD") & "&KaisyaCD=" & Content.Fields("会社CD") & "&SakuseiKaisyaCD=" & Content.Fields("作成会社CD") & "&NyukoKaisyaCD=" & Content.Fields("取引先CD") & "&BunsyoSyuruiCD=" & Content.Fields("文書種類CD") & "&BunsyoNaiyoCD=" & Content.Fields("文書内容CD") & "')"" onDblClick=""syokaibtn()"">" & vbCrLf)
Response.Write("<TD align=""left"">" & vbCrLf)
'行内を入れ子テーブルにする
Response.Write("<TABLE BORDER=""1"" WIDTH=""819"" CELLSPACING=""0"" CELLPADDING=""3"" CLASS=""tx1416"" STYLE=""border-collapse: collapse"" BORDERCOLOR=""#000000"">" & vbCrLf)
'見出し
Response.Write("<TR bgcolor=""#dddddd"">" & vbCrLf)
If ConvEnshuKubun(EnshuCD) = "P" Then
Response.Write("<TD HEIGHT=""20"" ALIGN=""LEFT"">学生氏名</TD>" & vbCrLf)
Else
Response.Write("<TD HEIGHT=""20"" ALIGN=""LEFT"">会社コード</TD>" & vbCrLf)
End If
Response.Write("<TD HEIGHT=""20"" WIDTH=""210"" ALIGN=""LEFT"">出庫会社</TD>" & vbCrLf)
Response.Write("<TD HEIGHT=""20"" WIDTH=""30"" ALIGN=""CENTER"">区分</TD>" & vbCrLf)
Response.Write("<TD HEIGHT=""20"" WIDTH=""50"" ALIGN=""CENTER"">出庫No</TD>" & vbCrLf)
Response.Write("<TD HEIGHT=""20"" WIDTH=""82"" ALIGN=""CENTER"">出庫日</TD>" & vbCrLf)
Response.Write("<TD HEIGHT=""20"" WIDTH=""210"" ALIGN=""LEFT"">取引先</TD>" & vbCrLf)
Response.Write("</TR>" & vbCrLf)
Response.Write("<TR>" & vbCrLf)
If ConvEnshuKubun(EnshuCD) = "P" Then
Response.Write("<TD HEIGHT=""20"" ALIGN=""LEFT"">" & ConvGakuseiShimei(ConvKaisyaGakuseiNo(EnshuCD, Content.Fields("作成会社CD"))) & "</TD>" & vbCrLf)
Else
Response.Write("<TD HEIGHT=""20"" ALIGN=""LEFT"" >" & Content.Fields("作成会社CD") & "</TD>" & vbCrLf)
End If
Response.Write("<TD HEIGHT=""20"" ALIGN=""LEFT"">" & Content.Fields("出庫会社名称") & "</TD>" & vbCrLf)
Response.Write("<TD HEIGHT=""20"" ALIGN=""CENTER"">")
If Content.Fields("文書種類CD") = "SU" Then Response.Write("通常") Else Response.Write("返品") End If
Response.Write("</TD>" & vbCrLf)
Response.Write("<TD HEIGHT=""20"" ALIGN=""CENTER"">" & Content.Fields("文書内容CD") & "</TD>" & vbCrLf)
Response.Write("<TD HEIGHT=""20"" ALIGN=""CENTER"">" & Content.Fields("処理日") & "</TD>" & vbCrLf)
Response.Write("<TD HEIGHT=""20"" ALIGN=""LEFT"">" & Content.Fields("取引先名称") & "</TD>" & vbCrLf)
Response.Write("</TR>" & vbCrLf)
Response.Write("</TABLE>" & vbCrLf)
Response.Write("<TABLE BORDER=""0"" CELLSPACING=""0"" CELLPADDING=""3"" CLASS=""tx1416"" STYLE=""border-collapse: collapse;"" BORDERCOLOR=""#000000"">" & vbCrLf)
Response.Write("<TR>" & vbCrLf)
Dim ShohinCnt
ShohinCnt = 0
Query = "exec SPD入出庫取得 '" & GB_SystemCD & "','" & EnshuCD & "', '" & Content.Fields("会社CD") & "', '" & Content.Fields("作成会社CD") & "', '" & Content.Fields("文書種類CD") & "', '" & Content.Fields("文書内容CD") & "'"
Set Content2 = OpenQuery(Query)
Do While Not(Content2.BOF Or Content2.EOF)
ShohinCnt = ShohinCnt + 1
If ShohinCnt = 3 Or ShohinCnt = 5 Then
Response.Write("</TR>" & vbCrLf)
Response.Write("<TR>" & vbCrLf)
End If
Response.Write("<TD bgcolor=""#dddddd"" WIDTH=""38"" style=""border:solid 1px #000000;border-top:none;"">商品" & ShohinCnt & "</TD>" & vbCrLf)
Response.Write("<TD WIDTH=""113"" style=""border:solid 1px #000000;border-top:none;"">" & ConvSyohinRyakuMeisyo(Content2.Fields("商品CD")) & "</TD>" & vbCrLf)
Response.Write("<TD WIDTH=""100"" style=""border:solid 1px #000000;border-top:none;"">数量：" & SetMoney(Content2.Fields("数量"), false, true) & "</TD>" & vbCrLf)
Response.Write("<TD WIDTH=""130"" style=""border:solid 1px #000000;border-top:none;"">単価：" & SetMoney(Content2.Fields("単価"), false, true) & "</TD>" & vbCrLf)
Content2.MoveNext
Loop
If ShohinCnt Mod 2 = 1 Then
'If ShohinCnt = 3 Or ShohinCnt = 5 Then
Response.Write("<TD WIDTH=""402"" colspan=""4"" style=""border:solid 1px #000000;border-top:none;""> </TD>" & vbCrLf)
End If
Response.Write("</TR>" & vbCrLf)
Response.Write("</TABLE>" & vbCrLf)
Response.Write("</TD>" & vbCrLf)
Response.Write("</TR>" & vbCrLf)
ii = ii + 1
Content.MoveNext
Loop
%>
</TABLE>
</DIV>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</td>
</tr>
</table>
</td>
</tr>
</table>
</DIV>
</form>
<!--印刷出力用フレーム-->
<IFRAME name="PrintoutInline" SRC="" WIDTH="0" HEIGHT="0" FRAMEBORDER=0 MARGINHEIGHT=0 MARGINWIDTH=0 NORESIZE SCROLLING=no tabindex="-1"></IFRAME>
</body>
<% = HtmlFooter %>
</html>
<%
End Sub
%>