trunk/FlisServer/FlisServerDlg.cpp

// FlisServerDlg.cpp : implementation file
//

#include "stdafx.h"
#include "FlisServer.h"
#include "FlisServerDlg.h"
#include ".\flisserverdlg.h"
#include <vector>

#ifdef _DEBUG
#define new DEBUG_NEW
#endif


// CAboutDlg dialog used for App About

class CAboutDlg : public CDialog
{
public:
        CAboutDlg();

// Dialog Data
        enum { IDD = IDD_ABOUTBOX };

        protected:
        virtual void DoDataExchange(CDataExchange* pDX);    // DDX/DDV support

// Implementation
protected:
        DECLARE_MESSAGE_MAP()
};

CAboutDlg::CAboutDlg() : CDialog(CAboutDlg::IDD)
{
}

void CAboutDlg::DoDataExchange(CDataExchange* pDX)
{
        CDialog::DoDataExchange(pDX);
}

BEGIN_MESSAGE_MAP(CAboutDlg, CDialog)
END_MESSAGE_MAP()


// CFlisServerDlg dialog


CFlisServerDlg::CFlisServerDlg(CWnd* pParent /*=NULL*/)
        : CDialog(CFlisServerDlg::IDD, pParent)
{
        m_hIcon = AfxGetApp()->LoadIcon(IDR_MAINFRAME);
}

void CFlisServerDlg::DoDataExchange(CDataExchange* pDX)
{
        CDialog::DoDataExchange(pDX);
        DDX_Control(pDX, IDC_Textwindow, m_Textwindow);
}

BEGIN_MESSAGE_MAP(CFlisServerDlg, CDialog)
        ON_WM_SYSCOMMAND()
        ON_WM_PAINT()
        ON_WM_QUERYDRAGICON()
        //}}AFX_MSG_MAP
        ON_BN_CLICKED(IDC_test, OnBnClickedtest)
        ON_BN_CLICKED(IDCLOSE, OnBnClickedClose)
END_MESSAGE_MAP()


// CFlisServerDlg message handlers

BOOL CFlisServerDlg::OnInitDialog()
{
        CDialog::OnInitDialog();

        // Add "About..." menu item to system menu.

        // IDM_ABOUTBOX must be in the system command range.
        ASSERT((IDM_ABOUTBOX & 0xFFF0) == IDM_ABOUTBOX);
        ASSERT(IDM_ABOUTBOX < 0xF000);

        CMenu* pSysMenu = GetSystemMenu(FALSE);
        if (pSysMenu != NULL)
        {
                CString strAboutMenu;
                strAboutMenu.LoadString(IDS_ABOUTBOX);
                if (!strAboutMenu.IsEmpty())
                {
                        pSysMenu->AppendMenu(MF_SEPARATOR);
                        pSysMenu->AppendMenu(MF_STRING, IDM_ABOUTBOX, strAboutMenu);
                }
        }

        // Set the icon for this dialog.  The framework does this automatically
        //  when the application's main window is not a dialog
        SetIcon(m_hIcon, TRUE);                 // Set big icon
        SetIcon(m_hIcon, FALSE);                // Set small icon

        // TODO: Add extra initialization here
        StartSerial();
        //SetPin();
        DBConnect();
        
        return TRUE;  // return TRUE  unless you set the focus to a control
}

void CFlisServerDlg::OnSysCommand(UINT nID, LPARAM lParam)
{
        if ((nID & 0xFFF0) == IDM_ABOUTBOX)
        {
                CAboutDlg dlgAbout;
                dlgAbout.DoModal();
        }
        else
        {
                CDialog::OnSysCommand(nID, lParam);
        }
}

// If you add a minimize button to your dialog, you will need the code below
//  to draw the icon.  For MFC applications using the document/view model,
//  this is automatically done for you by the framework.

