几个开源的CAML生成类

作者：柒月

之前，我们介绍了LINQ to SharePoint。

本着“我不造轮子，我只做轮子的搬运工”的人生目标，接下来，我们一起看一看几位大神编写的CAML生成类。同样，它使开发者无需关心CAML语句如何编写，而更专注于业务逻辑的实现，并且看起来更加轻巧、灵活。

CAML.NET

引用：http://camldotnet.codeplex.com/

例：

string typeName = "My Content Type";
string simpleQuery =
    CAML.Query(
        CAML.Where(
            CAML.Or(
                CAML.Eq(
                    CAML.FieldRef("ContentType"), 
                    CAML.Value(typeName)),
                CAML.IsNotNull(
                    CAML.FieldRef("Description")))),
        CAML.GroupBy(
            true,
            CAML.FieldRef("Title",CAML.SortType.Descending)),
        CAML.OrderBy(
            CAML.FieldRef("_Author"),
            CAML.FieldRef("AuthoringDate"),
            CAML.FieldRef("AssignedTo",CAML.SortType.Ascending))
    );

生成的CAML：

   
      
         
            
            My Content Type
         
         
            
         
      
   
   
      
   
   
      
      
      
   

Camlex.NET

引用：http://camlex.codeplex.com/

例：

var caml =
    Camlex.Query()
        .Where(x => (int)x["ProductID"] == 1000 && ((bool)x["IsCompleted"] == false || x["IsCompleted"] == null))
            .ToString();

生成的CAML：

  
    
      
      1000
    
    
      
        
        0
      
      
        
      
    
  

Caml Query

引用：https://camlquery.codeplex.com/

例：

SPSite site = new SPSite("http://jyserver:81");

SPList list = site.RootWeb.Lists"Notice";

QueryField field1 = new QueryField("标题", false); //the second parameter explain if the first parameter is a internal name.
//or : QueryField field1 = new QueryField("Title"); //"Title" is internal name. 
//DateTime type field
TypedQueryField field2 = new TypedQueryField("Expires");

CamlExpression expr = field1.Contains("Test1") && field2 >= DateTime.Now.AddDays(-1);
SPListItemCollection items =
ListQuery
.From(list)
.Where(expr)
.GetItems();

生成的CAML:

  
    
      
      Test1
    
    
      
      2015-07-08T21:43:45Z
    
  

CAML Builder

引用：http://blog.163.com/chinaren_bjr/blog/static/16989137201251010335793/

例：

Query = CAMLBuilder.BuildQuery(
        new CAMLBuilder.WhereBuilder("Title", "Text", "测试", OperationSymbol.BeginsWith).And("Author", "User", "张三")), 
        new CAMLBuilder.OrderBuilder("Created", false))

生成的CAML:

  
    
      
       测试
    
     
      
       张三