AjaxExtJs学习笔记(2)_Basic GridPanel[基本网格]

这一节,将学习如何利用网络上最普遍的UI控件_Grid

 

1.静态示例:

静态示例其实官方下载包里,就有sample,那里只贴出代码,后边的如何跟WCF结合,做出动态版的Grid才是本文重点

Ajax 1<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"&gt;
Ajax 2<html xmlns=”http://www.w3.org/1999/xhtml"&gt;
Ajax 3<head>
Ajax 4    <meta http-equiv=”Content-Type” content=”text/html; charset=utf-8″>
Ajax 5    <link rel=”stylesheet” type=”text/css” href=”../resources/css/ext-all.css” />
Ajax 6     <script type=”text/javascript” src=”../adapter/ext/ext-base.js”></script>
Ajax 7    <script type=”text/javascript” src=”../ext-all.js”></script> 
Ajax 8    <title>ExtJs Study</title>
Ajax 9</head>
Ajax 10<body>
Ajax 11
Ajax 12Ajax 13<script type=”text/javascript”>Ajax 14
Ajax 15Ajax 16    Ext.onReady(function() Ajax 17{
Ajax 18    
Ajax 19    Ext.state.Manager.setProvider(new Ext.state.CookieProvider());//设置缓存
Ajax 20
Ajax 21    //数据来源于,实际行使用可动态读取
Ajax 22    var myData = [
Ajax 23        [‘3m Co’, 71.72, 0.02, 0.03, ‘9/1 12:00am’],
Ajax 24        [‘Alcoa Inc’, 29.01, 0.42, 1.47, ‘9/1 12:00am’],
Ajax 25        [‘Altria Group Inc’, 83.81, 0.28, 0.34, ‘9/1 12:00am’],
Ajax 26        [‘American Express Company’, 52.55, 0.01, 0.02, ‘9/1 12:00am’],
Ajax 27        [‘American International Group, Inc.’, 64.13, 0.31, 0.49, ‘9/1 12:00am’],
Ajax 28        [‘AT&T Inc.’, 31.61, -0.48, -1.54, ‘9/1 12:00am’],
Ajax 29        [‘Boeing Co.’, 75.43, 0.53, 0.71, ‘9/1 12:00am’],
Ajax 30        [‘Caterpillar Inc.’, 67.27, 0.92, 1.39, ‘9/1 12:00am’],
Ajax 31        [‘Citigroup, Inc.’, 49.37, 0.02, 0.04, ‘9/1 12:00am’],
Ajax 32        [‘E.I. du Pont de Nemours and Company’, 40.48, 0.51, 1.28, ‘9/1 12:00am’],
Ajax 33        [‘Exxon Mobil Corp’, 68.1, -0.43, -0.64, ‘9/1 12:00am’],
Ajax 34        [‘General Electric Company’, 34.14, -0.08, -0.23, ‘9/2 12:00am’],
Ajax 35        [‘General Motors Corporation’, 30.27, 1.09, 3.74, ‘9/3 12:00am’],
Ajax 36        [‘Hewlett-Packard Co.’, 36.53, -0.03, -0.08, ‘9/1 12:00am’],
Ajax 37        [‘Honeywell Intl Inc’, 38.77, 0.05, 0.13, ‘9/1 12:00am’],
Ajax 38        [‘Intel Corporation’, 19.88, 0.31, 1.58, ‘9/1 12:00am’],
Ajax 39        [‘International Business Machines’, 81.41, 0.44, 0.54, ‘9/1 12:00am’],
Ajax 40        [‘Johnson & Johnson’, 64.72, 0.06, 0.09, ‘9/1 12:00am’],
Ajax 41        [‘JP Morgan & Chase & Co’, 45.73, 0.07, 0.15, ‘9/1 12:00am’],
Ajax 42        [‘McDonald\’s Corporation’, 36.76, 0.86, 2.40, ‘9/1 12:00am’],
Ajax 43        [‘Merck & Co., Inc.’, 40.96, 0.41, 1.01, ‘9/1 12:00am’],
Ajax 44        [‘Microsoft Corporation’, 25.84, 0.14, 0.54, ‘9/1 12:00am’],
Ajax 45        [‘Pfizer Inc’, 27.96, 0.4, 1.45, ‘9/1 12:00am’],
Ajax 46        [‘The Coca-Cola Company’, 45.07, 0.26, 0.58, ‘9/1 12:00am’],
Ajax 47        [‘The Home Depot, Inc.’, 34.64, 0.35, 1.02, ‘9/1 12:00am’],
Ajax 48        [‘The Procter & Gamble Company’, 61.91, 0.01, 0.02, ‘9/1 12:00am’],
Ajax 49        [‘United Technologies Corporation’, 63.26, 0.55, 0.88, ‘9/1 12:00am’],
Ajax 50        [‘Verizon Communications’, 35.57, 0.39, 1.11, ‘9/1 12:00am’],
Ajax 51        [‘Wal-Mart Stores, Inc.’, 45.45, 0.73, 1.63, ‘9/1 12:00am’]
Ajax 52    ];
Ajax 53
Ajax 54    //”变化”字段的格式化输出
Ajax 55Ajax 56    function change(val) Ajax 57{
Ajax 58Ajax 59        if (val > 0) Ajax 60{
Ajax 61            return ‘<span style=”color:green;”>’ + val + ‘</span>’;
Ajax 62Ajax 63        } else if (val < 0) Ajax 64{
Ajax 65            return ‘<span style=”color:red;”>’ + val + ‘</span>’;
Ajax 66        }
Ajax 67        return val;
Ajax 68    }
Ajax 69
Ajax 70
Ajax 71    //”变化(%)”字段的格式化输出
Ajax 72Ajax 73    function pctChange(val) Ajax 74{
Ajax 75Ajax 76        if (val > 0) Ajax 77{
Ajax 78            return ‘<span style=”color:green;”>’ + val + ‘%</span>’;
Ajax 79Ajax 80        } else if (val < 0) Ajax 81{
Ajax 82            return ‘<span style=”color:red;”>’ + val + ‘%</span>’;
Ajax 83        }
Ajax 84        return val;
Ajax 85    }
Ajax 86
Ajax 87    //成立数量存款和储蓄(类似c#中的dataset构架)
Ajax 88Ajax 89    var store = new Ext.data.SimpleStore(Ajax 90{
Ajax 91        fields: [
Ajax 92Ajax 93           Ajax 94{ name: ‘company’ },
Ajax 95Ajax 96           Ajax 97{ name: ‘price’, type: ‘float’ },
Ajax 98Ajax 99           Ajax 100{ name: ‘change’, type: ‘float’ },
Ajax 101Ajax 102           Ajax 103{ name: ‘pctChange’, type: ‘float’ },
Ajax 104Ajax 105           Ajax 106{ name: ‘lastChange’, type: ‘date’, dateFormat: ‘n/j h:ia’ }
Ajax 107        ]
Ajax 108    });
Ajax 109    store.loadData(myData);//加载数据
Ajax 110
Ajax 111    //创制数量表格
Ajax 112Ajax 113    var grid = new Ext.grid.GridPanel(Ajax 114{
Ajax 115        store: store,
Ajax 116        columns: [
Ajax 117Ajax 118            Ajax 119{ id: ‘company’, header: “公司名”, width: 160, sortable: true, dataIndex: ‘company’ },
Ajax 120Ajax 121            Ajax 122{ header: “价格”, width: 75, sortable: true, renderer: ‘usMoney’, dataIndex: ‘price’ },
Ajax 123Ajax 124            Ajax 125{ header: “变化”, width: 75, sortable: true, renderer: change, dataIndex: ‘change’ },
Ajax 126Ajax 127            Ajax 128{ header: “变化(%)”, width: 75, sortable: true, renderer: pctChange, dataIndex: ‘pctChange’ },
Ajax 129Ajax 130            Ajax 131{ header: “最终更新”, width: 85, sortable: true, renderer: Ext.util.Format.dateRenderer(‘m/d/Y’), dataIndex: ‘lastChange’ }
Ajax 132        ],
Ajax 133        stripeRows: true,
Ajax 134        autoExpandColumn: ‘company’,
Ajax 135        height: 350,
Ajax 136        width: 600,
Ajax 137        title: ‘不难互联网示例’
Ajax 138    });
Ajax 139
Ajax 140    grid.render(‘grid-example’);//宣染钦赐ID
Ajax 141
Ajax 142    grid.getSelectionModel().selectFirstRow();//暗中同意选项第壹行
Ajax 143         
Ajax 144    });
Ajax 145</script>
Ajax 146
Ajax 147<button id=”btnHello”>Hello World</button>
Ajax 148<div id=”grid-example”></div>
Ajax 149</body>
Ajax 150</html>
Ajax 151

 

