YG-MW-WCS/Projects/永冠/WCS.Service/Helpers/LogHelper.cs

using DBHelper;
using Microsoft.EntityFrameworkCore;
using System;
using System.Linq;
using WCS.Entity;

namespace WCS.Service.Helpers
{
    public class LogHelper
    {
        /// <summary>
        /// 添加异常记录
        /// </summary>
        /// <param name="msg">异常信息</param>
        /// <param name="time">时间</param>
        public static void AddWCS_EXCEPTION(string msg, DateTime time)
        {
            DB.Do(db =>
            {
                var exp = db.Default.Set<WCS_EXCEPTION>()
                .Where(v => EF.Functions.DateDiffSecond(v.UPDATETIME, DateTime.Now) < 5)
                .Where(v => v.MSG == msg)
                .OrderByDescending(v => v.ID)
                .FirstOrDefault();

                if (exp == null)
                {
                    exp = db.Default.Set<WCS_EXCEPTION>().Add(new WCS_EXCEPTION
                    {
                        MSG = msg,
                        STARTTIME = DateTime.Now,
                        TIMES = 0,
                        UPDATETIME = DateTime.Now,
                        UPDATEUSER = "WCS"
                    }).Entity;
                }
                exp.TIMES++;
                exp.UPDATETIME = DateTime.Now;
                db.Default.SaveChanges();
            });
        }

        /// <summary>
        /// 添加异常记录
        /// </summary>
        /// <param name="msg">异常信息</param>
        public static void AddWCS_EXCEPTION(string msg)
        {
            DB.Do(db =>
            {
                var exp = db.Default.Set<WCS_EXCEPTION>()
                .Where(v => EF.Functions.DateDiffSecond(v.UPDATETIME, DateTime.Now) < 5)
                .Where(v => v.MSG == msg)
                .OrderByDescending(v => v.ID)
                .FirstOrDefault();

                if (exp == null)
                {
                    exp = db.Default.Set<WCS_EXCEPTION>().Add(new WCS_EXCEPTION
                    {
                        MSG = msg,
                        STARTTIME = DateTime.Now,
                        TIMES = 0,
                        UPDATETIME = DateTime.Now,
                        UPDATEUSER = "WCS"
                    }).Entity;
                }
                exp.TIMES++;
                exp.UPDATETIME = DateTime.Now;
                db.Default.SaveChanges();
            });
        }
    }
}