Repeater + Resources 列表 [原创][分享]

根据公司的业务要求写了一个列表控件，大致实现以下功能（大体思路实现）
1、数据绑定（可根据设置显示隐藏列表字段）
2、根据resources文件设置列表头
3、排序，分页
4、列表的筛选功能
主体代码：
前台页面设置控件代码

<div id="listTitle" style="width: 100%" class="bgblue">
                        <ul>
                            <li style="width: 30px; text-align: center; float: left;" class="bgblue">选择</li>
                            <asp:Label ID="c1" runat="server" ></asp:Label>
                            <asp:Label ID="c2" runat="server" ></asp:Label>
                            <asp:Label ID="c3" runat="server" ></asp:Label>
                            <asp:Label ID="c4" runat="server" ></asp:Label>
                            <asp:Label ID="c5" runat="server" ></asp:Label>
                            <asp:Label ID="c6" runat="server" ></asp:Label>
                            <asp:Label ID="c7" runat="server" ></asp:Label>
                            <asp:Label ID="c8" runat="server" ></asp:Label>
                            <asp:Label ID="c9" runat="server" ></asp:Label>
                            <asp:Label ID="c10" runat="server" ></asp:Label>
                        </ul>
                    </div>
                    <div id="joblist">
                        <asp:Repeater ID="resume" runat="server">
                            <ItemTemplate>
                                <div style="width: 100%" class="navlist" id='<%# DataBinder.Eval(Container.DataItem, "ResumeID") %>'>
                                    <ul>
                                        <li style="width: 30px; text-align: center; float: left;">
                                            <input type="checkbox" name="checkbox" style="cursor: hand" value="<%# DataBinder.Eval(Container.DataItem, "id") %>"
                                                keyid='<%# DataBinder.Eval(Container.DataItem, "id") %>' url='<%# DataBinder.Eval(Container.DataItem, "url") %>'"'>
                                        </li>
                                        <asp:Label ID="column1" runat="server" ></asp:Label>
                                        <asp:Label ID="column2" runat="server" ></asp:Label>
                                        <asp:Label ID="column3" runat="server" ></asp:Label>
                                        <asp:Label ID="column4" runat="server" ></asp:Label>
                                        <asp:Label ID="column5" runat="server" ></asp:Label>
                                        <asp:Label ID="column6" runat="server" ></asp:Label>
                                        <asp:Label ID="column7" runat="server" ></asp:Label>
                                        <asp:Label ID="column8" runat="server" ></asp:Label>
                                        <asp:Label ID="column9" runat="server" ></asp:Label>
                                        <asp:Label ID="column10" runat="server" ></asp:Label>
                                    </ul>
                                </div>
                            </ItemTemplate>
                        </asp:Repeater>
                    </div>

