📄 invoice.cpp

📁 基于VC+SQL SERVER环境开发的企业商品销售系统.完整的数据库和原代码
💻 CPP
📖 第 1 页 / 共 3 页
字号:
12 3 下一页
// Invoice.cpp : implementation file
//

#include "stdafx.h"
#include "Sale.h"
#include "Invoice.h"
#include "Affirm.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CInvoice dialog


CInvoice::CInvoice(CWnd* pParent /*=NULL*/)
	: CDialog(CInvoice::IDD, pParent)
{
	//{{AFX_DATA_INIT(CInvoice)
	m_clientName = _T("");
	m_department = _T("");
	m_formDate = COleDateTime::GetCurrentTime();
	m_saleType = _T("");
	m_seller = _T("");
	m_payCondition = _T("");
	m_taxNO = _T("");
	m_bank = _T("");
	m_account = _T("");
	m_remark = _T("");
	m_invoiceID = _T("");
	invoiceID = _T("");
	//}}AFX_DATA_INIT
}


void CInvoice::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CInvoice)
	DDX_Control(pDX, IDC_payCondition, m_payConditionCombo);
	DDX_Control(pDX, IDC_seller, m_sellerCombo);
	DDX_Control(pDX, IDC_saleType, m_saleTypeCombo);
	DDX_Control(pDX, IDC_department, m_departmentCombo);
	DDX_Control(pDX, IDC_clientName, m_clientCombo);
	DDX_Control(pDX, IDC_LIST1, m_invoiceCommidityList);
	DDX_CBString(pDX, IDC_clientName, m_clientName);
	DDX_CBString(pDX, IDC_department, m_department);
	DDX_DateTimeCtrl(pDX, IDC_formDate, m_formDate);
	DDX_CBString(pDX, IDC_saleType, m_saleType);
	DDX_CBString(pDX, IDC_seller, m_seller);
	DDX_CBString(pDX, IDC_payCondition, m_payCondition);
	DDX_Text(pDX, IDC_taxNO, m_taxNO);
	DDX_Text(pDX, IDC_bank, m_bank);
	DDX_Text(pDX, IDC_account, m_account);
	DDX_Text(pDX, IDC_remark, m_remark);
	DDX_Text(pDX, IDC_invoiceID, m_invoiceID);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CInvoice, CDialog)
	//{{AFX_MSG_MAP(CInvoice)
	ON_BN_CLICKED(IDC_firstPage, OnFirstPage)
	ON_BN_CLICKED(IDC_prevPage, OnPrevPage)
	ON_BN_CLICKED(IDC_nextPage, OnNextPage)
	ON_BN_CLICKED(IDC_lastPage, OnLastPage)
	ON_BN_CLICKED(IDC_new, OnNew)
	ON_BN_CLICKED(IDC_modify, OnModify)
	ON_BN_CLICKED(IDC_delete, OnDelete)
	ON_BN_CLICKED(IDC_addLine, OnAddLine)
	ON_BN_CLICKED(IDC_deleteLine, OnDeleteLine)
	ON_BN_CLICKED(IDC_save, OnSave)
	ON_BN_CLICKED(IDC_cancellation, OnCancellation)
	ON_BN_CLICKED(IDC_auditing, OnAuditing)
	ON_BN_CLICKED(IDC_exit, OnExit)
	ON_NOTIFY(NM_CLICK, IDC_LIST1, OnClickList)
	ON_CBN_SELCHANGE(IDC_clientName, OnSelchangeClientName)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CInvoice message handlers

void CInvoice::OnFirstPage() 
{
	UpdateData(true);
	_RecordsetPtr m_pRecordset;
	CString strSQL;
	HRESULT hTRes;
	try
	{	
		m_pInvoiceRecordset->MoveFirst();		
		if (!(m_pInvoiceRecordset->adoEOF))
		{
			m_clientName=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("clientName"));
			m_department=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("department"));
			DATE dt;
			COleDateTime da;
			dt=m_pInvoiceRecordset->GetCollect("formDate").date;
			da=COleDateTime(dt); 
			m_formDate.SetDate(da.GetYear(),da.GetMonth(),da.GetDay());
			m_saleType=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("saleType"));
			m_seller=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("seller"));
			m_payCondition=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("payCondition"));
			m_taxNO=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("taxNO"));
			m_bank=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("bank"));
			m_account=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("account"));
			m_remark=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("remark"));
			m_invoiceID=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("invoiceID"));		
		
			CString checked;
			checked=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("checked"));
			if(checked=="T")
			{
				bt_modify->EnableWindow(false);
				SetDlgItemText(IDC_auditing,"弃审");
			}
			else
			{
				bt_modify->EnableWindow(true);
				SetDlgItemText(IDC_auditing,"审核");
			}

			strSQL="select * from invoiceCommidity where invoiceID='";
			strSQL=strSQL+((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("invoiceID"));
			strSQL+="'";
		}

		hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));
		hTRes = m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
				((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
				adOpenDynamic,adLockPessimistic,adCmdText);
		int i=0;
		m_invoiceCommidityList.DeleteAllItems();
		while(!(m_pRecordset->adoEOF))
		{
			m_invoiceCommidityList.InsertItem(i,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("consignmentFormID")));
			m_invoiceCommidityList.SetItemText(i,1,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("commidityID")));				
			m_invoiceCommidityList.SetItemText(i,2,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("commidityName")));
			m_invoiceCommidityList.SetItemText(i,3,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("standard")));				
			m_invoiceCommidityList.SetItemText(i,4,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("model")));
			m_invoiceCommidityList.SetItemText(i,5,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("num")));
			m_invoiceCommidityList.SetItemText(i,6,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("price")));				
			m_invoiceCommidityList.SetItemText(i,7,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("total")));
			
			if (!(m_pRecordset->adoEOF))
			{
				m_pRecordset->MoveNext();
				i++;
			}
		}
	}
	catch(_com_error e)///捕捉异常
	{
		bt_lastPage->EnableWindow(false);
		bt_nextPage->EnableWindow(false);
		AfxMessageBox("已经到达纪录集的shou部！");
	}

	bt_firstPage->EnableWindow(true);
	bt_prevPage->EnableWindow(true);
	UpdateData(false);
	
}

void CInvoice::OnPrevPage() 
{
	UpdateData(true);
	_RecordsetPtr m_pRecordset;
	CString strSQL;
	HRESULT hTRes;
	try
	{	
		m_pInvoiceRecordset->MovePrevious();		
		if (!(m_pInvoiceRecordset->adoEOF))
		{
			m_clientName=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("clientName"));
			m_department=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("department"));
			DATE dt;
			COleDateTime da;
			dt=m_pInvoiceRecordset->GetCollect("formDate").date;
			da=COleDateTime(dt); 
			m_formDate.SetDate(da.GetYear(),da.GetMonth(),da.GetDay());
			m_saleType=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("saleType"));
			m_seller=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("seller"));
			m_payCondition=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("payCondition"));
			m_taxNO=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("taxNO"));
			m_bank=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("bank"));
			m_account=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("account"));
			m_remark=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("remark"));
			m_invoiceID=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("invoiceID"));		
		
			CString checked;
			checked=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("checked"));
			if(checked=="T")
			{
				bt_modify->EnableWindow(false);
				SetDlgItemText(IDC_auditing,"弃审");
			}
			else
			{
				bt_modify->EnableWindow(true);
				SetDlgItemText(IDC_auditing,"审核");
			}

			strSQL="select * from invoiceCommidity where invoiceID='";
			strSQL=strSQL+((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("invoiceID"));
			strSQL+="'";
		}

		hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));
		hTRes = m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
				((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
				adOpenDynamic,adLockPessimistic,adCmdText);
		int i=0;
		m_invoiceCommidityList.DeleteAllItems();
		while(!(m_pRecordset->adoEOF))
		{
			m_invoiceCommidityList.InsertItem(i,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("consignmentFormID")));
			m_invoiceCommidityList.SetItemText(i,1,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("commidityID")));				
			m_invoiceCommidityList.SetItemText(i,2,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("commidityName")));
			m_invoiceCommidityList.SetItemText(i,3,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("standard")));				
			m_invoiceCommidityList.SetItemText(i,4,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("model")));
			m_invoiceCommidityList.SetItemText(i,5,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("num")));
			m_invoiceCommidityList.SetItemText(i,6,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("price")));				
			m_invoiceCommidityList.SetItemText(i,7,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("total")));
			
			if (!(m_pRecordset->adoEOF))
			{
				m_pRecordset->MoveNext();
				i++;
			}
		}
	}
	catch(_com_error e)///捕捉异常
	{
		bt_firstPage->EnableWindow(false);
		bt_prevPage->EnableWindow(false);
		AfxMessageBox("已经到达纪录集的shou部！");
		m_pInvoiceRecordset->MoveNext();
	}
	bt_nextPage->EnableWindow(true);
	bt_lastPage->EnableWindow(true);

	UpdateData(false);
	
}

