📄 addnewclient.asp
字号:
<%
%>
<!--#include file="../conn.asp"-->
<!--#include file="../IsUser.asp"-->
<%
set rs=server.createobject("adodb.recordset") '创建记录集对象
ClientID=0 '设ClientID ＝ 0 ,即标识为添加客户信息
ClientCreatorID= User_ID '创建者为当前用户
OpenFlag = 1 '默认公开
ClientOperatorID=User_ID '最后修改者为当前用户
ClientCreateDate=now() '创建时间为当前系统时间
ClientUpdateDate=now() '最后修改时间为当前系统时间
Sqlstr = "select * from [User] where UserID=" & ClientCreatorID
'从用户ID得到用户名的查询
rs.open Sqlstr,conn,3,2 '执行数据库命令
if not (rs.bof or rs.eof) then '如果记录不为空
ClientCreatorName = rs("UserName") '获得用户名
ClientOperatorName = rs("UserName")
ClientCreatorSnum = rs("UserSection") '获得用户部门ID
else '否则
ClientCreatorName = "未知" '用户名未知
ClientOperatorName = "未知"
ClientCreatorSnum = 0 '部门未知
end if
rs.close '关闭记录集对象
Sqlstr = "select * from Section where SectionID =" & ClientCreatorSnum
'根据部门ID得到部门名
rs.open Sqlstr,conn,3,2 '执行数据库命令
if not (rs.bof or rs.eof) then '如果记录不为空
ClientCreatorSName = rs("SectionName") '获得部门名
else '否则
ClientCreatorSName = "未知" '部门名未知
end if
rs.close
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>填写客户详细信息</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<META http-equiv=Pragma content=no-cache>
<META content="MSHTML 6.00.2715.400" name=GENERATOR>
<style type="text/css">
<!--
.style1 {color: #FF6600}
-->
</style>
</HEAD>
<LINK href="../css.css" rel=stylesheet>
<BODY><BR>
<TABLE width="751" border=0 align=center cellPadding=0 cellSpacing=0>
<!--DWLayoutTable-->
<TBODY>
<FORM name=Searchclient action=list.asp method=post>
<TR>
<TD width="12" height="24" valign="top" ><Span align=center><img src="../images/DispStation_H.gif" width="11" height="24"></span></TD>
<TD width="137" align="center" valign="middle" bgcolor="#566CDB" >添加客户相关信息</TD>
<TD colspan="10" align="right" valign="middle" bgcolor="#DDDDDD" >
</TD>
</TR>
</form>
<TR>
<TD height="16" colspan="12" valign="top" ><!--DWLayoutEmptyCell--> </TD>
</TR>
<FORM name=NewClient action=saveclient.asp method=post>
<TR>
<TD height="30" colspan="5" align="left" valign="middle" ><FONT style="LINE-HEIGHT: 150%"><FONT face=Wingdings
color=#99ccff >v</FONT></FONT><FONT color=#ff6600>客户名称:
<input name="T_ClientName" type="text" id="T_ClientName" size="30" maxlength="50">
<input name="T_ClientNameID" type="hidden" value=<%=ClientID%>>
</FONT></TD>
<TD colspan="7" align="left" valign="middle" ><FONT style="LINE-HEIGHT: 150%"><FONT face=Wingdings
color=#99ccff >v</FONT><FONT face=Wingdings ></FONT></FONT><span class="style1">电子邮箱:
<input name="T_ClientEmail" type="text" id="T_ClientEmail" size="30" maxlength="50">
</span></TD>
</TR>
<TR>
<TD height="30" colspan="3" align="left" valign="middle" ><FONT style="LINE-HEIGHT: 150%"><FONT face=Wingdings
color=#99ccff >v</FONT></FONT><FONT color=#ff6600>国家/地区:
<input name="T_ClientNation" type="text" id="T_ClientNation" size="15" maxlength="30">
</FONT></TD>
<TD colspan="5" align="left" valign="middle" ><FONT style="LINE-HEIGHT: 150%"><FONT face=Wingdings
color=#99ccff >v</FONT></FONT><FONT color=#ff6600>省份/直辖市:
<input name="T_ClientPro" type="text" id="T_ClientPro" size="15" maxlength="30">
</FONT></TD>
<TD colspan="4" align="left" valign="middle" ><FONT style="LINE-HEIGHT: 150%"><FONT face=Wingdings
color=#99ccff >v</FONT><FONT face=Wingdings ></FONT></FONT><span class="style1">公司主页:
<input name="T_ClientHpage" type="text" id="T_ClientHpage" size="30" maxlength="50">
</span></TD>
</TR>
<TR>
<TD height="30" colspan="3" align="left" valign="middle" ><FONT style="LINE-HEIGHT: 150%"><FONT face=Wingdings
color=#99ccff >v</FONT></FONT><FONT color=#ff6600>国家 区号:
<input name="T_ClientNcode" type="text" id="T_ClientNcode" size="15" maxlength="30">
</FONT></TD>
<TD colspan="3" align="left" valign="middle" ><FONT style="LINE-HEIGHT: 150%"><FONT face=Wingdings
color=#99ccff >v</FONT></FONT><FONT color=#ff6600>城市</FONT><FONT color=#ff6600>:
<input name="T_ClientCity" type="text" id="T_ClientCity" size="15" maxlength="30">
</FONT></TD>
<TD colspan="4" align="left" valign="middle" ><FONT style="LINE-HEIGHT: 150%"><FONT face=Wingdings
color=#99ccff >v</FONT></FONT><FONT color=#ff6600>区号:
<input name="T_ClientAcode" type="text" id="T_ClientAcode" size="15" maxlength="30">
</FONT></TD>
<TD colspan="2" align="left" valign="middle" ><FONT style="LINE-HEIGHT: 150%"><FONT face=Wingdings
color=#99ccff >v</FONT></FONT><FONT color=#ff6600>邮编:
<input name="T_ClientPcode" type="text" id="T_ClientPcode" size="15" maxlength="30">
</FONT></TD>
</TR>
<TR>
<TD height="30" colspan="3" align="left" valign="middle" ><FONT style="LINE-HEIGHT: 150%"><FONT face=Wingdings
color=#99ccff >v</FONT></FONT><FONT color=#ff6600>公司年收入</FONT><FONT color=#ff6600>:
<input name="T_ClientIncome" type="text" id="T_ClientIncome" size="15" maxlength="30">
</FONT></TD>
<TD colspan="4" align="left" valign="middle" ><FONT style="LINE-HEIGHT: 150%"><FONT face=Wingdings
color=#99ccff >v</FONT></FONT><FONT color=#ff6600>员工人数:
<input name="T_ClientEmpNum" type="text" id="T_ClientCity4" size="15" maxlength="30">
</FONT></TD>
<TD colspan="4" align="left" valign="middle" ><FONT style="LINE-HEIGHT: 150%"><FONT face=Wingdings
color=#99ccff >v</FONT></FONT><FONT color=#ff6600>电话</FONT><FONT color=#ff6600>:
<input name="T_ClientTel" type="text" id="T_ClientCity5" size="15" maxlength="30">
</FONT></TD>
<TD width="177" align="left" valign="middle" ><FONT style="LINE-HEIGHT: 150%"><FONT face=Wingdings
color=#99ccff >v</FONT></FONT><FONT color=#ff6600>传真</FONT><FONT color=#ff6600>:
<input name="T_ClientFax" type="text" id="T_ClientCity6" size="15" maxlength="30">
</FONT></TD>
</TR>
<TR>
<TD height="30" colspan="12" align="left" valign="middle" ><FONT style="LINE-HEIGHT: 150%"><FONT face=Wingdings
color=#99ccff >v</FONT></FONT><FONT color=#ff6600>详细地址</FONT><FONT color=#ff6600>:
<input name="T_ClientAdd" type="text" id="T_ClientAdd" size="90" maxlength="120">
</FONT></TD>
</TR>
<TR valign="middle">
<TD height="16" colspan="12" ><hr color="#566CDB" align="center" size="1"></TD>
</TR>
<TR>
<TD height="30" colspan="6" align="left" valign="middle" ><FONT style="LINE-HEIGHT: 150%"><FONT face=Wingdings
color=#99ccff >v</FONT></FONT><FONT color=#ff6600>增值税开票名</FONT><FONT color=#ff6600>:
<input name="T_ClientTaxName" type="text" id="T_ClientTaxName" size="35" maxlength="80">
</FONT></TD>
<TD colspan="6" align="left" valign="middle" ><FONT style="LINE-HEIGHT: 150%"><FONT face=Wingdings
color=#99ccff >v</FONT></FONT><FONT color=#ff6600>增值税号</FONT><FONT color=#ff6600>:
<input name="T_ClientTaxNum" type="text" id="T_ClientTaxNum" size="30" maxlength="50">
</FONT></TD>
</TR>
<TR>
<TD height="30" colspan="6" align="left" valign="middle" ><FONT style="LINE-HEIGHT: 150%"><FONT face=Wingdings
color=#99ccff >v</FONT></FONT><FONT color=#ff6600>增值税银行账号:
<input name="T_ClientTaxANum" type="text" id="T_ClientTaxANum" size="35" maxlength="80">
</FONT></TD>
<TD colspan="6" align="left" valign="middle" ><FONT style="LINE-HEIGHT: 150%"><FONT face=Wingdings
color=#99ccff >v</FONT></FONT><FONT color=#ff6600>增值税开户银行</FONT><FONT color=#ff6600>:
<input name="T_ClientTaxABank" type="text" id="T_ClientTaxABank" size="30" maxlength="50">
</FONT></TD>
</TR>
<TR>
<TD height="30" colspan="6" align="left" valign="middle" ><FONT style="LINE-HEIGHT: 150%"><FONT face=Wingdings
color=#99ccff >v</FONT></FONT><FONT color=#ff6600>增值税开户地址:
<input name="T_ClientTaxAAdd" type="text" id="T_ClientTaxAAdd" size="35" maxlength="80">
</FONT></TD>
<TD colspan="6" align="left" valign="middle" ><FONT style="LINE-HEIGHT: 150%"><FONT face=Wingdings
color=#99ccff >v</FONT></FONT><FONT color=#ff6600>增值税开户电话:
<input name="T_ClientTaxATel" type="text" id="T_ClientTaxATel" size="30" maxlength="50">
</FONT></TD>
</TR>
<TR>
<TD height="30" colspan="6" align="left" valign="middle" ><FONT style="LINE-HEIGHT: 150%"><FONT face=Wingdings
color=#99ccff >v</FONT></FONT><FONT color=#ff6600>开户银行:
<input name="T_ClientABank" type="text" id="T_ClientABank" size="40" maxlength="80">
</FONT></TD>
<TD colspan="6" align="left" valign="middle" ><FONT style="LINE-HEIGHT: 150%"><FONT face=Wingdings
color=#99ccff >v</FONT></FONT><FONT color=#ff6600>银行账号</FONT><FONT color=#ff6600>:
<input name="T_ClientANum" type="text" id="T_ClientANum" size="30" maxlength="50">
</FONT></TD>
</TR>
<TR>
<TD height="16" colspan="12" ><hr color="#566CDB" align="center" size="1"></TD>
</TR>
<TR>
<TD height="30" colspan="6" align="left" valign="middle" >
<input name="NewButton" type="button" class="button_all" id="SaveButton" value="保存">
<input onclick="javascript:location.href='../menu.asp';" name="BackButton" type="button" class="button_all" id="BackButton" value="返回">
</TD>
<TD colspan="6" align="center" valign="middle" ><!--DWLayoutEmptyCell--> </TD>
</TR>
<TR valign="middle">
<TD height="16" colspan="12" ><hr color="#566CDB" align="center" size="1"></TD>
</TR>
<TR>
<TD height="27" colspan="4" align="left" valign="middle" ><FONT style="LINE-HEIGHT: 150%"><FONT face=Wingdings
color=#99ccff >v</FONT></FONT><FONT color=#ff6600>创建者:
<input readonly="true" name="T_ClientCreator" type="text" id="T_ClientIncome22" size="15" maxlength="30" value="<%=ClientCreatorName%>">
<input name="T_ClientCreatorID" type="hidden" value = <%=ClientCreatorID%>>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -