LINQ自定义真分页(尚未添加多字段动态查询与多字段排序)

最新推荐文章于 2020-01-06 13:49:43 发布
最新推荐文章于 2020-01-06 13:49:43 发布
阅读量1.6k 收藏
点赞数
分类专栏： 新知实践 文章标签： linq textbox server asp object triggers
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/davidcoffee/article/details/6235375
版权

 

前台:

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="LinqCustomPager._Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <style type="text/css">
        tr td
        {
            font-size: small;
            font-family: @宋体;
            text-align: center;
            border-left: solid thin Black;
            border-right: solid thin Black;
            border-collapse: collapse;
        }
        .tr_title
        {
            font-weight: bold;
            border-left: solid thin Black;
            border-right: solid thin Black;
            border-top: solid thin Black;
            border-bottom: solid thin Black;
            border-collapse: collapse;
        }
        .tr_content
        {
            border-left: solid thin Black;
            border-right: solid thin Black;
            border-top: solid thin Black;
            border-bottom: solid thin Black;
            border-collapse: collapse;
        }
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <center>
        <div align="center">
            LINQ自定义真分页测试<asp:ScriptManager ID="ScriptManagerRepeater" runat="server">
            </asp:ScriptManager>
            &nbsp;
            <table width="1000px" style="border-color: Black; border-style: solid; border-width: thin;
                border-collapse: collapse">
                <tr>
                    <td colspan="10">
                        查询条件
                    </td>
                </tr>
                <tr class="tr_title">
                    <td style="width: 100px">
                        姓名
                    </td>
                    <td style="width: 100px">
                        <asp:TextBox ID="txtQueryName" runat="server"></asp:TextBox>
                    </td>
                    <td style="width: 100px">
                        公司
                    </td>
                    <td style="width: 100px">
                        <asp:TextBox ID="txtQueryCompany" runat="server"></asp:TextBox>
                    </td>
                    <td style="width: 100px">
                        职位
                    </td>
                    <td style="width: 100px">
                        <asp:TextBox ID="txtQueryJob" runat="server"></asp:TextBox>
                    </td>
                    <td style="width: 100px">
                        邮编
                    </td>
                    <td style="width: 100px">
                        <asp:TextBox ID="txtQueryZipcode" runat="server"></asp:TextBox>
                    </td>
                    <td colspan="2" style="width: 200px">
                        <asp:Button ID="btnQuery" runat="server" Text="查询" Font-Size="Small" BorderStyle="Solid"
                            OnClick="btnQuery_Click" />
                    </td>
                </tr>
            </table>
            <br />
            <asp:UpdatePanel ID="upGuideTeacher" runat="server" UpdateMode="Always">
                <ContentTemplate>
                    <table width="1000px" style="border-color: Black; border-style: solid; border-width: thin;
                        border-collapse: collapse">
                        <tr class="tr_title">
                            <td style="width: 30px">
                                序号
                            </td>
                            <td style="width: 30px">
                                类型
                            </td>
                            <td style="width: 50px">
                                姓名
                            </td>
                            <td style="width: 120px">
                                公司
                            </td>
                            <td style="width: 200px">
                                职位
                            </td>
                            <td style="width: 180px">
                                地址
                            </td>
                            <td style="width: 60px">
                                邮编
                            </td>
                            <td style="width: 80px">
                                联系电话
                            </td>
                            <td style="width: 80px">
                                联系手机
                            </td>
                            <td style="width: 170px">
                                邮箱
                            </td>
                        </tr>
                        <asp:Repeater ID="rpGuideTeacher" runat="server">
                            <ItemTemplate>
                                <tr class="tr_content">
                                    <td>
                                        <%#Container.ItemIndex + 1 %>
                                    </td>
                                    <td>
                                        <%#Eval("GuideTeacherType")%>
                                    </td>
                                    <td>
                                        <%#Eval("GuideTeacherName")%>
                                    </td>
                                    <td>
                                        <%#Eval("GuideTeacherCompany")%>
                                    </td>
                                    <td>
                                        <%#Eval("GuideTeacherJob")%>
                                    </td>
                                    <td>
                                        <%#Eval("GuideTeacherAddress")%>
                                    </td>
                                    <td>
                                        <%#Eval("GuideTeacharZipCode")%>
                                    </td>
                                    <td>
                                        <%#Eval("GuideTeacherPhone")%>
                                    </td>
                                    <td>
                                        <%#Eval("GuideTeacherMobile")%>
                                    </td>
                                    <td>
                                        <%#Eval("GuideTeacherEmail")%>
                                    </td>
                                </tr>
                            </ItemTemplate>
                        </asp:Repeater>
                    </table>
                    <div style="font-size: small" align="center">
                        共<asp:Label ID="lblTotalPageCount" runat="server" ForeColor="Red"></asp:Label>页&nbsp;当前第<asp:Label
                            ID="lblCurrentPage" runat="server" ForeColor="Red"></asp:Label>页&nbsp;共<asp:Label
                                ID="lblTotalRecordCount" runat="server" ForeColor="Red"></asp:Label>条记录&nbsp;<asp:LinkButton
                                    ID="lkbtnFirst" runat="server" Text="首页" OnClick="lkbtnFirst_Click"></asp:LinkButton>&nbsp;<asp:LinkButton
                                        ID="lkbtnPrev" runat="server" Text="上一页" OnClick="lkbtnPrev_Click"></asp:LinkButton>&nbsp;
                        <asp:LinkButton ID="lkbtnNext" runat="server" Text="下一页" OnClick="lkbtnNext_Click"></asp:LinkButton>&nbsp;<asp:LinkButton
                            ID="lkbtnLast" runat="server" Text="尾页" OnClick="lkbtnLast_Click"></asp:LinkButton>&nbsp;每页显示<asp:DropDownList
                                ID="ddlPageSize" runat="server" OnSelectedIndexChanged="ddlPageSize_SelectedIndexChanged"
                                AutoPostBack="true">
                            </asp:DropDownList>
                        条&nbsp;转跳至第<asp:DropDownList ID="ddlGo" runat="server" OnSelectedIndexChanged="ddlGo_SelectedIndexChanged"
                            AutoPostBack="true">
                        </asp:DropDownList>
                        页</div>
                </ContentTemplate>
                <Triggers>
                    <asp:AsyncPostBackTrigger ControlID="lkbtnFirst" EventName="Click" />
                    <asp:AsyncPostBackTrigger ControlID="lkbtnPrev" EventName="Click" />
                    <asp:AsyncPostBackTrigger ControlID="lkbtnNext" EventName="Click" />
                    <asp:AsyncPostBackTrigger ControlID="lkbtnLast" EventName="Click" />
                    <asp:AsyncPostBackTrigger ControlID="ddlPageSize" EventName="SelectedIndexChanged" />
                    <asp:AsyncPostBackTrigger ControlID="ddlGo" EventName="SelectedIndexChanged" />
                </Triggers>
            </asp:UpdatePanel>
        </div>
    </center>
    </form>
