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

📄 deal.asp

📁 1 除掉了 时间 限制 2 除掉了 人数 限制 改为 500人 原为5人 3 发现一点小缺陷 增加人员的时候没有判断 登陆名是否重复! 自己写吧~~~:) 4 又 是一点缺陷
💻 ASP
📖 第 1 页 / 共 2 页
字号:
if (form1.strfield.value!="dealstagename"&&form1.strfield.value!="ownername"){
	form1.strvalue.value=form1.strvalue1.value;
	}
if (form1.strfield.value=="dealstagename"){
	form1.strvalue.value=form1.strvalue2.value;
	}
if (form1.strfield.value=="ownername"){
	form1.strvalue.value=form1.strvalue3.value;
	}
	if (form1.strfield.value=='OpenDate'){
		if(form1.strvalue.value==""){
			alert("请输入搜索日期!");
			return false;
			}
		if(CheckDate(document.form1.strvalue.value)){
			alert("请输入正确格式的日期!");
			return false;
			}
		}
form1.submit();
}
</SCRIPT>
<body leftmargin="10" rightmargin="10" topmargin="10">
<form name="form1" method="post" action="deal.asp"  onsubmit="return GetStrValue();">
  <table width="100%" height="20" border="0" cellpadding="0" cellspacing="0">
    <tr> 
      <td width="10%">
	 	<select name="strfield" onchange="relativeinput_onchange();">
          <option value=subject <%if request("strfield")="subject" then Response.Write "selected"%>>主题</option>
          <option value=Account <%if request("strfield")="Account" then Response.Write "selected"%>>客户</option>
          <option value=dealstagename <%if request("strfield")="dealstagename" then Response.Write "selected"%>>当前阶段</option>
          <option value=OpenDate <%if request("strfield")="OpenDate" then Response.Write "selected"%>>开始日期</option>
          <option value=ownername <%if request("strfield")="ownername" then Response.Write "selected"%>>销售员</option>
        </select></td>
      <td width="18%">
	  <div id=strvalue1 <%if request("strfield")<>"dealstagename" and request("strfield")<>"ownername" or request("strfield")=""  then response.write "style=display:block" else response.write "style=display:none" end if%>>
          <input type="text" name="strvalue1" value="<%=request("strvalue1")%>">
        </div>
	  <div id=strvalue2 <%if request("strfield")="dealstagename" then response.write "style=display:block" else response.write "style=display:none" end if%>>
	  		<select name="strvalue2" class="stedit">
                  <option value="">--请选择当前阶段--</option>
                  <%getgrouptype selecttablename,"dealstagename",request("strvalue2")%>
            </select></div>
	  <div id=strvalue3 <%if request("strfield")="ownername" then response.write "style=display:block" else response.write "style=display:none" end if%>>
	  		<select name="strvalue3" class="stedit">
                  <option value="">--请选择销售员--</option>
                  <%getgrouptype selecttablename,"ownername",request("strvalue3")%>
            </select></div>
		</td>
      <td> 
        <input type=hidden name="strvalue" value="<%=request("strvalue")%>" > 
        <input type=image src="../images/button_submit.gif" style="cursor:hand" border=0>
          <%
		if CurPage<=1 then
		    Response.Write "<a href='deal.asp?turnpage=yes&orderby="&session("orderby")&"&orderbyfield="&request("orderbyfield")&"&strvalue="&request("strvalue")&"&strfield="&request("strfield")&"&CurPage=1'><img src='../images/button_start.gif' border=0></a>&nbsp;"
		else
		    Response.Write "<a href='deal.asp?turnpage=yes&orderby="&session("orderby")&"&orderbyfield="&request("orderbyfield")&"&strvalue="&request("strvalue")&"&strfield="&request("strfield")&"&CurPage=1'><img src='../images/button_start.gif' border=0></a>&nbsp;"
		    Response.Write "<a href='deal.asp?turnpage=yes&orderby="&session("orderby")&"&orderbyfield="&request("orderbyfield")&"&strvalue="&request("strvalue")&"&strfield="&request("strfield")&"&CurPage="&CurPage-1&"'><img src='../images/button_backward.gif' border=0></a>&nbsp;"
		end if
   		if CurPage>=RS.PageCount then
			Response.Write "<a href='deal.asp?turnpage=yes&orderby="&session("orderby")&"&orderbyfield="&request("orderbyfield")&"&strvalue="&request("strvalue")&"&strfield="&request("strfield")&"&CurPage="&RS.PageCount&"'><img src='../images/button_end.gif' border=0></a>"
		else
			Response.Write "<a href='deal.asp?turnpage=yes&orderby="&session("orderby")&"&orderbyfield="&request("orderbyfield")&"&strvalue="&request("strvalue")&"&strfield="&request("strfield")&"&CurPage="&CurPage+1&"'><img src='../images/button_forward.gif' border=0></a>&nbsp;"
			Response.Write "<a href='deal.asp?turnpage=yes&orderby="&session("orderby")&"&orderbyfield="&request("orderbyfield")&"&strvalue="&request("strvalue")&"&strfield="&request("strfield")&"&CurPage="&RS.PageCount&"'><img src='../images/button_end.gif' border=0></a>"
		end if
		%>
        </td><td width=30%><div id=dateformat <%if request("strfield")="OpenDate" then response.write "style=display:block" else response.write "style=display:none" end if%>>日期输入格式提示:YYYY-MM-DD</div></td>
    </tr>
    <tr> 
      <td height="25" colspan=4><font size="2" class="title">销售机会列表</font> &nbsp;&nbsp;<a href="javascript:opensubwin('resizable=yes, scrollbars=yes, left= 40, top=40, menubar=no, location=no, toolbar=no ,width=750, height=500','newdeal.asp');"><img src="../images/button_new.gif" border=0></a></td>
    </tr>
    <tr > 
      <td height="16" colspan="4" background="../images/title.gif">&nbsp;</td>
    </tr>
    <tr>
      <td height=4 colspan="4"></td>
    </tr>
  </table>
  <table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="DECFAD">
    <tr bgcolor="efefef">
	  <td width="7%" height="22" align=center>操作</td>	
      <td width="15%" align=center><a href="deal.asp?CurPage=<%=CurPage%>&strfield=<%=request("strfield")%>&strvalue=<%=request("strvalue")%>&orderbyfield=deal&orderby=<%=session("orderby")%>">主题</a></td>
      <td  align=center><a href="deal.asp?CurPage=<%=CurPage%>&strfield=<%=request("strfield")%>&strvalue=<%=request("strvalue")%>&orderbyfield=account&orderby=<%=session("orderby")%>">客户</a></td>
      <td width="10%"  align=center><a href="deal.asp?CurPage=<%=CurPage%>&strfield=<%=request("strfield")%>&strvalue=<%=request("strvalue")%>&orderbyfield=dealstagename&orderby=<%=session("orderby")%>">当前阶段</a></td>
      <td width="15%"  align=center><a href="deal.asp?CurPage=<%=CurPage%>&strfield=<%=request("strfield")%>&strvalue=<%=request("strvalue")%>&orderbyfield=dealrate&orderby=<%=session("orderby")%>">成功几率</a></td>
      <td width="10%"  align=center> <a href="deal.asp?CurPage=<%=CurPage%>&strfield=<%=request("strfield")%>&strvalue=<%=request("strvalue")%>&orderbyfield=totalamount&orderby=<%=session("orderby")%>">标的</a></td>
      <td width="10%"  align=center><a href="deal.asp?CurPage=<%=CurPage%>&strfield=<%=request("strfield")%>&strvalue=<%=request("strvalue")%>&orderbyfield=OpenDate&orderby=<%=session("orderby")%>">开始日期</a></td>
      <td width="10%"  align=center><a href="deal.asp?CurPage=<%=CurPage%>&strfield=<%=request("strfield")%>&strvalue=<%=request("strvalue")%>&orderbyfield=owner&orderby=<%=session("orderby")%>">销售员</a></td>
    </tr>
    <%
  set dealid=rs("dealid")
  set deal=rs("deal")
  set dealrate=rs("dealrate") 
  set dealstagename=rs("dealstagename") 
  set accountid=rs("accountid")
  set account=rs("account")
  set totalamount=rs("totalamount")
  set status=rs("status")
  set OpenDate=rs("OpenDate")
  set ownername=rs("ownername")
  set subject=rs("subject")
  i=1:do while not rs.EOF and i<=session("pagesize")%>
    <tr bgcolor="#FFFFFF">
	  <td height="22" align=center width="7%" nowrap><table><tr><td>
	  <% 
' Add Payment Menu
'//////////////// Add Menu List Start /////////////////////////
AddPopupMenu1 true,true,false,false,false,false,false,false, _
				"newDeal.asp?id=", _
				"../delete.asp?dealid=",_
				"",_
				"",_
				"",_
				"",_
				"",_
				"menuDeal"&dealid
'/////////////// Menu List End	
%>
		    <img src="../images/edit.gif" border="0" id="Deal<%=dealid%>" align=absMiddle height=16  width=16 onMouseOver="ShowMenu('Deal<%=dealid%>','menuDeal<%=dealid%>','<%=dealid%>')" onMouseOut="HideMenu('menuDeal<%=dealid%>')"></td>
            <td align=left id="IMGtr1<%=i%>" style="display:block"><a href="javascript:showit('tr1<%=i%>',1)" title="查看明细"><img src="../images/button1.gif" border=0></a><td>
            <td align=left id="IMG1tr1<%=i%>" style="display:none"><a href="javascript:showit('tr1<%=i%>',1)" title="隐藏明细"><img src="../images/button2.gif" border=0></a></td>
          </tr></table>
	  </td>
      <td align=center><a href="javascript:opensubwin3('dealdetail.asp?dealid=<%=dealid%>','销售机会<%=dealid%>','toolbar=no,scrollbars=yes,location=no,status=no,menubar=no,width=600,height=400,top=150,left=160');"><%=subject%></a></td>
      <td align=center><a href="javascript:opensubwin3('../account/accountdetail.asp?accountid=<%=accountid%>','客户<%=accountid%>','toolbar=no,scrollbars=yes,location=no,status=no,menubar=no,width=600,height=400,top=150,left=160');"><%=account%></a></td>
      <td align=center height=18><%=dealstagename%></td>
      <td align=center><%=dealrate%>%</td>
      <td align=center><%if totalamount<>"" then Response.Write formatnumber(totalamount,2)%></td>
      <td align=center><%=OpenDate%></td>
      <td align=center><%=ownername%></td>
    </tr>
	<tr bgcolor="#FFFFFF" border=0  id='tr1<%=i%>' style=display:none><td colspan=8>
<table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="FFFFFF">
          <tr> 
            <td width="10%" align=center  bgcolor="DEDFDE">完成日期</td>
            <td width="25%" align=center bgcolor="efefef"><%=rs("closeddate")%></td>
            <td width="10%" align=center bgcolor="DEDFDE">联系人</td>
            <td width="20%" align=center bgcolor="efefef"><%=rs("contact")%></td>
            <td width="10%" align=center bgcolor="DEDFDE">失败原因</td>
            <td width="25%" align=center bgcolor="efefef"><%=rs("lostreason")%></td>
          </tr>
          <tr> 
            <td align=center height=18  bgcolor="DEDFDE">销售机会来源</td>
            <td align=center bgcolor="efefef"><%=rs("dealsource")%></td>
            <td align=center bgcolor="DEDFDE">销售机会流程</td>
            <td align=center bgcolor="efefef"><%=rs("dealprocess")%></td>
            <td align=center bgcolor="DEDFDE">最后修改者</td>
            <td align=center bgcolor="efefef"><%=rs("LastModName")%></td>
          </tr>
          <tr> 
            <td align=center height=18  bgcolor="DEDFDE">创建者</td>
            <td align=center bgcolor="efefef"><%=rs("CreateName")%></td>
            <td align=center bgcolor="DEDFDE">创建时间</td>
            <td align=center bgcolor="efefef"><%=rs("CreateDate")%></td>
            <td align=center bgcolor="DEDFDE">最后修改时间</td>
            <td align=center bgcolor="efefef"><%=rs("lastmodDate")%></td>
          </tr>
          <tr> 
            <td align=center height=18  bgcolor="DEDFDE">描述</td>
            <td colspan="5" align=LEFT bgcolor="efefef"><%=rs("description")%></td>
          </tr>
          <tr> 
            <td align=center height=18  bgcolor="DEDFDE">系统提示</td>
            <td colspan="5" align=left bgcolor="efefef"><font color=red><%=rs("warn")%></font></td>
          </tr>
        </table>

	</td></tr>
    <%
  i=i+1
  rs.MoveNext
  loop
%>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr height="50"><td>第<%=CurPage%>页&nbsp;/&nbsp;共<%=RS.PageCount%>页&nbsp;/&nbsp;记录数:<%=Rs.RecordCount%>条
</td></tr></table>
<%
  rs.Close
  set rs=nothing
  conn.Close 
  set conn=nothing
%>
</form>
</body>
</html>

⌨️ 快捷键说明

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