void CFlisServerDlg::OnPaint() 
{
        if (IsIconic())
        {
                CPaintDC dc(this); // device context for painting

                SendMessage(WM_ICONERASEBKGND, reinterpret_cast<WPARAM>(dc.GetSafeHdc()), 0);

                // Center icon in client rectangle
                int cxIcon = GetSystemMetrics(SM_CXICON);
                int cyIcon = GetSystemMetrics(SM_CYICON);
                CRect rect;
                GetClientRect(&rect);
                int x = (rect.Width() - cxIcon + 1) / 2;
                int y = (rect.Height() - cyIcon + 1) / 2;

                // Draw the icon
                dc.DrawIcon(x, y, m_hIcon);
        }
        else
        {
                CDialog::OnPaint();
        }
}

// The system calls this function to obtain the cursor to display while the user drags
//  the minimized window.
HCURSOR CFlisServerDlg::OnQueryDragIcon()
{
        return static_cast<HCURSOR>(m_hIcon);
}
int CFlisServerDlg::StartSerial(void)
{
        int Baud;
        CString SerialPort = "COM3";

        Baud = 1200;
        if( Serial.isOpen() ){
                Serial.close();
                Serial.open( SerialPort, Baud );
        }
        else {
                Serial.open( SerialPort, Baud );
        }

                
return 0;
}
std::vector<unsigned char> CFlisServerDlg::readFrame()
{
        std::vector<unsigned char> buf;
        while(Serial.getComstat().cbInQue > 0)
        {
        unsigned char data = Serial.readByte();

        buf.push_back(data);
        }
        return buf;
}
void CFlisServerDlg::OnBnClickedtest()
{
        // TODO: Add your control notification handler code here
/*      
////////////////Read sms ting//////////////////
        CString tekst;
        std::vector<unsigned char> data;
        data.push_back('a');
        data.push_back('t');
        data.push_back('+');
        data.push_back('c');
        data.push_back('m');
        data.push_back('g');
        data.push_back('r');
        data.push_back('=');
        data.push_back('1');

        writeFrame(data);
        ReadSms();
////////////////Read sms ting//////////////////
*/
/*
////////////////DBRead stuff//////////////////
        CString testdata;
        std::vector<Commands> data;
        data = DBRead();
        for (int i=0; i<data.size(); i++)
        {
                testdata.Append(data[i].IDnr);
                testdata.Append(data[i].CommandID);
                testdata.Append(data[i].InstallationsID);
        }
        m_Textwindow.SetWindowText(testdata);
////////////////DBRead stuff//////////////////  
*/
/*      
///////////////Send sms stuff/////////////////
        vector<unsigned char> tlfnr;
        vector<unsigned char> smsdata;
        tlfnr.push_back('2');
        tlfnr.push_back('9');
        tlfnr.push_back('7');
        tlfnr.push_back('2');
        tlfnr.push_back('2');
        tlfnr.push_back('6');
        tlfnr.push_back('0');
        tlfnr.push_back('3');

        SendSmsHead(tlfnr);

         //35:29860132:75 <--- demo pakke;
        smsdata.push_back('3');
        smsdata.push_back('5');
        smsdata.push_back(':');
        smsdata.push_back('2');
        smsdata.push_back('9');
        smsdata.push_back('8');
        smsdata.push_back('6');
        smsdata.push_back('0');
        smsdata.push_back('1');
        smsdata.push_back('3');
        smsdata.push_back('2');
        smsdata.push_back(':');
        smsdata.push_back('7');
        smsdata.push_back('5');

        SendSmsData(smsdata);
        Sleep(2000);
        if(Serial.getComstat().cbInQue > 0)
        {
                CString tekst;
                std::vector<unsigned char> answer = readFrame();
                Sleep(50);
                        char array1[25];
                        int i;
                        for (int i=0; i<answer.size(); i++)
                        {
                                array1[i] = answer[i];
                        }
                
                        for (int i=0; i<answer.size(); i++)
                        {
                                if ((array1[i] != 0x0A) && (array1[i] != 0x0D))
                                {
                                        tekst.AppendChar(array1[i]);
                                }
                        }
                        m_Textwindow.SetWindowText(tekst);
        }
///////////////Send sms stuff/////////////////
*/
}
void CFlisServerDlg::writeFrame(std::vector<unsigned char> data)
{
        for (int i=0; i<data.size(); i++)
        {
                Serial.writeByte( data[i] );
                Sleep(5);
        }
        Serial.writeByte(0x0D);
        Sleep(100);

}
int CFlisServerDlg::SetPin(void)
{
        CString tekst;
        std::vector<unsigned char> data;
        data.push_back('a');
        data.push_back('t');
        data.push_back('+');
        data.push_back('c');
        data.push_back('p');
        data.push_back('i');
        data.push_back('n');
        data.push_back('=');
        data.push_back('2');
        data.push_back('5');
        data.push_back('9');
        data.push_back('5');

        writeFrame(data);
        Sleep(750);
        if(Serial.getComstat().cbInQue > 0)
        {
                std::vector<unsigned char> answer = readFrame();
                Sleep(50);
                        char array1[25];
                        int i;
                        for (int i=0; i<answer.size(); i++)
                        {
                                array1[i] = answer[i];
                        }
                
                        for (int i=0; i<answer.size(); i++)
                        {
                                if ((array1[i] != 0x0A) && (array1[i] != 0x0D))
                                {
                                        tekst.AppendChar(array1[i]);
                                }
                        }
                        m_Textwindow.SetWindowText(tekst);
        }
return 0;
}
void CFlisServerDlg::SendSmsData(std::vector<unsigned char> data)
{       
        
        for (int i=0; i<data.size(); i++)
        {
                Serial.writeByte( data[i] );
                Sleep(5);
        }
        Serial.writeByte(0x1A);
        Sleep(500);

}
void CFlisServerDlg::SendSmsHead(std::vector<unsigned char> data)
{
        vector<unsigned char> atcommand;
        atcommand.push_back('a');
        atcommand.push_back('t');
        atcommand.push_back('+');
        atcommand.push_back('c');
        atcommand.push_back('m');
        atcommand.push_back('g');
        atcommand.push_back('s');
        atcommand.push_back('=');
        atcommand.push_back('"');
        int s = (atcommand.size() -1 );
        
        for (int i=0; i<(atcommand.size()); i++)
        {
                Serial.writeByte( atcommand[i] );
                Sleep(5);
        }
        
        for (int i=0; i<data.size(); i++)
        {
                Serial.writeByte( data[i] );
                Sleep(5);
        }
        Serial.writeByte(atcommand[s]);
        Serial.writeByte(0x0D);
        Sleep(250);
}
void CFlisServerDlg::DBConnect()
{
        CString dsn;
        dsn.Format("ODBC;Description=asd;DRIVER=PostgreSQL ANSI;SERVER=192.168.134.132; uid=serrenab;password=furnacemonitor;database=flisfyr;sslmode=prefer");
        db.OpenEx(dsn, CDatabase::noOdbcDialog);
}
vector<Commands> CFlisServerDlg::DBRead(void)
{
        vector<Commands> buffer;

        CString SQL, IDnr, CommandID, InstallationsID;
        SQL = "select id,date_trunc('second', created) as created,executed,commandid,installationid from command WHERE executed IS NULL;";
        CRecordset rs(&db);
        rs.Open(AFX_DB_USE_DEFAULT_TYPE, SQL);
        if (rs.GetRecordCount()>0) 
        {
                rs.MoveFirst();
                while(!rs.IsEOF())
                {
                Commands Mycom;
                rs.GetFieldValue((short)0, IDnr);
                rs.GetFieldValue(3, CommandID);
                rs.GetFieldValue(4, InstallationsID);
                
                Mycom.IDnr = IDnr;
                Mycom.CommandID = CommandID;
                Mycom.InstallationsID = InstallationsID;

                buffer.push_back(Mycom);
                rs.MoveNext();
                }
        }
        rs.Close();
        return buffer;
}
void CFlisServerDlg::ReadSms()
{
        CString tekst, oldtekst;
        Sleep(950);
        if(Serial.getComstat().cbInQue > 0)
        {
                std::vector<unsigned char> answer = readFrame();
                Sleep(50);
                        char array1[250];
                        int i;
                        for (int i=0; i<answer.size(); i++)
                        {
                                array1[i] = answer[i];
                        }
                
                        for (int i=0; i<answer.size(); i++)
                        {
                                if ((array1[i] != 0x0A) && (array1[i] != 0x0D))
                                {
                                        tekst.AppendChar(array1[i]);
                                }
                        }

                        m_Textwindow.GetWindowText(oldtekst);
                        oldtekst.Append("\r\n");
                        oldtekst.Append(tekst);
                        m_Textwindow.SetWindowText(oldtekst);
                        SmsSplit(tekst);
        }
}
void CFlisServerDlg::SmsSplit(CString data)
{
        CString FyrData, TlfNr, SmsCount, Temper, Flamme, Flis, FremFejl, PowerFail, oldtekst;
        char CharData[150];
        strcpy(CharData,data);

        int s=22;
        for (int i=0; i<=7; i++)
        {
                TlfNr.AppendChar(CharData[s]);
                s++;
        }

        for (int s=55; s<=(data.GetLength()-3); s++)
        {
                FyrData.AppendChar(CharData[s]);
        }
        FyrData.Append(":");
        
        SmsCount = Splitter(FyrData);
        Temper = Splitter(FyrData);
        Flamme = Splitter(FyrData);
        Flis = Splitter(FyrData);
        FremFejl = Splitter(FyrData);
        PowerFail = Splitter(FyrData);
///////////////////////////////////////////////////////////////////////////////////////////////////////
///////////////////// Her skal sendes data til databasen //////////////////////////////////////////////
                m_Textwindow.GetWindowText(oldtekst);
                oldtekst.Append("\r\n");
                oldtekst.Append("P� n�ste linie kommer SmsCount. \r\n");
                oldtekst.Append(SmsCount);
                oldtekst.Append("\r\n");
                oldtekst.Append("P� n�ste linie kommer Temper. \r\n");
                oldtekst.Append(Temper);
                oldtekst.Append("\r\n");
                oldtekst.Append("P� n�ste linie kommer Flamme. \r\n");
                oldtekst.Append(Flamme);
                oldtekst.Append("\r\n");
                oldtekst.Append("P� n�ste linie kommer Flis. \r\n");
                oldtekst.Append(Flis);
                oldtekst.Append("\r\n");
                oldtekst.Append("P� n�ste linie kommer FremFejl. \r\n");
                oldtekst.Append(FremFejl);
                oldtekst.Append("\r\n");
                oldtekst.Append("P� n�ste linie kommer PowerFail. \r\n");
                oldtekst.Append(PowerFail);
                m_Textwindow.SetWindowText(oldtekst);
///////////////////////////////////////////////////////////////////////////////////////////////////////
///////////////////// Her skal sendes data til databasen //////////////////////////////////////////////
}
CString CFlisServerDlg::Splitter(CString& fyrdata)
{
        CString Output;

        int pos = fyrdata.Find(':',0);
        if (pos != -1)
                {
                        Output = fyrdata.Left(pos);
                        fyrdata = fyrdata.Right( fyrdata.GetLength() - pos -1);
                }
        return Output;
}
void CFlisServerDlg::OnBnClickedClose()
{
        // TODO: Add your control notification handler code here
        
        if( Serial.isOpen() )
        {
                Serial.close();
        }
        
        if(db.IsOpen())
        {
        db.Close();
        }
        OnOK();
}
1	// FlisServerDlg.cpp : implementation file
2	//
3
4	#include "stdafx.h"
5	#include "FlisServer.h"
6	#include "FlisServerDlg.h"
7	#include ".\flisserverdlg.h"
8	#include <vector>
9
10	#ifdef _DEBUG
11	#define new DEBUG_NEW
12	#endif
13
14
15	// CAboutDlg dialog used for App About
16
17	class CAboutDlg : public CDialog
18	{
19	public:
20	CAboutDlg();
21
22	// Dialog Data
23	enum { IDD = IDD_ABOUTBOX };
24
25	protected:
26	virtual void DoDataExchange(CDataExchange* pDX); // DDX/DDV support
27
28	// Implementation
29	protected:
30	DECLARE_MESSAGE_MAP()
31	};
32
33	CAboutDlg::CAboutDlg() : CDialog(CAboutDlg::IDD)
34	{
35	}
36
37	void CAboutDlg::DoDataExchange(CDataExchange* pDX)
38	{
39	CDialog::DoDataExchange(pDX);
40	}
41
42	BEGIN_MESSAGE_MAP(CAboutDlg, CDialog)
43	END_MESSAGE_MAP()
44
45
46	// CFlisServerDlg dialog
47
48
49
50	CFlisServerDlg::CFlisServerDlg(CWnd* pParent /=NULL/)
51	: CDialog(CFlisServerDlg::IDD, pParent)
52	{
53	m_hIcon = AfxGetApp()->LoadIcon(IDR_MAINFRAME);
54	}
55
56	void CFlisServerDlg::DoDataExchange(CDataExchange* pDX)
57	{
58	CDialog::DoDataExchange(pDX);
59	DDX_Control(pDX, IDC_Textwindow, m_Textwindow);
60	}
61
62	BEGIN_MESSAGE_MAP(CFlisServerDlg, CDialog)
63	ON_WM_SYSCOMMAND()
64	ON_WM_PAINT()
65	ON_WM_QUERYDRAGICON()
66	//}}AFX_MSG_MAP
67	ON_BN_CLICKED(IDC_test, OnBnClickedtest)
68	ON_BN_CLICKED(IDCLOSE, OnBnClickedClose)
69	END_MESSAGE_MAP()
70
71
72	// CFlisServerDlg message handlers
73
74	BOOL CFlisServerDlg::OnInitDialog()
75	{
76	CDialog::OnInitDialog();
77
78	// Add "About..." menu item to system menu.
79
80	// IDM_ABOUTBOX must be in the system command range.
81	ASSERT((IDM_ABOUTBOX & 0xFFF0) == IDM_ABOUTBOX);
82	ASSERT(IDM_ABOUTBOX < 0xF000);
83
84	CMenu* pSysMenu = GetSystemMenu(FALSE);
85	if (pSysMenu != NULL)
86	{
87	CString strAboutMenu;
88	strAboutMenu.LoadString(IDS_ABOUTBOX);
89	if (!strAboutMenu.IsEmpty())
90	{
91	pSysMenu->AppendMenu(MF_SEPARATOR);
92	pSysMenu->AppendMenu(MF_STRING, IDM_ABOUTBOX, strAboutMenu);
93	}
94	}
95
96	// Set the icon for this dialog. The framework does this automatically
97	// when the application's main window is not a dialog
98	SetIcon(m_hIcon, TRUE); // Set big icon
99	SetIcon(m_hIcon, FALSE); // Set small icon
100
101	// TODO: Add extra initialization here
102	StartSerial();
103	//SetPin();
104	DBConnect();
105
106	return TRUE; // return TRUE unless you set the focus to a control
107	}
108
109	void CFlisServerDlg::OnSysCommand(UINT nID, LPARAM lParam)
110	{
111	if ((nID & 0xFFF0) == IDM_ABOUTBOX)
112	{
113	CAboutDlg dlgAbout;
114	dlgAbout.DoModal();
115	}
116	else
117	{
118	CDialog::OnSysCommand(nID, lParam);
119	}
120	}
121
122	// If you add a minimize button to your dialog, you will need the code below
123	// to draw the icon. For MFC applications using the document/view model,
124	// this is automatically done for you by the framework.
125
126	void CFlisServerDlg::OnPaint()
127	{
128	if (IsIconic())
129	{
130	CPaintDC dc(this); // device context for painting
131
132	SendMessage(WM_ICONERASEBKGND, reinterpret_cast<WPARAM>(dc.GetSafeHdc()), 0);
133
134	// Center icon in client rectangle
135	int cxIcon = GetSystemMetrics(SM_CXICON);
136	int cyIcon = GetSystemMetrics(SM_CYICON);
137	CRect rect;
138	GetClientRect(&rect);
139	int x = (rect.Width() - cxIcon + 1) / 2;
140	int y = (rect.Height() - cyIcon + 1) / 2;
141
142	// Draw the icon
143	dc.DrawIcon(x, y, m_hIcon);
144	}
145	else
146	{
147	CDialog::OnPaint();
148	}
149	}
150
151	// The system calls this function to obtain the cursor to display while the user drags
152	// the minimized window.
153	HCURSOR CFlisServerDlg::OnQueryDragIcon()
154	{
155	return static_cast<HCURSOR>(m_hIcon);
156	}
157	int CFlisServerDlg::StartSerial(void)
158	{
159	int Baud;
160	CString SerialPort = "COM3";
161
162	Baud = 1200;
163	if( Serial.isOpen() ){
164	Serial.close();
165	Serial.open( SerialPort, Baud );
166	}
167	else {
168	Serial.open( SerialPort, Baud );
169	}
170
171
172	return 0;
173	}
174	std::vector<unsigned char> CFlisServerDlg::readFrame()
175	{
176	std::vector<unsigned char> buf;
177	while(Serial.getComstat().cbInQue > 0)
178	{
179	unsigned char data = Serial.readByte();
180
181	buf.push_back(data);
182	}
183	return buf;
184	}
185	void CFlisServerDlg::OnBnClickedtest()
186	{
187	// TODO: Add your control notification handler code here
188	/*
189	////////////////Read sms ting//////////////////
190	CString tekst;
191	std::vector<unsigned char> data;
192	data.push_back('a');
193	data.push_back('t');
194	data.push_back('+');
195	data.push_back('c');
196	data.push_back('m');
197	data.push_back('g');
198	data.push_back('r');
199	data.push_back('=');
200	data.push_back('1');
201
202	writeFrame(data);
203	ReadSms();
204	////////////////Read sms ting//////////////////
205	*/
206	/*
207	////////////////DBRead stuff//////////////////
208	CString testdata;
209	std::vector<Commands> data;
210	data = DBRead();
211	for (int i=0; i<data.size(); i++)
212	{
213	testdata.Append(data[i].IDnr);
214	testdata.Append(data[i].CommandID);
215	testdata.Append(data[i].InstallationsID);
216	}
217	m_Textwindow.SetWindowText(testdata);
218	////////////////DBRead stuff//////////////////
219	*/
220	/*
221	///////////////Send sms stuff/////////////////
222	vector<unsigned char> tlfnr;
223	vector<unsigned char> smsdata;
224	tlfnr.push_back('2');
225	tlfnr.push_back('9');
226	tlfnr.push_back('7');
227	tlfnr.push_back('2');
228	tlfnr.push_back('2');
229	tlfnr.push_back('6');
230	tlfnr.push_back('0');
231	tlfnr.push_back('3');
232
233	SendSmsHead(tlfnr);
234
235	//35:29860132:75 <--- demo pakke;
236	smsdata.push_back('3');
237	smsdata.push_back('5');
238	smsdata.push_back(':');
239	smsdata.push_back('2');
240	smsdata.push_back('9');
241	smsdata.push_back('8');
242	smsdata.push_back('6');
243	smsdata.push_back('0');
244	smsdata.push_back('1');
245	smsdata.push_back('3');
246	smsdata.push_back('2');
247	smsdata.push_back(':');
248	smsdata.push_back('7');
249	smsdata.push_back('5');
250
251	SendSmsData(smsdata);
252	Sleep(2000);
253	if(Serial.getComstat().cbInQue > 0)
254	{
255	CString tekst;
256	std::vector<unsigned char> answer = readFrame();
257	Sleep(50);
258	char array1[25];
259	int i;
260	for (int i=0; i<answer.size(); i++)
261	{
262	array1[i] = answer[i];
263	}
264
265	for (int i=0; i<answer.size(); i++)
266	{
267	if ((array1[i] != 0x0A) && (array1[i] != 0x0D))
268	{
269	tekst.AppendChar(array1[i]);
270	}
271	}
272	m_Textwindow.SetWindowText(tekst);
273	}
274	///////////////Send sms stuff/////////////////
275	*/
276	}
277	void CFlisServerDlg::writeFrame(std::vector<unsigned char> data)
278	{
279	for (int i=0; i<data.size(); i++)
280	{
281	Serial.writeByte( data[i] );
282	Sleep(5);
283	}
284	Serial.writeByte(0x0D);
285	Sleep(100);
286
287	}
288	int CFlisServerDlg::SetPin(void)
289	{
290	CString tekst;
291	std::vector<unsigned char> data;
292	data.push_back('a');
293	data.push_back('t');
294	data.push_back('+');
295	data.push_back('c');
296	data.push_back('p');
297	data.push_back('i');
298	data.push_back('n');
299	data.push_back('=');
300	data.push_back('2');
301	data.push_back('5');
302	data.push_back('9');
303	data.push_back('5');
304
305	writeFrame(data);
306	Sleep(750);
307	if(Serial.getComstat().cbInQue > 0)
308	{
309	std::vector<unsigned char> answer = readFrame();
310	Sleep(50);
311	char array1[25];
312	int i;
313	for (int i=0; i<answer.size(); i++)
314	{
315	array1[i] = answer[i];
316	}
317
318	for (int i=0; i<answer.size(); i++)
319	{
320	if ((array1[i] != 0x0A) && (array1[i] != 0x0D))
321	{
322	tekst.AppendChar(array1[i]);
323	}
324	}
325	m_Textwindow.SetWindowText(tekst);
326	}
327	return 0;
328	}
329	void CFlisServerDlg::SendSmsData(std::vector<unsigned char> data)
330	{
331
332	for (int i=0; i<data.size(); i++)
333	{
334	Serial.writeByte( data[i] );
335	Sleep(5);
336	}
337	Serial.writeByte(0x1A);
338	Sleep(500);
339
340	}
341	void CFlisServerDlg::SendSmsHead(std::vector<unsigned char> data)
342	{
343	vector<unsigned char> atcommand;
344	atcommand.push_back('a');
345	atcommand.push_back('t');
346	atcommand.push_back('+');
347	atcommand.push_back('c');
348	atcommand.push_back('m');
349	atcommand.push_back('g');
350	atcommand.push_back('s');
351	atcommand.push_back('=');
352	atcommand.push_back('"');
353	int s = (atcommand.size() -1 );
354
355	for (int i=0; i<(atcommand.size()); i++)
356	{
357	Serial.writeByte( atcommand[i] );
358	Sleep(5);
359	}
360
361	for (int i=0; i<data.size(); i++)
362	{
363	Serial.writeByte( data[i] );
364	Sleep(5);
365	}
366	Serial.writeByte(atcommand[s]);
367	Serial.writeByte(0x0D);
368	Sleep(250);
369	}
370	void CFlisServerDlg::DBConnect()
371	{
372	CString dsn;
373	dsn.Format("ODBC;Description=asd;DRIVER=PostgreSQL ANSI;SERVER=192.168.134.132; uid=serrenab;password=furnacemonitor;database=flisfyr;sslmode=prefer");
374	db.OpenEx(dsn, CDatabase::noOdbcDialog);
375	}
376	vector<Commands> CFlisServerDlg::DBRead(void)
377	{
378	vector<Commands> buffer;
379
380	CString SQL, IDnr, CommandID, InstallationsID;
381	SQL = "select id,date_trunc('second', created) as created,executed,commandid,installationid from command WHERE executed IS NULL;";
382	CRecordset rs(&db);
383	rs.Open(AFX_DB_USE_DEFAULT_TYPE, SQL);
384	if (rs.GetRecordCount()>0)
385	{
386	rs.MoveFirst();
387	while(!rs.IsEOF())
388	{
389	Commands Mycom;
390	rs.GetFieldValue((short)0, IDnr);
391	rs.GetFieldValue(3, CommandID);
392	rs.GetFieldValue(4, InstallationsID);
393
394	Mycom.IDnr = IDnr;
395	Mycom.CommandID = CommandID;
396	Mycom.InstallationsID = InstallationsID;
397
398	buffer.push_back(Mycom);
399	rs.MoveNext();
400	}
401	}
402	rs.Close();
403	return buffer;
404	}
405	void CFlisServerDlg::ReadSms()
406	{
407	CString tekst, oldtekst;
408	Sleep(950);
409	if(Serial.getComstat().cbInQue > 0)
410	{
411	std::vector<unsigned char> answer = readFrame();
412	Sleep(50);
413	char array1[250];
414	int i;
415	for (int i=0; i<answer.size(); i++)
416	{
417	array1[i] = answer[i];
418	}
419
420	for (int i=0; i<answer.size(); i++)
421	{
422	if ((array1[i] != 0x0A) && (array1[i] != 0x0D))
423	{
424	tekst.AppendChar(array1[i]);
425	}
426	}
427
428	m_Textwindow.GetWindowText(oldtekst);
429	oldtekst.Append("\r\n");
430	oldtekst.Append(tekst);
431	m_Textwindow.SetWindowText(oldtekst);
432	SmsSplit(tekst);
433	}
434	}
435	void CFlisServerDlg::SmsSplit(CString data)
436	{
437	CString FyrData, TlfNr, SmsCount, Temper, Flamme, Flis, FremFejl, PowerFail, oldtekst;
438	char CharData[150];
439	strcpy(CharData,data);
440
441	int s=22;
442	for (int i=0; i<=7; i++)
443	{
444	TlfNr.AppendChar(CharData[s]);
445	s++;
446	}
447
448	for (int s=55; s<=(data.GetLength()-3); s++)
449	{
450	FyrData.AppendChar(CharData[s]);
451	}
452	FyrData.Append(":");
453
454	SmsCount = Splitter(FyrData);
455	Temper = Splitter(FyrData);
456	Flamme = Splitter(FyrData);
457	Flis = Splitter(FyrData);
458	FremFejl = Splitter(FyrData);
459	PowerFail = Splitter(FyrData);
460	///////////////////////////////////////////////////////////////////////////////////////////////////////
461	///////////////////// Her skal sendes data til databasen //////////////////////////////////////////////
462	m_Textwindow.GetWindowText(oldtekst);
463	oldtekst.Append("\r\n");
464	oldtekst.Append("P� n�ste linie kommer SmsCount. \r\n");
465	oldtekst.Append(SmsCount);
466	oldtekst.Append("\r\n");
467	oldtekst.Append("P� n�ste linie kommer Temper. \r\n");
468	oldtekst.Append(Temper);
469	oldtekst.Append("\r\n");
470	oldtekst.Append("P� n�ste linie kommer Flamme. \r\n");
471	oldtekst.Append(Flamme);
472	oldtekst.Append("\r\n");
473	oldtekst.Append("P� n�ste linie kommer Flis. \r\n");
474	oldtekst.Append(Flis);
475	oldtekst.Append("\r\n");
476	oldtekst.Append("P� n�ste linie kommer FremFejl. \r\n");
477	oldtekst.Append(FremFejl);
478	oldtekst.Append("\r\n");
479	oldtekst.Append("P� n�ste linie kommer PowerFail. \r\n");
480	oldtekst.Append(PowerFail);
481	m_Textwindow.SetWindowText(oldtekst);
482	///////////////////////////////////////////////////////////////////////////////////////////////////////
483	///////////////////// Her skal sendes data til databasen //////////////////////////////////////////////
484	}
485	CString CFlisServerDlg::Splitter(CString& fyrdata)
486	{
487	CString Output;
488
489	int pos = fyrdata.Find(':',0);
490	if (pos != -1)
491	{
492	Output = fyrdata.Left(pos);
493	fyrdata = fyrdata.Right( fyrdata.GetLength() - pos -1);
494	}
495	return Output;
496	}
497	void CFlisServerDlg::OnBnClickedClose()
498	{
499	// TODO: Add your control notification handler code here
500
501	if( Serial.isOpen() )
502	{
503	Serial.close();
504	}
505
506	if(db.IsOpen())
507	{
508	db.Close();
509	}
510	OnOK();
511	}