一步步打造漂亮的新闻列表(无刷新分页、内容预览)第三章

 
$("#Pagination").pagination(56, { 
num_edge_entries: 2, 
num_display_entries: 4, 
callback: pageselectCallback, 
items_per_page:1 
}); 

 
<link type="text/css" rel="Stylesheet" rel="nofollow noopener noreferrer" href="css/newsList.css" /> 
<link type="text/css" rel="Stylesheet" rel="nofollow noopener noreferrer" href="css/pagination.css" /> 
<script src="js/jquery-1.4.1.js" type="text/javascript"></script> 
<script src="js/jquery.pagination.js" type="text/javascript"></script> 

 
<script type="text/javascript" language="javascript"> 
$().ready(function() { 
InitData(0); 
}); 
//处理翻页 
function pageselectCallback(page_id, jq) { 
//alert(page_id); 
InitData(page_id); 
}; 
function InitData(pageindx) 
{ 
var tbody = ""; 
var orderby="news_id"; 
$.ajax({ 
type: "POST",//用POST方式传输 
dataType:"json",//数据格式JSON 
url:'Ajax/NewsHandler.ashx',//目标地址 
data:"pageno="+(pageindx+1)+"&orderby="+orderby, 
success:function(json) { 
$("#productTable tr:gt(0)").remove(); 
var productData = json.News; 
$.each(productData, function(i, n) { 
var trs = ""; 
trs += "<tr><td style='text-align:center'><a rel="nofollow noopener noreferrer" href=\"NewsRead.aspx?news_id="+n.news_id+"\" class=\"info2\" >" + n.news_title + "</a></td><td style='text-align:center'>" + n.news_readtimes + "</td><td style='text-align:center'>" + n.news_time + "</td></tr>"; 
tbody += trs; 
}); 
$("#productTable").append(tbody); 
//奇偶行颜色不同 
$("#productTable tr:gt(0):odd").attr("class", "odd"); 
$("#productTable tr:gt(0):even").attr("class", "enen"); } 
}); 
$("#pagination").pagination(<%=pagecount %>, { 
callback: pageselectCallback, 
prev_text: '<< 上一页, 
next_text: '下一页 >>', 
items_per_page:9, 
num_display_entries:6, 
current_page:pageindx, 
num_edge_entries:2 
}); 
} 
</script> 

 
[ 
{ 
"term":"BACCHUS", 
"part":"n.", 
"definition":"A convenient deity invented by the ancients as an excuse for getting drunk.", 
"quote":[ 
"Is public worship,then,a sin.", 
"That for devotions paid to Bacchus", 
"The lictors dare to run us in.", 
"And resolutely thump and whack us?" 
], 
"author":"Jorace" 
}, 
{ 
"term":"BACKBITE", 
"part":"v.t.", 
"definition":"To speak of a man as you find him when he can t find you." 
}, 
{ 
"term":"BEARD", 
"part":"n.", 
"definition":"The hair that is commonly cut off by those who justly execrate the absurd Chinese custom of shaving the bead." 
} 
] 

 
public static string DataTableToJSON(DataTable dt, string dtName) 
{ 
StringBuilder sb = new StringBuilder(); 
StringWriter sw = new StringWriter(sb); 
using (JsonWriter jw = new JsonTextWriter(sw)) 
{ 
JsonSerializer ser = new JsonSerializer(); 
jw.WriteStartObject(); 
jw.WritePropertyName(dtName); 
jw.WriteStartArray(); 
foreach (DataRow dr in dt.Rows) 
{ 
jw.WriteStartObject(); 
foreach (DataColumn dc in dt.Columns) 
{ 
jw.WritePropertyName(dc.ColumnName); 
ser.Serialize(jw, dr[dc].ToString()); 
} 
jw.WriteEndObject(); 
} 
jw.WriteEndArray(); 
jw.WriteEndObject(); 
sw.Close(); 
jw.Close(); 
} 
return sb.ToString(); 
} 

 
int pageindex;//页数 
int.TryParse(context.Request["pageno"], out pageindex);//把赋值给pageindex 
string orderby = context.Request["orderby"].ToString();//以什么排序 
DataTable dt = new DataTable(); 
dt = PageData(pageindex, 10, "tb_news", orderby);//获取数据 
string jsonData = DataTableToJSON(dt, "News");//创建json对象,将datatable对象转换为json对象 
context.Response.Write(jsonData);//返回json数据 

 
#region 返回特定页数的数据 
/// <summary> 
/// 返回特定页数的数据 
/// </summary> 
/// <param name="pageindex">特定的页数</param> 
/// <param name="pagesize">页的大小</param> 
/// <param name="table">哪张表</param> 
/// <returns></returns> 
public DataTable PageData(int pageindex, int pagesize, string table, string orderby) 
{ 
string connectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["NewsConnection"].ToString(); 
OleDbConnection conn; 
if (pageindex < 1) 
pageindex = 1; 
conn = new OleDbConnection(connectionString); 
DataTable dt=new DataTable(); 
try 
{ 
conn.Open(); 
OleDbCommand cmdTotal = new OleDbCommand("select count(0) from " + table, conn); 
int recordCount = Convert.ToInt32(cmdTotal.ExecuteScalar());//数据的总数 
int pageCount;//总共的页数 
if (recordCount % pagesize > 0) 
pageCount = recordCount / pagesize + 1; 
else 
pageCount = recordCount / pagesize; 
if (pageindex > pageCount) 
pageindex = pageCount; 
DataTable dataTemp = new DataTable(); 
string cmdText = "select news_id,news_title,news_readtimes,news_time from " + table + " order by " + orderby + " desc"; 
OleDbCommand cmd = new OleDbCommand(cmdText, conn); 
OleDbDataAdapter oda = new OleDbDataAdapter(cmd); 
oda.Fill(dataTemp); 
dt= dataTemp.Clone(); 
for (int i = 0; i < pagesize; i++) 
{ 
if (recordCount <= (pagesize * (pageindex - 1) + i)) 
break; 
dt.Rows.Add(dataTemp.Rows[pagesize * (pageindex - 1) + i].ItemArray); 
} 
} 
catch (Exception e) 
{ 
} 
finally 
{ 
conn.Close(); 
} 
return dt; 
} 
#endregion 

 
protected void InitPageCount() 
{ 
conn = new OleDbConnection(connectionString);//创建新的连接 
try 
{ 
conn.Open(); 
string cmdText = "select count(0) as pages from tb_news"; 
OleDbCommand cmd = new OleDbCommand(cmdText, conn); 
DataTable dt = new DataTable(); 
OleDbDataAdapter oda = new OleDbDataAdapter(cmd); 
oda.Fill(dt); 
if (dt != null) 
{ 
pagecount = dt.Rows[0]["pages"].ToString(); 
} } 
catch (Exception e) 
{ 
pagecount = "0"; 
Response.Write("Error：" + e.Message);//如果连接失败，将错误显示出来 
} 
finally 
{ 
conn.Close();//一定要及时关掉conn 
} 
} 

到此这篇关于一步步打造漂亮的新闻列表(无刷新分页、内容预览)第三章就介绍到这了。青春是一场泅渡，如履薄冰，战战兢兢我们却要把持住那些岌岌可危的惶恐，毅然朝梦里花开的暖季前行。更多相关一步步打造漂亮的新闻列表(无刷新分页、内容预览)第三章内容请查看相关栏目，小编编辑不易，再次感谢大家的支持！