三包协议信息管理接口 - 获取、新增、更新、删除、分页查询

三包协议信息管理接口

该接口提供以下功能：

• 获取单个三包协议信息
• 新增三包协议信息
• 更新三包协议信息
• 删除三包协议信息
• 分页查询三包协议信息列表

获取单个三包协议信息

/// <summary>
/// 获取三包协议信息
/// </summary>
/// <param name="id">三包协议信息ID</param>
/// <returns>三包协议信息Dto</returns>
public static WarrantyDto GetWarranty(Guid id)
{
    using (var context = new SPEHousingDbContext())
    {
        var entity = context.TBL_WARRANTY.Find(id);
        if (entity == null)
            return null;

        return Converter.Convert<TBL_WARRANTY, WarrantyDto>(entity);
    }
}

新增三包协议信息

/// <summary>
/// 新增三包协议信息
/// </summary>
/// <param name="dto">三包协议信息Dto</param>
/// <returns></returns>
public static void AddWarranty(WarrantyDto dto)
{
    using (var context = new SPEHousingDbContext())
    {
        var entity = Converter.Convert<WarrantyDto, TBL_WARRANTY>(dto);
        context.TBL_WARRANTY.Add(entity);
        context.SaveChanges();
    }
}

更新三包协议信息

/// <summary>
/// 更新三包协议信息
/// </summary>
/// <param name="dto">三包协议信息Dto</param>
/// <returns></returns>
public static void UpdateWarranty(WarrantyDto dto)
{
    using (var context = new SPEHousingDbContext())
    {
        var entity = context.TBL_WARRANTY.Find(dto.WarrantyId);
        if (entity == null)
            throw new Exception('未找到相关三包协议信息');

        entity = Converter.Convert<WarrantyDto, TBL_WARRANTY>(dto, entity);
        context.SaveChanges();
    }
}

删除三包协议信息

/// <summary>
/// 删除三包协议信息
/// </summary>
/// <param name="id">三包协议信息ID</param>
/// <returns></returns>
public static void DeleteWarranty(Guid id)
{
    using (var context = new SPEHousingDbContext())
    {
        var entity = context.TBL_WARRANTY.Find(id);
        if (entity == null)
            throw new Exception('未找到相关三包协议信息');

        context.TBL_WARRANTY.Remove(entity);
        context.SaveChanges();
    }
}

分页查询三包协议信息列表

/// <summary>
/// 获取三包协议信息分页列表
/// </summary>
/// <param name="pageIndex">页码</param>
/// <param name="pageSize">分页大小</param>
/// <param name="name">三包协议信息名称 - 搜索项</param>
/// <param name="status">状态 - 搜索项</param>
/// <returns></returns>
public static List<WarrantyDto> GetWarrantyPageList(int pageIndex, int pageSize, string name, int? status)
{
    using (var context = new SPEHousingDbContext())
    {
        var query = context.TBL_WARRANTY.AsQueryable<TBL_WARRANTY>();
        if (!string.IsNullOrEmpty(name))
            query = query.Where(item => item.Name.Contains(name));
        if (status != null)
            query = query.Where(item => item.Status == status.Value);

        var listDto = query.OrderByDescending(item => item.CreateTime)
                            .Skip((pageIndex - 1) * pageSize)
                            .Take(pageSize)
                            .ToList()
                            .Select(item => Converter.Convert<TBL_WARRANTY, WarrantyDto>(item))
                            .ToList();
        return listDto;
    }
}

/// <summary>
/// 获取三包协议信息分页列表
/// </summary>
/// <param name="name">三包协议信息名称 - 搜索项</param>
/// <param name="status">状态 - 搜索项</param>
/// <returns></returns>
public static int GetWarrantyPageListCount(string name, int? status)
{
    using (var context = new SPEHousingDbContext())
    {
        var query = context.TBL_WARRANTY.AsQueryable<TBL_WARRANTY>();
        if (!string.IsNullOrEmpty(name))
            query = query.Where(item => item.Name.Contains(name));
        if (status != null)
            query = query.Where(item => item.Status == status.Value);

        return query.Count();
    }
}

注册通知管理接口

该接口提供以下功能：

• 获取注册通知列表
• 获取单个注册通知
• 新增注册通知
• 更新注册通知

获取注册通知列表

/// <summary>
/// 获取注册通知列表
/// </summary>
/// <param name="status">状态</param>
/// <returns></returns>
public static List<RegisterNoticeDto> GetRegisterNoticeList(int? status)
{
    using (var context = new SPEHousingDbContext())
    {
        var query = context.TBL_REGISTER_NOTICE.AsQueryable<TBL_REGISTER_NOTICE>();
        if (status != null)
            query = query.Where(item => item.Status == status.Value);

        var listDto = query.OrderByDescending(item => item.CreateTime)
                            .ToList()
                            .Select(item => Converter.Convert<TBL_REGISTER_NOTICE, RegisterNoticeDto>(item))
                            .ToList();
        return listDto;
    }
}

获取单个注册通知

/// <summary>
/// 获取注册通知
/// </summary>
/// <param name="id">注册通知ID</param>
/// <returns>注册通知Dto</returns>
public static RegisterNoticeDto GetRegisterNotice(Guid id)
{
    using (var context = new SPEHousingDbContext())
    {
        var entity = context.TBL_REGISTER_NOTICE.Find(id);
        if (entity == null)
            return null;

        return Converter.Convert<TBL_REGISTER_NOTICE, RegisterNoticeDto>(entity);
    }
}

新增注册通知

/// <summary>
/// 新增注册通知
/// </summary>
/// <param name="dto">注册通知Dto</param>
/// <returns></returns>
public static void AddRegisterNotice(RegisterNoticeDto dto)
{
    using (var context = new SPEHousingDbContext())
    {
        var entity = Converter.Convert<RegisterNoticeDto, TBL_REGISTER_NOTICE>(dto);
        context.TBL_REGISTER_NOTICE.Add(entity);
        context.SaveChanges();
    }
}

更新注册通知

/// <summary>
/// 更新注册通知
/// </summary>
/// <param name="dto">注册通知Dto</param>
/// <returns></returns>
public static void UpdateRegisterNotice(RegisterNoticeDto dto)
{
    using (var context = new SPEHousingDbContext())
    {
        var entity = context.TBL_REGISTER_NOTICE.Find(dto.RegisterNoticeId);
        if (entity == null)
            throw new Exception('未找到相关注册通知');

        entity = Converter.Convert<RegisterNoticeDto, TBL_REGISTER_NOTICE>(dto, entity);
        context.SaveChanges();
    }
}

删除注册通知

/// <summary>
/// 删除注册通知
/// </summary>
/// <param name="id">注册通知ID</param>
/// <returns></returns>
public static void DeleteRegisterNotice(Guid id)
{
    using (var context = new SPEHousingDbContext())
    {
        var entity = context.TBL_REGISTER_NOTICE.Find(id);
        if (entity == null)
            throw new Exception('未找到相关注册通知');

        context.TBL_REGISTER_NOTICE.Remove(entity);
        context.SaveChanges();
    }
}