?? teachermanage.aspx.cs
字號:
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
namespace TestOnline
{
/// <summary>
/// teacherManage 的摘要說明。
/// </summary>
public class teacherManage : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DropDownList ddl_course;
protected System.Web.UI.WebControls.ImageButton Ibtn_ok;
protected System.Web.UI.WebControls.Label lbl_courseId;
protected System.Web.UI.WebControls.ImageButton IBtn_add;
protected System.Web.UI.WebControls.TextBox tbx_query1;
protected System.Web.UI.WebControls.RadioButton rbtn_showall;
protected System.Web.UI.WebControls.RadioButton rbtn_showpub;
protected System.Web.UI.WebControls.RadioButton rbtn_shownopub;
protected System.Web.UI.WebControls.ImageButton ImageButton1;
protected System.Web.UI.WebControls.DataGrid DataGrid1;
protected System.Web.UI.WebControls.Label lbl_noResult;
protected System.Web.UI.WebControls.Label lbl_courseName;
protected System.Web.UI.WebControls.CheckBox cbx_isTest;
protected System.Web.UI.WebControls.Label lbl_count;
protected System.Web.UI.WebControls.ImageButton Ibtn_save;
protected System.Data.DataView dv;
private void Page_Load(object sender, System.EventArgs e)
{
// 在此處放置用戶代碼以初始化頁面
if(Session["teacherId"]==null)
{
Response.Redirect("login.aspx");
}
else
if(!Page.IsPostBack)
{
string teacherId=Convert.ToString(Session["teacherId"]);
string courseId=(new projClass()).getTeacherCourseId(teacherId);
Session["courseId"]=courseId;
string courseName=(new projClass()).getCourseNameAsCourseId(courseId);
lbl_courseName.Text=courseName;
bool isTest;
isTest=(new projClass()).getIsTestAsCourseId(courseId);
if(isTest)
cbx_isTest.Checked=true;
else cbx_isTest.Checked=false;
BindGrid();
}
}
#region Web 窗體設計器生成的代碼
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 該調用是 ASP.NET Web 窗體設計器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 設計器支持所需的方法 - 不要使用代碼編輯器修改
/// 此方法的內容。
/// </summary>
private void InitializeComponent()
{
this.Ibtn_save.Click += new System.Web.UI.ImageClickEventHandler(this.Ibtn_save_Click);
this.IBtn_add.Click += new System.Web.UI.ImageClickEventHandler(this.IBtn_add_Click);
this.ImageButton1.Click += new System.Web.UI.ImageClickEventHandler(this.ImageButton1_Click);
this.DataGrid1.ItemCreated += new System.Web.UI.WebControls.DataGridItemEventHandler(this.DataGrid1_ItemCreated);
this.DataGrid1.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DataGrid1_PageIndexChanged);
this.DataGrid1.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_DeleteCommand);
this.DataGrid1.SelectedIndexChanged += new System.EventHandler(this.DataGrid1_SelectedIndexChanged);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
void BindGrid()
{
string teacherId=Convert.ToString(Session["teacherId"]);
string courseId=(new projClass()).getTeacherCourseId(teacherId);
DataSet ds=new DataSet();
ds=(new projClass()).getTest(courseId);
DataTable dt=ds.Tables["testInfo"];
//DataView
dv=new DataView(dt);
if(rbtn_showall.Checked)
{
if(tbx_query1.Text.Trim()!="")
dv.RowFilter="testContent like '%"+tbx_query1.Text.Trim()+"%'";
}
else if(rbtn_showpub.Checked)
dv.RowFilter="pub like '是' and testContent like '%"+tbx_query1.Text.Trim()+"%' ";
else if(rbtn_shownopub.Checked)
dv.RowFilter="pub like '否' and testContent like '%"+tbx_query1.Text.Trim()+"%'";
DataGrid1.DataSource=dv;
lbl_count.Text=dv.Count.ToString();
if(dv.Count==0)
{
lbl_noResult.Visible=true;
DataGrid1.Visible=false;
}
else
{
lbl_noResult.Visible=false;
DataGrid1.Visible=true;
}
DataGrid1.DataBind();
}
private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
// string data="";
// int count=0;
// Hashtable ht_testId;
// //int count=0;
// if(Session["ht_testId"]!=null)
// {
// //Hashtable
// ht_testId=(Hashtable)Session["ht_testId"];
//
// }
// else
// {
// // Hashtable
// ht_testId=new Hashtable();
// Session["ht_testId"]=ht_testId;
// }
// foreach (DataGridItem item in DataGrid1.Items)
// {
// CheckBox cbx=(CheckBox)item.FindControl("cbx_select");
// if(cbx.Checked)
// {
// count++;
// data+="1";
// //獲取試題的ID
// string id=item.Cells[2].Text.ToString();
//
// if(!ht_testId.Contains(id))
// ht_testId.Add(id,"");
// }
// else data+="0";
// }
//
// if(ViewState["pagedata"]!=null)
// {
// Hashtable ht=(Hashtable)ViewState["pagedata"];
// //Hashtable ht_testId=(Hashtable)Session["ht_testId"];
// if(ht.Contains(this.DataGrid1.CurrentPageIndex))
// ht[this.DataGrid1.CurrentPageIndex]=data;
// else
// ht.Add(this.DataGrid1.CurrentPageIndex,data);
// ViewState["pagedata"]=ht;
// }
// else
// {
// Hashtable ht=new Hashtable();
// //Hashtable ht_testId=new Hashtable();
// ht.Add(this.DataGrid1.CurrentPageIndex,data);
// ViewState["pagedata"]=ht;
//
// }
DataGrid1.CurrentPageIndex=e.NewPageIndex;
BindGrid();
}
private void IBtn_add_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
string courseId=Convert.ToString(Session["courseId"]);
string teacherId=Convert.ToString(Session["teacherId"]);
if(!(Session["courseId"]==null))
Response.Redirect("testAddByTeacher.aspx?courseId="+courseId+"&teacherId="+teacherId);
else Response.Write("<script>alert(\"沒有獲取到科目ID!\");</script>");
}
private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
if(e.Item.ItemType==ListItemType.Item||e.Item.ItemType==ListItemType.AlternatingItem)
{
if(ViewState["pagedata"]!=null)
{
Hashtable ht=(Hashtable)ViewState["pagedata"];
if(ht.Contains(this.DataGrid1.CurrentPageIndex))
{
CheckBox cb=(CheckBox)e.Item.FindControl("cbx_select");
cb.Checked=ht[this.DataGrid1.CurrentPageIndex].ToString()[e.Item.ItemIndex].ToString()=="1";
}
}
}
}
private void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e)
{
}
private void ImageButton5_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
foreach (DataGridItem item in DataGrid1.Items)
{
CheckBox cbx=(CheckBox)item.FindControl("cbx_select");
cbx.Checked=false;
}
}
private void ImageButton1_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
if(Session["courseId"]==null)
Response.Write("<script>alert(\"沒有獲取到科目ID！\");</script>");
ViewState.Clear();
DataGrid1.CurrentPageIndex=0;
BindGrid();
}
private void Ibtn_save_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
string courseId=Convert.ToString(Session["courseId"]);
string courseName=lbl_courseName.Text;
bool isTest=cbx_isTest.Checked;
int count=(new projClass()).updateCourseInfo(courseId,courseName,isTest);
if(count==1)
{
if(isTest)
Response.Write("<script>alert(\"保存成功!這門課可以進入考試!\");</script>");
else
Response.Write("<script>alert(\"保存成功!這門課將不能進入考試!\");</script>");
}
else Response.Write("<script>alert(\"保存失敗!\");</script>");
}
private void DataGrid1_ItemCreated(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
switch(e.Item.ItemType)
{
case ListItemType.Item:
case ListItemType.AlternatingItem:
case ListItemType.EditItem:
{
LinkButton btnDelete=(LinkButton)e.Item.FindControl("btn_del");
btnDelete.Attributes.Add("onclick", "return confirm('你是否確定刪除?');");
break;
}
}
}
private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
string id=e.Item.Cells[1].Text.ToString().Trim();
int count=(new projClass()).deleteTestInfo(id);
if(count==0)
Response.Write("<script>alert(\"刪除失敗！\");</script>");
else Response.Write("<script>alert(\"刪除成功！\");</script>");
// Response.Redirect("showTest.aspx");
Response.Write("<script> window.location.reload() </script>");
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -