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

最新推荐文章于 2025-05-27 08:00:00 发布
原创 最新推荐文章于 2025-05-27 08:00:00 发布 · 1.7k 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#linq #textbox #server #asp #object #triggers

本文介绍了一个使用LINQ实现的自定义分页功能，通过C#代码展示了如何进行数据分页展示，并包含了前端页面设计及后端逻辑处理。

 

前台:

<%@ 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自定义真分页~求改进求指导~准备改到用户控件中做成一个分页控件~有高手能给下思路否~

LINQ根据某个字段的特定值排序
weixin_39730950的博客
02-23 1194
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中的自定义排序
xk_hypothesis的博客
05-11 786
1.开发过程中，会遇到OrderBy/OrderByDescending排序无法满足的情况，此时就需要自定义排序，按照想要的排序规则取排序，比如订单的状态等等。
Linq to SQL: 自定义排序
KingCruel的专栏
01-13 3935
某些时候我们需要按照某个特定的序列来完成结果排序，比如说按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 排序的字段和方式是动态时
zhang_wei_的博客
01-06 285
直接使用 var orderList = from letter in letterListF orderby letter.GetType().GetProperty(sortCoulmn).GetValue(letter) descending select letter; 这里注意还要GetValue
动态创建分页 LINQ+EF
weixin_38166931的博客
07-18 89
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 多字段 动态排序
asp.net Linq TO Sql 分页方法
01-20
ASP.NET LINQ to SQL 是一种强大的数据访问...总的来说，ASP.NET LINQ to SQL的分页方法结合了强类型查询和服务器端分页，为Web应用提供了高效且灵活的数据展示方式。在实际项目中，可以根据需求进行相应的调整和优化。
动态LINQ：运行时构建查询的魔法
最新发布
冰茶的博客
05-27 2540
文章摘要 动态LINQ（Dynamic LINQ）是一种允许运行时构建LINQ查询的技术，通过字符串表达式实现灵活查询。核心优势包括：动态构建查询条件、简化复杂查询、提高代码可维护性。System.Linq.Dynamic.Core库为其提供支持，支持参数化查询、动态排序和字段选择。技术实现基于表达式树，可通过预编译提升性能。高级特性包括自定义类型提供、null传播操作符和动态创建数据类。动态LINQ特别适用于需根据用户输入或程序状态动态生成查询的场景，为开发提供更大灵活性。
LINQ多字段分组统计实现与源码解析
综上所述，该源码项目所涵盖的知识点远不止于表面的“group by多个字段”操作，而是深入触及了LINQ查询表达式的构建逻辑、匿名类型的运行时行为、数据库查询翻译机制（Query Translation）、内存与数据库端的计算...
LINQ demo: 联合查询，排序，分组查询
weixin_44279482的博客
04-30 215
Where, join on, join, OrderBy, GroupBy
LINQ 按多个字段排序
@
07-15 7199
LINQ 按多个字段排序（orderby、thenby、Take）   orderby  子句解析为 OrderBy()方法，orderby descending 子句解析为OrderBy Descending()方法： var racers = Formula1.GetChampions(). Where(r = > r.Country == "Brazil"). OrderB
LINQ使用Orderby、ThenBy实现多字段的排序
热门推荐
pan_junbiao的博客
11-06 2万+
LINQ中的排序操作符，包括：OrderBy、OrderByDescending、ThenBy、ThenByDescending、Reverse，提供了升序或者降序排序。 OrderBy：按升序对序列的元素进行排序。 OrderByDescending：按降序对序列的元素排序。 ThenBy：按升序对序列中的元素执行后续排序。 ThenByDescending：按降序对序列中的元素执行后续排序。 ...
C# linq order by 多字段排序
weixin_42193688的博客
04-21 2207
代码示例： var result = (from r in result1.Union(result2).Union(result3) orderby r.订单编号, r.myOrder, r.组件ID, r.部件名称,r.物料名称,r.物料色号 select r).ToList(); ...
Eval是什么
冯浩月
12-16 7640
前言    小编最近在进行一个制作网页版项目时，遇到了一个陌生的东东，在web窗体的源界面多次碰到&lt;%# Eval() %&gt;，小编对这个点非常好奇，特意在网上查找了相关的资料，并整理如下。   作用Eval   在网页版项目中的作用：   具体代码：   &lt;strong&gt; &lt;div id="category" class="commonfrm"&gt;...
让Linq的OrderBy支持动态字段
weixin_33962923的博客
09-14 392
使用linq的OrderBy，如果明确知道是哪个字段，当然很容易： IQueryable<User> userQuery = ...; userQuery.OrderBy(u => u.Code) 但假如我们想写一个通用方法，预先并不知道要用哪个字段排序呢？ 在网上寻寻觅觅，有许多国内的博客互相抄袭，信誓旦旦，但其实那些代码都运行不了。 还是老外的...
Linq查询分组排序（多表，多条件）
weixin_45106892的博客
10-25 1738
Linq查询，分组，多表，排序，分页 into 查询条件可能为空 类似于Left Join 第一个Select后面没有接对象。如果接了对象第二个select后就接不上对象。查询出来就是个IGrouping对象，可能与你自己定义的输出对象不一样，然后还要循环取出来在转换。在第二个地方接 就不需要在此转换。 很头大，第一次写这么长的Linq。 ...
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值