queryfree.cpp

CT工作站具有打印报告、病历管理、图像处理专家词库等功能

// QueryFree.cpp : implementation file
// 

#include "stdafx.h"
#include "bxt.h"
#include "QueryFree.h"
#include "bxtDlg.h"
#include "Query.h"
#include "QueryOrder.h"

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

/////////////////////////////////////////////////////////////////////////////
// QueryFree dialog


QueryFree::QueryFree(CWnd* pParent /*=NULL*/)
	: CDialog(QueryFree::IDD, pParent)
{
	//{{AFX_DATA_INIT(QueryFree)
	m_name				= _T("");
	m_sex				= _T("");
	m_class				= _T("");
	m_illname			= _T("");
	m_checkpos			= _T("");
	m_age1				= _T("");
	m_age2				= _T("");
	m_age3				= _T("");
	//}}AFX_DATA_INIT
	m_pCfg				= ((CBxtApp *)(AfxGetApp()))->GetConfig();
}

void
QueryFree::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(QueryFree)
	DDX_Text(pDX, IDC_EDIT1, m_name);
	DDX_Text(pDX, IDC_EDIT2, m_sex);
	DDX_Text(pDX, IDC_EDIT6, m_class);
	DDX_Text(pDX, IDC_EDIT8, m_illname);
	DDX_Text(pDX, IDC_EDIT9, m_checkpos);
	DDX_Text(pDX, IDC_EDIT3, m_age1);
	DDX_Text(pDX, IDC_EDIT4, m_age2);
	DDX_Text(pDX, IDC_EDIT5, m_age3);
	//}}AFX_DATA_MAP
}

BEGIN_MESSAGE_MAP(QueryFree, CDialog)
	//{{AFX_MSG_MAP(QueryFree)
	ON_BN_CLICKED(IDC_BUTTON_QUERY, OnButtonQuery)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// QueryFree message handlers

BOOL
QueryFree::OnInitDialog() 
{
	CDialog::OnInitDialog();

	m_btnQuery.SubclassDlgItem(IDC_BUTTON_QUERY, this);
	m_btnQuery.SetIcon(IDI_ICON_QUERY, 96, 32);
	m_btnQuery.SetMouseOnColor(RGB(255, 0, 255));
	m_btnQuery.SetPressColor(RGB(0, 0, 255));
	m_btnQuery.SetWindowText("");
	
	return	(TRUE);
}

void
QueryFree::OnButtonQuery() 
{
	if	(m_pCfg->iUiType == UI_TYPE_SIMPLE)
	{
		SimpleQuery();
	}
	else
	{
		NormalQuery();
	}
}

BOOL
QueryFree::NormalQuery()
{
	CString datawhere = ((CBxtDlg *)AfxGetMainWnd())->querytime->MakeDataSQL();
	CString	sWhere;
	int age1,age2,age3,baselen;
	char buf[10];

	sWhere	= "WHERE ";

	baselen	= sWhere.GetLength();
	if (!datawhere.IsEmpty())
	{
		sWhere += datawhere;
		sWhere += " AND ";
	}
	
	UpdateData(true);
	
	// 年龄大于
	if (!m_age1.IsEmpty())
	{
		age1 = atoi(m_age1);
		m_age1 = itoa(age1,buf,10);
		sWhere += " AGE>";
		sWhere += m_age1;
		sWhere += " AND ";
	}

	// 年龄等于
	if (!m_age2.IsEmpty())
	{
		age2 = atoi(m_age2);
		m_age2 = itoa(age2,buf,10);
		sWhere += " AGE=";
		sWhere += m_age2;
		sWhere += " AND ";
	}

	// 年龄小于
	if (!m_age3.IsEmpty())
	{
		age3 = atoi(m_age3);
		m_age3 = itoa(age3,buf,10);
		sWhere += " AGE<";
		sWhere += m_age3;
		sWhere += " AND ";
	}

	// 检查部位
	if (!m_checkpos.IsEmpty())
	{
		sWhere += " CHECKPOS='";
		sWhere += m_checkpos;
		sWhere += "' AND ";
	}

	// 科别
	if (!m_class.IsEmpty())
	{
		sWhere += " CLASS='";
		sWhere += m_class;
		sWhere += "' AND ";
	}
	
	// 病名
	if (!m_illname.IsEmpty())
	{
		sWhere += " ILLNAME='";
		sWhere += m_illname;
		sWhere += "' AND ";
	}

	// 姓名
	if (!m_name.IsEmpty())
	{
		sWhere += " NAME LIKE '%";
		sWhere += m_name;
		sWhere += "%'";
		sWhere += " AND ";
	}

	// 性别
	if (!m_sex.IsEmpty())
	{
		sWhere += " SEX='";
		sWhere += m_sex;
		sWhere += "'";
		sWhere += " AND ";
	}

	UpdateData(false);

	if (sWhere.GetLength() == baselen)
	{
		sWhere = sWhere.Left(sWhere.GetLength() - 6);	// Get Rid Of "WHERE "
	}
	else
	{
		sWhere = sWhere.Left(sWhere.GetLength() - 4);	// Get Rid Of "AND ";
	}

	CString	sOrder;
	sOrder = ((CBxtDlg *)AfxGetMainWnd())->queryorder->MakeSortSQL();

	if	(!sOrder.IsEmpty())	sOrder	= " " + sOrder;

	CWnd	*pWnd	= ((CBxtDlg*)AfxGetMainWnd())->query;
	pWnd->SendMessage(WX_SETWHERE, 0, (LPARAM)(sWhere.GetBuffer(sWhere.GetLength())));
	pWnd->SendMessage(WX_SETORDER, 0, (LPARAM)(sOrder.GetBuffer(sOrder.GetLength())));
	pWnd->SendMessage(WX_QUERY, (WPARAM)(TRUE), 0);

	return	(TRUE);
}

BOOL
QueryFree::SimpleQuery()
{
	return	(FALSE);
}