score.aspx.cs

毕业设计题目,学生成绩查询系统,包括管理员和普通用户两级管理

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;

namespace StudentScroeQuery.Admin
{
	/// <summary>
	/// Score 的摘要说明。
	/// </summary>
	public class Score : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.TextBox txtnum;
		protected System.Web.UI.WebControls.TextBox txtscore;
		protected System.Web.UI.WebControls.Label labmsg;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator3;
		protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator1;
		protected System.Web.UI.WebControls.RangeValidator RangeValidator1;
		protected System.Web.UI.WebControls.DropDownList drpcourse;
		protected System.Web.UI.WebControls.CustomValidator CustomValidator1;
		protected System.Web.UI.WebControls.Button button1;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if(!Page.IsPostBack)
			{
				binddrpscore();
			}
		}
		void binddrpscore()
		{
			
			this.drpcourse.DataTextField="Course_Name";
			this.drpcourse.DataValueField="Course_Id";
			this.drpcourse.DataSource=new BLL.score_bll().get_allcourse();
			this.drpcourse.DataBind();
			this.drpcourse.Items.Insert(0,"--选择课程--");
//			this.drpcourse.Items.Add("--选择课程--");
//			DataTable dtbl=new BLL.score_bll().get_allcourse().Tables[0];
//			foreach(DataRow row in dtbl.Rows)
//			{
//				ListItem item=new ListItem("--"+row["Course_name"].ToString()+"--",row["Course_id"].ToString());
//				this.drpcourse.Items.Add(item);
//			}
//			
			
			
			
		}

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

		}
		#endregion

		private void button1_Click(object sender, System.EventArgs e)
		{
			if(this.drpcourse.SelectedIndex==0)
			{
				Response.Write("<script>alert('请选择一门课程')</script>");
				return;
			}
			//判断该学生这门课的成绩是否已添加过了,暂无
			if(!new BLL.score_bll().ExistedCourse(Convert.ToInt32(this.txtnum.Text),Convert.ToInt32(this.drpcourse.SelectedValue)))
			{
				
				Response.Write("<script>alert('本门课程已经添加!')</script>");
				return;
			}
			

			if(Page.IsValid)
			{
				int stu_id=Convert.ToInt32(txtnum.Text);
				int cou_id=Int32.Parse(drpcourse.SelectedValue);
				int score=Convert.ToInt32(txtscore.Text);
				try
				{
					new BLL.score_bll().add_score(stu_id,cou_id,score);
					labmsg.Text="添加成功!";
					return;
				}
				catch(Exception ex)
				{
					labmsg.Text=ex.Message;

				}

			}
		}

		private void CustomValidator1_ServerValidate(object source, System.Web.UI.WebControls.ServerValidateEventArgs args)
		{
			int num=Convert.ToInt32(txtnum.Text);
			if(new BLL.score_bll().isExistnum(num))
			{
				args.IsValid=true;
			}
			else
			{
				args.IsValid=false;
			}
		}
	}
}