/// <summary>
/// 功能描述：自定义Sql查询
/// 创建人：甘春雨
/// 创建时间：2016年1月7日20:18:09
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static List <T> SqlQueryList(string sql)
{
List <T> data = default(List <T>);
try
{
using (DbBase DbContent = new DbBase(connectionName))
{
data = DapperEx.QueryData <T>(DbContent, sql);
}
}
catch (Exception)
{
}
return(data);
}
/// <summary>
/// 通过主键集合获取models
/// </summary>
/// <param name="ids"></param>
/// <returns></returns>
public async Task <List <T> > GetModelsByPrimaryKeyIdsAsync(IEnumerable <string> ids, bool?enable = true)
{
var keyName = DapperEx.GetTablePrimaryKey <T>();
var distinctIds = ids.Distinct();
using (var conn = MySqlHelper.GetConnection())
{
var sqlWhere = string.Empty;
if (enable.HasValue)
{
sqlWhere = " and `enable`=@enable";
}
var result = await conn.GetListAsync <T>($"where {keyName} in @distinctIds {sqlWhere}", new { distinctIds, enable });
return(result.ToList());
}
}
