抒情散文
当前位置:首页 > 抒情散文 > 列表页

aspnet验证控件【asp.net中Repeater控件用法笔记】

泥巴往事网  发布于:2018-08-15  分类: 抒情散文 手机版

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

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

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

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

HeaderTemplate: 建立如何显示标题。

FooterTemplate: 建立如何显示页脚。

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

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

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

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

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

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

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" />
<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 (mandName == "add")
{
bel lblGuid = (bel)e.Item.FindControl("lblGuid");

//首先,恢复数据源
DataTable dt = DefineDataTableSchema(hfRptColumns.Value);
foreach (RepeaterItem item in rptRequest.Items)
{
DataRow newRow = dt.NewRow();
newRow["Guid"] = ((bel)item.FindControl("lblGuid")).Text;
newRow["EquRequestItemId"] = ((bel)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 == ((bel)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 (mandName == "delete")
{
bel lblGuid = (bel)e.Item.FindControl("lblGuid");

//首先,恢复数据源
DataTable dt = DefineDataTableSchema(hfRptColumns.Value);
foreach (RepeaterItem item in rptRequest.Items)
{
if (lblGuid.Text != ((bel)item.FindControl("lblGuid")).Text)
{
DataRow newRow = dt.NewRow();
newRow["Guid"] = ((bel)item.FindControl("lblGuid")).Text;
newRow["EquRequestItemId"] = ((bel)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 bel).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 bel).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 + "")");
}
}
}

}

}
}

本文已影响

aspnet验证控件【asp.net中Repeater控件用法笔记】