public static List <T> GetList <T>(QueryInfo <T> model) { var getModel = model.GetModel; var list = new List <T>(); using (var db = new DbBuilder(model.Config)) { var reader = db.GetDataReader(model.SqlString, model.Parameters); if (getModel != null) { while (reader.Read()) { list.Add(getModel(reader)); } } else { var builder = EntityBuilder <T> .CreateBuilder(reader); while (reader.Read()) { list.Add(builder.Build(reader)); } } } return(list); }
public static List <T> GetList <T>(PageInfo <T> model) { if (string.IsNullOrWhiteSpace(model.StrSelect)) { model.StrSelect = "*"; } if (model.Config == null) { throw new Exception("Config不能为空!"); } if (string.IsNullOrWhiteSpace(model.StrFrom)) { throw new Exception("StrFrom不能为空!"); } if (string.IsNullOrWhiteSpace(model.StrOrder)) { throw new Exception("StrOrder不能为空!"); } var getModel = model.GetModel; var list = new List <T>(); using (var db = new DbBuilder(model.Config)) { string sql = "select count(1) as tcount from (" + model.StrFrom + ") where 1=1 " + model.StrWhere; var recordCount = (int)new DbBuilder(model.Config).GetSingle(sql, model.Parameters); sql = SqlHelper.GetSqlString(model.StrFrom, model.PageSize, model.PageIndex, recordCount, "*", model.StrWhere, model.StrOrder, model.Config); var reader = db.GetDataReader(sql, model.Parameters); if (getModel != null) { while (reader.Read()) { list.Add(getModel(reader)); } } else { var builder = EntityBuilder <T> .CreateBuilder(reader); while (reader.Read()) { list.Add(builder.Build(reader)); } } } return(list); }