// AddKinds.cpp : implementation file
//

#include "stdafx.h"
#include "Equipment.h"
#include "AddKinds.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
extern CEquipmentApp theApp;
/////////////////////////////////////////////////////////////////////////////
// CAddKinds dialog


CAddKinds::CAddKinds(CWnd* pParent /*=NULL*/)
	: CDialog(CAddKinds::IDD, pParent)
{
	m_hIcon = AfxGetApp()->LoadIcon(IDR_MAINTITLE);
	//{{AFX_DATA_INIT(CAddKinds)
	//}}AFX_DATA_INIT
	font.CreateFont(0,0,0,0,FW_BLACK,0,0,0,OEM_CHARSET,OUT_DEVICE_PRECIS,CLIP_DEFAULT_PRECIS,PROOF_QUALITY,DEFAULT_PITCH,"黑體");
}


void CAddKinds::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAddKinds)
	DDX_Control(pDX, IDC_EDIT1, kind);
	DDX_Control(pDX, IDC_LIST, list);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CAddKinds, CDialog)
	//{{AFX_MSG_MAP(CAddKinds)
	ON_NOTIFY(NM_CLICK, IDC_LIST, OnClickList)
	ON_COMMAND(ID_BUTTONADD, OnButtonadd)
	ON_COMMAND(ID_BUTTONCLOSE, OnButtonclose)
	ON_COMMAND(ID_BUTTONUPDATE, OnButtonupdate)
	ON_COMMAND(ID_BUTTONDELETE, OnButtondelete)
	ON_COMMAND(ID_BUTTONREFRESH, OnButtonrefresh)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CAddKinds message handlers

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

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

