一个基于SharePoint查询的小例子
这几天自己做练习，写了一个基于SharePoint列表的查询，做之前是没有头绪的，做完之后才觉得是一件很简单的事情。写在日志里记录下自己的成长。前台代码：
<asp:TextBox ID="txtSearch" runat="server"></asp:TextBox>
<asp:Button ID="btnSearch" runat="server" Text="搜索" OnClick="btnSearch_Click"/>
<asp:LinkButton ID="lbtnA" runat="server" OnClick="lbtnA_Click">A</asp:LinkButton>
<asp:GridView ID="gvwAbb" runat="server" AutoGenerateColumns="False" AllowPaging="True"PageSize="2" OnPageIndexChanging="gvwAbb_PageIndexChanging">
<Columns>
<asp:TemplateField>
<HeaderTemplate>
Name
</HeaderTemplate>
<ItemTemplate>
<a href='<%#Eval("LinkFileName") %>'><%#Eval("Name") %></a>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField HeaderText="创建者/Creator" DataField="Creator" />
<asp:BoundField HeaderText="创建时间/CreateTime" DataField="CreateTime" />
</Columns>
<EmptyDataTemplate>
暂时没有符合条件的数据<br />
There is no data now
</EmptyDataTemplate>
</asp:GridView>
后台代码：
public partial class SearchAndShowControl : System.Web.UI.UserControl
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
queryAbbField = myList.Fields["splist"].InternalName;
}
}
private SPList myList = GetSPList();
private static string queryAbbField = string.Empty;//静态变量存储查询的Field，其实是一个常量更好；
private void gvwBind(SPList mylist)
{
gvwAbb.DataSource = Search(mylist, ViewState["Query"].ToString());//ViewState["Query"]查询语句
gvwAbb.DataBind();
}
protected void gvwAbb_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
gvwAbb.PageIndex = e.NewPageIndex;
this.gvwBind(myList);
}
protected void rblView_SelectedIndexChanged(object sender, EventArgs e)
{
if (Convert.ToInt32(rblView.SelectedValue) == 0)
{
ViewState["Query"] = @"<OrderBy><FieldRef Name='Created_x0020_Date' Ascending='FALSE' /></OrderBy>";//查询语句
this.gvwBind(myList);
}
if (Convert.ToInt32(rblView.SelectedValue) == 1)
{
string queryCreatorField = myList.Fields["Creator"].InternalName;
ViewState["Query"] = @"<Where><Eq><FieldRef Name='" + queryCreatorField + "' /><Value Type='Text'>" + this.Page.User.Identity.Name + "</Value></Eq></Where><OrderBy><FieldRef Name='Created_x0020_Date' Ascending='FALSE' /></OrderBy>";
this.gvwBind(myList);
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
if (txtSearch.Text != string.Empty)
{
ViewState["Query"] = @"<Where><Contains><FieldRef Name='" + queryAbbField + "' /><Value Type='Text'>" + txtSearch.Text + "</Value></Contains></Where><OrderBy><FieldRef Name='Created_x0020_Date' Ascending='FALSE' /></OrderBy>";
this.gvwBind(myList);
}
else
{
ViewState["Query"] = @"<OrderBy><FieldRef Name='Created_x0020_Date' Ascending='FALSE' /></OrderBy>";
this.gvwBind(myList);
}
}
//一共26个英文字母，查询queryAbbField域以某个字母开始的，并且按创建时间倒序排序，这里只显示A的，其他都一样。
protected void lbtnA_Click(object sender, EventArgs e)
{
ViewState["Query"] = @"<Where><BeginsWith><FieldRef Name='" + queryAbbField + "' /><Value Type='Text'>a</Value></BeginsWith></Where><OrderBy><FieldRef Name='Created_x0020_Date' Ascending='FALSE' /></OrderBy>";
this.gvwBind(myList);
}
public static SPList GetSPList()//获得当前的SPList
{
SPSite mysite = new SPSite(http://ComputerName/sites/cn);
SPWeb myweb = SPContext.Current.Web;
SPList mylist = myweb.Lists["splist"];
return mylist;
}
//定义了一个类Message，定义一些属性，Name，Creator等等。
public static List<Message> Search(SPList mylist, string myquery)
{
SPQuery query = new SPQuery();
query.Query = myquery;
SPListItemCollection myitems = mylist.GetItems(query);
return AddList(myitems);
}
public static List<Message> AddList(SPListItemCollection items)
{
List<Message> messages = new List<Message>();
foreach (SPListItem item in items)
{
Message msg = new Message();
msg.Abbreviation = item["Name"].ToString();
msg.ForeignName = item["Department"].ToString();
msg.Creator = item["Creator"].ToString();
msg.CreateTime = Convert.ToDateTime(item["创建时间"]);
msg.LinkFileName = item.File.ServerRelativeUrl;
messages.Add(msg);
}
return messages;
}
页:
[1]