Skip to content

.NET Server Object Model # Common function

Jack Hu edited this page Aug 15, 2017 · 4 revisions

Get DataTable

 SPQuery query = new SPQuery();
 query.Query = @"<OrderBy><FieldRef Name ='LinkOrder'></FieldRef></OrderBy>";
 SPList list_MainList = ssweb.Lists.TryGetList(PosMainList);
 SPListItemCollection mainCollection = list_MainList.GetItems(query);
 List<string> list_mainCollection = mainCollection.Cast<SPListItem>().OrderBy(x => x.ToStringExtension("LinkOrder")).Select(x => x.ToStringExtension("InternalFieldName")).ToList();
 List<string> fields = new List<string>();
 fields.AddRange(list_mainCollection);

SPListItemCollection items = ssweb.Lists.TryGetList(listName).GetItems(fields.ToArray());
var records = items.GetDataTable().AsEnumerable();
records = records.Where(x => DateTime.Parse(x.Field<string>("Year") + "-" + x.Field<string>("Month")) <= DateTime.Parse(strs[0] + "-" + strs[1]));
DataView dv = records.AsDataView();

return records.AsDataView().ToTable();

Batch Delete

SPWeb ssweb = SPContext.Current.Web;
ssweb.AllowUnsafeUpdates = true;
SPQuery query = new SPQuery();
query.Query = "<Where><Eq><FieldRef Name='ItemGuid' /><Value Type='Text'>" + ItemGuid + "</Value></Eq></Where><OrderBy><FieldRef Name='Modified' Ascending='True' /></OrderBy>";
SPListItemCollection HistoryColls = ServerBuilder.GetListItemCollection(ssweb, History, query, string.Empty);
StringBuilder sbDelete = new StringBuilder();
sbDelete.Append("<?xml version=\"1.0\" encoding=\"UTF-8\"?><Batch>");
foreach (SPListItem i in HistoryColls)
{
   sbDelete.Append("<Method>");
   sbDelete.Append("<SetList Scope=\"Request\">" + i.ParentList.ID + "</SetList>");
   sbDelete.Append("<SetVar Name=\"ID\">" + Convert.ToString(i.ID) + "</SetVar>");
   sbDelete.Append("<SetVar Name=\"Cmd\">Delete</SetVar>");
   sbDelete.Append("</Method>");
}
sbDelete.Append("</Batch>");
ssweb.ProcessBatchData(sbDelete.ToString());

SPDocumentLibrary FilesLib = ssweb.Lists[Files] as SPDocumentLibrary;
string FilesFolderUrl = ssweb.Url + @"/" + FilesLib.Title + @"/";
SPFolder Folder = ssweb.GetFolder(FilesFolderUrl + ItemGuid);
if (Folder != null && Folder.Exists == true)
{
    Folder.Recycle();
}
 ssweb.AllowUnsafeUpdates = false;

User Field

SPFieldUserValueCollection users= (SPFieldUserValueCollection)item[str];
foreach (SPFieldUserValue user in users)
{
   if (user!= null && user.User != null)
   {
       if (user.User.Email != string.Empty)
       {
           string email=user.User.Email;
           string name=user.User.Name;
       }
   }
}

Event Reciever ItemUpdated fired twice

public override void ItemUpdated(SPItemEventProperties properties)
  {  
    //base.ItemUpdated(properties);
    base.EventFiringEnabled = false;
    item.Update();
    base.EventFiringEnabled = true;
  }

Clone this wiki locally