// InDlg.cpp : implementation file
//

#include "stdafx.h"
#include "pro.h"

#include "InDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CInDlg dialog


CInDlg::CInDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CInDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CInDlg)
//	m_intime = _T("");
	m_monn = _T("");
	m_tps = _T("");
	m_intimec = 0;
	//}}AFX_DATA_INIT
}


void CInDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CInDlg)
	DDX_Control(pDX, IDC_EDIT2, m_monnadd);
	DDX_Control(pDX, IDC_TMPLIST, m_ListCtrl);
	DDX_Control(pDX, IDC_CX, m_cx);
//	DDX_Text(pDX, IDC_INTIME, m_intime);
	DDX_Text(pDX, IDC_EDIT2, m_monn);
	DDX_Text(pDX, IDC_PS, m_tps);
	DDX_DateTimeCtrl(pDX, IDC_INTIMEC, m_intimec);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CInDlg, CDialog)
	//{{AFX_MSG_MAP(CInDlg)
	ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
	ON_BN_CLICKED(IDC_TOLIST, OnTolist)
	ON_BN_CLICKED(IDC_DELTMP, OnDeltmp)
	ON_BN_CLICKED(IDC_CLS, OnCls)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CInDlg message handlers

BOOL CInDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	m_db.Open ();
	// TODO: Add extra initialization here
	SYSTEMTIME ctime;
	GetLocalTime(&ctime);
//	m_intime.Format ("%d-%02d-%02d",ctime.wYear ,ctime.wMonth ,ctime.wDay );
	m_intimec=ctime;
	



	//	
	UpdateData(FALSE);
	
	
	int index=0;
	KRecSet k_db;
	k_db.Open ();
	
	if(!k_db.IsBOF ())k_db.MoveFirst();
	while(!k_db.IsEOF ())
	{
		
		
		m_cx.InsertString (index++,k_db.m_column1 );
		k_db.MoveNext();
		
	}
	m_cx.SetCurSel(0);



	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 = 100;
	m_ListCtrl.InsertColumn(1,&lvc);
	
	lvc.iSubItem = 2;
	lvc.pszText = (char *)"發動機號";
	lvc.cx =100;
	m_ListCtrl.InsertColumn(2,&lvc);
	lvc.iSubItem = 3;
	lvc.pszText = (char *)"入庫時間";
	lvc.cx =150;
	m_ListCtrl.InsertColumn(3,&lvc);

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


	t_db.Open ();

	/*bb.Open ();
	bb.AddNew ();
	bb.m_cx="dkfj";
	bb.m_monn="weoirwi";
	SYSTEMTIME st;
	GetLocalTime(&st);
	CTime tt=st;
	bb.m_ctime=tt;
	
	bb.Update ();
	bb.Requery();
	*/
	 
	
	OnCls();
	show();

	
	
	return TRUE;  // return TRUE unless you set the focus to a control
	// EXCEPTION: OCX Property Pages should return FALSE
}

void CInDlg::OnButton2() 
{
	// TODO: Add your control notification handler code here

	//UpdateData();
	t_db.Requery();
	if(!t_db.IsBOF ())t_db.MoveFirst();
	
	while(!t_db.IsEOF())
	{
		SYSTEMTIME stime;
		GetLocalTime(&stime);
		m_db.AddNew ();
		m_db.m_column1=t_db.m_cx;
		m_db.m_column2=t_db.m_monn;
		m_db.m_column4=0;
		m_db.m_column5=0;
		m_db.m_column6=0;
		m_db.m_column7=t_db.m_ctime ;
		m_db.m_edittime =stime;
		m_db.m_salled=0;
		m_db.m_invalm =t_db.m_invalt ;
		if(t_db.m_ps .GetLength ())m_db.m_column8=t_db.m_ps ;
		t_db.MoveNext ();
		m_db.Update ();
		m_db.Requery();
	}
	OnOK();
	
}


