private void Reentrant()
{
log("---->Begin to reentrant the Job!");
Schedule(() =>
{
string[] txtFiles = Directory.GetFiles(path, "*.zip", SearchOption.AllDirectories);
string fileName = string.Empty;
string tempFolder = string.Empty;
foreach (string file in txtFiles)
{
fileName = file.Substring(file.LastIndexOf("\\") + 1);
tempFolder = unZipTempFolder + "\\" + fileName.Remove(fileName.IndexOf("."));
log("------------------->tempFolder:" + tempFolder);
ZipHelper.UnZip(file, tempFolder);
//Console.WriteLine("Un zip success !");
String excelFile1 = tempFolder + "\\利润表.xls";
String excelFile2 = tempFolder + "\\现金流量表.xls";
String excelFile3 = tempFolder + "\\资产表.xls";
ImportToData.ImportAllProfit(excelFile1);
ImportToData.ImportAllBalance(excelFile2);
ImportToData.ImportAllCashFlow(excelFile3);
File.Move(file, finishBackup + fileName);
}
// Thread.Sleep(TimeSpan.FromSeconds(3));
}).WithName("[reentrant]").ToRunEvery(30).Minutes();//.ToRunNow().AndEvery(30).Minutes();
}
private void btnImport_Click(object sender, EventArgs e)
{
String excelFile = @"D:\project\hongxian\厦门14-4-12.xls";
ImportToData.ImportAllCompany(excelFile);//.ImportAllProfit(excelFile);
MessageBox.Show("完成！");
}
private static int getBaseId(DataTable data)
{
for (int i = 0; i < 6; i++)
{
if (data.Rows[i][1] == null || data.Rows[i][1].ToString().Length == 0)
{
Console.WriteLine("表头[" + data.Rows[i][0] + "]必填信息为空!");
return(0);
}
}
object obj = data.Rows[0][1];
if (null == obj)
{
log("提交的数据缺失！" + data.TableName);
return(0);
}
string taxpayer_id = data.Rows[0][1].ToString();
string taxpayer_name = data.Rows[1][1].ToString();
string certificate = data.Rows[2][1].ToString();
DateTime dt = DateTime.Now;
string declare_date = DateTime.Parse(data.Rows[3][1].ToString()).ToString("yyyy-MM-dd");
string filling_date = DateTime.Parse(data.Rows[4][1].ToString()).ToString("yyyy-MM-dd");
string report_date = DateTime.Parse(data.Rows[5][1].ToString()).ToString("yyyy-MM-dd");
int id = ImportToData.saveBase(taxpayer_id, taxpayer_name, certificate, declare_date, filling_date, report_date);
return(id);
}