search.aspx.cs

除了具有传统OA的邮件、工作流、文档等功能外

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 partial class Search : System.Web.UI.Page
	{

		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;
			}
		}

		//Email
		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"),
		};

		private string[] FieldsName = {"StaffName","RealName","Mobile","Gender","Email","PositionName"};

		protected 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()
		{    

		}
		#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);
			}

		}
		protected 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)
		{
		
		}

		protected void btn_Search_Click(object sender, System.EventArgs e)
		{
			Server.Transfer("ResultList.aspx");

		}

		protected 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;
			}
			
		}

		protected 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;
			}
			
		}

		protected 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 = "选择显示字段>>>";
			}
		}

		protected void lbx_Fields_SelectedIndexChanged(object sender, System.EventArgs e)
		{
		
		}

		
	}
}