Repository

Concept

A repository hides persistence details: the domain talks to an interface, infrastructure implements it (EF, mooSQL, …). In DDD, one repository per aggregate root is typical.

Why use it

1. Domain code focuses on rules, not SQL/ORM details.
2. Swapping ORMs mostly changes the implementation, not domain contracts.

Setup

private readonly SooRepository<SysRegion> _sysRegionRep;

public SysRegionService(SqlSugarRepository<SysRegion> sysRegionRep)
{
    _sysRegionRep = DBCash.useRepo<SysRegion>(0);
}

GetList

<List<SysRegion> list= _sysRegionRep.GetList(u => u.Pid == input.Id);

First 100 rows:

<List<SysRegion> list= _sysRegionRep.GetList(100);

GetFirst

var sysRegion =  _sysRegionRep.GetFirst(u => u.Id == input.Id);

GetPageList

var res=Rep.GetPageList(input.Page, input.PageSize, (c, d) => {
    c.where(()=>d.CreateTime,input.StartTime,">=")
    .where(()=>d.CreateTime,input.EndTime,"<=")
    .orderByDesc(()=>d.CreateTime);
});

GetTreeList

var menuList = _sysMenuRep.GetTreeList((m) => m.Pid, 0
    , (c, m) => {
        c.where(() => m.Type, MenuTypeEnum.Btn, "!=")
        .where(() => m.Status, StatusEnum.Enable)
        .orderBy(() => m.OrderNo)
        .orderBy(() => m.Id);
    });

GetChildList

var list = Rep.GetChildList((r) => r.Pid, input.Id);

Insert / InsertRange

_sysRegionRep.Insert(sysRegion)

_sysRegionRep.InsertRange(sysRegions)

IsAny

var isExist =  _sysRegionRep.IsAny(u => u.Name == input.Name && u.Code == input.Code);
if (isExist)
    throw Oops.Oh(ErrorCodeEnum.R2002);

Update / UpdateRange

_sysRegionRep.Update(new SysRegion());

_sysRegionRep.UpdateRange(new SysRegion());

DeleteByIds

public async Task DeleteRegion(DeleteRegionInput input)
{
    var regionTreeList = _sysRegionRep.useBus().Where(u => u.Pid == input.Id).ToList();
    var regionIdList = regionTreeList.Select(u => u.Id).ToList();
    regionIdList.Add(input.Id);
    _sysRegionRep.DeleteByIds(regionIdList);
}

Delete

_sysPosRep.Delete(u => u.Id == input.Id);

ChangeTo

var hasPosEmp =  _sysPosRep.ChangeTo<SysUser>()
    .IsAny(u => u.PosId == input.Id);