private void ImportWJFL_SF()
{
if (!IsValidToImportWJFL(this.lblImportWJFLPathSF.Text))
{
return;
}
var filePath = this.lblImportWJFLPathSF.Text;
DateTime asOfDate;
var result = ExcelHelper.GetImportDateFromWJFLSF(filePath, out asOfDate);
if (!string.IsNullOrEmpty(result))
{
ShowError(result);
return;
}
var importer = new ImporterSF();
this.Cursor = Cursors.WaitCursor;
try {
var startTime = DateTime.Now;
result = importer.UpdateWJFL(asOfDate, filePath);
this.Cursor = Cursors.Default;
if (string.IsNullOrEmpty(result))
{
var seconds = Math.Round((DateTime.Now - startTime).TotalSeconds);
var timeSpan = seconds > 3 ? string.Format("({0}秒)", seconds) : "";
ShowInfo(string.Format("神府支行{0}数据的七级分类已经更新完毕。{1}", asOfDate.ToString("yyyy年M月d日"), timeSpan));
}
else
{
ShowError("神府支行: " + result);
}
}
catch (IOException ex) {
if (ex.Message.IndexOf("it is being used by another process") > 0)
{
ShowError("五级分类文件已经被打开，请先从Excel里关闭该报表然后再导入。");
}
else
{
ShowError("请关闭所有excel，然后再尝试导出报表。");
}
logger.Error(ex);
}
catch (System.Data.SqlClient.SqlException ex) {
logger.Error("Error in ImportWJFL_SF:\r\n", ex);
ShowError("数据库访问发生错误，请确保数据库可以访问。");
}
catch (Exception ex) {
ShowError("导入发生错误");
logger.Error(ex);
}
finally {
this.Cursor = Cursors.Default;
}
}
private void btnImport_Click(object sender, EventArgs e)
{
DateTime asOfDate;
if (IsValidToImport(out asOfDate))
{
if (MessageBox.Show(string.Format("确定您导入的数据是{0}的吗？", asOfDate.ToString("yyyy-M-d")), this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
string[] sourceFiles =
{
"dummy", // 1-based array is required
string.Join("|", importLoanFiles),
this.lblImportPublic.Text, this.lblImportPrivate.Text,
this.lblImportNonAccrual.Text, this.lblImportOverdue.Text,
string.Join("|", importYWNeiFiles),
string.Join("|", importYWWaiFiles),
this.lblImportLoanSF.Text
};
var importer = new ImporterSF();
this.Cursor = Cursors.WaitCursor;
try {
var startTime = DateTime.Now;
var result = importer.CreateImport(asOfDate, sourceFiles);
this.Cursor = Cursors.Default;
if (string.IsNullOrEmpty(result))
{
var seconds = Math.Round((DateTime.Now - startTime).TotalSeconds);
var timeSpan = seconds > 3 ? string.Format("({0}秒)", seconds) : "";
ShowInfo(string.Format("{0}的数据导入完毕。{1}", asOfDate.ToString("yyyy年M月d日"), timeSpan));
logger.DebugFormat("Import done. {0} seconds costed.", seconds);
InitImportPanel();
}
else
{
ShowError(result);
}
}
catch (System.Data.SqlClient.SqlException ex) {
logger.Error("Error in btnImport_Click:\r\n", ex);
ShowError("数据库访问发生错误，请确保数据库可以访问。");
}
catch (Exception ex) {
ShowError("导入发生错误");
logger.Error(ex);
}
finally {
this.Cursor = Cursors.Default;
}
}
}
private void ImportWJFL_SF()
{
if (!IsValidToImportWJFL(this.lblImportWJFLPathSF.Text)) {
return;
}
var filePath = this.lblImportWJFLPathSF.Text;
DateTime asOfDate;
var result = ExcelHelper.GetImportDateFromWJFLSF(filePath, out asOfDate);
if (!string.IsNullOrEmpty(result)) {
ShowError(result);
return;
}
var importer = new ImporterSF();
this.Cursor = Cursors.WaitCursor;
try {
var startTime = DateTime.Now;
result = importer.UpdateWJFL(asOfDate, filePath);
this.Cursor = Cursors.Default;
if (string.IsNullOrEmpty(result)) {
var seconds = Math.Round((DateTime.Now - startTime).TotalSeconds);
var timeSpan = seconds > 3 ? string.Format("({0}秒)", seconds) : "";
ShowInfo(string.Format("神府支行{0}数据的七级分类已经更新完毕。{1}", asOfDate.ToString("yyyy年M月d日"), timeSpan));
}
else {
ShowError("神府支行: " + result);
}
}
catch (IOException ex) {
if (ex.Message.IndexOf("it is being used by another process") > 0) {
ShowError("五级分类文件已经被打开，请先从Excel里关闭该报表然后再导入。");
}
else {
ShowError("请关闭所有excel，然后再尝试导出报表。");
}
logger.Error(ex);
}
catch (System.Data.SqlClient.SqlException ex) {
logger.Error("Error in ImportWJFL_SF:\r\n", ex);
ShowError("数据库访问发生错误，请确保数据库可以访问。");
}
catch (Exception ex) {
ShowError("导入发生错误");
logger.Error(ex);
}
finally {
this.Cursor = Cursors.Default;
}
}
private void btnImport_Click(object sender, EventArgs e)
{
DateTime asOfDate;
if (IsValidToImport(out asOfDate)) {
if (MessageBox.Show(string.Format("确定您导入的数据是{0}的吗？", asOfDate.ToString("yyyy-M-d")), this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) {
return;
}
string[] sourceFiles = {
"dummy", // 1-based array is required
this.lblImportLoan.Text,
this.lblImportPublic.Text, this.lblImportPrivate.Text,
this.lblImportNonAccrual.Text, this.lblImportOverdue.Text,
string.Join("|", importYWNeiFiles),
string.Join("|", importYWWaiFiles),
this.lblImportLoanSF.Text
};
var importer = new ImporterSF();
this.Cursor = Cursors.WaitCursor;
try {
var startTime = DateTime.Now;
var result = importer.CreateImport(asOfDate, sourceFiles);
this.Cursor = Cursors.Default;
if (string.IsNullOrEmpty(result)) {
var seconds = Math.Round((DateTime.Now - startTime).TotalSeconds);
var timeSpan = seconds > 3 ? string.Format("({0}秒)", seconds) : "";
ShowInfo(string.Format("{0}的数据导入完毕。{1}", asOfDate.ToString("yyyy年M月d日"), timeSpan));
logger.DebugFormat("Import done. {0} seconds costed.", seconds);
InitImportPanel();
}
else {
ShowError(result);
}
}
catch (System.Data.SqlClient.SqlException ex) {
logger.Error("Error in btnImport_Click:\r\n", ex);
ShowError("数据库访问发生错误，请确保数据库可以访问。");
}
catch (Exception ex) {
ShowError("导入发生错误");
logger.Error(ex);
}
finally {
this.Cursor = Cursors.Default;
}
}
}
