inputteacherinfo.aspx.cs

来自「一个办公管理系统完整版」· CS 代码 · 共 145 行

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 System.Data.SqlClient;

namespace OfficeSys.admin
{
	/// <summary>
	/// inputTeacherInfo 的摘要说明。
	/// </summary>
	public class inputTeacherInfo : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.TextBox UserName;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.TextBox PassWord;
		protected System.Web.UI.WebControls.Label Label3;
		protected System.Web.UI.WebControls.DropDownList DropDownList1;
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Web.UI.WebControls.Label Message;
		protected System.Web.UI.WebControls.Label Label4;
		protected System.Web.UI.WebControls.DropDownList DropDownList2;
		protected System.Web.UI.WebControls.Button Button2;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
		protected System.Web.UI.WebControls.Label Label5;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if(Session["id"]==null)
			{
				Response.Redirect("../login.aspx");
			}
			
			Class.DataProcess  dataProcess=new Class.DataProcess( );
			//分配权限信息
			string strSql1="select * from 权限表";
			
			//显示还未分配登陆帐号的教师信息
			string strSql2="select 教师信息表.教师名,教师信息表.教师号 from 教师信息表,用户信息表 where 教师信息表.教师号!=用户信息表.教师号";
			SqlDataReader reader=dataProcess.ExecuteReader(strSql1);
			
			if(!Page.IsPostBack)
			{  this.DropDownList1.Items.Add(new ListItem("请选择","请选择"));
				while(reader.Read())
				{  						
					this.DropDownList1.Items.Add(new ListItem(reader.GetString(1).ToString( ).Trim( ),reader.GetString(0).ToString( ).Trim( )));
					
				}	

			}
			reader=dataProcess.ExecuteReader(strSql2);
			
			if(!Page.IsPostBack)
			{this.DropDownList2.Items.Add(new ListItem("请选择","请选择"));
				while(reader.Read( ))
				{
					this.DropDownList2.Items.Add(new ListItem(reader.GetString(0).ToString().Trim(),reader.GetString(1).ToString().Trim()));
				}
			}
			reader.Close( );
		}

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

		}
		#endregion

		private void Button1_Click(object sender, System.EventArgs e)
		{
			Class.DataProcess  dataProcess=new Class.DataProcess( );
			string strSql1="select 用户名 from 用户信息表 where 用户名='"+this.UserName.Text.ToString().Trim( )+"'";
			SqlDataReader reader=dataProcess.ExecuteReader(strSql1);
			if(this.DropDownList1.SelectedValue.Trim( )=="请选择")
			{
			}
			else
			{
				if(this.DropDownList2.SelectedValue.Trim( )=="请选择")
				{

				}
				else
				{
					if(reader.Read())
					{
						this.Message.Text="这个用户已经存在，请重新输入";	
					}
					else
					{   				
						string strSql2="insert into 用户信息表(用户名,密码,教师号,权限号) values('"+this.UserName.Text+"','"+this.PassWord.Text+"','"+this.DropDownList2.SelectedValue+"','"+this.DropDownList1.SelectedValue+"')";
						if(dataProcess.ExecuteNonQuery(strSql2)!=0)
						{
							this.Message.Text="成功录入这个用户";
						}
						else
						{
							this.Message.Text="用户信息录入不成功";
						}	 
					}
				}
			}
			reader.Close( );
		}

		private void Button2_Click(object sender, System.EventArgs e)
		{
			this.UserName.Text="";
			this.PassWord.Text="";
		}

		private void DropDownList2_SelectedIndexChanged(object sender, System.EventArgs e)
		{
		
		}
	}
}