document.cs

办公室系统包括上下班打卡

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using GUCAS.SC.SqlHelper;

public class Folder
{
	public void InitFolderTree(TreeView tv)
	{
		DataTable dt = SystemTools.ConvertDataReaderToDataTable(GetFolders());

		tv.Nodes.Clear();     ///清空树的所有节点		
		DataRow[] rowList = dt.Select("ParentID='-1'");
		if(rowList.Length < 1) return;

		///创建根节点
		TreeNode root = new TreeNode();
		///设置根节点属性
		root.Text = rowList[0]["Name"].ToString();
		///设置根节点的value值
		root.Value = rowList[0]["ID"].ToString();
		root.Expanded = true;
		///添加根节点
		tv.Nodes.Add(root);

		///添加根节点的文档
		CreateNodeDocument(root);

		///创建其他节点
		CreateChildNode(root,dt);
	}

	private void CreateChildNode(TreeNode parentNode,DataTable dt)
	{
		///选择数据时，添加了排序表达式OrderBy
		DataRow[] rowList = dt.Select("ParentID='" + parentNode.Value
			+ "'","ShowOrder");
		foreach(DataRow row in rowList)
		{   ///创建新节点
			TreeNode node = new TreeNode();
			///设置节点的属性
			node.Text = row["Name"].ToString();
			node.Value = row["ID"].ToString();
			node.ImageUrl = "~/App_Themes/Default/Images/folder.gif";
			parentNode.ChildNodes.Add(node);

			///添加节点的文档
			CreateNodeDocument(node);

			///递归调用，创建其他节点
			CreateChildNode(node,dt);
		}
	}

	private void CreateNodeDocument(TreeNode parentNode)
	{   ///获取节点包含的文档
		Document document = new Document();
		SqlDataReader dr = document.GetDocumentByFolder(
			Int32.Parse(parentNode.Value));
		if(dr == null)
		{
			return;
		}
		while(dr.Read())
		{   ///设置节点的属性
			TreeNode node = new TreeNode();
			node.Text = dr["Name"].ToString();
			node.NavigateUrl = dr["Url"].ToString();
			node.Value = dr["ID"].ToString();
			node.Target = "_blank";
			///添加该节点到树中
			parentNode.ChildNodes.Add(node);
		}
		dr.Close();
	}

	public SqlDataReader GetFolders()
	{
		return (DataCommon.GetDataByReader("Pr_GetFolders"));
	}

	public SqlDataReader GetSingleFolder(int folderID)
	{
		return (DataCommon.GetDataByReaderIDParam("Pr_GetSingleFolder",folderID));
	}

	public int AddFolder(string name,int parentID)
	{
		SqlParameter[] parameters = {
			SqlHelper.CreateInParam("@Name",SqlDbType.VarChar,50,name),
			SqlHelper.CreateInParam("@ParentID",SqlDbType.Int,4,parentID)
		};
		return (SqlHelper.RunProc("Pr_AddFolder",parameters));
	}

	public int UpdateFolder(int folderID,string name)
	{
		SqlParameter[] parameters = {
			SqlHelper.CreateInParam("@ID",SqlDbType.Int,4,folderID),
			SqlHelper.CreateInParam("@Name",SqlDbType.VarChar,50,name)
		};
		return (SqlHelper.RunProc("Pr_UpdateFolder",parameters));
	}

	public int UpdateFolderOrder(int folderID,string moveFlag)
	{
		SqlParameter[] parameters = {
			SqlHelper.CreateInParam("@ID",SqlDbType.Int,4,folderID),
			SqlHelper.CreateInParam("@MoveFlag",SqlDbType.VarChar,10,moveFlag)
		};
		return (SqlHelper.RunProc("Pr_UpdateFolderOrder",parameters));
	}

	public int DeleteFolder(int folderID)
	{
		return (DataCommon.QueryDataIDParam("Pr_DeleteFolder",folderID));
	}
}

public class Document
{
	public SqlDataReader GetDocuments()
	{
		return (DataCommon.GetDataByReader("Pr_GetDocuments"));
	}

	public SqlDataReader GetSingleDocument(int documentID)
	{
		return (DataCommon.GetDataByReaderIDParam("Pr_GetSingleDocument",documentID));
	}

	public SqlDataReader GetDocumentByEmployee(int employeeID)
	{
		///定义保存从数据库获取的结果的DataReader
		SqlDataReader dr = null;

		///添加存储过程的参数
		SqlParameter[] parameters = {
			SqlHelper.CreateInParam("@EmployeeID",SqlDbType.Int,4,employeeID)
		};

		///执行存储过程
		SqlHelper.RunProc("Pr_GetDocumentByEmployee",parameters,out dr);

		///返回从数据库获取的结果
		return dr;		
	}

	public SqlDataReader GetDocumentByFolder(int folderID)
	{
		///定义保存从数据库获取的结果的DataReader
		SqlDataReader dr = null;

		///添加存储过程的参数
		SqlParameter[] parameters = {
			SqlHelper.CreateInParam("@FolderID",SqlDbType.Int,4,folderID)
		};

		///执行存储过程
		SqlHelper.RunProc("Pr_GetDocumentByFolder",parameters,out dr);

		///返回从数据库获取的结果
		return dr;
	}

	public int AddDocument(string name,string desn,string url,
		int employeeID,int folderID)
	{
		SqlParameter[] parameters = {
			SqlHelper.CreateInParam("@Name",SqlDbType.VarChar,200,name),
			SqlHelper.CreateInParam("@Desn",SqlDbType.NVarChar,1000,desn),
			SqlHelper.CreateInParam("@Url",SqlDbType.VarChar,200,url),
			SqlHelper.CreateInParam("@EmployeeID",SqlDbType.Int,4,employeeID),
			SqlHelper.CreateInParam("@FolderID",SqlDbType.Int,4,folderID)
		};
		return (SqlHelper.RunProc("Pr_AddDocument",parameters));
	}

	public int UpdateDocument(int documentID,string name,
		string desn)
	{
		SqlParameter[] parameters = {
			SqlHelper.CreateInParam("@ID",SqlDbType.Int,4,documentID),
			SqlHelper.CreateInParam("@Name",SqlDbType.VarChar,200,name),
			SqlHelper.CreateInParam("@Desn",SqlDbType.NVarChar,1000,desn)			
		};
		return (SqlHelper.RunProc("Pr_UpdateDocument",parameters));
	}

	public int DeleteDocument(int documentID)
	{
		return (DataCommon.QueryDataIDParam("Pr_DeleteDocument",documentID));
	}
}