totalzj.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_totalzj : 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='../';</script>");
                Response.End();
            }
        }
        catch
        {
            Response.Write("<script>parent.window.location.href='../';</script>");
            Response.End();
        }
        if (!IsPostBack)
        {
            int id = -1;
            try
            {
                id = Convert.ToInt32(Request["id"].ToString());
            }
            catch
            {
                return;
            }
            DataRow dr = grd_MIS.manager.GetData_StationInfo(id);
            if ((dr == null))
            {
                return;
            }
            namesj.Text = dr["StationName"].ToString();
            neirong.Text = dr["StationDescrip"].ToString();
            remark.Text = dr["Remark"].ToString();
            HiddenField1.Value = dr["StationID"].ToString();
            HiddenField2.Value = dr["Enable"].ToString();
            if (Convert.ToInt32(HiddenField2.Value) == 1)
            {
                Button2.Enabled = true;
                //Button1.Enabled = true;
            }
            else
                if (Convert.ToInt32(HiddenField2.Value) == 0)
                {
                    //Button1.Enabled = true;
                    Button2.Enabled = false;

                }
                else
                {
                    Button2.Enabled = false;
                    //Button1.Enabled = false;
                }

            id = -1;
            try
            {
                id = Convert.ToInt32(Request["passid"].ToString());


            }
            catch
            {
                id = -1;
            }
            if (id > 0)
            {
                if (grd_MIS.manager.SetData_StationApply_IsChecked(id,1))
                {
                    //Response.Write("<script>alert('审核成功');</script>");
                }
                else
                {
                    Response.Write("<script>alert('审核失败，请与系统维护人员联系');</script>");
                } 
            }
            id = -1;
            try
            {
                id = Convert.ToInt32(Request["falid"].ToString());


            }
            catch
            {
                id = -1;
            }
            if (id > 0)
            {
                if (grd_MIS.manager.SetData_StationApply_IsChecked(id, 2))
                {
                    //Response.Write("<script>alert('审核成功');</script>");
                }
                else
                {
                    Response.Write("<script>alert('审核失败，请与系统维护人员联系');</script>");
                }
            }


 
        }
    }
    public void print()
    {
        //打印信息
        
        if (Convert.ToInt32(HiddenField1.Value) <= 0)
        {
            return;
 
        }
        DataTable reader = grd_MIS.manager.GetData_StationApply_StationID(Convert.ToInt32(HiddenField1.Value));//接口调用
        int i = 0;
         if (reader != null)
        {
            while (reader.Rows.Count > i)
            {
                DataRow read = reader.Rows[i];
                Response.Write("<tr><td align=\"center\" class=\"mode5\" >(");
                Response.Write(read["StationApplyID"].ToString() + ")");
                int ie = -1;
                String str = "未知审核";
                try
                {
                    ie = Convert.ToInt32(read["IsChecked"].ToString());
                }
                catch
                {
                    ie = -1;
                }
                if (ie == 1) str = "申请成功";
                if (ie == 2) str = "申请失败";
                Response.Write(str.ToString());
                Response.Write("</td><td align=\"center\" class=\"mode5\" >");
                Response.Write(read["StuName"].ToString());
                Response.Write("</td><td align=\"center\" class=\"mode5\">");
                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");
                if (Convert.ToInt32(HiddenField2.Value) == 1)
                {
                    Response.Write("<a target=\"_self\"  href=\"totalzj.aspx?passid=" + read["StationApplyID"].ToString() + "&id=" + HiddenField1.Value + "\">		<font color=\"#000000\" style=\"font-size: 9pt\">通过申请</font></a>" + "</font>&nbsp&nbsp");
                    Response.Write("<a target=\"_self\"  href=\"totalzj.aspx?falid=" + read["StationApplyID"].ToString() + "&id=" + HiddenField1.Value + "\">		<font color=\"#000000\" style=\"font-size: 9pt\">拒绝申请</font></a>" + "</font>&nbsp&nbsp");

                }
                Response.Write("</td></tr>\n");
                i++;

            }
            


        }
    }


    protected void Button2_Click(object sender, EventArgs e)
    {
        if (Convert.ToInt32(HiddenField1.Value) > 0)
        {
            if (grd_MIS.manager.SetData_StationInfo_Enable(Convert.ToInt32(HiddenField1.Value), 0))
            {
                Button2.Enabled = false;
                //Button1.Enabled = true;
            }
            else
            {
                Response.Write("<script>alert('审核失败，请与系统维护人员联系');</script>");
 
            }
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {

    }
    protected void Button3_Click(object sender, EventArgs e)
    {
        if (Convert.ToInt32(HiddenField1.Value) <= 0)
        {
            return;

        }
        DataTable reader = grd_MIS.manager.GetData_StationApply_StationID(Convert.ToInt32(HiddenField1.Value));//接口调用
        if(reader==null)return;
        if (DropDownList2.SelectedValue == "-1")
        {
            Response.Write("<script>alert('请先选择导出类型');</script>");
            return;

        }
        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++;
            }

        }
        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++;
            }

        }
        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++;
            }

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

    }
}