accessoryfileservice.cs

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

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

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 AccessoryFileService
	{
        /// <summary>
        /// Method:Add accessory
        /// </summary>
        /// <param name="accessoryFile">AccessoryFile</param>
        /// <returns>AccessoryFile</returns>
        public static AccessoryFile AddAccessoryFile(AccessoryFile accessoryFile)
		{
            string sql =
				"INSERT AccessoryFile (FileId, AccessoryName, AccessorySize, AccessoryType, CreateDate, AccessoryPath)" +
				"VALUES (@FileId, @AccessoryName, @AccessorySize, @AccessoryType, @CreateDate, @AccessoryPath)";
				
			sql += " ; SELECT @@IDENTITY";

            try
            {
				SqlParameter[] para = new SqlParameter[]
				{
					new SqlParameter("@FileId", accessoryFile.File.FileId), //FK
					new SqlParameter("@AccessoryName", accessoryFile.AccessoryName),
					new SqlParameter("@AccessorySize", accessoryFile.AccessorySize),
					new SqlParameter("@AccessoryType", accessoryFile.AccessoryType),
					new SqlParameter("@CreateDate", accessoryFile.CreateDate),
					new SqlParameter("@AccessoryPath", accessoryFile.AccessoryPath)
				};
				
                int newId = DBHelper.GetScalar(sql, para);
				return GetAccessoryFileByAccessoryId(newId);
            }
            catch (Exception e)
            {
				Console.WriteLine(e.Message);
                throw e;
            }
		}
		/// <summary>
		/// Method:Delete accessory
		/// </summary>
        /// <param name="accessoryFile">AccessoryFile</param>
        public static void DeleteAccessoryFile(AccessoryFile accessoryFile)
		{
			DeleteAccessoryFileByAccessoryId( accessoryFile.AccessoryId );
		}
        /// <summary>
        /// Method:According to accessories ID deletes accessories file;
        /// </summary>
        /// <param name="accessoryId">accessoryId</param>
        public static void DeleteAccessoryFileByAccessoryId(int AccessoryId)
		{
            string sql = "DELETE AccessoryFile WHERE AccessoryId = @AccessoryId";

            try
            {
				SqlParameter[] para = new SqlParameter[]
				{
					new SqlParameter("@AccessoryId", AccessoryId)
				};
			
                DBHelper.ExecuteCommand(sql, para);
            }
            catch (Exception e)
            {
				Console.WriteLine(e.Message);
				throw e;
            }
		}
        /// <summary>
        /// 
        /// </summary>
        /// <param name="AccessoryId"></param>
        public static void DeleteAccessoryFileByAccessoryIds(string AccessoryId)
        {
            string sql = "DELETE AccessoryFile WHERE AccessoryId in ("+AccessoryId+")";

            try
            {
                DBHelper.ExecuteCommand(sql);
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                throw e;
            }
        }
		/// <summary>
		/// Method:Modify accessories
		/// </summary>
		/// <param name="accessoryFile"></param>
        public static void ModifyAccessoryFile(AccessoryFile accessoryFile)
        {
            string sql =
                "UPDATE AccessoryFile " +
                "SET " +
	                "FileId = @FileId, " + //FK
	                "AccessoryName = @AccessoryName, " +
	                "AccessorySize = @AccessorySize, " +
	                "AccessoryType = @AccessoryType, " +
	                "CreateDate = @CreateDate, " +
	                "AccessoryPath = @AccessoryPath " +
                "WHERE AccessoryId = @AccessoryId";


            try
            {
				SqlParameter[] para = new SqlParameter[]
				{
					new SqlParameter("@AccessoryId", accessoryFile.AccessoryId),
					new SqlParameter("@FileId", accessoryFile.File.FileId), //FK
					new SqlParameter("@AccessoryName", accessoryFile.AccessoryName),
					new SqlParameter("@AccessorySize", accessoryFile.AccessorySize),
					new SqlParameter("@AccessoryType", accessoryFile.AccessoryType),
					new SqlParameter("@CreateDate", accessoryFile.CreateDate),
					new SqlParameter("@AccessoryPath", accessoryFile.AccessoryPath)
				};

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

        }		
        /// <summary>
        /// Method:Get All accessories
        /// </summary>
        /// <returns>IList<AccessoryFile></returns>
        public static IList<AccessoryFile> GetAllAccessoryFiles()
        {
            string sqlAll = "SELECT * FROM AccessoryFile";
			return GetAccessoryFilesBySql( sqlAll );
        }
        /// <summary>
        /// over load method: get all accessory according to file id.
        /// </summary>
        /// <param name="FileId"></param>
        /// <returns></returns>
        public static IList<AccessoryFile> GetAllAccessoryFiles(Int32 FileId)
        {
            string sqlAll = "SELECT * FROM AccessoryFile where FileId="+FileId;
            return GetAccessoryFilesBySql(sqlAll);
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="FileId"></param>
        /// <returns></returns>
        public static IList<AccessoryFile> GetAllAccessoryFilesByCondition(string condition)
        {
            string sqlAll = "SELECT * FROM AccessoryFile where AccessoryName like ('&" + condition + "%') or AccessoryName like ('" + condition + "%') or AccessoryName like ('&" + condition + "')";
            return GetAccessoryFilesBySql(sqlAll);
        }
		/// <summary>
		/// Method:According to accessories ID gets all accessories
		/// </summary>
        /// <param name="accessoryId">accessoryId</param>
        /// <returns>AccessoryFile</returns>
        public static AccessoryFile GetAccessoryFileByAccessoryId(int accessoryId)
        {
            string sql = "SELECT * FROM AccessoryFile WHERE AccessoryId = @AccessoryId";

			int fileId;

            try
            {
                SqlDataReader reader = DBHelper.GetReader(sql, new SqlParameter("@AccessoryId", accessoryId));
                if (reader.Read())
                {
                    AccessoryFile accessoryFile = new AccessoryFile();

					accessoryFile.AccessoryId = (int)reader["AccessoryId"];
					accessoryFile.AccessoryName = (string)reader["AccessoryName"];
					accessoryFile.AccessorySize = (int)reader["AccessorySize"];
					accessoryFile.AccessoryType = (int)reader["AccessoryType"];
					accessoryFile.CreateDate = (DateTime)reader["CreateDate"];
					accessoryFile.AccessoryPath = (string)reader["AccessoryPath"];
					fileId = (int)reader["FileId"]; //FK

                    reader.Close();

					accessoryFile.File = FileInfoService.GetFileInfoByFileId(fileId);
					
                    return accessoryFile;
                }
                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 accessories file.
		/// </summary>
		/// <param name="safeSql">Security T-SQL</param>
		/// <returns></returns>
        private static IList<AccessoryFile> GetAccessoryFilesBySql( string safeSql )
        {
            List<AccessoryFile> list = new List<AccessoryFile>();

			try
			{
				DataTable table = DBHelper.GetDataSet( safeSql );
				
				foreach (DataRow row in table.Rows)
				{
					AccessoryFile accessoryFile = new AccessoryFile();
					
					accessoryFile.AccessoryId = (int)row["AccessoryId"];
					accessoryFile.AccessoryName = (string)row["AccessoryName"];
					accessoryFile.AccessorySize = (int)row["AccessorySize"];
					accessoryFile.AccessoryType = (int)row["AccessoryType"];
					accessoryFile.CreateDate = (DateTime)row["CreateDate"];
					accessoryFile.AccessoryPath = (string)row["AccessoryPath"];
					accessoryFile.File = FileInfoService.GetFileInfoByFileId((int)row["FileId"]); //FK
	
					list.Add(accessoryFile);
				}
	
				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 get the accessories document.
		/// </summary>
		/// <param name="sql">safe T-SQL</param>
		/// <param name="values">SqlParameter</param>
		/// <returns></returns>
        private static IList<AccessoryFile> GetAccessoryFilesBySql( string sql, params SqlParameter[] values )
        {
            List<AccessoryFile> list = new List<AccessoryFile>();

			try
			{
				DataTable table = DBHelper.GetDataSet( sql, values );
				
				foreach (DataRow row in table.Rows)
				{
					AccessoryFile accessoryFile = new AccessoryFile();
					
					accessoryFile.AccessoryId = (int)row["AccessoryId"];
					accessoryFile.AccessoryName = (string)row["AccessoryName"];
					accessoryFile.AccessorySize = (int)row["AccessorySize"];
					accessoryFile.AccessoryType = (int)row["AccessoryType"];
					accessoryFile.CreateDate = (DateTime)row["CreateDate"];
					accessoryFile.AccessoryPath = (string)row["AccessoryPath"];
					accessoryFile.File = FileInfoService.GetFileInfoByFileId((int)row["FileId"]); //FK
	
					list.Add(accessoryFile);
				}
	
				return list;
			}
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                throw e;
            }
			
        }
		
	}
}