📄 import.asp
字号:
<!-- #include file = "../include/asphead.asp" -->
<!-- #include file = "../include/function.asp" -->
<%CheckUser()%>
<SCRIPT ID=clientEventHandlersJS LANGUAGE=javascript>
<!--
function Init()
{
window.parent.parent.navigate("importresult.asp")
}
//-->
</SCRIPT>
<%
dim WExcel
set WExcel=server.CreateObject("WExcel.ImExport")
dim ExcelSheet,Head,SheetID,DictID
dim ValidSheetDataCount,InvalidSheetDataCount
dim FromRowID
dim Result
ExcelSheet=Request.Cookies("ImExport")("ExcelSheet")
Head=Request.Cookies("ImExport")("Head")
if Request.Cookies("Temp")("ImportFor")="dictitem" then
DictID=Request.Cookies("System")("DictID")
Result=WExcel.ImportDictData(cint(UserID),cstr(ExcelSheet),cint(Head),cint(DictID),FromRowID,ValidSheetDataCount,InvalidSheetDataCount)
Response.Cookies("ImExport")("Result")=Result
Response.Cookies("ImExport")("ImportedCount")=ValidSheetDataCount
Response.Cookies("ImExport")("DiscardCount")=InvalidSheetDataCount
elseif Request.Cookies("Temp")("ImportFor")="useraccount" then
Result=WExcel.ImportUserAccount(cint(UserID),cstr(ExcelSheet),cint(Head),FromRowID,ValidSheetDataCount,InvalidSheetDataCount)
Response.Cookies("ImExport")("Result")=Result
Response.Cookies("ImExport")("ImportedCount")=ValidSheetDataCount
Response.Cookies("ImExport")("DiscardCount")=InvalidSheetDataCount
else
SheetID=Request.Cookies("Temp")("SheetID")
Result=WExcel.ImportSheetData(cint(UserID),cstr(ExcelSheet),cint(Head),cint(SheetID),FromRowID,ValidSheetDataCount,InvalidSheetDataCount)
Response.Cookies("ImExport")("Result")=Result
Response.Cookies("ImExport")("ImportedCount")=ValidSheetDataCount
Response.Cookies("ImExport")("DiscardCount")=InvalidSheetDataCount
Response.Cookies("ImExport").Expires = CookieLife '由于导出选项Cookie需要保留，所以这里也应设置生命期
if Result=0 and ValidSheetDataCount>0 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 + -