company.cpp

利用OLEDB以数据库的方式打开Excell文件

// Company.cpp : implementation file
//

#include "stdafx.h"
#include "DBManager.h"
#include "Company.h"

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

/////////////////////////////////////////////////////////////////////////////
// CCompany dialog


CCompany::CCompany(CWnd* pParent /*=NULL*/)
	: CDialog(CCompany::IDD, pParent)
{
	//{{AFX_DATA_INIT(CCompany)
	m_company_account = _T("");
	m_company_address = _T("");
	m_company_area = _T("");
	m_company_bank = _T("");
	m_company_begin_date = _T("");
	m_company_id = _T("");
	m_company_kaihu_date = _T("");
	m_company_leader = _T("");
	m_company_mobile_num = _T("");
	m_company_money = _T("");
	m_company_name = _T("");
	m_company_person = _T("");
	m_company_phone = _T("");
	m_company_register_id = _T("");
	m_company_type = _T("");
	//}}AFX_DATA_INIT
}


void CCompany::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CCompany)
	DDX_Text(pDX, IDC_COMPANY_ACCOUNT, m_company_account);
	DDX_Text(pDX, IDC_COMPANY_ADDRESS, m_company_address);
	DDX_Text(pDX, IDC_COMPANY_AREA, m_company_area);
	DDX_Text(pDX, IDC_COMPANY_BANK, m_company_bank);
	DDX_Text(pDX, IDC_COMPANY_BEGIN_DATE, m_company_begin_date);
	DDX_Text(pDX, IDC_COMPANY_ID, m_company_id);
	DDX_Text(pDX, IDC_COMPANY_KAIHU_DATE, m_company_kaihu_date);
	DDX_Text(pDX, IDC_COMPANY_LEADER, m_company_leader);
	DDX_Text(pDX, IDC_COMPANY_MOBILE_NUM, m_company_mobile_num);
	DDX_Text(pDX, IDC_COMPANY_MONEY, m_company_money);
	DDX_Text(pDX, IDC_COMPANY_NAME, m_company_name);
	DDX_Text(pDX, IDC_COMPANY_PERSON, m_company_person);
	DDX_Text(pDX, IDC_COMPANY_PHONE, m_company_phone);
	DDX_Text(pDX, IDC_COMPANY_REGISTER_ID, m_company_register_id);
	DDX_Text(pDX, IDC_COMPANY_TYPE, m_company_type);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CCompany, CDialog)
	//{{AFX_MSG_MAP(CCompany)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CCompany message handlers

