tellsj.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_tellsj : System.Web.UI.Page
{
    public int allpage = 0;
    protected void Page_Load(object sender, EventArgs e)
    {
        try
        {
            if (Session["admin"].ToString() != "true")
            {
                
                Response.Write("<script>parent.window.location.href='../';</script>");
                Response.End();
            }
        }
        catch
        {
            Response.Write("<script>parent.window.location.href='../';</script>");
            Response.End();
        }
        Button3.Enabled = false;
        Button2.Enabled = true;
        add.Visible = false;
        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_UndergraduateCourse_ByUnderCourseID(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)
            {
                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();
                    add.Visible = false;
                    Button1.Visible = true;
                                        
                }


            }
        }

    }
    public void print()
    {
        //打印课表
       
        int id = Convert.ToInt32(HiddenField1.Value);
        DataTable reader = grd_MIS.manager.GetData_UndergraduateCourse(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=\"changesj.aspx?id=" + read["UnderCourseID"].ToString() + "\">		<font color=\"#000000\" style=\"font-size: 9pt\">查看申请学生</font></a>" + "</font>&nbsp&nbsp");
                Response.Write("<a target=\"_self\" href=\"tellsj.aspx?editid=" + read["UnderCourseID"].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=\"tellsj.aspx?deleteid=" + read["UnderCourseID"].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())==1)
                {
                    Button3.Enabled = true;
                    if(!Button1.Visible)
                    add.Visible = true;
                    
                }
                i++;

            }
            if (reader.Rows.Count < 1)
            {
                Button2.Enabled = false;
                Button3.Enabled = false;
                if (reader.Rows.Count == 0)
                {
                    add.Visible = true;
                }

            }
            else 
            {
                Button2.Enabled = true;
                
               

            }




        }
        else
        {
            Button2.Enabled = false;
            Button3.Enabled = false;
            //add.Enabled = false;
        }
        //add.Visible = Button3.Enabled;
    }
   
    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_UndergraduateCourse(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>");

            }
        }
        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_UndergraduateCourse_ByUnderCourseID(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 = "";
                Button1.Visible = false;
                add.Visible = true;
                

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

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

    }
    protected void Button3_Click(object sender, EventArgs e)
    {
        if (grd_MIS.manager.SetData_UndergraduateCourse_Enable(Convert.ToInt32(HiddenField1.Value), 0))
        {
            Button3.Enabled = false;
            Button2.Enabled = true;
        }
    }
    protected void Button4_Click(object sender, EventArgs e)
    {
        Response.Redirect("addsj.aspx");
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        DataTable reader;
        if (DropDownList2.SelectedValue == "-1")
        {
            Response.Write("<script>alert('请先选择导出类型');</script>");
            return;

        }
        if (Convert.ToInt32(HiddenField1.Value) < 1) return;
        if (DropDownList2.SelectedValue == "4")
        {//课程表
            reader = grd_MIS.manager.GetData_UndergraduateCourse(Convert.ToInt32(HiddenField1.Value));
 
        }
        else
            if (DropDownList2.SelectedValue == "3")
            {//全部数据
                reader = grd_MIS.manager.GetData_TeaPracApplyID_Term(Convert.ToInt32(HiddenField1.Value));
              
 
            }
        else
                if(DropDownList2.SelectedValue=="2")
            {//审核失败的数据
            reader = grd_MIS.manager.GetData_TeaPracApplyID_Term(Convert.ToInt32(HiddenField1.Value));
            int i=0;
            if (reader == null) return;
            while(i<reader.Rows.Count)
            {
                if(Convert.ToInt32(reader.Rows[i]["IsChecked"])!=2)
                {
                    reader.Rows[i].Delete();
                }
                else
                {
                    i++;
                }
            }

        }
                else
            if (DropDownList2.SelectedValue == "1")
            {//已经通过审核的数据
                reader = grd_MIS.manager.GetData_TeaPracApplyID_Term(Convert.ToInt32(HiddenField1.Value));
                int i = 0;
                if (reader == null) return;
                while (i < reader.Rows.Count)
                {
                    if (Convert.ToInt32(reader.Rows[i]["IsChecked"]) != 1)
                    {
                        reader.Rows[i].Delete();
                    }
                    else
                    {
                        i++;
                    }
                }

            }
            else
                if (DropDownList2.SelectedValue == "0")
                {
                    reader = grd_MIS.manager.GetData_TeaPracApplyID_Term(Convert.ToInt32(HiddenField1.Value));
                    int i = 0;
                    if (reader == null) return;
                    while (i < reader.Rows.Count)
                    {//未审核的数据
                        if (Convert.ToInt32(reader.Rows[i]["IsChecked"]) != 0)
                        {
                            reader.Rows[i].Delete();
                        }
                        else
                        {
                            i++;
                        }
                    }

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