#include "StdAfx.h"
|
#include "MBTNXXXObj.h"
|
#include "MBAttrValueMgr.h"
|
|
|
|
CMBTNXXXObj::CMBTNXXXObj(void)
|
{
|
RemoveAllAttr();
|
|
m_bDldFile = false;
|
}
|
|
|
CMBTNXXXObj::~CMBTNXXXObj(void)
|
{
|
RemoveAllAttr();
|
}
|
|
|
void CMBTNXXXObj::GetAttrVector( CMBTNXXXAttrVector &vectorAttr )
|
{
|
vectorAttr.clear();
|
vectorAttr = m_vectorAttr;
|
}
|
|
CMBTNXXXAttr *CMBTNXXXObj::GetAttr( CString strName )
|
{
|
if( strName.IsEmpty() )
|
return NULL;
|
|
CMBTNXXXAttrVector::iterator it;
|
CMBTNXXXAttr *pAttr = NULL;
|
|
for( it = m_vectorAttr.begin();it != m_vectorAttr.end();it++ )
|
{
|
pAttr = *it;
|
if( pAttr->m_strName == strName )
|
{
|
return pAttr;
|
}
|
}
|
|
return NULL;
|
}
|
|
bool CMBTNXXXObj::AddAttr( CMBTNXXXAttr *pAttr )
|
{
|
if( NULL == pAttr || pAttr->m_strName.IsEmpty() )
|
return false;
|
|
m_vectorAttr.push_back(pAttr);
|
|
return true;
|
}
|
|
bool CMBTNXXXObj::RemoveAllAttr()
|
{
|
CMBTNXXXAttrVector::iterator it;
|
CMBTNXXXAttr *pAttr = NULL;
|
|
for( it = m_vectorAttr.begin();it != m_vectorAttr.end();it++ )
|
{
|
pAttr = *it;
|
delete pAttr;
|
pAttr = NULL;
|
}
|
|
m_vectorAttr.clear();
|
|
return true;
|
}
|
|
// »ñÈ¡insert sql
|
CString CMBTNXXXObj::GetInsertSql( CString strTableName )
|
{
|
CString strSql,strFileds,strValues;
|
|
CMBTNXXXAttrVector::iterator it;
|
CMBTNXXXAttr *pAttr = NULL;
|
|
strFileds = _T("S_ID");
|
strFileds += _T(",");
|
|
strValues = _T("'") + m_strObjID + _T("'");
|
strValues += _T(",");
|
|
for( it = m_vectorAttr.begin();it != m_vectorAttr.end();it++ )
|
{
|
pAttr = *it;
|
strFileds += pAttr->m_strName;
|
strFileds += _T(",");
|
|
strValues += _T("'") + pAttr->m_strVaule + _T("'");
|
strValues += _T(",");
|
}
|
|
strFileds = strFileds.Left(strFileds.GetLength()-1);
|
strValues = strValues.Left(strValues.GetLength()-1);
|
|
strSql.Format(_T("insert into %s(%s) VALUES (%s)"),strTableName,strFileds,strValues);
|
return strSql;
|
}
|
|
CString CMBTNXXXObj::GetUpdateSql( CString strTableName )
|
{
|
CString strSql,strSetSql,strTmpSql,strFiled,strVaule,strTabLabel;
|
|
CMBTNXXXAttrVector::iterator it;
|
CMBTNXXXAttr *pAttr = NULL;
|
|
for( it = m_vectorAttr.begin();it != m_vectorAttr.end();it++ )
|
{
|
pAttr = *it;
|
|
strTabLabel = pAttr->m_strTabLable;
|
strTabLabel= strTabLabel.MakeUpper();
|
|
strFiled = pAttr->m_strName;
|
strVaule = pAttr->m_strVaule;
|
|
strTmpSql.Format(_T("%s=\"%s\","),strFiled,strVaule);
|
strSetSql += strTmpSql;
|
}
|
|
strSetSql = strSetSql.Left(strSetSql.GetLength()-1);
|
|
strSql.Format(_T("UPDATE %s SET %s where S_ID='%s'"),strTableName,strSetSql,m_strObjID);
|
return strSql;
|
}
|
|
|
CString CMBTNXXXObj::IsExsitSqlToSTb( CString strTableName )
|
{
|
CString strSql;
|
|
strSql.Format(_T("select * from %s where S_ID='%s'"),strTableName,m_strObjID);
|
return strSql;
|
}
|
|
|
|
|
CString CMBTNXXXObj::GetInsertSqlToSTb( CString strTableName )
|
{
|
CString strSql,strFileds,strValues,strTabLabel;
|
|
CMBTNXXXAttrVector::iterator it;
|
CMBTNXXXAttr *pAttr = NULL;
|
|
strFileds = _T("S_ID");
|
strFileds += _T(",");
|
|
strValues = _T("'") + m_strObjID + _T("'");
|
strValues += _T(",");
|
|
for( it = m_vectorAttr.begin();it != m_vectorAttr.end();it++ )
|
{
|
pAttr = *it;
|
|
strTabLabel = pAttr->m_strTabLable;
|
strTabLabel= strTabLabel.MakeUpper();
|
|
if( strTabLabel == _T("S") )
|
{
|
strFileds += pAttr->m_strName;
|
strFileds += _T(",");
|
|
strValues += _T("'") + pAttr->m_strVaule + _T("'");
|
strValues += _T(",");
|
}
|
}
|
|
strFileds = strFileds.Left(strFileds.GetLength()-1);
|
strValues = strValues.Left(strValues.GetLength()-1);
|
|
strSql.Format(_T("insert into %s(%s) VALUES (%s)"),strTableName,strFileds,strValues);
|
return strSql;
|
}
|
|
|
CString CMBTNXXXObj::GetUpdateSqlToSTb( CString strTableName )
|
{
|
CString strSql,strSetSql,strTmpSql,strFiled,strVaule,strTabLabel;
|
|
CMBTNXXXAttrVector::iterator it;
|
CMBTNXXXAttr *pAttr = NULL;
|
|
|
for( it = m_vectorAttr.begin();it != m_vectorAttr.end();it++ )
|
{
|
pAttr = *it;
|
|
strTabLabel = pAttr->m_strTabLable;
|
strTabLabel= strTabLabel.MakeUpper();
|
|
if( strTabLabel == _T("S") )
|
{
|
strFiled = pAttr->m_strName;
|
strVaule = pAttr->m_strVaule;
|
|
strTmpSql.Format(_T("%s=\"%s\","),strFiled,strVaule);
|
strSetSql += strTmpSql;
|
}
|
}
|
|
strSetSql = strSetSql.Left(strSetSql.GetLength()-1);
|
|
strSql.Format(_T("UPDATE %s SET %s where S_ID='%s'"),strTableName,strSetSql,m_strObjID);
|
return strSql;
|
}
|
|
|
CString CMBTNXXXObj::IsExsitSqlToMTb( CString strTableName )
|
{
|
CString strSql;
|
|
strSql.Format(_T("select * from %s where G_MASTER_OBJ_ID='%s' and G_SLAVE_OBJ_ID='%s'"),strTableName,m_strMID,m_strObjID);
|
|
return strSql;
|
}
|
|
CString CMBTNXXXObj::GetInsertSqlToMTb( CString strMAttrs,CString strTableName )
|
{
|
CString strTabLabel,strOrder,strEffect,strInvalidate,strDisplayName,strJoinTime;
|
CString strName,strVaule;
|
CString strSql,strFileds,strValues;
|
|
CMBTNXXXAttrVector::iterator it;
|
CMBTNXXXAttr *pAttr = NULL;
|
|
|
CMBAttrValueMgr *pAttrValueMgr = new CMBAttrValueMgr();
|
pAttrValueMgr->AddAttr( strMAttrs );
|
|
for( it = m_vectorAttr.begin();it != m_vectorAttr.end();it++ )
|
{
|
pAttr = *it;
|
|
strName = pAttr->m_strName;
|
strName = strName.MakeLower();
|
strName = strName.Trim();
|
|
strVaule = pAttr->m_strVaule;
|
|
strTabLabel = pAttr->m_strTabLable;
|
strTabLabel = strTabLabel.MakeUpper();
|
strTabLabel = strTabLabel.Trim();
|
|
if( strTabLabel == _T("C") )
|
{
|
if( strName == _T("order") )
|
{
|
strOrder = strVaule;
|
}
|
else if( strName == _T("effect") )
|
{
|
strEffect = strVaule;
|
}
|
else if( strName == _T("invalidate") )
|
{
|
strInvalidate = strVaule;
|
}
|
else if( strName == _T("displayname") )
|
{
|
strDisplayName = strVaule;
|
}
|
else if( strName == _T("jointime") )
|
{
|
strJoinTime = strVaule;
|
}
|
}
|
else if( strTabLabel == _T("M") )
|
{
|
pAttrValueMgr->AttachValue(pAttr->m_strName,pAttr->m_strVaule);
|
}
|
}
|
|
pAttrValueMgr->GetAttrs( strFileds,strValues );
|
|
strSql.Format(_T("insert into %s(G_MASTER_OBJ_ID,G_SLAVE_OBJ_ID,G_SLAVE_OBJ_VID,%s,C_Order,C_Effect,C_Invalidate,C_DisplayName,C_JoinTime) VALUES ('%s','%s','%s',%s,'%s','%s','%s','%s','%s')"),
|
strTableName,strFileds,m_strMID,m_strObjID,m_strSVID,strValues,strOrder,strEffect,strInvalidate,strDisplayName,strJoinTime);
|
|
MBSAFE_DELETE(pAttrValueMgr)
|
|
return strSql;
|
}
|
|
CString CMBTNXXXObj::GetUpdateSqlToMTb( CString strMAttrs,CString strTableName )
|
{
|
CString strTabLabel,strOrder,strEffect,strInvalidate,strDisplayName,strJoinTime;
|
CString strName,strVaule;
|
CString strSql,strFileds,strValues;
|
|
CMBTNXXXAttrVector::iterator it;
|
CMBTNXXXAttr *pAttr = NULL;
|
|
|
CMBAttrValueMgr *pAttrValueMgr = new CMBAttrValueMgr();
|
pAttrValueMgr->AddAttr( strMAttrs );
|
|
for( it = m_vectorAttr.begin();it != m_vectorAttr.end();it++ )
|
{
|
pAttr = *it;
|
|
strName = pAttr->m_strName;
|
strName = strName.MakeLower();
|
strName = strName.Trim();
|
|
strVaule = pAttr->m_strVaule;
|
|
strTabLabel = pAttr->m_strTabLable;
|
strTabLabel = strTabLabel.MakeUpper();
|
strTabLabel = strTabLabel.Trim();
|
|
if( strTabLabel == _T("C") )
|
{
|
if( strName == _T("order") )
|
{
|
strOrder = strVaule;
|
}
|
else if( strName == _T("effect") )
|
{
|
strEffect = strVaule;
|
}
|
else if( strName == _T("invalidate") )
|
{
|
strInvalidate = strVaule;
|
}
|
else if( strName == _T("displayname") )
|
{
|
strDisplayName = strVaule;
|
}
|
else if( strName == _T("jointime") )
|
{
|
strJoinTime = strVaule;
|
}
|
}
|
else if( strTabLabel == _T("M") )
|
{
|
pAttrValueMgr->AttachValue(pAttr->m_strName,pAttr->m_strVaule);
|
}
|
}
|
|
strFileds = pAttrValueMgr->GetAttrs( );
|
|
strSql.Format(_T("UPDATE %s SET %s,C_Order='%s',C_Effect='%s',C_Invalidate='%s',C_DisplayName='%s',C_JoinTime='%s' where G_MASTER_OBJ_ID='%s' and G_SLAVE_OBJ_ID='%s'"),strTableName,strFileds,strOrder,strEffect,strInvalidate,strDisplayName,strJoinTime,m_strMID,m_strObjID);
|
|
MBSAFE_DELETE(pAttrValueMgr)
|
|
return strSql;
|
}
|
