searoderdlg.cpp

订单管理系统

// SearOderDlg.cpp : implementation file
//

#include "stdafx.h"
#include "ordermanagement.h"
#include "SearOderDlg.h"

#include "ADOConn.h"

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

/////////////////////////////////////////////////////////////////////////////
// SearOderDlg dialog


SearOderDlg::SearOderDlg(CWnd* pParent /*=NULL*/)
	: CDialog(SearOderDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(SearOderDlg)
	m_str1 = _T("");
	m_str10 = _T("");
	m_str11 = _T("");
	m_str12 = _T("");
	m_str2 = _T("");
	m_str3 = _T("");
	m_str4Date = _T("");
	m_str5 = _T("");
	m_str6 = _T("");
	m_str7 = _T("");
	m_str8 = _T("");
	m_str9 = _T("");
	m_kStr = _T("");
	m_nSearch = _T("");
	m_nSort = _T("");
	//}}AFX_DATA_INIT
m_hIcon = AfxGetApp()->LoadIcon(IDR_MAINFRAME);
}


void SearOderDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(SearOderDlg)
	DDX_Control(pDX, IDC_BTN_REFRESH, m_reCtr);
	DDX_Control(pDX, IDC_OINFO_LIST, m_listCtr);
	DDX_Control(pDX, IDC_SORT_BTN, m_soCtr);
	DDX_Control(pDX, IDC_SEARCH_BTN, m_seCtr);
	DDX_Control(pDX, IDC_KSORT_COMB, m_odSoCtr);
	DDX_Control(pDX, IDC_KSEARCH_COMB, m_odSeCtr);
	DDX_Control(pDX, IDC_KEY_EDIT, m_kStrCtr);
	DDX_Text(pDX, IDC_EDIT1, m_str1);
	DDX_Text(pDX, IDC_EDIT10, m_str10);
	DDX_Text(pDX, IDC_EDIT11, m_str11);
	DDX_Text(pDX, IDC_EDIT12, m_str12);
	DDX_Text(pDX, IDC_EDIT2, m_str2);
	DDX_Text(pDX, IDC_EDIT3, m_str3);
	DDX_Text(pDX, IDC_EDIT4_DATE, m_str4Date);
	DDX_Text(pDX, IDC_EDIT5, m_str5);
	DDX_Text(pDX, IDC_EDIT6, m_str6);
	DDX_Text(pDX, IDC_EDIT7, m_str7);
	DDX_Text(pDX, IDC_EDIT8, m_str8);
	DDX_Text(pDX, IDC_EDIT9, m_str9);
	DDX_Text(pDX, IDC_KEY_EDIT, m_kStr);
	DDX_CBString(pDX, IDC_KSEARCH_COMB, m_nSearch);
	DDX_CBString(pDX, IDC_KSORT_COMB, m_nSort);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(SearOderDlg, CDialog)
	//{{AFX_MSG_MAP(SearOderDlg)
	ON_BN_CLICKED(IDC_SORT_BTN, OnSortBtn)
	ON_BN_CLICKED(IDC_SEARCH_BTN, OnSearchBtn)
	ON_BN_CLICKED(IDC_ONCANCLE, OnOncancle)
	ON_BN_CLICKED(IDC_BTN_REFRESH, OnBtnRefresh)
	ON_NOTIFY(NM_CLICK, IDC_OINFO_LIST, OnClickOinfoList)
	ON_WM_CTLCOLOR()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// SearOderDlg message handlers