BOOL CCompany::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	CRecordset rs(m_company_pCDataBase);
	CString SQL_String,csSQL,m_cs_gongsi;
	m_cs_gongsi=gongsi;
	SQL_String="select * from ["+m_cs_gongsi+"$] where [单位名称]='%s'";
	csSQL.Format(SQL_String,m_cs_company_name);
	rs.Open(CRecordset::dynaset,(csSQL));
	try
	{
		rs.GetFieldValue("序号",m_company_id);
		rs.GetFieldValue("单位名称",m_company_name);
		rs.GetFieldValue("手机总数",m_company_mobile_num);
		rs.GetFieldValue("负责人",m_company_person);
		rs.GetFieldValue("联系电话",m_company_phone);
		rs.GetFieldValue("地址",m_company_address);
		rs.GetFieldValue("法定代表人",m_company_leader);
		rs.GetFieldValue("注册资本",m_company_money);
		rs.GetFieldValue("企业类型",m_company_type);
		rs.GetFieldValue("注册号",m_company_register_id);
		rs.GetFieldValue("营业期限",m_company_area);
		rs.GetFieldValue("成立日期",m_company_begin_date);
		rs.GetFieldValue("开户银行",m_company_bank);
		rs.GetFieldValue("银行帐号",m_company_account);
		rs.GetFieldValue("开户日期",m_company_kaihu_date);
	}
	catch( ... )
	{
		MessageBox( "公司信息不匹配","系统提示", MB_ICONINFORMATION ); 
	}

	SetDlgItemText(IDC_COMPANY_ACCOUNT, m_company_account);
	SetDlgItemText(IDC_COMPANY_ADDRESS, m_company_address);
	SetDlgItemText(IDC_COMPANY_AREA, m_company_area);
	SetDlgItemText(IDC_COMPANY_BANK, m_company_bank);
	SetDlgItemText(IDC_COMPANY_BEGIN_DATE, m_company_begin_date);
	SetDlgItemText(IDC_COMPANY_ID, m_company_id);
	SetDlgItemText(IDC_COMPANY_KAIHU_DATE, m_company_kaihu_date);
	SetDlgItemText(IDC_COMPANY_LEADER, m_company_leader);
	SetDlgItemText(IDC_COMPANY_MOBILE_NUM, m_company_mobile_num);
	SetDlgItemText(IDC_COMPANY_MONEY, m_company_money);
	SetDlgItemText(IDC_COMPANY_NAME, m_company_name);
	SetDlgItemText(IDC_COMPANY_PERSON, m_company_person);
	SetDlgItemText(IDC_COMPANY_PHONE, m_company_phone);
	SetDlgItemText(IDC_COMPANY_REGISTER_ID, m_company_register_id);
	SetDlgItemText(IDC_COMPANY_TYPE, m_company_type);
	rs.Close();
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CCompany::OnOK() 
{
	// TODO: Add extra validation here
	if (m_company_name.GetLength()!=0 && m_company_mobile_num.GetLength()!=0 && m_company_person.GetLength()!=0 && m_company_phone.GetLength()!=0 && m_company_address.GetLength()!=0 && m_company_leader.GetLength()!=0 && m_company_money.GetLength()!=0 && m_company_type.GetLength()!=0 && m_company_register_id.GetLength()!=0 && m_company_area.GetLength()!=0 && m_company_begin_date.GetLength()!=0 && m_company_bank.GetLength()!=0 && m_company_account.GetLength()!=0 && m_company_kaihu_date.GetLength()!=0)
	{
		GetDlgItemText(IDC_COMPANY_ACCOUNT, m_company_account);
		GetDlgItemText(IDC_COMPANY_ADDRESS, m_company_address);
		GetDlgItemText(IDC_COMPANY_AREA, m_company_area);
		GetDlgItemText(IDC_COMPANY_BANK, m_company_bank);
		GetDlgItemText(IDC_COMPANY_BEGIN_DATE, m_company_begin_date);
		GetDlgItemText(IDC_COMPANY_ID, m_company_id);
		GetDlgItemText(IDC_COMPANY_KAIHU_DATE, m_company_kaihu_date);
		GetDlgItemText(IDC_COMPANY_LEADER, m_company_leader);
		GetDlgItemText(IDC_COMPANY_MOBILE_NUM, m_company_mobile_num);
		GetDlgItemText(IDC_COMPANY_MONEY, m_company_money);
		GetDlgItemText(IDC_COMPANY_NAME, m_company_name);
		GetDlgItemText(IDC_COMPANY_PERSON, m_company_person);
		GetDlgItemText(IDC_COMPANY_PHONE, m_company_phone);
		GetDlgItemText(IDC_COMPANY_REGISTER_ID, m_company_register_id);
		GetDlgItemText(IDC_COMPANY_TYPE, m_company_type);
		CString SQL_company_update,csSQL_update,cs_gongsi;
		cs_gongsi=gongsi;
		SQL_company_update="update ["+cs_gongsi+"$] set [单位名称]='%s',[手机总数]=%s,[负责人]='%s',[联系电话]='%s',[地址]='%s',[法定代表人]='%s',[注册资本]='%s',[企业类型]='%s',[注册号]=%s,[营业期限]='%s',[成立日期]='%s',[开户银行]='%s',[银行帐号]=%s,[开户日期]='%s' where [序号]=%s";
		csSQL_update.Format(SQL_company_update,m_company_name,m_company_mobile_num,m_company_person,m_company_phone,m_company_address,m_company_leader,m_company_money,m_company_type,m_company_register_id,m_company_area,m_company_begin_date,m_company_bank,m_company_account,m_company_kaihu_date,m_company_id);
		m_company_pCDataBase->ExecuteSQL(csSQL_update);
	}
	else
		MessageBox("不能有空白项目!","系统提示");
	CDialog::OnOK();
}