/// <summary>
/// 读取Excel
/// </summary>
/// <param name="excelFileStream"></param>
public static void InsertExcelTagInfo(Stream excelFileStream)
{
//正常的流程是先插入再删除，现在暂时不这样考虑
MongoDbRepository.DeleteAllRecPhysical(Tag.CollectionName);
IWorkbook workbook = new XSSFWorkbook(excelFileStream);
var sheet = workbook.GetSheetAt(0);
int CurrentRowIndex = 3;
//这里表示第一个可用格子的下标？？？
int StartColIndex = 3;
IRow row = sheet.GetRow(CurrentRowIndex);
while (row != null && !string.IsNullOrEmpty(row.GetCell(StartColIndex).StringCellValue))
{
Tag t = new Tag();
t.TagName = row.GetCell(StartColIndex).StringCellValue;
StartColIndex += 5;
t.Catalog = NpoiExtend.GetCellText(row.GetCell(StartColIndex));
StartColIndex += 5;
t.IsCaseSensitive = !string.IsNullOrEmpty(NpoiExtend.GetCellText(row.GetCell(StartColIndex)));
StartColIndex += 5;
t.BaseTagName = NpoiExtend.GetCellText(row.GetCell(StartColIndex));
StartColIndex += 5;
t.Comment = NpoiExtend.GetCellText(row.GetCell(StartColIndex));
StartColIndex += 5;
t.IsOnlyContain = !string.IsNullOrEmpty(NpoiExtend.GetCellText(row.GetCell(StartColIndex)));
MongoDbRepository.InsertRec(t);
CurrentRowIndex++;
StartColIndex = 3;
row = sheet.GetRow(CurrentRowIndex);
}
}
public static void Init()
{
var masterConnection = new SqliteConnection(Config.LocalSqliteConnectiongString);
masterConnection.Open();
using (var secondConnection = new SqliteConnection(Config.LocalSqliteConnectiongString))
{
secondConnection.Open();
var queryCommand = secondConnection.CreateCommand();
queryCommand.CommandText =
@"
SELECT *
FROM ZPOETRYCONTENTRECORD
";
//删除原始数据
MongoDbRepository.DeleteAllRecPhysical(nameof(PoetryContent));
using (var reader = queryCommand.ExecuteReader())
{
int sn = 1;
while (reader.Read())
{
var t = new PoetryContentRecord();
for (int i = 0; i < 8; i++)
{
var fieldName = reader.GetName(i);
Console.WriteLine(fieldName + ":" + reader.GetValue(i));
switch (fieldName)
{
case "ZNAME":
t.Name = reader.GetValue(i).ToString();
break;
case "ZCOMMENT":
t.Comment = reader.GetValue(i).ToString();
break;
case "ZCONTENT":
t.Content = reader.GetValue(i).ToString();
break;
case "ZORDER":
t.Order = int.Parse(reader.GetValue(i).ToString());
break;
default:
break;
}
}
MongoDbRepository.InsertRec(t, sn);
sn++;
}
}
}
masterConnection.Close();
}
public static void Init()
{
var masterConnection = new SqliteConnection(Config.LocalSqliteConnectiongString);
masterConnection.Open();
using (var secondConnection = new SqliteConnection(Config.LocalSqliteConnectiongString))
{
secondConnection.Open();
var queryCommand = secondConnection.CreateCommand();
queryCommand.CommandText =
@"
SELECT *
FROM ZPERSONAGERECORD
";
//删除原始数据
MongoDbRepository.DeleteAllRecPhysical(nameof(Personage));
using (var reader = queryCommand.ExecuteReader())
{
int sn = 1;
while (reader.Read())
{
var t = new PersonageRecord();
for (int i = 0; i < 15; i++)
{
var fieldName = reader.GetName(i);
Console.WriteLine(fieldName + ":" + reader.GetValue(i));
switch (fieldName)
{
case "ZNAME":
t.Name = reader.GetValue(i).ToString();
break;
case "ZDETAILDYNASTY":
t.DetailDynasty = reader.GetValue(i).ToString();
break;
case "ZDESCRIPTIONA":
t.Description = reader.GetValue(i).ToString();
break;
case "ZNATION":
t.Nation = reader.GetValue(i).ToString();
break;
case "ZALIAS":
t.Alias = reader.GetValue(i).ToString();
break;
case "ZIMAGENAME":
t.ImageName = reader.GetValue(i).ToString();
if (InitFile.ImageFileNameDict.ContainsKey(t.ImageName))
{
t.ImageName = InitFile.ImageFileNameDict[t.ImageName];
}
else
{
System.Console.WriteLine("缺失图片:" + t.ImageName);
}
break;
case "ZMAINWORK":
t.MainWork = reader.GetValue(i).ToString();
break;
default:
break;
}
}
MongoDbRepository.InsertRec(t, sn);
sn++;
}
}
}
masterConnection.Close();
}
public static void Init()
{
var masterConnection = new SqliteConnection(Config.LocalSqliteConnectiongString);
masterConnection.Open();
using (var secondConnection = new SqliteConnection(Config.LocalSqliteConnectiongString))
{
secondConnection.Open();
var queryCommand = secondConnection.CreateCommand();
queryCommand.CommandText =
@"
SELECT *
FROM ZPOETRYRECORD
";
//删除原始数据
MongoDbRepository.DeleteAllRecPhysical(nameof(Poetry));
using (var reader = queryCommand.ExecuteReader())
{
int sn = 1;
while (reader.Read())
{
var t = new PoetryRecord();
for (int i = 0; i < 8; i++)
{
var fieldName = reader.GetName(i);
Console.WriteLine(fieldName + ":" + reader.GetValue(i));
switch (fieldName)
{
case "ZNAME":
t.Name = reader.GetValue(i).ToString();
break;
case "ZDESCRIPTIONA":
t.Description = reader.GetValue(i).ToString();
break;
case "ZSPECIAL":
t.Special = reader.GetValue(i).ToString();
break;
case "ZAUTHOR":
t.Author = reader.GetValue(i).ToString();
break;
case "ZIMAGENAME":
t.ImageName = reader.GetValue(i).ToString();
if (InitFile.ImageFileNameDict.ContainsKey(t.ImageName))
{
t.ImageName = InitFile.ImageFileNameDict[t.ImageName];
}
else
{
System.Console.WriteLine("缺失图片:" + t.ImageName);
}
break;
default:
break;
}
}
MongoDbRepository.InsertRec(t, sn);
sn++;
}
}
}
masterConnection.Close();
}