BOOL SearOderDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	//添加窗口图标
	SetIcon(m_hIcon, TRUE);			// Set big icon
	SetIcon(m_hIcon, FALSE);		// Set small icon
	
	//初始化图标
	m_imagelist.Create(16, 16,ILC_MASK,1,4);
	HICON hIcon=AfxGetApp()->LoadIcon(IDI_ICON3);
	m_imagelist.Add(hIcon);

	//初始化列表框表头
	m_listCtr.SetImageList(&m_imagelist,LVSIL_SMALL);

	m_listCtr.InsertColumn(0,  "订 单 ID",  LVCFMT_LEFT,120);
	m_listCtr.InsertColumn(1,  "客 户 ID",  LVCFMT_LEFT,120);
	m_listCtr.InsertColumn(2,  "客户名称",  LVCFMT_LEFT,120);
	m_listCtr.InsertColumn(3,  "产 品 ID",  LVCFMT_LEFT,120);
	m_listCtr.InsertColumn(4,  "产品名称",  LVCFMT_LEFT,120);
	m_listCtr.InsertColumn(5,  "订购数量",  LVCFMT_LEFT,80);
	m_listCtr.InsertColumn(6,  "公司联系人",LVCFMT_LEFT,100);
	m_listCtr.InsertColumn(7,  "客户联系人",LVCFMT_LEFT,100);
	m_listCtr.InsertColumn(8,  "送货地址",  LVCFMT_LEFT,150);
	m_listCtr.InsertColumn(9,  "签订日期",  LVCFMT_LEFT,100);
	m_listCtr.InsertColumn(10, "有效截止期",LVCFMT_LEFT,100);
	m_listCtr.InsertColumn(11, "备  注",    LVCFMT_LEFT,200);
	
	//-- 设置单列全选,显示网格 -- //
	m_listCtr.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);	
	

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

void SearOderDlg::oSechList()
{
	m_listCtr.DeleteAllItems();
	try{
		ADOConn oSeconn;
		_bstr_t sSQL;
		_RecordsetPtr  m_pRecordset;
		int nItem;

		/*取登录用户的ID号，currState表示登陆的用户*/
		sSQL ="select * from ClientMessage where currState=1";
		m_pRecordset = oSeconn.GetRecordSet(sSQL);
		oSeconn.vCID = m_pRecordset->GetCollect("clientID");
		CString cliID = (char *)(_bstr_t)oSeconn.vCID;
		sSQL = "select * from OderFormMessage where clientID='"+cliID+"' order by oderFormID ";
		m_pRecordset = oSeconn.GetRecordSet(sSQL);

		while(!m_pRecordset->adoEOF)
		{

			oSeconn.vOID = m_pRecordset->GetCollect("oderFormID");
			oSeconn.vCID = m_pRecordset->GetCollect("clientID");
			oSeconn.vCN  = m_pRecordset->GetCollect("clientName");
			oSeconn.vPID = m_pRecordset->GetCollect("productID");
			oSeconn.vPN  = m_pRecordset->GetCollect("productName");
			oSeconn.vOPNUM = m_pRecordset->GetCollect("productNum");
			oSeconn.vCOP = m_pRecordset->GetCollect("companyContactPerson");
			oSeconn.vClP = m_pRecordset->GetCollect("clientContactPerson");	
			oSeconn.vTRADD = m_pRecordset->GetCollect("consignmentAddress");//AfxMessageBox("ok");
			oSeconn.vFDATA = m_pRecordset->GetCollect("formDate");
			oSeconn.vEDATA = m_pRecordset->GetCollect("endDate");
			oSeconn.vREMARK = m_pRecordset->GetCollect("remark");
			// -- 添加数据到列表控件中 -- //
			nItem = m_listCtr.InsertItem(0xffff,(_bstr_t)oSeconn.vOID,0);
			m_listCtr.SetItemText(nItem,1,(_bstr_t)oSeconn.vCID);	
			m_listCtr.SetItemText(nItem,2,(_bstr_t)oSeconn.vCN);
			m_listCtr.SetItemText(nItem,3,(_bstr_t)oSeconn.vPID);
			m_listCtr.SetItemText(nItem,4,(_bstr_t)oSeconn.vPN);
			m_listCtr.SetItemText(nItem,5,(_bstr_t)oSeconn.vOPNUM);
			m_listCtr.SetItemText(nItem,6,(_bstr_t)oSeconn.vCOP);
			m_listCtr.SetItemText(nItem,7,(_bstr_t)oSeconn.vClP);
			m_listCtr.SetItemText(nItem,8,(_bstr_t)oSeconn.vTRADD);
			m_listCtr.SetItemText(nItem,9,(_bstr_t)oSeconn.vFDATA);
			m_listCtr.SetItemText(nItem,10,(_bstr_t)oSeconn.vEDATA);
			m_listCtr.SetItemText(nItem,11,(_bstr_t)oSeconn.vREMARK);

			m_pRecordset->MoveNext();
		}
	}
	catch(_com_error e)
	{
		AfxMessageBox(e.ErrorMessage());
	}
}

void SearOderDlg::OnOncancle() 
{
	//if(MessageBox("是否确定退出？","请确认",MB_YESNO) == IDYES)
	//{
	CDialog::OnCancel();
	//}
}

void SearOderDlg::odSech()
{
	ADOConn conn;
	_RecordsetPtr  m_pRecordset;
	_bstr_t vSQL;
	int nItem;
	CString sKey,sort;

	m_listCtr.DeleteAllItems();
	try{
		//如果Concection对象为空,则重新连接 
		if(conn.m_pConn == NULL)  
			conn.OnInitADOConn();

		if(m_odSoCtr.GetCurSel() == 0)//确定排序方式
			sort = "DESC";
	    else 
			sort = "ASC";
/*取登录用户的ID号，currState表示登陆的用户*/
		vSQL ="select * from ClientMessage where currState=1";
		m_pRecordset = conn.GetRecordSet(vSQL);
		conn.vCID = m_pRecordset->GetCollect("clientID");
		CString cliID = (char *)(_bstr_t)conn.vCID;
		//vSQL = "select * from OderFormMessage where clientID='"+cliID+"' order by oderFormID ";
		//m_pRecordset = conn.GetRecordSet(vSQL);

		switch(m_nSechType)
		{
		case 0: 
			vSQL = "select * from OderFormMessage where clientID='"+cliID+"' order by oderFormID "+sort;
			m_pRecordset = conn.GetRecordSet(vSQL);	
			break;
		case 1:
			vSQL= "select * from OderFormMessage where productID='" +m_kStr+ "'order by oderFormID "+sort;
			m_pRecordset = conn.GetRecordSet(vSQL);
			break;
		case 2: 
			vSQL="select * from OderFormMessage where productName='" +m_kStr+ "'order by oderFormID "+sort;
			m_pRecordset = conn.GetRecordSet(vSQL);
			break;
		case 3: 
			vSQL="select * from OderFormMessage where oderFormID='" +m_kStr+ "'order by oderFormID "+sort;
			m_pRecordset = conn.GetRecordSet(vSQL);
			break;
		case 4: 
			vSQL= "select * from OderFormMessage where clientID='" +m_kStr+ "'order by oderFormID "+sort;
			m_pRecordset = conn.GetRecordSet(vSQL);
			break;
		case 5:
			vSQL= "select * from OderFormMessage where clientName='" +m_kStr+ "' order by oderFormID "+sort;
			m_pRecordset = conn.GetRecordSet(vSQL);	
			break;

		default:
			vSQL = "select * from OderFormMessage where productID='" +m_kStr+ "'order by oderFormID "+sort;
			m_pRecordset = conn.GetRecordSet(vSQL);	
			break;
		}
		while(!m_pRecordset->adoEOF)
		{
			conn.vOID = m_pRecordset->GetCollect("oderFormID");
			conn.vCID = m_pRecordset->GetCollect("clientID");
			conn.vCN  = m_pRecordset->GetCollect("clientName");
			conn.vPID = m_pRecordset->GetCollect("productID");
			conn.vPN = m_pRecordset->GetCollect("productName");
			conn.vOPNUM = m_pRecordset->GetCollect("productNum");
			conn.vCOP = m_pRecordset->GetCollect("companyContactPerson");
			conn.vClP = m_pRecordset->GetCollect("clientContactPerson");	
			conn.vTRADD = m_pRecordset->GetCollect("consignmentAddress");//AfxMessageBox("ok");
			conn.vFDATA = m_pRecordset->GetCollect("formDate");
			conn.vEDATA = m_pRecordset->GetCollect("endDate");
			conn.vREMARK = m_pRecordset->GetCollect("remark");
			// -- 添加数据到列表控件中 -- //
			nItem = m_listCtr.InsertItem(0xffff,(_bstr_t)conn.vOID,0);//;
			m_listCtr.SetItemText(nItem,1,(_bstr_t)conn.vCID);	
			m_listCtr.SetItemText(nItem,2,(_bstr_t)conn.vCN);
			m_listCtr.SetItemText(nItem,3,(_bstr_t)conn.vPID);
			m_listCtr.SetItemText(nItem,4,(_bstr_t)conn.vPN);
			m_listCtr.SetItemText(nItem,5,(_bstr_t)conn.vOPNUM);
			m_listCtr.SetItemText(nItem,6,(_bstr_t)conn.vCOP);
			m_listCtr.SetItemText(nItem,7,(_bstr_t)conn.vClP);
			m_listCtr.SetItemText(nItem,8,(_bstr_t)conn.vTRADD);
			m_listCtr.SetItemText(nItem,9,(_bstr_t)conn.vFDATA);
			m_listCtr.SetItemText(nItem,10,(_bstr_t)conn.vEDATA);
			m_listCtr.SetItemText(nItem,11,(_bstr_t)conn.vREMARK);

			m_pRecordset->MoveNext();
		}
		m_pRecordset->Close();
	}
	catch(_com_error e)
	{
		AfxMessageBox(e.ErrorMessage());
	}	
}

void SearOderDlg::OnSearchBtn() 
{
	UpdateData(true);
//	AfxMessageBox("ok");
	//if(m_odSeCtr.GetCurSel() < 0)
		//m_nSechType =0;
	//else
	//{
		switch(m_odSeCtr.GetCurSel())
		{
		 case 0: m_nSechType =1;break;
		 case 1: m_nSechType =2;break;
		 case 2: m_nSechType =3;break;
		 case 3: m_nSechType =4;break;
		 case 4: m_nSechType =5;break;
		 default: break;
		}
	//}
	this->odSech();
	
}

void SearOderDlg::OnSortBtn() 
	//OnSearchBtn();
{
m_nSechType =0;
this->odSech();
}

void SearOderDlg::OnBtnRefresh() 
{
	m_nSearch = _T("");
	m_nSort = _T("");
	m_kStr  = "";

	m_str1 = "";
	m_str2 = "";
	m_str3 = "";
	m_str4Date = "";
	m_str5 = "";
	m_str6 = "";
	m_str7 = "";
	m_str8 = "";
	m_str9 = "";
	m_str10 = "";
	m_str11 = "";
	m_str12 = "";

	UpdateData(false);

	m_nSechType = -1;
	this->oSechList();
}

void SearOderDlg::OnClickOinfoList(NMHDR* pNMHDR, LRESULT* pResult) 
{
	CString s[13];
	int num = m_listCtr.GetSelectionMark();//获当前行值
	for(int i=0;i <= 11;i++)
	{
		s[i] = m_listCtr.GetItemText(num,i);//"i"表示列号
	}
	m_str1 = s[0];
	m_str2 = s[1];
	m_str3 = s[2];
	m_str5 = s[3];
	m_str6 = s[4];
	m_str7 = s[5];
	m_str8 = s[6];
	m_str9 = s[7];
	m_str10 = s[8];
	m_str4Date= s[9];
	m_str11 = s[11];
	m_str12 = s[10];

	UpdateData(false);

	*pResult = 0;
}

HBRUSH SearOderDlg::OnCtlColor(CDC* pDC, CWnd* pWnd, UINT nCtlColor) 
{
	//HBRUSH hbr = CDialog::OnCtlColor(pDC, pWnd, nCtlColor);
	
COLORREF backColor = RGB(231, 231, 231); //office 2003背景色 
pDC->SetBkMode(TRANSPARENT);                //设置控件背景透明 
return CreateSolidBrush(backColor);            //创建背景刷子 	
	// TODO: Return a different brush if the default is not desired
	//return hbr;

	//HBRUSH hbr = CDialog::OnCtlColor(pDC,pWnd,nCtlColor); 
//pDC->SetBkMode(TRANSPARENT);   
//return    (HBRUSH)GetStockObject(NULL_BRUSH);   
}