file.cs

办公自动化系统

using System;
using System.Data;
using System.Collections;

using MyOA.DataAccessLayer;
using MyOA.DataAccessHelper;
using MyOA.CommonComponent;


namespace MyOA.BusinessLogicLayer
{
	/// <summary>
	/// File 的摘要说明。
	/// </summary>
	public class File
	{
		#region 私有成员

		private int _fileId;			//公文Id
		private string _fileTitle;		//公文标题
		private string _fileContent;	//公文正文
		private string _fromUserName;	//公文撰写者
		private string _toUserName;		//公文接收者
		private int _fileStatusId;		//公文状态编号
		private string _fileStatusName;		//公文状态
		private string _affixFile;		//附件
		
		private bool _exist;		//是否存在标志

		#endregion 私有成员

		#region 属性
		
		public int FileId
		{
			set
			{
				this._fileId=value;
			}
			get
			{
				return this._fileId;
			}
		}
		public string FileTitle
		{
			set
			{
				this._fileTitle=value;
			}
			get
			{
				return this._fileTitle;
			}
		}
		public string FileContent
		{
			set
			{
				this._fileContent=value;
			}
			get
			{
				return this._fileContent;
			}
		}
		public string FromUserName
		{
			set
			{
				this._fromUserName=value;
			}
			get
			{
				return this._fromUserName;
			}
		}
		public string ToUserName
		{
			set
			{
				this._toUserName=value;
			}
			get
			{
				return this._toUserName;
			}
		}
		public int FileStatusId
		{
			set
			{
				this._fileStatusId=value;
			}
			get
			{
				return this._fileStatusId;
			}
		}	
		public string FileStatusName
		{
			set
			{
				this._fileStatusName=value;
			}
			get
			{
				return this._fileStatusName;
			}
		}
		public string AffixFile
		{
			set
			{
				this._affixFile=value;
			}
			get
			{
				return this._affixFile;
			}
		}
		public bool Exist
		{
			get
			{
				return this._exist;
			}
		}

		#endregion 属性

		#region 方法
		
		/// <summary>
		/// 根据参数fileId，获取公文详细信息
		/// </summary>
		/// <param name="fileId">公文ID</param>
		public void LoadData(int fileId)
		{
			Database db=new Database();		//实例化一个Database类

			string sql="";
			sql="Select * from [File],[FileStatus] where FileId = "+fileId
				+" And [File].FileStatus=[FileStatus].FileStatusId";

			DataRow dr=db.GetDataRow(sql);	//利用Database类的GetDataRow方法查询公文数据

			//根据查询得到的数据，对成员赋值
			if(dr!=null)
			{
				this._fileId=GetSafeData.ValidateDataRow_N(dr,"FileID");
				this._fileTitle=GetSafeData.ValidateDataRow_S(dr,"FileTitle");
				this._fileContent=GetSafeData.ValidateDataRow_S(dr,"FileContent");
				this._fromUserName=GetSafeData.ValidateDataRow_S(dr,"FromUserName");
				this._toUserName=GetSafeData.ValidateDataRow_S(dr,"ToUserName");
				this._fileStatusId=GetSafeData.ValidateDataRow_N(dr,"FileStatusId");
				this._fileStatusName=GetSafeData.ValidateDataRow_S(dr,"FileStatusName");
				this._affixFile=GetSafeData.ValidateDataRow_S(dr,"AffixFile");
				
				this._exist=true;
			}
			else
			{
				this._exist=false;
			}
		}

		/// <summary>
		/// 向数据库添加一个公文
		/// </summary>
		/// <param name="htUserInfo">公文信息哈希表</param>
		public static void Add(Hashtable fileInfo)
		{
			Database db=new Database();		//实例化一个Database类
			db.Insert("[File]",fileInfo );	//利用Database类的Insert方法添加公文数据
		}

		/// <summary>
		/// 修改公文数据
		/// </summary>
		/// <param name="htUserInfo">公文信息哈希表</param>
		public static void Update(Hashtable fileInfo,string where)
		{
			Database db=new Database();		//实例化一个Database类
			db.Update("[File]",fileInfo,where);	//利用Database类的Update方法修改公文数据
		}

		/// <summary>
		/// 查询公文
		/// </summary>
		/// <param name="andQueryItems">“AND”子句查询条件哈希表</param>
		/// <param name="orQueryItems">“OR”子句查询条件哈希表</param>
		/// <returns>以DataTable形式返回查询结果数据</returns>
		public static DataTable Query(Hashtable andQueryItems,Hashtable orQueryItems)
		{
			string whereAnd=SqlStringConstructor.GetConditionClause(andQueryItems,"AND");
			string whereOr=SqlStringConstructor.GetConditionClause(orQueryItems,"OR");

			if(whereOr!="")
				whereOr+= " Or [File].ToUserName='全部' ";
			else
				whereOr+= " Where [File].ToUserName='全部' ";

			string sql="Select * From [File],[FileStatus]";
			string where="";
			
			if(whereAnd=="" && whereOr=="")
			{
				where=" Where [File].FileStatus=[FileStatus].FileStatusId";
			}
			else if(whereAnd=="" && whereOr!="")
			{				
				where=whereOr +" And [File].FileStatus=[FileStatus].FileStatusId";
			}
			else if(whereAnd!="" && whereOr=="")
			{
				where=whereAnd +" And [File].FileStatus=[FileStatus].FileStatusId";
			}
			else
			{
				whereOr=whereOr.Remove(0,6);		//去掉Where
				where=whereAnd +" And ("+whereOr+") And [File].FileStatus=[FileStatus].FileStatusId";
			}

			sql+=where+" ";

			Database db = new Database();
			return db.GetDataTable(sql);
		}

		/// <summary>
		/// 删除公文数据
		/// </summary>
		/// <param name="fileId">公文编号</param>
		public static void Delete(int fileId)
		{
			Database db=new Database();		//实例化一个Database类
			string sql="Delete from [File] Where [FileId] = "+fileId.ToString();
			db.ExecuteSQL(sql);
		}
		
		#endregion 方法
	}
}