2.动态示例

先贴出运营效果图
Ajax 152

 

 

a.先写wcf服务端
(1)新建一个”启用了Ajax的WCF服务”,命名为MyService.svc
Ajax 153

(2)写三个主意用于获取网格所需的多寡

[ServiceContract(Namespace = “”)]
    [AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Allowed)]
    public class MyService
    {

        [OperationContract]
        [WebInvoke(ResponseFormat = WebMessageFormat.Json, Method = “GET”, UriTemplate = “GetClsData”)]
        public T_Class[] GetClsData()
        {
            List<T_Class> _Result = new List<T_Class>();
            using (DBDataContext db = new DBDataContext())
            {
                var query = db.T_Classes.Where(c => c.F_Type.ToLower() == “shop”).OrderBy(c => c.F_RootID).ThenBy(c => c.F_Orders).Select(c => new { F_ID = c.F_ID, 

F_ClassName = c.F_ClassName, F_ParentID = c.F_ParentID,F_Orders = c.F_Orders,F_ReadMe = c.F_ReadMe });
                _Result = db.ExecuteQuery<T_Class>(query, true).ToList<T_Class>();
                db.Connection.Close();
            }
            return _Result.ToArray();
        }
}

 

留神:那里是用linq to sql的点子写的,暗中同意情形下linq to
sql设计器生成的T_Class类里,是不扶助种类化的,ExtJs调用时不可能正确类别成JSON字符串,必要手动在类前拉长数量契约

[DataContract],在品质前拉长[DataMember]
如下:
[Table(Name=”dbo.T_Class”)] 
    [DataContract]
 public partial class T_Class : INotifyPropertyChanging,
INotifyPropertyChanged
 {
  

[Column(Storage=”_F_ClassName”, DbType=”NVarChar(256)”)]
        [DataMember]
  public string F_ClassName
  {

(3)修改svc文件,右击svc文件,接纳打开药情势–>HTML编辑器,扩大Factory=”System.ServiceModel.Activation.WebServiceHostFactory”

<%@ ServiceHost Language=”C#” Debug=”true”
Service=”Ajax_WCF.MyService” CodeBehind=”MyService.svc.cs”
Factory=”System.ServiceModel.Activation.WebServiceHostFactory”%>
Ajax 154

Ajax 155

(4)修改web.config,找到以下节点(注:Ajax_WCF为项目标命名空间,因各自项目实在情况而异)
<behavior name=”Ajax_WCF.MyServiceAspNetAjaxBehavior”>
     <enableWebScript />
</behavior>
把<enableWebScript />删除,换成<webHttp />

 <behavior name=”Ajax_WCF.MyServiceAspNetAjaxBehavior”>
     <webHttp />
    </behavior>

说美素佳儿(Friso)下:(3),(4)二步是必须的,指标是为了生成Restful
WCF,能够在ExtJs里用接近”MyService.svc/GetClsData”那样的url来走访

b.Extjs调用的前端页面

<%@ Page Language=”C#” AutoEventWireup=”true” CodeBehind=”02.Grid.aspx.cs” Inherits=”Ajax_WCF._02_Grid” %>
<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"&gt;
<html xmlns=”http://www.w3.org/1999/xhtml"&gt;
<head>
    <meta http-equiv=”Content-Type” content=”text/html; charset=utf-8″>    
    <link rel=”stylesheet” type=”text/css” href=”js/ext2.2/resources/css/ext-all.css” /> 
     <script type=”text/javascript” src=”js/ext2.2/adapter/ext/ext-base.js”></script>    
    <script type=”text/javascript” src=”js/ext2.2/ext-all.js”></script>
    <title>ExtJs Basic Grid Demo</title>

</head>
<body>
<script type=”text/javascript”>
    Ext.onReady(function() {
        var proxy = new Ext.data.HttpProxy({ url: ‘MyService.svc/GetClsData’ });
        var reader = new Ext.data.JsonReader({}, [
        { name: ‘F_ID’ },
        { name: ‘F_ClassName’ },
        { name: ‘F_Orders’ },
        { name: ‘F_ParentID’ },
        { name: ‘F_ReadMe’}]
    )
        var store = new Ext.data.Store({ proxy: proxy, reader: reader });
        store.load();
        var grid = new Ext.grid.GridPanel({
            store: store,
            columns: [
        { id: ‘F_ID’, header: “分类ID”, width: 250, sortable: true, dataIndex: ‘F_ID’ },
        { header: “分类名称”, width: 75, sortable: true, dataIndex: ‘F_ClassName’ },
        { header: “排序号”, width: 75, sortable: true, dataIndex: ‘F_Orders’ },
        { header: “备注”, width: 100, sortable: true, dataIndex: ‘F_ReadMe’}],
            height: 350,
            width: 600,
            title: ‘基本网格示例’,
            viewConfig: { columnsText: ‘显示列’, sortAscText: ‘升序’, sortDescText: ‘降序’ }
        });
        grid.render(‘grid-example’);
        grid.getSelectionModel().selectFirstRow();
    });
</script>
    ExtJs_Grid_Demo
    <div id=”grid-example”></div>
</body>
</html>

ok,完成了。

 

除此以外,假诺要贯彻对Grid的询问,能够再拉长这几行代码:

JS部分:

 

var fnAjaxDemo = function() {
            var mydata;
            Ext.Ajax.request({
                url:
“MyService.svc/GetClsData?name=” +
encodeURAV4IComponent(Ext.get(“ProductName”).dom.value),
//服务器端地址
                success: function(request) {                   
                    store.loadData(eval(request.responseText));                   
                },
                failure: function() {
                    alert(“failure!”);
                }
            });
        }

        Ext.get(“btnRefresh”).on(“click”, fnAjaxDemo);

 

。。。

 

html部分:
分类名称:<input type=”text” id=”ProductName”
name=”ProductName”/><button
id=”btnRefresh”>查询记录</button>

本来,相应的GetClsData部分也要修改:

 

[OperationContract]
        [WebInvoke(ResponseFormat = WebMessageFormat.Json, Method =
“GET”, UriTemplate = “GetClsData”)]
        public T_Class[] GetClsData()
        {
            string name =
CNTVS.TOOLS.Utils.fRequest(“name”).ToString();
            List<T_Class> _Result = new
List<T_Class>();
            using (DBDataContext db = new DBDataContext())
            {
                var query = db.T_Classes.Where(c =>
c.F_Type.ToLower() == “shop”);

                if (name != “”)
                {
                    query = query.Where(p =>
p.F_ClassName.ToLower().Contains(name.ToLower()));
                }

                var query2 = query.OrderBy(c => c.F_RootID).ThenBy(c
=> c.F_Orders).Select(c => new { F_ID = c.F_ID, F_ClassName =
c.F_ClassName, F_ParentID = c.F_ParentID, F_Orders = c.F_Orders,
F_ReadMe = c.F_ReadMe });

                _Result = db.ExecuteQuery<T_Class>(query2,
true).ToList<T_Class>();
                db.Connection.Close();
            }
            return _Result.ToArray();
        }

 

末尾验明正身多少个注意事项:
1.Ext.onReady(function()
{…}这一串script,假若平素写在页面中,必须放在<body>…</body>中,否则网格上右击,设置展现列时,报JS错误,原因不明。
2.WCF的服务端方法,必须安装成JSON格式,别的Method设置为GET,不然运维时,前端页面读不出数据
3.假如设置了autoExpandColumn,则autoExpandColumn对应的列,必须是id对应的列,不然出错
4.服务端的类中,假如有DateTime字符的字段,需求手动修改dbml对应的cs文件,把DateTime改成string,不然系列化时,会发生很怪的值,猜想是.Net在连串化成JSON时的bug.
5.为了减小生成的JSON字符串的轻重,能够仅在须求输出的类属性上标记[DataMember],那样在变更的JSON字符串,不会包含未标记为[DataMember]的字段

相关文章