bigsearch.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;
using System.Data.SqlClient;

public partial class Manager_BigSearch : System.Web.UI.Page
{
    ManagerClass mcObj = new ManagerClass();
    PersonRecordClass prObj = new PersonRecordClass();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            DDLBindArea();
            tabHind.Visible = false;
            tabJYZYKT.Visible = false;
            tabJYFBLW.Visible = false;
            tabJYFBLZ.Visible = false;
            tabJYHJQK.Visible = false;
            tabKYZYKT.Visible = false;
            tabKYFBLW.Visible = false;
            tabKYFBLZ.Visible = false;
            tabKYHJQK.Visible = false;
            if (Convert.ToInt32(Session["isOpen"]) == 1)
            {
                labSystem.Text = "开放";
            }
            else
            {
                labSystem.Text = "不开放";
            }
            if (Convert.ToInt32(Session["isSearch"]) == 1)
            {
                labSearch.Text = "开放";
            }
            else
            {
                labSearch.Text = "不开放";
            }
        }
    }
    /// <summary>
    /// 显示搜索范围
    /// </summary>
    public void DDLBindArea()
    {
        SqlCommand myCmd = mcObj.GetTClassCmd();
        SqlDataAdapter da = new SqlDataAdapter(myCmd);
        DataSet ds = new DataSet();
        da.Fill(ds, "Class");
        ddlArea.DataSource = ds.Tables["Class"].DefaultView;
        ddlArea.DataTextField = ds.Tables["Class"].Columns[0].ToString();
        ddlArea.DataBind();
        ddlArea.Items.Insert(0,"全校");
    
    }
    //搜索按钮
    protected void btnSearch_Click(object sender, EventArgs e)
    {
       
        if (rdbJY.Checked == false && rdbKY.Checked == false && rdbTS.Checked == false)
        {
            Response.Write("<script>alert('请选择搜索条件2！');</script>");
        }
        else
        { 
         tabHind.Visible = true;
         tabSearchConditon.Visible = false;

         if (rdbJY.Checked == true)
         {
             if (Convert.ToInt32(ddlJY.SelectedValue.ToString()) == 1)
             {
                 
                 tabJYZYKT.Visible = true;
                 gvListBind(gvJYZYKTList);
               
             }
             else if (Convert.ToInt32(ddlJY.SelectedValue.ToString()) == 2)
             {
                 tabJYFBLW.Visible = true;
                 gvListBind(gvJYFBLWList);

             }
             else if (Convert.ToInt32(ddlJY.SelectedValue.ToString()) == 3)
             {
                 tabJYFBLZ.Visible = true;
                 gvListBind(gvJYFBLZList);

             }
             else if (Convert.ToInt32(ddlJY.SelectedValue.ToString()) == 4)
             {
                 tabJYHJQK.Visible = true;
                 gvListBind(gvJYHJQKList);

             } 
         }
         else if (rdbKY.Checked == true)
         {
             if (Convert.ToInt32(ddlKY.SelectedValue.ToString()) == 1)
             {
                 tabKYZYKT.Visible = true;
                 gvKListBind(gvKYZYKTList);

             }
             else if (Convert.ToInt32(ddlKY.SelectedValue.ToString()) == 2)
             {
                 tabKYFBLW.Visible = true;
                 gvKListBind(gvKYFBLWList);

             }
             else if (Convert.ToInt32(ddlKY.SelectedValue.ToString()) == 3)
             {
                 tabKYFBLZ.Visible = true;
                 gvKListBind(gvKYFBLZList);

             }
             else if (Convert.ToInt32(ddlKY.SelectedValue.ToString()) == 4)
             {
                 tabKYHJQK.Visible = true;
                 gvKListBind(gvKYHJQKList);

             } 
         
         
         }
         else if (rdbTS.Checked == true)
         {

             gvTListBind(gvTSList);
         }
        
        }     
    }
    //=============================================================
    // 方 法 名： gvListBind()
    // 功能描述： 对GridView进行绑定，显示教学研究的资料
    // 输入参数： 无
    // 返 回 值： 无
    // ==============================================================
    public void gvListBind(GridView gvList)
    {
        if ((Session["Admin"] == null) && (Session["isSearch"]==null))
        {
            Response.Write("<script>parent.location='../Default.aspx';</script>");
        }
        else
        {
            int keyId;
            if(txtKey.Text.Trim()=="")
            {
              keyId =0;
            }
            else 
            {
              keyId =1;
            }
            if (Convert.ToInt32(Session["Admin"]) == 1)
            { 

               SqlCommand myCmd = mcObj.GetATSCmd(Convert.ToInt32(ddlJY.SelectedItem.Value.ToString()), keyId, Convert.ToInt32(ddlArea.SelectedIndex.ToString()), txtKey.Text.Trim(), ddlArea.SelectedItem.Text.ToString());
                prObj.GVBind(myCmd, gvList, "AJY");
            }
            else
            {
                SqlCommand myCmd = mcObj.GetSTSCmd(Convert.ToInt32(Session["UID"]), Convert.ToInt32(ddlJY.SelectedValue.ToString()), keyId, Convert.ToInt32(ddlArea.SelectedIndex.ToString()), txtKey.Text.Trim(), ddlArea.SelectedItem.Text.ToString());
                prObj.GVBind(myCmd, gvList, "SJY");
            }
            labFCondition.Text = ddlArea.SelectedItem.Text.Trim();
            labSCondition.Text =rdbJY.Text.Trim();
            labTCondition.Text = ddlJY.SelectedItem.Text.Trim();
            labKey.Text = txtKey.Text.Trim();

        }

    }
    //=============================================================
    // 方 法 名： gvKListBind()
    // 功能描述： 对GridView进行绑定，显示科学研究的资料
    // 输入参数： 无
    // 返 回 值： 无
    // ==============================================================
    public void gvKListBind(GridView gvList)
    {
        if ((Session["Admin"] == null) && (Session["isSearch"] == null))
        {
            Response.Write("<script>parent.location='../Default.aspx';</script>");
        }
        else
        {
            int keyId;
            if (txtKey.Text.Trim() == "")
            {
                keyId = 0;
            }
            else
            {
                keyId = 1;
            }
            if (Convert.ToInt32(Session["Admin"]) == 1)
            {

                SqlCommand myCmd = mcObj.GetATKYSCmd(Convert.ToInt32(ddlKY.SelectedItem.Value.ToString()), keyId, Convert.ToInt32(ddlArea.SelectedIndex.ToString()), txtKey.Text.Trim(), ddlArea.SelectedItem.Text.ToString());
                prObj.GVBind(myCmd, gvList, "AKY");
            }
            else
            {
                SqlCommand myCmd = mcObj.GetSTKYSCmd(Convert.ToInt32(Session["UID"]), Convert.ToInt32(ddlJY.SelectedValue.ToString()), keyId, Convert.ToInt32(ddlArea.SelectedIndex.ToString()), txtKey.Text.Trim(), ddlArea.SelectedItem.Text.ToString());
                prObj.GVBind(myCmd, gvList, "SKY");
            }
            labFCondition.Text = ddlArea.SelectedItem.Text.Trim();
            labSCondition.Text = rdbKY.Text.Trim();
            labTCondition.Text = ddlKY.SelectedItem.Text.Trim();
            labKey.Text = txtKey.Text.Trim();

        }

    }

    /// <summary>
    /// 显示用户基本资料信息
    /// </summary>
    /// <param name="gvList"></param>
    public void gvTListBind(GridView gvList)
    {
        if (Session["Username"] == null)
        {
            Response.Write("<script>parent.location='../Default.aspx';</script>");
        }
        else
        {
            int keyId;
            if (txtKey.Text.Trim() == "")
            {
                keyId = 0;
            }
            else
            {
                keyId = 1;
            }
            if (Convert.ToInt32(Session["Admin"]) == 1)
            {

                SqlCommand myCmd = mcObj.GetATISCmd(keyId, Convert.ToInt32(ddlArea.SelectedIndex.ToString()),txtKey.Text.Trim(), ddlArea.SelectedItem.Text.ToString(),ddlTS.SelectedItem.Text.ToString());
                prObj.GVBind(myCmd, gvList, "ATY");
            }
            else
            {
                SqlCommand myCmd = mcObj.GetSTICmd(Convert.ToInt32(Session["UID"]),keyId, Convert.ToInt32(ddlArea.SelectedIndex.ToString()), txtKey.Text.Trim(), ddlArea.SelectedItem.Text.ToString(),ddlTS.SelectedItem.Text.ToString());
                prObj.GVBind(myCmd, gvList, "STY");
            }
            labFCondition.Text = ddlArea.SelectedItem.Text.Trim();
            labSCondition.Text = rdbTS.Text.Trim();
            labTCondition.Text = ddlTS.SelectedItem.Text.Trim();
            labKey.Text = txtKey.Text.Trim();

        }

    }

    //重新搜索按钮
    protected void lnkbtnSearch_Click(object sender, EventArgs e)
    {
        Response.Redirect("BigSearch.aspx"); 
    }
    protected void rdbJY_CheckedChanged(object sender, EventArgs e)
    {
        ddlJY.Enabled = true;
        rdbKY.Checked = false;
        rdbTS.Checked = false;
        ddlKY.Enabled = false;
        ddlTS.Enabled = false;
    }
    protected void rdbKY_CheckedChanged(object sender, EventArgs e)
    {
        ddlKY.Enabled = true;
        rdbJY.Checked = false;
        rdbTS.Checked = false;
        ddlJY.Enabled = false;
        ddlTS.Enabled = false;
    }
    protected void rdbTS_CheckedChanged(object sender, EventArgs e)
    {
        ddlTS.Enabled = true;
        rdbJY.Checked = false;
        rdbKY.Checked = false;
        ddlJY.Enabled = false;
        ddlKY.Enabled = false;

    }
}