后台代码实现：

  1using System;
  2using System.Collections;
  3using System.Configuration;
  4using System.Data;
  5using System.Linq;
  6using System.Web;
  7using System.Web.Security;
  8using System.Web.UI;
  9using System.Web.UI.HtmlControls;
 10using System.Web.UI.WebControls;
 11using System.Web.UI.WebControls.WebParts;
 12using System.Xml.Linq;
 13
 14using System.Text;
 15using System.Reflection;
 16using System.Collections.Generic;
 17using System.Resources;
 18
 19public partial class _Receive : PageBase
 20{
 21    /**//// <summary>
 22    /// 初始默认值（显示列的字段）（数组）
 23    /// </summary>
 24    private string[] columns = new string[] { 
 25        "IsSee",//是否查看  +1
 26        "JobSeekerName",//求职者姓名    +2
 27        "Jobname",//职位名称     +3
 28        "WorkYear",//工作年限  +4
 29        "NowCityCodevalue",//所在地址 +5
 30        "Degreevalue",//学历    +6
 31        "CreateDate",//创建日期 +7
 32        "SystemLeach",//系统过滤
 33        "Assess",//简历评估
 34        "Photo"//相片
 35    };
 36
 37    private string[] CheckedRequestString = new string[]{
 38        "JOBId",//职位id
 39        "pjno",//折叠
 40        "menuid",//套红
 41        "positionid",//职位夹id
 42        "summarystyleid",//列表显示样式
 43        "workyear",//工作年限
 44        "address",//地址
 45        "degree",//学历
 46        "tradeid",//行业id
 47        "job",//岗位id
 48        "sex",//性别
 49        "vocationalid",//专业
 50        "time",//日期
 51        "wy",
 52        "szdz",
 53        "xl"
 54    };
 55
 56    /**//// <summary>
 57    /// 初始默认值（显示列的字段）
 58    /// </summary>
 59    private string seachShowColumns = PageBase.GetDefaultColumnCode(PageBase.PageTableNo.Receive.ToString());
 60
 61    /**//// <summary>
 62    /// 初始排序字段
 63    /// </summary>
 64    private string sortColumn = "CreateDate";
 65    /**//// <summary>
 66    /// 初始排序的方式
 67    /// </summary>
 68    private string sortDirection = "ASC";
 69
 70    protected void Page_Load(object sender, EventArgs e)
 71    {
 72        if (!this.IsPostBack)
 73        {
 74            this.ddlDatabind();
 75            this.InitColumns();
 76            this.GetReceiveDatabind();
 77
 78            /**////
 79            this.txtwork.Value = System.DateTime.Now.ToString("yyyy-MM-dd");
 80            /**////
 81        }
 82    }
 83    数据列表加载#region 数据列表加载
 84
 85    /**//// <summary>
 86    /// pageload的时候加载列表头
 87    /// </summary>
 88    private void InitColumns(){
 89        PageTableProfileBAL ptpb;
 90        PageTableProfileBAL.GetInstance(out ptpb);
 91        List<PageTableProfile> ptp = ptpb.GetPageTableProfileByColmn(UserID, PageBase.PageTableNo.Receive.ToString());
 92        
 93        string keycontent = ptp.Count == 1 && ptp[0].SeachShowColumns != "" ? ptp[0].SeachShowColumns : this.SeachShowColumns;
 94        
 95        //string CheckedColumnReplace = "SendStatus,IsSee,IsFavOrBuy,";
 96        //if (keycontent.IndexOf(CheckedColumnReplace) == -1)
 97        //    keycontent = CheckedColumnReplace + keycontent;
 98
 99        /**////modfiy by john on 2008-05-24 
        ///加上需要显示的图片信息。 定义当前的图片以及还原位置.
        string CheckedColumnReplace = "IsSee,SystemLeach,Assess,Photo,";
        if (keycontent.IndexOf(CheckedColumnReplace) == -1)
            keycontent = CheckedColumnReplace + keycontent;

        string keycontentcopyto = "";

        foreach (string defaultcolumnkey in this.columns)
        {
            if (keycontent.IndexOf(defaultcolumnkey) > -1)
            {
                keycontentcopyto += defaultcolumnkey + ",";
            }
        }
        keycontent = keycontentcopyto.TrimEnd(',');

        columns = ResizeColumns(keycontent.Split(",".ToCharArray()));
        string virtualPath = Page.Request.ApplicationPath + "/Receive.aspx";

        for (int i = 0; i < columns.Length; i++)
        {
            ContentPlaceHolder cp = (ContentPlaceHolder)Master.FindControl("content_plane");
            Label label = cp.FindControl("c" + (i + 1)) as Label;
            label.Text = CreateHeaderColumn(GetColumnText(virtualPath, columns[i]), columns[i]);
        }
    }

    /**//// <summary>
    /// 获得列表显示字段的描述
    /// </summary>
    /// <param name="virtualPath"></param>
    /// <param name="columnName"></param>
    /// <returns></returns>
    private string GetColumnText(string virtualPath, string columnName)
    {
        /**////modify john at 2008-05-29 
        ///手动识别资源文字
        return HttpContext.GetLocalResourceObject(virtualPath, "Column_" + columnName).ToString() == "创建时间" ? "更新日期" : HttpContext.GetLocalResourceObject(virtualPath, "Column_" + columnName).ToString();
    }

    /**//// <summary>
    /// 创建列表头部
    /// </summary>
    /// <param name="text"></param>
    /// <param name="columnName"></param>
    /// <returns></returns>
    private string CreateHeaderColumn(string text, string columnName)
    {
        StringBuilder sb = new StringBuilder();

        if (columnName == "SystemLeach" || columnName == "IsSee" || columnName == "Assess" || columnName == "Photo")   /**////图标的特殊形式处理
        {
            sb.AppendFormat("<li style=\"width:16px;text-align: center;float: left;\" class=\"bgblue\">");
            sb.Append("</li>");
        }
        else
        {
            
            /**////标签标准形式的处理
            sb.AppendFormat("<li style=\"width:{0}px;text-align: center;float: left;\" class=\"bgblue\">", GetColumnWidth(columnName, this.columns.Length));
            sb.AppendFormat("<img src=\"{0}\" width=\"7\" height=\"4\" hspace=\"4\" border=\"0\" align=\"absmiddle\"/>", GetSortImageName(columnName));
            sb.AppendFormat("<a href='#' class='dark2' id='{1}' onclick=tableSort(this,'{2}')>{0}</a>", text, columnName, this.sortDirection);
            sb.Append("</li>");
            break;
            
        }
        return sb.ToString();
    }


    /**//// <summary>
    /// 排序显示相对应的image
    /// </summary>
    /// <param name="columnName"></param>
    /// <returns></returns>
    private string GetSortImageName(string columnName)
    {
        if (this.sortColumn == columnName)
        {
            if (this.sortDirection == "ASC")
            {
                //return "jian.gif";
                return "http://xxxxx/App_Themes/default/jobseekers/images/desc.gif";
            }
            else
            {
                //return "up.gif";
                return "http://xxxxxx/App_Themes/default/jobseekers/images/asc.gif";
            }
        }
        else
        {
            return "http://xxxxxx/App_Themes/default/jobseekers/images/up.gif";
        }
    }

    /**//// <summary>
    /// 得到需要显示的列的个数
    /// </summary>
    /// <param name="columns"></param>
    /// <returns></returns>
    private string[] ResizeColumns(string[] columns)
    {
        string[] cc = null;
        if (columns.Length > 11)
        {
            cc = new string[11];
            for (int i = 0; i < 11; i++)
            {
                cc[i] = columns[i];
            }
        }
        else
        {
            cc = columns;
        }
        return cc;
    }

    /**//// <summary>
    /// 得到列表与头部标签的宽度
    /// </summary>
    /// <param name="columnName"></param>
    /// <param name="columnCount"></param>
    /// <returns></returns>
    private string GetColumnWidth(string columnName, int columnCount)
    {
        int tablewidth = 705,width = 0,length = this.columns.Length-4;tablewidth = 705 - (16 * 4) - 30;
        width = tablewidth / length;
        return width.ToString();
    }

    /**//// <summary>
    /// 数据访问，绑定列表集
    /// </summary>
    public void GetReceiveDatabind()
    {
        FavoriteBAL frb;
        FavoriteBAL.GetInstance(out frb);
        List<Favorite> fr = new List<Favorite>();
        
        sortColumn = this.__sortorder.Value;
        sortColumn = sortColumn == string.Empty ? "CompanyID" : sortColumn;
        string orderdesc = sortColumn + " " + sortDirection;

        this.pager1.PageUrl = CheckedRequest();

        int RecordCount = 0;
        pager1.PageSize = getPageSize() == 0 ? 20 : getPageSize();
        fr = frb.GetFavoriteSequence(search() + searchkey() , pager1.CurrentPageIndex,orderdesc, true, ref RecordCount, pager1.PageSize, true,false);

        pager1.RecordCount = RecordCount;
        this..DataSource = fr;
        this..ItemDataBound += new RepeaterItemEventHandler(_ItemDataBound);
        this..DataBind();
    }

    protected int getPageSize()
    {
        PageTableProfileBAL ptpb;
        PageTableProfileBAL.GetInstance(out ptpb);
        List<PageTableProfile> ptp = ptpb.GetPageTableProfileByColmn(UserID, PageBase.PageTableNo.Receive.ToString());
        int pagesizeinit = 0;
        if (ptp.Count == 1)
            pagesizeinit = ptp[0].SearchResultPageSize;
        return pagesizeinit;
    }

    /**//// <summary>
    /// 循环读取设置列表值
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    void _ItemDataBound(object sender, RepeaterItemEventArgs e)
    {
        RepeaterItem item = e.Item;
        Favorite fr = item.DataItem as Favorite;
        for (int i = 0; i < columns.Length; i++)
        {
            Label label1 = item.FindControl("column" + (i + 1)) as Label;
            label1.Text = GetValue(fr, i);
        }
    }

    /**//// <summary>
    /// 获得列表显示相应的字段值
    /// </summary>
    /// <param name="fr"></param>
    /// <param name="index"></param>
    /// <returns></returns>
    private string GetValue(Favorite fr, int index)
    {
        if (index > columns.Length || index == -1) return "";
        PropertyInfo info = fr.GetType().GetProperty(columns[index].ToString());
        string text = string.Empty;
        if (info.GetValue(fr, null) != null)
        {
            text = info.GetValue(fr, null).ToString();
        }
        StringBuilder sb = new StringBuilder();

        if (columns[index].Equals("SystemLeach") || columns[index].Equals("IsSee") || columns[index].Equals("Assess") || columns[index].Equals("Photo"))
        {
            sb.AppendFormat("<li style=\"width:16px;text-align: center;float: left;\">");//class=\"" + columns[index] + "\"
            switch (columns[index])
            {
                case "SystemLeach":
                    sb.AppendFormat("{0}", "<img src=\"http://xxx/v5/images/03525520.gif\" width=\"16\" height=\"16\" />");
                    break;
                case "IsSee":
                    sb.AppendFormat("{0}", "<img src=\"http://xxx/v5/images/17_03.gif\" width=\"16\" height=\"16\" />");
                    break;
                case "Assess":
                    sb.AppendFormat("{0}", "<img src=\"http://xxx/v5/images/17_01.gif\" width=\"16\" height=\"16\" />");
                    break;
                case "Photo":
                    sb.AppendFormat("{0}", "<img src=\"http://xxx/v5/images/17_04.gif\" width=\"16\" height=\"16\" />");
                    break;
            }
            
            sb.Append("</li>");
        }
        else
        {
            sb.AppendFormat("<li style=\"width:{0}px;text-align: center;float: left; overflow:hidden;'>\">", GetColumnWidth(columns[index], this.columns.Length));//class=\"" + columns[index] + "\"
            if (columns[index].Equals("CreateDate"))
                text = Convert.ToDateTime(text).ToString("yyyy-MM-dd");
            if (columns[index].Equals("WorkYear"))
            {
                if (text == "0")
                    text = "应届毕业";
                else
                    text += "年";
            }
            sb.AppendFormat("{0}", text);
            sb.Append("</li>");
        }
        return sb.ToString();
    }
    #endregion

    设置需要查询的条件#region 设置需要查询的条件

    private string search()
    {
        return "delstatus != " + (int)PageBase.DelStatus.Yes + " and status = " + (int)PageBase.Status.Receive + " and userid = '" + UserID + "'";
    }


   
    #endregion

    

    自定义属性#region 自定义属性

    private List<Favorite> FavoriteTable
    {
        get
        {
            return ViewState["FavoriteTable"] as List<Favorite>;
        }
        set
        {
            ViewState["FavoriteTable"] = value;
        }
    }

    public string SeachShowColumns
    {
        get { return this.seachShowColumns; }

        set
        {
            if (!string.IsNullOrEmpty(value))
            {
                this.seachShowColumns = value;
            }
        }
    }
    protected void btnsort_Click(object sender, EventArgs e)
    {
        sortColumn = this.__sortorder.Value;
        sortDirection = this.__sortDir.Value;

        this.InitColumns();
        this.GetReceiveDatabind();
    }

    #endregion
}