コード例 #1
0
ファイル: Login.aspx.cs プロジェクト: KINNLR/OCSS
 protected void Page_Load(object sender, EventArgs e)
 {
     if (Session["stunum"] != null || Session["adminnum"] != null || Session["thnnum"] != null)
     {
         Session.Abandon();
     }
     DataBaseUtil.connectDB();
 }
コード例 #2
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (Session["stunum"] == null)
     {
         Response.Write("<script>alert('请先登录!');window.location.href='Login.aspx'</script>");
     }
     else
     {
         DataBaseUtil.connectDB();
     }
 }
コード例 #3
0
        protected void bind()
        {
            string tnum = Session["thnnum"].ToString();

            DataBaseUtil.connectDB();
            string         showSql = " select tb_student.sno,sname,tb_course.cno,cname,grade from tb_course,tb_sc,tb_teacher,tb_student where tb_course.cno=tb_sc.cno and tb_sc.tno=tb_teacher.tno and tb_sc.sno=tb_student.sno and  tb_sc.tno='" + tnum + "'";
            DataSet        ds      = new DataSet();
            SqlDataAdapter myDA    = new SqlDataAdapter(showSql, myconn);

            myDA.Fill(ds, "TEST");
            GridView1.DataSource = ds;
            GridView1.DataBind();
        }
コード例 #4
0
        public void dBind()
        {
            DataBaseUtil.connectDB();
            string snum    = Session["stunum"].ToString();
            string showSql = "select sno ,sname ,ssex, sbirth, mname from tb_student join tb_major on tb_student.mno=tb_major.mno and sno='" + snum + "'";

            SqlDataAdapter sda = new SqlDataAdapter(showSql, myconn);
            DataSet        ds  = new DataSet();

            sda.Fill(ds, "stutab");

            GridView1.DataSource = ds;
            GridView1.DataBind();
        }
コード例 #5
0
ファイル: TeacherInfo.aspx.cs プロジェクト: KINNLR/OCSS
        public void dBind()
        {
            DataBaseUtil.connectDB();
            string tnum    = Session["thnnum"].ToString();
            string showSql = "select tno ,dno ,tname, tsex from tb_teacher where tno='" + tnum + "'";

            SqlDataAdapter sda = new SqlDataAdapter(showSql, myconn);
            DataSet        ds  = new DataSet();

            sda.Fill(ds, "thtab");

            GridView1.DataSource = ds;
            GridView1.DataBind();
        }
コード例 #6
0
ファイル: CommonPass.aspx.cs プロジェクト: KINNLR/OCSS
        public void dBind()
        {
            DataBaseUtil.connectDB();
            string anum    = Session["adminnum"].ToString();
            string showSql = "select ano ,aname ,apass from tb_admin where ano='" + anum + "'";

            SqlDataAdapter sda = new SqlDataAdapter(showSql, myconn);
            DataSet        ds  = new DataSet();

            sda.Fill(ds, "admintab");

            GridView1.DataSource = ds;
            GridView1.DataBind();
        }
コード例 #7
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (Session["adminname"] == null)
     {
         Response.Write("<script>alert('请先登录!');window.location.href='Login.aspx'</script>");
     }
     else if (Session["adminright"].ToString() == "10" || Session["adminright"].ToString() == null)
     {
         Response.Write("<script>alert('您没有权限使用此功能');window.location.href='AdminInfo.aspx'</script>");
     }
     else
     {
         DataBaseUtil.connectDB();
     }
 }
コード例 #8
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (Session["adminname"] == null)
            {
                Response.Write("<script>alert('请先登录!');window.location.href='Login.aspx'</script>");
            }
            else
            {
                DataBaseUtil.connectDB();
                string ssql = "select mno as '专业编号',mname as '专业名称',tb_major.dno as '系别编号',dname as '系别',dtel as '联系方式' from tb_major join tb_dept on tb_major.dno=tb_dept.dno";

                SqlDataAdapter sda = new SqlDataAdapter(ssql, myconn);
                DataSet        ds  = new DataSet();
                sda.Fill(ds, "mdInfo");
                GridView1.DataSource = ds;
                GridView1.DataBind();
            }
        }
コード例 #9
0
        protected void bind()
        {
            if (Session["thnnum"] == null)
            {
                Response.Write("<script>alert('请先登录!');window.location.href='Login.aspx'</script>");
            }
            else
            {
                string tnum = Session["thnnum"].ToString();
                DataBaseUtil.connectDB();
                string         showSql = " select cno as '课程号',cname as '课程名',ccredit as '学分',tno as '本人教师编号' from tb_course where tno='" + tnum + "'";
                DataSet        ds      = new DataSet();
                SqlDataAdapter myDA    = new SqlDataAdapter(showSql, myconn);

                myDA.Fill(ds, "TEST");


                GridView1.DataSource = ds;
                GridView1.DataBind();
            }
        }
コード例 #10
0
        protected void bind()
        {
            if (Session["stunum"] == null)
            {
                Response.Write("<script>alert('请先登录!');window.location.href='Login.aspx'</script>");
            }
            else
            {
                string studentNum = Session["stunum"].ToString();
                DataBaseUtil.connectDB();
                string         showSql = " select tb_course.cno as '课程号',cname as '课程名',ccredit as '学分',tname as '教师名',dname as '系别',dtel as '联系方式' from tb_course,tb_sc,tb_teacher,tb_dept where tb_course.cno=tb_sc.cno and tb_sc.tno=tb_teacher.tno and tb_teacher.dno=tb_dept.dno and tb_sc.sno='" + studentNum + "'";
                DataSet        ds      = new DataSet();
                SqlDataAdapter myDA    = new SqlDataAdapter(showSql, myconn);

                myDA.Fill(ds, "TEST");


                GridView1.DataSource = ds;
                GridView1.DataBind();
            }
        }
コード例 #11
0
 protected void LinkButton1_Click(object sender, EventArgs e)
 {
     Session.Abandon();
     DataBaseUtil.closeDB();
     Response.Redirect("Login.aspx");
 }
