📄 buyselfpage.cpp

📁 bookman电子图书馆
💻 CPP
字号:
// BuySelfPage.cpp : implementation file
//

#include "stdafx.h"
#include "bookMan.h"
#include "BuySelfPage.h"
#include "bookManView.h"
#include "MainFrm.h"
#include "AdoBind.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CBuySelfPage dialog


CBuySelfPage::CBuySelfPage(CWnd* pParent /*=NULL*/)
	: CDialog(CBuySelfPage::IDD, pParent)
{
	//{{AFX_DATA_INIT(CBuySelfPage)
//	m_doType = 0;
	//	m_DoTime = COleDateTime::GetCurrentTime();
	//	m_afterZheko = 0.0f;
	//	m_strAuthor = _T("none");
	//	m_strFrom = _T("none");
	//	m_strIsbn = _T("none");
	//	m_strBookName = _T("none");
	//	m_fPrice = 0.0f;
	//	m_fZheko = 100.0f;
	//	m_strType = _T("none");
	//	m_nBigType = 0;
	//	m_strPress = _T("none");
	//}}AFX_DATA_INIT
	InitData();
}


void CBuySelfPage::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CBuySelfPage)
	DDX_Control(pDX, IDC_BUYSELF_COMBO_BUYTYPE, m_buyType);
	DDX_Control(pDX, IDC_BUYSELF_BUTTON_SUBMIT, m_buy);
	DDX_Control(pDX, IDC_BUYSELF_BUTTON_SELF, m_self);
	DDX_Control(pDX, IDC_BUYSELF_BUTTON_MODIFY, m_modify);
	DDX_Control(pDX, IDC_BUYSELF_LIST_EXIST, m_exist);
	DDX_CBIndex(pDX, IDC_BUYSELFT_COMBO_DOTYPE, m_doType);
	DDX_DateTimeCtrl(pDX, IDC_BUYSELF_DATETIMEPICKER_BUYDATE, m_DoTime);
	DDX_Text(pDX, IDC_BUYSELF_EDIT_AFTERZHEKO, m_afterZheko);
	DDX_Text(pDX, IDC_BUYSELF_EDIT_AUTHOR, m_strAuthor);
	DDV_MaxChars(pDX, m_strAuthor, 10);
	DDX_Text(pDX, IDC_BUYSELF_EDIT_FROM, m_strFrom);
	DDV_MaxChars(pDX, m_strFrom, 20);
	DDX_Text(pDX, IDC_BUYSELF_EDIT_ISBN, m_strIsbn);
	DDV_MaxChars(pDX, m_strIsbn, 15);
	DDX_Text(pDX, IDC_BUYSELF_EDIT_NAME, m_strBookName);
	DDV_MaxChars(pDX, m_strBookName, 50);
	DDX_Text(pDX, IDC_BUYSELF_EDIT_PRICE, m_fPrice);
	DDX_Text(pDX, IDC_BUYSELF_EDIT_ZHEKO, m_fZheko);
	DDX_CBString(pDX, IDC_BUYSELF_COMBO_TYPE, m_strType);
	DDV_MaxChars(pDX, m_strType, 10);
	DDX_CBIndex(pDX, IDC_BUYSELF_COMBO_BUYTYPE, m_nBigType);
	DDX_CBString(pDX, IDC_BUYSELF_COMBO_PRESS, m_strPress);
	DDV_MaxChars(pDX, m_strPress, 30);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CBuySelfPage, CDialog)
	//{{AFX_MSG_MAP(CBuySelfPage)
	ON_WM_CTLCOLOR()
	ON_CBN_SELCHANGE(IDC_BUYSELFT_COMBO_DOTYPE, OnSelchangeBuyselftComboDotype)
	ON_BN_CLICKED(IDC_BUYSELF_BUTTON_SUBMIT, OnBuyselfButtonSubmit)
	ON_BN_CLICKED(IDC_BUYSELF_BUTTON_SELF, OnBuyselfButtonSelf)
	ON_EN_CHANGE(IDC_BUYSELF_EDIT_PRICE, OnChangeBuyselfEditPrice)
	ON_EN_CHANGE(IDC_BUYSELF_EDIT_ZHEKO, OnChangeBuyselfEditZheko)
	ON_NOTIFY(NM_CLICK, IDC_BUYSELF_LIST_EXIST, OnClickBuyselfListExist)
	ON_EN_CHANGE(IDC_BUYSELF_EDIT_NAME, OnChangeBuyselfEditName)
	ON_BN_CLICKED(IDC_BUYSELF_BUTTON_MODIFY, OnBuyselfButtonModify)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CBuySelfPage message handlers

HBRUSH CBuySelfPage::OnCtlColor(CDC* pDC, CWnd* pWnd, UINT nCtlColor) 
{
	HBRUSH hbr = CDialog::OnCtlColor(pDC, pWnd, nCtlColor);
	
	return hbr;
}

BOOL CBuySelfPage::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	//设置物种组合框的图像列表
	iBuyType.Create(16,16,TRUE,3,1);
	AddBitmap(IDB_BOOK);
	AddBitmap(IDB_CDROM);
	AddBitmap(IDB_PAPER);

	COMBOBOXEXITEM buyItem[3];
	LPTSTR pszText[3]={"书籍杂志","软件光盘","报刊读物"};
	for(int i=0;i<3;i++)
	{
		buyItem[i].mask=CBEIF_TEXT|CBEIF_IMAGE|CBEIF_SELECTEDIMAGE;
		buyItem[i].iItem=i;
		buyItem[i].pszText=pszText[i];
		buyItem[i].iImage=i;
		buyItem[i].iSelectedImage=i;
		m_buyType.InsertItem(&buyItem[i]);
	}
	m_buyType.SetCurSel(0);
	m_buyType.SetImageList(&iBuyType);

	brush.CreateSolidBrush(RGB(255,224,240));
	CRect tabRect;
	((CBookManView *)((CMainFrame *)AfxGetMainWnd())->GetActiveView())->m_tabCtrl.GetClientRect(&tabRect);
	SetWindowPos(NULL,0,0,tabRect.Width()-SP_RIGHT,tabRect.Height()-SP_BOTTOM,SWP_NOMOVE);
	CRect tabWindowRect;
	((CBookManView *)((CMainFrame *)AfxGetMainWnd())->GetActiveView())->m_tabCtrl.GetWindowRect(&tabWindowRect);
	CRect listWindowRect;
	m_exist.GetWindowRect(&listWindowRect);

	//设置列表控件的初始大小
	m_exist.SetWindowPos(NULL,0,0,tabWindowRect.right-listWindowRect.left-10,tabWindowRect.bottom-listWindowRect.top-10,SWP_NOMOVE);
	//向列表控件插入列
	m_exist.InsertColumn(0,"类别",LVCFMT_LEFT,50,0);
	m_exist.InsertColumn(1,"物种",LVCFMT_LEFT,100,1);
	m_exist.InsertColumn(2,"名称",LVCFMT_LEFT,130,2);
	m_exist.InsertColumn(3,"出版社",LVCFMT_LEFT,100,3);
	m_exist.InsertColumn(4,"类型",LVCFMT_LEFT,80,4);
	m_exist.InsertColumn(5,"作者",LVCFMT_LEFT,80,5);
	m_exist.InsertColumn(6,"价格",LVCFMT_LEFT,50,6);
	m_exist.InsertColumn(7,"拆扣",LVCFMT_LEFT,50,7);
	m_exist.InsertColumn(8,"拆后价",LVCFMT_LEFT,50,8);
	m_exist.InsertColumn(9,"ISBN编号",LVCFMT_LEFT,100,9);
	m_exist.InsertColumn(10,"供应商",LVCFMT_LEFT,100,10);
	m_exist.InsertColumn(11,"交易日期",LVCFMT_LEFT,80,11);
	//设置扩展属性
	m_exist.SetExtendedStyle(LVS_EX_FULLROWSELECT|
		LVS_EX_GRIDLINES|LVS_EX_TRACKSELECT);
	
	RefreshData();
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CBuySelfPage::OnSelchangeBuyselftComboDotype() 
{
	UpdateData();
	if(m_doType==0)			//购入
	{
		m_buy.EnableWindow(TRUE);
		m_self.EnableWindow(FALSE);
		m_modify.EnableWindow(FALSE);
	}
	else if(m_doType==1)	//卖出
	{
		m_buy.EnableWindow(FALSE);
		m_self.EnableWindow(TRUE);
		m_modify.EnableWindow(FALSE);
	}
	InitData();
}

