file.cs

asp.net 办公自动化系统 人事管理 公文管理 内部邮件管理以及办公自动化系统中不可或缺的模块

using System;
using System.Data;
using System.Data.SqlClient;

namespace eOA
{
	/// <summary>
	/// File 的摘要说明。
	/// </summary>
	public class File
	{
		public File()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}

		public DataSet GetAllRecvFile(int RecvID)
		{
			SqlParameter[] para = {
									  new SqlParameter("@RecvID", RecvID)
								  };
			return SqlAccess.ExecuteDataset(SqlAccess .CONN_STRING, CommandType.StoredProcedure,"GetAllRecvFile",para);

		}

		public DataSet GetAllSendFile(int SendID)
		{
			SqlParameter[] para = {
									  new SqlParameter("@SendID", SendID)
								  };
			return SqlAccess.ExecuteDataset(SqlAccess .CONN_STRING, CommandType.StoredProcedure,"GetAllSendFile",para);

		}

		public SqlDataReader GetFileByID(int FileID)
		{			
			SqlParameter[] para = {
									  new SqlParameter("@FileID", FileID)
								  };
			return SqlAccess.ExecuteReader(SqlAccess.CONN_STRING,CommandType.StoredProcedure, "GetFileByID", para);
		}

		public void DeleteFile(int FileID)
		{
			SqlParameter[] para = {
									  new SqlParameter("@FileID", FileID)
								  };

			SqlAccess.ExecuteNonQuery(SqlAccess.CONN_STRING, CommandType.StoredProcedure, "DeleteFile", para);
		}

		public void AddFile(string Subject,string Content,string Accessory,int SendID,string SendEmp,int RecvID,string RecvEmp,DateTime CreateDate,string State)
		{
			SqlParameter[] para = {
									  new SqlParameter("@Subject", Subject),
									  new SqlParameter("@Content", Content),
									  new SqlParameter("@Accessory", Accessory),
									  new SqlParameter("@SendID", SendID),
									  new SqlParameter("@SendEmp", SendEmp),
									  new SqlParameter("@RecvID", RecvID),
									  new SqlParameter("@RecvEmp", RecvEmp),									  
									  new SqlParameter("@CreateDate", CreateDate),
									  new SqlParameter("@State", State)
								  };

			SqlAccess.ExecuteNonQuery(SqlAccess.CONN_STRING, CommandType.StoredProcedure, "AddFile", para);
		}

		public void DealFile(int FileID)
		{
			SqlParameter[] para = {
									  new SqlParameter("@FileID", FileID)
								  };

			SqlAccess.ExecuteNonQuery(SqlAccess.CONN_STRING, CommandType.StoredProcedure, "DealFile", para);
		}

		public int GetEmpIDByName(string EmpName)
		{
			SqlParameter[] Para = {
									  new SqlParameter("@EmpName", EmpName),
			};
			return Convert.ToInt32  (SqlAccess.ExecuteScalar(SqlAccess.CONN_STRING, CommandType.StoredProcedure, "GetEmpIDByName", Para));
		}
	}
}