void LoadSiteSkin( )
{
SPSecurity.RunWithElevatedPrivileges(delegate()
{
using (SPSite elevatedsiteColl = new SPSite(SPContext.Current.Site.ID))
{
using (SPWeb elevatedWeb = elevatedsiteColl.OpenWeb(SPContext.Current.Web.ID))
{
SPQuery qry = new SPQuery();
qry.Query = "<Where><Contains><FieldRef Name='FileLeafRef'/><Value Type='Text'>" +
".temp.html</Value></Contains></Where>";
//try opening the file
SPList xList = elevatedWeb.GetCatalog(SPListTemplateType.MasterPageCatalog);
if (xList == null) return;
SPListItemCollection xItems = xList.GetItems(qry);
if ((xItems != null) && (xItems.Count > 0))
{
foreach (SPListItem item in xItems)
{
string html = Encoding.UTF8.GetString(item.File.OpenBinary());
ParserHtmlTemplate(html);
}
}
}
}
});
}
GemBox.Spreadsheet.LineStyle LineSyleThin = GemBox.Spreadsheet.LineStyle.Thin; //细线
#endregion Fields
#region Methods
public DataTable GetDataSource(string sFrom, string sTo, string sNewTypeVal)
{
DataTable dt = CreateDataTable();
SPQuery query = new SPQuery();
query.Query = Query(sFrom, sTo, sNewTypeVal);
query.ViewFields = GetField();
SPListItemCollection splic = SPContext.Current.Web.Lists["POTypeChangeItems"].GetItems(query);
if (splic != null && splic.Count > 0)
{
foreach (SPListItem item in splic)
{
DataRow dr = dt.NewRow();
dr["Date"] = item["Modified"];
dr["PONb"] = item["Title"];
//[""] = item["DIV"];
//dr[""] = item["SubDIV"];
//dr[""] = item["class"];
dr["PAD"] = item["PAD"];
dr["SAD"] = item["SAD"];
dr["OMU"] = item["OMU"];
dr["Qty"] = item["Qty"];
dr["NewPOType"] = item["NewType"];
dt.Rows.Add(dr);
}
}
return dt;
}
/// <summary>
/// This method returns all publication locations
/// </summary>
/// <returns>SPListItemCollection</returns>
public SPListItem GetProjectDetails(string PID,SPWeb Web)
{
SPList ObjList = Web.Lists["Project Documents"];
SPQuery _query=new SPQuery();
_query.Query="<Where><Eq><FieldRef Name=\"Persistent_x0020_ID\" /><Value Type=\"Text\">" + PID + "</Value></Eq></Where>";
return ObjList.GetItems(_query)[0];
}
protected void BindDropDownList()
{
SPSecurity.RunWithElevatedPrivileges(() =>
{
using (var adminSite = new SPSite(CurrentWeb.Site.ID))
{
using (var adminWeb = adminSite.OpenWeb(CurrentWeb.ID))
{
try
{
adminWeb.AllowUnsafeUpdates = true;
SPList iconLink = Utilities.GetCustomListByUrl(adminWeb, ListsName.InternalName.WebsiteLink);
SPQuery query = new SPQuery();
query.Query = "<OrderBy><FieldRef Name='Title' Ascending='True' /></OrderBy>";
SPListItemCollection items = iconLink.GetItems(query);
DataTable dt = items.GetDataTable();
if (dt != null && dt.Rows.Count > 0)
{
lbWebURL.DataSource = dt;
lbWebURL.DataTextField = FieldsName.WebsiteLink.InternalName.Title;
lbWebURL.DataValueField = FieldsName.WebsiteLink.InternalName.WebURL;
lbWebURL.DataBind();
}
//lbWebURL.Items.Insert(0, new ListItem("--Liên kết website--", string.Empty));
lbWebURL.Attributes.Add("onclick", string.Format("RedirectURL('{0}')", lbWebURL.ClientID));
}
catch (SPException ex)
{
Utilities.LogToULS(ex);
}
}
}
});
}
void Test1()
{
using (SPWeb webSite = SPContext.Current.Site.AllWebs["Site_Name"])
{
SPList list = webSite.Lists["List_Name"];
SPQuery query = new SPQuery();
query.ViewXml = "<View><Query><OrderBy><FieldRef Name='ID'/>" +
"</OrderBy><Where><Or><Geq><FieldRef Name='Field1'/>" +
"<Value Type='Number'>1500</Value></Geq><Leq>" +
"<FieldRef Name='Field2'/><Value Type='Number'>500</Value>" +
"</Leq></Or></Where></Query><ViewFields>" +
"<FieldRef Name='Title'/>" +
"<FieldRef Name='Field1'/><FieldRef Name='Field2'/>" +
"<FieldRef Name='Field3'/><FieldRef Name='Field4'/>" +
"</ViewFields><RowLimit>100</RowLimit></View>";
SPListItemCollection items = list.GetItems(query);
foreach (SPListItem item in items)
{
// Response.Write(SPEncode.HtmlEncode(item.Xml) + "<BR>");
}
}
//SPFieldType t = null;
}
void FillData()
{
string curLoginName = SPContext.Current.Web.CurrentUser.LoginName;
string swhere = @"<Where><Eq><FieldRef Name='userLoginName'/><Value Type='Text'>{0}</Value></Eq></Where>";
SPQuery query = new SPQuery();
query.Query = String.Format(swhere, curLoginName);
SPListItemCollection coll = SPContext.Current.Site.RootWeb.Lists["QuickNavigator"].GetItems(query);
int count = coll.Count;
for (int i = 0; i < 5; i++)
{
TextBox txtTitle = (TextBox)psetup.FindControl("txtTitle" + i.ToString());
TextBox txtValue = (TextBox)psetup.FindControl("txtValue" + i.ToString());
Label lblNav = (Label)psetup.FindControl("nav" + i.ToString());
int num = i + 1;
var prefix = "<p>0" + num + "</p>";
if (i >= count)
{
txtTitle.Text = "";
txtValue.Text = "";
lblNav.Text = prefix;
}
else
{
txtTitle.Text = coll[i]["Title"] + "";
txtValue.Text = coll[i]["ValueCell"] + "";
lblNav.Text = "<a href=\"" + txtValue.Text + "\" target=\"_blank\">" + prefix + "<h1>" + txtTitle.Text + "</h1></a>";
}
}
}
public void GetPendingFiles()
{
SPListItemCollection items = null;
using (SPSite site = new SPSite("http://kamlesh-lt:2013"))
{
using (SPWeb web = site.OpenWeb())
{
try
{
SPList list = web.Lists["BulkUpload"];
fldErrorLogs = web.Folders["ErrorLogs"];
SPQuery query = new SPQuery();
query.Query = "<Where><Eq><FieldRef Name=\"Status\" /><Value Type=\"Choice\">Pending</Value></Eq></Where>";
query.ViewAttributes = "Scope='Recursive'";
items = list.GetItems(query);
for (int i = 0; i < items.Count; i++)
{
this.ProcessFile(items[i]);
}
}
catch (Exception ex)
{
throw ex;
}
}
}
}
/// <summary>
/// Returns the SPView data as HTML with the "aggr" tbody element filled with aggregation values.
/// </summary>
/// <param name="view">The SPView object.</param>
/// <returns>HTML with data rendered in table.</returns>
public static string RenderAsHtmlWithAggregations(this SPView view)
{
var outputHtml = view.RenderAsHtml();
var queryXml = new XmlDocument();
queryXml.LoadXml(view.GetViewXml());
var query = new SPQuery() { Query = queryXml.SelectSingleNode("//Where").OuterXml, ViewFields = queryXml.SelectSingleNode("//ViewFields").InnerXml };
var dataTable = view.ParentList.GetItems(query).GetDataTable();
if (dataTable != null)
{
var match = Regex.Match(outputHtml, "<tbody id=\"aggr\">.*</tbody>");
if (match.Success)
{
var aggregationMarkup = match.Value;
var document = new XmlDocument();
document.LoadXml(aggregationMarkup);
var cells = document.GetElementsByTagName("td");
foreach (DataColumn column in dataTable.Columns)
{
var expression = view.GetAggregationString(column.ColumnName);
if (!expression.IsNullOrEmpty())
{
var value = dataTable.Compute(string.Format("{0}({1})", expression, column.ColumnName), string.Empty);
cells[column.Ordinal].InnerText = string.Format("{0} {1}", expression, value);
}
}
outputHtml = outputHtml.Replace(aggregationMarkup, document.OuterXml);
}
}
return outputHtml;
}
public static void BatchDeleteItems(string listName, SPQuery query)
{
// Set up the variables to be used.
StringBuilder methodBuilder = new StringBuilder();
string batch = string.Empty;
string batchFormat = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>" +
"<Batch onError=\"Return\">{0}</Batch>";
string methodFormat = "<Method ID=\"{0}\">" +
"<SetList Scope=\"Request\">{1}</SetList>" +
"<SetVar Name=\"ID\">{2}</SetVar>" +
"<SetVar Name=\"Cmd\">Delete</SetVar>" +
"</Method>";
// Get the list containing the items to update.
SPList list = WorkFlowUtil.GetWorkflowList(listName);
// Query to get the unprocessed items.
SPListItemCollection unprocessedItems = list.GetItems(query);
// Build the CAML delete commands.
foreach (SPListItem item in unprocessedItems)
{
methodBuilder.AppendFormat(methodFormat, "1", item.ParentList.ID, item.ID.ToString());
}
// Put the pieces together.
batch = string.Format(batchFormat, methodBuilder.ToString());
// Process the batch of commands.
string batchReturn = SPContext.Current.Web.ProcessBatchData(batch.ToString());
}
private int GetLatestItemOrderNo(SPItemEventProperties properties)
{
int orderNo = 0;
string caml = string.Empty;
var expressionsAnd = new List<Expression<Func<SPListItem, bool>>>();
if (expressionsAnd.Count > 0)
caml = Camlex.Query().WhereAll(expressionsAnd).OrderBy(x => x[Constants.ORDER_NUMBER_COLUMN] as Camlex.Desc).ToString();
else
caml = Camlex.Query().OrderBy(x => x[Constants.ORDER_NUMBER_COLUMN] as Camlex.Desc).ToString();
SPQuery spQuery = new SPQuery();
spQuery.Query = caml;
spQuery.RowLimit = 1;
SPList currentList = properties.List;
SPListItemCollection items = currentList.GetItems(spQuery);
if (items != null && items.Count > 0)
{
SPListItem item = items[0];
if (item != null)
{
orderNo = Convert.ToInt32(item[Constants.ORDER_NUMBER_COLUMN]);
}
}
return orderNo;
}
protected void Page_Load(object sender, EventArgs e)
{
string currentURL = HttpContext.Current.Request.Url.AbsolutePath;
linkAddNews.NavigateUrl = currentURL + "?action=Add";
string property = Request.QueryString["action"];
if (property == null)
{
SPQuery query = new SPQuery();
using (SPWeb spWeb = SPContext.Current.Web)
{
SPList newsList = spWeb.Lists["CSC List News"];
SPQuery spQuery = new SPQuery(newsList.DefaultView);
spQuery.ViewFields = "<FieldRef Name='NewsImage'/><FieldRef Name='NewsDateFrom'/><FieldRef Name='NewsDateTo'/><FieldRef Name='NewsTitle'/><FieldRef Name='NewsShort'/><FieldRef Name='NewsFull'/>";
SPListItemCollection allNews = newsList.GetItems(spQuery);
gridListNews.DataSource = allNews.GetDataTable();
gridListNews.DataBind();
/*spQuery.Query = "<Where><Eq><FieldRef Name='Title'/>"
+ "<Value Type='Text'>"
+ "MyTask"
+ "</Value></Eq></Where>";
} */
}
}
else {
this.Visible = false;
}
}
/// <summary>
/// Checks the duplicate.
/// </summary>
/// <param name="siteURL">The site URL.</param>
/// <param name="value">The value.</param>
/// <param name="columnName">Name of the column.</param>
/// <param name="listName">Name of the list.</param>
/// <returns>bool</returns>
internal bool CheckDuplicate(string siteURL, string value, string columnName, string listName)
{
bool blnIsValueExist = false;
SPList list;
SPQuery query;
SPSecurity.RunWithElevatedPrivileges(delegate()
{
using (SPSite site = new SPSite(siteURL))
{
using (SPWeb web = site.OpenWeb())
{
list = web.Lists[listName];
query = new SPQuery();
query.Query = @"<Where><Eq><FieldRef Name='" + columnName + "' /><Value Type='Text'>" + value + "</Value></Eq></Where>";
if (list.GetItems(query).Count > 0)
{
blnIsValueExist = true;
}
}
}
});
return blnIsValueExist;
}
public List<Book> GetByCategory(int categoryId)
{
var web = SPContext.Current.Web;
var booksList = web.Lists[ListName];
var query = new SPQuery();
query.Query = string.Format(
@"<Where>
<Eq>
<FieldRef Name='Category' LookupId='TRUE' />
<Value Type='Lookup'>{0}</Value>
</Eq>
</Where>", categoryId);
var items = booksList.GetItems(query);
var booksInCategory = items.OfType<SPListItem>().Select(it => new Book
{
Id = it.ID,
Title = it.Title,
Description = it["Description"] as string,
ImageUrl = new SPFieldUrlValue(it["Image"] as string).Url,
CategoryId = categoryId
}).ToList();
return booksInCategory;
}
protected void BindRepeater()
{
SPSecurity.RunWithElevatedPrivileges(() =>
{
using (var adminSite = new SPSite(CurrentWeb.Site.ID))
{
using (var adminWeb = adminSite.OpenWeb(CurrentWeb.ID))
{
try
{
adminWeb.AllowUnsafeUpdates = true;
SPList list = Utilities.GetCustomListByUrl(adminWeb, ListsName.InternalName.DocumentsList);
SPQuery query = new SPQuery();
query.Query="<OrderBy><FieldRef Name='ID' Ascending='FALSE' /></OrderBy>";
query.RowLimit = 10;
SPListItemCollection items = list.GetItems(query);
if (items!=null&&items.Count>0)
{
rptDocument.DataSource = items.GetDataTable();
rptDocument.DataBind();
}
}
catch (Exception ex)
{
Utilities.LogToULS(ex);
}
}
}
});
}
protected void btnQuery_Click(object sender, EventArgs e)
{
try
{
using (SPSite site = new SPSite(SPContext.CurrentWeb.Url))
using (SPWeb web = site.OpenWeb())
SPList courseList = web.Lists.TryGetList("MyList");
if (courseList != null)
{
StringBuilder query = new StringBuilder();
query.Append("<Where>"); // -----> finish schema with subsequent appends...
}
SPQuery camlQuery = new SPQuery();
camlQuery.Query = Queryable.ToString();
camlQuery.ViewFields = "<FieldRef Name = 'Title' ";
SPListItemCollection items = courseList.GetItems(camlQuery);
grdClasses.DataSource = items.GetDataTable();
grdClasses.DataBind();
}
catch
{
}
}
//string sTitle, string sAssignedTo)//sTitle, sAssignedTo
/// <summary>
/// 检测list里是否存在重复的task记录
/// </summary>
/// <param name="splCompletedTasks"></param>
/// <param name="id"></param>
/// <returns></returns>
public static bool isUnique(SPList splCompletedTasks,string id)
{
SPQuery query = new SPQuery();
query.Query = string.Format(@"
<Where>
<Eq>
<FieldRef Name='TaskID' />
<Value Type='Text'>{0}</Value>
</Eq>
</Where>", id);
// query.Query = string.Format(@" <Where>
// <And>
// <Eq>
// <FieldRef Name='AssignedTo' />
// <Value Type='User'>{0}</Value>
// </Eq>
// <Contains>
// <FieldRef Name='Title' />
// <Value Type='Text'>{1}</Value>
// </Contains>
// </And>
// </Where>",sAssignedTo,sTitle);
int iCount = splCompletedTasks.GetItems(query).Count;
if (iCount > 0)
{
return false;
}
else
{
return true;
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
SPQuery qry = new SPQuery();
SPWeb rootWeb = Site.RootWeb;
SPList list = rootWeb.Lists["Articles"];
CamlQuery caml = new CamlQuery();
SPQuery articleQuery = new SPQuery();
articleQuery.Query = CAML.Where(
CAML.Contains(
CAML.FieldRef("Title"),
CAML.Value(txtTitleSearch.Text)));
//articleQuery.ViewFields = CAML.ViewFields(CAML.FieldRef("Title"), CAML.FieldRef("Modified By"));
//articleQuery.ViewFields = string.Concat(
// "<FieldRef Name='Title' />",
// "<FieldRef Name='Modified' />");
//articleQuery.ViewFieldsOnly = true;
//articleQuery.ViewFields = "<ViewFields><FieldRef Name=\"Title\"/></ViewFields>";
SPListItemCollection col;
if (txtTitleSearch.Text.Length == 0)
{
col = list.Items;
}
else
{
col = list.GetItems(articleQuery);
}
ViewState["AtricleSearchResults"] = col.GetDataTable();
gvResult.DataSource = col.GetDataTable();
gvResult.DataBind();
}
// Executes the expression tree that is passed to it.
internal static object Execute(SPList list, Expression expression, bool isEnumerable)
{
// The expression must represent a query over the data source.
if (!IsQueryOverDataSource(expression))
throw new InvalidProgramException("No query over the data source was specified.");
var caml = (new CamlTranslator()).Translate(null, expression);
var query = new SPQuery();
var viewFieldsXml = caml.Element(Tags.ViewFields);
var rowLimitXml = caml.Element(Tags.RowLimit);
var queryXml = caml.Elements()
.Where(n => n.Name != Tags.ViewFields && n.Name != Tags.RowLimit)
.ToList();
query.Query = (new XElement(Tags.Query, queryXml)).Value;
if (viewFieldsXml != null)
{
query.ViewFields = viewFieldsXml.Value;
query.ViewFieldsOnly = true;
}
if (rowLimitXml != null)
{
query.RowLimit = (int)rowLimitXml.Value;
}
return list.GetItems(query);
}
public SPQuery Build()
{
SPQuery spQuery = new SPQuery();
StringBuilder queryBuilder = new StringBuilder("<Where>");
if (filters.Count > 1)
{
queryBuilder.Append("<And>");
}
foreach (CAMLFilter filter in this.filters)
{
queryBuilder.Append(filter.FilterExpression);
}
if (filters.Count > 1)
{
queryBuilder.Append("</And>");
}
queryBuilder.Append("</Where>");
spQuery.Query = queryBuilder.ToString();
return spQuery;
}
private string SetDefaultDepartManager()
{
string manager = string.Empty;
SPSecurity.RunWithElevatedPrivileges(delegate()
{
using (SPSite site = new SPSite(SPContext.Current.Site.ID))
{
using (SPWeb web = site.RootWeb)
{
SPList list = web.Lists["Department"];
SPQuery query = new SPQuery();
query.Query = string.Format(@"<Where>
<Eq>
<FieldRef Name='Title' />
<Value Type='Text'>{0}</Value>
</Eq>
</Where>", "Store Operations");
SPListItemCollection items = list.GetItems(query);
if (items.Count > 0)
{
manager = (new SPFieldLookupValue(items[0]["ManagerAccount"].AsString())).LookupValue;
}
}
}
});
return manager;
}
protected override void CreateChildControls()
{
return;
SPQuery query = new SPQuery();
// supports less than 130,000 records
// query.Query = "<Where><Eq><FieldRef Name='_x804c__x4f4d_'/><Value Type='Text'>J</Value></Eq></Where>";
query.Query = "<Where><And><Eq><FieldRef Name='_x6027__x522b_'/><Value Type='Text'>男</Value></Eq><Eq><FieldRef Name='_x804c__x4f4d_'/><Value Type='Text'>J</Value></Eq></And></Where>";
SPWeb web = SPContext.Current.Web;
PortalSiteMapProvider ps = PortalSiteMapProvider.WebSiteMapProvider;
PortalWebSiteMapNode psNode = (PortalWebSiteMapNode)ps.FindSiteMapNode(web.ServerRelativeUrl);
if (psNode != null)
{
Stopwatch timer = new Stopwatch();
timer.Start();
SiteMapNodeCollection items = ps.GetCachedListItemsByQuery(psNode, "人物列表", query, web);
StringBuilder sb = new StringBuilder();
foreach (PortalListItemSiteMapNode item in items)
{
sb.Append(item["性别"]);
sb.Append("，");
}
timer.Stop();
sb.Append("<hr>");
sb.Append(string.Format("{0:N}",timer.Elapsed.Ticks / 10m));
LiteralControl lc = new LiteralControl();
lc.Text = sb.ToString();
this.Controls.Add(lc);
}
}
public Customer GetByName(string name)
{
var web = SPContext.Current.Web;
var list = web.Lists[ListName];
var query = new SPQuery();
query.Query = @"
<Where>
<Eq><FieldRef Name='Title' />
<Value Type='Text'>" + name + @"</Value>
</Eq>
</Where>";
query.RowLimit = 1;
var results = list.GetItems(query);
if (results.Count == 0)
{
return null;
}
var item = results.Cast<SPListItem>().First();
return new Customer
{
Name = item.Title,
CustomerId = item.ID
};
}
private void RenderNumberOfBids(SPListItem item)
{
if (item["NumberOfBids"] != null)
{
var bids = item["NumberOfBids"].ToString();
NumberOfBidsLabel.Text = string.Format("{0} - <a href=\"#\" onclick=\"javascript:$('#auction-bid-history').slideToggle()\">Bid History</a>", bids);
// build list of bids for this item
var query = new SPQuery
{
Query =
"<Where><Eq><FieldRef Name=\"Item\" LookupId=\"TRUE\"/><Value Type=\"Lookup\">" + item.ID +
"</Value></Eq></Where><OrderBy><FieldRef Name=\"Modified\" Ascending=\"FALSE\"/></OrderBy></Query>"
};
var bidHistory = SPContext.Current.Web.Lists[Constants.BidderListName].GetItems(query);
BidHistory.Text = "<table cellpadding=\"4\" cellspacing=\"4\"><tr>";
BidHistory.Text += "<th>Bidder</th><th>Bid Amount</th><th>Bid Time</th>";
foreach (SPListItem bidItem in bidHistory)
{
var bidderColumn = (SPFieldUser)bidItem.Fields.GetField("Bidder");
var bidder = (SPFieldUserValue)bidderColumn.GetFieldValue(bidItem["Bidder"].ToString());
BidHistory.Text += string.Format("<tr><td>{0}</td><td>{1:c}</td><td>{2}</td></tr>", bidder.User.Name, bidItem["Amount"], bidItem["Modified"]);
}
BidHistory.Text += "</tr></table>";
}
else
{
NumberOfBidsLabel.Text = "0";
}
}
public static System.Web.UI.WebControls.WebParts.WebPart CreateWebPart(SPWeb web, string webPartName, SPLimitedWebPartManager webPartManager)
{
SPQuery qry = new SPQuery();
qry.Query = String.Format(CultureInfo.CurrentCulture,
"<Where><Eq><FieldRef Name='FileLeafRef'/><Value Type='File'>{0}</Value></Eq></Where>",
webPartName);
SPList webPartGallery = null;
if (null == web.ParentWeb)
{
webPartGallery = web.GetCatalog(SPListTemplateType.WebPartCatalog);
}
else
{
webPartGallery = web.Site.RootWeb.GetCatalog(SPListTemplateType.WebPartCatalog);
}
SPListItemCollection webParts = webPartGallery.GetItems(qry);
XmlReader xmlReader = new XmlTextReader(webParts[0].File.OpenBinaryStream());
string errorMsg;
System.Web.UI.WebControls.WebParts.WebPart webPart = webPartManager.ImportWebPart(xmlReader, out errorMsg);
return webPart;
}
internal SPListItemCollection GetListItemCollection(SPList spList, string keyOne, string valueOne, string keyTwo, string valueTwo, string keyThree, string valueThree)
{
// Return list item collection based on the lookup field
SPField spFieldOne = spList.Fields[keyOne];
SPField spFieldTwo = spList.Fields[keyTwo];
SPField spFieldThree = spList.Fields[keyThree];
var query = new SPQuery
{
Query = @"<Where>
<And>
<And>
<Eq>
<FieldRef Name=" + spFieldOne.InternalName + @" />
<Value Type=" + spFieldOne.Type.ToString() + @">" + valueOne + @"</Value>
</Eq>
<Eq>
<FieldRef Name=" + spFieldTwo.InternalName + @" />
<Value Type=" + spFieldTwo.Type.ToString() + @">" + valueTwo + @"</Value>
</Eq>
</And>
<Eq>
<FieldRef Name=" + spFieldThree.InternalName + @" />
<Value Type=" + spFieldThree.Type.ToString() + @">" + valueThree + @"</Value>
</Eq>
</And>
</Where>"
};
return spList.GetItems(query);
}
protected void Page_Load(object sender, EventArgs e)
{
//Retrieve Items from a List
using (SPSite site = new SPSite(SPContext.Current.Web.Url)) ;
using (SPWeb web = site.OpenWeb())
{
SPList oList = web.Lists.TryGetList("Courses");
string sQuery = @"<Where><IsNotNull><FieldRef Name='Product'></FieldRef></IsNotNull></Where>";
string sViewFields = @"<FieldRef Name = 'Product' />";
uint iRowLimit = 10;
var oQuery = new SPQuery();
oQuery.Query = sQuery;
oQuery.ViewFields = sViewFields;
oQuery.RowLimit = iRowLimit;
SPListItemCollection collListItems = oList.GetItems(oQuery);
DataView dv = new DataView(collListItems.GetDataTable());
DataTable dt = dv.ToTable(true, "Product");
1stProducts.DataSource = dt;
1stProducts.DataTextFied = "Product";
1stProducts.DataBind();
}
}
public Entities.SPListItemIdentificationType GetIdentificationTypeItem(string text)
{
try
{
Entities.SPListItemIdentificationType returnListItem = null;
DAO.IdentificationTypeDAO identificationtTypeDAO = new CAFAM.WebPortal.DAO.IdentificationTypeDAO(Web);
SPList spList = identificationtTypeDAO.GetIdentificationTypeSPList();
SPQuery spQuery = new SPQuery();
spQuery.Query = string.Format("<Where><Eq><FieldRef Name='Title' /><Value Type='Text'>{0}</Value></Eq></Where>", text);
SPListItemCollection spListItems = spList.GetItems(spQuery);
if (spListItems.Count != 0)
{
returnListItem = new CAFAM.WebPortal.Entities.SPListItemIdentificationType(spListItems[0]["Title"].ToString(), spListItems[0]["Value"]);
}
return returnListItem;
}
catch (Exception ex)
{
throw ex;
}
}
public static DateTime? GetLastUpdateDate()
{
DateTime? maxValue = null;
try
{
SPWeb web;
if (SPContext.Current != null)
web = SPContext.Current.Web;
else
web = new SPSite("http://finweb.contoso.com/sites/PMM").OpenWeb();
SPList objList = web.Lists.TryGetList(Constants.LIST_NAME_PROJECT_TASKS);
SPQuery objQuery = new SPQuery();
objQuery.Query = "<OrderBy><FieldRef Name='ModifiedOn' Ascending='False' /></OrderBy><RowLimit>1</RowLimit>";
objQuery.Folder = objList.RootFolder;
// Execute the query against the list
SPListItemCollection colItems = objList.GetItems(objQuery);
if (colItems.Count > 0)
{
maxValue = Convert.ToDateTime(colItems[0]["ModifiedOn"]);
}
}
catch (Exception ex)
{
}
return maxValue;
}
public static void CheckandAddEntry(SPList configurationList, Guid ProjectGuid, Project Project_Svc)
{
try
{
// Checking whether the project id is already available.
var query = new SPQuery
{
Query =
@"<Where><Eq><FieldRef Name='" + ProjectUIDFieldName + "' /><Value Type='Text'>" + ProjectGuid.ToString() + "</Value></Eq></Where>"
};
var ProjectItemCollection = configurationList.GetItems(query);
if (ProjectItemCollection.Count == 0)
{
configurationList.ParentWeb.Site.RootWeb.AllowUnsafeUpdates = true;
SPListItem item = configurationList.Items.Add();
//first project name
item["Title"] = Project_Svc.GetProjectNameFromProjectUid(ProjectGuid, DataStoreEnum.WorkingStore);
item[GroupFieldName] = DefaultGroupValue;
item[ProjectUIDFieldName] = ProjectGuid.ToString();
item.Update();
configurationList.ParentWeb.Site.RootWeb.Update();
}
}
catch (Exception ex)
{
ErrorLog("Error at adding configuration item to the list due to " + ex.Message, EventLogEntryType.Error);
}
}
public DataTable GetNewsRecords(string query)
{
DataTable table = new DataTable();
SPSecurity.RunWithElevatedPrivileges(() =>
{
using (var site = new SPSite(SPContext.Current.Web.Site.ID))
{
using (var web = site.OpenWeb(SPContext.Current.Web.ID))
{
try
{
SPQuery spQuery = new SPQuery
{
Query = query
};
SPList list = Utilities.GetDocListFromUrl(web, ListsName.English.ImageCatList);
if (list != null)
{
SPListItemCollection items = list.GetItems(spQuery);
table = items.GetDataTable();
}
}
catch (Exception ex)
{
table = null;
}
}
}
});
return table;
}
private SPQuery BuildQuery(string field, string parentField, string filterValueField, string filterValue)
{
SPQuery query = new SPQuery();
string caml = "";
if (string.IsNullOrEmpty(parentField) || string.IsNullOrEmpty(filterValueField))
{
caml = @"<ViewFields><FieldRef Name='{0}' /></ViewFields><OrderBy><FieldRef Name='{0}' /></OrderBy>";
query.Query = string.Format(caml, field);
}
else
{
caml = @"<ViewFields><FieldRef Name='{0}' /><FieldRef Name='{1}' /></ViewFields><OrderBy><FieldRef Name='{0}' /></OrderBy><Where><Eq><FieldRef Name='{1}' /><Value Type='Text'>{2}</Value></Eq></Where>";
query.Query = string.Format(caml, field, parentField, filterValue);
}
return(query);
}
public void Employment(DropDownList ddlClients)
{
using (SPSite osite = new SPSite(SPContext.Current.Site.Url))
{
using (SPWeb oweb = osite.OpenWeb())
{
SPList olist = oweb.Lists.TryGetList(Employments);
SPQuery oquery = new SPQuery();
oquery.Query = "<Where><Eq><FieldRef Name='Status'/><Value Type='Text'>Active</Value></Eq></Where>";
SPListItemCollection ocollection = olist.GetItems(oquery);
foreach (SPListItem oitem in ocollection)
{
ddlClients.Items.Add(oitem["VacancyName"].ToString());
}
//ddlClient.Items.Insert(0, "None");
}
}
}
public SharePointListDescriptor GetListItemsByField(string listName, string fieldNames, string fieldValues, string queryType)
{
SPList spList = this.GetList(listName);
SPQuery query = new SPQuery();
query.Query = "<Where>" + this.GetCAMLClause(spList, fieldNames, fieldValues, queryType) + "</Where>";
SPListItemCollection items = spList.GetItems(query);
SharePointListDescriptor descriptor = new SharePointListDescriptor();
descriptor.ListId = spList.ID.ToString();
descriptor.SharePointListItems = new SharePointListItem[items.Count];
descriptor.ListName = spList.Title;
for (int i = 0; i < items.Count; i++)
{
descriptor.SharePointListItems[i] = this.SPListItemtoDescriptor(items[i]);
}
return(descriptor);
}
private double GetOOBColumnValue(SPWeb web, int itemId, string internalName)
{
SPList list = web.Lists["Sharepoint for Out of Budget expenses"];
if (list != null)
{
SPQuery query = new SPQuery();
query.Query = "<Where><Eq><FieldRef Name='ID'></FieldRef><Value Type='Counter'>" + itemId.ToString() + "</Value></Eq></Where>";
SPListItemCollection items = list.GetItems(query);
if (items != null && items.Count > 0)
{
return((items[0][internalName] == null) ? 0 : Convert.ToDouble(items[0][internalName]));
}
}
return(0);
}
public void CanUseIntegersAndDateTimes()
{
CAMLQueryBuilder target = new CAMLQueryBuilder();
target.AddEqual("Name", 1);
target.AddEqual("Name2", new DateTime(2000, 11, 22));
SPQuery query = target.Build();
string expectedDateTime = SPUtility.CreateISO8601DateTimeFromSystemDateTime(new DateTime(2000, 11, 22));
string expectedQuery =
string.Format(
"<Where><And><Eq><FieldRef Name='Name'/><Value Type='Integer'>1</Value></Eq>" +
"<Eq><FieldRef Name='Name2'/><Value Type='DateTime'>{0}</Value></Eq></And></Where>",
expectedDateTime);
Assert.AreEqual(expectedQuery, query.Query);
}
/// <summary>
/// GET list items
/// </summary>
/// <returns></returns>
public SPListItemCollection GetOrderedListCollectionItems(string _siteName, string _listName)
{
SPListItemCollection items = null;
using (SPSite site = new SPSite(_siteName))
{
using (web = site.OpenWeb())
{
SPList list = web.Lists[_listName];
SPQuery query = new SPQuery();
///TO DO order by Create Date
query.Query = "<OrderBy><FieldRef Name=\"Order\" /></OrderBy>";
items = list.GetItems(query);
}
}
return(items);
}
private void GetAvailableValues3(SPList lookupList, string fId, ListBox ddl, string parentValue)
{
string caml = @"<Where><Eq><FieldRef Name='ParentName' LookupId='TRUE' /><Value Type='Lookup'>" + parentValue + "</Value></Eq></Where><OrderBy><FieldRef Name='Title' /></OrderBy>";
var query = new SPQuery()
{
Query = caml
};
var items = lookupList.GetItems(query);
if (items != null && items.Count > 0)
{
foreach (SPListItem item in items)
{
ddl.Items.Add(new ListItem("------------ " + item[fId].ToString(), item.ID.ToString()));
GetAvailableValues3(lookupList, fId, ddl, item.ID.ToString());
}
}
}
//Diese Methode sammelt Elemente aus dem Unterordner der SharePoint-Bibiothek "Temp"; diese "Sammlung" wird in einer anderen Methode verwendet um sie zu einer PDF-Datei zusammen zu fügen
public SPListItemCollection CollectFiles(SPFolder ordner, SPList bibliothek, Boolean lieferant)
{
//Um Dokumente zu "sammeln" muss eine Abfrage(SPQuery) erstellt werden
SPQuery Query = new SPQuery();
//Dieser String ist wichtig, da nur durch ihn Elemente innerhalb eiens Ordners abgefragt werden können
Query.ViewAttributes = "Scope=\"Recursive\"";
string query = "<OrderBy><FieldRef Name=\"ID\" Ascending='False' /></OrderBy>";
Query.Query = query;
//Abzielen der Abfrage auf den im Aufruf mitgegeben Ordner
Query.Folder = ordner;
//Durchführen der Abfrage
SPListItemCollection collListItems = bibliothek.GetItems(Query);
//Rückgabe der "SPListItemCollection", damit dieser weiter verwendet werden kann.
return(collListItems);
}
public void EmploymentType(DropDownList ddlClients)
{
using (SPSite osite = new SPSite(SPContext.Current.Site.Url))
{
using (SPWeb oweb = osite.OpenWeb())
{
SPList olist = oweb.Lists.TryGetList(oEmployment);
SPQuery oquery = new SPQuery();
oquery.Query = "<Query><Where><Eq><FieldRef Name='CandidateName' /></Eq></Where></Query>";
SPListItemCollection ocollection = olist.GetItems(oquery);
foreach (SPListItem oitem in ocollection)
{
ddlClients.Items.Add(oitem["CandidateName"].ToString());
}
//ddlClient.Items.Insert(0, "None");
}
}
}
internal SPListItemCollection GetListItemCollection(SPList spList, string key, string value)
{
// Return list item collection based on the lookup field
SPField spField = spList.Fields[key];
var query = new SPQuery
{
Query =
@"<Where>
<Eq>
<FieldRef Name='" + spField.InternalName +
@"'/><Value Type='" + spField.Type.ToString() + @"'>" + value + @"</Value>
</Eq>
</Where>"
};
return(spList.GetItems(query));
}
private SPListItem getSettingItem(SPWeb web)
{
SPList settinglist = web.GetList("/Lists/ListSetting");
SPQuery query = new SPQuery()
{
Query = string.Format(@"<Where><Eq><FieldRef Name='ListId' /><Value Type='Text'>{0}</Value></Eq></Where>", workflowProperties.ListId.ToString().ToUpper())
};
SPListItemCollection items = settinglist.GetItems(query);
if (items.Count == 1)
{
return(items[0]);
}
else
{
return(null);
}
}
public SPListItemCollection RetornaLista(string NomeLista, string Query, string ViewFields, string Projected, Guid Site)
{
try
{
SPQuery objQuery = new SPQuery();
objQuery.Query = Query;
objQuery.ProjectedFields = Projected;
objQuery.ViewFields = ViewFields;
objQuery.ExpandRecurrence = true;
return(SPContext.Current.Site.AllWebs[Site].Lists[NomeLista].GetItems(objQuery));
}
catch (Exception ex)
{
this.Erro = ex.Message;
return(null);
}
}
// retrieve method is encapsulated and hidden fromt the public
private AppData retrieve(int key)
{
SPQuery query = new SPQuery();
query.Query = "<Where><Eq><FieldRef Name=\"ID\"/><Value Type=\"Integer\">" + key + "</Value></Eq></Where>";
query.ViewAttributes = "Scope=\"Recursive\"";
SPListItemCollection items = itemToFind.ParentList.GetItems(query);
if (items.Count > 0)
{
//foreach (SPListItem item in items)
//{
// SPItem result = item.Web.GetItem(item.Url);
// return result;
//}
}
return(new AppData());
}
protected void bSearch_Click(object sender, EventArgs e)
{
lbClasses.Items.Clear();
SPWeb currentWeb = SPContext.Current.Web;
SPList classesList = currentWeb.Lists["Classes"];
SPQuery classesQuery = new SPQuery();
classesQuery.ViewFields = "<FieldRef Name='CourseTitle'/><FieldRef Name='Trainer'/><FieldRef Name='Venue'/><FieldRef Name='StartDate'/><FieldRef Name='_EndDate'/>";
classesQuery.Query = "<Where><Contains><FieldRef Name='CourseTitle'/><Value Type='Text'>" + tbQuery.Text + "</Value></Contains></Where>";
SPListItemCollection introClasses = classesList.GetItems(classesQuery);
foreach (SPListItem introClass in introClasses)
{
lbClasses.Items.Add(introClass["Course Title"].ToString());
lbClasses.Items.Add("...in " + introClass["Venue"].ToString() + ", starting on " + introClass["Start Date"].ToString() + ", ending on " + introClass["End Date"].ToString());
}
lResultCount.Text = "Found " + introClasses.Count.ToString() + " classes.";
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
using (SPSite oSPsite = new SPSite(SPContext.Current.Web.Url))
{
using (SPWeb oSPWeb = oSPsite.OpenWeb())
{
if (Page.Request.UrlReferrer != null)
{
string listName = "IR02OffJob";
// Fetch the List
SPList SPListIR02 = oSPWeb.GetList(string.Format("{0}/Lists/{1}/AllItems.aspx", oSPWeb.Url, listName));
SPQuery query = new SPQuery();
//query.ViewFields = "<ViewFields><FieldRef Name='ID' /><FieldRef Name='Total' /><FieldRef Name='Created' /></ViewFields>";
//query.ViewFieldsOnly = true;
StringBuilder sb = new StringBuilder();
sb.Append("<Where><Eq><FieldRef Name='Author' /><Value Type='Integer'><UserID /></Value></Eq></Where><OrderBy><FieldRef Name='Created' Ascending='FALSE' /></OrderBy>");
query.Query = sb.ToString();
SPListItemCollection spListItems = SPListIR02.GetItems(query);
query.RowLimit = 1;
if (spListItems != null && spListItems.Count > 0)
{
foreach (SPListItem item in spListItems)
{
AddDummyEntryInIR01ListToAssignTaskTo(oSPWeb, item);
}
}
}
}
}
}
catch (Exception ex)
{
SPDiagnosticsService.Local.WriteTrace(0, new SPDiagnosticsCategory("SL.FG.FFL(IntermediateOffForm->Page_Load)", TraceSeverity.Unexpected, EventSeverity.Error), TraceSeverity.Unexpected, ex.Message, ex.StackTrace);
}
}
//返回操作列表
private DataTable GetBindData(string listName, string parentId)
{
DataTable dt = null;
if (ViewState["dtAction"] != null)
{
dt = (DataTable)ViewState["dtAction"];
}
else
{
SPWeb web = SPContext.Current.Web;
SPList list = web.Lists.TryGetList(listName);//先到我的操作表中去找
SPQuery qry = new SPQuery
{
DatesInUtc = false
};
if (list != null)
{
qry.Query = "<Where><Eq><FieldRef Name='Author' LookupId='True' /><Value Type='Integer'>" + SPContext.Current.Web.CurrentUser.ID + @"</Value></Eq></Where><OrderBy><FieldRef Name='Period' Ascending='TRUE' /><FieldRef Name='Frequency' Ascending='FALSE' /></OrderBy>";
dt = list.GetItems(qry).GetDataTable();
SPListItemCollection items = list.GetItems(qry);
SPListItem item;
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
item = items.GetItemById((int)dr["ID"]);
dr["ID"] = new SPFieldLookupValue(item["ActionID"].ToString()).LookupId;
}
dt.AcceptChanges();
}
}
if (dt == null || dt.Rows.Count == 0)
{
list = web.Lists.TryGetList(webObj.ActionList);
qry = new SPQuery();
qry.Query = "<OrderBy><FieldRef Name='Period' Ascending='TRUE' /><FieldRef Name='Frequency' Ascending='FALSE' /></OrderBy>";
dt = list.GetItems(qry).GetDataTable();
}
ViewState["dtAction"] = dt;
}
return(dt);
}
private void LoadFruitArray()
{
// Get the Page Client Script Manager
var cs = Page.ClientScript;
// Try and get the Fruit List from the current Web
var fruitList = SPContext.Current.Web.Lists.TryGetList("Fruits");
// If list not found then return
if (fruitList == null)
{
return;
}
var fruits = new List <string>();
// Query to select just the image names from the list with _small in the name
var query = new SPQuery
{
Query = "<Where>" +
"<Contains>" +
"<FieldRef Name='NameOrTitle' />" +
"<Value Type='Text'>_small</Value>" +
"</Contains>" +
"</Where>",
ViewFields = "<FieldRef Name='NameOrTitle' />",
ViewFieldsOnly = true
};
var fruitListItems = fruitList.GetItems(query);
// Iterate through each list item
foreach (SPListItem item in fruitListItems)
{
// Add the Item Name i.e. 'apple_small.jpg'
fruits.Add(string.Format("'{0}'", item.Name));
}
// Combine all array elements as comma delimited
var fruitItems = string.Join(",", fruits.ToArray());
// Register Fruit array to the page Client Script Manager
cs.RegisterArrayDeclaration("Fruits", fruitItems);
}
private List <SPList> GetDueDateLists(int offSetDays)
{
List <SPList> spLists = new List <SPList>();
// get our filtered list of cases
var parentWeb = SPContext.Current.Site.RootWeb;
var eCases = parentWeb.GetList(parentWeb.Url + "/Lists/Cases");
SPQuery myeCaseQuery = new SPQuery();
//string eCaseQuery = "<Where><Eq><FieldRef Name='AssignedToSupervisor' /><Value Type='Integer'><UserID/></Value></Eq></Where>";
string eCaseQuery = "<Where><Eq><FieldRef Name='AssignedTo' /><Value Type='Integer'><UserID/></Value></Eq></Where>";
myeCaseQuery.Query = eCaseQuery;
var filteredCases = eCases.GetItems(myeCaseQuery);
foreach (SPListItem caseItem in filteredCases)
{
// get our lists
using (SPSite caseSite = new SPSite(parentWeb.Url + "/" + caseItem["UniqueCaseID"].ToString()))
{
using (SPWeb caseWeb = caseSite.OpenWeb())
{
if (!caseWeb.IsRootWeb)
{
// case related dates
var caseRelatedDates = caseWeb.GetList(caseWeb.Url + "/Lists/CaseRelatedDates");
if (caseRelatedDates != null)
{
spLists.Add(caseRelatedDates);
}
// tasks and activities
var tasksAndActivities = caseWeb.GetList(caseWeb.Url + "/Lists/TasksAndActivities");
if (tasksAndActivities != null)
{
spLists.Add(tasksAndActivities);
}
}
}
}
}
return(spLists);
}
public static string GetRedirectUrl(string key)
{
string redirectUrl = null;
try
{
using (SPSite oSPsite = new SPSite(SPContext.Current.Web.Url))
{
using (SPWeb oSPWeb = oSPsite.OpenWeb())
{
string listName = "CommonDictionary";
// Fetch the List
SPList spList = oSPWeb.GetList(string.Format("{0}/Lists/{1}/AllItems.aspx", oSPWeb.Url, listName));
SPQuery query = new SPQuery();
SPListItemCollection spListItems;
// Include only the fields you will use.
query.ViewFields = "<FieldRef Name='Title'/><FieldRef Name='Value'/>";
query.ViewFieldsOnly = true;
query.RowLimit = 1; // Only select the top 1.
StringBuilder sb = new StringBuilder();
sb.Append("<Where>")
.Append("<Eq>")
.Append("<FieldRef Name='Title' />")
.Append("<Value Type='Text'>" + key + "</Value>")
.Append("</Eq>")
.Append("</Where>");
query.Query = sb.ToString();
spListItems = spList.GetItems(query);
for (int i = 0; i < spListItems.Count; i++)
{
SPListItem listItem = spListItems[i];
redirectUrl = string.Format("{0}/{1}", oSPWeb.Url, Convert.ToString(listItem["Value"]));
}
}
}
}
catch (Exception ex)
{
SPDiagnosticsService.Local.WriteTrace(0, new SPDiagnosticsCategory("SL.FG.PFL(Utility->GetRedirectUrl)", TraceSeverity.Unexpected, EventSeverity.Error), TraceSeverity.Unexpected, ex.Message, ex.StackTrace);
}
return(redirectUrl);
}
protected void btnCopyCat_OnClick(object sender, EventArgs e)
{
SPSecurity.RunWithElevatedPrivileges(() =>
{
using (var site = new SPSite(SPContext.Current.Web.Site.ID))
{
using (var enWeb = site.OpenWeb(SPContext.Current.Web.ID))
{
if (enWeb.Url.Contains("/en"))
{
var vnWeb = site.RootWeb;
var vnList = vnWeb.GetList(vnWeb.Url + "/Lists/" + ListsName.English.NewsCategory);
var enList = enWeb.GetList(enWeb.Url + "/Lists/" + ListsName.English.NewsCategory);
for (int i = 0; i < enList.ItemCount; i++)
{
var itemToDelete = enList.Items[0];
itemToDelete.Delete();
}
enList.Update();
var vnNewsList = vnWeb.GetList(vnWeb.Url + "/Lists/" + ListsName.English.NewsRecord);
var enNewsList = enWeb.GetList(enWeb.Url + "/Lists/" + ListsName.English.NewsRecord);
var catQuery = "<Where><IsNull><FieldRef Name='" +
FieldsName.NewsCategory.English.ParentName + "' /></IsNull></Where>";
var query = new SPQuery();
query.Query = catQuery;
var vnListItems = vnList.GetItems(query);
foreach (SPListItem vnItem in vnListItems)
{
var enItem = enList.Items.Add();
enItem["Title"] = vnItem["Title"];
enItem[FieldsName.NewsCategory.English.Status] = vnItem[FieldsName.NewsCategory.English.Status];
enWeb.AllowUnsafeUpdates = true;
enItem.Update();
enWeb.AllowUnsafeUpdates = true;
vnWeb.AllowUnsafeUpdates = true;
CopyNews(vnItem.ID, enItem.ID, enList, vnNewsList, enNewsList);
enWeb.AllowUnsafeUpdates = true;
CopyCat(vnItem.ID, enItem.ID, vnList, enList, vnNewsList, enNewsList);
}
}
}
}
});
}
public override void FeatureDeactivating(SPFeatureReceiverProperties properties)
{
try
{
SPSite site = (SPSite)properties.Feature.Parent;
SPWeb parentWeb = site.RootWeb;
SPList eventLog = parentWeb.Lists.TryGetList("CCPEventFeatureLog");
SPWebCollection webs = parentWeb.Webs;//get subsites directly under top level
int webCount = webs.Count + 1;
string webStr = webCount.ToString();
//Create Item to Track WebCount
SPQuery query = new SPQuery();
query.ViewXml = "<View Scope='RecursiveAll'/>";
SPListItemCollection coll = eventLog.GetItems(query);
SPListItem item = eventLog.AddItem();
item["WebCount"] = webStr;
item.Update();
foreach (SPWeb targetWeb in webs)
{
try
{
/* Activate Feature to attach receiver to both Proposals and Contracts */
targetWeb.Features.Remove(new Guid("025286a3-564b-4084-a073-1c1fac92c036"));
}
finally
{
if (targetWeb != null)
{
targetWeb.Dispose();
}
}
} //foreach
}
catch (Exception e)
{
SPSite site = (SPSite)properties.Feature.Parent;
SPWeb parentWeb = site.RootWeb;
SPList eventLog = parentWeb.Lists.TryGetList("CCPEventFeatureLog");
SPListItem item = eventLog.AddItem();
item["CCPEvents"] = "FeatureDeactivating : " + e.Message;
}
}
/// <summary>
/// 添加新操作
/// </summary>
/// <param name="action"></param>
/// <returns></returns>
private int AddAction(string action)
{
int id = 0;
SPSecurity.RunWithElevatedPrivileges(delegate()
{
try
{
using (SPSite spSite = new SPSite(SPContext.Current.Site.ID)) //找到网站集
{
using (SPWeb spWeb = spSite.OpenWeb(SPContext.Current.Web.ID))
{
SPList spList = spWeb.Lists.TryGetList(objWeb.ActionListName);
if (spList == null)
{
lblMsg.Text = objWeb.ActionListName + " 列表不存在！";
}
SPQuery qry = new SPQuery();
qry.ViewFields = "<FieldRef Name='Title' /><FieldRef Name='ID' />";
qry.Query = @"<Where><Eq><FieldRef Name='Title' /><Value Type='Text'>" + action +
"</Value></Eq></Where>";
SPListItemCollection items = spList.GetItems(qry);
if (items.Count > 0)
{
id = (int)items[0]["ID"];
}
else
{
SPListItem item = spList.Items.Add();
item[spList.Fields.GetFieldByInternalName("Title").Title] = action;
item[spList.Fields.GetFieldByInternalName("Flag").Title] = "11";
item["创建者"] = SPContext.Current.Web.CurrentUser.ID;
item.Update();
id = item.ID;
}
}
}
}
catch
{
}
});
return(id);
}
static SPListItemCollection QueryItems(SPList list)
{
var query = new SPQuery();
//query.ViewFields =
// "<FieldRef Name='Title' />" +
// "<FieldRef Name='ID' />" +
// "<FieldRef Name='ProjectGV' />";
//query.Query =
//"<OrderBy>" +
//" <FieldRef Name='ID' />" +
//"</OrderBy>" +
////"<Where>" +
////" <Contains>" +
////" <FieldRef Name='Title' />" +
////" <Value Type='Text'>q3</Value>" +
////" </Contains>" +
////"</Where>";
//query.Query = "<Where><Or><In><FieldRef Name='ProjectGV' /><Values></Values></In><Contains><FieldRef Name='ProjectGV'/><Value Type='Text'>Q3</Value></Contains></Or></Where>";
query.Query =
@"
<Where>
<Or>
<In>
<FieldRef Name='ProjectGV' />
<Values>
<Value Type='Text'>B1</Value>
<Value Type='Text'>A2</Value>
<Value Type='Text'>huy</Value>
</Values>
</In>
<Contains>
<FieldRef Name='ProjectGV'/>
<Value Type='Text'>G23</Value>
</Contains>
</Or>
</Where>
";
return(list.GetItems(query));
}
//解析新闻字符串
private ArrayList GetTitleAndTextOFList(string listUrl)
{
ArrayList txtTitle = new ArrayList();
if (listUrl.StartsWith("http://"))
{
listUrl = listUrl.Substring(listUrl.IndexOf("/", 7) + 1);
}
if (listUrl.IndexOf("&") > 0)
{
listUrl = listUrl.Substring(0, listUrl.IndexOf("&"));
}
string num = listUrl.Substring(listUrl.IndexOf("=") + 1); //当前新闻的序号
string listURl = listUrl.Substring(0, listUrl.LastIndexOf("/")); //列表url
SPWeb web = SPContext.Current.Web;
string txt;
string listName = "";
foreach (SPList myList in web.Lists)
{
if (myList.BaseTemplate == SPListTemplateType.Announcements)
{
txt = myList.DefaultDisplayFormUrl;
if (txt.Contains(listURl))
{
listName = myList.Title;
break;
}
}
}
SPList list = web.Lists.TryGetList(listName);
SPQuery query = new SPQuery();
query.ViewAttributes = "Scope='RecursiveAll'";
query.Query = "<Where><Eq><FieldRef Name='ID' /><Value Type='Counter'>" + num + "</Value></Eq></Where>";
SPListItemCollection items = list.GetItems(query);
if (items.Count > 0)
{
txtTitle.Add(items[0]["标题"].ToString());
txtTitle.Add(items[0]["正文"].ToString());
}
return(txtTitle);
}
/// <summary>
/// Get configuration settings from the list
/// </summary>
/// <param name="category"></param>
/// <returns></returns>
public string GetRCRSettingsItem(string category)
{
string description = string.Empty;
try
{
if (category == string.Empty)
{
return(description);
}
using (SPWeb web = SPContext.Current.Web)
{
SPList spList = web.Lists["PDF Settings"];
SPQuery spQuery = new SPQuery();
spQuery.Query = @"<Where><Eq><FieldRef Name='SettingsCategory'/><Value Type='CHOICE'>" + category + "</Value></Eq></Where>";
spQuery.ViewFields = String.Concat("<FieldRef Name='SettingsValue'/>");
spQuery.ViewFieldsOnly = true;
spQuery.RowLimit = 1;
SPListItemCollection spListItems = spList.GetItems(spQuery);
if (spListItems != null)
{
foreach (SPListItem spListItem in spListItems)
{
if (spListItem["SettingsValue"] != null)
{
description = spListItem["SettingsValue"].ToString();
}
}
}
}
return(description);
}
catch (Exception err)
{
LogErrorHelper objErr = new LogErrorHelper();
objErr.logErrorEmail(APP_NAME, err, "Error at GetRCRSettingsItem function");
objErr = null;
SPDiagnosticsService.Local.WriteTrace(0, new SPDiagnosticsCategory(APP_NAME, TraceSeverity.Unexpected, EventSeverity.Error), TraceSeverity.Unexpected, err.Message.ToString(), err.StackTrace);
return(string.Empty);
}
}
/// <summary>
/// SelectData Method creates a DataTable from the data fetched from SharePoint List or Doc Library and returns the DataTable
/// </summary>
/// <returns></returns>
public DataTable SelectData()
{
DataTable dataSource = new DataTable();
try
{
SPSite site = SPContext.Current.Web.Site;
SPWeb web = site.OpenWeb();
SPList lstICSSDocuments = web.Lists["PhotoList"]; //create document library or List and add column year,Description,Url,Name, Title is inbuilt.
SPQuery query = new SPQuery();
IEnumerable <SPListItem> lstItemICSSDocuments = lstICSSDocuments.GetItems(query).OfType <SPListItem>();
dataSource.Columns.Add("Year");
dataSource.Columns.Add("Description");
dataSource.Columns.Add("Name");
dataSource.Columns.Add("Title");
dataSource.Columns.Add("Url");
SPSecurity.RunWithElevatedPrivileges(delegate()
{
//SPGroup grpName = web.Groups["ICSSViewers"];
var committeeAndGroupDocumentswithURL = lstItemICSSDocuments.Select(x => new { Year = x["Year"], Description = x["Description"], Name = x["Name"], Title = x["Title"], Url = site.Url + "/" + x.Url });
foreach (var document in committeeAndGroupDocumentswithURL)
{
DataRow dr = dataSource.NewRow();
dr["Title"] = document.Title;
dr["Url"] = document.Url;
dr["Name"] = document.Name;
dr["Description"] = document.Description;
dr["Year"] = document.Year;
dataSource.Rows.Add(dr);
}
});
web.Dispose();
}
catch (Exception ex)
{
SPDiagnosticsService diagnosticsService = SPDiagnosticsService.Local;
SPDiagnosticsCategory cat = diagnosticsService.Areas["SharePoint Foundation"].Categories["Unknown"];
diagnosticsService.WriteTrace(1, cat, TraceSeverity.Medium, ex.StackTrace, cat.Name, cat.Area.Name);
SPUtility.TransferToErrorPage("Some Error occured, Please try after some time. <br/> If problem persists, contact your adminstrator");
}
return(dataSource);
}
internal SPListItemCollection GetListItemCollection(SPList spList, string keyOne, string valueOne, string keyTwo, string valueTwo, string keyThree, string valueThree)
{
// Return list item collection based on the lookup field
SPField spFieldOne = spList.Fields[keyOne];
SPField spFieldTwo = spList.Fields[keyTwo];
SPField spFieldThree = spList.Fields[keyThree];
var query = new SPQuery
{
Query = @"<Where>
<And>
<And>
<Eq>
<FieldRef Name=" + spFieldOne.InternalName + @" />
<Value Type=" + spFieldOne.Type.ToString() + @">" + valueOne + @"</Value>
</Eq>
<Eq>
<FieldRef Name=" + spFieldTwo.InternalName + @" />
<Value Type=" + spFieldTwo.Type.ToString() + @">" + valueTwo + @"</Value>
</Eq>
</And>
<Eq>
<FieldRef Name=" + spFieldThree.InternalName + @" />
<Value Type=" + spFieldThree.Type.ToString() + @">" + valueThree + @"</Value>
</Eq>
</And>
</Where>"
// Query = @"<Where>
// <And>
// <Eq>
// <FieldRef Name=" + spFieldOne.InternalName + @" />
// <Value Type=" + spFieldOne.Type.ToString() + ">" + valueOne + @"</Value>
// </Eq>
// <Eq>
// <FieldRef Name=" + spFieldTwo.InternalName + @" />
// <Value Type=" + spFieldTwo.Type.ToString() + ">" + valueTwo + @"</Value>
// </Eq>
// </And>
// </Where>"
};
return(spList.GetItems(query));
}
public override SiteMapNodeCollection GetChildNodes(SiteMapNode node)
{
ULSLog2013.LogMessage("Child Nodes was called");
SiteMapNodeCollection test = new SiteMapNodeCollection();
SPSecurity.RunWithElevatedPrivileges(delegate()
{
try
{
using (SPSite site = new SPSite(SPContext.Current.Site.ID))
{
using (SPWeb web = site.RootWeb)
{
SPList nav = web.Lists["Navigation"];
ULSLog2013.LogMessage("Found our list:" + nav.Title);
SPQuery sPQuery = new SPQuery();
sPQuery.Query = "<OrderBy><FieldRef Name='LinkOrder' Ascending='True' /><FieldRef Name='Title' Ascending='True' /></OrderBy><Where><IsNull><FieldRef Name='ParentKey' /></IsNull></Where>";
SPListItemCollection items = nav.GetItems(sPQuery);
foreach (SPListItem item in items)
{
SiteMapNode smNode = new SiteMapNode(this, item["Key"].ToString(), item["LinkURL"].ToString(), item["Title"].ToString());
test.Add(smNode);
string str = item["Key"].ToString();
SetChildNodes(str, smNode, nav);
}
ULSLog2013.LogMessage("We got this many items:" + items.Count.ToString());
}
}
}
catch (Exception ex)
{
ULSLog2013.LogError(ex, "finding list");
}
});
return(test);
}
public List <SPListItem> RetornaListaPorUrl(string urlLista, string strQuery)
{
List <SPListItem> objSaida = new List <SPListItem>();
SPList objLista =
Site.RootWeb.GetList(urlLista);
SPQuery objQuery = new SPQuery {
Query = strQuery
};
foreach (SPListItem item in objLista.GetItems(objQuery))
{
objSaida.Add(item);
}
return(objSaida);
}
private SPListItemCollection ConsultaListaEdicionUsuario()
{
SPWeb app = SPContext.Current.Web;
app.AllowUnsafeUpdates = true;
SPList Lista = app.Lists["EdicionFormularioUsuario"];
SPQuery oQuery = new SPQuery();
oQuery.Query = "<Where>" +
"<Or>" +
"<Eq><FieldRef Name='TipoFormulario'/><Value Type='TEXT'>" + "Empresa" + "</Value></Eq>" +
"<Eq><FieldRef Name='TipoFormulario'/><Value Type='TEXT'>" + "Operacion" + "</Value></Eq>" +
"</Or>" +
"</Where>" +
"<OrderBy>" + "<FieldRef Name='Modified' Ascending='True' />" + "</OrderBy>";
SPListItemCollection ColecLista = Lista.GetItems(oQuery);
return(ColecLista);
}
