📄 tsxxdlg.cpp
字号:
{
s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("价格"));
}
catch(...)
{
s=" ";
}
m_JIAGE=s;
UpdateData(false);
m_AdoConn.ExitConnect();
*pResult = 0;
}
void CTsxxDlg::OnTsxxAdd()
{
// TODO: Add your control notification handler code here
ADOConn m_AdoConn;
m_AdoConn.OnInitADOConn();
CString s;
CString strSql;
m_AdoConn.m_pRecordset.CreateInstance(__uuidof(Recordset));
try
{
if(i)
{
//CString strSql;
strSql.Format("SELECT * FROM %s","书籍信息");
}
else
{
// CString strSql;
CString str1,str2;
if(tsxxcxdlg_m_1 & tsxxcxdlg_m_2)
{
str1="SELECT * FROM 书籍信息 WHERE 类别=";
str2="AND 书名=";
strSql=str1+"'"+tsxxcxdlg_m_TSLBCX+"'"+str2+"'"+tsxxcxdlg_m_SMCX+"'";
}
else if(tsxxcxdlg_m_1)
{
str1="SELECT * FROM 书籍信息 WHERE 类别=";
strSql=str1+"'"+tsxxcxdlg_m_TSLBCX+"'";
}
else if(tsxxcxdlg_m_2)
{
str1="SELECT * FROM 书籍信息 WHERE 书名=";
strSql=str1+"'"+tsxxcxdlg_m_SMCX+"'";
}
else
{
MessageBox("请输入查询条件！");
}
}
//rSql="SELECT DateA,Sum(MoneyA) as MoneySum FROM Budget group by DateA having DateA>=#2004-8-1# and DateA<=#2004-8-2#";
m_AdoConn.m_pRecordset->Open(_variant_t(strSql), // 查询DemoTable表中所有字段
m_AdoConn.m_pConnection.GetInterfacePtr(), // 获取库接库的IDispatch指针
adOpenDynamic,
adLockOptimistic,
adCmdText);
}
catch(_com_error *e)
{
AfxMessageBox(e->ErrorMessage());
}
UpdateData(true);
if(m_SHUMIN== "" ||m_TSLB== "")
{
AfxMessageBox("书名和图书类别不能为空!");
return;
}
try
{
m_AdoConn.m_pRecordset->AddNew();
m_AdoConn.m_pRecordset->PutCollect("书籍编号", _variant_t(m_SJBH));
m_AdoConn.m_pRecordset->PutCollect("书名", _variant_t(m_SHUMIN));
m_AdoConn.m_pRecordset->PutCollect("类别", _variant_t(m_TSLB));
m_AdoConn.m_pRecordset->PutCollect("作者", _variant_t(m_ZUOZ));
m_AdoConn.m_pRecordset->PutCollect("出版社", _variant_t(m_CBS));
m_AdoConn.m_pRecordset->PutCollect("登记日期", _variant_t(m_DJRQ));
m_AdoConn.m_pRecordset->PutCollect("出版日期", _variant_t(m_CBRQ));
m_AdoConn.m_pRecordset->PutCollect("是否被借出", _variant_t(m_SHIFOU));
m_AdoConn.m_pRecordset->PutCollect("价格", _variant_t(m_JIAGE));
m_AdoConn.m_pRecordset->Update();
}
catch(_com_error *e)
{
AfxMessageBox(e->ErrorMessage());
}
MessageBox("插入成功！");
m_AdoConn.ExitConnect();
ShowDate();
}
void CTsxxDlg::OnTsxxDel()
{
// TODO: Add your control notification handler code here
ADOConn m_AdoConn;
m_AdoConn.OnInitADOConn();
CString s;
CString strSql;
m_AdoConn.m_pRecordset.CreateInstance(__uuidof(Recordset));
try
{ if(i)
{
//CString strSql;
strSql.Format("SELECT * FROM %s","书籍信息");
}
else
{
// CString strSql;
CString str1,str2;
if(tsxxcxdlg_m_1 & tsxxcxdlg_m_2)
{
str1="SELECT * FROM 书籍信息 WHERE 类别=";
str2="AND 书名=";
strSql=str1+"'"+tsxxcxdlg_m_TSLBCX+"'"+str2+"'"+tsxxcxdlg_m_SMCX+"'";
}
else if(tsxxcxdlg_m_1)
{
str1="SELECT * FROM 书籍信息 WHERE 类别=";
strSql=str1+"'"+tsxxcxdlg_m_TSLBCX+"'";
}
else if(tsxxcxdlg_m_2)
{
str1="SELECT * FROM 书籍信息 WHERE 书名=";
strSql=str1+"'"+tsxxcxdlg_m_SMCX+"'";
}
else
{
MessageBox("请输入查询条件！");
}
}
//rSql="SELECT DateA,Sum(MoneyA) as MoneySum FROM Budget group by DateA having DateA>=#2004-8-1# and DateA<=#2004-8-2#";
m_AdoConn.m_pRecordset->Open(_variant_t(strSql), // 查询DemoTable表中所有字段
m_AdoConn.m_pConnection.GetInterfacePtr(), // 获取库接库的IDispatch指针
adOpenDynamic,
adLockOptimistic,
adCmdText);
}
catch(_com_error *e)
{
AfxMessageBox(e->ErrorMessage());
}
POSITION pos=m_list_tsxx.GetFirstSelectedItemPosition();
if(pos==NULL)
return;
int nItem=m_list_tsxx.GetNextSelectedItem(pos);
m_AdoConn.m_pRecordset->Move(nItem);
try
{
s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("书名"));
}
catch(...)
{
s=" ";
}
m_SHUMIN=s;
try
{
s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("类别"));
}
catch(...)
{
s=" ";
}
m_TSLB=s;
CString str1,str2;
str1="你确定要删除记录";
//str2.LoadString(IDS_WARN_2);
str1=str1+m_SHUMIN+": "+m_TSLB+str2;
if(AfxMessageBox(str1,MB_YESNO|MB_ICONEXCLAMATION)==IDYES)
{
m_AdoConn.m_pRecordset->Delete(adAffectCurrent);///删除当前记录
UpdateData(false);
}
m_AdoConn.ExitConnect();
//m_pRecordset->Delete(adAffectCurrent);///删除当前记录
ShowDate();
}
void CTsxxDlg::OnTsxxEdit()
{
// TODO: Add your control notification handler code here
ADOConn m_AdoConn;
m_AdoConn.OnInitADOConn();
CString s;
CString strSql;
m_AdoConn.m_pRecordset.CreateInstance(__uuidof(Recordset));
try
{ if(i)
{
//CString strSql;
strSql.Format("SELECT * FROM %s","书籍信息");
}
else
{
// CString strSql;
CString str1,str2;
if(tsxxcxdlg_m_1 & tsxxcxdlg_m_2)
{
str1="SELECT * FROM 书籍信息 WHERE 类别=";
str2="AND 书名=";
strSql=str1+"'"+tsxxcxdlg_m_TSLBCX+"'"+str2+"'"+tsxxcxdlg_m_SMCX+"'";
}
else if(tsxxcxdlg_m_1)
{
str1="SELECT * FROM 书籍信息 WHERE 类别=";
strSql=str1+"'"+tsxxcxdlg_m_TSLBCX+"'";
}
else if(tsxxcxdlg_m_2)
{
str1="SELECT * FROM 书籍信息 WHERE 书名=";
strSql=str1+"'"+tsxxcxdlg_m_SMCX+"'";
}
else
{
MessageBox("请输入查询条件！");
}
}
//rSql="SELECT DateA,Sum(MoneyA) as MoneySum FROM Budget group by DateA having DateA>=#2004-8-1# and DateA<=#2004-8-2#";
m_AdoConn.m_pRecordset->Open(_variant_t(strSql), // 查询DemoTable表中所有字段
m_AdoConn.m_pConnection.GetInterfacePtr(), // 获取库接库的IDispatch指针
adOpenDynamic,
adLockOptimistic,
adCmdText);
}
catch(_com_error *e)
{
AfxMessageBox(e->ErrorMessage());
}
POSITION pos=m_list_tsxx.GetFirstSelectedItemPosition();
if(pos==NULL)
return;
int nItem=m_list_tsxx.GetNextSelectedItem(pos);
m_AdoConn.m_pRecordset->Move(nItem);
/*
try
{
s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("书籍编号"));
}
catch(...)
{
s=" ";
}
m_SJBH=s;
try
{
s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("书名"));
}
catch(...)
{
s=" ";
}
m_SHUMIN=s;
try
{
s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("类别"));
}
catch(...)
{
s=" ";
}
m_TSLB=s;
try
{
s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("作者"));
}
catch(...)
{
s=" ";
}
m_ZUOZ=s;
try
{
s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("出版社"));
}
catch(...)
{
s=" ";
}
m_CBS=s;
try
{
s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("出版日期"));
//AfxMessageBox(s);
}
catch(...)
{
s=" ";
}
m_CBRQ=s;
try
{
s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("登记日期"));
}
catch(...)
{
s=" ";
}
m_DJRQ=s;
try
{
s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("是否被借出"));
}
catch(...)
{
s=" ";
}
m_SHIFOU=s;
try
{
s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("价格"));
}
catch(...)
{
s=" ";
}
m_JIAGE=s;
UpdateData(false);*/
UpdateData(true);
try
{
m_AdoConn.m_pRecordset->PutCollect("书籍编号", _variant_t(m_SJBH));
m_AdoConn.m_pRecordset->PutCollect("书名", _variant_t(m_SHUMIN));
m_AdoConn.m_pRecordset->PutCollect("类别", _variant_t(m_TSLB));
m_AdoConn.m_pRecordset->PutCollect("作者", _variant_t(m_ZUOZ));
m_AdoConn.m_pRecordset->PutCollect("出版社", _variant_t(m_CBS));
m_AdoConn.m_pRecordset->PutCollect("登记日期", _variant_t(m_DJRQ));
m_AdoConn.m_pRecordset->PutCollect("出版日期", _variant_t(m_CBRQ));
m_AdoConn.m_pRecordset->PutCollect("是否被借出", _variant_t(m_SHIFOU));
m_AdoConn.m_pRecordset->PutCollect("价格", _variant_t(m_JIAGE));
m_AdoConn.m_pRecordset->Update();
}
catch(_com_error *e)
{
AfxMessageBox(e->ErrorMessage());
}
MessageBox("修改成功！");
m_AdoConn.ExitConnect();
ShowDate();
}
void CTsxxDlg::OnTsxxQuery()
{
// TODO: Add your control notification handler code here
CTsxxcxDlg tsxxcxdlg;
//tsxxcxdlg.DoModal();
if(tsxxcxdlg.DoModal()==IDOK)
{
i=false;
tsxxcxdlg_m_1 =tsxxcxdlg.m_1;
tsxxcxdlg_m_2 =tsxxcxdlg.m_2;
tsxxcxdlg_m_TSLBCX=tsxxcxdlg.m_TSLBCX;
tsxxcxdlg_m_SMCX=tsxxcxdlg.m_SMCX;
ADOConn m_AdoConn;
m_AdoConn.OnInitADOConn();
m_AdoConn.m_pRecordset.CreateInstance(__uuidof(Recordset));
try
{
CString strSql;
CString str1,str2;
if(tsxxcxdlg_m_1 & tsxxcxdlg_m_2)
{
str1="SELECT * FROM 书籍信息 WHERE 类别=";
str2="AND 书名=";
strSql=str1+"'"+tsxxcxdlg_m_TSLBCX+"'"+str2+"'"+tsxxcxdlg_m_SMCX+"'";
}
else if(tsxxcxdlg_m_1)
{
str1="SELECT * FROM 书籍信息 WHERE 类别=";
strSql=str1+"'"+tsxxcxdlg_m_TSLBCX+"'";
}
else if(tsxxcxdlg_m_2)
{
str1="SELECT * FROM 书籍信息 WHERE 书名=";
strSql=str1+"'"+tsxxcxdlg_m_SMCX+"'";
}
else
{
MessageBox("请输入查询条件！");
return;
}
//MessageBox(strSql);
m_AdoConn.m_pRecordset->Open(_variant_t(strSql), // 查询DemoTable表中所有字段
m_AdoConn.m_pConnection.GetInterfacePtr(), // 获取库接库的IDispatch指针
adOpenDynamic,
adLockOptimistic,
adCmdText);
}
catch(_com_error *e)
{
AfxMessageBox(e->ErrorMessage());
}
}
ShowDate();
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -