private void CommitData(AccruedCreditInterestExcute fee3) { SetProcessState(ProcessState.Saving); try { sReportDate = fee3.AccruedReport.ReportDate; sReportCreatedDate = fee3.AccruedReport.ReportCreationTime; for (int i = 0; i < fee3.AccruedReport.ListContractType.Count; i++) { for (int j = 0; j < fee3.AccruedReport.ListContractType[i].ListContract.Count; j++) { List <string> values = new List <string>(); values.Add(sLogID); values.Add(fee3.AccruedReport.ListContractType[i].ConType); // pvCONTRACTYPE values.Add(fee3.AccruedReport.ListContractType[i].Currency); //pvCURRENCY values.Add(fee3.AccruedReport.ListContractType[i].ListContract[j].ContractNo); //pvCONTRACTNO values.Add(fee3.AccruedReport.ListContractType[i].ListContract[j].ClientName); //pvCLIENTNAME values.Add(fee3.AccruedReport.ListContractType[i].ListContract[j].Interests); //pvINTEREST Console.WriteLine("rownum---- " + fee3.AccruedReport.ListContractType[i].ListContract[j].RowNumber); ctrlSA.ExecuteStoreProcedure("TXTREADER.IMP_ACCRUEDINTEREST", values); //values.ForEach(Console.WriteLine); } //Console.WriteLine("abc---- " + fee3.AccruedReport.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; } } }