// DelPhotoSet.cpp : implementation file
//

#include "stdafx.h"
#include "dbserver.h"
#include "DelPhotoSet.h"
#include "mysqldata.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// DelPhotoSet dialog
DelPhotoSet::DelPhotoSet(CWnd* pParent /*=NULL*/)
	: CDialog(DelPhotoSet::IDD, pParent)
{
	//{{AFX_DATA_INIT(DelPhotoSet)
	m_check1 = FALSE;
	m_check2 = FALSE;
	m_check3 = FALSE;
	m_check4 = FALSE;
	m_edit1 = 12;
	m_edit2 = 12;
	m_edit3 = 12;
	m_edit4 = 12;
	//}}AFX_DATA_INIT
}

void DelPhotoSet::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(DelPhotoSet)
	DDX_Control(pDX, IDC_SPIN6, m_spin4);
	DDX_Control(pDX, IDC_SPIN5, m_spin3);
	DDX_Control(pDX, IDC_SPIN4, m_spin2);
	DDX_Control(pDX, IDC_SPIN1, m_spin1);
	DDX_Check(pDX, IDC_CHECK1, m_check1);
	DDX_Check(pDX, IDC_CHECK2, m_check2);
	DDX_Check(pDX, IDC_CHECK3, m_check3);
	DDX_Check(pDX, IDC_CHECK4, m_check4);
	DDX_Text(pDX, IDC_EDIT1, m_edit1);
 
	DDX_Text(pDX, IDC_EDIT2, m_edit2);
 
	DDX_Text(pDX, IDC_EDIT3, m_edit3);
 
	DDX_Text(pDX, IDC_EDIT4, m_edit4);
 
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// DelPhotoSet message handlers

BOOL DelPhotoSet::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_spin1.SetRange (1, 1200);
	m_spin2.SetRange (1, 1200);
	m_spin3.SetRange (1, 1200);
	m_spin4.SetRange (1, 1200);

  
	CDatabase *pMaindb = NULL;
	ODBCConnGuard ConnGuard(pMaindb , -1, 3000);
	if ( pMaindb )
	{
		CRstversion rsSt; 
		rsSt.m_pDatabase=pMaindb; 
		rsSt.Open();
		if(!rsSt.IsEOF())
		{
			m_check1=atoi(rsSt.m_delcheck1);
			m_check2=atoi(rsSt.m_delcheck2);
			m_check3=atoi(rsSt.m_delcheck3);
			m_check4=atoi(rsSt.m_delcheck4);
			m_edit1=atoi(rsSt.m_deledit1); 
			m_edit2=atoi(rsSt.m_deledit2); 
			m_edit3=atoi(rsSt.m_deledit3); 
			m_edit4=atoi(rsSt.m_deledit4); 
			if(m_edit1==0)m_edit1=12;
			if(m_edit2==0)m_edit2=12;
			if(m_edit3==0)m_edit3=12;
			if(m_edit4==0)m_edit4=12;

		}
		rsSt.Close(); 

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

void DelPhotoSet::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData();
	m_edit1=min(max(m_edit1,1),1200);
	m_edit2=min(max(m_edit2,1),1200);
	m_edit3=min(max(m_edit3,1),1200);
	m_edit4=min(max(m_edit4,1),1200);
	CString sql;
	sql.Format("update version set [delcheck1]='%d',[delcheck2]='%d',[delcheck3]='%d',[delcheck4]='%d',[deledit1]='%d',[deledit2]='%d',[deledit3]='%d',[deledit4]='%d'", 
		m_check1,m_check2,m_check3,m_check4,m_edit1, m_edit2,m_edit3,m_edit4);

	CDatabase *pMaindb = NULL;
	ODBCConnGuard ConnGuard(pMaindb , -1, 3000);
	if ( pMaindb == NULL )
		return;
	pMaindb->ExecuteSQL (sql);
	AfxMessageBox("保存成功!", MB_ICONINFORMATION);
	CDialog::OnOK();
}

HBRUSH DelPhotoSet::OnCtlColor(CDC* pDC, CWnd* pWnd, UINT nCtlColor) 
{
	HBRUSH hbr = CDialog::OnCtlColor(pDC, pWnd, nCtlColor);
	// TODO: Change any attributes of the DC here
	if (nCtlColor==CTLCOLOR_STATIC && pWnd->GetDlgCtrlID ()==IDC_STATIC1)
	{
		pDC-> SetBkMode(TRANSPARENT); //设置字体背景为透明
		return (HBRUSH)::GetStockObject(NULL_BRUSH); // 设置背景色
	}
	// TODO: Return a different brush if the default is not desired
	return hbr;
}