brandsetdlg.cpp

自已做的简单的库存管理软件。包含员工信息管理等

// BrandsetDlg.cpp : implementation file
//

#include "stdafx.h"
#include "BrandsetDlg.h"
#include "changebrand.h"

int last_item;
extern _ConnectionPtr pMyConnect;

bool bAdd;
int index;
CString str_data[10][8];

// CBrandsetDlg dialog

IMPLEMENT_DYNAMIC(CBrandsetDlg, CDialog)

CBrandsetDlg::CBrandsetDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CBrandsetDlg::IDD, pParent)
	, num_of_brand(0)
{
	for( int i = 0; i < 10; i++ )
	{
		for ( int j = 0; j < 8; j++ )
		{
			str_data[i][j] = _T("");
		}
	}

	bNeedUpdateItem = FALSE;
	the_last = 0;
	bAdd = TRUE;
	index = 0;
}

CBrandsetDlg::~CBrandsetDlg()
{
}

void CBrandsetDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	DDX_Text(pDX, IDC_EDIT_BRAND1, str_data[0][0]);
	DDX_Text(pDX, IDC_EDIT_BRAND2, str_data[1][0]);
	DDX_Text(pDX, IDC_EDIT_BRAND3, str_data[2][0]);
	DDX_Text(pDX, IDC_EDIT_BRAND4, str_data[3][0]);
	DDX_Text(pDX, IDC_EDIT_BRAND5, str_data[4][0]);
	DDX_Text(pDX, IDC_EDIT_BRAND6, str_data[5][0]);
	DDX_Text(pDX, IDC_EDIT_BRAND7, str_data[6][0]);
	DDX_Text(pDX, IDC_EDIT_BRAND8, str_data[7][0]);
	DDX_Text(pDX, IDC_EDIT_BRAND9, str_data[8][0]);
	DDX_Text(pDX, IDC_EDIT_BRAND10, str_data[9][0]);

	DDX_Text(pDX, IDC_EDIT_NAME1, str_data[0][1]);
	DDX_Text(pDX, IDC_EDIT_NAME2, str_data[1][1]);
	DDX_Text(pDX, IDC_EDIT_NAME3, str_data[2][1]);
	DDX_Text(pDX, IDC_EDIT_NAME4, str_data[3][1]);
	DDX_Text(pDX, IDC_EDIT_NAME5, str_data[4][1]);
	DDX_Text(pDX, IDC_EDIT_NAME6, str_data[5][1]);
	DDX_Text(pDX, IDC_EDIT_NAME7, str_data[6][1]);
	DDX_Text(pDX, IDC_EDIT_NAME8, str_data[7][1]);
	DDX_Text(pDX, IDC_EDIT_NAME9, str_data[8][1]);
	DDX_Text(pDX, IDC_EDIT_NAME10, str_data[9][1]);

	DDX_Text(pDX, IDC_EDIT_TEL1, str_data[0][2]);
	DDX_Text(pDX, IDC_EDIT_TEL2, str_data[1][2]);
	DDX_Text(pDX, IDC_EDIT_TEL3, str_data[2][2]);
	DDX_Text(pDX, IDC_EDIT_TEL4, str_data[3][2]);
	DDX_Text(pDX, IDC_EDIT_TEL5, str_data[4][2]);
	DDX_Text(pDX, IDC_EDIT_TEL6, str_data[5][2]);
	DDX_Text(pDX, IDC_EDIT_TEL7, str_data[6][2]);
	DDX_Text(pDX, IDC_EDIT_TEL8, str_data[7][2]);
	DDX_Text(pDX, IDC_EDIT_TEL9, str_data[8][2]);
	DDX_Text(pDX, IDC_EDIT_TEL10, str_data[9][2]);

	DDX_Text(pDX, IDC_EDIT_FAX1, str_data[0][3]);
	DDX_Text(pDX, IDC_EDIT_FAX2, str_data[1][3]);
	DDX_Text(pDX, IDC_EDIT_FAX3, str_data[2][3]);
	DDX_Text(pDX, IDC_EDIT_FAX4, str_data[3][3]);
	DDX_Text(pDX, IDC_EDIT_FAX5, str_data[4][3]);
	DDX_Text(pDX, IDC_EDIT_FAX6, str_data[5][3]);
	DDX_Text(pDX, IDC_EDIT_FAX7, str_data[6][3]);
	DDX_Text(pDX, IDC_EDIT_FAX8, str_data[7][3]);
	DDX_Text(pDX, IDC_EDIT_FAX9, str_data[8][3]);
	DDX_Text(pDX, IDC_EDIT_FAX10, str_data[9][3]);

	DDX_Text(pDX, IDC_EDIT_EMAIL1, str_data[0][4]);
	DDX_Text(pDX, IDC_EDIT_EMAIL2, str_data[1][4]);
	DDX_Text(pDX, IDC_EDIT_EMAIL3, str_data[2][4]);
	DDX_Text(pDX, IDC_EDIT_EMAIL4, str_data[3][4]);
	DDX_Text(pDX, IDC_EDIT_EMAIL5, str_data[4][4]);
	DDX_Text(pDX, IDC_EDIT_EMAIL6, str_data[5][4]);
	DDX_Text(pDX, IDC_EDIT_EMAIL7, str_data[6][4]);
	DDX_Text(pDX, IDC_EDIT_EMAIL8, str_data[7][4]);
	DDX_Text(pDX, IDC_EDIT_EMAIL9, str_data[8][4]);
	DDX_Text(pDX, IDC_EDIT_EMAIL10, str_data[9][4]);

	DDX_Text(pDX, IDC_EDIT_WEBSITE1, str_data[0][5]);
	DDX_Text(pDX, IDC_EDIT_WEBSITE2, str_data[1][5]);
	DDX_Text(pDX, IDC_EDIT_WEBSITE3, str_data[2][5]);
	DDX_Text(pDX, IDC_EDIT_WEBSITE4, str_data[3][5]);
	DDX_Text(pDX, IDC_EDIT_WEBSITE5, str_data[4][5]);
	DDX_Text(pDX, IDC_EDIT_WEBSITE6, str_data[5][5]);
	DDX_Text(pDX, IDC_EDIT_WEBSITE7, str_data[6][5]);
	DDX_Text(pDX, IDC_EDIT_WEBSITE8, str_data[7][5]);
	DDX_Text(pDX, IDC_EDIT_WEBSITE9, str_data[8][5]);
	DDX_Text(pDX, IDC_EDIT_WEBSITE10, str_data[9][5]);
	DDX_Control(pDX, IDC_STATIC_PAGE, m_page);
}


