addstudent.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 addstudent : PageBase
	{
		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.DropDownList xb;
		protected System.Web.UI.WebControls.DropDownList bj;
		protected System.Web.UI.WebControls.TextBox xy;
		protected System.Web.UI.WebControls.Button cmdOK;
		protected System.Web.UI.WebControls.TextBox xh;
	
		//static string str_conn="";//数据库连接字串
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			//页面加载时判断是否有权限 判断3个Cookie的值
			if (!Page.IsPostBack)
			{
				if (purview()&&(Request.Cookies["class_type"].Value.ToString()=="0"))
				{
					//有打开权限
                    Bind_bj();
				}
				else
				{
					Response.Write("<script>window.top.location.href('../WebForm1.aspx'); </script>");
				}
			}
		}

		private void Bind_bj()
		{
			//绑定班级
			string str_sql=" select guid,Name from class_table where IsDelete='0' ";
			//str_conn
			
            CommonInterface CIF=new CommonSql(str_conn_protected);  
            bj.DataSource=CIF.ExeForDtl(str_sql);
			bj.DataTextField="Name";
			bj.DataValueField="guid";
			bj.DataBind();
            bj.Items.Insert(0,"--请选择--"); 
            CIF.Close();            
		}
		#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>
		/// 根据str_ID学号判断学生是否存在
		/// </summary>
		/// <param name="str_ID">学号</param>
		/// <returns>true 存在 false 不存在</returns>
		private bool exist_strudent(string str_ID)
		{
            string str_sql=" select * from student_table where IsDelete='0' and ID='"+str_ID+"' ";
            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=xh.Text.Trim().Replace("'","''") ;//学号不能重复
			if (exist_strudent(str_ID)) 
			{
				Alert("这个学号已经存在,不能新增");
				return;
			}
			else
			{
				string str_guid=System.Guid.NewGuid().ToString();  
                string str_name=xm.Text.Trim().Replace("'","''");  //学生姓名
                string str_sex=xb.SelectedIndex.ToString();//学生性别
				string str_bj="";//班级
				if (bj.SelectedItem.Text!="--请选择--")
				{
                    str_bj=bj.SelectedItem.Value ; 
				}
				else
				{
                    str_bj="";
				}
				string str_xy=xy.Text.Trim().Replace("'","''");//学院
                string str_password=str_ID;//初始化密码为学生ID
                string str_sql="insert into student_table(guid,ID,Name,Sex,Class_Guid,College,Password)";  
                str_sql+=" values ("+"'"+str_guid+"' ,";
                str_sql+=" '"+str_ID+"',";
                str_sql+=" '"+str_name+"',";
                str_sql+=" '"+str_sex+"',";
				str_sql+=" '"+str_bj+"',";
                str_sql+=" '"+str_xy+"',";
                str_sql+=" '"+str_ID+"'";
                str_sql+=")";
				CommonInterface CIF=new CommonSql(str_conn_protected);  
				CIF.Execute(str_sql);

				Alert("新增成功");

			}
		}
	}
}