Skip to content

.NET Server Object Model # Common function

Jack Hu edited this page Aug 17, 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;
  }

//In Document library event handlers during Item Updating also checking that Document is it in Check In mode or Check Out. That's why it is called twice.

 public override void ItemUpdating(SPItemEventProperties properties)
  {  
    base.ItemUpdating(properties);
    if (properties.AfterProperties["vti_sourcecontrolcheckedoutby"] == null && 
        properties.BeforeProperties["vti_sourcecontrolcheckedoutby"] != null)
     {
       //do stuff
     }
  }

Change password webpart

http://www.cnblogs.com/batter152/p/4863364.html

Clone this wiki locally