1) Take instance of your site collection and web:
SPSite currentSite = SPContext.Current.Site;
SPWeb currentRootWeb = currentSite.RootWeb;
2) Suppose we have the name of discussion list - "MyDiscussionList".
Get GUID of this list:
Guid myDiscussionListGUID = Guid.NewGuid();
foreach (SPList list in currentRootWeb.Lists)
{
if (list.BaseTemplate.ToString() == "DiscussionBoard" && list.Title == "MyDiscussionList")
{
myDiscussionListGUID = list.ID; // Read GUID of Discussion List
break;
}
}
Tips:
a) list.ItemCount will return all discussions and their replies
b) list.Items.Count will return only replies
3) Get your list:
SPList myDiscussionList = currentRootWeb.Lists.GetList(myDiscussionListGUID, false);
4) Create a new Discussion:
SPListItem newItem = SPUtility.CreateNewDiscussion(myDiscussionList.Items, "New Message using code");
newItem["Body"] = "My new message content using code";
newItem.Update();
5) How to read all discussions:
foreach (SPListItem folder in myDiscussionList.Folders)
{
Response.Write("Folder Name: " + folder.Name + "<BR>");
Response.Write("Folder ID: " + folder.ID + "<BR>");
Response.Write("Attachments Count: " + folder.Attachments.Count + "<BR>"); // Returns attachment count
// Code to read attachment URL.
for (int i = 0; i < folder.Attachments.Count; i++)
{
Response.Write("Attachment Url " + folder.Attachments.UrlPrefix + folder.Attachments + "<BR>");
}
// Read body of attachment
Response.Write("Body: " + folder.Fields["Body"].GetFieldValueAsText(folder["Body"]) + "<BR>");
}
6) If you want to delete a discussion:
SPListItem listItemParentToDelete = null;
foreach (SPListItem folder in myDiscussionList.Folders)
{
listItemParentToDelete = folder;
}
if (listItemParentToDelete != null)
{
listItemParentToDelete.Delete();
}
7) Loop through all discussion replies:
foreach (SPListItem listItem in myDiscussionList.Items)
{
Response.Write("Item DisplayName: " + listItem.DisplayName + "<BR>"); // Returns Title of Discussion
Response.Write("List ID: " + listItem.ID + "<BR>");
Response.Write("List Folder ID: " + listItem.Fields["Parent Folder Id"].GetFieldValueAsText(listItem["Parent Folder Id"]).ToString() + "<BR>"); // Returns ID of Parent Discussion
Response.Write("Body: " + listItem.Fields["Body"].GetFieldValueAsText(listItem["Body"]) + "<BR>");
// Create Parent List Item
int parentListID = Convert.ToInt32(listItem.Fields["Parent Folder Id"].GetFieldValueAsText(listItem["Parent Folder Id"]));
SPListItem parentListItem = lvContentItemsDiscussionsList.GetItemById(parentListID);
Response.Write("Parent List Item Name: " + parentListItem.Name + "<BR>");
// Code to Reply to a Discussion Message
SPListItem reply = SPUtility.CreateNewDiscussionReply(parentListItem);
reply["Body"] = "<div class=ExternalClass89C47CD7892B4279A8F42A65DD63AE3A><div> </div> <div>Reply to the new message<br><br> <hr> <b>From: </b>Admin<br><b>Posted: </b>Friday, July 20, 2007 4:01 AM<br><b>Subject: </b>New message<br><br> <div class=ExternalClass3D04672E599B486F9ECB76C138494708> <div>My new message content</div></div></div></div>";
reply["TrimmedBody"] = "<div class=ExternalClass677134B4EA284660B1B236824800345C><div> </div> <div>Reply to the new message<br></div></div>";
reply.Update();
// Code to delete a discussion reply
listItemToDelete = listItem;
}
8) Code to delete a discussion reply:
SPListItem listItemToDelete = null;
foreach (SPListItem listItem in myDiscussionList.Items)
{
listItemToDelete = listItem;
}
// Code to delete a discussion reply
if (listItemToDelete != null)
{
listItemToDelete.Delete();
}
Note: You need to allow unsafe updates in order to do any operation on SharePoint list directly.
currentRootWeb.AllowUnsafeUpdates = true;
原帖地址：http://www.beyondweblogs.com/post/SharePoint-Discussion-Board-Common-Operations-through-Code.aspx
