| 网站首页 | 业界新闻 | 小组 | 威客 | 人才 | 下载频道 | 博客 | 代码贴 | 在线编程 | 编程论坛
欢迎加入我们,一同切磋技术
用户名:   
 
密 码:  
共有 365 人关注过本帖
标题:按日期查询后的分页问题
只看楼主 加入收藏
qinyun
Rank: 1
等 级:新手上路
帖 子:46
专家分:0
注 册:2008-6-6
结帖率:20%
收藏
 问题点数:0 回复次数:0 
按日期查询后的分页问题
按日期查询后的分页问题
我是一个初学者,以下是我的页面代码,在按日期段及姓名查询后分页不正常,请大家帮忙指点一下,先谢谢

<!--#include file =conn.asp-->

<%
if session("baoxiuuser_id")="" then
       response.write "<script language=jscript>alert('对不起,您不是本站的注册用户或没有登陆系统!');window.location.href='index.asp';</script>"
    response.end
end if
%>

<html>
<head>
<title>报修管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../admin/style.css" rel="stylesheet" type="text/css">
</head>
<script src="../js/js.js"></script>


</SCRIPT>

<DIV ID="overDiv" STYLE="position:absolute; visibility:hide; z-index:1;"></DIV><BR>
                <SCRIPT LANGUAGE="JavaScript" SRC="../js/overlib.js"></SCRIPT>
<script language="javascript" src="js/calendar.js"> </script>
</script>
<script   language="Javascript"><!--   
  function   gopage(p){ var url1 = "baoxiu_guanli.asp"   
          window.location.href   =   url1   ;//這里妳可以這樣該改!   
          }
          
  //   --></script>   
   
 <script language="javascript">

function checkform()    
{
    
if (form1.baoxiu_date1.value=="")
    
        {
        
        alert("开始日期不能为空");
        
        form1.baoxiu_date1.focus();
        
        return false;
        
        }    
        
if (form1.baoxiu_date2.value=="")
    
        {
        
        alert("结束日期不能为空");
        
        form1.baoxiu_date2.focus();
        
        return false;
        
        }        
        
    if (form1.baoxiu_date2.value<form1.baoxiu_date1.value)    
        
        {
        
        alert("结束日期不能小于开始日期");
        
        form1.baoxiu_date2.focus();
        
        return false;
        
            }
    return true;    
if (form1.paidan_name.value=="")
    
        {
        
        alert("工程师姓名不能为空");
        
        form1.paidan_name.focus();
        
        return false;
        
        }    
    }
    
            
                                        




</script>
 
<body>

<table width="99%" border="0" align="center" cellpadding="0" cellspacing="1" class="TableBorder">
  <tr>
    <td height="30"  colspan=4 align="center" class="TableTitle1"><b>服务数据管理</b></td>
  </tr>
  <tr>
    <td width="92" align="center" class="TableRow2" height=25><strong>服务管理:</strong></td>
    <td width="184" class="TableRow2"><div align="left">数据分析 | <a href="dengluok.asp">退出管理</a></div></td>
    <td width="667"  height="30"valign="middle" class="TableRow2">
      <form name="form1" method="POST" action="baoxiu_guanli.asp"  onsubmit="return checkform() ">
      <div align="left">日期:
        <input name="baoxiu_date1" type="text" id="baoxiu_date1" size="20" value="<%= year(date)%>-<%= month(date)%>-1" onFocus="setday(this)" readonly >  
        &nbsp;至&nbsp;
  <input name="baoxiu_date2" type="text" id="baoxiu_date2" onFocus="setday(this)" value="<%= year(date)%>-<%= month(date)%>-<%= day(date)%>" size="20" readonly>
工程师:
<select name="paidan_name" size="1" id="paidan_name" >
  <option value="" selected>选择所有人员</option>
  <option value="周伟">周伟</option>
  <option value="汪伟">汪伟</option>
  <option value="王波">王波</option>
  <option value="熊飞">熊飞</option>
  <option value="汪龙">汪龙</option>
  <option value="袁海江">袁海江</option>
