// CheckPrint.cpp : implementation file
//

#include "stdafx.h"
#include "aaa.h"
#include "CheckPrint.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
extern _ConnectionPtr m_pCon;  
extern _RecordsetPtr m_pRs; 
extern CAaaApp theApp;
/////////////////////////////////////////////////////////////////////////////
// CCheckPrint dialog


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


void CCheckPrint::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CCheckPrint)
	DDX_Control(pDX, IDC_QUERY, m_query);
	DDX_Control(pDX, IDC_PRINT, m_print);
	DDX_Control(pDX, IDC_LIST1, list);
	DDX_Control(pDX, IDC_COMBO1, fields);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CCheckPrint, CDialog)
	//{{AFX_MSG_MAP(CCheckPrint)
	ON_BN_CLICKED(IDC_QUERY, OnQuery)
	ON_BN_CLICKED(IDC_PRINT, OnPrint)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CCheckPrint message handlers

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

void CCheckPrint::OnCancel() 
{
	// TODO: Add extra cleanup here
	
	//CDialog::OnCancel();
}

void CCheckPrint::AddStorage()
{
	fields.ResetContent();
	m_pRs->raw_Close();
	CString sql;
	sql.Format("select storagename from tb_storageinfo");
	m_pRs->Open((_variant_t)sql,m_pCon.GetInterfacePtr(),adOpenKeyset,adLockOptimistic,adCmdText);
	while (! m_pRs->adoEOF)
	{
		fields.AddString((TCHAR*)(_bstr_t)m_pRs->GetFields()->GetItem((long)0)->Value);
		m_pRs->MoveNext();
	}
}

BOOL CCheckPrint::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	//添加倉庫信息
	AddStorage();
	//設置列表風格
	list.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_HEADERDRAGDROP|LVS_EX_GRIDLINES|LVS_EX_ONECLICKACTIVATE|LVS_EX_FLATSB);
	list.InsertColumn(0,"倉庫名稱");
	list.InsertColumn(1,"商品編號");
	list.InsertColumn(2,"商品名稱");
	list.InsertColumn(3,"庫存數量");

	list.SetColumnWidth(0,120);
	list.SetColumnWidth(1,200);
	list.SetColumnWidth(2,80);
	list.SetColumnWidth(3,100);
	return TRUE;  // return TRUE unless you set the focus to a control
}
//查詢倉庫商品信息
void CCheckPrint::OnQuery() 
{
	CString c_field;
	fields.GetWindowText(c_field);
	if (!c_field.IsEmpty())
	{
		CString sql,temp;
		sql.Format("select a.merchandiseID,a.storagename,a.Storagenum,b.name from tb_merchandisestorage a inner join tb_merchandiseinfo b on a.merchandiseID = b.id and a.storagename = '%s' ",c_field);
		m_pRs->raw_Close();
		m_pRs->Open((_variant_t)sql,m_pCon.GetInterfacePtr(),adOpenKeyset,adLockOptimistic,adCmdText);
		int row = 0;
		list.DeleteAllItems();
		if (m_pRs->RecordCount>0)
		{
			while (! m_pRs->adoEOF)
			{
				list.InsertItem(row,"");
				temp = (TCHAR *)(_bstr_t)m_pRs->GetFields()->GetItem("storagename")->Value;
				list.SetItemText(row,0,temp);
				temp = (TCHAR *)(_bstr_t)m_pRs->GetFields()->GetItem("merchandiseID")->Value;
				list.SetItemText(row,1,temp);
				temp = (TCHAR *)(_bstr_t)m_pRs->GetFields()->GetItem("name")->Value;
				list.SetItemText(row,2,temp);
				temp = (TCHAR *)(_bstr_t)m_pRs->GetFields()->GetItem("Storagenum")->Value;
				list.SetItemText(row,3,temp);
				row +=1;
				m_pRs->MoveNext();
			}
		}
		else
		{
			list.DeleteAllItems();
			MessageBox("沒有找到符合條件的數據.","提示",64);
		}
	}
	else
	{
		MessageBox("請設置查詢條件","提示",64);
	}
}

void CCheckPrint::OnPrint() 
{
	CPreParent preparent;
	preparent.pstruct.title = "倉庫盤點報表";
	preparent.pstruct.list = &list;
	preparent.DoModal();
}