xunsjxxdlg.cpp

物资采购系统

// XunsjxxDlg.cpp : implementation file
//

#include "stdafx.h"
#include "kufangDBS.h"
#include "XunsjxxDlg.h"
extern CDatabase m_db;

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

/////////////////////////////////////////////////////////////////////////////
// CXunsjxxDlg dialog


CXunsjxxDlg::CXunsjxxDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CXunsjxxDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CXunsjxxDlg)
	m_strZiduansj = _T("");
	m_strValuesj = _T("");
	//}}AFX_DATA_INIT
}


void CXunsjxxDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CXunsjxxDlg)
	DDX_Control(pDX, IDC_LIST_CHAXUNSJ, m_listChaxunsj);
	DDX_CBString(pDX, IDC_COMBO_ZIDUANSJ, m_strZiduansj);
	DDX_Text(pDX, IDC_EDIT_VALUESJ, m_strValuesj);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CXunsjxxDlg, CDialog)
	//{{AFX_MSG_MAP(CXunsjxxDlg)
	ON_BN_CLICKED(IDC_BTN_SJXX_CHAXUN, OnBtnSjxxChaxun)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CXunsjxxDlg message handlers

void CXunsjxxDlg::OnBtnSjxxChaxun() 
{
	// TODO: Add your control notification handler code here
m_listChaxunsj.DeleteAllItems();
UpdateData();
//选择字段
CString sql  ;//注意字段的描绘
if(m_strZiduansj=="商家名称")  sql.Format("Select * from sj where sjmc ='%s'",m_strValuesj);
else if(m_strZiduansj =="商家电话") sql.Format("Select * from sj where sjdh ='%s'",m_strValuesj);
else if(m_strZiduansj =="传真号码") sql.Format("Select * from sj where czhm ='%s'",m_strValuesj);
else if(m_strZiduansj =="联系人")  sql.Format("Select * from sj where lxr='%s'",m_strValuesj);
else sql.Format("Select * from sb where lxrdh ='%s'",m_strValuesj);
TRY{
//获取所有的设备记录集
  CRecordset rs;
rs.m_pDatabase = & m_db;
 rs.Open(CRecordset::dynaset, sql);  
int sjbh;
CString sjmc,sjdh,czhm,lxr,lxrdh;
while (!rs.IsEOF()){
    CDBVariant  var;
  //获取成员字段值
  rs.GetFieldValue((short)0,var,SQL_C_SLONG);
    if (var.m_dwType !=DBVT_NULL)
        sjbh = var.m_iVal;
   var.Clear();
  rs.GetFieldValue(1, sjmc);
  rs.GetFieldValue(2, sjdh);
  rs.GetFieldValue(3, czhm);
  rs.GetFieldValue(4,lxr);
  rs.GetFieldValue(5,lxrdh);
InsertShebeiItem8(sjbh,sjmc,sjdh,czhm,lxr,lxrdh);
  rs.MoveNext();
  }
rs.Close();
}
CATCH(CDBException,ex)
{
   AfxMessageBox(ex->m_strError);
   AfxMessageBox(ex->m_strStateNativeOrigin);
}
AND_CATCH(CMemoryException,pEx)
{
   pEx->ReportError();
   AfxMessageBox("memory exception");
}
AND_CATCH(CException,e){
   TCHAR szError[100];
   e->GetErrorMessage(szError,100);
   AfxMessageBox(szError);
}
END_CATCH
	
}
//////////////////////////////////////////////////////////////////////////
BOOL CXunsjxxDlg::OnInitDialog()
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	//设置列表空间风格
DWORD dwExStyle = LVS_EX_FULLROWSELECT | LVS_EX_GRIDLINES | LVS_EX_HEADERDRAGDROP | LVS_EX_ONECLICKACTIVATE | LVS_EX_UNDERLINEHOT;
m_listChaxunsj.SetExtendedStyle(dwExStyle);
//初始化设备列表控件
m_listChaxunsj.InsertColumn(0,"商家编号",LVCFMT_CENTER,60) ;
m_listChaxunsj.InsertColumn(1,"商家名称",LVCFMT_CENTER,60) ;
m_listChaxunsj.InsertColumn(2,"商家电话 ",LVCFMT_CENTER,60) ;
m_listChaxunsj.InsertColumn(3,"传真号码",LVCFMT_CENTER,60) ;
m_listChaxunsj.InsertColumn(4,"联系人",LVCFMT_CENTER,60) ;
m_listChaxunsj.InsertColumn(5,"联系人电话",LVCFMT_CENTER,60) ;

	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE

}

void CXunsjxxDlg::InsertShebeiItem8(int sjbh, CString sjmc, CString sjdh, CString czhm, CString lxr, CString lxrdh)
{
//获取当前的显示条数
int nIndex = m_listChaxunsj.GetItemCount();
LV_ITEM lvItem;
lvItem.mask = LVIF_TEXT;
lvItem.iItem = nIndex;
lvItem.iSubItem = 0;
CString temp;
temp.Format("%d", sjbh);
lvItem.pszText = (char*)(LPCTSTR) temp;
//在nIndex一行插入数据
m_listChaxunsj . InsertItem(&lvItem);
m_listChaxunsj . SetItemText(nIndex,1, sjmc);
m_listChaxunsj . SetItemText(nIndex,2, sjdh);
m_listChaxunsj . SetItemText(nIndex,3, czhm);
m_listChaxunsj . SetItemText(nIndex,4, lxr); 
m_listChaxunsj . SetItemText(nIndex,5, lxrdh);

}