📄 economiclaw_sp_edit2.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_sp2" '表名
if pid<>0 then
set rs=Server.CreateObject("ADODB.RecordSet")
rs.open "Select * from "&table&" where id=" & pid ,oConn,1,1
if not rs.EOF then
blrylb=rs("blrylb") & ""
blryxmlb=GetUserNames(blrylb,",")
end if
rs.Close
set rs=nothing
end if
if request("addedit_subed")="true" then
'表单提交后,接受录入参数
zt_jld=0
zt_cbr=0
zt_bajg=0
zt_hsjg=0
ajxz=request("ajxz")
larq=request("larq")
wfss=request("wfss")
cbryj=request("cbryj")
bajgyj=request("bajgyj")
bajgrq=request("bajgrq")
hsjgyj=request("hsjgyj")
hsjgrq=request("hsjgrq")
jldyj=request("jldyj")
jldrq=request("jldrq")
blrylb=request("blrylb")
if wfss<>"" then zt_nr=1
if cbryj<>"" then zt_cbr=1
if bajgyj<>"" then zt_bajg=1
if hsjgyj<>"" then zt_hsjg=1
if jldyj<>"" then zt_jld=1
field1=array("ajxz","larq","wfss","cbryj","bajgyj","bajgrq","jldyj","jldrq","zt_jld","blrylb","hsjgyj","hsjgrq","zt_cbr","zt_bajg","zt_hsjg","zt_nr")
value1=array(ajxz,larq,wfss,cbryj,bajgyj,bajgrq,jldyj,jldrq,zt_jld,blrylb,hsjgyj,hsjgrq,zt_cbr,zt_bajg,zt_hsjg,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_sp_list2.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
oConn.Execute sql
if zt_jld=1 then
tempid=HtmlOut(GetTableValue("EconomicLaw_sp2","bkupid","id",pid))
field2=array("bkupid","userid","spid")
value2=array(tempid,loginid,pid)
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_jys where bkupid=" & tempid ,oConn,1,1
if rs.fields(0)=0 then
rs.close
set rs=nothing
sql = "INSERT INTO EconomicLaw_jys (" & 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
function display(bul)
if bul then
display="style='display:none;'"
else
display=""
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><TABLE WIDTH="100%" BORDER="0" CELLPADDING="1" CELLSPACING="1" BORDERCOLOR="#FFFFFF" BGCOLOR="#efefef">
<TR>
<TD WIDTH="12%" ALIGN="center" BGCOLOR="#FFFFFF"><P>当事人姓名<BR>
或 名 称</P> </TD>
<TD HEIGHT="48" COLSPAN="3" 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 WIDTH="27%" HEIGHT="39" BGCOLOR="#FFFFFF">
<INPUT NAME="ajxz" TYPE="text" CLASS="inputnew" ID="ajxz" VALUE="<%=showvalue("ajxz")%>" SIZE="30" CHECK_NULL="请填写审批事项"></TD>
<TD WIDTH="21%" ALIGN="center" BGCOLOR="#FFFFFF">立 案 时 间</TD>
<TD WIDTH="40%" BGCOLOR="#FFFFFF"><INPUT NAME="larq" TYPE="TEXT" CLASS="inputnew" ID="larq" value="<%=showvalue("larq")%>" SIZE="12" MAXLENGTH="12" CHECK_NULL="请填写立案时间">
<A href=# TITLE="选择日期" onClick="fPopUpDlg('../js/calendar.htm', document.lxa.larq, 'winpop', 234, 261);return false"> <IMG SRC="../images/datetime.gif" border=0></A> </TD>
</TR>
<TR>
<TD ALIGN="center" BGCOLOR="#FFFFFF">当事人主要违法事实</TD>
<TD COLSPAN="3" BGCOLOR="#FFFFFF"><%if isnull(rs("cbryj")) then %>
<TEXTAREA NAME="wfss" COLS="85" ROWS="10" CLASS="textarea" ID="wfss"><%=showvalue("wfss")%></TEXTAREA>
<%else%>
<%=showvalue("wfss")%>
<INPUT type=hidden id=wfss name=wfss value=<%=showvalue("wfss")%>>
<%end if%></TD>
</TR>
<TR <%=IsShow(showvalue("zt_nr"))%>>
<TD ALIGN="center" BGCOLOR="#FFFFFF">承办<BR>
人报处以建<BR>
意见</TD>
<TD HEIGHT="143" COLSPAN="3" BGCOLOR="#FFFFFF">
<%if isnull(rs("bajgyj")) then %>
<TEXTAREA NAME="cbryj" COLS="85" ROWS="10" CLASS="textarea" ID="cbryj"><%=showvalue("cbryj")%></TEXTAREA>
<%else%>
<%=showvalue("cbryj")%><INPUT type=hidden id=cbryj name=cbryj value=<% =showvalue("cbryj")%>>
<%end if%> </TD>
</TR>
<TR <%=IsShow(showvalue("zt_cbr"))%>>
<TD ALIGN="center" BGCOLOR="#FFFFFF">办案机构处罚建议 </TD>
<TD HEIGHT="148" COLSPAN="3" BGCOLOR="#FFFFFF">
<%if isnull(rs("hsjgyj")) then %>
<TEXTAREA NAME="bajgyj" COLS="85" ROWS="10" CLASS="textarea" ID="bajgyj"><%=showvalue("bajgyj")%></TEXTAREA>
<DIV ALIGN="right"><BR>
办理日期：
<INPUT NAME="bajgrq" TYPE="TEXT" CLASS="inputnew" ID="bajgrq" onKeyUp="DateFormat(this,this.value,event,false,'2')" VALUE="<%=showvalue("bajgrq")%>" SIZE="12" MAXLENGTH="12" CHECK_DATE="日期格式错误">
<A href=# TITLE="选择日期" onClick="fPopUpDlg('../js/calendar.htm', document.lxa.bajgrq, 'winpop', 234, 261);return false"><IMG SRC="../images/datetime.gif" border=0> </A></DIV>
<%else%>
<%=showvalue("bajgyj")%>
<INPUT type=hidden id=bajgyj name=bajgyj value=<% =showvalue("bajgyj")%>>
<INPUT type=hidden id=bajgrq name=bajgrq value=<% =showvalue("bajgrq")%>>
<DIV ALIGN="right"><BR> 办理日期：<%=showvalue("bajgrq")%></DIV>
<%end if%>
</TD>
</TR>
<TR <%=IsShow(showvalue("zt_bajg"))%>>
<TD ALIGN="center" BGCOLOR="#FFFFFF">核审机构意见</TD>
<TD HEIGHT="148" COLSPAN="3" BGCOLOR="#FFFFFF">
<%if isnull(rs("jldyj")) then %>
<TEXTAREA NAME="hsjgyj" COLS="85" ROWS="10" CLASS="textarea" ID="hsjgyj"><%=showvalue("hsjgyj")%></TEXTAREA>
<DIV ALIGN="right"><BR>
办理日期：
<INPUT NAME="hsjgrq" TYPE="TEXT" CLASS="inputnew" ID="hsjgrq" onKeyUp="DateFormat(this,this.value,event,false,'2')" VALUE="<%=showvalue("hsjgrq")%>" SIZE="12" MAXLENGTH="12" CHECK_DATE="日期格式错误">
<A href=# TITLE="选择日期" onClick="fPopUpDlg('../js/calendar.htm', document.lxa.hsjgrq, 'winpop', 234, 261);return false"><IMG SRC="../images/datetime.gif" border=0> </A></DIV>
<%else%>
<%=showvalue("hsjgyj")%><INPUT type=hidden id=hsjgyj name=hsjgyj value=<% =showvalue("hsjgyj")%>><INPUT type=hidden id=hsjgrq name=hsjgrq value=<% =showvalue("hsjgrq")%>>
<DIV ALIGN="right"><BR> 办理日期：<%=showvalue("hsjgrq")%></DIV>
<%end if%>
</TD>
</TR>
<TR <%=IsShow(showvalue("zt_hsjg"))%>>
<TD ALIGN="center" BGCOLOR="#FFFFFF">局领导<BR>
意 见</TD>
<TD HEIGHT="148" COLSPAN="3" 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></DIV></TD>
</TR>
</TABLE></TD>
</TR>
<TR>
<TD HEIGHT="30" 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 + -