aspx页面Repeater嵌套Repeater

我就是我 2021-11-22 15:36 283阅读 0赞

//--------------以下为\*.aspx页面Repeater嵌套Repeater:----------------------------------------

<table width="700" border="0" cellspacing="0" cellpadding="0">  
                  <tr>  
                    <td width="21" valign="top" background="http://images.cnblogs.com/pic/small-Tbl-left-bg.jpg"><img src="http://images.cnblogs.com/pic/small-Tbl\_02.jpg" width="21" height="62" alt=""></td>  
                    <td valign="top" class="jianbian-B"><table style="margin-top:5px;" border="0" cellspacing="0" cellpadding="0">  
                      <tr>  
                        <td width="20"><img src="http://images.cnblogs.com/pic/tubiao-1.jpg" /></td>  
                        <td class="STYLE-chenghuang-font"> \*\*\*\*\*</td>  
                      </tr>  
                    </table>  
     <table style="margin-top:20px" width="100%" border="0" cellspacing="0" cellpadding="0">  
                      <tr>  
                        <td width="40"><span style="FLOAT: left">届数：</span></td>  
                        <td width="70"><asp:TextBox ID="txtFallNum" runat="server" Width="50px"></asp:TextBox></td>  
                        <td width="40"><div align="center">日期：</div></td>  
                        <td width="70">  
          <asp:dropdownlist id="ddlStartDate" runat="server" Width="80px">  
                                 <asp:ListItem Value="">不限</asp:ListItem>  
       <asp:ListItem Value="09-07">9月7日</asp:ListItem>  
       <asp:ListItem Value="09-08">9月8日</asp:ListItem>  
       <asp:ListItem Value="09-09">9月9日</asp:ListItem>  
       <asp:ListItem Value="09-10">9月10日</asp:ListItem>  
       <asp:ListItem Value="09-11">9月11日</asp:ListItem>  
       <asp:ListItem Value="09-12">9月12日</asp:ListItem>  
                          </asp:dropdownlist></td>  
                        <td width="40"><div align="center">至</div></td>  
                        <td>   
           <asp:dropdownlist id="ddlEndDate" runat="server" Width="80px">  
                                <asp:ListItem Value="">不限</asp:ListItem>  
       <asp:ListItem Value="09-07">9月7日</asp:ListItem>  
       <asp:ListItem Value="09-08">9月8日</asp:ListItem>  
       <asp:ListItem Value="09-09">9月9日</asp:ListItem>  
       <asp:ListItem Value="09-10">9月10日</asp:ListItem>  
       <asp:ListItem Value="09-11">9月11日</asp:ListItem>  
       <asp:ListItem Value="09-12">9月12日</asp:ListItem>  
                          </asp:dropdownlist>名称：<asp:textbox id="txtMeeting" runat="server" Width="130px"></asp:textbox>  
                                <asp:button id="btnFind" runat="server" CssClass="btn\_2k3" Text="查询" OnClick="btnFind\_Click"></asp:button>  
                              <asp:regularexpressionvalidator id="re" Runat="server" ValidationExpression="\\d+" ControlToValidate="txtFallnum"  
           ErrorMessage="请输入整数！"></asp:regularexpressionvalidator></td>  
                      </tr>  
                    </table>  
     <table style="margin-top:10px;" id="Table2" cellspacing="0" cellpadding="0" width="100%" border="0" runat="server">  
                <tr>  
                  <td>  
                  <asp:Repeater id="rptCategories" runat="server" OnItemDataBound="rptCategories\_ItemDataBound">  
                      <HeaderTemplate>  
                        <table width="100%" border="1" bordercolor="\#FFB24D"cellspacing="0" cellpadding="0" style="border-collapse:collapse; line-height:1.5em">  
                        <tr style="text-align: center;" >  
                        <td class="chengsetitle">  
                           会议名称  
                        </td>  
                        <td class="chengsetitle">  
                            日期  
                        </td>  
                        <td class="chengsetitle">  
                           时间  
                        </td>  
                        <td class="chengsetitle">  
                           地点  
                        </td>  
                        <td class="chengsetitle">  
                           在线报名  
                        </td>  
                        </tr>  
                      </HeaderTemplate>  
                      <ItemTemplate>  
                          
                        <tr style="text-align: left;height:30px"><td colspan="5" ><b><%\# Eval("ClassName") %></b></td></tr>  
                          
                        <asp:Repeater id="rptProduct" runat="server">  
                          <ItemTemplate>  
                            <tr style="text-align: left;height:26px">  
            <td style="text-align: left;width:180px">  
                <asp:HyperLink id="lbtnMeeting" runat="server" NavigateUrl='<%\# DataBinder.Eval(Container, "DataItem.f\_id")+".html"%>' Target="\_blank" Text='<%\# DataBinder.Eval(Container, "DataItem.Meeting") %>'> </asp:HyperLink>  
            </td>  
            <td style="text-align: center;width:60px" ><%\# Eval("StartDate")%>  
            </td>  
            <td style="text-align: center;width:100px">  
                <%\# Eval("endDate")%>  
            </td>  
            <td style="text-align: left;width:150px">  
                <%\# Eval("adress")%>  
            </td>  
            <td style="text-align: center;width:50px">  
               <a href='<%\# "\*\*\*\*\*.aspx?f\_id="+DataBinder.Eval(Container, "DataItem.F\_ID") %>' target="\_blank"><%\# DataBinder.Eval(Container, "DataItem.IsSign").ToString() == "1"?"报名":""%></a>  
            </td>  
                            </tr>  
                          </ItemTemplate>  
                        </asp:Repeater>  
                      </ItemTemplate>  
                      <FooterTemplate>  
                        </table>  
                      </FooterTemplate>  
                    </asp:Repeater>  
               
                  </td>  
                </tr>  
                <tr style="height:35px">  
                  <td align="right">  
                      <uc2:Pager ID="Pager1" runat="server" />  
                  </td>  
                </tr>  
            </table>  
     </td>  
                    <td ></td>  
                  </tr>  
                </table>

