operatelogservice.cs

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

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

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 OperateLogService
	{
        /// <summary>
        /// 
        /// </summary>
        /// <param name="operateLog"></param>
        /// <returns></returns>
        public static OperateLog AddOperateLog(OperateLog operateLog)
		{
            string sql =
				"INSERT OperateLog (UserId, OperateName, ObjectId, OperateDesc, OperateTime)" +
				"VALUES (@UserId, @OperateName, @ObjectId, @OperateDesc, @OperateTime)";
				
			sql += " ; SELECT @@IDENTITY";

            try
            {
				SqlParameter[] para = new SqlParameter[]
				{
					new SqlParameter("@UserId", operateLog.User.UserId), //FK
					new SqlParameter("@OperateName", operateLog.OperateName),
					new SqlParameter("@ObjectId", operateLog.ObjectId),
					new SqlParameter("@OperateDesc", operateLog.OperateDesc),
					new SqlParameter("@OperateTime", operateLog.OperateTime)
				};
				
                int newId = DBHelper.GetScalar(sql, para);
				return GetOperateLogByOperateId(newId);
            }
            catch (Exception e)
            {
				Console.WriteLine(e.Message);
                throw e;
            }
		}
		/// <summary>
		/// 
		/// </summary>
		/// <param name="operateLog"></param>
        public static void DeleteOperateLog(OperateLog operateLog)
		{
			DeleteOperateLogByOperateId( operateLog.OperateId );
		}
        /// <summary>
        /// 
        /// </summary>
        /// <param name="operateId"></param>
        public static void DeleteOperateLogByOperateId(int operateId)
		{
            string sql = "DELETE OperateLog WHERE OperateId = @OperateId";

            try
            {
				SqlParameter[] para = new SqlParameter[]
				{
					new SqlParameter("@OperateId", operateId)
				};
			
                DBHelper.ExecuteCommand(sql, para);
            }
            catch (Exception e)
            {
				Console.WriteLine(e.Message);
				throw e;
            }
		}
        /// <summary>
        /// 
        /// </summary>
        /// <param name="operateIds"></param>
        public static Boolean DeleteOperateLogByOperateIds(String operateIds)
        {
            string sql = "DELETE OperateLog WHERE OperateId in ("+operateIds+")";

            try
            {
                DBHelper.ExecuteCommand(sql);
                return true;
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                throw e;
            }
            return false;
        }
		/// <summary>
		/// 
		/// </summary>
		/// <param name="operateLog"></param>
        public static void ModifyOperateLog(OperateLog operateLog)
        {
            string sql =
                "UPDATE OperateLog " +
                "SET " +
	                "UserId = @UserId, " + //FK
	                "OperateName = @OperateName, " +
	                "ObjectId = @ObjectId, " +
	                "OperateDesc = @OperateDesc, " +
	                "OperateTime = @OperateTime " +
                "WHERE OperateId = @OperateId";


            try
            {
				SqlParameter[] para = new SqlParameter[]
				{
					new SqlParameter("@OperateId", operateLog.OperateId),
					new SqlParameter("@UserId", operateLog.User.UserId), //FK
					new SqlParameter("@OperateName", operateLog.OperateName),
					new SqlParameter("@ObjectId", operateLog.ObjectId),
					new SqlParameter("@OperateDesc", operateLog.OperateDesc),
					new SqlParameter("@OperateTime", operateLog.OperateTime)
				};

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

        }		
        /// <summary>
        /// 
        /// </summary>
        /// <returns></returns>
        public static IList<OperateLog> GetAllOperateLogs()
        {
            string sqlAll = "SELECT * FROM OperateLog";
			return GetOperateLogsBySql( sqlAll );
        }
        /// <summary>
        /// 
        /// </summary>
        /// <returns></returns>
        public static IList<OperateLog> GetAllOperateLogByCondition(String StartTime,String EndTime)
        {
            String sql = "select * from OperateLog";
            if (StartTime != "" && EndTime != "")
            {
                sql += " where OperateTime between '"+StartTime+"' and '"+EndTime+"'";
            }
            return GetOperateLogsBySql(sql);
        }
		/// <summary>
		/// 
		/// </summary>
		/// <param name="operateId"></param>
		/// <returns></returns>
        public static OperateLog GetOperateLogByOperateId(int operateId)
        {
            string sql = "SELECT * FROM OperateLog WHERE OperateId = @OperateId";

			string userId;

            try
            {
                SqlDataReader reader = DBHelper.GetReader(sql, new SqlParameter("@OperateId", operateId));
                if (reader.Read())
                {
                    OperateLog operateLog = new OperateLog();

					operateLog.OperateId = (int)reader["OperateId"];
					operateLog.OperateName = (string)reader["OperateName"];
					operateLog.ObjectId = (string)reader["ObjectId"];
					operateLog.OperateDesc = (string)reader["OperateDesc"];
					operateLog.OperateTime = (DateTime)reader["OperateTime"];
                    userId = (string)reader["UserId"]; //FK

                    reader.Close();

					operateLog.User = UserInfoService.GetUserInfoByUserId(userId);
					
                    return operateLog;
                }
                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<OperateLog> GetOperateLogsBySql( string safeSql )
        {
            List<OperateLog> list = new List<OperateLog>();

			try
			{
				DataTable table = DBHelper.GetDataSet( safeSql );
				
				foreach (DataRow row in table.Rows)
				{
					OperateLog operateLog = new OperateLog();
					
					operateLog.OperateId = (int)row["OperateId"];
					operateLog.OperateName = (string)row["OperateName"];
					operateLog.ObjectId = (string)row["ObjectId"];
					operateLog.OperateDesc = (string)row["OperateDesc"];
					operateLog.OperateTime = (DateTime)row["OperateTime"];
					operateLog.User = UserInfoService.GetUserInfoByUserId((string)row["UserId"]); //FK
	
					list.Add(operateLog);
				}
	
				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<OperateLog> GetOperateLogsBySql( string sql, params SqlParameter[] values )
        {
            List<OperateLog> list = new List<OperateLog>();

			try
			{
				DataTable table = DBHelper.GetDataSet( sql, values );
				
				foreach (DataRow row in table.Rows)
				{
					OperateLog operateLog = new OperateLog();
					
					operateLog.OperateId = (int)row["OperateId"];
					operateLog.OperateName = (string)row["OperateName"];
					operateLog.ObjectId = (string)row["ObjectId"];
					operateLog.OperateDesc = (string)row["OperateDesc"];
					operateLog.OperateTime = (DateTime)row["OperateTime"];
					operateLog.User = UserInfoService.GetUserInfoByUserId((string)row["UserId"]); //FK
	
					list.Add(operateLog);
				}
	
				return list;
			}
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                throw e;
            }
			
        }
		
	}
}