<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Index.aspx.cs" Inherits="Index" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title>网页查询</title>
<link href="http://cdn.bootcss.com/bootstrap/3.3.4/css/bootstrap.min.css" rel="stylesheet" />
<script src="http://cdn.bootcss.com/bootstrap/3.3.4/js/bootstrap.min.js"></script>
<!-- HTML5 Shim 和 Respond.js 用于让 IE8 支持 HTML5元素和媒体查询 -->
<!-- 注意: 如果通过 file:// 引入 Respond.js 文件,则该文件无法起效果 -->
<!--[if lt IE 9]>
<script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
<script src="https://oss.maxcdn.com/libs/respond.js/1.3.0/respond.min.js"></script>
<![endif]-->
<style>
* {
margin:0px;
padding:0px;
}
.lab-a {
margin:20px auto;
}
</style>
</head>
<body>
<form id="form1" runat="server" class="form-horizontal">
<div class="form-group lab-a">
<asp:Label ID="Label1" runat="server" Text="标题:" style="margin-bottom:-30px;" class="col-sm-3 control-label "></asp:Label>
<div class="col-sm-10 col-sm-offset-3">
<asp:TextBox ID="TextBox1" runat="server" Height="30px" Width="271px" class="form-control"></asp:TextBox>
</div>
</div>
<div class="form-group ">
<div class="col-sm-10 col-sm-offset-3">
<label for="name">查询条件选择:</label>
<div class="lab-a ">
<label class="checkbox-inline">
<asp:CheckBox ID="CheckBox2" runat="server" /> 学生性别
</label>
<label class="checkbox-inline">
<asp:CheckBox ID="CheckBox4" runat="server" /> 学生姓名
</label>
<label class="checkbox-inline">
<asp:CheckBox ID="CheckBox5" runat="server" />学生年龄
</label>
</div>
</div>
</div>
<div class="form-group">
<div class="col-sm-offset-3 col-sm-10">
<asp:Button ID="Button1" runat="server" Text="查询" class="btn btn-primary" OnClick="Button1_Click1" />
<asp:Button ID="Button5" runat="server" Text="添加" class="btn btn-success" OnClick="Button5_Click" />
<asp:Button ID="Button2" runat="server" Text="修改" class="btn btn-warning" OnClick="Button2_Click" />
<asp:Button ID="Button3" runat="server" Text="删除" class="btn btn-danger" OnClick="Button3_Click" />
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
</div>
</div>
<asp:UpdatePanel ID="UpdatePanel1" runat="server" UpdateMode="Conditional">
<ContentTemplate>
<div class="form-group">
<div class="col-sm-offset-2 col-sm-10">
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" Height="126px" Width="855px" BackColor="White" BorderColor="#336666" BorderStyle="Double" BorderWidth="3px" CellPadding="4" GridLines="Horizontal" AllowPaging="True" CssClass="table-hover table" PageSize="5" OnPageIndexChanging="GridView1_PageIndexChanging" OnDataBound="GridView1_DataBound" AllowSorting="True" OnSorting="GridView1_Sorting" OnRowDataBound="GridView1_RowDataBound" OnRowDeleting="GridView1_RowDeleting" >
<Columns>
<asp:TemplateField HeaderText="选择">
<ItemTemplate>
<asp:CheckBox ID="CheckBox1" runat="server" />
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="stu_id" HeaderText="学生编号" SortExpression="stu_id" />
<asp:BoundField DataField="stu_code" HeaderText="学生学号" />
<asp:BoundField DataField="stu_name" HeaderText="学生姓名" />
<asp:BoundField DataField="stu_sex" HeaderText="学生性别" />
<asp:BoundField DataField="age" HeaderText="学生年龄" />
<asp:BoundField DataField="stu_dept" HeaderText="学生系别" />
<asp:BoundField DataField="stu_admin" HeaderText="学生密码" />
<asp:BoundField DataField="stu_provinces" HeaderText="省" />
<asp:BoundField DataField="stu_city" HeaderText="市" />
<asp:BoundField DataField="stu_districts" HeaderText="县" />
<asp:CommandField HeaderText="删除" ShowDeleteButton="True" />
</Columns>
<FooterStyle BackColor="White" ForeColor="#333333" />
<HeaderStyle BackColor="#336666" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#336666" ForeColor="White" HorizontalAlign="Center" />
<PagerTemplate>
<asp:Label ID="lblPage" runat="server" Text='<%# "第" + (((GridView)Container.NamingContainer).PageIndex + 1) + "页/共" + (((GridView)Container.NamingContainer).PageCount) + "页" %> '></asp:Label>
<asp:LinkButton ID="lbnFirst" runat="Server" Text="首页" Enabled='<%# ((GridView)Container.NamingContainer).PageIndex != 0 %>' CommandName="Page" CommandArgument="First" ></asp:LinkButton>
<asp:LinkButton ID="lbnPrev" runat="server" Text="上一页" Enabled='<%# ((GridView)Container.NamingContainer).PageIndex != 0 %>' CommandName="Page" CommandArgument="Prev" class="previous" ></asp:LinkButton>
<asp:LinkButton ID="lbnNext" runat="Server" Text="下一页" Enabled='<%# ((GridView)Container.NamingContainer).PageIndex != (((GridView)Container.NamingContainer).PageCount - 1) %>' CommandName="Page" CommandArgument="Next" class="next"></asp:LinkButton>
<asp:LinkButton ID="lbnLast" runat="Server" Text="尾页" Enabled='<%# ((GridView)Container.NamingContainer).PageIndex != (((GridView)Container.NamingContainer).PageCount - 1) %>' CommandName="Page" CommandArgument="Last" ></asp:LinkButton>
到第 <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" ForeColor="Red" Height="19px" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged" Width="70px"></asp:DropDownList> 页
</PagerTemplate>
<RowStyle BackColor="White" ForeColor="#333333" />
<SelectedRowStyle BackColor="#339966" Font-Bold="True" ForeColor="White" />
<SortedAscendingCellStyle BackColor="#F7F7F7" />
<SortedAscendingHeaderStyle BackColor="#487575" />
<SortedDescendingCellStyle BackColor="#E5E5E5" />
<SortedDescendingHeaderStyle BackColor="#275353" />
</asp:GridView>
</div>
</div>
</ContentTemplate>
</asp:UpdatePanel>
</form>
</body>
</html>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using MySql.Data.MySqlClient;
using DBHelper;
public partial class Index : System.Web.UI.Page
{
Student stu_s = new Student();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ViewState["SortOrder"] = "stu_id";
ViewState["OrderDire"] = "ASC";
BindView();
}
}
public void BindView()
{
string names = "";
if (!string.IsNullOrEmpty(this.TextBox1.Text)) {
names += " and stu_name like '" + this.TextBox1.Text + "%'";
}
DataView view=stu_s.GetTableSet(names);
string sort = (string)ViewState["SortOrder"] + " " + (string)ViewState["OrderDire"];
view.Sort = sort;
GridView1.DataSource = view;
GridView1.DataKeyNames = new string[] { "stu_id" };
GridView1.DataBind();
//GridView1.BottomPagerRow.Visible = true;
//GridViewRow pagerow = GridView1.BottomPagerRow;
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
BindView();
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
GridViewRow pagerRow = GridView1.BottomPagerRow;
DropDownList pageList = (DropDownList)pagerRow.Cells[0].FindControl("DropDownList1");
GridView1.PageIndex = pageList.SelectedIndex;
BindView();
}
protected void GridView1_DataBound(object sender, EventArgs e)
{
//GridViewRow pagerRow = GridView1.BottomPagerRow;
//DropDownList pageList = (DropDownList)pagerRow.Cells[0].FindControl("DropDownList1");
//if (pageList != null)
//{
// for (int i = 0; i < GridView1.PageCount; i++)
// {
// int pageNumber = i + 1;
// ListItem item = new ListItem(pageNumber.ToString());
// if (i == GridView1.PageIndex)
// {
// item.Selected = true;
// }
// pageList.Items.Add(item);
// }
//}
}
protected void Button1_Click(object sender, EventArgs e)
{
}
protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
{
string sPage = e.SortExpression;
if (ViewState["SortOrder"].ToString() == sPage)
{
if (ViewState["OrderDire"].ToString() == "Desc")
ViewState["OrderDire"] = "ASC";
else
ViewState["OrderDire"] = "Desc";
}
else
{
ViewState["SortOrder"] = e.SortExpression;
}
BindView();
}
protected void Button1_Click1(object sender, EventArgs e)
{
//if (this.TextBox1.Text == "")
//{
// BindView();
//}
//else
//{
// string names = this.TextBox1.Text.Trim();
// DataView view = stu_s.GetTableViewString(names);
// GridView1.DataSource = view;
// GridView1.DataKeyNames = new string[] { "stu_id" };
// GridView1.DataBind();
//}
BindView();
}
protected void Button5_Click(object sender, EventArgs e)
{
Response.Redirect("AddStudent.aspx");
}
protected void Button2_Click(object sender, EventArgs e)
{
string id="";
for (int i = 0; i < GridView1.Rows.Count - 1; i++) {
CheckBox ckb = (CheckBox)GridView1.Rows[i].FindControl("Checkbox1");
if (ckb.Checked == true) {
id = GridView1.DataKeys[i].Value.ToString();
}
}
Response.Redirect("AddStudent.aspx?id=" + id);
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string sqlstr = "delete from t_student where stu_id='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
DBHelper.SqlHelper.ExecteNonQueryText(sqlstr);
Response.Write("<script>alert('删除成功')</script>");
GridView1.EditIndex = -1;
BindView();
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
//如果是绑定数据行
if (e.Row.RowType == DataControlRowType.DataRow)
{
if (e.Row.RowState == DataControlRowState.Normal || e.Row.RowState == DataControlRowState.Alternate)
{
((LinkButton)e.Row.Cells[11].Controls[0]).Attributes.Add("onclick", "javascript:return confirm('你确认要删除:" + e.Row.Cells[3].Text + "吗?')");
}
//首先判断是否是数据行
if (e.Row.RowType == DataControlRowType.DataRow)
{
//当鼠标停留时更改背景色
e.Row.Attributes.Add("onmouseover", "c=this.style.backgroundColor;this.style.backgroundColor='#00A9FF'");
//当鼠标移开时还原背景色
e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=c");
}
//如果是绑定数据行
if (e.Row.RowType == DataControlRowType.DataRow)
{
//鼠标经过时,行背景色变
e.Row.Attributes.Add("onmouseover", "this.style.backgroundColor='#E6F5FA'");
//鼠标移出时,行背景色变
e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor='#FFFFFF'");
}
}
}
protected void Button3_Click(object sender, EventArgs e)
{
string id = "";
for (int i = 0; i < GridView1.Rows.Count - 1; i++)
{
CheckBox ckb = (CheckBox)GridView1.Rows[i].FindControl("Checkbox1");
if (ckb.Checked == true)
{
id = GridView1.DataKeys[i].Value.ToString();
}
}
int x = stu_s.GetDelStudent(id);
if (x > 0)
{
Response.Write("<script>alert('删除成功,当前删除值':" + id + ");</script>");
}
else {
Response.Write("<script>alert('删除失败')</script>");
}
BindView();
}
}