// ProTypeManDlg.cpp : implementation file
//

#include "stdafx.h"
#include "Stock.h"
#include "ProTypeManDlg.h"
#include "ProTypeEditDlg.h"
#include "ProType.h"
#include "Product.h"

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

/////////////////////////////////////////////////////////////////////////////
// CProTypeManDlg dialog


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


void CProTypeManDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CProTypeManDlg)
	DDX_Control(pDX, IDC_ADODC1, m_adodc1);
	DDX_Control(pDX, IDC_ADODC2, m_adodc2);
	DDX_Control(pDX, IDC_DATALIST1, m_datalist1);
	DDX_Control(pDX, IDC_DATALIST2, m_datalist2);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CProTypeManDlg, CDialog)
	//{{AFX_MSG_MAP(CProTypeManDlg)
	ON_BN_CLICKED(IDC_ADD1_BUTTON, OnAdd1Button)
	ON_BN_CLICKED(IDC_MODI1_BUTTON, OnModi1Button)
	ON_BN_CLICKED(IDC_DEL1_BUTTON, OnDel1Button)
	ON_BN_CLICKED(IDC_ADD2_BUTTON, OnAdd2Button)
	ON_BN_CLICKED(IDC_MODI2_BUTTON, OnModi2Button)
	ON_BN_CLICKED(IDC_DEL2_BUTTON, OnDel2Button)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CProTypeManDlg message handlers

void CProTypeManDlg::OnAdd1Button() 
{
	// TODO: Add your control notification handler code here
	CProTypeEditDlg dlg;
	dlg.cTypeId = ""; //表示添加記錄
	dlg.cTypeName = ""; 
	dlg.iUpperId = 0; //表示一級類別
	//打開編輯對話框
	if (dlg.DoModal() == IDOK)
		m_adodc1.Refresh();
}

void CProTypeManDlg::OnModi1Button() 
{
	// TODO: Add your control notification handler code here
	if (m_datalist1.GetText() == "")
	{
		MessageBox("請選擇要修改的產品類別");
		return;
	}
	CProTypeEditDlg dlg;
	dlg.cTypeId = m_datalist1.GetBoundText(); //表示修改記錄
	dlg.cTypeName = m_datalist1.GetText(); 
	dlg.iUpperId = 0; //表示一級類別
	dlg.m_TypeName = m_datalist1.GetText();
	dlg.m_Upper = "";
	//打開編輯對話框
	if (dlg.DoModal() == IDOK)
		m_adodc1.Refresh();
}

void CProTypeManDlg::OnDel1Button() 
{
	// TODO: Add your control notification handler code here
	if (m_datalist1.GetText() == "")
	{
		MessageBox("請選擇要刪除的產品類別");
		return;
	}
	CString Tid;
	Tid = m_datalist1.GetBoundText();
	//判斷是否包含下級類別
	CProType pt;
	if (pt.HaveSon(Tid) == 1)
	{
		MessageBox("當前類別包含下級類別，不能刪除");
		return;
	}
	//確定是否刪除
	if (MessageBox("是否刪除當前類別", "請確認", MB_YESNO) == IDYES)
	{	
		pt.sql_delete(Tid);  //刪除
		m_adodc1.Refresh();	 //刷新
	}
}

BEGIN_EVENTSINK_MAP(CProTypeManDlg, CDialog)
    //{{AFX_EVENTSINK_MAP(CProTypeManDlg)
	ON_EVENT(CProTypeManDlg, IDC_DATALIST1, -600 /* Click */, OnClickDatalist1, VTS_NONE)
	//}}AFX_EVENTSINK_MAP
END_EVENTSINK_MAP()

void CProTypeManDlg::OnClickDatalist1() 
{
	// TODO: Add your control notification handler code here
	CString cUpper;
	cUpper = m_datalist1.GetBoundText(); //讀取選擇類別的編號
	//設置二級類別的記錄源
	m_adodc2.SetRecordSource("SELECT * FROM ProType WHERE UpperId=" + cUpper);
	m_adodc2.Refresh();
}

void CProTypeManDlg::OnAdd2Button() 
{
	// TODO: Add your control notification handler code here
	if (m_datalist1.GetText() == "")
	{
		MessageBox("請選擇上級產品類別");
		return;
	}
	CProTypeEditDlg dlg;
	dlg.cTypeId = ""; //表示添加記錄
	dlg.cTypeName = ""; 
	dlg.iUpperId = atoi(m_datalist1.GetBoundText()); //設置上級類別編號
	dlg.m_TypeName = "";
	dlg.m_Upper = m_datalist1.GetText();
	//打開編輯對話框
	if (dlg.DoModal() == IDOK)
		OnClickDatalist1();	
}

void CProTypeManDlg::OnModi2Button() 
{
	// TODO: Add your control notification handler code here
	if (m_datalist2.GetText() == "")
	{
		MessageBox("請選擇要修改的產品類別");
		return;
	}
	CProTypeEditDlg dlg;
	dlg.cTypeId = m_datalist2.GetBoundText(); //表示修改記錄
	dlg.cTypeName = m_datalist2.GetText(); 
	dlg.iUpperId = atoi(m_datalist1.GetBoundText()); //上級類別編號
	dlg.m_TypeName = m_datalist2.GetText();
	dlg.m_Upper = m_datalist1.GetText();
	//打開編輯對話框
	if (dlg.DoModal() == IDOK)
		OnClickDatalist1();	
}

void CProTypeManDlg::OnDel2Button() 
{
	// TODO: Add your control notification handler code here
	if (m_datalist2.GetText() == "")
	{
		MessageBox("請選擇要刪除的產品類別");
		return;
	}
	CString Tid;
	Tid = m_datalist2.GetBoundText();
	//判斷類別中是否包含產品
	CProduct pro;
	if (pro.HaveType(Tid) == 1)
	{
		MessageBox("當前類別中包含產品，不能刪除");
		return;
	}
	//確定是否刪除
	if (MessageBox("是否刪除當前類別", "請確認", MB_YESNO) == IDYES)
	{	
		CProType pt;
		pt.sql_delete(Tid);  //刪除
		OnClickDatalist1();	 //刷新
	}	
}