本文整理汇总了C#中SPQuery类的典型用法代码示例。如果您正苦于以下问题：C# SPQuery类的具体用法？C# SPQuery怎么用？C# SPQuery使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
SPQuery类属于命名空间，在下文中一共展示了SPQuery类的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的C#代码示例。
示例1: LoadSiteSkin
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);
}
}
}
}
});
}
开发者ID:porter1130，项目名称:C-A，代码行数:30，代码来源:SiteSkinManager.cs
示例2: BatchDeleteItems
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());
}
开发者ID:porter1130，项目名称:C-A，代码行数:33，代码来源:WorkFlowUtil.cs
示例3: BindDropDownList
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);
}
}
}
});
}
开发者ID:setsunafjava，项目名称:vpsp，代码行数:35，代码来源:LinkSiteUC.ascx.cs
示例4: Execute
// 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);
}
开发者ID:s-KaiNet，项目名称:Untech.SharePoint，代码行数:30，代码来源:SpQueryContext.cs
示例5: CreateChildControls
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);
}
}
开发者ID:ricardocarneiro，项目名称:SharePoint-1，代码行数:31，代码来源:MapProvider+Test+Web+Part.cs
示例6: Build
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;
}
开发者ID:lazda，项目名称:collabode，代码行数:26，代码来源:CAMLQueryBuilder.cs
示例7: CheckandAddEntry
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);
}
}
开发者ID:Santhoshonet，项目名称:ProjectGovernanceReport，代码行数:28，代码来源:MyUtilities.cs
示例8: GetPendingFiles
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;
}
}
}
}
开发者ID:kbelote，项目名称:dummy，代码行数:31，代码来源:BUpload.cs
示例9: isUnique
//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;
}
}
开发者ID:porter1130，项目名称:C-A，代码行数:40，代码来源:Program.cs
示例10: GetNewsRecords
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;
}
开发者ID:bebikashg，项目名称:ttqn，代码行数:32，代码来源:ShowGalleryUS.ascx.cs
示例11: GetByName
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
};
}
开发者ID:valmaev，项目名称:SPEmulators，代码行数:27，代码来源:CustomerListRepository.cs
示例12: CheckDuplicate
/// <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;
}
开发者ID:vijaymca，项目名称:Dotnet，代码行数:33，代码来源:CommonDAL.cs
示例13: BindRepeater
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);
}
}
}
});
}
开发者ID:setsunafjava，项目名称:vpsp，代码行数:30，代码来源:LatestDocsUC.ascx.cs
示例14: btnSearch_Click
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();
}
开发者ID:MohitVash，项目名称:TestProject，代码行数:35，代码来源:ArticleSelectDialog.aspx.cs
示例15: FillData
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>";
}
}
}
开发者ID:porter1130，项目名称:C-A，代码行数:35，代码来源:QuickNavigator.ascx.cs
示例16: CreateWebPart
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;
}
开发者ID:kawalgrover，项目名称:MARTA-Projects，代码行数:30，代码来源:BoardMeetingReceiver.cs
示例17: SetDefaultDepartManager
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;
}
开发者ID:porter1130，项目名称:C-A，代码行数:30，代码来源:NewForm.aspx.cs
示例18: GetIdentificationTypeItem
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;
}
}
开发者ID:gcode-mirror，项目名称:chafam，代码行数:25，代码来源:IdentificationTypeBLL.cs
示例19: GetLastUpdateDate
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;
}
开发者ID:jgoodso2，项目名称:PMMP，代码行数:33，代码来源:TaskItemRepository.cs
示例20: GetDataSource
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;
}
开发者ID:porter1130，项目名称:C-A，代码行数:34，代码来源:Report.aspx.cs
注：本文中的SPQuery类示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。 |
客服电话
APP下载
官方微信
请发表评论