void CInvoice::OnNextPage() 
{
	UpdateData(true);
	_RecordsetPtr m_pRecordset;
	CString strSQL;
	HRESULT hTRes;
	try
	{	
		m_pInvoiceRecordset->MoveNext();		
		if (!(m_pInvoiceRecordset->adoEOF))
		{
			m_clientName=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("clientName"));
			m_department=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("department"));
			DATE dt;
			COleDateTime da;
			dt=m_pInvoiceRecordset->GetCollect("formDate").date;
			da=COleDateTime(dt); 
			m_formDate.SetDate(da.GetYear(),da.GetMonth(),da.GetDay());
			m_saleType=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("saleType"));
			m_seller=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("seller"));
			m_payCondition=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("payCondition"));
			m_taxNO=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("taxNO"));
			m_bank=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("bank"));
			m_account=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("account"));
			m_remark=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("remark"));
			m_invoiceID=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("invoiceID"));		
		
			CString checked;
			checked=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("checked"));
			if(checked=="T")
			{
				bt_modify->EnableWindow(false);
				SetDlgItemText(IDC_auditing,"弃审");
			}
			else
			{
				bt_modify->EnableWindow(true);
				SetDlgItemText(IDC_auditing,"审核");
			}
			strSQL="select * from invoiceCommidity where invoiceID='";
			strSQL=strSQL+((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("invoiceID"));
			strSQL+="'";
		}

		hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));
		hTRes = m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
				((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
				adOpenDynamic,adLockPessimistic,adCmdText);
		int i=0;
		m_invoiceCommidityList.DeleteAllItems();
		while(!(m_pRecordset->adoEOF))
		{			
			m_invoiceCommidityList.InsertItem(i,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("consignmentFormID")));
			m_invoiceCommidityList.SetItemText(i,1,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("commidityID")));				
			m_invoiceCommidityList.SetItemText(i,2,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("commidityName")));
			m_invoiceCommidityList.SetItemText(i,3,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("standard")));				
			m_invoiceCommidityList.SetItemText(i,4,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("model")));
			m_invoiceCommidityList.SetItemText(i,5,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("num")));
			m_invoiceCommidityList.SetItemText(i,6,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("price")));				
			m_invoiceCommidityList.SetItemText(i,7,((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("total")));
			
			if (!(m_pRecordset->adoEOF))
			{
				m_pRecordset->MoveNext();
				i++;
			}
		}
	}
	catch(_com_error e)///捕捉异常
	{
		bt_lastPage->EnableWindow(false);
		bt_nextPage->EnableWindow(false);
		m_pInvoiceRecordset->MovePrevious();
		AfxMessageBox("已经到达纪录集的尾部！");
	}

	bt_firstPage->EnableWindow(true);
	bt_prevPage->EnableWindow(true);
	UpdateData(false);
	
}

void CInvoice::OnLastPage() 
{
	UpdateData(true);
	_RecordsetPtr m_pRecordset;
	CString strSQL;
	HRESULT hTRes;
	try
	{	
		m_pInvoiceRecordset->MoveLast();		
		if (!(m_pInvoiceRecordset->adoEOF))
		{
			m_clientName=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("clientName"));
			m_department=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("department"));
			DATE dt;
			COleDateTime da;
			dt=m_pInvoiceRecordset->GetCollect("formDate").date;
			da=COleDateTime(dt); 
			m_formDate.SetDate(da.GetYear(),da.GetMonth(),da.GetDay());
			m_saleType=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("saleType"));
			m_seller=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("seller"));
			m_payCondition=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("payCondition"));
			m_taxNO=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("taxNO"));
			m_bank=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("bank"));
			m_account=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("account"));
			m_remark=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("remark"));
			m_invoiceID=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("invoiceID"));		
		
			CString checked;
			checked=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pInvoiceRecordset->GetCollect("checked"));
			if(checked=="T")
12 3 下一页
💿 文件大小 869 K
👤 上传用户 lxwcqq
📂 所属分类数据库系统
🏷️ 相关标签

#SERVER #SQL #VC #环境
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -