/// <summary>
/// 根据ID查询
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="id"></param>
/// <returns></returns>
public T QueryById <T>(int id) where T : BaseModel
{
Type type = typeof(T);
string sql = $"{SqlStringCache<T>.GetQuerySql()}where id={id}";
return(Execute(sql, i =>
{
SqlDataReader reader = i.ExecuteReader();
if (reader.Read())
{
return GetDate <T>(reader);
}
return null;
}));
}
/// <summary>
/// 查询所有数据
/// </summary>
/// <typeparam name="T"></typeparam>
/// <returns></returns>
public List <T> QueryAll <T>() where T : BaseModel
{
Type type = typeof(T);
string sql = SqlStringCache <T> .GetQuerySql();
return(Execute(sql, i =>
{
List <T> result = new List <T>();
SqlDataReader reader = i.ExecuteReader();
while (reader.Read())
{
result.Add(GetDate <T>(reader));
}
return result;
}));
}