/// <summary>
/// 将entity转换为vo。不包括来自元数据的属性
/// </summary>
private void CopyToVo(TheBookVo vo, TheBookEntity entity)
{
vo.Id = entity.Id;
vo.Title = entity.Title;
vo.DataStatus = entity.DataStatus;
vo.CreateTime = entity.CreateTime;
vo.LastUpdateTime = entity.LastUpdateTime;
}
/// <summary>
/// 新增实体
/// </summary>
public void Create(TheBookEntity entity)
{
string sql = @"
insert into the_book(title, category_ids, color_id, data_status, create_time, last_update_time)
values(@Title, @CategoryIds, @ColorId, @DataStatus, @CreateTime, @LastUpdateTime);";
using (var mysqlConn = connectionProvider.GetConnection())
{
mysqlConn.Execute(sql, entity);
}
}
/// <summary>
/// 将entity转换为vo
/// </summary>
public TheBookExtendedVo toExtendedVo(TheBookEntity entity)
{
TheBookExtendedVo vo = new TheBookExtendedVo();
CopyToVo(vo, entity);
if (!string.IsNullOrEmpty(entity.CategoryIds))
{
var items = entity.CategoryIds.Split(";").ToList();
vo.CategoryIds = metaCategoryProvider.ToMetadataList(items);
}
vo.ColorId = metaColorProvider.ToMetadata(entity.ColorId);
return(vo);
}
/// <summary>
/// 将entity转换为vo
/// </summary>
public TheBookBasicVo toBasicVo(TheBookEntity entity)
{
TheBookBasicVo vo = new TheBookBasicVo();
CopyToVo(vo, entity);
if (!string.IsNullOrEmpty(entity.CategoryIds))
{
vo.CategoryIds = entity.CategoryIds.Split(";").ToList();
}
vo.ColorId = entity.ColorId;
return(vo);
}
public TheBookEntity toEntity(TheBookCreateRequest request)
{
TheBookEntity entity = new TheBookEntity();
var item = request.Item;
entity.Title = item.Title;
entity.CategoryIds = item.CategoryIds != null?string.Join(";", item.CategoryIds) : null;
entity.ColorId = item.ColorId;
entity.DataStatus = 1;
entity.CreateTime = TimeConvertor.FromMilliTicks(TimeConvertor.ToMilliTicks(DateTime.Now));
entity.LastUpdateTime = TimeConvertor.FromMilliTicks(TimeConvertor.ToMilliTicks(DateTime.Now));
return(entity);
}
/// <summary>
/// 更新实体
/// </summary>
public void Update(TheBookEntity entity)
{
string sql = @"
update the_book
set
title = @Title,
category_ids = @CategoryIds,
color_id = @ColorId,
data_status = @DataStatus,
create_time = @CreateTime,
last_update_time = @LastUpdateTime,
id = id
where
id = @Id;";
using (var mysqlConn = connectionProvider.GetConnection())
{
mysqlConn.Execute(sql, entity);
}
}
public TheBookItemResponse Item([FromBody] TheBookItemRequest request)
{
TheBookItemResponse response = new TheBookItemResponse();
if (request.Id <= 0)
{
response.Status = -1;
return(response);
}
TheBookEntity entity = theBookRepository.GetById(request.Id);
if (entity == null)
{
response.Status = 404;
return(response);
}
response.Item = theBookConvertor.toExtendedVo(entity);
response.Status = 1;
return(response);
}
public TheBookUpdateResponse Update([FromBody] TheBookUpdateRequest request)
{
TheBookUpdateResponse response = new TheBookUpdateResponse();
if (request.Id == 0 || request.Id < 0)
{
response.Status = -1;
return(response);
}
TheBookEntity entity = theBookRepository.GetById(request.Id);
if (entity == null)
{
response.Status = 404;
return(response);
}
theBookRepository.Update(theBookConvertor.toEntity(request, entity));
response.Status = 1;
return(response);
}
