public DataTable FindTable <T>(T entity) { if (entity == null) { return(db.FindTable(DatabaseCommon.SelectSql(EntityAttribute.GetEntityTable <T>()))); } else { return(db.FindTable(DatabaseCommon.QueryWhereSQL <T>(entity).ToString())); } }
public DataTable FindTable <T>(T entity, Pagination pagination) { DataTable data; if (entity != null && pagination != null) { int total = pagination.records; if (pagination.sord == null) { pagination.sord = "asc"; } data = db.FindTable(DatabaseCommon.QueryWhereSQL <T>(entity).ToString(), pagination.sidx, pagination.sord.ToLower() == "asc" ? true : false, pagination.rows, pagination.page, out total); pagination.records = total; } else if (entity != null && pagination == null) { data = db.FindTable(DatabaseCommon.QueryWhereSQL <T>(entity).ToString()); } else { data = db.FindTable(DatabaseCommon.SelectSql(EntityAttribute.GetEntityTable <T>())); } return(data); }