// ResysDlg.cpp : implementation file
//

#include "stdafx.h"
#include "pro.h"
#include "ResysDlg.h"
#include "MRecSet.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CResysDlg dialog


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


void CResysDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CResysDlg)
	DDX_Control(pDX, IDC_LIST1, m_ListCtrl);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CResysDlg, CDialog)
	//{{AFX_MSG_MAP(CResysDlg)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CResysDlg message handlers

BOOL CResysDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	

	m_ListCtrl.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);

	LV_COLUMN lvc;
	
	lvc.mask = LVCF_TEXT | LVCF_SUBITEM | LVCF_WIDTH /*| LVCF_FMT*/;
	
	lvc.iSubItem = 0;
	lvc.pszText = (char *)"序號";
	lvc.cx = 50;
	m_ListCtrl.InsertColumn(0,&lvc);
	
	lvc.iSubItem = 1;
	lvc.pszText = (char *)"刪除時間";
	lvc.cx = 130;
	m_ListCtrl.InsertColumn(1,&lvc);

	lvc.iSubItem = 2;
	lvc.pszText = (char *)"車型";
	lvc.cx = 80;
	m_ListCtrl.InsertColumn(2,&lvc);

	
	lvc.iSubItem = 3;
	lvc.pszText = (char *)"發動機號";
	lvc.cx =70;
	m_ListCtrl.InsertColumn(3,&lvc);

	
	lvc.iSubItem = 4;
	lvc.pszText = (char *)"出售日期";
	lvc.cx = 130;
	m_ListCtrl.InsertColumn(4,&lvc);
	

	lvc.iSubItem = 5;
	lvc.pszText = (char *)"價格";
	lvc.cx = 70;
	m_ListCtrl.InsertColumn(5,&lvc);


	lvc.iSubItem = 6;
	lvc.pszText = (char *)"配送";
	lvc.cx = 70;
	m_ListCtrl.InsertColumn(6,&lvc);


	lvc.iSubItem = 7;
	lvc.pszText = (char *)"稅費";
	lvc.cx = 70;
	m_ListCtrl.InsertColumn(7,&lvc);

	


	lvc.iSubItem = 8;
	lvc.pszText = (char *)"x";
	lvc.cx = 70;
	m_ListCtrl.InsertColumn(8,&lvc);

		lvc.iSubItem = 9;
	lvc.pszText = (char *)"入庫時間";
	lvc.cx = 90;
	m_ListCtrl.InsertColumn(9,&lvc);


	lvc.iSubItem = 10;
	lvc.pszText = (char *)"備注";
	lvc.cx = 190;
	m_ListCtrl.InsertColumn(10,&lvc);

	

	///////////////////////////////////////////////////////////////
	
	UpdateData(FALSE);
	r_db.Open ();
	show();
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