BEGIN_MESSAGE_MAP(CBrandsetDlg, CDialog)
	ON_BN_CLICKED(IDOK, &CBrandsetDlg::OnBnClickedOk)
	ON_BN_CLICKED(IDC_BUTTON_ADD, &CBrandsetDlg::OnBnClickedButtonAdd)
	ON_BN_CLICKED(IDC_BUTTON_UP, &CBrandsetDlg::OnBnClickedButtonUp)
	ON_BN_CLICKED(IDC_BUTTON_DOWN, &CBrandsetDlg::OnBnClickedButtonDown)
	ON_BN_CLICKED(IDC_CHECK1, &CBrandsetDlg::OnBnClickedCheck1)
	ON_BN_CLICKED(IDC_CHECK2, &CBrandsetDlg::OnBnClickedCheck2)
	ON_BN_CLICKED(IDC_CHECK3, &CBrandsetDlg::OnBnClickedCheck3)
	ON_BN_CLICKED(IDC_CHECK4, &CBrandsetDlg::OnBnClickedCheck4)
	ON_BN_CLICKED(IDC_CHECK5, &CBrandsetDlg::OnBnClickedCheck5)
	ON_BN_CLICKED(IDC_CHECK6, &CBrandsetDlg::OnBnClickedCheck6)
	ON_BN_CLICKED(IDC_CHECK7, &CBrandsetDlg::OnBnClickedCheck7)
	ON_BN_CLICKED(IDC_CHECK8, &CBrandsetDlg::OnBnClickedCheck8)
	ON_BN_CLICKED(IDC_CHECK9, &CBrandsetDlg::OnBnClickedCheck9)
	ON_BN_CLICKED(IDC_CHECK10, &CBrandsetDlg::OnBnClickedCheck10)
	ON_BN_CLICKED(IDC_BUTTON_DELETE, &CBrandsetDlg::OnBnClickedButtonDelete)
	ON_BN_CLICKED(IDC_BUTTON_MODIFY, &CBrandsetDlg::OnBnClickedButtonModify)
END_MESSAGE_MAP()



