html部分
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title></title>
<link href="ext-3.1.1/resources/css/ext-all.css" rel="Stylesheet" />
<script type="text/javascript" src="ext-3.1.1/adapter/ext/ext-base.js"></script>
<script type="text/javascript" src="ext-3.1.1/ext-all.js"></script>
<script type="text/javascript">
Ext.onReady(function() {
Ext.QuickTips.init();
var root = new Ext.tree.AsyncTreeNode({ id: "root1", text: "所有部门",qtip:"所有部门"});
var tree = new Ext.tree.TreePanel({
width: 200,
root: root,
loader: new Ext.tree.TreeLoader({
dataUrl: "treeList.aspx"
})
});
tree.on("click", function(node) {
Ext.Msg.alert("消息弹出框", "您点击了:" + node.text);
});
//创建cm定义gridpanne列定义
var cm = new Ext.grid.ColumnModel([
{ header: "编号", name: "ID", sortable: true },
{ header: "编号", name: "UserName", sortable: true },
{ header: "年龄", name: "Age", sortable: true }
]);
//定义recode 标准给事
var recode = new Ext.data.Record.create([{ name: "ID" }, { name: "UserName" }, { name: "Age"}]);
//定义reader
var reader = new Ext.data.JsonReader(
{
totalProperty: "count",
root: "root"
},
recode
);
//定义store返回recode
var store = new Ext.data.Store({
url: "GetUserDataJson.aspx",
reader: reader
});
//store加载
store.load({ params: { start: 0, limit: 3} });
//定义gridpannel
var grid = new Ext.grid.GridPanel({
title: "员工总数",
store: store,
height: 300,
cm: cm,
bbar: new Ext.PagingToolbar({ pageSize: 3, store: store, displayInfo: true, displayMsg: "第{0}~{1},总数为:{2}" })
});
new Ext.Viewport({
layout: "border",
items: [{
//begin
title: "用户管理",
region: "west",
layout: "accordion",
width: 200,
items: [{ title: "部门管理", height: 200, items: tree }, { title: "职位管理"}]
}, { id: "tabmain", xtype: "tabpanel", region: "center", items: [{ title: "首页", height: 400, items: grid}]}]
});
//end
})
</script>
</head>
<body>
</body>
</html>
treeList.aspx部分:
[{id:"node1",text:"研发部",leaf:true,qtip:"研发部",href:"/hanfa/index.aspx"},{id:"node2",text:"市场部",leaf:true,qtip:"市场部",href:"/shichang/Index"},{id:"node3",text:"运维部",leaf:true,qtip:"运维部",href:"/yunwei/index.aspx"}]
GetUserDataJson.aspx部分
<%
int start =int.Parse(Request.Params["start"].ToString());
int limit = int.Parse(Request.Params["limit"].ToString());
string sqlcon = ConfigurationManager.ConnectionStrings["mycon"].ConnectionString;
using (System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(sqlcon))
{
string sql = string.Format("select top {0} * from tuser where id not in( select top {1} id from tuser order by id desc) order by id desc",limit,start);
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(sql, con))
{
con.Open();
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
StringBuilder allStr = new StringBuilder();
allStr.Append(@"{root:[");
int i = 0;
while (reader.Read())
{
i++;
allStr.Append("{ID:'" + reader["Id"].ToString() + "',UserName:'" + reader["UserName"].ToString() + " ',Age:'" + reader["age"].ToString() + "'},");
}
allStr = allStr.Remove(allStr.Length - 1, 1);
allStr.Append(@"],count:'10'}");
%>
<%=allStr.ToString() %>
<%
}
}
%>