queryview.cpp

用VC做的订单管理系统,可以实现网络订单的各种功能

// QueryView.cpp : implementation file
//

#include "stdafx.h"
#include "indent.h"
#include "QueryView.h"
#include "QueryFrame.h"
#include "resource.h"

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

/////////////////////////////////////////////////////////////////////////////
// QueryView


IMPLEMENT_DYNCREATE(QueryView, CListView)

QueryView::QueryView()
{
	m_nItem = -1;
	m_strFind.Empty();
	m_strEndTime.Empty();
	m_strBeginTime.Empty();
}

QueryView::~QueryView()
{
}


BEGIN_MESSAGE_MAP(QueryView, CListView)
	ON_WM_CONTEXTMENU()
	//{{AFX_MSG_MAP(QueryView)
	ON_UPDATE_COMMAND_UI(ID_INDENT_QUERY_RECORD, OnUpdateIndentQueryRecord)
	ON_BN_CLICKED(IDC_BTN_FIND, OnBtnFind)
	ON_NOTIFY_REFLECT(NM_CLICK, OnClick)
	ON_UPDATE_COMMAND_UI(ID_INDENT_OPEN_RECORD, OnUpdateIndentOpenRecord)
	ON_COMMAND(ID_EDIT_DELETE, OnEditDelete)
	ON_UPDATE_COMMAND_UI(ID_EDIT_DELETE, OnUpdateEditDelete)
	ON_COMMAND(ID_REFURBISH, OnRefurbish)
	ON_NOTIFY_REFLECT(NM_DBLCLK, OnDblclk)
	ON_COMMAND(ID_INDENT_OPEN_RECORD, OnIndentOpenRecord)
	ON_NOTIFY_REFLECT(LVN_COLUMNCLICK, OnColumnclick)
	
	//}}AFX_MSG_MAP

END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// QueryView diagnostics

#ifdef _DEBUG
void QueryView::AssertValid() const
{
	CListView::AssertValid();
}

void QueryView::Dump(CDumpContext& dc) const
{
	CListView::Dump(dc);
}
#endif //_DEBUG

/////////////////////////////////////////////////////////////////////////////
// QueryView message handlers

void QueryView::OnUpdateIndentQueryRecord(CCmdUI* pCmdUI) 
{
	// TODO: Add your command update UI handler code here
	pCmdUI->Enable(!this);
}

BOOL QueryView::PreCreateWindow(CREATESTRUCT& cs) 
{
	// TODO: Add your specialized code here and/or call the base class
	cs.style |= LVS_REPORT|LVS_SINGLESEL;

	return CListView::PreCreateWindow(cs);
}

void QueryView::OnInitialUpdate() 
{
	CListView::OnInitialUpdate();

	CIndentApp* pApp = (CIndentApp*)AfxGetApp();
	m_ado = pApp->m_ado;
	m_pListCtrl = &GetListCtrl();

	m_pListCtrl->SetExtendedStyle(LVS_EX_GRIDLINES | LVS_EX_FULLROWSELECT);

	((QueryFrame*)GetParent())->OnGetDateTime();
	// Insert a column. This override is the most convenient.
	LVCOLUMN col;
	col.mask = LVCF_FMT|LVCF_SUBITEM|LVCF_TEXT|LVCF_WIDTH;
	col.fmt = LVCFMT_LEFT;

	col.cx = 60;
	LPSTR subject[17];
	subject[0] = "致";
	subject[1] = "编号";
	subject[2] = "客户";
	subject[3] = "订单号码";
	subject[4] = "日期";
	subject[5] = "布类";
	subject[6] = "针数";
	subject[7] = "寸数";
	subject[8] = "胚重";
	subject[9] = "规矩";
	subject[10] = "成品";
	subject[11] = "数量";
	subject[12] = "交货日期";
	subject[13] = "地点";
	subject[14] = "合同类别";
	subject[15] = "备注";
	subject[16] = "发货人";

	for(int i=0; i<17; i++)
	{
		col.pszText = subject[i]; 
		col.iSubItem = i;
		m_pListCtrl->InsertColumn(i,&col);
	}

	// Query and show data
	Query();

	
}

void QueryView::OnBtnFind() 
{
	CString strFind;
	int i;
	CEdit* pEdit = (CEdit*)((QueryFrame*)GetParent())->m_wndMyDialogBar.GetDlgItem(IDC_EDIT_FIND);
	pEdit->GetWindowText(strFind);
	//