department.cpp

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

#include <memory>
#include "Department.h"

Department::Department( TADOConnection* pADOConnect)
{
    this->pConnect = pADOConnect;
    DeptNo = "";
    DeptName = "";
    CompanyNo = "";
}

Department::~Department()
{
}

inline String Department::GetDeptNo() const
{
    return DeptNo;
}

inline String Department::GetDeptName() const
{
    return DeptName;
}

inline String Department::GetCompanyNo() const
{
    return CompanyNo;
}

void Department::SetDeptNo( String DeptNo)
{
    this->DeptNo = DeptNo;
}

void Department::SetDeptName( String DeptName)
{
    this->DeptName = DeptName;
}

void Department::SetCompanyNo( String CompanyNo)
{
    this->CompanyNo = CompanyNo;
}

void Department::sql_insert()
{
    try {
        int AffectedRec;
        String SQLStr = "insert into department values( '" + GetDeptNo() + "' , '";
        SQLStr += GetDeptName() + "' , '" + GetCompanyNo() + "')";
        pConnect->Execute( SQLStr, AffectedRec);
    }
    catch(...) {
    }
}

void Department::sql_update( String DeptName, String CompanyNo)
{
    try {
        int AffectedRec;
        String SQLStr = "update department set name = '" + DeptName + "', gscode = '";
        SQLStr += CompanyNo + "' where number = '" + GetDeptNo() + "'";
        pConnect->Execute( SQLStr, AffectedRec);
    }
    catch( ...) {
    }
}

void Department::sql_delete( String DeptNo)
{
    try {
        int AffectedRec;
        String SQLStr = "delete from department";
        SQLStr +=  " where number = '" + DeptNo + "'";
        pConnect->Execute( SQLStr, AffectedRec);
    }
    catch( ...) {
    }
}

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

        if( pQry->IsEmpty()) {
            DeptName = "";
            CompanyNo = "";
        }
        else {
            DeptNo= pQry->FieldByName( "name")->AsString;
            CompanyNo = pQry->FieldByName( "gscode")->AsString;
        }
    }
    catch( ...){
    }
}