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); }