clientinfor.cpp

基于VC+SQL SERVER环境开发的企业商品销售系统.完整的数据库和原代码

// ClientInfor.cpp : implementation file
//

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

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

/////////////////////////////////////////////////////////////////////////////
// CClientInfor dialog


CClientInfor::CClientInfor(CWnd* pParent /*=NULL*/)
	: CDialog(CClientInfor::IDD, pParent)
{
	//{{AFX_DATA_INIT(CClientInfor)
	m_bookinDate = COleDateTime::GetCurrentTime();
	m_clientID = _T("");
	m_clientLevel = _T("");
	m_clientType = _T("");
	m_company = _T("");
	m_contactPerson = _T("");
	m_area = _T("");
	m_address = _T("");
	m_postcode = _T("");
	m_telephone = _T("");
	m_fax = _T("");
	m_eMail = _T("");
	m_remark = _T("");
	m_manageRange = _T("");
	m_manageProduct = _T("");
	m_accountBank = _T("");
	m_acount = _T("");
	m_taxNO = _T("");
	m_registerDate = COleDateTime::GetCurrentTime();
	m_registerFund = 0.0;
	m_scale = _T("");
	m_industryCharacter = _T("");
	m_allFunds = 0.0;
	m_clientCharacter = _T("");
	//}}AFX_DATA_INIT
}


void CClientInfor::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CClientInfor)
	DDX_Control(pDX, IDC_area, m_areaCombo);
	DDX_Control(pDX, IDC_clientType, m_clientTypeCombo);
	DDX_Control(pDX, IDC_clientLevel, m_clientLevelCombo);
	DDX_Control(pDX, IDC_LIST2, m_clientList);
	DDX_Text(pDX, IDC_bookinDate, m_bookinDate);
	DDX_Text(pDX, IDC_clientID, m_clientID);
	DDX_CBString(pDX, IDC_clientLevel, m_clientLevel);
	DDX_CBString(pDX, IDC_clientType, m_clientType);
	DDX_Text(pDX, IDC_company, m_company);
	DDX_Text(pDX, IDC_contactPerson, m_contactPerson);
	DDX_CBString(pDX, IDC_area, m_area);
	DDX_Text(pDX, IDC_address, m_address);
	DDX_Text(pDX, IDC_postcode, m_postcode);
	DDX_Text(pDX, IDC_telephone, m_telephone);
	DDX_Text(pDX, IDC_fax, m_fax);
	DDX_Text(pDX, IDC_eMail, m_eMail);
	DDX_Text(pDX, IDC_remark, m_remark);
	DDX_Text(pDX, IDC_manageRange, m_manageRange);
	DDX_Text(pDX, IDC_manageProduct, m_manageProduct);
	DDX_Text(pDX, IDC_accountBank, m_accountBank);
	DDX_Text(pDX, IDC_accounts, m_acount);
	DDX_Text(pDX, IDC_taxNO, m_taxNO);
	DDX_Text(pDX, IDC_registerDate, m_registerDate);
	DDX_Text(pDX, IDC_registerFund, m_registerFund);
	DDX_Text(pDX, IDC_scale, m_scale);
	DDX_CBString(pDX, IDC_industryCharacter, m_industryCharacter);
	DDX_Text(pDX, IDC_allFunds, m_allFunds);
	DDX_CBString(pDX, IDC_clientCharacter, m_clientCharacter);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CClientInfor, CDialog)
	//{{AFX_MSG_MAP(CClientInfor)
	ON_BN_CLICKED(IDC_BUTTON2, OnAdd)
	ON_BN_CLICKED(IDC_BUTTON3, OnDelete)
	ON_BN_CLICKED(IDC_BUTTON4, OnModify)
	ON_BN_CLICKED(IDC_BUTTON5, OnSave)
	ON_BN_CLICKED(IDC_BUTTON6, OnExit)
	ON_NOTIFY(NM_CLICK, IDC_LIST2, OnClickClientList)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CClientInfor message handlers

