sharepoint caml语句查询列表视图，根据人员ID匹配

最新推荐文章于 2019-08-08 04:13:38 发布

yl_99

最新推荐文章于 2019-08-08 04:13:38 发布

阅读量2.2k

点赞数

分类专栏： sharepoint 学习札记

本文链接：https://blog.csdn.net/yl_99/article/details/12570995

版权

sharepoint 学习札记专栏收录该内容

127 篇文章 0 订阅

订阅专栏

using (SPSite site = new SPSite("http://localhost:xxxx"))
            {
                using (SPWeb web = site.OpenWeb())
                {

                    SPQuery query = new SPQuery();
                    SPList oList = web.Lists["FlyingTask"];
                    SPView oView = oList.Views["FlyingTodoTask"];
                    SPUser user = web.CurrentUser;

                    oView.Query = @"<Where>
                                      <And>

                                         <Eq>
                                            <FieldRef Name='AssignedTo' LookupId='TRUE'/>　
　　　　　　                                <Value Type='Text'>" + user.ID+ @"</Value>　

                                         </Eq>

                                      </And>
                                   </Where>";
                    //oView.Update(); //修改视图

                    query.Query = @"<Where>
                                         <Eq>
                                            <FieldRef Name='AssignedTo' LookupId='TRUE' />
                                            <Value Type='Text'>>" + user.ID+ @"</Value>

                                         </Eq>
                                   </Where>";

SPListItemCollection items = oList.GetItems(query, oView.ID.ToString("B").ToUpper());

                    //只是输出格式；
                    //Guid.NewGuid.ToString("n") ="4546a166b64746f784099789ec8f8324"
                    //Guid.NewGuid.ToString("b")="{4546a166-b647-46f7-8409-9789ec8f8324}"
                    //Guid.NewGuid.ToString("d")="4546a166-b647-46f7-8409-9789ec8f8324"
                    //Guid.NewGuid.ToString("p")="(4546a166-b647-46f7-8409-9789ec8f8324)"

                    Console.WriteLine(items.Count);
                    Console.ReadLine();

}
}

//SPView oView = oweb.GetViewFromUrl("Lists/List_Name/View_Name.aspx");
                            //SPView view2 = web2.GetViewFromUrl("http://localhost:XXXX/sites/site01/shared/Documents/Forms/AllItems.aspx");
                            //string currentUrl = web2.Url + "/Lists/MRBReport/MRBEmailView.aspx";
                            //SPView viewMonthly = web2.Lists["WeeklyReport"].Views["Monthly Report"];
                            SPView currentView = web2.GetViewFromUrl(Request.Url.AbsoluteUri);

MRBReport-batchQuery.ascx 多条件动态组合，通过修改视图实现批量查询