/// <summary>
/// 根据条件获取列表，不支持分表数据的查询
/// </summary>
/// <param name="sql"></param>
/// <param name="type">返回对象类型</param>
/// <returns></returns>
public List <object> GetList(string where, string order, Type type, params object[] paras)
{
DBTable table = MapHelper.GetDBTable(type);
string sql = string.Format("select * from {0} {1} {2}",
table.Name,
string.IsNullOrEmpty(where) ? "" : "where " + FormatWhereOrder(table, where),
string.IsNullOrEmpty(order) ? "" : string.Format(" order by {0}", order));
Command.CommandText = sql;
Command.CommandType = CommandType.Text;
Command.Parameters.Clear();
int i = 0;
foreach (object obj in paras)
{
AddParameter(FormatParameterName("p" + (i++).ToString()), ParameterDirection.Input, obj);
}
using (IDataReader reader = Command.ExecuteReader())
{
return(FullDataReader.CreateDegFullMapList(reader, type)(reader));
}
}
/// <summary>
/// 根据SQL语句查询列表，不支持分表数据的查询
/// </summary>
/// <param name="sql"></param>
/// <param name="type">返回对象类型</param>
/// <returns></returns>
public List <object> GetListBySQL(string sql, Type type, params object[] paras)
{
DBTable table = MapHelper.GetDBTableExist(type);
if (table != null)
{
Command.CommandText = FormatWhereOrder(table, sql);
Command.CommandType = CommandType.Text;
Command.Parameters.Clear();
int i = 0;
foreach (object obj in paras)
{
AddParameter(FormatParameterName("p" + (i++).ToString()), ParameterDirection.Input, obj);
}
using (IDataReader reader = Command.ExecuteReader())
{
return(FullDataReader.CreateDegFullMapList(reader, type)(reader));
}
}
else
{
return(GetCustomerList(sql, type, paras));
}
}
