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.Data.SqlClient;

/*
?*?類名：?AddJXPaln
?*?描述：?教學計劃
?*?功能：?顯示、編輯、刪除教學計劃表數據
?*/


public?partial?class?AddJXPlan?:?System.Web.UI.Page
{
????protected?void?Page_Load（object?sender?EventArgs?e）
????{
????????TM_BindGrid（）;
????}

????//讀“教學計劃”數據到Trs控件展示
????public?void?TM_BindGrid（）
????{
????????try
????????{
????????????SqlConnection?sqlConn?=?Sql.createConn（）;
????????????sqlConn.Open（）;

????????????string?tm_sqlstr?=?“select?*?from?教學計劃“;
????????????SqlDataAdapter?tm_adp?=?new?SqlDataAdapter（tm_sqlstr?sqlConn）;
????????????DataSet?tm_ds?=?new?DataSet（）;
????????????tm_adp.Fill（tm_ds）;

????????????Sql.createConn（）.Close（）;

????????????Trs.DataSource?=?tm_ds;
????????????Trs.DataBind（）;
????????????tm_ds.Clear（）;
????????????tm_ds.Dispose（）;

????????????Sql.createConn（）.Close（）;
????????}
????????catch?（SqlException）
????????{
????????????Label_Info.Text?=?“數據庫聯接失敗“;
????????};
????}

????#region?控件Trs內部操作

????//編輯一行
????protected?void?Trs_RowEditing（object?sender?GridViewEditEventArgs?e）
????{
????????Trs.EditIndex?=?e.NewEditIndex;
????????TM_BindGrid（）;
????}

????//鼠標滑過和滑出數據行顏色變化...
????protected?void?Trs_RowDataBound（object?sender?GridViewRowEventArgs?e）
????{
????????if?（e.Row.RowType?==?DataControlRowType.DataRow）
????????{
????????????e.Row.Attributes.Add（“onmouseover“?“this.style.backgroundColor=‘#E6F5FA‘“）;
????????????e.Row.Attributes.Add（“onmouseout“?“this.style.backgroundColor=‘#FFFFFF‘“）;
????????}
????}

????//取消編輯狀態則刷新控件
????protected?void?Trs_RowCancelEdit（object?sender?GridViewCancelEditEventArgs?e）
????{
????????Trs.EditIndex?=?-1;
????????TM_BindGrid（）;
????}

????//下一頁
????protected?void?Trs_Data_Page（object?sender?GridViewPageEventArgs?e）
????{
????????try
????????{
????????????Trs.PageIndex?=?e.NewPageIndex;
????????????TM_BindGrid（）;
????????}
????????catch?{?}
????}

????#endregion

????#region?超鏈接按鈕

????//全選
????protected?void?linkSelectAll_Click（object?sender?EventArgs?e）
????{
????????for?（int?i?=?0;?i?????????{
????????????CheckBox?chkSelect?=?（CheckBox）Trs.Rows[i].FindControl（“chkSelect“）;
????????????chkSelect.Checked?=?true;
????????}
????}

????//反選
????protected?void?linkSelectOther_Click（object?sender?EventArgs?e）
????{
????????for?（int?i?=?0;?i?????????{
????????????CheckBox?chkSelect?=?（CheckBox）Trs.Rows[i].FindControl（“chkSelect“）;
????????????chkSelect.Checked?=?!chkSelect.Checked;
????????}
????}

????//刪除
????protected?void?linkDelete_Click（object?sender?EventArgs?e）
????{
????????SqlConnection?sqlConn?=?Sql.createConn（）;
????????sqlConn.Open（）;

????????for

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件??????13913??2008-10-05?19:36??教材管理系統\AddJXPlan.aspx

?????文件???????4339??2008-10-04?14:16??教材管理系統\AddJXPlan.aspx.cs

?????文件???????8138??2008-10-11?23:32??教材管理系統\AddKe.aspx

?????文件???????4282??2008-10-05?20:16??教材管理系統\AddKe.aspx.cs

?????文件??????17015??2008-10-05?19:36??教材管理系統\Addstudent.aspx

?????文件???????4157??2008-10-04?15:10??教材管理系統\Addstudent.aspx.cs

?????文件??????11447??2008-10-11?23:38??教材管理系統\AddTRSection.aspx

?????文件???????9480??2008-10-04?23:48??教材管理系統\AddTRSection.aspx.cs

?????文件????????992??2008-05-18?02:39??教材管理系統\App_code\CodePassWord.cs

?????文件???????1218??2008-06-03?16:08??教材管理系統\App_code\DataSet1.xsd

?????文件??????????3??2008-06-03?16:08??教材管理系統\App_code\DataSet1.xss

?????文件??????18464??2008-10-02?16:55??教材管理系統\App_code\DataSet2.xsd

?????文件????????865??2008-10-02?16:55??教材管理系統\App_code\DataSet2.xss

?????文件???????4089??2008-05-18?02:41??教材管理系統\App_code\ExcelOutIn.cs

?????文件???????4176??2008-10-05?04:33??教材管理系統\App_code\IListitem.cs

?????文件???????4734??2008-10-02?12:06??教材管理系統\App_code\JXplan.cs

?????文件????????763??2008-10-02?20:29??教材管理系統\App_code\Sql.cs

?????文件???????5090??2008-06-03?14:21??教材管理系統\App_data\jc.xml

?????文件????2424832??2008-12-21?22:28??教材管理系統\App_data\TeachingMaterialSystem_Data.MDF

?????文件?????516096??2008-12-21?22:28??教材管理系統\App_data\TeachingMaterialSystem_Data_log.ldf

?????文件????1048576??2008-07-02?11:09??教材管理系統\App_data\TeachingMaterialSystem_Log.LDF

?????文件???????3072??2008-10-05?00:17??教材管理系統\bin\App_Licenses.dll

?????文件?????376832??2005-09-30?17:31??教材管理系統\bin\CuteEditor.dll

?????文件?????????38??2007-12-14?00:09??教材管理系統\bin\CuteEditor.dll.refresh

?????文件??????45056??2005-09-22?21:55??教材管理系統\bin\CuteEditor.ImageEditor.dll

?????文件????????112??2005-10-18?21:45??教材管理系統\bin\CuteEditor.lic

?????文件??????69632??2004-04-20?20:25??教材管理系統\bin\EeekSoft.Web.PopupWin.DLL

?????文件?????????60??2008-10-05?14:29??教材管理系統\bin\EeekSoft.Web.PopupWin.DLL.refresh

?????文件?????106496??2004-03-30?22:57??教材管理系統\bin\NetSpell.SpellChecker.dll

?????文件?????????60??2008-10-04?11:03??教材管理系統\bin\NetSpell.SpellChecker.dll.refresh

............此處省略1325個文件信息