📄 pcdmview.cpp
字号:
break;
// </BOOK_ADDON STEP8 Chapter 10.2.3> ***************************
// <BOOK_ADDON STEP7 Chapter 9.6.4> ***************************
case 36:
tDlg=new CWaitDlg(IDD_RECVWAIT,TEXT(""));
tDlg->DoModal();
tBstr=SysAllocString(tDlg->m_RecvString);
delete tDlg;
//MessageBox(tBstr,TEXT("Received")); // <BOOK Include to check Buffer
hr=comUtils.CreateInstance(__uuidof( PCDMUtils ) );
if (FAILED(hr))
{
MessageBox(TEXT("Could not access the PCDMUtils Class"));
break;
}
hr=comUtils->AnalyzeURL(tBstr);
if (hr==ERROR_DUP_NAME)
MessageBox(TEXT("Sorry but this CD is already in the Database"));
else
RefreshLVC();
break;
case 30:
{
if (m_LastRow==0) break;
_bstr_t bsSel(L"PCDMIrDA://PCDM/PCDMAccessDB?Command=1&Table=PCDMCDs&IDX=0&");
hr=comDB.CreateInstance(__uuidof( PCDMAccessDB ) );
if (FAILED(hr))
{
MessageBox(TEXT("Could not access the PCDMDll.DLL"));
break;
}
hr=comDB->OpenTable(TEXT("\\My Documents\\PCDM.cdb"),TEXT("PCDMCDs"),_variant_t((long)PCDM_PID_ID),&DBHandle);
if (FAILED(hr))
{
hr=comDB->OpenTable(TEXT(""),TEXT("PCDMCDs"),_variant_t((long)PCDM_PID_ID),&DBHandle);
if (FAILED(hr))
{
MessageBox(TEXT("Database could not be opened"));
break;
}
}
VariantInit(&value);
value.vt=VT_I4;
value.lVal=m_LastRow;
hr=comDB->MoveFirst(DBHandle);
hr=comDB->FindRecord(DBHandle,_variant_t((long)PCDM_PID_ID),value);
if (hr==S_OK)
{
hr=comDB->ReadRecord(DBHandle,&FieldCnt);
if (hr==S_OK)
{
for (int i=0;i<FieldCnt;i++)
{
VariantClear(&value);
hr=comDB->GetValue(_variant_t((long)(PCDM_PID_ID+i)),&value);
if (!FAILED(hr))
{
wsprintf(tStr,TEXT("Fld%d=%s"),i,value.bstrVal);
bsSel+=tStr;
if (i<FieldCnt-1)
bsSel+=TEXT("&");
}
}
}
comDB->CloseTable(DBHandle);
hr=comDB->OpenTable(TEXT("\\My Documents\\PCDM.cdb"),TEXT("PCDMTracks"),_variant_t((LONG)PCDM_PID_TRACKS_ID),&DBHandle);
if (hr==S_OK)
{
VariantInit(&tvalue);
while (hr==S_OK)
{
hr=comDB->ReadRecord(DBHandle,&FieldCnt);
if (hr==S_OK)
{
for (int i=0;i<FieldCnt;i++)
{
VariantClear(&value);
hr=comDB->GetValue(_variant_t((LONG)(PCDM_PID_TRACKS_ID+i)),&value);
if (i==PCDM_PID_TRACKS_ID)
{
VariantChangeType(&tvalue,&value,NULL,VT_I4);
if (tvalue.lVal!=m_LastRow)
break;
else
bsSel+=L";PCDMIrDA://PCDM/PCDMAccessDB?Command=1&Table=PCDMTracks&";
}
if (!FAILED(hr))
{
wsprintf(tStr,TEXT("Fld%d=%s"),i,value.bstrVal);
bsSel+=tStr;
if (i<FieldCnt-1)
bsSel+=TEXT("&");
}
}
}
hr=comDB->MoveNext(DBHandle);
}
comDB->CloseTable(DBHandle);
}
bsSel+=TEXT(";");
//MessageBox(bsSel); // <BOOK Include to check Buffer
tDlg=new CWaitDlg(IDD_SENDWAIT,bsSel);
tDlg->DoModal();
delete tDlg;
}
else
comDB->CloseTable(DBHandle);
}
break;
// </BOOK_ADDON STEP7 Chapter 9.6.4> ***************************
case IDCLOSE:
GetParentFrame()->DestroyWindow();
break;
default:
break;
}
//</BOOK_ADDON STEP5 Chapter 7.4.4> *********************************
}
void CPCDMView::OnInitialUpdate()
{
CFormView::OnInitialUpdate();
// Sizes the IDD_MAINFORM Dialog to the size of the Mainframe
CRect myRect;
GetParentFrame()->GetClientRect(&myRect);
SetWindowPos(NULL,myRect.left,myRect.top,
myRect.right,myRect.bottom,SWP_NOZORDER);
//<BOOK_ADDON STEP5 Chapter 7.4.4> *********************************
if (LOWORD(((CPCDMApp *)AfxGetApp())->m_CePlatform)==CEP_PALMPCV3)
m_cmdBar.SetWindowPos(NULL,myRect.top,myRect.left,
myRect.right,1,SWP_NOZORDER);
else
//</BOOK_ADDON STEP5 Chapter 7.4.4> *********************************
m_cmdBar.SetWindowPos(NULL,myRect.top,myRect.left,
myRect.right,25,SWP_NOZORDER);
// Creates our Command-Bar
//<BOOK_ADDON STEP3 Chapter 7.2.4> *********************************
m_cmdBar.SetCmdBarType(1);
m_cmdBar.CreateBar(1,0);
//</BOOK_ADDON STEP3 Chapter 7.2.4> *********************************
// Inserts Menus
m_cmdBar.InsertMenu(TEXT("File"),0);
m_cmdBar.InsertMenuItem(TEXT("Send to..") ,0,0,30);
m_cmdBar.InsertMenuItem(TEXT("Receive..") ,0,1,36);
m_cmdBar.InsertMenuItem(TEXT("Show Details"),0,2,31);
m_cmdBar.InsertMenuItem(TEXT("") ,0,3,0);
m_cmdBar.InsertMenuItem(TEXT("Help") ,0,4,34);
m_cmdBar.InsertMenuItem(TEXT("About") ,0,5,35);
m_cmdBar.InsertMenuItem(TEXT("") ,0,6,0);
m_cmdBar.InsertMenuItem(TEXT("Exit") ,0,7,IDCLOSE);
//<BOOK_ADDON STEP3 Chapter 7.2.4> *********************************
m_cmdBar.CreateBar(101,RBBS_FIXEDBMP);
// <BOOK_ADDON STEP4 Chapter 7.3.4/>
if (LOWORD(((CPCDMApp *)AfxGetApp())->m_CePlatform)!=CEP_PALMPCV3)
// </BOOK_ADDON STEP4 Chapter 7.3.4/>
m_cmdBar.InsertButton(SBM_SEP,TBSTATE_ENABLED, 0,0, TEXT(""));
//</BOOK_ADDON STEP3 Chapter 7.2.4> *********************************
// Inserts Toolbar Buttons
m_cmdBar.InsertButton(SBM_SEND,TBSTATE_ENABLED, 1,30,
TEXT("Send Entry to other Device"));
m_cmdBar.InsertButton(SBM_OPEN,TBSTATE_ENABLED, 2,31,
TEXT("Show Details"));
m_cmdBar.InsertButton(SBM_SEP,TBSTATE_ENABLED, 3,0,
TEXT(""));
m_cmdBar.InsertButton(SBM_FIND,TBSTATE_ENABLED, 4,32,
TEXT("Search for CD"));
m_cmdBar.InsertButton(SBM_SEP,TBSTATE_ENABLED, 5,0,
TEXT(""));
m_cmdBar.InsertButton(SBM_HELP,TBSTATE_ENABLED,6,34,
TEXT("Help"));
m_cmdBar.InsertButton(SBM_PROP,TBSTATE_ENABLED,7,35,
TEXT("About"));
// Inserts the Search Combo Box
m_cmdBar.InsertComboBox(100,4,1007);
m_cmdBar.AddStringToComboBox(1007,TEXT("Madonna"));
//</BOOK_ADDON STEP3 Chapter 7.2.4> *********************************
// Adds the Close Button
m_cmdBar.SetAdornments(0);
// </BOOK_ADDON Step2 Chapter 7.1.4> **********************************************
//<BOOK_ADDON STEP5 Chapter 7.4.4> *********************************
if (LOWORD(((CPCDMApp *)AfxGetApp())->m_CePlatform)==CEP_PALMPCV3)
m_LVC.SetWindowPos(NULL,5,0,myRect.right-10,
myRect.bottom-5,SWP_NOZORDER);
else
m_LVC.SetWindowPos(NULL,5,30,myRect.right-10,
myRect.bottom-35,SWP_NOZORDER);
// Column for Author (Half the screen )
m_LVC.AddColumn((myRect.right/2),TEXT("Artist/Author"));
// Column for Title (Half the screen)
m_LVC.AddColumn((myRect.right/2)-14,TEXT("Title"));
//</BOOK_ADDON STEP5 Chapter 7.4.4> *********************************
// <BOOK_ADDON Step6 Chapter 8.3.5> *********************************
RefreshLVC();
// </BOOK_ADDON Step6 Chapter 8.3.5> *********************************
}
//<BOOK_ADDON STEP5 Chapter 7.4.4> *********************************
void CPCDMView::OnRowSelected(long Row, long Column, long lParam)
{
CDetails *dlg;
int plat;
if (lParam==m_LastRow)
{
plat=LOWORD(((CPCDMApp *)AfxGetApp())->m_CePlatform);
if (plat>=CEP_PALMPC && plat<CEP_PALMPCEND)
dlg=new CDetails(IDD_CDDETAILSPALM, lParam);
else
dlg=new CDetails(IDD_CDDETAILS, lParam);
dlg->DoModal();
}
m_LastRow=lParam;
}
//</BOOK_ADDON STEP5 Chapter 7.4.4> *********************************
BOOL CPCDMView::RefreshLVC()
{
// <BOOK_ADDON Step6 Chapter 8.3.5> *********************************
IPCDMAccessDBPtr comDB;
long DBHandle;
VARIANT value,tvalue;
VariantInit(&value);
VariantInit(&tvalue);
HRESULT hr=comDB.CreateInstance( __uuidof( PCDMAccessDB ) );
if (FAILED(hr))
{
MessageBox(TEXT("Could not access the PCDMAccessDB Class"));
return FALSE;
}
hr=comDB->OpenTable(TEXT("\\My Documents\\PCDM.cdb"),TEXT("PCDMCDs"),_variant_t((LONG)PCDM_PID_ID),&DBHandle);
if (hr!=S_OK) // If Database does not exist create sample data
{
hr=comDB->AddProperty(_variant_t((LONG)PCDM_PID_ID),TRUE);
hr=comDB->AddProperty(_variant_t((LONG)PCDM_PID_AUTHOR),FALSE);
hr=comDB->AddProperty(_variant_t((LONG)PCDM_PID_TITLE),FALSE);
hr=comDB->AddProperty(_variant_t((LONG)PCDM_PID_LABEL),FALSE);
hr=comDB->AddProperty(_variant_t((LONG)PCDM_PID_RELEASE),FALSE);
hr=comDB->AddProperty(_variant_t((LONG)PCDM_PID_COPYRIGHT),FALSE);
hr=comDB->AddProperty(_variant_t((LONG)PCDM_PID_CRC),FALSE);
hr=comDB->CreateTable(TEXT("\\My Documents\\PCDM.cdb"),TEXT("PCDMCDs"));
hr=comDB->OpenTable(TEXT("\\My Documents\\PCDM.cdb"),TEXT("PCDMCDs"),_variant_t((LONG)PCDM_PID_ID),&DBHandle);
hr=comDB->AddNewRecord(DBHandle);
hr=comDB->SetValue(_variant_t((LONG)PCDM_PID_ID),_variant_t(TEXT("1")));
hr=comDB->SetValue(_variant_t((LONG)PCDM_PID_AUTHOR),_variant_t(TEXT("Madonna")));
hr=comDB->SetValue(_variant_t((LONG)PCDM_PID_TITLE),_variant_t(TEXT("Ray of Light")));
hr=comDB->SetValue(_variant_t((LONG)PCDM_PID_LABEL),_variant_t(TEXT("Tower Records")));
hr=comDB->SetValue(_variant_t((LONG)PCDM_PID_RELEASE),_variant_t(TEXT("8/8/96")));
hr=comDB->SetValue(_variant_t((LONG)PCDM_PID_COPYRIGHT),_variant_t(TEXT("(c) 1996")));
hr=comDB->SetValue(_variant_t((LONG)PCDM_PID_CRC),_variant_t(TEXT("0")));
hr=comDB->WriteRecord(DBHandle);
hr=comDB->AddNewRecord(DBHandle);
hr=comDB->SetValue(_variant_t((LONG)PCDM_PID_ID),_variant_t(TEXT("2")));
hr=comDB->SetValue(_variant_t((LONG)PCDM_PID_AUTHOR),_variant_t(TEXT("Queen")));
hr=comDB->SetValue(_variant_t((LONG)PCDM_PID_TITLE),_variant_t(TEXT("Innuendo")));
hr=comDB->SetValue(_variant_t((LONG)PCDM_PID_LABEL),_variant_t(TEXT("Queen Records")));
hr=comDB->SetValue(_variant_t((LONG)PCDM_PID_RELEASE),_variant_t(TEXT("3/2/92")));
hr=comDB->SetValue(_variant_t((LONG)PCDM_PID_COPYRIGHT),_variant_t(TEXT("(c) 1992")));
hr=comDB->SetValue(_variant_t((LONG)PCDM_PID_CRC),_variant_t(TEXT("0")));
hr=comDB->WriteRecord(DBHandle);
hr=comDB->MoveFirst(DBHandle);
} // Get rid of that code after testing your application⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -