Example #1
0
        public virtual int Fill(FixedAssetReportDataTable 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);
        }
Example #2
0
        public virtual FixedAssetReportDataTable 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;
            }
            FixedAssetReportDataTable fixedAssetReportDataTable = new FixedAssetReportDataTable();

            this.Adapter.Fill(fixedAssetReportDataTable);
            return(fixedAssetReportDataTable);
        }