学生信息标准管理系统源代码.doc

系统源代码
一、登录界面代码
using System;
using System.Data;
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;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class login : System.Web.UI.Page
{
protected void txtid_Click(object sender, EventArgs e)
{
txtid.Text = "";
txtpassword.Text = "";
}
protected void Button1_Click(object sender, EventArgs e)
{
string strconn = ConfigurationManager.AppSettings["connStr"];
SqlConnection conn = new SqlConnection(strconn);
conn.Open();
DataSet ds=new DataSet () ;
SqlDataAdapter da = new SqlDataAdapter("select * from users where userid='" + txtid.Text + "' and userpwd='" + txtpassword.Text + "'", conn);
da.Fill(ds);
if (ds.Tables[0].Rows.Count==0)
{
Label3 .Text ="账号或密码错误，请重新输入！";
}
else
{
Session ["userid"]=txtid .Text ;
Session["userpwd"] = txtpassword.Text;
Session["username"] = ds.Tables[0].Rows[0]["username"].ToString();
Session["userpower"] = ds.Tables[0].Rows[0]["userpower"].ToString();
if (Session["userpower"].ToString () == "0")
{
Response.Redirect("admin/index.aspx");
}
else if (Session["userpower"].ToString() == "1")
{
Response.Redirect("student/index.aspx");
}
else
{
Label3.Text = "对不起，权限验证失败";
}
}
conn.Close();
ds.Clear ();
}
}

二、添加课程页面代码
using System;
using System.Data;
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;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class addcourse : System.Web.UI.Page
{
SqlCommand mycmd;
SqlConnection conn;
protected void Page_Load(object sender, EventArgs e)
{
courseid.Attributes.Add("onblur", "checkcourseid()");
string strconn = ConfigurationManager.AppSettings["connStr"];
conn = new SqlConnection(strconn);
}
protected void Button1_Click(object sender, EventArgs e)
{
if (courseid.Text.ToString() == "")
{
Label7.Text = "课程号不能为空";
}
else
{
string sqlstr = "";
sqlstr = "insert into course(courseid,coursename,coursetime,fen,type,teacher)values('" + courseid.Text + "','" + coursename.Text + "','" + coursetime.Text + "','" + fen.Text + "','" + type.Text + "','" + teacher.Text + "')";
conn.Open();
mycmd = new SqlCommand(sqlstr, conn);
mycmd.Dispose();
try
{
mycmd.ExecuteNonQuery();
Response.Write("<script>javascript:alert('添加成功!!!');</script>");
}
catch (SqlException)
{
Response.Write("<script>javascript:alert('添加失败!!!');</script>");
}
finally
{
conn.Close();
sqlstr = "";
}
}
}
protected void Button2_Click(object sender, EventArgs e)
{
courseid.Text = "";
coursename.Text = "";
coursetime.Text = "";
fen.Text = "";
type.Text = "";
}
protected void Button3_Click(object sender, EventArgs e)
{
Response.Redirect("course.aspx");
}
}

