public static List<EmailListItem> GetAllEmailListItems(SPWeb web) { SPList list = Utility.GetListFromURL(Constants.EMAIL_LIST_URL, web); if (list == null) return null; CAMLListQuery<EmailListItem> query = new CAMLListQuery<EmailListItem>(list); return query.ExecuteListQuery(string.Empty); }
public static List <Model.Entities.NewsItem> GetNewsByCategory(SPList list, int itemCount, string pagingInfo, out SPListItemCollection collection) { CAMLListQuery <NewsItem> query = new CAMLListQuery <NewsItem>(list); string caml = string.Empty; caml = Camlex.Query() .Where(x => x[SPBuiltInFieldId._ModerationStatus] == (DataTypes.ModStat) "0") .OrderBy(x => x[SPBuiltInFieldId.Created] as Camlex.Desc) .ToString(); return(query.ExecuteListQuery(caml, itemCount, pagingInfo, out collection)); }
public static List <Model.Entities.NewsItem> GetOtherNews(SPList list, int exceptId, int itemCount) { CAMLListQuery <NewsItem> query = new CAMLListQuery <NewsItem>(list); string caml = string.Empty; caml = Camlex.Query() .Where(x => (int)x[SPBuiltInFieldId.ID] != exceptId && x[SPBuiltInFieldId._ModerationStatus] == (DataTypes.ModStat) "0") .OrderBy(x => x[SPBuiltInFieldId.Created] as Camlex.Desc) .ToString(); return(query.ExecuteListQuery(caml, itemCount)); }
public static Model.Entities.NewsItem GetLatestNewsInCategory(SPList list) { CAMLListQuery <NewsItem> query = new CAMLListQuery <NewsItem>(list); string caml = string.Empty; caml = Camlex.Query() .Where(x => x[SPBuiltInFieldId._ModerationStatus] == (DataTypes.ModStat) "0") .OrderBy(x => x[SPBuiltInFieldId.Created] as Camlex.Desc) .ToString(); return(query.ExecuteListQuery(caml, 1).FirstOrDefault()); }
//public static List<Model.Entities.NewsItem> GetLastestNews(SPWeb web, int itemCount, bool hotNewsOnly) //{ // CAMLSiteQuery<NewsItem> query = new CAMLSiteQuery<NewsItem>(ListTemplateIds.NEWS_TEMPLATE_ID, web); // string caml = string.Empty; // if (hotNewsOnly) // { // var orderByList = new List<Expression<Func<SPListItem, object>>>(); // orderByList.Add(x => x["OrderNumber"] as Camlex.Asc); // orderByList.Add(x => x[SPBuiltInFieldId.Created] as Camlex.Desc); // caml = Camlex.Query() // .Where(x => (bool)x["IsHotNews"] == true && // x[SPBuiltInFieldId._ModerationStatus] == (DataTypes.ModStat)"0") // .OrderBy(x => x["OrderNumber"] as Camlex.Desc) // .ToString(); // } // return query.ExecuteListQuery(caml, itemCount); //} public static List<Model.Entities.NewsItem> GetLastestNews(SPList list, int itemCount, bool hotNewsOnly) { CAMLListQuery<NewsItem> query = new CAMLListQuery<NewsItem>(list); string caml = string.Empty; if (hotNewsOnly) { var orderByList = new List<Expression<Func<SPListItem, object>>>(); orderByList.Add(x => x["OrderNumber"] as Camlex.Asc); orderByList.Add(x => x[SPBuiltInFieldId.Created] as Camlex.Desc); caml = Camlex.Query() .Where(x => (bool)x["IsHotNews"] == true && x[SPBuiltInFieldId._ModerationStatus] == (DataTypes.ModStat)"0") .OrderBy(x => x["OrderNumber"] as Camlex.Desc) .ToString(); } return query.ExecuteListQuery(caml, itemCount); }
//public static List<Model.Entities.NewsItem> GetLastestNews(SPWeb web, int itemCount, bool hotNewsOnly) //{ // CAMLSiteQuery<NewsItem> query = new CAMLSiteQuery<NewsItem>(ListTemplateIds.NEWS_TEMPLATE_ID, web); // string caml = string.Empty; // if (hotNewsOnly) // { // var orderByList = new List<Expression<Func<SPListItem, object>>>(); // orderByList.Add(x => x["OrderNumber"] as Camlex.Asc); // orderByList.Add(x => x[SPBuiltInFieldId.Created] as Camlex.Desc); // caml = Camlex.Query() // .Where(x => (bool)x["IsHotNews"] == true && // x[SPBuiltInFieldId._ModerationStatus] == (DataTypes.ModStat)"0") // .OrderBy(x => x["OrderNumber"] as Camlex.Desc) // .ToString(); // } // return query.ExecuteListQuery(caml, itemCount); //} public static List <Model.Entities.NewsItem> GetLastestNews(SPList list, int itemCount, bool hotNewsOnly) { CAMLListQuery <NewsItem> query = new CAMLListQuery <NewsItem>(list); string caml = string.Empty; if (hotNewsOnly) { var orderByList = new List <Expression <Func <SPListItem, object> > >(); orderByList.Add(x => x["OrderNumber"] as Camlex.Asc); orderByList.Add(x => x[SPBuiltInFieldId.Created] as Camlex.Desc); caml = Camlex.Query() .Where(x => (bool)x["IsHotNews"] == true && x[SPBuiltInFieldId._ModerationStatus] == (DataTypes.ModStat) "0") .OrderBy(x => x["OrderNumber"] as Camlex.Desc) .ToString(); } return(query.ExecuteListQuery(caml, itemCount)); }
public static Model.Entities.NewsItem GetLatestNewsInCategory(SPList list) { CAMLListQuery<NewsItem> query = new CAMLListQuery<NewsItem>(list); string caml = string.Empty; caml = Camlex.Query() .Where(x => x[SPBuiltInFieldId._ModerationStatus] == (DataTypes.ModStat)"0") .OrderBy(x => x[SPBuiltInFieldId.Created] as Camlex.Desc) .ToString(); return query.ExecuteListQuery(caml, 1).FirstOrDefault(); }
public static List<Model.Entities.NewsItem> GetOtherNews(SPList list, int exceptId, int itemCount) { CAMLListQuery<NewsItem> query = new CAMLListQuery<NewsItem>(list); string caml = string.Empty; caml = Camlex.Query() .Where(x => (int)x[SPBuiltInFieldId.ID] != exceptId && x[SPBuiltInFieldId._ModerationStatus] == (DataTypes.ModStat)"0") .OrderBy(x => x[SPBuiltInFieldId.Created] as Camlex.Desc) .ToString(); return query.ExecuteListQuery(caml, itemCount); }
public static List<Model.Entities.NewsItem> GetNewsByCategory(SPList list, int itemCount, string pagingInfo, out SPListItemCollection collection) { CAMLListQuery<NewsItem> query = new CAMLListQuery<NewsItem>(list); string caml = string.Empty; caml = Camlex.Query() .Where(x => x[SPBuiltInFieldId._ModerationStatus] == (DataTypes.ModStat)"0") .OrderBy(x => x[SPBuiltInFieldId.Created] as Camlex.Desc) .ToString(); return query.ExecuteListQuery(caml, itemCount, pagingInfo, out collection); }
private void codeActivity2_ExecuteCode(object sender, EventArgs e) { var list = this.workflowProperties.TaskList; CAMLListQuery<TaskItem> query = new CAMLListQuery<TaskItem>(list); string caml = Camlex.Query().Where(p => (Guid)p[SPBuiltInFieldId.WorkflowInstanceID] == WorkflowInstanceId).ToString(); var items = query.ExecuteListQuery(caml); foreach (var item in items) { SPFieldUserValue fv = new SPFieldUserValue(workflowProperties.Web, item.AssignedTo); _allApprovers.Add(fv.User.LoginName); } }