void CBuySelfPage::AddBitmap(UINT nID)
{
	BOOL breturn;
	CBitmap bm;
	breturn=bm.LoadBitmap(nID);
	if(breturn)
	{
		iBuyType.Add(&bm,RGB(255,255,255));
		bm.DeleteObject();
	}
}

void CBuySelfPage::OnBuyselfButtonSubmit() 
{
	UpdateData();
	//_RecordsetPtr pRst=NULL;
	CString strQuery,strDoType,strBigtype,strDoDate,strPrice,strZheko,strAfterZheko;
	if(m_doType==0)
		strDoType="购入";
	else
		strDoType="卖出";
	//m_afterZheko=(m_fPrice*m_fZheko)/100;
	if(m_nBigType==0)
		strBigtype="书籍杂志";
	else if(m_nBigType==1)
		strBigtype="软件光盘";
	else
		strBigtype="报刊读物";
	strDoDate=m_DoTime.Format("%Y-%m-%d");
	strPrice.Format("%5.2f",m_fPrice);
	strZheko.Format("%4.2f",m_fZheko);
	strAfterZheko.Format("%5.2f",m_afterZheko);
	strQuery="insert into BUY(FLAG,BIGTYPE,NAME,CBS,TYPE,AUTHOR,PRICE,PREFERENTIAL,AFTERPREFE,ISBN,SUPPLY,DOTIME) values('" \
		+strDoType+"','"+strBigtype+"','"+m_strBookName+"','"+m_strPress+"','"+m_strType+"','"+m_strAuthor+"'," \
		+strPrice+","+strZheko+","+strAfterZheko+",'"+m_strIsbn+"','"+m_strFrom+"','"+strDoDate+"')";
	//AfxMessageBox(strQuery);
	try{
		//TESTHR(pRst.CreateInstance("ADODB.Recordset"));
		//pRst->Open(strQuery.AllocSysString(),pConn.GetInterfacePtr(),adOpenStatic,adLockOptimistic,adCmdText);
		pConn->Execute(strQuery.AllocSysString(),NULL,adModeUnknown);
	}
	catch(_com_error &e)
	{
		DisplayAdoError(e);
		return;
	}
	catch(...)
	{
		AfxMessageBox("未知错误");
		return;
	}
	InitData();
	UpdateData(FALSE);
	m_buy.EnableWindow(FALSE);
	RefreshData();
}

void CBuySelfPage::OnBuyselfButtonSelf() 
{
	if(m_exist.GetItemCount()==0)
	{
		m_self.EnableWindow(FALSE);
		m_modify.EnableWindow(FALSE);
		return;
	}
	UpdateData();
	CString strQuery,strDoTime;
	_RecordsetPtr pRst=NULL;
	strQuery="select * from buy where NAME='"+m_strBookName+"' and ISBN='"+m_strIsbn+"'";
	try{
		TESTHR(pRst.CreateInstance("ADODB.Recordset"));
		pRst->Open(strQuery.AllocSysString(),pConn.GetInterfacePtr(),adOpenStatic,adLockOptimistic,adCmdText);
		long count=pRst->GetRecordCount();
		if(count!=0){
			strDoTime=m_DoTime.Format("%Y-%m-%d");
			strQuery="update buy set FLAG='卖出',DOTIME='"+strDoTime+"' where NAME='"+m_strBookName+"' and ISBN='"+m_strIsbn+"'";
			pConn->Execute(strQuery.AllocSysString(),NULL,adModeUnknown);
		}
		pRst->Close();
	}
	catch(_com_error &e)
	{
		DisplayAdoError(e);
		return;
	}
	m_self.EnableWindow(FALSE);
	m_modify.EnableWindow(FALSE);
	InitData();
	UpdateData(FALSE);
	RefreshData();
}

