国产一级a片免费看高清,亚洲熟女中文字幕在线视频,黄三级高清在线播放,免费黄色视频在线看

打開APP
userphoto
未登錄

開通VIP，暢享免費(fèi)電子書等14項超值服

開通VIP

首頁

好書

留言交流

下載APP

聯(lián)系客服
存儲過程分頁
前臺
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="MyProPage.aspx.cs" Inherits="MyProPage" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "<html xmlns="<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <table width="100%" border="0" cellpadding="0" cellspacing="0" align="center">
            <tr>
                <td width="100%">
                    <asp:GridView ID="GridViewItems" runat="server" AutoGenerateColumns="False" border="0"
                        CellPadding="0" ShowFooter="True" UseAccessibleHeader="False" GridLines="None"
                        ForeColor="#333333" PageSize="1000" OnRowDataBound="GridViewItems_RowDataBound">
                        <Columns>
                            <asp:TemplateField HeaderText="選擇" FooterText="選擇">
                                <ItemStyle HorizontalAlign="Center" />
                                <ItemTemplate>
                                    <input type="checkbox" name="checkme" value='<%# Eval("Id")%>' />
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="ID" FooterText="Id">
                                <ItemTemplate>
                                    <%# Eval("Id")%>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="名稱" FooterText="名稱">
                                <ItemTemplate>
                                    <%# Eval("Titles")%>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="分類" FooterText="分類">
                                <ItemTemplate>
                                    <%# Eval("CategoryName")%>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="充許評論" FooterText="充許評論">
                                <ItemTemplate>
                                    <asp:LinkButton ID="btnAllowComment" runat="server" CommandName="Comment" CommandArgument='<%# Eval("Id") %>'></asp:LinkButton>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="推薦" FooterText="推薦">
                                <ItemTemplate>
                                    <asp:LinkButton ID="btnCommend" runat="server" CommandName="Commend" CommandArgument='<%# Eval("Id") %>'></asp:LinkButton>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="顯示" FooterText="顯示">
                                <ItemTemplate>
                                    <asp:LinkButton ID="btnState" runat="server" CommandName="State" CommandArgument='<%# Eval("Id") %>'></asp:LinkButton>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="訪問數(shù)" FooterText="訪問數(shù)">
                                <ItemTemplate>
                                    <%# Eval("Visits")%>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="評論數(shù)" FooterText="評論數(shù)">
                                <ItemTemplate>
                                    <%# Eval("Comments")%>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="頂貼數(shù)" FooterText="頂貼數(shù)">
                                <ItemTemplate>
                                    <%# Eval("Support")%>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="文件名" FooterText="文件名">
                                <ItemTemplate>
                                    <%# Eval("FileName")%>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="操作" FooterText="操作">
                                <ItemTemplate>
                                    <a href="?action=edit&i=<%# Eval("id") %>">修改</a><asp:LinkButton ID="btnDel" runat="server"
                                        CommandName="Del" CommandArgument='<%# Eval("id") %>'> <span onclick="return confirm('確定刪除該信息嗎？\n\n刪除后無法恢復(fù)！');">刪除</span></asp:LinkButton>
                                    <asp:HiddenField ID="HiPicture" runat="server" Value='<%# Eval("Pictures")%> ' />
                                </ItemTemplate>
                            </asp:TemplateField>
                        </Columns>
                        <FooterStyle BackColor="" Font-Bold="True" ForeColor="White" />
                        <RowStyle BackColor="#F6F6F6" />
                        <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
                        <HeaderStyle BackColor="" Font-Bold="True" ForeColor="White" />
                        <AlternatingRowStyle BackColor="White" />
                    </asp:GridView>
                </td>
            </tr>
            <tr>
                <td width="100%"><% PageView();%></td>
            </tr>
        </table>
    </div>
    </form>
