// DlgStock.cpp : implementation file
//

#include "stdafx.h"
#include "Project.h"
#include "DlgStock.h"
#include "DlgLogin.h"

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

CString GetTime();
/////////////////////////////////////////////////////////////////////////////
// CDlgStock dialog
static int i = 0;

CDlgStock::CDlgStock(CWnd* pParent /*=NULL*/)
	: CDialog(CDlgStock::IDD, pParent)
{
	bIfAdd = FALSE;
	//{{AFX_DATA_INIT(CDlgStock)
	m_Manufacturer =_T("");
	m_StockAmount  =0;
	m_StockPrice   =0.0 ;	
	//}}AFX_DATA_INIT
}


void CDlgStock::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDlgStock)
	DDX_Control(pDX, IDC_Stock_BtnAdd, m_BtnAdd);
	DDX_Control(pDX, IDC_STOCKLIST,    m_StockList);
	DDX_Text(pDX, IDC_GoodsID,     m_GoodsID);
	DDX_Text(pDX, IDC_GoodsName,   m_GoodsName);
	DDX_Text(pDX, IDC_StockAmount, m_StockAmount);
	DDX_Text(pDX, IDC_StockPrice,  m_StockPrice);
	DDX_Text(pDX, IDC_Manufacturer, m_Manufacturer);
	DDV_MaxChars(pDX, m_Manufacturer, 20);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDlgStock, CDialog)
	//{{AFX_MSG_MAP(CDlgStock)
	ON_BN_CLICKED(IDC_Stock_BtnAdd,    OnStockBtnAdd)
	ON_BN_CLICKED(IDC_Stock_BtnDelete, OnStockBtnDelete)
	ON_BN_CLICKED(IDC_OK, OnOk)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDlgStock message handlers
BOOL CDlgStock::OnInitDialog() 
{
	CDialog::OnInitDialog();
	i = 0;
	
	//初始化列表框
	m_StockList.SetTextColor(RGB (0, 0, 0));
	m_StockList.SetBkColor(RGB(255,255,255));
	m_StockList.SetExtendedStyle(LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT);	

	m_StockList.InsertColumn(0,_T("貨品ID"),   LVCFMT_CENTER,50);
	m_StockList.InsertColumn(1,_T("貨品名"),   LVCFMT_CENTER,70);
	m_StockList.InsertColumn(2,_T("生產(chǎn)商"),   LVCFMT_CENTER,100);
	m_StockList.InsertColumn(3,_T("進貨量"),   LVCFMT_CENTER,55);
	m_StockList.InsertColumn(4,_T("進價"),     LVCFMT_CENTER,60);
	m_StockList.InsertColumn(5,_T("進貨日期"), LVCFMT_CENTER,140);

	return TRUE;  
}

void CDlgStock::OnStockBtnAdd()         //添加按鈕響應
{	
	this->UpdateData(true);
	if(m_GoodsID!="")				    //必須有貨號
	{
		if(m_GoodsName != "")			//必須有貨名
		{
			if(m_StockPrice>0)			//必須有進價
			{
				CString  sDateTime;
				sDateTime= GetTime();                   //獲取當前時間

				Stock goods;
				goods.sGoodID       = m_GoodsID;
				goods.sGoodName     = m_GoodsName;
				goods.sManufacturer = m_Manufacturer;
				goods.iAmounts      = m_StockAmount;
				goods.fPrice        = m_StockPrice;
				goods.sStockTime    = sDateTime;		
				stocks.push_back(goods);               //加入進貨數(shù)組
				int k= stocks.size();
				
				CString sAmounts,sPrice,sDate;					
				sAmounts.Format("%i",m_StockAmount);
				sPrice.Format("%f",  m_StockPrice);
				
				m_StockList.InsertItem(i, m_GoodsID);    //列表顯示
				m_StockList.SetItemText(i,1,m_GoodsName);
				m_StockList.SetItemText(i,2,m_Manufacturer);
				m_StockList.SetItemText(i,3,sAmounts);
				m_StockList.SetItemText(i,4,sPrice);
				m_StockList.SetItemText(i,5,sDateTime);
				i++;
			}
			else   AfxMessageBox("缺進價");
		}
		else  AfxMessageBox("缺貨名");
	}
	else  AfxMessageBox("缺貨號");
	m_GoodsID = m_GoodsName = m_Manufacturer = "";   //清空控件
	m_StockAmount = m_StockPrice = 0;
	this->UpdateData(false);
}


void CDlgStock::OnOk() 
{
	CDlgLogin dlgLogin;
	try
	{   //連接數(shù)據(jù)源
		_bstr_t Conn = "DSN="+_bstr_t(dlgLogin.m_LoginDSN)+";";   
		pConn.CreateInstance(__uuidof(Connection));
		HRESULT hr=pConn->Open(Conn,_bstr_t(""),_bstr_t(""),adModeUnknown);  //
	}
	catch(_com_error& ex)
	{
		AfxMessageBox(ex.Description());
	}	

	if(stocks.size()!=0)
	{
		for(int j=0; j<stocks.size(); j++)
		{
			CString sql;
			sql.Format("insert into TableStock values(\'%s\',\'%s\',\'%s\',\'%f\',\'%i\',\'%s\')",
				stocks[j].sGoodID,	stocks[j].sGoodName,  stocks[j].sManufacturer,
				stocks[j].fPrice,	stocks[j].iAmounts,	  stocks[j].sStockTime  );
		    try
			{
				HRESULT hr = pConn->Execute(_bstr_t(sql),NULL, adCmdText);   //向TableStock插入新記錄
			}
			catch(_com_error& e)
			{	
				AfxMessageBox(e.Description());	
			}
		}
	}
	stocks.clear();    //向數(shù)據(jù)庫保存后清除數(shù)組
	pConn.Release();
}

void CDlgStock::OnCancel() 
{
	CDialog::OnCancel();
}


void CDlgStock::OnStockBtnDelete() 
{
	int j = m_StockList.GetSelectionMark();
	if(j >= 0)
		stocks.erase(stocks.begin()+j);      //從stock數(shù)組中刪除被取消的項
	m_StockList.DeleteItem(j);
	i--;
}