public virtual int Fill(TrialBalanceDataTable dataTable, DateTime?dateFrom, DateTime?dateTo) { this.Adapter.SelectCommand = this.CommandCollection[0]; if (&dateFrom.HasValue) { this.Adapter.SelectCommand.Parameters[1].Value = &dateFrom.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value; } if (&dateTo.HasValue) { this.Adapter.SelectCommand.Parameters[2].Value = &dateTo.Value; } else { this.Adapter.SelectCommand.Parameters[2].Value = DBNull.Value; } if (this.ClearBeforeFill) { dataTable.Clear(); } int num = this.Adapter.Fill(dataTable); return(num); }
public virtual TrialBalanceDataTable GetData(DateTime?dateFrom, DateTime?dateTo) { this.Adapter.SelectCommand = this.CommandCollection[0]; if (&dateFrom.HasValue) { this.Adapter.SelectCommand.Parameters[1].Value = &dateFrom.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value; } if (&dateTo.HasValue) { this.Adapter.SelectCommand.Parameters[2].Value = &dateTo.Value; } else { this.Adapter.SelectCommand.Parameters[2].Value = DBNull.Value; } TrialBalanceDataTable trialBalanceDataTable = new TrialBalanceDataTable(); this.Adapter.Fill(trialBalanceDataTable); return(trialBalanceDataTable); }