记录视图(SPView)

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/**//*是否是默认视图*/);

转载于:https://www.cnblogs.com/QFW/archive/2008/05/22/1204657.html