.NET分页+组合查询。一次读一页
<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="Home_Index.ascx.cs" Inherits="Shualo.WEB.Home.Home_Index" %> <%--中间内容--%>
- <%= strAT.ToString() %>
用户名： 密码：
首 页
- <%--
- 我的任务
- 我的任务
- 已接任务
- 已发任务 --%>
- 来路流量区
- 收藏互动区
- 推广任务区
- 任务预定VIP任务
发布人类型： <%# new Shualo.Business.Member_level_infoBLL().GetEntity(new Shualo.Business.Member_InfoBLL().GetEntity(Eval("memberId").ToString()).levelId).levelName.ToString()=="VIP会员"?" 
":"" %> <%# new Shualo.Business.BPMS_ItemDetailsBLL().GetEntity(new Shualo.Business.Member_InfoBLL().GetEntity(Eval("memberId").ToString()).trustTypeItemId.ToString()).ItemName.ToString()=="未加入"?"":"
信托卡" %> 发布时间： <%# Eval("carateTime") %> 奖发布点： <%# Eval("totalRelease") %>个 任务价格： <%# Eval("price") %>元 任务要求： <%# Bindtaskask(Eval("taskNo").ToString()) %> 任务状态： <%# new Shualo.Business.BPMS_ItemDetailsBLL().GetEntity(Eval("taskItemId").ToString()).ItemName.ToString() %> 
更多》公告 - <%= strnotice.ToString() %>
- <%= strjietask.ToString() %>
- <%= strfatask.ToString() %>
- <%= strhelp.ToString() %>
- 更多...
- <%= strskill.ToString() %>
- 更多...
- <%= strsell.ToString() %>
- 更多...
- <%= strsshoping.ToString() %>
- 更多...
我也参加>>平台动态
- <%= strtask.ToString() %>
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", ""); strLoginName = u.memberName.ToString();//存放用户ID if (Session["index_memberinfoArea"] != null) { index_memberinfoArea = Session["index_memberinfoArea"].ToString();//显示用户信息区域 } #region 任务左部菜单显示隐藏已登陆 strleftTask.Append("- 已接任务
"); strleftTask.Append("- 已发任务
"); strleftTask.Append("- 来路流量区
\n"); strleftTask.Append("- 收藏互动区
\n"); strleftTask.Append("- 推广任务区
\n"); strleftTask.Append("- 来路流量区
\n"); strleftTask.Append("- 收藏互动区
\n"); strleftTask.Append("- 推广任务区
\n"); strleftTask.Append("- 拍拍任务区
\n"); strleftTask.Append("- 阿里巴巴任务区
\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 回传页码值 /// 总记录数 /// 每页记录数 /// 当前页数 /// Url参数 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 ? "首页上一页" : "首页上一页"; //中间页处理，这个增加时间复杂度，减小空间复杂度 for (int i = startcount; i <= endcount; i++) { pagestr += page == i ? "" + i + "" : "" + i + ""; } pagestr += page < allpage ? "下一页尾页" : " 下一页尾页"; pagestr += ""; return pagestr; } #endregion
转载于:https://www.cnblogs.com/wybshyy/p/5847916.html
本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！
<%--
