odf_new/server/ZR.Service/Business/OdfCableFaultImagesService.cs

using Infrastructure.Attribute;
using ZR.Model.Business;
using ZR.Repository;
using ZR.Service.Business.IBusinessService;

namespace ZR.Service.Business
{
    /// <summary>
    /// 故障图片Service业务层处理
    /// </summary>
    [AppService(ServiceType = typeof(IOdfCableFaultImagesService), ServiceLifetime = LifeTime.Transient)]
    public class OdfCableFaultImagesService : BaseService<OdfCableFaultImages>, IOdfCableFaultImagesService
    {
        /// <summary>
        /// 按故障 ID 查询图片列表
        /// </summary>
        /// <param name="faultId"></param>
        /// <returns></returns>
        public List<OdfCableFaultImages> GetByFaultId(int faultId)
        {
            return Queryable()
                .Where(x => x.FaultId == faultId)
                .OrderBy(x => x.Id)
                .ToList();
        }

        /// <summary>
        /// 批量插入图片记录
        /// </summary>
        /// <param name="faultId"></param>
        /// <param name="imageUrls"></param>
        /// <returns></returns>
        public int BatchInsert(int faultId, List<string> imageUrls)
        {
            if (imageUrls == null || imageUrls.Count == 0)
            {
                return 0;
            }

            var list = imageUrls.Select(url => new OdfCableFaultImages
            {
                FaultId = faultId,
                ImageUrl = url,
                CreatedAt = DateTime.Now
            }).ToList();

            return Insert(list);
        }

        /// <summary>
        /// 按故障 ID 删除所有图片记录
        /// </summary>
        /// <param name="faultId"></param>
        /// <returns></returns>
        public int DeleteByFaultId(int faultId)
        {
            return Deleteable()
                .Where(x => x.FaultId == faultId)
                .ExecuteCommand();
        }
    }
}