zzjg_contrl.cs

工资管理系统

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using Datamodel;

namespace Data_Contrl
{
	/* ****************************************************	
				   重庆杰诺软件开发工作室

	QQ:83898700
	EMAIL:[e-mail]
	url:www.gisii.com
	***************************************************** */
	/// <summary>
	/// zzjg_Contrl 的摘要说明。
	/// </summary>
	public class zzjg_Contrl
	{
		public zzjg_Contrl()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		/// <summary>
		/// 部门维护的树形菜单
		/// </summary>
		/// <returns></returns>
		public string TreeLoad()
		{
			CreateDb mydb = new CreateDb();
			IDataReader Rs=null;
			DBManager my = mydb.Createdb();
			my.OpenConn();
			string strSQL="select * from H_bm order by id asc";
			Rs=my.ExecuteCreateReader(my.ExeCommand(strSQL));
			string arr_tree="<DIV class=deeptree>";
			arr_tree+="<script lanage=javascript>";
			arr_tree+="var a=new TreeView(\'a\',\'main\');";
			while(Rs.Read()==true)
			{
				arr_tree+="a.add("+Rs["id"]+","+Rs["Parentid"]+",\""+Rs["bmnr"].ToString()+"\",\"sys_zzjg.aspx?id="+Rs["id"]+"&NodeName="+Rs["bmnr"]+"\",\"parnent\");";
			}
			arr_tree+="document.write(a);";
			arr_tree+="a.expandAll();";
			arr_tree+="</script>";
			arr_tree+="</DIV>";
			Rs.Close();
			my.CloseConn();
			return arr_tree;
		}
		/// <summary>
		/// 设备维护的部门树
		/// </summary>
		/// <returns></returns>
		public string Sbwf_TreeLoad()
		{
			CreateDb mydb = new CreateDb();
			IDataReader Rs=null;
			DBManager my = mydb.Createdb();
			my.OpenConn();
			string strSQL="select * from H_bm order by id asc";
			Rs=my.ExecuteCreateReader(my.ExeCommand(strSQL));
			string arr_tree="<DIV class=deeptree>";
			arr_tree+="<script lanage=javascript>";
			arr_tree+="var a=new TreeView(\'a\',\'main\');";
			while(Rs.Read()==true)
			{
				arr_tree+="a.add("+Rs["id"]+","+Rs["Parentid"]+",\""+Rs["bmnr"].ToString()+"\",\"sbwf.aspx?id="+Rs["id"]+"&NodeName="+Rs["bmnr"]+"\",\"parnent\");";
			}
			arr_tree+="document.write(a);";
			arr_tree+="a.expandAll();";
			arr_tree+="</script>";
			arr_tree+="</DIV>";
			Rs.Close();
			my.CloseConn();
			return arr_tree;
		}
		/// <summary>
		/// 维护界面的主部门
		/// </summary>
		/// <param name="Parentid"></param>
		/// <returns></returns>
		public string WfTreeinit(int Parentid)
		{
			CreateDb mydb = new CreateDb();
			IDataReader Rs=null;
			DBManager my = mydb.Createdb();
			my.OpenConn();
			string strSQL="select * from H_bm where id="+Parentid+" order by id asc";
			Rs=my.ExecuteCreateReader(my.ExeCommand(strSQL));
			string arr_tree="<DIV class=deeptree>";
			arr_tree+="<script lanage=javascript>";
			arr_tree+="var a=new TreeView(\'a\',\'main\');";
			while(Rs.Read()==true)
			{
				arr_tree+="a.add("+Rs["id"]+",0,\""+Rs["bmnr"].ToString()+"\",\"sbwf.aspx?id="+Rs["id"]+"&NodeName="+Rs["bmnr"]+"\",\"parnent\");";
				arr_tree+=WfGetSub(Convert.ToInt32(Rs["id"].ToString()));
			}
			arr_tree+="document.write(a);";
			arr_tree+="a.expandAll();";
			arr_tree+="</script>";
			arr_tree+="</DIV>";
			Rs.Close();
			my.CloseConn();
			return arr_tree;
		}
		/// <summary>
		/// 维护界面需要的子部门
		/// </summary>
		/// <param name="Parentid"></param>
		/// <returns></returns>
		public string WfGetSub(int Parentid)
		{
			CreateDb mydb = new CreateDb();
			IDataReader Rs=null;
			DBManager my = mydb.Createdb();
			my.OpenConn();
			string strSQL="select * from H_bm where parentid="+Parentid+" order by id asc";
			Rs=my.ExecuteCreateReader(my.ExeCommand(strSQL));
			string arr_tree=string.Empty;
			while(Rs.Read()==true)
			{
				arr_tree+="a.add("+Rs["id"]+","+Rs["Parentid"]+",\""+Rs["bmnr"].ToString()+"\",\"sbwf.aspx?id="+Rs["id"]+"&NodeName="+Rs["bmnr"]+"\",\"parnent\");";
				arr_tree+=WfGetSub(Convert.ToInt32(Rs["id"].ToString()));
			}

			Rs.Close();
			my.CloseConn();
			return arr_tree;
		}
		/// <summary>
		/// 生成一个完整的部门树
		/// </summary>
		/// <param name="sel"></param>
		/// <returns></returns>
		public string TreeLoad(string sel)
		{
			CreateDb mydb = new CreateDb();
			IDataReader Rs=null;
			DBManager my = mydb.Createdb();
			my.OpenConn();
			string strSQL="select * from H_bm order by id asc";
			Rs=my.ExecuteCreateReader(my.ExeCommand(strSQL));
			string arr_tree="<DIV class=deeptree>";
			arr_tree+="<script lanage=javascript>";
			arr_tree+="var a=new TreeView(\'a\',\'main\');";
			while(Rs.Read()==true)
			{
				arr_tree+="a.add("+Rs["id"]+","+Rs["Parentid"]+",\""+Rs["bmnr"].ToString()+"\",\"\");";
			}
			arr_tree+="document.write(a);";
			arr_tree+="a.expandAll();";
			arr_tree+="</script>";
			arr_tree+="</DIV>";
			Rs.Close();
			my.CloseConn();
			return arr_tree;
		}
		/// <summary>
		/// 增加主部门
		/// </summary>
		/// <param name="id"></param>
		/// <param name="bmnr"></param>
		/// <returns></returns>
		public string Tree_Create(int id,string bmnr)
		{
			string  sqlstr="insert into H_bm (Parentid,bmnr) values ("+id+",'"+bmnr+"')";
			try
			{
				CreateDb mydb = new CreateDb();
				DBManager my = mydb.Createdb();
				my.OpenConn();
				my.ExecutenonQuery(my.ExeCommand(sqlstr));
				my.CloseConn();
				return "增加栏目成功";
			}
			catch(Exception e)
			{
				throw (e);
			}
		}
		/// <summary>
		/// 删除部门
		/// </summary>
		/// <param name="id"></param>
		/// <returns></returns>
		public string Tree_Del(int id)
		{
			try
			{
				CreateDb mydb = new CreateDb();
				DBManager my = mydb.Createdb();
				my.OpenConn();
				string Sqlstr="select * from H_bm where parentid="+id;
				IDataReader Rs=null;
				Rs=my.ExecuteCreateReader(my.ExeCommand(Sqlstr));
				if(Rs.Read()==true)
				{
					Rs.Close();
					return "不能删除他下面还有子栏目！";
				}
				else
				{
					Rs.Close();
					try
					{
						my.CloseConn();
						CreateDb mydb1 = new CreateDb();
						DBManager my1 = mydb.Createdb();
						my1.OpenConn();
						string sqlStr1="delete from H_bm where id="+id;
						my1.ExecutenonQuery(my1.ExeCommand(sqlStr1));
						my1.CloseConn();
						CreateDb mydb2 = new CreateDb();
						DBManager my2 = mydb.Createdb();
						my2.OpenConn();
						string sqlStr2="delete from H_Sb_info where classid="+id;
						my2.ExecutenonQuery(my2.ExeCommand(sqlStr2));
						my2.CloseConn();						
						return "删除栏目成功!";

					}
					catch
					{
						return "删除不成功";
					}
				}
			}
			catch
			{
				return "不能删除栏目！";
			}
		}
		/// <summary>
		/// 修改树
		/// </summary>
		/// <param name="TreeList"></param>
		public string Tree_Update(int id,string bmnr)
		{
			try
			{
				string sqlStr="Update H_bm set bmnr='"+bmnr+"' where id="+id;
				CreateDb mydb = new CreateDb();
				DBManager my = mydb.Createdb();
				my.OpenConn();
				my.ExecutenonQuery(my.ExeCommand(sqlStr));
				my.CloseConn();
				return "栏目修改成功！";
			}
			catch
			{
				return "栏目修改不成功！";
			}
		}