</body>
</html>

 

 


后台:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace LinqCustomPager
{
    public partial class _Default : System.Web.UI.Page
    {
        private int pageIndex = 1;
        private int pageSize = 10;

        /// <summary>
        /// 选取需要显示的分页数
        /// </summary>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        private int GuideTeacherDataBind(int pageIndex, int pageSize)
        {
            DavidContextDataContext davidcontext = new DavidContextDataContext();
            int totalCount = davidcontext.BIGuideTeacher.Count();
            int pageCount = totalCount % pageSize == 0 ? (totalCount / pageSize) : ((totalCount / pageSize) + 1);
            pageIndex = pageIndex <= pageCount ? pageIndex : 1;//防止在10条情况下选中11页在选50条情况
            var items = davidcontext.BIGuideTeacher.Skip((pageIndex - 1) * pageSize).Take(pageSize);
            lblTotalPageCount.Text = pageCount.ToString();
            lblCurrentPage.Text = pageIndex.ToString();
            lblTotalRecordCount.Text = totalCount.ToString();

            //绑定每页条数
            ddlPageSize.Items.Clear();
            ddlPageSize.SelectedValue = pageSize.ToString();
            for (int i = 10; i <= 50; i = i + 10)
            {
                ddlPageSize.Items.Add(new ListItem(i.ToString(), i.ToString()));
            }
            ddlPageSize.DataBind();

            //绑定对应页数
            ddlGo.Items.Clear();
            ddlGo.SelectedValue = pageIndex <= pageCount ? pageIndex.ToString() : "1";
            for (int i = 1; i <= pageCount; i++)
            {
                ddlGo.Items.Add(new ListItem(i.ToString(), i.ToString()));
            }
            ddlGo.DataBind();

            lkbtnFirst.Enabled = lkbtnPrev.Enabled = lkbtnNext.Enabled = lkbtnLast.Enabled = true;
            if (lblCurrentPage.Text == "1")
            {
                lkbtnFirst.Enabled = lkbtnPrev.Enabled = false;
            }
            else if (lblCurrentPage.Text == pageCount.ToString())
            {
                lkbtnNext.Enabled = lkbtnLast.Enabled = false;
            }
            rpGuideTeacher.DataSource = items;
            rpGuideTeacher.DataBind();
            return pageCount;
        }
  
  //首页
        protected void lkbtnFirst_Click(object sender, EventArgs e)
        {
            pageSize = int.Parse(ddlPageSize.SelectedValue);
            GuideTeacherDataBind(1, pageSize);
        }
  //上一页
        protected void lkbtnPrev_Click(object sender, EventArgs e)
        {
            pageSize = int.Parse(ddlPageSize.SelectedValue);
            int currentPageIndex = int.Parse(lblCurrentPage.Text) - 1;
            GuideTeacherDataBind(currentPageIndex, pageSize);
        }
  //下一页
        protected void lkbtnNext_Click(object sender, EventArgs e)
        {
            pageSize = int.Parse(ddlPageSize.SelectedValue);
            int currentPageIndex = int.Parse(lblCurrentPage.Text) + 1;
            GuideTeacherDataBind(currentPageIndex, pageSize);
        }
  //尾页
        protected void lkbtnLast_Click(object sender, EventArgs e)
        {
            pageSize = int.Parse(ddlPageSize.SelectedValue);
            int pageCount = GuideTeacherDataBind(1, pageSize);
            GuideTeacherDataBind(pageCount, pageSize);
        }
        //转跳至XX页
        protected void ddlGo_SelectedIndexChanged(object sender, EventArgs e)
        {
            pageIndex = int.Parse(ddlGo.SelectedValue);
            pageSize = int.Parse(ddlPageSize.SelectedValue);
            GuideTeacherDataBind(pageIndex, pageSize);
        }
  //每页显示XX条
        protected void ddlPageSize_SelectedIndexChanged(object sender, EventArgs e)
        {
            pageIndex = int.Parse(ddlGo.SelectedValue);
            pageSize = int.Parse(ddlPageSize.SelectedValue);
            GuideTeacherDataBind(pageIndex, pageSize);
        }
    }
}

