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