⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 newcompany.asp

📁 1 除掉了 时间 限制 2 除掉了 人数 限制 改为 500人 原为5人 3 发现一点小缺陷 增加人员的时候没有判断 登陆名是否重复! 自己写吧~~~:) 4 又 是一点缺陷
💻 ASP
字号:
<!--#include file="../config.ini" -->
<!--#include file="../commfunction.inc" -->
<%

if request("id")<>"" then
	dim connq
	dim rsq
	set connq=server.CreateObject("adodb.connection")
	set rsq=server.CreateObject("adodb.recordset")
	connq.Open connstring
	rsq.Open "select * from company where id="&request("id"),connq,2,3,1
	strcompany=rsq("company")
	strenglishname=rsq("englishname")
	strphone=rsq("phone")
	strfax=rsq("fax")
	straddress=rsq("address")
	strzip=rsq("zip")
	strbank=rsq("bank")
	straccountno=rsq("accountno")
	strtaxno=rsq("taxno")
	strwhseaddress=rsq("whseaddress")
	strwhsezip=rsq("whsezip")
	strwhsecontact=rsq("whsecontact")
	strwhsephone=rsq("whsephone")
	strwhsefax=rsq("whsefax")
	strsiger1=rsq("siger1")
	strsiger2=rsq("siger2")
	strsiger3=rsq("siger3")
	strsiger4=rsq("siger4")
	strsiger5=rsq("siger5")
	rsq.Close
	set rsq=nothing
	connq.Close
	set connq=nothing
else
	strmaxdiscount=0
end if

if request("company")<>"" then
	dim conn
	dim rs
	set conn=server.CreateObject("adodb.connection")
	set rs=server.CreateObject("adodb.recordset")
	conn.Open connstring
	if request("id")="" then
		rs.Open "select * from company",conn,2,3,1
		rs.AddNew 
	else
		rs.Open "select * from company where id="&request("id"),conn,2,3,1
	end if
	rs("company")=request("company")
	rs("englishname")=request("englishname")
	rs("phone")=request("phone")
	rs("fax")=request("fax")
	rs("address")=request("address")
	rs("zip")=request("zip")
	rs("bank")=request("bank")
	rs("accountno")=request("accountno")
	rs("taxno")=request("taxno")
	rs("whseaddress")=request("whseaddress")
	rs("whsezip")=request("whsezip")
	rs("whsecontact")=request("whsecontact")
	rs("whsephone")=request("whsephone")
	rs("whsefax")=request("whsefax")
	rs("siger1")=request("siger1")
	rs("siger2")=request("siger2")
	rs("siger3")=request("siger3")
	rs("siger4")=request("siger4")
	rs("siger5")=request("siger5")

	rs.Update 
	rs.Close 
	set rs=nothing
	conn.Close 
	set conn=nothing
%>
<script language=javascript>
	window.opener.location.reload();
	window.close();
</script>
<%
end if
%>

