manageexercise.aspx.cs

利用C#编写一个简单的考试系统。主要功能是

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;


using Teach_Manager.Common;  
using Teach_Manager.Dao;

namespace Teach_Manager.student
{
	/// <summary>
	/// 功能:学生上机练习
	/// 作者:
	/// 日期:2006-05-07	
	/// </summary>
	public class manageexercise :PageBase 
	{
		protected System.Web.UI.WebControls.TextBox txtCTMC;
		protected System.Web.UI.WebControls.Button cmdOK;
		protected System.Web.UI.WebControls.DataGrid DGForum;
		protected System.Web.UI.WebControls.DropDownList ddlKCDH;
	
		string frm_Type="";

		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if (!Page.IsPostBack)
			{
				if (purview()&&(Request.Cookies["class_type"].Value.ToString()=="0"))
				{
					//判断是添加习题还是管理习题
					frm_Type=Request.QueryString["type"];
					if (frm_Type=="0")
					{
						//管理习题
                        frm_Type="0";

					}
					if (frm_Type=="1")
					{
                        //添加答案
                        frm_Type="1";
						//隐藏Delete
						DGForum.Columns[10].Visible=false; 
					}
				
					Frm_Init();
				}
				else
				{
					if ((Request.QueryString["type"]=="3")&&(purview()))
					{						
						//学生做题目
						//隐藏Delete
						DGForum.Columns[10].Visible=false; 
						frm_Type="3";
                        Frm_Init();
					}
					else
					{
                        Response.Write("<script>window.top.location.href('../WebForm1.aspx'); </script>");
					}					
				}
			}
		}


		/// <summary>
		/// 根据条件 填充DataGrid
		/// </summary>
		/// <param name="str_where">where 子句</param>
		private void Search_DataGrid(string str_where)
		{
            string str_sql="select * from view_exercise where IsDelete='0' ";
			if (str_where.Trim()!="")
			{
                str_sql+=" and "+str_where;
			}
			CommonInterface CIF=new CommonSql(str_conn_protected); 
			DataTable dt=CIF.ExeForDtl(str_sql); 
			DGForum.DataSource = dt;
			DGForum.DataBind();
			CIF.Close();
		}

		private void Frm_Init()
		{
			//棒定课程下拉列表
			string str_sql="select guid,Name from course_Table where IsDelete='0'";
			CommonInterface CIF=new CommonSql(str_conn_protected); 
			ddlKCDH.DataSource=CIF.ExeForDtl(str_sql);
			ddlKCDH.DataTextField="Name";
			ddlKCDH.DataValueField="guid";
			ddlKCDH.DataBind();
			ddlKCDH.Items.Insert(0,"--请选择--"); 
            CIF.Close();
            //绑定DataGrid

			Search_DataGrid("");

		}

		/// <summary>
		/// 分页
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		public void Page_Grid(Object sender, DataGridPageChangedEventArgs e) 
		{
			string str_sql = "select * from view_exercise where IsDelete=0";
			// Set CurrentPageIndex to the page the user clicked.
			DGForum.CurrentPageIndex = e.NewPageIndex;
			// Rebind the data. 
			CommonInterface CIF=new CommonSql(str_conn_protected); 
			DataTable dt=CIF.ExeForDtl(str_sql); 
			DGForum.DataSource = dt;
			DGForum.DataBind();
			CIF.Close();
		}



		/// <summary>
		/// 删除习题
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		public void exercise_Delete(Object sender, DataGridCommandEventArgs e) 
		{
			
			//string str_ID = ((TextBox)e.Item.Cells[1].Controls[1]).Text;
			//string str_Name = ((TextBox)e.Item.Cells[2].Controls[1]).Text;
		
			//IsDelete =1 表示删除
			string sql_edit = "UPDATE exercise_table " +
				"SET IsDelete = '1'" +				
				" WHERE guid = '" + e.Item.Cells[0].Text+"'";
           
			CommonInterface CIF=new CommonSql(str_conn_protected); 
			CIF.Execute(sql_edit); 



			string str_sql = "select * from view_exercise where IsDelete=0 ";	
			DGForum.EditItemIndex = -1;		
			DataTable dt=CIF.ExeForDtl(str_sql); 
			CIF.Close();
			DGForum.DataSource = dt;
			DGForum.DataBind();

		}




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

		}
		#endregion

		private void cmdOK_Click(object sender, System.EventArgs e)
		{
			//习题查询 根据课程名称和习题名称
			string str_courseGuid="";
			if (ddlKCDH.SelectedItem.Text!="--请选择--")
			{
                str_courseGuid=ddlKCDH.SelectedItem.Value;
			}
            string str_exercisename=txtCTMC.Text.Trim().Replace("'","''");            
			string str_where=" Name like '%"+str_exercisename+"%'";
			if (str_courseGuid!="")                        
			{
                str_where+=" and course_guid='"+str_courseGuid+"'";
			}
            Search_DataGrid(str_where);
		
		}

		private void DGForum_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			if(e.Item.ItemType == ListItemType.Item  || e.Item.ItemType == ListItemType.AlternatingItem)
			{
				//添加自定义属性，当鼠标移过来时设置该行的背景色为"6699ff",并保存原背景色
				e.Item.Attributes.Add("onmouseover","currentcolor=this.style.backgroundColor;this.style.backgroundColor='#6699ff'");
				//添加自定义属性，当鼠标移走时还原该行的背景色
				e.Item.Attributes.Add("onmouseout","this.style.backgroundColor=currentcolor");

				//双击 以后显示用户的详细信息 这里是学生提交答案			
                e.Item.Attributes.Add("ondblclick", "window.open('exercise_details.aspx?exercise_guid="+e.Item.Cells[0].Text+"&&frm_Type=3' ,'习题详细信息','width=620,height=400,resizable=yes,top=100,left=100'"+");");
				
				
				
			}
		}
	}
}