📄 shopdlg.cpp
字号:
sql = "select * from employeeview where " + mode1 + " " + option1 + " " + "'" + condition1+"'";
}
else if(option22 == true && andor == false)
{
sql = "select * from employeeview where " + mode2 + " " + option2 + " " + "'" + condition2 + "'";
}
else
goto label;
//sql = (mode1 + option1 + condition1) + (andor + mode2 + option2 + condition2);
try
{
//AfxMessageBox("请选择查询方式!");
m_pRecordset->Close();
m_pRecordset = NULL;
m_userlist.DeleteAllItems();
m_pRecordset.CreateInstance("ADODB.Recordset");
//m_pRecordset->MoveFirst();
//m_pRecordset.CreateInstance(_uuidof(Recordset));//
//m_pRecordset->Open("select * from employeeview",_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
m_pRecordset->Open( (_variant_t)sql,_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
//AfxMessageBox("请选择查询方式!");
//m_pRecordset->Close();
//m_pRecordset->Open("select * from employeeview where sql",_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
//m_bSuccess = TRUE;
while(!m_pRecordset->adoEOF)
{
//AfxMessageBox("请选择查询方式!");
vempno= m_pRecordset->GetCollect("empno");
vempname = m_pRecordset->GetCollect("empname");
vsex=m_pRecordset->GetCollect("sex");
vsalary = m_pRecordset->GetCollect("salary");
vduty = m_pRecordset->GetCollect("duty");
vdeptno= m_pRecordset->GetCollect("deptno");
vdeptname= m_pRecordset->GetCollect("deptname");
vmanagername = m_pRecordset->GetCollect("managername");
vbirthday = m_pRecordset->GetCollect("birthday");
vaddress= m_pRecordset->GetCollect("address");
vtelephone= m_pRecordset->GetCollect("telephone");
vremark= m_pRecordset->GetCollect("remark");
//this->AbleFalse();
//this->LoadData();
//this->GetDlgItem(IDC_BUTTON4)->EnableWindow(FALSE);
//this->GetDlgItem(IDC_BUTTON2)->EnableWindow(FALSE);
nItem=m_userlist.InsertItem(0xffff,(_bstr_t)vempno);//先插第一个项
m_userlist.SetItem(nItem,1,1,(_bstr_t)vempname,NULL,0,0,0);
m_userlist.SetItem(nItem,2,1,(_bstr_t)vsex ,NULL,0,0,0);
m_userlist.SetItem(nItem,3,1,(_bstr_t)vsalary ,NULL,0,0,0);
m_userlist.SetItem(nItem,4,1,(_bstr_t)vduty,NULL,0,0,0);
m_userlist.SetItem(nItem,5,1,(_bstr_t)vdeptno,NULL,0,0,0);
m_userlist.SetItem(nItem,6,1,(_bstr_t)vdeptname,NULL,0,0,0);
m_userlist.SetItem(nItem,7,1,(_bstr_t)vmanagername ,NULL,0,0,0);
m_userlist.SetItem(nItem,8,1,(_bstr_t)vbirthday ,NULL,0,0,0);
m_userlist.SetItem(nItem,9,1,(_bstr_t)vaddress,NULL,0,0,0);
m_userlist.SetItem(nItem,10,1,(_bstr_t)vtelephone,NULL,0,0,0);
m_userlist.SetItem(nItem,11,1,(_bstr_t)vremark,NULL,0,0,0);
m_pRecordset->MoveNext();
}
}
catch(_com_error e)///捕捉异常
{
//AfxMessageBox("读取数据库失败!");///显示错误信息
}
//对逻辑运算的符号的恢复，以供下一次的查询 。
label: //AfxMessageBox("请选择查询方式!");
//option11 = false;
//option22 = false;
//andor00 = false;
////////////////////////////////////////////////////////////////////
//mode1 = "";
//mode2 = "";
//option1 = "";
//option2 = "";
//andor = "";
UpdateData(false);
//UpdateData(true);
//AfxMessageBox("请选择查询方式!");
// TODO: Add your control notification handler code here
}
void CShopDlg::Ondelete()
{
UpdateData(true);
//_variant_t vclassnumber;
//int panduan = 1;
//CString sql,sql2,classnumber;
//m_insertstudentnum = "'"+m_insertstudentnum + "'";
//sql = "select * from student where studentnum = "+m_insertstudentnum ;
if(MessageBox("确定要删除吗?",0,
MB_OKCANCEL|MB_DEFBUTTON2|MB_ICONWARNING)==IDOK)
{
m_empno = "'"+m_empno + "'";
sql = "select * from employee where empno = "+m_empno ;
//////////////////////////////////////////////////////////////////////////////
try
{
m_pRecordset->Close();
m_pRecordset = NULL;
m_pRecordset.CreateInstance(_uuidof(Recordset));//
m_pRecordset->Open( (_variant_t)sql,_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
m_pRecordset->Delete(adAffectCurrent);
//AfxMessageBox("删除记录成功!!");
displayintheuserlist();
//m_pRecordset->Close();
//m_pRecordset = NULL;
// m_pRecordset.CreateInstance(_uuidof(Recordset));//
// m_pRecordset->Open("select * from student",_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
}
catch(_com_error e)///捕捉异常
{
AfxMessageBox("删除记录失败!");///显示错误信息
// panduan = 0;
}
}
// TODO: Add your control notification handler code here
}
void CShopDlg::Onmodify()
{
//先删除,再添加
//下面是删除
UpdateData(true);
//_variant_t vclassnumber;
//int panduan = 1;
//CString sql,sql2,classnumber;
//m_insertstudentnum = "'"+m_insertstudentnum + "'";
//sql = "select * from student where studentnum = "+m_insertstudentnum ;
if(MessageBox("确定要修改吗吗?",0,
MB_OKCANCEL|MB_DEFBUTTON2|MB_ICONWARNING)==IDOK)
{
m_empno = "'"+m_empno + "'";
sql = "select * from employee where empno = "+m_empno ;
//////////////////////////////////////////////////////////////////////////////
try
{
m_pRecordset->Close();
m_pRecordset = NULL;
m_pRecordset.CreateInstance(_uuidof(Recordset));//
m_pRecordset->Open( (_variant_t)sql,_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
m_pRecordset->Delete(adAffectCurrent);
//AfxMessageBox("删除记录成功!!");
// displayintheuserlist();
//m_pRecordset->Close();
//m_pRecordset = NULL;
// m_pRecordset.CreateInstance(_uuidof(Recordset));//
// m_pRecordset->Open("select * from student",_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
}
catch(_com_error e)///捕捉异常
{
//AfxMessageBox("删除记录失败!");///显示错误信息
// panduan = 0;
}
// TODO: Add your control notification handler code here
//////////////////////////////////////////////////////////
//********************下面是添加*********************************
//bool judge;
// judge = false;
UpdateData(true);//把控件的值传给相应的变量
if (m_empno == "" || m_empname == "" || m_deptno == "")
{
AfxMessageBox("职工编号或职工姓名或部门编号不能为空！！");
goto tiaozhuan;
}
m_pRecordset.CreateInstance("ADODB.Recordset");
m_pRecordset->Open("select deptno from deptment",_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
if (!m_pRecordset->adoEOF)
{
vdeptno= m_pRecordset->GetCollect("deptno");
//vdeptname= m_pRecordset->GetCollect("deptname");
while(_variant_t(m_deptno) != vdeptno && !m_pRecordset->adoEOF)
{
m_pRecordset->MoveNext();
if(!m_pRecordset->adoEOF)
{
vdeptno= m_pRecordset->GetCollect("deptno");
}
}
}
//AfxMessageBox("无此部门编号，请输入正确的部门编号！");
if (m_pRecordset->adoEOF)
{
AfxMessageBox("无此部门编号，请输入正确的部门编号！");
goto tiaozhuan;
}
m_pRecordset->Close();
m_pRecordset = NULL;
//UpdateData(true);//把控件的值传给相应的变量
//m_pRecordset1->Close();
//m_pRecordset1 = NULL;
m_pRecordset1.CreateInstance(_uuidof(Recordset));//
m_pRecordset1->Open("select * from employee",_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
try
{
m_pRecordset1->AddNew();
vempno = m_empno;
vempname = m_empname;
vsex = m_sex;
vsalary = m_salary;
vduty = m_duty;
vdeptno = m_deptno;
//vdeptname = m_deptname;
//vmanagername = m_managername;
vbirthday = m_birthday;
vaddress = m_address;
vtelephone = m_telephone;
vremark = m_remark;
//UpdateData(true);
m_pRecordset1->PutCollect("empno",vempno);
m_pRecordset1->PutCollect("empname",vempname);
m_pRecordset1->PutCollect("sex",vsex);
m_pRecordset1->PutCollect("salary",vsalary);
m_pRecordset1->PutCollect("duty",vduty);
m_pRecordset1->PutCollect("deptno",vdeptno);
//m_pRecordset->PutCollect("deptname",vdeptname);
//m_pRecordset->PutCollect("managername",vmanagername);
m_pRecordset1->PutCollect("birthday",vbirthday);
m_pRecordset1->PutCollect("address",vaddress);
m_pRecordset1->PutCollect("telephone",vtelephone);
m_pRecordset1->PutCollect("remark",vremark);
//UpdateData(true);
//m_pRecordset.CreateInstance("ADODB.Recordset");
//m_pRecordset->Open("insert into employee values(empno,empname,sex,salary,duty,deptno,birthday,address,telephone,remark) ",_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
//AfxMessageBox("添加记录成功!");
m_pRecordset1->Update();
m_pRecordset1->Close();
m_pRecordset1 = NULL;
//AfxMessageBox("添加记录成功!");
//重建指针,以备下次添加记录时使用
//m_pRecordset1.CreateInstance(_uuidof(Recordset));//
//m_pRecordset1->Open("select * from employee",_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
}
catch(_com_error e)///捕捉异常
{
AfxMessageBox("此员工已存在!");///显示错误信息
}
goto tiaozhuan1;
/*if(m_empno.GetLength()>0 && m_empname.GetLength()>0)
{
m_pRecordset->AddNew();
m_nCurrentSel = m_userlist.InsertItem(0xffff,"");
SaveData();///保存数据到记录集和列表框
m_userlist.SetItemState(m_nCurrentSel,LVIS_SELECTED|LVIS_FOCUSED,LVIS_SELECTED|LVIS_FOCUSED);
m_userlist.SetHotItem(m_nCurrentSel);
m_userlist.SetFocus();
} */
tiaozhuan:
m_deptno = "";
UpdateData(false);
tiaozhuan1:
try {}
catch(_com_error e)///捕捉异常
{
//AfxMessageBox("存储数据失败!");///显示错误信息
}
displayintheuserlist();
}
AfxMessageBox("修改成功!!!!!");
}
void CShopDlg::Onclose()
{
CDialog::OnOK();
// TODO: Add your control notification handler code here
}
void CShopDlg::Oncountnumber()
{
int count = 0;
CString vcount;
//m_pRecordset->Close();
//m_pRecordset = NULL;
//UpdateData(true);//把控件的值传给相应的变量
//m_pRecordset1->Close();
//m_pRecordset1 = NULL;
m_pRecordset.CreateInstance(_uuidof(Recordset));//
m_pRecordset->Open("select * from employee",_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
while (!m_pRecordset->adoEOF)
{
count = count + 1;
m_pRecordset->MoveNext();
}
m_count.Format("%d",count);
vcount = "当前职工人数为 " + m_count + " 人";
m_count = vcount;
UpdateData(false);
//catch(_com_error e)///捕捉异常
//AfxMessageBox("读取数据库失败!");///显示错误信息
// TODO: Add your control notification handler code here
}
void CShopDlg::Onpersonmanage()
{
CShopDlg::OnOK();
CShopDlg dl;
dl.DoModal();
// TODO: Add your command handler code here
}
void CShopDlg::OnMenuitem32773()
{
//CShopDlg::OnOK();
Cdeptment dl;
dl.DoModal();
// TODO: Add your command handler code here
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -