GridView 实现自定义分页、排序、查询、添加、编辑、多选删除、导出、突出显示等常见应用实现

最新推荐文章于 2022-10-14 10:16:30 发布

转载最新推荐文章于 2022-10-14 10:16:30 发布 · 695 阅读

文章标签：

#asp #textbox #server #class #button #input

asp.net(资料）专栏收录该内容

98 篇文章

订阅专栏

本文介绍了一个图书管理系统的前端页面设计，包括图书信息的增加、查询及管理功能。页面使用ASP.NET技术实现，并通过JavaScript进行辅助交互。

前台代码

BookInfo.aspx

<%...@ Page Language="C#" EnableEventValidation="false" AutoEventWireup="true" CodeFile="BookInfo.aspx.cs" Inherits="ZDWH_BookInfo" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

function $(s)...{return document.getElementById(s);}

function isNull(_sVal)...{return (_sVal == "" || _sVal == null || _sVal == "undefined");}

//获取地址栏参数

function GetURL(name)

...{

var URLParams = new Array();

var aParams = document.location.search.substr(1).split('&');

for (i=0; i < aParams.length; i++)

...{

var aParam = aParams[i].split('=');

URLParams[aParam[0]] = aParam[1];

}

//取得传过来的name参数

return URLParams[name];

}

var tgs;

var tmp_background_val;

function tog(n,flags)

...{

if (tgs)

...{tgs.style.background= tmp_background_val ;}

n.style.background= '#99ccff' ;

tmp_background_val=flags;

tgs=n;

}

function CheckAll(spanChk)//全选

...{

var oItem = spanChk.children;

var theBox=(spanChk.type=="checkbox")?spanChk:spanChk.children.item[0];

xState=theBox.checked;

elm=theBox.form.elements;

for(i=0;i<elm.length;i++)

if(elm[i].type=="checkbox" && elm[i].id!=theBox.id)

...{

if(elm[i].checked!=xState)

elm[i].click();

}

function GetRowIndex(obj)

...{

$('<%=HiddenID.ClientID %>').value = obj;

}

var HiddenID;

function checkSelect()

...{

HiddenID=$('<%=HiddenID.ClientID %>').value;

if(isNull(HiddenID))

...{

alert("请选择一条记录!");

}

return !isNull(HiddenID);

}

</script>

</head>

<body>

<b>图书信息增加</b>    

<asp:Button class="input_button" id="BtnClear" Text="清空" runat="server" CausesValidation="False" OnClick="BtnClear_Click"></asp:Button>

<asp:button class="input_button" id="BtnSave" runat="server" text="保存" OnClick="BtnSave_Click"></asp:button>

<asp:Label ID="LblCode1" Text="图书编号" ForeColor="Red" runat="server" Visible="false"></asp:Label>

<asp:Label ID="LblCode" Text="" ForeColor="Red" runat="server" Visible="false"></asp:Label>

<tbody>

图书ISBN：

<asp:TextBox class="input_text" id="TxtISBN" runat="server" width="200"></asp:TextBox>

</td>

出版社：

<asp:DropDownList class="input_text" id="DdlSelPress" runat="server" width="200"></asp:DropDownList>

</td>

</tr>

图书名称：

<asp:TextBox class="input_text" id="TxtName" runat="server" width="600"></asp:TextBox>

<asp:RequiredFieldValidator id="Requiredfieldvalidator1" runat="server" ErrorMessage="*" ControlToValidate="TxtName">此项必填</asp:RequiredFieldValidator>

</td>

</tr>

定    价：

<asp:TextBox class="input_text" id="TxtBookPrice" runat="server" width="200"></asp:TextBox>

<asp:RequiredFieldValidator id="Requiredfieldvalidator2" runat="server" ErrorMessage="*" ControlToValidate="TxtBookPrice">此项必填</asp:RequiredFieldValidator>

</td>

图书源码：

<asp:TextBox class="input_text" id="TxtSourceCode" runat="server" width="200"></asp:TextBox>

</td>

</tr>

自编代码：

<asp:TextBox class="input_text" id="TxtBookSelfCode" runat="server" width="200"></asp:TextBox>

</td>

出版年度：

<asp:TextBox class="input_text" id="TxtCbyYear" runat="server" width="200"></asp:TextBox>

</td>

</tr>

版    次：

<asp:TextBox class="input_text" id="TxtBc" runat="server" width="200"></asp:TextBox>

</td>

作    者：

<asp:TextBox class="input_text" id="TxtBookAuthor" runat="server" width="200"></asp:TextBox>

</td>

</tr>

架位号：

<asp:TextBox class="input_text" id="TxtLocateCode" runat="server" width="200"></asp:TextBox>

</td>

备    注：

<asp:TextBox class="input_text" id="TxtMemo" runat="server" width="200"></asp:TextBox>

</td>

</tr>

</tbody>

</table>

<br />

<b>图书信息查询</b>

<tbody>

检索条件：

<asp:DropDownList class="input_text" id="DdlQuery_tj" runat="server" width="97">

<asp:ListItem Value="name" Selected="True">图书名称</asp:ListItem>

<asp:ListItem Value="ISBN">图书ISBN</asp:ListItem>

<asp:ListItem Value="author">作者</asp:ListItem>

<asp:ListItem Value="abbrname">出版社名称</asp:ListItem>

<asp:ListItem Value="memo">备注</asp:ListItem>

</asp:DropDownList>

  检索内容：

<asp:TextBox class="input_text" id="TxtQuery_content" runat="server" width="120"></asp:TextBox>

<asp:button class="input_button" id="BtnQuery" runat="server" text="查询" CausesValidation="False" OnClick="BtnQuery_Click"></asp:button>

<br />

<asp:Button ID="BtnDelChecked" runat="server" Height="25px" OnClick="BtnDelChecked_Click"

Text="删除选中" Width="100px" CausesValidation="false" Visible="false" OnClientClick="javascript:return ( checkSelect() && confirm('警告：删除将无法恢复！确认删除吗？') );" />

<asp:Button ID="BtnToExcel" runat="server" CausesValidation="False" Height="25px"

OnClick="BtnToExcel_Click" Text="导出到Excel" Width="100px" />

<asp:Button ID="BtnToWord" runat="server" CausesValidation="False" Height="25px"

OnClick="BtnToWord_Click" Text="导出到Word" Width="100px" /></b>

</td>

</tr>

<tr>

<asp:GridView ID="gridViewPublishers" runat="server" CellPadding="4"

ForeColor="#333333" GridLines="None" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" OnPageIndexChanging="GridViewPublishersPageChanged" OnSorting="GridViewPublishersSorting" OnRowDeleting="GridViewRowDelete" DataKeyNames="code" OnRowEditing="GridViewRowEdit" OnRowDataBound="gridViewPublishers_RowDataBound">

<asp:TemplateField>

</ItemTemplate>

</HeaderTemplate>

</asp:TemplateField>

<asp:BoundField DataField="ID" DataFormatString="{0:d}" HeaderText="序號" />

<asp:BoundField DataField="code" HeaderText="圖書編號" SortExpression="code" />

<asp:BoundField DataField="name" HeaderText="圖書名稱 " SortExpression="name" />

<asp:BoundField DataField="abbrname" HeaderText="版別" SortExpression="abbrname" />

<asp:BoundField DataField="price" DataFormatString="{0:C}" HtmlEncode="false" HeaderText="定價" SortExpression="price" />

<asp:BoundField DataField="Author" HeaderText="作者" SortExpression="author" />

<asp:BoundField DataField="version" HeaderText="版次" SortExpression="version" />

<asp:BoundField DataField="storeamountz" HeaderText="總店庫存" SortExpression="storeamountz" />

<asp:BoundField DataField="storeamounta" HeaderText="門市庫存" SortExpression="storeamounta" />

<asp:TemplateField>

<asp:Button ID="del" runat="server" CausesValidation="false" Text="删除" CommandName="Delete" OnClientClick="return confirm('您确认删除该记录吗?');" CommandArgument='<%# Eval("Code") %>'></asp:Button>

</ItemTemplate>

删除

</HeaderTemplate>

</asp:TemplateField>