</select>
<input type="submit" name="Submit" value="提交">
</div>
<input type="hidden" name="xingming" value="<%=request.form("paidan_name")%>">
<input type="hidden" name="date1" value="<%=request.form("baoxiu_date1")%>">
<input type="hidden" name="date2" value="<%=request.form("baoxiu_date2")%>">
<input type="hidden" name="condition2" value="<%=getcondition%>">
<input type="hidden" name="key" value="<%=getkey%>">
<input type="hidden" name="pageno" value="<%=getpageno%>">
   
      </form> </td>
    <td width="17" class="TableRow2">&nbsp;</td>
</table>






<div id="main1" style="color:blue" onClick="document.all.child1.style.display=(document.all.child1.style.display =='none')?'':'none'" >

<%

dim xingming,date1,date2


xingming=request.form("paidan_name")
date1=request.form("baoxiu_date1")
date2=request.form("baoxiu_date2")




sql="select * from baoxiu where paidan_name like '%" & xingming & "%' and baoxiu_date  between #"&date1&"#  and  #"&date2&"#  order by baoxiu_date desc"
Set rs= Server.CreateObject("ADODB.Recordset")

rs.open sql,conn,1,1

rs.pagesize=""&htshu&""
'实现分页
if rs.Eof then
    rs_total = 0
else
   rs_total = rs.RecordCount
end if
dim pageno
maxpage=rs.pagecount
getpageno = (Request("pageno"))
if(getpageno = "")then
    pageno = 1
else
    pageno = getpageno
End if
if(not rs.Eof)then
    rs.AbsolutePage = pageno
end if    
%>
<table width="962"  bgcolor="#CCCC99"  border="0" align="center" cellpadding="0" cellspacing="0" >
   
    <tr>
        <td width="8%" height="30" align="center"  ><strong>工程师名</strong></td>
        <td width="7%" align="center"  ><strong>服务单数</strong></td>
        <td width="5%"  align="center"  ><strong>满意</strong></td>
        <td width="5%"  align="center"  ><strong>一般</strong></td>
        <td width="5%"  align="center"  ><strong>投诉</strong></td>
        <td width="5%"  align="center"  ><strong>未访</strong></td>
        <td width="9%" align="center"  ><strong>应收费用</strong></td>
        <td width="9%" align="center"  ><strong>实收金额</strong></td>
        <td width="8%" align="center"  ><strong>创收金额</strong></td>        
        <td width="10%" align="center"  ><strong>服务单费</strong></td>
        <td width="7%" align="center"  ><strong>客户评价</strong></td>
        <td width="9%" align="center"  ><strong>所得合计</strong></td>
        <td width="9%" align="center"  ><strong>查看祥细</strong></td>
    </tr>
  </table>
</div>
 

<div id="child1" style="display:none">

<table width="962" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td><table  width="100%" border="0" align="center" cellpadding="0" cellspacing="1" class="tableBorder5">
      <tr>
        
        <td width="150" height="30" align="center" class="TableTitle1" ><strong> 报修时间</strong></td>
        <td width="55"  align="center" class="TableTitle1" ><strong>客户</strong></td>
        <td width="110"  align="center" class="TableTitle1" ><strong>联系电话</strong></td>
        <td width="220"  height="30" align="center" class="TableTitle1" ><strong>联系地址</strong></td>
        <td width="120"  align="center" class="TableTitle1" ><strong>报修原因</strong></td>
        <td width="55"  align="center" class="TableTitle1" ><strong>工程师</strong></td>
        <td width="65"  height="30" align="center" class="TableTitle1" ><strong>服务状态</strong></td>
        <td width="85"  align="center" class="TableTitle1" ><strong>服务时间</strong></td>
        <td width="85"  align="center" class="TableTitle1" ><strong>客户评价</strong></td>
      </tr>
      <%
              If(rs.Eof)Then
              %>
      <tr>
        <td height="120" colspan="9" align="center" class="TableBody1">对不起!没有找到你需要的报修记录!</td>
      </tr>
<!--#include file ="bottom.asp"-->
      <%
                Response.End()
                End If
                repeat_rows = 0
                While(repeat_rows < rs.PageSize and Not rs.Eof)
              %>





      <%baoxiu_id=rs("baoxiu_id")%>
      <tr>

