modifyexercise.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.teacher
{
	/// <summary>
	/// 功能说明:批改习题
	/// 日期:
	/// 作者:
	/// </summary>
	public class modifyexercise : PageBase 
	{
		protected System.Web.UI.WebControls.DataGrid DGForum;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if (!Page.IsPostBack)
			{
				if (purview()&&(Request.Cookies["class_type"].Value.ToString()=="0"))
				{
                    //只有教师自己才能批改习题
                    Frm_Init();
				}
			}
			else
			{
				Response.Write("<script>window.top.location.href('../WebForm1.aspx'); </script>");
			}

		}

		private void Frm_Init()
		{
            //Search_DataGrid(" exercise_table_teacherguid='"+Response.Cookies["username_guid"].ToString()+"'");
			//string str_teacher=Cookies["username_guid"].
			string str_teacher_guid=Request.Cookies["username_guid"].Value.ToString();
 
            Search_DataGrid(" exercise_table_teacher_guid='"+str_teacher_guid+"'");
		}

		/// <summary>
		/// 根据条件 填充DataGrid
		/// </summary>
		/// <param name="str_where">where 子句</param>
		private void Search_DataGrid(string str_where)
		{
			string str_sql="select * from view_modifyexercise 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();
		}

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

		}
		#endregion

		private void DGForum_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
            //string str_type=Request.QueryString["type"].ToString();
			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('checkexercise.aspx?exercise_guid="+e.Item.Cells[0].Text+"' ,'批改习题','width=620,height=400,resizable=yes,top=100,left=100'"+");");			
     			e.Item.Attributes.Add("ondblclick", "window.open('checkexercise.aspx?guid="+e.Item.Cells[0].Text+"&&exercise_guid="+e.Item.Cells[1].Text+"&&type="+Request.QueryString["type"].ToString()+"' ,'批改习题','width=620,height=460,resizable=yes,top=100,left=100'"+");");
                
			}
		}
	}
}