teachpratise.aspx.cs

一个研究生管理系统 具体的情况自己看了

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 student_teachpratise : System.Web.UI.Page
{
    //每个页面显示２０条记录；
    public int allpage = 1;
    public int currentpage = 0;
    public DataTable dt = null;
    protected void Page_Load(object sender, EventArgs e)
    {
        try
        {
            if (Session["Student"].ToString()!= "true")
            {
                Response.Write("<script>parent.window.href=\"../login.aspx\"</script>");
                Response.End();
            }
        }
        catch
        {
            Response.Write("<script>parent.window.href=\"../login.aspx\"</script>");
            Response.End();
        }
            if (Student.Student.IsUndergraduateCourseValid())
            {
              
                try
                {
                    
                    dt = Student.Student.GetTeacherPratiseValid();
                    try
                    {
                        currentpage = Convert.ToInt32(Request["pageid"].ToString());
                    }
                    catch
                    {
                    }
                    if (dt != null)
                    {
                        allpage = dt.Rows.Count / 20 + 1;
                        page_all.Text = "共" + allpage.ToString() + "页";
                        page_1.Text = "当前第" + currentpage.ToString() + "页";
                       
                    }
                    else
                    {
                        page_all.Text = "共" + allpage.ToString() + "页";
                        page_1.Text = "当前第" + currentpage.ToString() + "页";
                      
                    }
                    
                }
                catch(Exception ex)
                {
                    Response.Write("<script> alert(\'" + ex.Message + "\');</script>");
                }
            }
            else
            {
                Response.Write("<script> alert('课程实践申请已经结束！！');</script>");
                titletext.Enabled = false;
                add.Enabled = false;
                delete.Enabled = false;
                
            }
        
    }
    public void PrintTeachPratise()
    {
        try
        {
          
            if (dt != null)
            {
                
                for(int i = currentpage * 20, j=0;i<dt.Rows.Count&&j<20;i++,j++)
                {
                    Response.Write("<tr>");
                    Response.Write("<td align=\"center\" class=\"mode5\" height=\"35\" style=\"width: 118px\">");
                    Response.Write(dt.Rows[i]["UnderCourseID"].ToString());
                    Response.Write("</td>");
                    Response.Write("<td align=\"center\" height=\"35\" class=\"mode5\" style=\"width: 142px\">");
                    Response.Write(dt.Rows[i]["CourseName"].ToString());
                    Response.Write("</td>");
                    Response.Write("<td align=\"center\" class=\"mode5\" style=\"width: 126px\">");
                    Response.Write(dt.Rows[i]["Teacher"].ToString());
                    Response.Write("</td>");
                    Response.Write("<td align=\"center\" class=\"mode5\" style=\"width: 119px\">");
                    Response.Write(dt.Rows[i]["CourseID"].ToString());
                    Response.Write("</td>");
                    Response.Write(" <td align=\"center\" class=\"mode5\" style=\"width: 110px\">");
                    Response.Write(dt.Rows[i]["TeaClassID"].ToString());
                    Response.Write("</td>");
                    Response.Write("<td align=\"center\" class=\"mode5\">");
                    Response.Write("<a href=\"#\" OnClick=\"showModalDialog('seeteachpratise.aspx?undercourseid=" + dt.Rows[i]["UnderCourseID"].ToString() + "','','dialogHeight:490px;dialogWidth:650px')\">查看</a>");
                    Response.Write("</td>");
                    Response.Write("</tr>");
                    

                }
            }
        }
        catch (Exception ex)
        {
            Response.Write("<script> alert(\'" + ex.Message + "\');</script>");
        }
    }
    public void PrintPage()
    {
        for (int i = 0; i < allpage; i++)
        {
            Response.Write("<a href=teachpratise.aspx?pageid=" + i.ToString() + ">" + i.ToString() + "&nbsp</a>\n");
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        try
        {
             
            if (titletext.Text.Trim() != "")
            {
                
                if (!Student.Student.HasStuAppliedTeachPrac(Session["StuID"].ToString(), titletext.Text.Trim()))
                {
                    
                   
                    if (Student.Student.SetTeachPracApply(Session["StuID"].ToString(), Convert.ToInt32(titletext.Text.Trim()), Student.Student.GetTeacherPhoneFromUndergraduateCourse(titletext.Text.Trim())))
                    {
                        Response.Write("<script> alert('课程实践申请提交成功');</script>");
                    }
                    else
                    {
                        Response.Write("<script> alert('课程实践申请提交失败');</script>");
                    }
                   
                }
                else
                {
                    Response.Write("<script> alert('您已经申请过改课程的课程实践');</script>");
                }
            }
            else
            {
                Response.Write("<script> alert('本科课程号不能为空');</script>");
            }
        }
        catch (Exception ex)
        {
            Response.Write("<script> alert(\'" + ex.Message + "rff\');</script>");
        }


    }
    protected void delete_Click(object sender, EventArgs e)
    {
        try
        {
            if (titletext.Text.Trim() != "")
            {
                if (!Student.Student.HasStuAppliedTeachPrac(Session["StuID"].ToString(), titletext.Text.Trim()))
                {

                    Response.Write("<script> alert('您还未提交过该课程的课程实践');</script>");

                }
                else
                {
                    
                    if (Student.Student.DeleteTeachPracApply(Session["StuID"].ToString(), titletext.Text.Trim()))
                    {
                        Response.Write("<script> alert('课程实践申请删除成功成功');</script>");
                    }
                    else
                    {
                        Response.Write("<script> alert('课程实践申请删除失败');</script>");
                    }
                }
            }
            else
            {
                Response.Write("<script> alert('本科课程号不能为空');</script>");
            }
        }
        catch (Exception ex)
        {
            Response.Write("<script> alert(\'" + ex.Message + "\');</script>");
        }


    }
    public void   panduanIsCheckedTeachPratiseSuccess_Doing(int IsChecked)
    {
        if (IsChecked == 0)
        {
            Response.Write("评审中");

        }
        else if (IsChecked == 1)
        {
            Response.Write("成功");

        }
        else if (IsChecked == 2)
        {
            Response.Write("失败");
        }
        else
        {
            Response.Write("出错");

        }
    }
    public void PrintTeachPratiseSuccess_Doing()
    {
        try
        {
            DataTable dt = Student.Student.GetTeachPratiseSuccess_Doing_Failure_Current(Session["StuID"].ToString());

            if (dt != null)
            {

                for (int i = 0; i < dt.Rows.Count ; i++)
                {
                   

                    Response.Write("<tr>");
                    Response.Write("<td align=\"center\" class=\"mode5\" height=\"35\" style=\"width: 106px\">");
                    Response.Write(dt.Rows[i]["UnderCourseID"].ToString());
                    Response.Write("</td>");
                    Response.Write("<td align=\"center\" height=\"35\" class=\"mode5\" style=\"width: 140px\">");
                    Response.Write(dt.Rows[i]["CourseName"].ToString());
                    Response.Write("</td>");
                    Response.Write("<td align=\"center\" class=\"mode5\" style=\"width: 126px\">");
                    Response.Write(dt.Rows[i]["Teacher"].ToString());
                    Response.Write("</td>");
                    Response.Write("<td align=\"center\" class=\"mode5\" style=\"width: 86px\">");
                    Response.Write(dt.Rows[i]["CourseID"].ToString());
                    Response.Write("</td>");
                    Response.Write(" <td align=\"center\" class=\"mode5\" style=\"width: 96px\">");
                    Response.Write(dt.Rows[i]["TeaClassID"].ToString());
                    Response.Write("</td>");
                    Response.Write("</td>");
                    Response.Write(" <td align=\"center\" class=\"mode5\" style=\"width: 62px\">");
                    panduanIsCheckedTeachPratiseSuccess_Doing(Convert.ToInt32(dt.Rows[i]["IsChecked"].ToString()));
                    Response.Write("</td>");
                    Response.Write("<td align=\"center\" class=\"mode5\">");
                    Response.Write("<a href=\"#\" OnClick=\"showModalDialog('seeteachpratiseDid.aspx?undercourseid=" + dt.Rows[i]["UnderCourseID"].ToString() + "','','dialogHeight:490px;dialogWidth:650px')\">查看</a>");
                    Response.Write("</td>");
                    Response.Write("</tr>");
                }
            }
        }
        catch (Exception ex)
        {
            Response.Write("<script> alert(\'" + ex.Message + "\');</script>");
        }
    }
}