addcourse.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 addcourse : PageBase 
	{
		protected System.Web.UI.WebControls.TextBox txtKCDH;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.TextBox txtKCM;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
		protected System.Web.UI.WebControls.Button cmdOK;
		protected System.Web.UI.WebControls.DataGrid course_datagrid;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if (!Page.IsPostBack)
			{
				if (purview()&&(Request.Cookies["class_type"].Value.ToString()=="0"))
				{
					//有打开权限	
					//绑定DataGrid
     				string str_sql=" select * from course_Table where IsDelete='0' ";
					CommonInterface CIF=new CommonSql(str_conn_protected); 
					DataTable dt=CIF.ExeForDtl(str_sql); 
					course_datagrid.DataSource=dt;
                    course_datagrid.DataBind();
				}
				else
				{
					Response.Write("<script>window.top.location.href('../WebForm1.aspx'); </script>");
				}
			}
		}


		public void Page_Grid(Object sender, DataGridPageChangedEventArgs e) 
		{
			string str_sql = "select * from course_Table where IsDelete='0' ";	
			// Set CurrentPageIndex to the page the user clicked.
			course_datagrid.CurrentPageIndex = e.NewPageIndex;
			// Rebind the data. 
			CommonInterface CIF=new CommonSql(str_conn_protected); 
			DataTable dt=CIF.ExeForDtl(str_sql); 
			course_datagrid.DataSource = dt;
			course_datagrid.DataBind();
		}

		public void course_Edit(Object sender, DataGridCommandEventArgs e) 
		{
			string str_sql = "select * from course_Table where IsDelete='0' ";	


			course_datagrid.EditItemIndex = e.Item.ItemIndex;

			CommonInterface CIF=new CommonSql(str_conn_protected); 
			DataTable dt=CIF.ExeForDtl(str_sql); 

			course_datagrid.DataSource = dt;
			course_datagrid.DataBind();

		}

		public void course_Cancel(Object sender, DataGridCommandEventArgs e) 
		{

			string str_sql = "select * from course_Table where IsDelete='0' ";	
    		course_datagrid.EditItemIndex = -1;

			CommonInterface CIF=new CommonSql(str_conn_protected); 
			DataTable dt=CIF.ExeForDtl(str_sql); 


			course_datagrid.DataSource = dt;
			course_datagrid.DataBind();

		}


		public void course_Update(Object sender, DataGridCommandEventArgs e) 
		{
			//string str_ID = ((TextBox)e.Item.Cells[1].Controls[1]).Text;
			string str_Name = ((TextBox)e.Item.Cells[2].Controls[1]).Text;

		
			string sql_edit = "UPDATE course_Table " +
				"SET Name = '" + str_Name.Replace("'","''")+ "' " +				
				" WHERE guid = '" + e.Item.Cells[0].Text+"'";
           
			CommonInterface CIF=new CommonSql(str_conn_protected); 
            CIF.Execute(sql_edit); 


			

			string str_sql = "select * from course_Table where IsDelete='0' ";	
			course_datagrid.EditItemIndex = -1;

		
			DataTable dt=CIF.ExeForDtl(str_sql); 
			course_datagrid.DataSource = dt;
			course_datagrid.DataBind();

		}



		
		public void course_Delete(Object sender, DataGridCommandEventArgs e) 
		{
			
			//string str_ID = ((TextBox)e.Item.Cells[1].Controls[1]).Text;
			//string str_Name = ((TextBox)e.Item.Cells[2].Controls[1]).Text;

		
			//IsDelete =1 表示删除
			string sql_edit = "UPDATE course_Table " +
				"SET IsDelete = '1'" +				
				" WHERE guid = " + e.Item.Cells[0].Text;
           
			CommonInterface CIF=new CommonSql(str_conn_protected); 
			CIF.Execute(sql_edit); 



			string str_sql = "select * from course_Table where IsDelete='0' ";	
			course_datagrid.EditItemIndex = -1;

		
			DataTable dt=CIF.ExeForDtl(str_sql); 
			course_datagrid.DataSource = dt;
			course_datagrid.DataBind();

		}




		#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

		private void cmdOK_Click(object sender, System.EventArgs e)
		{
		    //保存课程
            //有效性判断
			if ((txtKCDH.Text.Trim()=="")||(txtKCM.Text.Trim()==""))
			{
                Alert("课程代号或者课程名称不能为空");
				return ;
			}
            string str_ID=txtKCDH.Text.Trim().Replace("'","''");  //课程代号
			if (exist_course(str_ID))
			{
				Alert("这个帐号已经存在,不能新增");
				return;
			}
			string str_guid=System.Guid.NewGuid().ToString();  
			string str_Name=txtKCM.Text.Trim().Replace("'","''"); 
            string str_sql="insert into course_Table(guid,ID,Name) ";
            str_sql+=" values (";
            str_sql+="'"+str_guid+"',";
            str_sql+="'"+str_ID+"',";
			str_sql+="'"+str_Name+"'";
            str_sql+=")";


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

			Alert("新增成功");



			string str_select = "select * from course_Table where IsDelete='0' ";	
			course_datagrid.EditItemIndex = -1;		
			DataTable dt=CIF.ExeForDtl(str_select); 
			course_datagrid.DataSource = dt;
			course_datagrid.DataBind();
		}

		/// <summary>
		/// 判断课程代号是否重复
		/// </summary>
		/// <param name="str_ID">课程代号</param>
		/// <returns>true 已经存在 false 不存在</returns>
		private bool exist_course(string str_ID)
		{
            string str_sql="select * from course_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;            
		}

	}
}