【VC开源代码栏目提醒】:网学会员,鉴于大家对VC开源代码十分关注,论文会员在此为大家搜集整理了“DlgSaleBack2.cpp”一文,供大家参考学习!
// DlgSaleBack2.cpp : implementation file
//
#include "stdafx.h"
#include "bbb.h"
#include "DlgSaleBack2.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
extern _ConnectionPtr m_pCon; //ADO连接对象
extern _RecordsetPtr m_pRs;
extern _RecordsetPtr m_pRs1;
extern _CommandPtr m_pCom;
extern CString user;
/////////////////////////////////////////////////////////////////////////////
// CDlgSaleBack2 dialog
CDlgSaleBack2::CDlgSaleBack2(CWnd* pParent /*=NULL*/)
: CDialog(CDlgSaleBack2::IDD, pParent)
{
changed = true;
//{{AFX_DATA_INIT(CDlgSaleBack2)
// NOTE: the ClassWizard will add member initialization here
//}}AFX_DATA_INIT
}
void CDlgSaleBack2::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CDlgSaleBack2)
DDX_Control(pDX, IDC_SUMMONEY, m_summoney);
DDX_Control(pDX, IDC_SELLPRICE, m_sellprice);
DDX_Control(pDX, IDC_REBATE, m_rebate);
DDX_Control(pDX, IDC_PAYMONEY, m_paymoney);
DDX_Control(pDX, IDC_OPERATOR, m_operator);
DDX_Control(pDX, IDC_NUM, m_booknum);
DDX_Control(pDX, IDC_LIST1, m_list);
DDX_Control(pDX, IDC_FACTMONEY, m_factmoney);
DDX_Control(pDX, IDC_DATE, m_date);
DDX_Control(pDX, IDC_CUSTOMER, m_customer);
DDX_Control(pDX, IDC_COUNTERNAME, m_counter);
DDX_Control(pDX, IDC_BOOKREBATE, m_bookrebate);
DDX_Control(pDX, IDC_BOOKNAME, m_bookname);
DDX_Control(pDX, IDC_BARCODE, m_barcode);
DDX_Control(pDX, IDC_AUTHOR, m_author);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CDlgSaleBack2, CDialog)
//{{AFX_MSG_MAP(CDlgSaleBack2)
ON_EN_CHANGE(IDC_BARCODE, OnChangeBarcode)
ON_EN_CHANGE(IDC_REBATE, OnChangeRebate)
ON_EN_CHANGE(IDC_SUMMONEY, OnChangeSummoney)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CDlgSaleBack2 message handlers
void CDlgSaleBack2::AddDataToList()
{
CString c_barcode,c_bookname,c_booknum,c_bookrebate,c_sellprice,c_author,c_subtotal;
float f_booknum,f_bookrebate,f_sellprice,f_subtotal;
m_barcode.GetWindowText(c_barcode);
m_bookname.GetWindowText(c_bookname);
m_booknum.GetWindowText(c_booknum);
m_bookrebate.GetWindowText(c_bookrebate);
m_author.GetWindowText(c_author);
m_sellprice.GetWindowText(c_sellprice);
f_booknum = atof(c_booknum);
f_bookrebate = atof(c_bookrebate);
f_sellprice = atof(c_sellprice);
f_subtotal = f_booknum*f_bookrebate*f_sellprice;
c_subtotal.Format("%f",f_subtotal);
if (c_barcode.IsEmpty()||c_bookname.IsEmpty()||c_booknum.IsEmpty()||c_bookrebate.IsEmpty()||c_sellprice.IsEmpty())
{
return;
}
else
{
//Add data to list
m_list.InsertItem(100,"");
int rows = m_list.GetItemCount();
m_list.SetItemText(rows-1,0,c_barcode);
m_list.SetItemText(rows-1,1,c_bookname);
m_list.SetItemText(rows-1,2,c_author);
m_list.SetItemText(rows-1,3,c_sellprice);
m_list.SetItemText(rows-1,4,c_bookrebate);
m_list.SetItemText(rows-1,5,c_booknum);
m_list.SetItemText(rows-1,6,c_subtotal);
//Clear Edit Text
m_barcode.SetWindowText("");
m_booknum.SetWindowText("");
m_bookrebate.SetWindowText("1.0");
m_sellprice.SetWindowText("");
m_barcode.SetFocus();
//统计
float money = CalculateMoney();
CString temp;
temp.Format("%f",money);
m_summoney.SetWindowText(temp);
}
}
void CDlgSaleBack2::AddOperate()
{
if (HeaderInfoIsNull())
{
MessageBox("销售主表信息不能为空");
return;
}
if (ListInfoIsNull())
{
MessageBox("商品列表不能为空");
return;
}
CString c_id,c_customer,c_operator,c_rebate,c_summoney,c_paymoney,c_factmoney,c_selltime,c_counter;
float f_rebate,f_summoney,f_paymoney,f_factmoney;
m_customer.GetWindowText(c_customer);
m_operator.GetWindowText(c_operator);
m_rebate.GetWindowText(c_rebate);
m_summoney.GetWindowText(c_summoney);
m_paymoney.GetWindowText(c_paymoney);
m_factmoney.GetWindowText(c_factmoney);
m_date.GetWindowText(c_selltime);
m_counter.GetWindowText(c_counter);
f_rebate = atof(c_rebate);
f_summoney = atof(c_summoney);
f_paymoney = atof(c_paymoney);
f_factmoney = atof(c_factmoney);
m_pCom->ActiveConnection = m_pCon.GetInterfacePtr();
//define parameter information
_ParameterPtr arrays[9];
// utilize command object to create parameter
arrays[0] = m_pCom->CreateParameter("a1",adVarChar,adParamInput,30);
arrays[1] = m_pCom->CreateParameter("a2",adVarChar,adParamInput,30);
arrays[2] = m_pCom->CreateParameter("a3",adSingle,adParamInput,30);
arrays[3] = m_pCom->CreateParameter("a4",adCurrency,adParamInput,10);
arrays[4] = m_pCom->CreateParameter("a5",adCurrency,adParamInput,10);
arrays[5] = m_pCom->CreateParameter("a6",adCurrency,adParamInput,10);
arrays[6] = m_pCom->CreateParameter("a7",adVarChar,adParamInput,30);
arrays[7] = m_pCom->CreateParameter("a8",adVarChar,adParamInput,30);
arrays[8] = m_pCom->CreateParameter("a9",adVarChar,adParamOutput,30);
// set parameter values
arrays[0]->Value = (_bstr_t)c_customer;
arrays[1]->Value = (_bstr_t)c_operator;
arrays[2]->Value = f_rebate;
arrays[3]->Value = f_summoney;
arrays[4]->Value = f_paymoney;
arrays[5]->Value = f_factmoney;
arrays[6]->Value = (_bstr_t)c_selltime;
arrays[7]->Value = (_bstr_t)c_counter;
//add parameter to command object
m_pCom->CommandText = "sp_cancelsell";
m_pCom->CommandType = adCmdStoredProc;
for (int m = 0;m<9;m++)
{
m_pCom->Parameters->Append(arrays[m]);
}
try
{
m_pCom->Execute(0,NULL,adCmdStoredProc);
//Get Sell ID
c_id = (TCHAR*)(_bstr_t)arrays[8]->Value;
for (int i = 9 ;i >0;i--)
{
m_pCom->Parameters->Delete((long)(i-1));
}
for(int row = 0; row< m_list.GetItemCount();row++)
{
CString c_barcode;
float f_unitprice,f_number,f_bookrebate,f_money;
c_barcode = m_list.GetItemText(row,0);
f_unitprice = atof(m_list.GetItemText(row,3));
f_number = atof(m_list.GetItemText(row,5));
f_bookrebate = atof(m_list.GetItemText(row,4));
f_money = atof(m_list.GetItemText(row,6));
m_pRs->raw_Close();
CString sql;
sql.Format("insert into tb_cancelsell_sub values ('%s','%s',%f,%f,%f,%f)",c_id,c_barcode,f_unitprice,f_number,f_rebate,f_money);
m_pRs->Open((_variant_t)sql,m_pCon.GetInterfacePtr(),adOpenKeyset,adLockOptimistic,adCmdText);
// Update Counter Book Number
sql.Format("update tb_counterbook set b
上一篇:
DlgRoleinfo.cpp
下一篇:
经济民主一种关于劳动的政治经济学