addteacher.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>
	/// addteacher 的摘要说明。
	/// </summary>
	public class addteacher : PageBase 
	{
		protected System.Web.UI.WebControls.TextBox zh;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.TextBox xm;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
		protected System.Web.UI.WebControls.Button cmdOK;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if (!Page.IsPostBack)
			{
				if (purview()&&(Request.Cookies["class_type"].Value.ToString()=="0"))
				{

				}
				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.cmdOK.Click += new System.EventHandler(this.cmdOK_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion
		/// <summary>
		/// 判断教师帐号是否已经存在
		/// </summary>
		/// <param name="str_ID">帐号</param>
		/// <returns>true 存在这个教师帐号 fasle 不存在这个教师帐号</returns>
		private bool exist_teacher(string str_ID)
		{
            //select * from teacher_table where ID='1' and Password='1' 
			string str_sql="select * from teacher_table where IsDelete='0' and ID='"+zh.Text.Trim().Replace("'","''")+"'";
			
			CommonInterface CIF=new CommonSql(str_conn_protected);  
			DataTable dt=CIF.ExeForDtl(str_sql); 
			if (dt.Rows.Count>0)
			{
				//这个学号已经存在
				return true;
			}
			else
			{
				//这个学号不存在
			}
			return false;
		}
		
		private void cmdOK_Click(object sender, System.EventArgs e)
		{
			//新增教师
            string str_ID=zh.Text.Trim().Replace("'","''");  
			if (exist_teacher(str_ID))
			{
				Alert("这个帐号已经存在,不能新增");
				return;
			}
			else
			{
                string str_guid=System.Guid.NewGuid().ToString();  				
				string str_Name=xm.Text.Trim().Replace("'","''");  
                string str_password=str_ID;//帐号与密码相同
				string str_sql="insert into teacher_table(guid,ID,Name,Password) ";
                str_sql+="values (";
                str_sql+="'"+str_guid+"',";
                str_sql+="'"+str_ID+"',";
                str_sql+="'"+str_Name+"',";
                str_sql+="'"+str_password+"'";
                str_sql+=")";

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

				Alert("新增成功");
			}

		}
	}
}