<!-- #include file="../../include.asp" --> <% '<!-- '################################################ ' 名称 :同時同業ユーザーデータコピー ' 作成日 :2009/5/19 ' 作成者 :小野 ' 目的 :同時同業ユーザーデータのコピーを行う。 ' 概要 : '################################################ '--> %> <% main() Sub main() If Not(SessionCheck()) Then Exit Sub End If Dim Query Dim Content 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 Dim CopyMoto CopyMoto = Request("CopyMoto") Dim TmpUserID TmpUserID = Request("UserID") 'ユーザーID・演習履歴配列作成 Dim UserID Dim UserMei Dim Rireki Dim SentakuCD ReDim UserID(0) ReDim UserMei(0) ReDim Rireki(0) ReDim SentakuCD(0) Query = "exec SPMユーザー一覧 '" & GB_SystemCD & "', '" & EnshuCD & "', '%', '%', '%', '" & Date() & "'" Set Content = OpenQuery(Query) Do While Not(Content.BOF Or Content.EOF) ReDim PreServe UserID(UBound(UserID) + 1) '配列+1 ReDim PreServe UserMei(UBound(UserID)) ReDim PreServe Rireki(UBound(UserID)) ReDim PreServe SentakuCD(UBound(UserID)) UserID(UBound(UserID)) = "" & Content.Fields("学生番号") UserMei(UBound(UserID)) = "" & Content.Fields("氏名") Rireki(UBound(UserID)) = "" & Content.Fields("最終参加日時") SentakuCD(UBound(UserID)) = "" & Content.Fields("会社名称") Content.MoveNext Loop Dim TmpCnt %> <html> <% = HtmlHeader("") %> <SCRIPT LANGUAGE="JavaScript"> <!-- HomeAlias = "<% = HomeAlias %>"; HomeAliasSL = "<% = HomeAliasSL %>"; ExitFlg = 0; --> </SCRIPT> <SCRIPT LANGUAGE="JavaScript"> <!-- var lsURL="#" function syokaibtn() { if(lsURL == "#") { alert("コピー先ユーザーが選択されていません"); } else { if (form1.CopyMoto.value == "") { alert("演習コピー元のユーザーを選択してください "); form1.CopyMoto.focus(); return false; } if(confirm("\nコピー元に指定されたユーザーの演習データを \nコピー先に指定されたユーザーにコピーします。 \n\nコピー先に指定されたユーザーにすでに入力 \nされている演習データは一旦全てクリアされます。 \n\n\n初回の処理には数十秒~数分程度の時間がかかることがあります。 \n\n\nよろしいですか? \n")) { tblbtn(lsURL + "&CopyMoto=" + form1.CopyMoto.value); } } } //TRselect & URLset function celsel(rw,selURL) { var trw; trw=rw; lsURL=selURL; for (k=0; k<document.getElementById("SyoukaiList").rows.length; k++) { document.getElementById("SyoukaiList").rows[k].style.backgroundColor =""; }//セル色クリア document.getElementById("SyoukaiList").rows[rw].style.backgroundColor ="#ffcdde";//選択行色変更 } //--> </SCRIPT> </head> <body onkeydown="if(ExitFlg==2)ExitFlg=3;" onBeforeUnload="if(ExitFlg!=0)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(" 演習データをコピーする ", "syokaibtn()", "", "", "", "", "", "", "", "")) Response.Write(HttpL3_1("", "", "", "", "", "", "", "", "", "")) Response.Write(HttpL3_2("戻る", "tblbtn( '/" & HomeAlias & "/admin/enshu/fm_enshucontrol.asp?EnshuCD=" & EnshuCD & "')", "", "", "", "", "", "", "", "")) Response.Write(HttpL4("演習コントロール", "演習データコピー")) 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" class="tx1416"> <tr> <td valign="top" height="100%"> <TABLE WIDTH="820" BORDER="1" CELLPADDING="0" CELLSPACING="0" BORDERCOLOR="#000000" BGCOLOR="#FFFFCC" CLASS="tx1416" STYLE="border-collapse: collapse"> <TR ALIGN="CENTER"> <TD HEIGHT="30" align="center">対象演習名</TD> <TD height="30" align="center"> <% = EnshuMeisyo %> </TD> <TD HEIGHT="30" align="center">コピー元</TD> <TD height="30" align="center"> <select size="1" name="CopyMoto" class="tbox4"> <option value=""><< 選択して下さい >></option> <% For TmpCnt = 1 To UBound(UserID) Response.Write("<option value=""" & UserID(TmpCnt) & """") If UCase(UserID(TmpCnt)) = UCase(CopyMoto) Then Response.Write(" selected") End If Response.Write(">" & UserMei(TmpCnt) & "</option>" & vbCrLf) Next %> </select> </TD> </TR> </table> <div><% = Spacer(1,5) %></div> コピー先ユーザーを以下から指定してください。 <table BORDER="0" CELLPADDING="0" CELLSPACING="0"> <TR> <TD VALIGN="BOTTOM" WIDTH="640"> <TABLE HEIGHT="24" BORDER="1" WIDTH="820" CELLPADDING="3" CELLSPACING="0" BORDERCOLOR="#000000" BGCOLOR="#FFFFCC" CLASS="tx1416" STYLE="border-collapse: collapse"> <TR ALIGN="CENTER"> <TD HEIGHT="20" WIDTH="130">ユーザーID</TD> <TD HEIGHT="20" WIDTH="240">氏名</TD> <TD HEIGHT="20">選択会社</TD> <TD HEIGHT="20" WIDTH="141">最終参加日時</TD> </TR> </TABLE> </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:420px; z-index:1; border: 1px none #000000; overflow: auto;"> <TABLE ID="SyoukaiList" BORDER="1" WIDTH="820" CELLSPACING="0" CELLPADDING="3" BGCOLOR="#FFFFFF" CLASS="tx1416" STYLE="border-collapse: collapse" BORDERCOLOR="#000000"> <% Dim jj, iiDef iiDef = -1 For TmpCnt = 1 To UBound(UserID) If UCase(UserID(TmpCnt)) = UCase(TmpUserID) Then iiDef = TmpCnt - 1 End If Response.Write("<TR ALIGN=""CENTER"" style=""cursor:hand"" onClick=""celsel(" & TmpCnt - 1 & ", 'fm_enshucontrol03_bin.asp?EnshuCD=" & EnshuCD & "&UserID=" & UserID(TmpCnt) & "')"" onDblClick=""syokaibtn()"">" & vbCrLf) Response.Write("<TD HEIGHT=""21"" WIDTH=""130"" ALIGN=""center"">" & UserID(TmpCnt) & "</TD>" & vbCrLf) Response.Write("<TD WIDTH=""240"" ALIGN=""center"">" & UserMei(TmpCnt) & "</TD>" & vbCrLf) Response.Write("<TD ALIGN=""center"">" & SentakuCD(TmpCnt) & "</TD>" & vbCrLf) Response.Write("<TD WIDTH=""141"" ALIGN=""center"">" & Rireki(TmpCnt) & "</TD>" & vbCrLf) Response.Write("</TR>" & vbCrLf) Next %> </TABLE> </DIV> </TD> </TR> </TABLE> </TD> </TR> </TABLE> </td> </tr> </table> </td> </tr> </table> </DIV> </form> </body> <SCRIPT FOR="window" EVENT="onload" LANGUAGE="JavaScript"> <% If iiDef <> -1 Then %> celsel(<% = iiDef %>, 'fm_enshucontrol03_bin.asp?EnshuCD=<% = EnshuCD %>&UserID=<% = UserID(iiDef + 1) %>') Layer1.scrollTop = <% = (iiDef - 5) * 21 %>; <% End If %> </script> <% = HtmlFooter %> </html> <% End Sub %>