public virtual CloudAccountDA.ReportTaxSummaryDataTable GetData(int?CompanyID, DateTime?FromDate, DateTime?ToDate) { this.Adapter.SelectCommand = this.CommandCollection[0]; if (CompanyID.HasValue) { this.Adapter.SelectCommand.Parameters[1].Value = CompanyID.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value; } if (FromDate.HasValue) { this.Adapter.SelectCommand.Parameters[2].Value = FromDate.Value; } else { this.Adapter.SelectCommand.Parameters[2].Value = DBNull.Value; } if (ToDate.HasValue) { this.Adapter.SelectCommand.Parameters[3].Value = ToDate.Value; } else { this.Adapter.SelectCommand.Parameters[3].Value = DBNull.Value; } CloudAccountDA.ReportTaxSummaryDataTable dataTable = new CloudAccountDA.ReportTaxSummaryDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
public virtual int Fill(CloudAccountDA.ReportTaxSummaryDataTable dataTable, int?CompanyID, DateTime?FromDate, DateTime?ToDate) { this.Adapter.SelectCommand = this.CommandCollection[0]; if (CompanyID.HasValue) { this.Adapter.SelectCommand.Parameters[1].Value = CompanyID.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value; } if (FromDate.HasValue) { this.Adapter.SelectCommand.Parameters[2].Value = FromDate.Value; } else { this.Adapter.SelectCommand.Parameters[2].Value = DBNull.Value; } if (ToDate.HasValue) { this.Adapter.SelectCommand.Parameters[3].Value = ToDate.Value; } else { this.Adapter.SelectCommand.Parameters[3].Value = DBNull.Value; } if (this.ClearBeforeFill) { dataTable.Clear(); } return(this.Adapter.Fill(dataTable)); }