📄 copydata.asp
字号:
<!-- #include file = "../include/asphead.asp" -->
<!-- #include file = "../include/function.asp" -->
<%CheckUser()%>
<SCRIPT ID=clientEventHandlersJS LANGUAGE=javascript>
<!--
function Init()
{
window.parent.parent.navigate("copyresult.asp")
}
//-->
</SCRIPT>
<%
dim WExcel
set WExcel=server.CreateObject("WExcel.ImExport")
dim SheetID
SheetID=Request.Cookies("Temp")("SheetID")
dim CopyTo
CopyTo=Request.Cookies("ImExport")(SheetID & "CopyTo")
dim CopyRange,CurSelectedRows,PageRows
CopyRange=Request.Cookies("ImExport")("CopyRange")
CurSelectedRows=Request.Cookies("ImExport")("CurSelectedRows")
PageRows=Request.Cookies("ImExport")("PageRows")
dim RowIDs,strWhere
if CopyRange=0 then
RowIDs=PageRows
elseif CopyRange=1 then
RowIDs=CurSelectedRows
else
RowIDs=""
end if
strWhere=Request.Cookies("Temp")("Where" & SheetID)
dim ValidSheetDataCount,InvalidSheetDataCount
dim FromRowID
WExcel.CopySheetData cint(UserID),cint(SheetID),cint(CopyTo),cstr(strWhere),cint(CopyRange),cstr(RowIDs),FromRowID,ValidSheetDataCount,InvalidSheetDataCount
Response.Cookies("ImExport")("ImportedCount")=ValidSheetDataCount
Response.Cookies("ImExport")("DiscardCount")=InvalidSheetDataCount
Response.Cookies("ImExport").Expires = CookieLife '由于导出选项Cookie需要保留，所以这里也应设置生命期
if ValidSheetDataCount>0 then
if SheetID=CopyTo then '如果是在本表中复制，需要更新列表显示
Response.Cookies("Temp")("AddMode" & SheetID)="1"
if Request.Cookies("Temp")("FirstAddRowID" & SheetID)="" then
Response.Cookies("Temp")("FirstAddRowID" & SheetID)=FromRowID
elseif cint(Request.Cookies("Temp")("FirstAddRowID" & SheetID))<=0 then
Response.Cookies("Temp")("FirstAddRowID" & SheetID)=FromRowID
end if
end if
end if
CheckErr
%>
<body LANGUAGE=javascript onload="return Init()">
</body>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -