departmentmanage.aspx.cs

很不错的公文流转系统

					" , IsStepPass="+IsStepPass+" WHERE departmentID="+tempTN.ID ;
				sqls[3]=" update accounts_users set username='"+DepName.Text.Trim()+"收文人员'"+" where departmentid="+tempTN  + " and username like '%收文人员'";
				
				try
				{
					dc.ExcuteSqls(sqls)      ;
					Page.RegisterStartupScript ("","<script>alert('修改成功');window.location='DepartMentManage.aspx';</script>");
				
				}
				catch
				{
					
					Page.RegisterStartupScript ("","<script>alert('修改失败');window.location='DepartMentManage.aspx';</script>");
				}
				CreateDataSource();
			}
		}
		/// <summary>
		/// 返回新增部门的ID
		/// </summary>
		/// <param name="parentid"></param>
		/// <returns></returns>
		private int GetDepartmentID(string parentid)
		{
			OI.DatabaseOper.DatabaseConnect dc=new DatabaseConnect();
	
			SqlParameter[] parameters={
										  new SqlParameter("@parentdepartmentid" ,SqlDbType.Int,4),
										  new SqlParameter("@departmentname",SqlDbType.VarChar,40),
										  new SqlParameter("@tel1",SqlDbType.VarChar,30),
										  new SqlParameter("@tel2",SqlDbType.VarChar,30),
										  new SqlParameter("@fax",SqlDbType.VarChar,30),
										  new SqlParameter("@ispublic",SqlDbType.Bit,1),
										  new SqlParameter("@departmentid",SqlDbType.Int,4),
				                          new SqlParameter ("@IsStepPass",SqlDbType.Bit,1),
									  };
			parameters[0].Value=Convert.ToInt32(parentid);
			parameters[1].Value=DepName.Text .Trim ();
			parameters[2].Value=tel1.Text .Trim ();
			parameters[3].Value=tel2.Text .Trim ();
			parameters[4].Value=fax.Text .Trim ();
			parameters[5].Value=1;
			parameters[6].Direction=ParameterDirection.Output;
			if (checkboxTransmit.Checked)
			{parameters[7].Value=1; }
			else
			{ parameters[7].Value=0;}
			dc.RunCommand("departmentadmin",parameters);
			return Convert.ToInt32(parameters[6].Value);
		}

		private void ButtonModi_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			ButtonAdd.Visible =false;
			ButtonModi.Visible =false;			
			ImageButton_Delete.Visible=false;
			state.Visible =false;
			ButtonSave.Visible =true;
			TextBoxSaveButton.Text ="修改";
			this.dispInput (true);
			a6.Visible =false;
			checkboxReceive.Visible =false;
               
			this.emptyData ();
			TreeNode tempTN=TreeViewDepart.GetNodeFromIndex (TreeViewDepart.SelectedNodeIndex );
			string sql="SELECT DepartmentName,Tel1,Tel2,Fax ,IsStepPass FROM Departments WHERE DepartmentID='"+tempTN.ID .Trim ()+"' order by displayorder";
			ArrayList al=dc.getData (sql);
			if(al.Count >0)
			{
				DepName.Text =al[0].ToString ();
				tel1.Text =al[1].ToString ();
				tel2.Text =al[2].ToString ();
				fax.Text =al[3].ToString ();
				if (al[4].ToString ()=="True")
				{
				   checkboxTransmit.Checked =true;
				}
				else
				{
					 checkboxTransmit.Checked =false;
				}
			}
		}
		

		private void ButtonAdd_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			ButtonAdd.Visible =false;
			ButtonModi.Visible =false;			
			state.Visible =false;
			ButtonSave.Visible =true;
			ImageButton_Delete.Visible=false;
			TextBoxSaveButton.Text ="增加";
			this.dispInput (true);
			this.enableControler (true);
		}

		private void clickSelected(object sender, Microsoft.Web.UI.WebControls.TreeViewClickEventArgs e)
		{
			this.dispButton (true,false);			
		}

