public List <T> Select <T>(string sql, List <CommandParameter> parameterList) where T : class
{
DataSet ds = ExecuteDataSet(sql, parameterList, new string[] { "Table" });
List <T> dataList = RelationalMappingUnity.Select <T>(ds.Tables[0]);
return(dataList);
}
public List <T> Select <T>(List <AttachedWhereItem> attachedWhere, SqlExpressionPagingArgs pagingArgs) where T : class, new()
{
SqlExpressionArgs args = new SqlExpressionArgs();
args.Type = SqlExpressionType.Select;
args.GenerateWhere = false;
args.AttachedWhere = attachedWhere;
args.PagingArgs = pagingArgs;
//不能用 default(T) ，会是null
SqlExpression sqlExpression = RelationalMappingUnity.GetSqlExpression(new T(), args);
DataSet ds = ExcuteDataSetSqlExpression(sqlExpression);
List <T> dataList = RelationalMappingUnity.Select <T>(ds.Tables[0]);
if (pagingArgs != null)
{
if (ds.Tables.Count > 1)
{
pagingArgs.TotalRow = int.Parse(ds.Tables[1].Rows[0][0].ToString());
}
else
{
pagingArgs.TotalRow = ds.Tables[0].Rows.Count;
}
pagingArgs.TotalPage = pagingArgs.TotalRow / pagingArgs.PageSize;
if (pagingArgs.TotalRow % pagingArgs.PageSize > 0)
{
pagingArgs.TotalPage++;
}
}
return(dataList);
}
public List <T> Select <T>(string sql) where T : class
{
DataSet ds = ExecuteDataSet(sql);
List <T> dataList = RelationalMappingUnity.Select <T>(ds.Tables[0]);
return(dataList);
}
public bool Fill <T>(object obj, string table, Dictionary <string, object> attachedWhere) where T : class, new()
{
SqlExpressionArgs args = new SqlExpressionArgs();
args.Table = table;
args.Type = SqlExpressionType.Select;
if (attachedWhere == null)
{
args.GenerateWhere = true;
}
else
{
args.GenerateWhere = false;
args.AttachedWhere = AttachedWhereItem.Parse(attachedWhere);
}
//不能用 default(T) ，会是null
SqlExpression sqlExpression = RelationalMappingUnity.GetSqlExpression(obj, args);
DataSet ds = ExcuteDataSetSqlExpression(sqlExpression);
List <T> dataList = RelationalMappingUnity.Select <T>(ds.Tables[0]);
Debug.Assert(dataList.Count <= 1, "Fill 时取出的记录大于1条");
if (dataList.Count != 1)
{
return(false);
}
T dataObj = dataList[0];
ReflectionHelper.Inject(obj, dataObj);
return(true);
}
