📄 datadetail.asp
字号:
<!--#include file="headfiles/Connection.inc"-->
<%
dim intTID
intTid=request("tid")
if intTid="" then
intTid=1
else
intTid=cint(intTid)
end if
if intTid=1 then
response.Redirect("DepartDetail.asp")
end if
dim rsItem
set rsItem=server.CreateObject("ADODB.RECORDSET")
select case intTID
case 1
strSql="select Depart_ID as itemID,Depart_Name as itemName from DepartTable"
case 2
strSql="select EduDegree_ID as itemID,EduDegree_Name as itemName from EduDegreeTable"
case 3
strSql="select EmployeeType_ID as itemID,EmployeeType_Name as itemName from EmployeeTypeTable"
case 4
strSql="select PayType_ID as itemID,PayType_Name as itemName from PayTypeTable"
case 5
strSql="select ForeignLanguage_ID as itemID,ForeignLanguage_Name as itemName from ForeignLanguageTable"
case 6
strSql="select JobTitle_ID as itemID,JobTitle_Name as itemName from JobTitleTable"
case 7
strSql="select Position_ID as itemID,Position_Name as itemName from PositionTable"
case 8
strSql="select Nation_ID as itemID,Nation_Name as itemName from NationTable"
case 9
strSql="select Political_ID as itemID,Political_Name as itemName from PoliticalTable"
case 10
strSql="select Married_ID as itemID,Married_Name as itemName from MarriedTable"
case 11
strSql="select Level_ID as itemID,Level_Name as itemName from LevelTable"
case 12
strSql="select UserPower_ID as itemID,UserPower_Name as itemName from UserPowerTable"
case else
strSql="select Depart_ID as itemID,Depart_Name as itemName from DepartTable"
end select
rsItem.open strSql,Conn,3,1
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<link href="headfiles/text.css" rel="stylesheet" type="text/css">
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_swapImgRestore() { //v3.0
var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_swapImage() { //v3.0
var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>
</head>
<body background="images\bg.gif" onLoad="saveTr.style.display='none';MM_preloadImages('images/save1.gif','images/undo1.gif')">
<%
response.Write chr(10)&chr(13)&"<table border=0 width=500 height=370 cellpadding=10 cellspacing=0><tr><td valign=top align=center style="&chr(34)&"BORDER-RIGHT: 1px outset; BORDER-TOP: 1px outset; BORDER-LEFT: 1px outset; BORDER-BOTTOM: 1px outset"&chr(34)&">"
response.Write chr(10)&chr(13)&"<table width=480 border=1 cellpadding=0 cellspacing=0 bordercolordark="&chr(34)&"#dddddd"&chr(34)&" bordercolorlight="&chr(34)&"#dddddd"&chr(34)&">"
Response.Write chr(10)&chr(13)&"<tr class=title2><td height=20 width=45 align=center>序号</td><td width=95 align=center>编号</td><td width=240 align=center>名称</td><td align=center width=50>修改</td><td align=center width=50>删除</td></tr>"
dim intCount
intCount=1
while not rsItem.BOF and not rsItem.EOF
Response.Write chr(10)&chr(13)&"<tr><td width=45 height=25 align=center>"&intCount&"</td><td width=95 align=center><input type=text style="&chr(34)&"width:80px"&chr(34)&" name=txtNumber value="&rsItem("itemID")&" disabled=ture></td><td width=240 align=center><input type=text style="&chr(34)&"width:230px"&chr(34)&" name=txtName value="&rsItem("itemName")&" disabled=ture></td><td width=50 align=center><img src=images\modify2.gif alt=修改 onMouseOut="&chr(34)&"this.className='normal'"&chr(34)&" onMouseOver="&chr(34)&"this.className='hand'"&chr(34)&" onclick='ModifyItem("&intCount&");'></td><td width=50 align=center><img src=images\del2.gif alt=删除 onMouseOver="&chr(34)&"this.className='hand'"&chr(34)&" onMouseOut="&chr(34)&"this.className='normal'"&chr(34)&" onclick='DeleteItem("&intCount&");'></td></tr>"
intCount=intCount+1
rsItem.MoveNext
wend
Response.Write chr(10)&chr(13)&"<tr><td width=45 align=center>"&rsItem.RecordCount+1&"</td><td width=95 align=center><input type=text style="&chr(34)&"width:80px"&chr(34)&" name=txtNumber value='(自动添加)' disabled></td><td width=240 align=center><input type=text style="&chr(34)&"width:230px"&chr(34)&" name=txtName disabled=ture></td><td width=100 colspan=2 align=center><img src='images\new3.gif' alt='添加新纪录' onMouseOver="&chr(34)&"this.className='hand'"&chr(34)&" onMouseOut="&chr(34)&"this.className='normal'"&chr(34)&" onclick='ModifyItem("&intCount&");'></td></tr>"
%>
<script language="JavaScript">
<!--
function ModifyItem(i){
var j;
if(saveTr.style.display=='block'){
alert ("当前有操作未完成！\n\n\n请先保存或取消！");
return false;
}
for(j=0;j<=<%=intCount-1%>;j++){
txtNumber(j).disabled=true;
txtName(j).disabled=true;
}
txtName(j-1).value="";
txtName(i-1).disabled=false;
saveTr.style.display='block';
if(i==<%=intCount%>){
frmDataDetail.txtNum.value=1;
}else{
frmDataDetail.txtNum.value=2;
}
}
function DeleteItem(i){
var j;
var msg;
if(saveTr.style.display=='block'){
alert ("正在添加或修改，不能删除！\n\n\n请先保存或取消！");
return false;
}
for(j=0;j<=<%=intCount-1%>;j++){
txtNumber(j).disabled=true;
txtName(j).disabled=true;
}
txtNumber(j-1).value="";
txtName(j-1).value="";
frmDataDetail.txtNum.value=3;
msg=confirm("确定要删除吗？");
if (msg==true){
txtNumber(i-1).disabled=false;
//window.open("DeleteData.asp?tid=<%=intTid%>");
//window.open("AddData.asp?tid=<%=intTid%>","new");
frmDataDetail.txtID.value=txtNumber(i-1).value;
frmDataDetail.action="DeleteData.asp?tid=<%=intTid%>";
frmDataDetail.submit();
}else{
return false;
}
}
function optCancel(){
var j;
for(j=0;j<=<%=intCount-1%>;j++){
txtNumber(j).disabled=true;
txtName(j).disabled=true;
}
txtName(j-1).value="";
saveTr.style.display='none';
frmDataDetail.txtNum.value=0;
}
function optSave(){
var i,j,k;
var msg;
for(i=0;i<=<%=intCount-1%>;i++){
if(txtName(i).disabled==false){
// alert(i);
k=i;
if((txtName(i).value).length==0){
alert("对不起，您还没有输入名称！");
txtName(i).focus();
return false;
}
for(j=0;j<<%=intCount-1%>;j++){
if((txtName(i).value==txtName(j).value)&&(j!=i)){
alert("名称有重复，请用其它名称！");
txtName(i).focus();
return false;
}
}
}
}
msg=confirm("确定要保存当前值吗？");
if(msg==true){
txtNumber(k).disabled=false;
if(frmDataDetail.txtNum.value==1){
for(i=0;i<=<%=intCount-1%>;i++){
if(txtName(i).disabled==false){
//window.open("AddData.asp?tid=<%=intTid%>","new");
frmDataDetail.txtName.value=txtName(i).value;
frmDataDetail.action="AddData.asp?tid=<%=intTid%>";
frmDataDetail.submit();
}
}
}else{
//window.open("ModifyData.asp?tid=<%=intTid%>","new");
for(i=0;i<=<%=intCount-1%>;i++){
if(txtName(i).disabled==false){
//window.open("AddData.asp?tid=<%=intTid%>","new");
frmDataDetail.txtID.value=txtNumber(i).value;
frmDataDetail.txtName.value=txtName(i).value;
frmDataDetail.action="ModifyData.asp?tid=<%=intTid%>";
frmDataDetail.submit();
}
}
}
}else{
txtNumber(k).disabled=true;
}
}
//-->
</script>
<form target="_parent" method="post" id="frmDataDetail">
<tr id="saveTr"><td colspan=5><input type="text" style="visibility:hidden;width:80px" name="txtID" id="txtID"><input type="text" style="visibility:hidden;width:80px" name="txtName" id="txtName">
<a onClick="optSave();" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image1','','images/save1.gif',1)"><img src="images/save.gif" name="Image1" width="60" height="25" border="1"></a>
<input type="text" style="visibility:hidden;width:20px" id=txtNum>
<a onClick="optCancel();" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image2','','images/undo1.gif',1)"><img src="images/undo.gif" name="Image2" width="60" height="25" border="1"></a></td>
</tr>
</form>
</table></td></tr></table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -