private void ButtonOK_Click(object sender, EventArgs e)
{
tableName2SQLite = textBoxTableName.Text;
briefIntro = textBoxBriefIntroduction.Text;
string errMsg = "";
if (tableName2SQLite.Length < 2)
{
errMsg = "词典名字至少需要2个字符！";
}
else if (GetDictsInfo(FormMain.sqliteInstance).Contains(tableName2SQLite))
{
//tableName已经存在
errMsg = "您指定的词典名字已经存在，请重新指定名字。";
}
else if (string.IsNullOrEmpty(fileName))
{
errMsg = "您还没有指定词典文件，请指定。";
}
else if (briefIntro.Length < 10)
{
errMsg = "词典简介10个字符，请完善简介信息。";
}
DataTable wordsTable = ExcelNpoiUtility.ExcelToDataTableNpoi(fileName);
if (wordsTable == null)
{
errMsg = "读取EXCEL文件失败，请关闭文件后再次尝试。";
}
if (errMsg.Length > 0)
{
MessageBox.Show(errMsg, "词典错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
textBoxTableName.Focus();
return;
}
string sql2CreateTable = DictHelper.FormatCreateWordInfoSql(tableName2SQLite);
FormMain.sqliteInstance.WriteTable2Db(wordsTable, tableName2SQLite, sql2CreateTable);
DictInfo di = new DictInfo
{
DictName = tableName2SQLite,
WordCount = wordsTable.Rows.Count,
BriefIntro = briefIntro,
IsChecked = 1 //新加入的默认为勾选
};
List <DictInfo> diList = new List <DictInfo>
{
di
};
SetupDictsInfo(diList, DictOps.AddDict, FormMain.sqliteInstance);
DialogResult = DialogResult.OK;
Close();
}
private void ButtonOK_Click(object sender, EventArgs e)
{
tableName2SQLite = textBoxTableName.Text;
briefIntro = textBoxBriefIntroduction.Text;
string errMsg = "";
if (tableName2SQLite.Length < 2)
{
errMsg = "词典名字至少需要2个字符！";
}
else if (GetDictsInfo(FormMain.sqliteInstance).Contains(tableName2SQLite))
{
//tableName已经存在
errMsg = "您指定的词典名字已经存在，请重新指定名字。";
}
else if (string.IsNullOrEmpty(fileName))
{
errMsg = "您还没有指定词典文件，请指定。";
}
else if (briefIntro.Length < 10)
{
errMsg = "词典简介10个字符，请完善简介信息。";
}
if (errMsg.Length > 0)
{
MessageBox.Show(errMsg, "词典错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
textBoxTableName.Focus();
return;
}
DataTable dataTable = ExcelNpoiUtility.ExcelToDataTableNpoi(fileName);
FormMain.sqliteInstance.WriteTable2Db(dataTable, tableName2SQLite);
DictInfo di = new DictInfo();
di.DictName = tableName2SQLite;
di.WordCount = dataTable.Rows.Count;
di.BriefIntro = briefIntro;
di.IsChecked = 1; //新加入的默认为勾选
List <DictInfo> diList = new List <DictInfo>();
diList.Add(di);
SetupDictsInfo(diList, DictOps.AddDict, FormMain.sqliteInstance);
DialogResult = DialogResult.OK;
Close();
}
