BLL/Log.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Logistics.DAL;
using Logistics.IDal;
using System.Data;

namespace Logistics.BLL
{
    public class Log
    {
        public static void record(string _log_tablename, int _log_userid, string _log_action, string _log_remark, int _log_rowid)
        {
            Logistics.Model.Logistics_Log log = new Logistics.Model.Logistics_Log();
            log.Log_TableName = _log_tablename;
            log.User_ID = _log_userid;
            log.Log_Action = _log_action;
            log.Log_Remark = _log_remark;
            log.Log_RowID = _log_rowid;
            log.Log_Time = DateTime.Now;
            ISessionn session = SessionFactory.createSession();
            session.add(log);
            session.close();
        }
        /// <summary>
        /// 得到所有的日志
        /// </summary>
        /// <param name="startIndex">开始的页数</param>
        /// <param name="pageSize">每页大小</param>
        /// <returns></returns>
        public DataTable getAllLog(int startIndex, int pageSize)
        {
            ISessionn session = SessionFactory.createSession();
            var sql = "select * from dbo.Logistics_Log";
            DataTable dt = session.createQuery().execute(startIndex, sql, pageSize, "Log_ID").Tables[0];
            return dt;
        }
        /// <summary>
        /// 根据每页显示的记录数查询共有的页数
        /// </summary>
        /// <param name="pageSize">一页显示记录数</param>
        /// <returns></returns>
        public int getPageCount(int pageSize)
        {
            var temp = 0;
            ISessionn session = SessionFactory.createSession();
            var sql = "select count(Log_ID) as shuliang from dbo.Logistics_Log";
            DataTable dt = session.createQuery().execute(sql).Tables[0];
           int i= int.Parse(dt.Rows[0][0].ToString());
           if (i % pageSize == 0)
           {
               temp = i / pageSize;
           }
           else
           {
               temp = i / pageSize + 1;
           }
            return temp;
        }