コード例 #12
0
ファイル: Login.aspx.cs プロジェクト: KINNLR/OCSS
        protected void LoginButton_Click(object sender, EventArgs e)
        {
            string usernumber = Textbox1.Text;
            string userpass   = Textbox2.Text;

            if (Textbox1.Text == "" || Textbox2.Text == "")
            {
                Page.ClientScript.RegisterClientScriptBlock(GetType(), "Attention", "<script>alert('请输入学号或密码');</script>");
            }
            else if (!RadioButton1.Checked && !RadioButton2.Checked && !RadioButton3.Checked)
            {
                Page.ClientScript.RegisterClientScriptBlock(GetType(), "Attention", "<script>alert('请选择您的身份');</script>");
            }
            else if (RadioButton1.Checked)
            {
                //loginsql =
                //    "select sno,spass,sname,ssex,sbirth,sdept from tb_student where sno='"+usernumber+"' and spass='******'";
                string studentsql = "select sno,spass,sname,ssex,sbirth,dname,mname from tb_student join tb_major on tb_student.mno=tb_major.mno join tb_dept on tb_major.dno=tb_dept.dno where sno='" + usernumber + "'" + " and spass='******'";
                mycomd.CommandText = studentsql;
                mycomd.Connection  = myconn;
                SqlDataAdapter myDA = new SqlDataAdapter();
                myDA.SelectCommand = mycomd;
                //将数据保存至数据集
                DataSet myDS = new DataSet();
                int     n    = myDA.Fill(myDS, "login");
                if (n != 0)
                {
                    string studentname   = myDS.Tables["login"].Rows[0]["sname"].ToString();
                    string studentnumber = myDS.Tables["login"].Rows[0]["sno"].ToString();
                    string studentsex    = myDS.Tables["login"].Rows[0]["ssex"].ToString();
                    string studentpass   = myDS.Tables["login"].Rows[0]["spass"].ToString();
                    string studentbirth  = myDS.Tables["login"].Rows[0]["sbirth"].ToString();
                    string deptname      = myDS.Tables["login"].Rows[0]["dname"].ToString();
                    string majorname     = myDS.Tables["login"].Rows[0]["mname"].ToString();

                    Session["stuname"]  = studentname;
                    Session["stunum"]   = studentnumber;
                    Session["stusex"]   = studentsex;
                    Session["stupass"]  = studentpass;
                    Session["stubirth"] = studentbirth;
                    Session["deptn"]    = deptname;
                    Session["majorn"]   = majorname;
                    Response.Redirect("StudentMainPage.aspx");
                }
                else
                {
                    Page.ClientScript.RegisterClientScriptBlock(GetType(), "Attention", "<script>alert('编号或密码有误,请重新输入');</script>");
                    Textbox1.Text = "";
                    Textbox2.Text = "";
                }
            }
            else if (RadioButton2.Checked)
            {
                string adminsql = "select ano,aname,apass,asex,aright from tb_admin where ano='" + usernumber + "' and apass='******'";

                SqlDataAdapter sda = new SqlDataAdapter(adminsql, myconn);
                DataSet        ds  = new DataSet();
                int            dsc = sda.Fill(ds, "admin");
                if (dsc != 0)
                {
                    string adminnumber = ds.Tables["admin"].Rows[0]["ano"].ToString();
                    string adminname   = ds.Tables["admin"].Rows[0]["aname"].ToString();
                    string adminpass   = ds.Tables["admin"].Rows[0]["apass"].ToString();
                    string adminsex    = ds.Tables["admin"].Rows[0]["asex"].ToString();
                    string adminright  = ds.Tables["admin"].Rows[0]["aright"].ToString();

                    Session["adminnum"]   = adminnumber;
                    Session["adminpass"]  = adminpass;
                    Session["adminsex"]   = adminsex;
                    Session["adminname"]  = adminname;
                    Session["adminright"] = adminright;

                    Response.Redirect("AdminMainPage.aspx");
                }
                else
                {
                    Page.ClientScript.RegisterClientScriptBlock(GetType(), "Attention", "<script>alert('编号或密码有误,请重新输入');</script>");
                    Textbox1.Text = "";
                    Textbox2.Text = "";
                }
            }
            else if (RadioButton3.Checked)
            {
                string teachersql = "select tno,dno,tname,tsex,tpass from tb_teacher where tno='" + usernumber + "' and tpass='******'";

                SqlDataAdapter sda = new SqlDataAdapter(teachersql, myconn);
                DataSet        ds  = new DataSet();
                int            dsc = sda.Fill(ds, "teacher");

                if (dsc != 0)
                {
                    string teachernumber = ds.Tables["teacher"].Rows[0]["tno"].ToString();
                    string deptnumber    = ds.Tables["teacher"].Rows[0]["dno"].ToString();
                    string teachername   = ds.Tables["teacher"].Rows[0]["tname"].ToString();
                    string teacherpass   = ds.Tables["teacher"].Rows[0]["tpass"].ToString();
                    string teachersex    = ds.Tables["teacher"].Rows[0]["tsex"].ToString();


                    Session["thnnum"]  = teachernumber;
                    Session["deptnum"] = deptnumber;
                    Session["thname"]  = teachername;
                    Session["thpass"]  = teacherpass;
                    Session["thsex"]   = teachersex;

                    Response.Redirect("TeacherMainPage.aspx");
                }
                else
                {
                    Page.ClientScript.RegisterClientScriptBlock(GetType(), "Attention", "<script>alert('编号或密码有误,请重新输入');</script>");
                    Textbox1.Text = "";
                    Textbox2.Text = "";
                }
            }
            DataBaseUtil.closeDB();
            //Server.Transfer("TestingRedirect.aspx");
        }
コード例 #13
0
ファイル: StudentPassChange.aspx.cs プロジェクト: KINNLR/OCSS
 protected void Page_Load(object sender, EventArgs e)
 {
     //Label1.Text = Session["stuname"].ToString();//test Session
     DataBaseUtil.connectDB();
 }