addexercise.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>
	/// 功能:添加习题
	/// 作者:
	/// 日期:2006-5-6
	/// </summary>
	public class addexercise : PageBase 
	{
		protected System.Web.UI.WebControls.DropDownList ddlKCDH;
		protected System.Web.UI.WebControls.CheckBox chkpic;
		protected System.Web.UI.WebControls.TextBox txtTM;
		protected System.Web.UI.WebControls.Button cmdOK;
		protected System.Web.UI.WebControls.Label message;
		protected System.Web.UI.HtmlControls.HtmlInputFile uploadnet;
		protected System.Web.UI.WebControls.TextBox txt_subject_name;
		protected System.Web.UI.WebControls.HyperLink HyperLink1;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if (!Page.IsPostBack)
			{
				if (purview()&&(Request.Cookies["class_type"].Value.ToString()=="0"))
				{
                    //绑定课程下拉列表
					HyperLink1.Text ="上传图片如下:";
					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,"--请选择--"); 



					txtTM.TextMode = TextBoxMode.MultiLine;
					txtTM.Rows  = 5;
					txtTM.Columns  = 50;
					txtTM.Attributes.Add("onKeyDown","textCounter(this,800);");
					txtTM.Attributes.Add("onKeyUp","textCounter(this,800);"); 

				}
				else
				{
					Response.Write("<script>window.top.location.href('../WebForm1.aspx'); </script>");
				}
			}
		}

	

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

		}
		#endregion

		private void chkpic_CheckedChanged(object sender, System.EventArgs e)
		{
			if (chkpic.Checked)
			{
				uploadnet.Disabled=false;
			}
			else
			{
                uploadnet.Disabled=true;
			}
		    //!chkpic.Checked;
		}


		/// <summary>
		/// 上传文件
		/// </summary>
		/// <returns>true 上传成功 false 上传失败</returns>
		private string  uploadfile() 
		{ 
			try 
			{ 				
				string uploadFileNet;   
    
				uploadFileNet=uploadnet.Value; 
				int i=uploadFileNet.LastIndexOf("\\"); 
				string NetFileName=uploadFileNet.Substring(i+1);    
				//string pullpathNET=Server.MapPath("/Teach_Manager")+@"\upload_file\"+NetFileName;
     
				int extendNet; 
				extendNet=NetFileName.LastIndexOf("."); 
//				extentXrf=XrfFileName.LastIndexOf("."); 
				string strextendNet; 
				strextendNet=NetFileName.Substring(extendNet+1); 


				string upload_filename=System.Guid.NewGuid().ToString();

				string pullpathNET=System.Configuration.ConfigurationSettings.AppSettings["DocPath"].ToString()+upload_filename;
                if (strextendNet.Trim()!="")
				{
                    pullpathNET+="."+strextendNet;
                    upload_filename+="."+strextendNet;
				}
					 

				//strextentXrf=XrfFileName.Substring(extentXrf+1); 
//				if ((strextendNet.ToUpper()=="")&&(strextentXrf.ToUpper()=="XRF")) 
				{ 
					uploadnet.PostedFile.SaveAs(pullpathNET); 
					//uploadxrf.PostedFile.SaveAs(pullpathXRF);
					
					return upload_filename; 
				} 
				
			
			} 
			catch (Exception exc) 
			{ 
				Response.Write(exc.Message); 
				return ""; 
			} 


		} 



		private void cmdOK_Click(object sender, System.EventArgs e)
		{
			//保存习题	
			string upload_filename="";
			if (uploadnet.Value.Trim()!="")
			{
				upload_filename=uploadfile();
				
				if (upload_filename!="")
				{                    
					//Alert("上传完成"+Request.Cookies["username_guid"].Value.ToString()); 
                    HyperLink1.Text ="上传图片如下:";
					HyperLink1.ImageUrl= System.Configuration.ConfigurationSettings.AppSettings["DocOpenPath"].ToString()+ upload_filename;
                    uploadnet.Disabled =true;	
				
					

				}
				else
				{
                    Alert("上传失败");
					return;
				}
				//保存数据到数据库
                

			}
			#region 保存习题
			string str_guid=System.Guid.NewGuid().ToString();
			string str_name=txt_subject_name.Text.Trim().Replace("'","''");   
			//课程Guid
			string str_course_guid=ddlKCDH.SelectedItem.Value;
			//上传照片名称
			string str_photo_name=upload_filename;
			//题目内容
			string str_content=txtTM.Text.Trim().Replace("'","''"); 
			//答案(这里答案为空)
			string str_solution="";
			//出题教师Guid
			string str_teacher_guid=Request.Cookies["username_guid"].Value.ToString();
					
			string str_sql=" insert into exercise_table(guid,Name,course_guid,photo_name,content,solution,teacher_guid) ";
			str_sql+=" values (";
			str_sql+="'"+str_guid+"',";
			str_sql+="'"+str_name+"',";
			str_sql+="'"+str_course_guid+"',";
			str_sql+="'"+str_photo_name+"',";
			str_sql+="'"+str_content+"',";
			str_sql+="'"+str_solution+"',";
			str_sql+="'"+str_teacher_guid+"'";
			str_sql+=")";
                    

					
			CommonInterface CIF=new CommonSql(str_conn_protected);  
			CIF.Execute(str_sql);

			Alert("新增成功");


			#endregion


			
		}
	}
}