gridview修改，添加，删除等

最新推荐文章于 2022-01-18 22:13:52 发布

sunchaohuang

最新推荐文章于 2022-01-18 22:13:52 发布

阅读量4.5k

点赞数

分类专栏： ASP.NET 文章标签： asp textbox server object dataset table

ASP.NET 专栏收录该内容

68 篇文章

订阅专栏

本文介绍了一个使用GridView实现的培训管理系统示例，展示了dropdownlist的集成、新增行的绑定及编辑功能、时间验证等技巧，并提供了不可编辑列的设置示例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

下面的gridview使用到了常用的基本功能：

1 dropdownlist的使用

2 新增行的绑定

3 新增行的修改，添加，删除

4 基本功能的编辑，删除

5 行的颜色改变(如编辑行)

6 girdview中时间的验证功能(如开始时间)

7 不可编辑列，不可编辑单元的设置(如建立日期)

代码中有些隐藏的和多余的部分，大家知道一下。最重要的演示gridview的使用。

代码如下：（数据库部分大家感觉一下，不能什么都弄出来。不好意思了。一般人都可以感觉出来的了）

<%@ Register TagPrefix="FCKeditorV2" Namespace="FredCK.FCKeditorV2" Assembly="FredCK.FCKeditorV2" %>

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="PeiXunJinXiu.aspx.cs" Inherits="InterFace_RenShi_PeiXunJinXiu" ValidateRequest="false" %>

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

</head>

<body>

<div>

<table>

<tr>

<td>

<asp:Label ID="LabelStatus" runat="server" Font-Size="10pt" Text="当前状态:"></asp:Label></td>

<td>

<asp:Menu ID="MenuCaidan" runat="server" BackColor="#FFFFC0" DynamicHorizontalOffset="2"

Font-Names="Verdana" Font-Size="0.8em" ForeColor="#990000" OnMenuItemClick="MenuCaidan_MenuItemClick"

Orientation="Horizontal" StaticSubMenuIndent="10px">

<Items>

<asp:MenuItem Selected="True" Text="人事栏" Value="客户栏"></asp:MenuItem>

<asp:MenuItem Text="培训进修" Value="培训进修"></asp:MenuItem>

</Items>

<%# Eval("Text") %>

</StaticItemTemplate>

<StaticHoverStyle BackColor="#FFC0C0" Font-Overline="False" Font-Underline="True"

ForeColor="White" />

</asp:Menu>

</td>

</tr>

</table>

</tr>

</table>

<asp:MultiView ID="MultiViewXinXiGuanLi" runat="server" ActiveViewIndex="0">

<asp:View ID="ViewXinXiLan" runat="server">

<table>

<tr>

<td>

<table>

<tr>

<td>

<asp:Image ID="ImageShouYe" runat="server" ImageUrl="~/DatabaseImg/100.jpg" /></td>

</tr>

</table>

</td>

<td>

<table>

<tr>

选择类别名称

</td>

<td>

条件

</td>

<td>

输入要查询的条件值

</td>

</tr>

<tr>

<asp:DropDownList ID="DropDownListLeiBeiOne" runat="server" Width="100px">

</asp:DropDownList></td>

<td>

<asp:DropDownList ID="DropDownListTiaoJianOne" runat="server" Width="80px">

</asp:DropDownList></td>

<td>

<asp:TextBox ID="TextBoxOne" runat="server" class="smallInput"></asp:TextBox></td>

</tr>

<tr>

<asp:DropDownList ID="DropDownListLeiBeiTwo" runat="server" Width="100px">

</asp:DropDownList></td>

<td>

<asp:DropDownList ID="DropDownListTiaoJianTwo" runat="server" Width="80px">

</asp:DropDownList></td>

<td>

<asp:TextBox ID="TextBoxTwo" runat="server" class="smallInput"></asp:TextBox></td>

</tr>

<tr>

<asp:DropDownList ID="DropDownListLeiBeiThree" runat="server" Width="100px">

</asp:DropDownList></td>

<td>

<asp:DropDownList ID="DropDownListTiaoJianThree" runat="server" Width="80px">

</asp:DropDownList></td>

<td>

<asp:TextBox ID="TextBoxThree" runat="server" class="smallInput"></asp:TextBox></td>

</tr>

<tr>

<asp:DropDownList ID="DropDownListLeiBeiFour" runat="server" Width="100px">

</asp:DropDownList></td>

<td>

<asp:DropDownList ID="DropDownListTiaoJianFour" runat="server" Width="80px">

</asp:DropDownList></td>

<td>

<asp:TextBox ID="TextBoxFour" runat="server" class="smallInput"></asp:TextBox></td>

</tr>

<tr>

<asp:Label ID="Labelchaxunfangshi" runat="server" Text="查询排序方式："></asp:Label></font></td>

<td>

<asp:DropDownList ID="DropDownListPaiXuFangShi" runat="server" BackColor="Transparent"

ForeColor="Blue" Width="80px">

</asp:DropDownList></td>

<td>

</td>

</tr>

</table>

</td>

<table>

<tr>

<asp:Button ID="ButtonTiJianChaXun" runat="server" Height="50px" OnClick="ButtonTiJianChaXun_Click"

Text="条件查询" /></td>

</tr>

</table>

</td>

</tr>

</table>

<table>

<tr>

<td>

<asp:Button ID="ButtonChaKan" runat="server" Font-Size="12pt" OnClick="ButtonTianJia_Click"

Text="查看" />

</td>

</tr>

</table>

<asp:GridView ID="GridViewXinXiLan" runat="server" AllowPaging="True" AutoGenerateColumns="False"

CellPadding="4" DataKeyNames="SN" ForeColor="#333333" GridLines="None" OnPageIndexChanging="GridViewXinXiLan_PageIndexChanging">

