.NET分页+组合查询。一次读一页

wybshyy

于 2016-07-29 14:04:59 发布

阅读量764

点赞数

分类专栏： asp.net

本文链接：https://blog.csdn.net/wybshyy/article/details/52064344

版权

asp.net 专栏收录该内容

156 篇文章 1 订阅

订阅专栏

<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="Home_Index.ascx.cs" Inherits="Shualo.WEB.Home.Home_Index" %>

<%--中间内容--%>

<ul>

<%= strAT.ToString() %>

</ul>

</div>

<ul>

</ul>

</div>

</div>

$(".banner").hover(function () {

$(this).find(".prev,.next").stop(true, true).fadeTo("show", 0.5)

function () {

$(this).find(".prev,.next").fadeOut()

});

$(".banner").slide({

titCell: ".hd ul",

mainCell: ".bd ul",

effect: "fold",

autoPlay: true,

autoPage: true,

trigger: "click",

startFun: function (i) {

var curLi = jQuery(".banner .bd li").eq(i);

if (!!curLi.attr("_src")) {

curLi.css("background-image", curLi.attr("_src")).removeAttr("_src")

}

});

//验证用户登陆

$(function () {

$("#aLogin").click(function () {

$.ajax({

type: "Post",

url: "/Home/Home.aspx/Login",

data: { 'username': $("#Home_Index1_username").val(), 'userPWD': $("#userPWD").val(), 'action': 'Login', 'checked': $("#Remember_my").attr("checked"), 'Code': $("#Code").val() },

//contentType: "application/json; charset=utf-8",

//dataType: "json",

success: function (data) {

alert(data);

window.location.reload(true);

error: function (err) {

//alert(err);

}

});

//页面刷新并定位到当前高度

function refresh() {

window.location.reload(true);

window.scroll(0, document.body.scrollTop);

}

//搜索

function ListTask() {

var ddlSearch = $("#ddlSearch").val();

var keywords = $("#keywords").val();

var url = window.location.search;//获取地址栏所有参数

if (keywords != null && keywords.length > 0) {

//如果搜索时有其他筛选，则把其他筛选条件加进去，如果有搜索的值则替换

if (url.indexOf("?") != -1) {

//判断地址里是否已存在搜索参数，有则替换

if (url.indexOf("ddlSearch=taskNo&keywords=") != -1) {

var reg = new RegExp("(^|&)keywords=([^&]*)(&|$)");

var r = window.location.search.substr(1).match(reg);

if (r != null) {

//如果有此参数，则把此参数对应的值清空

url = url.replace("ddlSearch=taskNo&keywords=" + unescape(r[2]), "");

}

url += "&ddlSearch=" + ddlSearch + "&keywords=" + keywords;

} else {

url += "&ddlSearch=" + ddlSearch + "&keywords=" + keywords;

}

} else {

url = "/Home/Home.aspx?ddlSearch=" + ddlSearch + "&keywords=" + keywords;

}

else {

//判断地址里是否已存在搜索参数，有则清除

if (url.indexOf("ddlSearch=taskNo&keywords=") != -1) {

var reg = new RegExp("(^|&)keywords=([^&]*)(&|$)");

var r = window.location.search.substr(1).match(reg);

if (r != null) {

//如果有此参数，则把此参数对应的值清空

url = url.replace("ddlSearch=taskNo&keywords=" + unescape(r[2]), "");

}

//如果地址栏最后有&号，则清除(&占两个字符)

if (str.substr(-1) == "&") {

str = str.substr(0, str.length - 1);

}

if (url.indexOf("&&") != -1) {

url = url.replace("&&", "&");

}

if (url.indexOf("?&") != -1) {

url = url.replace("?&", "?");

}

window.location.href = url;

}

//组合筛选函数。传来的参数一个或两个，参数名1，参数值1，参数名2，参数值2

function GetQueryString(name, value, name1, value1) {

//$("#ulindexleft li").attr("class", "");//移除LI下所有的样式

//$("#" + liid + "").attr("class", "on");//选中的LI的样式设置为ON

//$("#limytaskjie").attr("class", "gray");//把我的任务区域还原成原来样式

//$("#limytaskfa").attr("class", "gray");//把我的任务区域还原成原来样式

//获取整个地址栏，查询到有重复的就删除，否则就新加进去

var url = window.location.search;

var str = "";//用来存放最新的地址

if (url.indexOf("?") != -1) {

str = url.substr(1);//获取地址栏参数

var reg = new RegExp("(^|&)" + name + "=([^&]*)(&|$)");

var r = window.location.search.substr(1).match(reg);

var strdizi;

if (r != null) {

//如果有此参数，则把此参数对应的值替换

str = str.replace(unescape(r[2]), value);

} else {

//没有此参数原地址栏不存在，且参数有实际值，则追加进去参数

if (name.length > 0) {

str += "&" + name + "=" + value;

}

var reg1 = new RegExp("(^|&)" + name1 + "=([^&]*)(&|$)");

var r1 = window.location.search.substr(1).match(reg1);

if (r1 != null) {

//如果有此参数，则把此参数对应的值替换

str = str.replace(unescape(r1[2]), value1);

} else {

//没有此参数原地址栏不存在，且参数有实际值，则追加进去参数

if (name1.length > 0) {

str += "&" + name1 + "=" + value1;

}

} else {//如果地址栏第一次传值

if (name != null & name.length > 0) {

str += name + "=" + value + "&";

}

if (name1 != null & name1.length > 0) {

str += name1 + "=" + value1 + "&";

}

if (str.substr(-1) == "&") {

str = str.substr(0, str.length - 1);

}

if (url.indexOf("&&") != -1) {

url = url.replace("&&", "&");

}

if (url.indexOf("?&") != -1) {

url = url.replace("?&", "?");

}

//alert("/Home/Home.aspx?" + str);

window.location.href = "/Home/Home.aspx?" + str;

}

//键盘回车事件

function textChanged(event) {

var keyCode = event.keyCode ? event.keyCode : event.which ? event.which : event.charCode;

if (keyCode == 13) {

document.getElementById("aLogin").click();

}

//我要接手，是否已登陆，是否自己的任务

$(function () {

$("#spTaskOver").click(function () {

$.ajax({

type: "Post",

url: "/Home/Home.aspx/spTaskOver",

data: { 'taskNo': $("#tdtaskNo").text(), 'action': 'spTaskOver' },

success: function (data) {

if (data == "success") {

alert("可以接手");

//window.location.href = "/Home/MyTaskIn.aspx";

} else {

alert(data);

}

error: function (err) {

alert(err);

}

});

</script>

</div>

<img src="/Frame/VerifyCode.ashx" id="Verify_codeImag" width="70" height="28" alt="点击切换验证码"

title="点击切换验证码" style="cursor: pointer; margin-left: -5px;" οnclick="ToggleCode(this.id, '/Frame/VerifyCode.ashx');return false;" /></span>

<%--<span>验证码：</span>

<%--<asp:Button ID="aLogin" CssClass="Login" Text="登录" runat="server" BorderStyle="None" OnClick="aLogin_Click" />--%>

<%--<span id="spanrememberme"> <input class="Remember_my" type="checkbox" checked="checked" runat="server" id="agree_userterm" name="auto_login">记住我</span>--%><a href="FindPWD.aspx">忘记密码？</a>

<div class="right"><a href="register.aspx">注册</a><a href="#">新用户？从这里开始</a></div>

</div>

<%--<li id="Li1" class="on" ><a href="#">我的任务</a></li>

<%--<li id="li1"><a style="cursor:pointer; text-decoration:none;" οnclick="GetQueryString('li1','strtaskArea','\'27d4277a-1d3c-431a-9cdf-f799f67f425c\'','','')">淘宝任务区</a></li>

<li><a href="Home.aspx?strtaskArea=<%= strLoginName %>">来路流量区</a></li>

<li><a href="Home.aspx?strtaskArea=">收藏互动区</a></li>

<li><a href="Home.aspx?strtaskArea=">推广任务区</a></li>

<li id="li2"><a style="cursor:pointer; text-decoration:none;" οnclick="GetQueryString('li2','strtaskArea','\'e7251c54-afa7-4e46-8d0c-dd6f4a39a8ed\'','','')">拍拍任务区</a></li>

<li><a style="cursor:pointer; text-decoration:none;" οnclick="GetQueryString('strtaskArea','\'6c7a762d-c64b-4b5c-9e45-c8f308d2ee20\'','','')">阿里巴巴任务区</a></li>

--%>

<%= strleftTask.ToString() %>

</ul>

</div>

</div>

</select>

</div>

<div class="search_right fr"><a href="#"><span class="ser_01"></span><span>任务预定</span></a><a href="#"><span class="ser_02"></span><span οnclick="GetQueryString('memberType','vip','','')">VIP任务</span></a><a οnclick="refresh()"><span class="ser_03"></span><span>刷新</span></a></div>

</div>

<asp:Repeater ID="rpIndexTaskList" runat="server">

<tr>

<td class="fn_01" width="80">发布人类型：</td>

<%# new Shualo.Business.Member_level_infoBLL().GetEntity(new Shualo.Business.Member_InfoBLL().GetEntity(Eval("memberId").ToString()).levelId).levelName.ToString()=="VIP会员"?"<img src='/Home/images/vpi.jpg' />":"" %>

<%# new Shualo.Business.BPMS_ItemDetailsBLL().GetEntity(new Shualo.Business.Member_InfoBLL().GetEntity(Eval("memberId").ToString()).trustTypeItemId.ToString()).ItemName.ToString()=="未加入"?"":"<img src='/Home/images/jiangpai.gif' />信托卡" %>

</span></td>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

</table>

</ItemTemplate>

</asp:Repeater>

<asp:Literal ID="Literal1" runat="server"></asp:Literal>

</div>

<%--页面右部--%>

<%= index_memberinfoArea %>

</div>

<ul>

<%= strnotice.ToString() %>

</ul>

</div>

<li class="active">本周接手王</li>

<li>本周发布王</li>

</ul>

<ul>

<%= strjietask.ToString() %>

</ul>

</div>

<ul>

<%= strfatask.ToString() %>

</ul>

</div>

$(function () {

$('.tab ul.menu li').click(function () {

//获得当前被点击的元素索引值

var Index = $(this).index();

//给菜单添加选择样式

$(this).addClass('active').siblings().removeClass('active');

//显示对应的div

$('.tab').children('div').eq(Index).show().siblings('div').hide();

});

$(function () {

$('.king_tab ul.menu li').click(function () {

//获得当前被点击的元素索引值

var Index = $(this).index();

//给菜单添加选择样式

$(this).addClass('active').siblings().removeClass('active');

//显示对应的div

$('.king_tab').children('div').eq(Index).show().siblings('div').hide();

});

$(function () {

$('.test_tab ul.menu li').click(function () {

//获得当前被点击的元素索引值

var Index = $(this).index();

//给菜单添加选择样式

$(this).addClass('active').siblings().removeClass('active');

//显示对应的div

$('.test_tab').children('div').eq(Index).show().siblings('div').hide();

});

</script>

</ul>

<ul>

<%= strhelp.ToString() %>

</ul>

</div>

<ul>

<%= strskill.ToString() %>

</ul>

</div>

</ul>

<ul>

<%= strsell.ToString() %>

</ul>

</div>

<ul>

<%= strsshoping.ToString() %>

</ul>

</div>

<ul>

<%= strtask.ToString() %>

</ul>

</div>

public string strLoginName = string.Empty;

public string index_memberinfoArea = string.Empty;

//private int sid;//备用类别ID

const int intPageSize = 1;//定义每页显示记录

int intPage;

public string strshowAlltaskask;//显示全部任务要求

public string strshowPage;//是否隐藏页码

public string ddlSearch;//搜索下拉框的条件字段（数据库的字段名）

public string keywords;//搜索的关键字

public string priceMin;//筛选任务最低价格

public string priceMax;//筛选任务最高价格

public string praiseTime;//筛选好评时限

public string memberType;//筛选VIP任务

public string strtaskArea;//左部菜单筛选任务区

public string strlefttaskArea;//左部菜单筛选任务区

public string strMyTaskon = string.Empty;//左部菜单任务区_我的任务

public string strtaobaoon = string.Empty;//左部菜单任务区_淘宝

public string strpaipaion = string.Empty;//左部菜单任务区_拍拍

public string stralion = string.Empty;//左部菜单任务区_阿里

public string strintoon = string.Empty;//左部菜单任务区_来路

public string strhouseon = string.Empty;//左部菜单任务区_收藏

public string strtuion = string.Empty;//左部菜单任务区_推广

public StringBuilder sqlwhere=new StringBuilder() ;//获取列表时的动态查询条件

public StringBuilder strmember = new StringBuilder();

public string strloginArea = "block";//

public StringBuilder strleftTask = new StringBuilder();//任务左部菜单显示隐藏

protected void Page_Load(object sender, EventArgs e)

{

#region 组合查询值

//搜索时传来的值

if (Globals.GetArg("ddlSearch") != string.Empty)

{

ddlSearch = Globals.GetArg("ddlSearch");

}

if (Globals.GetArg("keywords") != string.Empty)

{

keywords = Globals.GetArg("keywords");

sqlwhere.Append(" and " + ddlSearch + " ='" + keywords + "'");

}

if (Globals.GetArg("priceMin") != string.Empty)

{

//最低和最高价格都有值时才新增价格筛选

priceMin = Globals.GetArg("priceMin");

if (Globals.GetArg("priceMax") != string.Empty)

{

priceMax = Globals.GetArg("priceMax");

sqlwhere.Append(" and price >= " + priceMin + " and price <= " + priceMax);

}

if (Globals.GetArg("praiseTime") != string.Empty)

{

praiseTime = Globals.GetArg("praiseTime");

sqlwhere.Append(" and praiseTimeItemId = " + praiseTime);

}

if (Globals.GetArg("strtaskArea") != string.Empty)

{

strtaskArea = Globals.GetArg("strtaskArea");

sqlwhere.Append(" and taskAreaItemId = " + strtaskArea);

}

if (Globals.GetArg("memberType") != string.Empty)

{

memberType = Globals.GetArg("memberType");

sqlwhere.Append(" and memberId in(select memberId from member_info where isVip=1 ) ");

}

#endregion

#region 页码数

if (Request.Params["page"] == null)

{

intPage = 1;

rpIndexTaskList.DataSource = new task_listBLL().GetNumberCont(sqlwhere.ToString() + " and memberIdOver is null order by carateTime desc ", intPageSize);

rpIndexTaskList.DataBind();

if (RecordCount() != 0)

{

Literal1.Text = pagination(RecordCount(), intPageSize, intPage, Request.RawUrl.IndexOf("=") > 0 ? Request.RawUrl+"&" : Request.RawUrl+"?");

}

else

{

intPage = Int32.Parse(Request.Params["page"].ToString());

PageDataBind();

if (RecordCount() != 0)

{

string str1 = Request.RawUrl;

string str2 = "page=" + intPage.ToString();

string str3="";//存放过虑后的参数，过虑掉page=?

if (str1.IndexOf(str2 + "&") > 0)

{

str3=str1.Replace(str2 + "&", "")+"&";

}

else if (str1.IndexOf(str2) > 0)

{

str3=str1.Replace(str2, "");

}

Literal1.Text = pagination(RecordCount(), intPageSize, intPage, str3);

}

#endregion

#region Cookie记住的用户名

HttpCookie GetCookieUsersName = Request.Cookies["Login_UsersName"];

if (GetCookieUsersName != null && !string.IsNullOrEmpty(GetCookieUsersName.Value))

{

username.Value = GetCookieUsersName.Value;

}

#endregion

if (!IsPostBack)

{

}

#region 用户信息

private void GetUserInfo()

{

//用户信息

if (Session["index_memberinfo"] != null)

{

strMyTaskon = "on";

strloginArea = "none";//隐藏登陆区域

Member_Info u = (Member_Info)Session["index_memberinfo"];

//Page.ClientScript.RegisterStartupScript(Page.GetType(), "myscript", "<script>logingoto();</script>");

strLoginName = u.memberName.ToString();//存放用户ID

if (Session["index_memberinfoArea"] != null)

{

index_memberinfoArea = Session["index_memberinfoArea"].ToString();//显示用户信息区域

}

#region 任务左部菜单显示隐藏已登陆

strleftTask.Append("<li class='" + strMyTaskon + "' ><a>我的任务</a></li>");

strleftTask.Append("<li class='gray'><a href='MyTaskIn.aspx'>已接任务 </a></li>");

strleftTask.Append("<li class='gray'><a href='MyTaskOut.aspx'>已发任务</a></li>");

strleftTask.Append("<li class='" + strtaobaoon + "' ><a style='cursor:pointer; text-decoration:none;' οnclick=\"GetQueryString('strtaskArea',\'\\'27d4277a-1d3c-431a-9cdf-f799f67f425c\\\'','','')\">淘宝任务区</a></li>\n");

strleftTask.Append("<li class='" + strintoon + "'><a href='Home.aspx?strtaskArea='>来路流量区</a></li>\n");

strleftTask.Append("<li class='" + strhouseon + "'><a href='Home.aspx?strtaskArea='>收藏互动区</a></li>\n");

strleftTask.Append("<li class='" + strtuion + "'><a href='Home.aspx?strtaskArea='>推广任务区</a></li>\n");

strleftTask.Append("<li class='" + strpaipaion + "'><a style='cursor:pointer; text-decoration:none;' οnclick=\"GetQueryString('strtaskArea',\'\\'e7251c54-afa7-4e46-8d0c-dd6f4a39a8ed\\\'','','')\">拍拍任务区</a></li>\n");

strleftTask.Append("<li class='" + stralion + "'><a style='cursor:pointer; text-decoration:none;' οnclick=\"GetQueryString('strtaskArea',\'\\'6c7a762d-c64b-4b5c-9e45-c8f308d2ee20\\\'','','')\">阿里巴巴任务区</a></li>\n");

strleftTask.Append("");

#endregion

}

else

{

#region 任务左部菜单显示隐藏未登陆

strleftTask.Append("<li class='" + strintoon + "'><a href='Home.aspx?strtaskArea='>来路流量区</a></li>\n");

strleftTask.Append("<li class='" + strhouseon + "'><a href='Home.aspx?strtaskArea='>收藏互动区</a></li>\n");

strleftTask.Append("<li class='" + strtuion + "'><a href='Home.aspx?strtaskArea='>推广任务区</a></li>\n");

strleftTask.Append("");

#endregion

}

#endregion

#region 绑定显示数据

public void PageDataBind()

{

if (intPage <= 1)

{

rpIndexTaskList.DataSource = new task_listBLL().GetNumberCont(sqlwhere.ToString() + " and memberIdOver is null order by carateTime desc ", intPageSize);

rpIndexTaskList.DataBind();

}

else

{

rpIndexTaskList.DataSource = new task_listBLL().GetNumberCont(sqlwhere.ToString() + " and memberIdOver is null and (taskId not in(select top " + intPageSize * (intPage - 1) + " taskId from task_list where memberIdOver is null order by carateTime desc) ) order by carateTime desc ", intPageSize);

rpIndexTaskList.DataBind();

}

#endregion

#region 计算总记录数

public int RecordCount()

{

int count = new task_listBLL().GetListWhere(sqlwhere.ToString()).Count;

if (count > 0)

{

strshowPage = "none";

}

else

{

strshowPage = "block";

}

return count;

}

#endregion

#region 回传页码值

/// <param name="total">总记录数</param>

/// <param name="per">每页记录数</param>

/// <param name="page">当前页数</param>

/// <param name="query_string">Url参数</param>

public static string pagination(int total, int per, int page, string query_string)

{

int allpage = 0;

int next = 0;

int pre = 0;

int startcount = 0;

int endcount = 0;

string pagestr = "";

if (page < 1) { page = 1; }

//计算总页数

if (per != 0)

{

allpage = (total / per);

allpage = ((total % per) != 0 ? allpage + 1 : allpage);

allpage = (allpage == 0 ? 1 : allpage);

}

next = page + 1;

pre = page - 1;

startcount = (page + 5) > allpage ? allpage - 9 : page - 4;//中间页起始序号

//中间页终止序号

endcount = page < 5 ? 10 : page + 5;

if (startcount < 1) { startcount = 1; } //为了避免输出的时候产生负数，设置如果小于1就从序号1开始

if (allpage < endcount) { endcount = allpage; }//页码+5的可能性就会产生最终输出序号大于总页码，那么就要将其控制在页码数之内

//pagestr = "共" + allpage + "页      ";

pagestr = "";

pagestr += page > 1 && allpage > 1 ? "<div style='float:left; width:40px; height:30px; line-height:30px; background-color:#ccc; text-align:center;vertical-align:middle;'><a href=\"" + query_string + "page=1\">首页</a></div><div style='float:left; width:60px; height:30px; line-height:30px; background-color:#ccc; text-align:center;vertical-align:middle;'><a href=\"" + query_string + "page=" + pre + "\">上一页</a></div>" : "<div style='float:left; width:40px; height:30px; line-height:30px; background-color:#ccc; text-align:center;vertical-align:middle;'>首页</div><div style='float:left; width:60px; height:30px; line-height:30px; background-color:#ccc; text-align:center;vertical-align:middle;'>上一页</div>";

//中间页处理，这个增加时间复杂度，减小空间复杂度

for (int i = startcount; i <= endcount; i++)

{

pagestr += page == i ? "<div style='float:left; width:20px; height:30px; line-height:30px; background-color:#ccc; text-align:center;vertical-align:middle;'><font color=\"#ff0000\">" + i + "</font></div>" : "<div style='float:left; width:20px; height:30px; line-height:30px; background-color:#ccc; text-align:center;vertical-align:middle;'><a href=\"" + query_string + "page=" + i + "\">" + i + "</a></div>";

}

pagestr += page < allpage ? "<div style='float:left; width:60px; height:30px; line-height:30px; background-color:#ccc; text-align:center;vertical-align:middle;'><a href=\"" + query_string + "page=" + next + "\">下一页</a></div><div style='float:left; width:40px; height:30px; line-height:30px; background-color:#ccc; text-align:center;vertical-align:middle;'><a href=\"" + query_string + "page=" + allpage + "\">尾页</a></div>" : " <div style='float:left; width:60px; height:30px; line-height:30px; background-color:#ccc; text-align:center;vertical-align:middle;'>下一页</div><div style='float:left; width:40px; height:30px; line-height:30px; background-color:#ccc; text-align:center;vertical-align:middle;'>尾页</div>";

pagestr += "";

return pagestr;

}

#endregion

wybshyy

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
.NET分页+组合查询。一次读一页

$(".banner").hover(function () { $(this).find(".prev,.next").stop(true, true).fadeTo("show", 0.5) }, function () { $(this).find(".prev,.next").fadeOut() });
复制链接

扫一扫