一个基于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;
        }

转载于:https://www.cnblogs.com/jerryshi/archive/2008/01/03/1024912.html