import.asp

来自「学生档案与成绩管理(1)学生档案管理:记录每个学生的档案信息」· ASP 代码 · 共 55 行

ASP
55
字号
<!-- #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 + =
减小字号Ctrl + -
显示快捷键?