// CheckManDlg.cpp : implementation file
//

#include "stdafx.h"
#include "Stock.h"
#include "CheckManDlg.h"
#include "COMDEF.H"
#include "Columns.h"
#include "Column.h"
#include "_recordset.h"
#include "CheckEditDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CCheckManDlg dialog


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


void CCheckManDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CCheckManDlg)
	DDX_Control(pDX, IDC_ADODC1, m_adodc1);
	DDX_Control(pDX, IDC_ADODC2, m_adodc2);
	DDX_Control(pDX, IDC_ADODC3, m_adodc3);
	DDX_Control(pDX, IDC_ADODC5, m_adodc5);
	DDX_Control(pDX, IDC_ADODC6, m_adodc6);
	DDX_Control(pDX, IDC_DATAGRID1, m_datagrid);
	DDX_Control(pDX, IDC_PNAME_DATACOMBO, m_Pname);
	DDX_Control(pDX, IDC_PROTYPE1_DATACOMBO, m_ProType1);
	DDX_Control(pDX, IDC_PROTYPE2_DATACOMBO, m_ProType2);
	DDX_Control(pDX, IDC_STOREHOUSE_DATACOMBO, m_Storehouse);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CCheckManDlg, CDialog)
	//{{AFX_MSG_MAP(CCheckManDlg)
	ON_BN_CLICKED(IDC_MODI_BUTTON, OnModiButton)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CCheckManDlg message handlers
void CCheckManDlg::Refresh_Data()
{
	CString cPid;  //保存當前選擇的產品編號
	if (m_Pname.GetBoundText() == "")
		cPid = "0";
	else
		cPid = m_Pname.GetBoundText();
	CString cSid; //保存當前選擇的倉庫編號
	if (m_Storehouse.GetBoundText() == "")
		cSid = "0";
	else
		cSid = m_Storehouse.GetBoundText();
	//設置SELECT語句
	CString cSource;
	cSource = "SELECT SpId, Pprice As 產品入庫單價, Pnum As 庫存數量, MakeDate As 生產日期";
	cSource += " FROM ProInStore WHERE Pid=" + cPid + " AND Sid=" + cSid;
	//設置記錄源
	m_adodc6.SetRecordSource(cSource);
	m_adodc6.Refresh();
	//設置表格列寬度
	_variant_t vIndex;
	vIndex = long(0);
	m_datagrid.GetColumns().GetItem(vIndex).SetWidth(0);	
	vIndex = long(1);
	m_datagrid.GetColumns().GetItem(vIndex).SetWidth(180);	
	vIndex = long(2);
	m_datagrid.GetColumns().GetItem(vIndex).SetWidth(180);	
	vIndex = long(3);
	m_datagrid.GetColumns().GetItem(vIndex).SetWidth(180);	
}

BEGIN_EVENTSINK_MAP(CCheckManDlg, CDialog)
    //{{AFX_EVENTSINK_MAP(CCheckManDlg)
	ON_EVENT(CCheckManDlg, IDC_PROTYPE1_DATACOMBO, -600 /* Click */, OnClickProtype1Datacombo, VTS_I2)
	ON_EVENT(CCheckManDlg, IDC_PROTYPE2_DATACOMBO, -600 /* Click */, OnClickProtype2Datacombo, VTS_I2)
	ON_EVENT(CCheckManDlg, IDC_PNAME_DATACOMBO, -600 /* Click */, OnClickPnameDatacombo, VTS_I2)
	ON_EVENT(CCheckManDlg, IDC_STOREHOUSE_DATACOMBO, -600 /* Click */, OnClickStorehouseDatacombo, VTS_I2)
	//}}AFX_EVENTSINK_MAP
END_EVENTSINK_MAP()

void CCheckManDlg::OnClickProtype1Datacombo(short Area) 
{
	//讀取一級產品類別編號
	CString cUpperId;
	cUpperId = m_ProType1.GetBoundText();
	if (cUpperId == "")
		cUpperId = "0";
	//設置查詢二級產品類型的SELECT語句
	CString cSource;
	cSource = "SELECT * FROM ProType WHERE UpperId=" + cUpperId;

	m_ProType2.SetText("");
	//設置m_adodc3，從而刷新二級產品類別的列表
	m_adodc2.SetRecordSource(cSource);
	m_adodc2.Refresh();		
	//設置產品列表框，因為沒有選中二級產品類別，所以要清空產品列表框
	cSource = "SELECT * FROM Product WHERE TypeId=0";

	m_Pname.SetText("");
	//設置m_adodc3，從而刷新二級產品類別的列表
	m_adodc3.SetRecordSource(cSource);
	m_adodc3.Refresh();
	//刷新庫存產品表格
	Refresh_Data();
}

BOOL CCheckManDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	//刷新庫存產品表格
	Refresh_Data();
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CCheckManDlg::OnClickProtype2Datacombo(short Area) 
{
	//讀取二級產品類別編號
	CString cTypeId;
	cTypeId = m_ProType2.GetBoundText();
	if (cTypeId == "")
		cTypeId = "0";
	//設置查詢二級產品類型的SELECT語句
	CString cSource;
	cSource = "SELECT * FROM Product WHERE TypeId=" + cTypeId;

	m_Pname.SetText("");
	//設置m_adodc3，從而刷新二級產品類別的列表
	m_adodc3.SetRecordSource(cSource);
	m_adodc3.Refresh();		
	//刷新庫存產品表格
	Refresh_Data();	
}

void CCheckManDlg::OnClickPnameDatacombo(short Area) 
{
	//刷新庫存產品表格
	Refresh_Data();
}

void CCheckManDlg::OnClickStorehouseDatacombo(short Area) 
{
	//刷新庫存產品表格
	Refresh_Data();	
}

void CCheckManDlg::OnModiButton() 
{
	// TODO: Add your control notification handler code here
	if (m_adodc6.GetRecordset().GetEof())
	{
		MessageBox("請選擇盤點記錄");
		return;
	}
	CCheckEditDlg dlg;
	dlg.cSpId = m_datagrid.GetItem(0);			//庫存記錄編號
	dlg.m_Sname = m_Storehouse.GetText();		//倉庫名稱
	dlg.m_Pname = m_Pname.GetText();			//產品名稱
	dlg.m_MakeDate = m_datagrid.GetItem(3);		//生產日期
	dlg.m_Price = m_datagrid.GetItem(1);		//單價
	dlg.m_OldNum = m_datagrid.GetItem(2);		//原數量
	if (dlg.DoModal() == IDOK)
		Refresh_Data();
}