public virtual IDataReader ExecuteReader(KeyValuePair <string, object> parameter, string order)
{
List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >();
parameters.Add(parameter);
return(DbLogic.ExecuteReader(DbHelper, this.CurrentTableName, parameters, 0, order));
}
/// <summary>
/// 按父亲节点获取数据
/// </summary>
/// <param name="parentId">父节点主键</param>
/// <returns>数据表</returns>
public virtual IDataReader ExecuteReaderByParent(string parentId)
{
List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >();
parameters.Add(new KeyValuePair <string, object>(BaseBusinessLogic.FieldParentId, parentId));
return(DbLogic.ExecuteReader(DbHelper, this.CurrentTableName, parameters, 0, BaseBusinessLogic.FieldSortCode));
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="categoryId">类别主键</param>
/// <returns>数据表</returns>
public virtual IDataReader ExecuteReaderByCategory(string categoryCode)
{
List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >();
parameters.Add(new KeyValuePair <string, object>(BaseBusinessLogic.FieldCategoryCode, categoryCode));
return(DbLogic.ExecuteReader(DbHelper, this.CurrentTableName, parameters));
}
public virtual IDataReader ExecuteReader(params KeyValuePair <string, object>[] parameters)
{
List <KeyValuePair <string, object> > parametersList = new List <KeyValuePair <string, object> >();
for (int i = 0; i < parameters.Length; i++)
{
parametersList.Add(parameters[i]);
}
return(DbLogic.ExecuteReader(DbHelper, this.CurrentTableName, parametersList));
}
public virtual List<T> GetList<T>(string name, Object[] values, string order = null) where T : BaseEntity, new()
{
List<T> result = new List<T>();
using (IDataReader dr = DbLogic.ExecuteReader(DbHelper, this.CurrentTableName, "*", name, values, order))
{
result = GetList<T>(dr);
}
return result;
}
public virtual List<T> GetList<T>(string[] ids) where T : BaseEntity, new()
{
List<T> result = new List<T>();
using (IDataReader dr = DbLogic.ExecuteReader(DbHelper, this.CurrentTableName, "*", BaseBusinessLogic.FieldId, ids))
{
result = GetList<T>(dr);
}
return result;
}
public virtual List<T> GetList<T>(int topLimit = 0, string order = null) where T : BaseEntity, new()
{
List<T> result = new List<T>();
using (IDataReader dr = DbLogic.ExecuteReader(DbHelper, this.CurrentTableName, null, topLimit, order))
{
result = GetList<T>(dr);
}
return result;
}
public virtual List<T> GetList<T>(List<KeyValuePair<string, object>> parameters, int topLimit = 0, string order = null) where T : BaseEntity, new()
{
List<T> result = new List<T>();
using (IDataReader dr = DbLogic.ExecuteReader(DbHelper, this.CurrentTableName, parameters, topLimit, order))
{
result = GetList<T>(dr);
}
return result;
}
public virtual List<T> GetList<T>(KeyValuePair<string, object> parameter, string order) where T : BaseEntity, new()
{
List<T> result = new List<T>();
List<KeyValuePair<string, object>> parameters = new List<KeyValuePair<string, object>>();
parameters.Add(parameter);
using (IDataReader dr = DbLogic.ExecuteReader(DbHelper, this.CurrentTableName, parameters, 0, order))
{
result = GetList<T>(dr);
}
return result;
}
public virtual List<T> GetList<T>(params KeyValuePair<string, object>[] parameters) where T : BaseEntity, new()
{
List<T> result = new List<T>();
List<KeyValuePair<string, object>> parametersList = new List<KeyValuePair<string, object>>();
for (int i = 0; i < parameters.Length; i++)
{
parametersList.Add(parameters[i]);
}
using (IDataReader dr = DbLogic.ExecuteReader(DbHelper, this.CurrentTableName, parametersList))
{
result = GetList<T>(dr);
}
return result;
}
public virtual IDataReader ExecuteReader(string name, Object[] values, string order = null)
{
return(DbLogic.ExecuteReader(DbHelper, this.CurrentTableName, name, values, order));
}
public virtual IDataReader ExecuteReader(string[] ids)
{
return(DbLogic.ExecuteReader(DbHelper, this.CurrentTableName, BaseBusinessLogic.FieldId, ids));
}
//
// 读取多条记录
//
public virtual IDataReader ExecuteReader(int topLimit = 0, string order = null)
{
return(DbLogic.ExecuteReader(DbHelper, this.CurrentTableName, null, string.Empty, topLimit, order, this.SelectFields));
}
//
// 获取一些列表的常用方法
//
public virtual IDataReader ExecuteReaderByWhere(string where = null, List <KeyValuePair <string, object> > parameters = null, int topLimit = 0, string order = null)
{
return(DbLogic.ExecuteReader(DbHelper, this.CurrentTableName, parameters, where, topLimit, order, "*"));
}
