public static IList <T> Paging(string connectionString, out int recordCount, string tableName, string fields, string sortfield, int start, int end, string orderType, string whereSQL, ToEntityCallback callback)
{
IList <T> list = null;
recordCount = DBH.Count(connectionString, tableName, whereSQL);
using (IDataReader dr = DBH.Paging(connectionString, tableName, fields, sortfield, start, end, orderType, whereSQL))
{
if (dr != null)
{
list = new List <T>();
while (dr.Read())
{
list.Add(callback(dr));
}
dr.Close();
}
}
return(list);
}
/// <summary>
/// 根据查询条件获取指定类型的对象，需要传递Entity Build Callback
/// </summary>
/// <param name="connectionString">连接串</param>
/// <param name="commandType"></param>
/// <param name="commandText"></param>
/// <param name="callback">Entity Build方法</param>
/// <param name="commandParameters"></param>
/// <returns></returns>
public static T Get(string connectionString, CommandType commandType, string commandText, ToEntityCallback callback, params SqlParameter[] commandParameters)
{
T t = null;
using (IDataReader dr = DBH.ExecuteReader(connectionString, commandType, commandText, commandParameters))
{
if (dr != null)
{
if (dr.Read())
{
t = callback(dr);
}
dr.Close();
}
}
return(t);
}
public static IList <T> List(string connectionString, CommandType commandType, string commandText, ToEntityCallback callback, params SqlParameter[] commandParameters)
{
IList <T> tList = null;
using (IDataReader dr = DBH.ExecuteReader(connectionString, commandType, commandText, commandParameters))
{
if (dr != null)
{
try
{
tList = new List <T>();
while (dr.Read())
{
T t = callback(dr);
tList.Add(t);
}
}
catch { }
finally { dr.Close(); }
}
}
return(tList);
}
