コード例 #1
0
 public virtual LicenseMaster.LicenseMasterDataTable GetVendorLicenseDetails(string NameOfApplicant, string LicenseNo) {
     this.Adapter.SelectCommand = this.CommandCollection[11];
     if ((NameOfApplicant == null)) {
         this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
     }
     else {
         this.Adapter.SelectCommand.Parameters[1].Value = ((string)(NameOfApplicant));
     }
     if ((LicenseNo == null)) {
         this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value;
     }
     else {
         this.Adapter.SelectCommand.Parameters[2].Value = ((string)(LicenseNo));
     }
     LicenseMaster.LicenseMasterDataTable dataTable = new LicenseMaster.LicenseMasterDataTable();
     this.Adapter.Fill(dataTable);
     return dataTable;
 }
コード例 #2
0
 public virtual LicenseMaster.LicenseMasterDataTable GetRenewalHistry(string LicenseNo) {
     this.Adapter.SelectCommand = this.CommandCollection[9];
     if ((LicenseNo == null)) {
         this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
     }
     else {
         this.Adapter.SelectCommand.Parameters[1].Value = ((string)(LicenseNo));
     }
     LicenseMaster.LicenseMasterDataTable dataTable = new LicenseMaster.LicenseMasterDataTable();
     this.Adapter.Fill(dataTable);
     return dataTable;
 }
コード例 #3
0
 public virtual LicenseMaster.LicenseMasterDataTable GetRenewDetail() {
     this.Adapter.SelectCommand = this.CommandCollection[10];
     LicenseMaster.LicenseMasterDataTable dataTable = new LicenseMaster.LicenseMasterDataTable();
     this.Adapter.Fill(dataTable);
     return dataTable;
 }
コード例 #4
0
 public virtual LicenseMaster.LicenseMasterDataTable GetLicenseDetailByLicenseAppID(System.Guid LicenseApplicationId) {
     this.Adapter.SelectCommand = this.CommandCollection[7];
     this.Adapter.SelectCommand.Parameters[0].Value = ((System.Guid)(LicenseApplicationId));
     LicenseMaster.LicenseMasterDataTable dataTable = new LicenseMaster.LicenseMasterDataTable();
     this.Adapter.Fill(dataTable);
     return dataTable;
 }