BOOL CAddKinds::OnInitDialog() 
{
	CDialog::OnInitDialog();
	SetIcon(m_hIcon,true);
	//設置列表風格
	list.SetExtendedStyle(LVS_REPORT|LVS_EX_FULLROWSELECT|LVS_OWNERDRAWFIXED |LVS_EX_FLATSB|LVS_SHOWSELALWAYS|LVS_EX_HEADERDRAGDROP);
	list.InsertColumn(1,"資產增加方式");//向列表中添加列
	list.SetColumnWidth(0,350);//設置列寬度
/************************創建工具欄******************************/
	toolbar.Create(TBSTYLE_FLAT|CCS_TOP|WS_CHILD|WS_VISIBLE|WS_BORDER|CCS_ADJUSTABLE|TBSTYLE_WRAPABLE,CRect(0,0,0,0),this,IDR_TOOLBAR2);
	toolbar.SetBitmapSize(CSize(32,32));
	imagelist.Create(32,32,ILC_COLOR32|ILC_MASK,0,0);
	for (int n =0;n<5;n++)
	{
		imagelist.Add(theApp.LoadIcon(n+IDI_ICON1));
	}
	
	toolbar.SetImageList(&imagelist);
	TBBUTTON  buttons[6];
	for (int i =0; i<6;i++)
	{
			CString str;
			int strlength;
			CCHAR *temp;
			str.LoadString(ID_BUTTONADD+i-1);//第一個按鈕為分隔條
			strlength = str.GetLength()+1;
			temp = str.GetBufferSetLength(strlength);
			temp[strlength]= '\0';
			temp[strlength-1]= '\0';
		if (i<1)
			buttons[i].fsStyle =TBSTYLE_SEP;
		else
		{
			buttons[i].fsStyle =TBSTYLE_BUTTON;
		}
		buttons[i].fsState =TBSTATE_ENABLED;
		buttons[i].dwData =0;
		buttons[i].idCommand = ID_BUTTONADD+i-1;		
		buttons[i].iString = toolbar.AddStrings(temp);
		buttons[i].iBitmap = i-1;
		str.ReleaseBuffer();
	}
	toolbar.AutoSize();
	toolbar.AddButtons(6,buttons);
	toolbar.ShowWindow(SW_SHOW);
/************************創建工具欄******************************/
	OnButtonrefresh() ;
	CStatic * static1;
	static1 = (CStatic *)this->GetDlgItem(IDC_STATIC);
	static1->SetFont(&font,true);





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


BOOL CAddKinds::PreTranslateMessage(MSG* pMsg) 
{
	if (pMsg->message ==WM_KEYDOWN)
		if (pMsg->wParam ==13)
			pMsg->wParam = 9;
	return CDialog::PreTranslateMessage(pMsg);
}



bool CAddKinds::IsRepeated(CString str)
{
	CString sql;
	sql.Format("select * from tb_addkinds where addkinds = '%s'",str);
	theApp.datamanage->Record1->raw_Close();	
	theApp.datamanage->Record1->Open((_bstr_t)sql,theApp.datamanage->GetConn().GetInterfacePtr(),adOpenKeyset,adLockOptimistic,adCmdText);
	if(theApp.datamanage->Record1->RecordCount>0)
		return true;
	return false;
}


void CAddKinds::OnClickList(NMHDR* pNMHDR, LRESULT* pResult) 
{
	int currentrow = list.GetSelectionMark();//得到當前行
	if (currentrow!=-1)
	{
		kind.SetWindowText(list.GetItemText(currentrow,0));
	}
	else
		kind.SetWindowText("");
	*pResult = 0;
}

void CAddKinds::OnButtonadd() 
{
	CString str;
	kind.GetWindowText(str);
	if (!str.IsEmpty())
	{
		if (!IsRepeated(str))
		{
			try
			{
				CString sql;
				sql.Format("insert into tb_addkinds values ('%s')",str);
				theApp.datamanage->ExecSQL(sql);
				this->MessageBox("操作成功.","提示",64);
				kind.SetWindowText("");
				kind.SetFocus();
			}
			catch(...)
			{
				this->MessageBox("操作失敗.","提示",64);
				kind.SetFocus();
				kind.SetSel(0);
			}
			OnButtonrefresh() ;
		}
		else
			MessageBox("該類別已存在.","提示",64);
	}
	else
		AfxMessageBox("基礎信息不能為空.",0,0);	
}

void CAddKinds::OnButtonclose() 
{
	EndDialog(0);	
}

void CAddKinds::OnButtonupdate() 
{
	if (theApp.datamanage->GetRecordset()->RecordCount >0)
	{
		if(MessageBox("確實要修改當前數據嗎?","提示",MB_YESNO)==IDYES )
		{
			CString str;
			kind.GetWindowText(str);			
			if (str.IsEmpty()) //判斷能力基礎信息是否為空
			{
				MessageBox("基礎信息不能為空","提示",64);
			}
			else if (!IsRepeated(str))
			{
				int currentrow = list.GetSelectionMark();//得到當前行
				if (currentrow!=-1)
				{
					try
					{
						CString sql,olddata;
						olddata = list.GetItemText(currentrow,0);		
						sql.Format("update tb_addkinds set addkinds = '%s' where addkinds = '%s'",str,olddata);
						theApp.datamanage->ExecSQL(sql);
						this->MessageBox("操作成功.","提示",64);
						kind.SetWindowText("");
						kind.SetFocus();					
					}
					catch(...)
					{
						MessageBox("操作失敗.","提示",64);				
					}
					OnButtonrefresh() ;
				}
				else
				{
					MessageBox("當前沒有可修改的數據.","提示",64);	
				}
			}
			else
				MessageBox("該類別已經存在.","提示",64);
		}
	}
	else
		MessageBox("當前沒有可修改的數據.","提示",64);	
}

void CAddKinds::OnButtondelete() 
{
	if(MessageBox("確實要刪除當前記錄嗎?","提示",MB_YESNO)==IDYES)
		if (theApp.datamanage->GetRecordset()->RecordCount>0)
		{
			int currentrow = list.GetSelectionMark();//得到當前行
			if (currentrow!=-1)
			{
				CString sql,olddata;
				olddata = list.GetItemText(currentrow,0);
				sql.Format("delete tb_addkinds where addkinds = '%s'",olddata);
				try
				{
					theApp.datamanage->ExecSQL(sql);
					MessageBox("操作成功.","提示",64);
				}
				catch(...)
				{
					MessageBox("操作失敗.","提示",64);			
				}
				OnButtonrefresh() ;
			}
			else
			{
				MessageBox("請在表格中選擇欲刪除的數據.","提示",64);
			}
		}			
		else
			MessageBox("當前沒有可刪除的記錄.","提示");	
}

void CAddKinds::OnButtonrefresh() 
{
	kind.SetWindowText("");
	list.DeleteAllItems();
	theApp.datamanage->GetRecordset()->raw_Close();
	theApp.datamanage->GetRecordset()->Open("select addkinds as 資產增加方式 from tb_addkinds",theApp.datamanage->GetConn().GetInterfacePtr(),adOpenKeyset,adLockPessimistic,adCmdText);
	if (theApp.datamanage->GetRecordset()->RecordCount >0)
	{
		while (! theApp.datamanage->GetRecordset()->ADOEOF)
		{
			CString str;
			_variant_t temp;
			temp =theApp.datamanage->GetRecordset()->GetCollect("資產增加方式");
			str = temp.bstrVal;
			list.InsertItem(0,str,0);
			theApp.datamanage->GetRecordset()->MoveNext();
		}
	}	
}