Hidistro.SqlDal/Store/LogDao.cs

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

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

namespace Hidistro.SqlDal.Store
{
    using Hidistro.Core;
    using Hidistro.Core.Entities;
    using Hidistro.Entities.Store;
    using Microsoft.Practices.EnterpriseLibrary.Data;
    using System;
    using System.Collections.Generic;
    using System.Data;
    using System.Data.Common;
    using System.Text;

    public class LogDao
    {
        private Database database = DatabaseFactory.CreateDatabase();

        public bool DeleteAllLogs()
        {
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand("TRUNCATE TABLE Hishop_Logs");
            try
            {
                this.database.ExecuteNonQuery(sqlStringCommand);
                return true;
            }
            catch (Exception)
            {
                return false;
            }
        }

        public bool DeleteLog(long logId)
        {
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand("DELETE FROM Hishop_Logs WHERE LogId = @LogId");
            this.database.AddInParameter(sqlStringCommand, "LogId", DbType.Int64, logId);
            return (this.database.ExecuteNonQuery(sqlStringCommand) == 1);
        }

        public int DeleteLogs(string strIds)
        {
            if (strIds.Length <= 0)
            {
                return 0;
            }
            string query = string.Format("DELETE FROM Hishop_Logs WHERE LogId IN ({0})", strIds);
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand(query);
            return this.database.ExecuteNonQuery(sqlStringCommand);
        }

        public DbQueryResult GetLogs(OperationLogQuery query)
        {
            StringBuilder builder = new StringBuilder();
            Pagination page = query.Page;
            if (query.FromDate.HasValue)
            {
                builder.AppendFormat("AddedTime >= '{0}'", query.FromDate.Value.ToString("yyyy-MM-dd 00:00:00"));
            }
            if (query.ToDate.HasValue)
            {
                if (!string.IsNullOrEmpty(builder.ToString()))
                {