//-----------------------以下为页面代码-------------------------------

Security mySecurity;  
        int rptRowsCount;//初始化嵌套rpt的当前已显示行的行数  
        string rptClassName;//rpt前一页最后一个ClassName  
        int rptClassNameCount;//rpt前一页最后一个ClassName显示在rpt上的行数

protected void Page\_Load(object sender, EventArgs e)  
        \{  
            if (!Page.IsPostBack)  
            \{  
                string strFallnum = txtFallNum.Text.Trim();  
                string strWhere = "";  
                if (Request\["list"\] != null)  
                \{  
                    \#region 页面附值  
                    mySecurity = new Security();  
                    string pars = mySecurity.DecryptQueryString(Request\["list"\]);//解密  
                    string\[\] tmplist = pars.Split(',');

this.txtFallNum.Text = tmplist\[1\];  
                    this.ddlStartDate.SelectedIndex = this.ddlStartDate.Items.IndexOf(this.ddlStartDate.Items.FindByValue(tmplist\[2\]));  
                    this.ddlEndDate.SelectedIndex = this.ddlEndDate.Items.IndexOf(this.ddlEndDate.Items.FindByValue(tmplist\[3\]));  
                    this.txtMeeting.Text = tmplist\[4\];  
                    if (ViewState\["strWhere"\] != null)  
                    \{  
                        strWhere = ViewState\["strWhere"\].ToString();  
                    \}  
                    else  
                    \{  
                        strWhere = this.getWhere();  
                    \}  
                    \#endregion  
                \}  
                else  
                \{  
                    \#region 页面初始  
                    this.txtFallNum.Text = SysConfig.GetFallNum();  
                    strWhere = this.getWhere();  
                    \#endregion  
                \}  
                DataBind(strWhere);  
            \}  
        \}

