st_question.aspx.cs

数据库：Microsoft SQL Server 2000。 技术平台：Microsoft .NET Framework 2.0.0.0版本。 IIS：Internet Informati

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 STGROUP.ST_WebExam.ST_Admin
{
	/// <summary>
	/// ST_Question 的摘要说明。
	/// </summary>
	public partial class ST_Question : System.Web.UI.Page
	{
	
		protected void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			Response.Cache.SetCacheability(HttpCacheability.NoCache);//去掉页面缓存
			if(!IsPostBack)
			{
                bool flag = ST_DdlBind();
				if(flag)
					ST_DgBind();
			}
		}
        /// <summary>
        /// 绑定科目信息
        /// </summary>
        public bool ST_DdlBind()
        {
            ST_ExamBiz.ST_Course st_course = new STGROUP.ST_ExamBiz.ST_Course();
            DataSet ds = st_course.ST_GetAllCourseInfo();
			if(ds!=null && ds.Tables.Count>0 && ds.Tables[0].Rows.Count>0)
			{
				ddlCourse.DataSource = ds;
				ddlCourse.DataBind();
				return true;
			}
			else
			{
				Response.Write("<script language='javascript'>alert('请先添加科目信息！');window.location='ST_Course.aspx'</script>");
				Response.End();
				return false;
			}
        }
		/// <summary>
		/// 绑定问题
		/// </summary>
		public void ST_DgBind()
		{
			dgBulletin.Visible = true;
			ST_ExamBiz.ST_Question st_Question = new STGROUP.ST_ExamBiz.ST_Question();
			DataSet ds = st_Question.ST_GetAllQuestionInfo(int.Parse(ddlCourse.SelectedValue));
			if(ds!=null && ds.Tables.Count>0 && ds.Tables[0].Rows.Count>0)
			{
				dgBulletin.DataSource = ds;
				dgBulletin.DataBind();
			}
			else
			{
				dgBulletin.Visible = false;
			}
		}

		/// <summary>
		/// 获得备选答案
		/// </summary>
		/// <param name="answer1"></param>
		/// <param name="answer2"></param>
		/// <param name="answer3"></param>
		/// <param name="answer4"></param>
		/// <returns></returns>
		public string GetAnswer(string answer1,string answer2,string answer3,string answer4 )
		{
			System.Text.StringBuilder sb = new System.Text.StringBuilder();
			sb.Append("A:"+answer1);
			sb.Append("<br>");
			sb.Append("B:"+answer2);
			sb.Append("<br>");
			sb.Append("C:"+answer3);
			sb.Append("<br>");
			sb.Append("D:"+answer4);
			sb.Append("<br>");
			return sb.ToString();
		}

		public void dgItem(object sender, DataGridCommandEventArgs e)
		{
			ST_ExamBiz.ST_Question st_Question = new STGROUP.ST_ExamBiz.ST_Question();
			int st_QuestionID = int.Parse(e.Item.Cells[0].Text);
			int st_majorID = int.Parse(e.Item.Cells[6].Text);
			if(e.CommandName=="edit")
			{
				//编辑课程信息
				string str = "<script language='javascript' defer>ret = window.showModalDialog('ST_QuestionAdd.aspx?Action=edit&id="+st_QuestionID+"&mid="+st_majorID+"',window,'dialogHeight:350px;dialogWidth:600px;center:Yes;Help:No;Resizable:No;Scroll:auto;Status:no;');</script>";
				Response.Write(str);

			}
			if(e.CommandName=="delete")
			{
				//删除课程信息
				st_Question.ST_DeleteQuestionInfo(st_QuestionID);
			}
			ST_DgBind();
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.dgBulletin.ItemCreated += new System.Web.UI.WebControls.DataGridItemEventHandler(this.dgBulletin_ItemCreated);

		}
		#endregion

		private void dgBulletin_ItemCreated(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			//添加客户端删除事件
			e.Item.Cells[5].Attributes.Add("onclick","javascript:return confirm('确实要删除吗？');");
		}

	
		protected void btnOK_Click(object sender, System.EventArgs e)
		{
			//转向到添加题目页面
			string str = "<script language='javascript' defer>ret = window.showModalDialog('ST_QuestionAdd.aspx?Action=add',window,'dialogHeight:350px;dialogWidth:600px;center:Yes;Help:No;Resizable:No;Scroll:auto;Status:no;');</script>";
			Response.Write(str);
		}

		protected void ddlCourse_SelectedIndexChanged(object sender, System.EventArgs e)
		{
            //科目变化时，重新绑定问题
			ST_DgBind();
		}
	}
}