/// <summary>
/// 查询集合，带分页
/// </summary>
/// <param name="item">框架实体</param>
/// <param name="dp">分页对象</param>
/// <returns>对象集合</returns>
public List <T> SelectList(FrameWorkItem item, DataPage dp = null)
{
IDataReader dr = null;
try
{
dr = BuildDataReader(item, dp);
List <T> list = new List <T>();
if (dp != null && dp.PageSize > 0)
{
int result = GetResult <int>(string.Format("SELECT COUNT(1) FROM ({0}) a", item.Sql), item.ConnectionString, item.SqlParam);
dp.RowCount = result;
}
while (dr != null && dr.Read())
{
T tempT = new T();
tempT = DynamicBuilderEntity <T> .CreateBuilder(dr).Build(dr);
list.Add(tempT);
}
return(list);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dr != null)
{
dr.Close();
}
}
}
/// <summary>
/// 查询单个实体
/// </summary>
/// <param name="item">框架实体</param>
/// <returns>单个对象</returns>
public T SelectModel(FrameWorkItem item)
{
IDataReader dr = null;
try
{
dr = BuildDataReader(item);
if (dr != null && dr.Read())
{
return(DynamicBuilderEntity <T> .CreateBuilder(dr).Build(dr));
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dr != null)
{
dr.Close();
}
}
return(default(T));
}
