📄 newsysaccount.asp
字号:
<!--#include file="../config.ini" -->
<!--#include file="../commfunction.inc" -->
<%
if request("id")<>"" then
dim connq
dim rsq
set connq=server.CreateObject("adodb.connection")
set rsq=server.CreateObject("adodb.recordset")
connq.Open connstring
rsq.Open "select * from SysAccount where SysAccountId="&request("id"),connq,2,3,1
strSysAccount=rsq("SysAccount")
strused=rsq("used")
strcomplete=rsq("complete")
strdescriptions=rsq("descriptions")
strcreator=getfieldvalue("usertable","loginid",rsq("Creator"),"username")
strcreatedate=rsq("createdate")
rsq.Close
set rsq=nothing
connq.Close
set connq=nothing
end if
if request("SysAccount")<>"" then
dim conn
dim rs
set conn=server.CreateObject("adodb.connection")
set rs=server.CreateObject("adodb.recordset")
conn.Open connstring
if request("id")="" then
rs.Open "select * from SysAccount",conn,2,3,1
rs.AddNew
rs("used")=0
rs("complete")=0
rs("creator")=session("loginid")
rs("createdate")=now()
rs("lastmoduser")=session("loginid")
rs("lastmoddate")=now()
else
rs.Open "select * from SysAccount where SysAccountId="&request("id"),conn,2,3,1
rs("lastmoduser")=session("loginid")
rs("lastmoddate")=now()
end if
rs("SysAccount")=request("SysAccount")
rs("descriptions")=request("descriptions")
rs.Update
rs.Close
set rs=nothing
conn.Close
set conn=nothing
%>
<script language=javascript>
window.opener.location.reload();
window.close();
</script>
<%
end if
%>
<HTML><HEAD><TITLE>帐套</TITLE>
<LINK href="../global.css" rel=STYLESHEET type=text/css>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<script language="javascript">
function save(){
if (form1.SysAccount.value==''){
alert('请输入帐套名称');
form1.SysAccount.focus();
return;
}
form1.submit();
}
</script>
<body>
<form name=form1 method="post" id=form1>
<table width="100%" height="20" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="25"><strong><font size="2" class=title><b><%=request("type")%>帐套</b></font></strong></td>
<td> </td>
</tr>
<tr >
<td height="16" colspan="2" background="../images/title.gif"> </td>
</tr>
<tr>
<td height=4></td>
</tr>
<tr><td><div align="center" style="cursor:hand">
<a onclick="save();"><img src="../images/button_save.gif"></a>
<a onclick="window.close();"><img src="../images/button_cancel.gif"></a></DIV></td>
</tr>
</table>
<table width="100%" cellpadding="2" cellspacing="1" bgcolor="#FFFFFF">
<tr bgcolor="white">
<td width="30%" bgcolor="DEDFDE">
<div align="center"><font color=red>* </font>名称</div></td>
<td bgcolor="EFEFEF" >
<input name=SysAccount type=text value="<%=strSysAccount%>" size="20">
</td>
</tr>
<tr bgcolor="white">
<td width="30%" bgcolor="DEDFDE">
<div align="center">开帐时间</div></td>
<td bgcolor="EFEFEF" > <font color=red><%=strcreatedate%></font> </td>
</tr>
<tr bgcolor="white">
<td width="30%" bgcolor="DEDFDE">
<div align="center">创建者</div></td>
<td bgcolor="EFEFEF" > <font color=red><%=strcreator%></font> </td>
</tr>
<tr bgcolor="white">
<td width="30%" bgcolor="DEDFDE" >
<div align="center">描述</div></td>
<td bgcolor="EFEFEF">
<textarea name="descriptions" cols="25" rows="3"><%=strdescriptions%></textarea>
</td>
</tr>
</table>
</form>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -