• gridview弹出窗口


    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(" ", "").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(" ", "").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(" ", "").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(" ", "").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">

    <html xmlns="http://www.w3.org/1999/xhtml" >
    <head id="Head1" runat="server">
        <title>部门管理</title>
        <link href="../css/CRM.css" type="text/css" rel="stylesheet" />
    </head>
    <body>
        <form id="form1" runat="server">
            <table width="100%" height="100%">
                 <tr height="20px">
               <td colspan="3" style="font-weight: bold; font-size: 20px; color: white;  height: 5px;
                        font-family: 楷体_GB2312; height: 27px; background-color: #63769b">
                        部门管理
               </td>
           </tr>
                <tr height="20px">
                    <td align="center" style=" 20%; font-weight: bold; font-size:20px; color:Black; height:5px; font-family: 楷体_GB2312; height:27px;">
                       部门名称:</td>
                    <td width="30%">
                        <asp:TextBox ID="txbDepartment" MaxLength="20" Width="300px" Height="20px" runat="server"></asp:TextBox>
                    </td>
                    <td align="left">
                        &nbsp;<asp:ImageButton ID="ImgDepartment" runat="server" ImageUrl="~/Images/button/btnAdd.gif"
                            OnClick="ImgDepartment_Click" /></td>
                </tr>
                <tr valign="top">
                    <td colspan="3">
                        <asp:GridView ID="GridView1" runat="server" Width="100%" AutoGenerateColumns="False" CellPadding="4" ForeColor="#333333"
                        GridLines="None" OnRowCancelingEdit="GridView1_RowCancelingEdit" OnRowEditing="GridView1_RowEditing"
                        OnRowUpdating="GridView1_RowUpdating" DataKeyNames="DEPARTMENTID" OnRowCreated="GridView1_RowCreated"
                        OnRowDeleting="GridView1_RowDeleting">
                            <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                            <RowStyle BackColor="#EFF3FB" Height="13px" />
                            <EditRowStyle BackColor="#2461BF" />
                            <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
                            <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
                            <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" Height="13px" />
                            <AlternatingRowStyle BackColor="White" />
                            <Columns>
                                <asp:TemplateField HeaderText="部门名称" >
                                    <EditItemTemplate>
                                        <asp:TextBox ID="txbDepartment" MaxLength="20" runat="server" Text='<%# Eval("DEPARTMENTNAME") %>'></asp:TextBox>
                                    </EditItemTemplate>
                                    <ItemTemplate>
                                        <asp:Label ID="lblDepartment" runat="server" Text='<%# Eval("DEPARTMENTNAME") %>'></asp:Label>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                 <asp:BoundField  HeaderText="权限">
                                                <HeaderStyle Wrap="False"  />
                                                <ItemStyle Wrap="False" Font-Bold="True" Width="60" ForeColor="MidnightBlue"/>
                                            </asp:BoundField>
                                <%--<asp:HyperLinkField DataNavigateUrlFields="DEPARTMENTID" DataNavigateUrlFormatString="DepartmentPower.aspx?id={0}"
                                     HeaderText="权限" Target="_blank" Text="分配权限" ItemStyle-Width=60>
                                    <HeaderStyle Wrap="False" />
                                </asp:HyperLinkField>--%>
                                <asp:CommandField HeaderText="编辑" ShowEditButton="True" ItemStyle-Width=40 />
                                <asp:CommandField HeaderText="删除" ShowDeleteButton="True"  ItemStyle-Width=40/>
                            </Columns>
                        </asp:GridView>
                    </td>
                </tr>
            </table>
        </form>
    </body>
    </html>

  • 相关阅读:
    页面笔记
    RestTemplate
    Spring中使用HibernateCallback
    工作中的小零碎
    hibernate核心思想 体系结构(转)
    db2备份和导入单个表操作
    MSB-STRUTS-课堂笔记
    设计模式:策略模式(转)
    java中的匿名内部类总结(转)
    struts2.0中Action的对象生命周期详解!!(转)
  • 原文地址:https://www.cnblogs.com/kaiwanlin/p/3632564.html
Copyright © 2020-2023  润新知