SPSite oSiteCollection = SPContext.Current.Site;
SPList oList = oSiteCollection.AllWebs["/"].Lists["testlist2"];
SPQuery oQuery = new SPQuery();
oQuery.Query = "<Where><Gt><FieldRef Name='ProjectedValue'/>" +
"<Value Type='Number'>500</Value></Gt></Where>";
SPListItemCollection collListItems = oList.GetItems(oQuery);
foreach (SPListItem oListItem in collListItems)
{
Label1.Text += "Item: " +
SPEncode.HtmlEncode(oListItem["Title"].ToString()) +
"::" + "Value: " +
oListItem["Investment"].ToString() +
"::" + "Calculated: " +
oListItem["ProjectedValue"].ToString()+
"<BR>";
}
调试这段代码的时候总提示:函数求值需要运行所有线程。是哪里的毛病?
------解决方案--------------------
LZ,ASP.NET里面不能在页面中启动子线程去操作页面的Control。
------解决方案--------------------
/// <summary>
/// 获取员工信息列表
/// </summary>
private void GetEmployeeAll()
{
//获得当前列表
using (SPSite site = new SPSite(SPContext.Current.Site.ID))
{
using (SPWeb web = site.OpenWeb())
{
SPList list = web.Lists["员工信息列表"];
SPQuery Query = new SPQuery();
//获得一个集合,这个集合是包含个人数据相关的一些信息.
SPUser sptest = SPContext.Current.Web.CurrentUser;
try
{
//caml查询 sptest集合的 sptest.LoginName 获得当前用户帐号
Query.Query = string.Format("<Where> <Eq><FieldRef Name='LoginName'/> <Value Type ='Text'>{0}</Value></Eq></Where>", sptest.LoginName);
//得到caml的结果
SPListItemCollection items = list.GetItems(Query);
SPListItem item = null;
if (items != null)
{
item = items[0];
}
}
catch
{
}
}
}
}