// DlgBookAdjustPrice2.cpp : implementation file
//

#include "stdafx.h"
#include "bbb.h"
#include "DlgBookAdjustPrice2.h"
#include "KeyEdit.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

extern _ConnectionPtr m_pCon;  //ADO連接對象
extern _RecordsetPtr m_pRs; 
extern _CommandPtr m_pCom;
/////////////////////////////////////////////////////////////////////////////
// CDlgBookAdjustPrice2 dialog


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


void CDlgBookAdjustPrice2::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDlgBookAdjustPrice2)
	DDX_Control(pDX, IDC_VALUE, m_value);
	DDX_Control(pDX, IDC_SELLPRICE, m_sellprice);
	DDX_Control(pDX, IDC_QUERY, m_query);
	DDX_Control(pDX, IDC_FIELDS, m_field);
	DDX_Control(pDX, IDC_DETAILLIST, m_list);
	DDX_Control(pDX, IDC_BARCODE, m_barcode);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDlgBookAdjustPrice2, CDialog)
	//{{AFX_MSG_MAP(CDlgBookAdjustPrice2)
	ON_CBN_SELCHANGE(IDC_FIELDS, OnSelchangeFields)
	ON_BN_CLICKED(IDC_QUERY, OnQuery)
	ON_NOTIFY(NM_CLICK, IDC_DETAILLIST, OnClickDetaillist)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDlgBookAdjustPrice2 message handlers

BOOL CDlgBookAdjustPrice2::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	//set the sytle of m_list
	m_list.ModifyStyle(0,LVS_SHOWSELALWAYS);
	m_list.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_FLATSB|LVS_EX_GRIDLINES);
	//insert column to m_list ,set column text and column width

	m_list.InsertColumn(0,"條形碼",LVCFMT_LEFT,100);
	m_list.InsertColumn(1,"書籍名稱",LVCFMT_LEFT,100);
	m_list.InsertColumn(2,"助記碼",LVCFMT_LEFT,60);
	m_list.InsertColumn(3,"作者",LVCFMT_LEFT,80);
	m_list.InsertColumn(4,"出版社",LVCFMT_LEFT,80);
	m_list.InsertColumn(5,"價格",LVCFMT_LEFT,80);

	//set edit control color
	m_barcode.SetEditTextColor(RGB(0,0,255));
	m_sellprice.SetEditTextColor(RGB(0,0,255));

	//allow edit control to keyed number only
	m_barcode.IsNumber= true;
	m_sellprice.IsNumber = true;
	
	return TRUE;  
}

void CDlgBookAdjustPrice2::Query()
{
	m_list.DeleteAllItems();
	m_barcode.SetWindowText("");
	m_sellprice.SetWindowText("");
	
	//judge combobox text is or not null
	CString c_field,c_value,field;
	m_field.GetWindowText(c_field);
	m_value.GetWindowText(c_value);
	
	if ((c_field.IsEmpty())||(c_value.IsEmpty()))
	{
		AfxMessageBox("查詢條件不完整.",IDOK,0);
		return;
	}
	// begin querying
	
	int index = m_field.GetCurSel();
	if (index != -1)
	{
		switch (index)
		{
			case 0: 
			{
				field ="bookname";
				break;
			}
			case 1: 
			{
				field = "barcode";
				break;
			}
			case 2: 
			{
				field = "author";
				break;
			}
		}
	}
	CString sql;
	sql.Format("select a.barcode,bookname,shortname,author,bookconcern,b.sellprice from tb_bookinfo a inner join tb_fixprice b on a.barcode = b.barcode and a.%s = '%s'",field,c_value);
	m_pRs = m_pCon->Execute((_bstr_t)sql,NULL,adCmdText);
	int row = 0;
	while (! m_pRs->adoEOF)
	{
		m_list.InsertItem(1000,"");
		for (int i = 0;i <m_pRs->GetFields()->Count;i++)
		{
			CString temp = (TCHAR*)(_bstr_t)m_pRs->GetFields()->GetItem((long)i)->Value;
			m_list.SetItemText(row,i,temp);
		}
		row +=1;
		m_pRs->MoveNext();
	}
}

void CDlgBookAdjustPrice2::CancelOperate()
{
	m_list.DeleteAllItems();
	m_field.SetCurSel(0);
	m_value.SetCurSel(-1);
	m_barcode.SetWindowText("");
	m_sellprice.SetWindowText("");
}

void CDlgBookAdjustPrice2::BookAdjustPrice()
{
	CString barcode;
	m_barcode.GetWindowText(barcode);
	if (!barcode.IsEmpty())
	{
		CString c_sellprice;
		m_sellprice.GetWindowText(c_sellprice);
		if (c_sellprice.IsEmpty())
		{
			AfxMessageBox("請設置圖書售價.",IDOK,0);
			return;
		}
		float f_sellprice =atof(c_sellprice);
		CString sql;
		sql.Format("update tb_fixprice set sellprice = %f  where barcode = '%s'",f_sellprice,barcode);
		try
		{
			m_pCon->Execute((_bstr_t)sql,NULL,adCmdText);
			CancelOperate();
			MessageBox("操作成功.","提示",64);
		}
		catch(...)
		{
			MessageBox("操作失敗.","提示",64);
		}		
	}
	else
	{
		AfxMessageBox("請在表格中選擇數據",IDOK,0);
	}	
}

void CDlgBookAdjustPrice2::OnSelchangeFields() 
{
	int index = m_field.GetCurSel();
	if (index != -1)
	{
		CString field;
		switch (index)
		{
			case 0: 
			{
				field ="bookname";
				break;
			}
			case 1: 
			{
				field = "barcode";
				break;
			}
			case 2: 
			{
				field = "author";
				break;
			}
		}
		CString sql;
		sql.Format("select distinct %s from tb_bookinfo",field);
		m_pRs->raw_Close();
		m_pRs = m_pCon->Execute((_bstr_t)sql,NULL,adCmdText);
		m_value.ResetContent(); // delete all items
		while (!m_pRs->adoEOF)
		{
			m_value.AddString((_bstr_t)m_pRs->GetCollect((long)0).bstrVal);	
			m_pRs->MoveNext();
		}
	}	
}

void CDlgBookAdjustPrice2::OnQuery() 
{
	Query();	
}


void CDlgBookAdjustPrice2::OnClickDetaillist(NMHDR* pNMHDR, LRESULT* pResult) 
{
	int row = m_list.GetSelectionMark();
	if (row != -1)//row is selected in m_list
	{
		m_barcode.SetWindowText(m_list.GetItemText(row,0));
	}
	else
		m_barcode.SetWindowText("");	
	*pResult = 0;
}