changesj.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;

public partial class manger_changesj : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        try
        {
            if (Session["admin"].ToString() != "true")
            {
                //Response.Write("<script>parent.window.location.href='login.aspx';</script>");
                Response.Write("<script>parent.window.location.href='../login.aspx';</script>");
                Response.End();
            }
        }
        catch
        {
            Response.Write("<script>parent.window.location.href='../login.aspx';</script>");
            Response.End();
        }
        int id = -1;
        try
        {
            id = Convert.ToInt32(Request["id"].ToString());
        }
        catch
        {
            id = -1;
        }
        if (id > 0)
        {
            DataRow read = grd_MIS.manager.GetData_UndergraduateCourse_ByUnderCourseID(id);
            if (read != null)
            {
               

                TextBox1.Text = read["CourseID"].ToString();
                TextBox2.Text = read["CourseName"].ToString();
                TextBox3.Text = read["TeaClassID"].ToString();
                TextBox4.Text = read["Teacher"].ToString();
                TextBox5.Text = read["ClassAddress"].ToString();
                TextBox6.Text = read["ClassDate"].ToString();
                TextBox7.Text = read["ClassWeeks"].ToString();
                TextBox8.Text = read["CourseType"].ToString();
                TextBox9.Text = read["TeacherPhone"].ToString();
                TextBox10.Text = read["Remark"].ToString();
                HiddenField2.Value = read["UnderCourseID"].ToString();
                HiddenField1.Value = read["Enable"].ToString();

            }
            //else
            //{
            //    Response.Write("ssssssssssssssssssssssss");
            //}


        }
        try
        {
            id = Convert.ToInt32(Request["Passid"].ToString());
            if (id > 0)
            {
                grd_MIS.manager.SetData_TeachPracApply_TeaPracApplyID(id, 1);
            }


        }
        catch
        { 
        }
        try
        {
            id = Convert.ToInt32(Request["Failid"].ToString());
            if (id > 0)
            {
                grd_MIS.manager.SetData_TeachPracApply_TeaPracApplyID(id, 2);
            }


        }
        catch
        { 
        }
    
    }
    public void print()
    {
        //打印历史活动信息
      
        int id = Convert.ToInt32(HiddenField2.Value);
        DataTable reader = grd_MIS.manager.GetData_TeachPracApply_ByUnderCourseID(id);//接口调用
        int i = 0;
        if (reader != null)
        {
           // Response.Write("ssssssssssssssssssssssss");
            while (reader.Rows.Count > i)
            {
                DataRow read = reader.Rows[i];
                Response.Write("<tr><td align=\"center\" class=\"mode5\" >");
                int check = Convert.ToInt32(read["IsChecked"].ToString());
                if (check == 0)
                {
                    Response.Write("未审核");
                }
                else
                    if (check == 1)
                    {
                        Response.Write("已通过申请");
                    }
                    else
                    {
                        Response.Write("已拒绝该申请");
 
                    }
                Response.Write("</td><td align=\"center\" class=\"mode5\" >");
                Response.Write(read["StuName"].ToString());
                Response.Write("</td><td align=\"center\" class=\"mode5\">");
                if (Convert.ToInt32(HiddenField1.Value) == 1)
                {
                    Response.Write("<a target=\"_self\" href=\"changesj.aspx?Passid=" + read["TeaPracApplyID"].ToString() + "&id=" + id.ToString() + "\">	<font color=\"#000000\" style=\"font-size: 9pt\">通过申请</font></a>" + "</font>&nbsp&nbsp");
                    Response.Write("<a target=\"_self\" href=\"changesj.aspx?Failid=" + read["TeaPracApplyID"].ToString() + "&id=" + id.ToString() + "\">	<font color=\"#000000\" style=\"font-size: 9pt\">已拒绝该申请</font></a>" + "</font>&nbsp&nbsp");
                }
                Response.Write("<a target=\"_blank\" href=\"../comm/studentinfo.aspx?id=" + read["StuID"].ToString() + "\">	<font color=\"#000000\" style=\"font-size: 9pt\">学生信息</font></a>" + "</font>&nbsp&nbsp");
                Response.Write("</td></tr>\n");
                i++;

            }
          
           


        }
    }
    protected void Button3_Click(object sender, EventArgs e)
    {
        int id = Convert.ToInt32(HiddenField2.Value);
        if (id <= 0) return;
        DataTable reader = grd_MIS.manager.GetData_TeachPracApply_ByUnderCourseID(id);//接口调用
        if (DropDownList2.SelectedValue == "-1")
        {
            Response.Write("<script>alert('请先选择导出类型');</script>");
            return;

        }
        if (DropDownList2.SelectedValue == "0")
        {
            int i = 0;
            while (i < reader.Rows.Count)
            {
                if (Convert.ToInt32(reader.Rows[i]["IsChecked"]) != 0) reader.Rows[i].Delete();
                
                    i++;
            }

 
        }
        else
            if (DropDownList2.SelectedValue == "1")
            {
                int i = 0;
                while (i < reader.Rows.Count)
                {
                    if (Convert.ToInt32(reader.Rows[i]["IsChecked"]) != 1) reader.Rows[i].Delete();
                   
                        i++;
                }


            }
            else
                if (DropDownList2.SelectedValue == "2")
                {
                    int i = 0;
                    while (i < reader.Rows.Count)
                    {
                        if (Convert.ToInt32(reader.Rows[i]["IsChecked"]) != 2) reader.Rows[i].Delete();
                      
                            i++;
                    }


                }
                else
                    if (DropDownList2.SelectedValue != "3")
                    {

                        return;
                    }
                   
            

        dg.DataSource = reader;
        dg.DataBind();
        comm.ToExcel(dg, "StundetExcellApp");
    }
}