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, "*")); }