<asp:TemplateField HeaderText="选择" ShowHeader="False">

<asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" CommandName="Select"

Text="选择"></asp:LinkButton>

</ItemTemplate>

</asp:TemplateField>

<asp:BoundField DataField="建立日期" HeaderText="建立日期">

</asp:BoundField>

<asp:BoundField DataField="员工编号" HeaderText="员工编号">

</asp:BoundField>

<asp:BoundField DataField="姓名" HeaderText="姓名" NullDisplayText=" ">

</asp:BoundField>

<asp:BoundField DataField="性别" HeaderText="性别">

</asp:BoundField>

<asp:BoundField DataField="民族" HeaderText="民族" NullDisplayText=" ">

</asp:BoundField>

<asp:BoundField DataField="籍贯" HeaderText="籍贯" NullDisplayText=" ">

</asp:BoundField>

<asp:BoundField DataField="出生日期" HeaderText="出生日期">

</asp:BoundField>

<asp:BoundField DataField="政治面貌" HeaderText="政治面貌">

</asp:BoundField>

<asp:BoundField DataField="婚姻状况" HeaderText="婚姻状况" />

<asp:BoundField DataField="学历" HeaderText="学历" />

<asp:BoundField DataField="户口" HeaderText="户口" />

<asp:BoundField DataField="身份证号" HeaderText="身份证号" />

<asp:BoundField DataField="职称" HeaderText="职称" />

<asp:BoundField DataField="所属部门" HeaderText="所属部门" />

<asp:BoundField DataField="岗位" HeaderText="岗位" />

<asp:BoundField DataField="入厂时间" HeaderText="入厂时间" />

<asp:BoundField DataField="转正时间" HeaderText="转正时间" />

<asp:BoundField DataField="合同到期" HeaderText="合同到期" />

<asp:BoundField DataField="用工形式" HeaderText="用工形式" />

<asp:BoundField DataField="档案资料" HeaderText="档案资料" />

<asp:BoundField DataField="工作状态" HeaderText="工作状态" />

<asp:BoundField DataField="是否涉密" HeaderText="是否涉密" />

<asp:BoundField DataField="薪金" HeaderText="薪金" />

<asp:BoundField DataField="电话" HeaderText="电话" />

<asp:BoundField DataField="手机" HeaderText="手机" />

<asp:BoundField DataField="电子邮件" HeaderText="电子邮件" />

<asp:BoundField DataField="QQ号" HeaderText="QQ号" />

<asp:BoundField DataField="经办人" HeaderText="经办人" />

<asp:BoundField DataField="SN" HeaderText="SN" Visible="False" />

</Columns>

</asp:GridView>

<table>

<tr>

<td>

 <asp:LinkButton ID="lnkbtnFirst" runat="server" OnClick="PagerButtonClick">首页</asp:LinkButton>

<asp:LinkButton ID="lnkbtnPre" runat="server" OnClick="PagerButtonClick">上一页</asp:LinkButton>

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

<asp:LinkButton ID="lnkbtnLast" runat="server" OnClick="PagerButtonClick">尾页</asp:LinkButton>

<asp:Label ID="lblCurrentIndex" runat="server" Text="第?页"></asp:Label>

<asp:Label ID="lblPageCount" runat="server" Text="共?页"></asp:Label>

<asp:Label ID="lblRecordCount" runat="server" Text="记录数"></asp:Label>

<asp:TextBox ID="txtJumpPage" runat="server" Width="24px">1</asp:TextBox>

<asp:LinkButton ID="lnkbtnJumpPage" runat="server" OnClick="lnkbtnJumpPage_Click">跳转</asp:LinkButton></td>

</tr>

</table>

</asp:View>

<asp:View ID="ViewXiangXiXinXi" runat="server">

<asp:GridView ID="GridViewTianJia" runat="server" AutoGenerateColumns="False" CellPadding="4"

ForeColor="#333333" OnRowDataBound="GridViewTianJia_RowDataBound" OnRowCancelingEdit="GridViewTianJia_RowCancelingEdit" OnRowDeleting="GridViewTianJia_RowDeleting" OnRowEditing="GridViewTianJia_RowEditing" DataKeyNames="SN" OnRowUpdating="GridViewTianJia_RowUpdating">

<asp:BoundField DataField="ID" HeaderText="ID" Visible="False" >

</asp:BoundField>

<asp:BoundField DataField="建立日期" HeaderText="建立日期" ReadOnly="True">

</asp:BoundField>

<asp:TemplateField HeaderText="姓名">

<asp:TextBox ID="TextBoxXinMing" runat="server" Text='<%# Bind("姓名") %>' Width="60"></asp:TextBox>

</EditItemTemplate>

<asp:Label ID="Label2" runat="server" Text='<%# Bind("姓名") %>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="类型">

<asp:HiddenField ID="HDLeiXing" runat="server" Value='<%# Eval("类型") %>' />

<asp:DropDownList ID="DropDownListLeiXing" runat="server" Width="60">

</asp:DropDownList>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="名称">

<asp:TextBox ID="TextBoxMingCheng" runat="server" Text='<%# Bind("名称") %>' Width="60"></asp:TextBox>

</EditItemTemplate>

<asp:Label ID="Label3" runat="server" Text='<%# Bind("名称") %>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="开始时间">

<asp:TextBox ID="TextBoxKaiShiShiJian" runat="server" Text='<%# Bind("开始时间") %>' Width="70" CausesValidation="True" ValidationGroup="vgpKaiShiShiJian"></asp:TextBox>

<asp:RequiredFieldValidator ID="reqFromDate" runat="server" ControlToValidate="TextBoxKaiShiShiJian" ErrorMessage="请输入开始时间" ValidationGroup="vgpKaiShiShiJian" Display="Dynamic" />