小弟初稿~LINQ自定义真分页~求改进求指导~准备改到用户控件中做成一个分页控件~有高手能给下思路否~

davidcoffee
关注
专栏目录
LINQ根据某个字段的特定值排序
weixin_39730950的博客
02-23 1080
LINQ根据某个字段的特定值排序 今天遇到一个要List要把某一个字段特定的一个值排到最后面的需求。 List<Ad> ads = new List<Ad>(); ads.Add(new Ad() { a1 = "a" }); ads.Add(new Ad() { a1 = "b" }); ads.Add(new Ad() { a1 = "c" }); ads.Add(new Ad()
C# Linq查询、where 扩展查询以及QueryExpression分页查询
m0_70735467的博客
08-11 825
C# 常用的三种查询方式
Linq to SQL: 自定义排序
KingCruel的专栏
01-13 3809
某些时候我们需要按照某个特定的序列来完成结果排序，比如说按in条件中的Id顺序返回文章。 比如按此顺序排序：1,5,2,6,3,7,4,9 SQL语句如下： select * from pdt_Music where MusicID in(1,2,3,4,5,6,7,8,9) order by CHARINDEX(RTRIM(CAST(MusicID as NCHAR)),'5,2,8,
动态创建分页 LINQ+EF
weixin_38166931的博客
07-18 54
public class Message { public int MessageId { get; set; } public string MessageTitle { get; set; } public string MessageContent { get; set; } pu...
C# List OrderBy 动态多字段排序
07-01
C# 使用orderby 多字段 动态排序
LINQ 按多个字段排序
小小的花园里面挖呀挖呀～
07-15 7000
LINQ 按多个字段排序（orderby、thenby、Take）   orderby  子句解析为 OrderBy()方法，orderby descending 子句解析为OrderBy Descending()方法： var racers = Formula1.GetChampions(). Where(r = > r.Country == "Brazil"). OrderB
asp.net Linq TO Sql 分页方法
01-20
ASP.NET LINQ to SQL 是一种强大的数据访问...总的来说，ASP.NET LINQ to SQL的分页方法结合了强类型查询和服务器端分页，为Web应用提供了高效且灵活的数据展示方式。在实际项目中，可以根据需求进行相应的调整和优化。
LINQ To SQL实现分页效果源码
12-30
5. **优化性能**：在某些情况下，为了提高性能，你可能需要在查询中添加`OrderBy()`或`OrderByDescending()`，这将确保分页是基于特定字段排序的。如果不指定，数据库可能会返回不确定的结果。 6. **考虑效率**：...
EF框架实现增删查改以及数据分页和排序.rar
11-16
在这个"EF框架实现增删查改以及数据分页和排序.rar"的资源中，我们将深入探讨如何利用EF进行数据操作，并实现数据的分页与排序功能。 首先，EF的核心概念是实体（Entity）和上下文（DbContext）。实体是对数据库表...
LINQ使用Orderby、ThenBy实现多字段的排序
热门推荐
pan_junbiao的博客
11-06 2万+
LINQ中的排序操作符，包括：OrderBy、OrderByDescending、ThenBy、ThenByDescending、Reverse，提供了升序或者降序排序。 OrderBy：按升序对序列的元素进行排序。 OrderByDescending：按降序对序列的元素排序。 ThenBy：按升序对序列中的元素执行后续排序。 ThenByDescending：按降序对序列中的元素执行后续排序。 ...
linq 排序的字段和方式是动态时
zhang_wei_的博客
01-06 247
直接使用 var orderList = from letter in letterListF orderby letter.GetType().GetProperty(sortCoulmn).GetValue(letter) descending select letter; 这里注意还要GetValue
LINQ 按多个字段排序（orderby、thenby、Take）
软件研发实战应用技术分享
04-10 1万+
LINQ 按多个字段排序（orderby、thenby、Take；orderby  子句解析为 OrderBy()方法，orderby descending 子句解析为OrderBy Descending()方法：var racers = Formula1.GetChampions().Where(r = > r.Country == "Brazil").OrderByDescending(r = > r.Wins).Select(r = > r);
让Linq的OrderBy支持动态字段
weixin_33962923的博客
09-14 335
使用linq的OrderBy，如果明确知道是哪个字段，当然很容易： IQueryable<User> userQuery = ...; userQuery.OrderBy(u => u.Code) 但假如我们想写一个通用方法，预先并不知道要用哪个字段排序呢？ 在网上寻寻觅觅，有许多国内的博客互相抄袭，信誓旦旦，但其实那些代码都运行不了。 还是老外的...
ASP.NET MVC 实现分页、搜索与排序详细代码示例
2. 仓储实现：在`IUsersRepository`的`Find`方法中，根据传入的排序参数（order）调整SQL查询语句或Linq表达式，确保数据按指定方式排序。 四、前端展示 1. Bootstrap3 + jPaginate：使用Bootstrap3的样式库来美化...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值