MOSS对象模型之：SPList

首先让我们看看MOSS2007整个对象模型架构

 

从最内层开始出发

   SPListItem 创建Item，这里需要注意的一点是这里的name参数需要用internal names

   

 SPListItem item = list.Items.Add();
 item["Title"] = "Ann Simms";
 item["First_x0020_Name"] = "Ann";
 item["Last_x0020_Name"] = "Simms";
 item["EmailAddress"] ="annsimms@adventureworks.com";
  item.Update();

 

  SPListItemCollection 获取List的列表项的集合，具体方法为

 

list.Items.GetDataTalbe();

 

  SpQuery 结合CAML 查询制定列表或者站点下某一类列表项

  1.制定列表下

  

 SPWeb web = SPContext.Current.Web;
 SPList list = web.Lists[“Announcements”];
 SPQuery query = new SPQuery();
 string date = SPUtility.CreateISO8601DateTimeFromSystemDateTime(DateTime.Today);
 qry.Query = "<OrderBy><FieldRef Name='Title' /></OrderBy>" +
       "<Where><Geq><FieldRef Name='Created' />" +
        "<Value Type='DateTime'>" + date + "</Value></Geq></Where>";        
  SPListItemCollection results = list.GetItems(query);
 

 

  2.站点下某一类列表

 

 

 1 SPWeb web = SPContext.Current.Web;
 2 SPSiteDataQuery qry = new SPSiteDataQuery();
 3 string date = SPUtility.CreateISO8601DateTimeFromSystemDateTime(DateTime.Today);
 4 qry.Query = "<OrderBy><FieldRef Name='Title' /></OrderBy>" +
 5       "<Where><Geq><FieldRef Name='Created' />" +
 6        "<Value Type='DateTime'>" + date + "</Value></Geq></Where>";        
 7 qry.Lists = "<Lists ServerTemplate='101' />";
 8 qry.ViewFields = "<FieldRef Name='Title' />";
 9 qry.Webs = "<Webs Scope='SiteCollection' />";
  DataTable tbl = web.GetSiteData(qry);
 

 

这里的ServerTemplate="101" 101表示查找的为普通list列表

 

 

对文档库的部分操作

文档库之间文件的拷贝，做了个简单的Demo

 

 1 using (SPSite site = new SPSite("http://cpu/"))
 2             {
 3                 try
 4                 {
 5 
 6                     //拷贝
 7                        SPWeb web = site.RootWeb;
 8                     //SPDocumentLibrary doclib = (SPDocumentLibrary)web.Lists["共享文档"];
 9                
                     SPFile document = web.GetFile("DOC1/role.txt");
                     document.CopyTo("http://cpu/Execel/role.txt", true);
 
                     Console.WriteLine("It's OK");
                 }
 
                 catch (Exception ex)
                 {
                     Console.WriteLine(ex.Message);
                 }
 
                 finally
                 {
                     Console.ReadLine();
                 }
             }

 

文档库新增文件以及文档库文件的转移

 

 

 1    using (SPSite site = new SPSite("http://cpu/"))
 2                 {
 3                     try
 4                     {
 5                         //新增
 6                         SPWeb web = site.RootWeb;
 7                         SPList list = web.Lists["共享文档"];
 8 
 9                         SPFile document = web.GetFile("Execel/5.gif");
                         SPFile newdoc = list.RootFolder.Files.Add
                            (list.RootFolder.Url + "/" + document.Name,
                             document.OpenBinary(), document.Author,
                             document.ModifiedBy, document.TimeCreated,
                             document.TimeLastModified);
                         list.Update();
 
                         //移动到
                         document.MoveTo("http://cpu/DOC1/5.gif", true);
 
 
                     }
 
                     catch (Exception ex)
                     {
                         Console.WriteLine(ex.Message);
                     }
                     finally
                     {
                         Console.ReadLine();
                     }
                  }

 

在网上看到个遍历文档库下所有文件的方法，感觉比较不错，这里收下共享出来

 

 1 //调用
 2           SPWeb web = site.RootWeb;
 3           SPDocumentLibrary doclib = (SPDocumentLibrary)web.Lists["共享文档"];
 4           doclib.Lists.IncludeRootFolder = true;
 5           GoThroughDocLib(doclib, doclib.RootFolder, 0);
 6 //方法
 7 static void GoThroughDocLib(SPDocumentLibrary doclib, SPFolder folder, int level)
 8         {
 9             SPListItemCollection items = doclib.GetItemsInFolder(doclib.DefaultView, folder);
             if (items.Count == 0)
                 return;
 
             for (int i = 0; i < level; i++)
                 Console.Write("  ");
             foreach (SPListItem item in items)
             {
                 if (item.FileSystemObjectType == SPFileSystemObjectType.Folder)
                 {
                     Console.WriteLine("[{0}]", item.Name);
                     GoThroughDocLib(doclib, item.Folder, level + 1);
                 }
                 else
                     Console.WriteLine(item.Name);
             }
         }

 

 关于获取文档库信息的一些对象，这个帖子感觉比较全面Item