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