// DClime.cpp : implementation file
//

#include "stdafx.h"
#include "商品庫存管理系統.h"
#include "DClime.h"
#include "DClime_AddDlg.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
extern _ConnectionPtr cnn;
extern CMyApp theApp;
/////////////////////////////////////////////////////////////////////////////
// CDClime dialog


CDClime::CDClime(CWnd* pParent /*=NULL*/)
	: CDialog(CDClime::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDClime)
	//}}AFX_DATA_INIT
}


void CDClime::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDClime)
	DDX_Control(pDX, IDC_TREE1, m_Tree);
	DDX_Control(pDX, IDC_BUTDele, m_ButDele);
	DDX_Control(pDX, IDC_BUTAdd, m_ButAdd);
	DDX_Control(pDX, IDC_BUTExit, m_ButExit);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDClime, CDialog)
	//{{AFX_MSG_MAP(CDClime)
	ON_BN_CLICKED(IDC_BUTAdd, OnBUTAdd)
	ON_BN_CLICKED(IDC_BUTDele, OnBUTDele)
	ON_BN_CLICKED(IDC_BUTExit, OnBUTExit)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDClime message handlers

void CDClime::OnOK() 
{
	// TODO: Add extra validation here
	
	//CDialog::OnOK();
}

void CDClime::OnBUTAdd() 
{
	HTREEITEM Node,SelectNode;
	CDClime_AddDlg dlg;
	CString NodeText,ParentNodeText,sSQL;
	int ID;
	Node=m_Tree.GetSelectedItem();
	dlg.SetNode(&m_Tree,Node);
	dlg.DoModal();
	NodeText=m_Tree.GetItemText(Node);
	ParentNodeText=m_Tree.GetItemText(m_Tree.GetParentItem(Node));
	if(dlg.IsOK==false)
		return;
	else
	{
		if(dlg.Connection==1)	//確定關系
		{	
			ID=theApp.NumberTOName("地域信息表","名稱",NodeText);

			SelectNode=Node;
		}
		else	
		{
			ID=theApp.NumberTOName("地域信息表","名稱",ParentNodeText);
			SelectNode=m_Tree.GetParentItem(Node);
		}
		CString LatterText=theApp.CharToLetterCode(dlg.Name);
		int NewID=theApp.AutoNumber(0,"地域信息表");
		sSQL.Format("INSERT into 地域信息表 VALUES(%d,'%s','%s',%d,%d)",NewID,dlg.Name,LatterText,dlg.IconStyle,ID);
		cnn->Execute((_bstr_t)sSQL,NULL,adCmdText);
		m_Tree.InsertItem(dlg.Name,dlg.IconStyle,dlg.IconStyle,SelectNode,TVI_LAST);
	}
}

void CDClime::OnBUTDele() 
{
	_RecordsetPtr rst;
	rst.CreateInstance(__uuidof(Recordset));
	CString NodeText,sSQL;
	HTREEITEM DeleteItem;
	int a=MessageBox("確定刪除指定節點嗎？","系統提示",MB_ICONQUESTION|MB_OKCANCEL);
	if(a==1)
	{
		//判斷是否包含子節點
		DeleteItem=m_Tree.GetSelectedItem();
		NodeText=m_Tree.GetItemText(DeleteItem);
		int ID=theApp.NumberTOName("地域信息表","名稱",NodeText);
		sSQL.Format("SELECT * FROM 地域信息表 WHERE 上級編號=%d",ID);
		rst=cnn->Execute((_bstr_t)sSQL,NULL,adCmdText);
		if(theApp.GetRecordCount(rst)!=0)
		{
			MessageBox("此節點包含子節點,請先刪除子節點！","系統提示",MB_ICONSTOP|MB_OK);
			rst->Close();
		}
		else
		{
			rst->Close();
			sSQL.Format("DELETE * FROM 地域信息表 WHERE 編號=%d",ID);
			cnn->Execute((_bstr_t)sSQL,NULL,adCmdText);
			m_Tree.DeleteItem(DeleteItem);

		}
	}	
}

