netQT/index_teacher.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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;
using CommonLib;


public partial class netQT_index_teacher : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Repeater1.DataSource = new DBExec().getView("select top 5 * from T_News order by DateTime desc");
            Repeater1.DataBind();
            //Repeater2.DataSource = new DBExec().getView("select * from T_kejian");
            //Repeater2.DataBind();
        }
        Label4.Text = Convert.ToString(DateTime.Now.DayOfWeek);
        Label3.Text = Convert.ToString(DateTime.Now);

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        if (TextBox1.Text != "" && TextBox2.Text != "")
        {

            if (RadioButtonList1.SelectedItem.Text == "教师")
            {
                string str;
                str = "select * from T_Teacher where PassWord='" + TextBox2.Text + "'and TeacherName='" + TextBox1.Text + "'";
                SqlDataReader dr = new DBExec().execSqlQry(str);
                if (dr.Read())
                {
                    Session.Add("T_ID", dr.GetValue(0).ToString());
                    Response.Redirect("teacher_index.aspx");
                    JavaScriptHelper.Alert("登陆成功！");
                }
                else
                {
                    JavaScriptHelper.Alert("对不起输入的用户名或密码有误");
                }

            }
            else if (RadioButtonList1.SelectedItem.Text == "学生")
            {
                string str;
                str = "select * from T_Student where PassWord='" + TextBox2.Text + "'and StuName='" + TextBox1.Text + "'";
                SqlDataReader dr = new DBExec().execSqlQry(str);
                if (dr.Read())
                {
                    Session.Add("S_ID", dr.GetValue(0).ToString());
                    Response.Redirect("student_index.aspx");