private void CommitData(FeeOverduePaymentExcute fee) { SetProcessState(ProcessState.Saving); try { sReportDate = fee.FeeReport.ReportDate; sReportCreatedDate = fee.FeeReport.ReportCreationTime; for (int i = 0; i < fee.FeeReport.ListContractType.Count; i++) { for (int j = 0; j < fee.FeeReport.ListContractType[i].ListContract.Count; j++) { List <string> values = new List <string>(); values.Add(sLogID); values.Add(fee.FeeReport.ListContractType[i].ConType); // pvCONTRACTYPE values.Add(fee.FeeReport.ListContractType[i].Currency); //pvCURRENCY values.Add(fee.FeeReport.ListContractType[i].ListContract[j].ContractNo); //pvCONTRACT values.Add(fee.FeeReport.ListContractType[i].ListContract[j].Account); //pvACCOUNT values.Add(fee.FeeReport.ListContractType[i].ListContract[j].Due); //pvFEEDUE values.Add(fee.FeeReport.ListContractType[i].ListContract[j].Paid); //pvFEEPAID ctrlSA.ExecuteStoreProcedure("TXTREADER.IMP_FEEOVERDUEPAYMENT", values); //values.ForEach(Console.WriteLine); } //Console.WriteLine("abc---- " + fee.FeeReport.ListContractType[i].ListContract.Count); } } 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; } } }