using SqlSugar;
using WMS.BZModels;
using WMS.BZModels.Models.KLHC;
using WMS.BZSqlSugar;
using WMS.Info;
using WMS.Util;

namespace WMS.BZServices.KLHC
{
    /// <summary>
    /// 江景缓存信息服务
    /// </summary>
    public class RbciService
    {
        /// <summary>
        /// 江景缓存信息仓储
        /// </summary>
        private readonly Repository<BaseRBCI> _rbciRepository;

        /// <summary>
        /// 江景缓存信息服务构造函数
        /// </summary>
        /// <param name="rbciRepository">江景缓存信息仓储</param>
        public RbciService(Repository<BaseRBCI> rbciRepository)
        {
            _rbciRepository = rbciRepository;
        }

        /// <summary>
        /// 获取江景缓存信息分页列表
        /// </summary>
        /// <param name="pagination">分页信息</param>
        /// <returns></returns>
        public PagedInfo<BaseRBCI> GetPageList(Pagination pagination)
        {
            var list = _rbciRepository.Context.Queryable<BaseRBCI>().With(SqlWith.NoLock).Where(x => x.Id != 0);
            var page = new PagedInfo<BaseRBCI>();
            var total = 0;
            page.PageSize = pagination.rows;
            page.PageIndex = pagination.page;
            pagination.sidx = pagination.sidx.Replace("DESC", "").Replace("ASC", "");
            page.Result = list.ToPageList(pagination.page, pagination.rows, ref total).ToList().OrderBy(x => x.Direction).ThenBy(x => x.WheelType.ToInt()).ToList();
            page.TotalNum = total;
            return page;
        }

        /// <summary>
        /// 更新江景缓存信息的上下限预警值
        /// </summary>
        /// <param name="user">用户信息</param>
        /// <param name="id">缓存信息ID</param>
        /// <param name="upperLimitWarningValue">上限警戒值</param>
        /// <param name="lowerLimitWarningValue">下限警戒值</param>
        /// <param name="Memo">备注</param>
        public void Update(LoginUserInfo user, long id, int upperLimitWarningValue, int lowerLimitWarningValue, string Memo)
        {
            _rbciRepository.UpdateSetColumnsTrue(p => new BaseRBCI()
            {
                UpperLimitWarningValue = upperLimitWarningValue,
                LowerLimitWarningValue = lowerLimitWarningValue,
                Memo = Memo,
                EditTime = DateTime.Now,
                EditWho = user.UserName,
            }, p => p.Id == id);
        }
    }
}