using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
using System.Reflection;
namespace DAL
{
public class UserManageClass
{
/// summary>
/// 取得總頁數
/// /summary>
/// returns>總頁數/returns>
public int GetPageCount()
{
int counts;
string SqlStr = "select count(0) from [User]";
counts = new SQLHelper().Content(SqlStr, CommandType.Text);
return counts;
}
/// summary>
/// 取出每一頁的內容
/// /summary>
/// param name="SatrPage">開始頁數/param>
/// param name="EndPage">結束頁數/param>
/// returns>每一頁的內容/returns>
public DataTable GetPageDate(string SatrPage, string EndPage)
{
DataTable dt;
string SqlStr = @"select * from
(select *, ROW_NUMBER() over(order by id)as no_ from [User])aa
where aa.no_ between '"+SatrPage+"' and '"+EndPage+"'";
dt = new SQLHelper().ExecuteQuery(SqlStr, CommandType.Text);
return dt;
}
/// summary>
/// 將一個DataTable轉換成列表
/// /summary>
/// typeparam name="T">實體對象的類型/typeparam>
/// param name="dt">要轉換的DataTable/param>
/// returns>/returns>
public ListT> DataTableToEntityListT>(DataTable dt)
{
ListT> entiyList = new ListT>();
Type entityType = typeof(T);
PropertyInfo[] entityProperties = entityType.GetProperties();
foreach (DataRow row in dt.Rows)
{
T entity = Activator.CreateInstanceT>();
foreach (PropertyInfo propInfo in entityProperties)
{
if (dt.Columns.Contains(propInfo.Name))
{
if (!row.IsNull(propInfo.Name))
{
propInfo.SetValue(entity, row[propInfo.Name], null);
}
}
}
entiyList.Add(entity);
}
return entiyList;
}
}
}
using System;
using System.Collections;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Xml.Linq;
using System.Data.SqlClient;
using DAL;
using System.Web.Extensions;
using System.Web.Script.Serialization;
using Model;
using System.Web.UI.MobileControls;
using System.Collections.Generic;
namespace LandingSystem
{
/// summary>
/// $codebehindclassname$ 的摘要說明
/// /summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class PageService : IHttpHandler
{
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string action = context.Request["action"];
if (action == "GetPageCount")
{
int counts = new UserManageClass().GetPageCount();
int page = counts / 3;
if (counts % 3 != 0)
{
page++;
}
context.Response.Write(page);
}
else if (action == "GetPageData")
{
int pageNo = Convert.ToInt32(context.Request["PageNo"]);
string SatrPage = ((pageNo - 1) * 3 + 1).ToString();
string EndPage = (pageNo * 3).ToString();
DataTable dt= new UserManageClass().GetPageDate(SatrPage, EndPage);
IListRegisterModel> data = ModelConvertHelperRegisterModel>.ConvertToModel(dt);
// IListRegisterModel> data = new UserManageClass().DataTableToEntityListRegisterModel>(dt);
var p1 = data.Select(c => new { c.Name,c.Phone});
#region 廢物代碼
// var p1 = data.Select( c => new { c.Name,c.Phone});
//var p1=data.Select(dr=>new {dr["Name"].ToString(),dr["Phone"].ToString()});
//var T_model = new ListRegisterModel>();
//var p3 = T_model.Select(c => new { c.Name, c.Phone });
//var p2=data.Select(c=>new {})
#endregion
JavaScriptSerializer jss = new JavaScriptSerializer();
context.Response.Write(jss.Serialize(p1));
}
}
public bool IsReusable
{
get
{
return false;
}
}
}
}
head runat="server">
title>無標題頁/title>
script src="JS/jquery-latest.js" type="text/javascript">/script>
script type="text/javascript">
$(function(){
//-----------------------------------------------------------
function getPageData(pageNo){ //取得某頁數據的方法
$.post("PageService.ashx",{"action":"GetPageData","PageNo":pageNo},function(data,status){
if(status=="success"){
$("#Comment").empty();
var comments=$.parseJSON(data); //反序列化json數據。
for(var i=0;icomments.length;i++){
var row=comments[i];
var li= $("li>"+row.Name+" : "+row.Phone+"/li>");
$("#Comment").append(li); //每取出一條數據就創建一個li并append到Comment/ul內。
}
}
});
}
//-------------------------------------------------------------------
getPageData(1); //首次進入頁面，看到的是第一頁的數據
//----------------------------------------------------------------/
//取得所有的頁數并且初始化分頁按鈕
$.post("PageService.ashx",{"action":"GetPageCount"},function(data,status){
if(status=="success"){
var tr1=$("tr>/tr>");
var pageNo=parseInt(data);
for(var i=1;i=pageNo;i++){
var td=$("td>a href=''>"+i+"/a>/td>");
tr1.append(td);
}
$("#pageNo").append(tr1);
$("#pageNo a").click(function(e){ //頁碼創建后，就為每一個頁碼監聽一個click事件。
e.preventDefault(); //取消a的默認跳轉行為
getPageData($(this).html()); //點擊后就去執行取頁數據的操作。
});
}
});
//----------------------------------------------------------------------------
});
/script>
/head>
body>
table>
tr>
td>
ul id="Comment">/ul>
/td>
/tr>
/table>
br />
頁數：
table id="pageNo">/table>
/body>
/html>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Collections;
using System.Data;
using System.Reflection;
namespace DAL
{
public class ModelConvertHelperT> where T : new ()
{
public static IListT> ConvertToModel(DataTable dt)
{
IListT> ts = new ListT>();
Type type=typeof(T);
string tempName = "";
foreach (DataRow dr in dt.Rows)
{
T t = new T();
// 獲得此模型的公共屬性
PropertyInfo[] propertys = t.GetType().GetProperties();
foreach (PropertyInfo pi in propertys)
{
tempName = pi.Name;
// 檢查DataTable是否包含此列
if (dt.Columns.Contains(tempName))
{
// 判斷此屬性是否有Setter
if (!pi.CanRead) continue;
object value = dr[tempName];
if (value != DBNull.Value)
if (pi.PropertyType == typeof(int))
{
pi.SetValue(t, Convert.ToInt32(value), null);
}
else if (pi.PropertyType == typeof(string))
{
pi.SetValue(t, value.ToString(), null);
}
//pi.SetValue(t, value, null);
}
}
ts.Add(t);
}
return ts;
}
}
}
