3,242
社区成员
发帖
与我相关
我的任务
分享
SPList mylst = web.Lists["个人文档"];
SPList corplst = web.Lists["公司文档"];
SPQuery query = new SPQuery();
query.ViewAttributes = "Scope=/Recursive/";
string now = DateTime.Now.ToString();
query.Query = "<ViewFields><FieldRef Name='FileLeafRef' /><FieldRef Name='FileSizeDisplay' /></ViewFields>" +
"<Where><And><And><Leq><FieldRef Name='PublishingStartDate' /><Value Type='PublishingScheduleStartDateFieldType'>" + now + "</Value></Leq>" +
"<Geq><FieldRef Name='PublishingExpirationDate' /><Value Type='PublishingScheduleEndDateFieldType'>" + now + "</Value></Geq></And>" +
"<Eq><FieldRef Name='FSObjType' /><Value Type='Integer'>0</Value></Eq></And></Where>" +
"<QueryOptions><ViewAttributes Scope='RecursiveAll' /></QueryOptions>";
SPListItemCollection myitems = mylst.GetItems(query);
foreach (SPListItem item in myitems)
{
sizes += Math.Round(Convert.ToDecimal(item["FileSizeDisplay"]) / (1024 * 1024), 2);
sizes += Math.Round(Convert.ToDecimal(item.File.Length) / (1024 * 1024), 2);
}