void CInDlg::OnTolist()
{
	// TODO: Add your control notification handler code here
//	MessageBox("LOVEZ3");
UpdateData();


	


	CString tcx;
	double tinval=0;
	CString tmonn;
	int idx=m_cx.GetCurSel();
	if(idx==CB_ERR)
	{

		MessageBox("車型不能為空.");
		m_monnadd.SetFocus ();
		return;
	}
	
	m_cx.GetLBText(idx,tcx);
	tmonn=m_monn;
	
	

	if(tcx.GetLength ()<1||tmonn.GetLength ()<1)
	{
		MessageBox("數據不完整不能加入.");
		m_monnadd.SetFocus ();
		return;
	}



	if(t_db.IsOpen ())
	{

		if(!t_db.IsBOF ())t_db.MoveFirst ();
			do
			{
				//if(strcmp(t_db.m_monn,m_monn)==0)
				
				if(t_db.m_monn==m_monn)
				{
					MessageBox("該發動機號已預登記.");
					m_monn="";
					UpdateData(FALSE);
					m_monnadd.SetFocus ();
					return;
				}
				if(!t_db.IsEOF ())t_db.MoveNext ();
			}while(!t_db.IsEOF() );

			MRecSet mdb;
			mdb.Open ();
			if(mdb.IsOpen ())
			{
				mdb.Requery();
				if(!mdb.IsBOF ())mdb.MoveFirst ();
				do
				{
					if(mdb.m_column2==m_monn)
					{
						MessageBox("該發動機號已登記.");
						m_monn="";
						UpdateData(FALSE);
						m_monnadd.SetFocus ();
						return;
					}
					if(!mdb.IsEOF ())mdb.MoveNext ();
				}while(!mdb.IsEOF() );
			}
			mdb.Close ();

			KRecSet kdb;
			kdb.Open ();
			if(kdb.IsOpen ())
			{
				kdb.Requery();
				if(!kdb.IsBOF ())kdb.MoveFirst ();
				while(!kdb.IsEOF() )
				{
					if(kdb.m_column1 ==tcx)
					{
						tinval=kdb.m_inval ;
						break;
						
					}
					if(!kdb.IsEOF ())kdb.MoveNext ();
				}
			}
			kdb.Close ();
//			delete mdb;
		
	t_db.AddNew ();
	

	t_db.m_cx =tcx;
	t_db.m_monn=tmonn;
	t_db.m_ctime=m_intimec;
	t_db.m_invalt =tinval;
	if(m_tps.GetLength ())t_db.m_ps =m_tps;
	t_db.Update ();
	
	
	t_db.Requery ();

	show();
	m_ListCtrl.EnsureVisible(m_ListCtrl.GetItemCount() -1,TRUE);//自己下拉
	m_monnadd.SetFocus ();
	m_monn="";
	m_tps ="";
	UpdateData(FALSE);
	}
	else  MessageBox("數據庫打開失敗");
	
}

int CInDlg::show()
{
	m_ListCtrl.DeleteAllItems();
	
	//t_db.Requery();
	int i=0;
	
	if(!t_db.IsBOF() )t_db.MoveFirst ();
	while(!t_db.IsEOF() )
	{
		CString s;
		s.Format ("%d",i+1 );
		m_ListCtrl.InsertItem (i,s,0);
		m_ListCtrl.SetItemData (i,(DWORD)t_db.m_ID );
		m_ListCtrl.SetItemText (i,0,s );
		s.Format ("%s",t_db.m_cx );
		m_ListCtrl.SetItemText(i,1,s);
		s.Format ("%s",t_db.m_monn );
		m_ListCtrl.SetItemText(i,2,s);
		s.Format ("%02d-%02d-%02d",t_db.m_ctime.GetYear (),t_db.m_ctime .GetMonth (),t_db.m_ctime.GetDay () );
		m_ListCtrl.SetItemText(i,3,s);

		if(t_db.m_ps .GetLength ())m_ListCtrl.SetItemText (i,4,t_db.m_ps );
		
		i++;
		t_db.MoveNext ();
	}
	
	
	return i;
	
}

void CInDlg::OnDeltmp() 
{
	// 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(!t_db.IsBOF ())t_db.MoveFirst();
			do
			{
				if(t_db.m_ID!=id)
					t_db.MoveNext ();
				else
				{
					t_db.Delete ();
					dc++;
					t_db.Requery();
					break;
				}
				
			}while(!t_db.IsEOF ());
			
			
		}
		t_db.Requery();
		this->show ();
		
		
		
	}
}

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