int CResysDlg::show()
{
	m_ListCtrl.DeleteAllItems ();
	int i=0;
	if(!r_db.IsOpen ())r_db.Open ();
if(!r_db.IsBOF() )r_db.MoveFirst ();
	while(!r_db.IsEOF() )
	{
		CString s;
		s.Format ("%d",i+1 );
		m_ListCtrl.InsertItem (i,s,0);
		m_ListCtrl.SetItemData (i,(DWORD)r_db.m_oid  );
		m_ListCtrl.SetItemText (i,0,s );

		s.Format ("%02d-%02d-%02d %02d:%02d:%02d:",r_db.m_deltime.GetYear (),r_db.m_deltime .GetMonth (),r_db.m_deltime.GetDay () ,r_db.m_deltime .GetHour (),r_db.m_deltime .GetMinute  (),r_db.m_deltime .GetSecond  ());
		m_ListCtrl.SetItemText(i,1,s);

		s.Format ("%s",r_db.m_cx );
		m_ListCtrl.SetItemText(i,2,s);

		s.Format ("%s",r_db.m_monn );
		m_ListCtrl.SetItemText(i,3,s);

		if(r_db.m_salled==0)s="//";
		else s.Format ("%02d-%02d-%02d",r_db.m_selltime.GetYear (),r_db.m_selltime .GetMonth (),r_db.m_selltime.GetDay () );
		m_ListCtrl.SetItemText(i,4,s);

		if(r_db.m_salled==0)s="//";
		else s.Format ("%0.2f",r_db.m_ovalue );
//		aout+=m_db.m_column4;
		m_ListCtrl.SetItemText(i,5,s);
		
		if(r_db.m_salled==0)s="//";
		else s.Format ("%0.2f",r_db.m_cprent );
//		apre+=m_db.m_column5;
		m_ListCtrl.SetItemText(i,6,s);
		if(r_db.m_salled==0)s="//";
		else s.Format ("%0.2f",r_db.m_csui);
//		asui+=m_db.m_column6;
		m_ListCtrl.SetItemText(i,7,s);

		
		if(r_db.m_salled==1)
		{
			
		double	curli=0;
		curli=r_db.m_ovalue -(r_db.m_invalue +r_db.m_cprent  +r_db.m_csui);
			s.Format ("%0.2f",curli);
		}
		else 
		{
		
			s="//";
		}
		
		m_ListCtrl.SetItemText(i,8,s);


		CTime ctime=r_db.m_intime ;
		s.Format ("%d-%02d-%02d",ctime.GetYear (),ctime.GetMonth (),ctime.GetDay ());
		m_ListCtrl.SetItemText (i,9,s);


		if(r_db.m_ps .GetLength ())m_ListCtrl.SetItemText (i,10,r_db.m_ps );
		
		i++;
		r_db.MoveNext ();
	}

	return i;
}

void CResysDlg::OnButton1() 
{
	// TODO: Add your control notification handler code here
	r_db.Requery();
	if(!r_db.IsBOF ())r_db.MoveFirst();
	while(!r_db.IsEOF ())
	{
		r_db.Delete ();
		r_db.MoveNext ();
	}
	m_ListCtrl.DeleteAllItems ();
	r_db.Requery();

}

void CResysDlg::OnButton2() 
{
	// TODO: Add your control notification handler code here
	POSITION pos=m_ListCtrl.GetFirstSelectedItemPosition();
	if(pos==NULL)
	{
		MessageBox("沒有記錄被選擇.");
	}
	else
	{
		int idx;
		long id;
		int dc=0;
		while(pos)
		{
			idx=m_ListCtrl.GetNextSelectedItem (pos);
			id=m_ListCtrl.GetItemData (idx);
			if(!r_db.IsBOF ())r_db.MoveFirst();
			do
			{
				if(r_db.m_oid!=id)
					r_db.MoveNext ();
				else
				{


					MRecSet m_db;
			m_db.Open ();
			if(!m_db.IsBOF ())m_db.MoveFirst();
			while(!m_db.IsEOF())
			{
				if(m_db.m_column2 ==r_db.m_monn)
				{
					CString msg;
					msg.Format ("%s 已登記在庫中，恢復中斷!",r_db.m_monn);
					MessageBox(msg);
					m_db.Close ();
					r_db.Requery();
					show();
					return;
				}
				m_db.MoveNext();
			}
			m_db.AddNew ();
			m_db.m_column1 =r_db.m_cx ;
			m_db.m_column2 =r_db.m_monn ;
			m_db.m_column3 =r_db.m_selltime  ;
			m_db.m_column4=r_db.m_ovalue  ;
			m_db.m_column5=r_db.m_cprent  ;
			m_db.m_column6=r_db.m_csui  ;
			m_db.m_column7=r_db.m_intime  ;
			m_db.m_column8=r_db.m_ps ;
			m_db.m_salled =r_db.m_salled ;
			m_db.m_invalm =r_db.m_invalue ;
			SYSTEMTIME stime;
			GetLocalTime(&stime);
			m_db.m_edittime =stime;
			m_db.Update ();
			m_db.Close ();


					r_db.Delete ();
					dc++;
					r_db.Requery();
					break;
				}
				
			}while(!r_db.IsEOF ());
			
			
		}
		r_db.Requery();
		//m_ListCtrl.DeleteAllItems();
		this->show ();
		
		
		
	}
	
}