下面的gridview使用到了常用的基本功能:
1 dropdownlist的使用
2 新增行的绑定
3 新增行的修改,添加,删除
4 基本功能的编辑,删除
5 行的颜色改变(如编辑行)
6 girdview中时间的验证功能(如开始时间)
7 不可编辑列,不可编辑单元的设置(如建立日期)
代码中有些隐藏的和多余的部分,大家知道一下。最重要的演示gridview的使用。
![](https://p-blog.csdn.net/images/p_blog_csdn_net/longronglin/gvdaquan2.JPG)
代码如下:(数据库部分大家感觉一下,不能什么都弄出来。不好意思了。一般人都可以感觉出来的了)
<%
@ 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
"
>
<
html xmlns
=
"
http://www.w3.org/1999/xhtml
"
>
<
head runat
=
"
server
"
>
<
title
>
培训进修
</
title
>
<
link href
=
"
../../css/style.css
"
rel
=
"
stylesheet
"
type
=
"
text/css
"
/>
</
head
>
<
body
>
<
form id
=
"
formPeiXunJinXiu
"
runat
=
"
server
"
>
<
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
"
>
<
StaticMenuItemStyle Font
-
Size
=
"
10pt
"
HorizontalPadding
=
"
5px
"
VerticalPadding
=
"
2px
"
/>
<
DynamicHoverStyle BackColor
=
"
#990000
"
ForeColor
=
"
White
"
/>
<
DynamicMenuStyle BackColor
=
"
#FFFBD6
"
/>
<
StaticSelectedStyle BackColor
=
"
Gold
"
/>
<
DynamicSelectedStyle BackColor
=
"
#FFCC66
"
/>
<
DynamicMenuItemStyle HorizontalPadding
=
"
5px
"
VerticalPadding
=
"
2px
"
/>
<
Items
>
<
asp:MenuItem Selected
=
"
True
"
Text
=
"
人事栏
"
Value
=
"
客户栏
"
></
asp:MenuItem
>
<
asp:MenuItem Text
=
"
培训进修
"
Value
=
"
培训进修
"
></
asp:MenuItem
>
</
Items
>
<
StaticItemTemplate
>
<%
# Eval(
"
Text
"
)
%>
</
StaticItemTemplate
>
<
StaticHoverStyle BackColor
=
"
#FFC0C0
"
Font
-
Overline
=
"
False
"
Font
-
Underline
=
"
True
"
ForeColor
=
"
White
"
/>
</
asp:Menu
>
</
td
>
</
tr
>
</
table
>
<
table style
=
"
border-top-width: 0px
"
>
<
tr valign
=
"
top
"
>
<
td style
=
"
height: 7px
"
>
<
img alt
=
"
图象
"
height
=
"
5
"
src
=
"
../../Images/funcLine.JPG
"
width
=
"
933
"
/></
td
>
</
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 style
=
"
width: 99px
"
>
选择类别名称
</
td
>
<
td
>
条件
</
td
>
<
td
>
输入要查询的条件值
</
td
>
</
tr
>
<
tr
>
<
td style
=
"
width: 99px
"
>
<
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
>
<
td style
=
"
width: 99px
"
>
<
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
>
<
td style
=
"
width: 99px
"
>
<
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
>
<
td style
=
"
width: 99px
"
>
<
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
>
<
td style
=
"
width: 99px
"
>
<
font color
=
"
blue
"
>
<
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
>
<
td style
=
"
height: 176px
"
>
<
table
>
<
tr
>
<
td style
=
"
height: 50px
"
>
<
asp:Button ID
=
"
ButtonTiJianChaXun
"
runat
=
"
server
"
Height
=
"
50px
"
OnClick
=
"
ButtonTiJianChaXun_Click
"
Text
=
"
条件查询
"
/></
td
>
</
tr
>
</
table
>
</
td
>
</
tr
>
</
table
>
<
img alt
=
"
图象
"
height
=
"
5
"
src
=
"
../../Images/funcLine.JPG
"
width
=
"
933
"
/><
br
/>
<
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
"
>
<
FooterStyle BackColor
=
"
#507CD1
"
Font
-
Bold
=
"
True
"
Font
-
Size
=
"
Small
"
ForeColor
=
"
White
"
/>
<
RowStyle BackColor
=
"
#EFF3FB
"
/>
<
EditRowStyle BackColor
=
"
#2461BF
"
/>
<
SelectedRowStyle BackColor
=
"
DodgerBlue
"
Font
-
Bold
=
"
False
"
ForeColor
=
"
#333333
"
/>
<
PagerStyle BackColor
=
"
#2461BF
"
ForeColor
=
"
White
"
HorizontalAlign
=
"
Center
"
/>
<
HeaderStyle BackColor
=
"
#507CD1
"
Font
-
Bold
=
"
True
"
Font
-
Size
=
"
10pt
"
ForeColor
=
"
White
"
/>
<
AlternatingRowStyle BackColor
=
"
White
"
/>
<
Columns
>
<
asp:TemplateField HeaderText
=
"
选择
"
ShowHeader
=
"
False
"
>
<
ItemTemplate
>
<
asp:LinkButton ID
=
"
LinkButton1
"
runat
=
"
server
"
CausesValidation
=
"
False
"
CommandName
=
"
Select
"
Text
=
"
选择
"
></
asp:LinkButton
>
</
ItemTemplate
>
<
ItemStyle Wrap
=
"
False
"
/>
</
asp:TemplateField
>
<
asp:BoundField DataField
=
"
建立日期
"
HeaderText
=
"
建立日期
"
>
<
ItemStyle Wrap
=
"
False
"
/>
<
HeaderStyle Wrap
=
"
False
"
/>
</
asp:BoundField
>
<
asp:BoundField DataField
=
"
员工编号
"
HeaderText
=
"
员工编号
"
>
<
ItemStyle Wrap
=
"
False
"
/>
<
HeaderStyle Wrap
=
"
False
"
/>
</
asp:BoundField
>
<
asp:BoundField DataField
=
"
姓名
"
HeaderText
=
"
姓名
"
NullDisplayText
=
"
"
>
<
ItemStyle Wrap
=
"
False
"
/>
<
HeaderStyle Wrap
=
"
False
"
/>
</
asp:BoundField
>
<
asp:BoundField DataField
=
"
性别
"
HeaderText
=
"
性别
"
>
<
ItemStyle Wrap
=
"
False
"
/>
<
HeaderStyle Wrap
=
"
False
"
/>
</
asp:BoundField
>
<
asp:BoundField DataField
=
"
民族
"
HeaderText
=
"
民族
"
NullDisplayText
=
"
"
>
<
ItemStyle Wrap
=
"
False
"
/>
<
HeaderStyle Wrap
=
"
False
"
/>
</
asp:BoundField
>
<
asp:BoundField DataField
=
"
籍贯
"
HeaderText
=
"
籍贯
"
NullDisplayText
=
"
"
>
<
HeaderStyle Wrap
=
"
False
"
/>
</
asp:BoundField
>
<
asp:BoundField DataField
=
"
出生日期
"
HeaderText
=
"
出生日期
"
>
<
HeaderStyle Wrap
=
"
False
"
/>
</
asp:BoundField
>
<
asp:BoundField DataField
=
"
政治面貌
"
HeaderText
=
"
政治面貌
"
>
<
HeaderStyle Wrap
=
"
False
"
/>
</
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
>
<
PagerSettings Visible
=
"
False
"
/>
</
asp:GridView
>
&
nbsp;
<
table
>
<
tr
>
<
td
>
&
nbsp;
<
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
"
>
<
FooterStyle BackColor
=
"
#507CD1
"
Font
-
Bold
=
"
True
"
ForeColor
=
"
White
"
/>
<
Columns
>
<
asp:BoundField DataField
=
"
ID
"
HeaderText
=
"
ID
"
Visible
=
"
False
"
>
<
ItemStyle Wrap
=
"
False
"
/>
</
asp:BoundField
>
<
asp:BoundField DataField
=
"
建立日期
"
HeaderText
=
"
建立日期
"
ReadOnly
=
"
True
"
>
<
ItemStyle Wrap
=
"
False
"
/>
</
asp:BoundField
>
<
asp:TemplateField HeaderText
=
"
姓名
"
>
<
EditItemTemplate
>
<
asp:TextBox ID
=
"
TextBoxXinMing
"
runat
=
"
server
"
Text
=
'
<%# Bind("姓名") %>
'
Width
=
"
60
"
></
asp:TextBox
>
</
EditItemTemplate
>
<
ItemStyle Wrap
=
"
False
"
/>
<
ItemTemplate
>
<
asp:Label ID
=
"
Label2
"
runat
=
"
server
"
Text
=
'
<%# Bind("姓名") %>
'
></
asp:Label
>
</
ItemTemplate
>
</
asp:TemplateField
>
<
asp:TemplateField HeaderText
=
"
类型
"
>
<
ItemStyle Wrap
=
"
False
"
/>
<
ItemTemplate
>
<
asp:HiddenField ID
=
"
HDLeiXing
"
runat
=
"
server
"
Value
=
'
<%# Eval("类型") %>
'
/>
<
asp:DropDownList ID
=
"
DropDownListLeiXing
"
runat
=
"
server
"
Width
=
"
60
"
>
</
asp:DropDownList
>
</
ItemTemplate
>
</
asp:TemplateField
>
<
asp:TemplateField HeaderText
=
"
名称
"
>
<
EditItemTemplate
>
<
asp:TextBox ID
=
"
TextBoxMingCheng
"
runat
=
"
server
"
Text
=
'
<%# Bind("名称") %>
'
Width
=
"
60
"
></
asp:TextBox
>
</
EditItemTemplate
>
<
ItemStyle Wrap
=
"
False
"
/>
<
ItemTemplate
>
<
asp:Label ID
=
"
Label3
"
runat
=
"
server
"
Text
=
'
<%# Bind("名称") %>
'
></
asp:Label
>
</
ItemTemplate
>
</
asp:TemplateField
>
<
asp:TemplateField HeaderText
=
"
开始时间
"
>
<
EditItemTemplate
>
<
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
>
<
ItemStyle Wrap
=
"
False
"
/>
<
ItemTemplate
>
<
asp:Label ID
=
"
Label4
"
runat
=
"
server
"
Text
=
'
<%# Bind("开始时间") %>
'
></
asp:Label
>
</
ItemTemplate
>
</
asp:TemplateField
>
<
asp:TemplateField HeaderText
=
"
结束时间
"
>
<
EditItemTemplate
>
<
asp:TextBox ID
=
"
TextBoxJieShuShiJian
"
runat
=
"
server
"
Text
=
'
<%# Bind("结束时间") %>
'
Width
=
"
70
"
></
asp:TextBox
>
</
EditItemTemplate
>
<
ItemStyle Wrap
=
"
False
"
/>
<
ItemTemplate
>
<
asp:Label ID
=
"
Label5
"
runat
=
"
server
"
Text
=
'
<%# Bind("结束时间") %>
'
></
asp:Label
>
</
ItemTemplate
>
</
asp:TemplateField
>
<
asp:TemplateField HeaderText
=
"
取得证书
"
>
<
EditItemTemplate
>
<
asp:TextBox ID
=
"
TextBoxZhengShu
"
runat
=
"
server
"
Text
=
'
<%# Bind("取得证书") %>
'
Width
=
"
60
"
></
asp:TextBox
>
</
EditItemTemplate
>
<
ItemStyle Wrap
=
"
False
"
/>
<
ItemTemplate
>
<
asp:Label ID
=
"
Label6
"
runat
=
"
server
"
Text
=
'
<%# Bind("取得证书") %>
'
></
asp:Label
>
</
ItemTemplate
>
</
asp:TemplateField
>
<
asp:TemplateField HeaderText
=
"
备注
"
>
<
EditItemTemplate
>
<
asp:TextBox ID
=
"
TextBoxBeiZhu
"
runat
=
"
server
"
Text
=
'
<%# Bind("备注") %>
'
Width
=
"
60
"
></
asp:TextBox
>
</
EditItemTemplate
>
<
ItemStyle Wrap
=
"
False
"
/>
<
ItemTemplate
>
<
asp:Label ID
=
"
Label7
"
runat
=
"
server
"
Text
=
'
<%# Bind("备注") %>
'
></
asp:Label
>
</
ItemTemplate
>
</
asp:TemplateField
>
<
asp:BoundField DataField
=
"
经办人
"
HeaderText
=
"
经办人
"
ReadOnly
=
"
True
"
>
<
ItemStyle Wrap
=
"
False
"
/>
</
asp:BoundField
>
<
asp:BoundField DataField
=
"
SN
"
HeaderText
=
"
SN
"
Visible
=
"
False
"
/>
<
asp:TemplateField HeaderText
=
"
编辑
"
ShowHeader
=
"
False
"
>
<
EditItemTemplate
>
<
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
>
<
ItemStyle Wrap
=
"
False
"
/>
<
ItemTemplate
>
<
asp:LinkButton ID
=
"
LinkButton1
"
runat
=
"
server
"
CausesValidation
=
"
False
"
CommandName
=
"
Edit
"
Text
=
"
编辑
"
></
asp:LinkButton
>&
nbsp;
</
ItemTemplate
>
</
asp:TemplateField
>
<
asp:TemplateField HeaderText
=
"
操作
"
ShowHeader
=
"
False
"
>
<
ItemStyle Wrap
=
"
False
"
/>
<
ItemTemplate
>
<
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
>
<
RowStyle BackColor
=
"
#EFF3FB
"
/>
<
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
"
/>
<
AlternatingRowStyle BackColor
=
"
White
"
/>
<
EmptyDataTemplate
>
建立日期 姓名 类型 名称 开始时间 结束时间 取得证书 备注 经办人
</
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代码:
/**/
/*----------------------------------------------------------------
// Copyright (C) 2007
// 作者:马如林
// 时间: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 ![](https://i-blog.csdnimg.cn/blog_migrate/a41954a27d6ad96fa2c2cf816e677448.gif)
...
{
//SELECT 建立日期,员工编号,姓名,性别,民族,籍贯,出生日期,政治面貌,婚姻状况,学历,户口,身份证号,职称,所属部门,岗位,入厂时间,转正时间,合同到期,用工形式,档案资料,工作状态,是否涉密,薪金,电话,手机,电子邮件,QQ号,简介,备注,经办人,SN
private String querySql = "SELECT 建立日期,员工编号,姓名,性别,民族,籍贯,出生日期,政治面貌,婚姻状况,学历,户口,身份证号,职称,所属部门,岗位,入厂时间,转正时间,合同到期,用工形式,档案资料,工作状态,是否涉密,薪金,电话,手机,电子邮件,QQ号,经办人,SN FROM renshixinxi ";
protected void Page_Load(object sender, EventArgs e) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
this.MenuCaidan.Items[0].Enabled = true;
this.MenuCaidan.Items[1].Enabled = false;
if (!Page.IsPostBack) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
dropDownListInit();
// 初始化默认Gridview的SQL语句
fillGridView(querySql);
}
// gridview 换行控制
this.GridViewXinXiLan.Attributes.Add("style", "word-break:keep-all;word-wrap:normal");
}
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
/**//// <summary>
/// 点击菜单
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void MenuCaidan_MenuItemClick(object sender, MenuEventArgs e) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
switch (MenuCaidan.SelectedItem.Text.Trim()) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
case "人事栏": ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
MultiViewXinXiGuanLi.ActiveViewIndex = 0;
fillGridView(querySql);
break;
}
case "培训进修": MultiViewXinXiGuanLi.ActiveViewIndex = 1;
break;
default: break;
}
}
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
/**//// <summary>
/// 条件查询
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ButtonTiJianChaXun_Click(object sender, EventArgs e) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
String strCondition = "";
String strChoose = "";
if (TextBoxOne.Text.Trim().Length != 0) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
String tempStr = DropDownListTiaoJianOne.SelectedItem.Value;
switch (tempStr) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
case "包含": strChoose = " LIKE ";
break;
case "不包含": strChoose = " NOT LIKE ";
break;
}
if (strCondition.Length == 0) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
strCondition = strCondition + DropDownListLeiBeiOne.SelectedItem.Value + strChoose + "'%" + TextBoxOne.Text.Trim() + "%'";
}
else ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
strCondition = strCondition + "AND " + DropDownListLeiBeiOne.SelectedItem.Value + strChoose + "'%" + TextBoxOne.Text.Trim() + "%'";
}
}
if (TextBoxTwo.Text.Trim().Length != 0) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
String tempStr = DropDownListTiaoJianTwo.SelectedItem.Value;
switch (tempStr) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
case "包含": strChoose = " LIKE ";
break;
case "不包含": strChoose = " NOT LIKE ";
break;
}
if (strCondition.Length == 0) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
strCondition = strCondition + DropDownListLeiBeiTwo.SelectedItem.Value + strChoose + "'%" + TextBoxTwo.Text.Trim() + "%'";
}
else ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
strCondition = strCondition + "AND " + DropDownListLeiBeiTwo.SelectedItem.Value + strChoose + "'%" + TextBoxTwo.Text.Trim() + "%'";
}
}
if (TextBoxThree.Text.Trim().Length != 0) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
String tempStr = DropDownListTiaoJianThree.SelectedItem.Value;
switch (tempStr) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
case "等于": strChoose = "=";
break;
case "大于": strChoose = ">";
break;
case "小于": strChoose = "<";
break;
}
if (strCondition.Length == 0) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
strCondition = strCondition + DropDownListLeiBeiThree.SelectedItem.Value + strChoose + TextBoxThree.Text.Trim();
}
else ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
strCondition = strCondition + "AND " + DropDownListLeiBeiThree.SelectedItem.Value + strChoose + TextBoxThree.Text.Trim();
}
}
if (TextBoxFour.Text.Trim().Length != 0) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
String tempStr = DropDownListTiaoJianFour.SelectedItem.Value;
switch (tempStr) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
case "等于": strChoose = "=";
break;
case "大于": strChoose = ">";
break;
case "小于": strChoose = "<";
break;
}
if (strCondition.Length == 0) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
strCondition = strCondition + DropDownListLeiBeiFour.SelectedItem.Value + strChoose + TextBoxFour.Text.Trim();
}
else ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
strCondition = strCondition + "AND " + DropDownListLeiBeiFour.SelectedItem.Value + strChoose + TextBoxFour.Text.Trim();
}
}
if (strCondition.Length != 0) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
strCondition = " where " + strCondition;
}
strCondition = strCondition + " ORDER BY " + DropDownListPaiXuFangShi.SelectedItem.Value.Trim();
String strSql = querySql + strCondition;
String mQuerySql = strSql;
// 填充表格
fillGridView(mQuerySql);
// 保存SQL语句
ViewState["sql"] = mQuerySql;
}
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
/**//// <summary>
/// 初始化DropDownList
/// </summary>
private void dropDownListInit() ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
GetTableInformation getTableInformation = new GetTableInformation();
// 获取表结构信息
Hashtable tableInfor = getTableInformation.getTableInfor("renshixinxi");
// 移除SN
tableInfor.Remove("SN");
foreach (DictionaryEntry de in tableInfor) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
String key = de.Key.ToString();
String value = de.Value.ToString();
switch (value) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
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) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
this.DropDownListLeiBeiOne.Visible = false;
this.DropDownListTiaoJianOne.Visible = false;
this.TextBoxOne.Visible = false;
}
if (DropDownListLeiBeiTwo.Items.Count == 0) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
this.DropDownListLeiBeiTwo.Visible = false;
this.DropDownListTiaoJianTwo.Visible = false;
this.TextBoxTwo.Visible = false;
}
if (DropDownListLeiBeiThree.Items.Count == 0) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
this.DropDownListLeiBeiThree.Visible = false;
this.DropDownListTiaoJianThree.Visible = false;
this.TextBoxThree.Visible = false;
}
if (DropDownListLeiBeiFour.Items.Count == 0) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
this.DropDownListLeiBeiFour.Visible = false;
this.DropDownListTiaoJianFour.Visible = false;
this.TextBoxFour.Visible = false;
}
}
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
/**//// <summary>
/// 填充GridView
/// </summary>
private void fillGridView(String querySql) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
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;
}
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
/**//// <summary>
/// 填充GridView
/// </summary>
private void fillGridViewTianJia(String querySql) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
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");
}
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
/**//// <summary>
/// 转换SQL查询结果为DataSet
/// </summary>
/// <returns>ds</returns>
private DataSet GetData(String querySql) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
String connStr = OracleHelper.DatabaseConnStr;
// 创建数据集
DataSet ds = OracleHelper.ExeSqlForDataSet(connStr, CommandType.Text, querySql, null);
return ds;
}
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
/**//// <summary>
/// 首页,上一页,下一页,尾页公用的点击程序
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void PagerButtonClick(object sender, EventArgs e) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
// 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());
}
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
/**//// <summary>
/// 分页的相关参数设置
/// </summary>
/// <param name="ds"></param>
protected void getRefSet(DataSet ds) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
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) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
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) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
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();
}
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
/**//// <summary>
/// 跳转到指定页面,页面参数由txtJumpPage获取
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void lnkbtnJumpPage_Click(object sender, EventArgs e) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
// 减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());
}
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
/**//// <summary>
/// 解决数据源不能分页的问题
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void GridViewXinXiLan_PageIndexChanging(object sender, GridViewPageEventArgs e) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
// 读取数据源 设定显示值 并绑定
GridViewXinXiLan.DataSource = ViewState["GridViewXinXiLan_DataSource"];
GridViewXinXiLan.PageIndex = e.NewPageIndex;
GridViewXinXiLan.DataBind();
}
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
/**//// <summary>
/// 查看按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ButtonTianJia_Click(object sender, EventArgs e) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
if (this.GridViewXinXiLan.SelectedRow != null) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
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 ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
// 错误信息提示
String tip = "请选择行!";
Response.Write("<script>alert('" + tip + "')</script>");
}
}
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
/**//// <summary>
/// 新增
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ButtonXinZen_Click(object sender, EventArgs e) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
//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;
}
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
/**//// <summary>
/// 数据绑定
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void GridViewTianJia_RowDataBound(object sender, GridViewRowEventArgs e) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
//为DropDownList绑定值
if (((DropDownList)e.Row.FindControl("DropDownListLeiXing")) != null) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
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()) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
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) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
if (e.Row.RowState == DataControlRowState.Normal || e.Row.RowState == DataControlRowState.Alternate) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
//((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() + ""吗?')");
}
}
}
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
/**//// <summary>
/// 删除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void GridViewTianJia_RowDeleting(object sender, GridViewDeleteEventArgs e) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
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 ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
OracleHelper.ExecuteNonQuery(trans, CommandType.Text, delSql, null);
trans.Commit();
}
catch (Exception ex) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
trans.Rollback();
ex.ToString();
}
finally ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
conn.Close();
}
GridViewTianJia.EditIndex = -1;
// 初始化默认Gridview的SQL语句
String querySql = "SELECT ID,建立日期,姓名,类型,名称,开始时间,结束时间,取得证书,备注,经办人,SN FROM peixunjinxiu WHERE ID='" + this.LabelZhuJian.Text.Trim() + "'";
fillGridViewTianJia(querySql);
}
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
/**//// <summary>
/// 取消
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void GridViewTianJia_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
GridViewTianJia.EditIndex = -1;
// 初始化默认Gridview的SQL语句
String querySql = "SELECT ID,建立日期,姓名,类型,名称,开始时间,结束时间,取得证书,备注,经办人,SN FROM peixunjinxiu WHERE ID='" + this.LabelZhuJian.Text.Trim() + "'";
fillGridViewTianJia(querySql);
}
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
/**//// <summary>
/// 编辑
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void GridViewTianJia_RowEditing(object sender, GridViewEditEventArgs e) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
GridViewTianJia.EditIndex = e.NewEditIndex;
// 初始化默认Gridview的SQL语句
String querySql = "SELECT ID,建立日期,姓名,类型,名称,开始时间,结束时间,取得证书,备注,经办人,SN FROM peixunjinxiu WHERE ID='" + this.LabelZhuJian.Text.Trim() + "'";
fillGridViewTianJia(querySql);
}
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
/**//// <summary>
/// 更新
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void GridViewTianJia_RowUpdating(object sender, GridViewUpdateEventArgs e) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
// 建立日期,姓名,类型,名称,开始时间,结束时间,取得证书,备注,经办人,SN
String sqlUpdate = "UPDATE peixunjinxiu SET 姓名=:xm,类型=:lx,名称=:mc,开始时间=:kssj,结束时间=:jssj,取得证书=:qdzs,备注=:bz"
+ " WHERE SN=:sn";
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
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 ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
OracleHelper.ExecuteNonQuery(trans, CommandType.Text, sqlUpdate, parms);
trans.Commit();
}
catch (Exception ex) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
trans.Rollback();
ex.ToString();
}
finally ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
conn.Close();
}
GridViewTianJia.EditIndex = -1;
// 初始化默认Gridview的SQL语句
String querySql = "SELECT ID,建立日期,姓名,类型,名称,开始时间,结束时间,取得证书,备注,经办人,SN FROM peixunjinxiu WHERE ID='" + this.LabelZhuJian.Text.Trim() + "'";
fillGridViewTianJia(querySql);
}
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
/**//// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ButtonBaoCun_Click(object sender, EventArgs e) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
// 建立日期,姓名,类型,培训名称,进修名称,开始时间,结束时间,取得证书,备注,经办人,SN
String sqlInsert = "INSERT INTO peixunjinxiu(ID,建立日期,姓名,类型,名称,开始时间,结束时间,取得证书,备注,经办人,SN) "
+ "VALUES(:id,:jlrq,:xm,:lx,:mc,:kssj,:jssj,:qdzs,:bz,:jbr,:sn)";
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
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 ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
OracleHelper.ExecuteNonQuery(trans, CommandType.Text, sqlInsert, parms);
trans.Commit();
}
catch (Exception ex) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
trans.Rollback();
ex.ToString();
}
finally ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
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;
}
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
/**//// <summary>
/// 取消
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ButtonQuXiao_Click(object sender, EventArgs e) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
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;
}
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
/**//// <summary>
/// 取消
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void LinkButtonQuXiao_Click(object sender, EventArgs e) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
GridViewTianJia.EditIndex = -1;
// 初始化默认Gridview的SQL语句
String querySql = "SELECT ID,建立日期,姓名,类型,名称,开始时间,结束时间,取得证书,备注,经办人,SN FROM peixunjinxiu WHERE ID='" + this.LabelZhuJian.Text.Trim() + "'";
fillGridViewTianJia(querySql);
}
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
/**//// <summary>
/// 添加保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void LinkButtonTianJia_Click(object sender, EventArgs e) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
if (Page.IsValid) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
//
}
// 建立日期,姓名,类型,培训名称,进修名称,开始时间,结束时间,取得证书,备注,经办人,SN
String sqlInsert = "INSERT INTO peixunjinxiu(ID,建立日期,姓名,类型,名称,开始时间,结束时间,取得证书,备注,经办人,SN) "
+ "VALUES(:id,:jlrq,:xm,:lx,:mc,:kssj,:jssj,:qdzs,:bz,:jbr,:sn)";
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
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 ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
OracleHelper.ExecuteNonQuery(trans, CommandType.Text, sqlInsert, parms);
trans.Commit();
}
catch (Exception ex) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
trans.Rollback();
ex.ToString();
}
finally ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
conn.Close();
}
GridViewTianJia.EditIndex = -1;
// 初始化默认Gridview的SQL语句
String querySql = "SELECT ID,建立日期,姓名,类型,名称,开始时间,结束时间,取得证书,备注,经办人,SN FROM peixunjinxiu WHERE ID='" + this.LabelZhuJian.Text.Trim() + "'";
fillGridViewTianJia(querySql);
}
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
/**//// <summary>
/// 时间格式验证
/// </summary>
/// <param name="source"></param>
/// <param name="args"></param>
protected void CVKaiShiShiJian_ServerValidate(object source, ServerValidateEventArgs args) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
try ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
DateTime dt = DateTime.Parse(args.Value);
// 如果长度不为10则不是合法的日期
if(args.Value.Trim().Length == 10) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
args.IsValid = true;
return;
}
}
catch (Exception) ![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
}
args.IsValid = false;
}
}