dataset6.h

Visual C++.net数据库开发经典案例

        this->EnforceConstraints = true;
        this->tableUsers = new My::DataSet6::UsersDataTable();
        this->Tables->Add(this->tableUsers);
    };
    
    inline System::Boolean DataSet6::ShouldSerializeUsers() {
        return false;
    };
    
    inline System::Void DataSet6::SchemaChanged(System::Object *  sender, System::ComponentModel::CollectionChangeEventArgs *  e) {
        if ((e->Action == System::ComponentModel::CollectionChangeAction::Remove)) {
            this->InitVars();
        }
    };
    
    
    
    
    
    
    
    
    inline DataSet6::UsersDataTable::UsersDataTable() : 
            DataTable(S"Users") {
        this->InitClass();
    }
    
    inline DataSet6::UsersDataTable::UsersDataTable(System::Data::DataTable *  table) : 
            DataTable(table->TableName) {
        if ((table->CaseSensitive != table->DataSet->CaseSensitive)) {
            this->CaseSensitive = table->CaseSensitive;
        }
        if ((table->Locale->ToString() != table->DataSet->Locale->ToString())) {
            this->Locale = table->Locale;
        }
        if ((table->Namespace != table->DataSet->Namespace)) {
            this->Namespace = table->Namespace;
        }
        this->Prefix = table->Prefix;
        this->MinimumCapacity = table->MinimumCapacity;
        this->DisplayExpression = table->DisplayExpression;
    }
    
    inline System::Int32 DataSet6::UsersDataTable::get_Count() {
        return this->Rows->Count;
    }
    
    inline System::Data::DataColumn *  DataSet6::UsersDataTable::get_UserIDColumn() {
        return this->columnUserID;
    }
    
    inline System::Data::DataColumn *  DataSet6::UsersDataTable::get_DepartmentColumn() {
        return this->columnDepartment;
    }
    
    inline System::Data::DataColumn *  DataSet6::UsersDataTable::get_NameColumn() {
        return this->columnName;
    }
    
    inline System::Data::DataColumn *  DataSet6::UsersDataTable::get_SexColumn() {
        return this->columnSex;
    }
    
    inline System::Data::DataColumn *  DataSet6::UsersDataTable::get_PasswordColumn() {
        return this->columnPassword;
    }
    
    inline My::DataSet6::UsersRow *  DataSet6::UsersDataTable::get_Item(System::Int32 index) {
        return (__try_cast<My::DataSet6::UsersRow *  >(this->Rows->Item[index]));
    }
    
    
    
    
    
    inline System::Void DataSet6::UsersDataTable::AddUsersRow(My::DataSet6::UsersRow *  row) {
        this->Rows->Add(row);
    };
    
    inline My::DataSet6::UsersRow *  DataSet6::UsersDataTable::AddUsersRow(System::String *  UserID, System::String *  Department, System::String *  Name, System::String *  Sex, System::String *  Password) {
        My::DataSet6::UsersRow *  rowUsersRow = (__try_cast<My::DataSet6::UsersRow *  >(this->NewRow()));
        System::Object* __mcTemp__1[] = new System::Object*[5];
                __mcTemp__1[0] = UserID;
                __mcTemp__1[1] = Department;
                __mcTemp__1[2] = Name;
                __mcTemp__1[3] = Sex;
                __mcTemp__1[4] = Password;
        rowUsersRow->ItemArray = __mcTemp__1;
        this->Rows->Add(rowUsersRow);
        return rowUsersRow;
    };
    
    inline My::DataSet6::UsersRow *  DataSet6::UsersDataTable::FindByUserID(System::String *  UserID) {
        System::Object* __mcTemp__1[] = new System::Object*[1];
                __mcTemp__1[0] = UserID;
        return (__try_cast<My::DataSet6::UsersRow *  >(this->Rows->Find(__mcTemp__1)));
    };
    
    inline System::Collections::IEnumerator *  DataSet6::UsersDataTable::GetEnumerator() {
        return this->Rows->GetEnumerator();
    };
    
    inline System::Data::DataTable *  DataSet6::UsersDataTable::Clone() {
        My::DataSet6::UsersDataTable *  cln = (__try_cast<My::DataSet6::UsersDataTable *  >(__super::Clone()));
        cln->InitVars();
        return cln;
    };
    
    inline System::Data::DataTable *  DataSet6::UsersDataTable::CreateInstance() {
        return new My::DataSet6::UsersDataTable();
    };
    
    inline System::Void DataSet6::UsersDataTable::InitVars() {
        this->columnUserID = this->Columns->Item[S"UserID"];
        this->columnDepartment = this->Columns->Item[S"Department"];
        this->columnName = this->Columns->Item[S"Name"];
        this->columnSex = this->Columns->Item[S"Sex"];
        this->columnPassword = this->Columns->Item[S"Password"];
    };
    
    inline System::Void DataSet6::UsersDataTable::InitClass() {
        this->columnUserID = new System::Data::DataColumn(S"UserID", __typeof(System::String), 0, System::Data::MappingType::Element);
        this->Columns->Add(this->columnUserID);
        this->columnDepartment = new System::Data::DataColumn(S"Department", __typeof(System::String), 0, System::Data::MappingType::Element);
        this->Columns->Add(this->columnDepartment);
        this->columnName = new System::Data::DataColumn(S"Name", __typeof(System::String), 0, System::Data::MappingType::Element);
        this->Columns->Add(this->columnName);
        this->columnSex = new System::Data::DataColumn(S"Sex", __typeof(System::String), 0, System::Data::MappingType::Element);
        this->Columns->Add(this->columnSex);
        this->columnPassword = new System::Data::DataColumn(S"Password", __typeof(System::String), 0, System::Data::MappingType::Element);
        this->Columns->Add(this->columnPassword);
        System::Data::DataColumn* __mcTemp__1[] = new System::Data::DataColumn*[1];
                        __mcTemp__1[0] = this->columnUserID;
        this->Constraints->Add(new System::Data::UniqueConstraint(S"Constraint1", __mcTemp__1, true));
        this->columnUserID->AllowDBNull = false;
        this->columnUserID->Unique = true;
        this->columnDepartment->AllowDBNull = false;
        this->columnName->AllowDBNull = false;
        this->columnSex->AllowDBNull = false;
    };
    
    inline My::DataSet6::UsersRow *  DataSet6::UsersDataTable::NewUsersRow() {
        return (__try_cast<My::DataSet6::UsersRow *  >(this->NewRow()));
    };
    
    inline System::Data::DataRow *  DataSet6::UsersDataTable::NewRowFromBuilder(System::Data::DataRowBuilder *  builder) {
        return new My::DataSet6::UsersRow(builder);
    };
    
    inline System::Type *  DataSet6::UsersDataTable::GetRowType() {
        return __typeof(My::DataSet6::UsersRow);
    };
    
    inline System::Void DataSet6::UsersDataTable::OnRowChanged(System::Data::DataRowChangeEventArgs *  e) {
        __super::OnRowChanged(e);
        if ((this->UsersRowChanged != 0)) {
            this->UsersRowChanged(this, new My::DataSet6::UsersRowChangeEvent((__try_cast<My::DataSet6::UsersRow *  >(e->Row)), e->Action));
        }
    };
    
    inline System::Void DataSet6::UsersDataTable::OnRowChanging(System::Data::DataRowChangeEventArgs *  e) {
        __super::OnRowChanging(e);
        if ((this->UsersRowChanging != 0)) {
            this->UsersRowChanging(this, new My::DataSet6::UsersRowChangeEvent((__try_cast<My::DataSet6::UsersRow *  >(e->Row)), e->Action));
        }
    };
    
    inline System::Void DataSet6::UsersDataTable::OnRowDeleted(System::Data::DataRowChangeEventArgs *  e) {
        __super::OnRowDeleted(e);
        if ((this->UsersRowDeleted != 0)) {
            this->UsersRowDeleted(this, new My::DataSet6::UsersRowChangeEvent((__try_cast<My::DataSet6::UsersRow *  >(e->Row)), e->Action));
        }
    };
    
    inline System::Void DataSet6::UsersDataTable::OnRowDeleting(System::Data::DataRowChangeEventArgs *  e) {
        __super::OnRowDeleting(e);
        if ((this->UsersRowDeleting != 0)) {
            this->UsersRowDeleting(this, new My::DataSet6::UsersRowChangeEvent((__try_cast<My::DataSet6::UsersRow *  >(e->Row)), e->Action));
        }
    };
    
    inline System::Void DataSet6::UsersDataTable::RemoveUsersRow(My::DataSet6::UsersRow *  row) {
        this->Rows->Remove(row);
    };
    
    
    
    inline DataSet6::UsersRow::UsersRow(System::Data::DataRowBuilder *  rb) : 
            DataRow(rb) {
        this->tableUsers = (__try_cast<My::DataSet6::UsersDataTable *  >(this->Table));
    }
    
    inline System::String *  DataSet6::UsersRow::get_UserID() {
        return (__try_cast<System::String *  >(this->Item[this->tableUsers->UserIDColumn]));
    }
    inline void DataSet6::UsersRow::set_UserID(System::String *  value) {
        this->Item[this->tableUsers->UserIDColumn] = value;
    }
    
    inline System::String *  DataSet6::UsersRow::get_Department() {
        return (__try_cast<System::String *  >(this->Item[this->tableUsers->DepartmentColumn]));
    }
    inline void DataSet6::UsersRow::set_Department(System::String *  value) {
        this->Item[this->tableUsers->DepartmentColumn] = value;
    }
    
    inline System::String *  DataSet6::UsersRow::get_Name() {
        return (__try_cast<System::String *  >(this->Item[this->tableUsers->NameColumn]));
    }
    inline void DataSet6::UsersRow::set_Name(System::String *  value) {
        this->Item[this->tableUsers->NameColumn] = value;
    }
    
    inline System::String *  DataSet6::UsersRow::get_Sex() {
        return (__try_cast<System::String *  >(this->Item[this->tableUsers->SexColumn]));
    }
    inline void DataSet6::UsersRow::set_Sex(System::String *  value) {
        this->Item[this->tableUsers->SexColumn] = value;
    }
    
    inline System::String *  DataSet6::UsersRow::get_Password() {
        try {
            return (__try_cast<System::String *  >(this->Item[this->tableUsers->PasswordColumn]));
        }
        catch (System::InvalidCastException * e) {
            throw new System::Data::StrongTypingException(S"无法获取值，因为它是 DBNull。", e);
        }
    }
    inline void DataSet6::UsersRow::set_Password(System::String *  value) {
        this->Item[this->tableUsers->PasswordColumn] = value;
    }
    
    inline System::Boolean DataSet6::UsersRow::IsPasswordNull() {
        return this->IsNull(this->tableUsers->PasswordColumn);
    };
    
    inline System::Void DataSet6::UsersRow::SetPasswordNull() {
        this->Item[this->tableUsers->PasswordColumn] = System::Convert::DBNull;
    };
    
    
    
    
    inline DataSet6::UsersRowChangeEvent::UsersRowChangeEvent(My::DataSet6::UsersRow *  row, System::Data::DataRowAction action) {
        this->eventRow = row;
        this->eventAction = action;
    }
    
    inline My::DataSet6::UsersRow *  DataSet6::UsersRowChangeEvent::get_Row() {
        return this->eventRow;
    }
    
    inline System::Data::DataRowAction DataSet6::UsersRowChangeEvent::get_Action() {
        return this->eventAction;
    }
}