SharePoint 对List提取Field信息

我们知道在SharePoint中, 我们对List 中的Items操作时难免对遇到需要对Items进行排序分页, 或者对数据库进行必要的读取操作;

在以前的程序中我们常常是需要提取Item的某个field时直接到数据库中进行比对,这样的做法是不对的,因为在数据库中对某个field值存放的位置是不定的,所以为了使我们的程序更加健壮,我们需要从List属性中提取field的相对的具体字段;

 

string siteUrl = "http://avepoint-shma:2000"; string listName = "DemoList"; string[] columnsName = new string[] { "column1", "column2", "column3", "column4" }; Dictionary<string, string> dValue = new Dictionary<string, string>(); using (SPSite site = new SPSite(siteUrl)) { using (SPWeb web = site.OpenWeb()) { try { SPList list = web.GetList("Lists/" + listName); if (list.BaseTemplate == SPListTemplateType.GenericList) { XmlDocument xmlDoc = new XmlDocument(); xmlDoc.LoadXml(list.SchemaXml); XmlNode node; foreach (string column in columnsName) { node = xmlDoc.SelectSingleNode("//List//Fields//Field[@Name='" + column + "']"); dValue.Add(column, node.Attributes["ColName"].Value); } } } catch (Exception ex) { } } }

 

这样我们就可以使用dValue这个Dictionary中的键值对对数据库中相应的field进行提取了;

 

 

