SPViewCollection views = SPList.Views;
string viewName = "最近两周更新的任务";
System.Collections.Specialized.StringCollection viewFields = new System.Collections.Specialized.StringCollection();
viewFields.Add("任务名称");
viewFields.Add("部门");
viewFields.Add("计划完成时间");
viewFields.Add("任务创建人");
viewFields.Add("任务执行人");
string strADAccount = SPWeb.Site.RootWeb.SiteUsers.GetByID(CurrentUser.ID).LoginName;
string strDept = HRCommon.GetDepartmentByAdAccount(strADAccount)[0];
DateTime dtStart = Common.GetWeekForStart(DateTime.Now);
DateTime dtEnd = Common.GetWeekForEnd(DateTime.Now).AddDays(7);
string query =
@"<Where>
<And>
<And>
<And>
<Or>
<Neq>
<FieldRef Name=""_x5b8c__x6210__x6807__x5fd7_"" />
<Value Type=""Choice"">已撤销</Value>
</Neq>
<Neq>
<FieldRef Name=""_x5b8c__x6210__x6807__x5fd7_"" />
<Value Type=""Choice"">已关闭</Value>
</Neq>
</Or>
<Eq>
<FieldRef Name=""_x90e8__x95e8_"" />
<Value Type=""Text"">{0}</Value>
</Eq>
</And>
<Geq>
<FieldRef Name=""Modified"" />
<Value Type=""DateTime"">{1}</Value>
</Geq>
</And>
<Leq>
<FieldRef Name=""Modified"" />
<Value Type=""DateTime"">{2}</Value>
</Leq>
</And>
</Where>
<OrderBy>
<FieldRef Name=""Modified"" Ascending=""False"" />
</OrderBy>";
views.Add(viewName, viewFields, string.Format(query, strDept, dtStart, dtEnd), 100, true/*是否支持分页*/, false/*是否是默认视图*/);
views.Add(viewName, viewFields,
浙公网安备 33010602011771号