public virtual int Fill(BalanceSheetDataTable 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 BalanceSheetDataTable 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; } BalanceSheetDataTable balanceSheetDataTable = new BalanceSheetDataTable(); this.Adapter.Fill(balanceSheetDataTable); return(balanceSheetDataTable); }