三、添加成绩程序代码
using System;
using System.Data;
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;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class addscore : System.Web.UI.Page
{
SqlCommand mycmd;
SqlConnection conn;
protected void Page_Load(object sender, EventArgs e)
{
string strconn = ConfigurationManager.AppSettings["connStr"];
conn = new SqlConnection(strconn);
}
protected void Button1_Click(object sender, EventArgs e)
{
if (userid.SelectedValue .ToString ()== "")
{
Label11.Text = "学号不能为空";
}
else
{
string sqlstr = "";
sqlstr = "insert into score(userid,username,courseid,coursename,score,[year])values('" + userid.SelectedValue + "','" + username.Text + "','" + txtcourseid.SelectedValue + "','" + coursename.Text + "','" + score.Text + "','" + txtyear.SelectedValue + "')";
conn.Open();
mycmd = new SqlCommand(sqlstr, conn);
mycmd.Dispose();
try
{
mycmd.ExecuteNonQuery();
Response.Write("<script>javascript:alert('添加成功!!!');</script>");
}
catch (SqlException)
{
Response.Write("<script>javascript:alert('添加失败!!!');</script>");
}
finally
{
conn.Close();
sqlstr = "";
}
}
}
protected void Button2_Click(object sender, EventArgs e)
{
username.Text = "";
coursename.Text = "";
score.Text = "";
txtyear.Text = "";
}
protected void Button3_Click(object sender, EventArgs e)
{
Response.Redirect("score.aspx");
}
protected void userid_SelectedIndexChanged(object sender, EventArgs e)
{
string sqlstr = "";
sqlstr = "select username from students where userid='" + userid.SelectedValue + "'";
conn.Open();
mycmd = new SqlCommand(sqlstr, conn);
mycmd.Dispose();
SqlDataReader da;
da = mycmd.ExecuteReader();
while (da.Read())
{
username.Text = da["username"].ToString();
}
}
protected void txtcourseid_SelectedIndexChanged(object sender, EventArgs e)
{
string sqlstr = "";
sqlstr = "select coursename from course where courseid='" + txtcourseid.SelectedValue + "'";
conn.Open();
mycmd = new SqlCommand(sqlstr, conn);
mycmd.Dispose();
SqlDataReader da;
da = mycmd.ExecuteReader();
while (da.Read())
{
coursename.Text = da["coursename"].ToString();
}
}
}

四、添加学生程序代码
using System;
using System.IO;
using System.Text;
using System.Data;
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;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class addstudent : System.Web.UI.Page
{
SqlCommand mycmd;
protected void Page_Load(object sender, EventArgs e)
{
userid.Attributes.Add("onblur", "checkuserid()");
string strconn = ConfigurationManager.AppSettings["connStr"];
SqlConnection conn = new SqlConnection(strconn);
}
protected void Button1_Click(object sender, EventArgs e)
{
if (userid.Text.ToString() == "")
return;
string strconn = ConfigurationManager.AppSettings["connStr"];
SqlConnection conn = new SqlConnection(strconn);
string sqlstr = "";
string sql = "";
sqlstr = "insert into students(userid,username,sex,minzu,birthday,class,comefrom,beizhu,xuey,zhuany,tel,idc,zhengzmm,zhiw,huoj,weij)values('" + userid.Text + "','" + txtusername.Text + "','" + txtsex.SelectedItem.Value + "','" + txtminzu.Text + "','" + txtbirthday.Text + "','" + txtclass.Text + "','" + txtcomefrom.Text + "','" + txtbeizhu.Text + "','" + txtxuey.SelectedValue + "','" + txtzhuany.SelectedValue + "','" + txttel.Text + "','" + txtidc.Text + "','" + txtzzmm.SelectedValue + "','" + txtzhiw.Text + "','" + txthuoj.Text + "','" + txtweij.Text + "')";
conn.Open();
mycmd = new SqlCommand(sqlstr, conn);
mycmd.Dispose();
string name = this.FileUpload1.FileName;//获取上传文件名称
string type = name.Substring(name.LastIndexOf("\\") + 1);//获取上传文件后缀
string ipath = Server.MapPath("images/") + DateTime.Now.ToString("yyyyMMddhhmmss") + name;
string wpath = "images\\" + DateTime.Now.ToString("yyyyMMddhhmmss") + name;
string query1 = "insert into images(userid,path) values('" + userid.Text + "',@path)";
FileUpload1.SaveAs(ipath); //服务器保留路径
SqlCommand cm = new SqlCommand(query1);
cm.Connection = conn;
cm.Parameters.Add("@path", SqlDbType.VarChar, 50);
cm.Parameters["@path"].Value = wpath;
cm.ExecuteNonQuery();
// this.lb_info.Text = "上传成功！";
try
{
mycmd.ExecuteNonQuery();
string sqlstr1 = "";
sqlstr1 = "insert into users(userid,username)values('" + userid.Text + "','" + txtusername.Text + "') ";
SqlCommand mycmd1 = new SqlCommand(sqlstr1, conn);
mycmd1.Dispose();
try
{
mycmd1.ExecuteNonQuery();
Response.Write("<script>javascript:alert('添加成功!!!');</script>");
}
catch (SqlException)
{
Response.Write("<script>javascript:alert('添加失败!!!');</script>");
}
finally
{
sqlstr1 = "";
}
}
catch (SqlException)
{
Response.Write("<script>javascript:alert('添加失败!!!');</script>");
}
finally
{
conn.Close();
sqlstr = "";
}
}
protected void Button2_Click(object sender, EventArgs e)
{
userid.Text = "";
txtusername.Text = "";
txtminzu.Text = "";
txtbirthday.Text = "";
txtclass.Text = "";
txtcomefrom.Text = "";
txtbeizhu.Text = "";
}
protected void Button3_Click(object sender, EventArgs e)
{
Response.Redirect("student.aspx");
}
}

