Search.aspx.cs
资源名称:OAJP.rar [点击查看]
上传用户:jdb8708888
上传日期:2013-05-29
资源大小:19971k
文件大小:7k
源码类别:
WEB源码(ASP,PHP,...)
开发平台:
C#
- using System;
- using System.Collections;
- using System.ComponentModel;
- using System.Data;
- using System.Data.SqlClient;
- using System.Drawing;
- using System.Web;
- using System.Web.SessionState;
- using System.Web.UI;
- using System.Web.UI.WebControls;
- using System.Web.UI.HtmlControls;
- using UDS.Components;
- namespace UDS.SubModule.Staff.Sch
- {
- /// <summary>
- /// Search 的摘要说明。
- /// </summary>
- public class Search : System.Web.UI.Page
- {
- protected System.Web.UI.WebControls.TextBox tbx_Name;
- protected System.Web.UI.WebControls.DropDownList ddl_Position;
- protected System.Web.UI.WebControls.LinkButton lbtn_Others;
- protected System.Web.UI.WebControls.Button btn_Search;
- protected System.Web.UI.WebControls.LinkButton lbtn_SelectField;
- protected System.Web.UI.HtmlControls.HtmlTable table_Field;
- protected System.Web.UI.WebControls.Button btn_In;
- protected System.Web.UI.WebControls.Button btn_Out;
- protected System.Web.UI.WebControls.ListBox lbx_Fields;
- protected System.Web.UI.WebControls.ListBox lbx_SelectedFields;
- private string TopTable = "";
- #region 查询选项
- //登陆名或姓名
- public string StaffName
- {
- get
- {
- return tbx_Name.Text;
- }
- }
- //所选职位
- public int Postion
- {
- get
- {
- return Int32.Parse(ddl_Position.SelectedValue);
- }
- }
- //手机号码
- public string Mobile
- {
- get
- {
- return tbx_Mobile.Text;
- }
- }
- public string Email
- {
- get
- {
- return tbx_Email.Text;
- }
- }
- //性别
- public string Gender
- {
- get
- {
- return ddl_Gender.SelectedValue;
- }
- }
- //手机选项
- public bool MobileSwitch
- {
- get
- {
- return cbx_Mobile.Checked;
- }
- }
- //Email选项
- public bool EmailSwitch
- {
- get
- {
- return cbx_Email.Checked;
- }
- }
- //性别选项
- public bool GenderSwitch
- {
- get
- {
- return cbx_Gender.Checked;
- }
- }
- //查询选项
- public string SearchBound
- {
- get
- {
- return ddl_SearchBound.SelectedValue;
- }
- }
- //显示的字段,内容是datagrid的列序号
- public int[] SelectedFields
- {
- get
- {
- int[] number = new int[lbx_SelectedFields.Items.Count];
- for(int i=0;i<number.Length;i++)
- {
- number[i] = Int32.Parse(lbx_SelectedFields.Items[i].Value);
- }
- return number;
- }
- }
- //选中的字段名
- public string[] SelectedFieldsName
- {
- get
- {
- string[] name = new string[lbx_SelectedFields.Items.Count];
- for(int i=0;i<name.Length;i++)
- {
- name[i] = FieldsName[Int32.Parse(lbx_SelectedFields.Items[i].Value)];
- }
- return name;
- }
- }
- #endregion
- private System.Web.UI.WebControls.ListItem[] Fields ={
- new ListItem("用户名","0"),
- new ListItem("姓名","1"),
- new ListItem("手机","2"),
- new ListItem("性别","3"),
- new ListItem("Email","4"),
- new ListItem("职位","5"),
- };
- protected System.Web.UI.HtmlControls.HtmlTable table_Other;
- protected System.Web.UI.WebControls.DropDownList ddl_Gender;
- protected System.Web.UI.WebControls.CheckBox cbx_Gender;
- protected System.Web.UI.WebControls.TextBox tbx_Email;
- protected System.Web.UI.WebControls.CheckBox cbx_Email;
- protected System.Web.UI.WebControls.TextBox tbx_Mobile;
- protected System.Web.UI.WebControls.CheckBox cbx_Mobile;
- protected System.Web.UI.WebControls.DropDownList ddl_SearchBound;
- private string[] FieldsName = {"StaffName","RealName","Mobile","Gender","Email","PositionName"};
- private void Page_Load(object sender, System.EventArgs e)
- {
- cbx_Mobile.Attributes["onclick"] = "document.getElementById('tbx_Mobile').disabled = !document.getElementById('tbx_Mobile').disabled";
- cbx_Email.Attributes["onclick"] = "document.getElementById('tbx_Email').disabled = !document.getElementById('tbx_Email').disabled";
- cbx_Gender.Attributes["onclick"] = "document.getElementById('ddl_Gender').disabled = !document.getElementById('ddl_Gender').disabled";
- if(!Page.IsPostBack)
- {
- table_Other.Visible = false;
- table_Field.Visible = false;
- BindPosition();
- BindDefaultField();
- ViewState["TopTable"] = TopTable;
- }
- else
- {
- TopTable = ViewState["TopTable"].ToString();
- }
- }
- #region Web 窗体设计器生成的代码
- override protected void OnInit(EventArgs e)
- {
- //
- // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
- //
- InitializeComponent();
- base.OnInit(e);
- }
- /// <summary>
- /// 设计器支持所需的方法 - 不要使用代码编辑器修改
- /// 此方法的内容。
- /// </summary>
- private void InitializeComponent()
- {
- this.btn_Search.Click += new System.EventHandler(this.btn_Search_Click);
- this.lbtn_Others.Click += new System.EventHandler(this.lbtn_Others_Click);
- this.lbtn_SelectField.Click += new System.EventHandler(this.lbtn_SelectField_Click);
- this.btn_Out.Click += new System.EventHandler(this.btn_Out_Click);
- this.lbx_Fields.SelectedIndexChanged += new System.EventHandler(this.lbx_Fields_SelectedIndexChanged);
- this.btn_In.Click += new System.EventHandler(this.btn_In_Click);
- this.Load += new System.EventHandler(this.Page_Load);
- }
- #endregion
- private void BindPosition()
- {
- Database db = new Database();
- SqlDataReader dr;
- db.RunProc("SP_Ext_GetPosition",out dr);
- ddl_Position.DataSource = dr;
- ddl_Position.DataTextField = "Position_Name";
- ddl_Position.DataValueField = "Position_ID";
- ddl_Position.DataBind();
- ddl_Position.Items.Insert(0,new ListItem("全部职位","0"));
- }
- private void BindDefaultField()
- {
- foreach(ListItem li in Fields)
- {
- lbx_SelectedFields.Items.Add(li);
- }
- }
- private void lbtn_Others_Click(object sender, System.EventArgs e)
- {
- table_Other.Visible = !table_Other.Visible;
- if(table_Other.Visible == true)
- {
- lbtn_Others.Text = "其它查询选项<<<";
- }
- else
- {
- lbtn_Others.Text = "其它查询选项>>>";
- }
- }
- private void cbx_Gender_CheckedChanged(object sender, System.EventArgs e)
- {
- }
- private void btn_Search_Click(object sender, System.EventArgs e)
- {
- Server.Transfer("ResultList.aspx");
- }
- private void btn_In_Click(object sender, System.EventArgs e)
- {
- if(lbx_Fields.SelectedItem!=null)
- {
- lbx_SelectedFields.Items.Add(lbx_Fields.SelectedItem);
- lbx_Fields.Items.Remove(lbx_Fields.SelectedItem);
- if(lbx_Fields.Items.Count!=0)
- lbx_Fields.Items[0].Selected = true;
- lbx_SelectedFields.Items[lbx_SelectedFields.SelectedIndex].Selected = false;
- }
- }
- private void btn_Out_Click(object sender, System.EventArgs e)
- {
- if(lbx_SelectedFields.SelectedItem!=null)
- {
- lbx_Fields.Items.Add(lbx_SelectedFields.SelectedItem);
- lbx_SelectedFields.Items.Remove(lbx_SelectedFields.SelectedItem);
- if(lbx_SelectedFields.Items.Count!=0)
- lbx_SelectedFields.Items[0].Selected = true;
- lbx_Fields.Items[lbx_Fields.SelectedIndex].Selected = false;
- }
- }
- private void lbtn_SelectField_Click(object sender, System.EventArgs e)
- {
- table_Field.Visible = !table_Field.Visible;
- if(table_Field.Visible == true)
- {
- lbtn_SelectField.Text = "选择显示字段<<<";
- }
- else
- {
- lbtn_SelectField.Text = "选择显示字段>>>";
- }
- }
- private void lbx_Fields_SelectedIndexChanged(object sender, System.EventArgs e)
- {
- }
- }
- }