using Infrastructure.Attribute;

using DOAN.Repository;
using DOAN.Model.Factory_Model.Dto;
using DOAN.Model.Factory_Model;
using DOAN.Service.Factory_Model.IService;
using Mapster;



namespace DOAN.Service.Factory_Model
{
    /// <summary>
    /// 设备台账Service业务层处理
    /// </summary>
    [AppService(ServiceType = typeof(IBaseDeviceAccountService), ServiceLifetime = LifeTime.Transient)]
    public class BaseDeviceAccountService : BaseService<BaseDeviceAccount>, IBaseDeviceAccountService
    {
        /// <summary>
        /// 查询设备台账列表
        /// </summary>
        /// <param name="parm"></param>
        /// <returns></returns>
        public PagedInfo<BaseDeviceAccountDto> GetList(BaseDeviceAccountQueryDto parm)
        {
            var predicate = QueryExp(parm);


            var query = Queryable()
            .Where(predicate.ToExpression());

            var response = Context.Queryable(query).LeftJoin<BaseProductionLine>((q, c) => q.FkLineId == c.Id)
                .Select((q, c) => new BaseDeviceAccountDto()
                {
                    ProductionLineName = c.LineName
                }, true).ToPage<BaseDeviceAccountDto, BaseDeviceAccountDto>(parm);

            return response;
        }

        public List<BaseDeviceAccountDto> GetList_NO_Page(BaseDeviceAccountQueryDto parm)
        {
            var predicate = QueryExp(parm);

            var response = Queryable()
                .Where(predicate.ToExpression())
                .ToList()
                .Adapt<List<BaseDeviceAccountDto>>();

            return response;

        }
        /// <summary>
        /// 获取详情
        /// </summary>
        /// <param name="Id"></param>
        /// <returns></returns>
        public BaseDeviceAccount GetInfo(int Id)
        {
            var response = Queryable()
                .Where(x => x.Id == Id)
                .First();

            return response;
        }

        /// <summary>
        /// 添加设备台账
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public BaseDeviceAccount AddBaseDeviceAccount(BaseDeviceAccount model)
        {
            return Insertable(model).ExecuteReturnEntity();
        }

        /// <summary>
        /// 修改设备台账
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int UpdateBaseDeviceAccount(BaseDeviceAccount model)
        {
            return Update(model, true);
        }

        /// <summary>
        /// 查询导出表达式
        /// </summary>
        /// <param name="parm"></param>
        /// <returns></returns>
        private static Expressionable<BaseDeviceAccount> QueryExp(BaseDeviceAccountQueryDto parm)
        {
            var predicate = Expressionable.Create<BaseDeviceAccount>()
                .AndIF(!string.IsNullOrEmpty(parm.DeviceCode), it => it.DeviceCode.Contains(parm.DeviceCode))
                .AndIF(!string.IsNullOrEmpty(parm.DeviceName), it => it.DeviceName.Contains(parm.DeviceName))
                .AndIF(parm.Status > -1, it => it.Status == parm.Status)
                .AndIF(parm.FkLineId > -1, it => it.FkLineId == parm.FkLineId)

                ;

            return predicate;
        }
    }
}