searchi.cpp

一个很好的VC源代码

// SearchI.cpp : implementation file
//

#include "stdafx.h"
#include "aomanage.h"
#include "SearchI.h"
#include "MainFrm.h"
#include "List2.h"
#include "In2.h"

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

/////////////////////////////////////////////////////////////////////////////
// CSearchI dialog


CSearchI::CSearchI(CWnd* pParent /*=NULL*/)
	: CParentDlg(CSearchI::IDD, pParent)
{
	//{{AFX_DATA_INIT(CSearchI)
	m_strPCode = _T("");
	m_strWorker = _T("");
	m_strLast = _T("");
	m_strFirst = _T("");
	//}}AFX_DATA_INIT
	m_pStorage=new CDaoRecordset(&((CMainFrame*)AfxGetMainWnd())->m_db);
}


void CSearchI::DoDataExchange(CDataExchange* pDX)
{
	CParentDlg::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CSearchI)
	DDX_Control(pDX, IDC_LIST1, m_ctlList);
	DDX_Text(pDX, IDC_EDIT1, m_strPCode);
	DDX_Text(pDX, IDC_EDIT9, m_strWorker);
	DDX_Text(pDX, IDC_EDIT10, m_strLast);
	DDX_Text(pDX, IDC_EDIT2, m_strFirst);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CSearchI, CParentDlg)
	//{{AFX_MSG_MAP(CSearchI)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
	ON_WM_CLOSE()
	ON_MESSAGE(WM_LIST2DBLCLICK,OnList2DblClick)
	ON_BN_CLICKED(IDC_BUTTON9, OnButton9)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CSearchI message handlers

BOOL CSearchI::OnInitDialog() 
{
	CParentDlg::OnInitDialog();
	
	m_pStorage->Open(AFX_DAO_USE_DEFAULT_TYPE,"select * from storage");
	FIELD2 fdValue[8]={{"品号","code"},\
	{"数量","count"},{"日期","sdate"},\
	{"时间","stime"},{"入库/提货人","worker"}
	};
	m_ctlList.SetField(5,fdValue,m_pStorage);
	m_ctlList.Init();
	//double nWidth[5]={1,0.7,1,1.3,1};
	//m_ctlList.SetWidth(nWidth);
	UpdateData(FALSE);
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CSearchI::OnButton1() 
{
	UpdateData(TRUE);
	COleDateTime oleDate;
	CString strFltr,strTemp;
	if (m_strPCode.GetLength())
		strFltr+=" and code='"+m_strPCode+"'";
	if (m_strFirst.GetLength())
	{
		if (!oleDate.ParseDateTime(m_strFirst))
		{
			MessageBox("你输入的日期格式不正确");
			return;
		}
		else
			strFltr.Format(strFltr+" and sdate>%d",(int)oleDate);
	}
	if (m_strLast.GetLength())
	{
		if (!oleDate.ParseDateTime(m_strLast))
		{
			MessageBox("你输入的日期格式不正确");
			return;
		}
		else
			strFltr.Format(strFltr+" and sdate<%d",(int)oleDate);
	}
	if (m_strWorker.GetLength())
		strFltr+=" and worker='"+m_strWorker+"'";
	if (!strcmp(strFltr.Left(5)," and "))
		strFltr=strFltr.Right(strFltr.GetLength()-5);
	m_pStorage->m_strFilter=strFltr;
	m_ctlList.Refresh();
}

void CSearchI::OnButton2() 
{
	OnCancel();
}

void CSearchI::OnClose() 
{
	if (m_pStorage->IsOpen())
		m_pStorage->Close();
	CParentDlg::OnClose();
}

void CSearchI::OnList2DblClick(WPARAM wParam,LPARAM lParam)
{
	POSITION pos=m_ctlList.GetFirstSelectedItemPosition();
	if (pos)
	{
		int nItem=m_ctlList.GetNextSelectedItem(pos);
		m_pStorage->MoveFirst();
		m_pStorage->Move(nItem);
		COleVariant vVal;
		m_pStorage->GetFieldValue("id",vVal);
		CIn2 dlg;
		dlg.m_nID=vVal.iVal;
		if (dlg.DoModal()==IDOK)
			m_ctlList.Refresh();
	}
}

void CSearchI::OnButton9() 
{
	POSITION pos=m_ctlList.GetFirstSelectedItemPosition();
	if (pos)
	{
		int nItem=m_ctlList.GetNextSelectedItem(pos);
		m_pStorage->MoveFirst();
		m_pStorage->Move(nItem);
		COleVariant vVal;
		m_pStorage->GetFieldValue("id",vVal);
		CIn2 dlg;
		dlg.m_nID=vVal.iVal;
		if (dlg.DoModal()==IDOK)
			m_ctlList.Refresh();
	}
	else
		MessageBox("请选中该记录");
}