web管理系统课程设计

{
Label7.Text = "当前时间是：" + DateTime.Now.ToString() ;
}
protected void Button1_Click(object sender, EventArgs e)
{
if (rbtstudent.Checked == false && rbtteacher.Checked == false)
湖北第二师范学院
《Web程序设计》
课程设计报告书
班级：12级计算机应用技术（1）班
学号：
姓名：
指导老师：王海军
成绩：
设计时间：2014年6月12日
简单的
一.登录页面：
登录页面的设计与代码：
主要以不同的角色进去就会跳进不同的页面就会有不同的权限
源代码：
后台代码：
using System;
using System.Data;
{
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
}
protected void Button3_Click1(object sender, EventArgs e)
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
Response.Redirect("teachers/教师主页.aspx");
// Response.Write("<script>alert('登陆成功！')</script>");
}
else
{
Response.Write("<script>alert('你输入的用户名、角色或密码错误!请重新输入！')</script>");
}
protected void rbtstudent_CheckedChanged(object sender, EventArgs e)
{
}}
二.教师主页的设计与代码：
后台代码：主要是用Response.Redirect("")语句实现跳转到各个页面;还有用session传值显示当前登录者“欢迎xx老师”。
Session["stdmm"] = dr["stdmm"];
Session["stdxb"]=dr["stdxb"];
Session["stdsfz"] = dr["stdsfz"];
Session["stdrxsj"] = dr["stdrxsj"];
Session["stdbj"] = dr["stdbj"];
// Label4.Text = "wenku.baidu.com户名或密码不正当确，请重新输入";
con.Close();
}
}
if (rbtteacher.Checked==true)
{
SqlConnection con = new SqlConnection("server=.;database=school;integrated security=SSPI");
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
Session["thId"]=dr[0];
Session["thMm"] = dr["thMm"];
Session["thXm"] = dr["thXm"];
Session["thXb"]=dr["thXb"];
Session["thSfzh"]=dr["thSfzh"];
Session["thJsnl"]=dr["thJsnl"];
Session["thSzyx"]=dr["thSzyx"];
userpwd.Text = Session["thMm"].ToString();
username.Text = Session["thId"].ToString();
}
//添加新学生
protected void Button3_Click(object sender, EventArgs e)
{
}
protected void Button2_Click(object sender, EventArgs e)
{
Response.Redirect("teachmain.aspx");
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "select * from student where stdid='" + username.Text + "'and stdmm='" + userpwd.Text + "'";
{
SqlConnection con = new SqlConnection("server=.;database=school;integrated security=SSPI");
//con.Open();
string strsql = "select count(*) from [student] where stdid='" + TextBox10.Text.Trim() + "'";
Label4.Text = "登陆成功";
username.Text = "";//userID为textbox1
username.Enabled = false;
userpwd.Text = "";//userPWD为textbox2
userpwd.Enabled = false;
dr.Close();
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["thMm"] == null || Session["thMm"].ToString().Length == 0) Response.Redirect("~/login.aspx");
// Label4.Text = "用户名或密码不正当确，请重新输入";
con.Close();
}
}
}
}
protected void Button2_Click(object sender, EventArgs e)
{
username.Text = "";
userpwd.Text = "";
Response.Redirect("login.aspx");
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
//cmd.CommandText = "select * from achievement where stdid='" + username.Text + "'";
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
Session["stdid"] = dr[0];
Label4.Text = "登陆成功";
username.Text = "";//userID为textbox1
username.Enabled = false;
userpwd.Text = "";//userPWD为textbox2
userpwd.Enabled = false;
dr.Close();
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "select * from teachers where thId='" + username.Text + "'and thmm='" + userpwd.Text + "'";
string shenfen = TextBox2.Text.Trim();
string ruxuesj = TextBox3.Text.Trim();
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Data.Sql;
using System.Data.SqlTypes;
public partial class techers_gradeinput : System.Web.UI.Page
}
else
{
string userid = TextBox10.Text.Trim();
string password = TextBox11.Text.Trim();
string name = TextBox13.Text.Trim();
string sex = DropDownList1.Text.Trim();
（1）.学生信息管理（教师角色）：
主要用的是GridView控件实现学生信息查看与编辑，首先把GridViewde的属性Visible=False把GridView控件隐藏，当点击“学生信息管理”的按钮的时候就能看到学生的信息与管理。
（2）.添加新生信息（教师角色）：
源代码：
后台代码：
using System.Data;
{
Response.Write("<script>alert('请选择你的登录身份！')</script>");
}
else
{
if ( rbtstudent.Checked == true)
{
SqlConnection con = new SqlConnection("server=.;database=school;integrated security=SSPI");
Response.Redirect("students/学生主页.aspx");
// Response.Write("<script>alert('登陆成功！')</script>");
}
else
{
Response.Write("<script>alert('你输入的用户名、角色或密码错误!请重新输入')</script>");
Session["stddz"] = dr["stddz"];
Session["stddh"] = dr["stddh"];
Session["stdxm"] = dr["stdxm"];
username.Text= Session["stdid"].ToString();
userpwd.Text= Session["stdmm"].ToString();
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class login1 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
}
protected void Button4_Click(object sender, EventArgs e)
{
Response.Redirect("gradeinput.aspx");
}
protected void FormView1_PageIndexChanging(object sender, FormViewPageEventArgs e)
SqlCommand com = new SqlCommand(strsql, con);
con.Open();
int num = (int)com.ExecuteScalar();
if (num > 0)
{
Response.Write("<script>alert('该账号已经存在！')</script>");