📄 update_company_sav.asp
字号:
<head>
<%
dim conn
dim connstr
Set conn=Server.CreateObject("ADODB.Recordset")
connstr="Driver={Microsoft ODBC for Oracle};server=mylink;uid=system;pwd=system;"
%>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>公司资料更改</title>
<style>
td {
font-size: 13px;
}
</style></head>
<link href=css.css rel=STYLESHEET type=text/css>
<%
if request("province")="" then
founderr=true
errmsg=errmsg+"<br>"+"<li>所在省份不能为空"
else
province=request("province")
end if
if request("linkman")="" then
rounderr=true
errmsg=errmsg+"<br>"+"<li>联系人不能为空"
else
linkman=request("linkman")
end if
if request("city")="" then
founderr=true
errmsg=errmsg+"<br>"+"<li>所在城市不能为空"
else
city=request("city")
end if
if request("address")="" then
founderr=true
errmsg=errmsg+"<br>"+"<li>公司地址不能为空"
else
address=request("address")
end if
if request("telphone")="" then
founderr=true
errmsg=errmsg+"<br>"+"<li>联系电话不能为空"
else
telphone=request("telphone")
end if
idcard=request("idcard")
fax=request("fax")
lmmobilephone=request("lmmobilephone")
zipcode=request("zipcode")
lmemail=request("lmemail")
remark=request("remark")
%>
<body>
<!-- #include file="pagetop.asp" -->
<table width="550" height="160" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#F2F2F2">
<% if founderr=true then %>
<tr>
<td height="70" bgcolor="#FFFFFF" colspan="4"></td>
</tr>
<tr><td align="center" bgcolor="#FFFFFF"><font color="#0000FF" size="-1"> <%=errmsg%> </font></td></tr>
<tr><td height="20" bgcolor="#FFFFFF"></td></tr>
<tr><meta http-equiv="refresh" content="3;url=javascript:history.go(-1)">
<td height="20" colspan="4" align="center" bgcolor="#FFFFFF"><font size="-1">三秒钟后自动返回，如果您的浏览器没有返回，请<a href="javascript:history.go(-1)" target="_self">单击此处</a>返回</font></td>
</tr>
<tr>
<td height="70" bgcolor="#FFFFFF" colspan="4"></td>
</tr>
<%
else
companyname=request("companyname")
set rs1=server.createobject("adodb.recordset")
sql="select * from GSCOTT.company_info_table where company_name='"&companyname&"'"
rs1.open sql,connstr,3,3
rs1("company_idcard")=idcard
rs1("company_province")=province
rs1("company_city")=city
rs1("company_lmemail")=lmemail
rs1("company_address")=address
rs1("company_zipcode")=zipcode
rs1("company_telphone")=telphone
rs1("company_linkman")=linkman
rs1("company_lmmobilephone")=lmmobilephone
rs1("company_remark")=remark
rs1("company_fax")=fax
date1=(rs1("company_date"))
rs1.update
rs1.close
set rs1=nothing
%>
<tr>
<td height="20" bgcolor="#FFFFFF" colspan="4"></td>
</tr>
<tr align="center">
<td height="20" colspan="4" bgcolor="E4E2FE">公司资料更改成功</td>
</tr>
<tr>
<td width="20%" height="20" align="right">公司名称：</td>
<td width="30%" height="20"><%=companyname%></td>
<td width="20%" height="20" align="right"> </td>
<td width="30%"> </td>
</tr>
<tr>
<td height="20" align="right">身份证号：</td>
<td><%=idcard%></td>
<td align="right">联系人：</td>
<td><%=linkman%></td>
</tr>
<tr>
<td height="20" align="right">所在省份：</td>
<td><%=province%></td>
<td align="right">所在城市：</td>
<td><%=city%></td>
</tr>
<tr>
<td height="20" align="right">公司地址：</td>
<td><%=address%></td>
<td align="right">邮编：</td>
<td><%=zipcode%></td>
</tr>
<tr>
<td height="20" align="right">联系电话：</td>
<td><%=telphone%></td>
<td align="right">联系人手机：</td>
<td><%=lmmobilephone%></td>
</tr>
<tr>
<td height="20" align="right">联系人Email：</td>
<td><%=lmemail%></td>
<td align="right">传真：</td>
<td><%=fax%></td>
</tr>
<tr>
<td height="20" align="right">注册时间：</td>
<td><%=date1%></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td align="right">备注：</td>
<td colspan="3"><%=remark%></td>
</tr>
<tr>
<td height="20" bgcolor="#FFFFFF" colspan="4"></td>
</tr>
<% end if %>
</table>
<!-- #include file="pagefooter.html" -->
</body> ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -