addplan.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-05-06
	/// </summary>
	public class addplan : PageBase
	{
		protected System.Web.UI.WebControls.DropDownList ddlkcdh;
		protected System.Web.UI.WebControls.DropDownList ddlBJ;
		protected System.Web.UI.WebControls.DropDownList ddljsxm;
		protected System.Web.UI.WebControls.DataGrid coursearrange_datagrid;
		protected System.Web.UI.WebControls.Button cmdOK;
	


		/// <summary>
		/// 绑定课程,班级,教师
		/// </summary>
		private void BindDataList()
		{
			//绑定班级
			string str_sql=" select guid,Name from class_table where IsDelete='0' ";
			//str_conn
			
			CommonInterface CIF=new CommonSql(str_conn_protected);  
			
			ddlBJ.DataSource=CIF.ExeForDtl(str_sql);
			ddlBJ.DataTextField="Name";
			ddlBJ.DataValueField="guid";
			ddlBJ.DataBind();
			ddlBJ.Items.Insert(0,"--请选择--"); 


			//select guid,Name from course_Table where IsDelete='0' 课程表
			//select guid ,Name from teacher_table where IsDelete='0' 教师表
            str_sql="select guid,Name from course_Table where IsDelete='0'";
			ddlkcdh.DataSource=CIF.ExeForDtl(str_sql);
			ddlkcdh.DataTextField="Name";
			ddlkcdh.DataValueField="guid";
			ddlkcdh.DataBind();
			ddlkcdh.Items.Insert(0,"--请选择--"); 

            
			str_sql="select guid ,Name from teacher_table where IsDelete='0'";
			ddljsxm.DataSource=CIF.ExeForDtl(str_sql);
			ddljsxm.DataTextField="Name";
			ddljsxm.DataValueField="guid";
			ddljsxm.DataBind();
			ddljsxm.Items.Insert(0,"--请选择--"); 

			//绑定DataGrid
            
			str_sql=" select guid,teacher_table_name,course_Table_name,class_table_name from view_courseplan where IsDelete='0' ";
			DataTable dt=CIF.ExeForDtl(str_sql); 
			coursearrange_datagrid.DataSource=dt;
			coursearrange_datagrid.DataBind();
			CIF.Close();            

		}
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if (!Page.IsPostBack)
			{
				if (purview()&&(Request.Cookies["class_type"].Value.ToString()=="0"))
				{
					//绑定课程,班级,教师
                    BindDataList();

				}
				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>
		/// <returns>true 可以保存 false 不能保存</returns>
		private bool effective_check()
		{
			
            
			if (ddlkcdh.SelectedItem.Text=="--请选择--")
			{
				Alert("请选择课程");
				return false;			
			}

			if (ddlBJ.SelectedItem.Text=="--请选择--")
			{
				Alert("请选择班级");
				return false;			
			}

			if (ddljsxm.SelectedItem.Text=="--请选择--")
			{
				Alert("请选择教师");
				return false;			
			}

			return true;


		}

		/// <summary>
		/// 分页
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		public void Page_Grid(Object sender, DataGridPageChangedEventArgs e) 
		{
			string str_sql = "select guid,teacher_table_name,course_Table_name,class_table_name from view_courseplan where IsDelete='0' ";
	    	// Set CurrentPageIndex to the page the user clicked.
			coursearrange_datagrid.CurrentPageIndex = e.NewPageIndex;
			// Rebind the data. 
			CommonInterface CIF=new CommonSql(str_conn_protected); 
			DataTable dt=CIF.ExeForDtl(str_sql); 
			coursearrange_datagrid.DataSource = dt;
			coursearrange_datagrid.DataBind();
		}

		/// <summary>
		/// 删除课程安排
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		public void coursearrang_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 coursearrange_table " +
				"SET IsDelete = '1'" +				
				" WHERE guid = '" + e.Item.Cells[1].Text+"'";
           
			CommonInterface CIF=new CommonSql(str_conn_protected); 
			CIF.Execute(sql_edit); 



			string str_sql = "select guid,teacher_table_name,course_Table_name,class_table_name from view_courseplan where IsDelete='0' ";	
			coursearrange_datagrid.EditItemIndex = -1;		
			DataTable dt=CIF.ExeForDtl(str_sql); 
			coursearrange_datagrid.DataSource = dt;
			coursearrange_datagrid.DataBind();

		}

		private void cmdOK_Click(object sender, System.EventArgs e)
		{
			//新增课程安排 课程,班级,教师
			if (effective_check())
			{
				//可以保存
				string str_guid=System.Guid.NewGuid().ToString();
				string str_course_guid=ddlkcdh.SelectedItem.Value;
                string str_class_guid=ddlBJ.SelectedItem.Value;
				string str_teacher_guid=ddljsxm.SelectedItem.Value;
                
				string str_sql="insert into coursearrange_table(guid,class_guid,course_guid,teacher_guid) ";
				str_sql+=" values (";
                str_sql+="'"+str_guid+"',";
				str_sql+="'"+str_class_guid+"',";
				str_sql+="'"+str_course_guid+"',";
				str_sql+="'"+str_teacher_guid+"'";
                str_sql+=")";
                
				CommonInterface CIF=new CommonSql(str_conn_protected);  
				CIF.Execute(str_sql);


				str_sql = "select guid,teacher_table_name,course_Table_name,class_table_name from view_courseplan where IsDelete='0' ";	
				coursearrange_datagrid.EditItemIndex = -1;		
				DataTable dt=CIF.ExeForDtl(str_sql); 
				coursearrange_datagrid.DataSource = dt;
				coursearrange_datagrid.DataBind();


				Alert("新增成功");
			}
			else
			{
				return;
			}
 
		}
	}
}