scholarapp.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_ScholarApp : 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();
        }
        if (!IsPostBack)
        {
            LoadDropDownList();
            try
            {
                HiddenField1.Value = Request["id"].ToString();
                int id = Convert.ToInt32(HiddenField1.Value);
                if (id > 0)
                {
                    DataRow dr = grd_MIS.manager.GetData_ScholarInfo(id);
                    int i = Convert.ToInt32(dr["Enable"].ToString());
                    if (i == 0)
                    {
                        Button1.Enabled = false;
                        Button3.Enabled = true;
                    }
                    else
                        if (i == 1)
                        {
                            Button1.Enabled = true;
                            Button3.Enabled = true;
                        }
                        else
                        {
                            Button1.Enabled = false;
                            Button3.Enabled = false;
                        }
                }
            }
            catch
            {
                Button1.Enabled = false;
                Button3.Enabled = false;
 
            }

        }
    }
    public void LoadDropDownList()
    {
        DataTable reader = grd_MIS.manager.GetData_ScholarInfo();
        DropDownList1.DataSource = reader;
        DropDownList1.DataTextField = "ScholarshipName";
        DropDownList1.DataValueField = "ScholarshipInfoID";
        DropDownList1.DataBind();

    }
    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_ScholarApply(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["ScholarshipName"].ToString());
                Response.Write("</td><td align=\"center\" class=\"mode5\">");
                Response.Write("<a target=\"_blank\" href=\"ScholarApp_more.aspx?id=" + read["ScholarshipAppID"].ToString()+"\">		<font color=\"#000000\" style=\"font-size: 9pt\">查看申请表</font></a>" + "</font>&nbsp&nbsp");
                Response.Write("</td></tr>\n");
                i++;

            }
        }
    }
    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        Response.Redirect("ScholarApp.aspx?id=" + DropDownList1.SelectedValue);
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        int id = -1;
        try
        {
            id = Convert.ToInt32(HiddenField1.Value);

        }
        catch
        {
            return;
        }
        if (id <= 0) return;
        DataTable reader = grd_MIS.manager.GetData_ScholarApply(id);
        if (reader != null)
        {
            int i = 0;
            while (i <reader.Rows.Count)
            {
                DataRow read = reader.Rows[i];
              
                int m = Convert.ToInt32(read["IsChecked"]);
                if (m == 0)
                {
                    Response.Write("<script>alert('还有未审核的申请表');</script>");
                    return;
                }
               
                i++;

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

    }
    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_ScholarApply(id);
        else
            reader = grd_MIS.manager.GetData_ScholarApply(id, Convert.ToInt32(DropDownList2.SelectedValue));
       
        dg.DataSource = reader;
        dg.DataBind();
        comm.ToExcel(dg, "StundetScholarApp");
    }
}