void CClientInfor::OnAdd() 
{
	UpdateData(true);
	m_bookinDate = COleDateTime::GetCurrentTime();
	int clientID=((CSaleApp*)AfxGetApp())->m_pIDRecordset->GetCollect("clientID").intVal;
	if(clientID<10)
		m_clientID.Format("client0000%d",clientID);
	else if(clientID<100&&clientID>9)
		m_clientID.Format("client000%d",clientID);
	else if(clientID<1000&&clientID>99)
		m_clientID.Format("client00%d",clientID);

	CString str;
	str.Format("%d",clientID+1);
	((CSaleApp*)AfxGetApp())->m_pIDRecordset->PutCollect("clientID",_variant_t(str));
	((CSaleApp*)AfxGetApp())->m_pIDRecordset->Update();
	// m_clientID = _T("");
	m_clientLevel = _T("");
	m_clientType = _T("");
	m_company = _T("");
	m_contactPerson = _T("");
	m_area = _T("");
	m_address = _T("");
	m_postcode = _T("");
	m_telephone = _T("");
	m_fax = _T("");
	m_eMail = _T("");
	m_remark = _T("");
	m_manageRange = _T("");
	m_manageProduct = _T("");
	m_accountBank = _T("");
	m_acount = _T("");
	m_taxNO = _T("");
	m_registerDate = COleDateTime::GetCurrentTime();
	m_registerFund = 0.0;
	m_scale = _T("");
	m_industryCharacter = _T("");
	m_allFunds = 0.0;
	m_clientCharacter = _T("");

	flag=1;

	tx_bookinDate->EnableWindow(false);
	tx_clientID->EnableWindow(false);
	tx_clientLevel->EnableWindow(true);
	tx_clientType->EnableWindow(true);
	tx_company->EnableWindow(true);
	tx_contactPerson->EnableWindow(true);
	tx_area->EnableWindow(true);
	tx_address->EnableWindow(true);
	tx_postcode->EnableWindow(true);
	tx_telephone->EnableWindow(true);
	tx_fax->EnableWindow(true);
	tx_eMail->EnableWindow(true);
	tx_remark->EnableWindow(true);
	tx_manageRange->EnableWindow(true);
	tx_manageProduct->EnableWindow(true);
	tx_accountBank->EnableWindow(true);
	tx_acount->EnableWindow(true);
	tx_taxNO->EnableWindow(true);
	tx_registerDate->EnableWindow(true);
	tx_registerFund->EnableWindow(true);
	tx_scale->EnableWindow(true);
	tx_industryCharacter->EnableWindow(true);
	tx_allFunds->EnableWindow(true);
	tx_clientCharacter->EnableWindow(true);

	bt_save->EnableWindow(true);
	bt_add->EnableWindow(false);
	bt_modify->EnableWindow(false);
	bt_delete->EnableWindow(false);
	UpdateData(false);	
	
}

void CClientInfor::OnDelete() 
{
	CAffirm dlg;
	if(dlg.DoModal()!=IDOK)
	{
		return;
	}
	_variant_t RecordsAffected;
	CString strSQL;
	strSQL="delete from client where clientID='";
	strSQL=strSQL+m_clientID+"'";
	(((CSaleApp*)AfxGetApp())->m_pConn)->Execute((_bstr_t)strSQL,&RecordsAffected,adCmdText);
	
	POSITION pos = m_clientList.GetFirstSelectedItemPosition();
	if(pos)
	{
		int nFirstSelItem = m_clientList.GetNextSelectedItem(pos);
		m_clientList.DeleteItem(nFirstSelItem);
	}	
	bt_delete->EnableWindow(false);
	m_bookinDate = COleDateTime::GetCurrentTime();
	m_clientID = _T("");
	m_clientLevel = _T("");
	m_clientType = _T("");
	m_company = _T("");
	m_contactPerson = _T("");
	m_area = _T("");
	m_address = _T("");
	m_postcode = _T("");
	m_telephone = _T("");
	m_fax = _T("");
	m_eMail = _T("");
	m_remark = _T("");
	m_manageRange = _T("");
	m_manageProduct = _T("");
	m_accountBank = _T("");
	m_acount = _T("");
	m_taxNO = _T("");
	m_registerDate = COleDateTime::GetCurrentTime();
	m_registerFund = 0.0;
	m_scale = _T("");
	m_industryCharacter = _T("");
	m_allFunds = 0.0;
	m_clientCharacter = _T("");

	UpdateData(false);
	
}

void CClientInfor::OnModify() 
{
	tx_bookinDate->EnableWindow(false);
	tx_clientID->EnableWindow(false);
	tx_clientLevel->EnableWindow(true);
	tx_clientType->EnableWindow(true);
	tx_company->EnableWindow(true);
	tx_contactPerson->EnableWindow(true);
	tx_area->EnableWindow(true);
	tx_address->EnableWindow(true);
	tx_postcode->EnableWindow(true);
	tx_telephone->EnableWindow(true);
	tx_fax->EnableWindow(true);
	tx_eMail->EnableWindow(true);
	tx_remark->EnableWindow(true);
	tx_manageRange->EnableWindow(true);
	tx_manageProduct->EnableWindow(true);
	tx_accountBank->EnableWindow(true);
	tx_acount->EnableWindow(true);
	tx_taxNO->EnableWindow(true);
	tx_registerDate->EnableWindow(true);
	tx_registerFund->EnableWindow(true);
	tx_scale->EnableWindow(true);
	tx_industryCharacter->EnableWindow(true);
	tx_allFunds->EnableWindow(true);
	tx_clientCharacter->EnableWindow(true);

	flag=2;
	bt_save->EnableWindow(true);
	
}

void CClientInfor::OnSave() 
{
	UpdateData(true);
	_RecordsetPtr m_pRecordset;    


	CString strSQL;

	if(flag==1)         //添加
	{
		strSQL="SELECT * FROM client" ;	

		try
		{
			HRESULT hTRes;
			hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));
			if (SUCCEEDED(hTRes))