seodinfodlg.cpp

订单管理系统

// SeOdInfoDlg.cpp : implementation file
//

#include "stdafx.h"
#include "ordermanagement.h"
#include "SeOdInfoDlg.h"

#include "SSeOdInfoDlg.h"
#include "ADOConn.h"

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

/////////////////////////////////////////////////////////////////////////////
// SeOdInfoDlg dialog


SeOdInfoDlg::SeOdInfoDlg(CWnd* pParent /*=NULL*/)
	: CDialog(SeOdInfoDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(SeOdInfoDlg)
	m_str1 = _T("");
	m_str10 = _T("");
	m_str2 = _T("");
	m_str3 = _T("");
	m_str4 = _T("");
	m_str5 = _T("");
	m_str6 = _T("");
	m_str7 = _T("");
	m_str8 = _T("");
	m_str9 = _T("");
	m_str11 = _T("");
	//}}AFX_DATA_INIT
}


void SeOdInfoDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(SeOdInfoDlg)
	DDX_Text(pDX, IDC_EDIT1, m_str1);
	DDX_Text(pDX, IDC_EDIT10, m_str10);
	DDX_Text(pDX, IDC_EDIT2, m_str2);
	DDX_Text(pDX, IDC_EDIT3, m_str3);
	DDX_Text(pDX, IDC_EDIT4, m_str4);
	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_EDIT11, m_str11);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// SeOdInfoDlg message handlers



void SeOdInfoDlg::OnCancel() 
{
	// TODO: Add extra cleanup here
	
	CDialog::OnCancel();
}

BOOL SeOdInfoDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	//添加窗口图标
	SetIcon(m_hIcon, TRUE);			// Set big icon
	SetIcon(m_hIcon, FALSE);		// Set small icon

	m_str1 = s[0];
	m_str2 = s[1];
	m_str3 = s[2];
	m_str4 = s[3];
	m_str5 = s[4];
	m_str6 = s[5];
	m_str7 = s[6];
	m_str8 = s[7];
	m_str9 = s[8];
	m_str10 =s[9];
	m_str11 =s[10];
	UpdateData(false);
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void SeOdInfoDlg::OnOK() 
{
	UpdateData(true);
	ADOConn mSconn;
	_bstr_t mSQL;

	try{
		//如果Concection对象为空,则重新连接  productNum ='"+m_str7+"',
		if(mSconn.m_pConn == NULL)  
			mSconn.OnInitADOConn();

		if(MessageBox("是否确定更改？","请确认",MB_YESNO) == IDYES)
		{
			mSQL ="UPDATE OderFormMessage SET productNum ='"+m_str7+"',clientContactPerson='"+m_str8+"',consignmentAddress='"+m_str9+"',remark='"+m_str10+"' WHERE OderFormID='"+m_str2+"'";
			mSconn.ExecuteSQL(mSQL);

				mSQL ="UPDATE ConsignmentForm SET orderstate ='"+m_str11+"' WHERE sendOderID='"+m_str1+"'";

			if(mSconn.ExecuteSQL(mSQL))
			{
				AfxMessageBox("更改成功!");	
				CDialog::OnOK();
			}
//			else

		}
	}
	catch(_com_error e)
	{
		AfxMessageBox(e.ErrorMessage());
	}
}



HBRUSH SeOdInfoDlg::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);   
}