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();
        
    }
    //************************************************************
   
}