public virtual IDataReader GetDataReader(KeyValuePair <string, object> parameter, int topLimit = 0, string order = null)
{
List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> > {
parameter
};
return(DbCommonLibary.GetDataReader(this.DBProvider, this.CurrentTableName, parameters, topLimit, order));
}
public virtual IDataReader GetDataReaderByParent(string parentId)
{
List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> > {
new KeyValuePair <string, object>(BusinessLogic.FieldParentId, parentId)
};
return(DbCommonLibary.GetDataReader(this.DBProvider, this.CurrentTableName, parameters, 0, BusinessLogic.FieldSortCode));
}
public virtual IDataReader GetDataReader(KeyValuePair <string, object> parameter1, KeyValuePair <string, object> parameter2, string order)
{
List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> > {
parameter1,
parameter2
};
return(DbCommonLibary.GetDataReader(this.DBProvider, this.CurrentTableName, parameters, 0, order));
}
public virtual List <T> GetList <T>(List <KeyValuePair <string, object> > parameters, string order) where T : BaseEntity, new()
{
List <T> list = new List <T>();
using (IDataReader dr = DbCommonLibary.GetDataReader(DBProvider, this.CurrentTableName, parameters, 0, order))
{
list = GetList <T>(dr);
}
return(list);
}
public virtual List <T> GetList <T>(string name, Object[] values, string order = null) where T : BaseEntity, new()
{
List <T> list = new List <T>();
using (IDataReader dr = DbCommonLibary.GetDataReader(DBProvider, this.CurrentTableName, name, values, order))
{
list = GetList <T>(dr);
}
return(list);
}
public virtual List <T> GetList <T>(string[] ids) where T : BaseEntity, new()
{
List <T> list = new List <T>();
using (IDataReader dr = DbCommonLibary.GetDataReader(DBProvider, this.CurrentTableName, BusinessLogic.FieldId, ids))
{
list = GetList <T>(dr);
}
return(list);
}
public virtual List <T> GetList <T>(int topLimit = 0, string order = null) where T : BaseEntity, new()
{
List <T> list = new List <T>();
using (IDataReader dr = DbCommonLibary.GetDataReader(DBProvider, this.CurrentTableName, null, topLimit, order))
{
list = GetList <T>(dr);
}
return(list);
}
public virtual IDataReader GetDataReader(string name, object[] values, string order = null)
{
return(DbCommonLibary.GetDataReader(this.DBProvider, this.CurrentTableName, name, values, order));
}
public virtual IDataReader GetDataReader(int topLimit = 0, string order = null)
{
return(DbCommonLibary.GetDataReader(this.DBProvider, this.CurrentTableName, null, topLimit, order));
}
public virtual IDataReader GetDataReader(string[] ids)
{
return(DbCommonLibary.GetDataReader(this.DBProvider, this.CurrentTableName, BusinessLogic.FieldId, ids, null));
}
public virtual IDataReader GetDataReader(params KeyValuePair <string, object>[] parameters)
{
List <KeyValuePair <string, object> > list = parameters.ToList();
return(DbCommonLibary.GetDataReader(this.DBProvider, this.CurrentTableName, list, 0, null));
}
