private ImportColumnMapping LoadImportColumnMapping(XmlNode node, Import import)
{
ImportColumnMapping column = new ImportColumnMapping(import);
foreach (XmlAttribute xa in node.Attributes)
{
switch (xa.Name)
{
case "col":
column.ColumnName = xa.Value.Trim();
break;
case "prop":
column.PropertyName = xa.Value.Trim();
break;
case "inherit":
column.Inherit = xa.Value.Trim().SafeToBool();
break;
case "from":
column.Direction = "left".Equals(xa.Value.Trim(), StringComparison.OrdinalIgnoreCase) ? InheritDirection.Left : InheritDirection.Up;
break;
default:
break;
}
}
return(column);
}
private Import LoadImport(XmlNode node)
{
Import import = new Import();
foreach (XmlAttribute xa in node.Attributes)
{
switch (xa.Name)
{
case "id":
import.Id = xa.Value.Trim();
break;
case "sheet":
import.Sheet = xa.Value.Trim();
break;
case "firstRowIndex":
import.FirstRowIndex = xa.Value.Trim().SafeToInt() - 1;
import.FirstRowIndex = import.FirstRowIndex < 0 ? 0 : import.FirstRowIndex;
break;
case "xlsFormat":
import.XlsFormat = ConvertXlsFormat(xa.Value);
break;
case "columnMapType":
import.ColumnMapType = ("dataheader".EqualsIgnoreCase(xa.Value) ? ColumnMapType.DataHeader : ColumnMapType.ExcelHeader);
break;
default:
break;
}
}
foreach (XmlNode xn in node.ChildNodes)
{
if ("#comment" == xn.Name)
{
continue;
}
ImportColumnMapping imcolumn = LoadImportColumnMapping(xn, import);
import.Add(imcolumn.ColumnName, imcolumn);
}
return(import);
}
