wnp_uj_save.asp

U盘身份识别软件

<!--#include file="CONN.asp" -->
<%
if session("USERID")="" then
response.Redirect "WNP_LOGIN.ASP"
end if
%>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<%
action=request("action")

'空 WND_UJ_FUNCTION 判断
ujFunction = request("WND_UJ_FUNCTION")
if Len(ujFunction)<5 then
  	ujFunction=""
end if

'action 为 mod
if action="mod" then
  ujid=request("ujid")
  ujOrder=Cint(request("ujOrder"))
  sql="select * from WNT_UJ where WND_UJ_Order="&ujOrder&" and WND_ID<>"&ujid
  rs.open sql,conn,1,1
  if not rs.eof then '如果操作为移动
    rs.close
    sql="select * from WNT_UJ where WND_ID="&ujid
	rs.open sql,conn,1,1
	tempUjOrder=rs("WND_UJ_Order")
	rs.close
	if tempUjOrder>ujOrder then '向前移动操作
      sql="update WNT_UJ set WND_UJ_Order=WND_UJ_Order+1 where (WND_UJ_Order>="&ujOrder&" and WND_UJ_Order <"&tempUjOrder&")"
    else '向后移动操作
      sql="update WNT_UJ set WND_UJ_Order=WND_UJ_Order-1 where (WND_UJ_Order<="&ujOrder&" and WND_UJ_Order >"&tempUjOrder&")"
    end if
    conn.execute(sql)
	sql="update WNT_UJ set WND_UJ_Order="&ujOrder&",WND_UJ_UJ='"&request("WND_UJ_UJ")&"',WND_UJ_Step="&CInt(request("ujdengji"))&",WND_UJ_FUNCTION='"&ujFunction&"',WND_UJ_DATE=date(),WND_UJ_UserType="&request("userType")&",WND_UJ_TYPE="&request("UJType")&" where WND_ID="&ujid
	conn.execute(sql)
	response.Redirect "WNP_UJ_EDIT.ASP?page="&request("nowpage")
  else '操作不为移动
    rs.close
	sql="update WNT_UJ set WND_UJ_Order="&ujOrder&",WND_UJ_UJ='"&request("WND_UJ_UJ")&"',WND_UJ_Step="&CInt(request("ujdengji"))&",WND_UJ_FUNCTION='"&ujFunction&"',WND_UJ_DATE=date(),WND_UJ_UserType="&request("userType")&",WND_UJ_TYPE="&request("UJType")&" where WND_ID="&ujid
	conn.execute(sql)
	response.Redirect "WNP_UJ_EDIT.ASP?page="&request("nowpage")
  end if

'action 为 add
elseif action="add" then
  ujOrder=Cint(request("ujOrder"))
  sql="select * from WNT_UJ where WND_UJ_Order="&ujOrder
  rs.open sql,conn,1,1
  if not rs.eof then '添加时如果序号与已有记录序号重复
    rs.close
    sql="update WNT_UJ set WND_UJ_Order=WND_UJ_Order+1 where WND_UJ_Order>="&ujOrder
    conn.execute(sql)
	sql="insert into WNT_UJ(WND_UJ_Order,WND_UJ_Step,WND_UJ_FUNCTION,WND_UJ_UJ,WND_UJ_DATE,WND_UJ_UserType,WND_UJ_TYPE) values("&ujOrder&","&Cint(request("ujdengji"))&",'"&ujFunction&"','"&request("WND_UJ_UJ")&"',date(),"&request("userType")&","&request("UJType")&")"
	conn.execute(sql)
	response.Redirect "WNP_UJ_EDIT.ASP"
  else '添加时如果序号与已有记录序号不重复
    rs.close
	sql="insert into WNT_UJ(WND_UJ_Order,WND_UJ_Step,WND_UJ_FUNCTION,WND_UJ_UJ,WND_UJ_DATE,WND_UJ_UserType,WND_UJ_TYPE) values("&ujOrder&","&Cint(request("ujdengji"))&",'"&ujFunction&"','"&request("WND_UJ_UJ")&"',date(),"&request("userType")&","&request("UJType")&")"
	conn.execute(sql)
	response.Redirect "WNP_UJ_EDIT.ASP?page="&request("nowpage")
  end if
end if
%>