sysfunservice.cs

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

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

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 SysFunService
	{
        /// <summary>
        /// 
        /// </summary>
        /// <param name="sysFun"></param>
        /// <returns></returns>
        public static SysFun AddSysFun(SysFun sysFun)
		{
            string sql =
				"INSERT SysFun (DisplayName, NodeURL, DisplayOrder, ParentNodeId)" +
				"VALUES (@DisplayName, @NodeURL, @DisplayOrder, @ParentNodeId)";
				
			sql += " ; SELECT @@IDENTITY";

            try
            {
				SqlParameter[] para = new SqlParameter[]
				{
					new SqlParameter("@DisplayName", sysFun.DisplayName),
					new SqlParameter("@NodeURL", sysFun.NodeURL),
					new SqlParameter("@DisplayOrder", sysFun.DisplayOrder),
					new SqlParameter("@ParentNodeId", sysFun.ParentNodeId)
				};
				
                int newId = DBHelper.GetScalar(sql, para);
				return GetSysFunByNodeId(newId);
            }
            catch (Exception e)
            {
				Console.WriteLine(e.Message);
                throw e;
            }
		}
		/// <summary>
		/// 
		/// </summary>
		/// <param name="sysFun"></param>
        public static void DeleteSysFun(SysFun sysFun)
		{
			DeleteSysFunByNodeId( sysFun.NodeId );
		}
        /// <summary>
        /// 
        /// </summary>
        /// <param name="nodeId"></param>
        public static void DeleteSysFunByNodeId(int nodeId)
		{
            string sql = "DELETE SysFun WHERE NodeId = @NodeId";

            try
            {
				SqlParameter[] para = new SqlParameter[]
				{
					new SqlParameter("@NodeId", nodeId)
				};
			
                DBHelper.ExecuteCommand(sql, para);
            }
            catch (Exception e)
            {
				Console.WriteLine(e.Message);
				throw e;
            }
		}
		/// <summary>
		/// 
		/// </summary>
		/// <param name="sysFun"></param>
        public static void ModifySysFun(SysFun sysFun)
        {
            string sql =
                "UPDATE SysFun " +
                "SET " +
	                "DisplayName = @DisplayName, " +
	                "NodeURL = @NodeURL, " +
	                "DisplayOrder = @DisplayOrder, " +
	                "ParentNodeId = @ParentNodeId " +
                "WHERE NodeId = @NodeId";


            try
            {
				SqlParameter[] para = new SqlParameter[]
				{
					new SqlParameter("@NodeId", sysFun.NodeId),
					new SqlParameter("@DisplayName", sysFun.DisplayName),
					new SqlParameter("@NodeURL", sysFun.NodeURL),
					new SqlParameter("@DisplayOrder", sysFun.DisplayOrder),
					new SqlParameter("@ParentNodeId", sysFun.ParentNodeId)
				};

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

        }		
        /// <summary>
        /// 
        /// </summary>
        /// <returns></returns>
        public static IList<SysFun> GetAllSysFuns()
        {
            string sqlAll = "SELECT * FROM SysFun";
			return GetSysFunsBySql( sqlAll );
        }
        /// <summary>
        /// 
        /// </summary>
        /// <returns></returns>
        public static IList<SysFun> GetAllParentNodInfo()
        {
            string sql = "SELECT * FROM SysFun WHERE ParentNodeId = 0";
            return GetSysFunsBySql(sql);
        }
        /// <summary>
        /// 
        /// </summary>
        /// <returns></returns>
        public static IList<SysFun> GetSysFunByParentNodeId(Int32 ParentNodeId)
        {
            string sql = "SELECT * FROM SysFun WHERE ParentNodeId = "+ParentNodeId;
            return GetSysFunsBySql(sql);
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="pId"></param>
        /// <returns></returns>
        public static List<SysFun> GetSysFunsByParentId(Int32 pId)
        {
            string sql = "SELECT * FROM SysFun WHERE ParentNodeId = @ParentNodeId";
            List<SysFun> list = new List<SysFun>();
            try
            {
                SqlDataReader reader = DBHelper.GetReader(sql, new SqlParameter("@ParentNodeId", pId));
                while (reader.Read())
                {
                    SysFun sysFun = new SysFun();

                    sysFun.NodeId = (int)reader["NodeId"];
                    sysFun.DisplayName = (string)reader["DisplayName"];
                    sysFun.NodeURL = (string)reader["NodeURL"];
                    sysFun.DisplayOrder = (int)reader["DisplayOrder"];
                    sysFun.ParentNodeId = (int)reader["ParentNodeId"];

                    list.Add(sysFun);
                }
                reader.Close();
                return list;

            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                throw e;
            }
        
        }
		/// <summary>
		/// 
		/// </summary>
		/// <param name="nodeId"></param>
		/// <returns></returns>
        public static SysFun GetSysFunByNodeId(int nodeId)
        {
            string sql = "SELECT * FROM SysFun WHERE NodeId = @NodeId";

            try
            {
                SqlDataReader reader = DBHelper.GetReader(sql, new SqlParameter("@NodeId", nodeId));
                if (reader.Read())
                {
                    SysFun sysFun = new SysFun();

					sysFun.NodeId = (int)reader["NodeId"];
					sysFun.DisplayName = (string)reader["DisplayName"];
					sysFun.NodeURL = (string)reader["NodeURL"];
					sysFun.DisplayOrder = (int)reader["DisplayOrder"];
					sysFun.ParentNodeId = (int)reader["ParentNodeId"];

                    reader.Close();
					
                    return sysFun;
                }
                else
                {
                    reader.Close();
                    return null;
                }
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                throw e;
            }
        }
		
		
		
		/// <summary>
		/// 
		/// </summary>
		/// <param name="safeSql"></param>
		/// <returns></returns>
        private static IList<SysFun> GetSysFunsBySql( string safeSql )
        {
            List<SysFun> list = new List<SysFun>();

			try
			{
				DataTable table = DBHelper.GetDataSet( safeSql );
				
				foreach (DataRow row in table.Rows)
				{
					SysFun sysFun = new SysFun();
					
					sysFun.NodeId = (int)row["NodeId"];
					sysFun.DisplayName = (string)row["DisplayName"];
					sysFun.NodeURL = (string)row["NodeURL"];
					sysFun.DisplayOrder = (int)row["DisplayOrder"];
					sysFun.ParentNodeId = (int)row["ParentNodeId"];
	
					list.Add(sysFun);
				}
	
				return list;
			}
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                throw e;
            }

        }
		/// <summary>
		/// 
		/// </summary>
		/// <param name="sql"></param>
		/// <param name="values"></param>
		/// <returns></returns>
        private static IList<SysFun> GetSysFunsBySql( string sql, params SqlParameter[] values )
        {
            List<SysFun> list = new List<SysFun>();

			try
			{
				DataTable table = DBHelper.GetDataSet( sql, values );
				
				foreach (DataRow row in table.Rows)
				{
					SysFun sysFun = new SysFun();
					
					sysFun.NodeId = (int)row["NodeId"];
					sysFun.DisplayName = (string)row["DisplayName"];
					sysFun.NodeURL = (string)row["NodeURL"];
					sysFun.DisplayOrder = (int)row["DisplayOrder"];
					sysFun.ParentNodeId = (int)row["ParentNodeId"];
	
					list.Add(sysFun);
				}
	
				return list;
			}
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                throw e;
            }
			
        }
		
	}
}