?? showtest.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>
/// showTest 的摘要說明。
/// </summary>
public class showTest : System.Web.UI.Page
{
protected System.Web.UI.WebControls.TextBox tbx_query;
protected System.Web.UI.WebControls.DropDownList DropDownList1;
protected System.Web.UI.WebControls.DropDownList DropDownList2;
protected System.Web.UI.WebControls.ImageButton Ibtn_query;
protected System.Web.UI.WebControls.DataGrid DataGrid1;
protected System.Web.UI.WebControls.Label lbl_count;
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.ImageButton IBtn_add;
protected System.Web.UI.WebControls.ImageButton Ibtn_del;
protected System.Web.UI.WebControls.ImageButton Ibtn_ok;
protected System.Web.UI.WebControls.Label lbl_courseId;
protected System.Web.UI.WebControls.Button Button1;
protected System.Web.UI.WebControls.Label Label2;
protected System.Web.UI.WebControls.DropDownList ddl_course;
protected System.Web.UI.WebControls.ImageButton ImageButton1;
protected System.Web.UI.WebControls.TextBox tbx_query1;
protected System.Web.UI.WebControls.RadioButton rbtn_showpub;
protected System.Web.UI.WebControls.RadioButton rbtn_shownopub;
protected System.Web.UI.WebControls.Label lbl_noResult;
protected System.Web.UI.WebControls.RadioButton rbtn_showall;
protected System.Data.DataView dv;
private void Page_Load(object sender, System.EventArgs e)
{
// 在此處放置用戶代碼以初始化頁面
//Ibtn_del.Attributes.Add("OnClick","return confirm('你確定要刪除這些試題嗎？');");
if(Session["adminId"]==null)
{
Response.Redirect("login.aspx");
}
else
{
if(!IsPostBack)
{
//BindGrid();
DataSet ds=new DataSet();
ds=(new projClass()).getCourses();
foreach(DataRow row in ds.Tables[0].Rows)
{
ddl_course.Items.Add(row["courseName"].ToString());
}
if(Session["courseId"]!=null)
{
string courseId=Convert.ToString(Session["courseId"]);
lbl_courseId.Text=courseId;
ddl_course.SelectedValue=(new projClass()).getCourseNameAsCourseId(courseId);
BindGrid();
}
}
// DataGrid1.PageIndexChanged+=new DataGridPageChangedEventHandler(DataGrid1_PageIndexChanged);
}
}
#region Web 窗體設計器生成的代碼
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 該調用是 ASP.NET Web 窗體設計器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 設計器支持所需的方法 - 不要使用代碼編輯器修改
/// 此方法的內容。
/// </summary>
private void InitializeComponent()
{
this.ddl_course.SelectedIndexChanged += new System.EventHandler(this.ddl_course_SelectedIndexChanged);
this.Ibtn_ok.Click += new System.Web.UI.ImageClickEventHandler(this.Ibtn_ok_1_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 courseId=lbl_courseId.Text;
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 ddl_course_SelectedIndexChanged(object sender, System.EventArgs e)
{
// Label1.Text="text"+ddl_course.SelectedItem.Text+";selectedItem:"+ddl_course.SelectedItem.Value+";selectedvalue:"+ddl_course.SelectedValue+";index:"+ddl_course.SelectedIndex.ToString();
}
private void Ibtn_ok_1_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
//lbl_courseId.Text=ddl_course.SelectedItem.Text;
string courseId;
string courseName=ddl_course.SelectedItem.Text;
courseId=(new projClass()).getCourseIdAsCourseName(courseName);
lbl_courseId.Text=courseId;
Session["courseId"]=courseId;
BindGrid();
//return courseName;
}
private void IBtn_add_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
string courseId=Convert.ToString(Session["courseId"]);
string adminId=Convert.ToString(Session["adminId"]);
if(!(Session["courseId"]==null))
Response.Redirect("testAdd.aspx?courseId="+courseId+"&adminId="+adminId);
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";
}
}
}
}
// public string getFirstSelected()
// {
// bool selected=false;//判斷用戶是否選擇了一個記錄
// string selectedId="";
// foreach (DataGridItem item in DataGrid1.Items)
// {
// if(!selected)
// {
// CheckBox cbx=(CheckBox)item.FindControl("cbx_select");
// if(cbx!=null)
// {
// if(cbx.Checked)
// {
// selectedId=item.Cells[2].Text;
// selected=true;
// return selectedId;
// }
//
// }
// }
//
// }
// if(!selected)
// {
// //Response.Write("<script>alert(\"請選擇一條記錄！\");</script>");//沒有選擇記錄
// selectedId="none";
// }
// return selectedId;
// }
private void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e)
{
}
private void ImageButton4_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
foreach (DataGridItem item in DataGrid1.Items)
{
CheckBox cbx=(CheckBox)item.FindControl("cbx_select");
cbx.Checked=true;
}
}
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 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>");
}
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 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;
}
}
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -