public virtual int FillBy(VoucherDataTable dataTable, DateTime?date)
        {
            this.Adapter.SelectCommand = this.CommandCollection[2];
            if (&date.HasValue)
            {
                this.Adapter.SelectCommand.Parameters[1].Value = &date.Value;
            }
            else
            {
                this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value;
            }
            if (this.ClearBeforeFill)
            {
                dataTable.Clear();
            }
            int num = this.Adapter.Fill(dataTable);

            return(num);
        }
        public virtual int Fill(VoucherDataTable dataTable, int?invoiceCode)
        {
            this.Adapter.SelectCommand = this.CommandCollection[0];
            if (&invoiceCode.HasValue)
            {
                this.Adapter.SelectCommand.Parameters[1].Value = &invoiceCode.Value;
            }
            else
            {
                this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value;
            }
            if (this.ClearBeforeFill)
            {
                dataTable.Clear();
            }
            int num = this.Adapter.Fill(dataTable);

            return(num);
        }