<asp:CustomValidator ID="CVKaiShiShiJian" runat="server" ErrorMessage="日期格式错误()" ControlToValidate="TextBoxKaiShiShiJian" Display="Dynamic" OnServerValidate="CVKaiShiShiJian_ServerValidate"></asp:CustomValidator>

</EditItemTemplate>

<asp:Label ID="Label4" runat="server" Text='<%# Bind("开始时间") %>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="结束时间">

<asp:TextBox ID="TextBoxJieShuShiJian" runat="server" Text='<%# Bind("结束时间") %>' Width="70"></asp:TextBox>

</EditItemTemplate>

<asp:Label ID="Label5" runat="server" Text='<%# Bind("结束时间") %>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="取得证书">

<asp:TextBox ID="TextBoxZhengShu" runat="server" Text='<%# Bind("取得证书") %>' Width="60"></asp:TextBox>

</EditItemTemplate>

<asp:Label ID="Label6" runat="server" Text='<%# Bind("取得证书") %>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="备注">

<asp:TextBox ID="TextBoxBeiZhu" runat="server" Text='<%# Bind("备注") %>' Width="60"></asp:TextBox>

</EditItemTemplate>

<asp:Label ID="Label7" runat="server" Text='<%# Bind("备注") %>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:BoundField DataField="经办人" HeaderText="经办人" ReadOnly="True" >

</asp:BoundField>

<asp:BoundField DataField="SN" HeaderText="SN" Visible="False" />

<asp:TemplateField HeaderText="编辑" ShowHeader="False">

<asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="True" CommandName="Update"

Text="更新"></asp:LinkButton>

<asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False" CommandName="Cancel"

Text="取消"></asp:LinkButton>

</EditItemTemplate>

<asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" CommandName="Edit"

Text="编辑"></asp:LinkButton> 

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="操作" ShowHeader="False">

<asp:LinkButton ID="LinkButton3" runat="server" CausesValidation="False" CommandName="Delete"

Text="删除"></asp:LinkButton>

<asp:LinkButton ID="LinkButtonTianJia" runat="server" Visible="False" OnClick="LinkButtonTianJia_Click">添加保存</asp:LinkButton>

<asp:LinkButton ID="LinkButtonQuXiao" runat="server" OnClick="LinkButtonQuXiao_Click"

Visible="False">取消</asp:LinkButton>

</ItemTemplate>

</asp:TemplateField>

</Columns>

建立日期姓名类型名称开始时间结束时间取得证书备注经办人

</EmptyDataTemplate>

</asp:GridView>

<asp:Button ID="ButtonXinZen" runat="server" Text="新增" OnClick="ButtonXinZen_Click" />

<asp:Button ID="ButtonBaoCun" runat="server" OnClick="ButtonBaoCun_Click" Text="保存" Visible="False" Enabled="False" />

<asp:Button ID="ButtonQuXiao" runat="server" OnClick="ButtonQuXiao_Click" Text="取消" Visible="False" Enabled="False" />

<asp:Label ID="LabelZhuJian" runat="server" Text="隐藏主键" Visible="False"></asp:Label></asp:View>

</asp:MultiView>

</div>

</form>

</body>

</html>

cs代码：

/*----------------------------------------------------------------

// 作者：马如林

// 时间：2007/06/08

// 文件名：

// 文件功能描述：

// 培训进修信息页面

// 修改标识：

// 修改描述：

//----------------------------------------------------------------*/

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.Globalization;

using System.Data.OracleClient;

using System.IO;

using System.Text;

using System.Text.RegularExpressions;

using Hhxx.App_Code.DatabaseOperate;

using Hhxx.App_Code.Database;

using Hhxx.App_Code.Common;

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