\#region 绑定Repeater  
        private void DataBind(string strCondition)  
        \{  
            rptRowsCount = 0;//初始化嵌套rpt的当前已显示行的行数为0

\#region 条件  
            string fldName = "DictID,F\_id,ClassName,Meeting,Sponsor,UnderTaker,Coopertion,Subject,"  
                + " endDate,Adress,StartDate,Scale,Speaker,Content,SysDate,ContactWay,OrderBy,"  
                + "issign ,newOrderBy=(case when OrderBy is null then 1000 else OrderBy end)";  
            string tblName = "T\_Forum\_Info t left join t\_sysdictdetail s on t.ClassName=s.DictName\_C";  
            strCondition += " and beforecheck=1 and lang=0 and tablename='t\_forum\_info' and fieldname='classname'";// Order by newOrderBy";  
            \#endregion

\#region 绑定分页  
            Pager1.UrlFormat = "?list=";//分页格式  
            Pager1.RecordCount = dbAccess.GetCount(tblName, strCondition, fldName);//取得总记录数  
            Pager1.PageSize = SysConfig.GetPageSize("Forum");//为0时，默认读取配置文件的分页数  
            \#endregion

\#region 绑定数据  
            int pageIndex;  
            if (this.Pager1.SetPageIndex == 1)  
                pageIndex = 1;  
            else  
                pageIndex = this.Pager1.PageIndex;  
            DataSet ds,ds\_cn;  
            int StartNum = this.Pager1.PageSize \* (this.Pager1.PageIndex - 1) + 1;  
            int EndNum = this.Pager1.PageSize \* this.Pager1.PageIndex;  
            string tblName\_P = "(" + getPageList(tblName, fldName, StartNum, EndNum, "DictID,StartDate,endDate", true, strCondition, "F\_ID") + ") as a";  
            ds = dbAccess.GetDataSet(tblName\_P, "distinct DictID,ClassName", "", "DictID");  
            this.Pager1.PageCount = System.Convert.ToInt32(Math.Ceiling((Decimal)Pager1.RecordCount / Pager1.PageSize));//获取页数

\#region rptClassName和rptClassNameCount值计算  
            if (this.Pager1.PageIndex == 1)  
            \{  
                //当前页为第一页的时候  
                rptClassName = "";  
                rptClassNameCount = 0;  
                if(ds.Tables\[0\].Rows.Count>0)  
                    rptClassName = ds.Tables\[0\].Rows\[ds.Tables\[0\].Rows.Count - 1\]\["CLassName"\].ToString();//放在这个位置则取rpt的最后一个类别  
            \}  
            else  
            \{  
                //取得前一页的最后一个列名和列的显示数  
                StartNum = this.Pager1.PageSize \* (pageIndex - 1 - 1) + 1;  
                EndNum = this.Pager1.PageSize \* (pageIndex - 1);  
                tblName\_P = "(" + getPageList(tblName, fldName, StartNum, EndNum, "DictID,StartDate,endDate", true, strCondition, "F\_ID") + ") as a";  
                ds\_cn = dbAccess.GetDataSet(tblName\_P, "", "", "DictID");  
                int ss = 0;  
                //获取前页的最后一个类别,为了判断下一页与本页最后一个类别做判断  
                if (ds\_cn.Tables\[0\].Rows.Count > 0)  
                \{  
                    rptClassName = ds\_cn.Tables\[0\].Rows\[ds\_cn.Tables\[0\].Rows.Count - 1\]\["CLassName"\].ToString();  
                    for (int i = 0; i < ds\_cn.Tables\[0\].Rows.Count; i++)  
                    \{  
                        if (ds\_cn.Tables\[0\].Rows\[i\]\["CLassName"\].ToString() == rptClassName)  
                            ss++;  
                    \}  
                    //如果前一页的最后一个列名的列的显示数>=每月显示数,且当前页>2,那么继续判断

//这里只判断了翻2页的情况,如果类别大于3页那么要写个循环判断  
                    if (ss >= this.Pager1.PageSize && this.Pager1.PageIndex > 2)  
                    \{  
                        tblName\_P = "(" + getPageList(tblName, fldName, this.Pager1.PageSize, pageIndex - 2, "DictID,StartDate,endDate", true, strCondition, "F\_ID") + ") as a";  
                        ds\_cn = dbAccess.GetDataSet(tblName\_P, "", "", "DictID");  
                        for (int i = 0; i < ds\_cn.Tables\[0\].Rows.Count; i++)  
                        \{  
                            if (ds\_cn.Tables\[0\].Rows\[i\]\["CLassName"\].ToString() == rptClassName)  
                                ss++;  
                        \}  
                    \}  
                    rptClassNameCount = ss;  
                \}  
                else  
                \{  
                    rptClassName = "";  
                    rptClassNameCount = 0;  
                \}  
            \}  
            \#endregion

Pager1.UrlPar = "\{0\}," + this.txtFallNum.Text.Trim() + "," + this.ddlStartDate.SelectedValue + "," + this.ddlEndDate.SelectedValue + "," + this.txtMeeting.Text.Trim();//跳转页面 查询条件的值  
             
            this.rptCategories.DataSource = ds;  
            this.rptCategories.DataBind();  
            \#endregion  
        \}  
        \#endregion

protected void btnFind\_Click(object sender, EventArgs e)  
        \{  
            string strWhere = getWhere();  
            ViewState\["strWhere"\] = strWhere;  
            this.Pager1.SetPageIndex = 1;//每次查询初始化当前页为第一页  
            DataBind(strWhere);  
        \}

private string getWhere()  
        \{  
            string strStartDate = ddlStartDate.SelectedItem.Value;  
            string strEndDate = ddlEndDate.SelectedItem.Value;  
            string strMeeting = txtMeeting.Text.Trim();  
            string strFallnum = txtFallNum.Text.Trim();  
            string strWhere = "";  
            if (strStartDate != "")  
            \{  
                strWhere += " and CONVERT(DATETIME,CONVERT(VARCHAR,YEAR(GETDATE()))+'-'+STARTDATE) >= CONVERT(VARCHAR,YEAR(GETDATE()))+'-'+'" + strStartDate + "'";  
            \}  
            if (strEndDate != "")  
            \{  
                strWhere += " and CONVERT(DATETIME,CONVERT(VARCHAR,YEAR(GETDATE()))+'-'+STARTDATE) <= CONVERT(VARCHAR,YEAR(GETDATE()))+'-'+'" + strEndDate + "'";  
            \}

if (strFallnum != string.Empty)  
            \{  
                strWhere += " and fallnum =" + strFallnum;  
            \}  
            if (strMeeting != string.Empty)  
            \{  
                strWhere += " and meeting like '%" + strMeeting + "%'";  
            \}  
            return strWhere;  
        \}

protected void rptCategories\_ItemDataBound(object sender, RepeaterItemEventArgs e)  
        \{  
            if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)  
            \{  
                //初始化嵌套Repeater的当前已显示行的行数小于每页显示数的情况下  
                int flag = 0;  
                if (this.Pager1.PageIndex == this.Pager1.PageCount)  
                \{  
                    //当前页=最后一页的情况,计算最后一页的记录数//否则默认  
                    flag = Pager1.RecordCount - (this.Pager1.PageIndex - 1) \* this.Pager1.PageSize;  
                \}  
                else  
                \{                     
                    flag = this.Pager1.PageSize;  
                \}  
                if (rptRowsCount < flag)  
                \{  
                    Repeater rptProduct = (Repeater)e.Item.FindControl("rptProduct");//查找嵌套的Repeater  
                    DataRowView rowv = (DataRowView)e.Item.DataItem; //找到分类Repeater关联的数据项  
                    string className = rowv\["ClassName"\].ToString();//提取分类名称  
                    DataBindRpt(rptProduct, className);//根据分类名称查询该分类对应的数据，并绑定到Repeater  
                \}  
            \}  
        \}

\#region 绑定嵌套的Repeater  
        private void DataBindRpt(Repeater rptProduct, string className)  
        \{  
            \#region 条件  
            string fldName = "DictID,F\_id,ClassName,Meeting,Sponsor,UnderTaker,Coopertion,Subject,"  
                + " endDate,Adress,(SubString(StartDate,1,2)+'月'+SubString(StartDate,4,5)+'日') as StartDate,Scale,Speaker,Content,SysDate,ContactWay,OrderBy,"  
                + "issign ,newOrderBy=(case when OrderBy is null then 1000 else OrderBy end)";  
            string tblName = "T\_Forum\_Info t left join t\_sysdictdetail s on t.ClassName=s.DictName\_C";  
            string strCondition = getWhere();  
            strCondition += " and beforecheck=1 and lang=0 and tablename='t\_forum\_info' and fieldname='classname'";// Order by newOrderBy";  
            strCondition += " and ClassName='" + className + "'";  
            string strOrder = "OrderBy";  
            \#endregion

\#region 绑定数据  
            if (rptRowsCount < this.Pager1.PageSize)//当Repeater的记录数小于当前页的记录数的时  
            \{  
                int size = 0;//初始化 剩余的查询记录数为0  
                if (this.Pager1.PageIndex == this.Pager1.PageCount)//当前页＝最后一页的情况  
                \{  
                    size = Pager1.RecordCount - (this.Pager1.PageIndex - 1) \* this.Pager1.PageSize - rptRowsCount;//剩余的查询记录数 ＝ 最后一页显示记录数 － 已查询记录数  
                \}  
                else  
                \{  
                    size = this.Pager1.PageSize - rptRowsCount;//剩余的查询记录数 ＝ 当前页总记录数 － 已查询记录数  
                \}  
                DataSet ds;  
                int pageIndex = 1;  
                int StartNum;//起始记录数  
                int EndNum;//结尾记录数  
                if (className == rptClassName)//类别相同，过滤已经查询的记录  
                \{  
                    //假设50条/页--已经查询2条，那么从第3条开始查询  
                    StartNum = rptClassNameCount + 1;  
                    EndNum = StartNum + size;  
                    string tblName\_P = "(" + getPageList(tblName, fldName, StartNum, EndNum, strOrder, true, strCondition, "F\_ID") + ") as a";  
                    ds = dbAccess.GetDataSet(tblName\_P, "", "", strOrder);  
                    rptRowsCount = rptRowsCount + ds.Tables\[0\].Rows.Count;  
                \}  
                else//列别不一样  
                \{  
                    StartNum = 1;  
                    EndNum =  size;  
                    string tblName\_P = "(" + getPageList(tblName, fldName, StartNum, EndNum, strOrder, true, strCondition, "F\_ID") + ") as a";  
                    ds = dbAccess.GetDataSet(tblName\_P, "", "", strOrder);  
                    rptRowsCount = rptRowsCount + ds.Tables\[0\].Rows.Count;  
                \}  
                rptProduct.DataSource = ds;  
                rptProduct.DataBind();  
            \}  
            \#endregion  
        \}  
        \#endregion

\#region 改写dbAccess.getPageList的分页SQL,具体使用详见dbAccess.getPageList  
        public string getPageList(string tblName, string fldName, int StartNum, int EndNum,  
string fldSort, bool Sort, string strCondition, string ID)  
        \{  
            if (string.IsNullOrEmpty(fldName))  
                fldName = "\*";  
            if (string.IsNullOrEmpty(fldSort))  
                fldSort = ID;  
            if (Sort)  
                fldSort = fldSort + " desc ";  
            StringBuilder strSql = new StringBuilder("select \* from (select ROW\_NUMBER() OVER(ORDER BY " + fldSort + ")  as rowNum," + fldName + " from " + tblName + " where 1=1 " + strCondition + ") as a where rowNum between " + StartNum + " and " + EndNum);  
            return strSql.ToString();  
        \}  
        \#endregion  
    \}

//---------------------通用分页方法出自于廖永军的代码生成器---------------------------------------------

/// <summary>  
        /// 通用分页方法  
        /// </summary>  
        /// <param name="tblName">要显示的表或多个表的连接</param>  
        /// <param name="fldName">要显示的字段列表,可为Null,表示\*</param>  
        /// <param name="pageSize">每页显示的记录个数</param>  
        /// <param name="pageIndex">要显示那一页的记录</param>  
        /// <param name="fldSort">排序字段列表或条件</param>  
        /// <param name="Sort">排序方法，False为升序，True为降序(如果是多字段排列Sort指代最后一个排序字段的排列顺序(最后一个排序字段不加排序标记)--程序传参如：' SortA Asc,SortB Desc,SortC ')</param>  
        /// <param name="strCondition">查询条件,不需where,以And开始,可为Null,表示""</param>  
        /// <param name="ID">主表的主键</param>  
        /// <returns>查询当前页的数据集</returns>  
        public static DataSet PageList(string tblName, string fldName, int pageSize, int pageIndex,  
            string fldSort, bool Sort, string strCondition, string ID)  
        \{  
            if (string.IsNullOrEmpty(fldName))  
                fldName = "\*";  
            if (pageSize == 0)  
                pageSize = int.Parse(ConfigurationSettings.AppSettings\["PageSize"\]);  
            if (string.IsNullOrEmpty(fldSort))  
                fldSort = ID;  
            if (Sort)  
                fldSort = fldSort + " desc ";  
            StringBuilder strSql = new StringBuilder("select \* from (select ROW\_NUMBER() OVER(ORDER BY " + fldSort + ")  as rowNum," + fldName + " from " + tblName + " where 1=1 " + strCondition + ") as a where rowNum between " + (pageSize \* (pageIndex - 1) + 1) + " and " + pageSize \* pageIndex);  
            return ExecuteQuery(strSql.ToString());  
        \}

/// <summary>  
        /// 得到数据总条数,在单表统计时使用  
        /// </summary>  
        /// <param name="strCondition">条件</param>  
        public static int GetCount(string tblName, string strCondition)  
        \{  
            DataSet ds = GetDataSet(tblName, "count(\*)", strCondition, null);  
            return Convert.ToInt32(ds.Tables\[0\].Rows\[0\]\[0\]);  
        \}

/// <summary>  
        /// 得到数据总条数，在多表统计时使用  
        /// </summary>  
        /// <param name="strCondition">条件</param>  
        public static int GetCount(string tblName, string strCondition, string fldName)  
        \{  
            if (string.IsNullOrEmpty(fldName))  
                fldName = "\*";  
            DataSet ds = GetDataSet(tblName, fldName, strCondition, null);  
            return Convert.ToInt32(ds.Tables\[0\].Rows.Count);  
        \}

转载于:https://www.cnblogs.com/yongheng178/archive/2008/08/22/1274299.html