void CDClime::OnBUTExit() 
{
	this->OnCancel();	
}

BOOL CDClime::OnInitDialog() 
{
	CDialog::OnInitDialog();
		//設置圖標
	m_hIcon=::LoadIcon(::AfxGetResourceHandle(),MAKEINTRESOURCE(IDI_ICON2));
	this->SetIcon(m_hIcon,true);

	_RecordsetPtr Rst,RstProvince,RstCity,RstTown;
	HTREEITEM item,itemProvince,itemCity,itemTown;
	CString sSQL,ItemText,ItemStyle,ItemID;
	//初始化數據集
	::CoInitialize(NULL);
	Rst.CreateInstance(__uuidof(Recordset));
	RstProvince.CreateInstance(__uuidof(Recordset));
	RstCity.CreateInstance(__uuidof(Recordset));
	RstTown.CreateInstance(__uuidof(Recordset));
	
	//建立并初始化圖像列表控件
	m_Imagelist.Create(16,16,ILC_COLOR32|ILC_MASK,0,0);
	for(int i=IDI_ICON11;i<=IDI_ICON14;i++)
	{
		m_Imagelist.Add(::LoadIcon(::AfxGetResourceHandle(),MAKEINTRESOURCE(i)));
	}
	
	m_Tree.EnableAutomation();
	m_Tree.SetImageList(&m_Imagelist,TVSIL_NORMAL);
	item=m_Tree.InsertItem("中華人民共和國",0,0,TVI_ROOT,TVI_LAST);
	sSQL.Format("SELECT * FROM 地域信息表 WHERE 上級編號=0");
	RstProvince=cnn->Execute((_bstr_t)sSQL,NULL,adCmdText);
	if(theApp.GetRecordCount(RstProvince)<=0)
		return false;
	else
	{
		RstProvince->MoveFirst();
		for(int Province=0;Province<theApp.GetRecordCount(RstProvince);Province++)
		{
			RstProvince->MoveFirst();
			RstProvince->Move(Province);
			ItemText=(char*)(_bstr_t)RstProvince->GetCollect("名稱");
			ItemStyle=(char*)(_bstr_t)RstProvince->GetCollect("類型");
			ItemID=(char*)(_bstr_t)RstProvince->GetCollect("編號");
			itemProvince=m_Tree.InsertItem(ItemText,atoi(ItemStyle),atoi(ItemStyle),item,TVI_LAST);
			sSQL.Format("SELECT * FROM 地域信息表 WHERE 上級編號=%s",ItemID);
			RstCity=cnn->Execute((_bstr_t)sSQL,NULL,adCmdText);
			if(theApp.GetRecordCount(RstCity)>0)
			{
				for(int City=0;City<theApp.GetRecordCount(RstCity);City++)
				{
					RstCity->MoveFirst();
					RstCity->Move(City);
					ItemText=(char*)(_bstr_t)RstCity->GetCollect("名稱");
					ItemStyle=(char*)(_bstr_t)RstCity->GetCollect("類型");
					ItemID=(char*)(_bstr_t)RstCity->GetCollect("編號");
					itemCity=m_Tree.InsertItem(ItemText,atoi(ItemStyle),atoi(ItemStyle),itemProvince,TVI_LAST);
					sSQL.Format("SELECT * FROM 地域信息表 WHERE 上級編號=%s",ItemID);
					RstTown=cnn->Execute((_bstr_t)sSQL,NULL,adCmdText);
					if(theApp.GetRecordCount(RstTown)>0)
					{
						for(int Town=0;Town<theApp.GetRecordCount(RstTown);Town++)
						{
							RstTown->MoveFirst();
							RstTown->Move(Town);
							ItemText=(char*)(_bstr_t)RstTown->GetCollect("名稱");
							ItemStyle=(char*)(_bstr_t)RstTown->GetCollect("類型");
							itemTown=m_Tree.InsertItem(ItemText,atoi(ItemStyle),atoi(ItemStyle),itemCity,TVI_LAST);
						}

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