public void getRecords(string siteUrl, Guid listGuid, int itemId)
{
using (SPSite spsite = new SPSite(siteUrl))
{
using (SPWeb spweb = spsite.OpenWeb(siteUrl))
{
SPListCollection colllists = spweb.Lists;
SPList parentlist = colllists.GetList(listGuid, true);
string parentlistTitle = parentlist.Title.ToString(); //父列表标题
string childlistTitle = parentlistTitle + "业绩"; //子列表标题
SPList childlist = colllists.TryGetList(childlistTitle);
if (childlist != null)
{
SPQuery qry = new SPQuery();
qry.Query = "<Where><Eq><FieldRef Name='Dept' LookupId='True' /><Value Type='Lookup'>" + itemId + "</Value></Eq></Where>";
SPListItemCollection listItems = childlist.GetItems(qry);
if (listItems.Count > 0)
{
DataTable dt = listItems.GetDataTable();
}
}
}
}
}
/// <summary>
/// 读取创意列表生成创意DataTable数据源
/// </summary>
/// <param name="lstName"></param>
/// <returns></returns>
private DataTable getDataBySPList(string lstName)
{
DataTable dt = new DataTable("创意表");
using (SPSite site = SPContext.Current.Site)
{
using (SPWeb web = site.OpenWeb(SPContext.Current.Web.ID))
{
SPListCollection lstColl = web.Lists;
SPList lst = lstColl.TryGetList(lstName);
if (lst != null)
{
SPQuery qry = new SPQuery();
qry.Query = @"<Where><Eq><FieldRef Name='Flag0' /><Value Type='Number'>1</Value></Eq></Where>";
SPListItemCollection lstItems = lst.GetItems(qry);
if (lst.ItemCount > 0)
{
dt = lstItems.GetDataTable();
}
else
{
dt = null;
}
}
}
}
return(dt);
}
public SPListInstance TryGetList(string listName)
{
var list = m_listCollection.TryGetList(listName);
if (list == null)
{
return(null);
}
return(new SPListInstance(this.Engine, null, null, list));
}