//		private void ButtonSave_Click(object sender, System.EventArgs e)
//		{
//			TreeNode tempTN=TreeViewDepart.GetNodeFromIndex (TreeViewDepart.SelectedNodeIndex );
//			if(TextBoxSaveButton.Text .Trim ()=="增加")
//			{
//				string sql="INSERT INTO departments(ParentDepartmentID,departmentName,tel1,tel2,fax,isPublic)"+
//					"VALUES('"+tempTN.ID +"','"+DepName.Text .Trim ()+"','"+tel1.Text .Trim ()+"','"+tel2.Text .Trim ()+"','"+fax.Text .Trim ()+"',1)";
//				dc.addData (sql);
//				this.emptyData ();
//				Page.RegisterStartupScript ("","<script>alert('增加成功')</script>");
//				Response.Redirect("");
//			}
//			if(TextBoxSaveButton.Text .Trim ()=="修改" &&tempTN.ID !="0")
//			{	
//				if(tempTN.ID .Trim ()=="0")
//					return;
//				string sql="UPDATE departments SET DepartmentName='"+DepName.Text .Trim ()+"',Tel1='"+tel1.Text .Trim ()+"',Tel2='"+tel2.Text .Trim ()+"',Fax='"+fax.Text .Trim ()+"'"+
//					"WHERE departmentID='"+tempTN.ID +"'";
//				dc.updateData (sql);
//				Page.RegisterStartupScript ("","<script>alert('修改成功')</script>");
//			}
//			else
//			{
//				Page.RegisterStartupScript ("","<script>alert('修改失败')</script>");
//			}
//			//this.CreateDataSource ();
//		}

		private void changeSelected(object sender, Microsoft.Web.UI.WebControls.TreeViewSelectEventArgs e)
		{
			this.DispComp (false);
			TreeNode tempTN=TreeViewDepart.GetNodeFromIndex (TreeViewDepart.SelectedNodeIndex );
			if(tempTN.ID .Trim ()=="0")
				state.Visible =false;
			else
				state.Visible =true;

			string sql="SELECT TOP 1 IsPublic FROM departments WHERE DepartmentID='"+tempTN.ID .Trim ()+"' order by displayorder";
			ArrayList al=dc.getData (sql);
			if(al.Count ==1)
			{
				if(Convert.ToBoolean (al[0].ToString ()))
					state.ImageUrl  ="../images/jy.gif";
				else
					state.ImageUrl ="../images/qy.gif";
			}			
			this.dispButton (true,true);
			this.emptyData ();
			/*
			ButtonAdd.Visible =true;
			ButtonModi.Visible =true;			
			state.Visible =true;*/
			ButtonSave.Visible =false;			
		}
	
		private void CreateChildNode (int Parentid, ref TreeNode Pnode)
		{
			string sqlstr ="SELECT DepartmentId,DepartmentName,IsPublic FROM departments WHERE ParentDepartmentID='"+Parentid+"' order by  displayorder";
			DataSet ds=new DataSet ();
			ds=dc.getBinding (sqlstr,"s");
			foreach (DataRow dr in ds.Tables[0].Rows )
			{
				TreeNode node=new TreeNode ();
				node.Text =dr["DepartmentName"].ToString ();
				node.ID =dr["DepartmentId"].ToString ();
				/*
						if (dr["menupath"].ToString () !="")
						{
							node.NavigateUrl=dr["menupath"].ToString ();
							node.Target ="main";
						}*/
				if(Convert.ToBoolean ( dr["IsPublic"].ToString ().Trim ()))
				{
					CreateChildNode(Convert.ToInt32(dr["DepartmentId"]),ref node);
				}
				Pnode.Nodes .Add(node);
							
						
			}
				
		}
		private void create()
		{
			string sql="select ParentDepartmentID from departments where DepartmentID="+Convert.ToInt32(Session["departmentid"]) +" order by displayorder";
		//	int parentid= dc.IFExist(sql);
			int parentid;
			object o =dc.GetObjectBySql(sql);
			if (o ==null || o.ToString ()=="")
			{
				parentid=0;
			}
			else
			{
				parentid=int.Parse (o.ToString ());
			}
			
			pid.Add(Convert.ToInt32(Session["departmentid"]));
			pid.Add(parentid);
			create(parentid);
		}
		private void create(int parentid )
		{
			if( parentid!=0 )
			{
				string sql="select ParentDepartmentID from departments where DepartmentID="+parentid +" order by displayorder";
				int parentid1= dc.IFExist(sql);
				pid.Add(parentid1);
				create(parentid1);
			}
						  
		}
		private void creatnode()
		{
			for(int i=pid.Count-1; i>=0; i--)
			{
				if(Convert.ToInt32(pid[i])==0)
				{
					CreateDataSource();
				}
				else
				{
					CreateDataSource(Convert.ToInt32(pid[i]));
				}
			}
		}
		
		private void CreateDataSource()
		{
			TreeViewDepart.Nodes .Clear ();
			TreeNode node=new TreeNode ();
			node.Text ="开始";
			node.ID ="0";
			nodeTemp=node;
			TreeViewDepart.Nodes.Add (node);
			
		}
		private void CreateDataSource(int departmentid )
		{
			string sqlstr="select departmentname from departments where departmentid="+departmentid +" order by  displayorder";
			DataSet ds=new DataSet();
			ds=dc.getBinding (sqlstr,"s");
			TreeNode node=new TreeNode ();
			foreach (DataRow dr in ds.Tables[0].Rows )
			{
				node.Text =dr["DepartmentName"].ToString ();
				node.ID =departmentid.ToString();

			}
			nodeTemp.Nodes.Add(node);
			nodeTemp=node;



		}
		private void CreateChildDepartment()
		{
			string sql="Select departmentid from departments where parentdepartmentid="+Convert.ToInt32(pid[0]) +" order by  displayorder  ";
			ArrayList al=dc.getData(sql);
			if(al.Count!=0)
			{
				TreeNode node=new TreeNode();
				node=nodeTemp;
				CreateChildNode(Convert.ToInt32(pid[0]),ref node);
			}
		}

		private void ImageButton_Delete_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			string id=TreeViewDepart.GetNodeFromIndex(TreeViewDepart.SelectedNodeIndex).ID;
