public MetaCategoryEntity GetById(int id)
{
string sql = "select name as Name, description as Description from category where Id = ?";
using (var mysqlConn = connectionProvider.GetConnection())
{
return(mysqlConn.QueryFirstOrDefault <MetaCategoryEntity>(sql, new { Id = id }));
}
}
public MetaColorEntity GetById(int id)
{
string sql = "select color_id as ColorId, color_name as ColorName from color where Id = ?";
using (var mysqlConn = connectionProvider.GetConnection())
{
return(mysqlConn.QueryFirstOrDefault <MetaColorEntity>(sql, new { Id = id }));
}
}
/// <summary>
/// 获取单个实体
/// </summary>
/// <param name="id">实体编号</param>
/// <returns>实体</returns>
public CategoryEntity GetById(int id)
{
string sql = @"
select
id as Id,
name as Name,
description as Description,
data_status as DataStatus,
create_time as CreateTime,
last_update_time as LastUpdateTime,
1 as _
from category
where
id = ?
and data_status = 1;";
using (var mysqlConn = connectionProvider.GetConnection())
{
return(mysqlConn.QueryFirstOrDefault <CategoryEntity>(sql, new { id = id }));
}
}
/// <summary>
/// 获取单个实体
/// </summary>
/// <param name="id">实体编号</param>
/// <returns>实体</returns>
public TheBookEntity GetById(int id)
{
string sql = @"
select
id as Id,
title as Title,
category_ids as CategoryIds,
color_id as ColorId,
data_status as DataStatus,
create_time as CreateTime,
last_update_time as LastUpdateTime,
1 as _
from the_book
where
id = ?
and data_status = 1;";
using (var mysqlConn = connectionProvider.GetConnection())
{
return(mysqlConn.QueryFirstOrDefault <TheBookEntity>(sql, new { id = id }));
}
}