accounts_users.aspx.cs

很不错的公文流转系统

using System; 
using System.Collections;
using System.ComponentModel;
using System.Data;
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 OI.DatabaseOper ;
using System.Diagnostics ;
using System.Data.SqlClient;
using ZHENGYI;


namespace OI.Manage
{
	/// <summary>
	/// Accounts_Users 的摘要说明。
	/// </summary>
	public class Accounts_Users :OI.PageBase 
	{
		protected System.Web.UI.WebControls.DataGrid DataGridAccounts_Users;
		protected System.Web.UI.WebControls.TextBox TextBoxSelect;
		protected System.Web.UI.WebControls.DropDownList DropDownListSelect;
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Web.UI.WebControls.ImageButton ImageButton1;
		protected ZHENGYI.DataGridNavigation divepage;
		protected System.Web.UI.WebControls.ImageButton ImageButtonSave;
		protected System.Web.UI.HtmlControls.HtmlInputText movingto;
		protected System.Web.UI.HtmlControls.HtmlInputButton btnmove;
		protected System.Web.UI.HtmlControls.HtmlInputHidden position;
		private DatabaseConnect dc; 
		
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if (Session["userid"]==null)
			{
				Response.Write ("<script>alert('超时,请重新登录');top.location.href='../userpass.aspx';</script>");
				return ;
			}
			dc=new DatabaseConnect();
			SetDivePage();
			if(!Page.IsPostBack)
			{
				
				this.Bind();
			}
		}
		


		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.ImageButton1.Click += new System.Web.UI.ImageClickEventHandler(this.ImageButton1_Click);
			this.DataGridAccounts_Users.ItemCreated += new System.Web.UI.WebControls.DataGridItemEventHandler(this.DataGridAccounts_Users_ItemCreated);
			this.DataGridAccounts_Users.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGridAccounts_Users_Delete);
			this.DataGridAccounts_Users.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.DataGridAccounts_Users_ItemDataBound);
			this.DataGridAccounts_Users.SelectedIndexChanged += new System.EventHandler(this.DataGridAccounts_Users_SelectedIndexChanged);
			this.ImageButtonSave.Click += new System.Web.UI.ImageClickEventHandler(this.ImageButtonSave_Click);
			this.btnmove.ServerClick += new System.EventHandler(this.btnmove_ServerClick);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion
		
		/// <summary>
		/// 链接到增加页面
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void SetDivePage()
		{
			DataGridAccounts_Users.AllowPaging =true; 
			
			
			ZHENGYI.BindDataDelegate f =new ZHENGYI.BindDataDelegate (Bind);//修改这个dataBind,让f 指向你的方法。 
			divepage.SetTarget(DataGridAccounts_Users,f,15);
		}
		
	
		private ArrayList al=new ArrayList();//保存部门节点的和其子节点的所有departmentid值
		
		private void SelectDepartmentID(string parentid)
		{
			
			string sql="select departmentid from departments where parentdepartmentid='"+parentid+"'";
			ArrayList aldepartmentid=dc.getData(sql);
			for(int i=0;i<aldepartmentid.Count;i++)
			{  
				al.Add(aldepartmentid[i].ToString());
				SelectDepartmentID(aldepartmentid[i].ToString());
			}
			
		}
		/// <summary>
		///判断是不是管理员
		/// </summary>
		/// <returns></returns>
		private bool IsAdinistrator()
		{
			
			dc=new DatabaseConnect();
			string sql="select parentdepartmentid from departments where departmentid="+Convert.ToInt32(Session["departmentid"]);
			if(Convert.ToString(dc.GetObjectBySql(sql))=="0")
				return true;
			else
				return false;
			
		}
		/// <summary>
		/// 返回被删除人员的部门ID
		/// </summary>
		/// <returns></returns>
		private string DepartnentID()
		{   
			dc=new DatabaseConnect();
			string sql="select departmentid from departments where departmentname='不确定'";
			string departmentid=Convert.ToString(dc.GetObjectBySql(sql));
			return departmentid;
		}



	
		private void Bind()
		{
			
			dc=new DatabaseConnect();
			al.Add(Session["departmentid"].ToString());
			SelectDepartmentID(Session["departmentid"].ToString());//获得部门节点的和其子节点的所有departmentid值
			string str;
			//bool isadminstrator=IsAdinistrator();
			if(IsAdinistrator())
			{
				string departmentid=DepartnentID();
			    str="(";
				str+=departmentid+",";
				for(int i=0;i<al.Count;i++)
				{
					if(i!=al.Count-1)
						str+=al[i].ToString()+",";
					else
						str+=al[i].ToString();

				}
				str+=")";
			}
			else
			{
			    str="(";
				for(int i=0;i<al.Count;i++)
				{
					if(i!=al.Count-1)
						str+=al[i].ToString()+",";
					else
						str+=al[i].ToString();

				}
				str+=")";

			}
				
		
	
			
			string con=null;
		
			if(DropDownListSelect.SelectedValue .Trim ()=="请选择")
				con=null;
			else if(DropDownListSelect.SelectedValue .Trim ()=="姓名")
				con=" and UserName LIKE '%"+TextBoxSelect.Text .Trim ()+"%'";
			else if(DropDownListSelect.SelectedValue.Trim()=="部门")
				con=" and departmentname LIKE'%"+TextBoxSelect.Text .Trim ()+"%'";
			else if(DropDownListSelect.SelectedValue .Trim ()=="性别")
			{
				switch(TextBoxSelect.Text .Trim ())
				{
					case "女":con=" and Sex= 0";break;
					case "男":con=" and Sex= 1";break;
					default: con=" and Sex=0";break;
				}
			}
				
			else if(DropDownListSelect.SelectedValue .Trim ()=="电话")
				con=" and Telephone LIKE '%"+TextBoxSelect.Text .Trim ()+"%'";
			else if(DropDownListSelect.SelectedValue .Trim ()=="移动电话")
				con=" and Mobile LIKE '%"+TextBoxSelect.Text .Trim ()+"%'";
			else if(DropDownListSelect.SelectedValue .Trim ()=="Email")
				con=" and Email LIKE '%"+TextBoxSelect.Text .Trim ()+"%'";
			string strUser="select UserID,Accounts_Users.displayorder,UserName,departmentname,case sex when 1 then '男' when 0 then '女'end as sex,Telephone,Mobile,Email, "+
				"case  when "+
				"len((Content ))>10 "+
				"then SUBSTRING(Content,1,10)+'...' "+
				"else Content "+
				"end "+
				"AS Content "+
				"FROM dbo.Accounts_Users inner join dbo.Departments on dbo.Accounts_Users.DepartmentID =dbo.Departments.DepartmentID where dbo.Accounts_Users.DepartmentID in  "+str+con;
		      // "FROM dbo.Accounts_Users inner join dbo.Departments on dbo.Accounts_Users.DepartmentID =dbo.Departments.DepartmentID where 1=1  "+con;
				strUser += " order by Accounts_Users.displayorder  ";
			DataSet ds=new DataSet();
			try
			{
				ds=dc.getBinding(strUser,"Accounts_Users");
			}
			catch(System.Data.SqlClient.SqlException ex)
			{
				throw new AppException("此语句发生错误:"+strUser,ex);
			}
			
			
			DataGridAccounts_Users.DataSource =ds.Tables ["Accounts_Users"].DefaultView ;
			DataGridAccounts_Users.DataBind();
			
		}


		

	


		//	}