/// <summary>
/// 获取列映射数组
/// </summary>
/// <param name="columnMappingString"></param>
/// <returns></returns>
public static DataColumnMapping[] GetColumnMappings(string columnMappingString)
{
DataColumnMapping[] columns;
Regex regex = new Regex("\\s*([^:]+):([^;]*);*\\s*");
MatchCollection mcs = regex.Matches(columnMappingString);
columns = new DataColumnMapping[mcs.Count];
int i = 0;
foreach (Match m in mcs)
{
columns[i++] = new DataColumnMapping(m.Groups[1].Value, m.Groups[2].Value);
}
return columns;
}
public virtual IDictionary <string, string> GetExportFieldAndName(String[] exportFields)
{
if (this._columnNames == null || this._columnNames.Length == 0)
{
return(null);
}
IDictionary <string, string> dictionary = new Dictionary <string, string>();
foreach (string columnField in exportFields)
{
DataColumnMapping map = this._columnNames.SingleOrDefault(
a => String.Compare(a.Field, columnField, true,
CultureInfo.InvariantCulture) == 0);
if (map.Field != null)
{
dictionary.Add(map.Field, map.Name);
}
}
return(dictionary);
}
public ExportItem(string queryName, DataColumnMapping[] columns):base(columns)
{
this.PortalKey = queryName;
}
public static bool ReadExportConfigFormXml(
string xml,
string xpath,
out DataColumnMapping[] columns)
{
XmlDocument xd = new XmlDocument();
xd.LoadXml(xml);
if (String.IsNullOrEmpty(xpath))
{
xpath = "/item";
}
XmlNode rootNode = xd.SelectSingleNode(xpath);
XmlNode node;
if (rootNode == null)
{
throw new ArgumentNullException("xpath");
}
#region 获取列配置
node = rootNode.SelectSingleNode("column");
if (node == null)
{
columns = null;
}
else
{
string columnMappingString = node.Attributes["mapping"].Value;
columns = GetColumnMappings(columnMappingString);
}
#endregion
return true;
}
/// <summary>
/// 从文件中读取导出配置
/// </summary>
/// <param name="filePath"></param>
/// <param name="columns"></param>
/// <param name="queryName"></param>
/// <returns></returns>
public static bool ReadExportConfigFormFile(
string filePath,
out DataColumnMapping[] columns)
{
return ReadExportConfigFormXml(
System.IO.File.ReadAllText(filePath),
null,
out columns);
}
protected BaseDataExportPortal(DataColumnMapping[] columnNames)
{
this._columnNames = columnNames;
}
