Office365学习笔记—列表查询,删除条目,更新条目。
1,基于Query语句的列表查询。
function retrieveListItems(itemId) { var siteUrl=_spPageContextInfo.webServerRelativeUrl;
var clientContext = new SP.ClientContext(siteUrl); //列表名一定要用中文 var oList = clientContext.get_web().get_lists().getByTitle('项目信息'); var camlQuery = new SP.CamlQuery(); camlQuery.set_viewXml( '<View><Query><Where><Eq><FieldRef Name=\'ID\'/>' + '<Value Type=\'Number\'>'+itemId+'</Value></Eq></Where></Query>' + '<RowLimit>10</RowLimit></View>' ); this.collListItem = oList.getItems(camlQuery); clientContext.load(collListItem); clientContext.executeQueryAsync( Function.createDelegate(this, this.onQuerySucceeded), Function.createDelegate(this, this.onQueryFailed) ); } function onQuerySucceeded(sender, args) { var listItemInfo = ''; var listItemEnumerator = collListItem.getEnumerator(); while (listItemEnumerator.moveNext()) { var oListItem = listItemEnumerator.get_current(); listItemInfo = oListItem.get_item('Title'); alert(listItemInfo); } } function onQueryFailed(sender, args) { alert('Request failed. ' + args.get_message() + '\n' + args.get_stackTrace()); }
camlQuery.set_viewXml(
'<View><Query>'+
'<Where>'+
'<And>'+
'<Eq>'+
'<FieldRef Name=\'Project\' LookupId=\'TRUE\'/><Value Type=\'Lookup\'>'+projectId+'</Value>' +
'</Eq>'+
'<Eq>'+
'<FieldRef Name=\'AssignedTo\'/><Value Type=\'User\'>'+userName+'</Value>' +
'</Eq>'+
'</And>'+
'</Where></Query>' +
'<RowLimit>10</RowLimit></View>'
);
2,基于ItemId的列表查询
function retrieveListItems(itemId) { var siteUrl=_spPageContextInfo.webServerRelativeUrl; var clientContext = new SP.ClientContext(siteUrl); var oList = clientContext.get_web().get_lists().getByTitle('项目工作项'); this.oListItem = oList.getItemById(itemId); clientContext.load(this.oListItem); clientContext.executeQueryAsync( Function.createDelegate(this, this.onQuerySucceeded), Function.createDelegate(this, this.onQueryFailed) ); } function onQuerySucceeded(sender, args) { alert(this.oListItem.get_item('ID')); } function onQueryFailed(sender, args) { alert('Request failed. ' + args.get_message() + '\n' + args.get_stackTrace()); }
3.根据Id删除条目
function deleteListItem(itemId) { var siteUrl=_spPageContextInfo.webServerRelativeUrl; var clientContext = new SP.ClientContext(siteUrl); var oList = clientContext.get_web().get_lists().getByTitle('项目工作项'); this.oListItem = oList.getItemById(itemId); oListItem.deleteObject(); clientContext.executeQueryAsync( Function.createDelegate(this, this.onQuerySucceeded), Function.createDelegate(this, this.onQueryFailed) ); } function onQuerySucceeded() { alert('删除成功'); //SP.UI.ModalDialog.commonModalDialogClose(0); } function onQueryFailed(sender, args) { alert('Request failed. ' + args.get_message() + '\n' + args.get_stackTrace()); }
4.根据Id更新条目
function updateListItem(itemId,newVersion) { var siteUrl=_spPageContextInfo.webServerRelativeUrl; var clientContext = new SP.ClientContext(siteUrl); var oList = clientContext.get_web().get_lists().getByTitle('项目信息'); this.oListItem = oList.getItemById(itemId); oListItem.set_item('FullVersion',newVersion); oListItem.update(); clientContext.executeQueryAsync(Function.createDelegate(this, this.onUpdateSucceeded), Function.createDelegate(this, this.onUpdateFailed)); } function onUpdateSucceeded() { alert('更新成功!'); } function onUpdateFailed(sender, args) { alert('Request failed. ' + args.get_message() + '\n' + args.get_stackTrace()); }