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

📄 deal.asp

📁 1 除掉了 时间 限制 2 除掉了 人数 限制 改为 500人 原为5人 3 发现一点小缺陷 增加人员的时候没有判断 登陆名是否重复！ 自己写吧~~~：） 4 又 是一点缺陷
💻 ASP
📖 第 1 页 / 共 2 页
字号:
🔍
12 
<!--#include file="../config.ini" -->
<!--#include file="../commfunction.inc" -->
<%
Dim objcheck
Set objcheck=Server.CreateObject("SmartSales.CheckFunction")
objcheck.CheckUserFunction "deal","read"
set objcheck=nothing

dim conn
dim rs 
set conn=server.CreateObject("adodb.connection")
set rs=server.CreateObject("adodb.recordset")
conn.Open connstring
if Request("strfield")<>"" then
	if Request("strfield")<>"OpenDate" then
		strwhere=" and "&request("strfield")&" like '%"&request("strvalue")&"%'"
	else
		strwhere=" and "&request("strfield")&"='"&request("strvalue")&"'"
	end if
end if
if Request.Form("strfield")<>"" then
	if Request.Form("strfield")<>"OpenDate" then
		strwhere=" and "&request("strfield")&" like '%"&request.form("strvalue")&"%'"
	else
		strwhere=" and "&request("strfield")&"='"&request.form("strvalue")&"'"
	end if
end if
if Request.QueryString("orderbyfield")<>"" then
	'排序字段改变返回第一页
	if session("orderbyfield")<>Request.QueryString("orderbyfield") then
		tofirstpage=true
	else
		tofirstpage=false
	end if
	
	'翻页时保持排序方式，不翻页循环改变升序/降序
	if request("turnpage")="" then
		if request("orderby")="" or request("orderby")="desc" then
			session("orderby")="asc"
		else
			session("orderby")="desc"
		end if
		strwhere=strwhere & " order by "&Request.QueryString("orderbyfield")&" "&session("orderby")
	else
		if request("orderbyfield")<>"" then
			strwhere=strwhere & " order by "&Request.QueryString("orderbyfield")&" "&session("orderby")
		end if
	end if	
	
	'保存当然排序字段
	session("orderbyfield")=Request.QueryString("orderbyfield")
else
	strwhere=strwhere & " order by deal desc"
end if

rs.Open "select * from v_deal where (creator='"&session("loginid")&"' or owner='"&session("loginid")&"' or owner in(select userid from v_userreportto_all where reportto='"&session("loginid")&"'))"&strwhere,conn,1,1

'搜索时用
selecttablename="v_deal where (creator='"&session("loginid")&"' or owner='"&session("loginid")&"' or owner in(select userid from v_userreportto_all where reportto='"&session("loginid")&"'))"

if Request.QueryString("CurPage") = "" or Request("CurPage") = 0 then
	CurPage = 1 
else
	CurPage = cint(Request.QueryString("CurPage"))
end If

if not Rs.eof then
	Rs.PageSize=session("PageSize")
	Rs.AbsolutePage=CurPage
else
	CurPage=0
end if
%>

<html>
<head>
<LINK href="../global.css" rel=STYLESHEET type=text/css>
<LINK href="../tools/menu.css" rel=STYLESHEET type=text/css>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<Script LANGUAGE="javascript" src="../tools/menuView.js"></script>
<title>销售机会</title>
</head>
<script language=javascript>
var   g_UrlParams ;
function  JustShowMenu(src)
{
    document.all(src).style.visibility = "visible";
}

function   HideMenu(src)
{
  document.all(src).style.visibility = "hidden";
}

function  MenuItem_onclick(url,attrstr)
{
	var tempwin=window.open(url,null,attrstr);
	tempwin.location.href=url + g_UrlParams;
     //window.location.href = url + g_UrlParams;
}

function  LocateMenu(src,MenuName)
{
   var left; 
   var top ;
   var parent ;
   parent = document.all(src).offsetParent;
   left =  parent.offsetLeft + document.all(src).offsetLeft + document.all(src).offsetWidth/2;
   top  =  parent.offsetTop  + document.all(src).offsetTop +document.all(src).offsetHeight/2;
   
   while(true)
   {
        parent = parent.offsetParent ;
        if  ( "BODY"==parent.tagName)  break;
        left += parent.offsetLeft ;
        top  += parent.offsetTop;
   }
   document.all(MenuName).style.left = left ;
   document.all(MenuName).style.top = top ;
}

function   ShowMenu(src,MenuName,iUrlParams)
{
   var  i ;
   var  parent = new Array(20) ;
   var  left ;
   var  top  ;
   
   g_UrlParams = iUrlParams ;

   LocateMenu(src,MenuName);
   document.all(MenuName).style.visibility = "visible";
}
</script>

<SCRIPT language=JavaScript>
function showit(objname,imgn){
		if (eval(objname+'.style.display=="block"') == true)
		{
			eval(objname+'.style.display="none";');
			eval('IMG'+objname+'.style.display="block";');			
			eval('IMG1'+objname+'.style.display="none";');			
			//alert('IMG'+objname+'.src = "../images/button2.gif";');
			//eval('IMG'+objname+'.src = "../images/button2.gif";');
		}
		else
		{
			eval(objname+'.style.display="block";');
			eval('IMG'+objname+'.style.display="none";');			
			eval('IMG1'+objname+'.style.display="block";');			
			//alert('IMG'+objname+'.src = "../images/button1.gif";');
			//eval('IMG'+objname+'.src = "../images/button1.gif";');
		}
}

function relativeinput_onchange()
{
if (form1.strfield.value=='OpenDate'){
	dateformat.style.display='block';
	}
if (form1.strfield.value!='OpenDate'){
	dateformat.style.display='none';
	}
if (form1.strfield.value=="dealstagename"){
	strvalue1.style.display='none';
	strvalue2.style.display='block';
	strvalue3.style.display='none';
	form1.strvalue1.value="";
	form1.strvalue3.value="";
	}
if (form1.strfield.value!="dealstagename"&&form1.strfield.value!="ownername"){
	strvalue1.style.display='block';
	strvalue2.style.display='none';
	strvalue3.style.display='none';
	form1.strvalue2.value="";
	form1.strvalue3.value="";
	}
if (form1.strfield.value=="ownername"){
	strvalue1.style.display='none';
	strvalue2.style.display='none';
	strvalue3.style.display='block';
	form1.strvalue1.value="";
	form1.strvalue2.value="";
	}
}
function GetStrValue()
{
12

⌨️ 快捷键说明

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