using Infrastructure.Attribute;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using ZR.Model;
using ZR.Model.Dto;
using ZR.Model.Models.Inspect;
using ZR.Model.System;
using ZR.Repository;
using ZR.Service.System.IService;

namespace ZR.Service.System
{
    [AppService(ServiceType = typeof(IPdaAutoUpdateService), ServiceLifetime = LifeTime.Transient)]
    public class PdaAutoUpdateService : BaseService<PdaAutoUpdate>, IPdaAutoUpdateService
    {
        #region 依赖注入
        public PdaAutoUpdateService()
        {

        }
        #endregion

        #region 业务逻辑代码
        public int AddPdaAutoUpdate(PdaAutoUpdate model)
        {
            model.PublishTime = DateTime.Now;
            return Add(model, true);
        }
        public PdaAutoUpdate GetPdaLatestmsg()
        {
            var response = Queryable()
                .OrderByDescending(x => x.Id).First();
            return response;
        }

        #region 2024年3月18日 赵亚雄
        /// <summary>
        /// 查询列表
        /// </summary>
        /// <param name="parm"></param>
        /// <returns></returns>
        public PagedInfo<PdaAutoUpdateDto> GetList(PdaAutoUpdateQueryDto parm)
        {
            //开始拼装查询条件
            var predicate = Expressionable.Create<PdaAutoUpdate>();

            predicate.AndIF(parm.BeginTime != null && parm.EndTime != null, q => q.PublishTime > parm.BeginTime && q.PublishTime < parm.EndTime);
            predicate.AndIF(!string.IsNullOrEmpty(parm.PackageName), q => q.PackageName.Contains(parm.PackageName));
            predicate.AndIF(parm.VersionNo != null, q => q.VersionNo == parm.VersionNo);
            predicate.AndIF(!string.IsNullOrEmpty(parm.VersionName), q => q.VersionName.Contains(parm.VersionName));
            predicate.AndIF(!string.IsNullOrEmpty(parm.UpdateDetails), q => q.UpdateDetails.Contains(parm.UpdateDetails));

            //搜索条件查询语法参考Sqlsugar
            var response = Queryable()
                .Where(predicate.ToExpression())
                .ToPage<PdaAutoUpdate, PdaAutoUpdateDto>(parm);

            return response;
        }
        /// <summary>
        /// 修改
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int UpdatePdaAutoUpdate(PdaAutoUpdate model)
        {
            //var response = Update(w => w.Id == model.Id, it => new PdaAutoUpdate()
            //{
            //    PackageName = model.PackageName,
            //    VersionNo = model.VersionNo,
            //    VersionName = model.VersionName,
            //    PublishTime = model.PublishTime,
            //    UpdateDetails = model.UpdateDetails,
            //    Remark = model.Remark,
            //});
            //return response;
            return Update(model, true);
        }

        #endregion
        #endregion
    }
}