private void removeSymlDuplicate()
{
System.Windows.Forms.Cursor oldCursor = System.Windows.Forms.Cursor.Current;
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
iRepos.removeLocalSymlDuplicate(scrollViewerLog, progressBar1);
this.btnFindSymlDuplicate.Dispatcher.Invoke(new Action(() =>
{ this.btnFindSymlDuplicate.IsEnabled = true; }));
this.opStep = OPERATIONSTEP.removeServerSymlDuplicate;
System.Windows.Forms.Cursor.Current = oldCursor;
}
private void formatData()
{
System.Windows.Forms.Cursor oldCursor = System.Windows.Forms.Cursor.Current;
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
if (iRepos.formatData(scrollViewerLog, progressBar1))
this.btnRemoveDuplicate.Dispatcher.Invoke(
new Action(() => { this.btnRemoveDuplicate.IsEnabled = true; }));
this.opStep = OPERATIONSTEP.removeLocalDuplicate;
System.Windows.Forms.Cursor.Current = oldCursor;
}
private void onekeyThread()
{
String err;
List<ColumnError> errs;
System.Windows.Forms.Cursor oldCursor = System.Windows.Forms.Cursor.Current;
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
String srcFile, srcFolder, destFolder;
srcFile = String.Empty;
srcFolder = String.Empty;
destFolder = String.Empty;
txtSourceFile.Dispatcher.Invoke(new Action(() => { srcFile = txtSourceFile.Text; }));
txtSourceFolder.Dispatcher.Invoke(new Action(() =>
{ srcFolder = txtSourceFolder.Text; }));
txtDestFolder.Dispatcher.Invoke(new Action(() => { destFolder = txtDestFolder.Text; }));
while (String.Empty.Equals(srcFile) || String.Empty.Equals(srcFolder)) ;
iRepos.destFolder = destFolder;
#if nodef
if (iCurrentReposId.Equals("zhongwenhuiyi") || iCurrentReposId.Equals("waiwenhuiyi"))
{
if (this.opStep <= OPERATIONSTEP.validateSymlTableName)
{
logInfo(scrollViewerLog, "正在验证索引目录表名……\n");
err = iRepos.validateTableName(iRepos.formatPmTableName, srcFile, srcFolder);
if (String.Empty.Equals(err))
{
iRepos.hasFormatTable = true;
logInfo(scrollViewerLog, "验证表名成功！\n存在规范后的表" +
iRepos.symlTableName + "，从该表中读取数据");
}
else
{
logInfo(scrollViewerLog, err);
return;
}
}
if (this.opStep <= OPERATIONSTEP.validateSymlTableColumn)
{
logInfo(scrollViewerLog, "正在验证索引目录字段……");
errs = iRepos.validateTableColums(false);
if (errs != null && errs.Count != 0)
{
string errMsg = "";
foreach (ColumnError clmErr in errs)
{
errMsg += clmErr.ToString();
}
logInfo(scrollViewerLog, errMsg);
return;
}
logInfo(scrollViewerLog, "索引字段验证通过.");
}
if (this.opStep <= OPERATIONSTEP.formatSymlData)
iRepos.formatSyml(scrollViewerLog, progressBar1);
if (this.opStep <= OPERATIONSTEP.removeLocalSymlDuplicate)
iRepos.removeLocalSymlDuplicate(scrollViewerLog, progressBar1);
if (this.opStep <= OPERATIONSTEP.removeServerSymlDuplicate)
iRepos.removeServerSymlDuplicate(scrollViewerLog, progressBar1);
if (this.opStep <= OPERATIONSTEP.addSymlRecords)
iRepos.addSymlRecords(scrollViewerLog, progressBar1);
// 需要合并到一个线程里去，否则并行执行有关联的代码
}
#endif
if (this.opStep <= OPERATIONSTEP.validateTableName)
{
logInfo(scrollViewerLog, "正在验证表名……");
err = iRepos.validateTableName(iRepos.formatPmTableName, srcFile, srcFolder);
if (String.Empty.Equals(err))
{
iRepos.hasFormatTable = true;
logInfo(scrollViewerLog, "验证表名成功！\n存在规范后的表" +
iRepos.formatPmTableName + "，从该表中读取数据");
}
else
{
err = iRepos.validateTableName(iRepos.pmTableName);
if (String.Empty.Equals(err))
{
iRepos.hasFormatTable = false;
logInfo(scrollViewerLog, "验证表名成功！\n从原始数据表" +
iRepos.pmTableName + "中读取数据");
if (!iCurrentReposId.Equals("zhongwenqikan")
&& !iCurrentReposId.Equals("zhongwenqikanjingguan")
&& !iCurrentReposId.Equals("waiwenqikan")
&& !iCurrentReposId.Equals("dianlibaokan")
&& !iCurrentReposId.Equals("jingjibaokan")
&& !iCurrentReposId.Equals("kejibaokan")
&& !iCurrentReposId.Equals("zonghebaokan")
&& !iCurrentReposId.Equals("zhongguochengguo")
&& !iCurrentReposId.Equals("nengyuanbaogao")
&& !iCurrentReposId.Equals("zhongwenhuiyi")
&& !iCurrentReposId.Equals("waiwenhuiyi")
&& !iCurrentReposId.Equals("xueweilunwen"))
{
err = "当前文库不支持从原始数据里提取篇名！";
logInfo(scrollViewerLog, err);
return;
}
}
else
{
logInfo(scrollViewerLog, err);
return;
}
}
}
if (this.opStep <= OPERATIONSTEP.validateTableColumn)
{
logInfo(scrollViewerLog, "正在验证字段……");
errs = iRepos.validateTableColums();
if (errs != null && errs.Count != 0)
{
string errMsg = "";
foreach (ColumnError clmErr in errs)
{
errMsg += clmErr.ToString();
}
logInfo(scrollViewerLog, errMsg);
return;
}
logInfo(scrollViewerLog, "字段验证通过.");
}
if (this.opStep <= OPERATIONSTEP.formatData)
iRepos.formatData(scrollViewerLog, progressBar1);
if (this.opStep <= OPERATIONSTEP.removeLocalDuplicate)
iRepos.removeLocalDuplicate(scrollViewerLog, progressBar1);
if (this.opStep <= OPERATIONSTEP.removeServerDuplicate)
iRepos.removeServerDuplicate(scrollViewerLog, progressBar1);
if (this.opStep <= OPERATIONSTEP.addRecords)
iRepos.addRecords(scrollViewerLog, progressBar1);
this.opStep = OPERATIONSTEP.done;
System.Windows.MessageBox.Show("上传数据完毕!\n");
System.Windows.Forms.Cursor.Current = oldCursor;
}
/* 检查txtSourceFile, txtSourceFolder, txtDestFolder */
private void EnableValidateOperation()
{
if (!String.Empty.Equals(txtSourceFile.Text)
&& !String.Empty.Equals(txtSourceFolder.Text)
&& !String.Empty.Equals(txtDestFolder.Text))
{
this.btnValidateTableName.IsEnabled = true;
if (iCurrentReposId.Equals("zhongwenhuiyi")
|| iCurrentReposId.Equals("waiwenhuiyi"))
{
this.btnValidateSymlTableName.IsEnabled = true;
this.opStep = OPERATIONSTEP.validateSymlTableName;
}
else
{
this.opStep = OPERATIONSTEP.validateTableName;
}
this.btnOnekey.IsEnabled = true;
this.btnOpenMdb.IsEnabled = true;
}
}
private void findDuplicate()
{
System.Windows.Forms.Cursor oldCursor = System.Windows.Forms.Cursor.Current;
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
iRepos.removeServerDuplicate(scrollViewerLog, progressBar1);
this.btnAddRecord.Dispatcher.Invoke(
new Action(() => { this.btnAddRecord.IsEnabled = true; }));
this.opStep = OPERATIONSTEP.addRecords;
System.Windows.Forms.Cursor.Current = oldCursor;
}
private void btnValidateTableName_Click(object sender, RoutedEventArgs e)
{
String err = iRepos.validateTableName(iRepos.formatPmTableName,
txtSourceFile.Text, txtSourceFolder.Text);
if (String.Empty.Equals(err))
{
iRepos.hasFormatTable = true;
logInfo(scrollViewerLog, "验证表名成功！\n存在规范后的表 [" +
iRepos.formatPmTableName + "]，从该表中读取数据");
}
else
{
err = iRepos.validateTableName(iRepos.pmTableName);
if (String.Empty.Equals(err))
{
iRepos.hasFormatTable = false;
logInfo(scrollViewerLog, "验证表名成功！\n从原始数据表 [" +
iRepos.pmTableName + "] 中读取数据");
/* 这里设置检查是否支持从原始数据里提取篇名信息 */
if (!iCurrentReposId.Equals("zhongwenqikan")
&& !iCurrentReposId.Equals("zhongwenqikanjingguan")
&& !iCurrentReposId.Equals("waiwenqikan")
&& !iCurrentReposId.Equals("dianlibaokan")
&& !iCurrentReposId.Equals("jingjibaokan")
&& !iCurrentReposId.Equals("kejibaokan")
&& !iCurrentReposId.Equals("zonghebaokan")
&& !iCurrentReposId.Equals("zhongguochengguo")
&& !iCurrentReposId.Equals("xueweilunwen")
&& !iCurrentReposId.Equals("zhongwenhuiyi")
&& !iCurrentReposId.Equals("waiwenhuiyi")
&& !iCurrentReposId.Equals("nengyuanbaogao"))
{
err = "当前文库不支持从原始数据里提取篇名！";
logInfo(scrollViewerLog, err);
return;
}
}
else
{
logInfo(scrollViewerLog, err);
return;
}
}
setButtonDisable();
this.btnValidateTableColumn.IsEnabled = true;
this.opStep = OPERATIONSTEP.validateTableColumn;
}
private void btnValidateTableColumn_Click(object sender, RoutedEventArgs e)
{
logInfo(scrollViewerLog, "开始验证表中各字段……");
System.Windows.Forms.Cursor oldCursor = System.Windows.Forms.Cursor.Current;
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
List<ColumnError> errs = iRepos.validateTableColums();
if (errs != null && errs.Count != 0)
{
string errMsg = "";
foreach (ColumnError clmErr in errs)
{
errMsg += clmErr.ToString();
}
logInfo(scrollViewerLog, errMsg);
}
else
{
logInfo(scrollViewerLog, "验证字段通过.");
setButtonDisable();
this.btnValidateColumnContent.IsEnabled = true;
this.opStep = OPERATIONSTEP.formatData;
}
System.Windows.Forms.Cursor.Current = oldCursor;
}
private void btnValidateSymlTableName_Click(object sender, RoutedEventArgs e)
{
String err = iRepos.validateTableName(iRepos.formatPmTableName,
txtSourceFile.Text, txtSourceFolder.Text);
if (String.Empty.Equals(err))
{
iRepos.hasFormatTable = true;
logInfo(scrollViewerLog, "验证表名成功！\n存在规范后的表" +
iRepos.symlTableName + "，从该表中读取数据.");
}
else
{
logInfo(scrollViewerLog, err);
return;
}
setSymlButtonDisable();
this.btnValidateSymlTableColumn.IsEnabled = true;
this.opStep = OPERATIONSTEP.validateSymlTableColumn;
}
private void addSymlRecord()
{
System.Windows.Forms.Cursor oldCursor = System.Windows.Forms.Cursor.Current;
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
iRepos.addSymlRecords(scrollViewerLog, progressBar1);
this.btnValidateTableName.Dispatcher.Invoke(new Action(() =>
{ this.btnValidateTableName.IsEnabled = true; }));
this.opStep = OPERATIONSTEP.validateTableName;
System.Windows.Forms.Cursor.Current = oldCursor;
}
private void addRecord()
{
System.Windows.Forms.Cursor oldCursor = System.Windows.Forms.Cursor.Current;
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
iRepos.addRecords(scrollViewerLog, progressBar1);
System.Windows.Forms.Cursor.Current = oldCursor;
this.opStep = OPERATIONSTEP.done;
System.Windows.MessageBox.Show("上传数据完毕!\n");
}
