?? question.ascx.cs
字號:
?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 TQMS.BusinessLogicLayer;
public partial class modules_Question : System.Web.UI.UserControl
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
this.lblEmptyMessge.Text = "";
Common.BindDdlCourse(this.ddlCourse);//綁定科目下拉列表框
ViewState.Add("ddlCourse", ddlCourse.SelectedValue);
Common.BindChapter(ddlChapter, int.Parse(ddlCourse.SelectedValue));
this.ddlType.Items.Add(new ListItem("全選", "0"));//綁定題型下拉列表框
Common.BindDdlType(this.ddlType);
this.ddlDifficult.Items.Add(new ListItem("全選", "0"));
Common.BindDdlDifficult(this.ddlDifficult);//綁定難度下拉列表框
}
}
//用戶查詢按鈕事件
protected void btnSearch_Click(object sender, EventArgs e)
{
Hashtable ht = new Hashtable();
if (this.ddlChapter.Items.Count < 1)
{
Response.Write("<script language='javascript'>alert('暫無試題!!');</script>");
this.gvQuestion.Visible = false;
return;
}
if (this.ddlChapter.SelectedValue != "0")
{
ht.Add("TQ_ChapterID", this.ddlChapter.SelectedValue);
}
if (this.ddlType.SelectedValue != "0")
{
ht.Add("TQ_Type", this.ddlType.SelectedValue);
}
if (this.ddlDifficult.SelectedValue != "0")
{
ht.Add("TQ_DifficultyLevel", ddlDifficult.SelectedValue);
}
if (this.tbxKey1.Text != "")
{
string strKey = this.tbxKey1.Text.Trim();
ht.Add("TQ_QuestionContent", strKey);
}
//DataTable dt = Question.QueryQuestionForShort(ht);
DataTable dt = Question.QueryQuestion(ht);
if (dt.Rows.Count <= 0)
{
this.lblEmptyMessge.Text = "沒有符合條件的結果,請變換條件以進行重新查詢";
this.lblEmptyMessge.Visible = true;
this.gvQuestion.Visible = false;
}
else
{
this.gvQuestion.Visible= true;
this.gvQuestion.DataSource = dt;
this.gvQuestion.DataBind();
this.lblEmptyMessge.Visible = false;
}
//resetQuery();//恢復下拉列表框
}
//自動綁定章目信息到章目下拉列表框中
protected void ddlCourse_SelectedIndexChanged(object sender, EventArgs e)
{
this.ddlChapter.Items.Clear();
Common.BindChapter(this.ddlChapter, int.Parse(this.ddlCourse.SelectedValue));//綁定章節下拉列表框
}
//編輯,刪除按鈕事件
protected void gvQuestion_ItemCommand(object source, DataListCommandEventArgs e)
{
if (e.CommandName == "Delete")
{
int questionID = Convert.ToInt32(e.CommandArgument);
Question question = new Question();
question.LoadData(questionID);
//if (question.UserID != (int)Session["userID"])
//{
// Response.Write("<Script Language=JavaScript>alert(\"對不起,你無權刪除!!\")</Script>");
// gvQuestion.EditItemIndex = -1;
// return;
//}
question.Delete();
gvQuestion.EditItemIndex = -1;
btnSearch_Click(btnSearch, e);
}
if (e.CommandName == "Edit")
{
int questionID = Convert.ToInt32(e.CommandArgument);
Response.Redirect("~/EditQuestion.aspx?action=edit&id=" + questionID);
}
}
//當用戶利用復選框時進行多條記錄的刪除時觸發
protected void btnDeleteAll_Click(object sender, EventArgs e)
{
}
//用戶單擊全選按鈕時觸發
protected void btnAllSelect_Click(object sender, EventArgs e)
{
for (int i = 0; i < gvQuestion.Items.Count; i++)
{
CheckBox chk = (CheckBox)gvQuestion.Items[i].FindControl("chkQuestion");
chk.Checked = true;
}
}
//當用單擊顯示答案時
protected void showAnswer_Click(object sender, EventArgs e)
{
for (int i = 0; i < this.gvQuestion.Items.Count; i++)
{
if (gvQuestion.Items[i].ItemType == ListItemType.AlternatingItem || gvQuestion.Items[i].ItemType == ListItemType.Item)
{
((Label)gvQuestion.Items[i].FindControl("TQ_RightAnserLabel")).Visible = true;
}
}
}
//順序綁定題號
protected void gvQuestion_ItemCreated(object sender, DataListItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
((Label)e.Item.FindControl("id")).Text = (e.Item.ItemIndex+1).ToString();
}
}
//將數據庫中題型和難度的數值信息用漢字顯示出來
protected void gvQuestion_ItemDataBound(object sender, DataListItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
Label lbl = new Label();
lbl = (Label)(e.Item.FindControl("TQ_TypeLabel"));
Common.showType(lbl);
lbl= (Label)(e.Item.FindControl("TQ_DifficultyLevelLabel"));
Common.showDifficulty(lbl);
}
}
//******************** 以下功能暫不實現**************************
//定義能恢復下拉列表框的函數
protected void resetQuery()
{
//科目
foreach (ListItem item in ddlCourse.Items)
{
if (item.Value == ViewState["ddlCourse"].ToString())
item.Selected = true;
else
item.Selected = false;
}
//章節
foreach (ListItem item in ddlCourse.Items)
{
if (item.Value == ViewState["ddlChapter"].ToString())
item.Selected = true;
else
item.Selected = false;
}
//類型
foreach (ListItem item in ddlType.Items)
{
if (item.Value == ViewState["ddlType"].ToString())
item.Selected = true;
else
item.Selected = false;
}
//難度
foreach (ListItem item in ddlDifficult.Items)
{
if (item.Value == ViewState["ddlDifficult"].ToString())
item.Selected = true;
else
item.Selected = false;
}
}
//*****************DataList分頁的實現 *************************
protected void pager(DataList dlst, DataTable dt, int pageszie)
{
PagedDataSource obj = new PagedDataSource();
obj.DataSource = (IEnumerable) dt.DefaultView;
obj.AllowPaging = true;
obj.PageSize = pageszie;
int nowpage;
if (Request.QueryString["page"] != null)
nowpage = int.Parse(Request.QueryString["page"].ToString());
else
nowpage = 1;
obj.CurrentPageIndex = nowpage - 1;
this.hlkFirst.NavigateUrl = Request.CurrentExecutionFilePath + "?page=1";
hlkLast.NavigateUrl = Request.CurrentExecutionFilePath + "?page="+Convert.ToInt32(obj.PageCount-1);
if (!obj.IsFirstPage)
{
hlkPre.NavigateUrl = Request.FilePath + "?page=" + Convert.ToSingle(nowpage - 1);
}
if (!obj.IsLastPage)
{
hlkNext.NavigateUrl = Request.CurrentExecutionFilePath + "?page=" + Convert.ToSingle(nowpage + 1);
}
this.gvQuestion.Visible = true;
this.gvQuestion.DataSource = obj;//調用自定義的分頁函數
this.gvQuestion.DataBind();
}
//************************************************************
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -