string fileUrl = FileHandler.GetDirectoryMappingDetails(FileHandler.DirectoryMappingType.Temp).WritePath + fileName;
List<Words> wordsList = new List<Words>();
int emptyNum = 0;//空行数据
bool valibool = true;//是否验证通过
ExcelHelper excelHelper = new ExcelHelper(fileUrl);
DataTable dt = excelHelper.LoadDataFromExcel(fileUrl);
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i][0].ToString() == "Word" || dt.Rows[i][0] == DBNull.Value || dt.Rows[i][0].ToString() == "Category")
{
continue;
}
Words words = new Words();
words.EnterTime = DateTime.Now;
words.SysStatus = 1;
words.ProvideType = param.ProvideType;
//判断第一行第一个是否为 指定类型
if (dt.Rows[0][0].ToString() == "Category")
{
if (dt.Rows[i] != null)
{
words.Category = dt.Rows[i][0].ToString();
words.Word = dt.Rows[i][1].ToString();
}
else
{
valibool = false;
}
}
else
{
if (dt.Rows[i] != null)
{
words.Category = dt.Rows[i][1].ToString();
words.Word = dt.Rows[i][0].ToString();
}
else
{
valibool = false;
}
}
if (string.IsNullOrEmpty(words.EnterTime.ToString()))
{
continue;
}
if (emptyNum == dt.Rows.Count)
{
}
else
{
if (!valibool)
{
result.ImportMsg += "第" + (i + 1) + "行,缺少词;<br/>";
}
else
{
//当前excel表去重复
Words excWords = wordsList.Where(a => a.Word == words.Word && a.ProvideType == words.ProvideType && a.Category == words.Category).FirstOrDefault();
//数据库表去重复
Words chkWords = conditionResult.Where(a => a.Word == words.Word && a.ProvideType == words.ProvideType && a.Category == words.Category).FirstOrDefault();
if (excWords == null && chkWords == null)
{
wordsList.Add(words);
emptyNum++;
}
}
}
List<Words> wordsList = new List<Words>();
int emptyNum = 0;//空行数据
bool valibool = true;//是否验证通过
ExcelHelper excelHelper = new ExcelHelper(fileUrl);
DataTable dt = excelHelper.LoadDataFromExcel(fileUrl);
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i][0].ToString() == "Word" || dt.Rows[i][0] == DBNull.Value || dt.Rows[i][0].ToString() == "Category")
{
continue;
}
Words words = new Words();
words.EnterTime = DateTime.Now;
words.SysStatus = 1;
words.ProvideType = param.ProvideType;
//判断第一行第一个是否为 指定类型
if (dt.Rows[0][0].ToString() == "Category")
{
if (dt.Rows[i] != null)
{
words.Category = dt.Rows[i][0].ToString();
words.Word = dt.Rows[i][1].ToString();
}
else
{
valibool = false;
}
}
else
{
if (dt.Rows[i] != null)
{
words.Category = dt.Rows[i][1].ToString();
words.Word = dt.Rows[i][0].ToString();
}
else
{
valibool = false;
}
}
if (string.IsNullOrEmpty(words.EnterTime.ToString()))
{
continue;
}
if (emptyNum == dt.Rows.Count)
{
}
else
{
if (!valibool)
{
result.ImportMsg += "第" + (i + 1) + "行,缺少词;<br/>";
}
else
{
//当前excel表去重复
Words excWords = wordsList.Where(a => a.Word == words.Word && a.ProvideType == words.ProvideType && a.Category == words.Category).FirstOrDefault();
//数据库表去重复
Words chkWords = conditionResult.Where(a => a.Word == words.Word && a.ProvideType == words.ProvideType && a.Category == words.Category).FirstOrDefault();
if (excWords == null && chkWords == null)
{
wordsList.Add(words);
emptyNum++;
}
}
}