</body>
</html>
public partial class MyProPage : System.Web.UI.Page
{
    MyPagination pagina = null;
    int CurPage = 0;
    int PageSize = 10;
    protected void Page_Load(object sender, EventArgs e)
    {
      
        if(!IsPostBack)
        {
            GVBind();
        }
    }
    public void GVBind()
    {
        if (Request["page"] != null)
            CurPage = Convert.ToInt32(Request["page"].ToString());
        if (Request["PageSize"] != null)
            PageSize = Convert.ToInt32(Request["PageSize"].ToString());
        if (CurPage < 1) CurPage = 1;
        //--
        int num = Convert.ToInt32(SqlHelper.ExecuteScalar(CommandType.Text, "select count(*) from D_Information", new SqlParameter()).ToString());
        pagina = new MyPagination();
        pagina.Count = num;
        pagina.TableName = "D_Information";
        pagina.PageIndex = CurPage;
        pagina.PageSize = PageSize;
        DataSet ds = SqlHelper.ExecuteDataSet(System.Data.CommandType.StoredProcedure, "GetMyrecordFromPage", pagina.GetParam());
        GridViewItems.DataSource = ds.Tables[0];
        GridViewItems.DataBind();
    }
    protected void GridViewItems_RowDataBound(object sender, GridViewRowEventArgs e)
    {
      
    }
    /// <summary>
        /// 顯示分頁
        /// </summary>
    public void PageView()
    {
        Response.Write(pagina.ChinesePage());
    }
    //protected int _curpage = 1;
    //protected int _pagecount = 0;
    //protected int _pagesize = 10;
    //protected int _totalcount = 0;
    //// Methods
    //public string ChinesePage()
    //{
    //    string str = DelUrlPara("page");
    //    StringBuilder builder = new StringBuilder();
    //    int num = 0;
    //    int num2 = 0;
    //    if ((this._pagecount <= 10) || (this._curpage <= 3))
    //    {
    //        num = 1;
    //        num2 = (10 > this._pagecount) ? this._pagecount : 10;
    //    }
    //    else if ((this._pagecount - this._curpage) <= 7)
    //    {
    //        num = this._pagecount - 9;
    //        num2 = this._pagecount;
    //    }
    //    else
    //    {
    //        num = this._curpage - 2;
    //        num2 = this._curpage + 7;
    //    }
    //    builder.Append(string.Concat(new object[] { "<span class=\"pagenav\">共:", this._totalcount, "條 ", this._pagesize, "條/頁 ", this._pagecount, "頁/<font color=red>", this._curpage, "頁</font> </span>" }));
    //    if (this._curpage > 1)
    //    {
    //        builder.Append(string.Concat(new object[] { "<a href=\"", str, "page=1\" title=\"首頁\"><<</a> <a href=\"", str, "page=", this._curpage - 1, "\" title=\"上一頁\"><</a> " }));
    //    }
    //    for (int i = num; i <= num2; i++)
    //    {
    //        builder.Append((this._curpage == i) ? ("<a class=\"curr\" href=\"javascript:void(0)\">" + i + "</a> ") : string.Concat(new object[] { "<a href=\"", str, "page=", i, "\" title=\"第", i, "頁\">", i, "</a> " }));
    //    }
    //    if (this._pagecount > this._curpage)
    //    {
    //        builder.Append(string.Concat(new object[] { "<a href=\"", str, "page=", this._curpage + 1, "\" title=\"下一頁\">></a> <a href=\"", str, "page=", this._pagecount, "\" title=\"末頁\">>></a> " }));
    //    }
    //    return builder.ToString();
    //}
sql 
USE [News]
GO
/****** 對象:  StoredProcedure [dbo].[GetMyrecordFromPage]    腳本日期: 03/09/2010 12:18:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create procedure [dbo].[GetMyrecordFromPage]
(
 @tblName varchar(255),--表名
 @fldName varchar(255),--字段
 @PageSize int = 10,--頁尺寸
 @PageIndex int = 1,--頁碼
 @OrderType bit =0,--排序方式(0 升序  !0降序)
 @IsCount bit =0,--返回記錄數(shù)  !0返回記錄數(shù)
 @strWhere varchar(2000) = '' --條件語句
)
as
declare @strSQL varchar(6000)
declare @strTmp varchar(1000)
declare @strOrder varchar(500)
--判斷是否返回行數(shù)
if @IsCount!=0
begin
 set @strSql='select count(['+@fldName+']) from ['+@tblName+']'
end
else
begin
 --判斷排序類型
 if @OrderType!=0
 begin
  set @strOrder=' order by ['+@fldName+'] desc'
  set @strTmp='<(select min'
 end
 else
 begin
  set @strOrder=' order by ['+@fldName+'] asc'
  set @strTmp='>(select max'
 end
 --判斷有無條件
 if @strWhere=''
 begin
  set @strWhere='1=1'
 end
 --判斷是否第一頁
 if @PageIndex =1
 begin
  set @strTmp=''
  if @strWhere!=''
  begin
   set @strTmp=' where '+@strWhere
  end
  set @strSQL='select top '+str(@PageSize)+' * from ['+@tblName+'] '+@strTmp+@strOrder
 end
 else
 begin
  set @strSQL='select top '+str(@PageSize)+' * from ['
  +@tblName+'] where ['+@fldName+']'+@strTmp+'(['
  +@fldName+']) from (select top '+str((@PageIndex-1)*@PageSize)+' ['
  +@fldName+'] from ['+@tblName+'] where '+@strWhere
  +@strOrder+') as tblTmp) and '+@strWhere+@strOrder
 end
end
print @strSQL
exec(@strSQL)

 
本站僅提供存儲服務(wù)，所有內(nèi)容均由用戶發(fā)布，如發(fā)現(xiàn)有害或侵權(quán)內(nèi)容，請點(diǎn)擊舉報。
打開APP，閱讀全文并永久保存 查看更多類似文章
猜你喜歡
類似文章
用DataReader高效率分頁
分頁查詢
一個分頁類
ASP分頁
高效分頁存儲過程
SQLServer 高效 分頁存儲過程
更多類似文章 >>
生活服務(wù)
分享 收藏 導(dǎo)長圖 關(guān)注 下載文章
綁定賬號成功
后續(xù)可登錄賬號暢享VIP特權(quán)！
如果VIP功能使用有故障，
可點(diǎn)擊這里聯(lián)系客服！

聯(lián)系客服