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)); }