void CBuySelfPage::OnBuyselfButtonModify() 
{
	if(m_exist.GetItemCount()==0)
	{
		m_self.EnableWindow(FALSE);
		m_modify.EnableWindow(FALSE);
		return;
	}
	
	CString strOldName,strOldIsbn,strQuery,strDoType,strBigtype,strDoDate,strPrice,strZheko,strAfterZheko;
	strOldName=m_strBookName;
	strOldIsbn=m_strIsbn;
	UpdateData();
	if(m_doType==0)
		strDoType="购入";
	else
		strDoType="卖出";
	//m_afterZheko=(m_fPrice*m_fZheko)/100;
	if(m_nBigType==0)
		strBigtype="书籍杂志";
	else if(m_nBigType==1)
		strBigtype="软件光盘";
	else
		strBigtype="报刊读物";
	strDoDate=m_DoTime.Format("%Y-%m-%d");
	strPrice.Format("%5.2f",m_fPrice);
	strZheko.Format("%4.2f",m_fZheko);
	strAfterZheko.Format("%5.2f",m_afterZheko);
	strQuery="update buy set FLAG='"+strDoType+"',BIGTYPE='"+strBigtype+"',NAME='"+m_strBookName+"',CBS='" \
		+m_strPress+"',TYPE='"+m_strPress+"',AUTHOR='"+m_strAuthor+"',PRICE='"+strPrice+"',PREFERENTIAL='" \
		+strZheko+"',AFTERPREFE='"+strAfterZheko+"',ISBN='"+m_strIsbn+"',SUPPLY='"+m_strFrom+"',DOTIME='"+strDoDate \
		+"' where NAME='"+strOldName+"' and ISBN='"+strOldIsbn+"'";
	try{
		pConn->Execute(strQuery.AllocSysString(),NULL,adModeUnknown);
	}
	catch(_com_error &e)
	{
		DisplayAdoError(e);
		return;
	}
	m_self.EnableWindow(FALSE);
	m_modify.EnableWindow(FALSE);
	InitData();
	UpdateData(FALSE);
	RefreshData();	
}

void CBuySelfPage::RefreshData()
{
	_RecordsetPtr pRst=NULL;
	IADORecordBinding *picRs=NULL;
	CAdoBind rs;
	m_exist.DeleteAllItems();
	try{
		TESTHR(pRst.CreateInstance("ADODB.Recordset"));
		pRst->Open("select * from buy",pConn.GetInterfacePtr(),adOpenStatic,adLockOptimistic,adCmdText);
		TESTHR(pRst->QueryInterface(__uuidof(IADORecordBinding),(LPVOID *)&picRs));
		TESTHR(picRs->BindToRecordset(&rs));
		int item=0;
		CString str;
		while(!pRst->adoEOF)
		{
			str.Format("%s",rs.m_szFlag);
			m_exist.InsertItem(item,str);
			str.Format("%s",rs.m_szBigType);
			m_exist.SetItemText(item,1,str);
			str.Format("%s",rs.m_szName);
			m_exist.SetItemText(item,2,str);
			str.Format("%s",rs.m_szCbs);
			m_exist.SetItemText(item,3,str);
			str.Format("%s",rs.m_szType);
			m_exist.SetItemText(item,4,str);
			str.Format("%s",rs.m_szAuthor);
			m_exist.SetItemText(item,5,str);
			str.Format("%5.2f",rs.m_fPrice);
			m_exist.SetItemText(item,6,str);
			str.Format("%4.2f",rs.m_fPreferential);
			m_exist.SetItemText(item,7,str);
			str.Format("%5.2f",rs.m_fAfterPrefe);
			m_exist.SetItemText(item,8,str);
			str.Format("%s",rs.m_szIsbn);
			m_exist.SetItemText(item,9,str);
			str.Format("%s",rs.m_szSupply);
			m_exist.SetItemText(item,10,str);
			str.Format("%s",rs.m_szDoTime);
			m_exist.SetItemText(item,11,str);
			item++;
			pRst->MoveNext();
		}
		picRs->Release();
		pRst->Close();
	}
	catch(_com_error &e)
	{
		DisplayAdoError(e);
		return;
	}
}

