public ExcelQueryable(ExcelQueryArgs args)
: base(CreateExecutor(args))
{
foreach (var property in typeof(T).GetProperties())
{
ExcelColumnAttribute att
= (ExcelColumnAttribute)Attribute.GetCustomAttribute(property, typeof(ExcelColumnAttribute));
att.Register(args, property);
}
}
public ExcelQueryable(ExcelQueryArgs args)
: base(CreateExecutor(args))
{
foreach (var property in typeof(T).GetProperties())
{
ExcelColumnAttribute att = (ExcelColumnAttribute)Attribute.GetCustomAttribute(property, typeof(ExcelColumnAttribute));
if (att != null && !args.ColumnMappings.ContainsKey(property.Name))
{
args.ColumnMappings.Add(property.Name, att.ColumnName);
}
}
}
internal SqlGeneratorQueryModelVisitor(ExcelQueryArgs args)
{
_args = args;
SqlStatement = new SqlParts();
SqlStatement.Table = (String.IsNullOrEmpty(_args.StartRange)) ?
!String.IsNullOrEmpty(_args.NamedRangeName) && String.IsNullOrEmpty(_args.WorksheetName) ?
string.Format("[{0}]",
_args.NamedRangeName) :
string.Format("[{0}${1}]",
_args.WorksheetName, _args.NamedRangeName) :
string.Format("[{0}${1}:{2}]",
_args.WorksheetName, _args.StartRange, _args.EndRange);
if (!string.IsNullOrEmpty(_args.WorksheetName) && _args.WorksheetName.ToLower().EndsWith(".csv"))
{
SqlStatement.Table = SqlStatement.Table.Replace("$]", "]");
}
}
private static IQueryExecutor CreateExecutor(ExcelQueryArgs args)
{
return(new ExcelQueryExecutor(args));
}