roleinfoservice.cs

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

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

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 RoleInfoService
	{
        /// <summary>
        ///Method:Add
        /// </summary>
        /// <param name="roleInfo">RoleInfo</param>
        /// <returns>RoleInfo</returns>
        public static RoleInfo AddRoleInfo(RoleInfo roleInfo)
		{
            string sql =
				"INSERT RoleInfo (RoleName, RoleDesc)" +
				"VALUES (@RoleName, @RoleDesc)";
				
			sql += " ; SELECT @@IDENTITY";

            try
            {
				SqlParameter[] para = new SqlParameter[]
				{
					new SqlParameter("@RoleName", roleInfo.RoleName),
					new SqlParameter("@RoleDesc", roleInfo.RoleDesc)
				};
				
                int newId = DBHelper.GetScalar(sql, para);
				return GetRoleInfoByRoleId(newId);
            }
            catch (Exception e)
            {
				Console.WriteLine(e.Message);
                throw e;
            }
		}
		/// <summary>
		/// Method:Delete RoleInfo
		/// </summary>
		/// <param name="roleInfo">RoleInfo</param>
        public static void DeleteRoleInfo(RoleInfo roleInfo)
		{
			DeleteRoleInfoByRoleId( roleInfo.RoleId );
		}
        /// <summary>
        /// Method:Delete RoleInfo By RoleID
        /// </summary>
        /// <param name="roleId">RoleID</param>
        public static void DeleteRoleInfoByRoleId(int roleId)
		{
            string sql = "DELETE RoleInfo WHERE RoleId = @RoleId";

            try
            {
				SqlParameter[] para = new SqlParameter[]
				{
					new SqlParameter("@RoleId", roleId)
				};
			
                DBHelper.ExecuteCommand(sql, para);
            }
            catch (Exception e)
            {
				Console.WriteLine(e.Message);
				throw e;
            }
		}
		/// <summary>
		/// Method:Modify RoleInfo
		/// </summary>
        /// <param name="roleInfo">RoleInfo</param>
        public static void ModifyRoleInfo(RoleInfo roleInfo)
        {
            string sql =
                "UPDATE RoleInfo " +
                "SET " +
	                "RoleName = @RoleName, " +
	                "RoleDesc = @RoleDesc " +
                "WHERE RoleId = @RoleId";


            try
            {
				SqlParameter[] para = new SqlParameter[]
				{
					new SqlParameter("@RoleId", roleInfo.RoleId),
					new SqlParameter("@RoleName", roleInfo.RoleName),
					new SqlParameter("@RoleDesc", roleInfo.RoleDesc)
				};

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

        }		
        /// <summary>
        /// Method:Get All RoleInfos
        /// </summary>
        /// <returns>IList<RoleInfo></returns>
        public static IList<RoleInfo> GetAllRoleInfos()
        {
            string sqlAll = "SELECT * FROM RoleInfo";
			return GetRoleInfosBySql( sqlAll );
        }
		/// <summary>
		/// Method:Get RoleInfo By RoleID
		/// </summary>
		/// <param name="roleId">RoleInfo</param>
		/// <returns>RoleInfo</returns>
        public static RoleInfo GetRoleInfoByRoleId(int roleId)
        {
            string sql = "SELECT * FROM RoleInfo WHERE RoleId = @RoleId";

            try
            {
                SqlDataReader reader = DBHelper.GetReader(sql, new SqlParameter("@RoleId", roleId));
                if (reader.Read())
                {
                    RoleInfo roleInfo = new RoleInfo();

					roleInfo.RoleId = (int)reader["RoleId"];
					roleInfo.RoleName = (string)reader["RoleName"];
					roleInfo.RoleDesc = (string)reader["RoleDesc"];

                    reader.Close();
					
                    return roleInfo;
                }
                else
                {
                    reader.Close();
                    return null;
                }
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                throw e;
            }
        }
		
		
		
		/// <summary>
		/// Method:Get RoleInfo By Security T-SQL
		/// </summary>
		/// <param name="safeSql">Security T-SQL</param>
		/// <returns>IList<RoleInfo></returns>
        private static IList<RoleInfo> GetRoleInfosBySql( string safeSql )
        {
            List<RoleInfo> list = new List<RoleInfo>();

			try
			{
				DataTable table = DBHelper.GetDataSet( safeSql );
				
				foreach (DataRow row in table.Rows)
				{
					RoleInfo roleInfo = new RoleInfo();
					
					roleInfo.RoleId = (int)row["RoleId"];
					roleInfo.RoleName = (string)row["RoleName"];
					roleInfo.RoleDesc = (string)row["RoleDesc"];
	
					list.Add(roleInfo);
				}
	
				return list;
			}
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                throw e;
            }

        }
		/// <summary>
		/// Over Loading Method:Get RoleInfo By Security T-SQL
		/// </summary>
		/// <param name="sql">Security T-SQL</param>
		/// <param name="values">SqlParameter</param>
		/// <returns>IList</returns>
        private static IList<RoleInfo> GetRoleInfosBySql( string sql, params SqlParameter[] values )
        {
            List<RoleInfo> list = new List<RoleInfo>();

			try
			{
				DataTable table = DBHelper.GetDataSet( sql, values );
				
				foreach (DataRow row in table.Rows)
				{
					RoleInfo roleInfo = new RoleInfo();
					
					roleInfo.RoleId = (int)row["RoleId"];
					roleInfo.RoleName = (string)row["RoleName"];
					roleInfo.RoleDesc = (string)row["RoleDesc"];
	
					list.Add(roleInfo);
				}
	
				return list;
			}
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                throw e;
            }
			
        }
		
	}
}