{

//SELECT 建立日期,员工编号,姓名,性别,民族,籍贯,出生日期,政治面貌,婚姻状况,学历,户口,身份证号,职称,所属部门,岗位,入厂时间,转正时间,合同到期,用工形式,档案资料,工作状态,是否涉密,薪金,电话,手机,电子邮件,QQ号,简介,备注,经办人,SN

private String querySql = "SELECT 建立日期,员工编号,姓名,性别,民族,籍贯,出生日期,政治面貌,婚姻状况,学历,户口,身份证号,职称,所属部门,岗位,入厂时间,转正时间,合同到期,用工形式,档案资料,工作状态,是否涉密,薪金,电话,手机,电子邮件,QQ号,经办人,SN FROM renshixinxi ";

protected void Page_Load(object sender, EventArgs e)

{

this.MenuCaidan.Items[0].Enabled = true;

this.MenuCaidan.Items[1].Enabled = false;

if (!Page.IsPostBack)

{

dropDownListInit();

// 初始化默认Gridview的SQL语句

fillGridView(querySql);

}

// gridview 换行控制

this.GridViewXinXiLan.Attributes.Add("style", "word-break:keep-all;word-wrap:normal");

}

/// <summary>

/// 点击菜单

/// </summary>

/// <param name="sender"></param>

/// <param name="e"></param>

protected void MenuCaidan_MenuItemClick(object sender, MenuEventArgs e)

{

switch (MenuCaidan.SelectedItem.Text.Trim())

{

case "人事栏":

{

MultiViewXinXiGuanLi.ActiveViewIndex = 0;

fillGridView(querySql);

break;

}

case "培训进修": MultiViewXinXiGuanLi.ActiveViewIndex = 1;

break;

default: break;

}

/// <summary>

/// 条件查询

/// </summary>

/// <param name="sender"></param>

/// <param name="e"></param>

protected void ButtonTiJianChaXun_Click(object sender, EventArgs e)

{

String strCondition = "";

String strChoose = "";

if (TextBoxOne.Text.Trim().Length != 0)

{

String tempStr = DropDownListTiaoJianOne.SelectedItem.Value;

switch (tempStr)

{

case "包含": strChoose = " LIKE ";

break;

case "不包含": strChoose = " NOT LIKE ";

break;

}

if (strCondition.Length == 0)

{

strCondition = strCondition + DropDownListLeiBeiOne.SelectedItem.Value + strChoose + "'%" + TextBoxOne.Text.Trim() + "%'";

}

else

{

strCondition = strCondition + "AND " + DropDownListLeiBeiOne.SelectedItem.Value + strChoose + "'%" + TextBoxOne.Text.Trim() + "%'";

}

if (TextBoxTwo.Text.Trim().Length != 0)

{

String tempStr = DropDownListTiaoJianTwo.SelectedItem.Value;

switch (tempStr)

{

case "包含": strChoose = " LIKE ";

break;

case "不包含": strChoose = " NOT LIKE ";

break;

}

if (strCondition.Length == 0)

{

strCondition = strCondition + DropDownListLeiBeiTwo.SelectedItem.Value + strChoose + "'%" + TextBoxTwo.Text.Trim() + "%'";

}

else

{

strCondition = strCondition + "AND " + DropDownListLeiBeiTwo.SelectedItem.Value + strChoose + "'%" + TextBoxTwo.Text.Trim() + "%'";

}

if (TextBoxThree.Text.Trim().Length != 0)

{

String tempStr = DropDownListTiaoJianThree.SelectedItem.Value;

switch (tempStr)

{

case "等于": strChoose = "=";

break;

case "大于": strChoose = ">";

break;

case "小于": strChoose = "<";

break;

}

if (strCondition.Length == 0)

{

strCondition = strCondition + DropDownListLeiBeiThree.SelectedItem.Value + strChoose + TextBoxThree.Text.Trim();

}

else

{

strCondition = strCondition + "AND " + DropDownListLeiBeiThree.SelectedItem.Value + strChoose + TextBoxThree.Text.Trim();

}

if (TextBoxFour.Text.Trim().Length != 0)

{

String tempStr = DropDownListTiaoJianFour.SelectedItem.Value;

switch (tempStr)

{

case "等于": strChoose = "=";

break;

case "大于": strChoose = ">";

break;

case "小于": strChoose = "<";

break;

}

if (strCondition.Length == 0)

{

strCondition = strCondition + DropDownListLeiBeiFour.SelectedItem.Value + strChoose + TextBoxFour.Text.Trim();

}

else

{

strCondition = strCondition + "AND " + DropDownListLeiBeiFour.SelectedItem.Value + strChoose + TextBoxFour.Text.Trim();

}

if (strCondition.Length != 0)

{

strCondition = " where " + strCondition;

}

strCondition = strCondition + " ORDER BY " + DropDownListPaiXuFangShi.SelectedItem.Value.Trim();

String strSql = querySql + strCondition;

String mQuerySql = strSql;

// 填充表格

fillGridView(mQuerySql);

// 保存SQL语句

ViewState["sql"] = mQuerySql;

}

/// <summary>

/// 初始化DropDownList

/// </summary>

private void dropDownListInit()

{

GetTableInformation getTableInformation = new GetTableInformation();

// 获取表结构信息

Hashtable tableInfor = getTableInformation.getTableInfor("renshixinxi");

// 移除SN

tableInfor.Remove("SN");

foreach (DictionaryEntry de in tableInfor)

{

String key = de.Key.ToString();

String value = de.Value.ToString();

switch (value)

{

case "CHAR":

DropDownListLeiBeiOne.Items.Add(key);

DropDownListLeiBeiTwo.Items.Add(key);

// 排序方式下拉框添加数据字段

DropDownListPaiXuFangShi.Items.Add(key);

break;

case "VARCHAR2":

DropDownListLeiBeiOne.Items.Add(key);

DropDownListLeiBeiTwo.Items.Add(key);

// 排序方式下拉框添加数据字段

DropDownListPaiXuFangShi.Items.Add(key);

break;

case "NUMBER":

DropDownListLeiBeiThree.Items.Add(key);

DropDownListLeiBeiFour.Items.Add(key);

// 排序方式下拉框添加数据字段

DropDownListPaiXuFangShi.Items.Add(key);

break;

}

DropDownListTiaoJianOne.Items.Add("包含");

DropDownListTiaoJianOne.Items.Add("不包含");

DropDownListTiaoJianTwo.Items.Add("包含");

DropDownListTiaoJianTwo.Items.Add("不包含");

DropDownListTiaoJianThree.Items.Add("等于");

DropDownListTiaoJianThree.Items.Add("小于");

DropDownListTiaoJianThree.Items.Add("大于");

DropDownListTiaoJianFour.Items.Add("等于");

DropDownListTiaoJianFour.Items.Add("小于");

DropDownListTiaoJianFour.Items.Add("大于");

if (DropDownListLeiBeiOne.Items.Count == 0)

{

this.DropDownListLeiBeiOne.Visible = false;

this.DropDownListTiaoJianOne.Visible = false;

this.TextBoxOne.Visible = false;

}

if (DropDownListLeiBeiTwo.Items.Count == 0)

{

this.DropDownListLeiBeiTwo.Visible = false;

this.DropDownListTiaoJianTwo.Visible = false;

this.TextBoxTwo.Visible = false;

}

if (DropDownListLeiBeiThree.Items.Count == 0)

{

this.DropDownListLeiBeiThree.Visible = false;

this.DropDownListTiaoJianThree.Visible = false;

this.TextBoxThree.Visible = false;

}

if (DropDownListLeiBeiFour.Items.Count == 0)

{

this.DropDownListLeiBeiFour.Visible = false;

this.DropDownListTiaoJianFour.Visible = false;

this.TextBoxFour.Visible = false;

}

/// <summary>

/// 填充GridView

/// </summary>

private void fillGridView(String querySql)

{

DataSet ds = new DataSet();

ds = GetData(querySql);

// 清空以前的数据源

GridViewXinXiLan.DataSource = null;

// 将ds作为信息栏GridView的数据源

GridViewXinXiLan.DataSource = ds;

// 绑定数据

GridViewXinXiLan.DataBind();

// 分页的相关参数设置

getRefSet(ds);

// 保存数据源防止丢失 VS的破Bug

ViewState["GridViewXinXiLan_DataSource"] = GridViewXinXiLan.DataSource;

// 保存SQL语句

ViewState["sql"] = querySql;

}

/// <summary>

/// 填充GridView

/// </summary>

private void fillGridViewTianJia(String querySql)

{

DataSet ds = new DataSet();

ds = GetData(querySql);

// 清空以前的数据源

GridViewTianJia.DataSource = null;

// 将ds作为信息栏GridView的数据源

GridViewTianJia.DataSource = ds;

// 绑定数据

GridViewTianJia.DataBind();

// 分页的相关参数设置

getRefSet(ds);

// 保存数据源防止丢失 VS的破Bug

ViewState["GridViewTianJia_DataSource"] = this.GridViewTianJia.DataSource;

// 保存SQL语句

ViewState["sql"] = querySql;

// gridview 换行控制

this.GridViewTianJia.Attributes.Add("style", "word-break:keep-all;word-wrap:normal");

}

/// <summary>

/// 转换SQL查询结果为DataSet

/// </summary>

/// <returns>ds</returns>

private DataSet GetData(String querySql)

{

String connStr = OracleHelper.DatabaseConnStr;

// 创建数据集

DataSet ds = OracleHelper.ExeSqlForDataSet(connStr, CommandType.Text, querySql, null);

return ds;

}

/// <summary>

/// 首页，上一页，下一页，尾页公用的点击程序

/// </summary>

/// <param name="sender"></param>

/// <param name="e"></param>

protected void PagerButtonClick(object sender, EventArgs e)

{

// CommandArgument对应该对象在页面初始化后的设定值

// 减1 是因为系统默认首页的PageIndex为0，为了符合人们的正常思维而使用

// 重新绑定

GridViewXinXiLan.DataSource = ViewState["GridViewXinXiLan_DataSource"];

GridViewXinXiLan.PageIndex = Convert.ToInt32(((LinkButton)sender).CommandArgument) - 1;

GridViewXinXiLan.DataBind();

// 更新当前页面显示值

lblCurrentIndex.Text = "第 " + (GridViewXinXiLan.PageIndex + 1).ToString() + " 页";

// 更新参数

lnkbtnPre.CommandArgument = (GridViewXinXiLan.PageIndex == 0 ? "1" : GridViewXinXiLan.PageIndex.ToString());

lnkbtnNext.CommandArgument = (GridViewXinXiLan.PageCount == 1 ? GridViewXinXiLan.PageCount.ToString() : (GridViewXinXiLan.PageIndex + 2).ToString());

}

/// <summary>

/// 分页的相关参数设置

/// </summary>

/// <param name="ds"></param>

protected void getRefSet(DataSet ds)

{

lblCurrentIndex.Text = "第 " + (GridViewXinXiLan.PageIndex + 1).ToString() + " 页";

lblPageCount.Text = "共 " + GridViewXinXiLan.PageCount.ToString() + " 页";

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

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

{

lnkbtnFirst.Visible = false;

lnkbtnPre.Visible = false;

lnkbtnNext.Visible = false;

lnkbtnLast.Visible = false;

lblCurrentIndex.Visible = false;

lblPageCount.Visible = false;

lblRecordCount.Visible = false;

this.lnkbtnJumpPage.Visible = false;

this.txtJumpPage.Visible = false;

}

else if (GridViewXinXiLan.PageCount == 1)

{

lnkbtnFirst.Visible = false;

lnkbtnPre.Visible = false;

lnkbtnNext.Visible = false;

lnkbtnLast.Visible = false;

}

// 设置LinkButton此时对应的参数

lnkbtnFirst.CommandArgument = "1";

lnkbtnPre.CommandArgument = (GridViewXinXiLan.PageIndex == 0 ? "1" : GridViewXinXiLan.PageIndex.ToString());

lnkbtnNext.CommandArgument = (GridViewXinXiLan.PageCount == 1 ? GridViewXinXiLan.PageCount.ToString() : (GridViewXinXiLan.PageIndex + 2).ToString());

lnkbtnLast.CommandArgument = GridViewXinXiLan.PageCount.ToString();

}

/// <summary>

/// 跳转到指定页面，页面参数由txtJumpPage获取

/// </summary>

/// <param name="sender"></param>

/// <param name="e"></param>

protected void lnkbtnJumpPage_Click(object sender, EventArgs e)

{

// 减1 是因为系统默认首页的PageIndex为0，为了符合人们的正常思维而使用

// 重新绑定

GridViewXinXiLan.DataSource = ViewState["GridViewXinXiLan_DataSource"];

GridViewXinXiLan.PageIndex = int.Parse(txtJumpPage.Text) - 1;

GridViewXinXiLan.DataBind();

// 更新当前页面显示值

lblCurrentIndex.Text = "第 " + (GridViewXinXiLan.PageIndex + 1).ToString() + " 页";

// 更新参数

lnkbtnPre.CommandArgument = (GridViewXinXiLan.PageIndex == 0 ? "1" : GridViewXinXiLan.PageIndex.ToString());

lnkbtnNext.CommandArgument = (GridViewXinXiLan.PageCount == 1 ? GridViewXinXiLan.PageCount.ToString() : (GridViewXinXiLan.PageIndex + 2).ToString());

}

/// <summary>

/// 解决数据源不能分页的问题

/// </summary>

/// <param name="sender"></param>

/// <param name="e"></param>

protected void GridViewXinXiLan_PageIndexChanging(object sender, GridViewPageEventArgs e)

{

// 读取数据源设定显示值并绑定

GridViewXinXiLan.DataSource = ViewState["GridViewXinXiLan_DataSource"];

GridViewXinXiLan.PageIndex = e.NewPageIndex;

GridViewXinXiLan.DataBind();

}

/// <summary>

/// 查看按钮

/// </summary>

/// <param name="sender"></param>

/// <param name="e"></param>

protected void ButtonTianJia_Click(object sender, EventArgs e)

{

if (this.GridViewXinXiLan.SelectedRow != null)

{

this.MenuCaidan.Items[1].Enabled = true;

MenuCaidan.Items[1].Selected = true;

MultiViewXinXiGuanLi.ActiveViewIndex = 1;

this.LabelZhuJian.Text = this.GridViewXinXiLan.DataKeys[this.GridViewXinXiLan.SelectedRow.RowIndex][0].ToString(); ;

// 初始化默认Gridview的SQL语句

String querySql = "SELECT ID,建立日期,姓名,类型,名称,开始时间,结束时间,取得证书,备注,经办人,SN FROM peixunjinxiu WHERE ID='" + this.LabelZhuJian.Text.Trim() + "'";

fillGridViewTianJia(querySql);

ButtonChaKan.Visible = true;

ButtonChaKan.Enabled = true;

}

else

{

// 错误信息提示

String tip = "请选择行!";

Response.Write("<script>alert('" + tip + "')</script>");

}

/// <summary>

/// 新增

/// </summary>

/// <param name="sender"></param>

/// <param name="e"></param>

protected void ButtonXinZen_Click(object sender, EventArgs e)

{

//ButtonBaoCun.Visible = true;

//ButtonBaoCun.Enabled = true;

//ButtonQuXiao.Visible = true;

//ButtonQuXiao.Enabled = true;

DataSet ds = new DataSet();

// 初始化默认Gridview的SQL语句

String querySql = "SELECT ID,建立日期,姓名,类型,名称,开始时间,结束时间,取得证书,备注,经办人,SN FROM peixunjinxiu WHERE ID='" + this.LabelZhuJian.Text.Trim() + "'";

ds = GetData(querySql);

// 清空以前的数据源

GridViewTianJia.DataSource = null;

String jlrq = DateTime.Now.ToString("yyyy-MM-dd", DateTimeFormatInfo.InvariantInfo);

String sn = System.Guid.NewGuid().ToString().Replace("-", "");

String userName = "session";

ds.Tables[0].Rows.Add(this.LabelZhuJian.Text, jlrq, "姓名", "培训类型", "名称", jlrq, jlrq, "取得证书", "无", userName, sn);

// 将ds作为信息栏GridView的数据源

GridViewTianJia.DataSource = ds;

// 绑定数据

GridViewTianJia.DataBind();

// gridview 换行控制

this.GridViewTianJia.Attributes.Add("style", "word-break:keep-all;word-wrap:normal");

// 编辑的更新

GridViewTianJia.EditIndex = GridViewTianJia.Rows.Count - 1;

// 设置编辑行的颜色

GridViewTianJia.EditRowStyle.BackColor = System.Drawing.Color.Orange;

// 绑定数据

GridViewTianJia.DataBind();

GridViewTianJia.Rows[GridViewTianJia.Rows.Count - 1].FindControl("LinkButton1").Visible = false;

// 编辑的取消

GridViewTianJia.Rows[GridViewTianJia.Rows.Count - 1].FindControl("LinkButton2").Visible = false;

GridViewTianJia.Rows[GridViewTianJia.Rows.Count - 1].FindControl("LinkButtonTianJia").Visible = true;

GridViewTianJia.Rows[GridViewTianJia.Rows.Count - 1].FindControl("LinkButton3").Visible = false;

GridViewTianJia.Rows[GridViewTianJia.Rows.Count - 1].FindControl("LinkButtonQuXiao").Visible = true;

}

/// <summary>

/// 数据绑定

/// </summary>

/// <param name="sender"></param>

/// <param name="e"></param>

protected void GridViewTianJia_RowDataBound(object sender, GridViewRowEventArgs e)

{

//为DropDownList绑定值

if (((DropDownList)e.Row.FindControl("DropDownListLeiXing")) != null)

{

DropDownList ddlXL = (DropDownList)e.Row.FindControl("DropDownListLeiXing");

// 奖惩类型

String conn = OracleHelper.DatabaseConnStr;

ddlXL.Items.Clear();

String queryLeiXing = "SELECT 名称 FROM XITONGZIDIAN WHERE ID='03010301' ORDER BY 序号";

OracleDataReader drLeiXing = OracleHelper.ExecuteReader(conn, CommandType.Text, queryLeiXing, null);

while (drLeiXing.Read())

{

ddlXL.Items.Add(drLeiXing.GetString(0).Trim());

}

drLeiXing.Close();

//ddlXL.SelectedValue = ((HiddenField)e.Row.FindControl("HDLeiXing")).Value.ToString().Trim();

ddlXL.Items.Remove(((HiddenField)e.Row.FindControl("HDLeiXing")).Value.ToString().Trim());

ddlXL.Items.Insert(0, ((HiddenField)e.Row.FindControl("HDLeiXing")).Value.ToString().Trim());

}

//如果是绑定数据行

if (e.Row.RowType == DataControlRowType.DataRow)

{

if (e.Row.RowState == DataControlRowState.Normal || e.Row.RowState == DataControlRowState.Alternate)

{

//((LinkButton)e.Row.Cells[12].Controls[0]).Attributes.Add("onclick", "javascript:return confirm('你确认要删除："" + e.Row.Cells[1].Text.Trim() + ""吗?')");

((LinkButton)e.Row.FindControl("LinkButton3")).Attributes.Add("onclick", "javascript:return confirm('你确认要删除："" + e.Row.Cells[1].Text.Trim() + ""吗?')");

}

/// <summary>

/// 删除

/// </summary>

/// <param name="sender"></param>

/// <param name="e"></param>

protected void GridViewTianJia_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

String sn = GridViewTianJia.DataKeys[e.RowIndex].Values[0].ToString().Trim();

String delSql = "DELETE FROM peixunjinxiu WHERE SN = '" + sn + "'";

OracleConnection conn = new OracleConnection(OracleHelper.DatabaseConnStr);

conn.Open();

OracleTransaction trans = conn.BeginTransaction(IsolationLevel.ReadCommitted);

try

{

OracleHelper.ExecuteNonQuery(trans, CommandType.Text, delSql, null);

trans.Commit();

}

catch (Exception ex)

{

trans.Rollback();

ex.ToString();

}

finally

{

conn.Close();

}

GridViewTianJia.EditIndex = -1;

// 初始化默认Gridview的SQL语句

String querySql = "SELECT ID,建立日期,姓名,类型,名称,开始时间,结束时间,取得证书,备注,经办人,SN FROM peixunjinxiu WHERE ID='" + this.LabelZhuJian.Text.Trim() + "'";

fillGridViewTianJia(querySql);

}

/// <summary>

/// 取消

/// </summary>

/// <param name="sender"></param>

/// <param name="e"></param>

protected void GridViewTianJia_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

{

GridViewTianJia.EditIndex = -1;

// 初始化默认Gridview的SQL语句

String querySql = "SELECT ID,建立日期,姓名,类型,名称,开始时间,结束时间,取得证书,备注,经办人,SN FROM peixunjinxiu WHERE ID='" + this.LabelZhuJian.Text.Trim() + "'";

fillGridViewTianJia(querySql);

}

/// <summary>

/// 编辑

/// </summary>

/// <param name="sender"></param>

/// <param name="e"></param>

protected void GridViewTianJia_RowEditing(object sender, GridViewEditEventArgs e)

{

GridViewTianJia.EditIndex = e.NewEditIndex;

// 初始化默认Gridview的SQL语句

String querySql = "SELECT ID,建立日期,姓名,类型,名称,开始时间,结束时间,取得证书,备注,经办人,SN FROM peixunjinxiu WHERE ID='" + this.LabelZhuJian.Text.Trim() + "'";

fillGridViewTianJia(querySql);

}

/// <summary>

/// 更新

/// </summary>

/// <param name="sender"></param>

/// <param name="e"></param>

protected void GridViewTianJia_RowUpdating(object sender, GridViewUpdateEventArgs e)

{

// 建立日期,姓名,类型,名称,开始时间,结束时间,取得证书,备注,经办人,SN

String sqlUpdate = "UPDATE peixunjinxiu SET 姓名=:xm,类型=:lx,名称=:mc,开始时间=:kssj,结束时间=:jssj,取得证书=:qdzs,备注=:bz"

+ " WHERE SN=:sn";

OracleParameter[] parms = {

new OracleParameter(":xm", OracleType.Char, 20),

new OracleParameter(":lx", OracleType.Char, 10),

new OracleParameter(":mc", OracleType.VarChar, 255),

new OracleParameter(":kssj", OracleType.Char, 10),

new OracleParameter(":jssj", OracleType.Char, 10),

new OracleParameter(":qdzs", OracleType.VarChar, 255),

new OracleParameter(":bz", OracleType.VarChar,1024),

new OracleParameter(":sn", OracleType.Char, 32)

};

parms[0].Value = ((TextBox)GridViewTianJia.Rows[e.RowIndex].FindControl("TextBoxXinMing")).Text.Trim();

parms[1].Value = ((DropDownList)GridViewTianJia.Rows[e.RowIndex].FindControl("DropDownListLeiXing")).SelectedValue.ToString().Trim();

parms[2].Value = ((TextBox)GridViewTianJia.Rows[e.RowIndex].FindControl("TextBoxMingCheng")).Text.Trim();

parms[3].Value = ((TextBox)GridViewTianJia.Rows[e.RowIndex].FindControl("TextBoxKaiShiShiJian")).Text.Trim();

parms[4].Value = ((TextBox)GridViewTianJia.Rows[e.RowIndex].FindControl("TextBoxJieShuShiJian")).Text.Trim();

parms[5].Value = ((TextBox)GridViewTianJia.Rows[e.RowIndex].FindControl("TextBoxZhengShu")).Text.Trim();

parms[6].Value = ((TextBox)GridViewTianJia.Rows[e.RowIndex].FindControl("TextBoxBeiZhu")).Text.Trim();

parms[7].Value = GridViewTianJia.DataKeys[e.RowIndex].Values[0].ToString().Trim();

OracleConnection conn = new OracleConnection(OracleHelper.DatabaseConnStr);

conn.Open();

OracleTransaction trans = conn.BeginTransaction(IsolationLevel.ReadCommitted);

try

{

OracleHelper.ExecuteNonQuery(trans, CommandType.Text, sqlUpdate, parms);

trans.Commit();

}

catch (Exception ex)

{

trans.Rollback();

ex.ToString();

}

finally

{

conn.Close();

}

GridViewTianJia.EditIndex = -1;

// 初始化默认Gridview的SQL语句

String querySql = "SELECT ID,建立日期,姓名,类型,名称,开始时间,结束时间,取得证书,备注,经办人,SN FROM peixunjinxiu WHERE ID='" + this.LabelZhuJian.Text.Trim() + "'";

fillGridViewTianJia(querySql);

}

/// <summary>

/// 保存

/// </summary>

/// <param name="sender"></param>

/// <param name="e"></param>

protected void ButtonBaoCun_Click(object sender, EventArgs e)

{

// 建立日期,姓名,类型,培训名称,进修名称,开始时间,结束时间,取得证书,备注,经办人,SN

String sqlInsert = "INSERT INTO peixunjinxiu(ID,建立日期,姓名,类型,名称,开始时间,结束时间,取得证书,备注,经办人,SN) "

+ "VALUES(:id,:jlrq,:xm,:lx,:mc,:kssj,:jssj,:qdzs,:bz,:jbr,:sn)";

OracleParameter[] parms = {

new OracleParameter(":id", OracleType.Char, 32),

new OracleParameter(":jlrq", OracleType.Char, 10),

new OracleParameter(":xm", OracleType.Char, 20),

new OracleParameter(":lx", OracleType.Char, 10),

new OracleParameter(":mc", OracleType.VarChar, 255),

new OracleParameter(":kssj", OracleType.Char, 10),

new OracleParameter(":jssj", OracleType.Char, 10),

new OracleParameter(":qdzs", OracleType.VarChar, 255),

new OracleParameter(":bz", OracleType.VarChar,1024),

new OracleParameter(":jbr", OracleType.Char, 20),

new OracleParameter(":sn", OracleType.Char, 32)

};

parms[0].Value = this.LabelZhuJian.Text.Trim();

parms[1].Value = this.GridViewTianJia.Rows[GridViewTianJia.Rows.Count - 1].Cells[1].Text.ToString().Trim();

parms[2].Value = ((TextBox)GridViewTianJia.Rows[GridViewTianJia.Rows.Count - 1].FindControl("TextBoxXinMing")).Text.Trim();

parms[3].Value = ((DropDownList)GridViewTianJia.Rows[GridViewTianJia.Rows.Count - 1].FindControl("DropDownListLeiXing")).SelectedValue.ToString().Trim();

parms[4].Value = ((TextBox)GridViewTianJia.Rows[GridViewTianJia.Rows.Count - 1].FindControl("TextBoxMingCheng")).Text.Trim();

parms[5].Value = ((TextBox)GridViewTianJia.Rows[GridViewTianJia.Rows.Count - 1].FindControl("TextBoxKaiShiShiJian")).Text.Trim();

parms[6].Value = ((TextBox)GridViewTianJia.Rows[GridViewTianJia.Rows.Count - 1].FindControl("TextBoxJieShuShiJian")).Text.Trim();

parms[7].Value = ((TextBox)GridViewTianJia.Rows[GridViewTianJia.Rows.Count - 1].FindControl("TextBoxZhengShu")).Text.Trim();

parms[8].Value = ((TextBox)GridViewTianJia.Rows[GridViewTianJia.Rows.Count - 1].FindControl("TextBoxBeiZhu")).Text.Trim();

parms[9].Value = this.GridViewTianJia.Rows[GridViewTianJia.Rows.Count - 1].Cells[9].Text.ToString().Trim();

parms[10].Value = GridViewTianJia.DataKeys[GridViewTianJia.Rows.Count - 1].Values[0].ToString().Trim();

OracleConnection conn = new OracleConnection(OracleHelper.DatabaseConnStr);

conn.Open();

OracleTransaction trans = conn.BeginTransaction(IsolationLevel.ReadCommitted);

try

{

OracleHelper.ExecuteNonQuery(trans, CommandType.Text, sqlInsert, parms);

trans.Commit();

}

catch (Exception ex)

{

trans.Rollback();

ex.ToString();

}

finally

{

conn.Close();

}

GridViewTianJia.EditIndex = -1;

// 初始化默认Gridview的SQL语句

String querySql = "SELECT ID,建立日期,姓名,类型,名称,开始时间,结束时间,取得证书,备注,经办人,SN FROM peixunjinxiu WHERE ID='" + this.LabelZhuJian.Text.Trim() + "'";

fillGridViewTianJia(querySql);

ButtonBaoCun.Visible = false;

ButtonBaoCun.Enabled = false;

ButtonQuXiao.Visible = false;

ButtonQuXiao.Enabled = false;

}

/// <summary>

/// 取消

/// </summary>

/// <param name="sender"></param>

/// <param name="e"></param>

protected void ButtonQuXiao_Click(object sender, EventArgs e)

{

GridViewTianJia.EditIndex = -1;

// 初始化默认Gridview的SQL语句

String querySql = "SELECT ID,建立日期,姓名,类型,名称,开始时间,结束时间,取得证书,备注,经办人,SN FROM peixunjinxiu WHERE ID='" + this.LabelZhuJian.Text.Trim() + "'";

fillGridViewTianJia(querySql);

ButtonBaoCun.Visible = false;

ButtonBaoCun.Enabled = false;

ButtonQuXiao.Visible = false;

ButtonQuXiao.Enabled = false;

}

/// <summary>

/// 取消

/// </summary>

/// <param name="sender"></param>

/// <param name="e"></param>

protected void LinkButtonQuXiao_Click(object sender, EventArgs e)

{

GridViewTianJia.EditIndex = -1;

// 初始化默认Gridview的SQL语句

String querySql = "SELECT ID,建立日期,姓名,类型,名称,开始时间,结束时间,取得证书,备注,经办人,SN FROM peixunjinxiu WHERE ID='" + this.LabelZhuJian.Text.Trim() + "'";

fillGridViewTianJia(querySql);

}

/// <summary>

/// 添加保存

/// </summary>

/// <param name="sender"></param>

/// <param name="e"></param>

protected void LinkButtonTianJia_Click(object sender, EventArgs e)

{

if (Page.IsValid)