// AddMaterial.cpp : implementation file
//

#include "stdafx.h"
#include "倉庫管理系統.h"
#include "AddMaterial.h"

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

extern CDatabase m_database;
extern CShow* showdlg;
/////////////////////////////////////////////////////////////////////////////
// CAddMaterial dialog


CAddMaterial::CAddMaterial(CWnd* pParent /*=NULL*/)
	: CDialog(CAddMaterial::IDD, pParent)
{
	isupdate=false;
	//{{AFX_DATA_INIT(CAddMaterial)
	m_name = _T("");
	m_num = 0;
	m_mark = _T("");
	//}}AFX_DATA_INIT
}


void CAddMaterial::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAddMaterial)
	DDX_Text(pDX, IDC_EDIT1, m_name);
	DDX_Text(pDX, IDC_EDIT2, m_num);
	DDX_Text(pDX, IDC_EDIT3, m_mark);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CAddMaterial, CDialog)
	//{{AFX_MSG_MAP(CAddMaterial)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CAddMaterial message handlers

void CAddMaterial::OnOK() 
{
	UpdateData(true);
	CString sql;
	char temp[15];
	if(isupdate){
		UpdateData(true);
		sql.Format("update 物資表 set 物資名稱='%s',數量='%d',備注='%s' where 物資號='%s'",m_name,m_num,m_mark,itemnum);
		try {
			m_database.ExecuteSQL(sql);//執行插入操作
			sql="select * from 物資表 order by 物資號";
			showdlg->OnRefreshData(sql);
		}catch (CDBException e) {
			MessageBox("更新失敗");
		}
		CDialog::OnOK();
	}else{
		int maxnum;
		
		sql.Format("select * from 物資表 order by 物資號");
		CMessSet m_record;
		m_record.m_pDatabase=&m_database;
		m_record.Open(AFX_DB_USE_DEFAULT_TYPE,sql);
		//獲取物次表的最大物資號，最動生成物資號
		if(m_record.IsEOF()){
			maxnum=0;
		}else{
			m_record.MoveLast();
			maxnum=m_record.m_column1;
			maxnum++;
		}
		//生成插入資料的SQL語句
		
		sql.Format("insert into 物資表 values('");
		itoa(maxnum,temp,10);
		sql=sql+temp+"','"+m_name+"','";
		itoa(m_num,temp,10);
		sql=sql+temp+"','"+m_mark+"')";
		try {
			m_database.ExecuteSQL(sql);//執行插入操作
			sql="select * from 物資表 order by 物資號";
			showdlg->OnRefreshData(sql);
		}catch (CDBException e) {
			MessageBox("插入失敗");
			return;
		}
	}
	
	
}

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