Moss2007 jQuery调用Webservice获取列表数据 更新数据

寻技术 JQuery 2023年07月11日 123

Moss2007 jQuery调用Webservice获取列表数据 更新数据

1、获取数据如下:

<script type="text/javascript" src="http://jqueryjs.googlecode.com/files/jquery-1.3.2.min.js"></script>

<script type="text/javascript">

//-------------------------异步获取数据
//---------------------------------------------------
$(document).ready(function() {

// Create the SOAP request
// NOTE: we need to be able to display list attachments to users, hence the addition of the
// <queryOptions> element, which necessitated the addition of the <query> element

var soapEnv =
"<soapenv:Envelope xmlns:soapenv='http://schemas.xmlsoap.org/soap/envelope/'> \
<soapenv:Body> \
<GetListItems xmlns='http://schemas.microsoft.com/sharepoint/soap/'> \
<listName>testlist</listName> \
<viewFields> \
<ViewFields> \
<FieldRef Name='Title' /> \
<FieldRef Name='Body' /> \
<FieldRef Name='ID' /> \
<FieldRef Name='Attachments' /> \
</ViewFields> \
</viewFields> \
<query> \
<Query /> \
</query> \
<queryOptions> \
<QueryOptions> \
<IncludeAttachmentUrls>TRUE</IncludeAttachmentUrls> \
</QueryOptions> \
</queryOptions> \
</GetListItems> \
</soapenv:Body> \
</soapenv:Envelope>";

// our basic SOAP code to hammer the Lists web service
$.ajax({
url: "http://yourdomain.net/_vti_bin/lists.asmx",
type: "POST",
dataType: "xml",
data: soapEnv,
// 如果要同步获取数据加上下面这句话,默认为true
// async: false,
error: printError,
complete: processResult,
contentType: "text/xml; charset=\"utf-8\""
});
});

// basic error display that will pop out SOAP errors, very useful!
function printError(XMLHttpRequest, textStatus, errorThrown)
{
alert("There was an error: " + errorThrown + " " + textStatus);
alert(XMLHttpRequest.responseText);
}


// main method that will cycle through the SoAP response nodes
function processResult(xData, status)
{
$(xData.responseXML).find("z\\:row").each(function() {
if ($(this).attr("ows_Title") == null || $(this).attr("ows_Title") == "") {
//TODO
}
else {
//TODO
}
});
}
</script>

2、更新数据如下:

<script type="text/javascript" src="http://jqueryjs.googlecode.com/files/jquery-1.3.2.min.js">

<script type="text/javascript" language="javascript">

function TestMethod(Name) {
var soap = createEnvelope(Name);
var ws = new ActiveXObject("Microsoft.XMLHTTP");
ws.open("POST", "http://yourdomain.net/_vti_bin/lists.asmx", false);
ws.setRequestHeader("Content-Type", "text/xml; charset=utf-8");
ws.setRequestHeader("SOAPAction", "http://schemas.microsoft.com/sharepoint/soap/UpdateListItems");
ws.send(soap);
}

function createEnvelope(Name) {
var soap = '<?xml version=\"1.0\" encoding=\"utf-8\"?>';
soap += '<soap:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope\/\">';
soap += '<soap:Body>';
soap += '<UpdateListItems xmlns="http://schemas.microsoft.com/sharepoint/soap/">';
soap += '<listName>TestList</listName>';

//如果是新建记录Cmd="New" 如果是更新记录Cmd="Update"
soap += '<updates><Batch OnError="Continue"><Method ID="1" Cmd="New"><Field Name="Name">' + Name + '</Field></Method></Batch></updates>';

soap += '</UpdateListItems></soap:Body></soap:Envelope>';

return soap;
}
</script>
关闭

用微信“扫一扫”