ljreasch.cpp

零件交易系统 零件交易中心管理系统主要提供顾客和供应商之间完成零件交易的功能

// LJReasch.cpp : implementation file
//

#include "stdafx.h"
#include "Toolmangne.h"
#include "LJReasch.h"

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

/////////////////////////////////////////////////////////////////////////////
// CLJReasch dialog

extern CToolmangneApp theApp;
void CLJReasch::SetStyle(CListCtrl * plist)
{
	DWORD dwsty = GetWindowLong(plist->m_hWnd,GWL_STYLE);
	dwsty &=~(LVS_TYPEMASK);
	dwsty &=~(LVS_EDITLABELS);

	SetWindowLong(plist->m_hWnd,GWL_STYLE,dwsty|LVS_REPORT|LVS_NOLABELWRAP|LVS_SHOWSELALWAYS);
	
	DWORD sys = LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES;
	ListView_SetExtendedListViewStyleEx(plist->m_hWnd,sys,sys);
}
CLJReasch::CLJReasch(CWnd* pParent /*=NULL*/)
	: CDialog(CLJReasch::IDD, pParent)
{
	//{{AFX_DATA_INIT(CLJReasch)
	m_id = _T("");
	//}}AFX_DATA_INIT
}


void CLJReasch::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CLJReasch)
	DDX_Control(pDX, IDC_LIST1, m_list);
	DDX_Text(pDX, IDC_EDIT1, m_id);
	//}}AFX_DATA_MAP
	init();
}


BEGIN_MESSAGE_MAP(CLJReasch, CDialog)
	//{{AFX_MSG_MAP(CLJReasch)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CLJReasch message handlers

void CLJReasch::OnButton1() 
{
	UpdateData();
	// TODO: Add your control notification handler code here
	CString sql = "select * from Part where ID ="+m_id;//+"'";
     //CString sql = "UPDATE  Provider Set PassWord ='"+m_pass+"',Address='"+m_addr+"',Tel='"+m_tell+"',Intro='"+m_info+"' WHERE  ID="+UserId;
	 
	 _RecordsetPtr	m_pRecordset;
	 m_pRecordset.CreateInstance(__uuidof(Recordset));
	 _variant_t RecordsAffected;
	 try
	 {
		 m_pRecordset->Open(_variant_t(sql),                // 查询DemoTable表中所有字段
			 theApp.m_pConnection.GetInterfacePtr(),	  // 获取库接库的IDispatch指针
			 adOpenDynamic,
			 adLockOptimistic,
			 adCmdText);
		 _variant_t var;
		 if(!m_pRecordset->BOF)
			 m_pRecordset->MoveFirst();
		 else
		 {
			 AfxMessageBox("没有交易信息");
			 return ;
		 }			
		 // 读入库中各字段并加入列表框中
		 CString tmp[5];
		 while(!m_pRecordset->adoEOF)
		 {
			 var = m_pRecordset->GetCollect("ID");
			 if(var.vt != VT_NULL)
				 tmp[0] = (LPCSTR)_bstr_t(var);
			 var = m_pRecordset->GetCollect("Color");
			 if(var.vt != VT_NULL)
				 tmp[1] = (LPCSTR)_bstr_t(var);
			 var = m_pRecordset->GetCollect("Name");
			 if(var.vt != VT_NULL)
				 tmp[2] = (LPCSTR)_bstr_t(var);
			 var = m_pRecordset->GetCollect("Weight");
			 if(var.vt != VT_NULL)
				 tmp[3] = (LPCSTR)_bstr_t(var);
			 var = m_pRecordset->GetCollect("Intro");
			 if(var.vt != VT_NULL)
				 tmp[4] = (LPCSTR)_bstr_t(var);
			 adddata(tmp);
			 m_pRecordset->MoveNext();
		 }
	 }
	 catch(...)
	 {
		 AfxMessageBox("查询失败");
		 return ;
	 }   	
}

