📄 economiclaw_sp_edit.asp
字号:
<%
'==============================================================
'OA 表单生成器
'版本: 1.1.0 -- 2005-5-24
'程序版权：(c) 2004 by 展亮
'说明：本代码为自由代码，用户可以自由使用，但请保留作者文件头部说明
' 在使用过程中如出现什么问题请及时与作者联系。
' 电子邮件：zlbox@yeah.net QQ:2343397
'=============================================================
'功能：添加/编辑工商户
'参数： request.form("addedit_subed")="true"#表单提交; request("id")#要编辑记录的ID;
'=============================================================
%>
<!--#include file="../inc/Secure.asp"-->
<!--#include file="../inc/conn.asp"-->
<!--#include file="../inc/Const.asp"-->
<!--#include file="../inc/ronger.asp"-->
<!--#include file="EconomicLaw_menu.asp"-->
<!--#include file="function.asp"-->
<%
'response.buffer=false
'------------------------------------------------设置参数
LoginID=clng(trim(Session("LoginID"))) '当前用户ID
pid=clng(request("id")) '记录ID
'------------------------------------------------
'------------------------------------------------添加/修改记录
table="EconomicLaw_sp" '表名
if request("addedit_subed")="true" then
'表单提交后,接受录入参数
zt_jld=0
zt_nr=0
zt_sp=0
tbdw=request("tbdw")
ajmc=request("ajmc")
spsx=request("spsx")
sply=request("sply")
cbr=request("cbr")
cbrq=request("cbrq")
cbjgyj=request("cbjgyj")
cbjgrq=request("cbjgrq")
jldyj=request("jldyj")
jldrq=request("jldrq")
blrylb=request("blrylb")
if sply<>"" then zt_nr=1
if cbjgyj<>"" then zt_sp=1
if jldyj<>"" then zt_jld=1
field1=array("tbdw","ajmc","spsx","sply","cbr","cbrq","cbjgrq","cbjgyj","jldyj","jldrq","zt_sp","zt_jld","blrylb","zt_nr")
value1=array(tbdw,ajmc,spsx,sply,cbr,cbrq,cbjgrq,cbjgyj,jldyj,jldrq,zt_sp,zt_jld,blrylb,zt_nr)
if pid=0 then
for i=0 to ubound(field1)
value1(i)=replace(value1(i),"'","''")
next
sql = "INSERT INTO "&table&" (" & Join(field1, ",") & ") VALUES ('" & Join(value1, "','") & "')"
sql = replace(replace(sql,",'',",",null,"),",'',",",null,")
'response.write sql
oConn.Execute sql
response.write "<script>alert('案件登记提交成功！');this.location='EconomicLaw_reg.asp'</script>"
response.end
else
sql="UPDATE "&table&" SET "
for i=0 to ubound(field1)
if value1(i)="" then
sql = sql & field1(i) & "=null"
else
sql = sql & field1(i) & "='" & replace(value1(i),"'","''") & "'"
end if
if i <> ubound(field1) then sql=sql & "," else sql=sql & " where id='" & pid & "'"
next
'response.write sql
oConn.Execute sql
if zt_jld=1 then
tempid=HtmlOut(GetTableValue("EconomicLaw_sp","bkupid","id",pid))
field2=array("bkupid","userid")
value2=array(tempid,loginid)
if pid<>0 then
for i=0 to ubound(field2)
value2(i)=replace(value2(i),"'","''")
next
set rs=Server.CreateObject("ADODB.RecordSet")
rs.open "Select count(*) from EconomicLaw_sp2 where bkupid=" & tempid ,oConn,1,1
if rs.fields(0)=0 then
rs.close
set rs=nothing
sql = "INSERT INTO EconomicLaw_sp2 (" & Join(field2, ",") & ") VALUES ('" & Join(value2, "','") & "')"
sql = replace(replace(sql,",'',",",null,"),",'',",",null,")
'response.write sql
oConn.Execute sql
end if
end if
end if
response.write "<script>alert('信息提交成功！');history.go(-2)</script>"
response.end
end if
end if
'------------------------------------------------
'--------------------------------------------取记录
set rs=Server.CreateObject("ADODB.RecordSet")
sql="select * from " & table & " where ID="&pid
rs.open sql,oConn,1,1
'------------------------------------------------
function showvalue(field)
if rs.eof then
showvalue=""
else
if (isnull(rs(field))) then showvalue="" else showvalue=Server.HTMLEncode(rs(field))
end if
end function
%>
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=gb2312">
<LINK REL="stylesheet" HREF="../css/main.css" type=text/css>
<TITLE>案件登记</TITLE>
<SCRIPT SRC="../js/Popup.js"></SCRIPT>
<SCRIPT SRC="../js/formatdate.js"></SCRIPT>
<SCRIPT SRC="../js/front_chec.js"></SCRIPT>
<SCRIPT SRC="../js/user_select.js"></SCRIPT>
<SCRIPT LANGUAGE="JavaScript">
<!--
function select_users(f_xm,f_id){
strtmpusers = SelectUsers(f_id.value);
if (strtmpusers != "") {
strtmpusers=strtmpusers.split("_")
f_id.value=strtmpusers[0]
f_xm.value=strtmpusers[1]
}
}
-->
</SCRIPT>
<SCRIPT LANGUAGE=javascript>
function doselry(){
strtmpusers = SelectUsers(lxa.blrylb.value);
if (strtmpusers != "") {
strtmpusers=strtmpusers.split("_")
lxa.blrylb.value=strtmpusers[0]
lxa.blryxmlb.value=strtmpusers[1]
}
}
xyblr=new Array()
function checkxyblr(){
if (xyblr[lxa.blgzbh.value] == 1) {
selectblry.style.display='none';
}else{selectblry.style.display='';}
}
</SCRIPT>
</HEAD>
<BODY TOPMARGIN="10" LEFTMARGIN="10">
<TABLE WIDTH="98%" BORDER="0" ALIGN="center" CELLPADDING="0" CELLSPACING="0">
<TR>
<TD HEIGHT="18"> </TD>
</TR>
<TR>
<TD HEIGHT="103" ALIGN="center" CLASS="tab2">四川省工商行政管理机关<BR>
<BR>
行政处罚案件有关事项审批表</TD>
</TR>
</TABLE>
<TABLE WIDTH="98%" BORDER="0" ALIGN="center" CELLPADDING="0" CELLSPACING="0">
<FORM NAME="lxa" METHOD="POST" ACTION="?id=<%=pid%>" onSubmit="return checknull(this)">
<INPUT type=hidden NAME="addedit_subed" VALUE="true">
<TR>
<TD HEIGHT="28">填表单位:
<INPUT NAME="tbdw" TYPE="text" CLASS="inputnew" ID="tbdw" VALUE="<%=showvalue("tbdw")%>" CHECK_NULL="请填写填表单位"></TD>
<TD ALIGN="right">编号:
<INPUT NAME="bh" TYPE="text" CLASS="inputext" ID="bh" VALUE="<%=HtmlOut(GetTableValue("EconomicLaw_reg","bh","id",rs("bkupid")))%>" CHECK_NULL="请填写编号"></TD>
</TR>
<TR>
<TD COLSPAN="2"><TABLE WIDTH="100%" BORDER="0" CELLPADDING="1" CELLSPACING="1" BORDERCOLOR="#FFFFFF" BGCOLOR="#efefef">
<TR>
<TD WIDTH="9%" ALIGN="center" BGCOLOR="#FFFFFF">案件名称</TD>
<TD HEIGHT="33" BGCOLOR="#FFFFFF">
<INPUT NAME="ajmc" TYPE="text" CLASS="inputnew" ID="ajmc" VALUE="<%=showvalue("ajmc")%>" SIZE="100" CHECK_NULL="请填写案件名称"></TD>
</TR>
<TR>
<TD ALIGN="center" BGCOLOR="#FFFFFF"><P>当事人姓名<BR>
或 名 称</P> </TD>
<TD WIDTH="91%" HEIGHT="48" BGCOLOR="#FFFFFF">
<INPUT NAME="dsrxm" TYPE="text" CLASS="inputreadonly" ID="dsrxm" VALUE="<%=HtmlOut(GetTableValue("EconomicLaw_reg","dsrxm","id",rs("bkupid")))%>" SIZE="95"></TD>
</TR>
<TR>
<TD ALIGN="center" BGCOLOR="#FFFFFF">审批事项</TD>
<TD HEIGHT="39" BGCOLOR="#FFFFFF">
<INPUT NAME="spsx" TYPE="text" CLASS="inputnew" ID="spsx" VALUE="<%=showvalue("spsx")%>" SIZE="100" CHECK_NULL="请填写审批事项"></TD>
</TR>
<TR>
<TD ALIGN="center" BGCOLOR="#FFFFFF">提请审批<BR>
的理由及<BR>
依 据</TD>
<TD BGCOLOR="#FFFFFF"><%if isnull(rs("cbjgyj")) then %>
<TEXTAREA NAME="sply" COLS="85" ROWS="10" CLASS="textarea" ID="sply"><%=showvalue("sply")%></TEXTAREA>
<DIV ALIGN="left">
<BR>
承办人：
<INPUT NAME="cbr" TYPE="text" CLASS="inputnew" ID="cbr" VALUE="<%if showvalue("cbr")="" then response.write getusername(loginid) else response.write showvalue("cbr") end if%>" SIZE="15">
办理日期：
<INPUT NAME="cbrq" TYPE="TEXT" CLASS="inputnew" ID="cbrq" value="<%=showvalue("cbrq")%>" SIZE="12" MAXLENGTH="12" >
<A href=# TITLE="选择日期" onClick="fPopUpDlg('../js/calendar.htm', document.lxa.cbrq, 'winpop', 234, 261);return false"> <IMG SRC="../images/datetime.gif" border=0> </A><A href=# TITLE="选择日期" onClick="fPopUpDlg('../js/calendar.htm', document.lxa.cbrq, 'winpop', 234, 261);return false"></A>
</DIV>
<%else%>
<%=showvalue("sply")%>
<INPUT type=hidden id=sply name=sply value=<%=showvalue("sply")%>>
<INPUT type=hidden id=cbrq name=cbrq value=<%=showvalue("cbrq")%>>
<INPUT type=hidden id=cbr name=cbr value=<%=showvalue("cbr")%>>
<DIV ALIGN="right">
<BR>
承办人：<%=showvalue("cbr")%> 办理日期：<%=showvalue("cbrq")%>
</DIV>
<%end if%>
</TD>
</TR>
<TR <%=IsShow(showvalue("zt_nr"))%>>
<TD ALIGN="center" BGCOLOR="#FFFFFF">承办<BR>
机构<BR>
意见</TD>
<TD HEIGHT="143" BGCOLOR="#FFFFFF">
<%if isnull(rs("jldyj")) then %>
<TEXTAREA NAME="cbjgyj" COLS="85" ROWS="10" CLASS="textarea" ID="cbjgyj"><%=showvalue("cbjgyj")%></TEXTAREA>
<DIV ALIGN="right"><BR>
办理日期：
<INPUT NAME="cbjgrq" TYPE="TEXT" CLASS="inputnew" ID="cbjgrq" value="<%=showvalue("cbjgrq")%>" SIZE="12" MAXLENGTH="12" >
<A href=# TITLE="选择日期" onClick="fPopUpDlg('../js/calendar.htm', document.lxa.cbjgrq, 'winpop', 234, 261);return false"><IMG SRC="../images/datetime.gif" border=0> </A></DIV>
<%else%>
<%=showvalue("cbjgyj")%><INPUT type=hidden id=cbjgyj name=cbjgyj value=<% =showvalue("cbjgyj")%>>
<DIV ALIGN="right"><BR> 办理日期：<%=showvalue("cbjgrq")%></DIV>
<%end if%>
</TD>
</TR>
<TR <%=IsShow(showvalue("zt_sp"))%>>
<TD ALIGN="center" BGCOLOR="#FFFFFF">局领导<BR>
意 见</TD>
<TD HEIGHT="148" BGCOLOR="#FFFFFF">
<TEXTAREA NAME="jldyj" COLS="85" ROWS="10" CLASS="textarea" ID="jldyj"><%=showvalue("jldyj")%></TEXTAREA>
<DIV ALIGN="right"><BR>
办理日期：
<INPUT NAME="jldrq" TYPE="TEXT" CLASS="inputnew" ID="jldrq" onKeyUp="DateFormat(this,this.value,event,false,'2')" VALUE="<%=showvalue("jldrq")%>" SIZE="12" MAXLENGTH="12" CHECK_DATE="日期格式错误">
<A href=# TITLE="选择日期" onClick="fPopUpDlg('../js/calendar.htm', document.lxa.jldrq, 'winpop', 234, 261);return false"><IMG SRC="../images/datetime.gif" border=0> </A><A href=# TITLE="选择日期" onClick="fPopUpDlg('../js/calendar.htm', document.lxa.jldrq, 'winpop', 234, 261);return false"></A> </DIV></TD>
</TR>
</TABLE></TD>
</TR>
<TR>
<TD HEIGHT="30" COLSPAN="2" ALIGN="center"><INPUT NAME="Submit" TYPE="submit" CLASS="button1" VALUE="确定提交">
<INPUT NAME="Submit3" TYPE="button" CLASS="button1" VALUE="取消" onClick="history.back();"></TD>
</TR>
</FORM>
</TABLE>
</BODY>
</HTML> ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -