gridview中加弹出窗口用例

wapysun

浏览: 21546520 次
性别:
来自: 杭州

最近访客更多访客>>

devcang

hunankeda110

辽东小小

apex53

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

2012-06 ( 77)
2012-05 ( 587)
2012-04 ( 177)
更多存档...

ASP SQL Server UI Web CSS

。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.Text;

public partial class System_ManageDepartment : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
GridView1.DataSource = null;
BindGridView();
}
}

protected void ImgDepartment_Click(object sender, ImageClickEventArgs e)
{
if (!JS.isCookiesAvailabile())
{
return;
}

//插入部门名称的SQL语句
StringBuilder strsql = new StringBuilder("INSERT INTO DICT_DEPARTMENT(DEPARTMENTNAME) VALUES('")
.Append(txbDepartment.Text.Trim())
.Append("')");

try
{
if (txbDepartment.Text.Trim() != "")
{
//插入用户增加的部门名称

DbHelperSQL.ExecuteSql(strsql.ToString());

//显示所有的部门名称
BindGridView();

//清空文本框中的内容

txbDepartment.Text = "";
}
else
{
JS.Alert("部门名称不能为空！请输入部门名称！");
}
}
catch (Exception ex)
{
JS.Alert("操作失败，详细信息：" + ex.Message.Replace("\r\n", "").Replace("'", ""));
}
}

#region 绑定GridView1
protected void BindGridView()
{
if (!JS.isCookiesAvailabile())
{
return;
}

try
{
DataTable dt = DbHelperSQL.gettable("SELECT * FROM DICT_DEPARTMENT WHERE DEPARTMENTID>0");
GridView1.DataSource = dt;
GridView1.DataBind();
}
catch (Exception ex)
{
JS.Alert("操作失败，详细信息：" + ex.Message.Replace("\r\n", "").Replace("'", ""));
}
}
#endregion

protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
BindGridView();
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
BindGridView();
}

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string departmentname = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txbDepartment")).Text.Trim();
if (!string.IsNullOrEmpty(departmentname))
{
StringBuilder strsql = new StringBuilder("UPDATE DICT_DEPARTMENT SET DEPARTMENTNAME='")
.Append(departmentname)
.Append("'")
.Append(" WHERE DEPARTMENTID='")
.Append(GridView1.DataKeys[e.RowIndex].Value)
.Append("'");

try
{
DbHelperSQL.ExecuteSql(strsql.ToString());
GridView1.EditIndex = -1;
BindGridView();
}
catch (Exception ex)
{
JS.Alert("修改部门名称失败，详细信息：" + ex.Message.Replace("\r\n", "").Replace("'", ""));
}
}
else
{
JS.Alert("部门名称不可为空，请重新输入！");
}
}

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
StringBuilder strsql = new StringBuilder("DELETE FROM DICT_DEPARTMENT WHERE DEPARTMENTID='")
.Append(GridView1.DataKeys[e.RowIndex].Value)
.Append("'");

try
{
DbHelperSQL.ExecuteSql(strsql.ToString());
BindGridView();

}
catch (Exception ex)
{
JS.Alert("删除部门名称失败！" + ex.Message.Replace("\r\n", "").Replace("'", ""));
}
}

protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)
{
if (null == this.GridView1.DataSource)
{
return;
}
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Cells[e.Row.Cells.Count - 1].Attributes.Add("onclick", "return confirm('确定要永久删除该条记录吗？');");

int index = e.Row.RowIndex;
if (index >= 0)
{
if (this.GridView1.DataSource != null)
{
DataTable dt = ((DataTable)this.GridView1.DataSource);
e.Row.Cells[1].Text = "分配权限";
e.Row.Cells[1].Attributes.Add("onclick", string.Format("window.open('DepartmentPower.aspx?id={0}','','left=250,top=100,scrollbars=yes,width=700,height=470,resizable=yes');", dt.Rows[e.Row.RowIndex]["DEPARTMENTID"]));

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

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