checkexercise.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 checkexercise : PageBase 
	{
		protected System.Web.UI.WebControls.TextBox exercise_name;
		protected System.Web.UI.WebControls.TextBox course_name;
		protected System.Web.UI.WebControls.TextBox exercise_content;
		protected System.Web.UI.WebControls.TextBox exercise_solution;
		protected System.Web.UI.WebControls.TextBox teacher_name;
		protected System.Web.UI.WebControls.TextBox exercise_datetime;
		protected System.Web.UI.WebControls.LinkButton LinkButton1;
		protected System.Web.UI.WebControls.TextBox student_name;
		protected System.Web.UI.WebControls.TextBox submit_dateyime;
		protected System.Web.UI.WebControls.TextBox txtgrade;
		protected System.Web.UI.WebControls.Button PutIn_sulution;
	
		private static string str_link="";

		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			// 在此处放置用户代码以初始化页面
			if (!Page.IsPostBack)
			{
				if (purview())
				{
					fillData();
				}
				else
				{
					Response.Write("<script>window.top.location.href('../WebForm1.aspx'); </script>");
				}
			}
		}

		private void fillData()
		{
			//习题Guid
			string exercise_guid=Request.QueryString["exercise_guid"];
			//提交题目Guid
            string guid=Request.QueryString["guid"];
            //根据提交题目的Guid,查询出来作题学生姓名,和提交时间
			string str_where1=" guid='"+guid+"'";
            Search_DataGrid1(str_where1);

			//string str_frmType=Request.QueryString["frm_Type"];
//			if (str_frmType=="1")
//			{
//				//添加答案
//				exercise_solution.ReadOnly =false;
//				PutIn_sulution.Visible =true;
//			}

			string str_where=" guid='"+exercise_guid+"'";
			Search_DataGrid(str_where);


			exercise_solution.Attributes.Add("onKeyDown","textCounter(this,800);");
			exercise_solution.Attributes.Add("onKeyUp","textCounter(this,800);"); 
			

            string str_type=Request.QueryString["type"].ToString();
			if (str_type=="1")
			{
				PutIn_sulution.Visible =false;
				txtgrade.ReadOnly =true;
			}

		}

		/// <summary>
		/// 根据条件 查询作题学生姓名,和提交时间
		/// </summary>
		/// <param name="str_where"></param>
		private void Search_DataGrid1(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); 
            CIF.Close();

			if (dt.Rows.Count>0)
			{
				student_name.Text =dt.Rows[0]["student_table_name"].ToString();
				submit_dateyime.Text =dt.Rows[0]["Make_dateTime"].ToString();
				//分数
				txtgrade.Text =dt.Rows[0]["grade"].ToString();
				if (txtgrade.Text.ToString()=="-1")
				{
                    txtgrade.Text="";
				}
			}

		}

		/// <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); 
			CIF.Close();
			//把相关数据填充进去
			if (dt.Rows.Count>0)
			{
				//习题名称
				exercise_name.Text =dt.Rows[0]["Name"].ToString();
				//课程名称
				course_name.Text =dt.Rows[0]["course_Table_name"].ToString();
				//习题内容
				exercise_content.Text =dt.Rows[0]["content"].ToString();
				//习题答案
				exercise_solution.Text =dt.Rows[0]["solution"].ToString();
				//出题教师姓名
				teacher_name.Text =dt.Rows[0]["teacher_table_name"].ToString();
				//出题时间
				exercise_datetime.Text =dt.Rows[0]["exercise_date"].ToString();
				//图片链接地址
				if (dt.Rows[0]["photo_name"].ToString()!="")
				{
					str_link=System.Configuration.ConfigurationSettings.AppSettings["DocOpenPath"].ToString()+ dt.Rows[0]["photo_name"].ToString();
				}
			}			
		}

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

		}
		#endregion

		private void PutIn_sulution_Click(object sender, System.EventArgs e)
		{
			//提交分数
			if (txtgrade.Text.Trim()=="")
			{
                Response.Write("<script language=javascript>window.alert('分数不能为空！');</script>");
				return;
			}
			//判断是否是数字
			try
			{
				int i_grade=int.Parse(txtgrade.Text.Trim()); 
			}
			catch
			{
                Response.Write("<script language=javascript>window.alert('分数只能是数字！');</script>");
				return ;
			}
            //Response.Write("<script language=javascript>window.alert('验证通过！');</script>");
            //更新  doexercise_table的grade字段
			string guid=Request.QueryString["guid"];
			string str_sql=" update doexercise_table set grade="+txtgrade.Text.Trim()+" where guid='"+guid+"'";
			CommonInterface CIF=new CommonSql(str_conn_protected);  
			CIF.Execute(str_sql);
            
			Response.Write("<script language=javascript>window.alert('批改完成！');</script>");
		}

		private void LinkButton1_Click(object sender, System.EventArgs e)
		{
			//链接显示图片信息
			if (str_link!="")
			{
				Response.Write("<script>window.open('"+str_link+"');</script>"); 
			}
		}
	}
}