APCGC_CBS.DAL/Admin/DALSysLog.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using APCGC_CBS.DAL.DataAccess;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace APCGC_CBS.DAL.Admin
{
    public class DALSysLog
    {
        /// <summary>
        /// 添加用户操作日志
        /// </summary>
        /// <param name="UserID"></param>
        /// <param name="LogType"></param>
        /// <param name="Message"></param>
        /// <param name="Remark"></param>
        /// <param name="ClientIP"></param>
        /// <param name="ClientType"></param>
        /// <returns></returns>
        public static int AddSysLog(int UserID, string LogType, string Message, string Remark, string ClientIP, string ClientType)
        {
            string strSql = @"INSERT INTO [Sys_Log]([LogType],[UserID],[Message],[Remark],[ClientIP],[ClientType]) 
                                VALUES(@LogType,@UserID,@Message,@Remark,@ClientIP,@ClientType); select @@identity";
            SqlParameter[] parameters = {
                    new SqlParameter("@UserID", SqlDbType.BigInt),
                    new SqlParameter("@LogType", SqlDbType.VarChar),
                    new SqlParameter("@Message", SqlDbType.VarChar),
                    new SqlParameter("@Remark", SqlDbType.VarChar),
                    new SqlParameter("@ClientIP", SqlDbType.VarChar),
                    new SqlParameter("@ClientType", SqlDbType.VarChar)
                                        };
            parameters[0].Value = UserID;
            parameters[1].Value = LogType;
            parameters[2].Value = Message;
            parameters[3].Value = Remark;
            parameters[4].Value = ClientIP;
            parameters[5].Value = ClientType;
            int res = Convert.ToInt32(DbHelperSQL.GetSingle(strSql, parameters));
            return res;
        }

        /// <summary>
        /// 日志列表
        /// </summary>
        /// <param name="SqlWhere"></param>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <param name="count"></param>
        /// <returns></returns>
        public static DataTable GetSysLogListPage(string SqlWhere, int pageIndex, int pageSize, ref int count)
        {
            string sql = @"SELECT SL.*,SU.UserName FROM [Sys_Log] SL LEFT JOIN Sys_UserInfo SU ON SL.UserID = SU.User_ID";
            SqlParameter[] parameters = null;
            if (!string.IsNullOrEmpty(SqlWhere))
                sql = sql + SqlWhere;
            DataTable oldData = DbHelperSQL.GetPageList(sql, parameters, "LogTime", "DESC", pageIndex, pageSize, ref count);