librarygdlg.cpp

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

// librarygDlg.cpp : implementation file
//

#include "stdafx.h"
#include "glxt.h"
#include "librarygDlg.h"


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

/////////////////////////////////////////////////////////////////////////////
// ClibrarygDlg dialog


ClibrarygDlg::ClibrarygDlg(CWnd* pParent /*=NULL*/)
	: CDialog(ClibrarygDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(ClibrarygDlg)
	m_count = 0;
	//}}AFX_DATA_INIT
}


void ClibrarygDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(ClibrarygDlg)
	DDX_Control(pDX, IDC_LIST1, m_kushp);
	DDX_Text(pDX, IDC_EDIT1, m_count);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(ClibrarygDlg, CDialog)
	//{{AFX_MSG_MAP(ClibrarygDlg)
	ON_WM_CTLCOLOR()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// ClibrarygDlg message handlers

BOOL ClibrarygDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_db.Open(_T("gshDSN"));
    m_rs.m_pDatabase=&m_db;
	m_shp.m_pDatabase=&m_db;


	m_kushp.SetExtendedStyle(LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT );
	m_kushp.InsertColumn(0,"库存编号",LVCFMT_LEFT,100);
	m_kushp.InsertColumn(1,"商品编号",LVCFMT_LEFT,100);
	m_kushp.InsertColumn(2,"商品名称",LVCFMT_LEFT,100);
    m_kushp.InsertColumn(3,"库存数量",LVCFMT_LEFT,100);
	m_kushp.InsertColumn(4,"品牌",LVCFMT_LEFT,80);
	m_kushp.InsertColumn(5,"规格",LVCFMT_LEFT,80);
	m_kushp.InsertColumn(6,"产地",LVCFMT_LEFT,80);
	m_kushp.InsertColumn(7,"商品类别",LVCFMT_LEFT,80);
	m_kushp.InsertColumn(8,"计量单位",LVCFMT_LEFT,80);
    m_kushp.InsertColumn(9,"供货商",LVCFMT_LEFT,80);
    m_kushp.InsertColumn(10,"进货价格",LVCFMT_CENTER,80);
    m_kushp.InsertColumn(11,"销售价格",LVCFMT_CENTER,80);
	m_kushp.InsertColumn(12,"备注",LVCFMT_CENTER,200);
    int i=0;
    if(!m_rs.IsOpen())
	  m_rs.Open();
	m_kushp.DeleteAllItems();
    int n = 0 ;
	  while(!m_rs.IsEOF())
	  {
	    m_kushp.InsertItem(n,"");
        CString s;
		s.Format("%s",m_rs.m_Lbno);
 		m_kushp.SetItemText(n,0,s);
		s.Format("%s",m_rs.m_Gno);
 		m_kushp.SetItemText(n,1,s);
		s.Format("%s",m_rs.m_Gname);
        m_kushp.SetItemText(n,2,s);
		s.Format("%d",m_rs.m_Lbcount);
		m_kushp.SetItemText(n,3,s);
		s.Format("%s",m_rs.m_Gsign);
     	m_kushp.SetItemText(n,4,s);
		s.Format("%s",m_rs.m_Gtype);
     	m_kushp.SetItemText(n,5,s);
		s.Format("%s",m_rs.m_Gaddr);
     	m_kushp.SetItemText(n,6,s);
	    s.Format("%s",m_rs.m_Gkindname);
     	m_kushp.SetItemText(n,7,s);
	    s.Format("%s",m_rs.m_Gcbitname);
		m_kushp.SetItemText(n,8,s);
		s.Format("%s",m_rs.m_Pname);
     	m_kushp.SetItemText(n,9,s);
		s.Format("%.1f",m_rs.m_Gprice);
        m_kushp.SetItemText(n,10,s);
	    s.Format("%.1f",m_rs.m_Gsprice);
		m_kushp.SetItemText(n,11,s);
		n++;
		m_rs.MoveNext();
	  }
	  m_rs.Close();
       
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void ClibrarygDlg::OnOK() 
{
	// TODO: Add extra validation here
	int index=m_kushp.GetNextItem(-1,LVNI_SELECTED);
		if(index!=-1)
		{
	     m_lbno=m_kushp.GetItemText(index,0);
     	 m_gno=m_kushp.GetItemText(index,1);
		 m_gname=m_kushp.GetItemText(index,2);
		 m_gpp=m_kushp.GetItemText(index,4);
		 m_gtype=m_kushp.GetItemText(index,5);
	     m_addr=m_kushp.GetItemText(index,6);
	     m_gkind=m_kushp.GetItemText(index,7);
         m_pname=m_kushp.GetItemText(index,8);
	     m_dw=m_kushp.GetItemText(index,9);
         m_bprice=atof(m_kushp.GetItemText(index,10));
		 m_sprice=atof(m_kushp.GetItemText(index,11));
		 if(m_shp.IsOpen())
		    m_shp.Close();
         m_shp.Open();
		 m_shp.MoveFirst();
	       
		 try
		 {
			
		  while(1)
		  {
			 
		      if(m_shp.m_Lbno==m_lbno&&m_shp.m_Gno==m_gno)
			  { 
				  m_shp.Edit();
	              UpdateData(TRUE); 
		  
				 m_shp.m_Lbcount=m_shp.m_Lbcount-m_count;
				 m_shp.Update();
			     //break;
			  
			      if(m_shp.m_Lbcount==0)
				  { 
					  try
					  {
			    	    m_shp.Delete();
					  }
			
		    	      catch(CDBException * e)
					  {
				         AfxMessageBox(e->m_strError,MB_ICONEXCLAMATION);
					     e->Delete();
				         return;
					  }
				  }
		
	        	break;
			  }

			  else
			   m_shp.MoveNext();
		  }
		 }
         catch(CDBException * e)
		 {
	       AfxMessageBox(e->m_strError,MB_ICONEXCLAMATION);
	       e->Delete();
		 }
	     m_shp.Close();
	}
  CDialog::OnOK();
}

HBRUSH ClibrarygDlg::OnCtlColor(CDC* pDC, CWnd* pWnd, UINT nCtlColor) 
{
	HBRUSH hbr = CDialog::OnCtlColor(pDC, pWnd, nCtlColor);
	
	// TODO: Change any attributes of the DC here
	
	// TODO: Return a different brush if the default is not desired
	return m_brush;;
}