/
Building.cpp
116 lines (94 loc) · 2.73 KB
/
Building.cpp
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
#include "Building.h"
Building Building::getObject(vector<string> param,string sepOut,string sepIn) {
Building building = Building(param,sepOut,sepIn);
return building;
}
vector<Building> Building::getObjectSet(vector<vector<string>> param,string sepOut,string sepIn) {
vector<Building> buildingSet;
vector<vector<string>>::iterator iter = param.begin();
while(iter!=param.end()) {
Building building = Building::getObject(*iter++,sepOut,sepIn);
buildingSet.push_back(building);
}
return buildingSet;
}
void Building::GetThisBuildingRecord(int BId)
{
id=BId;
//_ConnectionPtr sqlSp;
//DBConnect* dbconnection;
//_RecordsetPtr m_pRecordset;
//dbconnection = DBConnGuard::GetAConnect();
//sqlSp = dbconnection->_connection_ptr;
////dbCon.getMyConnection(connection);
//m_pRecordset.CreateInstance(__uuidof(Recordset));
//////////////////////////////////////////////////////////////////
CoInitialize(NULL);
_ConnectionPtr sqlSp;
HRESULT hr=sqlSp.CreateInstance(_uuidof(Connection));
if(FAILED(hr))
{
cout<<"cuole"<<endl;
}
try {
_bstr_t strConnect="Driver={sql server};server=ZHANGZHE-PC;uid=sa;pwd=123456;database=test30;";
sqlSp->Open(strConnect,"","",adModeUnknown);
}
catch(_com_error &e) {
cout<<"cuole"<<endl;
}
_RecordsetPtr m_pRecordset;; //记录集对象指针,用来执行SQL语句并记录查询结果
if(FAILED(m_pRecordset.CreateInstance( _uuidof( Recordset ))))
{
cout<<"cuole"<<endl;
}
///////////////////////////////////////////////////////////////////////
string Ext;
BuildingPoint BP;
stringstream ss;
Ext.append("SELECT * FROM BuildingPoint WHERE PBuildingId=");
ss<<BId;
Ext.append(ss.str());
ss.str("");
ss.clear();
try
{
m_pRecordset->Open(Ext.c_str(),(IDispatch*)sqlSp,adOpenDynamic,adLockOptimistic, adCmdText);
m_pRecordset->MoveFirst();
while(!m_pRecordset->adoEOF)
{
BP.longitude=double(m_pRecordset->GetCollect("PLongitude"));
BP.latitude=double(m_pRecordset->GetCollect("PLatitude"));
BP.id=int(m_pRecordset->GetCollect("PId"));
BP.px=double(m_pRecordset->GetCollect("PX"));
BP.py=double(m_pRecordset->GetCollect("PY"));
BP.buildingId=int(m_pRecordset->GetCollect("PBuildingId"));
BPoint.push_back(BP);
m_pRecordset->MoveNext();
}
Ext.clear();
}
catch (_com_error &e)
{
cout << e.Description()<<endl;
}
m_pRecordset->Close();
//查找建筑物的高度
Ext.append("SELECT * FROM Building WHERE BId=");
ss<<BId;
Ext.append(ss.str());
ss.str("");
ss.clear();
try
{
m_pRecordset->Open(Ext.c_str(),(IDispatch*)sqlSp,adOpenDynamic,adLockOptimistic, adCmdText);
buildingHeight=float(m_pRecordset->GetCollect("BHeight"));
Ext.clear();
}
catch (_com_error &e)
{
cout << e.Description()<<endl;
}
/*sqlSp->Close();
m_pRecordset->Close();*/
}