student.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_student : 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();
        }

    }
    protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (DropDownList2.SelectedValue == "~")
        {
            TextBox2.Visible = true;
        }
        else
        {
            TextBox2.Visible = false;
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        if (DropDownList1.SelectedValue == "-1")
        {
            Response.Write("<script>alert('还没有选择查询目标');</script>");
            return;
        }
        if (DropDownList2.SelectedValue == "-1")
        {
            Response.Write("<script>alert('还没有选择查询条件');</script>");
            return;
        }
        if (TextBox1.Text == "")
        {
            Response.Write("<script>alert('还没有输入匹配数据');</script>");
            return;
 
        }
        String str;
        DataTable reader = grd_MIS.manager.GetData_StudentInfo_AllEnable();
        if (reader == null) return;
        reader.Columns.Add("count", typeof(int));
        int i = 0;
        DataTable read = null;
        if(DropDownList1.SelectedValue=="1")
        {
        
                    i = 0;
                    int data = 0;
                    try
                    {
                        data = Convert.ToInt32(TextBox1.Text);
                    }
                    catch
                    {
                        Response.Write("<script>alert('还没有输入匹配数据错误');</script>");
                        return;
                    }
                    //if (data < 1) return;                   
                    while (i < reader.Rows.Count)
                    {
                        str = "select count(StuID) as cout from JoinActivStu where StuID='" + reader.Rows[i]["StuID"].ToString() + "'";
                        try
                        {
                            read = null;
                            read = grd_MIS.manager.GetData_SqlExec(str);
                        }
                        catch (Exception ex)
                        {
                            Response.Write(ex.Message);
                        }
                        if (read != null && (read.Rows.Count == 1))
                        {
                            if (DropDownList2.SelectedValue == ">")
                            {
                                if (Convert.ToInt32(read.Rows[0][0]) > data)
                                {
                                    reader.Rows[i]["count"] = Convert.ToInt32(read.Rows[0][0]);

                                }
                                else
                                {
                                    reader.Rows[i].Delete();
                                }

                            }
                            else
                                if (DropDownList2.SelectedValue == "=")
                                {
                                    if (Convert.ToInt32(read.Rows[0][0]) == data)
                                    {
                                        reader.Rows[i]["count"] = Convert.ToInt32(read.Rows[0][0]);

                                    }
                                    else
                                    {
                                        reader.Rows[i].Delete();
                                    }

                                }
                                else
                                    if (DropDownList2.SelectedValue == "<")
                                    {
                                        if (Convert.ToInt32(read.Rows[0][0]) < data)
                                        {
                                            reader.Rows[i]["count"] = Convert.ToInt32(read.Rows[0][0]);

                                        }
                                        else
                                        {
                                            reader.Rows[i].Delete();
                                        }

                                    }
                                    else
                                        if (DropDownList2.SelectedValue == ">=")
                                        {
                                            if (Convert.ToInt32(read.Rows[0][0]) >= data)
                                            {
                                                reader.Rows[i]["count"] = Convert.ToInt32(read.Rows[0][0]);

                                            }
                                            else
                                            {
                                                reader.Rows[i].Delete();
                                            }

                                        }
                                        else
                                            if (DropDownList2.SelectedValue == "<=")
                                            {
                                                if (Convert.ToInt32(read.Rows[0][0]) <= data)
                                                {
                                                    reader.Rows[i]["count"] = Convert.ToInt32(read.Rows[0][0]);

                                                }
                                                else
                                                {
                                                    reader.Rows[i].Delete();
                                                }

                                            }
                                            else
                                                if (DropDownList2.SelectedValue == ">")
                                                {
                                                    if (Convert.ToInt32(read.Rows[0][0]) > data)
                                                    {
                                                        reader.Rows[i]["count"] = Convert.ToInt32(read.Rows[0][0]);

                                                    }
                                                    else
                                                    {
                                                        reader.Rows[i].Delete();
                                                    }

                                                }
                                                else
                                                    if (DropDownList2.SelectedValue == "~")
                                                    {
                                                        int de = -1;
                                                        try
                                                        {
                                                            de = Convert.ToInt32(TextBox2.Text);
                                                        }
                                                        catch
                                                        {
                                                            Response.Write("<script>alert('还没有输入匹配数据错误');</script>");
                                                            return;
                                                        }
                                                        if ((Convert.ToInt32(read.Rows[0][0]) >= data) && (Convert.ToInt32(read.Rows[0][0]) <= de))
                                                        {
                                                            reader.Rows[i]["count"] = Convert.ToInt32(read.Rows[0][0]);

                                                        }
                                                        else
                                                        {
                                                            reader.Rows[i].Delete();
                                                        }

                                                    }


                        }
                        else
                        {
                            reader.Rows[i].Delete();
 
                        }
                        
                        i++;
                    }




                  
 
                }
        else
            if(DropDownList1.SelectedValue=="2")
        {
        
                    i = 0;
                    int data = 0;
                    try
                    {
                        data = Convert.ToInt32(TextBox1.Text);
                    }
                    catch
                    {
                        Response.Write("<script>alert('还没有输入匹配数据错误');</script>");
                        return;
                    }
                    //if (data < 1) return;                   
                    while (i < reader.Rows.Count)
                    {
                        str = "select count(StuID) as cout from JoinReportStu where StuID='" + reader.Rows[i]["StuID"].ToString() + "'";
                        try
                        {
                            read = null;
                            read = grd_MIS.manager.GetData_SqlExec(str);
                        }
                        catch (Exception ex)
                        {
                            Response.Write(ex.Message);
                        }
                        if (read != null && (read.Rows.Count == 1))
                        {
                            if (DropDownList2.SelectedValue == ">")
                            {
                                if (Convert.ToInt32(read.Rows[0][0]) > data)
                                {
                                    reader.Rows[i]["count"] = Convert.ToInt32(read.Rows[0][0]);

                                }
                                else
                                {
                                    reader.Rows[i].Delete();
                                }

                            }
                            else
                                if (DropDownList2.SelectedValue == "=")
                                {
                                    if (Convert.ToInt32(read.Rows[0][0]) == data)
                                    {
                                        reader.Rows[i]["count"] = Convert.ToInt32(read.Rows[0][0]);

                                    }
                                    else
                                    {
                                        reader.Rows[i].Delete();
                                    }

                                }
                                else
                                    if (DropDownList2.SelectedValue == "<")
                                    {
                                        if (Convert.ToInt32(read.Rows[0][0]) < data)
                                        {
                                            reader.Rows[i]["count"] = Convert.ToInt32(read.Rows[0][0]);

                                        }
                                        else
                                        {
                                            reader.Rows[i].Delete();
                                        }

                                    }
                                    else
                                        if (DropDownList2.SelectedValue == ">=")
                                        {
                                            if (Convert.ToInt32(read.Rows[0][0]) >= data)
                                            {
                                                reader.Rows[i]["count"] = Convert.ToInt32(read.Rows[0][0]);

                                            }
                                            else
                                            {
                                                reader.Rows[i].Delete();
                                            }