<%'报修时间-------------------------------------------------------------------------------------------------------- %>
      <td width="140" height="30" align="center"  class="TableBody1" ><a href="baoxiu_list.asp?baoxiu_id=<%=baoxiu_id%>"><font color="#0099FF"><%=rs("baoxiu_date")%></font></a>
  
</td>

<%'报修姓名--------------------------------------------------------------------------------------------------------%>

<td width="65" height="30" align="center"  class="TableBody1" >
   <%
Response.Write("<a href='baoxiu_list.asp?baoxiu_id="&rs("baoxiu_id")&"'>"&(rs("user_name"))&"</a>")
%>
</td>


<%'报修电话--------------------------------------------------------------------------------------------------------%>
<td width="85" height="30" align="center"  class="TableBody1" >
      <%
Response.Write("<a href='baoxiu_list.asp?baoxiu_id="&rs("baoxiu_id")&"'>"&(rs("contact"))&"</a>")
%>
        </td>


<%'联系地址-------------------------------------------------------------------------------------------------------%>
<td width="200" height="30" align="center" class="TableBody1" >   
<%
                If(Len(rs("user_dizhi")) > 9)Then
                Response.Write("<a href='baoxiu_list.asp?baoxiu_id="&rs("baoxiu_id")&"'>"&(Mid(rs("user_dizhi"),1,9))&"…</a>")
                Else
                Response.Write("<a href='baoxiu_list.asp?baoxiu_id="&rs("baoxiu_id")&"'>"&(rs("user_dizhi"))&"</a>")
                End If
                %>     
        
        </td>


<%'报修原因--------------------------------------------------------------------------------------------------------%>
        <td width="180" height="30" align="center" class="TableBody1" >
        
<%
                If(Len(rs("baoxiu_yuanyin")) > 9)Then
                Response.Write("<a href='baoxiu_list.asp?baoxiu_id="&rs("baoxiu_id")&"'>"&(Mid(rs("baoxiu_yuanyin"),1,9))&"…</a>")
                Else
                Response.Write("<a href='baoxiu_list.asp?baoxiu_id="&rs("baoxiu_id")&"'>"&(rs("baoxiu_yuanyin"))&"</a>")
                End If
                %>  


</td>

<%'工程师姓名--------------------------------------------------------------------------------------------------------%>
         <td width="75" height="30" align="center" class="TableBody1" ><a href="baoxiu_list.asp?baoxiu_id=<%=baoxiu_id%>" onMouseOver="drc('姓名:<%=rs("user_name")%><br>电话:<%=rs("contact")%><br>地址:<%=rs("user_dizhi")%><br>原因:<%=rs("baoxiu_yuanyin")%><br>服务费:<%=rs("user_feiyong")%><br>对策:<%=rs("weixiu_main")%><br>实收:<%=rs("weixiu_feiyong")%><br>客户评价:<%=rs("kehuyijian")%>','<%=rs("paidan_name")%>的单子'); return true;" onMouseOut="nd(); return true;"><%=rs("paidan_name")%></a>
</td>

<%'报修状态--------------------------------------------------------------------------------------------------------%>
        <td width="75" height="30" align="center" class="TableBody1" ><%if rs("weixiu_zhuangtai")<>"" then%><a href="baoxiu_list.asp?baoxiu_id=<%=baoxiu_id%>"><%=rs("weixiu_zhuangtai")%><%else%><b>×</b><%end if%></td>
        <td width="70" align="center"  class="TableBody1"><%if rs("weixiu_zhuangtai")<>"" then%><a href="baoxiu_list.asp?baoxiu_id=<%=baoxiu_id%>"><%=rs("weixiu_time")%><%else%><b>×</b><%end if%></td>
        <td width="70" align="center"  class="TableBody1">
  <%if rs("keping")="未联系上"  then%><a href="baoxiu_list.asp?baoxiu_id=<%=baoxiu_id%>"><font color="#000000"><%=rs("keping")%></font><%else%><b></b>
  <%if rs("keping")="投诉"  then%><a href="baoxiu_list.asp?baoxiu_id=<%=baoxiu_id%>"><font color="#009933"><%=rs("keping")%></font><%else%><b></b>
  <%if rs("keping")="非常不满" then%><a href="baoxiu_list.asp?baoxiu_id=<%=baoxiu_id%>"><font color="#0000FF"><%=rs("keping")%></font><%else%><b></b>
  <%if rs("keping")="不满意" then%><a href="baoxiu_list.asp?baoxiu_id=<%=baoxiu_id%>"><font color="#0000FF"><%=rs("keping")%></font><%else%><b></b>
  <%if rs("keping")="一般" then%><a href="baoxiu_list.asp?baoxiu_id=<%=baoxiu_id%>"><font color="#FF00FF"><%=rs("keping")%></font><%else%><b></b>
  <%if rs("keping")="比较满意" then%><a href="baoxiu_list.asp?baoxiu_id=<%=baoxiu_id%>"><font color="#FF0000"><%=rs("keping")%></font><%else%><b></b>
  <%if rs("keping")="非常满意" then%><a href="baoxiu_list.asp?baoxiu_id=<%=baoxiu_id%>"><font color="#FF0000"><%=rs("keping")%></font><%else%><b></b>
  <%if rs("keping")<>"" then%><a href="baoxiu_list.asp?baoxiu_id=<%=baoxiu_id%>"><font color="#FF0000"><%=rs("keping")%></font><%else%><b>×</b>
  <%end if%>
  <%end if%>
  <%end if%>
  <%end if%>    
  <%end if%>
  <%end if%>
  <%end if%>    
  <%end if%>        

        
        </td>
      </tr>
      <%
              repeat_rows = repeat_rows + 1
              rs.MoveNext
              Wend
              %>
    </table>
      <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr>
          <td width="302" height="30">[<font color=red><%=pageno%></font>/<%=rs.PageCount%>]&nbsp;每页<font color=red><%=rs.PageSize%></font>条&nbsp;共<font color=red><%=rs_total%></font>条记录 【<a href="baoxiulist.xls">Excel</a>】</td>
          <td width="171">&nbsp;</td>
          <td width="277"><span>
            </span>
            <div align="right">
              <table width="400" height="20" border="0" cellpadding="0" cellspacing="0">
                <tr>
                  <td width="400" align="right"><%for i=1 to maxpage%>
                    [<a href="dengluok.asp?pageno=<%=i%>"><%=i%></a>]
                    <%next%>                  </td>
                </tr>
              </table>
            </div>
            <%
            rs.close
            Set rs = Nothing
            %></td>
        </tr>
    </table>
    </td>
  </tr>
</table>
</div>

<div id="main1" style="color:blue" onClick="document.all.child1.style.display=(document.all.child1.style.display =='none')?'':'none'" >

<%

sql2="select count(bx_id) as danshou,sum(user_feiyong) as yingshou,sum(chuangshou)as chuang,sum(weixiu_feiyong)as shishou,sum(paodanfei)as danfei from baoxiu where paidan_name like '%" & xingming & "%' and baoxiu_date  between #"&date1&"#  and  #"&date2&"#  "
Set rshuizong= Server.CreateObject("ADODB.Recordset")
rshuizong.open sql2,conn,1,1
%>

<td><table  width="962" border="0" align="center" cellpadding="0" cellspacing="1" class="tableBorder5">
      <tr>
        
        <td width="8%" height="30" align="center" class="TableRow2"><strong><%=xingming %></strong></td>
        <td width="7%" align="center" class="TableRow2" ><strong><%=rshuizong("danshou")%></strong></td>
        <td width="5%"  align="center" class="TableRow2" ><strong></strong></td>
        <td width="5%"  align="center" class="TableRow2" ><strong></strong></td>
        <td width="5%"  align="center" class="TableRow2" ><strong></strong></td>
        <td width="5%"  align="center" class="TableRow2" ><strong></strong></td>
        <td width="9%" align="center" class="TableRow2" ><strong><%=rshuizong("yingshou")%>.00</strong></td>
        <td width="9%" align="center" class="TableRow2" ><strong><%=rshuizong("shishou")%>.00</strong></td>
        <td width="8%" align="center" class="TableRow2" ><strong><%=rshuizong("chuang")%>.00</strong></td>        
        <td width="10%" align="center" class="TableRow2" ><strong><%=rshuizong("danfei")%>.00</strong></td>
        <td width="7%" align="center" class="TableRow2"><strong></strong></td>
        <td width="9%" align="center" class="TableRow2"><strong></strong></td>
        <td width="9%" align="center" class="TableRow2" ><strong>查看祥细</strong></td>
      </tr>
</table>    
</div>




























<%
sqlzong="select * from baoxiu where paidan_name like '%" & xingming & "%'  and baoxiu_date  between #"&date1&"#  and  #"&date2&"#   order by baoxiu_date desc"
Set rs_zong= Server.CreateObject("ADODB.Recordset")
rs_zong.open sqlzong,conn,1,1

rs_zong.pagesize=""&htshu&""
'实现分页
if rs_zong.Eof then
    rs_total = 0
else
   rs_total = rs_zong.RecordCount
end if
dim pagenozong
maxpagezong=rs_zong.pagecount
getpagenozong = (Request("pagenozong"))
if(getpagenozong = "")then
    pagenozong = 1
else
    pagenozong = getpagenozong
End if
if(not rs_zong.Eof)then
    rs_zong.AbsolutePage = pagenozong
end if    
%>


<table width="100%" height="72" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td  height="20" align=center>
  <tr>
    <td align=center>
      <table cellspacing="0" width="100%">
        <tr align="center">
          <td valign="top" colspan="3">
          <form name="Del_baoxiu" method="post">
            <table  width="100%" border="0" align="center" cellpadding="0" cellspacing="1" class="tableBorder">
              <tr>
                <td width="150" height="30" align="center" class="TableTitle1" ><strong> 报修时间</strong></td>
                <td width="55"  align="center" class="TableTitle1" ><strong>客户</strong></td>
                <td width="110"  align="center" class="TableTitle1" ><strong>联系电话</strong></td>
                <td width="140"  height="30" align="center" class="TableTitle1" ><strong>服务原因</strong></td>
                <td width="220"  align="center" class="TableTitle1" ><strong>服务项目</strong></td>
                <td width="50"  align="center" class="TableTitle1" ><strong>应收</strong></td>
                <td width="50"  align="center" class="TableTitle1" ><strong>实收</strong></td>
                <td width="50"  align="center" class="TableTitle1" ><strong>创收</strong></td>
                <td width="50"  align="center" class="TableTitle1" ><strong>单费</strong></td>
                <td width="45"  align="center" class="TableTitle1" ><strong>工程师</strong></td>
                <td width="80"  align="center" class="TableTitle1" ><strong>服务时间</strong></td>
                <td width="60"  align="center" class="TableTitle1" ><strong>客户评价</strong></td>
                <td width="30" align="center" class="TableTitle1" ><strong>删除</strong></td>
              </tr>
      <%
              If(rs_zong.Eof)Then
              %>
      <tr>
        <td height="120" colspan="9" align="center" class="TableRow2">对不起!没有找到你需要的报修记录!</td>
      </tr>
<!--#include file ="bottom.asp"-->
      <%
                Response.End()
                End If
                repeat_rows = 0
                While(repeat_rows < rs_zong.PageSize and Not rs_zong.Eof)
              %>





      <%baoxiu_id=rs_zong("baoxiu_id")%>
      <tr>

<%'报修时间-------------------------------------------------------------------------------------------------------- %>
      <td width="140" height="30" align="center"  class="TableRow2" ><a href="baoxiu_list.asp?baoxiu_id=<%=baoxiu_id%>"><font color="#0099FF"><%=rs_zong("baoxiu_date")%></font></a>
  
</td>

<%'报修姓名--------------------------------------------------------------------------------------------------------%>

<td width="65" height="30" align="center"  class="TableRow2" >
   <%
Response.Write("<a href='baoxiu_list.asp?baoxiu_id="&rs_zong("baoxiu_id")&"'>"&(rs_zong("user_name"))&"</a>")
%>
</td>


<%'报修电话--------------------------------------------------------------------------------------------------------%>
<td width="85" height="30" align="center"  class="TableRow2" >
      <%
Response.Write("<a href='baoxiu_list.asp?baoxiu_id="&rs_zong("baoxiu_id")&"'>"&(rs_zong("contact"))&"</a>")
%>
        </td>


<%'联系地址-------------------------------------------------------------------------------------------------------%>
<td width="140" height="30" align="left" class="TableRow2" >   
<%
                If(Len(rs_zong("baoxiu_yuanyin")) >7)Then
                Response.Write("<a href='baoxiu_list.asp?baoxiu_id="&rs_zong("baoxiu_id")&"'>"&(Mid(rs_zong("baoxiu_yuanyin"),1,7))&"…</a>")
                Else
                Response.Write("<a href='baoxiu_list.asp?baoxiu_id="&rs_zong("baoxiu_id")&"'>"&(rs_zong("baoxiu_yuanyin"))&"</a>")
                End If
                %>     
        
        </td>


<%'报修原因--------------------------------------------------------------------------------------------------------%>
        <td width="220" height="30" align="left" class="TableRow2" >
        
<%
                If(Len(rs_zong("weixiu_main")) > 13)Then
                Response.Write("<a href='baoxiu_list.asp?baoxiu_id="&rs_zong("baoxiu_id")&"'>"&(Mid(rs_zong("weixiu_main"),1,13))&"…</a>")
                Else
                Response.Write("<a href='baoxiu_list.asp?baoxiu_id="&rs_zong("baoxiu_id")&"'>"&(rs_zong("weixiu_main"))&"</a>")
                End If
                %>  


</td>


  
<%'应收-------------------------------------------------------------------------------------------------------%>

<td width="35"  align="center" class="TableRow2" ><a href="baoxiu_list.asp?baoxiu_id=<%=baoxiu_id%>" onMouseOver="drc('姓名:<%=rs_zong("user_name")%><br>电话:<%=rs_zong("contact")%><br>地址:<%=rs_zong("user_dizhi")%><br>原因:<%=rs_zong("baoxiu_yuanyin")%><br>现象:<%=rs_zong("guzhang")%><br>服务费:<%=rs_zong("user_feiyong")%><br>对策:<%=rs_zong("weixiu_main")%><br>实收费:<%=rs_zong("weixiu_feiyong")%><br>客户评价:<%=rs_zong("kehuyijian")%>','<%=rs_zong("paidan_name")%>的单子'); return true;" onMouseOut="nd(); return true;"><%=rs_zong("user_feiyong")%></a>
</td>
<%'应收--------------------------------------------------------------------------------------------------------%>

<td width="35"  align="center" class="TableRow2" ><a href="baoxiu_list.asp?baoxiu_id=<%=baoxiu_id%>" onMouseOver="drc('姓名:<%=rs_zong("user_name")%><br>电话:<%=rs_zong("contact")%><br>地址:<%=rs_zong("user_dizhi")%><br>原因:<%=rs_zong("baoxiu_yuanyin")%><br>现象:<%=rs_zong("guzhang")%><br>服务费:<%=rs_zong("user_feiyong")%><br>对策:<%=rs_zong("weixiu_main")%><br>实收费:<%=rs_zong("weixiu_feiyong")%><br>客户评价:<%=rs_zong("kehuyijian")%>','<%=rs_zong("paidan_name")%>的单子'); return true;" onMouseOut="nd(); return true;"><%=rs_zong("weixiu_feiyong")%></a>
</td>

<%'创收--------------------------------------------------------------------------------------------------------%>

 <td width="35"  align="center" class="TableRow2" ><a href="baoxiu_list.asp?baoxiu_id=<%=baoxiu_id%>" onMouseOver="drc('姓名:<%=rs_zong("user_name")%><br>电话:<%=rs_zong("contact")%><br>地址:<%=rs_zong("user_dizhi")%><br>原因:<%=rs_zong("baoxiu_yuanyin")%><br>现象:<%=rs_zong("guzhang")%><br>服务费:<%=rs_zong("user_feiyong")%><br>对策:<%=rs_zong("weixiu_main")%><br>实收费:<%=rs_zong("weixiu_feiyong")%><br>客户评价:<%=rs_zong("kehuyijian")%>','<%=rs_zong("paidan_name")%>的单子'); return true;" onMouseOut="nd(); return true;"><%=rs_zong("chuangshou")%></a>
