📄 wnp_user_edit.asp
字号:
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<!--#include file="WNP_INCLUDE.ASP" -->
<%
pagename="WNP_USER_EDIT.ASP"
unitLeftSameStep=session("UNIT_Jibie")*session("EveryStepNumber")
unitAllTempStep=(session("UNIT_Jibie")+1)*session("EveryStepNumber")
%>
<table width="760" height="20" border="0" align="center" cellpadding="0" cellspacing="0" class="textmost">
<form name="search" method="post" action="<%=pagename%>">
<tr valign="bottom">
<td height="15" colspan="6" align="center"> </td>
<tr valign="bottom" bgColor=#fdfaf4 borderColorDark=#ffffff border=1>
<td width="85" height="20" align="center">查询：</td>
<td width="183"><input name="key1" type="text" id="key1"></td>
<td colspan="4" align="left" bgcolor="#fdfaf4"><input type="image" src="IMAGES/search.jpg"></td>
<tr valign="bottom">
<td height="15" colspan="6" align="center"> </td>
</form>
</table>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="30" align="center" class="title1">用户编辑</td>
</tr>
</table>
<table width="760" height="400" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td valign="top">
<table bgColor=#fdfaf4 borderColorDark=#ffffff border=1 cellspacing=0 cellpadding=0 align=center width=760 bordercolorlight=#999999 class=textmost>
<tr align="center" valign="bottom" class="texttitle">
<td width="55" height="30">用户序号</td>
<td>用户名</td>
<td>用户密码</td>
<td>单位名称</td>
<td width="100">用户类型</td>
<td width="160">有效期</td>
<td width="58">提交</td>
</tr>
<!--#include file="WNP_USER_SQL.ASP" -->
<%
do while not rs.eof and c<MaxPerPage
%>
<form name="form2" method="post" action="WNP_USER_SAVE.ASP?userid=<%=rs("WND_USER_ID")%>">
<tr align="center" valign="bottom">
<td height="20"><input name="userOrder" type="text" class="textInput1" id="userOrder" value="<%=rs("WND_USER_Order")%>" size="4" maxlength="4" ></td>
<td width="90"><input name="WND_USER_USERNAME" type="text" class="textInput1" id="WND_USER_USERNAME" value="<%=rs("WND_USER_USERNAME")%>" size="9" maxlength="16"></td>
<td width="90"><input name="WND_USER_PASSWORD" type="text" class="textInput1" id="WND_USER_PASSWORD" value="<%=rs("WND_USER_PASSWORD")%>" size="9" maxlength="16"></td>
<td width="190"><select name="WND_USER_UNITID" class="textmost">
<option value="" selected>请选择单位</option>
<%
sql="select * from WNT_UNIT where left(UNIT_BM,"&unitLeftSameStep&")='"&session("UNIT_BM")&"' and Len(UNIT_BM)="&unitAllTempStep&" order by UNIT_BM desc"
%>
<%
rssub.open sql,conn,1,1
do while not rssub.eof
%>
<option value="<%=trim(rssub("WND_UNIT_ID"))%>" <%if rs("WND_USER_UNITID")=rssub("WND_UNIT_ID") then response.Write "selected"%>><%=Left(trim(rssub("WND_UNIT_UN")),12)%></option>
<%
rssub.movenext
loop
rssub.close
%>
</select></td>
<td><select name="userType" id="userType">
<%
limitType=session("WND_USER_TYPE")
sql="select * from WNT_GW where WND_GW_Order>="&limitType&" and WND_GW_Valid='yes' and WND_GW_SQLX='2' order by WND_GW_Order asc"
rssub.open sql,conn,1,1
do while not rssub.eof
%>
<option value="<%=rssub("WND_GW_ID")%>" <%if rssub("WND_GW_ID")=rs("WND_USER_TYPE") then response.Write "selected"%>><%=rssub("WND_GW_NAME")%></option>
<%
rssub.movenext
loop
rssub.close
%>
</select></td>
<td><select name="selectyear" id="selectyear">
<%
dim restartyear
restartyear=year(now())
%>
<option value="<%=year(rs("WND_USER_TIME"))%>" selected><%=year(rs("WND_USER_TIME"))%></option>
<%
For i=0 to 50
%>
<option value="<%=restartyear+i%>"><%=restartyear+i%></option>
<%
next
%>
</select>
<select name="selectmonth" id="selectmonth">
<option value="<%=month(rs("WND_USER_TIME"))%>" selected><%=month(rs("WND_USER_TIME"))%></option>
<option value="01">1</option>
<option value="02">2</option>
<option value="03">3</option>
<option value="04">4</option>
<option value="05">5</option>
<option value="06">6</option>
<option value="07">7</option>
<option value="08">8</option>
<option value="09">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
</select>
<select name="selectday" id="selectday">
<option value="<%=day(rs("WND_USER_TIME"))%>" selected><%=day(rs("WND_USER_TIME"))%></option>
<option value="01">1</option>
<option value="02">2</option>
<option value="03">3</option>
<option value="04">4</option>
<option value="05">5</option>
<option value="06">6</option>
<option value="07">7</option>
<option value="08">8</option>
<option value="09">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select></td>
<td width="58"><input name="Submit" type="submit" class="newSubmit" value="修 改"></td>
</tr>
</form>
<%
rs.movenext
c=c+1
loop
rs.close
%>
</table>
<br>
<table bgColor=#fdfaf4 borderColorDark=#ffffff border=1 cellspacing=0 cellpadding=0 align=center width=760 bordercolorlight=#999999 class=textmost>
<form name="form1" method="post" action="WNP_USER_SAVE.ASP" onSubmit="javascript:return checkuser();">
<tr height=20 valign=bottom align=center>
<td width="55" class="texttitle" >
<%
sql="select max(WND_USER_Order) as maxOrder from WNT_USER"
rs.open sql,conn,1,1
tempOrder1 = rs("maxOrder")+1
rs.close
%>
<input name="userOrder" type="text" class="textInput1" id="userOrder" value="<%=tempOrder1%>" size="4" maxlength="4" ></td>
<td width="90" ><input name="WND_USER_USERNAME" type="text" class="textInput1" id="WND_USER_USERNAME" size="9" maxlength="16"></td>
<td width="90"><input name="WND_USER_PASSWORD" type="text" class="textInput1" id="WND_USER_PASSWORD" size="9" maxlength="16"></td>
<td width="190" ><select name="WND_USER_UNITID" class="textmost">
<option value="" selected>请选择单位</option>
<%
sql="select * from WNT_UNIT where left(UNIT_BM,"&unitLeftSameStep&")='"&session("UNIT_BM")&"' and Len(UNIT_BM)="&unitAllTempStep&" order by UNIT_BM desc"
%>
<%
rs.open sql,conn,1,1
do while not rs.eof
%>
<option value="<%=trim(rs("WND_UNIT_ID"))%>"><%=Left(trim(rs("WND_UNIT_UN")),12)%></option>
<%
rs.movenext
loop
rs.close
%>
</select></td>
<td width="100" ><select name="userType" id="userType">
<%
sql="select * from WNT_GW where WND_GW_Valid='yes' and WND_GW_SQLX='2' order by WND_GW_Order desc"
rs.open sql,conn,1,1
do while not rs.eof
%>
<option value="<%=rs("WND_GW_ID")%>"><%=rs("WND_GW_NAME")%></option>
<%
rs.movenext
loop
rs.close
%>
</select></td>
<td width="160"><input name="WND_USER_WHO" type="hidden" id="WND_USER_WHO" value="<%=session("USERID")%>">
<select name="selectyear" id="selectyear">
<%
dim startyear
startyear=year(now())
%>
<option value="<%=startyear+1%>" selected><%=startyear+1%></option>
<%
For i=0 to 50
%>
<option value="<%=startyear+i%>"><%=startyear+i%></option>
<%
next
%>
</select>
<select name="selectmonth" id="selectmonth">
<option value="<%=month(now())%>" selected><%=month(now())%></option>
<option value="01">1</option>
<option value="02">2</option>
<option value="03">3</option>
<option value="04">4</option>
<option value="05">5</option>
<option value="06">6</option>
<option value="07">7</option>
<option value="08">8</option>
<option value="09">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
</select>
<select name="selectday" id="selectday">
<option value="<%=day(now())%>" selected><%=day(now())%></option>
<option value="01">1</option>
<option value="02">2</option>
<option value="03">3</option>
<option value="04">4</option>
<option value="05">5</option>
<option value="06">6</option>
<option value="07">7</option>
<option value="08">8</option>
<option value="09">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select> </td>
<td width="58" ><input name="Submit" type="submit" class="newSubmit" value="新 增"></td>
</tr>
</form>
</table>
<!--#include file="WNP_PAGEEND.ASP" -->
</td>
</tr>
</table>
</body>
</html>
<%
call closedb
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -