足球游戏_中国足彩网￥体育资讯$

大家可能都对datagrid比较熟悉，但是如果在数据量大的时候，我们就得考虑使用repeater作为我们的数据绑定控件了。Repeater控件与DataGrid (以及DataList)控件的主要区别是在于如何处理HTML。ASP.NET建立HTML代码以显示DataGrid控件，但Repeater允许开发人员决定如何显示数据。所以，你可以选择将数据显示在一个HTML表格中或者一个顺序列表中。这主要取决于你的选择，但你必须将正确的HTML插入到 ASP.NET页面中。

模板与DataList一样，Repeater控件只支持模板。以下的模板可供选择：

AlternatingItemTemplate: 指定如何显示每一其它选项。

ItemTemplate: 指定如何显示选项。(AlternatingItemTemplate可以覆盖这一模板。)

HeaderTemplate: 建立如何显示标题。

FooterTemplate: 建立如何显示页脚。

SeparatorTemplate: 指定如何显示不同选项之间的分隔符。

你可以使用这些模板来显示你希望的数据。唯一具有强制性的模板是ItemTemplate，所有其它的模板都是具有选择性的。

对于处理一个数据源，Repeater控件具有与DataGrid与DataList相同的属性：

DataMember：获得或者设置与 Repeater 控件绑定的相应DataSource属性的表格。

DataSource：获得或者设置为 Repeater 显示提供数据的数据源。

除此之外，还有一个Items属性，你可以通过这一属性编程访问Repeater数据中单一选项。它返回一个RepeaterItemCollection对象，为一组RepeaterItem对象的集合，代表 Repeater 数据的每一行。

ASP.NET Web数据控件还有其它一个共性：它们都使用DataBind方法来生成用户界面。调用这一方法可以返回并显示数据(假设DataSource和 DataMember属性设置正确)。在查看DataBind方法之前，我们先看看如何在一个Web页面中使用一个Repeater控件。

使用Repeater控件

使用Repeater控件的第一步骤是决定我们将要使用的数据源和字段。例如，我们将要使用SQL Server Northwind数据库中的Employees列表。Web页面将显示职工的完整名字，地址，以及电话号码。HTML将使用DIV标记，用 Repeater 模板来分隔内容。下面是 Web 页面的 HTML 内容：

前台代码

代码如下:

<asp:Repeater ID="Repeater1" runat="server">

<HeaderTemplate><table cellpadding="0" cellspacing="0" border="1" align="center" class="auto-style1">

<tr align="left">

<th>编号</th>

<th>姓名</th>

<th>年龄</th>

<th>班级</th>

<th>零花</th>

</tr>

</HeaderTemplate>

<ItemTemplate>

<tr >

<td><%#Eval("id")%></td>

<td><%#Eval("name")%></td>

<td><%#Eval("age")%></td>

<td><%#Eval("classid")%></td>

<td><%#Eval("salary")%></td>

</tr>

</ItemTemplate>

<FooterTemplate></table></FooterTemplate>

</asp:Repeater>

后台代码

代码如下:

string sql = string.Format("select * from person");

DataTable dt = sqlhelper.helper.ExecuteQuery(sql);

Repeater1.DataSource = dt;

Repeater1.DataBind();

AspNetpager的使用方法：

首先注册<%@ Register Assembly="AspNetPager" Namespace="Wuqi.Webdiyer" TagPrefix="webdiyer" %>

前台：

代码如下:

<webdiyer:AspNetPager ID="AspNetPager1" runat="server" CustomInfoHTML="第%CurrentPageIndex%页，共%PageCount%页，每页%PageSize%条"

FirstPageText="首页" LastPageText="尾页" LayoutType="Table" NextPageText="下一页"

onpagechanging="AspNetPager1_PageChanging" PageIndexBoxType="DropDownList"

PagingButtonLayoutType="Span" PrevPageText="上一页" ShowCustomInfoSection="Left"

ShowPageIndexBox="Always" SubmitButtonText="Go" TextAfterPageIndexBox="页"

TextBeforePageIndexBox="转到" Width="450px" PageSize="3">

</webdiyer:AspNetPager>

后台：

代码如下:

private void AddPages(Repeater rpt,Wuqi.Webdiyer.AspNetPager anp,DataTable dt)

{

PagedDataSource pds = new PagedDataSource();

pds.AllowPaging = true;

pds.DataSource = dt.DefaultView;

anp.RecordCount = dt.Rows.Count;//给分页控件指定当前总数

pds.PageSize = anp.PageSize;//确定分页，每页有n项

pds.CurrentPageIndex = anp.CurrentPageIndex - 1;//确定当前页数

rpt.DataSource = pds;//绑定数据源

rpt.DataBind();

}

protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)

{

AspNetPager1.CurrentPageIndex = e.NewPageIndex;

BindPersonData();

}

例子

repeater控件动态添加、删除一行

代码如下:

<script type="text/javascript">

var txtEquipmentIdsIDArray = new Array();

function OpenWindow(clientId, TypeId, ReqNum) {

var url = "../EquipmentIssue/EquipmentRequestIssue.aspx?TypeId=" + TypeId + "&ReqNum=" + ReqNum;

var widths = 600;

var heigths = 450;

var winPar = window.showModalDialog(url, window, 'dialogWidth=' + widths + 'px;dialogHeight=' + heigths + 'px;status=no;center=yes;scroll=no;help:No;');

if (winPar != undefined) {

var txtEquipmentIds = document.getElementById(clientId);

txtEquipmentIds.value = winPar;

// //审批用户控件中保存发放的EquipmentId

// var IsExistEquipmentIdsID = false;

// for (var i = 0; i < txtEquipmentIdsIDArray.length; i++) {

// if (txtEquipmentIdsIDArray[i] == clientId) {

// IsExistEquipmentIdsID = true;

// }

// }

// if (IsExistEquipmentIdsID == false) {

// txtEquipmentIdsIDArray.push(clientId);

// }

// var tempEquipmentId = "";

// for (var i = 0; i < txtEquipmentIdsIDArray.length; i++) {

// tempEquipmentId = tempEquipmentId + document.getElementById(txtEquipmentIdsIDArray[i]).value;

// var hiddenEquipmentIds = document.getElementById("UC_ApprovalAction1_hfEquipmentIds");

// hiddenEquipmentIds.value = tempEquipmentId;

// }

// //alert(hiddenEquipmentIds.value);

}

var tempReturnValue = "";

var tb_Request = document.getElementById("tb_Request");

var tr = tb_Request.getElementsByTagName("tr");

for (var i = 0; i < tr.length; i++) {

if (tr[i].id != "") {

var span_EquRequestItemId = tr[i].getElementsByTagName("span"); //获取申请明细的IDEquRequestItemId

var select_ddlStation; //获取使用工位StationId

var option = tr[i].getElementsByTagName("select")[1].getElementsByTagName("option");

for (var j = 0; j < option.length; j++) {

if (option[j].selected)

{

select_ddlStation = option[j]

}

}

var textarea_EquipmentIds = tr[i].getElementsByTagName("textarea"); //获取发放的资产号EquipmentNo

tempReturnValue = tempReturnValue + span_EquRequestItemId[0].innerText + ":" + select_ddlStation.value + ":" + textarea_EquipmentIds[0].innerText + "|";

}

}

var hiddenEquipmentIds = document.getElementById("UC_ApprovalAction1_hfEquipmentIds");

hiddenEquipmentIds.value = tempReturnValue;

//alert(hiddenEquipmentIds.value);

}

</script>

Repeater:

代码如下:

<div id="div_Repeater">

<asp:HiddenField ID="hfRptColumns" runat="server" Value="Guid,EquRequestItemId,EquipmentType,Station,EquipmentNum,EquipmentIds" />

<table id="tb_Request" cellpadding="1" cellspacing="0" width="100%" style="background-color: #DFE8F6; font-size:12px; padding:10px;">

<thead>

<tr>

<th>序号</th>

<th>明细编号</th>

<th>

资产类型

</th>

<th>

使用工位

</th>

<th>

申请数量

</th>

<th>

发放的资产号<font color="red">(资产管理员填写)</font>

</th>

</tr>

</thead>

<tbody>

<asp:Repeater ID="rptRequest" runat="server" onitemcommand="rptRequest_ItemCommand"

onitemdatabound="rptRequest_ItemDataBound">

<ItemTemplate>

<tr id="tr_Request">

<td>

<%# Container.ItemIndex+1 %>

<asp:Label ID="lblGuid" runat="server" Text='<%#Eval("Guid") %>' Visible="false"></asp:Label>

</td>

<td><asp:Label ID="lblEquRequestItemId" runat="server" Text='<%#Eval("EquRequestItemId") %>'></asp:Label></td>

<td>

<asp:DropDownList ID="ddlEquipmentType" runat="server"></asp:DropDownList>

<asp:Label ID="lblEquipmentType" runat="server" Text='<%#Eval("EquipmentType") %>' Visible="false"></asp:Label>

</td>

<td>

<asp:DropDownList ID="ddlStation" runat="server"></asp:DropDownList>

<asp:Label ID="lblStation" runat="server" Text='<%#Eval("Station") %>' Visible="false"></asp:Label>

</td>

<td><asp:TextBox ID="txtReqEquipmentNum" runat="server" Text='<%#Eval("EquipmentNum") %>'></asp:TextBox></td>

<td><asp:TextBox ID="txtEquipmentIds" runat="server" Text='<%#Eval("EquipmentIds") %>' TextMode="MultiLine"></asp:TextBox></td>

<td><asp:Button ID="btnAddRow" runat="server" Text="新增一行" CommandName="add" />

&nbsp;&nbsp;&nbsp;&nbsp;<asp:Button ID="btnDeleteRow" runat="server" Text="删除本行" CommandName="delete" /></td>

</tr>

</ItemTemplate>

</asp:Repeater>

</tbody>

</table>

</div>

后台：

代码如下:

/// <summary>

/// 绑定repeater的数据源

/// </summary>

private void RepeaterBindData()

{

DataTable dt = DefineDataTableSchema(hfRptColumns.Value);

if (Request["BusinessNo"] == null)

{

LoadData(dt);

}

else

{

LoadData(Request["BusinessNo"].ToString(), dt);

}

rptRequest.DataSource = dt;

rptRequest.DataBind();

}

private void LoadData(string businessNo, DataTable dt)

{

string strSql = "select * from EMS_EquipmentRequestItem where BussinessNo = '"+ businessNo +"'";

DataTable dt_EquipmentRequestItem = DBUtility.DbHelperSQL.Query(strSql).Tables[0];

//for (int i = 0; i < dt_EquipmentRequestItem.Rows.Count; i++)

foreach (DataRow dr in dt_EquipmentRequestItem.Rows)

{

DataRow row = dt.NewRow();

row["Guid"] = Guid.NewGuid();

row["EquRequestItemId"] = dr["EquRequestItemId"].ToString();

row["EquipmentType"] = dr["TypeId"].ToString();

row["Station"] = dr["StationId"].ToString();

row["EquipmentNum"] = dr["EquipmentNum"].ToString();

row["EquipmentIds"] = dr["EquipmentIds"].ToString();

dt.Rows.Add(row);

}

}

/// <summary>

/// repeater数据默认加载

/// </summary>

/// <param name="dt"></param>

private void LoadData(DataTable dt)

{

//默认显示1行

for (int i = 0; i < 1; i++)

{

DataRow row = dt.NewRow();

dt.Rows.Add(row);

}

//为第一行加载一些数据

DataRow row0 = dt.Rows[0];

row0["Guid"] = Guid.NewGuid();

row0["EquRequestItemId"] = "";

row0["EquipmentType"] = "";

row0["Station"] = "";

row0["EquipmentNum"] = "1";//默认初始为1

row0["EquipmentIds"] = "";

}

/// <summary>

/// 根据repeater相对应的列名，定义数据源datatable的schema

/// </summary>

/// <param name="columns">列名</param>

/// <returns></returns>

public DataTable DefineDataTableSchema(string columns)

{

DataTable dt = new DataTable();

string[] columnsAry = columns.Split(',');

foreach (string str in columnsAry)

{

dt.Columns.Add(str);

}

return dt;

}

protected void rptRequest_ItemCommand(object source, RepeaterCommandEventArgs e)

{

if (e.CommandName == "add")

{

System.Web.UI.WebControls.Label lblGuid = (System.Web.UI.WebControls.Label)e.Item.FindControl("lblGuid");

//首先，恢复数据源

DataTable dt = DefineDataTableSchema(hfRptColumns.Value);

foreach (RepeaterItem item in rptRequest.Items)

{

DataRow newRow = dt.NewRow();

newRow["Guid"] = ((System.Web.UI.WebControls.Label)item.FindControl("lblGuid")).Text;

newRow["EquRequestItemId"] = ((System.Web.UI.WebControls.Label)item.FindControl("lblEquRequestItemId")).Text;

newRow["EquipmentType"] = ((DropDownList)item.FindControl("ddlEquipmentType")).SelectedValue;

newRow["Station"] = ((DropDownList)item.FindControl("ddlStation")).SelectedValue;

newRow["EquipmentNum"] = ((TextBox)item.FindControl("txtReqEquipmentNum")).Text;

newRow["EquipmentIds"] = ((TextBox)item.FindControl("txtEquipmentIds")).Text;

dt.Rows.Add(newRow);

if (lblGuid.Text == ((System.Web.UI.WebControls.Label)item.FindControl("lblGuid")).Text)

{

//添加一行

DataRow row = dt.NewRow();

row["Guid"] = Guid.NewGuid();

row["EquipmentType"] = "";

row["Station"] = "";

row["EquipmentNum"] = "1";//默认初始为1

row["EquipmentIds"] = "";

dt.Rows.Add(row);

}

}

rptRequest.DataSource = dt;

rptRequest.DataBind();

}

else if (e.CommandName == "delete")

{

System.Web.UI.WebControls.Label lblGuid = (System.Web.UI.WebControls.Label)e.Item.FindControl("lblGuid");

//首先，恢复数据源

DataTable dt = DefineDataTableSchema(hfRptColumns.Value);

foreach (RepeaterItem item in rptRequest.Items)

{

if (lblGuid.Text != ((System.Web.UI.WebControls.Label)item.FindControl("lblGuid")).Text)

{

DataRow newRow = dt.NewRow();

newRow["Guid"] = ((System.Web.UI.WebControls.Label)item.FindControl("lblGuid")).Text;

newRow["EquRequestItemId"] = ((System.Web.UI.WebControls.Label)item.FindControl("lblEquRequestItemId")).Text;

newRow["EquipmentType"] = ((DropDownList)item.FindControl("ddlEquipmentType")).SelectedValue;

newRow["Station"] = ((DropDownList)item.FindControl("ddlStation")).SelectedValue;

newRow["EquipmentNum"] = ((TextBox)item.FindControl("txtReqEquipmentNum")).Text;

newRow["EquipmentIds"] = ((TextBox)item.FindControl("txtEquipmentIds")).Text;

dt.Rows.Add(newRow);

}

}

rptRequest.DataSource = dt;

rptRequest.DataBind();

}

}

protected void rptRequest_ItemDataBound(object sender, RepeaterItemEventArgs e)

{

if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)

{

DropDownList ddlEquipmentType_temp = e.Item.FindControl("ddlEquipmentType") as DropDownList;

string sqlstr = @"select distinct b.TypeId,b.EquipmentName + '_' + b.EquipmentType as 'EquipmentName_EquipmentType'

from EMS_EquipmentInfo a

join EMS_EquipmentType b on a.TypeId = b.TypeId and b.Status = '1'

order by EquipmentName_EquipmentType";

DataSet ds = DBUtility.DbHelperSQL.Query(sqlstr);

ddlEquipmentType_temp.DataTextField = "EquipmentName_EquipmentType";

ddlEquipmentType_temp.DataValueField = "TypeId";

ddlEquipmentType_temp.DataSource = ds;

ddlEquipmentType_temp.DataBind();

ddlEquipmentType_temp.SelectedValue = (e.Item.FindControl("lblEquipmentType") as System.Web.UI.WebControls.Label).Text;

DropDownList ddlStation_temp = e.Item.FindControl("ddlStation") as DropDownList;

string sqlstr2 = @"select NodeId,Line + '_' + StationName as 'Line_StationName' from V_Stations where status='1' order by Line_StationName";

DataSet ds2 = DBUtility.DbHelperSQL.Query(sqlstr2);

ddlStation_temp.DataTextField = "Line_StationName";

ddlStation_temp.DataValueField = "NodeId";

ddlStation_temp.DataSource = ds2;

ddlStation_temp.DataBind();

ddlStation_temp.SelectedValue = (e.Item.FindControl("lblStation") as System.Web.UI.WebControls.Label).Text;

TextBox txtEquIds = e.Item.FindControl("txtEquipmentIds") as TextBox;

txtEquIds.Attributes.Add("readonly", "true");

if (Request["BusinessNo"] != null)

{

(e.Item.FindControl("btnAddRow") as System.Web.UI.WebControls.Button).Visible = false;

(e.Item.FindControl("btnDeleteRow") as System.Web.UI.WebControls.Button).Visible = false;

string businessNo = Request["BusinessNo"].ToString();

bool IsApplyUser = Is_ApplyUser(Session["currentUserID"].ToString(), businessNo, "EMS_EquipmentRequest", "Requester");//是否为申请人本人

if (IsApplyUser == true)

{

string requestStatus = HttpUtility.UrlDecode(Request["RequestStatus"].ToString(), System.Text.Encoding.UTF8);//申请单的当前状态

if (requestStatus == "草稿" || requestStatus == "退回")

{

(e.Item.FindControl("btnAddRow") as System.Web.UI.WebControls.Button).Visible = true;

(e.Item.FindControl("btnDeleteRow") as System.Web.UI.WebControls.Button).Visible = true;

}

}

else

{

bool IsCurrentAppprovaler = Is_CurrentAppprovaler(Session["currentUserID"].ToString(), businessNo);//是否为当前能做审批的人

if (IsCurrentAppprovaler == true)

{

string sql = " SELECT TOP 1 LayerName from EMS_Approvaler where BussinessNo='" + businessNo + "' "

+ " AND ApprovalStatus='N' ORDER BY AppSequence ";

DataTable dt = DBUtility.DbHelperSQL.Query(sql).Tables[0];

if (dt.Rows.Count != 0 && dt.Rows[0]["LayerName"].ToString() == "资产管理员")

{

string ReqNum = (e.Item.FindControl("txtReqEquipmentNum") as TextBox).Text.Trim();

txtEquIds.Attributes.Add("onclick", "OpenWindow('" + txtEquIds.ClientID + "','" + ddlEquipmentType_temp.SelectedValue + "','" + ReqNum + "')");

}

}

}

}

}

}

中国足彩网信息请查看IT技术专栏