BOOL CBrandsetDlg::OnInitDialog()
{
	CDialog::OnInitDialog();



	CheckBoxId[0] = IDC_CHECK1;
	CheckBoxId[1] = IDC_CHECK2;
	CheckBoxId[2] = IDC_CHECK3;
	CheckBoxId[3] = IDC_CHECK4;
	CheckBoxId[4] = IDC_CHECK5;
	CheckBoxId[5] = IDC_CHECK6;
	CheckBoxId[6] = IDC_CHECK7;
	CheckBoxId[7] = IDC_CHECK8;
	CheckBoxId[8] = IDC_CHECK9;
	CheckBoxId[9] = IDC_CHECK10;

	Item[0][0] = IDC_EDIT_BRAND1;
	Item[0][1] = IDC_EDIT_NAME1;
	Item[0][2] = IDC_EDIT_TEL1;
	Item[0][3] = IDC_EDIT_FAX1;
	Item[0][4] = IDC_EDIT_EMAIL1;
	Item[0][5] = IDC_EDIT_WEBSITE1;

	Item[1][0] = IDC_EDIT_BRAND2;
	Item[1][1] = IDC_EDIT_NAME2;
	Item[1][2] = IDC_EDIT_TEL2;
	Item[1][3] = IDC_EDIT_FAX2;
	Item[1][4] = IDC_EDIT_EMAIL2;
	Item[1][5] = IDC_EDIT_WEBSITE2;

	Item[2][0] = IDC_EDIT_BRAND3;
	Item[2][1] = IDC_EDIT_NAME3;
	Item[2][2] = IDC_EDIT_TEL3;
	Item[2][3] = IDC_EDIT_FAX3;
	Item[2][4] = IDC_EDIT_EMAIL3;
	Item[2][5] = IDC_EDIT_WEBSITE3;

	Item[3][0] = IDC_EDIT_BRAND4;
	Item[3][1] = IDC_EDIT_NAME4;
	Item[3][2] = IDC_EDIT_TEL4;
	Item[3][3] = IDC_EDIT_FAX4;
	Item[3][4] = IDC_EDIT_EMAIL4;
	Item[3][5] = IDC_EDIT_WEBSITE4;

	Item[4][0] = IDC_EDIT_BRAND5;
	Item[4][1] = IDC_EDIT_NAME5;
	Item[4][2] = IDC_EDIT_TEL5;
	Item[4][3] = IDC_EDIT_FAX5;
	Item[4][4] = IDC_EDIT_EMAIL5;
	Item[4][5] = IDC_EDIT_WEBSITE5;

	Item[5][0] = IDC_EDIT_BRAND6;
	Item[5][1] = IDC_EDIT_NAME6;
	Item[5][2] = IDC_EDIT_TEL6;
	Item[5][3] = IDC_EDIT_FAX6;
	Item[5][4] = IDC_EDIT_EMAIL6;
	Item[5][5] = IDC_EDIT_WEBSITE6;

	Item[6][0] = IDC_EDIT_BRAND7;
	Item[6][1] = IDC_EDIT_NAME7;
	Item[6][2] = IDC_EDIT_TEL7;
	Item[6][3] = IDC_EDIT_FAX7;
	Item[6][4] = IDC_EDIT_EMAIL7;
	Item[6][5] = IDC_EDIT_WEBSITE7;

	Item[7][0] = IDC_EDIT_BRAND8;
	Item[7][1] = IDC_EDIT_NAME8;
	Item[7][2] = IDC_EDIT_TEL8;
	Item[7][3] = IDC_EDIT_FAX8;
	Item[7][4] = IDC_EDIT_EMAIL8;
	Item[7][5] = IDC_EDIT_WEBSITE8;

	Item[8][0] = IDC_EDIT_BRAND9;
	Item[8][1] = IDC_EDIT_NAME9;
	Item[8][2] = IDC_EDIT_TEL9;
	Item[8][3] = IDC_EDIT_FAX9;
	Item[8][4] = IDC_EDIT_EMAIL9;
	Item[8][5] = IDC_EDIT_WEBSITE9;

	Item[9][0] = IDC_EDIT_BRAND10;
	Item[9][1] = IDC_EDIT_NAME10;
	Item[9][2] = IDC_EDIT_TEL10;
	Item[9][3] = IDC_EDIT_FAX10;
	Item[9][4] = IDC_EDIT_EMAIL10;
	Item[9][5] = IDC_EDIT_WEBSITE10;

			
	if ( !ReadDB())
	{
		return FALSE;
	}

	cur_page = 1;
	DisplayBrand( cur_page );


	return FALSE;// 将焦点设置到控件，否则返回 TRUE

}


// CBrandsetDlg message handlers

