usergroup.cpp

一套BCB６开发的电话管理系统

#include "UserGroup.h"
#include <memory>
UserGroup::UserGroup( TADOConnection* pADOConnect)
{
    GroupID = "";
    GroupName = "";
    pConnect = pADOConnect;
}

UserGroup::~UserGroup()
{
}

inline String UserGroup::GetUserGroupID()
{
    return GroupID;
}

inline String UserGroup::GetUserGroupName()
{
    return GroupName;
}

inline TADOConnection* UserGroup::GetADOConnect()
{
    return pConnect;
}
/*
inline void UserGroup::SetUserGroupID( String UserGroupID)
{
    GroupID = UserGroupID;
}

inline void UserGroup::SetUserGroupName( String UserGroupName)
{
    GroupName = UserGroupName;
}
*/
void UserGroup::sql_insert()
{
    int AffectedRec;
    String SQLStr = "insert into UserGroupInfo values( '" + GetUserGroupID() + "'";
    SQLStr += ", '" + GetUserGroupName() + "')";

    pConnect->Execute( SQLStr, AffectedRec);
}

void UserGroup::sql_update( String UserGroupName)
{
    int AffectedRec;
    String SQLStr = "update UserGroupInfo set GroupName = '" + GetUserGroupName() + "'";
    SQLStr += " where GroupID = '" + GetUserGroupID() + "'";

    pConnect->Execute( SQLStr, AffectedRec);
}

void UserGroup::sql_delete( String UserGroupID)
{
    int AffectedRec;
    String SQLStr = "delete from UserGroupInfo where GroupID = '" + GetUserGroupID() + "'";

    pConnect->Execute( SQLStr, AffectedRec);
}

void UserGroup::GetData( String UserGroupID)
{
    std::auto_ptr< TADOQuery> pQry( new TADOQuery( NULL));
    try {
        pQry->Connection = pConnect;
        pQry->Close();
        pQry->SQL->Clear();
        pQry->SQL->Add( "select * from UserGroupInfo where GroupID = '" + UserGroupID + "'");
        pQry->Open();

        if( pQry->IsEmpty()) {
            GroupName = "";
            GroupID = "";
        }
        else {
            GroupID = pQry->FieldByName( "GroupID")->AsString;
            GroupName = pQry->FieldByName( "GroupName")->AsString;
        }
    }
    catch( ...){
    }
}