void CBuySelfPage::OnChangeBuyselfEditPrice() 
{
	UpdateData();
	m_afterZheko=(m_fPrice*	m_fZheko)/100;
	UpdateData(FALSE);
}

void CBuySelfPage::OnChangeBuyselfEditZheko() 
{
	UpdateData();
	m_afterZheko=(m_fPrice*	m_fZheko)/100;
	UpdateData(FALSE);
}

void CBuySelfPage::OnClickBuyselfListExist(NMHDR* pNMHDR, LRESULT* pResult) 
{
	if(m_exist.GetSelectedCount()==0)
	{
		m_buy.EnableWindow(TRUE);
		m_modify.EnableWindow(FALSE);
		m_self.EnableWindow(FALSE);
		return;
	}
	CString str;
	_variant_t vt;
	COleDateTime odt;
	int sel;
	sel=m_exist.GetSelectionMark();
	str=m_exist.GetItemText(sel,0);
	if(str=="购入")
		m_doType=0;
	else
		m_doType=1;
	str=m_exist.GetItemText(sel,1);
	if(str=="书籍杂志")
		m_nBigType=0;
	else if(str=="软件光盘")
		m_nBigType=1;
	else 
		m_nBigType=2;
	str=m_exist.GetItemText(sel,2);
	m_strBookName=str;
	str=m_exist.GetItemText(sel,3);
	m_strPress=str;
	str=m_exist.GetItemText(sel,4);
	m_strType=str;
	str=m_exist.GetItemText(sel,5);
	m_strAuthor=str;
	str=m_exist.GetItemText(sel,6);
	float temp=atof(str);
	m_fPrice=temp;
	str=m_exist.GetItemText(sel,7);
	temp=atof(str);
	m_fZheko=temp;
	str=m_exist.GetItemText(sel,8);
	temp=atof(str);
	m_afterZheko=temp;
	str=m_exist.GetItemText(sel,9);
	m_strIsbn=str;
	str=m_exist.GetItemText(sel,10);
	m_strFrom=str;
	str=m_exist.GetItemText(sel,11);
	vt=str;
	odt=vt;
	m_DoTime=odt;
	m_buy.EnableWindow(FALSE);
	m_modify.EnableWindow(TRUE);
	m_self.EnableWindow(TRUE);
	UpdateData(FALSE);
	
	*pResult = 0;
}

void CBuySelfPage::OnChangeBuyselfEditName() 
{
	m_buy.EnableWindow(TRUE);
}


void CBuySelfPage::InitData()
{
	m_doType = 0;
	m_DoTime = COleDateTime::GetCurrentTime();
	m_afterZheko = 0.0f;
	m_strAuthor = _T("none");
	m_strFrom = _T("none");
	m_strIsbn = _T("none");
	m_strBookName = _T("none");
	m_fPrice = 0.0f;
	m_fZheko = 100.0f;
	m_strType = _T("none");
	m_nBigType = 0;
	m_strPress = _T("none");
}
⌨️ 快捷键说明

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