<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Table.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta charset="utf-8" />
<title>layui</title>
<meta name="renderer" content="webkit" />
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1" />
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1" />
<link href="layui-v2.4.5/layui/css/layui.css" rel="stylesheet" />
</head>
<body>
<table class="layui-hide" id="test"></table>
<script src="layui-v2.4.5/layui/layui.js"></script>
<script>
layui.use('table', function () {
var table = layui.table;
table.render({
elem: '#test'
, url: 'Handler.ashx'
,method:'get'
, cellMinWidth: 80 //全局定义常规单元格的最小宽度，layui 2.2.1 新增
, cols: [[
{ field: 'id', width: 80, title: 'ID', width: '33%', sort: true }
, { field: 'name', width: 80, title: '用户名',width: '33%' }
, { field: 'tips', width: 80, title: '签名', width: '33%'}
]]
});
});
</script>
</body>
</html>
<%@ WebHandler Language="C#" Class="Handler" %>
using System;
using System.Web;
using System.Data;
public class Handler : IHttpHandler {
public void ProcessRequest (HttpContext context) {
context.Response.ContentType = "text/plain";
// context.Response.Write("Hello World");
// System.Data.DataTable dt = new System.Data.DataTable();
string str = string.Empty;
string sql = @"select * from test_datatable";
DataTable dt = DbHelperOra.DataSetQuery(DbHelperOra.conlodb, sql).Tables[0];
str = GridJsonn(dt, 1, 10);
context.Response.ContentType = "text/plain";
context.Response.Write(str);
}
public bool IsReusable {
get {
return false;
}
}
public static String GridJsonn(System.Data.DataTable dt, Int32 nPages, Int32 nPageSize)
{
//处理分页的时候数据
int nRowFrom = ((nPages - 1) * nPageSize);
int nRowTo = 0;
if (dt.Rows.Count > nPages * nPageSize)
{
nRowTo = nPages * nPageSize;
}
else
{
nRowTo = dt.Rows.Count;
}
string count = dt.Rows.Count.ToString();
//构建Json数据
string sJson = "{\"code\": " + 0 + ",\"msg\": \"\",\"count\":" + count + ",";
sJson += "\"data\": [";
for (int i = nRowFrom; i < nRowTo; i++)
{
sJson += "{" + "\"id\": " + dt.Rows[i]["id"] + ",\"name\": \"" + dt.Rows[i]["name"] + "\",\"tips\": \"" + dt.Rows[i]["tips"] + "\"},";
}
//string str= sJson.Substring(sJson.Length - 1, 1);
sJson += "]}";
sJson = sJson.Replace(",]}", "]}");
return sJson;
}
}
