自做 数据分页，执行SQL操作数据分页，SQL 分页
时间：2022-03-10 17:09
WMS.Web.YZMManagement.YZMOrderControl.YZMOrderControl_List.aspx
function ListGrid() { $("#Button1").click(); }<a id="btn-query"
href="javascript:;"
onclick="ListGrid();"
class="buttonHuge button-blue"
style="color: #fff">查询</a> <div style="margin-top:20px;bottom: 0px; position: absolute; width:100%; text-align:center;"> <asp:Button ID="FirstPageText"
runat="server"
Text="首 页" onclick="FirstPageText_Click"
/> <asp:Button ID="PrevPageText"
runat="server"
Text="上一页" onclick="PrevPageText_Click"
/> <asp:Label ID="Label1"
runat="server"
Text="第"></asp:Label> <input id="PageIndex"
type="text"
runat="server"
value=""
style=" width:50px;"
class="txt"
datacol="No"
checkexpession="Int"
/> <asp:Label ID="Label2"
runat="server"
Text="页"></asp:Label> <asp:Button ID="Btn_PageIndex"
runat="server"
Text="GO" onclick="Btn_PageIndex_Click"
/> <asp:Button ID="NextPageText"
runat="server"
Text="下一页" onclick="NextPageText_Click"
/> <asp:Button ID="LastPageText"
runat="server"
Text="尾 页" onclick="LastPageText_Click"
/> <asp:Label ID="Label5"
runat="server"
Text="当前页"></asp:Label> <asp:Label ID="CurrentPage"
runat="server"></asp:Label> <asp:Label ID="Label4"
runat="server"
Text="共"></asp:Label> <asp:Label ID="PageCount"
runat="server"></asp:Label> <asp:Label ID="Label3"
runat="server"
Text="页"></asp:Label> <asp:Label ID="Label6"
runat="server"
Text="检索到"></asp:Label> <asp:Label ID="CountSum"
runat="server"></asp:Label> <asp:Label ID="Label8"
runat="server"
Text="条数据"></asp:Label> </div> |
cs
public
string sel = ""; //当前页 public
int _CurrentPage; //共页 public
int _PageCount; //首页 public
int _FirstPage; //上一页 public
int _PrevPage; //下一页 public
int _NextPage; //尾页 public
int _LastPage; //跳转页 public
int _GO = 1; protected
void Page_Load(object
sender, EventArgs e) { if
(!IsPostBack) { sel = "sel"; loadhtml(); } } private
void loadhtml() { DataTable dt = new
DataTable(); //查询 if
(sel == "sel") { int
count = 0; dt = mor_dal.GetOrderDataTablePageList(SqlWhere.ToString(), "order_id", "asc", _GO, 20, ref
count); if
(count % 20 > 0) { _PageCount = count / 20 + 1; } else { _PageCount = count / 20; } //给分页赋值 CurrentPage.Text = _GO.ToString(); PageCount.Text = _PageCount.ToString(); CountSum.Text = count.ToString(); if
(_GO == 1) { PrevPageText.Enabled = false; } else { PrevPageText.Enabled = true; } if
(Convert.ToInt32(PageCount.Text.Trim()) == _GO) { NextPageText.Enabled = false; } else { NextPageText.Enabled = true; } } else { int
count = 0; dt = mor_dal.GetOrderDataTablePageList(SqlWhere.ToString(), "order_id", "asc", _GO, 20, ref
count); CurrentPage.Text = _GO.ToString(); } } /// <summary> /// 首页 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected
void FirstPageText_Click(object
sender, EventArgs e) { _GO = 1; PrevPageText.Enabled = false; if
(Convert.ToInt32(PageCount.Text.Trim()) == _GO) { NextPageText.Enabled = false; } else { NextPageText.Enabled = true; } loadhtml(); } /// <summary> /// 上一页 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected
void PrevPageText_Click(object
sender, EventArgs e) { _GO = Convert.ToInt32(CurrentPage.Text.Trim()) - 1; if
(_GO == 1) { PrevPageText.Enabled = false; } else { PrevPageText.Enabled = true; } if
(Convert.ToInt32(PageCount.Text.Trim()) == _GO) { NextPageText.Enabled = false; } else { NextPageText.Enabled = true; } loadhtml(); } /// <summary> /// 下一页 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected
void NextPageText_Click(object
sender, EventArgs e) { _GO = Convert.ToInt32(CurrentPage.Text.Trim()) + 1; if
(_GO == 1) { PrevPageText.Enabled = false; } else { PrevPageText.Enabled = true; } if
(Convert.ToInt32(PageCount.Text.Trim()) == _GO) { NextPageText.Enabled = false; } else { NextPageText.Enabled = true; } loadhtml(); } /// <summary> /// 尾页 /// </summary> /// <param name="sender"></param> /// <param name="e"></param>NextPageTextLastPage protected
void LastPageText_Click(object
sender, EventArgs e) { _GO = Convert.ToInt32(PageCount.Text.Trim()); NextPageText.Enabled = false; if
(_GO == 1) { PrevPageText.Enabled = false; } else { PrevPageText.Enabled = true; } loadhtml(); } /// <summary> /// G O /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected
void Btn_PageIndex_Click(object
sender, EventArgs e) { try { if
(Convert.ToInt32(PageIndex.Value.Trim()) <= Convert.ToInt32(PageCount.Text.Trim()) && PageIndex.Value.Trim() != "0") { _GO = Convert.ToInt32(PageIndex.Value.Trim()); if
(_GO == 1) { PrevPageText.Enabled = false; } else { PrevPageText.Enabled = true; } if
(Convert.ToInt32(PageCount.Text.Trim()) == _GO) { NextPageText.Enabled = false; } else { NextPageText.Enabled = true; } loadhtml(); } else { Page.Response.Write("<script type=\"text/javascript\">alert(‘已超出索引!‘);</script>"); } } catch
(Exception) { Page.Response.Write("<script type=\"text/javascript\">alert(‘输入有误!‘);</script>"); } }//执行SQL/// <summary> /// 销售订单明细--分页 /// </summary> /// <param name="sqlwhere">条件</param> /// <param name="orderField">排序字段</param> /// <param name="orderType">排序类型</param> /// <param name="pageIndex">当前页</param> /// <param name="pageSize">页大小</param> /// <param name="count">返回查询条数</param> /// <returns></returns> public
System.Data.DataTable GetOrderDataTablePageList(string
sqlwhere, string
orderField, string
orderType, int
pageIndex,
热门排行今日推荐热门手游 |