void CBrandsetDlg::OnBnClickedOk()
{
	// TODO: Add your control notification handler code here
	//OnOK();

	/*UpdateData(TRUE);

	for( int i = 0; i < 10; i++ )
	{
		//CHECK the Flag,if A,the item is new need add to DB,B can't be use, C had been modification and need add to DB
		if ( str_data[i][7] == _T("A") )
		{
			//BRAND
			if ( str_data[i][0].GetLength() > 20 )
			{
				AfxMessageBox(_T("品牌长度超出限制！"));
				return;
			}
			//COMPANY
			if ( str_data[i][1].GetLength() > 50 )
			{
				AfxMessageBox(_T("长度超出限制！"));
				return;
			}
			//TEL
			if ( str_data[i][2].GetLength() > 20 )
			{
				AfxMessageBox(_T("电话长度超出限制！"));
				return;
			}
			//FAX
			if ( str_data[i][3].GetLength() > 20 )
			{
				AfxMessageBox(_T("传真长度超出限制！"));
				return;
			}
			//EMAIL
			if ( str_data[i][4].GetLength() > 30 )
			{
				AfxMessageBox(_T("电邮长度超出限制！"));
				return;
			}
			//WEBSITE
			if ( str_data[i][5].GetLength() > 30 )
			{
				AfxMessageBox(_T("网址长度超出限制！"));
				return;
			}



			CString m_strSql; 
			//_RecordsetPtr m_pRecordset;
			_variant_t RecordsAffected;
				
			
			m_strSql.Format(_T("update BRAND_TABLE set BRAND='") +str_data[i][0]+ _T("',COMPANY='") +str_data[i][1]+ _T("',TEL='") +str_data[i][2]+ _T("',FAX='") +str_data[i][3]+ _T("',EMAIL='") +str_data[i][4]+ _T("',WEBSITE='") +str_data[i][5]+ _T("' where( SN=") +str_data[i][6]+ _T(")") );
			bool bSuccess = pMyConnect->Execute(_bstr_t(m_strSql),&RecordsAffected,adCmdText);
			if( !bSuccess )
			{
				AfxMessageBox(_T("更新品牌资料失败，请重启系统！"));
				return;
			}
			AfxMessageBox(_T("更新品牌资料成功！"));
		}
	}
	OnOK();*/
	
}

void CBrandsetDlg::OnBnClickedButtonAdd()
{
	// TODO: Add your control notification handler code here
	ClearSelected(0);

	bAdd = TRUE;

	CChangeBrand changebrand;
	INT_PTR nResponse = changebrand.DoModal();
	if (nResponse == IDOK)
	{
		// TODO: 在此处放置处理何时用“确定”来关闭
		//  对话框的代码
	}
	else if (nResponse == IDCANCEL)
	{
		// TODO: 在此放置处理何时用“取消”来关闭
		//  对话框的代码
	}


	

    if ( !ReadDB())
	{
		return;
	}

	cur_page= total_page;
	DisplayBrand( cur_page );

	
	str_data[the_last-1][7] = _T("A");

	
}


int CBrandsetDlg::ReadDB()
{

	ClearDisplay();
	DisableCheckBox();
	DisableUpDown();

	num_of_brand = Init();
	if ( num_of_brand == 0 )
	{
		return 0;
	}

	total_page = num_of_brand / 10 + 1;
	if (  num_of_brand % 10 == 0 )
	{
		total_page--;
	}

	SetUpDown();

	return 1;

}

int CBrandsetDlg::Init(void)
{
	int number = 0;

	_RecordsetPtr m_pRs; 
	CString m_strSql; 
	
	
	m_strSql.Format(_T("select SN from BRAND_TABLE where ( SN > 0)") ); 
	m_pRs.CreateInstance( __uuidof(Recordset) ); 
	m_pRs->Open( _bstr_t(m_strSql), _variant_t((IDispatch *)pMyConnect,true), adOpenKeyset, adLockOptimistic, adCmdText);  
		
	
	try
	{
		m_pRs->MoveFirst(); 
		while(m_pRs->adoEOF==VARIANT_FALSE)	
		{
			//Retrieve column's value: 	   
						
			_variant_t   TheValue;
			_bstr_t tmp;

			TheValue = m_pRs->Fields->GetItem(_variant_t("SN"))->Value;
			tmp=(_bstr_t)TheValue; 			
			CString str_tmp0 = tmp;
			str_sn_num[number] = str_tmp0;

			number++;
			if ( number == BRAND_MAX_NUM  )
				break;
			//Do something what you want to do:	......
			m_pRs->MoveNext(); 
		}		
	}
	catch (_com_error &e)
	{
		//::MessageBox(NULL,e.Description(),(LPCTSTR)(_T("警告")),MB_OK);
		
	}
	m_pRs->Close(); 

	return number;
}


void CBrandsetDlg::DisplayBrand( int index )
{
	ClearDisplay();

    int first_item = ( index - 1) * 10;
	CString   str1;
	str1 = str_sn_num[first_item];