public static string updListaSDC(string lstSDC, string regs, string UserName, string Password)
{
ListsWebSrv.Lists listService = retListWebSrv(UserName, Password);
//
System.Xml.XmlNode ndListView = listService.GetListAndView(lstSDC, "");
string strListID = ndListView.ChildNodes[0].Attributes["Name"].Value;
string strViewID = ndListView.ChildNodes[1].Attributes["Name"].Value;
//
System.Xml.XmlDocument doc = new System.Xml.XmlDocument();
System.Xml.XmlElement batchElement = doc.CreateElement("Batch");
batchElement.SetAttribute("OnError", "Continue");
batchElement.SetAttribute("ListVersion", "1");
batchElement.SetAttribute("ViewName", strViewID);
batchElement.InnerXml = regs; //"<Method ID='0' Cmd='New'><Field Name='Title'>Added item</Field></Method>";
try
{
XmlNode nodeListItems = listService.UpdateListItems(strListID, batchElement);
var owsID = nodeListItems.SelectSingleNode("//@ows_ID").Value;
//
return(owsID);
}
catch (Exception)
{
return("-1");
}
}
public static string UploadAttachment(string UserName, string Password, string filePath, string listName, string listItemId)
{
ListsWebSrv.Lists listService = retListWebSrv(UserName, Password);
//
var fileName = System.IO.Path.GetFileName(filePath);
var fileContent = System.IO.File.ReadAllBytes(filePath);
return(listService.AddAttachment(listName, listItemId, fileName, fileContent));
}
private static ListsWebSrv.Lists retListWebSrv(string UserName, string Password)
{
// Seta o nome e atributos da lista...
//
ListsWebSrv.Lists listService = new ListsWebSrv.Lists();
listService.Credentials = System.Net.CredentialCache.DefaultCredentials;
listService.Url = "http://sts237wk8/sites/SDU/_vti_bin/Lists.asmx";
listService.Credentials = new System.Net.NetworkCredential(UserName.Substring((UserName.IndexOf("\\") + 1)), Password, UserName.Substring(0, UserName.IndexOf("\\")));
//
return(listService);
}
public static DataTable retDtListaSDC(string lstSDC, string qryINN, string UserName, string Password)
{
try
{
ListsWebSrv.Lists listService = retListWebSrv(UserName, Password);
//
System.Xml.XmlNode ndListView = listService.GetListAndView(lstSDC, "");
string strListID = ndListView.ChildNodes[0].Attributes["Name"].Value;
string strViewID = ndListView.ChildNodes[1].Attributes["Name"].Value;
//
System.Xml.XmlDocument xmlDoc = new System.Xml.XmlDocument();
string rowLimit = "25000";
System.Xml.XmlElement query = xmlDoc.CreateElement("Query");
System.Xml.XmlElement viewFields = xmlDoc.CreateElement("ViewFields");
System.Xml.XmlElement queryOptions = xmlDoc.CreateElement("QueryOptions");
// Seta os filtros enviados pelas interfaces...
//
if (qryINN == "")
{
query.InnerXml = "<Where><Or><IsNull> <FieldRef Name='Title' /></IsNull><IsNotNull><FieldRef Name='Title' /></IsNotNull></Or></Where>";
}
else
{
query.InnerXml = qryINN;
}
// Chama a rotina para converter os campos numa DataTable...
//
XmlNode nodeListItems = listService.GetListItems(lstSDC, strViewID, query, viewFields, rowLimit, queryOptions, null);
return(XmlNodeToDataTable(nodeListItems));
}
catch (Exception e)
{
Console.WriteLine("|!| retDtListaSDC Error - " + e.Message);
return(null);
}
} //OK MPS - 04/11/2014
