}
	 }
	  
	 catch(CDaoException* e)
	 {
		 e->ReportError();
		 delete e;
		 return;
	 }

	}*/
	//else return;
	/*if(str==str1)
	{
		try
		{
			m_pDB->Open(dlgFile.GetFileName());
		}
		catch(CDaoException* e)
		{
			AfxMessageBox(e->m_pErrorInfo->m_strDescription);
			e->Delete;
		}
		if(m_pDB->IsOpen())
		{
			CString str;
			str.Format("",dlgFile.GetFileName().GetBuffer());
			SetWindowTextA(str.GetBuffer());

		}*/
	//}


//CListCtrl &lc =GetListCtrl();
	




	*pResult = 0;
}

CString CDlg4::strVARIANT(const COleVariant& var)
{
    CString str;
	switch(var.vt)
	{
	case VT_BSTR:
		str =(LPCSTR)var.bstrVal;
		break;
	case VT_I2:
		str.Format("%d",(int)var.iVal);
		break;
	case VT_I4:
		str.Format("%d",(int)var.lVal);
		break;
	case VT_R4:
		str.Format("%.4f",var.fltVal);
		break;
	case VT_R8:
		str.Format("%.4f",(double)var.dblVal);
		break;
   
	case VT_BOOL:
		str=(var.boolVal==0)?"FALSE":"TRUE";
		break;

	case VT_DATE:
		str =COleDateTime(var).Format();
		break;
	case VT_CY:
		str =COleCurrency(var).Format();
		break;
	case VT_NULL:
		str ="---";
		break;


	}
	return str;
}

void CDlg4::OnNMDblclkTree1(NMHDR *pNMHDR, LRESULT *pResult)
{
	// TODO: 在此添加控件通知處理程序代碼
	//
	//if(dlgFile.DoModal()!=IDOK)return;
	/*if(m_pDB.IsOpen())
	{
		m_pDB.Close
	}*/
	//
	m_ctrlList.DeleteAllItems();
//	m_ctrlList.

	

if(strtree==_T("臥式車床"))
{
	//m_ctrlList.GetHeaderCtrl();
int Column;
	LV_COLUMN lvColumn;
	lvColumn.mask = LVCF_FMT | LVCF_WIDTH | LVCF_TEXT | LVCF_SUBITEM;

	for(Column =0;Column<6;Column++)
	{
		CString HerderString;

		lvColumn.iSubItem =Column;
		lvColumn.pszText =(LPTSTR)(LPCTSTR)(m_Columns[Column]);
        lvColumn.cx =120;
		lvColumn.fmt=LVCF_FMT;
		m_ctrlList.InsertColumn(Column,&lvColumn);
	}

	try
	{
		int index =0;
		CString sql = _T("select * from 機床表");
		m_pUserSet->Open((_variant_t)sql,theApp.m_pConnection.GetInterfacePtr(),
			adOpenDynamic,adLockOptimistic,
			adCmdText);
		while(!m_pUserSet->adoEOF)
		{
			m_pFieldsPtr =m_pUserSet->Fields;
			m_pFieldPtr =m_pFieldsPtr->Item[_T("機床名稱")];
			CString str=_T("");
			if(m_pFieldPtr->Value.vt==VT_NULL)str=_T("");
			else str.Format((char *)_bstr_t(m_pFieldPtr->Value));

				int itemIndex =m_ctrlList.InsertItem(LVIF_TEXT|LVIF_PARAM,index,str,0,0,0,0);

			int SubitemIndex;
			for(SubitemIndex=1;SubitemIndex<6;SubitemIndex++)
			{
				m_pFieldPtr=m_pFieldsPtr->Item[_variant_t(m_Columns[SubitemIndex])];
				if(m_pFieldPtr->Value.vt==VT_NULL)str=_T("");
				else str.Format((char*)_bstr_t(m_pFieldPtr->Value));

				m_ctrlList.SetItem(itemIndex,SubitemIndex,LVIF_TEXT,str,0,0,0,0);

			}
			m_pUserSet->MoveNext();
			index++;
		}
		m_pUserSet->Close();
	}
	catch(_com_error* e)
	{
		AfxMessageBox(e->ErrorMessage());
	}
	catch(...)
  {
	  AfxMessageBox(_T("數據庫初始化錯誤，程序將關閉！"));
	  return;
  }
}
if(strtree==_T("外圓車刀"))
{
int Column2;
	LV_COLUMN lvColumn2;
	lvColumn2.mask = LVCF_FMT | LVCF_WIDTH | LVCF_TEXT | LVCF_SUBITEM;

	for(Column2 =0;Column2<2;Column2++)
	{
		CString HerderString;

		lvColumn2.iSubItem =Column2;
		lvColumn2.pszText =(LPTSTR)(LPCTSTR)(m_ColumnDao[Column2]);
        lvColumn2.cx =340;
		lvColumn2.fmt=LVCF_FMT;
		m_ctrlList.InsertColumn(Column2,&lvColumn2);
	}

try
	{
		int index =0;
		CString sql = _T("select * from 外圓車刀");
		m_pUserSet->Open((_variant_t)sql,theApp.m_pConnection.GetInterfacePtr(),
			adOpenDynamic,adLockOptimistic,
			adCmdText);
		while(!m_pUserSet->adoEOF)
		{
			m_pFieldsPtr =m_pUserSet->Fields;
			m_pFieldPtr =m_pFieldsPtr->Item[_T("外圓車刀名稱")];
			CString str=_T("");
			if(m_pFieldPtr->Value.vt==VT_NULL)str=_T("");
			else str.Format((char *)_bstr_t(m_pFieldPtr->Value));

				int itemIndex =m_ctrlList.InsertItem(LVIF_TEXT|LVIF_PARAM,index,str,0,0,0,0);

			int SubitemIndex;
			for(SubitemIndex=1;SubitemIndex<2;SubitemIndex++)
			{
				m_pFieldPtr=m_pFieldsPtr->Item[_variant_t(m_ColumnDao[SubitemIndex])];
				if(m_pFieldPtr->Value.vt==VT_NULL)str=_T("");
				else str.Format((char*)_bstr_t(m_pFieldPtr->Value));

				m_ctrlList.SetItem(itemIndex,SubitemIndex,LVIF_TEXT,str,0,0,0,0);

			}
			m_pUserSet->MoveNext();
			index++;
		}
		m_pUserSet->Close();
	}
	catch(_com_error* e)
	{
		AfxMessageBox(e->ErrorMessage());
	}
	catch(...)
  {
	  AfxMessageBox(_T("數據庫初始化錯誤，程序將關閉！"));
	  return;
  }



}

if(strtree==_T("車"))
{
int Column3;
	LV_COLUMN lvColumn3;
	lvColumn3.mask = LVCF_FMT | LVCF_WIDTH | LVCF_TEXT | LVCF_SUBITEM;

	for(Column3 =0;Column3<2;Column3++)
	{
		CString HerderString;

		lvColumn3.iSubItem =Column3;
		lvColumn3.pszText =(LPTSTR)(LPCTSTR)(m_Columnjiagong[Column3]);
        lvColumn3.cx =340;
		lvColumn3.fmt=LVCF_FMT;
		m_ctrlList.InsertColumn(Column3,&lvColumn3);
	}

try
	{
		int index =0;
		CString sql = _T("select * from 加工內容");
		m_pUserSet->Open((_variant_t)sql,theApp.m_pConnection.GetInterfacePtr(),
			adOpenDynamic,adLockOptimistic,
			adCmdText);
		while(!m_pUserSet->adoEOF)
		{
			m_pFieldsPtr =m_pUserSet->Fields;
			m_pFieldPtr =m_pFieldsPtr->Item[_T("加工內容")];
			CString str=_T("");
			if(m_pFieldPtr->Value.vt==VT_NULL)str=_T("");
			else str.Format((char *)_bstr_t(m_pFieldPtr->Value));

				int itemIndex =m_ctrlList.InsertItem(LVIF_TEXT|LVIF_PARAM,index,str,0,0,0,0);

			int SubitemIndex;
			for(SubitemIndex=1;SubitemIndex<2;SubitemIndex++)
			{
				m_pFieldPtr=m_pFieldsPtr->Item[_variant_t(m_Columnjiagong[SubitemIndex])];
				if(m_pFieldPtr->Value.vt==VT_NULL)str=_T("");
				else str.Format((char*)_bstr_t(m_pFieldPtr->Value));

				m_ctrlList.SetItem(itemIndex,SubitemIndex,LVIF_TEXT,str,0,0,0,0);

			}
			m_pUserSet->MoveNext();
			index++;
		}
		m_pUserSet->Close();
	}
	catch(_com_error* e)
	{
		AfxMessageBox(e->ErrorMessage());
	}
	catch(...)
  {
	  AfxMessageBox(_T("數據庫初始化錯誤，程序將關閉！"));
	  return;
  }



}

	
	*pResult = 0;
}

void CDlg4::OnLvnItemchangedList1(NMHDR *pNMHDR, LRESULT *pResult)
{
	LPNMLISTVIEW pNMLV = reinterpret_cast<LPNMLISTVIEW>(pNMHDR);
	// TODO: 在此添加控件通知處理程序代碼
	*pResult = 0;
}