/// <summary> /// 获取自定义对象列表,自己给定SQL语句 /// 通过字段名称与属性名称匹配来进行填充(不区分大小写) /// </summary> /// <param name="sql">sql语句,其中参数以?代替</param> /// <param name="paras">传入的参数</param> /// <returns>List</returns> public object GetDynamicList(string sql, params object[] paras) { Command.CommandType = CommandType.Text; Command.CommandText = PrepareCustomSelect(sql, paras); using (IDataReader reader = Command.ExecuteReader()) { return(FullDataReader.CreateDegFullDynamicList(reader)(reader)); } }
/// <summary> /// 获取自定义对象列表,自己给定SQL语句 /// 通过字段名称与属性名称匹配来进行填充(不区分大小写) /// </summary> /// <param name="pageIndex">分页索引,以1开始</param> /// <param name="pageSize">分页大小</param> /// <param name="fields">字段列表,以“,”分隔</param> /// <param name="from">表名称,比如t_a left join t_b on t_a.id=t_b.id</param> /// <param name="where">Where 条件,参数用?代替</param> /// <param name="group">Group by 子句</param> /// <param name="order">排序方式,不包含"order by"</param> /// <param name="paras">条件参数</param> /// <returns>List</returns> public object GetDynamicPagingList( int pageIndex, int pageSize, string fields, string from, string where, string group, string order, params object[] paras) { Command.CommandType = CommandType.Text; Command.CommandText = PrepareCustomSelectPaging(pageIndex, pageSize, fields, from, where, group, order, paras); using (IDataReader reader = Command.ExecuteReader()) { return(FullDataReader.CreateDegFullDynamicList(reader)(reader)); } }