register.aspx.cs

网络学生家教招聘系统.使用ASP.NET环境+C#开发。功能完备。代码扩展方便。

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
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.Configuration;

namespace PeopleInfo
{
	/// <summary>
	/// Register 的摘要说明。
	/// </summary>
	public class Register : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.TextBox Name;
		protected System.Web.UI.WebControls.TextBox Class;
		protected System.Web.UI.WebControls.ListBox sex;
		protected System.Web.UI.WebControls.TextBox PhoneNumber;
		protected System.Web.UI.WebControls.TextBox NativePlace;
		protected System.Web.UI.WebControls.TextBox Dormitory;
		protected System.Web.UI.WebControls.ListBox IsPoor;
		protected System.Web.UI.WebControls.ListBox HavePosition;
		protected System.Web.UI.WebControls.ListBox HaveExperiment;
		protected System.Web.UI.WebControls.RadioButtonList Course;
		protected System.Web.UI.WebControls.CheckBoxList GuoJi;
		protected System.Web.UI.WebControls.CheckBoxList Senior;
		protected System.Web.UI.WebControls.CheckBoxList University;
		protected System.Web.UI.WebControls.CheckBoxList Computer;
		protected System.Web.UI.WebControls.CheckBoxList ForeignLanguage;
		protected System.Web.UI.WebControls.TextBox SelfIntroduction;
		protected System.Web.UI.WebControls.TextBox PrizeStatement;
		protected System.Web.UI.WebControls.Button Submit;
		protected System.Web.UI.WebControls.RequiredFieldValidator rvClass;
		protected System.Web.UI.WebControls.RequiredFieldValidator rvNativePlace;
		protected System.Web.UI.WebControls.RequiredFieldValidator rvName;
		protected System.Web.UI.WebControls.RequiredFieldValidator rvPhoneNumber;
		protected System.Web.UI.WebControls.RequiredFieldValidator rvDormitory;
		protected System.Web.UI.WebControls.RequiredFieldValidator rvGradeAndJunior;
		protected System.Web.UI.WebControls.RequiredFieldValidator rvSenior;
		protected System.Web.UI.WebControls.RequiredFieldValidator rvUniversity;
		protected System.Web.UI.WebControls.RequiredFieldValidator rvComputer;
		protected System.Web.UI.WebControls.RequiredFieldValidator rvForeignLanguage;
		protected System.Web.UI.WebControls.RequiredFieldValidator rvSelfIntroduction;
		protected System.Web.UI.WebControls.RequiredFieldValidator rvCourse;
		protected System.Web.UI.WebControls.CheckBox IsUndergraduate;
		protected System.Web.UI.WebControls.CheckBoxList GradeAndJunior;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
		}

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

		}
		#endregion

		private void Submit_Click(object sender, System.EventArgs e)
		{
			string sqlcmdtext;//="SELECT MAX(*) FROM RegisterPerson";//"INSERT INTO RegisterPerson (ID,Name,Class,IsUndergraduate,sex,PhoneNumber,NativePlace,Dormitory,IsPoor,HavePosition,HaveEXP,Course,PassCET4,PassCET6,PassComputer2,PassComputer3,GoodAt,Introduction,Encouragement)VALUES(";
			int iCount;
			string strGoodAt="";
			foreach(ListItem item in GradeAndJunior.Items)
			{
				strGoodAt+=(item.Selected)?"1":"0";
			}

			
			foreach(ListItem item in Senior.Items)
			{
				strGoodAt+=(item.Selected)?"1":"0";
			}

			
			foreach(ListItem item in University.Items)
			{
				strGoodAt+=(item.Selected)?"1":"0";
			}

			
			foreach(ListItem item in Computer.Items)
			{
				strGoodAt+=(item.Selected)?"1":"0";
			}

			
			foreach(ListItem item in ForeignLanguage.Items)
			{
				strGoodAt+=(item.Selected)?"1":"0";
			}
			sqlcmdtext="INSERT INTO RegisterPerson (ID,Name,Class,IsUndergraduate,sex,PhoneNumber,NativePlace,Dormitory,IsPoor,HavePosition,HaveEXP,Course,PassCET4,PassCET6,PassComputer2,PassComputer3,GoodAt,Introduction,Encouragement)VALUES(";
			SqlConnection sqlconn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings.GetValues("ConnString")[0]);
			sqlconn.Open();
			SqlCommand cmd=new SqlCommand("SELECT MAX(ID) FROM RegisterPerson",sqlconn);
			iCount=(int)cmd.ExecuteScalar()+1;
			sqlcmdtext+=iCount.ToString()+",'"+Name.Text+"','"+Class.Text+"',"+(IsUndergraduate.Checked==true?"'T','":"'F','")+sex.SelectedItem.Value+"','"+PhoneNumber.Text+"','"+NativePlace.Text+"','"+Dormitory.Text+"','"+IsPoor.SelectedItem.Value+"','"+HavePosition.SelectedItem.Value+"','"+HaveExperiment.SelectedItem.Value+"',"+Course.SelectedItem.Value.ToString()+","+(GuoJi.Items[0].Selected?"'T'":"'F'")+","+(GuoJi.Items[1].Selected?"'T'":"'F'")+","+(GuoJi.Items[2].Selected?"'T'":"'F'")+","+(GuoJi.Items[3].Selected?"'T'":"'F'")+",'"+strGoodAt+"','"+SelfIntroduction.Text+"','"+PrizeStatement.Text+"')";
			cmd.CommandText=sqlcmdtext;
			cmd.ExecuteNonQuery();
			sqlconn.Close();
			Response.Redirect(Server.UrlPathEncode("Result.aspx?Succeed=true&URL=Index.aspx&Message=操作成功"));
			//Response.Write(iCount.ToString()+"<br>"+sqlcmdtext);
		}
	}
}