📄 account.asp
字号:
<!--#include file="../config.ini" -->
<!--#include file="../commfunction.inc" -->
<%
Dim objcheck
Set objcheck=Server.CreateObject("SmartSales.CheckFunction")
objcheck.CheckUserFunction "account","read"
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")<>"lastmoddate" 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")<>"lastmoddate" 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
orderby=" order by "&Request.QueryString("orderbyfield")&" "&session("orderby")
else
if request("orderbyfield")<>"" then
orderby=" order by "&Request.QueryString("orderbyfield")&" "&session("orderby")
end if
end if
session("orderbyfield")=Request.QueryString("orderbyfield")
else
orderby=" order by lastmoddate desc,accountlevel desc"
end if
if objcheck.CheckUserFunction2("delivery","edit") or objcheck.CheckUserFunction2("payment","edit") or objcheck.CheckUserFunction2("service","edit") then
rs.Open "select top 100 * from v_account where 1=1"&strwhere&orderby,conn,1,1
set rscount=conn.execute("select count(*) as count from v_account where 1=1"&strwhere)
else
rs.Open "select top 100 * from v_account where (ownerid='"&session("loginid")&"' or ownerid in(select userid from v_userreportto_all where reportto='"&session("loginid")&"') or accountid in(select accountid from accountshare where shareto='"&session("loginid")&"'))"&strwhere&orderby,conn,1,1
set rscount=conn.execute("select count(*) as count from v_account where (ownerid='"&session("loginid")&"' or ownerid in(select userid from v_userreportto_all where reportto='"&session("loginid")&"') or accountid in(select accountid from accountshare where shareto='"&session("loginid")&"'))"&strwhere)
end if
if objcheck.CheckUserFunction2("delivery","edit") or objcheck.CheckUserFunction2("payment","edit") or objcheck.CheckUserFunction2("service","edit") then
selecttablename="v_account"
else
selecttablename="v_account where (ownerid='"&session("loginid")&"' or ownerid in(select userid from v_userreportto_all where reportto='"&session("loginid")&"'))"
end if
if Request.QueryString("CurPage") = "" or Request("CurPage") = 0 or tofirstpage=true 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=='lastmoddate'){
dateformat.style.display='block';
}
if (form1.strfield.value!='lastmoddate'){
dateformat.style.display='none';
}
if (form1.strfield.value=="accounttype"){
strvalue1.style.display='none';
strvalue2.style.display='block';
strvalue3.style.display='none';
strvalue4.style.display='none';
strvalue5.style.display='none';
form1.strvalue1.value="";
form1.strvalue3.value="";
form1.strvalue4.value="";
form1.strvalue5.value="";
}
if (form1.strfield.value!="accounttype"&&form1.strfield.value!="owner"&&form1.strfield.value!="industry"&&form1.strfield.value!="province1"){
strvalue1.style.display='block';
strvalue2.style.display='none';
strvalue3.style.display='none';
strvalue4.style.display='none';
strvalue5.style.display='none';
form1.strvalue2.value="";
form1.strvalue3.value="";
form1.strvalue4.value="";
form1.strvalue5.value="";
}
if (form1.strfield.value=="owner"){
strvalue1.style.display='none';
strvalue2.style.display='none';
strvalue3.style.display='block';
strvalue4.style.display='none';
strvalue5.style.display='none';
form1.strvalue1.value="";
form1.strvalue2.value="";
form1.strvalue4.value="";
form1.strvalue5.value="";
}
if (form1.strfield.value=="industry"){
strvalue1.style.display='none';
strvalue2.style.display='none';
strvalue3.style.display='none';
strvalue4.style.display='block';
strvalue5.style.display='none';
form1.strvalue1.value="";
form1.strvalue2.value="";
form1.strvalue3.value="";
form1.strvalue5.value="";
}
if (form1.strfield.value=="province1"){
strvalue1.style.display='none';
strvalue2.style.display='none';
strvalue3.style.display='none';
strvalue4.style.display='none';
strvalue5.style.display='block';
form1.strvalue1.value="";
form1.strvalue2.value="";
form1.strvalue3.value="";
form1.strvalue4.value="";
}
}
function GetStrValue()
{
if (form1.strfield.value!="accounttype"&&form1.strfield.value!="owner"&&form1.strfield.value!="industry"&&form1.strfield.value!="province1"){
form1.strvalue.value=form1.strvalue1.value;
}
if (form1.strfield.value=="accounttype"){
form1.strvalue.value=form1.strvalue2.value;
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -