
/// <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,
GridViewCancelEditEventA
rgs
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)

...{
//
}
// 建立日期,姓名,类型,培训名称,进修名称,开始时间,结束时间,取得证书,备注,经办人,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);
}

/// <summary>
/// 时间格式验证
/// </summary>
/// <param name="source"></param>
/// <param name="args"></param>
protected void CVKaiShiShiJian_ServerValidate(
object source,
ServerValidateEventArgs
args)

...{
try

...{
DateTime
dt
=
DateTime.Parse(args.Value);
// 如果长度不为10则不是合法的日期
if(args.Value.Trim().Length
==
10)

...{
args.IsValid
=
true;
return;
}
}
catch (Exception)

...{
}
args.IsValid
=
false;
}

}