// DataOperator.cpp: implementation of the CDataOperator class. // ////////////////////////////////////////////////////////////////////// #include #include "geomative.h" #include "DataOperator.h" #include "navdataview.h" #include "Constant.h" #include "SaveInRes.h" #include "appdataproview.h" #include "appdatatzview.h" #include "appdatadevview.h" #include "appdatarsp2dtdview.h" #include "appdataipsp2dtdview.h" #include "appdatatdlistview.h" #include "appdatatzlistview.h" #include "appdataprolistview.h" #include "appdataprodetaillistview.h" #include "appdatatzdetaillistview.h" #include "appdatadevdetaillistview.h" #include "appdatatddetaillistview.h" #include "appdatarsp2dtdconlistview.h" #include "appdataipsp2dtdconlistview.h" #include "appdatatdgrlistview.h" #include "appdatarspcetdview.h" #include "appdatarspcetdconlistview.h" #include "AppDataIpsp3DTdConListView.h" #include "AppDataIpsp3DTdView.h" #include "AppDataRsp3DTdConListView.h" #include "AppDataRsp3DTdView.h" #include "AppDataIpspCETdConListView.h" #include "AppDataIpspCETdView.h" #include "AppDataSP2DTdConListView.h" #include "AppDataSP2DTdView.h" #include "AppDataSPCETdConListView_.h" #include "AppDataSPCETdView.h" #include "AppDataSP3DTdConListView.h" #include "AppDataSP3DTdView.h" #include "AppDataCESTdGrListView.h" #include "TdChannel.h" #include "DialCombine3DTask.h" #include "DetcGD10Dev.h" #include "FileOperTools.h" #ifdef _DEBUG #undef THIS_FILE static char THIS_FILE[]=__FILE__; #define new DEBUG_NEW #endif extern CGeoMativeApp theApp; ////////////////////////////////////////////////////////////////////// // Construction/Destruction ////////////////////////////////////////////////////////////////////// extern HHOOK hHook; extern LRESULT __stdcall CBTHookProc(long nCode, WPARAM wParam, LPARAM lParam); extern int g_iUILanguage; CDataOperator::CDataOperator(_ConnectionPtr& pConnection) { ASSERT(NULL != pConnection); m_pConnection = pConnection; } CDataOperator::~CDataOperator() { } //DEL bool CDataOperator::InitialNavDataProDlg(CNavDataProDlg& navDataProDlg) //DEL { //DEL _RecordsetPtr pRecPro = NULL; //DEL _RecordsetPtr pRecTz = NULL; //DEL _RecordsetPtr pRecTd = NULL; //DEL //DEL HTREEITEM hProItem = NULL; //DEL HTREEITEM hTzItem = NULL; //DEL HTREEITEM hTdItem = NULL; //DEL HTREEITEM hParentItem = NULL; //DEL //DEL DWORD dwHandle = (DWORD)VAL_ZERO; //DEL UINT uImageState = (UINT)VAL_ZERO; //DEL UINT uTdImageState = (UINT)VAL_ZERO; //DEL CString szSql = _T(""); //DEL //DEL CTreeCtrl& proTree = navDataProDlg.m_proTree; //DEL //DEL proTree.DeleteAllItems(); //DEL //DEL uImageState = m_stateProcessor.ChangeToImageState(PZ_STATE_DB); //DEL uTdImageState = m_stateProcessor.ChangeToImageState(PZ_STATE_LOC); //DEL //DEL pRecPro.CreateInstance(_uuidof(Recordset)); //DEL pRecTz.CreateInstance(_uuidof(Recordset)); //DEL pRecTd.CreateInstance(_uuidof(Recordset)); //DEL //DEL //DEL pRecPro->Open(_T("select ID,PRname,CN from project order by ID"), _variant_t((IDispatch*)m_pConnection, true), //DEL adOpenStatic, adLockOptimistic, adCmdText); //DEL //DEL while ((short)VAL_ZERO == pRecPro->adoEOF) //DEL { //DEL //DEL hProItem = proTree.InsertItem((LPCTSTR)(_bstr_t)pRecPro->GetCollect(_T("PRname"))); //DEL //DEL dwHandle = m_handleProcessor.GenerateHandle((DWORD)pRecPro->GetCollect(_T("ID")).ulVal, PZ_STYLE_PRO); //DEL proTree.SetItemData(hProItem, dwHandle); //DEL proTree.SetItemState(hProItem, uImageState, TVIS_STATEIMAGEMASK); //DEL //DEL szSql.Empty(); //DEL szSql.Format(_T("select ID,TZname from tz where PRID = %s order by ID" ), //DEL pRecPro->GetCollect(_T("ID")).vt == VT_NULL ? _T("-1") : (LPCTSTR)(_bstr_t)pRecPro->GetCollect(_T("ID"))); //DEL pRecTz->Open(szSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), //DEL adOpenStatic, adLockOptimistic, adCmdText); //DEL //DEL while ((short)VAL_ZERO == pRecTz->adoEOF) //DEL { //DEL hTzItem = proTree.InsertItem((pRecTz->GetCollect(_T("TZname")).vt == VT_NULL) ? _T("") : (LPCTSTR)(_bstr_t)pRecTz->GetCollect(_T("TZname")), hProItem); //DEL dwHandle = m_handleProcessor.GenerateHandle((DWORD)pRecTz->GetCollect(_T("ID")).ulVal, PZ_STYLE_TZ); //DEL proTree.SetItemData(hTzItem, dwHandle); //DEL proTree.SetItemState(hTzItem, uImageState, TVIS_STATEIMAGEMASK); //DEL //DEL szSql.Empty(); //DEL szSql.Format(_T("select ID,TDname,Ttype from td where TZID = %s order by ID"), //DEL pRecTz->GetCollect(_T("ID")).vt == VT_NULL ? _T("-1") : (LPCTSTR)(_bstr_t)pRecTz->GetCollect(_T("ID"))); //DEL pRecTd->Open(szSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), //DEL adOpenStatic, adLockOptimistic, adCmdText); //DEL //DEL while ((short)VAL_ZERO == pRecTd->adoEOF) //DEL { //DEL hTdItem = proTree.InsertItem(pRecTd->GetCollect(_T("TDname")).vt == VT_NULL ? _T("") : (LPCTSTR)(_bstr_t)pRecTd->GetCollect(_T("TDname")), hTzItem); //DEL //DEL switch (pRecTd->GetCollect(_T("Ttype")).iVal) //DEL { //DEL case 0: //DEL switch (pRecTd->GetCollect(_T("Stype")).iVal) //DEL { //DEL case 0: //DEL dwHandle = m_handleProcessor.GenerateHandle((DWORD)pRecTd->GetCollect(_T("ID")).ulVal, PZ_STYLE_TD_CERSP); //DEL break; //DEL case 1: //DEL dwHandle = m_handleProcessor.GenerateHandle((DWORD)pRecTd->GetCollect(_T("ID")).ulVal, PZ_STYLE_TD_2DRSP); //DEL break; //DEL case 2: //DEL dwHandle = m_handleProcessor.GenerateHandle((DWORD)pRecTd->GetCollect(_T("ID")).ulVal, PZ_STYLE_TD_3DRSP); //DEL break; //DEL default: //DEL break; //DEL //DEL } //DEL break; //DEL case 1: //DEL switch (pRecTd->GetCollect(_T("Stype")).iVal) //DEL { //DEL case 0: //DEL dwHandle = m_handleProcessor.GenerateHandle((DWORD)pRecTd->GetCollect(_T("ID")).ulVal, PZ_STYLE_TD_CEIPSP); //DEL break; //DEL case 1: //DEL dwHandle = m_handleProcessor.GenerateHandle((DWORD)pRecTd->GetCollect(_T("ID")).ulVal, PZ_STYLE_TD_2DIPSP); //DEL break; //DEL case 2: //DEL dwHandle = m_handleProcessor.GenerateHandle((DWORD)pRecTd->GetCollect(_T("ID")).ulVal, PZ_STYLE_TD_3DIPSP); //DEL break; //DEL default: //DEL break; //DEL } //DEL break; //DEL default: //DEL break; //DEL } //DEL proTree.SetItemData(hTdItem, dwHandle); //DEL proTree.SetItemState(hTdItem, uTdImageState, TVIS_STATEIMAGEMASK); //DEL //DEL pRecTd->MoveNext(); //DEL } //while (VAL_ZERO == pRecTd->adoEOF) //DEL pRecTd->Close(); //DEL hParentItem = proTree.GetParentItem(hTdItem); //DEL if (hParentItem != NULL) //DEL { //DEL proTree.Expand(hParentItem, TVE_EXPAND); //DEL hParentItem = NULL; //DEL } //if (hParentItem != NULL) //DEL //DEL pRecTz->MoveNext(); //DEL } //while (VAL_ZERO == pRecTz->adoEOF) //DEL pRecTz->Close(); //DEL //DEL hParentItem = proTree.GetParentItem(hTzItem); //DEL // ASSERT(hParentItem != NULL); //DEL if (hParentItem != NULL) //DEL { //DEL proTree.Expand(hParentItem, TVE_EXPAND); //DEL hParentItem = NULL; //DEL } //if (hParentItem != NULL) //DEL //DEL pRecPro->MoveNext(); //DEL } //while (VAL_ZERO == pRecPro->adoEOF) //DEL pRecPro->Close(); //DEL //DEL proTree.SelectSetFirstVisible(proTree.GetRootItem()); //DEL //DEL return true; //DEL } //DEL bool CDataOperator::InitialNavDataDevDlg(CNavDataDevDlg& navDataDevDlg) //DEL { //DEL _RecordsetPtr pRecDev = NULL; //DEL //DEL CString szSql; //DEL //DEL CTreeCtrl& devTree = navDataDevDlg.m_devTree; //DEL //DEL devTree.DeleteAllItems(); //DEL //DEL pRecDev.CreateInstance(_uuidof(Recordset)); //DEL //DEL pRecDev->Open(_T("select ID,DEname,SN from device order by ID"), _variant_t((IDispatch*)m_pConnection, true), //DEL adOpenStatic, adLockOptimistic, adCmdText); //DEL //DEL while ((short)VAL_ZERO == pRecDev->adoEOF) //DEL { //DEL InitialNavDataDevTree((DWORD)pRecDev->GetCollect(_T("ID")).ulVal, (LPCTSTR)(_bstr_t)pRecDev->GetCollect(_T("SN")), devTree); //DEL //DEL pRecDev->MoveNext(); //DEL } //while (VAL_ZERO == pRecDev->adoEOF) //DEL pRecDev->Close(); //DEL //DEL return true; //DEL } bool CDataOperator::InitialNavDataView(CNavDataView* pNavDataView) { _RecordsetPtr pRecPro = NULL; _RecordsetPtr pRecTz = NULL; _RecordsetPtr pRecTd = NULL; HTREEITEM hProItem = NULL; HTREEITEM hTzItem = NULL; HTREEITEM hTdItem = NULL; HTREEITEM hParentItem = NULL; DWORD dwHandle = (DWORD)VAL_ZERO; UINT uImageState = (UINT)VAL_ZERO; // UINT uTdImageState = (UINT)VAL_ZERO; CString szSql = _T(""); CTreeCtrl& dataTree = pNavDataView->m_dataTree; if (NULL != pNavDataView) { dataTree.DeleteAllItems(); uImageState = m_stateProcessor.ChangeToImageState(PZ_STATE_DB); // uTdImageState = m_stateProcessor.ChangeToImageState(PZ_STATE_DB); pRecPro.CreateInstance(_uuidof(Recordset)); pRecTz.CreateInstance(_uuidof(Recordset)); pRecTd.CreateInstance(_uuidof(Recordset)); pRecPro->Open(_T("select ID,PRname,CN from project order by ID"), _variant_t((IDispatch*)m_pConnection, true), adOpenStatic, adLockOptimistic, adCmdText); while ((short)VAL_ZERO == pRecPro->adoEOF) { hProItem = dataTree.InsertItem((LPCTSTR)(_bstr_t)pRecPro->GetCollect(_T("PRname"))); dwHandle = m_handleProcessor.GenerateHandle((DWORD)pRecPro->GetCollect(_T("ID")).ulVal, PZ_STYLE_PRO); dataTree.SetItemData(hProItem, dwHandle); dataTree.SetItemState(hProItem, uImageState, TVIS_STATEIMAGEMASK); szSql.Empty(); szSql.Format(_T("select ID,TZname from tz where PRID = %s order by ID" ), pRecPro->GetCollect(_T("ID")).vt == VT_NULL ? _T("-1") : (LPCTSTR)(_bstr_t)pRecPro->GetCollect(_T("ID"))); pRecTz->Open(szSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), adOpenStatic, adLockOptimistic, adCmdText); //如果查询不到默认测区，则报错，并进行下一个工程的显示 if ((long)VAL_ZERO == pRecTz->GetRecordCount()) { CString strPrName = (LPCTSTR)(_bstr_t)pRecPro->GetCollect(_T("PRname")); AfxMessageBox(_T("data missing in") + strPrName); pRecTz->Close(); pRecPro->MoveNext(); continue; } //默认取第一个测区的ID int iTzID = (VT_NULL == pRecTz->GetCollect(_T("ID")).vt) ? -1 : pRecTz->GetCollect(_T("ID")).lVal; pRecTz->Close(); szSql.Empty(); szSql.Format(_T("select ID,TDname,Ttype,Stype from td where TZID = %d order by ID"), iTzID); pRecTd->Open(szSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), adOpenStatic, adLockOptimistic, adCmdText); while ((short)VAL_ZERO == pRecTd->adoEOF) { hTdItem = dataTree.InsertItem(pRecTd->GetCollect(_T("TDname")).vt == VT_NULL ? _T("") : (LPCTSTR)(_bstr_t)pRecTd->GetCollect(_T("TDname")), hProItem); switch (pRecTd->GetCollect(_T("Ttype")).iVal) { case 0: switch (pRecTd->GetCollect(_T("Stype")).iVal) { case 0: dwHandle = m_handleProcessor.GenerateHandle((DWORD)pRecTd->GetCollect(_T("ID")).ulVal, PZ_STYLE_TD_CERSP); break; case 1: dwHandle = m_handleProcessor.GenerateHandle((DWORD)pRecTd->GetCollect(_T("ID")).ulVal, PZ_STYLE_TD_2DRSP); break; case 2: dwHandle = m_handleProcessor.GenerateHandle((DWORD)pRecTd->GetCollect(_T("ID")).ulVal, PZ_STYLE_TD_3DRSP); break; default: break; } break; case 1: switch (pRecTd->GetCollect(_T("Stype")).iVal) { case 0: dwHandle = m_handleProcessor.GenerateHandle((DWORD)pRecTd->GetCollect(_T("ID")).ulVal, PZ_STYLE_TD_CEIPSP); break; case 1: dwHandle = m_handleProcessor.GenerateHandle((DWORD)pRecTd->GetCollect(_T("ID")).ulVal, PZ_STYLE_TD_2DIPSP); break; case 2: dwHandle = m_handleProcessor.GenerateHandle((DWORD)pRecTd->GetCollect(_T("ID")).ulVal, PZ_STYLE_TD_3DIPSP); break; default: break; } break; case 2://自电 switch (pRecTd->GetCollect(_T("Stype")).iVal) { case 0: dwHandle = m_handleProcessor.GenerateHandle((DWORD)pRecTd->GetCollect(_T("ID")).ulVal, PZ_STYLE_TD_CESP); break; case 1: dwHandle = m_handleProcessor.GenerateHandle((DWORD)pRecTd->GetCollect(_T("ID")).ulVal, PZ_STYLE_TD_2DSP); break; case 2: dwHandle = m_handleProcessor.GenerateHandle((DWORD)pRecTd->GetCollect(_T("ID")).ulVal, PZ_STYLE_TD_3DSP); break; default: break; } break; default: break; } dataTree.SetItemData(hTdItem, dwHandle); dataTree.SetItemState(hTdItem, uImageState, TVIS_STATEIMAGEMASK); pRecTd->MoveNext(); } pRecTd->Close(); hParentItem = dataTree.GetParentItem(hTdItem); if (hParentItem != NULL) { dataTree.Expand(hParentItem, TVE_EXPAND); hParentItem = NULL; } ////////////////////////////////////////////////////////////////////////// /*删除中间的测区这一层 while ((short)VAL_ZERO == pRecTz->adoEOF) { hTzItem = dataTree.InsertItem((pRecTz->GetCollect(_T("TZname")).vt == VT_NULL) ? _T("") : (LPCTSTR)(_bstr_t)pRecTz->GetCollect(_T("TZname")), hProItem); dwHandle = m_handleProcessor.GenerateHandle((DWORD)pRecTz->GetCollect(_T("ID")).ulVal, PZ_STYLE_TZ); dataTree.SetItemData(hTzItem, dwHandle); dataTree.SetItemState(hTzItem, uImageState, TVIS_STATEIMAGEMASK); szSql.Empty(); szSql.Format(_T("select ID,TDname,Ttype,Stype from td where TZID = %s order by ID"), pRecTz->GetCollect(_T("ID")).vt == VT_NULL ? _T("-1") : (LPCTSTR)(_bstr_t)pRecTz->GetCollect(_T("ID"))); pRecTd->Open(szSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), adOpenStatic, adLockOptimistic, adCmdText); while ((short)VAL_ZERO == pRecTd->adoEOF) { hTdItem = dataTree.InsertItem(pRecTd->GetCollect(_T("TDname")).vt == VT_NULL ? _T("") : (LPCTSTR)(_bstr_t)pRecTd->GetCollect(_T("TDname")), hTzItem); switch (pRecTd->GetCollect(_T("Ttype")).iVal) { case 0: switch (pRecTd->GetCollect(_T("Stype")).iVal) { case 0: dwHandle = m_handleProcessor.GenerateHandle((DWORD)pRecTd->GetCollect(_T("ID")).ulVal, PZ_STYLE_TD_CERSP); break; case 1: dwHandle = m_handleProcessor.GenerateHandle((DWORD)pRecTd->GetCollect(_T("ID")).ulVal, PZ_STYLE_TD_2DRSP); break; case 2: dwHandle = m_handleProcessor.GenerateHandle((DWORD)pRecTd->GetCollect(_T("ID")).ulVal, PZ_STYLE_TD_3DRSP); break; default: break; } break; case 1: switch (pRecTd->GetCollect(_T("Stype")).iVal) { case 0: dwHandle = m_handleProcessor.GenerateHandle((DWORD)pRecTd->GetCollect(_T("ID")).ulVal, PZ_STYLE_TD_CEIPSP); break; case 1: dwHandle = m_handleProcessor.GenerateHandle((DWORD)pRecTd->GetCollect(_T("ID")).ulVal, PZ_STYLE_TD_2DIPSP); break; case 2: dwHandle = m_handleProcessor.GenerateHandle((DWORD)pRecTd->GetCollect(_T("ID")).ulVal, PZ_STYLE_TD_3DIPSP); break; default: break; } break; case 2://自电 switch (pRecTd->GetCollect(_T("Stype")).iVal) { case 0: dwHandle = m_handleProcessor.GenerateHandle((DWORD)pRecTd->GetCollect(_T("ID")).ulVal, PZ_STYLE_TD_CESP); break; case 1: dwHandle = m_handleProcessor.GenerateHandle((DWORD)pRecTd->GetCollect(_T("ID")).ulVal, PZ_STYLE_TD_2DSP); break; case 2: dwHandle = m_handleProcessor.GenerateHandle((DWORD)pRecTd->GetCollect(_T("ID")).ulVal, PZ_STYLE_TD_3DSP); break; default: break; } break; default: break; } dataTree.SetItemData(hTdItem, dwHandle); dataTree.SetItemState(hTdItem, uImageState, TVIS_STATEIMAGEMASK); pRecTd->MoveNext(); } pRecTd->Close(); hParentItem = dataTree.GetParentItem(hTdItem); if (hParentItem != NULL) { dataTree.Expand(hParentItem, TVE_EXPAND); hParentItem = NULL; } pRecTz->MoveNext(); } pRecTz->Close(); hParentItem = dataTree.GetParentItem(hTzItem); if (hParentItem != NULL) { dataTree.Expand(hParentItem, TVE_EXPAND); hParentItem = NULL; } */ pRecPro->MoveNext(); } pRecPro->Close(); dataTree.SelectSetFirstVisible(dataTree.GetRootItem()); } else { return false; } return true; } void CDataOperator::ShowProjectInfo(DWORD dwProHandle, CView *pAppDataView) { theApp.m_pProManager->GetDMS(dwProHandle)->ShowDetailInfo(((CAppDataProDetailListView*)(((CAppDataProView*)pAppDataView)->m_pDetailListView))->GetListCtrl()); theApp.m_pTdManager->ShowTdListByProject(dwProHandle, ((CAppDataTdListView*)(((CAppDataProView*)pAppDataView)->m_pContentListView))->GetListCtrl()); // theApp.m_pProManager->ShowTzList(dwProHandle, ((CAppDataTzListView*)(((CAppDataProView*)pAppDataView)->m_pContentListView))->GetListCtrl()); } void CDataOperator::ShowTzInfo(DWORD dwTzHandle, CView *pAppDataView) { theApp.m_pProManager->GetDMS(dwTzHandle)->ShowDetailInfo(((CAppDataTzDetailListView*)(((CAppDataTzView*)pAppDataView)->m_pDetailListView))->GetListCtrl()); theApp.m_pTdManager->ShowTdListByTz(dwTzHandle, ((CAppDataTdListView*)(((CAppDataTzView*)pAppDataView)->m_pContentListView))->GetListCtrl()); } //DEL void CDataOperator::ShowProjectInfoByDevTab(DWORD dwProHandle, DWORD dwDevHandle, CView *pAppDataView) //DEL { //DEL theApp.m_pProManager->GetDMS(dwProHandle)->ShowDetailInfo(((CAppDataProDetailListView*)(((CAppDataProView*)pAppDataView)->m_pDetailListView))->GetListCtrl()); //DEL theApp.m_pProManager->ShowTzList(dwProHandle, ((CAppDataTzListView*)(((CAppDataProView*)pAppDataView)->m_pContentListView))->GetListCtrl()); //DEL } void CDataOperator::ShowRsp3DTdInfo(DWORD dwTdHandle, CView *pAppDataView) { theApp.m_pTdManager->GetTestingData(dwTdHandle)->ShowDetailInfo(((CAppDataTdDetailListView*)(((CAppDataRsp3DTdView*)pAppDataView)->m_pDetailListView))->GetListCtrl()); theApp.m_pTdManager->GetTestingData(dwTdHandle)->ShowConList(((CAppDataRsp3DTdConListView*)(((CAppDataRsp3DTdView*)pAppDataView)->m_pContentListView))->GetListCtrl()); theApp.m_pTdManager->GetTestingData(dwTdHandle)->ShowGrList(((CAppDataTdGrListView*)(((CAppDataRsp3DTdView*)pAppDataView)->m_pGrListView))->GetListCtrl()); } void CDataOperator::ShowRsp2DTdInfo(DWORD dwTdHandle, CView *pAppDataView) { theApp.m_pTdManager->GetTestingData(dwTdHandle)->ShowDetailInfo(((CAppDataTdDetailListView*)(((CAppDataRsp2DTdView*)pAppDataView)->m_pDetailListView))->GetListCtrl()); theApp.m_pTdManager->GetTestingData(dwTdHandle)->ShowConList(((CAppDataRsp2DTdConListView*)(((CAppDataRsp2DTdView*)pAppDataView)->m_pContentListView))->GetListCtrl()); theApp.m_pTdManager->GetTestingData(dwTdHandle)->ShowGrList(((CAppDataTdGrListView*)(((CAppDataRsp2DTdView*)pAppDataView)->m_pGrListView))->GetListCtrl()); } void CDataOperator::ShowRspCETdInfo(DWORD dwTdHandle, CView* pAppDataView) { theApp.m_pTdManager->GetTestingData(dwTdHandle)->ShowDetailInfo(((CListView*)(((CAppDataRspCETdView*)pAppDataView)->m_pDetailListView))->GetListCtrl()); // theApp.m_pTdManager->GetTestingData(dwTdHandle)->ShowDetailInfo(((CAppDataRspCETdView*)pAppDataView)->m_pDetailListView->GetListCtrl()); theApp.m_pTdManager->GetTestingData(dwTdHandle)->ShowConList(((CAppDataRspCETdConListView*)(((CAppDataRspCETdView*)pAppDataView)->m_pContentListView))->GetListCtrl()); theApp.m_pTdManager->GetTestingData(dwTdHandle)->ShowGrList(((CAppDataCESTdGrListView*)(((CAppDataRspCETdView*)pAppDataView)->m_pGrListView))->GetListCtrl()); } void CDataOperator::LoadRspCERecordbyPage(DWORD dwTdHandle, CView *pAppDataView, int iSType) { theApp.m_pTdManager->GetTestingData(dwTdHandle)->ShowConListByPage(((CAppDataRspCETdConListView*)(((CAppDataRspCETdView*)pAppDataView)->m_pContentListView))->GetListCtrl(), iSType); } void CDataOperator::LoadRsp2dRecordbyPage(DWORD dwTdHandle, CView *pAppDataView, int iSType) { theApp.m_pTdManager->GetTestingData(dwTdHandle)->ShowConListByPage(((CAppDataRsp2DTdConListView*)(((CAppDataRsp2DTdView*)pAppDataView)->m_pContentListView))->GetListCtrl(), iSType); } void CDataOperator::LoadRsp3dRecordbyPage(DWORD dwTdHandle, CView *pAppDataView, int iSType) { theApp.m_pTdManager->GetTestingData(dwTdHandle)->ShowConListByPage(((CAppDataRsp3DTdConListView*)(((CAppDataRsp3DTdView*)pAppDataView)->m_pContentListView))->GetListCtrl(), iSType); } void CDataOperator::ShowIps2DpTdInfo(DWORD dwTdHandle, CView *pAppDataView) { CTestingData* pTestingData = theApp.m_pTdManager->GetTestingData(dwTdHandle); if (pTestingData == NULL) { ASSERT(pTestingData != NULL); return; } CAppDataIpsp2DTdView* pDataView = (CAppDataIpsp2DTdView*)pAppDataView; if (pDataView == NULL) { ASSERT(pDataView != NULL); return; } CAppDataTdDetailListView* pDetailListView = (CAppDataTdDetailListView*)pDataView->m_pDetailListView; if (pDetailListView == NULL) { ASSERT(pDetailListView != NULL); return; } pTestingData->ShowDetailInfo(pDetailListView->GetListCtrl()); CAppDataIpsp2DTdConListView* pContentListView = (CAppDataIpsp2DTdConListView*)pDataView->m_pContentListView; if (pContentListView == NULL) { ASSERT(pContentListView != NULL); return; } pTestingData->ShowConList(pContentListView->GetListCtrl()); CAppDataTdGrListView* pGrListView = (CAppDataTdGrListView*)pDataView->m_pGrListView; if (pGrListView == NULL) { ASSERT(pGrListView != NULL); return; } pTestingData->ShowGrList(pGrListView->GetListCtrl()); } void CDataOperator::ShowIps3DpTdInfo(DWORD dwTdHandle, CView *pAppDataView) { theApp.m_pTdManager->GetTestingData(dwTdHandle)->ShowDetailInfo(((CAppDataTdDetailListView*)(((CAppDataIpsp3DTdView*)pAppDataView)->m_pDetailListView))->GetListCtrl()); theApp.m_pTdManager->GetTestingData(dwTdHandle)->ShowConList(((CAppDataIpsp3DTdConListView*)(((CAppDataIpsp3DTdView*)pAppDataView)->m_pContentListView))->GetListCtrl()); theApp.m_pTdManager->GetTestingData(dwTdHandle)->ShowGrList(((CAppDataTdGrListView*)(((CAppDataIpsp3DTdView*)pAppDataView)->m_pGrListView))->GetListCtrl()); } void CDataOperator::ShowIpsCEpTdInfo(DWORD dwTdHandle, CView *pAppDataView) { theApp.m_pTdManager->GetTestingData(dwTdHandle)->ShowDetailInfo(((CAppDataTdDetailListView*)(((CAppDataIpspCETdView*)pAppDataView)->m_pDetailListView))->GetListCtrl()); // theApp.m_pTdManager->GetTestingData(dwTdHandle)->ShowConList(((CAppDataRspCETdConListView*)(((CAppDataIpspCETdView*)pAppDataView)->m_pContentListView))->GetListCtrl()); theApp.m_pTdManager->GetTestingData(dwTdHandle)->ShowConList(((CAppDataIpspCETdConListView*)(((CAppDataIpspCETdView*)pAppDataView)->m_pContentListView))->GetListCtrl()); theApp.m_pTdManager->GetTestingData(dwTdHandle)->ShowGrList(((CAppDataCESTdGrListView*)(((CAppDataIpspCETdView*)pAppDataView)->m_pGrListView))->GetListCtrl()); } void CDataOperator::LoadIpspCERecordbyPage(DWORD dwTdHandle, CView *pAppDataView, int iSType/* = 1*/) { theApp.m_pTdManager->GetTestingData(dwTdHandle)->ShowConListByPage(((CAppDataIpspCETdConListView*)(((CAppDataIpspCETdView*)pAppDataView)->m_pContentListView))->GetListCtrl(), iSType); } void CDataOperator::LoadIpsp2dRecordbyPage(DWORD dwTdHandle, CView *pAppDataView, int iSType/* = 2*/) { theApp.m_pTdManager->GetTestingData(dwTdHandle)->ShowConListByPage(((CAppDataIpsp2DTdConListView*)(((CAppDataIpsp2DTdView*)pAppDataView)->m_pContentListView))->GetListCtrl(), iSType); } void CDataOperator::LoadIpsp3dRecordbyPage(DWORD dwTdHandle, CView *pAppDataView, int iSType/* = 3*/) { theApp.m_pTdManager->GetTestingData(dwTdHandle)->ShowConListByPage(((CAppDataIpsp3DTdConListView*)(((CAppDataIpsp3DTdView*)pAppDataView)->m_pContentListView))->GetListCtrl(), iSType); } //DEL void CDataOperator::ShowDevInfoInDataMng(DWORD dwDevHandle, CView *pAppDataView) //DEL { //DEL DWORD dwDevID = (DWORD)VAL_ZERO; //DEL dwDevID = this->m_handleProcessor.GetIDFromHandle(dwDevHandle); //DEL theApp.m_pDevManager->GetDeviceByID(dwDevID)->ShowDetailInfo(((CAppDataDevDetailListView*)(((CAppDataDevView*)pAppDataView)->m_pDetailListView))->GetListCtrl()); //DEL theApp.m_pProManager->ShowProList(dwDevHandle, ((CAppDataProListView*)(((CAppDataDevView*)pAppDataView)->m_pContentListView))->GetListCtrl()); //DEL } UINT CDataOperator::CreateProjectInDB(CNavDataView* pNavDataView) { HTREEITEM hProItem = NULL; _RecordsetPtr pRecPro = NULL; DWORD dwHandle = (DWORD)VAL_ZERO; DWORD dwID = (DWORD)VAL_ZERO; UINT uImageState = (UINT)VAL_ZERO; UINT uExecCode = (UINT)VAL_ZERO; CString szSql = _T(""); pRecPro.CreateInstance(_uuidof(Recordset)); try { m_pConnection->BeginTrans(); uExecCode = theApp.m_pProManager->CreateProjectInDB(dwID); if (APP_SUCCESS == uExecCode) { szSql.Empty(); szSql.Format(_T("select PRname from project where ID = %u"), dwID); pRecPro->Open(szSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), adOpenStatic, adLockOptimistic, adCmdText); if ((long)VAL_ZERO != pRecPro->GetRecordCount()) { hProItem = pNavDataView->m_dataTree.InsertItem((LPCTSTR)(_bstr_t)pRecPro->GetCollect(_T("PRname"))); dwHandle = m_handleProcessor.GenerateHandle(dwID, PZ_STYLE_PRO); pNavDataView->m_dataTree.SetItemData(hProItem, dwHandle); uImageState = m_stateProcessor.ChangeToImageState(PZ_STATE_DB); pNavDataView->m_dataTree.SetItemState(hProItem, uImageState, TVIS_STATEIMAGEMASK); pNavDataView->m_dataTree.SelectItem(hProItem); } pRecPro->Close(); m_pConnection->CommitTrans(); } else { m_pConnection->RollbackTrans(); } } catch (_com_error e) { m_pConnection->RollbackTrans(); return APP_ERR_DB; } return uExecCode; } //DEL UINT CDataOperator::CreateProjectInLoc(CNavDataView* pNavDataView) //DEL { //DEL HTREEITEM hProItem = NULL; //DEL HTREEITEM hPreItem = NULL; //DEL HTREEITEM hCurItem = NULL; //DEL //DEL _RecordsetPtr pRecPro = NULL; //DEL DWORD dwHandle = (DWORD)VAL_ZERO; //DEL DWORD dwDevHandle = (DWORD)VAL_ZERO; //DEL DWORD dwID = (DWORD)VAL_ZERO; //DEL DWORD dwDevID = (DWORD)VAL_ZERO; //DEL UINT uImageState = (UINT)VAL_ZERO; //DEL UINT uExecCode = (UINT)VAL_ZERO; //DEL //DEL CString szSql = _T(""); //DEL /* //DEL pRecPro.CreateInstance(_uuidof(Recordset)); //DEL //DEL m_pConnection->BeginTrans(); //DEL //DEL try //DEL { //DEL uExecCode = theApp.m_pProManager->CreateProjectInDB(dwID); //DEL if ((APP_SUCCESS == uExecCode) || (APP_DUPLICATE == uExecCode)) //DEL { //DEL hCurItem = pNavDataView->m_navDevDlg.m_devTree.GetSelectedItem(); //DEL //DEL while (NULL != hCurItem) //DEL { //DEL hPreItem = hCurItem; //DEL hCurItem = pNavDataView->m_navDevDlg.m_devTree.GetParentItem(hCurItem); //DEL } //DEL //DEL dwDevHandle = pNavDataView->m_navDevDlg.m_devTree.GetItemData(hPreItem); //DEL dwDevID = m_handleProcessor.GetIDFromHandle(dwDevHandle); //DEL uExecCode = theApp.m_pProManager->CreateProjectInLoc(dwID, dwDevID); //DEL //DEL if (APP_SUCCESS == uExecCode) //DEL { //DEL szSql.Empty(); //DEL szSql.Format(_T("select PRname,CN from project where ID = %u"), dwID); //DEL pRecPro->Open(szSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), //DEL adOpenStatic, adLockOptimistic, adCmdText); //DEL //DEL if ((long)VAL_ZERO != pRecPro->GetRecordCount()) //DEL { //DEL hProItem = pNavDataView->m_navDevDlg.m_devTree.InsertItem((LPCTSTR)(_bstr_t)pRecPro->GetCollect(_T("PRname")), hPreItem); //DEL //DEL dwHandle = m_handleProcessor.GenerateHandle(dwID, PZ_STYLE_PRO); //DEL pNavDataView->m_navDevDlg.m_devTree.SetItemData(hProItem, dwHandle); //DEL //DEL uImageState = m_stateProcessor.ChangeToImageState(PZ_STATE_LOC); //DEL pNavDataView->m_navDevDlg.m_devTree.SetItemState(hProItem, uImageState, TVIS_STATEIMAGEMASK); //DEL pNavDataView->m_navDevDlg.m_devTree.SelectItem(hProItem); //DEL } //DEL pRecPro->Close(); //DEL } //DEL else //DEL { //DEL m_pConnection->RollbackTrans(); //DEL return uExecCode; //DEL } //DEL } //DEL else //DEL { //DEL m_pConnection->RollbackTrans(); //DEL return uExecCode; //DEL } //DEL } //DEL catch (_com_error e) //DEL { //DEL m_pConnection->RollbackTrans(); //DEL return APP_ERR_DB; //DEL } //DEL //DEL m_pConnection->CommitTrans(); //DEL InitialNavDataProDlg(pNavDataView->m_navProDlg); //DEL */ //DEL return uExecCode; //DEL } DWORD CDataOperator::GetTdIdFromNavDataView(CNavDataView *pNavDataView) { HTREEITEM hTdItem = NULL; HTREEITEM hTzItem = NULL; DWORD dwTdHandle = (DWORD)VAL_ZERO; DWORD dwTdID = (DWORD)VAL_ZERO; hTdItem = pNavDataView->m_dataTree.GetSelectedItem(); hTzItem = pNavDataView->m_dataTree.GetParentItem(hTdItem); dwTdHandle = pNavDataView->m_dataTree.GetItemData(hTdItem); return m_handleProcessor.GetIDFromHandle(dwTdHandle); } void CDataOperator::UpdateNavDataViewAfterDel(CNavDataView *pNavDataView) { HTREEITEM hTdItem = pNavDataView->m_dataTree.GetSelectedItem(); HTREEITEM hTzItem = pNavDataView->m_dataTree.GetParentItem(hTdItem); pNavDataView->m_dataTree.DeleteItem(hTdItem); pNavDataView->m_dataTree.SelectItem(NULL); pNavDataView->m_dataTree.SelectItem(hTzItem); } UINT CDataOperator::DeleteProjectInDB(CNavDataView* pNavDataView) { _RecordsetPtr pRecProID = NULL; _RecordsetPtr pRecTzList = NULL; _RecordsetPtr pRecTdList = NULL; DWORD dwHandle = (DWORD)VAL_ZERO; DWORD dwID = (DWORD)VAL_ZERO; DWORD dwTzID = (DWORD)VAL_ZERO; DWORD dwTdID = (DWORD)VAL_ZERO; CString szSql = _T(""); dwHandle = pNavDataView->m_dataTree.GetItemData(pNavDataView->m_dataTree.GetSelectedItem()); dwID = m_handleProcessor.GetIDFromHandle(dwHandle); pRecProID.CreateInstance(_uuidof(Recordset)); pRecTzList.CreateInstance(_uuidof(Recordset)); pRecTdList.CreateInstance(_uuidof(Recordset)); m_pConnection->BeginTrans(); try { szSql.Empty(); szSql.Format(_T("select ID from tz where PRID = %u"), dwID); pRecTzList->Open(szSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), adOpenStatic, adLockOptimistic, adCmdText); while ((short)VAL_ZERO == pRecTzList->adoEOF) { dwTzID = pRecTzList->GetCollect(_T("ID")).ulVal; szSql.Empty(); szSql.Format(_T("select ID,Ttype,Stype from td where TZID = %u"), dwTzID); pRecTdList->Open(szSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), adOpenStatic, adLockOptimistic, adCmdText); /* while ((short)VAL_ZERO == pRecTdList->adoEOF) { dwTdID = pRecTdList->GetCollect(_T("ID")).ulVal; switch (pRecTdList->GetCollect(_T("Ttype")).iVal) { case 0: theApp.m_pTdManager->DeleteRspTd(dwTdID); theApp.m_pTdManager->DeleteObjInMem(m_handleProcessor.GenerateHandle(dwTdID, PZ_STYLE_TD_RSP)); break; case 1: theApp.m_pTdManager->DeleteIpspTd(dwTdID); theApp.m_pTdManager->DeleteObjInMem(m_handleProcessor.GenerateHandle(dwTdID, PZ_STYLE_TD_IPSP)); break; default: break; } pRecTdList->MoveNext(); } pRecTdList->Close(); */ //Ttype，0:电阻率 1：激电 2:自电 //Stype,0:一维 1：二维 2:三维 while ((short)VAL_ZERO == pRecTdList->adoEOF) { dwTdID = pRecTdList->GetCollect(_T("ID")).ulVal; switch (pRecTdList->GetCollect(_T("Ttype")).iVal) { case 0: switch (pRecTdList->GetCollect(_T("Stype")).iVal) { case 0: theApp.m_pTdManager->DeleteRspCETd(dwTdID); theApp.m_pTdManager->DeleteObjInMem(m_handleProcessor.GenerateHandle(dwTdID, PZ_STYLE_TD_CERSP)); break; case 1: theApp.m_pTdManager->DeleteRsp2DTd(dwTdID); theApp.m_pTdManager->DeleteObjInMem(m_handleProcessor.GenerateHandle(dwTdID, PZ_STYLE_TD_2DRSP)); break; case 2: theApp.m_pTdManager->DeleteRsp3DTd(dwTdID); theApp.m_pTdManager->DeleteObjInMem(m_handleProcessor.GenerateHandle(dwTdID, PZ_STYLE_TD_3DRSP)); break; default: break; } break; case 1: switch (pRecTdList->GetCollect(_T("Stype")).iVal) { case 0: theApp.m_pTdManager->DeleteIpspCETd(dwTdID); theApp.m_pTdManager->DeleteObjInMem(m_handleProcessor.GenerateHandle(dwTdID, PZ_STYLE_TD_CEIPSP)); break; case 1: theApp.m_pTdManager->DeleteIpsp2DTd(dwTdID); theApp.m_pTdManager->DeleteObjInMem(m_handleProcessor.GenerateHandle(dwTdID, PZ_STYLE_TD_2DIPSP)); break; case 2: theApp.m_pTdManager->DeleteIpsp3DTd(dwTdID); theApp.m_pTdManager->DeleteObjInMem(m_handleProcessor.GenerateHandle(dwTdID, PZ_STYLE_TD_3DIPSP)); break; default: break; } break; case 2: switch (pRecTdList->GetCollect(_T("Stype")).iVal) { case 0: theApp.m_pTdManager->DeleteSPCETd(dwTdID); theApp.m_pTdManager->DeleteObjInMem(m_handleProcessor.GenerateHandle(dwTdID, PZ_STYLE_TD_CESP)); break; case 1: theApp.m_pTdManager->DeleteSP2DTd(dwTdID); theApp.m_pTdManager->DeleteObjInMem(m_handleProcessor.GenerateHandle(dwTdID, PZ_STYLE_TD_2DSP)); break; case 2: theApp.m_pTdManager->DeleteSP3DTd(dwTdID); theApp.m_pTdManager->DeleteObjInMem(m_handleProcessor.GenerateHandle(dwTdID, PZ_STYLE_TD_3DSP)); break; default: break; } break; default: break; } pRecTdList->MoveNext(); } pRecTdList->Close(); theApp.m_pProManager->DeleteTzInDB(dwTzID); theApp.m_pProManager->DeleteObjInMem(m_handleProcessor.GenerateHandle(dwTzID, PZ_STYLE_TZ)); pRecTzList->MoveNext(); } pRecTzList->Close(); theApp.m_pProManager->DeleteProjectInDB(dwID); theApp.m_pProManager->DeleteObjInMem(dwHandle); } catch (_com_error e) { m_pConnection->RollbackTrans(); return APP_ERR_DB; } m_pConnection->CommitTrans(); // InitialNavDataView(pNavDataView); pNavDataView->m_dataTree.DeleteItem(pNavDataView->m_dataTree.GetSelectedItem()); pNavDataView->m_dataTree.SelectItem(NULL); return APP_SUCCESS; } //DEL UINT CDataOperator::DeleteProjectInLoc(CNavDataView* pNavDataView) //DEL { //DEL UINT uExecCode = (UINT)VAL_ZERO; //DEL bool bIsDelTd = false; //DEL //DEL HTREEITEM hProItem = NULL; //DEL HTREEITEM hPreItem = NULL; //DEL HTREEITEM hCurItem = NULL; //DEL //DEL _RecordsetPtr pRecPro = NULL; //DEL _RecordsetPtr pRecTz = NULL; //DEL //DEL _RecordsetPtr pRecTzList = NULL; //DEL _RecordsetPtr pRecTdList = NULL; //DEL //DEL DWORD dwHandle = (DWORD)VAL_ZERO; //DEL DWORD dwID = (DWORD)VAL_ZERO; //DEL //DEL DWORD dwDevHandle = (DWORD)VAL_ZERO; //DEL DWORD dwDevID = (DWORD)VAL_ZERO; //DEL //DEL DWORD dwTdID = (DWORD)VAL_ZERO; //DEL CString szSql = _T(""); //DEL CString szCaption = _T(""); //DEL /* //DEL dwHandle = pNavDataView->m_navDevDlg.m_devTree.GetItemData(pNavDataView->m_navDevDlg.m_devTree.GetSelectedItem()); //DEL dwID = m_handleProcessor.GetIDFromHandle(dwHandle); //DEL //DEL hProItem = pNavDataView->m_navDevDlg.m_devTree.GetSelectedItem(); //DEL hCurItem = hProItem; //DEL //DEL while (NULL != hCurItem) //DEL { //DEL hPreItem = hCurItem; //DEL hCurItem = pNavDataView->m_navDevDlg.m_devTree.GetParentItem(hCurItem); //DEL } //DEL //DEL dwDevHandle = pNavDataView->m_navDevDlg.m_devTree.GetItemData(hPreItem); //DEL dwDevID = m_handleProcessor.GetIDFromHandle(dwDevHandle); //DEL //DEL pRecPro.CreateInstance(_uuidof(Recordset)); //DEL pRecTz.CreateInstance(_uuidof(Recordset)); //DEL pRecTzList.CreateInstance(_uuidof(Recordset)); //DEL pRecTdList.CreateInstance(_uuidof(Recordset)); //DEL //DEL m_pConnection->BeginTrans(); //DEL //DEL try //DEL { //DEL szSql.Empty(); //DEL szSql.Format(_T("select * from td where DEID = %u and TZID in (select ID from tz where PRID =%u)"), dwDevID, dwID); //DEL pRecTdList->Open(szSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), //DEL adOpenStatic, adLockOptimistic, adCmdText); //DEL //DEL if (VAL_ZERO != pRecTdList->GetRecordCount()) //DEL { //DEL szCaption.Empty(); //DEL szCaption.LoadString(IDS_OP_LD_PRO_TD); //DEL if (IDYES == AfxMessageBox(szCaption, MB_YESNO, MB_ICONQUESTION)) //DEL { //DEL bIsDelTd = true; //DEL } //DEL } //DEL //DEL pRecTdList->Close(); //DEL //DEL szSql.Empty(); //DEL szSql.Format(_T("select TZID from dptt where DEID = %u and PRID = %u and TZID is not NULL"), dwDevID ,dwID); //DEL pRecTzList->Open(szSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), //DEL adOpenStatic, adLockOptimistic, adCmdText); //DEL //DEL while ((short)VAL_ZERO == pRecTzList->adoEOF) //DEL { //DEL if (bIsDelTd) //DEL { //DEL szSql.Empty(); //DEL szSql.Format(_T("select ID,TDtype from td where DEID = %u and TZID = %u"), dwDevID, pRecTzList->GetCollect(_T("TZID")).ulVal); //DEL pRecTdList->Open(szSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), //DEL adOpenStatic, adLockOptimistic, adCmdText); //DEL //DEL while ((short)VAL_ZERO == pRecTdList->adoEOF) //DEL { //DEL dwTdID = (DWORD)pRecTdList->GetCollect(_T("ID")).ulVal; //DEL switch (pRecTdList->GetCollect(_T("TDtype")).iVal) //DEL { //DEL case 0: //DEL theApp.m_pTdManager->DeleteRspTd(dwTdID); //DEL theApp.m_pTdManager->DeleteObjInMem(m_handleProcessor.GenerateHandle(dwTdID, PZ_STYLE_TD_RSP)); //DEL break; //DEL case 1: //DEL theApp.m_pTdManager->DeleteIpspTd(dwTdID); //DEL theApp.m_pTdManager->DeleteObjInMem(m_handleProcessor.GenerateHandle(dwTdID, PZ_STYLE_TD_IPSP)); //DEL break; //DEL default: //DEL break; //DEL } //DEL pRecTdList->MoveNext(); //DEL } //DEL //DEL pRecTdList->Close(); //DEL } //DEL theApp.m_pProManager->DeleteTzInLoc(pRecTzList->GetCollect(_T("TZID")).ulVal, dwDevID); //DEL pRecTzList->MoveNext(); //DEL } //DEL //DEL pRecTzList->Close(); //DEL theApp.m_pProManager->DeleteProjectInLoc(dwID, dwDevID); //DEL } //DEL catch (_com_error e) //DEL { //DEL m_pConnection->RollbackTrans(); //DEL return APP_ERR_DB; //DEL } //DEL //DEL m_pConnection->CommitTrans(); //DEL //DEL InitialNavDataProDlg(pNavDataView->m_navProDlg); //DEL //DEL pNavDataView->m_navDevDlg.m_devTree.SelectItem(pNavDataView->m_navDevDlg.m_devTree.GetParentItem(hProItem)); //DEL pNavDataView->m_navDevDlg.m_devTree.DeleteItem(hProItem); //DEL */ //DEL return uExecCode; //DEL } UINT CDataOperator::CreateTzInDB(CNavDataView* pNavDataView) { HTREEITEM hProItem = NULL; HTREEITEM hTzItem = NULL; _RecordsetPtr pRecTz = NULL; DWORD dwHandle = (DWORD)VAL_ZERO; DWORD dwID = (DWORD)VAL_ZERO; DWORD dwProHandle = (DWORD)VAL_ZERO; DWORD dwProID = (DWORD)VAL_ZERO; UINT uImageState = (UINT)VAL_ZERO; UINT uExecCode = (UINT)VAL_ZERO; CString szSql = _T(""); pRecTz.CreateInstance(_uuidof(Recordset)); m_pConnection->BeginTrans(); try { hProItem = pNavDataView->m_dataTree.GetSelectedItem(); dwProHandle = pNavDataView->m_dataTree.GetItemData(hProItem); dwProID = m_handleProcessor.GetIDFromHandle(dwProHandle); uExecCode = theApp.m_pProManager->CreateTzInDB(dwID, dwProID); if (uExecCode == APP_SUCCESS) { szSql.Empty(); szSql.Format(_T("select TZname from tz where ID = %u"), dwID); pRecTz->Open(szSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), adOpenStatic, adLockOptimistic, adCmdText); if ((long)VAL_ZERO != pRecTz->GetRecordCount()) { hTzItem = pNavDataView->m_dataTree.InsertItem((pRecTz->GetCollect(_T("TZname")).vt == VT_NULL) ? _T("") : (LPCTSTR)(_bstr_t)pRecTz->GetCollect(_T("TZname")), hProItem); dwHandle = m_handleProcessor.GenerateHandle(dwID, PZ_STYLE_TZ); pNavDataView->m_dataTree.SetItemData(hTzItem, dwHandle); uImageState = m_stateProcessor.ChangeToImageState(PZ_STATE_DB); pNavDataView->m_dataTree.SetItemState(hTzItem, uImageState, TVIS_STATEIMAGEMASK); pNavDataView->m_dataTree.SelectItem(hTzItem); } pRecTz->Close(); m_pConnection->CommitTrans(); } else { m_pConnection->RollbackTrans(); } } catch (_com_error e) { hHook = SetWindowsHookEx(WH_CBT,(HOOKPROC)CBTHookProc,AfxGetInstanceHandle(),NULL); AfxMessageBox((LPCTSTR)e.Description(), MB_ICONINFORMATION); m_pConnection->RollbackTrans(); return APP_ERR_DB; } return uExecCode; } UINT CDataOperator::DeleteTzInDB(CNavDataView *pNavDataView) { HTREEITEM hTzItem = NULL; _RecordsetPtr pRecTzID = NULL; _RecordsetPtr pRecTdList = NULL; DWORD dwHandle = (DWORD)VAL_ZERO; DWORD dwID = (DWORD)VAL_ZERO; DWORD dwTdID = (DWORD)VAL_ZERO; CString szSql = _T(""); hTzItem = pNavDataView->m_dataTree.GetSelectedItem(); dwHandle = pNavDataView->m_dataTree.GetItemData(hTzItem); dwID = m_handleProcessor.GetIDFromHandle(dwHandle); pRecTzID.CreateInstance(_uuidof(Recordset)); pRecTdList.CreateInstance(_uuidof(Recordset)); m_pConnection->BeginTrans(); try { szSql.Empty(); szSql.Format(_T("select ID,Ttype,Stype from td where TZID = %u"), dwID); pRecTdList->Open(szSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), adOpenStatic, adLockOptimistic, adCmdText); while ((short)VAL_ZERO == pRecTdList->adoEOF) { dwTdID = pRecTdList->GetCollect(_T("ID")).ulVal; switch (pRecTdList->GetCollect(_T("Ttype")).iVal) { case 0: switch (pRecTdList->GetCollect(_T("Stype")).iVal) { case 0: break; case 1: theApp.m_pTdManager->DeleteRsp2DTd(dwTdID); theApp.m_pTdManager->DeleteObjInMem(m_handleProcessor.GenerateHandle(dwTdID, PZ_STYLE_TD_2DRSP)); break; case 2: break; default: break; } break; case 1: switch (pRecTdList->GetCollect(_T("Stype")).iVal) { case 0: break; case 1: theApp.m_pTdManager->DeleteRsp2DTd(dwTdID); theApp.m_pTdManager->DeleteObjInMem(m_handleProcessor.GenerateHandle(dwTdID, PZ_STYLE_TD_2DRSP)); break; case 2: break; default: break; } break; default: break; } pRecTdList->MoveNext(); } pRecTdList->Close(); theApp.m_pProManager->DeleteTzInDB(dwID); theApp.m_pProManager->DeleteObjInMem(m_handleProcessor.GenerateHandle(dwID, PZ_STYLE_TZ)); } catch (_com_error e) { hHook = SetWindowsHookEx(WH_CBT,(HOOKPROC)CBTHookProc,AfxGetInstanceHandle(),NULL); AfxMessageBox((LPCTSTR)e.Description(), MB_ICONINFORMATION); m_pConnection->RollbackTrans(); return APP_ERR_DB; } m_pConnection->CommitTrans(); // InitialNavDataDevDlg(pNavDataView->m_navDevDlg); pNavDataView->m_dataTree.SelectItem(pNavDataView->m_dataTree.GetParentItem(hTzItem)); pNavDataView->m_dataTree.DeleteItem(hTzItem); return APP_SUCCESS; } UINT CDataOperator::Convert2DTo3D(CNavDataView* pNavDataView) { UINT uExecCode = (UINT)APP_SUCCESS; HTREEITEM hTzItem = NULL; DWORD dwTzHandle = (DWORD)VAL_ZERO; hTzItem = pNavDataView->m_dataTree.GetSelectedItem(); dwTzHandle = pNavDataView->m_dataTree.GetItemData(hTzItem); if (TRUE == theApp.m_pTdManager->Convert2DTo3D(dwTzHandle)) { uExecCode = (UINT)APP_SUCCESS; } else { uExecCode = (UINT)APP_FAIL; } return uExecCode; } UINT CDataOperator::DeleteRspCETdInDB(DWORD dwTdID) { UINT uExecCode = (UINT)APP_SUCCESS; _RecordsetPtr pRecTd = NULL; pRecTd.CreateInstance(_uuidof(Recordset)); try { m_pConnection->BeginTrans(); theApp.m_pTdManager->DeleteRspCETd(dwTdID); theApp.m_pTdManager->DeleteObjInMem(m_handleProcessor.GenerateHandle(dwTdID, PZ_STYLE_TD_CERSP)); } catch (_com_error e) { m_pConnection->RollbackTrans(); hHook = SetWindowsHookEx(WH_CBT,(HOOKPROC)CBTHookProc,AfxGetInstanceHandle(),NULL); AfxMessageBox((LPCTSTR)e.Description()); return APP_ERR_DB; } m_pConnection->CommitTrans(); return uExecCode; } UINT CDataOperator::DeleteIpspCETdInDB(DWORD dwTdID) { UINT uExecCode = (UINT)APP_SUCCESS; _RecordsetPtr pRecTd = NULL; pRecTd.CreateInstance(_uuidof(Recordset)); try { m_pConnection->BeginTrans(); theApp.m_pTdManager->DeleteIpspCETd(dwTdID); theApp.m_pTdManager->DeleteObjInMem(m_handleProcessor.GenerateHandle(dwTdID, PZ_STYLE_TD_CEIPSP)); } catch (_com_error e) { hHook = SetWindowsHookEx(WH_CBT,(HOOKPROC)CBTHookProc,AfxGetInstanceHandle(),NULL); AfxMessageBox((LPCTSTR)e.Description()); m_pConnection->RollbackTrans(); return APP_ERR_DB; } m_pConnection->CommitTrans(); return uExecCode; } UINT CDataOperator::DeleteRsp3DTdInDB(DWORD dwTdID) { UINT uExecCode = (UINT)APP_SUCCESS; _RecordsetPtr pRecTd = NULL; pRecTd.CreateInstance(_uuidof(Recordset)); try { m_pConnection->BeginTrans(); theApp.m_pTdManager->DeleteRsp3DTd(dwTdID); theApp.m_pTdManager->DeleteObjInMem(m_handleProcessor.GenerateHandle(dwTdID, PZ_STYLE_TD_3DRSP)); } catch (_com_error e) { hHook = SetWindowsHookEx(WH_CBT,(HOOKPROC)CBTHookProc,AfxGetInstanceHandle(),NULL); AfxMessageBox((LPCTSTR)e.Description()); m_pConnection->RollbackTrans(); return APP_ERR_DB; } m_pConnection->CommitTrans(); return uExecCode; } UINT CDataOperator::DeleteRsp2DTdInDB(DWORD dwTdID) { UINT uExecCode = (UINT)APP_SUCCESS; _RecordsetPtr pRecTd = NULL; pRecTd.CreateInstance(_uuidof(Recordset)); try { m_pConnection->BeginTrans(); theApp.m_pTdManager->DeleteRsp2DTd(dwTdID); theApp.m_pTdManager->DeleteObjInMem(m_handleProcessor.GenerateHandle(dwTdID, PZ_STYLE_TD_2DRSP)); } catch (_com_error e) { m_pConnection->RollbackTrans(); return APP_ERR_DB; } m_pConnection->CommitTrans(); return uExecCode; } UINT CDataOperator::DeleteIpsp2DTdInDB(DWORD dwTdID) { UINT uExecCode = (UINT)APP_SUCCESS; _RecordsetPtr pRecTd = NULL; pRecTd.CreateInstance(_uuidof(Recordset)); try { m_pConnection->BeginTrans(); theApp.m_pTdManager->DeleteIpsp2DTd(dwTdID); theApp.m_pTdManager->DeleteObjInMem(m_handleProcessor.GenerateHandle(dwTdID, PZ_STYLE_TD_2DIPSP)); } catch (_com_error e) { m_pConnection->RollbackTrans(); return APP_ERR_DB; } m_pConnection->CommitTrans(); return uExecCode; } int CDataOperator::QueryTaskARInDB(DWORD dwTdHandle) { DWORD dwTdID = m_handleProcessor.GetIDFromHandle(dwTdHandle); _RecordsetPtr pRecTd = NULL; dwTdID = m_handleProcessor.GetIDFromHandle(dwTdHandle); pRecTd.CreateInstance(_uuidof(Recordset)); CString strSql =_T(""); strSql.Format(_T("select AR from tdchannel where TDID = %u and CHnumber = 1"), dwTdID); CString strErr = _T(""); try { pRecTd->Open(strSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), adOpenStatic, adLockOptimistic, adCmdText); if (pRecTd->GetRecordCount() > 0) { int iAR = pRecTd->GetCollect(_T("AR")).iVal; return iAR; } else { strErr.Format(_T("Query AR failed, tdid = %u"),dwTdID); AfxMessageBox(strErr); } } catch (_com_error e) { AfxMessageBox(e.Description()); } return 0; } UINT CDataOperator::DeleteIpsp3DTdInDB(DWORD dwTdID) { UINT uExecCode = (UINT)APP_SUCCESS; _RecordsetPtr pRecTd = NULL; pRecTd.CreateInstance(_uuidof(Recordset)); try { m_pConnection->BeginTrans(); theApp.m_pTdManager->DeleteIpsp3DTd(dwTdID); theApp.m_pTdManager->DeleteObjInMem(m_handleProcessor.GenerateHandle(dwTdID, PZ_STYLE_TD_3DIPSP)); } catch (_com_error e) { m_pConnection->RollbackTrans(); return APP_ERR_DB; } m_pConnection->CommitTrans(); return uExecCode; } UINT CDataOperator::DeleteSP2DTdInDB(DWORD dwTdID) { UINT uExecCode = (UINT)APP_SUCCESS; _RecordsetPtr pRecTd = NULL; pRecTd.CreateInstance(_uuidof(Recordset)); try { m_pConnection->BeginTrans(); theApp.m_pTdManager->DeleteSP2DTd(dwTdID); theApp.m_pTdManager->DeleteObjInMem(m_handleProcessor.GenerateHandle(dwTdID, PZ_STYLE_TD_2DSP)); } catch (_com_error e) { m_pConnection->RollbackTrans(); return APP_ERR_DB; } m_pConnection->CommitTrans(); return uExecCode; } UINT CDataOperator::DeleteSP3DTdInDB(DWORD dwTdID) { UINT uExecCode = (UINT)APP_SUCCESS; _RecordsetPtr pRecTd = NULL; pRecTd.CreateInstance(_uuidof(Recordset)); try { m_pConnection->BeginTrans(); theApp.m_pTdManager->DeleteSP3DTd(dwTdID); theApp.m_pTdManager->DeleteObjInMem(m_handleProcessor.GenerateHandle(dwTdID, PZ_STYLE_TD_3DIPSP)); } catch (_com_error e) { m_pConnection->RollbackTrans(); return APP_ERR_DB; } m_pConnection->CommitTrans(); return uExecCode; } UINT CDataOperator::DeleteSPCETdInDB(DWORD dwTdID) { UINT uExecCode = (UINT)APP_SUCCESS; _RecordsetPtr pRecTd = NULL; pRecTd.CreateInstance(_uuidof(Recordset)); try { m_pConnection->BeginTrans(); theApp.m_pTdManager->DeleteSPCETd(dwTdID); theApp.m_pTdManager->DeleteObjInMem(m_handleProcessor.GenerateHandle(dwTdID, PZ_STYLE_TD_CESP)); } catch (_com_error e) { m_pConnection->RollbackTrans(); return APP_ERR_DB; } m_pConnection->CommitTrans(); return uExecCode; } UINT CDataOperator::ExportIP2DToDAT(CNavDataView *pNavDataView, CString f_szFileName) { UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); if (TRUE == m_BatchExportFlag) { dwTdHandle = m_dwItemHandle; } try { if (true != theApp.m_pTdManager->GetTestingData(dwTdHandle)->ExportIP2DDataToDat(f_szFileName)) { uExecCode = (UINT)APP_FAIL; } } catch (...) { uExecCode = (UINT)APP_SUCCESS; } return uExecCode; } UINT CDataOperator::ExportIP2DToTxt(CNavDataView *pNavDataView, CString f_szFileName) { UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); if (TRUE == m_BatchExportFlag) { dwTdHandle = m_dwItemHandle; } try { if (true != theApp.m_pTdManager->GetTestingData(dwTdHandle)->ExportIPDataToTxt(f_szFileName)) { uExecCode = (UINT)APP_FAIL; } } catch (...) { uExecCode = (UINT)APP_SUCCESS; } return uExecCode; } UINT CDataOperator::ExportIP3DToTxt(CNavDataView *pNavDataView, CString f_szFileName) { UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); if (TRUE == m_BatchExportFlag) { dwTdHandle = m_dwItemHandle; } try { if (true != theApp.m_pTdManager->GetTestingData(dwTdHandle)->ExportIPDataToTxt(f_szFileName)) { uExecCode = (UINT)APP_FAIL; } } catch (_com_error e) { AfxMessageBox(e.Description()); uExecCode = (UINT)APP_SUCCESS; } return uExecCode; } UINT CDataOperator::ExportIP1DToTxt(CNavDataView *pNavDataView, CString f_szFileName) { UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); if (TRUE == m_BatchExportFlag) { dwTdHandle = m_dwItemHandle; } try { if (true != theApp.m_pTdManager->GetTestingData(dwTdHandle)->ExportIPDataToTxt(f_szFileName)) { uExecCode = (UINT)APP_FAIL; } } catch (_com_error e) { AfxMessageBox(e.Description()); uExecCode = (UINT)APP_SUCCESS; } return uExecCode; } UINT CDataOperator::ExportIP3DToDAT(CNavDataView *pNavDataView, CString f_szFileName) { UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); if (TRUE == m_BatchExportFlag) { dwTdHandle = m_dwItemHandle; } try { if (true != theApp.m_pTdManager->GetTestingData(dwTdHandle)->ExportIP3DToDatFile(f_szFileName)) { uExecCode = (UINT)APP_FAIL; } } catch (_com_error e) { AfxMessageBox(e.Description()); uExecCode = (UINT)APP_SUCCESS; } return uExecCode; } UINT CDataOperator::ExportRsp2DTdToDAT(CNavDataView *pNavDataView, CString f_szFileName) { UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); if (TRUE == m_BatchExportFlag) { dwTdHandle = m_dwItemHandle; } try { if (TRUE != theApp.m_pTdManager->GetTestingData(dwTdHandle)->SaveTdToRes2DFile(f_szFileName)) { uExecCode = (UINT)APP_FAIL; } } catch (...) { uExecCode = (UINT)APP_SUCCESS; } return uExecCode; } UINT CDataOperator::ExportRsp2DTdToExcel(CNavDataView *pNavDataView, CString f_szFileName) { UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); if (TRUE == m_BatchExportFlag) { dwTdHandle = m_dwItemHandle; } try { if (TRUE != theApp.m_pTdManager->GetTestingData(dwTdHandle)->SaveTdToExcelFile(f_szFileName)) { uExecCode = (UINT)APP_FAIL; } } catch (...) { uExecCode = (UINT)APP_FAIL; } return uExecCode; } UINT CDataOperator::ExportRsp2DTdToCSV(CNavDataView *pNavDataView, CString f_szFileName) { UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); if (TRUE == m_BatchExportFlag) { dwTdHandle = m_dwItemHandle; } try { if (TRUE != theApp.m_pTdManager->GetTestingData(dwTdHandle)->SaveTdToCsvFile(f_szFileName)) { uExecCode = (UINT)APP_FAIL; } } catch (...) { uExecCode = (UINT)APP_FAIL; } return uExecCode; } UINT CDataOperator::ExportRsp2DTdToUrf(CNavDataView *pNavDataView, CString f_szFileName) { UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); if (TRUE == m_BatchExportFlag) { dwTdHandle = m_dwItemHandle; } try { if (TRUE != theApp.m_pTdManager->GetTestingData(dwTdHandle)->ExportDataToUrf(f_szFileName)) { uExecCode = (UINT)APP_FAIL; } } catch (...) { uExecCode = (UINT)APP_SUCCESS; } return uExecCode; } UINT CDataOperator::ExportRsp2DTdToTxt(CNavDataView *pNavDataView, CString f_szFileName) { UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); if (TRUE == m_BatchExportFlag) { dwTdHandle = m_dwItemHandle; } try { if (TRUE != theApp.m_pTdManager->GetTestingData(dwTdHandle)->ExportResDataToTxt(f_szFileName)) { uExecCode = (UINT)APP_FAIL; } } catch (...) { uExecCode = (UINT)APP_SUCCESS; } return uExecCode; } UINT CDataOperator::ExportRspCETdToExcel(CNavDataView *pNavDataView, CString f_szFileName) { UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); if (TRUE == m_BatchExportFlag) { dwTdHandle = m_dwItemHandle; } try { if (TRUE != theApp.m_pTdManager->GetTestingData(dwTdHandle)->SaveTdToExcelFile(f_szFileName)) { uExecCode = (UINT)APP_FAIL; } } catch (...) { uExecCode = (UINT)APP_FAIL; } return uExecCode; } UINT CDataOperator::ExportRspCETdToCSV(CNavDataView *pNavDataView, CString f_szFileName) { UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); if (TRUE == m_BatchExportFlag) { dwTdHandle = m_dwItemHandle; } try { if (TRUE != theApp.m_pTdManager->GetTestingData(dwTdHandle)->SaveTdToCsvFile(f_szFileName)) { uExecCode = (UINT)APP_FAIL; } } catch (...) { uExecCode = (UINT)APP_FAIL; } return uExecCode; } UINT CDataOperator::ExportRsp1DTdToTxt(CNavDataView *pNavDataView, CString f_szFileName) { UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); if (TRUE == m_BatchExportFlag) { dwTdHandle = m_dwItemHandle; } try { if (TRUE != theApp.m_pTdManager->GetTestingData(dwTdHandle)->ExportResDataToTxt(f_szFileName)) { uExecCode = (UINT)APP_FAIL; } } catch (...) { uExecCode = (UINT)APP_SUCCESS; } return uExecCode; } UINT CDataOperator::DisplayRsp3DTdGraph(CNavDataView *pNavDataView) { return 0; } UINT CDataOperator::DisplayRsp2DTdGraph(CNavDataView *pNavDataView) { UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); try { theApp.m_pTdManager->GetTestingData(dwTdHandle)->LoadData(theApp.m_pSptManager->m_medLinkList); if (TRUE != theApp.m_pTdManager->GetTestingData(dwTdHandle)->DisplayGraph()) { uExecCode = (UINT)APP_FAIL; } } catch (...) { uExecCode = (UINT)APP_FAIL; } return uExecCode; } UINT CDataOperator::DisplayRspCETdGraph(CNavDataView *pNavDataView) { UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); try { theApp.m_pTdManager->GetTestingData(dwTdHandle)->LoadData(theApp.m_pSptManager->m_medLinkList); if (TRUE != theApp.m_pTdManager->GetTestingData(dwTdHandle)->DisplayGraph()) { uExecCode = (UINT)APP_FAIL; } } catch (...) { uExecCode = (UINT)APP_FAIL; } return uExecCode; } UINT CDataOperator::DisplayTPSplinesGraph(CNavDataView *pNavDataView, int iTSN) { CTdChannel* pTdChannel = NULL; UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); try { theApp.m_pTdManager->GetTestingData(dwTdHandle)->LoadData(theApp.m_pSptManager->m_medLinkList); // pTdChannel = (CTdChannel*)theApp.m_pTdManager->GetTestingData(dwTdHandle)->m_tdChaList.GetAt(theApp.m_pTdManager->GetTestingData(dwTdHandle)->m_tdChaList.FindIndex(0)); // pTdChannel->GetTdRecord(iTSN)->LoadOrgData(); if (TRUE != theApp.m_pTdManager->GetTestingData(dwTdHandle)->DisplayTPSplinesGraph(iTSN)) { uExecCode = (UINT)APP_FAIL; } } catch (...) { uExecCode = (UINT)APP_FAIL; } return uExecCode; } //DEL UINT CDataOperator::DeleteTzInLoc(CNavDataView* pNavDataView) //DEL { //DEL UINT uExecCode = (UINT)VAL_ZERO; //DEL //DEL CString szCaption; //DEL //DEL HTREEITEM hTzItem = NULL; //DEL HTREEITEM hPreItem = NULL; //DEL HTREEITEM hCurItem = NULL; //DEL //DEL _RecordsetPtr pRecTz = NULL; //DEL //DEL _RecordsetPtr pRecTdList = NULL; //DEL //DEL DWORD dwHandle = (DWORD)VAL_ZERO; //DEL DWORD dwID = (DWORD)VAL_ZERO; //DEL //DEL DWORD dwDevHandle = (DWORD)VAL_ZERO; //DEL DWORD dwDevID = (DWORD)VAL_ZERO; //DEL //DEL DWORD dwTdID = (DWORD)VAL_ZERO; //DEL CString szSql = _T(""); //DEL //DEL /* //DEL dwHandle = pNavDataView->m_navDevDlg.m_devTree.GetItemData(pNavDataView->m_navDevDlg.m_devTree.GetSelectedItem()); //DEL dwID = m_handleProcessor.GetIDFromHandle(dwHandle); //DEL //DEL hTzItem = pNavDataView->m_navDevDlg.m_devTree.GetSelectedItem(); //DEL hCurItem = hTzItem; //DEL //DEL while (NULL != hCurItem) //DEL { //DEL hPreItem = hCurItem; //DEL hCurItem = pNavDataView->m_navDevDlg.m_devTree.GetParentItem(hCurItem); //DEL } //DEL //DEL dwDevHandle = pNavDataView->m_navDevDlg.m_devTree.GetItemData(hPreItem); //DEL dwDevID = m_handleProcessor.GetIDFromHandle(dwDevHandle); //DEL //DEL pRecTz.CreateInstance(_uuidof(Recordset)); //DEL pRecTdList.CreateInstance(_uuidof(Recordset)); //DEL //DEL m_pConnection->BeginTrans(); //DEL //DEL try //DEL { //DEL //DEL szSql.Empty(); //DEL szSql.Format(_T("select ID,TDtype from td where DEID = %u and TZID = %u"), dwDevID, dwID); //DEL pRecTdList->Open(szSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), //DEL adOpenStatic, adLockOptimistic, adCmdText); //DEL //DEL if (VAL_ZERO != pRecTdList->GetRecordCount()) //DEL { //DEL szCaption.Empty(); //DEL szCaption.LoadString(IDS_OP_LD_TZ_TD); //DEL if (IDYES == AfxMessageBox(szCaption, MB_YESNO, MB_ICONQUESTION)) //DEL { //DEL while ((short)VAL_ZERO == pRecTdList->adoEOF) //DEL { //DEL dwTdID = (DWORD)pRecTdList->GetCollect(_T("ID")).ulVal; //DEL switch (pRecTdList->GetCollect(_T("TDtype")).iVal) //DEL { //DEL case 0: //DEL theApp.m_pTdManager->DeleteRspTd(dwTdID); //DEL theApp.m_pTdManager->DeleteObjInMem(m_handleProcessor.GenerateHandle(dwTdID, PZ_STYLE_TD_RSP)); //DEL break; //DEL case 1: //DEL theApp.m_pTdManager->DeleteIpspTd(dwTdID); //DEL theApp.m_pTdManager->DeleteObjInMem(m_handleProcessor.GenerateHandle(dwTdID, PZ_STYLE_TD_IPSP)); //DEL break; //DEL default: //DEL break; //DEL } //DEL pRecTdList->MoveNext(); //DEL } //DEL } //DEL } //DEL pRecTdList->Close(); //DEL //DEL theApp.m_pProManager->DeleteTzInLoc(dwID, dwDevID); //DEL } //DEL catch (_com_error e) //DEL { //DEL AfxMessageBox((LPCTSTR)e.Description(), MB_ICONINFORMATION); //DEL m_pConnection->RollbackTrans(); //DEL return APP_ERR_DB; //DEL } //DEL //DEL m_pConnection->CommitTrans(); //DEL //DEL InitialNavDataProDlg(pNavDataView->m_navProDlg); //DEL //DEL pNavDataView->m_navDevDlg.m_devTree.SelectItem(pNavDataView->m_navDevDlg.m_devTree.GetParentItem(hTzItem)); //DEL pNavDataView->m_navDevDlg.m_devTree.DeleteItem(hTzItem); //DEL */ //DEL return uExecCode; //DEL } //DEL UINT CDataOperator::CreateDmsInOffline(CNavDataView *pNavDataView) //DEL { //DEL HTREEITEM hDevItem = NULL; //DEL HTREEITEM hProItem = NULL; //DEL _RecordsetPtr pRecPro = NULL; //DEL _RecordsetPtr pRecTz = NULL; //DEL DWORD dwDevHandle = (DWORD)VAL_ZERO; //DEL DWORD dwDevID = (DWORD)VAL_ZERO; //DEL //DEL UINT uImageState = (UINT)VAL_ZERO; //DEL UINT uExecCode = (UINT)VAL_ZERO; //DEL //DEL CString szSql = _T(""); //DEL /* //DEL pRecPro.CreateInstance(_uuidof(Recordset)); //DEL pRecTz.CreateInstance(_uuidof(Recordset)); //DEL //DEL m_pConnection->BeginTrans(); //DEL //DEL try //DEL { //DEL hDevItem = pNavDataView->m_navDevDlg.m_devTree.GetSelectedItem(); //DEL dwDevHandle = pNavDataView->m_navDevDlg.m_devTree.GetItemData(hDevItem); //DEL dwDevID = m_handleProcessor.GetIDFromHandle(dwDevHandle); //DEL //DEL uExecCode = theApp.m_pProManager->CreateDMSInOffline(dwDevID); //DEL m_pConnection->CommitTrans(); //DEL } //DEL catch (_com_error e) //DEL { //DEL m_pConnection->RollbackTrans(); //DEL return APP_ERR_DB; //DEL } //DEL //DEL if (APP_SUCCESS == uExecCode) //DEL { //DEL AddDmsInDevTreeByLoc(pNavDataView->m_navDevDlg); //DEL //DEL pNavDataView->m_navDevDlg.m_devTree.Expand(hDevItem, TVE_EXPAND); //DEL //DEL pNavDataView->m_navDevDlg.m_devTree.SelectItem(NULL); //DEL pNavDataView->m_navDevDlg.m_devTree.SelectItem(hDevItem); //DEL //DEL } //DEL */ //DEL return uExecCode; //DEL } //DEL HTREEITEM CDataOperator::FindProItemInNavDevTree(DWORD dwDevID, CString szProCn, CTreeCtrl& devTree) //DEL { //DEL HTREEITEM hDevItem = NULL; //DEL HTREEITEM hProItem = NULL; //DEL _RecordsetPtr pRecProID = NULL; //DEL //DEL DWORD dwDevHandle = (DWORD)VAL_ZERO; //DEL DWORD dwProHandle = (DWORD)VAL_ZERO; //DEL DWORD dwProID = (DWORD)VAL_ZERO; //DEL //DEL CString szSql; //DEL pRecProID.CreateInstance(_uuidof(Recordset)); //DEL //DEL szSql.Empty(); //DEL szSql.Format(_T("select ID from project where CN = '%s'"), szProCn); //DEL //DEL pRecProID->Open(szSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), //DEL adOpenStatic, adLockOptimistic, adCmdText); //DEL //DEL if ((long)VAL_ZERO != pRecProID->GetRecordCount()) //DEL { //DEL dwProID = pRecProID->GetCollect(_T("ID")).ulVal; //DEL //DEL dwProHandle = m_handleProcessor.GenerateHandle(dwProID, PZ_STYLE_PRO); //DEL dwDevHandle = m_handleProcessor.GenerateHandle(dwDevID, PZ_STYLE_DEV_DATA); //DEL //DEL hDevItem = devTree.GetRootItem(); //DEL //DEL while (NULL != hDevItem) //DEL { //DEL if ((devTree.GetItemData(hDevItem) == dwDevHandle) && (devTree.ItemHasChildren(hDevItem))) //DEL { //DEL hProItem = devTree.GetChildItem(hDevItem); //DEL while (NULL != hProItem) //DEL { //DEL if (devTree.GetItemData(hProItem) == dwProHandle) //DEL { //DEL return hProItem; //DEL } //DEL hProItem = devTree.GetNextSiblingItem(hProItem); //DEL } //DEL } //DEL hDevItem = devTree.GetNextSiblingItem(hDevItem); //DEL } //DEL } //DEL //DEL pRecProID->Close(); //DEL return NULL; //DEL } //DEL HTREEITEM CDataOperator::FindTzItemInNavDevTree(DWORD dwDevID, DWORD dwProID, CString szTzName, CTreeCtrl& devTree) //DEL { //DEL HTREEITEM hDevItem = NULL; //DEL HTREEITEM hProItem = NULL; //DEL HTREEITEM hTzItem = NULL; //DEL //DEL DWORD dwDevHandle = (DWORD)VAL_ZERO; //DEL DWORD dwProHandle = (DWORD)VAL_ZERO; //DEL //DEL CString szSql; //DEL //DEL dwProHandle = m_handleProcessor.GenerateHandle(dwProID, PZ_STYLE_PRO); //DEL dwDevHandle = m_handleProcessor.GenerateHandle(dwDevID, PZ_STYLE_DEV_DATA); //DEL //DEL hDevItem = devTree.GetRootItem(); //DEL //DEL while (NULL != hDevItem) //DEL { //DEL if ((devTree.GetItemData(hDevItem) == dwDevHandle) && (devTree.ItemHasChildren(hDevItem))) //DEL { //DEL hProItem = devTree.GetChildItem(hDevItem); //DEL while (NULL != hProItem) //DEL { //DEL if ((devTree.GetItemData(hProItem) == dwProHandle) && (devTree.ItemHasChildren(hProItem))) //DEL { //DEL hTzItem = devTree.GetChildItem(hProItem); //DEL while (NULL != hTzItem) //DEL { //DEL if (devTree.GetItemText(hTzItem) == szTzName) //DEL { //DEL return hTzItem; //DEL } //DEL hTzItem = devTree.GetNextSiblingItem(hTzItem); //DEL } //DEL } //DEL hProItem = devTree.GetNextSiblingItem(hProItem); //DEL } //DEL } //DEL hDevItem = devTree.GetNextSiblingItem(hDevItem); //DEL } //DEL return NULL; //DEL } //DEL HTREEITEM CDataOperator::FindProItemInNavDevTree(DWORD dwDevID, DWORD dwProID, CTreeCtrl &devTree) //DEL { //DEL HTREEITEM hDevItem = NULL; //DEL HTREEITEM hProItem = NULL; //DEL //DEL DWORD dwDevHandle = (DWORD)VAL_ZERO; //DEL DWORD dwProHandle = (DWORD)VAL_ZERO; //DEL //DEL CString szSql; //DEL //DEL dwProHandle = m_handleProcessor.GenerateHandle(dwProID, PZ_STYLE_PRO); //DEL dwDevHandle = m_handleProcessor.GenerateHandle(dwDevID, PZ_STYLE_DEV_DATA); //DEL //DEL hDevItem = devTree.GetRootItem(); //DEL //DEL while (NULL != hDevItem) //DEL { //DEL if ((devTree.GetItemData(hDevItem) == dwDevHandle) && (devTree.ItemHasChildren(hDevItem))) //DEL { //DEL hProItem = devTree.GetChildItem(hDevItem); //DEL while (NULL != hProItem) //DEL { //DEL if (devTree.GetItemData(hProItem) == dwProHandle) //DEL { //DEL return hProItem; //DEL } //DEL hProItem = devTree.GetNextSiblingItem(hProItem); //DEL } //DEL } //DEL hDevItem = devTree.GetNextSiblingItem(hDevItem); //DEL } //DEL //DEL return NULL; //DEL } //DEL HTREEITEM CDataOperator::FindTzItemInNavDevTree(DWORD dwDevID, DWORD dwProID, DWORD dwTzID, CTreeCtrl& devTree) //DEL { //DEL HTREEITEM hDevItem = NULL; //DEL HTREEITEM hProItem = NULL; //DEL HTREEITEM hTzItem = NULL; //DEL //DEL _RecordsetPtr pRecTz = NULL; //DEL //DEL DWORD dwDevHandle = (DWORD)VAL_ZERO; //DEL DWORD dwProHandle = (DWORD)VAL_ZERO; //DEL DWORD dwTzHandle = (DWORD)VAL_ZERO; //DEL //DEL CString szTzName; //DEL CString szSql; //DEL //DEL pRecTz.CreateInstance(_uuidof(Recordset)); //DEL //DEL szSql.Empty(); //DEL szSql.Format(_T("select TZname from tz where ID = %u"), dwTzID); //DEL pRecTz->Open(szSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), adOpenStatic, adLockOptimistic, adCmdText); //DEL //DEL if ((long)VAL_ZERO != pRecTz->GetRecordCount()) //DEL { //DEL szTzName.Empty(); //DEL szTzName = (LPCTSTR)(_bstr_t)pRecTz->GetCollect(_T("TZname")); //DEL pRecTz->Close(); //DEL } //DEL else //DEL { //DEL pRecTz->Close(); //DEL return NULL; //DEL } //DEL //DEL dwProHandle = m_handleProcessor.GenerateHandle(dwProID, PZ_STYLE_PRO); //DEL dwDevHandle = m_handleProcessor.GenerateHandle(dwDevID, PZ_STYLE_DEV_DATA); //DEL //DEL hDevItem = devTree.GetRootItem(); //DEL //DEL while (NULL != hDevItem) //DEL { //DEL if ((devTree.GetItemData(hDevItem) == dwDevHandle) && (devTree.ItemHasChildren(hDevItem))) //DEL { //DEL hProItem = devTree.GetChildItem(hDevItem); //DEL while (NULL != hProItem) //DEL { //DEL if ((devTree.GetItemData(hProItem) == dwProHandle) && (devTree.ItemHasChildren(hProItem))) //DEL { //DEL hTzItem = devTree.GetChildItem(hProItem); //DEL while (NULL != hTzItem) //DEL { //DEL if (devTree.GetItemText(hTzItem) == szTzName) //DEL { //DEL return hTzItem; //DEL } //DEL hTzItem = devTree.GetNextSiblingItem(hTzItem); //DEL } //DEL } //DEL hProItem = devTree.GetNextSiblingItem(hProItem); //DEL } //DEL } //DEL hDevItem = devTree.GetNextSiblingItem(hDevItem); //DEL } //DEL return NULL; //DEL } //DEL bool CDataOperator::AddDmsInDevTreeByLoc(CNavDataDevDlg& navDataDevDlg) //DEL { //DEL HTREEITEM hDevItem = NULL; //DEL HTREEITEM hProItem = NULL; //DEL HTREEITEM hTzItem = NULL; //DEL //DEL _RecordsetPtr pRecPro = NULL; //DEL _RecordsetPtr pRecTz = NULL; //DEL //DEL _RecordsetPtr pRecProID = NULL; //DEL _RecordsetPtr pRecTzID = NULL; //DEL //DEL DWORD dwProHandle = (DWORD)VAL_ZERO; //DEL DWORD dwDevHandle = (DWORD)VAL_ZERO; //DEL DWORD dwTzHandle = (DWORD)VAL_ZERO; //DEL //DEL DWORD dwDevID = (DWORD)VAL_ZERO; //DEL DWORD dwProID = (DWORD)VAL_ZERO; //DEL DWORD dwTzID = (DWORD)VAL_ZERO; //DEL //DEL UINT uImageState = (UINT)VAL_ZERO; //DEL CString szSql; //DEL //DEL pRecPro.CreateInstance(_uuidof(Recordset)); //DEL pRecTz.CreateInstance(_uuidof(Recordset)); //DEL pRecProID.CreateInstance(_uuidof(Recordset)); //DEL pRecTzID.CreateInstance(_uuidof(Recordset)); //DEL //DEL hDevItem = navDataDevDlg.m_devTree.GetSelectedItem(); //DEL dwDevID = this->m_handleProcessor.GetIDFromHandle(navDataDevDlg.m_devTree.GetItemData(hDevItem)); //DEL //DEL szSql.Empty(); //DEL szSql.Format(_T("select PRID from dptt where DEID = %u and TZID is null"), dwDevID); //DEL pRecProID->Open(szSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), adOpenStatic, adLockOptimistic, adCmdText); //DEL //DEL while ((short)VAL_ZERO == pRecProID->adoEOF) //DEL { //DEL dwProID = (DWORD)pRecProID->GetCollect(_T("PRID")).ulVal; //DEL //DEL szSql.Empty(); //DEL szSql.Format(_T("select TZID from dptt where DEID = %u and PRID = %u and TZID is not null"), dwDevID, dwProID); //DEL //DEL pRecTzID->Open(szSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), adOpenStatic, adLockOptimistic, adCmdText); //DEL //DEL hProItem = FindProItemInNavDevTree(dwDevID, dwProID, navDataDevDlg.m_devTree); //DEL //DEL if (NULL != hProItem) //DEL { //DEL while ((short)VAL_ZERO == pRecTzID->adoEOF) //DEL { //DEL //DEL dwTzID = (DWORD)pRecTzID->GetCollect(_T("TZID")).ulVal; //DEL hTzItem = FindTzItemInNavDevTree(dwDevID, dwProID, dwTzID, navDataDevDlg.m_devTree); //DEL //DEL if (NULL == hTzItem) //DEL { //DEL AddTzInDevTreeByLoc(navDataDevDlg, dwDevID, dwTzID, hProItem); //DEL //可在此处添加代码，将测区建立至设备 //DEL } //DEL pRecTzID->MoveNext(); //DEL } //DEL //DEL } //DEL else //DEL { //DEL szSql.Empty(); //DEL szSql.Format(_T("select PRname,CN from project where ID = %u"), dwProID); //DEL pRecPro->Open(szSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), adOpenStatic, adLockOptimistic, adCmdText); //DEL //DEL hProItem = navDataDevDlg.m_devTree.InsertItem((LPCTSTR)(_bstr_t)pRecPro->GetCollect(_T("PRname")), hDevItem); //DEL //DEL dwProHandle = m_handleProcessor.GenerateHandle(dwProID, PZ_STYLE_PRO); //DEL navDataDevDlg.m_devTree.SetItemData(hProItem, dwProHandle); //DEL uImageState = m_stateProcessor.ChangeToImageState(PZ_STATE_LOC); //DEL navDataDevDlg.m_devTree.SetItemState(hProItem, uImageState, TVIS_STATEIMAGEMASK); //DEL //DEL pRecPro->Close(); //DEL //DEL //可在此处添加代码，将工程建立至设备，如CNS的值为true，则不可建立 //DEL //DEL while ((short)VAL_ZERO == pRecTzID->adoEOF) //DEL { //DEL dwTzID = (DWORD)pRecTzID->GetCollect(_T("TZID")).ulVal; //DEL //DEL AddTzInDevTreeByLoc(navDataDevDlg, dwDevID, dwTzID, hProItem); //DEL pRecTzID->MoveNext(); //DEL //DEL //可在此处添加代码，将测区建立至设备 //DEL } //DEL } //DEL pRecTzID->Close(); //DEL //DEL navDataDevDlg.m_devTree.Expand(hProItem, TVE_EXPAND); //DEL pRecProID->MoveNext(); //DEL } //DEL pRecProID->Close(); //DEL //DEL return true; //DEL } //DEL UINT CDataOperator::DeleteAllProjectInLocByDev(CNavDataView* pNavDataView) //DEL { //DEL UINT uExecCode = (UINT)VAL_ZERO; //DEL bool bIsDelTd = false; //DEL //DEL HTREEITEM hDevItem = NULL; //DEL HTREEITEM hProItem = NULL; //DEL //DEL _RecordsetPtr pRecPro = NULL; //DEL _RecordsetPtr pRecTz = NULL; //DEL //DEL _RecordsetPtr pRecProList = NULL; //DEL _RecordsetPtr pRecTzList = NULL; //DEL _RecordsetPtr pRecTdList = NULL; //DEL //DEL DWORD dwProHandle = (DWORD)VAL_ZERO; //DEL DWORD dwProID = (DWORD)VAL_ZERO; //DEL //DEL DWORD dwDevHandle = (DWORD)VAL_ZERO; //DEL DWORD dwDevID = (DWORD)VAL_ZERO; //DEL //DEL DWORD dwTdID = (DWORD)VAL_ZERO; //DEL CString szSql = _T(""); //DEL CString szCaption = _T(""); //DEL /* //DEL hDevItem = pNavDataView->m_navDevDlg.m_devTree.GetSelectedItem(); //DEL dwDevHandle = pNavDataView->m_navDevDlg.m_devTree.GetItemData(hDevItem); //DEL dwDevID = m_handleProcessor.GetIDFromHandle(dwDevHandle); //DEL //DEL pRecPro.CreateInstance(_uuidof(Recordset)); //DEL pRecTz.CreateInstance(_uuidof(Recordset)); //DEL pRecProList.CreateInstance(_uuidof(Recordset)); //DEL pRecTzList.CreateInstance(_uuidof(Recordset)); //DEL pRecTdList.CreateInstance(_uuidof(Recordset)); //DEL //DEL m_pConnection->BeginTrans(); //DEL //DEL try //DEL { //DEL szSql.Empty(); //DEL szSql.Format(_T("select PRID from dptt where DEID = %u and TZID is null"), dwDevID); //DEL pRecProList->Open(szSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), adOpenStatic, adLockOptimistic, adCmdText); //DEL //DEL szSql.Empty(); //DEL szSql.Format(_T("select * from td where DEID = %u"), dwDevID); //DEL pRecTdList->Open(szSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), //DEL adOpenStatic, adLockOptimistic, adCmdText); //DEL //DEL if (VAL_ZERO != pRecTdList->GetRecordCount()) //DEL { //DEL szCaption.Empty(); //DEL szCaption.LoadString(IDS_OP_LD_DEV_TD); //DEL if (IDYES == AfxMessageBox(szCaption, MB_YESNO, MB_ICONQUESTION)) //DEL { //DEL bIsDelTd = true; //DEL } //DEL } //DEL //DEL pRecTdList->Close(); //DEL //DEL while ((short)VAL_ZERO == pRecProList->adoEOF) //DEL { //DEL //DEL dwProID = (DWORD)pRecProList->GetCollect(_T("PRID")).ulVal; //DEL //DEL szSql.Empty(); //DEL szSql.Format(_T("select TZID from dptt where DEID = %u and PRID = %u and TZID is not null"), dwDevID ,dwProID); //DEL pRecTzList->Open(szSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), //DEL adOpenStatic, adLockOptimistic, adCmdText); //DEL //DEL while ((short)VAL_ZERO == pRecTzList->adoEOF) //DEL { //DEL if (bIsDelTd) //DEL { //DEL szSql.Empty(); //DEL szSql.Format(_T("select ID,TDtype from td where DEID = %u and TZID = %u"), dwDevID, pRecTzList->GetCollect(_T("TZID")).ulVal); //DEL pRecTdList->Open(szSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), //DEL adOpenStatic, adLockOptimistic, adCmdText); //DEL //DEL while ((short)VAL_ZERO == pRecTdList->adoEOF) //DEL { //DEL dwTdID = (DWORD)pRecTdList->GetCollect(_T("ID")).ulVal; //DEL switch (pRecTdList->GetCollect(_T("TDtype")).iVal) //DEL { //DEL case 0: //DEL theApp.m_pTdManager->DeleteRspTd(dwTdID); //DEL theApp.m_pTdManager->DeleteObjInMem(m_handleProcessor.GenerateHandle(dwTdID, PZ_STYLE_TD_RSP)); //DEL break; //DEL case 1: //DEL theApp.m_pTdManager->DeleteIpspTd(dwTdID); //DEL theApp.m_pTdManager->DeleteObjInMem(m_handleProcessor.GenerateHandle(dwTdID, PZ_STYLE_TD_IPSP)); //DEL break; //DEL default: //DEL break; //DEL } //DEL pRecTdList->MoveNext(); //DEL } //DEL pRecTdList->Close(); //DEL } //DEL //DEL theApp.m_pProManager->DeleteTzInLoc(pRecTzList->GetCollect(_T("TZID")).ulVal, dwDevID); //DEL pRecTzList->MoveNext(); //DEL } //DEL pRecTzList->Close(); //DEL theApp.m_pProManager->DeleteProjectInLoc(dwProID, dwDevID); //DEL pRecProList->MoveNext(); //DEL } //DEL pRecProList->Close(); //DEL } //DEL catch (_com_error e) //DEL { //DEL m_pConnection->RollbackTrans(); //DEL return APP_ERR_DB; //DEL } //DEL //DEL m_pConnection->CommitTrans(); //DEL //DEL hProItem = pNavDataView->m_navDevDlg.m_devTree.GetChildItem(hDevItem); //DEL while (NULL != hProItem) //DEL { //DEL pNavDataView->m_navDevDlg.m_devTree.DeleteItem(hProItem); //DEL hProItem = pNavDataView->m_navDevDlg.m_devTree.GetChildItem(hDevItem); //DEL } //DEL //DEL pNavDataView->m_navDevDlg.m_devTree.SelectItem(NULL); //DEL pNavDataView->m_navDevDlg.m_devTree.SelectItem(hDevItem); //DEL //DEL InitialNavDataProDlg(pNavDataView->m_navProDlg); //DEL */ //DEL return uExecCode; //DEL } //DEL UINT CDataOperator::DeleteTdRspInLoc(CNavDataView *pNavDataView) //DEL { //DEL UINT uExecCode = (UINT)APP_SUCCESS; //DEL //DEL HTREEITEM hTdItem = NULL; //DEL HTREEITEM hTzItem = NULL; //DEL //DEL DWORD dwTdHandle = (DWORD)VAL_ZERO; //DEL DWORD dwTdID = (DWORD)VAL_ZERO; //DEL //DEL _RecordsetPtr pRecTd = NULL; //DEL /* //DEL switch (pNavDataView->m_navTab.GetCurSel()) //DEL { //DEL case TAB_INDEX_PRO: //DEL hTdItem = pNavDataView->m_navProDlg.m_proTree.GetSelectedItem(); //DEL hTzItem = pNavDataView->m_navProDlg.m_proTree.GetParentItem(hTdItem); //DEL dwTdHandle = pNavDataView->m_navProDlg.m_proTree.GetItemData(hTdItem); //DEL break; //DEL //DEL case TAB_INDEX_DEV: //DEL hTdItem = pNavDataView->m_navDevDlg.m_devTree.GetSelectedItem(); //DEL hTzItem = pNavDataView->m_navProDlg.m_proTree.GetParentItem(hTdItem); //DEL dwTdHandle = pNavDataView->m_navDevDlg.m_devTree.GetItemData(hTdItem); //DEL break; //DEL //DEL default: //DEL break; //DEL } //DEL //DEL dwTdID = m_handleProcessor.GetIDFromHandle(dwTdHandle); //DEL //DEL pRecTd.CreateInstance(_uuidof(Recordset)); //DEL //DEL try //DEL { //DEL m_pConnection->BeginTrans(); //DEL //DEL theApp.m_pTdManager->DeleteRspTd(dwTdID); //DEL theApp.m_pTdManager->DeleteObjInMem(m_handleProcessor.GenerateHandle(dwTdID, PZ_STYLE_TD_RSP)); //DEL } //DEL catch (_com_error e) //DEL { //DEL m_pConnection->RollbackTrans(); //DEL return APP_ERR_DB; //DEL } //DEL //DEL m_pConnection->CommitTrans(); //DEL //DEL switch (pNavDataView->m_navTab.GetCurSel()) //DEL { //DEL case TAB_INDEX_PRO: //DEL pNavDataView->m_navProDlg.m_proTree.DeleteItem(hTdItem); //DEL pNavDataView->m_navProDlg.m_proTree.SelectItem(NULL); //DEL pNavDataView->m_navProDlg.m_proTree.SelectItem(hTzItem); //DEL InitialNavDataDevDlg(pNavDataView->m_navDevDlg); //DEL break; //DEL //DEL case TAB_INDEX_DEV: //DEL pNavDataView->m_navDevDlg.m_devTree.DeleteItem(hTdItem); //DEL pNavDataView->m_navDevDlg.m_devTree.SelectItem(NULL); //DEL pNavDataView->m_navDevDlg.m_devTree.SelectItem(hTzItem); //DEL InitialNavDataProDlg(pNavDataView->m_navProDlg); //DEL break; //DEL //DEL default: //DEL break; //DEL } //DEL */ //DEL return uExecCode; //DEL } //DEL UINT CDataOperator::DeleteTdIpspInLoc(CNavDataView *pNavDataView) //DEL { //DEL UINT uExecCode = (UINT)APP_SUCCESS; //DEL //DEL HTREEITEM hTdItem = NULL; //DEL HTREEITEM hTzItem = NULL; //DEL //DEL DWORD dwTdHandle = (DWORD)VAL_ZERO; //DEL DWORD dwTdID = (DWORD)VAL_ZERO; //DEL //DEL _RecordsetPtr pRecTd = NULL; //DEL /* //DEL switch (pNavDataView->m_navTab.GetCurSel()) //DEL { //DEL case TAB_INDEX_PRO: //DEL hTdItem = pNavDataView->m_navProDlg.m_proTree.GetSelectedItem(); //DEL hTzItem = pNavDataView->m_navProDlg.m_proTree.GetParentItem(hTdItem); //DEL dwTdHandle = pNavDataView->m_navProDlg.m_proTree.GetItemData(hTdItem); //DEL break; //DEL //DEL case TAB_INDEX_DEV: //DEL hTdItem = pNavDataView->m_navDevDlg.m_devTree.GetSelectedItem(); //DEL hTzItem = pNavDataView->m_navProDlg.m_proTree.GetParentItem(hTdItem); //DEL dwTdHandle = pNavDataView->m_navDevDlg.m_devTree.GetItemData(hTdItem); //DEL break; //DEL //DEL default: //DEL break; //DEL } //DEL //DEL dwTdID = m_handleProcessor.GetIDFromHandle(dwTdHandle); //DEL //DEL pRecTd.CreateInstance(_uuidof(Recordset)); //DEL //DEL try //DEL { //DEL m_pConnection->BeginTrans(); //DEL //DEL theApp.m_pTdManager->DeleteRspTd(dwTdID); //DEL theApp.m_pTdManager->DeleteObjInMem(m_handleProcessor.GenerateHandle(dwTdID, PZ_STYLE_TD_IPSP)); //DEL } //DEL catch (_com_error e) //DEL { //DEL m_pConnection->RollbackTrans(); //DEL return APP_ERR_DB; //DEL } //DEL //DEL m_pConnection->CommitTrans(); //DEL switch (pNavDataView->m_navTab.GetCurSel()) //DEL { //DEL case TAB_INDEX_PRO: //DEL pNavDataView->m_navProDlg.m_proTree.DeleteItem(hTdItem); //DEL pNavDataView->m_navProDlg.m_proTree.SelectItem(NULL); //DEL pNavDataView->m_navProDlg.m_proTree.SelectItem(hTzItem); //DEL InitialNavDataDevDlg(pNavDataView->m_navDevDlg); //DEL break; //DEL //DEL case TAB_INDEX_DEV: //DEL pNavDataView->m_navDevDlg.m_devTree.DeleteItem(hTdItem); //DEL pNavDataView->m_navDevDlg.m_devTree.SelectItem(NULL); //DEL pNavDataView->m_navDevDlg.m_devTree.SelectItem(hTzItem); //DEL InitialNavDataProDlg(pNavDataView->m_navProDlg); //DEL break; //DEL //DEL default: //DEL break; //DEL } //DEL */ //DEL return uExecCode; //DEL } //DEL HTREEITEM CDataOperator::InitialNavDataDevTree(DWORD dwDevID, CString szDevSN, CTreeCtrl &devTree) //DEL { //DEL _RecordsetPtr pRecDev = NULL; //DEL _RecordsetPtr pRecPro = NULL; //DEL _RecordsetPtr pRecTz = NULL; //DEL _RecordsetPtr pRecTd = NULL; //DEL //DEL _RecordsetPtr pRecProID = NULL; //DEL _RecordsetPtr pRecTzID = NULL; //DEL _RecordsetPtr pRecTdID = NULL; //DEL //DEL HTREEITEM hDevItem = NULL; //DEL HTREEITEM hProItem = NULL; //DEL HTREEITEM hTzItem = NULL; //DEL HTREEITEM hTdItem = NULL; //DEL HTREEITEM hParentItem = NULL; //DEL //DEL DWORD dwHandle = (DWORD)VAL_ZERO; //DEL UINT uImageState = (UINT)VAL_ZERO; //DEL //DEL CString szSql; //DEL //DEL pRecPro.CreateInstance(_uuidof(Recordset)); //DEL pRecTz.CreateInstance(_uuidof(Recordset)); //DEL pRecTd.CreateInstance(_uuidof(Recordset)); //DEL //DEL pRecProID.CreateInstance(_uuidof(Recordset)); //DEL pRecTzID.CreateInstance(_uuidof(Recordset)); //DEL pRecTdID.CreateInstance(_uuidof(Recordset)); //DEL //DEL uImageState = m_stateProcessor.ChangeToImageState(PZ_STATE_LOC); //DEL //DEL hDevItem = devTree.InsertItem(szDevSN); //DEL dwHandle = m_handleProcessor.GenerateHandle(dwDevID, PZ_STYLE_DEV_DATA); //DEL devTree.SetItemData(hDevItem, dwHandle); //DEL devTree.SetItemState(hDevItem, (UINT)m_stateProcessor.ChangeToImageState(PZ_STATE_OFFLINE), TVIS_STATEIMAGEMASK); //DEL //DEL szSql.Empty(); //DEL szSql.Format(_T("select distinct PRID from dptt where DEID = %u"), dwDevID); //DEL pRecProID->Open(szSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), adOpenStatic, adLockOptimistic, adCmdText); //DEL //DEL while ((short)VAL_ZERO == pRecProID->adoEOF) //DEL { //DEL szSql.Empty(); //DEL szSql.Format(_T("select PRname,CN from project where ID = %u order by ID"), (DWORD)pRecProID->GetCollect(_T("PRID")).ulVal); //DEL pRecPro->Open(szSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), adOpenStatic, adLockOptimistic, adCmdText); //DEL //DEL if ((long)VAL_ZERO != pRecPro->GetRecordCount()) //DEL { //DEL hProItem = devTree.InsertItem((LPCTSTR)(_bstr_t)pRecPro->GetCollect(_T("PRname")), hDevItem); //DEL //DEL dwHandle = m_handleProcessor.GenerateHandle((DWORD)pRecProID->GetCollect(_T("PRID")).ulVal, PZ_STYLE_PRO); //DEL devTree.SetItemData(hProItem, dwHandle); //DEL devTree.SetItemState(hProItem, uImageState, TVIS_STATEIMAGEMASK); //DEL } //DEL pRecPro->Close(); //DEL //DEL szSql.Empty(); //DEL szSql.Format(_T("select ID from tz where PRID = %u"), dwDevID, (DWORD)pRecProID->GetCollect(_T("PRID")).ulVal); //DEL pRecTzID->Open(szSql.AllocSysString(),_variant_t((IDispatch*)m_pConnection, true), //DEL adOpenStatic, adLockOptimistic, adCmdText); //DEL //DEL while ((short)VAL_ZERO == pRecTzID->adoEOF) //DEL { //DEL if (VT_NULL != pRecTzID->GetCollect(_T("ID")).vt) //DEL { //DEL szSql.Empty(); //DEL szSql.Format(_T("select TZname from tz where ID = %u"), (DWORD)pRecTzID->GetCollect(_T("ID")).ulVal); //DEL pRecTz->Open(szSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), //DEL adOpenStatic, adLockOptimistic, adCmdText); //DEL //DEL hTzItem = devTree.InsertItem(pRecTz->GetCollect(_T("TZname")).vt == VT_NULL ? _T("") : (LPCTSTR)(_bstr_t)pRecTz->GetCollect(_T("TZname")), hProItem); //DEL dwHandle = m_handleProcessor.GenerateHandle((DWORD)pRecTzID->GetCollect(_T("ID")).ulVal, PZ_STYLE_TZ); //DEL devTree.SetItemData(hTzItem, dwHandle); //DEL devTree.SetItemState(hTzItem, uImageState, TVIS_STATEIMAGEMASK); //DEL //DEL pRecTz->Close(); //DEL //DEL szSql.Empty(); //DEL szSql.Format(_T("select ID,TDname,Ttype from td where DEID = %u and TZID = %u order by ID"), dwDevID, (DWORD)pRecTzID->GetCollect(_T("ID")).ulVal); //DEL pRecTd->Open(szSql.AllocSysString(),_variant_t((IDispatch*)m_pConnection, true), //DEL adOpenStatic, adLockOptimistic, adCmdText); //DEL //DEL while ((short)VAL_ZERO == pRecTd->adoEOF) //DEL { //DEL hTdItem = devTree.InsertItem(pRecTd->GetCollect(_T("TDname")).vt == VT_NULL ? _T("") : (LPCTSTR)(_bstr_t)pRecTd->GetCollect(_T("TDname")), hTzItem); //DEL //DEL switch (pRecTd->GetCollect(_T("TDtype")).iVal) //DEL { //DEL case 0: //DEL dwHandle = m_handleProcessor.GenerateHandle((DWORD)pRecTd->GetCollect(_T("ID")).ulVal, PZ_STYLE_TD_RSP); //DEL break; //DEL case 1: //DEL dwHandle = m_handleProcessor.GenerateHandle((DWORD)pRecTd->GetCollect(_T("ID")).ulVal, PZ_STYLE_TD_IPSP); //DEL break; //DEL default: //DEL break; //DEL } //DEL //DEL devTree.SetItemData(hTdItem, dwHandle); //DEL devTree.SetItemState(hTdItem, uImageState, TVIS_STATEIMAGEMASK); //DEL //DEL pRecTd->MoveNext(); //DEL } //while (VAL_ZERO == pRecTd->adoEOF) //DEL pRecTd->Close(); //DEL //DEL hParentItem = devTree.GetParentItem(hTdItem); //DEL // ASSERT(hParentItem != NULL); //DEL if (hParentItem != NULL) //DEL { //DEL devTree.Expand(hParentItem, TVE_EXPAND); //DEL hParentItem = NULL; //DEL } //if (hParentItem != NULL) //DEL } //if (VT_NULL != pRecTzID->GetCollect(_T("TZID")).vt) //DEL //DEL pRecTzID->MoveNext(); //DEL } //while (VAL_ZERO == pRecTzID->adoEOF) //DEL pRecTzID->Close(); //DEL //DEL hParentItem = devTree.GetParentItem(hTzItem); //DEL // ASSERT(hParentItem != NULL); //DEL if (hParentItem != NULL) //DEL { //DEL devTree.Expand(hParentItem, TVE_EXPAND); //DEL hParentItem = NULL; //DEL } //if (hParentItem != NULL) //DEL //DEL pRecProID->MoveNext(); //DEL //DEL } //while (VAL_ZERO == pRecProID->adoEOF) //DEL pRecProID->Close(); //DEL //DEL hParentItem = devTree.GetParentItem(hProItem); //DEL // ASSERT(hParentItem != NULL); //DEL if (hParentItem != NULL) //DEL { //DEL devTree.Expand(hParentItem, TVE_EXPAND); //DEL hParentItem = NULL; //DEL } //if (hParentItem != NULL) //DEL //DEL devTree.SelectSetFirstVisible(devTree.GetRootItem()); //DEL return hDevItem; //DEL } //DEL bool CDataOperator::AddTzInDevTreeByLoc(CNavDataDevDlg &navDataDevDlg, DWORD dwDevID, DWORD dwTzID, HTREEITEM hProItem) //DEL { //DEL _RecordsetPtr pRecTz = NULL; //DEL HTREEITEM hTzItem = NULL; //DEL //DEL DWORD dwTzHandle = (DWORD)VAL_ZERO; //DEL UINT uImageState = (UINT)VAL_ZERO; //DEL CString szSql; //DEL //DEL pRecTz.CreateInstance(_uuidof(Recordset)); //DEL //DEL szSql.Empty(); //DEL szSql.Format(_T("select TZname from tz where ID = %u"), dwTzID); //DEL pRecTz->Open(szSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), adOpenStatic, adLockOptimistic, adCmdText); //DEL //DEL hTzItem = navDataDevDlg.m_devTree.InsertItem((pRecTz->GetCollect(_T("TZname")).vt == VT_NULL) ? _T("") : (LPCTSTR)(_bstr_t)pRecTz->GetCollect(_T("TZname")), hProItem); //DEL dwTzHandle = m_handleProcessor.GenerateHandle(dwTzID, PZ_STYLE_TZ); //DEL navDataDevDlg.m_devTree.SetItemData(hTzItem, dwTzHandle); //DEL //DEL uImageState = m_stateProcessor.ChangeToImageState(PZ_STATE_LOC); //DEL navDataDevDlg.m_devTree.SetItemState(hTzItem, uImageState, TVIS_STATEIMAGEMASK); //DEL //DEL pRecTz->Close(); //DEL //DEL AddTdInDevTreeByLoc(navDataDevDlg, dwDevID, dwTzID, hTzItem); //DEL //DEL navDataDevDlg.m_devTree.Expand(hTzItem, TVE_EXPAND); //DEL return true; //DEL } //DEL bool CDataOperator::AddTdInDevTreeByLoc(CNavDataDevDlg &navDataDevDlg, DWORD dwDevID, DWORD dwTzID, HTREEITEM hTzItem) //DEL { //DEL _RecordsetPtr pRecTdList = NULL; //DEL HTREEITEM hTdItem = NULL; //DEL //DEL DWORD dwTdHandle = (DWORD)VAL_ZERO; //DEL UINT uImageState = (UINT)VAL_ZERO; //DEL CString szSql = _T(""); //DEL //DEL uImageState = m_stateProcessor.ChangeToImageState(PZ_STATE_LOC); //DEL //DEL pRecTdList.CreateInstance(_uuidof(Recordset)); //DEL szSql.Empty(); //DEL szSql.Format(_T("select ID,TDname,TDtype from td where DEID = %u and TZID = %u order by ID"), dwDevID, dwTzID); //DEL pRecTdList->Open(szSql.AllocSysString(),_variant_t((IDispatch*)m_pConnection, true), //DEL adOpenStatic, adLockOptimistic, adCmdText); //DEL //DEL while ((short)VAL_ZERO == pRecTdList->adoEOF) //DEL { //DEL hTdItem = navDataDevDlg.m_devTree.InsertItem(pRecTdList->GetCollect(_T("TDname")).vt == VT_NULL ? _T("") : (LPCTSTR)(_bstr_t)pRecTdList->GetCollect(_T("TDname")), hTzItem); //DEL //DEL switch (pRecTdList->GetCollect(_T("TDtype")).iVal) //DEL { //DEL case 0: //DEL dwTdHandle = m_handleProcessor.GenerateHandle((DWORD)pRecTdList->GetCollect(_T("ID")).ulVal, PZ_STYLE_TD_RSP); //DEL break; //DEL case 1: //DEL dwTdHandle = m_handleProcessor.GenerateHandle((DWORD)pRecTdList->GetCollect(_T("ID")).ulVal, PZ_STYLE_TD_IPSP); //DEL break; //DEL default: //DEL break; //DEL } //DEL //DEL navDataDevDlg.m_devTree.SetItemData(hTdItem, dwTdHandle); //DEL navDataDevDlg.m_devTree.SetItemState(hTdItem, uImageState, TVIS_STATEIMAGEMASK); //DEL //DEL pRecTdList->MoveNext(); //DEL } //while (VAL_ZERO == pRecTd->adoEOF) //DEL pRecTdList->Close(); //DEL //DEL return true; //DEL } UINT CDataOperator::ExportRsp3DTdToDAT(CNavDataView *pNavDataView, CString f_szFileName) { UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); if (TRUE == m_BatchExportFlag) { dwTdHandle = m_dwItemHandle; } try { if (TRUE != theApp.m_pTdManager->GetTestingData(dwTdHandle)->SaveTdToRes3DFile(f_szFileName)) { uExecCode = (UINT)APP_FAIL; } } catch (...) { uExecCode = (UINT)APP_SUCCESS; } return uExecCode; } UINT CDataOperator::ExportRsp3DTdToExcel(CNavDataView *pNavDataView, CString f_szFileName) { UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); if (TRUE == m_BatchExportFlag) { dwTdHandle = m_dwItemHandle; } try { if (TRUE != theApp.m_pTdManager->GetTestingData(dwTdHandle)->SaveTdToExcelFile(f_szFileName)) { uExecCode = (UINT)APP_FAIL; } } catch (...) { uExecCode = (UINT)APP_FAIL; } return uExecCode; } UINT CDataOperator::ExportRsp3DTdToCSV(CNavDataView *pNavDataView, CString f_szFileName) { UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); if (TRUE == m_BatchExportFlag) { dwTdHandle = m_dwItemHandle; } try { if (TRUE != theApp.m_pTdManager->GetTestingData(dwTdHandle)->SaveTdToCsvFile(f_szFileName)) { uExecCode = (UINT)APP_FAIL; } } catch (...) { uExecCode = (UINT)APP_FAIL; } return uExecCode; } UINT CDataOperator::ExportRsp3DTdToTxt(CNavDataView *pNavDataView, CString f_szFileName) { UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); if (TRUE == m_BatchExportFlag) { dwTdHandle = m_dwItemHandle; } try { if (TRUE != theApp.m_pTdManager->GetTestingData(dwTdHandle)->ExportResDataToTxt(f_szFileName)) { uExecCode = (UINT)APP_FAIL; } } catch (...) { uExecCode = (UINT)APP_SUCCESS; } return uExecCode; } UINT CDataOperator::ExportRsp3DTdToUrf(CNavDataView *pNavDataView, CString f_szFileName) { UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); if (TRUE == m_BatchExportFlag) { dwTdHandle = m_dwItemHandle; } try { if (TRUE != theApp.m_pTdManager->GetTestingData(dwTdHandle)->ExportDataToUrf(f_szFileName)) { uExecCode = (UINT)APP_FAIL; } } catch (...) { uExecCode = (UINT)APP_SUCCESS; } return uExecCode; } UINT CDataOperator::DisplayIspCETdGraph(CNavDataView *pNavDataView) { // AfxMessageBox("comming soon"); return 0; } UINT CDataOperator::DisplayIsp2DTdGraph(CNavDataView *pNavDataView) { // AfxMessageBox("comming soon"); return 0; } UINT CDataOperator::DisplayIsp3DTdGraph(CNavDataView *pNavDataView) { // AfxMessageBox("comming soon"); return 0; } UINT CDataOperator::DisplayIsp3DTdIpCurve(CNavDataView *pNavDataView) { UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); try { theApp.m_pTdManager->GetTestingData(dwTdHandle)->LoadData(theApp.m_pSptManager->m_medLinkList); if (TRUE != theApp.m_pTdManager->GetTestingData(dwTdHandle)->DisplayIpCurveGraph())//1D 2D 3D调用同样的接口 { uExecCode = (UINT)APP_FAIL; } } catch (...) { uExecCode = (UINT)APP_FAIL; } return uExecCode; } UINT CDataOperator::DisplayIspCETdIpCurve(CNavDataView *pNavDataView) { //AfxMessageBox("comming soon CE"); UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); try { theApp.m_pTdManager->GetTestingData(dwTdHandle)->LoadData(theApp.m_pSptManager->m_medLinkList); if (TRUE != theApp.m_pTdManager->GetTestingData(dwTdHandle)->DisplayIpCurveGraph()) { uExecCode = (UINT)APP_FAIL; } } catch (...) { uExecCode = (UINT)APP_FAIL; } return uExecCode; } UINT CDataOperator::DisplayIsp2DTdIpCurve(CNavDataView *pNavDataView) { UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); try { theApp.m_pTdManager->GetTestingData(dwTdHandle)->LoadData(theApp.m_pSptManager->m_medLinkList); if (TRUE != theApp.m_pTdManager->GetTestingData(dwTdHandle)->DisplayIpCurveGraph())//1D、2D、3D调用同样的界面 { uExecCode = (UINT)APP_FAIL; } } catch (...) { if (LANG_ZHCN == g_iUILanguage) AfxMessageBox(_T("发生异常")); else MessageBoxEx(NULL, _T("Exception is occuried!!!"), STRING_MESSAGEBOXEX_TITLE, MB_OK, MAKELANGID(LANG_ENGLISH, SUBLANG_ENGLISH_US)); uExecCode = (UINT)APP_FAIL; } return uExecCode; } UINT CDataOperator::ExportRspCETdToDAT(CNavDataView *pNavDataView, CString f_szFileName) { UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); if (TRUE == m_BatchExportFlag) { dwTdHandle = m_dwItemHandle; } try { if (TRUE != theApp.m_pTdManager->GetTestingData(dwTdHandle)->SaveTdToResCEFile(f_szFileName)) { uExecCode = (UINT)APP_FAIL; } } catch (...) { uExecCode = (UINT)APP_SUCCESS; } return uExecCode; } UINT CDataOperator::ExportIpSpCETdToDAT(CNavDataView *pNavDataView, CString f_szFileName) { UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); if (TRUE == m_BatchExportFlag) { dwTdHandle = m_dwItemHandle; } try { if (TRUE != theApp.m_pTdManager->GetTestingData(dwTdHandle)->SaveTdToResCEFile(f_szFileName)) { uExecCode = (UINT)APP_FAIL; } } catch (...) { uExecCode = (UINT)APP_SUCCESS; } return uExecCode; } void CDataOperator::ShowSPCETdInfo(DWORD dwTdHandle, CView *pAppDataView) { theApp.m_pTdManager->GetTestingData(dwTdHandle)->ShowDetailInfo(((CAppDataTdDetailListView*)(((CAppDataSPCETdView*)pAppDataView)->m_pDetailListView))->GetListCtrl()); theApp.m_pTdManager->GetTestingData(dwTdHandle)->ShowConList(((CAppDataSPCETdConListView_*)(((CAppDataSPCETdView*)pAppDataView)->m_pContentListView))->GetListCtrl()); theApp.m_pTdManager->GetTestingData(dwTdHandle)->ShowGrList(((CAppDataCESTdGrListView*)(((CAppDataSPCETdView*)pAppDataView)->m_pGrListView))->GetListCtrl()); } void CDataOperator::ShowSP2DTdInfo(DWORD dwTdHandle, CView *pAppDataView) { theApp.m_pTdManager->GetTestingData(dwTdHandle)->ShowDetailInfo(((CAppDataTdDetailListView*)(((CAppDataSP2DTdView*)pAppDataView)->m_pDetailListView))->GetListCtrl()); theApp.m_pTdManager->GetTestingData(dwTdHandle)->ShowConList(((CAppDataSP2DTdConListView*)(((CAppDataSP2DTdView*)pAppDataView)->m_pContentListView))->GetListCtrl()); theApp.m_pTdManager->GetTestingData(dwTdHandle)->ShowGrList(((CAppDataTdGrListView*)(((CAppDataSP2DTdView*)pAppDataView)->m_pGrListView))->GetListCtrl()); } void CDataOperator::ShowSP3DTdInfo(DWORD dwTdHandle, CView *pAppDataView) { theApp.m_pTdManager->GetTestingData(dwTdHandle)->ShowDetailInfo(((CAppDataTdDetailListView*)(((CAppDataSP3DTdView*)pAppDataView)->m_pDetailListView))->GetListCtrl()); theApp.m_pTdManager->GetTestingData(dwTdHandle)->ShowConList(((CAppDataSP3DTdConListView*)(((CAppDataSP3DTdView*)pAppDataView)->m_pContentListView))->GetListCtrl()); theApp.m_pTdManager->GetTestingData(dwTdHandle)->ShowGrList(((CAppDataTdGrListView*)(((CAppDataSP3DTdView*)pAppDataView)->m_pGrListView))->GetListCtrl()); } void CDataOperator::LoadSPCERecordbyPage(DWORD dwTdHandle, CView *pAppDataView, int iSType/* = 1*/) { theApp.m_pTdManager->GetTestingData(dwTdHandle)->ShowConListByPage(((CAppDataSPCETdConListView_*)(((CAppDataSPCETdView*)pAppDataView)->m_pContentListView))->GetListCtrl(), iSType); } void CDataOperator::LoadSP2dRecordbyPage(DWORD dwTdHandle, CView *pAppDataView, int iSType/* = 2*/) { theApp.m_pTdManager->GetTestingData(dwTdHandle)->ShowConListByPage(((CAppDataSP2DTdConListView*)(((CAppDataSP2DTdView*)pAppDataView)->m_pContentListView))->GetListCtrl(), iSType); } void CDataOperator::LoadSP3dRecordbyPage(DWORD dwTdHandle, CView *pAppDataView, int iSType/* = 3*/) { theApp.m_pTdManager->GetTestingData(dwTdHandle)->ShowConListByPage(((CAppDataSP3DTdConListView*)(((CAppDataSP3DTdView*)pAppDataView)->m_pContentListView))->GetListCtrl(), iSType); } UINT CDataOperator::ExportSP3DTdToExcel(CNavDataView *pNavDataView, CString f_szFileName) { UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); if (TRUE == m_BatchExportFlag) { dwTdHandle = m_dwItemHandle; } try { if (TRUE != theApp.m_pTdManager->GetTestingData(dwTdHandle)->SaveTdToExcelFile(f_szFileName)) { uExecCode = (UINT)APP_FAIL; } } catch (...) { uExecCode = (UINT)APP_FAIL; } return uExecCode; } UINT CDataOperator::ExportSP3DTdToCSV(CNavDataView *pNavDataView, CString f_szFileName) { UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); if (TRUE == m_BatchExportFlag) { dwTdHandle = m_dwItemHandle; } try { if (TRUE != theApp.m_pTdManager->GetTestingData(dwTdHandle)->SaveTdToCsvFile(f_szFileName)) { uExecCode = (UINT)APP_FAIL; } } catch (...) { uExecCode = (UINT)APP_FAIL; } return uExecCode; } UINT CDataOperator::ExportSP3DTdToTxt(CNavDataView *pNavDataView, CString f_szFileName) { UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); if (TRUE == m_BatchExportFlag) { dwTdHandle = m_dwItemHandle; } try { if (TRUE != theApp.m_pTdManager->GetTestingData(dwTdHandle)->ExportSpDataToTxt(f_szFileName)) { uExecCode = (UINT)APP_FAIL; } } catch (...) { uExecCode = (UINT)APP_SUCCESS; } return uExecCode; } UINT CDataOperator::ExportSP2DTdToExcel(CNavDataView *pNavDataView, CString f_szFileName) { UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); if (TRUE == m_BatchExportFlag) { dwTdHandle = m_dwItemHandle; } try { if (TRUE != theApp.m_pTdManager->GetTestingData(dwTdHandle)->SaveTdToExcelFile(f_szFileName)) { uExecCode = (UINT)APP_FAIL; } } catch (...) { uExecCode = (UINT)APP_FAIL; } return uExecCode; } UINT CDataOperator::ExportSP2DTdToCSV(CNavDataView *pNavDataView, CString f_szFileName) { UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); if (TRUE == m_BatchExportFlag) { dwTdHandle = m_dwItemHandle; } try { if (TRUE != theApp.m_pTdManager->GetTestingData(dwTdHandle)->SaveTdToCsvFile(f_szFileName)) { uExecCode = (UINT)APP_FAIL; } } catch (...) { uExecCode = (UINT)APP_FAIL; } return uExecCode; } UINT CDataOperator::ExportSP2DTdToTxt(CNavDataView *pNavDataView, CString f_szFileName) { UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); if (TRUE == m_BatchExportFlag) { dwTdHandle = m_dwItemHandle; } try { if (TRUE != theApp.m_pTdManager->GetTestingData(dwTdHandle)->ExportSpDataToTxt(f_szFileName)) { uExecCode = (UINT)APP_FAIL; } } catch (...) { uExecCode = (UINT)APP_SUCCESS; } return uExecCode; } UINT CDataOperator::ExportSPCETdToExcel(CNavDataView *pNavDataView, CString f_szFileName) { UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); if (TRUE == m_BatchExportFlag) { dwTdHandle = m_dwItemHandle; } try { if (TRUE != theApp.m_pTdManager->GetTestingData(dwTdHandle)->SaveTdToExcelFile(f_szFileName)) { uExecCode = (UINT)APP_FAIL; } } catch (...) { uExecCode = (UINT)APP_FAIL; } return uExecCode; } UINT CDataOperator::ExportSPCETdToCSV(CNavDataView *pNavDataView, CString f_szFileName) { UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); if (TRUE == m_BatchExportFlag) { dwTdHandle = m_dwItemHandle; } try { if (TRUE != theApp.m_pTdManager->GetTestingData(dwTdHandle)->SaveTdToCsvFile(f_szFileName)) { uExecCode = (UINT)APP_FAIL; } } catch (...) { uExecCode = (UINT)APP_FAIL; } return uExecCode; } UINT CDataOperator::ExportSPCETdToTxt(CNavDataView *pNavDataView, CString f_szFileName) { UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); if (TRUE == m_BatchExportFlag) { dwTdHandle = m_dwItemHandle; } try { if (TRUE != theApp.m_pTdManager->GetTestingData(dwTdHandle)->ExportSpDataToTxt(f_szFileName)) { uExecCode = (UINT)APP_FAIL; } } catch (...) { uExecCode = (UINT)APP_SUCCESS; } return uExecCode; } UINT CDataOperator::ExportIpCETdToExcel(CNavDataView *pNavDataView, CString f_szFileName) { UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); if (TRUE == m_BatchExportFlag) { dwTdHandle = m_dwItemHandle; } try { if (TRUE != theApp.m_pTdManager->GetTestingData(dwTdHandle)->SaveTdToExcelFile(f_szFileName)) { uExecCode = (UINT)APP_FAIL; } } catch (...) { uExecCode = (UINT)APP_FAIL; } return uExecCode; } UINT CDataOperator::ExportIpCETdToCSV(CNavDataView *pNavDataView, CString f_szFileName) { UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); if (TRUE == m_BatchExportFlag) { dwTdHandle = m_dwItemHandle; } try { if (TRUE != theApp.m_pTdManager->GetTestingData(dwTdHandle)->SaveTdToCsvFile(f_szFileName)) { uExecCode = (UINT)APP_FAIL; } } catch (...) { uExecCode = (UINT)APP_FAIL; } return uExecCode; } UINT CDataOperator::ExportIp2DTdToExcel(CNavDataView *pNavDataView, CString f_szFileName) { UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; if (NULL == pNavDataView) { ASSERT(pNavDataView != NULL); uExecCode = (UINT)APP_FAIL; return uExecCode; } CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); if (TRUE == m_BatchExportFlag) { dwTdHandle = m_dwItemHandle; } try { if (NULL == theApp.m_pTdManager) { ASSERT(theApp.m_pTdManager != NULL); uExecCode = (UINT)APP_FAIL; return uExecCode; } CTestingData* pTestingData = theApp.m_pTdManager->GetTestingData(dwTdHandle); if (NULL == pTestingData) { ASSERT(pTestingData != NULL); uExecCode = (UINT)APP_FAIL; return uExecCode; } if (TRUE != pTestingData->SaveTdToExcelFile(f_szFileName)) { uExecCode = (UINT)APP_FAIL; } } //catch (...) catch (...) { uExecCode = (UINT)APP_FAIL; } return uExecCode; } UINT CDataOperator::ExportIp3DTdToExcel(CNavDataView *pNavDataView, CString f_szFileName) { UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); if (TRUE == m_BatchExportFlag) { dwTdHandle = m_dwItemHandle; } try { if (TRUE != theApp.m_pTdManager->GetTestingData(dwTdHandle)->SaveTdToExcelFile(f_szFileName)) { uExecCode = (UINT)APP_FAIL; } } catch (...) { uExecCode = (UINT)APP_FAIL; } return uExecCode; } UINT CDataOperator::ExportIp2DTdToCSV(CNavDataView *pNavDataView, CString f_szFileName) { UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; if (NULL == pNavDataView) { ASSERT(pNavDataView != NULL); uExecCode = (UINT)APP_FAIL; return uExecCode; } CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); if (TRUE == m_BatchExportFlag) { dwTdHandle = m_dwItemHandle; } try { if (NULL == theApp.m_pTdManager) { ASSERT(theApp.m_pTdManager != NULL); uExecCode = (UINT)APP_FAIL; return uExecCode; } CTestingData* pTestingData = theApp.m_pTdManager->GetTestingData(dwTdHandle); if (NULL == pTestingData) { ASSERT(pTestingData != NULL); uExecCode = (UINT)APP_FAIL; return uExecCode; } if (TRUE != pTestingData->SaveTdToCsvFile(f_szFileName)) { uExecCode = (UINT)APP_FAIL; } } //catch (...) catch (...) { uExecCode = (UINT)APP_FAIL; } return uExecCode; } UINT CDataOperator::ExportIp3DTdToCSV(CNavDataView *pNavDataView, CString f_szFileName) { UINT uExecCode = (UINT)APP_SUCCESS; DWORD dwTdHandle = (DWORD)VAL_ZERO; HTREEITEM hTdItem = NULL; CTreeCtrl& dataTree = pNavDataView->m_dataTree; hTdItem = dataTree.GetSelectedItem(); dwTdHandle = dataTree.GetItemData(hTdItem); if (TRUE == m_BatchExportFlag) { dwTdHandle = m_dwItemHandle; } try { if (TRUE != theApp.m_pTdManager->GetTestingData(dwTdHandle)->SaveTdToCsvFile(f_szFileName)) { uExecCode = (UINT)APP_FAIL; } } catch (...) { uExecCode = (UINT)APP_FAIL; } return uExecCode; } UINT CDataOperator::Delete2DRecord(CNavDataView *pNavDataView, int iTSN) { UINT uExecCode = (UINT)APP_SUCCESS; HTREEITEM hTdItem = NULL; HTREEITEM hTzItem = NULL; DWORD dwTdHandle = (DWORD)VAL_ZERO; DWORD dwTdID = (DWORD)VAL_ZERO; hTdItem = pNavDataView->m_dataTree.GetSelectedItem(); hTzItem = pNavDataView->m_dataTree.GetParentItem(hTdItem); dwTdHandle = pNavDataView->m_dataTree.GetItemData(hTdItem); dwTdID = m_handleProcessor.GetIDFromHandle(dwTdHandle); CString szSql = _T(""); try { _CommandPtr pCmdDelRspTd = NULL; pCmdDelRspTd.CreateInstance(_uuidof(Command)); pCmdDelRspTd->ActiveConnection = m_pConnection; szSql.Empty(); szSql.Format(_T("update td2dcon set bUse = false where TCHID in (select ID from tdchannel where TDID = %u) and TSN = %d"), dwTdID,iTSN); pCmdDelRspTd->CommandText = szSql.AllocSysString(); pCmdDelRspTd->Execute(NULL, NULL, adCmdText); //更新测点数量减1 szSql.Empty(); szSql.Format(_T("update td set TPamount = TPamount - 1 where ID = %d "), dwTdID); pCmdDelRspTd->CommandText = szSql.AllocSysString(); pCmdDelRspTd->Execute(NULL, NULL, adCmdText); } catch (_com_error e) { AfxMessageBox(e.Description()); return APP_ERR_DB; } return uExecCode; } UINT CDataOperator::Delete1DRecord(CNavDataView *pNavDataView, int iTSN) { UINT uExecCode = (UINT)APP_SUCCESS; HTREEITEM hTdItem = NULL; HTREEITEM hTzItem = NULL; DWORD dwTdHandle = (DWORD)VAL_ZERO; DWORD dwTdID = (DWORD)VAL_ZERO; hTdItem = pNavDataView->m_dataTree.GetSelectedItem(); hTzItem = pNavDataView->m_dataTree.GetParentItem(hTdItem); dwTdHandle = pNavDataView->m_dataTree.GetItemData(hTdItem); dwTdID = m_handleProcessor.GetIDFromHandle(dwTdHandle); CString szSql = _T(""); try { _CommandPtr pCmdDelRspTd = NULL; pCmdDelRspTd.CreateInstance(_uuidof(Command)); pCmdDelRspTd->ActiveConnection = m_pConnection; szSql.Empty(); szSql.Format(_T("update td1dcon set bUse = false where TCHID in (select ID from tdchannel where TDID = %u) and TSN = %d"), dwTdID,iTSN); pCmdDelRspTd->CommandText = szSql.AllocSysString(); pCmdDelRspTd->Execute(NULL, NULL, adCmdText); //更新测点数量减1 szSql.Empty(); szSql.Format(_T("update td set TPamount = TPamount - 1 where ID = %d "), dwTdID); pCmdDelRspTd->CommandText = szSql.AllocSysString(); pCmdDelRspTd->Execute(NULL, NULL, adCmdText); } catch (_com_error e) { AfxMessageBox(e.Description()); return APP_ERR_DB; } return uExecCode; } UINT CDataOperator::Delete3DRecord(CNavDataView *pNavDataView, int iTSN) { UINT uExecCode = (UINT)APP_SUCCESS; HTREEITEM hTdItem = NULL; HTREEITEM hTzItem = NULL; DWORD dwTdHandle = (DWORD)VAL_ZERO; DWORD dwTdID = (DWORD)VAL_ZERO; hTdItem = pNavDataView->m_dataTree.GetSelectedItem(); hTzItem = pNavDataView->m_dataTree.GetParentItem(hTdItem); dwTdHandle = pNavDataView->m_dataTree.GetItemData(hTdItem); dwTdID = m_handleProcessor.GetIDFromHandle(dwTdHandle); CString szSql = _T(""); try { _CommandPtr pCmdDelRspTd = NULL; pCmdDelRspTd.CreateInstance(_uuidof(Command)); pCmdDelRspTd->ActiveConnection = m_pConnection; szSql.Empty(); szSql.Format(_T("update td3dcon set bUse = false where TCHID in (select ID from tdchannel where TDID = %u) and TSN = %d"), dwTdID,iTSN); pCmdDelRspTd->CommandText = szSql.AllocSysString(); pCmdDelRspTd->Execute(NULL, NULL, adCmdText); //更新测点数量减1 szSql.Empty(); szSql.Format(_T("update td set TPamount = TPamount - 1 where ID = %d "), dwTdID); pCmdDelRspTd->CommandText = szSql.AllocSysString(); pCmdDelRspTd->Execute(NULL, NULL, adCmdText); } catch (_com_error e) { AfxMessageBox(e.Description()); return APP_ERR_DB; } return uExecCode; } void CDataOperator::CombineTask(CNavDataView *pNavData) { HTREEITEM hProItem = NULL; HTREEITEM hTdItem = NULL; DWORD dwHandle; DWORD dwProHandle = (DWORD)VAL_ZERO; DWORD dwProID = (DWORD)VAL_ZERO; UINT uImageState = (UINT)VAL_ZERO; uImageState = m_stateProcessor.ChangeToImageState(PZ_STATE_DB); hProItem = pNavData->m_dataTree.GetSelectedItem(); dwProHandle = pNavData->m_dataTree.GetItemData(hProItem); dwProID = m_handleProcessor.GetIDFromHandle(dwProHandle); CDialCombine3DTask dialCmb3DTask(m_pConnection, dwProID); if (IDOK == dialCmb3DTask.DoModal()) { hTdItem = pNavData->m_dataTree.InsertItem(dialCmb3DTask.m_strTaskName,hProItem); dwHandle = m_handleProcessor.GenerateHandle(dialCmb3DTask.m_dwTdID,GetTestType(dialCmb3DTask.m_iSptType, dialCmb3DTask.m_iTestType)); pNavData->m_dataTree.SetItemData(hTdItem, dwHandle); pNavData->m_dataTree.SetItemState(hTdItem, uImageState, TVIS_STATEIMAGEMASK); pNavData->m_dataTree.SelectItem(hTdItem); } //旧的三维合并方案 /* HTREEITEM hTzItem = NULL; HTREEITEM hTdItem = NULL; DWORD dwHandle; ////////////////////////////////////////////////////////////////////////// DWORD dwTzHandle = (DWORD)VAL_ZERO; DWORD dwTzID = (DWORD)VAL_ZERO; hTzItem = pNavData->m_dataTree.GetSelectedItem(); dwTzHandle = pNavData->m_dataTree.GetItemData(hTzItem); dwTzID = m_handleProcessor.GetIDFromHandle(dwTzHandle); _RecordsetPtr pRecTz = NULL; pRecTz.CreateInstance(_uuidof(Recordset)); CString strQuery = _T(""); //在这里TZtype应该选3，但是现在由于此函数不可用，所以暂时不改 strQuery.Format(_T("select * from tz where TZtype =2 and ID = %d"), dwTzID); pRecTz->Open(strQuery.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), adOpenStatic, adLockOptimistic, adCmdText); //如果没有记录，则表明此测区不是三维的测区，则不支持进行任务的合并 if ((long)VAL_ZERO == pRecTz->GetRecordCount()) { AfxMessageBox(_T("Not support combine task in this testzone's type!")); pRecTz->Close(); return; } pRecTz->Close(); ////////////////////////////////////////////////////////////////////////// hTzItem = NULL; UINT uImageState = (UINT)VAL_ZERO; uImageState = m_stateProcessor.ChangeToImageState(PZ_STATE_DB); CCombineDlg CombineDlg(pNavData, m_handleProcessor, m_pConnection); if (CombineDlg.DoModal() == IDOK) { hTzItem = pNavData->m_dataTree.GetSelectedItem(); hTdItem = pNavData->m_dataTree.InsertItem(CombineDlg.m_szTaskName,hTzItem); dwHandle = CombineDlg.m_handleProcessor.GenerateHandle(CombineDlg.m_TdID, GetTestType(CombineDlg.m_scriptType, CombineDlg.m_testType)); pNavData->m_dataTree.SetItemData(hTdItem, dwHandle); pNavData->m_dataTree.SetItemState(hTdItem, uImageState, TVIS_STATEIMAGEMASK); pNavData->m_dataTree.SelectItem(hTdItem); } */ } void CDataOperator::ExportTdOrgFile(CNavDataView *pNavData) { //这个函数还没有实现完成 if (NULL == pNavData) { return; } HTREEITEM hProItem = NULL; HTREEITEM hTdItem = NULL; DWORD dwProHandle = (DWORD)VAL_ZERO; DWORD dwProID = (DWORD)VAL_ZERO; DWORD dwTdHandle = (DWORD)VAL_ZERO; DWORD dwTdID = (DWORD)VAL_ZERO; hTdItem = pNavData->m_dataTree.GetSelectedItem(); hProItem = pNavData->m_dataTree.GetParentItem(hTdItem); if (NULL == hProItem || NULL == hTdItem) { if (LANG_ZHCN == g_iUILanguage) AfxMessageBox(_T("获取树节点失败")); else MessageBoxEx(NULL, _T("Get tree item failed."), STRING_MESSAGEBOXEX_TITLE, MB_OK, MAKELANGID(LANG_ENGLISH, SUBLANG_ENGLISH_US)); return; } CString strTdName = pNavData->m_dataTree.GetItemText(hTdItem); dwProHandle = pNavData->m_dataTree.GetItemData(hProItem); dwProID = m_handleProcessor.GetIDFromHandle(dwProHandle); dwTdHandle = pNavData->m_dataTree.GetItemData(hTdItem); dwTdID = m_handleProcessor.GetIDFromHandle(dwTdHandle); _RecordsetPtr pRecProID = NULL; _RecordsetPtr pRecTdID = NULL; _RecordsetPtr pRecTzID = NULL; CString szSql = _T(""); CString szFileName = _T(""); CString szDstFile = _T(""); CString strProCN = _T(""); CString strTzCN = _T(""); CString strTdCN = _T(""); CString szLocFilePath = _T(""); pRecProID.CreateInstance(_uuidof(Recordset)); pRecTdID.CreateInstance(_uuidof(Recordset)); pRecTzID.CreateInstance(_uuidof(Recordset)); //查询工程的CN szSql.Empty(); szSql.Format(_T("select CN from project where ID = %d"), dwProID); pRecProID->Open(szSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), adOpenStatic, adLockOptimistic, adCmdText); if ((long)VAL_ZERO == pRecProID->GetRecordCount()) { if (LANG_ZHCN == g_iUILanguage) AfxMessageBox(_T("无法查询项目的CN信息")); else MessageBoxEx(NULL, _T("Can not query project's CN information."), STRING_MESSAGEBOXEX_TITLE, MB_OK, MAKELANGID(LANG_ENGLISH, SUBLANG_ENGLISH_US)); pRecProID->Close(); return; } strProCN = pRecProID->GetCollect(_T("CN")).vt == VT_NULL ? _T("") : (LPCTSTR)(_bstr_t)pRecProID->GetCollect(_T("CN")); pRecProID->Close(); if (strProCN.IsEmpty()) { if (LANG_ZHCN == g_iUILanguage) AfxMessageBox(_T("项目的CN信息为空")); else MessageBoxEx(NULL, _T("Project's CN information is empty."), STRING_MESSAGEBOXEX_TITLE, MB_OK, MAKELANGID(LANG_ENGLISH, SUBLANG_ENGLISH_US)); return; } //查询测区的CN szSql.Empty(); szSql.Format(_T("select CN from tz where PRID = %d"), dwProID); pRecTzID->Open(szSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), adOpenStatic, adLockOptimistic, adCmdText); if ((long)VAL_ZERO == pRecTzID->GetRecordCount()) { if (LANG_ZHCN == g_iUILanguage) AfxMessageBox(_T("无法查询测试区域的CN信息")); else MessageBoxEx(NULL, _T("Can not query testzone's CN information."), STRING_MESSAGEBOXEX_TITLE, MB_OK, MAKELANGID(LANG_ENGLISH, SUBLANG_ENGLISH_US)); pRecTzID->Close(); return; } strTzCN = pRecTzID->GetCollect(_T("CN")).vt == VT_NULL ? _T("") : (LPCTSTR)(_bstr_t)pRecTzID->GetCollect(_T("CN")); pRecTzID->Close(); if (strTzCN.IsEmpty()) { if (LANG_ZHCN == g_iUILanguage) AfxMessageBox(_T("测试区域的CN信息是空")); else MessageBoxEx(NULL, _T("Testzone's CN information is empty."), STRING_MESSAGEBOXEX_TITLE, MB_OK, MAKELANGID(LANG_ENGLISH, SUBLANG_ENGLISH_US)); return; } //查询任务的CN int iTdType = 0; szSql.Empty(); szSql.Format(_T("select TDCN, Ttype from td where ID = %d"), dwTdID); pRecTdID->Open(szSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), adOpenStatic, adLockOptimistic, adCmdText); if ((long)VAL_ZERO == pRecTdID->GetRecordCount()) { if (LANG_ZHCN == g_iUILanguage) AfxMessageBox(_T("无法查询td的CN信息")); else MessageBoxEx(NULL, _T("Can not query td's CN information."), STRING_MESSAGEBOXEX_TITLE, MB_OK, MAKELANGID(LANG_ENGLISH, SUBLANG_ENGLISH_US)); pRecTdID->Close(); return; } strTdCN = pRecTdID->GetCollect(_T("TDCN")).vt == VT_NULL ? _T("") : (LPCTSTR)(_bstr_t)pRecTdID->GetCollect(_T("TDCN")); iTdType = pRecTdID->GetCollect(_T("Ttype")).iVal; pRecTdID->Close(); if (strTdCN.IsEmpty()) { if (LANG_ZHCN == g_iUILanguage) AfxMessageBox(_T("任务的CN信息是空")); else MessageBoxEx(NULL, _T("Task's CN information is empty."), STRING_MESSAGEBOXEX_TITLE, MB_OK, MAKELANGID(LANG_ENGLISH, SUBLANG_ENGLISH_US)); return; } //获取REC文件的源地址 szLocFilePath.Empty(); szLocFilePath.GetBufferSetLength(256); ::GetCurrentDirectory(szLocFilePath.GetLength(), szLocFilePath.GetBuffer(szLocFilePath.GetLength())); szLocFilePath.ReleaseBuffer(); szLocFilePath = szLocFilePath + _T("\\CACHE\\projects\\"); szFileName.Empty(); szFileName.Format(_T("%s%s\\%s\\%s.org"), szLocFilePath, strProCN, strTzCN, strTdCN); if (PathFileExistsA(szFileName) == FALSE) { if (LANG_ZHCN == g_iUILanguage) AfxMessageBox(_T("原始org文件不存在！")); else MessageBoxEx(NULL, _T("Original org File not Existed."), STRING_MESSAGEBOXEX_TITLE, MB_OK, MAKELANGID(LANG_ENGLISH, SUBLANG_ENGLISH_US)); return; } } void CDataOperator::ExportTdRecFile(CNavDataView *pNavData) { if (NULL == pNavData) { return; } HTREEITEM hProItem = NULL; HTREEITEM hTdItem = NULL; DWORD dwProHandle = (DWORD)VAL_ZERO; DWORD dwProID = (DWORD)VAL_ZERO; DWORD dwTdHandle = (DWORD)VAL_ZERO; DWORD dwTdID = (DWORD)VAL_ZERO; hTdItem = pNavData->m_dataTree.GetSelectedItem(); hProItem = pNavData->m_dataTree.GetParentItem(hTdItem); if (NULL == hProItem || NULL == hTdItem) { if (LANG_ZHCN == g_iUILanguage) AfxMessageBox(_T("获取树节点失败")); else MessageBoxEx(NULL, _T("Get tree item failed."), STRING_MESSAGEBOXEX_TITLE, MB_OK, MAKELANGID(LANG_ENGLISH, SUBLANG_ENGLISH_US)); return; } CString strTdName = pNavData->m_dataTree.GetItemText(hTdItem); dwProHandle = pNavData->m_dataTree.GetItemData(hProItem); dwProID = m_handleProcessor.GetIDFromHandle(dwProHandle); dwTdHandle = pNavData->m_dataTree.GetItemData(hTdItem); dwTdID = m_handleProcessor.GetIDFromHandle(dwTdHandle); _RecordsetPtr pRecProID = NULL; _RecordsetPtr pRecTdID = NULL; _RecordsetPtr pRecTzID = NULL; CString szSql = _T(""); CString szFileName = _T(""); CString szDstFile = _T(""); CString strProCN = _T(""); CString strTzCN = _T(""); CString strTdCN = _T(""); CString szLocFilePath = _T(""); pRecProID.CreateInstance(_uuidof(Recordset)); pRecTdID.CreateInstance(_uuidof(Recordset)); pRecTzID.CreateInstance(_uuidof(Recordset)); //查询工程的CN szSql.Empty(); szSql.Format(_T("select CN from project where ID = %d"), dwProID); pRecProID->Open(szSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), adOpenStatic, adLockOptimistic, adCmdText); if ((long)VAL_ZERO == pRecProID->GetRecordCount()) { if (LANG_ZHCN == g_iUILanguage) AfxMessageBox(_T("无法查询项目的CN信息")); else MessageBoxEx(NULL, _T("Can not query project's CN information."), STRING_MESSAGEBOXEX_TITLE, MB_OK, MAKELANGID(LANG_ENGLISH, SUBLANG_ENGLISH_US)); pRecProID->Close(); return; } strProCN = pRecProID->GetCollect(_T("CN")).vt == VT_NULL ? _T("") : (LPCTSTR)(_bstr_t)pRecProID->GetCollect(_T("CN")); pRecProID->Close(); if (strProCN.IsEmpty()) { if (LANG_ZHCN == g_iUILanguage) AfxMessageBox(_T("项目的CN信息为空")); else MessageBoxEx(NULL, _T("Project's CN information is empty."), STRING_MESSAGEBOXEX_TITLE, MB_OK, MAKELANGID(LANG_ENGLISH, SUBLANG_ENGLISH_US)); return; } //查询测区的CN szSql.Empty(); szSql.Format(_T("select CN from tz where PRID = %d"), dwProID); pRecTzID->Open(szSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), adOpenStatic, adLockOptimistic, adCmdText); if ((long)VAL_ZERO == pRecTzID->GetRecordCount()) { if (LANG_ZHCN == g_iUILanguage) AfxMessageBox(_T("无法查询测试区域的CN信息")); else MessageBoxEx(NULL, _T("Can not query testzone's CN information."), STRING_MESSAGEBOXEX_TITLE, MB_OK, MAKELANGID(LANG_ENGLISH, SUBLANG_ENGLISH_US)); pRecTzID->Close(); return; } strTzCN = pRecTzID->GetCollect(_T("CN")).vt == VT_NULL ? _T("") : (LPCTSTR)(_bstr_t)pRecTzID->GetCollect(_T("CN")); pRecTzID->Close(); if (strTzCN.IsEmpty()) { if (LANG_ZHCN == g_iUILanguage) AfxMessageBox(_T("测试区域的CN信息是空")); else MessageBoxEx(NULL, _T("Testzone's CN information is empty."), STRING_MESSAGEBOXEX_TITLE, MB_OK, MAKELANGID(LANG_ENGLISH, SUBLANG_ENGLISH_US)); return; } //查询任务的CN int iTdType = 0; szSql.Empty(); szSql.Format(_T("select TDCN, Ttype from td where ID = %d"), dwTdID); pRecTdID->Open(szSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), adOpenStatic, adLockOptimistic, adCmdText); if ((long)VAL_ZERO == pRecTdID->GetRecordCount()) { if (LANG_ZHCN == g_iUILanguage) AfxMessageBox(_T("无法查询td的CN信息")); else MessageBoxEx(NULL, _T("Can not query td's CN information."), STRING_MESSAGEBOXEX_TITLE, MB_OK, MAKELANGID(LANG_ENGLISH, SUBLANG_ENGLISH_US)); pRecTdID->Close(); return; } strTdCN = pRecTdID->GetCollect(_T("TDCN")).vt == VT_NULL ? _T("") : (LPCTSTR)(_bstr_t)pRecTdID->GetCollect(_T("TDCN")); iTdType = pRecTdID->GetCollect(_T("Ttype")).iVal; pRecTdID->Close(); if (strTdCN.IsEmpty()) { if (LANG_ZHCN == g_iUILanguage) AfxMessageBox(_T("任务的CN信息是空")); else MessageBoxEx(NULL, _T("Task's CN information is empty."), STRING_MESSAGEBOXEX_TITLE, MB_OK, MAKELANGID(LANG_ENGLISH, SUBLANG_ENGLISH_US)); return; } //获取REC文件的源地址 szLocFilePath.Empty(); szLocFilePath.GetBufferSetLength(256); ::GetCurrentDirectory(szLocFilePath.GetLength(), szLocFilePath.GetBuffer(szLocFilePath.GetLength())); szLocFilePath.ReleaseBuffer(); szLocFilePath = szLocFilePath + _T("\\CACHE\\projects\\"); szFileName.Empty(); szFileName.Format(_T("%s%s\\%s\\%s.rec"), szLocFilePath, strProCN, strTzCN, strTdCN); if (PathFileExistsA(szFileName) == FALSE) { if (LANG_ZHCN == g_iUILanguage) AfxMessageBox(_T("原始Rec文件不存在！")); else MessageBoxEx(NULL, _T("Original Rec File not Existed."), STRING_MESSAGEBOXEX_TITLE, MB_OK, MAKELANGID(LANG_ENGLISH, SUBLANG_ENGLISH_US)); return; } //szFileName.Format(_T("%s\\SD\\projects\\%s\\%s\\%s.rec"),CDetcGD10Dev::GetInstance()->GetGD10DevAddr(), strProCN, strTzCN, strTdCN); //获取目的地址 //OFN_NOCHANGEDIR:Restores the current directory to its original value if the user changed the directory while searching for files //也就是说如果用FileDialog中间改变了目录的路径之后，调用GetCurrentDirectory函数也能够返回原始目录，原始目录并不改变 //如果没有次熟悉，则原始目录会改变 //由于GetBuffer(MAX_PATH)可能会改变其内容，所以在这里先用备份的来当做文件名的保存 CString strBackTdName = strTdName; CFileDialog *pFileDial = new CFileDialog(FALSE, _T("xml"), _T(""), OFN_OVERWRITEPROMPT|OFN_HIDEREADONLY|OFN_NOCHANGEDIR, _T("xml files(*.xml)|*.xml|All Files (*.*)|*.*||"), NULL); pFileDial->m_ofn.lpstrTitle = _T("Open files"); pFileDial->m_ofn.lpstrFile = strBackTdName.GetBuffer(MAX_PATH); pFileDial->m_ofn.nMaxFile = MAX_PATH; if (IDOK != pFileDial->DoModal()) { strBackTdName.ReleaseBuffer(); return; } szDstFile = pFileDial->GetPathName(); strBackTdName.ReleaseBuffer(); if (SaveRecFileToLocal(szFileName, szDstFile, iTdType)) { if (LANG_ZHCN == g_iUILanguage) AfxMessageBox(_T("导出成功.")); else MessageBoxEx(NULL, _T("Save file success."), STRING_MESSAGEBOXEX_TITLE, MB_OK, MAKELANGID(LANG_ENGLISH, SUBLANG_ENGLISH_US)); } else { if (LANG_ZHCN == g_iUILanguage) AfxMessageBox(_T("导出失败.")); else MessageBoxEx(NULL, _T("Save file failed."), STRING_MESSAGEBOXEX_TITLE, MB_OK, MAKELANGID(LANG_ENGLISH, SUBLANG_ENGLISH_US)); } } bool CDataOperator::SaveRecFileToLocal(CString strRecFile, CString strDstFile, int iTaskType) { CString strLog = _T(""); CString strTdType = _T(""); if (!CFileOperTools::GetInstance()->IsFileExist(strRecFile)) { if (LANG_ZHCN == g_iUILanguage) AfxMessageBox(_T("原始文件不存在.")); else MessageBoxEx(NULL, _T("Orginial file is not exist."), STRING_MESSAGEBOXEX_TITLE, MB_OK, MAKELANGID(LANG_ENGLISH, SUBLANG_ENGLISH_US)); strLog.Empty(); strLog.Format(_T("[DataOperator][%d]Orginial file is not exist, file_path = %s"), __LINE__, strRecFile); CFileOperTools::GetInstance()->WriteComLog(strLog); return false; } switch (iTaskType) { case 0: strTdType = _T("RES"); break; case 1: strTdType = _T("IP"); break; case 2: strTdType = _T("SP"); break; default: if (LANG_ZHCN == g_iUILanguage) { strLog.Format(_T("解析任务类型错误 %d"), iTaskType); AfxMessageBox(strLog); } else { strLog.Format(_T("Parser task type error.type = %d"), iTaskType); MessageBoxEx(NULL, strLog, STRING_MESSAGEBOXEX_TITLE, MB_OK, MAKELANGID(LANG_ENGLISH, SUBLANG_ENGLISH_US)); } return false; } CMarkup markup; CMarkup markupLocal; if (!markup.Load(strRecFile)) { if (LANG_ZHCN == g_iUILanguage) AfxMessageBox(_T("打开原始文件失败.")); else MessageBoxEx(NULL, _T("Open orginial file failed."), STRING_MESSAGEBOXEX_TITLE, MB_OK, MAKELANGID(LANG_ENGLISH, SUBLANG_ENGLISH_US)); strLog.Empty(); strLog.Format(_T("[DataOperator][%d]Orginial file is not exist, file_path = %s,error_code = %d"), __LINE__, strRecFile, GetLastError()); CFileOperTools::GetInstance()->WriteComLog(strLog); return false; } if (!markup.FindElem(_T("Points"))) { if (LANG_ZHCN == g_iUILanguage) AfxMessageBox(_T("查找根节点失败")); else MessageBoxEx(NULL, _T("Find root element(Points)f fialed."), STRING_MESSAGEBOXEX_TITLE, MB_OK, MAKELANGID(LANG_ENGLISH, SUBLANG_ENGLISH_US)); return false; } markup.IntoElem(); bool bIsHaveData = false; markupLocal.SetDoc(_T("\r\n")); if (!markupLocal.AddElem(_T("Points"))) { if (LANG_ZHCN == g_iUILanguage) AfxMessageBox(_T("根节点写入文件失败")); else MessageBoxEx(NULL, _T("Write root element(Points) to file failed."), STRING_MESSAGEBOXEX_TITLE, MB_OK, MAKELANGID(LANG_ENGLISH, SUBLANG_ENGLISH_US)); return false; } markupLocal.IntoElem(); CString strID = _T(""); CString strWidth = _T(""); while(markup.FindElem(_T("Point"))) { bIsHaveData = true; strID = markup.GetAttrib(_T("ID")); //写入元素Point markupLocal.AddElem(_T("Point")); markupLocal.AddAttrib(_T("ID"), strID); markup.IntoElem(); int iStackTsn = 0; CString strStackTsn = _T(""); while(markup.FindElem(strTdType)) { strStackTsn.Empty(); strStackTsn.Format(_T("%d"),++iStackTsn); //写入元素V if (!markup.FindChildElem(_T("V"))) { if (LANG_ZHCN == g_iUILanguage) AfxMessageBox(_T("解析元素V错误")); else MessageBoxEx(NULL, _T("Parser element V error."), STRING_MESSAGEBOXEX_TITLE, MB_OK, MAKELANGID(LANG_ENGLISH, SUBLANG_ENGLISH_US)); strLog.Empty(); strLog.Format(_T("[DataOperator][%d]Can not found element v in ID = %s"), __LINE__, strID); CFileOperTools::GetInstance()->WriteComLog(strLog); return false; } strWidth = markup.GetChildAttrib(_T("width")); //将元素V的值写入到新文件当中 bool bIsAddSucc = false; if (markupLocal.AddChildElem(_T("V"))) { if (markupLocal.AddChildAttrib(_T("width"), strWidth)) { markupLocal.AddChildAttrib(_T("stack"), strStackTsn); if (markupLocal.SetChildData(markup.GetChildData())) bIsAddSucc = true; else { strLog.Empty(); strLog.Format(_T("[DataOperator][%d]set element V data failed in ID = %s, error_code = %d"), __LINE__, strID, GetLastError()); } } else { strLog.Empty(); strLog.Format(_T("[DataOperator][%d]Add Attribute width(V) failed in ID = %s, error_code = %d"), __LINE__, strID, GetLastError()); } } else { strLog.Empty(); strLog.Format(_T("[DataOperator][%d]Add Element v failed in ID = %s, error_code = %d"), __LINE__, strID, GetLastError()); } if (!bIsAddSucc) { CFileOperTools::GetInstance()->WriteComLog(strLog); if (LANG_ZHCN == g_iUILanguage) AfxMessageBox(_T("写入元素V错误")); else MessageBoxEx(NULL, _T("Write element v error."), STRING_MESSAGEBOXEX_TITLE, MB_OK, MAKELANGID(LANG_ENGLISH, SUBLANG_ENGLISH_US)); return false; } if (!markup.FindChildElem(_T("I"))) { if (LANG_ZHCN == g_iUILanguage) AfxMessageBox(_T("解析元素I错误")); else MessageBoxEx(NULL, _T("Parser element I error."), STRING_MESSAGEBOXEX_TITLE, MB_OK, MAKELANGID(LANG_ENGLISH, SUBLANG_ENGLISH_US)); strLog.Empty(); strLog.Format(_T("[DataOperator][%d]Can not found element I in ID = %s"), __LINE__, strID); CFileOperTools::GetInstance()->WriteComLog(strLog); return false; } //将元素I的值写入到新文件当中 bIsAddSucc = false; strWidth = markup.GetChildAttrib(_T("width")); if (markupLocal.AddChildElem(_T("I"))) { if (markupLocal.AddChildAttrib(_T("width"), strWidth)) { markupLocal.AddChildAttrib(_T("stack"), strStackTsn); if (markupLocal.SetChildData(markup.GetChildData())) bIsAddSucc = true; else { strLog.Empty(); strLog.Format(_T("[DataOperator][%d]set element I data failed in ID = %s, error_code = %d"), __LINE__, strID, GetLastError()); } } else { strLog.Empty(); strLog.Format(_T("[DataOperator][%d]Add Attribute width(I) failed in ID = %s, error_code = %d"), __LINE__, strID, GetLastError()); } } else { strLog.Empty(); strLog.Format(_T("[DataOperator][%d]Add Element I failed in ID = %s, error_code = %d"), __LINE__, strID, GetLastError()); } if (!bIsAddSucc) { CFileOperTools::GetInstance()->WriteComLog(strLog); if (LANG_ZHCN == g_iUILanguage) AfxMessageBox(_T("写入元素I错误.")); else MessageBoxEx(NULL, _T("Write element I error."), STRING_MESSAGEBOXEX_TITLE, MB_OK, MAKELANGID(LANG_ENGLISH, SUBLANG_ENGLISH_US)); return false; } } markup.OutOfElem(); } if (bIsHaveData) { if (markupLocal.Save(strDstFile)) { return true; } else { strLog.Empty(); strLog.Format(_T("[DataOperator][%d]Save file failed. dst_file_path = %s, error_code = %d"), __LINE__, strDstFile, GetLastError()); CFileOperTools::GetInstance()->WriteComLog(strLog); return false; } } else { if (LANG_ZHCN == g_iUILanguage) AfxMessageBox(_T("原始文件中缺乏有效数据.")); else MessageBoxEx(NULL, _T("Can not found valid data in rec file."), STRING_MESSAGEBOXEX_TITLE, MB_OK, MAKELANGID(LANG_ENGLISH, SUBLANG_ENGLISH_US)); strLog.Empty(); strLog.Format(_T("Can not found valid data in rec file. file_path = %s"), strRecFile); CFileOperTools::GetInstance()->WriteComLog(strLog); return false; } } int CDataOperator::GetTestType(int ScriptType, int TestType) { switch (TestType) { case 0: switch (ScriptType) { case 0: return PZ_STYLE_TD_CERSP; case 1: return PZ_STYLE_TD_2DRSP; case 2: return PZ_STYLE_TD_3DRSP; default: break; } break; case 1: switch (ScriptType) { case 0: return PZ_STYLE_TD_CEIPSP; case 1: return PZ_STYLE_TD_2DIPSP; case 2: return PZ_STYLE_TD_3DIPSP; default: break; } break; case 2://自电 switch (ScriptType) { case 0: return PZ_STYLE_TD_CESP; case 1: return PZ_STYLE_TD_2DSP; case 2: return PZ_STYLE_TD_3DSP; default: break; } break; default: break; } } UINT CDataOperator::Delete1DElectrodeRecord(CNavDataView *pNavDataView, const std::vector* pvtDelElecID) { UINT uExecCode = (UINT)APP_SUCCESS; HTREEITEM hTdItem = NULL; HTREEITEM hTzItem = NULL; _RecordsetPtr pRecPro = NULL; DWORD dwTdHandle = (DWORD)VAL_ZERO; DWORD dwTdID = (DWORD)VAL_ZERO; hTdItem = pNavDataView->m_dataTree.GetSelectedItem(); hTzItem = pNavDataView->m_dataTree.GetParentItem(hTdItem); dwTdHandle = pNavDataView->m_dataTree.GetItemData(hTdItem); dwTdID = m_handleProcessor.GetIDFromHandle(dwTdHandle); CString szSql = _T(""); CString strElecInfo = _T(""); CString strTmp = _T(""); for (int i = 0; i < pvtDelElecID->size(); i++) { if (0 == i) { strElecInfo.Format(_T("%.1f"),(*pvtDelElecID)[i]); } else { strTmp.Empty(); strTmp.Format(_T(",%.1f"),(*pvtDelElecID)[i]); strElecInfo += strTmp; } } try { _CommandPtr pCmdDelRspTd = NULL; pCmdDelRspTd.CreateInstance(_uuidof(Command)); pRecPro.CreateInstance(_uuidof(Recordset)); pCmdDelRspTd->ActiveConnection = m_pConnection; m_pConnection->BeginTrans(); szSql.Empty(); szSql.Format(_T("update td1dcon set bUse = false where TCHID in (select ID from tdchannel where TDID = %u) and (a in (%s) or b in (%s) or x in (%s) or y in (%s))"), dwTdID,strElecInfo,strElecInfo,strElecInfo,strElecInfo); pCmdDelRspTd->CommandText = szSql.AllocSysString(); pCmdDelRspTd->Execute(NULL, NULL, adCmdText); szSql.Empty(); szSql.Format(_T("select count(*) as cnt from td1dcon where TCHID in (select ID from tdchannel where TDID = %u) and bUse = true"), dwTdID); pRecPro->Open(szSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), adOpenStatic, adLockOptimistic, adCmdText); int nCnt = 0; if ((long)VAL_ZERO != pRecPro->GetRecordCount()) nCnt = pRecPro->GetCollect(_T("cnt")).lVal; else { if (LANG_ZHCN == g_iUILanguage) AfxMessageBox(_T("获取任务失败的统计信息")); else MessageBoxEx(NULL, _T("Get statistical information of task failed!"), STRING_MESSAGEBOXEX_TITLE, MB_OK, MAKELANGID(LANG_ENGLISH, SUBLANG_ENGLISH_US)); pRecPro->Close(); m_pConnection->RollbackTrans(); return APP_ERR_DB; } pRecPro->Close(); szSql.Empty(); szSql.Format(_T("update td set TPamount = %d where ID = %d "), nCnt, dwTdID); pCmdDelRspTd->CommandText = szSql.AllocSysString(); pCmdDelRspTd->Execute(NULL, NULL, adCmdText); } catch (_com_error e) { AfxMessageBox(e.Description()); m_pConnection->RollbackTrans(); return APP_ERR_DB; } m_pConnection->CommitTrans(); return uExecCode; } UINT CDataOperator::Delete2DElectrodeRecord(CNavDataView *pNavDataView, const std::vector* pvtDelElecID) { UINT uExecCode = (UINT)APP_SUCCESS; HTREEITEM hTdItem = NULL; HTREEITEM hTzItem = NULL; _RecordsetPtr pRecPro = NULL; DWORD dwTdHandle = (DWORD)VAL_ZERO; DWORD dwTdID = (DWORD)VAL_ZERO; hTdItem = pNavDataView->m_dataTree.GetSelectedItem(); hTzItem = pNavDataView->m_dataTree.GetParentItem(hTdItem); dwTdHandle = pNavDataView->m_dataTree.GetItemData(hTdItem); dwTdID = m_handleProcessor.GetIDFromHandle(dwTdHandle); CString szSql = _T(""); CString strElecInfo = _T(""); CString strTmp = _T(""); for (int i = 0; i < pvtDelElecID->size(); i++) { if (0 == i) { strElecInfo.Format(_T("%d"),(int)((*pvtDelElecID)[i])); } else { strTmp.Empty(); strTmp.Format(_T(",%d"),(int)((*pvtDelElecID)[i])); strElecInfo += strTmp; } } try { _CommandPtr pCmdDelRspTd = NULL; pCmdDelRspTd.CreateInstance(_uuidof(Command)); pRecPro.CreateInstance(_uuidof(Recordset)); pCmdDelRspTd->ActiveConnection = m_pConnection; m_pConnection->BeginTrans(); szSql.Empty(); szSql.Format(_T("update td2dcon set bUse = false where TCHID in (select ID from tdchannel where TDID = %u) and (C1 in (%s) or C2 in (%s) or P1 in (%s) or P2 in (%s))"), dwTdID,strElecInfo,strElecInfo,strElecInfo,strElecInfo); pCmdDelRspTd->CommandText = szSql.AllocSysString(); pCmdDelRspTd->Execute(NULL, NULL, adCmdText); //更新测点数量,由于在acess中不支持这样的嵌套语句(但是在sql的其它数据库中支持)，所以此时需要分开写 //update td set TPamount = (select count(*) from td2dcon //where TCHID in (select ID from tdchannel where TDID = %u) and bUse = true) where ID = %d szSql.Empty(); szSql.Format(_T("select count(*) as cnt from td2dcon where TCHID in (select ID from tdchannel where TDID = %u) and bUse = true"), dwTdID); pRecPro->Open(szSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), adOpenStatic, adLockOptimistic, adCmdText); int nCnt = 0; if ((long)VAL_ZERO != pRecPro->GetRecordCount()) nCnt = pRecPro->GetCollect(_T("cnt")).lVal; else { if (LANG_ZHCN == g_iUILanguage) AfxMessageBox(_T("获取任务的统计信息失败!")); else MessageBoxEx(NULL, _T("Get statistical information of task failed!"), STRING_MESSAGEBOXEX_TITLE, MB_OK, MAKELANGID(LANG_ENGLISH, SUBLANG_ENGLISH_US)); pRecPro->Close(); m_pConnection->RollbackTrans(); return APP_ERR_DB; } pRecPro->Close(); szSql.Empty(); szSql.Format(_T("update td set TPamount = %d where ID = %d "), nCnt, dwTdID); pCmdDelRspTd->CommandText = szSql.AllocSysString(); pCmdDelRspTd->Execute(NULL, NULL, adCmdText); } catch (_com_error e) { AfxMessageBox(e.Description()); m_pConnection->RollbackTrans(); pRecPro->Close(); return APP_ERR_DB; } m_pConnection->CommitTrans(); return uExecCode; } UINT CDataOperator::Delete3DElectrodeRecord(CNavDataView *pNavDataView, const std::vector* pvtDelElecID) { UINT uExecCode = (UINT)APP_SUCCESS; HTREEITEM hTdItem = NULL; HTREEITEM hTzItem = NULL; DWORD dwTdHandle = (DWORD)VAL_ZERO; DWORD dwTdID = (DWORD)VAL_ZERO; _RecordsetPtr pRecPro = NULL; hTdItem = pNavDataView->m_dataTree.GetSelectedItem(); hTzItem = pNavDataView->m_dataTree.GetParentItem(hTdItem); dwTdHandle = pNavDataView->m_dataTree.GetItemData(hTdItem); dwTdID = m_handleProcessor.GetIDFromHandle(dwTdHandle); CString szSql = _T(""); CString strElecInfo = _T(""); CString strTmp = _T(""); for (int i = 0; i < pvtDelElecID->size(); i++) { if (0 == i) { strElecInfo.Format(_T("%d"),(int)((*pvtDelElecID)[i])); } else { strTmp.Empty(); strTmp.Format(_T(",%d"),(int)((*pvtDelElecID)[i])); strElecInfo += strTmp; } } try { _CommandPtr pCmdDelRspTd = NULL; pCmdDelRspTd.CreateInstance(_uuidof(Command)); pRecPro.CreateInstance(_uuidof(Recordset)); pCmdDelRspTd->ActiveConnection = m_pConnection; m_pConnection->BeginTrans(); szSql.Empty(); szSql.Format(_T("update td3dcon set bUse = false where TCHID in (select ID from tdchannel where TDID = %u) and (C1 in (%s) or C2 in (%s) or P1 in (%s) or P2 in (%s))"), dwTdID,strElecInfo,strElecInfo,strElecInfo,strElecInfo); pCmdDelRspTd->CommandText = szSql.AllocSysString(); pCmdDelRspTd->Execute(NULL, NULL, adCmdText); szSql.Empty(); szSql.Format(_T("select count(*) as cnt from td3dcon where TCHID in (select ID from tdchannel where TDID = %u) and bUse = true"), dwTdID); pRecPro->Open(szSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), adOpenStatic, adLockOptimistic, adCmdText); int nCnt = 0; if ((long)VAL_ZERO != pRecPro->GetRecordCount()) nCnt = pRecPro->GetCollect(_T("cnt")).lVal; else { if (LANG_ZHCN == g_iUILanguage) AfxMessageBox(_T("获取任务的统计信息失败!")); else MessageBoxEx(NULL, _T("Get statistical information of task failed!"), STRING_MESSAGEBOXEX_TITLE, MB_OK, MAKELANGID(LANG_ENGLISH, SUBLANG_ENGLISH_US)); pRecPro->Close(); m_pConnection->RollbackTrans(); return APP_ERR_DB; } pRecPro->Close(); szSql.Empty(); szSql.Format(_T("update td set TPamount = %d where ID = %d "), nCnt, dwTdID); pCmdDelRspTd->CommandText = szSql.AllocSysString(); pCmdDelRspTd->Execute(NULL, NULL, adCmdText); } catch (_com_error e) { AfxMessageBox(e.Description()); m_pConnection->RollbackTrans(); return APP_ERR_DB; } m_pConnection->CommitTrans(); return uExecCode; }