salesforce javascript 更新 查询DB

来源:互联网 发布:矩阵分析作业答案 编辑:程序博客网 时间:2024/06/06 07:06


var account = new sforce.SObject("Account");


sforce.connection.sessionId = '{!GETSESSIONID()}';
sforce.connection.update([account],{ 
onSuccess : function(result){ 
//refreshMarketSegment(year,currentAccountId,elemId);
//saveAndRefresh();
saveCurrentAccountInfo(currentAccountId);
}, 
onFailure : function(result){ 
//alert('An error has ocurred: '+result); 

})



var query = "select Market_Segment__c "
 + "from SalesPlan__c "
 + "where Visit_Capacity__r.year__c = '" + year + "' "
 + "and Account__c = '" + currentAccountId + "' ";
var result = sforce.connection.query(query, {
   onSuccess: function (result) {
       var records = result.getArray("records");
var marketSegment = new sforce.StringBuffer();
for (var i = 0; i < records.length; i++) {
marketSegment.append(records[i].Market_Segment__c);
}
var rows=j$(document.getElementById(elemId)).parent().parent().prevAll().length;
j$('#itb_table_a').find('tbody').children().eq(rows).children().eq(16).find('span').text(''+marketSegment);
j$('#itb_table_a_tableColumnClone').find('tbody').children().eq(rows).children().eq(16).find('span').text(''+marketSegment);
j$('#itb_table_a_tableHeadClone').find('tbody').children().eq(rows).children().eq(16).find('span').text(''+marketSegment);
j$('#itb_table_a_tableFixClone').find('tbody').children().eq(rows).children().eq(16).find('span').text(''+marketSegment);

   },
   onFailure: function (result) {
       //console.log("An error has occurred " + result);
   }
});



   <apex:actionFunction action="{!saveCurrentAccountInfo}" name="saveCurrentAccountInfo" rerender="spForm" status="pageStatus">
       <apex:param name="currentAccountId" assignTo="{!currentAccountId}" value="" />
   </apex:actionFunction>


    public PageReference saveCurrentAccountInfo(){
    // save current account info in pop up window
    currentAccountId = Apexpages.currentPage().getParameters().get('currentAccountId');