void CLJReasch::init()
{
    m_list.InsertColumn(0,_T("零件号"),LVCFMT_LEFT,0); //插入列
    m_list.InsertColumn(1,_T("颜色"),LVCFMT_LEFT,0);
    m_list.InsertColumn(2,_T("名字"),LVCFMT_LEFT,0);
    m_list.InsertColumn(3,_T("重量"),LVCFMT_LEFT,0);
	m_list.InsertColumn(4,_T("介绍"),LVCFMT_LEFT,0);

	CRect rect4;
	m_list.GetClientRect(rect4); //获得当前客户区信息
	m_list.SetColumnWidth(0,rect4.Width()/6); //设置列的宽度。
	m_list.SetColumnWidth(1,rect4.Width()/6);
	m_list.SetColumnWidth(2,rect4.Width()/6);
	m_list.SetColumnWidth(3,rect4.Width()/6);
	m_list.SetColumnWidth(4,rect4.Width()/4);
	SetStyle(&m_list);
}

void CLJReasch::OnOK() 
{
	// TODO: Add extra validation here
	
	//CDialog::OnOK();
}

void CLJReasch::adddata(CString tmp[])
{
	LV_ITEM lvitem;
	lvitem.pszText=_T("");
	lvitem.mask=LVIF_TEXT;
	lvitem.iSubItem=0;
	lvitem.iItem=0;
	m_list.InsertItem(&lvitem);
	m_list.SetItemText(0,0,tmp[0]);
	m_list.SetItemText(0,1,tmp[1]);
	m_list.SetItemText(0,2,tmp[2]);
	m_list.SetItemText(0,3,tmp[3]);
	m_list.SetItemText(0,4,tmp[4]);
}

void CLJReasch::OnButton2() 
{
	UpdateData();
	// TODO: Add your control notification handler code here
	CString sql = "select * from Part";// where ID ="+m_id;//+"'";
     //CString sql = "UPDATE  Provider Set PassWord ='"+m_pass+"',Address='"+m_addr+"',Tel='"+m_tell+"',Intro='"+m_info+"' WHERE  ID="+UserId;
	 
	 _RecordsetPtr	m_pRecordset;
	 m_pRecordset.CreateInstance(__uuidof(Recordset));
	 _variant_t RecordsAffected;
	 try
	 {
		 m_pRecordset->Open(_variant_t(sql),                // 查询DemoTable表中所有字段
			 theApp.m_pConnection.GetInterfacePtr(),	  // 获取库接库的IDispatch指针
			 adOpenDynamic,
			 adLockOptimistic,
			 adCmdText);
		 _variant_t var;
		 if(!m_pRecordset->BOF)
			 m_pRecordset->MoveFirst();
		 else
		 {
			 AfxMessageBox("没有交易信息");
			 return ;
		 }			
		 // 读入库中各字段并加入列表框中
		 CString tmp[5];
		 while(!m_pRecordset->adoEOF)
		 {
			 var = m_pRecordset->GetCollect("ID");
			 if(var.vt != VT_NULL)
				 tmp[0] = (LPCSTR)_bstr_t(var);
			 var = m_pRecordset->GetCollect("Color");
			 if(var.vt != VT_NULL)
				 tmp[1] = (LPCSTR)_bstr_t(var);
			 var = m_pRecordset->GetCollect("Name");
			 if(var.vt != VT_NULL)
				 tmp[2] = (LPCSTR)_bstr_t(var);
			 var = m_pRecordset->GetCollect("Weight");
			 if(var.vt != VT_NULL)
				 tmp[3] = (LPCSTR)_bstr_t(var);
			 var = m_pRecordset->GetCollect("Intro");
			 if(var.vt != VT_NULL)
				 tmp[4] = (LPCSTR)_bstr_t(var);
			 adddata(tmp);
			 m_pRecordset->MoveNext();
		 }
	 }
	 catch(...)
	 {
		 AfxMessageBox("查询失败");
		 return ;
	 }   	
}