<HTML><HEAD><TITLE>公司信息</TITLE>
<LINK href="../global.css" rel=STYLESHEET type=text/css>
<META content="text/html; charset=gb2312" http-equiv=Content-Type>
 <form name=form1  method="post"  id=form1>
   <table width="100%" height="20" border="0" cellpadding="0" cellspacing="0">
   <tr> 
    <td height="25"><strong><font size="2" class=title><b><%if request("id")="" then%>新建公司<%else%>编辑公司<%end if%></b></font></strong></td>
      <td>&nbsp;</td>
    </tr>
    <tr > 
      <td height="16" colspan="2" background="../images/title.gif">&nbsp;</td>
    </tr>
    <tr>
      <td height=4></td>
    </tr>
	<tr><td>
	<div align="center" style="cursor:hand"><a onclick="form1.submit();"><img src="../images/button_save.gif"></a>&nbsp;&nbsp;&nbsp;&nbsp;<a onclick="window.close();"><img src="../images/button_cancel.gif"></a> 
    </div></td>
    </tr>
 </table>
  <table cellspacing="1" bgcolor="#FFFFFF" width=100% >
    <tr bgcolor="white"> 
      <td width="15%" height="20" bgcolor="DEDFDE"> <div align="center">公司名称</div></td>
      <td bgcolor="EFEFEF" colspan="3">        <input name="company" type="text" id="company" value="<%=strcompany%>">
      </td>
    </tr>
    <tr  bgcolor="white"> 
      <td width="15%" nowrap bgcolor="DEDFDE"> <div align="center">英文名称</div></td>
      <td bgcolor="EFEFEF" colspan="3"><input name=englishname type=text value="<%=strenglishname%>" size="45"></td>
    </tr>
    <tr  bgcolor="white"> 
      <td width="15%" nowrap bgcolor="DEDFDE"> <div align="center">电话</div></td>
      <td width="35%" bgcolor="EFEFEF"> <input name=phone type=text value="<%=strphone%>" size="12"></td>
      <td width="15%" bgcolor="DEDFDE"> <div align="center">传真</div></td>
      <td width="35%" bgcolor="EFEFEF"> <input name=fax type=text value="<%=strfax%>" size="12"></td>
    </tr>
    <tr  bgcolor="white"> 
      <td width="15%" bgcolor="DEDFDE" > <div align="center">地址</div></td>
      <td colspan="3" bgcolor="EFEFEF"> <input name=address type=text value="<%=straddress%>" size="45"></td>
    </tr>
    <tr  bgcolor="white"> 
      <td width="15%" bgcolor="DEDFDE" > <div align="center">邮编</div></td>
      <td width="35%" bgcolor="EFEFEF"> <input name=zip type=text value="<%=strzip%>" size="8"></td>
      <td width="15%" bgcolor="DEDFDE"> <div align="center">开户银行</div></td>
      <td width="35%" bgcolor="EFEFEF"> <input name=bank type=text value="<%=strbank%>" size="18"> 
      </td>
    </tr>
    <tr  bgcolor="white"> 
      <td width="15%" height="23" bgcolor="DEDFDE" > <div align="center">税号</div></td>
      <td width="35%" bgcolor="EFEFEF"> <input name=taxno type=text value="<%=strtaxno%>" size="18"> 
      </td>
      <td width="15%" bgcolor="DEDFDE"> <div align="center">帐号</div></td>
      <td width="35%" bgcolor="EFEFEF"><input name=accountno type=text value="<%=straccountno%>" size="18"> 
      </td>
    </tr>
    <tr  bgcolor="white"> 
      <td width="15%" bgcolor="DEDFDE" > <div align="center">仓库地址</div></td>
      <td colspan="3" bgcolor="EFEFEF"> <input name=whseaddress type=text value="<%=strwhseaddress%>" size="45"> 
        <div align="center"></div></td>
    </tr>
    <tr  bgcolor="white"> 
      <td width="15%" bgcolor="DEDFDE" > <div align="center">联系人</div></td>
      <td width="35%" bgcolor="EFEFEF"> <input name=whsecontact type=text value="<%=strwhsecontact%>" size="8"></td>
      <td width="15%" bgcolor="DEDFDE"> <div align="center">邮编</div></td>
      <td width="35%" bgcolor="EFEFEF"><input name=whsezip type=text value="<%=strwhsezip%>" size="8"> 
      </td>
    </tr>
    <tr  bgcolor="white"> 
      <td width="15%" bgcolor="DEDFDE" > <div align="center">电话</div></td>
      <td width="35%" bgcolor="EFEFEF"> <input name=whsephone type=text value="<%=strwhsephone%>" size="12"></td>
      <td width="15%" bgcolor="DEDFDE"> <div align="center">传真</div></td>
      <td width="35%" bgcolor="EFEFEF"><input name=whsefax type=text value="<%=strwhsefax%>" size="12"></td>
    </tr>
    <tr  bgcolor="white"> 
      <td width="15%" nowrap bgcolor="DEDFDE"> <div align="center">发货单签名1</div></td>
      <td width="35%" bgcolor="EFEFEF"> <input name=siger1 type=text value="<%=strsiger1%>" size="8"></td>
      <td width="15%" nowrap bgcolor="DEDFDE"> <div align="center">发货单签名2</div></td>
      <td width="35%" bgcolor="EFEFEF"> <input name=siger2 type=text value="<%=strsiger2%>" size="8"></td>
    </tr>
    <tr  bgcolor="white"> 
      <td width="15%" bgcolor="DEDFDE" > <div align="center">发货单签名3</div></td>
      <td width="35%" bgcolor="EFEFEF"> <input name=siger3 type=text value="<%=strsiger3%>" size="8"></td>
      <td width="15%" bgcolor="DEDFDE"> <div align="center">发货单签名4</div></td>
      <td width="35%" bgcolor="EFEFEF"> <input name=siger4 type=text value="<%=strsiger4%>" size="8"></td>
    </tr>
    <tr  bgcolor="white"> 
      <td width="15%" bgcolor="DEDFDE" > <div align="center">发货单签名5</div></td>
      <td width="35%" bgcolor="EFEFEF"> <input name=siger5 type=text value="<%=strsiger5%>" size="8"></td>
      <td width="15%" bgcolor="DEDFDE"> <div align="center"></div></td>
      <td width="35%" bgcolor="EFEFEF">&nbsp;</td>
    </tr>
  </table>
</form>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -