1、前台
<head runat="server">
<title></title>
<script type="text/javascript">
function showinfo() {
if (confirm('真的要删除吗') == false)
return false;
}
</script>
</head>
<body>
<form id="form1" runat="server">
<div>
<table>
<tr><td>
<asp:LinkButton ID="btnAdd" runat="server" οnclick="btnAdd_Click">添加</asp:LinkButton>
<asp:Button ID="btnDelete" runat="server" Text="删除" OnClientClick="return showinfo()"
οnclick="btnDelete_Click1" />
</td></tr>
<tr>
<td>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
AllowSorting="True" onrowdatabound="GridView1_RowDataBound"
onsorting="GridView1_Sorting" ShowFooter="True">
<Columns>
<asp:TemplateField HeaderText="选择">
<ItemTemplate>
<asp:CheckBox ID="ck1" runat="server" />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="标题">
<ItemTemplate>
<a href='WebShowXx.aspx?id=<%# Eval("Id") %>'><%# Eval("NewsTitle") %></a>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="NewsContent" HeaderText="内容" />
<asp:BoundField DataField="RealName" HeaderText="创建者"
SortExpression="RealName" />
<asp:BoundField DataField="CreateTime" DataFormatString="{0:yyyy-MM-dd hh:mm:ss}"
HeaderText="创建时间" SortExpression="CreateTime" />
<asp:BoundField DataField="ClassName" HeaderText="类别" />
<asp:TemplateField HeaderText="操作">
<ItemTemplate>
<asp:LinkButton ID="btnEdit" runat="server" CommandArgument='<%#Eval("Id") %>' οnclick="btnEdit_Click">编辑</asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="操作">
<ItemTemplate>
<asp:LinkButton ID="btnDelete" CommandArgument='<%#Eval("Id") %>'
runat="server" οnclick="btnDelete_Click" OnClientClick="return showinfo();">删除</asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</td>
</tr>
<tr>
<td>
<asp:LinkButton ID="btnFirst" runat="server" οnclick="btnFirst_Click">第一页 </asp:LinkButton>
<asp:LinkButton ID="btnPre" runat="server" οnclick="btnPre_Click">上一页</asp:LinkButton>
<asp:LinkButton ID="btnNext" runat="server" οnclick="btnNext_Click">下一页</asp:LinkButton>
<asp:LinkButton ID="btnLast" runat="server" οnclick="btnLast_Click">最后一页</asp:LinkButton>
</td>
</tr>
</table>
</div>
<asp:LinkButton ID="LinkButton1" runat="server">LinkButton</asp:LinkButton>
</form>
</body>
2、后台
public partial class WebForm1 : System.Web.UI.Page
{
int pagesize = 20;
int lcount = 0;
int xcount = 0;
//Dictionary<string, string> dic = new Dictionary<string, string>();
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack==false)
{
if (!string.IsNullOrEmpty(Request.QueryString["pageindex"]))
{
ViewState["pageindex"] = Request.QueryString["pageindex"];
}
else
{
ViewState["pageindex"] = 1;
}
GetCount();
LoadData();
}
}
private void GetCount()
{
string strcon = @"Data Source=机名;Initial Catalog=数据库名;Persist Security Info=True;User ID=数据库名称;Password=数据库密码";
SqlConnection conn = new SqlConnection(strcon);
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
conn.Open();
//cmd.CommandText = "SELECT T1.Id,T1.NewsTitle,SUBSTRING(T1.NewsContent,0,20)+'......' AS NewsContent,T1.CreateTime,T2.ClassName,T3.RealName FROM T_News1 T1 INNER JOIN T_NewsClass T2 ON T1.ClassId=T2.ClassId INNER JOIN T_User T3 ON T1.NewsCreator=T3.UserId";
cmd.CommandText = " SELECT COUNT(*) FROM T_News1";
int totalcount=Convert.ToInt32(cmd.ExecuteScalar());
cmd.Dispose();
conn.Dispose();
if (totalcount % pagesize == 0)
{
ViewState["pagelastindex"] = totalcount / pagesize;
}
else
{
ViewState["pagelastindex"] = totalcount / pagesize + 1;
}
}
private void LoadData()
{
string strcon = @"Data Source=机名;Initial Catalog=数据库名;Persist Security Info=True;User ID=数据库名称;Password=数据库密码";
SqlConnection conn = new SqlConnection(strcon);
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
//每次都显式打开
conn.Open();
//cmd.CommandText = "SELECT T1.Id,T1.NewsTitle,SUBSTRING(T1.NewsContent,0,20)+'......' AS NewsContent,T1.CreateTime,T2.ClassName,T3.RealName FROM T_News1 T1 INNER JOIN T_NewsClass T2 ON T1.ClassId=T2.ClassId INNER JOIN T_User T3 ON T1.NewsCreator=T3.UserId";
string sqlstr = "SELECT * FROM (SELECT ROW_NUMBER() OVER(ORDER BY T1.Id DESC)AS rownumber, T1.Id,T1.NewsTitle,SUBSTRING(T1.NewsContent,0,20)+'......' AS NewsContent,T1.CreateTime,T2.ClassName,T3.RealName FROM T_News1 T1 INNER JOIN T_NewsClass T2 ON T1.ClassId=T2.ClassId INNER JOIN T_User T3 ON T1.NewsCreator=T3.UserId)A WHERE A.rownumber>(@pageindex-1)*@pagesize AND A.rownumber<=@pageindex*@pagesize";
if (ViewState["sortexp"]!=null)
{
Dictionary<string, string> dic = ViewState["sortexp"] as Dictionary<string, string>;
string sqlorder = string.Empty;
foreach (KeyValuePair<string,string> item in dic)
{
sqlorder += item.Key + " " + item.Value+",";
}
sqlstr=sqlstr+" ORDER BY "+sqlorder.TrimEnd(',');
}
cmd.CommandText = sqlstr;
cmd.Parameters.AddWithValue("@pageindex",ViewState["pageindex"]);
cmd.Parameters.AddWithValue("@pagesize", pagesize);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
adapter.Fill(dt);
cmd.Dispose();
conn.Dispose();
//将查询出来的数据绑定到GridView
//原来需要手动拼接字符串的工作由GridView代劳了
this.GridView1.DataSource = dt;
//DataBind负责拼接字符串
this.GridView1.DataBind();
}
protected void btnFirst_Click(object sender, EventArgs e)
{
ViewState["pageindex"] = 1;
LoadData();
}
protected void btnPre_Click(object sender, EventArgs e)
{
int pageindex = Convert.ToInt32(ViewState["pageindex"]);
if (pageindex > 1)
{
pageindex--;
ViewState["pageindex"] = pageindex;
LoadData();
}
}
protected void btnNext_Click(object sender, EventArgs e)
{
int pageindex = Convert.ToInt32(ViewState["pageindex"]);
if (pageindex<Convert.ToInt32(ViewState["pagelastindex"]))
{
pageindex++;
ViewState["pageindex"] = pageindex;
LoadData();
}
}
protected void btnLast_Click(object sender, EventArgs e)
{
ViewState["pageindex"] = ViewState["pagelastindex"];
LoadData();
}
protected void btnEdit_Click(object sender, EventArgs e)
{
LinkButton btnEdit = sender as LinkButton;
Response.Redirect("WebEdit2.aspx?pageindex=" +Convert.ToInt32(ViewState["pageindex"]) + "&id=" + btnEdit.CommandArgument);
}
protected void btnDelete_Click(object sender, EventArgs e)
{
//sender 表示触发此事件的对象，在这里就是Id为btnDelete的LinkButton对象，但是默认此对象为object类型，object类型没有CommandArgument属性，此属性为LinkButton类型对象所有，所以我们需要自己动手将其转换为LinkButton类型，才可以获取CommandArgument属性存储的值
LinkButton btnDelete = sender as LinkButton;
string strcon = @"Data Source=机名;Initial Catalog=数据库名;Persist Security Info=True;User ID=数据库名称;Password=密码";
SqlConnection conn = new SqlConnection(strcon);
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
conn.Open();
cmd.CommandText = "DELETE FROM T_News1 WHERE Id=@id";
cmd.Parameters.AddWithValue("@id",btnDelete.CommandArgument);
if (cmd.ExecuteNonQuery() > 0)
{
//删除之后重新加载页面，让用户看到最新的变化
LoadData();
}
cmd.Dispose();
conn.Dispose();
}
//添加
protected void btnAdd_Click(object sender, EventArgs e)
{
Response.Redirect("WebAdd.aspx");
}
protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
{
//判断用户点击了哪个排序字段
//说明用户第一次点击排序字段
if (ViewState["sortexp"] == null)
{
Dictionary<string, string> dic = new Dictionary<string, string>();
dic.Add(e.SortExpression, "ASC");
ViewState["sortexp"] = dic;
}
else//用户第二次或者第N次点击排序字段
{
Dictionary<string, string> dic = ViewState["sortexp"] as Dictionary<string, string>;
//判断用户本次点击的排序字段是否和上次点击的排序字段一致，如果一致的话，那么就更改此字段的排序规则，如果不是就清除上次的排序字段，添加新的排序字段和规则(这是根据一个字段排序的情况)
if (dic.ContainsKey(e.SortExpression))
{
//如果上次是升序，则改为降序,如果是降序则改为升序
if (dic[e.SortExpression] == "ASC")
{
dic[e.SortExpression] = "DESC";
}
else
{
dic[e.SortExpression] = "ASC";
}
//ViewState["sortexp"] = dic;
}
else//清除上次排序字段和规则，添加新的排序字段和规则
{
//dic.Clear();
dic.Add(e.SortExpression, "ASC");
//ViewState["sortexp"] = dic;
}
}
//重新加载数据
LoadData();
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
#region 添加排序指示符
//RowDataBound事件的特殊之处在于，每加载一行都会执行一遍
//判断当前加载的是哪种类型的行，我们的目的是在标题行上做更改
if (e.Row.RowType == DataControlRowType.Header)
{
//遍历标题行中的所有列，找出包含控件的列。因为我们知道拍序列已经成为LinkButton控件了。
for (int i = 0; i < e.Row.Cells.Count; i++)
{
//在目前的程序中，只有拍序列里包含控件，其他列只是文字而已
if (e.Row.Cells[i].Controls.Count > 0)
{
LinkButton link = e.Row.Cells[i].Controls[0] as LinkButton;
//经过调试发现LiknButton的CommandArgument属性存储的就是当前排序列的字段名称
string sortexp = link.CommandArgument;
if (ViewState["sortexp"] != null)
{
Dictionary<string, string> dic = ViewState["sortexp"] as Dictionary<string, string>;
if (dic.ContainsKey(sortexp))
{
Literal li = new Literal();
//在viewstate中查询用户点当前点击的排序字段对应的排序规则，根据降序和升序动态的添加指示箭头
if (dic[sortexp] == "ASC")
{
li.Text = "↑";
}
else
{
li.Text = "↓";
}
//将包含排序指示箭头的控件添加到当前的排序列中
e.Row.Cells[i].Controls.Add(li);
}
}
}
}
}
#endregion
}
protected void btnDelete_Click1(object sender, EventArgs e)
{
//获取选中的行
string sqlid=string.Empty;
foreach (GridViewRow row in this.GridView1.Rows)
{
CheckBox chek=row.Cells[0].FindControl("ck1") as CheckBox;
if (chek.Checked==true)
{
LinkButton link=row.Cells[6].FindControl("btnEdit") as LinkButton;
sqlid += link.CommandArgument + ",";
}
}
if (DeleteNews(sqlid.TrimEnd(',')) > 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "infomation", "alert('删除成功')", true);
LoadData();
}
}
private int DeleteNews(string sqlid)
{
string strcon = @"Data Source=机名;Initial Catalog=数据库名;Persist Security Info=True;User ID=数据库名称;Password=密码";
SqlConnection conn = new SqlConnection(strcon);
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
//每次都显式打开
conn.Open();
cmd.CommandText = " DELETE FROM T_News1 WHERE Id IN("+sqlid+")";
int totalcount = cmd.ExecuteNonQuery();
cmd.Dispose();
conn.Dispose();
return totalcount;
}
}
扫一扫
125
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
