📄 project_input.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="../../config.asp"-->
<!--#include file="../checklogin.asp"-->
<%
if ChkAdmin("oa_addproject")=False then
call message("您没有添加项目的权限","back")
call endexit()
end if
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<SCRIPT language=JavaScript src="../../inc/meizzDate.js"></SCRIPT>
<link href="../img/css1.css" type=text/css rel=stylesheet>
<style type="text/css">
<!--
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
.style1 {
color: #FFFFFF;
font-weight: bold;
}
.style4 {color: #CC0000}
-->
</style>
</head>
<%
num=session("AdminName")&year(now())&month(now())&day(now())&second(now())&minute(now())
id=replace(request("id"),"'","")
act=request("act")
'基本信息
cusid=replace(trim(request.form("cusid")),"'","")
pro_num=replace(trim(request.form("pro_num")),"'","")
title=replace(trim(request.form("title")),"'","")
content=replace(trim(request.form("content")),"'","")
content=replace(content,Chr(13),"<br>")
flag=replace(trim(request.form("flag")),"'","")
uname=replace(trim(request.form("uname")),"'","")
mobile=replace(trim(request.form("mobile")),"'","")
tel=replace(trim(request.form("tel")),"'","")
fax=replace(trim(request.form("fax")),"'","")
email=replace(trim(request.form("email")),"'","")
qq=replace(trim(request.form("qq")),"'","")
companyid=session("companyid")
uid=request.Form("uid")
adduid=session("adminid")
sql="insert into oa_cus_project(pro_num,title,content,flag,cusid,uname,mobile,tel,fax,email,qq,uid,adduid,companyid) "& _
"values('"&pro_num&"','"&title&"','"&content&"','"&flag&"',"&cusid&",'"&uname&"','"&mobile&"','"&tel&"','"&fax&"','"&email&"','"&qq&"',"&uid&","&adduid&","&companyid&")"
upsql="update oa_cus_contact set cusid="&cusid&",uname='"&uname&"',mobile='"&mobile&"',tel='"&tel&"',fax='"&fax&"',email='"&email&"',qq='"&qq&"' where id="&request.Form("modid")
if act="add" then
conn.execute(sql)
call message("添加成功","projectlist.asp")
call exitend()
elseif act="edit" then
conn.execute(upsql)
call message("修改成功","cus_contactlist.asp?cusid="&cusid&"")
call exitend()
end if
%>
<body>
<%
if act="" then
%>
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#F2F2F2" class="tabel1">
<tr align="center">
<td height="25" bgcolor="#CC0000"><span class="style1">项目信息设置</span></td>
</tr>
<form name="myform" method="post" action="project_input.asp?act=add" onSubmit="return CheckForm();">
<tr bgcolor="#F9F9F9">
<td height="25" align="center"><table width="95%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="20" colspan="2" align="left"> <strong>项目信息 </strong> </td>
</tr>
<tr>
<td width="62%" align="left" valign="top"><TABLE width="100%" BORDER=0 CELLPADDING=0 CELLSPACING=5>
<TR>
<TD> 项目编号 </TD>
<TD><input name="pro_num" type=text class="tabel1" id="pro_num" maxlength="" value="<%=num%>"></TD>
</TR>
<TR>
<TD> 所属客户</TD>
<TD><select name="cusid" id="cusid">
<option value="">请选择客户</option>
<%
sql="select id,cus_name from oa_crm_cus where uid="&session("adminid")
set rs=conn.execute(sql)
do while not rs.eof
%>
<option value="<%=rs(0)%>"><%=rs(1)%></option>
<%
rs.movenext
loop
rs.close
set rs=nothing
%>
</select></TD>
</TR>
<TR>
<TD> 项目名称 </TD>
<TD><input name="title" type=text class="tabel1" id="title" maxlength="10">
<span class="style4">*</span></TD>
</TR>
<TR>
<TD WIDTH=117>联系人姓名</TD>
<TD WIDTH=453><input name="uname" type=text class="tabel1" id="uname" maxlength="10">
<span class="style4">*</span></TD>
</TR>
<TR>
<TD>手机</TD>
<TD><input name="mobile" type=text class="tabel1" id="mobile" maxlength="11">
<span class="style4">*</span></TD>
</TR>
<TR>
<TD>电话</TD>
<TD><input name="tel" type=text class="tabel1" id="cus_contactphone2" size="13" >
<span class="style4">*</span></TD>
</TR>
<TR>
<TD>传真</TD>
<TD><input name="fax" type=text class="tabel1" id="cus_contactfax3" size="13" ></TD>
</TR>
<TR>
<TD>QQ</TD>
<TD><input name="qq" type=text class="tabel1" id="cus_contactemail4" maxlength="10" ></TD>
</TR>
<TR>
<TD>E-Mail</TD>
<TD><input name="email" type=text class="tabel1" id="email" ></TD>
</TR>
<TR>
<TD> 是否签订合同 </TD>
<TD><input type="radio" name="flag" value="是">
是
<input name="flag" type="radio" value="否" checked>
否</TD>
</TR>
<TR>
<TD> 业务人员 </TD>
<TD><span class="style4">
<select name="uid" id="uid">
<option value="<%=session("adminid")%>" selected><%=session("truename")%></option>
<%
sql="select id,truename from oa_Admin where parentid="&session("adminid")
set rs=conn.execute(sql)
do while not rs.eof
%>
<option value="<%=rs(0)%>"><%=rs("truename")%></option>
<%
rs.movenext
loop
rs.close
set rs=nothing
%>
</select>
</span></TD>
</TR>
<TR>
<TD>需求描述 </TD>
<TD><textarea name="content" cols="40" rows="5" class="tabel1" id="content"></textarea></TD>
</TR>
<TR>
<TD> </TD>
<TD><input name="Submit3" type="submit" class="tabel1" value="提交">
<input name="Submit22" type="reset" class="tabel1" value="重置"></TD>
</TR>
</TABLE></td>
<td width="38%" align="left" valign="top"> </td>
</tr>
</table></td>
</tr>
</form>
</table>
<%
elseif act="edits" then
msql="select cusid,uname,mobile,tel,fax,email,qq,b.cus_name from oa_cus_contact as a inner join oa_crm_cus as b on a.cusid=b.id where a.id="&id
set rs=conn.execute(msql)
if not rs.eof then
cusid1=trim(rs(0))
uname1=trim(rs(1))
mobile1=trim(rs(2))
tel1=trim(rs(3))
fax1=trim(rs(4))
email1=trim(rs(5))
qq1=trim(rs(6))
cus_name1=trim(rs(7))
end if
rs.close
set rs=nothing
%>
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#F2F2F2" class="tabel1">
<tr align="center">
<td height="25" bgcolor="#CC0000"><span class="style1">项目信息修改</span></td>
</tr>
<form name="myform" method="post" action="cus_addcontact.asp?act=edit" onSubmit="return CheckForm();">
<tr bgcolor="#F9F9F9">
<td height="25" align="center"><table width="95%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="20" colspan="2" align="left"><b>联系人信息</b></td>
</tr>
<tr>
<td width="62%" align="left" valign="top"><TABLE width="100%" BORDER=0 CELLPADDING=0 CELLSPACING=5>
<TR>
<TD> 项目编号 </TD>
<TD><input name="pro_num2" type=text class="tabel1" id="pro_num2" maxlength="" value="<%=num%>"></TD>
</TR>
<TR>
<TD> 所属客户</TD>
<TD><select name="select" id="select">
<option value="">请选择客户</option>
<%
sql="select id,cus_name from oa_crm_cus where uid="&session("adminid")
set rs=conn.execute(sql)
do while not rs.eof
%>
<option value="<%=rs(0)%>"><%=rs(1)%></option>
<%
rs.movenext
loop
rs.close
set rs=nothing
%>
</select></TD>
</TR>
<TR>
<TD> 项目名称 </TD>
<TD><input name="title2" type=text class="tabel1" id="title2" maxlength="10">
<span class="style4">*</span></TD>
</TR>
<TR>
<TD WIDTH=117>联系人姓名</TD>
<TD WIDTH=453><input name="uname2" type=text class="tabel1" id="uname4" maxlength="10">
<span class="style4">*</span></TD>
</TR>
<TR>
<TD>手机</TD>
<TD><input name="mobile2" type=text class="tabel1" id="mobile2" maxlength="12">
<span class="style4">*</span></TD>
</TR>
<TR>
<TD>电话</TD>
<TD><input name="tel2" type=text class="tabel1" id="tel2" >
<span class="style4">*</span></TD>
</TR>
<TR>
<TD>传真</TD>
<TD><input name="fax2" type=text class="tabel1" id="fax2" ></TD>
</TR>
<TR>
<TD>QQ</TD>
<TD><input name="qq2" type=text class="tabel1" id="qq2" maxlength="11" ></TD>
</TR>
<TR>
<TD>E-Mail</TD>
<TD><input name="email2" type=text class="tabel1" id="email3" ></TD>
</TR>
<TR>
<TD> 是否签订合同 </TD>
<TD><input type="radio" name="flag" value="是">
是
<input name="flag" type="radio" value="否" checked>
否</TD>
</TR>
<TR>
<TD> 业务人员 </TD>
<TD><span class="style4">
<select name="select" id="select2">
<option value="<%=session("adminid")%>" selected><%=session("truename")%></option>
<%
sql="select id,truename from oa_Admin where parentid="&session("adminid")
set rs=conn.execute(sql)
do while not rs.eof
%>
<option value="<%=rs(0)%>"><%=rs("truename")%></option>
<%
rs.movenext
loop
rs.close
set rs=nothing
%>
</select>
</span></TD>
</TR>
<TR>
<TD>需求描述 </TD>
<TD><textarea name="textarea" cols="40" rows="5" class="tabel1" id="textarea"></textarea></TD>
</TR>
<TR>
<TD> </TD>
<TD><input name="Submit32" type="submit" class="tabel1" value="提交">
<input name="Submit222" type="reset" class="tabel1" value="重置"></TD>
</TR>
</TABLE></td>
<td width="38%" align="left" valign="top"> </td>
</tr>
<tr>
<td height="25" colspan="2" align="left"><input name="Submit" type="submit" class="tabel1" value="修改">
<input name="Submit2" type="reset" class="tabel1" value="重置">
<input name="modid" type="hidden" id="modid" value="<%=id%>"></td>
</tr>
</table></td>
</tr>
</form>
</table>
<%end if%>
</body>
</html>
<script language="javascript">
function CheckForm()
{
var objFrm=document.myform;
if(objFrm.cusid.value=="")
{
alert("请选镇客户！");
objFrm.cusid.focus();
return false;
}
if(objFrm.uname.value=="")
{
alert("请输入联系人姓名！");
objFrm.uname.focus();
return false;
}
if(objFrm.mobile.value=="")
{
alert("请输入联系人手机！");
objFrm.mobile.focus();
return false;
}
if(objFrm.tel.value=="")
{
alert("请输入联系人电话！");
objFrm.tel.focus();
return false;
}
return true;
}
</script>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -