?? 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 + -