		/// <summary>
		/// 新增加主类别
		/// </summary>
		/// <param name="TreeList"></param>
		public string Tree_Insert(string bmnr)
		{
			try
			{
				string  sqlstr="insert into H_bm (Parentid,bmnr) values (0,'"+bmnr+"')";
				CreateDb mydb = new CreateDb();
				DBManager my = mydb.Createdb();
				my.OpenConn();
				my.ExecutenonQuery(my.ExeCommand(sqlstr));
				my.CloseConn();
				return "增加栏目成功！";
			}
			catch(Exception e)
			{
				throw (e);
			}
		}
		/// <summary>
		/// 显示部门树形菜单
		/// </summary>
		/// <param name="Parentid"></param>
		/// <returns></returns>
		public string Treeinit(int Parentid)
		{
			CreateDb mydb = new CreateDb();
			IDataReader Rs=null;
			DBManager my = mydb.Createdb();
			my.OpenConn();
			string strSQL="select * from H_bm where id="+Parentid+" order by id asc";
			Rs=my.ExecuteCreateReader(my.ExeCommand(strSQL));
			string arr_tree="<DIV class=deeptree>";
			arr_tree+="<script lanage=javascript>";
			arr_tree+="var a=new TreeView(\'a\',\'main\');";
			while(Rs.Read()==true)
			{
				arr_tree+="a.add("+Rs["id"]+",0,\""+Rs["bmnr"].ToString()+"\",\"sys_zzjg.aspx?id="+Rs["id"]+"&NodeName="+Rs["bmnr"]+"\",\"parnent\");";
					arr_tree+=GetSub(Convert.ToInt32(Rs["id"].ToString()));
			}
			arr_tree+="document.write(a);";
			arr_tree+="a.expandAll();";
			arr_tree+="</script>";
			arr_tree+="</DIV>";
			Rs.Close();
			my.CloseConn();
			return arr_tree;
		}
		/// <summary>
		/// 显示子部门到树形菜单中
		/// </summary>
		/// <param name="Parentid"></param>
		/// <returns></returns>
		public string GetSub(int Parentid)
		{
			CreateDb mydb = new CreateDb();
			IDataReader Rs=null;
			DBManager my = mydb.Createdb();
			my.OpenConn();
			string strSQL="select * from H_bm where parentid="+Parentid+" order by id asc";
			Rs=my.ExecuteCreateReader(my.ExeCommand(strSQL));
			string arr_tree=string.Empty;
			while(Rs.Read()==true)
			{
				arr_tree+="a.add("+Rs["id"]+","+Rs["Parentid"]+",\""+Rs["bmnr"].ToString()+"\",\"sys_zzjg.aspx?id="+Rs["id"]+"&NodeName="+Rs["bmnr"]+"\",\"parnent\");";
				arr_tree+=GetSub(Convert.ToInt32(Rs["id"].ToString()));
			}

			Rs.Close();
			my.CloseConn();
			return arr_tree;
		}
	}
}