📄 adotestdlg.cpp
字号:
SaveData();///保存数据到记录集和列表框
m_userlist.SetItemState(m_nCurrentSel,LVIS_SELECTED|LVIS_FOCUSED,LVIS_SELECTED|LVIS_FOCUSED);
m_userlist.SetHotItem(m_nCurrentSel);
m_userlist.SetFocus();
}
}
else
AfxMessageBox("请输入学生的学号");
}
// TODO: Add your control notification handler code here
}
void CADOTESTDlg::OnDelitem()
{
CString did=m_userlist.GetItemText(m_nCurrentSel,0);
int i=MessageBox("确实要删除学生"+did+"的信息吗","警告!",1);
if(i==IDOK)
{
//m_bAutoSave = FALSE;
if(m_nCurrentSel >= 0)
{
m_userlist.DeleteItem(m_nCurrentSel);
m_pRecordset->MoveFirst();
while(!m_pRecordset->adoEOF)
{
vUserID = m_pRecordset->GetCollect("id");
if(did==(_bstr_t)vUserID)
{
m_pRecordset->Delete(adAffectCurrent);
break;
}
m_pRecordset->MoveNext();
}
int count = m_userlist.GetItemCount();
if(count <= m_nCurrentSel)
m_nCurrentSel = count-1;
if(count>0)
{
// LoadData();
m_userlist.SetItemState(m_nCurrentSel,LVIS_SELECTED|LVIS_FOCUSED,LVIS_SELECTED|LVIS_FOCUSED);
m_userlist.SetFocus();
}
if(count==0)
{
m_cdelitem.EnableWindow(false);
m_cchaitem.EnableWindow(false);
}
}
// m_bAutoSave = TRUE;
// TODO: Add your control notification handler code here
}
}
void CADOTESTDlg::OnItemchangedUserlist(NMHDR* pNMHDR, LRESULT* pResult)
{
NM_LISTVIEW* pNMListView = (NM_LISTVIEW*)pNMHDR;
if(pNMListView->uNewState&LVIS_SELECTED)
{
//UpdateData(true);
//SaveData();///保存旧数据
m_nCurrentSel = pNMListView->iItem;
// LoadData();///加载新数据
m_cdelitem.EnableWindow();
m_cchaitem.EnableWindow();
}
*pResult = 0;
}
void CADOTESTDlg::OnOK()
{
// TODO: Add extra validation here
CDialog::OnOK();
}
void CADOTESTDlg::OnFinditem()
{
// TODO: Add your control notification handler code here
m_pRecordset->MoveFirst();
CFind find;
int i=find.DoModal();
int fway=find.fway;
sid=find.fid;
sname=find.fname;
sage=find.fage;
sfrom=find.ffrom;
int nItem;
if(i==IDOK)
{
m_userlist.DeleteAllItems();
switch(fway)
{
case 0:
if(sid!=_T(""))
{
while(!m_pRecordset->adoEOF)
{
vUserID = m_pRecordset->GetCollect("id");
if(sid==(_bstr_t)vUserID)
{
vUserID = m_pRecordset->GetCollect("id");
vUsername = m_pRecordset->GetCollect("username");
vOld = m_pRecordset->GetCollect("old");
vSex = m_pRecordset->GetCollect("sex");
vFrom = m_pRecordset->GetCollect("from");
nItem=m_userlist.InsertItem(0xffff,(_bstr_t)vUserID);//先插第一个项
m_userlist.SetItem(nItem,1,1,(_bstr_t)vUsername,NULL,0,0,0);
m_userlist.SetItem(nItem,2,1,(_bstr_t)vOld,NULL,0,0,0);
m_userlist.SetItem(nItem,3,1,(_bstr_t)vSex,NULL,0,0,0);
m_userlist.SetItem(nItem,4,1,(_bstr_t)vFrom,NULL,0,0,0);
}
m_pRecordset->MoveNext();
}
if(m_userlist.GetItemCount()==0)
MessageBox("没有找到符合条件的学生！","提示！");
}
else
MessageBox("未输入任何信息！","提示！");
break;
case 1:
if(sname!=_T(""))
{
while(!m_pRecordset->adoEOF)
{
vUsername = m_pRecordset->GetCollect("username");
if(sname==(_bstr_t)vUsername)
{
vUserID = m_pRecordset->GetCollect("id");
vUsername = m_pRecordset->GetCollect("username");
vOld = m_pRecordset->GetCollect("old");
vSex = m_pRecordset->GetCollect("sex");
vFrom = m_pRecordset->GetCollect("from");
nItem=m_userlist.InsertItem(0xffff,(_bstr_t)vUserID);//先插第一个项
m_userlist.SetItem(nItem,1,1,(_bstr_t)vUsername,NULL,0,0,0);
m_userlist.SetItem(nItem,2,1,(_bstr_t)vOld,NULL,0,0,0);
m_userlist.SetItem(nItem,3,1,(_bstr_t)vSex,NULL,0,0,0);
m_userlist.SetItem(nItem,4,1,(_bstr_t)vFrom,NULL,0,0,0);
}
m_pRecordset->MoveNext();
}
if(m_userlist.GetItemCount()==0)
MessageBox("没有找到符合条件的学生！","提示！");
}
else
MessageBox("未输入任何信息！","提示！");
break;
case 2:
if(sage!=_T(""))
{
while(!m_pRecordset->adoEOF)
{
vOld = m_pRecordset->GetCollect("old");
if(sage==(_bstr_t)vOld)
{
vUserID = m_pRecordset->GetCollect("id");
vUsername = m_pRecordset->GetCollect("username");
vOld = m_pRecordset->GetCollect("old");
vSex = m_pRecordset->GetCollect("sex");
vFrom = m_pRecordset->GetCollect("from");
nItem=m_userlist.InsertItem(0xffff,(_bstr_t)vUserID);//先插第一个项
m_userlist.SetItem(nItem,1,1,(_bstr_t)vUsername,NULL,0,0,0);
m_userlist.SetItem(nItem,2,1,(_bstr_t)vOld,NULL,0,0,0);
m_userlist.SetItem(nItem,3,1,(_bstr_t)vSex,NULL,0,0,0);
m_userlist.SetItem(nItem,4,1,(_bstr_t)vFrom,NULL,0,0,0);
}
m_pRecordset->MoveNext();
}
if(m_userlist.GetItemCount()==0)
MessageBox("没有找到符合条件的学生！","提示！");
}
else
MessageBox("未输入任何信息！","提示！");
break;
case 3:
if(sfrom!=_T(""))
{
while(!m_pRecordset->adoEOF)
{
vFrom = m_pRecordset->GetCollect("from");
if(sfrom==(_bstr_t)vFrom)
{
vUserID = m_pRecordset->GetCollect("id");
vUsername = m_pRecordset->GetCollect("username");
vOld = m_pRecordset->GetCollect("old");
vSex = m_pRecordset->GetCollect("sex");
vFrom = m_pRecordset->GetCollect("from");
nItem=m_userlist.InsertItem(0xffff,(_bstr_t)vUserID);//先插第一个项
m_userlist.SetItem(nItem,1,1,(_bstr_t)vUsername,NULL,0,0,0);
m_userlist.SetItem(nItem,2,1,(_bstr_t)vOld,NULL,0,0,0);
m_userlist.SetItem(nItem,3,1,(_bstr_t)vSex,NULL,0,0,0);
m_userlist.SetItem(nItem,4,1,(_bstr_t)vFrom,NULL,0,0,0);
}
m_pRecordset->MoveNext();
}
if(m_userlist.GetItemCount()==0)
MessageBox("没有找到符合条件的学生！","提示！");
}
else
MessageBox("未输入任何信息！","提示！");
break;
default:
MessageBox("未输入任何信息！","提示！");
break;
}
}
}
void CADOTESTDlg::OnShowall()
{
// TODO: Add your control notification handler code here
m_userlist.DeleteAllItems();
int nItem;
m_pRecordset->MoveFirst();
while(!m_pRecordset->adoEOF)
{
vUserID = m_pRecordset->GetCollect("id");
vUsername = m_pRecordset->GetCollect("username");
vOld = m_pRecordset->GetCollect("old");
vSex = m_pRecordset->GetCollect("sex");
vFrom = m_pRecordset->GetCollect("from");
nItem=m_userlist.InsertItem(0xffff,(_bstr_t)vUserID);//先插第一个项
m_userlist.SetItem(nItem,1,1,(_bstr_t)vUsername,NULL,0,0,0);
m_userlist.SetItem(nItem,2,1,(_bstr_t)vOld,NULL,0,0,0);
m_userlist.SetItem(nItem,3,1,(_bstr_t)vSex,NULL,0,0,0);
m_userlist.SetItem(nItem,4,1,(_bstr_t)vFrom,NULL,0,0,0);
m_pRecordset->MoveNext();
}
m_cdelitem.EnableWindow(false);
m_cchaitem.EnableWindow(FALSE);
}
void CADOTESTDlg::OnButtonChange()
{
// TODO: Add your control notification handler code here
sid=m_userlist.GetItemText(m_nCurrentSel,0);
sname=m_userlist.GetItemText(m_nCurrentSel,1);
sage=m_userlist.GetItemText(m_nCurrentSel,2);
ssex=m_userlist.GetItemText(m_nCurrentSel,3);
sfrom=m_userlist.GetItemText(m_nCurrentSel,4);
CChange change(sid,sname,sage,ssex,sfrom);
int i=change.DoModal();
sid=change.id;
sname=change.name;
sage=change.age;
ssex=change.sex;
sfrom=change.from;
if(i==IDOK)
{
m_pRecordset->MoveFirst();
while(!m_pRecordset->adoEOF)
{
vUserID = m_pRecordset->GetCollect("id");
if(sid==(_bstr_t)vUserID)
{
vUsername = sname;
vOld = sage;
vSex = ssex;
vFrom = sfrom;
m_pRecordset->PutCollect("username",vUsername);
m_pRecordset->PutCollect("old",vOld);
m_pRecordset->PutCollect("sex",vSex);
m_pRecordset->PutCollect("from",vFrom);
m_userlist.SetItem(m_nCurrentSel,1,LVIF_TEXT,(_bstr_t)vUsername,NULL,0,0,0);
m_userlist.SetItem(m_nCurrentSel,2,LVIF_TEXT,(_bstr_t)vOld,NULL,0,0,0);
m_userlist.SetItem(m_nCurrentSel,3,LVIF_TEXT,(_bstr_t)vSex,NULL,0,0,0);
m_userlist.SetItem(m_nCurrentSel,4,LVIF_TEXT,(_bstr_t)vFrom,NULL,0,0,0);
break;
}
m_pRecordset->MoveNext();
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -