totalbx.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_totalbx : 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();
        }
        Button1.Visible = false;
        if (!IsPostBack)
        {
            int id = -1;

            try
            {//检查是否删除信息
                id = Convert.ToInt32(Request["deleteid"].ToString());
            }
            catch
            {
                id = -1;
            }
            if (id > 0)
            {//删除一个信息
                if (grd_MIS.manager.DelData_ReStudyCourse(id))
                {
                    Response.Write("<script>alert('删除成功');</script>");
                }
                else
                {
                    Response.Write("<script>alert('删除失败，请与系统维护人员联系');</script>");
                }
            }
            try
            {
                id = Convert.ToInt32(Request["id"].ToString());
            }
            catch
            {
                id = -1;
            }
            HiddenField1.Value = id.ToString();
            try
            {
                id = Convert.ToInt32(Request["editid"].ToString());
            }
            catch
            {
                id = -1;
            }
            if (id > 0)
            {
                DataTable reader = grd_MIS.manager.GetData_ReStudyCourse_ReStudyCourseID(id);
                DataRow read = null;
                if (reader.Rows.Count > 0)
                {
                    read = reader.Rows[0]; 
                }
                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["ReStudyCourseID"].ToString();
                    add.Visible = false;
                    Button1.Visible = true;

                }


            }
        }

    }
    public void print()
    {
        //打印课表

        int id = Convert.ToInt32(HiddenField1.Value);
        if (id <= 0) return;
        DataTable reader = grd_MIS.manager.GetData_ReStudyCourse_Term(id);//接口调用
        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["TeaClassID"].ToString());
                Response.Write("</td><td align=\"center\" class=\"mode5\">");
                Response.Write(read["CourseName"].ToString());
                Response.Write("</td><td align=\"center\" class=\"mode5\">");
                Response.Write("<a target=\"_blank\" href=\"changezj.aspx?id=" + read["ReStudyCourseID"].ToString() + "\">		<font color=\"#000000\" style=\"font-size: 9pt\">查看申请学生</font></a>" + "</font>&nbsp&nbsp");
                Response.Write("<a target=\"_self\" href=\"totalbx.aspx?editid=" + read["ReStudyCourseID"].ToString() + "&id=" + id.ToString() + "\">	<font color=\"#000000\" style=\"font-size: 9pt\">修改</font></a>" + "</font>&nbsp&nbsp");
                Response.Write("<a target=\"_self\" onclick='{if(confirm(\"您确定删除吗?此操作将不能恢复!\")){return true;}return false;}' href=\"totalbx.aspx?deleteid=" + read["ReStudyCourseID"].ToString() + "&id=" + id.ToString() + "\">	<font color=\"#000000\" style=\"font-size: 9pt\">删除</font></a>" + "</font>&nbsp&nbsp");
                Response.Write("</td></tr>\n");
                if (Convert.ToInt32(read["Enable"].ToString()) == 0)
                {
                    Button3.Enabled = false;
                    add.Visible = false;
                    

                }
                i++;

            }
        //    if (reader.Rows.Count < 1)
        //    {
        //        Button2.Enabled = false;
        //        Button3.Enabled = false;

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


        //    }




        }
        //else
        //{
        //    Button2.Enabled = false;
        //    Button3.Enabled = false;
        //    add.Enabled = false;
        //}
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        if (Convert.ToInt32(HiddenField1.Value) == -1)
        {
            return;

        }
        if (TextBox1.Text == "")
        {
            Response.Write("<script>alert('课程编号未填写');</script>");
            return;

        }
        if (TextBox2.Text == "")
        {
            Response.Write("<script>alert('课程名称未填写');</script>");
            return;

        }
        if (TextBox3.Text == "")
        {
            Response.Write("<script>alert('教学班号未填写');</script>");
            return;

        }
        if (TextBox4.Text == "")
        {
            Response.Write("<script>alert('上课教师未填写');</script>");
            return;

        }
        if (TextBox5.Text == "")
        {
            Response.Write("<script>alert('上课地点未填写');</script>");
            return;

        }
        if (TextBox6.Text == "")
        {
            Response.Write("<script>alert('上课时间未填写');</script>");
            return;

        }
        if (TextBox7.Text == "")
        {
            Response.Write("<script>alert('上课周次未填写');</script>");
            return;

        }
        try
        {
            if (grd_MIS.manager.AddData_ReStudyCourse(TextBox3.Text, TextBox1.Text, TextBox2.Text, TextBox8.Text, TextBox4.Text, TextBox9.Text, TextBox6.Text, TextBox5.Text, TextBox7.Text, Convert.ToInt32(HiddenField1.Value), TextBox10.Text, 1))
            {
                Response.Write("<script>alert('课程添加成功');</script>");
                TextBox10.Text = "";
                TextBox1.Text = "";
                TextBox2.Text = "";
                TextBox3.Text = "";
                TextBox4.Text = "";
                TextBox5.Text = "";
                TextBox6.Text = "";
                TextBox7.Text = "";
                TextBox8.Text = "";
                TextBox9.Text = "";

            }
            else
            {
                Response.Write("<script>alert('添加失败，请与系统管理员联系');</script>");
                Button1.Visible = true;
            }
        }
        catch
        {
            Response.Write("<script>alert('添加失败，请与系统管理员联系');</script>");
        }

    }
    protected void Button1_Click1(object sender, EventArgs e)
    {
        if (TextBox1.Text == "")
        {
            Response.Write("<script>alert('课程编号未填写');</script>");
            return;

        }
        if (TextBox2.Text == "")
        {
            Response.Write("<script>alert('课程名称未填写');</script>");
            return;

        }
        if (TextBox3.Text == "")
        {
            Response.Write("<script>alert('教学班号未填写');</script>");
            return;

        }
        if (TextBox4.Text == "")
        {
            Response.Write("<script>alert('上课教师未填写');</script>");
            return;

        }
        if (TextBox5.Text == "")
        {
            Response.Write("<script>alert('上课地点未填写');</script>");
            return;

        }
        if (TextBox6.Text == "")
        {
            Response.Write("<script>alert('上课时间未填写');</script>");
            return;

        }
        if (TextBox7.Text == "")
        {
            Response.Write("<script>alert('上课周次未填写');</script>");
            return;

        }
        try
        {
            if (grd_MIS.manager.SetData_ReStudyCourse_ByReStudyCourseID(Convert.ToInt32(HiddenField2.Value), TextBox3.Text, TextBox1.Text, TextBox2.Text, TextBox8.Text, TextBox4.Text, TextBox9.Text, TextBox6.Text, TextBox5.Text, TextBox7.Text, Convert.ToInt32(HiddenField1.Value), TextBox10.Text))
            {
                Response.Write("<script>alert('课程修改成功');</script>");
                TextBox10.Text = "";
                TextBox1.Text = "";
                TextBox2.Text = "";
                TextBox3.Text = "";
                TextBox4.Text = "";
                TextBox5.Text = "";
                TextBox6.Text = "";
                TextBox7.Text = "";
                TextBox8.Text = "";
                TextBox9.Text = "";
                if (Button3.Enabled == true)
                    add.Visible = true;

            }
            else
            {
                Response.Write("<script>alert('修改失败，请与系统管理员联系');</script>");


            }
        }
        catch
        {
            Response.Write("<script>alert('修改失败，请与系统管理员联系');</script>");
        }

    }
    protected void Button3_Click(object sender, EventArgs e)
    {
        try
        {
            if (grd_MIS.manager.SetData_ReStudyCourse(Convert.ToInt32(HiddenField1.Value)))
            {
                Response.Write("<script>alert('发布成功');</script>");
                Button3.Enabled = false;
                add.Visible = false;


            }
            else
            {
                Response.Write("<script>alert(' 发布失败，请与系统管理员联系');</script>");

            }
        }
        catch
        {
            Response.Write("<script>alert('发布失败，请与系统管理员联系');</script>");

        }


    }
    protected void Button2_Click(object sender, EventArgs e)
    {

    }
    protected void Button4_Click(object sender, EventArgs e)
    {
        Response.Redirect("addbx.aspx");
    }
    protected void Button22_Click(object sender, EventArgs e)
    {
        if (Convert.ToInt32(HiddenField1.Value) <= 0)
        {
            return;

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

        }
        if (DropDownList2.SelectedValue == "4")
        {
            reader = grd_MIS.manager.GetData_ReStudyCourse_Term(Convert.ToInt32(HiddenField1.Value));
        }
        if (DropDownList2.SelectedValue == "3")
        {
            reader = grd_MIS.manager.GetData_RestStudyList_Trem(Convert.ToInt32(HiddenField1.Value));
        }

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

       



    }
}