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;
}
}
}
