asp.net點(diǎn)擊查看更多實(shí)現(xiàn)無(wú)刷新加載的實(shí)現(xiàn)代碼

更新時(shí)間：2012年06月29日 23:52:20 作者：

asp.net點(diǎn)擊查看更多實(shí)現(xiàn)無(wú)刷新加載的實(shí)現(xiàn)代碼，需要的朋友可以參考下

頁(yè)面頁(yè)面的js代碼如下，

 
<script type="text/javascript"> 
$(function () { 
function init(count, start) { 
$.ajax({ 
type: "GET", 
dataType: "json", 
url: "Handler/Handler.ashx", 
data: { action: "GetMoreNews", count: count, start: start }, 
beforeSend: function () { $("#divload").show(); $("#more2").hide(); }, 
complete: function () { $("#divload").hide(); $("#more2").show(); }, 
success: function (json) { 
var str = ""; 
$.each(json, function (index, array) { 
var str = "<div class='single_item'>" 
+ "<div class='element_head'>" 
+ "<div class='author'>" + array['Title'] +"</div>" 
+ "<div class='date'>" + array['Date'] + "</div>" 
+ "</div>" 
+ "<div class='content'>" + array['Contents'] + "</div>" 
+ "</div>"; 
$("#more").append(str); 
}); 
if (json == "") { 
$("#more2").html("沒(méi)有更多內(nèi)容加載了……"); 
} 
} 
}); 
} 
var count = 5; 
var start = 0; 
init(count, start); 
$(".get_more").click(function () { 
start += 5; 
init(count, start); 
}); 
}); 
</script> 

解釋上面js的大體意思：定義一個(gè)init方法，此方法帶有兩個(gè)參數(shù)count和start，count意思是每次加載顯示評(píng)論數(shù)，start意思是，每次從數(shù)據(jù)庫(kù)中讀取的位置，比如0，5,10。
Handler.ashx處理頁(yè)面的代碼如下

復(fù)制代碼代碼如下:

 
頁(yè)面頁(yè)面的js代碼如下， 
<b> <script type="text/javascript"> 
$(function () { 
function init(count, start) { 
$.ajax({ 
type: "GET", 
dataType: "json", 
url: "Handler/Handler.ashx", 
data: { action: "GetMoreNews", count: count, start: start }, 
beforeSend: function () { $("#divload").show(); $("#more2").hide(); }, 
complete: function () { $("#divload").hide(); $("#more2").show(); }, 
success: function (json) { 
var str = ""; 
$.each(json, function (index, array) { 
var str = "<div class='single_item'>" 
+ "<div class='element_head'>" 
+ "<div class='author'>" + array['Title'] +"</div>" 
+ "<div class='date'>" + array['Date'] + "</div>" 
+ "</div>" 
+ "<div class='content'>" + array['Contents'] + "</div>" 
+ "</div>"; 
$("#more").append(str); 
}); 
if (json == "") { 
$("#more2").html("沒(méi)有更多內(nèi)容加載了……"); 
} 
} 
}); 
} 
var count = 5; 
var start = 0; 
init(count, start); 
$(".get_more").click(function () { 
start += 5; 
init(count, start); 
}); 
}); 
</script></b> 
解釋上面js的大體意思：定義一個(gè)init方法，此方法帶有兩個(gè)參數(shù)count和start，count意思是每次加載顯示評(píng)論數(shù)，start意思是，每次從數(shù)據(jù)庫(kù)中讀取的位置，比如0，5,10。 
Handler.ashx處理頁(yè)面的代碼如下 
[code] 
case "GetMoreNews": 
int count = int.Parse(context.Request.QueryString["count"].ToString()); 
int start = int.Parse(context.Request.QueryString["start"].ToString()); 
IList<WineNews> morenews = WineNewsManager.WineNewsQueryFromMToN(count,start); 
Content = JavaScriptConvert.SerializeObject(morenews); 
break; 

WineNewsQueryFromMToN代碼如下

復(fù)制代碼代碼如下:

 
public static IList<WineNews> WineNewsQueryFromMToN(int count,int start) 
{ 
using (SqlConnection cn = new SqlConnection(SQLHelp.Conn)) 
{ 
cn.Open(); 
string sql = "SELECT TOP " + count + " f.* FROM tb_WineNews f WHERE Id NOT IN (SELECT TOP " + start + " Id FROM tb_WineNews ORDER BY Id desc) ORDER BY Id desc"; 
SqlCommand cmd = new SqlCommand(sql, cn); 
SqlDataReader dr = cmd.ExecuteReader(); 
IList<WineNews> list = new List<WineNews>(); 
while (dr.Read()) 
{ 
WineNews wineNews = new WineNews(); 
if (dr["ID"] != DBNull.Value) 
{ 
wineNews.ID = (int)dr["ID"]; 
} 
if (dr["Title"] != DBNull.Value) 
{ 
wineNews.Title = (string)dr["Title"]; 
} 
if (dr["Contents"] != DBNull.Value) 
{ 
wineNews.Contents = (string)dr["Contents"]; 
} 
if (dr["Picture"] != DBNull.Value) 
{ 
wineNews.Picture = (string)dr["Picture"]; 
} 
if (dr["Date"] != DBNull.Value) 
{ 
wineNews.Date = ((DateTime)dr["Date"]).ToString("yyyy-MM-dd HH:mm:ss"); 
} 
list.Add(wineNews); 
} 
dr.Close(); 
return list; 
} 
} 