private void CommitData(DebtAutomationExcute fee2) { SetProcessState(ProcessState.Saving); try { for (int i = 0; i < fee2.DebtReport.ListDebt.Count; i++) { List <string> values = new List <string>(); values.Add(sLogID); values.Add(fee2.DebtReport.ListDebt[i].CardAccountNumber); // pv_CARDNUMBER values.Add(fee2.DebtReport.ListDebt[i].EmbossingName); //pv_NAME values.Add(fee2.DebtReport.ListDebt[i].BranchPart); //pv_BRANCHCODE values.Add(fee2.DebtReport.ListDebt[i].BankAccountNumber); //pv_BANKACCOUNT values.Add(fee2.DebtReport.ListDebt[i].DebtCreditFlag); //pv_FLAG values.Add(fee2.DebtReport.ListDebt[i].CardAccountCurrency); //pv_CURRENTCY values.Add(fee2.DebtReport.ListDebt[i].Amount); //pv_AMOUNT values.Add(fee2.DebtReport.ListDebt[i].NumOfDecPlace); //pv_DECIMALNUMBER values.Add(fee2.DebtReport.ListDebt[i].PostingDate); //pv_POSTINGDATE values.Add(fee2.DebtReport.ListDebt[i].AccountNumber); //pv_ACCOUNTNUMBER ctrlSA.ExecuteStoreProcedure("TXTREADER.IMP_DEBTEXECUTE", values); //values.ForEach(Console.WriteLine); //Console.WriteLine("abc---- " + fee2.DebtReport.ListDebt[i].RowNumber); } } catch (Exception ex) { sError = ex.Message.ToString(); ErrorReading = true; } //Console.WriteLine("---- " + fee2.DebtReport.ListDebt.Count); //Console.WriteLine("-------TimeProcess------- " + fee2.DebtReport.TimeProcess); //Console.WriteLine("-------TotalRow---------- " + fee2.DebtReport.FileRow); //Console.WriteLine("-------FileName---------- " + fee2.DebtReport.FileName); //Console.WriteLine("-------FileSize---------- " + fee2.DebtReport.FileSize); //Console.WriteLine("-------FileLastMod------- " + fee2.DebtReport.FileLastMod); //Console.WriteLine("-------FileCreate-------- " + fee2.DebtReport.FileCreate); //Console.WriteLine("-------FileLocation------ " + fee2.DebtReport.FileLocation); //Console.WriteLine("-------FileHash---------- " + fee2.DebtReport.FileHash); }
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; } } }