sharePoint spsitedataquery

签到信息：姓名，签到时间，签退时间
班次设置：班次名称，开始时间，结束时间
排班设置：姓名，班次名称

 

 

 

 

SPSiteDataQuery siteQuery = new SPSiteDataQuery();

            siteQuery.Webs = "<Webs Scope=\"SiteCollection\" />";

            siteQuery.Lists = string.Format("<Lists><List ID='{0}' /><List ID='{1}' /></Lists>", web.Lists["排班设置"].ID, web.Lists["班次设置"].ID);
            siteQuery.ViewFields = string.Format("<FieldRef Name='{0}' Nullable=\"TRUE\" /><FieldRef Name='{1}' Nullable=\"TRUE\" />",
                web.Lists["排班设置"].Fields["姓名"].InternalName, web.Lists["班次设置"].Fields["开始时间"].InternalName);
           
            siteQuery.RowLimit = 10;
            siteQuery.Query = string.Format("<Where><Eq><FieldRef Name='{0}' /><Value Type='Text'>{1}</Value></Eq></Where>",
                web.Lists["排班设置"].Fields["姓名"].InternalName, "史文彬");

            DataTable dt = web.GetSiteData(siteQuery);

            Console.WriteLine("数据显示开始");
            foreach (DataRow row in dt.Rows)
            {
                Console.WriteLine("=========================================");
                foreach (DataColumn col in dt.Columns)
                {
                    Console.WriteLine(col.ToString()+":"+row[col].ToString());
                }
               Console.WriteLine("=========================================");
            }

            Console.WriteLine("数据显示完毕");
            Console.ReadLine();