</td>



<%'单费--------------------------------------------------------------------------------------------------------%>

 <td width="35"  align="center" class="TableRow2" ><a href="baoxiu_list.asp?baoxiu_id=<%=baoxiu_id%>" onMouseOver="drc('姓名:<%=rs_zong("user_name")%><br>电话:<%=rs_zong("contact")%><br>地址:<%=rs_zong("user_dizhi")%><br>原因:<%=rs_zong("baoxiu_yuanyin")%><br>现象:<%=rs_zong("guzhang")%><br>服务费:<%=rs_zong("user_feiyong")%><br>对策:<%=rs_zong("weixiu_main")%><br>实收费:<%=rs_zong("weixiu_feiyong")%><br>客户评价:<%=rs_zong("kehuyijian")%>','<%=rs_zong("paidan_name")%>的单子'); return true;" onMouseOut="nd(); return true;"><%=rs_zong("paodanfei")%></a>
</td>

<%'工程师姓名--------------------------------------------------------------------------------------------------------%>
      
        <td width="45"  align="center" class="TableRow2" ><a href="baoxiu_list.asp?baoxiu_id=<%=baoxiu_id%>" onMouseOver="drc('姓名:<%=rs_zong("user_name")%><br>电话:<%=rs_zong("contact")%><br>地址:<%=rs_zong("user_dizhi")%><br>原因:<%=rs_zong("baoxiu_yuanyin")%><br>现象:<%=rs_zong("guzhang")%><br>服务费:<%=rs_zong("user_feiyong")%><br>对策:<%=rs_zong("weixiu_main")%><br>实收费:<%=rs_zong("weixiu_feiyong")%><br>客户评价:<%=rs_zong("kehuyijian")%>','<%=rs_zong("paidan_name")%>的单子'); return true;" onMouseOut="nd(); return true;"><%=rs_zong("paidan_name")%></a>
</td>

        <td width="80" align="center"  class="TableRow2"><%if rs_zong("weixiu_zhuangtai")<>"" then%><a href="baoxiu_list.asp?baoxiu_id=<%=baoxiu_id%>"><%=rs_zong("weixiu_time")%><%else%><b>×</b><%end if%></td>
        
                
<td width="60" align="center"  class="TableRow2">
  <%if rs_zong("keping")="未联系上"  then%><a href="baoxiu_list.asp?baoxiu_id=<%=baoxiu_id%>"><font color="#000000"><%=rs_zong("keping")%></font><%else%><b></b>
  <%if rs_zong("keping")="投诉"  then%><a href="baoxiu_list.asp?baoxiu_id=<%=baoxiu_id%>"><font color="#009933"><%=rs_zong("keping")%></font><%else%><b></b>
  <%if rs_zong("keping")="非常不满" then%><a href="baoxiu_list.asp?baoxiu_id=<%=baoxiu_id%>"><font color="#0000FF"><%=rs_zong("keping")%></font><%else%><b></b>
  <%if rs_zong("keping")="不满意" then%><a href="baoxiu_list.asp?baoxiu_id=<%=baoxiu_id%>"><font color="#0000FF"><%=rs_zong("keping")%></font><%else%><b></b>
  <%if rs_zong("keping")="一般" then%><a href="baoxiu_list.asp?baoxiu_id=<%=baoxiu_id%>"><font color="#FF00FF"><%=rs_zong("keping")%></font><%else%><b></b>
  <%if rs_zong("keping")="比较满意" then%><a href="baoxiu_list.asp?baoxiu_id=<%=baoxiu_id%>"><font color="#FF0000"><%=rs_zong("keping")%></font><%else%><b></b>
  <%if rs_zong("keping")="非常满意" then%><a href="baoxiu_list.asp?baoxiu_id=<%=baoxiu_id%>"><font color="#FF0000"><%=rs_zong("keping")%></font><%else%><b></b>
  <%if rs_zong("keping")<>"" then%><a href="baoxiu_list.asp?baoxiu_id=<%=baoxiu_id%>"><font color="#FF0000"><%=rs_zong("keping")%></font><%else%><b>×</b>
  <%end if%>
  <%end if%>
  <%end if%>
  <%end if%>    
  <%end if%>
  <%end if%>
  <%end if%>    
  <%end if%>        
