Пример #1
0
 public virtual OfficesMaster.OfficeMasterDataTable FindOfficeByName(string OfficeName) {
     this.Adapter.SelectCommand = this.CommandCollection[3];
     if ((OfficeName == null)) {
         this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
     }
     else {
         this.Adapter.SelectCommand.Parameters[1].Value = ((string)(OfficeName));
     }
     OfficesMaster.OfficeMasterDataTable dataTable = new OfficesMaster.OfficeMasterDataTable();
     this.Adapter.Fill(dataTable);
     return dataTable;
 }
Пример #2
0
 public virtual OfficesMaster.OfficeMasterDataTable GetOfficesByType(global::System.Nullable<global::System.Guid> OfficeTypeId) {
     this.Adapter.SelectCommand = this.CommandCollection[7];
     if ((OfficeTypeId.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[1].Value = ((System.Guid)(OfficeTypeId.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
     }
     OfficesMaster.OfficeMasterDataTable dataTable = new OfficesMaster.OfficeMasterDataTable();
     this.Adapter.Fill(dataTable);
     return dataTable;
 }
Пример #3
0
 public virtual OfficesMaster.OfficeMasterDataTable GetOffices() {
     this.Adapter.SelectCommand = this.CommandCollection[0];
     OfficesMaster.OfficeMasterDataTable dataTable = new OfficesMaster.OfficeMasterDataTable();
     this.Adapter.Fill(dataTable);
     return dataTable;
 }