//
首先获取到SPWeb对象web
SPListCollection lists = web.Lists;
SPList scoreList = lists[ " Score " ];
SPList passList = lists[ " Pass " ];
SPQuery query = new SPQuery();
query.Query = " <Where><Geq><FieldRef Name='Score'/> " +
" <Value Type='Number'>60</Value></Geq></Where> " ;
SPListItemCollection items = scoreList.GetItems(query);
foreach (SPListItem item in items)
{
string title = item["Title"] + "(合格)";
item["Title"] = title;
item.Update();
}
SPListItem newItem = passList.Items.Add();
newItem[ " Count " ] = items.Count;
newItem.Update();
SPListCollection lists = web.Lists;
SPList scoreList = lists[ " Score " ];
SPList passList = lists[ " Pass " ];
SPQuery query = new SPQuery();
query.Query = " <Where><Geq><FieldRef Name='Score'/> " +
" <Value Type='Number'>60</Value></Geq></Where> " ;
SPListItemCollection items = scoreList.GetItems(query);
foreach (SPListItem item in items)
{
string title = item["Title"] + "(合格)";
item["Title"] = title;
item.Update();
}
SPListItem newItem = passList.Items.Add();
newItem[ " Count " ] = items.Count;
newItem.Update();