/// <summary>
/// 添加数据
/// </summary>
/// <param name="dto"></param>
protected virtual async Task <TDataModelType> AddAsync(TDataModelType data)
{
Ensure.NotNull(data, nameof(data));
data.CreateDate = DateTime.Now;
data.LastModifyDate = DateTime.Now;
TDataModelType result = (await CSLDbContext.Set <TDataModelType>().AddAsync(data)).Entity;
await CSLDbContext.SaveChangesAsync();
return(result);
}
/// <summary>
/// 根据 ID 删除实数据
/// </summary>
/// <param name="id"></param>
public async Task DeleteByIdAsync(int id)
{
TDataModelType data = CSLDbContext.Set <TDataModelType>().Find(id);
if (data == null)
{
throw new ArgumentException($"指定删除的数据(id:{id})不存在");
}
CSLDbContext.Set <TDataModelType>().Remove(data);
await CSLDbContext.SaveChangesAsync();
}
public virtual TDataModelType Add(TDataModelType data)
{
Ensure.NotNull(data, nameof(data));
data.CreateDate = DateTime.Now;
data.LastModifyDate = DateTime.Now;
TDataModelType result = CSLDbContext.Set <TDataModelType>().Add(data).Entity;
CSLDbContext.SaveChanges();
return(result);
}
public async virtual Task <List <TDtoType> > ListDtos()
{
List <TDataModelType> datas = await CSLDbContext.Set <TDataModelType>().ToListAsync();
List <TDtoType> dtos = new List <TDtoType>();
foreach (TDataModelType item in datas)
{
dtos.Add(new TDtoType().ConvertFromDataModel(item));
}
return(dtos);
}
/// <summary>
/// 添加数据
/// </summary>
/// <param name="dto"></param>
public virtual async Task <TDataModelType> AddAsync(TDataModelType data)
{
if (data == null)
{
throw new ArgumentNullException(nameof(data));
}
data.CreateDate = DateTime.Now;
data.LastModifyDate = DateTime.Now;
TDataModelType result = (await CSLDbContext.Set <TDataModelType>().AddAsync(data)).Entity;
await CSLDbContext.SaveChangesAsync();
return(result);
}
/// <summary>
/// 编辑数据
/// </summary>
/// <param name="dto"></param>
public virtual async Task UpdateAsync(TDataModelType data)
{
if (data == null)
{
throw new ArgumentNullException(nameof(data));
}
data.LastModifyDate = DateTime.Now;
TDataModelType entity = CSLDbContext.Set <TDataModelType>().Where(e => e.Id == data.Id).FirstOrDefault();
Type modelType = typeof(TDataModelType);
foreach (string propName in typeof(TDataModelType).GetProperties().Select(p => p.Name).ToList())
{
modelType.GetProperty(propName).SetValue(entity, modelType.GetProperty(propName).GetValue(data));
}
CSLDbContext.Set <TDataModelType>().Update(entity);
await CSLDbContext.SaveChangesAsync();
}
public virtual async Task <QiniuStorageInfo> UpdateFileStorageInfo(QiniuStorageInfo qiniuStorageInfo)
{
Ensure.NotNull(qiniuStorageInfo, nameof(qiniuStorageInfo));
QiniuStorageInfo entityToUpdate = CSLDbContext.QiniuStorageInfoes.Where(item => item.FullName == qiniuStorageInfo.FullName).FirstOrDefault();
if (entityToUpdate != null)
{
CSLDbContext.QiniuStorageInfoes.Remove(entityToUpdate);
}
qiniuStorageInfo.CreateDate = DateTime.Now;
qiniuStorageInfo.LastModifyDate = DateTime.Now;
EntityEntry <QiniuStorageInfo> entry = await CSLDbContext.QiniuStorageInfoes.AddAsync(qiniuStorageInfo);
await CSLDbContext.SaveChangesAsync();
return(entry.Entity);
}
public BaseService()
{
this.CSLDbContext = new CSLDbContext();
}
/// <summary>
/// 根据 ID 查询数据。
/// </summary>
/// <param name="id"></param>
/// <returns>查找到的数据，或是 null</returns>
public TDataModelType GetById(int id)
{
TDataModelType data = CSLDbContext.Set <TDataModelType>().Find(id);
return(data);
}
public virtual List <TDataModelType> ListWhereAsync(Func <TDataModelType, bool> predicate)
{
List <TDataModelType> results = CSLDbContext.Set <TDataModelType>().Where(predicate).ToList();
return(results);
}
public async virtual Task <List <TDataModelType> > ListAsync()
{
List <TDataModelType> results = await CSLDbContext.Set <TDataModelType>().ToListAsync();
return(results);
}
/// <summary>
/// 根据 ID 查询数据。
/// </summary>
/// <param name="id"></param>
/// <returns>查找到的数据，或是 null</returns>
public async Task <TDataModelType> GetById(int id)
{
TDataModelType data = await CSLDbContext.Set <TDataModelType>().FindAsync(id);
return(data);
}
