/// <summary>
/// Load data list
/// </summary>
/// <typeparam name="T">Entity</typeparam>
/// <param name="by">Sql,All,Top,Page,Between</param>
/// <returns></returns>
public List <T> List <T>(By by) where T : new()
{
#region BySql
if (by is BySql)
{
var bySql = by as BySql;
var trans = bySql.Tran;
var cmdText = bySql.CmdText;
var cmdType = bySql.CmdType;
var cmdParms = bySql.CmdParms;
var list = new List <T>();
Type type = typeof(T);
var typeName = type.FullName;
Dictionary <string, string> infos = null;
if (IntrospectionManager.IsExistsColumnName(typeName))
{
infos = IntrospectionManager.GetColumns(typeName);
}
else
{
infos = new Dictionary <string, string>();
var fields = type.GetProperties(BindingFlags.Public | BindingFlags.Instance | BindingFlags.SetProperty | BindingFlags.GetProperty);
foreach (var fieldInfo in fields)
{
infos.Add(fieldInfo.Name, fieldInfo.Name);
}
IntrospectionManager.SetColumns(typeName, infos);
IntrospectionManager.SetDelegate(type);
}
DbDataReader dr = null;
if (trans == null)
{
dr = NativeSql.ExecuteReader(cmdText, cmdType, cmdParms);
}
else
{
dr = NativeSql.ExecuteReader(trans, cmdText, cmdType, cmdParms);
}
while (dr.Read())
{
T entity = new T();
foreach (var propertyName in infos.Keys)
{
var fieldName = infos[propertyName];
if (dr.GetSchemaTable().Select("columnname='" + fieldName + "'").Length > 0)
{
object columnValue = dr[fieldName];
if (columnValue is System.DBNull)
{
columnValue = null;
}
IntrospectionManager.GetSetDelegate(typeName)(entity, propertyName, columnValue);
}
/* object columnValue = dr[fieldName];
* if (columnValue is DBNull)
* {
* columnValue = null;
* }
* IntrospectionManager.GetSetDelegate(typeName)(entity, propertyName, columnValue);*/
}
list.Add(entity);
}
dr.Close();
dr.Dispose();
return(list);
}
#endregion
#region ByAll
else if (by is ByAll)
{
var byAll = by as ByAll;
var asc = byAll.Asc;
var trans = byAll.Trans;
string _left = ProviderManager.GetProvider(ProviderName).GetLeftEscape();
string _right = ProviderManager.GetProvider(ProviderName).GetRightEscape();
string sql;
var typeName = typeof(T).FullName;
var tableName = IntrospectionManager.GetTableName(typeName);
var pk = IntrospectionManager.GetPrimaryColumnName(typeName);
if (asc)
{
sql = string.Format("select * from {0}", _left + tableName + _right);
}
else
{
sql = string.Format("select * from {0} order by {1} desc", _left + tableName + _right, _left + pk + _right);
}
return(List <T>(By.Sql(sql, trans)));
}
#endregion
#region ByTop
else if (by is ByTop)
{
var byTop = by as ByTop;
var top = byTop.Top;
var asc = byTop.Asc;
var trans = byTop.Trans;
var typeName = typeof(T).FullName;
var pk = IntrospectionManager.GetPrimaryColumnName(typeName);
var tableName = IntrospectionManager.GetTableName(typeName);
string sql = ProviderManager.GetProvider(ProviderName).GetTopSql(top, asc, tableName, pk);
return(List <T>(By.Sql(sql, trans)));
}
#endregion
#region ByPage
else if (by is ByPage)
{
var byPage = by as ByPage;
var page = byPage.Page;
var pageSize = byPage.PageSize;
var asc = byPage.Asc;
var trans = byPage.Trans;
var typeName = typeof(T).FullName;
var pk = IntrospectionManager.GetPrimaryColumnName(typeName);
var tableName = IntrospectionManager.GetTableName(typeName);
string sql = ProviderManager.GetProvider(ProviderName).GetPageSql(page, pageSize, asc, tableName, pk);
return(List <T>(By.Sql(sql, trans)));
}
#endregion
#region ByBetween
else if (by is ByBetween)
{
var byBetween = by as ByBetween;
var from = byBetween.From;
var to = byBetween.To;
var asc = byBetween.Asc;
var trans = byBetween.Trans;
string _left = ProviderManager.GetProvider(ProviderName).GetLeftEscape();
string _right = ProviderManager.GetProvider(ProviderName).GetRightEscape();
var typeName = typeof(T).FullName;
var pk = IntrospectionManager.GetPrimaryColumnName(typeName);
var tableName = IntrospectionManager.GetTableName(typeName);
string sql;
if (asc)
{
sql = string.Format("select * from {0} where {1} between {2} and {3}", _left + tableName + _right,
_left + pk + _right, from, to);
}
else
{
sql = string.Format("select * from {0} where {1} between {2} and {3} order by {1}", _left + tableName + _right,
_left + pk + _right, from, to);
}
return(List <T>(By.Sql(sql, trans)));
}
#endregion
else
{
throw new NotSupportThisByException(by == null ? "null" : by.ToString());
}
}