fileinfoservice.cs

办公系统办公系统办公系统办公系统办公系统办公系统办公系统办公系统办公系统办公系统办公系统办公系统办公系统办公系统办公系统

//============================================================
// Producnt name:		BoBoARTS.CodeMad
// Version: 			1.0
// Coded by:			Shen Bo ([e-mail])
// Auto generated at: 	2008-9-18 16:21:36
//============================================================

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Office.Model;

namespace Office.DAL
{
	public static partial class FileInfoService
	{
        /// <summary>
        /// Method:Add a document
        /// </summary>
        /// <param name="fileInfo">FileInfo</param>
        /// <returns>FileInfo</returns>
        public static FileInfo AddFileInfo(FileInfo fileInfo)
		{
            string sql =
				"INSERT FileInfo (FileName, FileType, Remark, FileOwner, CreateDate, ParentId, FilePath, IfDelete)" +
				"VALUES (@FileName, @FileType, @Remark, @FileOwner, @CreateDate, @ParentId, @FilePath, @IfDelete)";
				
			sql += " ; SELECT @@IDENTITY";

            try
            {
				SqlParameter[] para = new SqlParameter[]
				{
					new SqlParameter("@FileType", fileInfo.FileType.FileTypeId), //FK
					new SqlParameter("@FileOwner", fileInfo.FileOwner.UserId), //FK
					new SqlParameter("@FileName", fileInfo.FileName),
					new SqlParameter("@Remark", fileInfo.Remark),
					new SqlParameter("@CreateDate", fileInfo.CreateDate),
					new SqlParameter("@ParentId", fileInfo.ParentId),
					new SqlParameter("@FilePath", fileInfo.FilePath),
					new SqlParameter("@IfDelete", fileInfo.IfDelete)
				};
				
                int newId = DBHelper.GetScalar(sql, para);
				return GetFileInfoByFileId(newId);
            }
            catch (Exception e)
            {
				Console.WriteLine(e.Message);
                throw e;
            }
		}
		/// <summary>
		/// Method:delete a document.
		/// </summary>
        /// <param name="fileInfo">FileInfo</param>
        public static void DeleteFileInfo(FileInfo fileInfo)
		{
			DeleteFileInfoByFileId( fileInfo.FileId );
		}
        /// <summary>
        /// Method: According to the document ,ID Deletes document.
        /// </summary>
        /// <param name="fileId">fileId</param>
        public static void DeleteFileInfoByFileId(int fileId)
		{
            string sql = "DELETE FileInfo WHERE FileId = @FileId";

            try
            {
				SqlParameter[] para = new SqlParameter[]
				{
					new SqlParameter("@FileId", fileId)
				};
			
                DBHelper.ExecuteCommand(sql, para);
            }
            catch (Exception e)
            {
				Console.WriteLine(e.Message);
				throw e;
            }
		}
		/// <summary>
		/// Method: Modification a document.
		/// </summary>
		/// <param name="fileInfo"></param>
        public static void ModifyFileInfo(FileInfo fileInfo)
        {
            string sql =
                "UPDATE FileInfo " +
                "SET " +
	                "FileType = @FileType, " + //FK
	                "FileOwner = @FileOwner, " + //FK
	                "FileName = @FileName, " +
	                "Remark = @Remark, " +
	                "CreateDate = @CreateDate, " +
	                "ParentId = @ParentId, " +
	                "FilePath = @FilePath, " +
	                "IfDelete = @IfDelete " +
                "WHERE FileId = @FileId";


            try
            {
				SqlParameter[] para = new SqlParameter[]
				{
					new SqlParameter("@FileId", fileInfo.FileId),
					new SqlParameter("@FileType", fileInfo.FileType.FileTypeId), //FK
					new SqlParameter("@FileOwner", fileInfo.FileOwner.UserId), //FK
					new SqlParameter("@FileName", fileInfo.FileName),
					new SqlParameter("@Remark", fileInfo.Remark),
					new SqlParameter("@CreateDate", fileInfo.CreateDate),
					new SqlParameter("@ParentId", fileInfo.ParentId),
					new SqlParameter("@FilePath", fileInfo.FilePath),
					new SqlParameter("@IfDelete", fileInfo.IfDelete)
				};

				DBHelper.ExecuteCommand(sql, para);
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
				throw e;
            }

        }		
        /// <summary>
        /// Method: Get all document.
        /// </summary>
        /// <returns>IList<FileInfo></returns>
        public static IList<FileInfo> GetAllFileInfos()
        {
            string sqlAll = "SELECT * FROM FileInfo";
			return GetFileInfosBySql( sqlAll );
        }
        public static IList<FileInfo> GetAllFileInfoFolder()
        {
            string sqlAll = "SELECT * FROM FileInfo where FileType=1";
            return GetFileInfosBySql(sqlAll);
        }
        /// <summary>
        /// Method:Get FileInfo according to parent id.
        /// </summary>
        /// <param name="parentId"></param>
        /// <returns></returns>
        public static IList<FileInfo> GetFileInfoByParentId(int parentId)
        {
            string sqlAll = "SELECT * FROM FileInfo WHERE ParentId="+parentId+" and ifdelete = 0";
            return GetFileInfosBySql(sqlAll);
        }
        public static IList<FileInfo> GetFileInfosByParentId(int parentId)
        {
            string sqlAll = "SELECT * FROM FileInfo WHERE ParentId=" + parentId;
            return GetFileInfosBySql(sqlAll);
        }
        /// <summary>
        /// Method:Get File Info according to File path
        /// </summary>
        /// <param name="Path"></param>
        /// <returns></returns>
        public static IList<FileInfo> GetFileInfoByPath(string Path)
        {
            string sqlAll = "SELECT * FROM FileInfo WHERE FilePath='"+Path+"' and ifDelete = 0";
            return GetFileInfosBySql(sqlAll);
        }
        /// <summary>
        /// 
        /// </summary>
        /// <returns></returns>
        public static IList<FileInfo> GetFileInfoByDelete()
        {
            string sqlAll = "SELECT * FROM FileInfo WHERE ifDelete = 1";
            return GetFileInfosBySql(sqlAll);
        }
        /// <summary>
        /// 
        /// </summary>
        /// <returns></returns>
        public static IList<FileInfo> GetFileInfoByCondition(string fileName,string fileOwner,string accessroy,string startTime,string endTime)
        {
            String sql = "Select * from FileInfo where IfDelete = 0 ";
            if (fileName != "")
                sql += "and FileName = '"+fileName+"'";
            if (fileOwner != "")
                sql += " and FileOwner = '"+fileOwner+"'";
            if (startTime != "" && endTime != "")
                sql += " and CreateDate between '"+startTime+"' and '"+endTime+"'";
            if (accessroy != "")
            {
                String ids = "";
                IList<AccessoryFile> list = AccessoryFileService.GetAllAccessoryFilesByCondition(accessroy);
                if (list.Count > 0)
                {
                    foreach (AccessoryFile tmp in list)
                    {
                        ids += tmp.File.FileId + ",";
                    }
                    sql += " and FileId in (" + ids.Substring(0, ids.Length - 1) + ")";
                }
                else
                {
                    sql += " and FileId in (0)";
                }
            }
            return GetFileInfosBySql(sql);
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="fileIds"></param>
        public static void DeleteFileInfoByFileIds(String fileIds)
        {
            string sql = "DELETE FileInfo WHERE FileId in(" + fileIds + ")";
            try
            {
                DBHelper.ExecuteCommand(sql);
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                throw e;
            }
        }
		/// <summary>
		/// Method:According to the document id get document information.
		/// </summary>
        /// <param name="fileId">fileId</param>
        /// <returns>FileInfo</returns>
        public static FileInfo GetFileInfoByFileId(int fileId)
        {
            string sql = "SELECT * FROM FileInfo WHERE FileId = @FileId";

			int fileType;
			string fileOwner;

            try
            {
                SqlDataReader reader = DBHelper.GetReader(sql, new SqlParameter("@FileId", fileId));
                if (reader.Read())
                {
                    FileInfo fileInfo = new FileInfo();

					fileInfo.FileId = (int)reader["FileId"];
					fileInfo.FileName = (string)reader["FileName"];
					fileInfo.Remark = (string)reader["Remark"];
					fileInfo.CreateDate = (DateTime)reader["CreateDate"];
					fileInfo.ParentId = (int)reader["ParentId"];
					fileInfo.FilePath = (string)reader["FilePath"];
					fileInfo.IfDelete = (int)reader["IfDelete"];
					fileType = (int)reader["FileType"]; //FK
					fileOwner = (string)reader["FileOwner"]; //FK

                    reader.Close();

					fileInfo.FileType = FileTypeInfoService.GetFileTypeInfoByFileTypeId(fileType);
					fileInfo.FileOwner = UserInfoService.GetUserInfoByUserId(fileOwner);
					
                    return fileInfo;
                }
                else
                {
                    reader.Close();
                    return null;
                }
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                throw e;
            }
        }
		
		/// <summary>
		/// Method:According to safe T-SQL the sentence gets the document information.
		/// </summary>
		/// <param name="safeSql">safe T-SQL</param>
        /// <returns>IList<FileInfo></returns>
        private static IList<FileInfo> GetFileInfosBySql( string safeSql )
        {
            List<FileInfo> list = new List<FileInfo>();

			try
			{
				DataTable table = DBHelper.GetDataSet( safeSql );
				
				foreach (DataRow row in table.Rows)
				{
					FileInfo fileInfo = new FileInfo();
					
					fileInfo.FileId = (int)row["FileId"];
					fileInfo.FileName = (string)row["FileName"];
					fileInfo.Remark = (string)row["Remark"];
					fileInfo.CreateDate = (DateTime)row["CreateDate"];
					fileInfo.ParentId = (int)row["ParentId"];
					fileInfo.FilePath = (string)row["FilePath"];
					fileInfo.IfDelete = (int)row["IfDelete"];
					fileInfo.FileType = FileTypeInfoService.GetFileTypeInfoByFileTypeId((int)row["FileType"]); //FK
					fileInfo.FileOwner = UserInfoService.GetUserInfoByUserId((string)row["FileOwner"]); //FK
	
					list.Add(fileInfo);
				}
	
				return list;
			}
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                throw e;
            }

        }
		/// <summary>
		/// Over loading Method: According to safe T-SQL the sentence and the parameter gets the document information.
		/// </summary>
        /// <param name="sql">safe T-SQL</param>
		/// <param name="values">SqlParameter</param>
        /// <returns>IList<FileInfo></returns>
        private static IList<FileInfo> GetFileInfosBySql( string sql, params SqlParameter[] values )
        {
            List<FileInfo> list = new List<FileInfo>();

			try
			{
				DataTable table = DBHelper.GetDataSet( sql, values );
				
				foreach (DataRow row in table.Rows)
				{
					FileInfo fileInfo = new FileInfo();
					
					fileInfo.FileId = (int)row["FileId"];
					fileInfo.FileName = (string)row["FileName"];
					fileInfo.Remark = (string)row["Remark"];
					fileInfo.CreateDate = (DateTime)row["CreateDate"];
					fileInfo.ParentId = (int)row["ParentId"];
					fileInfo.FilePath = (string)row["FilePath"];
					fileInfo.IfDelete = (int)row["IfDelete"];
					fileInfo.FileType = FileTypeInfoService.GetFileTypeInfoByFileTypeId((int)row["FileType"]); //FK
					fileInfo.FileOwner = UserInfoService.GetUserInfoByUserId((string)row["FileOwner"]); //FK
					list.Add(fileInfo);
				}
	
				return list;
			}
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                throw e;
            }
			
        }
		
	}
}