//			string []sqls=new string [2];
//			
//			sqls[0]="delete accounts_users where departmentid="+id +" and username like '%收文人员'" ;
//			sqls[1]="delete departments where departmentid="+id;
//			try
//			{
//				
//				dc.ExcuteSqls (sqls);
//			}
//			catch(Exception er)
//			{
//				Response.Write (er.Message );
//				Response.End ();
//			}
			try
			{
				int currentdepartmentID=int.Parse (id);
			
				delDepartment(currentdepartmentID);
			}
			catch
			{
			}
			
			Response.Redirect("DepartmentManage.aspx");

		}
		private void delDepartment(int currentID)
		{
             string sql="select  departmentID,parentDepartmentID from departments where parentDepartmentID="+currentID.ToString ();
		     DataSet ds=new DataSet (); 
			try
			{
				ds=dc.getBinding (sql,"t");
			}
			catch(Exception er)
			{
				Response.Write (er.Message );
				Response.End ();
			}
			foreach( DataRow  dr in  ds.Tables[0].Rows)
			{
				delDepartment(int.Parse (dr["departmentID"].ToString ()));
			}
            string []sqls=new string [3];
			sqls[0]="delete accounts_users where departmentid="+currentID.ToString () +" and username like '%收文人员'" ;
			sqls[1]=" update accounts_users set departmentid=0 where departmentid="+currentID.ToString ();
			sqls[2]=" delete  from departments where departmentid="+currentID.ToString ();
			try
			{
				
				dc.ExcuteSqls (sqls);
			}
			catch(Exception er)
			{
				Response.Write (er.Message );
				Response.End ();
			}

		}

		private void btnorderBy_Click(object sender, System.EventArgs e)
		{
		    TreeNode tempTN=TreeViewDepart.GetNodeFromIndex (TreeViewDepart.SelectedNodeIndex );
			string departmentid=tempTN.ID .Trim ();
			Response.Redirect ("departmentpx.aspx?departmentid="+departmentid);
		}
		  
	
	
	}
	public class checkDepartment:System.Web .UI.Page 
	{
		public checkDepartment()
		{
		}
		/// <summary>
		/// 检查当前部门在数据库中是否存在
		/// </summary>
		/// <param name="departmentName">用户名</param>
		/// <returns></returns>
		public bool ExistDepartment(string departmentName)
		{
			OI.DatabaseOper.DatabaseConnect  dc=new DatabaseConnect();
			string sql="select count(*)  from departments where departmentname='"+departmentName+"'" ;
			int count=0;
			try
			{
				count =int.Parse (dc.GetValueBySql(sql));
			}
			catch(Exception er)
			{
				Response.Write (er.Message );
				Response.End ();
			}
			if (count>0)
			{
				return true;
			}
			return false;
		}
		/// <summary>
		/// 检查当前部门在数据库中是否存在，此方法用在部门修改
		/// </summary>
		/// <param name="departmentName">用户名</param>
		/// <param name="userid">原用户ID</param>
		/// <returns></returns>
		public bool ExistDepartment(string departmentName,int  departmentid)
		{
			OI.DatabaseOper.DatabaseConnect  dc=new DatabaseConnect();
			string sql="select count(*)  from departments where departmentname='"+departmentName+"' and departmentid !="+departmentid.ToString () ;
			int count=0;
			try
			{
				count =int.Parse (dc.GetValueBySql(sql));
			}
			catch(Exception er)
			{
				Response.Write (er.Message );
				Response.End ();
			}
			if (count>0)
			{
				return true;
			}
			return false;
		}
	}
	}