saleinfo.cpp

一个ＶＣ写的药品管理系统

// SaleInfo.cpp : implementation file
//

#include "stdafx.h"
#include "medicine.h"
#include "SaleInfo.h"
#include "_recordset.h"
#include "COMDEF.H"
#include "MediInfo.h"

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

/////////////////////////////////////////////////////////////////////////////
// CSaleInfo dialog


CSaleInfo::CSaleInfo(CWnd* pParent /*=NULL*/)
	: CDialog(CSaleInfo::IDD, pParent)
{
	//{{AFX_DATA_INIT(CSaleInfo)
	m_FindInfo = _T("");
	//}}AFX_DATA_INIT
}


void CSaleInfo::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CSaleInfo)
	DDX_Control(pDX, IDC_FINDTYPE, m_Type);
	DDX_Control(pDX, IDC_ADODC1, m_Adodc);
	DDX_Control(pDX, IDC_DATAGRID1, m_DataGrid);
	DDX_Text(pDX, IDC_FINDINFO, m_FindInfo);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CSaleInfo, CDialog)
	//{{AFX_MSG_MAP(CSaleInfo)
	ON_BN_CLICKED(IDC_EXACTFIND, OnExactFind)
	ON_BN_CLICKED(IDC_LIKEFIND, OnLikeFind)
	ON_BN_CLICKED(IDC_BACK, OnBack)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CSaleInfo message handlers

int CSaleInfo::DoModal() 
{
	// TODO: Add your specialized code here and/or call the base class
	
	return CDialog::DoModal();
}

BOOL CSaleInfo::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	CTime t = CTime::GetCurrentTime();
	m_Type.SetCurSel(0);
    UpdateData(FALSE);//把变量信息及时更新到控件上
	RefreshData();
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CSaleInfo::RefreshData()
{
	UpdateData(TRUE);// 将控件上的信息及时更新到对应的变量
	/*	//销售记录
	CString SaleId,SaleDate;
	float MediAmout;
	int PayType;*/
	CString cSql;
	cSql = "select  SaleInfo.SaleId as'销售编号',MediInfo.MediId as'药品编号',MediInfo.MediName as";
	cSql+="'药品名称',MediInfo.Short as'药品简称', MediInfo.MediPrice as ";
	cSql+="'售价', SaleInfo.MediAmout as'数量',SaleInfo.VipDisc as'折扣', SaleInfo.PayType as";
	cSql+="'付款类型',SaleInfo.SaleDate as'销售日期' from SaleInfo,MediInfo where SaleInfo.MediId=MediInfo.MediId";
	m_Adodc.SetRecordSource(cSql);
	m_Adodc.Refresh();

	//	MessageBox(cSql);
	m_Adodc.SetRecordSource((LPCTSTR)(_bstr_t)cSql);
	m_Adodc.Refresh();

}

void CSaleInfo::OnExactFind() 
{
	// TODO: Add your control notification handler code here
	/*全部
按销售编号
按药名
按药品简码
按药品编号
按销售日期*/
	UpdateData(TRUE);
	CString cSql;
	cSql = "select  SaleInfo.SaleId as'销售编号',MediInfo.MediId as'药品编号',MediInfo.MediName as";
	cSql+="'药品名称',MediInfo.Short as'药品简称', MediInfo.MediPrice as ";
	cSql+="'售价', SaleInfo.MediAmout as'数量',SaleInfo.VipDisc as'折扣', SaleInfo.PayType as";
	cSql+="'付款类型',SaleInfo.SaleDate as'销售日期' from SaleInfo,MediInfo where SaleInfo.MediId=MediInfo.MediId";
	m_Adodc.SetRecordSource(cSql);

	if(m_FindInfo!="")
	{
		if(m_Type.GetCurSel()==1)
		{
			cSql += " and SaleInfo.SaleId ='"+m_FindInfo+"'";
		}
		else if(m_Type.GetCurSel()==2)
		{
			cSql += " and MediInfo.MediName = '"+m_FindInfo+"'";
		}
		else if(m_Type.GetCurSel()==3)
		{
			cSql += " and MediInfo.Short = '"+m_FindInfo+"'";
		}
		else if(m_Type.GetCurSel()==4)
		{
			cSql += " and MediInfo.MediId='"+m_FindInfo+"'";
		}
		else if(m_Type.GetCurSel()==5)
		{
			cSql += " and SaleInfo.SaleDate='"+m_FindInfo+"'";
		}
	}
	m_Adodc.SetRecordSource(cSql);
	m_Adodc.Refresh();
}

void CSaleInfo::OnLikeFind() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	CString cSql;
	cSql = "select  SaleInfo.SaleId as'销售编号',MediInfo.MediId as'药品编号',MediInfo.MediName as";
	cSql+="'药品名称',MediInfo.Short as'药品简称', MediInfo.MediPrice as ";
	cSql+="'售价', SaleInfo.MediAmout as'数量',SaleInfo.VipDisc as'折扣', SaleInfo.PayType as";
	cSql+="'付款类型',SaleInfo.SaleDate as'销售日期' from SaleInfo,MediInfo where SaleInfo.MediId=MediInfo.MediId";
	if(m_FindInfo!="")
	{
		if(m_Type.GetCurSel()==1)
		{
			cSql += " and SaleInfo.SaleId ='"+m_FindInfo+"'";
		}
		else if(m_Type.GetCurSel()==2)
		{
			cSql += " and MediInfo.MediName = '"+m_FindInfo+"'";
		}
		else if(m_Type.GetCurSel()==3)
		{
			cSql += " and MediInfo.Short = '"+m_FindInfo+"'";
		}
		else if(m_Type.GetCurSel()==4)
		{
			cSql += " and MediInfo.MediId='"+m_FindInfo+"'";
		}
		else if(m_Type.GetCurSel()==5)
		{
			MessageBox("无法对日期进行模糊查找");
		}
	}
	m_Adodc.SetRecordSource(cSql);
	m_Adodc.Refresh();
}

void CSaleInfo::OnBack() 
{
	// TODO: Add your control notification handler code here
	CMediInfo mi;
	mi.SaleId=m_DataGrid.GetItem(0);
	mi.sql_deleteSale();
	MessageBox("退药成功");
	RefreshData();
}