private static bool CheckTable(IRow ColumnsNameRow, Dictionary <string, SqlMapModel> ColumnsMap, out DataTable datatable, out Dictionary <string, Type> dic)
{
dic = new Dictionary <string, Type>();
datatable = new DataTable();
Regex regx = new Regex("\\s");
bool flag = false;
bool result;
if (!DataExcelInOfNPOI.xlstop(ColumnsNameRow))
{
result = false;
}
else if ((int)ColumnsNameRow.LastCellNum == ColumnsMap.Count)
{
for (int i = 0; i < (int)ColumnsNameRow.LastCellNum; i++)
{
ICell icell = ColumnsNameRow.GetCell(i);
string tValue = regx.Replace(icell.ToString(), "");
if (Regex.IsMatch(tValue, "^\\*"))
{
tValue = tValue.Remove(0, 1);
}
if (!ColumnsMap.ContainsKey(tValue))
{
dic = new Dictionary <string, Type>();
datatable = new DataTable();
result = false;
return(result);
}
if (!flag)
{
flag = true;
}
SqlMapModel SqlColumn = ColumnsMap[tValue];
datatable.Columns.Add(SqlColumn.SqlColumnName, typeof(string));
dic.Add(SqlColumn.SqlColumnName, SqlColumn.SqlDataType);
}
result = true;
}
else
{
result = false;
}
return(result);
}
private static bool CheckTable(IRow ColumnsNameRow, Dictionary <string, SqlMapModel> ColumnsMap, out DataTable datatable, out Dictionary <string, Type> dic, ref string err)
{
dic = new Dictionary <string, Type>();
datatable = new DataTable();
Regex regx = new Regex("\\s");
bool flag = false;
err = "";
bool result;
if (!DataExcelInOfNPOI.xlstop(ColumnsNameRow))
{
result = false;
}
else if ((int)ColumnsNameRow.LastCellNum == ColumnsMap.Count)
{
for (int i = 0; i < (int)ColumnsNameRow.LastCellNum; i++)
{
ICell icell = ColumnsNameRow.GetCell(i);
string tValue = regx.Replace(icell.ToString(), "");
if (Regex.IsMatch(tValue, "^\\*"))
{
tValue = tValue.Remove(0, 1);
}
if (!ColumnsMap.ContainsKey(tValue))
{
err = "系统发现异常列名(" + tValue + ")";
dic = new Dictionary <string, Type>();
datatable = new DataTable();
result = false;
return(result);
}
if (!flag)
{
flag = true;
}
SqlMapModel SqlColumn = ColumnsMap[tValue];
datatable.Columns.Add(SqlColumn.SqlColumnName, typeof(string));
dic.Add(SqlColumn.SqlColumnName, SqlColumn.SqlDataType);
}
result = true;
}
else
{
StringBuilder Sb = new StringBuilder();
if ((int)ColumnsNameRow.LastCellNum > ColumnsMap.Count)
{
Sb.AppendFormat("您选择的文件的列{0},多出系统要求({1}){2}列，参考列{3}", new object[]
{
ColumnsNameRow.LastCellNum,
ColumnsMap.Count,
(int)ColumnsNameRow.LastCellNum - ColumnsMap.Count,
"{"
});
for (int i = 0; i < (int)ColumnsNameRow.LastCellNum; i++)
{
ICell icell = ColumnsNameRow.GetCell(i);
string tValue = regx.Replace(icell.ToString(), "");
if (Regex.IsMatch(tValue, "^\\*"))
{
tValue = tValue.Remove(0, 1);
}
if (!ColumnsMap.ContainsKey(tValue))
{
Sb.AppendFormat("{0},", icell.ToString());
}
}
err = string.Format("{0}{1};", Sb.ToString().Trim(new char[]
{
','
}), "}");
}
else
{
Sb.AppendFormat("您选择的文件的({0}列),有{2}列系统要求({1})的列未提供，参考列{3}", new object[]
{
ColumnsNameRow.LastCellNum,
ColumnsMap.Count,
Math.Abs((int)ColumnsNameRow.LastCellNum - ColumnsMap.Count),
"{"
});
for (int i = 0; i < (int)ColumnsNameRow.LastCellNum; i++)
{
ICell icell = ColumnsNameRow.GetCell(i);
string tValue = regx.Replace(icell.ToString(), "");
if (Regex.IsMatch(tValue, "^\\*"))
{
tValue = tValue.Remove(0, 1);
}
if (ColumnsMap.ContainsKey(tValue))
{
ColumnsMap.Remove(tValue);
}
foreach (string j in ColumnsMap.Keys)
{
Sb.AppendFormat("{0},", j);
}
}
err = string.Format("{0}{1};", Sb.ToString().Trim(new char[]
{
','
}), "}");
}
result = false;
}
return(result);
}
