分页
来源:互联网 发布:软件测试绩效考核指标 编辑:程序博客网 时间:2024/06/10 01:46
<div> <ul runat="server" id="ulShow"></ul></div><div class="pagination_div"> <div class="pagination" runat="server" id="DivPage"></div></div>//分页样式<style type="text/css"> .pagination_div{ margin:0px; clear:both; text-align:center; padding-bottom:50px; margin-top:35px; } .pagination a:link,.pagination a:visited{ border:1px solid #d1e4fd; background:#e3efff; margin-left:5px; padding:3px 7px; color:#163f76; text-decoration:none;} .pagination a:hover{ background:#008bda; color:#fff; border-color:#008bda; text-decoration:none; } .pagination strong{ margin-left:5px; padding-top:4px; } .pagination input[type='text']{ height:22px; padding:0px; margin-left:5px; border-radius:0;}</style>protected void LoadList(){ DivPage.Visible=false; int r, p, PageIndex=0; PageIndex=Convert.ToInt32(Request.QueryString["Page"]); string whereStr=" a.ExpertId="+userId+" and a.UserType="+ut; if(re==1) whereStr+=" and a.ExpertScore!=0"; else if(re==2) whereStr+=" and a.ExpertScore=0"; SqlCondiitionInfo() st=new SqlConditionInfo[] { new SqlConditionInfo("@whereStr",whereStr,TypeCode.Object) }; DataTable dt=UtiPage.GetPage("GetApplyByExpert",PageIndex,10,out r,out p,st); if(dt!=null&&dt.Rows.Count>0) { StringBuilder sb=new StringBuilder(); for(int i=0; i<dt.Rows.Count; i++) { } this.ulShow.InnerHtml=sb.ToString(); } if(r>10) { DivPage.InnerHtml=PageNavigator.Pagination(PageIndex,p,"page.aspx?ut="+ut); DivPage.Visible=true; } }protected string[] GetApplyByExpert={"a.ID","a.*,u.*","applySpace a left join user u on a.schoolId=u.userId where @whereStr",order by a.ID asc};
0 0