private void CommitData(TrialExecute trial) { SetProcessState(ProcessState.Saving); try { for (int i = 0; i < trial.TrialReport.ListBranch.Count; i++) { for (int j = 0; j < trial.TrialReport.ListBranch[i].ListGroupTrial.Count; j++) { for (int k = 0; k < trial.TrialReport.ListBranch[i].ListGroupTrial[j].ListTrialRow.Count; k++) { List <string> values = new List <string>(); values.Add(sLogID); //logid values.Add(trial.TrialReport.ReportFromDate); //REPORT_FROM values.Add(trial.TrialReport.ReportToDate); //REPORT_TO values.Add(trial.TrialReport.ListBranch[i].BranchName); //BRANCH values.Add(trial.TrialReport.ListBranch[i].Currency); //CURRENCY values.Add(trial.TrialReport.ListBranch[i].ListGroupTrial[j].GroupName); //ACCT values.Add(trial.TrialReport.ListBranch[i].ListGroupTrial[j].ListTrialRow[k].AccountNo); //ACCOUNTNO values.Add(trial.TrialReport.ListBranch[i].ListGroupTrial[j].ListTrialRow[k].OpeningBalance); //OPENINGBALANCE values.Add(trial.TrialReport.ListBranch[i].ListGroupTrial[j].ListTrialRow[k].Debit); //DEBIT values.Add(trial.TrialReport.ListBranch[i].ListGroupTrial[j].ListTrialRow[k].Credit); //CREDIT values.Add(trial.TrialReport.ListBranch[i].ListGroupTrial[j].ListTrialRow[k].ClosingBalance); //COSLINGBALANCE ctrlSA.ExecuteStoreProcedure("TXTREADER.IMP_TRIAL", values); //values.ForEach(Console.WriteLine); } } } } catch (Exception ex) { sError = ex.Message.ToString(); ErrorReading = true; } }
public override void Read() { //SetProcessState(ProcessState.Running); //Console.WriteLine(FilePath); WriteInfo("Bắt đầu đọc file: " + sFileName); if (sFileName.Contains("FEE")) { FeeOverduePaymentExcute fee = new FeeOverduePaymentExcute(); fee.GetReport(s_FilePath); CommitData(fee); FinishReading(); } if (sFileName.Contains("OVERDUE")) { ContractOverduePaymentExcute fee1 = new ContractOverduePaymentExcute(); fee1.GetReport(s_FilePath); CommitData(fee1); FinishReading(); } if (sFileName.Contains("TRICHNOTUDONG")) { DebtAutomationExcute fee2 = new DebtAutomationExcute(); fee2.GetReport(s_FilePath); CommitData(fee2); FinishReading(); } if (sFileName.Contains("INTEREST")) { AccruedCreditInterestExcute fee3 = new AccruedCreditInterestExcute(); fee3.GetReport(s_FilePath); CommitData(fee3); FinishReading(); } if (sFileName.Contains("BALANCE")) { try { LoanExcute fee4 = new LoanExcute(); fee4.GetReport(s_FilePath); CommitData(fee4); FinishReading(); } catch (Exception ex) { sError = ex.Message.ToString(); ErrorReading = true; } } if (sFileName.Contains("EP747")) { try { VisaExecute fee5 = new VisaExecute(); fee5.GetReport(s_FilePath); CommitData(fee5); FinishReading(); } catch (Exception ex) { sError = ex.Message.ToString(); ErrorReading = true; } } if (sFileName.Contains("TRIAL")) { try { TrialExecute trial = new TrialExecute(); trial.GetReport(s_FilePath); CommitData(trial); FinishReading(); } catch (Exception ex) { sError = ex.Message.ToString(); ErrorReading = true; } } }