/// <summary>
/// 转换为数据库请求
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public NoticeCategoryGetEntityByPrimaryPropertyRequest ToGetEntityByPrimaryProperty(NoticeCategoryUpdateRequest request)
{
NoticeCategoryGetEntityByPrimaryPropertyRequest returnValue = new NoticeCategoryGetEntityByPrimaryPropertyRequest();
returnValue.Name = request.Name;
return(returnValue);
}
/// <summary>
/// 根据主属性获取单个实体
/// </summary>
public NoticeCategoryEntity GetEntityByPrimaryProperty(NoticeCategoryGetEntityByPrimaryPropertyRequest request)
{
string sql = @"
select
id as Id,
name as Name,
title as Title,
remark as Remark,
data_status as DataStatus,
create_time as CreateTime,
last_update_time as LastUpdateTime
from `oam_notice_category`
where
name = @Name
and data_status = 1;";
using (var mysqlConn = connectionProvider.GetConnection())
{
return(mysqlConn.QueryFirstOrDefault <NoticeCategoryEntity>(sql, request));
}
}
