chxlbdlg.cpp

商品进存销管理系统 包含发票

// chxlbDlg.cpp : implementation file
//

#include "stdafx.h"
#include "glxt.h"
#include "chxlbDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CchxlbDlg dialog


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


void CchxlbDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CchxlbDlg)
	DDX_Control(pDX, IDC_LIST2, m_lb);
	DDX_Control(pDX, IDC_LIST1, m_lchx);
	DDX_Text(pDX, IDC_EDIT1, m_tlb);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CchxlbDlg, CDialog)
	//{{AFX_MSG_MAP(CchxlbDlg)
	ON_BN_CLICKED(IDC_BUTTON2, Onchxun)
	ON_NOTIFY(NM_DBLCLK, IDC_LIST2, OnDblclkList2)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CchxlbDlg message handlers

BOOL CchxlbDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	m_lchx.SetExtendedStyle(LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT);
    m_lchx.InsertColumn(0,"商品编号",LVCFMT_LEFT,80);
	m_lchx.InsertColumn(1,"商品名称",LVCFMT_LEFT,80);
	m_lchx.InsertColumn(2,"品牌",LVCFMT_LEFT,100);
	m_lchx.InsertColumn(3,"规格",LVCFMT_LEFT,80);
    m_lchx.InsertColumn(4,"产地",LVCFMT_LEFT,80);
	m_lchx.InsertColumn(5,"商品类别",LVCFMT_LEFT,200);
    m_lchx.InsertColumn(6,"计量单位",LVCFMT_LEFT,80);
 
    m_lchx.InsertColumn(7,"进货价格",LVCFMT_CENTER,80);
    m_lchx.InsertColumn(8,"销售价格",LVCFMT_CENTER,80);

	m_lb.SetExtendedStyle(LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT);
	m_lb.InsertColumn(0,"编号",LVCFMT_LEFT,80);
	m_lb.InsertColumn(1,"商品类别",LVCFMT_LEFT,200);
	
	m_db.Open(_T("gshDSN"));
	m_set1.m_pDatabase=&m_db;
    m_set.m_pDatabase=&m_db;
   //if(!m_set1.IsOpen())
	m_set1.Open();
	m_lb.DeleteAllItems();
    int n = 0 ;
	  while(!m_set1.IsEOF())
	  {
	    m_lb.InsertItem(n,"");
        CString s;
		s.Format("%d",m_set1.m_Gkindno);
 		m_lb.SetItemText(n,0,s);
		
		s.Format("%s",m_set1.m_Gkindname);
        m_lb.SetItemText(n,1,s);
		m_set1.MoveNext();
		n++;
	  }
	m_set1.Close(); 

 

	// TODO: Add extra initialization here
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CchxlbDlg::Onchxun() 
{
	// TODO: Add your control notification handler code here
	//if(dlg.m_getstring=="按供应商名称查询")
    CString s;
    UpdateData();
    m_set.m_strFilter="Gkindname like '%" + m_tlb + "%'";
	m_set.Open();  
	if (m_set.IsEOF())
	{
		MessageBox("对不起，没有您要查找的记录!","提示");
		return ; 
	}
    else
	{   
		m_lchx.DeleteAllItems();
		int n = 0 ;
	    while(!m_set.IsEOF())
		{
			m_set.m_Gno.TrimRight();
			m_lchx.InsertItem(n,m_set.m_Gno);
			m_lchx.SetItemText(n,1,m_set.m_Gname);
            m_lchx.SetItemText(n,2,m_set.m_Gsign);
		    m_lchx.SetItemText(n,3,m_set.m_Gtype);
			m_lchx.SetItemText(n,4,m_set.m_Gaddr);
			m_lchx.SetItemText(n,5,m_set.m_Gkindname);
			m_lchx.SetItemText(n,6,m_set.m_Gcbitname);
 
            s.Format("%.2f",m_set.m_Gbprice);        
            m_lchx.SetItemText(n,7,s);
			s.Format("%.2f",m_set.m_Gsprice);
			m_lchx.SetItemText(n,8,s);
	
			m_set.MoveNext();
			n++;
		}
	}
  m_set.Close(); 
}

void CchxlbDlg::OnDblclkList2(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	int index=m_lb.GetNextItem(-1,LVNI_SELECTED);
     if(index!=-1)
 	{
 	   
 	   m_tlb=m_lb.GetItemText(index,1);
       
       UpdateData(FALSE);
 	   //*pResult = 0;
 	}
	
	*pResult = 0;
}