// JStrans.cpp : implementation file
//

#include "stdafx.h"
#include "GSMTest.h"
#include "JStrans.h"
#include "TransGL.h"


#include <winsock.h>
#include <mysql.h>
#include "database.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CJStrans dialog


CJStrans::CJStrans(CWnd* pParent /*=NULL*/)
	: CDialog(CJStrans::IDD, pParent)
{
	//{{AFX_DATA_INIT(CJStrans)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CJStrans::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CJStrans)
	DDX_Control(pDX, IDC_LIST1, m_add_jslist);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CJStrans, CDialog)
	//{{AFX_MSG_MAP(CJStrans)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CJStrans message handlers

BOOL CJStrans::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	 m_add_jslist.InsertColumn(0,"數量",LVCFMT_CENTER,80,0);
	m_add_jslist.InsertColumn(1,"變壓器ID",LVCFMT_CENTER,160,1);	
	m_add_jslist.InsertColumn(2,"變壓器TEL",LVCFMT_CENTER,160,1);
	m_add_jslist.InsertColumn(3,"備注",LVCFMT_LEFT,280,10);
	m_add_jslist.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
	showalltrans();

	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CJStrans::showalltrans()
{
	m_add_jslist.DeleteAllItems();
	
	CDatabase1 database;	
	if(!database.ConnectDB())
	{
		return;
	}
	
	CString charset="set charset gb2312;";//使之正常顯示中文,或用set character_set_results=gb2312;
	database.ExecuteSQL(charset,charset.GetLength());//執行語句.
	
	Data_Param result;		
	
	result.tab_name="trans_info";
	result.select_exp="TRANS_num,TRANS_ID,TRANS_TEL,remark";
    CString def1;
	def1="TRANS_TEL NOT IN (SELECT TRANS_TEL FROM TRANS_js)";
//	def1="(trans_info.TRANS_TEL)!=(trans_js.trans_tel)";
	result.where_def=def1.GetBuffer(100);

	

	if(database.SelectRecord(&result))
	{
		int count=(int)database.GetRowNum();			
		
		for(int i=0;i<count;i++)			
		{
			database.SeekData(i);				
			MYSQL_ROW row=database.GetRecord();
			
			m_add_jslist.InsertItem(i,row[0]);
			m_add_jslist.SetItemText(i,1,row[1]);
			m_add_jslist.SetItemText(i,2,row[2]);
			m_add_jslist.SetItemText(i,3,row[3]);
			
		}
	}

}

void CJStrans::OnOK() 
{
	// TODO: Add extra validation here
		int count=m_add_jslist.GetSelectedCount();

	POSITION pos=m_add_jslist.GetFirstSelectedItemPosition();
	if(pos==NULL)
	{
		AfxMessageBox("請選擇變壓器!");
		return;
	}
	int nItem = m_add_jslist.GetNextSelectedItem(pos);
	num=m_add_jslist.GetItemText(nItem,2);


/*	CDatabase1 database;	
	if(!database.ConnectDB())
	{	
		AfxMessageBox("連接服務器失敗!");
		return;
	}
	CString charset="set names 'gb2312'";//使之正常顯示中文,或用set character_set_results=gb2312;
	database.ExecuteSQL(charset,charset.GetLength());//執行語句.
	CString sSQL;

	while (count--) 
	{
		int nItem = m_add_jslist.GetNextSelectedItem(pos);
		
		sSQL.Format("select trans_num from trans_js where  TRANS_TEL='%s'",
			m_add_jslist.GetItemText(nItem,2));
		database.ExecuteSQL(sSQL,sSQL.GetLength());


		int cnt=(int)database.GetRowNum();
		if(cnt<=0)
		{
            num=m_add_jslist.GetItemText(nItem,2);
			sSQL.Format("insert into trans_js (TRANS_TEL) values ('%s')",
			m_add_jslist.GetItemText(nItem,2));
			if(!database.ExecuteSQL(sSQL,sSQL.GetLength()))
			{
				AfxMessageBox("操作失敗!");
				break;
			}
		}
	}*/
	
	CDialog::OnOK();
}