{
m_strClient = dlgAll.strKey;
UpdateData(FALSE);
}
}
void CSalesBill::OnCommodityserch()
{
// TODO: Add your control notification handler code here
UpdateData(TRUE);
CADOConn adoFind;
CDlgAll dlgAll;
CString strSQL;
strSQL = "SELECT CommodityInfo.barcode, CommodityInfo.name, CommodityInfo.standard, ";
strSQL = strSQL + "CommodityInfo.unit, StoreInfo.saleprice, StoreInfo.num FROM CommodityInfo INNER JOIN StoreInfo ON ";
strSQL = strSQL + "CommodityInfo.barcode = StoreInfo.barcode WHERE CommodityInfo.barcode = '";
strSQL = strSQL + m_strSerchCode + "' OR CommodityInfo.commoditycode = '";
strSQL = strSQL + m_strSerchCode + "' OR CommodityInfo.spellcode = '";
strSQL = strSQL + m_strSerchCode + "'";
dlgAll.strTitle = "商品基本信息";
dlgAll.strSQL = strSQL;
dlgAll.intKey = 0;
if (dlgAll.DoModal() == IDOK)
{
strSQL = "SELECT CommodityInfo.barcode, CommodityInfo.name, CommodityInfo.standard, ";
strSQL = strSQL + "CommodityInfo.unit, StoreInfo.saleprice, StoreInfo.num FROM CommodityInfo INNER JOIN StoreInfo ON ";
strSQL = strSQL + "CommodityInfo.barcode = StoreInfo.barcode WHERE CommodityInfo.barcode = '";
strSQL = strSQL + dlgAll.strKey + "'";
adoFind.Open(strSQL);
//adoFind.InitList(&m_ctrlListMain);
adoFind.FillList(&m_ctrlListMain);
m_ctrlListMain.SetItemText(0, 6, "1");
m_fltSalePrice = atof(m_ctrlListMain.GetItemText(0, 4));
m_iNum = 1;
m_fltAmount = m_fltAmount + m_iNum * m_fltSalePrice;
UpdateData(FALSE);
}
}