public virtual int Fill(dsCreditPackageRestrition.tblCreditPackageRestrictionDataTable dataTable, string CreditPackage, global::System.Nullable <decimal> Balance) { this.Adapter.SelectCommand = this.CommandCollection[0]; if ((CreditPackage == null)) { throw new global::System.ArgumentNullException("CreditPackage"); } else { this.Adapter.SelectCommand.Parameters[0].Value = ((string)(CreditPackage)); } if ((Balance.HasValue == true)) { this.Adapter.SelectCommand.Parameters[1].Value = ((decimal)(Balance.Value)); } else { this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value; } if ((this.ClearBeforeFill == true)) { dataTable.Clear(); } int returnValue = this.Adapter.Fill(dataTable); return(returnValue); }
public virtual dsCreditPackageRestrition.tblCreditPackageRestrictionDataTable GetData(string CreditPackage, global::System.Nullable<decimal> Balance) { this.Adapter.SelectCommand = this.CommandCollection[0]; if ((CreditPackage == null)) { throw new global::System.ArgumentNullException("CreditPackage"); } else { this.Adapter.SelectCommand.Parameters[0].Value = ((string)(CreditPackage)); } if ((Balance.HasValue == true)) { this.Adapter.SelectCommand.Parameters[1].Value = ((decimal)(Balance.Value)); } else { this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value; } dsCreditPackageRestrition.tblCreditPackageRestrictionDataTable dataTable = new dsCreditPackageRestrition.tblCreditPackageRestrictionDataTable(); this.Adapter.Fill(dataTable); return dataTable; }