</td>                                  
                <td width="30" align="center"  class="TableRow2"><input name="BoxUser" type="checkbox" value="<%=rs_zong("baoxiu_id")%>"></td>
              </tr>
               <%
              repeat_rows = repeat_rows + 1
              rs_zong.MoveNext
              Wend
              %>
            </table>
            <table  width="100%"  border="0" cellspacing="0" cellpadding="0" align=center>
              <tr>
                <td height="8" colspan=5></td>
              </tr>
              <tr>
              <td><table width="98%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolorlight="#799AE1" bordercolordark="#ffffff">
                <tr>
                  <td><table  width="98%"  border="0" cellspacing="0" cellpadding="0" align=center>
                    <tr>
                      <td width="69%">[<font color=red><%=pagenozong%></font>/<%=rs_zong.pagecount%>] | [每页<font color=red><%=rs_zong.PageSize%></font>条] | [共<font color=red><%=rs_total%></font>条]&nbsp;
                        <%
                        if(pagenozong <> 1)then
                        %>
                          <a href="?condition=<%=getcondition%>&key=<%=getkey%>">第一页</a>
                          <%
                        end if
                        %>
                          <%
                        if(pagenozong <> 1)then
                        %>
                        &nbsp;<a href="?condition=<%=getcondition%>&key=<%=getkey%>&pagenozong=<%=(pagenozong-1)%>">上一页</a>&nbsp;
                        <%
                        end if
                        %>
                        <%
                        '这里要判断一下pageno和rs.pagecount的值相等的情况,如果不判断,当它俩的值相等时,pageno<>cstr(rs_zong.pagecount)还是true
                        if(instr(pagenozong,cstr(rs_zong.pagecount)) = 0)then
                        %>
                        <a href="?condition=<%=getcondition%>&key=<%=getkey%>&pagenozong=<%=(pagenozong+1)%>">下一页</a>
                        <%
                        end if
                        %>
                        <%
                        if(instr(pagenozong,cstr(rs_zong.pagecount)) = 0)then
                        %>
                        &nbsp;<a href="?condition=<%=getcondition%>&key=<%=getkey%>&pagenozong=<%=rs_zong.pagecount%>">最后一页</a>
                        <%
                        end if
                        rs_zong.close
                        set rs_zong = nothing
                        %></td>
                      <td width="3%"></td>
                      <td width="19%" align=right nowrap>[<a style="color:red;cursor:hand;" onClick="Check1(Del_baoxiu)">删除</a>]
                        <%'这里用这几个隐藏域是为了把显示这个页面所需的参数传递到删除页面,然后再由删除页面传回本页面。%>
                        <input type="hidden" name="condition2" value="<%=getcondition%>">
                        <input type="hidden" name="key" value="<%=getkey%>">
                        <input type="hidden" name="pageno" value="<%=getpageno%>"></td>
                        <input type="hidden" name="xingming" value="<%=request.form("paidan_name")%>">
<input type="hidden" name="date1" value="<%=request.form("baoxiu_date1")%>">
<input type="hidden" name="date2" value="<%=request.form("baoxiu_date2")%>">
                        
                        
                    
                        </td>
                      <td width="6%" align="right" nowrap>[全选/反选]</td>
                      <td width="3%" height="26" align=center nowrap><input type="checkbox" name="checkbox" onClick="CheckAll(this.form.BoxUser,this.form.checkbox)"></td>
                    </tr>
                  </table></td>
                </tr>
              </table>              </td>
              </tr>
            </table>
            
            </form>           </td>
        </tr>
      </table>
</table>
<!--#include file =bottom.asp-->
</body>

</html>
搜索更多相关主题的帖子: 分页问题 
2008-06-06 14:26
快速回复:按日期查询后的分页问题
数据加载中...
 
   



关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.027112 second(s), 8 queries.
Copyright©2004-2024, BCCN.NET, All Rights Reserved