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