excellapp.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_ExcellApp : System.Web.UI.Page
{
    int enable = -1;
    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();
        }
        if (!IsPostBack)
        {
            HiddenField1.Value =Convert.ToString(-1);
            LoadDropDownList();
            int id = -1;
            try
            {
                id = Convert.ToInt32(Request["id"].ToString());
                HiddenField1.Value = id.ToString();

            }
            catch
            {
                return;
            }
            
             if(id>0)
             {
            try           
            {
          
                DataRow dr=grd_MIS.manager.GetData_ExcellInfo(id);
                if (dr != null)
                {
                    enable = Convert.ToInt32(dr["Enable"].ToString());
                }
                else
                {
                    enable = -1;
                }

            }
            catch
            {
                enable =-1;
            }
        }
            if (enable == 0)
            {
                Button1.Enabled = false;
                Button3.Enabled = true;
 
            }
            else
                if (enable == 1)
                {
                    Button3.Enabled = true;
                    Button1.Enabled = true;
                }
                else
                 {
                    Button1.Enabled = false;
                    Button3.Enabled = false;
                }


 
        }

    }
    public void LoadDropDownList()
    {
        DataTable reader = grd_MIS.manager.GetData_ExcellInfo();
        DropDownList1.DataSource = reader;
        DropDownList1.DataTextField = "ExcellenceName";
        DropDownList1.DataValueField = "ExcellenceInfoID";
        DropDownList1.DataBind();
 
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        if (Convert.ToInt32(HiddenField1.Value) <= 0) return;
        DataTable reader = grd_MIS.manager.GetData_ExcellApply(Convert.ToInt32(HiddenField1.Value));
        if (reader != null)
        {
            int i = 0;
            while (i < reader.Rows.Count)
            {
                DataRow read = reader.Rows[i];
                if (Convert.ToInt32(read["IsChecked"]) == 0)
                {
                    Response.Write("<script>alert('还有未审核的申请表');</script>");
                    return;
 
                }
                i++;
            }

        }

        if (grd_MIS.manager.SetData_ExcellInfoEnableValue(Convert.ToInt32(HiddenField1.Value), 0))
        {
            Response.Write("<script>alert('发布成功');</script>");
            Button1.Enabled = false;
            Button3.Enabled = true;
 
        }

    }
    public void print()
    {
        int id = -1;
        try
        {
            id = Convert.ToInt32(Request["id"].ToString());

        }
        catch
        {
            return;
        }
        if (id <= 0) return;
        DataTable reader = grd_MIS.manager.GetData_ExcellApply(id);
        if (reader!=null)
        {
            int i = 0;
            while (i <reader.Rows.Count)
            {
                DataRow read = reader.Rows[i];
                Response.Write("<tr><td align=\"center\" class=\"mode5\" style=\"width: 261px\">");
                int m=Convert.ToInt32(read["IsChecked"]);
                if(m==0)
                {
                    Response.Write("(未审核)");
                }
                else
                    if (m == 1)
                    {
                        Response.Write("(通过评审)");
                    }
                    else
                    {
                        Response.Write("(申请失败)");
                    }
                Response.Write(read["StuName"].ToString());
                Response.Write("</td><td align=\"center\" class=\"mode5\" style=\"width: 249px\">");
                Response.Write(read["ExcellenceName"].ToString());
                Response.Write("</td><td align=\"center\" class=\"mode5\">");
                Response.Write("<a target=\"_blank\"  href=\"ExcellApp_more.aspx?id=" + read["ExcellenceID"].ToString()+"\">		<font color=\"#000000\" style=\"font-size: 9pt\">查看申请表</font></a>" + "</font>&nbsp&nbsp");
                Response.Write("</td></tr>\n");
                i++;
 
            }
            
        }
        //else
        //{
        //    Response.Write("(通过评审)");

        //}
    }
    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        Response.Redirect("ExcellApp.aspx?id=" + DropDownList1.SelectedValue);


    }
    protected void Button3_Click(object sender, EventArgs e)
    {
        int id = -1;
        try
        {
            id = Convert.ToInt32(Request["id"].ToString());

        }
        catch
        {
            return;
        }
        if (id <= 0) return;
        DataTable reader;
        if (DropDownList2.SelectedValue == "-1")
        {
            Response.Write("<script>alert('请先选择导出类型');</script>");
            return;

        }
        if (DropDownList2.SelectedValue == "3")
            reader = grd_MIS.manager.GetData_ExcellApply(id);
        else
            reader = grd_MIS.manager.GetData_ExcellApply(id, Convert.ToInt32(DropDownList2.SelectedValue));

        dg.DataSource = reader;
        dg.DataBind();
        comm.ToExcel(dg, "StundetExcellApp");
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        Response.Redirect("add_m5.aspx");
    }
}