/// <summary>
/// 动态可扩展集合对象 List<System.Dynamic.ExpandoObject>
/// 返回对象与列名一致,返回对象可动态扩展
/// </summary>
/// <param name="sql"></param>
/// <param name="paras"></param>
/// <returns></returns>
public object GetExpandoDynamicList(string sql, params object[] paras)
{
Command.CommandType = CommandType.Text;
Command.CommandText = PrepareCustomSelect(sql, paras);
using (IDataReader reader = Command.ExecuteReader())
{
return(FullDataReader.CreateDegExpandoDynamicFullList(reader)(reader));
}
}
public object GetExpandoDynamicPagingList(
int pageIndex,
int pageSize,
string before,
string fields,
string from,
string where,
string group,
string order,
params object[] paras)
{
Command.CommandType = CommandType.Text;
Command.CommandText = string.Format("{0} {1}", before, PrepareCustomSelectPaging(pageIndex, pageSize, fields, from, where, group, order, paras));
using (IDataReader reader = Command.ExecuteReader())
{
return(FullDataReader.CreateDegExpandoDynamicFullList(reader)(reader));
}
}
