,'%s','%s')",c_name,c_shortname,c_barcode,c_author,c_press,atof(c_price),c_memo,c_kinds);
try
{
m_pRs->raw_Close();
m_pRs->Open((_variant_t)sql,m_pCon.GetInterfacePtr(),adOpenKeyset,adLockOptimistic,adCmdText);
MessageBox("操作成功.","提示",MB_OK|MB_ICONINFORMATION);
ClearInterface();
LoadBookInfo();
}
catch(...)
{
MessageBox("操作失败.","提示",MB_OK|MB_ICONERROR);
}
}
void CDlgBookInfo1::UpdateBookInfo()
{
if (!InfoIsNull())
{
if (m_list.GetSelectionMark()!=-1)
{
if (MessageBox("确实要修改数据吗?","提示",MB_YESNO|MB_ICONINFORMATION)==IDYES)
{
CString c_barcode;
c_barcode = m_list.GetItemText(m_list.GetSelectionMark(),2);
CString c_name,c_newcode,c_shortname,c_author,c_press,c_price,c_memo,c_kinds;
m_bookname.GetWindowText(c_name);
m_barcode.GetWindowText(c_newcode);
m_shortcode.GetWindowText(c_shortname);
m_author.GetWindowText(c_author);
m_public.GetWindowText(c_press);
m_price.GetWindowText(c_price);
m_memo.GetWindowText(c_memo);
m_kinds.GetWindowText(c_kinds);
CString sql;
sql.Format("update tb_bookinfo set bookname = '%s',shortname = '%s',barcode = '%s',author = '%s',bookconcern = '%s',price = %f,memo = '%s',kind = '%s' where barcode = '%s'"
,c_name,c_shortname,c_newcode,c_author,c_press,atof(c_price),c_memo,c_kinds,c_barcode);
m_pRs->raw_Close();
try
{
m_pRs->Open((_variant_t)sql,m_pCon.GetInterfacePtr(),adOpenKeyset,adLockOptimistic,adCmdText);
ClearInterface();
LoadBookInfo();
MessageBox("操作成功.","提示",64);
}
catch(...)
{
MessageBox("操作失败.","提示",MB_OK|MB_ICONERROR);
}
}
}
else
MessageBox("请选择欲修改的信息.","提示",MB_OK|MB_ICONINFORMATION);
}
else
MessageBox("基础信息不完整.","提示",MB_OK|MB_ICONINFORMATION);
}
void CDlgBookInfo1::OnDblclkList1(NMHDR* pNMHDR, LRESULT* pResult)
{
int row = m_list.GetSelection
上一篇：
carchaxun.pas
下一篇：
计算机实践报告论文
2013-9-1
