【VC开源代码栏目提醒】:网学会员为广大网友收集整理了,CheckPrint.cpp,希望对大家有所帮助!
// CheckPrint.cpp : implementation file
//
#include "stdafx.h"
#include "aaa.h"
#include "CheckPrint.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
extern _ConnectionPtr m_pCon;
extern _RecordsetPtr m_pRs;
extern CAaaApp theApp;
/////////////////////////////////////////////////////////////////////////////
// CCheckPrint dialog
CCheckPrint::CCheckPrint(CWnd* pParent /*=NULL*/)
: CDialog(CCheckPrint::IDD, pParent)
{
//{{AFX_DATA_INIT(CCheckPrint)
//}}AFX_DATA_INIT
}
void CCheckPrint::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CCheckPrint)
DDX_Control(pDX, IDC_QUERY, m_query);
DDX_Control(pDX, IDC_PRINT, m_print);
DDX_Control(pDX, IDC_LIST1, list);
DDX_Control(pDX, IDC_COMBO1, fields);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CCheckPrint, CDialog)
//{{AFX_MSG_MAP(CCheckPrint)
ON_BN_CLICKED(IDC_QUERY, OnQuery)
ON_BN_CLICKED(IDC_PRINT, OnPrint)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CCheckPrint message handlers
void CCheckPrint::OnOK()
{
// TODO: Add extra validation here
//CDialog::OnOK();
}
void CCheckPrint::OnCancel()
{
// TODO: Add extra cleanup here
//CDialog::OnCancel();
}
void CCheckPrint::AddStorage()
{
fields.ResetContent();
m_pRs->raw_Close();
CString sql;
sql.Format("select storagename from tb_storageinfo");
m_pRs->Open((_variant_t)sql,m_pCon.GetInterfacePtr(),adOpenKeyset,adLockOptimistic,adCmdText);
while (! m_pRs->adoEOF)
{
fields.AddString((TCHAR*)(_bstr_t)m_pRs->GetFields()->GetItem((long)0)->Value);
m_pRs->MoveNext();
}
}
BOOL CCheckPrint::OnInitDialog()
{
CDialog::OnInitDialog();
//添加仓库信息
AddStorage();
//设置列表风格
list.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_HEADERDRAGDROP|LVS_EX_GRIDLINES|LVS_EX_ONECLICKACTIVATE|LVS_EX_FLATSB);
list.InsertColumn(0,"仓库名称");
list.InsertColumn(1,"商品编号");
list.InsertColumn(2,"商品名称");
list.InsertColumn(3,"库存数量");
list.SetColumnWidth(0,120);
list.SetColumnWidth(1,200);
list.SetColumnWidth(2,80);
list.SetColumnWidth(3,100);
return TRUE; // return TRUE unless you set the focus to a control
}
//查询仓库商品信息
void CCheckPrint::OnQuery()
{
CString c_field;
fields.GetWindowText(c_field);
if (!c_field.IsEmpty())
{
CString sql,temp;
sql.Format("select a.merchandiseID,a.storagename,a.Storagenum,b.name from tb_merchandisestorage a inner join tb_merchandiseinfo b on a.merchandiseID = b.id and a.storagename = '%s' ",c_field);
m_pRs->raw_Close();
m_pRs->Open((_variant_t)sql,m_pCon.GetInterfacePtr(),adOpenKeyset,adLockOptimistic,adCmdText);
int row = 0;
list.DeleteAllItems();
if (m_pRs->RecordCount>0)
{
while (! m_pRs->adoEOF)
{
list.InsertItem(row,"");
temp = (TCHAR *)(_bstr_t)m_pRs->GetFields()->GetItem("storagename")->Value;
list.SetItemText(row,0,temp);
temp = (TCHAR *)(_bstr_t)m_pRs->GetFields()->GetItem("merchandiseID")->Value;
list.SetItemText(row,1,temp);
temp = (TCHAR *)(_bstr_t)m_pRs->GetFields()->GetItem("name")->Value;
list.SetItemText(row,2,temp);
temp = (TCHAR *)(_bstr_t)m_pRs->GetFields()->GetItem("Storagenum")->Value;
list.SetItemText(row,3,temp);
row +=1;
m_pRs->MoveNext();
}
}
else
{
list.DeleteAllItems();
MessageBox("没有找到符合条件的数据.","提示",64);
}
}
else
{
MessageBox("请设置查询条件","提示",64);
}
}
void CCheckPrint::OnPrint()
{
CPreParent preparent;
preparent.pstruct.title = "仓库盘点报表";
preparent.pstruct.list = &list;
preparent.DoModal();
}
上一篇:
CheckOutView.cpp
下一篇:
科研管理杂志简介