sharepoint绑定

private static PagedDataSource pds = new PagedDataSource();

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {      
                BindData();
            }
        }
        private void BindData()
        {
            var leaderMailBox = SharePointUtility.GetListItemDictionary<领导信箱>("LeaderMailBox");
            IEnumerable<领导信箱> LeaderMail = leaderMailBox.Values
                                .Where(item => item.回复是否显示 == "是")
                                .OrderByDescending(item => item.提交日期);

            int newsCount = LeaderMail.Count();
            if (newsCount <=0)
            {
                Label1.Text = "暂无数据";
            }
            else
            {
                Label1.Text = "";
            }
            AspNetPager.RecordCount = newsCount;
            AspNetPager.PageSize = 20;
            pds.DataSource = LeaderMail.ToList();
            pds.AllowPaging = true; //数据源  允许分页
            pds.CurrentPageIndex = AspNetPager.CurrentPageIndex - 1; //显示 当前页  
            pds.PageSize = AspNetPager.PageSize; //取控件 分页大小  
            BindToList();
        }
        private void BindToList()
        {
           
                rpt_mailList.DataSource = pds;
                rpt_mailList.DataBind();
            
        }

        protected void AspNetPager_PageChanged(object src, EventArgs e)
        {
            pds.CurrentPageIndex = AspNetPager.CurrentPageIndex - 1; //显示 当前页  
            pds.PageSize = AspNetPager.PageSize; //取控件 分页大小  
            BindToList();
        }

 

 protected void PrePage_Click(object sender, EventArgs e)
        {
             //string SiteUrl = SPContext.Current.Web.Url;
             //using (SPLinqDataContext SiteData = new SPLinqDataContext(SiteUrl))
             //{
                 
                 var LeaderMailFilter = LeaderMail
                     .Where(item => item.回复是否显示 == "是")
                     .OrderByDescending(item => item.提交日期)
                     .ToList();
                 int index =
                     LeaderMailFilter.FindIndex(item => item.ID == Convert.ToInt32(ViewState["ID"]));
                 if (index > 0)
                 {
                     index--;
                     int ID = LeaderMailFilter.ElementAt(index).ID;
                     BindData(ID);
                 }
                 else
                 {
                     mailTitle = Convert.ToString(ViewState["Title"]);
                 }
             //}
        }

        protected void NextPage_Click(object sender, EventArgs e)
        {
            var LeaderMailFilter = LeaderMail
                  .Where(item => item.回复是否显示 == "是")
                  .OrderByDescending(item => item.提交日期)
                  .ToList();
            int index =
               LeaderMailFilter.FindIndex(item => item.ID == Convert.ToInt32(ViewState["ID"]));
            //int index = LeaderMail.ToList().FindIndex(item => item.ID == Convert.ToInt32(ViewState["ID"]) && item.处理结果=="显示");

            if (index < LeaderMailFilter.Count() - 1)
                {
                    index++;
                    int ID = LeaderMailFilter.ElementAt(index).ID;
                    BindData(ID);
                }
                else
                {
                    mailTitle = Convert.ToString(ViewState["Title"]);
                }
            
        }

 

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.SharePoint;
using System.Diagnostics;
using System.Web;
using Microsoft.SharePoint.WebControls;
using System.IO;

namespace Cbw_SinopecPortal_WebPart
{
    class SharePointUtility
    {
        public static int GetLookupID(object field)
        {
            string fieldValue = field.ToString();
            return Convert.ToInt32(fieldValue.Substring(0, fieldValue.IndexOf(";#")));
        }

        public static string GetLookupLink(object field)
        {
            string fieldValue = Convert.ToString(field);
            if (string.IsNullOrEmpty(fieldValue))
            {
                return null;
            }
            else
            {
                return fieldValue.Substring(0, fieldValue.IndexOf(", "));
            }
        }

        public static SPList GetList(string listName)
        {
            listName = "Lists/" + listName;
            foreach (SPList list in SPContext.Current.Web.Lists)
            {
                if (list.RootFolder.Url == listName)
                {
                    return list;
                }
            }
            throw new Exception("不存在指定的列表：" + listName);
        }

        public static SPList GetDocumentLibaray(string libarary)
        {
            foreach (SPList list in SPContext.Current.Web.Lists)
            {
                if (list.RootFolder.Url == libarary)
                {
                    return list;
                }
            }
            throw new Exception("不存在指定的文檔庫：" + libarary);
        }

        public static SPList GetListOrDocumentLibaray(string name)
        {
            string listName = "Lists/" + name;
            foreach (SPList list in SPContext.Current.Web.Lists)
            {
                if (list.RootFolder.Url == listName || list.RootFolder.Url == name)
                {
                    return list;
                }
            }
            throw new Exception("不存在指定的列表OR文檔庫：" + name);
        }

        public static Dictionary<int, T> GetListItemDictionary<T>(string listName)
            where T : Entity.Item, new()
        {
            var list = SharePointUtility.GetList(listName);
            var items = from item in list.GetItems(new SPQuery()).Cast<SPListItem>()
                        select new { item.ID, Value = Entity.Item.Create<T>(item) };
            return items.ToDictionary(item => item.ID, item => item.Value);
        }

        public static Dictionary<int, T> GetListItemDictionary<T>(string listName, SPQuery spquery)
            where T : Entity.Item, new()
        {
            var list = SharePointUtility.GetList(listName);
            var items = from item in list.GetItems(spquery).Cast<SPListItem>()
                        select new { item.ID, Value = Entity.Item.Create<T>(item) };
            return items.ToDictionary(item => item.ID, item => item.Value);
        }

        public static Dictionary<int, T> GetDocumentItemDictionary<T>(string listName)
             where T : Entity.Item, new()
        {
            var list = SharePointUtility.GetDocumentLibaray(listName);
            var items = from item in list.GetItems(new SPQuery()).Cast<SPListItem>()
                        select new { item.ID, Value = Entity.Item.Create<T>(item) };
            return items.ToDictionary(item => item.ID, item => item.Value);
        }

        public static Dictionary<int, T> GetFolderDictionary<T>(string listName)
            where T : Entity.Item, new()
        {
            var list = SharePointUtility.GetDocumentLibaray(listName);
            var items = from item in list.Folders.Cast<SPListItem>()
                        select new { item.ID, Value = Entity.Item.Create<T>(item) };
            return items.ToDictionary(item => item.ID, item => item.Value);
        }

        public static T FindDocLibObj<T>(int ID, IEnumerable<T> Content)
            where T : Entity.DocumentLibrary<T>, new()
        {
            var item = Content.Where(p => p.ID == ID).FirstOrDefault();
            if (item != null)
            {
                return item;
            }
            foreach (var contentItem in Content.Where(p => p.IsFolder))
            {
                T result = FindDocLibObj(ID, contentItem.FolderCotent.Values);
                if (result != null)
                {
                    return result;
                }
            }
            return null;
        }

        public static int GetTotalSubFileCountForCollection<T>(IEnumerable<T> Collection)
            where T : Entity.DocumentLibrary<T>, new()
        {
            int TempSum = 0;
            foreach (var item in Collection.Where(item => item.IsFolder))
            {
                TempSum += GetTotalSubFileCountForFolder(item);
            }
            return TempSum + Collection.Count(p => !p.IsFolder);
        }

        public static int GetTotalSubFileCountForFolder<T>(T DocLibObj)
            where T : Entity.DocumentLibrary<T>, new()
        {
            int TempSum = 0;
            foreach (var DocLibObjItem in DocLibObj.FolderCotent.Values.Where(p => p.IsFolder))
            {
                TempSum += GetTotalSubFileCountForFolder(DocLibObjItem);
            }
            return TempSum + DocLibObj.FolderCotent.Values.Count(p => !p.IsFolder);
        }

        public static string GetAttachmentUrl(SPAttachmentCollection Attachments)
        {
            if (Attachments != null && Attachments.Count > 0)
            {
                return Attachments.UrlPrefix + Attachments[0];
            }
            return null;
        }

        public static void WriteLog(Exception ex)
        {
            try
            {
                Debug.WriteLine(ex);
                SPSecurity.RunWithElevatedPrivileges(delegate()
                {
                    EventLog.WriteEntry("Cbw_SinopecPortal", ex.ToString());
                });
            }
            catch
            {

            }
        }

        public static void PrivateLogin(string siteUrl)
        {
            SPSite site = new SPSite(siteUrl);
            SPWeb web = site.OpenWeb();
            HttpRequest httpRequest = new HttpRequest("", web.Url, "");
            HttpContext.Current = new HttpContext(httpRequest, new HttpResponse(new StringWriter()));
            SPControl.SetContextWeb(HttpContext.Current, web);
        }
    }
}