当前位置：首页 > 编程日记 > 正文

GridView自定义分页导航

编程日记 2024-11-17 04:20:00

自己做的一个项目中所运用到的技术：|

1. 日历控件（带时分秒）

2. GridView 批量删除,自定义分页,定位页码

3. GridView 修改

4. GridView 鼠标经过改变行的颜色

效果如下：

HTML：

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="StfCmpManager.aspx.cs" Inherits="StfCmpManager" %>

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

<title>合作商信息维护</title>

// 判断多选是否与选中项（没有选中的返回false）

function slcNo_click()

{

if (document.form1.checkboxname.length)

{

for (var i=0;i<document.form1.checkboxname.length;i++)

{

if(document.form1.checkboxname[i].checked)

{

return true;

}

else

{

if(document.form1.checkboxname.checked)

{

return true;

}

alert("请选择后再操作！");

return false;

}

// 鼠标经过改变行的颜色

if (!objbeforeItem)

{

var objbeforeItem=null;

var objbeforeItembackgroundColor=null;

}

function ItemOver(obj)

{

if(objbeforeItem)

{

objbeforeItem.style.backgroundColor = objbeforeItembackgroundColor;

}

objbeforeItembackgroundColor = obj.style.backgroundColor;

objbeforeItem = obj;

obj.style.backgroundColor = "#B9D1F3";

}

// 多选的全选与取消

function checkJs(boolvalue)

{

if(document.all.checkboxname.length>1)

{

for(var i=0;i<document.all.checkboxname.length;i++)

{

document.all.checkboxname[i].checked = boolvalue;

}

else

document.all.checkboxname.checked = boolvalue;

}

// 只有全部选中时“全选”选中

function SingleCheckJs()

{

var flag1=false;

var flag2=false;

if (document.form1.checkboxname.length)

{

for (var i=0;i<document.form1.checkboxname.length;i++)

{

if(document.form1.checkboxname[i].checked)

flag1 = true;

else

flag2 = true;

}

else

{

if(document.form1.checkboxname.checked)

flag1 = true;

else

flag2 = true;

}

if(flag1==true&&flag2==false)

document.getElementById("chk").checked = true;

else

document.getElementById("chk").checked = false;

}

</script>

</head>

<body>

<table id="Table10" cellSpacing="0" cellPadding="0" border="0" Style="z-index: 103;

left: 21px; position: absolute; top: 20px; width: 90%;">

<tr>

<FIELDSET style="BORDER-RIGHT: #cccccc 1px solid; BORDER-TOP: #cccccc 1px solid; BORDER-LEFT: #cccccc 1px solid; BORDER-BOTTOM: #cccccc 1px solid; HEIGHT: 45px"><LEGEND><FONT face="宋体" size="2">合作商查询</FONT></LEGEND>

<table id="Table1" height="40" cellSpacing="0" cellPadding="0" width="100%" align="center"

border="0">

<tr>

<td height="30"><FONT face="宋体"> </FONT><FONT face="宋体"> 合作商名称

<asp:textbox id="TStfName" runat="server" BorderStyle="Groove" Width="144px"></asp:textbox> </FONT></td>

</tr>

<tr>

<asp:textbox id="StartTime" onfocus="setday(this)" runat="server" Width="159px"></asp:textbox> 到

<asp:textbox id="EndTime" onfocus="setday(this)" runat="server" Width="160px"></asp:textbox>   <FONT face="Times New Roman">   </FONT></td>

</tr>

<TR>

<asp:button id="SelectClient" runat="server" Text="搜　索" onclick="SelectClient_Click"></asp:button>   </FONT></FONT></TD>

</TR>

</table>

</FIELDSET>

</td>

</tr>

</table>

<table cellpadding="0" cellspacing="0" border="0" Style="z-index: 103;

left: 21px; position: absolute; top: 140px; width: 90%;">

<asp:GridView ID="GridView1" runat="server" Width="100%" CellPadding="4" ForeColor="#333333"

AutoGenerateColumns="False" AllowPaging="True" BorderColor="Silver"

BorderStyle="Solid" BorderWidth="1px" OnRowDataBound="GridView1_RowDataBound"

ShowFooter="false" EmptyDataText="没有数据记录！！" AllowSorting="True" OnSorting="GridView1_Sorting">

<asp:BoundField HeaderText="编号" DataField="id" Visible="False" />

<asp:TemplateField HeaderText="<input type='checkbox' id='chk' name='chk' οnclick='checkJs(this.checked);' />全选">

<input type="checkbox" id="checkboxname" name="checkboxname" value='<%# DataBinder.Eval(Container.DataItem, "StfId")%>' onclick='SingleCheckJs();' />

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="序号">

<%# (Container.DataItemIndex+1).ToString()%>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="充值">

<%#GetClientVisitInfoShowCmpMoney(DataBinder.Eval(Container.DataItem,"StfId"),DataBinder.Eval(Container.DataItem,"StfName"))%>

</ItemTemplate>

</asp:TemplateField>

<asp:BoundField HeaderText="公司名称" DataField="StfCmpName" SortExpression="StfCmpName"/>

<asp:BoundField HeaderText="登陆名" DataField="StfName" SortExpression="StfName" />

<asp:BoundField HeaderText="帐户金额" DataField="StfCmpMoney" SortExpression="StfCmpMoney" />

<asp:BoundField HeaderText="帐户Q币" DataField ="StfQbmoney" SortExpression="StfQbmoney" />

<asp:BoundField HeaderText="合作日期" DataField="StfRegisterTime" HtmlEncode="False" SortExpression="StfRegisterTime" />

<asp:TemplateField HeaderText="操作" >

<%#GetClientVisitInfoShowAnchorStr(DataBinder.Eval(Container.DataItem,"StfId"),DataBinder.Eval(Container.DataItem,"StfName"))%>

</ItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

</td>

</tr>

<tr>

<asp:LinkButton ID="btnFirst" CommandArgument="first" OnClick="PagerButtonClick"

runat="server">首页</asp:LinkButton> <asp:LinkButton ID="btnPrev" CommandArgument="prev" OnClick="PagerButtonClick" runat="server">上一页</asp:LinkButton>

<asp:LinkButton ID="btnNext" CommandArgument="next" OnClick="PagerButtonClick" runat="server">下一页</asp:LinkButton>

<asp:LinkButton ID="btnLast" CommandArgument="last" OnClick="PagerButtonClick" runat="server">尾页</asp:LinkButton>

<asp:Label ID="LblCurrentIndex" runat="server"></asp:Label>

<asp:Label ID="LblPageCount" runat="server"></asp:Label>

<asp:Label ID="LblRecordCount" runat="server"></asp:Label>

跳转到第<asp:DropDownList ID="ddlCurrentPage" runat="server" AutoPostBack="True" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged">

</asp:DropDownList>页</td> <tr>

 操作：

<asp:Button ID="Button3" runat="server" OnClick="Button3_Click" Text="删除合作商" />

</td>

</tr>

</table>

</form>

</body>

</html>

CS：

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

public partial class StfCmpManager : System.Web.UI.Page

{

protected void Page_Load(object sender, System.EventArgs e)

{

string StfRight = "";

// 在此处放置用户代码以初始化页面

if (Session["UserId"] == null)

{

Response.Write("<script language='javascript'>alert('工作超时，请重新登录。');top.window.location='default.aspx';</script>");

return;

}

else

{

StfRight = Session["UserRight"].ToString().Trim();

if (!this.IsPostBack)

{

if (StfRight != "7" && StfRight != "8")

{

Response.Write("<script language='javascript'>alert('你没有权限察看此页。');top.window.location='default.aspx';</script>");

return;

}

GridViewBind("");

}

private void GridViewBind(string Sqlsort)

{

string where = string.Empty;

where = "and a.StfRight='6' and a.StfId=b.Stfid";

if (TStfName.Text.Trim() != "")

{

where += " and a.StfCmpName like '%" + TStfName.Text.Trim() + "%'";

}

if (StartTime.Text.Trim() != "")

{

where += " and a.StfRegistertime >= '" + StartTime.Text + "'";

}

if (EndTime.Text.Trim() != "")

{

where += " and a.StfRegistertime <= '" + EndTime.Text + "'";

}

if (where != string.Empty)

{

where = "Where " + where.Substring(4);

}

string connStr = ConfigurationManager.AppSettings.Get("DataConnectionString");

string SqlStr = "Select a.StfId as StfId,a.StfName as StfName,a.StfRealName as StfRealName,a.StfCmpName as StfCmpName,b.StfCmpMoney as StfCmpMoney,b.StfQbmoney as StfQbmoney,a.StfRegistertime as StfRegistertime From TStafferInfo a,TCmpMoney b " + where + Sqlsort;

//Response.Write(SqlStr);

//Response.End();

DataSet ds = new DataSet();

try

{

SqlConnection conn = new SqlConnection(connStr);

if (conn.State.ToString() == "Closed") conn.Open();

SqlDataAdapter da = new SqlDataAdapter(SqlStr, conn);

da.Fill(ds, "TStafferInfo");

if (conn.State.ToString() == "Open") conn.Close();

GridView1.DataSource = ds.Tables[0].DefaultView;

GridView1.DataBind();

LblCurrentIndex.Text = "第 " + (GridView1.PageIndex + 1).ToString() + " 页";

LblPageCount.Text = "共 " + GridView1.PageCount.ToString() + " 页";

LblRecordCount.Text = "总共 " + ds.Tables[0].Rows.Count.ToString() + " 条";

if (ds.Tables[0].Rows.Count == 0)

{

btnFirst.Visible = false;

btnPrev.Visible = false;

btnNext.Visible = false;

btnLast.Visible = false;

LblCurrentIndex.Visible = false;

LblPageCount.Visible = false;

LblRecordCount.Visible = false;

}

else if (GridView1.PageCount == 1)

{

btnFirst.Visible = false;

btnPrev.Visible = false;

btnNext.Visible = false;

btnLast.Visible = false;

}

// 计算生成分页页码,分别为："首页" "上一页" "下一页" "尾页"

btnFirst.CommandName = "1";

btnPrev.CommandName = (GridView1.PageIndex == 0 ? "1" : GridView1.PageIndex.ToString());

btnNext.CommandName = (GridView1.PageCount == 1 ? GridView1.PageCount.ToString() : (GridView1.PageIndex + 2).ToString());

btnLast.CommandName = GridView1.PageCount.ToString();

this.ddlCurrentPage.Items.Clear();

for (int i = 1; i <= this.GridView1.PageCount; i++)

{

this.ddlCurrentPage.Items.Add(i.ToString());

}

this.ddlCurrentPage.SelectedIndex = this.GridView1.PageIndex;

}

catch (Exception ex)

{

Response.Write("数据库错误，错误原因：" + ex.Message);

Response.End();

}

protected void PagerButtonClick(object sender, EventArgs e)

{

GridView1.PageIndex = Convert.ToInt32(((LinkButton)sender).CommandName) - 1;

GridViewBind("");

}

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)

{

e.Row.Attributes["onmouseover"] = "ItemOver(this)";

}

protected void Button1_Click(object sender, EventArgs e)

{

Response.Write(Request.Form.Get("RadioName"));

}

protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)

{

string sql = "";

if (ViewState["DataConnectionString"] == null || ViewState["DataConnectionString"].ToString().CompareTo("") == 0)

{

ViewState["DataConnectionString"] = " desc";

}

else

ViewState["DataConnectionString"] = "";

sql = " order by " + e.SortExpression + ViewState["DataConnectionString"];

GridViewBind(sql);

//DataFormatString="{0:yyyy年MM月dd日 hh时mm分ss秒}"

}

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)

{

this.GridView1.PageIndex = this.ddlCurrentPage.SelectedIndex;

GridViewBind("");

}

private bool CheckAddClientInfoForm()

{

int Tag = 0;

if (Tag == 1)

{

Response.Write("<script>alert('请将带*项填写!')</script>");

return false;

}

if (Tag == 2)

{

Response.Write("<script>alert('两次输入密码不同')</script>");

return false;

}

else

{

return true;

}

public string GetClientVisitInfoShowAnchorStr(object StfId, object StfName)

{

string AnchorStr = "<a href='#'><Div οnclick='javascript:window.open("TManageModify.aspx?StfId=" + StfId + "&StfName=" + StfName + "","","height=280,Width=600,scrollbars=yes,resizable=yes,status=no")'>修改</Div></a>";

return AnchorStr;

}

public string GetClientVisitInfoShowCmpMoney(object StfId, object StfName)

{

string AnchorStr = "<a href='#'><Div οnclick='javascript:window.open("StfCmpMoneyInfo.aspx?StfId=" + StfId + "&StfName=" + StfName + "","","height=250,Width=500,scrollbars=yes,resizable=yes,status=no")'>充值</Div></a>";

return AnchorStr;

}

protected void Button3_Click(object sender, EventArgs e)

{

string str = "";

string[] ckb = null;

str = Request.Form.Get("checkboxname");

ckb = str.Split(new char[] { ',' });

for (int i = 0; i < ckb.Length; i++)

{ //帐户和信息同时删除

string StrSql = " Delete TStafferInfo where StfId ='" + ckb[i] + "'";

String StrSql_d = " Delete TCmpMoneyInfo where StfId ='" + ckb[i] + "'";

SqlConnection Conn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings.Get("DataConnectionString"));

SqlCommand Cmd = new System.Data.SqlClient.SqlCommand(StrSql, Conn);

SqlCommand Cmd_d = new System.Data.SqlClient.SqlCommand(StrSql_d, Conn);

Conn.Open();

SqlTransaction Trans = Conn.BeginTransaction();

try

{

Cmd.Transaction = Trans;

Cmd_d.Transaction = Trans;

Cmd.ExecuteNonQuery();

Cmd_d.ExecuteNonQuery();

Trans.Commit();

}

catch (Exception Err)

{

Trans.Rollback();

Response.Write(Err.Message);

}

Response.Write("<script>window.close();alert('操作员删除成功！');</script>");

GridViewBind("");

}

protected void SelectClient_Click(object sender, EventArgs e)

{

GridViewBind("");

}

https://www.dkcj.cn/info/27852.html

GridView自定义分页导航

相关文章：

一文看懂AI数据采集标注未来三年的发展和趋势

HTTP 状态代码及其定义

html5地理定位数据

GridView控件修改、删除示例（修改含有DropDownList控件）

国产AI芯片加速，鲲云携手浪潮推出数据流AI服务器

织梦dedecms如何快速使用拼音首字母做栏目名称

移动应用AI化成新战场？详解苹果最新Core ML模型构建基于机器学习的智能应用...

mysql5.1 与mysql5.5 字符集设置区别

@所有技术社区，年度”社区之星“开选，快来盘点各家技术大佬

Gridview][UpdateCommand的写法要点]

BZOJ 1040 ZJOI2008 骑士树形DP

在GridView内访问特定控件

解决 apache 2.4.1 无法解析shtml中的expr指令问题

新华三发布H3C Workspace数字工作空间：只需一张屏，程序员也能随时随地在云上写代码

centos 安装 NTFS支持

linux基本命令详解の第一季

asp.net 2.0中一次性更新所有GRIDVIEW的记录

清华 CVer 对自监督学习的一些思考

使用 HTML5 时如何改进移动 Web 应用开发

hibernate.cfg.xml详细配置

ASP.NET2.0中用Gridview控件操作数据

人工智能在消费领域，都做了哪些事？

poj 1681 Painter#39;s Problem(高斯消元)

ASP.NET 2.0中GRIDVIEW排序

基础篇9-python基本数据结构-列表

用AI打造科技公益新模式，腾讯发起公益创新挑战赛，聚焦三大社会问题

一个查看全部用户的磁盘空间使用情况的脚本

Gridview导出到Excel,Gridview中的各类控件,Gridview中删除记录的处理

对标Oculus Quest2，爱奇艺奇遇VR打的什么牌？

DVWA默认用户名密码