kjh.api.55128.cn_old/CP.Model/other/SysLog.cs

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using CP.Common;
using MC.ORM;
using MySql.Data.MySqlClient;
using NIU.Core;
using NIU.Forum.Common;

namespace CP.Model
{

    #region 系统操作日志模型
    /// <summary>
    /// 系统操作日志模型
    /// </summary>
    [TableName("SysLog"), PrimaryKey("id")]
    public class SysLogInfo
    {
        public int id { get; set; }
        /// <summary>
        /// 用户名
        /// </summary>
        public string username { get; set; }
        /// <summary>
        /// 用户名id
        /// </summary>
        public int userid { get; set; }
        /// <summary>
        /// 操作标题
        /// </summary>
        public string title { get; set; }
        /// <summary>
        /// 具体内容
        /// </summary>
        public string Contents { get; set; }
        /// <summary>
        /// 用户名IP
        /// </summary>
        public string IP { get; set; }
        /// <summary>
        /// 添加时间
        /// /// </summary>
        public DateTime addtime { get; set; }

    }
    #endregion

    /// <summary>
    ///  系统操作日志的数据库操作
    /// </summary>
    public class SysLogData : DataConnect
    {

        /// <summary>
        /// 日志数据列表..
        /// </summary>
        /// <returns></returns>
        public static List<SysLogInfo> GetSysLogList()
        {
            List<SysLogInfo> list = new List<SysLogInfo>();
            DataConnect dc = new DataConnect();

            list = dc.db.Fetch<SysLogInfo>("where n1>0 order by id asc");
  
            return list;

        }
        /// <summary>
        /// 根据Id获取
        /// </summary>
        /// <returns></returns>
        public static SysLogInfo GetById(long id)
        {
            DataConnect dc = new DataConnect();
            return dc.db.SingleOrDefault<SysLogInfo>(id);
        }
        /// <summary>
        /// 添加
        /// </summary>
        /// <returns></returns>
        public static void Add(SysLogInfo model)
        {
            if (model == null)
                throw new OperationExceptionFacade("未接收到参数");
            DataConnect dc = new DataConnect();
            model.addtime = DateTime.Now;
            dc.db.Insert(model);
        }
        public static Page<SysLogInfo> GetPager(int pageIndex, int pageSize)
        {
            string sql = "order by id desc";
            DataConnect dc = new DataConnect();
            var datas = dc.db.Page<SysLogInfo>(pageIndex, pageSize, sql);
            return datas;
        }
        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public static void Delete(long id)
        {
            var entity = GetById(id);
            if (entity == null)
            {
                throw new OperationExceptionFacade("数据不存在，请刷新");
            }
            DataConnect dc = new DataConnect();
            dc.db.Delete<SysLogInfo>(id);
        }

    }

}