public SPListInstance GetListByGuid(object guid, object fetchMetadata, object fetchSecurityData, object fetchRelatedFields)
{
var guidInstance = GuidInstance.ConvertFromJsObjectToGuid(guid);
SPList list;
if (fetchMetadata != Undefined.Value && fetchSecurityData == Undefined.Value &&
fetchRelatedFields == Undefined.Value)
{
list = m_listCollection.GetList(guidInstance, TypeConverter.ToBoolean(fetchMetadata));
}
else if (fetchMetadata != Undefined.Value && fetchSecurityData != Undefined.Value &&
fetchRelatedFields == Undefined.Value)
{
list = m_listCollection.GetList(guidInstance, TypeConverter.ToBoolean(fetchMetadata), TypeConverter.ToBoolean(fetchSecurityData));
}
else if (fetchMetadata != Undefined.Value && fetchSecurityData != Undefined.Value &&
fetchRelatedFields != Undefined.Value)
{
list = m_listCollection.GetList(guidInstance, TypeConverter.ToBoolean(fetchMetadata), TypeConverter.ToBoolean(fetchSecurityData), TypeConverter.ToBoolean(fetchRelatedFields));
}
else
{
list = m_listCollection[guidInstance];
}
if (list == null)
{
return(null);
}
return(new SPListInstance(this.Engine, null, null, list));
}
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();
}
}
}
}
}
// in this case we're not using the spweb in the base class in fact we're passing it as a parameter
public void CreateList(SPWeb currentWebSite)
{
SPWeb website = null;
try
{
website = currentWebSite ?? GetWebSite();
website.AllowUnsafeUpdates = true;
SPListCollection lists = website.Lists;
Guid idList = lists.Add(ListName, string.Empty, SPListTemplateType.GenericList);
SPList list = lists.GetList(idList, false);
list.NoCrawl = true;
list.Update();
website.AllowUnsafeUpdates = false;
}
catch (Exception ex)
{
var log = new AppEventLog(AppException.ExceptionMessage(ex, "CreateList", "ClsHelper"));
log.WriteToLog();
}
finally
{
if (website != null)
{
website.Dispose();
}
}
}
public string GetListUrl(string listId)
{
Guid listGuid = new Guid(listId);
SPList list = null;
SPListCollection lists = null;
using (SPWeb site = SPContext.Current.Site.RootWeb)
{
// Look for the list in the root site.
lists = site.Lists;
for (int i = 0; i < lists.Count; i++)
{
if (lists[i].ID == listGuid)
{
list = lists.GetList(listGuid, false);
siteUrl = list.ParentWebUrl;
return(list.RootFolder.ServerRelativeUrl);
}
}
// If the list is not in the root site, look in the subsites.
foreach (SPWeb subSite in site.GetSubwebsForCurrentUser())
{
try
{
lists = subSite.Lists;
for (int i = 0; i < lists.Count; i++)
{
if (lists[i].ID == listGuid)
{
list = lists.GetList(listGuid, false);
siteUrl = list.ParentWebUrl;
return(list.RootFolder.ServerRelativeUrl);
}
}
}
finally
{
if (subSite != null)
{
subSite.Dispose();
}
}
}
}
return("");
}
/// <summary>
/// 创建列表"workVideo" "workPic", "workFile"
/// </summary>
public static SPList CreateList(string listName)
{
SPListCollection col = DAL.Common.SPWeb.Lists;
Guid guid;
if (listName == "workPic")
{
guid = col.Add(listName, "", SPListTemplateType.PictureLibrary);
}
else
{
guid = col.Add(listName, "", SPListTemplateType.DocumentLibrary);
}
SPList list = col.GetList(guid, false);
list.Hidden = true;
list.Update();
return(list);
}
/// <summary>
/// Gets the required lists.
/// </summary>
/// <param name="spListCollection">The sp list collection.</param>
/// <param name="dhbField">The DHB field.</param>
/// <param name="holidaysList">The holidays list.</param>
/// <param name="holidaySchedulesList">The holiday schedules list.</param>
/// <param name="resourcesList">The resources list.</param>
/// <param name="workHoursList">The work hours list.</param>
private static void GetRequiredLists(SPListCollection spListCollection, DaysHoursBreakdownField dhbField,
out SPList holidaysList, out SPList holidaySchedulesList,
out SPList resourcesList, out SPList workHoursList)
{
holidaySchedulesList = null;
resourcesList = spListCollection[dhbField.ResourcePoolList];
if (resourcesList == null)
{
throw new Exception("Cannot find the Resources list.");
}
workHoursList = spListCollection[dhbField.WorkHoursList];
if (workHoursList == null)
{
throw new Exception("Cannot find the WorkHours list.");
}
holidaysList = spListCollection[dhbField.HolidaysList];
if (holidaysList == null)
{
throw new Exception("Cannot find the Holidays list.");
}
SPField holidaySchedulesField = holidaysList.Fields.GetFieldByInternalName(dhbField.HolidaySchedulesField);
if (holidaySchedulesField != null)
{
holidaySchedulesList =
spListCollection.GetList(new Guid(((SPFieldLookup)holidaySchedulesField).LookupList), false);
}
if (holidaySchedulesList == null)
{
throw new Exception("Cannot find the Holiday Schedules list.");
}
}
