4,011
社区成员
发帖
与我相关
我的任务
分享
mysql_free_result(result);
d.DoModal ();
wchar_t ShouJia[100]; // 用于保存对话框返回的售价
::ZeroMemory (ShouJia,200);
for(unsigned int i = 0; i<100; i++)
{
ShouJia[i] = d.ShouJia[i] ;
}
mysql_query(conn,"select distinct 商品名称 from LinShiBiao");
result = mysql_store_result(conn);
row = mysql_fetch_row(result);
wchar_t ShangPinMingCheng[100]; // 用于保存临时表中的商品名称
::ZeroMemory (ShangPinMingCheng,200);
::MultiByteToWideChar (CP_OEMCP,0,row[0],-1,ShangPinMingCheng,100);
mysql_free_result(result);
if(p->GetItemCount () == 0) // 如果ClistCtrl 中没有记录
{
p->InsertItem (0,L"");
p->SetItemText (0,0,ShangPinMingCheng);
p->SetItemText (0,1,ShouJia);
p->SetItemText (0,2,L"1");
}
else
{
BOOL XiuGai = FALSE;
for(unsigned int i = 0; i< p->GetItemCount (); i++)
{
wchar_t mc[100];
wchar_t sj[100];
::ZeroMemory (mc,200);
::ZeroMemory (sj,200);
p->GetItemText (i,0,mc,100);
p->GetItemText (i,1,sj,100);
if( wcscmp(ShangPinMingCheng,mc)==0 && wcscmp(ShouJia,sj)==0 )
{
wchar_t sl[100];
::ZeroMemory (sl,200);
p->GetItemText (i,2,sl,100);
int a = _wtoi(sl);
a++;
::ZeroMemory (sl,200);
wsprintf(sl,L"%d",a);
p->SetItemText (i,2,sl);
XiuGai = TRUE;
break;
}
}
if( XiuGai == FALSE )
{
p->InsertItem (p->GetItemCount ()-1,L"");
p->SetItemText (p->GetItemCount ()-1,0,ShangPinMingCheng);
p->SetItemText (p->GetItemCount ()-1,1,ShouJia);
p->SetItemText (p->GetItemCount ()-1,2,L"1");
}
}
w = mysql_query(conn,"drop table LinShiBiao");
if(w!=0)
MessageBox(L"删除临时表失败");