[cpp]
BEGIN_MESSAGE_MAP(CUSERDlg, CDialog)
//{{AFX_MSG_MAP(CUSERDlg)
ON_BN_CLICKED(IDC_ADD, OnAdd)
ON_BN_CLICKED(IDC_DEL, OnDel)
ON_NOTIFY(NM_CLICK, IDC_LIST4, OnClickList4)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CUSERDlg message handlers
BOOL CUSERDlg::OnInitDialog()
{
CDialog::OnInitDialog();
// TODO: Add extra initialization here
m_CtlList.SetExtendedStyle(LVS_EX_FLATSB|LVS_EX_FULLROWSELECT|LVS_EX_HEADERDRAGDROP|LVS_EX_ONECLICKACTIVATE|LVS_EX_GRIDLINES);
m_CtlList.InsertColumn(0,"用户",LVCFMT_LEFT,150);
m_CtlList.InsertColumn(1,"权限",LVCFMT_LEFT,150);
showData(); www.zzzyk.com
return TRUE; // return TRUE unless you set the focus to a control
// EXCEPTION: OCX Property Pages should return FALSE
}
void CUSERDlg::OnAdd()
{
// TODO: Add your control notification handler code here
UpdateData(true);
CADO ado;
ado.CADOConnect();
CString temp,str,str1;
_variant_t ra;
int k=m_combo.GetCurSel();
if (k==1)
{
str1="student";
}
else
{
str1="admin";
}
if (m_name=="")
{
MessageBox("用户名不能为空");
GetDlgItem(IDC_EDIT4)->SetFocus();
}
else if (m_pass1!=m_pass2)
{
MessageBox("密码不符");
GetDlgItem(IDC_EDIT5)->SetFocus();
m_pass1=m_pass2="";
UpdateData(FALSE);
}
else
{
str.Format("insert into login values('%s','%s','%s')",m_name,m_pass1,str1);
//str.Format("insert into ");
ado.ExecuteSQL(_bstr_t(str));
showData();
m_name=m_pass1=m_pass2="";
MessageBox("添加用户成功");
}
}
void CUSERDlg::OnDel()
{
// TODO: Add your control notification handler code here
UpdateData(true);
CADO ado;
ado.CADOConnect();
if (m_CtlList.GetSelectionMark()==-1)
{
MessageBox("请选择用户");
return;
}
int pos=m_CtlList.GetSelectionMark();//当前选中的行索引
CString str1=m_CtlList.GetItemText(pos,0);
CString str;
str.Format("delete from login where sno='%s'",str1);
MessageBox(str1);
ado.ExecuteSQL(_bstr_t(str));
MessageBox("删除成功");
showData();
}
void CUSERDlg::showData()
{
// m_list.ResetContent();//数据清空
m_CtlList.DeleteAllItems();
CString user,password,power,temp;
CADO ado;
ado.CADOConnect();
CString str;
str="select * from login";
_RecordsetPtr pRS = ado.Select(str);
while (!pRS->adoEOF)
{
//pRS->MoveFirst();
m_CtlList.InsertItem(0,"");
user=pRS->GetCollect("sno").bstrVal;
power=pRS->GetCollect("userright").bstrVal;
m_CtlList.SetItemText(0,0,user);
m_CtlList.SetItemText(0,1,power);
pRS->MoveNext();
//k++;
}
}
void CUSERDlg::OnClickList4(NMHDR* pNMHDR, LRESULT* pResult)
{
// TODO: Add your control notification handler code here
int pos=m_CtlList.GetSelectionMark();//当前选中的行索引
m_name1=m_CtlList.GetItemText(pos,0);
// m_=m_CtlList.GetItemText(pos,1);
UpdateData(FALSE);
*pResult = 0;
}
