商店管理系统源代码(三) (七)

void CSalesBill::OnUpdate()
{
// TODO: Add your control notification handler code here
UpdateData(TRUE);
CString strSQL, strTemp;
CADOConn adoSaleBill, adoSaleCommodity, adoStoreInfo, adoIntegral;

strSQL = "INSERT INTO SaleBill VALUES ('";
strSQL = strSQL + m_strBillCode + "', '";
strSQL = strSQL + m_strBillDate + "', '";
strSQL = strSQL + m_strBiller + "', '";
strSQL = strSQL + m_strClient + "', '";
strSQL = strSQL + m_strNote + "')";
adoSaleBill.ExecuteSQL(strSQL);

for(int i = 0; i < m_ctrlListMain.GetItemCount(); i++)
{
strSQL = "INSERT INTO SaleCommodity VALUES ('";
strSQL = strSQL + m_strBillCode + "', '";
strSQL = strSQL + m_ctrlListMain.GetItemText(i, 0) + "', '";
strSQL = strSQL + m_ctrlListMain.GetItemText(i, 4) + "', '";
strSQL = strSQL + m_ctrlListMain.GetItemText(i, 6) + "')";
adoSaleCommodity.ExecuteSQL(strSQL);

int num = atoi(m_ctrlListMain.GetItemText(i, 5)) - atoi(m_ctrlListMain.GetItemText(i, 6));
strSQL = "UPDATE StoreInfo SET num = '";
strTemp.Format(_T("%d"), num);
strSQL = strSQL + strTemp + "' WHERE barcode = '";
strSQL = strSQL + m_ctrlListMain.GetItemText(i, 0) + "'";
adoStoreInfo.ExecuteSQL(strSQL);
}

strSQL = "SELECT * FROM Integral WHERE cardcode = '";
strSQL = strSQL + m_strClient + "'";
adoIntegral.Open(strSQL);
if (!adoIntegral.adoEOF())
{
strSQL = "UPDATE Integral SET totalintegral = '";
strTemp.Format(_T("%0.2f"), m_fltAmount + atoi(adoIntegral.GetItemString(1)));
strSQL = strSQL + strTemp + "', remainderintegral = '";
strTemp.Format(_T("%0.2f"), m_fltAmount + atoi(adoIntegral.GetItemString(3)));
strSQL = strSQL + strTemp + "' WHERE cardcode = '";
strSQL = strSQL + m_strClient + "'";
adoIntegral.ExecuteSQL(strSQL);
}
else
{
strSQL = "INSERT INTO Integral VALUES ('";
strSQL = strSQL + m_strClient + "', '";
strTemp.Format(_T("%d"), m_fltAmount);
strSQL = strSQL + strTemp + "', '0', '";
strSQL = strSQL + strTemp + "')";
adoIntegral.ExecuteSQL(strSQL);
}

}

void CSalesBill::OnDelete()
{
// TODO: Add your control notification handler code here
POSITION pos;
int index;
CADOConn adoSaleBill;
CString strSQL;

pos = m_ctrlListMain.GetFirstSelectedItemPosition();
index = m_ctrlListMain.GetNextSelectedItem(pos);
strSQL = "DELETE * FROM SaleBill WHERE SaleBill.salecode ='";
strSQL = strSQL + m_ctrlListMain.GetItemText(index, 0) + "'";
adoSaleBill.ExecuteSQL(strSQL);
m_fltAmount = m_fltAmount - atof(m_ctrlListMain.GetItemText(index, 4)) * atoi(m_ctrlListMain.GetItemText(index, 6));
m_ctrlListMain.DeleteItem(index);
}

void CSalesBill::OnAccount()
{
// TODO: Add your control notification handler code here
m_strBillCode = "";
m_strBillDate = "";
m_strClient = "";
m_strNote = "";
m_fltSalePrice = 0;
m_iNum = 0;
m_ctrlListMain.DeleteAllItems();
UpdateData(FALSE);
}

void CSalesBill::OnClientfind()
{
// TODO: Add your control notification handler code here
CADOConn adoFind;
CDlgAll dlgAll;
dlgAll.strTitle = "客户信息";
dlgAll.strSQL = "SELECT * FROM ClientInfo";
dlgAll.intKey = 0;

if (dlgAll.DoModal()