<List DocTemplateUrl="" DefaultViewUrl="" MobileDefaultViewUrl="" ID="{1C2EA198-A70B-454D-8BB9-65CF25DE2B25}" Title="Announcements" Description="Use the Announcements list to post messages on the home page of your site." ImageUrl="/_layouts/images/itann.png" Name="{1C2EA198-A70B-454D-8BB9-65CF25DE2B25}" BaseType="0" FeatureId="{00BFEA71-D1CE-42DE-9C63-A44004CE0104}" ServerTemplate="104" Created="20091216 07:32:20" Modified="20091216 07:32:20" LastDeleted="20091216 07:32:20" Version="0" Direction="none" ThumbnailSize="0" WebImageWidth="0" WebImageHeight="0" Flags="536875008" ItemCount="1" AnonymousPermMask="0" RootFolder="/Lists/Announcements" ReadSecurity="1" WriteSecurity="1" Author="1073741823" EventSinkAssembly="" EventSinkClass="" EventSinkData="" EmailAlias="" WebFullUrl="/" WebId="3b9bc163-1fd4-45a2-b07a-fb4f513ec6ed" SendToLocation="" ScopeId="5bf3f318-1b9e-4f75-a928-f1cbd4b9ec16" MajorVersionLimit="0" MajorWithMinorVersionsLimit="0" WorkFlowId="00000000-0000-0000-0000-000000000000" HasUniqueScopes="False" NoThrottleListOperations="False" HasRelatedLists="False" AllowDeletion="True" AllowMultiResponses="False" EnableAttachments="True" EnableModeration="False" EnableVersioning="False" HasExternalDataSource="False" Hidden="False" MultipleDataList="False" Ordered="False" ShowUser="True" EnablePeopleSelector="False" EnableResourceSelector="False" EnableMinorVersion="False" RequireCheckout="False" ThrottleListOperations="False" ExcludeFromOfflineClient="False" EnableFolderCreation="False" IrmEnabled="False" IsApplicationList="False" PreserveEmptyValues="False" StrictTypeCoercion="False" EnforceDataValidation="False" MaxItemsPerThrottledOperation="5000"> <Fields> <Field ID="{1d22ea11-1e32-424e-89ab-9fedbadb6ce1}" ColName="tp_ID" RowOrdinal="0" ReadOnly="TRUE" Type="Counter" Name="ID" PrimaryKey="TRUE" DisplayName="ID" SourceID="http://schemas.microsoft.com/sharepoint/v3" StaticName="ID" FromBaseType="TRUE" /> <Field ID="{03e45e84-1992-4d42-9116-26f756012634}" RowOrdinal="0" Type="ContentTypeId" Sealed="TRUE" ReadOnly="TRUE" Hidden="TRUE" DisplayName="Content Type ID" Name="ContentTypeId" DisplaceOnUpgrade="TRUE" SourceID="http://schemas.microsoft.com/sharepoint/v3" StaticName="ContentTypeId" ColName="tp_ContentTypeId" FromBaseType="TRUE" /> <Field ID="{c042a256-787d-4a6f-8a8a-cf6ab767f12d}" Type="Computed" DisplayName="Content Type" ReadOnly="TRUE" Name="ContentType" DisplaceOnUpgrade="TRUE" RenderXMLUsingPattern="TRUE" Sortable="FALSE" SourceID="http://schemas.microsoft.com/sharepoint/v3" StaticName="ContentType" Group="_Hidden" PITarget="MicrosoftWindowsSharePointServices" PIAttribute="ContentTypeID" FromBaseType="TRUE"> <FieldRefs> <FieldRef Name="ContentTypeId" /> </FieldRefs> <DisplayPattern> <MapToContentType> <Column Name="ContentTypeId" /> </MapToContentType> </DisplayPattern> </Field> <Field ID="{fa564e0f-0c70-4ab9-b863-0177e6ddd247}" Type="Text" Name="Title" DisplayName="Title" Required="TRUE" SourceID="http://schemas.microsoft.com/sharepoint/v3" StaticName="Title" FromBaseType="TRUE" ColName="nvarchar1" /> <Field ID="{28cf69c5-fa48-462a-b5cd-27b6f9d2bd5f}" ColName="tp_Modified" RowOrdinal="0" ReadOnly="TRUE" Type="DateTime" Name="Modified" DisplayName="Modified" StorageTZ="TRUE" SourceID="http://schemas.microsoft.com/sharepoint/v3" StaticName="Modified" FromBaseType="TRUE" /> <Field ID="{8c06beca-0777-48f7-91c7-6da68bc07b69}" ColName="tp_Created" RowOrdinal="0" ReadOnly="TRUE" Type="DateTime" Name="Created" DisplayName="Created" StorageTZ="TRUE" SourceID="http://schemas.microsoft.com/sharepoint/v3" StaticName="Created" FromBaseType="TRUE" /> <Field ID="{1df5e554-ec7e-46a6-901d-d85a3881cb18}" ColName="tp_Author" RowOrdinal="0" ReadOnly="TRUE" Type="User" List="UserInfo" Name="Author" DisplayName="Created By" SourceID="http://schemas.microsoft.com/sharepoint/v3" StaticName="Author" FromBaseType="TRUE" /> <Field ID="{d31655d1-1d5b-4511-95a1-7a09e9b75bf2}" ColName="tp_Editor" RowOrdinal="0" ReadOnly="TRUE" Type="User" List="UserInfo" Name="Editor" DisplayName="Modified By" SourceID="http://schemas.microsoft.com/sharepoint/v3" StaticName="Editor" FromBaseType="TRUE" /> <Field ID="{26d0756c-986a-48a7-af35-bf18ab85ff4a}" ColName="tp_HasCopyDestinations" RowOrdinal="0" Sealed="TRUE" Hidden="TRUE" ReadOnly="TRUE" Type="Boolean" Name="_HasCopyDestinations" DisplaceOnUpgrade="TRUE" DisplayName="Has Copy Destinations" SourceID="http://schemas.microsoft.com/sharepoint/v3" StaticName="_HasCopyDestinations" FromBaseType="TRUE" /> . . . <Fields> <List>

 上面是一段List的SchemaXml; 看过这段Xml后相信你会对List中Field管理的理解会更进一步;

 

在提取时我们可以根据需求的不同提取不同的字段, 如DisplayName, 还可以提取到其他别的属性;