private void InitData()
{
List <AttributesUtils.EnumItem> listFieldType = AttributesUtils.GetEnumList <Common.BaseEnum.Enumeration.FieldTypes>();
ExcelFieldType.DataSource = listFieldType;
ExcelFieldType.DataTextField = "Value";
ExcelFieldType.DataValueField = "Key";
ExcelFieldType.DataBind();
SQLFieldType.DataSource = listFieldType;
SQLFieldType.DataTextField = "Value";
SQLFieldType.DataValueField = "Key";
SQLFieldType.DataBind();
}
private void ProcessFiels(string fileExcel, IList <string> fielsXml)
{
using (var excel = new ExcelQueryFactory(fileExcel)) {
var header = (from c in excel.WorksheetNoHeader(0)
select c).FirstOrDefault();
var data = (from c in excel.Worksheet(0)
select c).ToList();
foreach (var item in data)
{
if (fielsXml.Any(x => x == item[0]))
{
List <ExcelField> list = new List <ExcelField>();
for (int i = StartColumnData; i < item.Count; i++)
{
if (!string.IsNullOrWhiteSpace(header[i]))
{
var field = new ExcelField
{
Name = item[0],
Value = item[i]
};
//Valida el tipo
ExcelFieldType tipo = ExcelFieldType.None;
Enum.TryParse(item[1]?.Value?.ToString()?.Replace(":", ""), true, out tipo);
field.Type = tipo;
list.Add(field);
}
}
Fields.Add(item[0], list);
CountFiles = list.Count;
}
}
}
}
