📄 save.asp
字号:
<!-- #include file = "../../../include/function.asp" -->
<%CheckUser()%>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<SCRIPT ID=clientEventHandlersJS LANGUAGE=javascript>
<!--
function window_onload() {
if (SheetExist.value!="1")
alert("保存失败。数据表不存在，可能被其他人删除掉了，请检查。");
else
{
if (Exist.value=="1")
{
alert("字段名重名。数据表中已有相同字段名的字段，请更改后再保存。");
}
else
if (LoopPath.value!="")
alert("公式中的字段循环调用，" + LoopPath.value + "，这是不允许的，请检查更改。");
else
if (Result.value==0)
window.parent.parent.close()
else
alert("保存失败。");
}
window.parent.EnableButton();
}
//-->
</SCRIPT>
</HEAD>
<BODY LANGUAGE=javascript onload="return window_onload()">
<%
dim WExcel
set WExcel=server.CreateObject("WExcel.System")
NewRecord=Request.Form("NewRecord")
SheetID=Request.Cookies("System")("StructureSheetID")
dim SheetExist
SheetExist=WExcel.SheetExist(cint(UserID),cint(SheetID))
if SheetExist=false then
SheetExist="0"
else
SheetExist="1"
dim Exist,Result
dim FormulaStr,LoopPath
FormulaStr=trim(Request.Form("FormulaStr"))
LoopPath=""
if NewRecord<>"1" then
RowID=Request.Form("RowID")
Exist=WExcel.CheckFieldExist(cint(SheetID),cstr(NewRecord),clng(RowID))
if Exist<>"1" then
if FormulaStr<>"" then
'循环检查
LoopPath=WExcel.CheckFormulaLoop(cint(SheetID),cint(RowID),cstr(FormulaStr))
if LoopPath="" then
Result=WExcel.SaveField(cint(UserID),cint(SheetID),cstr(NewRecord),clng(RowID))
end if
else
Result=WExcel.SaveField(cint(UserID),cint(SheetID),cstr(NewRecord),clng(RowID))
end if
end if
else
Exist=WExcel.CheckFieldExist(cint(SheetID),cstr(NewRecord))
if Exist<>"1" then
Result=WExcel.SaveField(cint(UserID),cint(SheetID),cstr(NewRecord))
end if
end if
end if
CheckErr
%>
<input TYPE="hidden" NAME="SheetExist" value="<%=SheetExist%>">
<input TYPE="hidden" NAME="Exist" value="<%=Exist%>">
<input TYPE="hidden" NAME="LoopPath" value="<%=LoopPath%>">
<input TYPE="hidden" NAME="Result" value="<%=Result%>">
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -