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.monModalDialogClose(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());}