stockenterdata.cpp

一个简易的医药销售管理系统源码

// StockEnterData.cpp : 实现文件
//

#include "stdafx.h"
#include "MedicineSaleManages.h"
#include "StockEnterData.h"
#include ".\stockenterdata.h"


// CStockEnterData 对话框

IMPLEMENT_DYNAMIC(CStockEnterData, CDialog)
CStockEnterData::CStockEnterData(CWnd* pParent /*=NULL*/)
	: CDialog(CStockEnterData::IDD, pParent)
	, select(_T(""))
{
}

CStockEnterData::~CStockEnterData()
{
}

void CStockEnterData::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	DDX_Control(pDX, IDC_LIST1, m_list1);
}


BEGIN_MESSAGE_MAP(CStockEnterData, CDialog)
	ON_BN_CLICKED(IDOK, OnBnClickedOk)
	ON_BN_CLICKED(IDCANCEL, OnBnClickedCancel)
	ON_LBN_SELCHANGE(IDC_LIST1, OnLbnSelchangeList1)
END_MESSAGE_MAP()


// CStockEnterData 消息处理程序

void CStockEnterData::OnBnClickedOk()
{
	if(m_list1.GetCurSel()<0)
	{
		AfxMessageBox("必须选择日期值,否则请单击取消!");
		return;
	}
	else
	{
		m_list1.GetText(m_list1.GetCurSel(),select);
		m_pRecordset.CreateInstance(_T("ADODB.Recordset"));
		CString strSQL="SELECT writed FROM entergoods where g_id='";
		strSQL+=select;
		strSQL+="'";//得到关键字日期以备查询用
		m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(strSQL.GetLength()+1),
			((CMedicineSaleManagesApp*)AfxGetApp())->m_pConn1.GetInterfacePtr(),
			adOpenDynamic,adLockPessimistic,adCmdText);
		_variant_t var;
		var = m_pRecordset->GetCollect("writed");
		if(var.boolVal)
		{
			AfxMessageBox("此日期的数据已经传入,不能重复传入!");
			m_pRecordset->Close();
			m_pRecordset=NULL;
			return;
		}
		m_pRecordset->Close();
		m_pRecordset=NULL;
	}
	OnOK();
}

void CStockEnterData::OnBnClickedCancel()
{
	// TODO: 在此添加控件通知处理程序代码
	OnCancel();
}

BOOL CStockEnterData::OnInitDialog()
{
	CDialog::OnInitDialog();
	CString str;
	CString strSQL;
	strSQL="select DISTINCT g_id from entergoods";
	m_pRecordset.CreateInstance(_T("ADODB.Recordset"));
	m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(strSQL.GetLength()+1),
			((CMedicineSaleManagesApp*)AfxGetApp())->m_pConn1.GetInterfacePtr(),
			adOpenDynamic,adLockPessimistic,adCmdText);
	while(!(m_pRecordset->adoEOF))
	{
		str=(LPCSTR)_bstr_t(m_pRecordset->GetCollect("g_id"));
		if(!str.IsEmpty())
			m_list1.AddString(str);
		if(!(m_pRecordset->adoEOF))
			m_pRecordset->MoveNext();
	}
	m_pRecordset->Close();
	m_pRecordset=NULL;
	int row=m_list1.GetCount();
	for(int r=0;r<row;r++)
		m_list1.SetItemHeight(r,18);
	return TRUE;
}

BOOL CStockEnterData::PreTranslateMessage(MSG* pMsg)
{
	// TODO: 在此添加专用代码和/或调用基类

	return CDialog::PreTranslateMessage(pMsg);
}

void CStockEnterData::WinHelp(DWORD dwData, UINT nCmd)
{
}

void CStockEnterData::OnLbnSelchangeList1()
{
	CString str;
	m_list1.GetText(m_list1.GetCurSel(),str);
	m_pRecordset.CreateInstance(_T("ADODB.Recordset"));
	CString strSQL="SELECT writed FROM entergoods where g_id='";
	strSQL+=str;
	strSQL+="'";//得到关键字日期以备查询用
	m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(strSQL.GetLength()+1),
		((CMedicineSaleManagesApp*)AfxGetApp())->m_pConn1.GetInterfacePtr(),
		adOpenDynamic,adLockPessimistic,adCmdText);
	_variant_t var;
	var = m_pRecordset->GetCollect("writed");
	if(var.boolVal)
		AfxMessageBox("此日期的数据已经传入,不能重复传入!");
	m_pRecordset->Close();
	m_pRecordset=NULL;
}