五、检验课程号唯一性程序代码
using System;
using System.Data;
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;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class checkcourseid : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
Response.Expires = 0;
string strconn = ConfigurationManager.AppSettings["connStr"];
SqlConnection conn = new SqlConnection(strconn);
string nam = Request.QueryString["name"].ToString();
string sql = "select courseid from course where courseid='" + nam + "'";
SqlCommand DBHelper;
DBHelper = new SqlCommand(sql, conn);
conn.Open();
SqlDataReader dr = DBHelper.ExecuteReader();
if (dr.Read())
{
Response.Write("<b class='Error'>该课程号已经存在，请换一个</b>");
}
else
{
Response.Write("<b class='Right'>该课程号能够使用</b>");
}
dr.Close();
}
}

六、检验学号唯一性程序代码
using System;
using System.Data;
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;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class checkuser : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
Response.Expires = 0;
string strconn = ConfigurationManager.AppSettings["connStr"];
SqlConnection conn = new SqlConnection(strconn);
string nam = Request.QueryString["name"].ToString();
string sql = "select userid from students where userid='" + nam + "'";
SqlCommand DBHelper;
DBHelper = new SqlCommand(sql, conn);
conn.Open();
SqlDataReader dr = DBHelper.ExecuteReader();
if (dr.Read())
{
Response.Write("<b class='Error'>该学号已经存在，请换一个</b>");
}
else
{
Response.Write("<b class='Right'>该学号能够使用</b>");
}
dr.Close();
}
}

七、课程信息程序代码
using System;
using System.Data;
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;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class course : System.Web.UI.Page
{
SqlConnection conn;
SqlDataReader getdata;
protected void Page_Load(object sender, EventArgs e)
{
string strconn = ConfigurationManager.AppSettings["connStr"];
conn = new SqlConnection(strconn);
SqlDataReader getdata;
SqlCommand mycmd;
DataSet ds = new DataSet();
string sql = "";
sql = "select * from course order by courseid";
mycmd = new SqlCommand(sql, conn);
conn.Open();
getdata = mycmd.ExecuteReader();
grdMain.DataSource = getdata;
grdMain.DataBind();
mycmd.Connection.Close();
conn.Close();
mycmd.Dispose();
}
protected void Button1_Click(object sender, EventArgs e)
{
DataSet ds;
SqlDataReader da;
string strsql = "";
SqlCommand cmd;
conn.Open();
strsql = "select * from course where courseid='" + courseid.Text + "'or coursename like '" + coursename.Text + "'";
cmd = new SqlCommand(strsql, conn);
da = cmd.ExecuteReader();
Datagrid1.DataSource = da;
Datagrid1.DataBind();
conn.Close();
cmd.Dispose();
cmd.Connection.Close();
}
}

八、编辑、删除学生信息程序代码
using System;
using System.Data;
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;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class images_editstudent : System.Web.UI.Page
{
SqlCommand cmd;
SqlCommand cmd2;
protected void Page_Load(object sender,