time 
设为首页】【收藏本站
当前位置: 主页 > ERP > CRM > Dynamic CRM 2013学习记录(10)比较客户端比较常用的几种查询数据方式

Dynamic CRM 2013学习记录(10)比较客户端比较常用的几种查询数据方式

时间:2015-01-08 15:43 点击:1031次 字体:[ ]




我们经常要在客户端进行数据查询,下面分别比较常用的几种查询方式:XMLHttpRequest, SDK.JQuery, SDK.Rest.

XMLHttpRequest是最基本的调用方式,JQuery和Rest的二种方式其实也是用的XMLHttpRequest,只不过是把它封装了一下

JQuery和Rest二种方式的接口一样,所以调用方式也一样

 

1. XMLHttpRequest

  • 定义
  1: function ODataRetrieve(oDataString) {
  2:     var ServerUrl = Xrm.Page.context.getClientUrl();
  3:     if (ServerUrl.match(//$/)) {
  4:         ServerUrl = ServerUrl.substring(0, ServerUrl.length - 1);
  5:     }
  6:     var retrieveReq = new XMLHttpRequest();
  7:     retrieveReq.open("GET", ServerUrl + "/XRMServices/2011/OrganizationData.svc/" + oDataString, false);
  8:     retrieveReq.setRequestHeader("Accept", "application/json");
  9:     retrieveReq.setRequestHeader("Content-Type", "application/json;charset=utf-8");
 10:     retrieveReq.send();
 11:     return JSON.parse(retrieveReq.responseText).d;
 12: }
 
  • 调用方法:
  1: var retrievedContact = ODataRetrieve("ContactSet(guid'" + ContactAttribute.getValue()[0].id + "')?Select=JobTitle,MobilePhone");
  2:     if (retrievedContact != null) {
  3:         ContactJobAttribute.setValue(retrievedContact.JobTitle);
  4:         ContactPhoneAttribute.setValue(retrievedContact.MobilePhone);
  5: }
 
2. SDK.JQuery
  • SDK.JQuery.js 位于SDKSampleCodeJSRESTEndpointJQueryRESTDataOperationsJQueryRESTDataOperationsScripts下

 

  1: retrieveRecord: function (id, type, select, expand, successCallback, errorCallback)
  2: retrieveMultipleRecords: function (type, options, successCallback, errorCallback, OnComplete)

 

  • 调用方法:
  1: SDK.JQuery.retrieveRecord(
  2:      AccountId,
  3:      "Account",
  4:      null, null,
  5:      function (account) {
  6:       writeMessage("Retrieved the account named "" + account.Name + "". This account was created on : "" + account.CreatedOn + "".");
  7:       updateAccount(AccountId);
  8:      },
  9:      errorHandler
 10:    );
 11: 
 
  1: SDK.JQuery.retrieveMultipleRecords(
  2:      "Contact",
  3:      "$select=ContactId,FullName&$top=1",
  4:      function (results) {
  5:       var firstResult = results[0];
  6:       if (firstResult != null) {
  7:        primaryContact = results[0];
  8:       }
  9:       else {
 10:        writeMessage("No Contact records are available to set as the primary contact for the account.");
 11:       }
 12:      },
 13:      errorHandler,
 14:      function () {
 15:       //OnComplete handler
 16:      }
 17:    );
 18: 

 

3. SDK.Rest

  • SDK.Rest.js 位于SDKSampleCodeJSRESTEndpointJavaScriptRESTAssociateDisassociateJavaScriptRESTAssociateDisassociateScripts下

 

  1: retrieveRecord: function (id, type, select, expand, successCallback, errorCallback)
  2: retrieveMultipleRecords: function (type, options, successCallback, errorCallback, OnComplete)

 

  • 调用方法:
  1:  SDK.REST.retrieveRecord(
  2:      AccountId,
  3:      "Account",
  4:      null,null,
  5:      function (account) {
  6:       writeMessage("Retrieved the account named "" + account.Name + "". This account was created on : "" + account.CreatedOn + "".");
  7:       updateAccount(AccountId);
  8:      },
  9:      errorHandler
 10:    );
 11: 
  1: SDK.REST.retrieveMultipleRecords(
  2:      "Contact",
  3:      "$select=ContactId,FullName&$top=1",
  4:      function (results) {
  5:       var firstResult = results[0];
  6:       if (firstResult != null) {
  7:        primaryContact = results[0];
  8:       }
  9:       else {
 10:        writeMessage("No Contact records are available to set as the primary contact for the account.");
 11:       }
 12:      },
 13:      errorHandler,
 14:      function () { 
 15:      //OnComplete handler
 16:       }
 17:    );
 18: 


本文地址 : http://www.fengfly.com/plus/view-215510-1.html
标签: Dynamic CRM 2013 查询数据 客户端
------分隔线----------------------------
最新评论 查看所有评论
发表评论 查看所有评论
请自觉遵守互联网相关的政策法规,严禁发布色情、暴力、反动的言论。
评价:
表情:
验证码: