⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 editdlg.cpp

📁 利用OLEDB以数据库的方式打开Excell文件
💻 CPP
字号:
🔍 
// EditDlg.cpp : implementation file
//

#include "stdafx.h"
#include "DBManager.h"
#include "DBManagerDlg.h"
#include "EditDlg.h"


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

/////////////////////////////////////////////////////////////////////////////
// CEditDlg dialog


CEditDlg::CEditDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CEditDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CEditDlg)
	m_cdma_type = _T("");
	m_company = _T("");
	m_contract_id = _T("");
	m_getphone = _T("");
	m_givemoney = _T("");
	m_id = _T("");
	m_lowest = _T("");
	m_money = _T("");
	m_name = _T("");
	m_person = _T("");
	m_person_id = _T("");
	m_phone_id = _T("");
	m_six = _T("");
	m_three = _T("");
	m_type = _T("");
	m_uim = _T("");
	m_use_money1 = _T("");
	m_yongjin1 = _T("");
	m_qianfei1 = _T("");
	m_six_shuoming = _T("");
	m_three_shuoming = _T("");
	m_bFlag = FALSE;
	//}}AFX_DATA_INIT
}


void CEditDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CEditDlg)
	DDX_Control(pDX, IDC_USE_MONEY, m_use_money);
	DDX_Control(pDX, IDC_QIANFEI, m_qianfei);
	DDX_Control(pDX, IDC_DATATIME, m_yongjin);
	DDX_Text(pDX, IDC_CDMA_TYPE, m_cdma_type);
	DDX_Text(pDX, IDC_COMPANY, m_company);
	DDX_Text(pDX, IDC_CONTRACT_ID, m_contract_id);
	DDX_Text(pDX, IDC_GETPHONE, m_getphone);
	DDX_Text(pDX, IDC_GIVEMONEY, m_givemoney);
	DDX_Text(pDX, IDC_ID, m_id);
	DDX_Text(pDX, IDC_LOWEST, m_lowest);
	DDX_Text(pDX, IDC_MONEY, m_money);
	DDX_Text(pDX, IDC_NAME, m_name);
	DDX_Text(pDX, IDC_PERSON, m_person);
	DDX_Text(pDX, IDC_PERSON_ID, m_person_id);
	DDX_Text(pDX, IDC_PHONE_ID, m_phone_id);
	DDX_Text(pDX, IDC_SIX, m_six);
	DDX_Text(pDX, IDC_THREE, m_three);
	DDX_Text(pDX, IDC_TYPE, m_type);
	DDX_Text(pDX, IDC_UIM, m_uim);
	DDX_Text(pDX, IDC_USE_MONEY1, m_use_money1);
	DDX_Text(pDX, IDC_YONGJIN1, m_yongjin1);
	DDX_Text(pDX, IDC_QIANFEI1, m_qianfei1);
	DDX_Text(pDX, IDC_SIX_SHUOMING, m_six_shuoming);
	DDX_Text(pDX, IDC_THREE_SHUOMING, m_three_shuoming);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CEditDlg, CDialog)
	//{{AFX_MSG_MAP(CEditDlg)
	ON_BN_CLICKED(ID_XIUGAI, OnXiugai)
	ON_BN_CLICKED(ID_DELETE, OnDelete)
	ON_CBN_SELCHANGE(IDC_DATATIME, OnSelchangeDatatime)
	ON_CBN_SELCHANGE(IDC_USE_MONEY, OnSelchangeUseMoney)
	ON_CBN_SELCHANGE(IDC_QIANFEI, OnSelchangeQianfei)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CEditDlg message handlers

BOOL CEditDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
        	
    // TODO: Add extra initialization here
  	GetDlgItem(IDC_UIM)->EnableWindow(false);
    GetDlgItem(IDC_CDMA_TYPE)->EnableWindow(false);
    GetDlgItem(IDC_TYPE)->EnableWindow(false);
  	GetDlgItem(IDC_LOWEST)->EnableWindow(false);
  	GetDlgItem(IDC_NAME)->EnableWindow(false);
   	GetDlgItem(IDC_PERSON_ID)->EnableWindow(false);
   	GetDlgItem(IDC_GIVEMONEY)->EnableWindow(false);
    GetDlgItem(IDC_GETPHONE)->EnableWindow(false);
	GetDlgItem(IDC_PHONE_ID)->EnableWindow(false);
    GetDlgItem(IDC_COMPANY)->EnableWindow(false);
    GetDlgItem(IDC_CONTRACT_ID)->EnableWindow(false);
    GetDlgItem(IDC_PERSON)->EnableWindow(false);
   	GetDlgItem(IDC_MONEY)->EnableWindow(false);
    GetDlgItem(IDC_THREE)->EnableWindow(false);
   	GetDlgItem(IDC_SIX)->EnableWindow(false);
	GetDlgItem(IDOK)->EnableWindow(false);
	//*****************************动态显示下拉菜单*******************//
	CRecordset rs(m_pCDataBase);
	CString m_biaoming_fieldinfo,SQl1;
	CStringArray  content_value_buf;
	m_biaoming_fieldinfo=biaoming;
	SQl1="select * from ["+m_biaoming_fieldinfo+"$]";
	rs.Open(CRecordset::dynaset,(SQl1));
	int col_count=rs.GetODBCFieldCount();
	for (int col_fieldinfo=16;col_fieldinfo<col_count;col_fieldinfo++)
	{
		CODBCFieldInfo  content_value;
		CString values_field;	
		rs.GetODBCFieldInfo((int)col_fieldinfo,content_value);
		values_field=content_value.m_strName;
		content_value_buf.Add(values_field);
	}
	rs.Close();//120
	for ( col_fieldinfo=2;col_fieldinfo<42;col_fieldinfo++)
	{
		CString values;
		values=content_value_buf.GetAt(col_fieldinfo);
		m_yongjin.AddString(values);
	}

	for ( col_fieldinfo=42;col_fieldinfo<82;col_fieldinfo++)
	{
		CString values;
		values=content_value_buf.GetAt(col_fieldinfo);
		m_use_money.AddString(values);
	}

	for ( col_fieldinfo=82;col_fieldinfo<123;col_fieldinfo++)
	{
		CString values;
		values=content_value_buf.GetAt(col_fieldinfo);
		m_qianfei.AddString(values);
	}
	//****************************************************************//
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CEditDlg::OnXiugai() 
{
  	GetDlgItem(IDC_UIM)->EnableWindow(true);
    GetDlgItem(IDC_CDMA_TYPE)->EnableWindow(true);
    GetDlgItem(IDC_TYPE)->EnableWindow(true);
  	GetDlgItem(IDC_LOWEST)->EnableWindow(true);
  	GetDlgItem(IDC_NAME)->EnableWindow(true);
   	GetDlgItem(IDC_PERSON_ID)->EnableWindow(true);
   	GetDlgItem(IDC_GIVEMONEY)->EnableWindow(true);
    GetDlgItem(IDC_GETPHONE)->EnableWindow(true);
	GetDlgItem(IDC_PHONE_ID)->EnableWindow(true);
    GetDlgItem(IDC_COMPANY)->EnableWindow(true);
    GetDlgItem(IDC_CONTRACT_ID)->EnableWindow(true);
    GetDlgItem(IDC_PERSON)->EnableWindow(true);
   	GetDlgItem(IDC_MONEY)->EnableWindow(true);
    GetDlgItem(IDC_THREE)->EnableWindow(true);
   	GetDlgItem(IDC_SIX)->EnableWindow(true);
	GetDlgItem(IDOK)->EnableWindow(true);
}

void CEditDlg::OnDelete() 
{
	if( MessageBox( "确认要删除词条记录吗?", "系统提示",MB_YESNOCANCEL ) == IDYES )
	{
		CString SQL1,csSQL;
		SQL1="delete * from [whole$] where [序号]=%s";
		//SQL1="delete * from ["+biaoming_DBManagerDlg.m_biaoming+"$] where [序号]=%s";
		csSQL.Format(SQL1,m_id);
		m_pCDataBase->ExecuteSQL(csSQL);
	}
}

void CEditDlg::OnOK() 
{
	m_bFlag = TRUE;
	// TODO: Add extra validation here
	UpdateData( TRUE );
	//*****************************************************************//
	CString use_money_update,qianfei_update,yongjin_update;
	GetDlgItemText(IDC_USE_MONEY,use_money_update);
	GetDlgItemText(IDC_QIANFEI,qianfei_update);
	GetDlgItemText(IDC_DATATIME,yongjin_update);
	GetDlgItemText(IDC_CDMA_TYPE,m_cdma_type);
	GetDlgItemText(IDC_COMPANY,m_company);
	GetDlgItemText(IDC_CONTRACT_ID,m_contract_id);
	GetDlgItemText(IDC_GETPHONE,m_getphone);

	GetDlgItemText(IDC_GIVEMONEY,m_givemoney);
	GetDlgItemText(IDC_LOWEST,m_lowest);
	GetDlgItemText(IDC_MONEY,m_money);
	GetDlgItemText(IDC_NAME,m_name);
	GetDlgItemText(IDC_PERSON,m_person);
	GetDlgItemText(IDC_PERSON_ID,m_person_id);
	GetDlgItemText(IDC_PHONE_ID,m_phone_id);

	GetDlgItemText(IDC_SIX,m_six);
	GetDlgItemText(IDC_SIX_SHUOMING,m_six_shuoming);

	GetDlgItemText(IDC_THREE,m_three);
	GetDlgItemText(IDC_THREE_SHUOMING,m_three_shuoming);

	GetDlgItemText(IDC_TYPE,m_type);
	GetDlgItemText(IDC_UIM,m_uim);
	GetDlgItemText(IDC_USE_MONEY1,m_use_money1);
	GetDlgItemText(IDC_YONGJIN1,m_yongjin1);
	GetDlgItemText(IDC_QIANFEI1,m_qianfei1);
	UpdateData( FALSE );
	//*****************************************************************//
	if (m_uim.GetLength()==0 || m_type.GetLength()==0 || m_three.GetLength()==0 || m_six.GetLength()==0 || m_cdma_type.GetLength()==0 || m_company.GetLength()==0 || m_contract_id.GetLength()==0 || m_getphone.GetLength()==0 || m_givemoney.GetLength()==0 || m_lowest.GetLength()==0 || m_money.GetLength()==0 || m_name.GetLength()==0 || m_person.GetLength()==0 || m_person_id.GetLength()==0 || m_phone_id.GetLength()==0)
	{
		MessageBox("不能有空白项目!","系统提示");
	}
	else   
	{
		if (use_money_update.GetLength()!=0 && yongjin_update.GetLength()!=0 && qianfei_update.GetLength()!=0)
		{
			CString SQL1,csSQL;
			m_biaoming=biaoming;
			//SQL1="update [whole$] set [%s]=%s,[%s]=%s,[%s]=%s,[UIM卡号]=%s,[手机品牌]='%s',[CDMA手机型号]='%s',[月最低消费标准(元/月)]=%s,[用户姓名]='%s',[身份证号码]=%s,[付费方式]='%s',[领机日期]='%s',[机号]='%s',[担保公司]='%s',[合同编号]='%s',[联系人]='%s',[入网佣金]=%s,[在网三个月佣金]=%s,[在网六个月佣金]=%s where [序号]=%s";
			SQL1="update ["+m_biaoming+"$] set [%s]=%s,[%s]=%s,[%s]=%s,[UIM卡号]=%s,[手机品牌]='%s',[CDMA手机型号]='%s',[月最低消费标准(元/月)]=%s,[用户姓名]='%s',[身份证号码]=%s,[付费方式]='%s',[领机日期]='%s',[机号]='%s',[担保公司]='%s',[合同编号]='%s',[联系人]='%s',[入网佣金]=%s,[在网三个月佣金]=%s,[在网六个月佣金]=%s,[说明(在网三个月佣金)]='%s',[说明(在网六个月佣金)]='%s' where [序号]=%s";
			csSQL.Format(SQL1,yongjin_update,m_yongjin1,use_money_update,m_use_money1,qianfei_update,m_qianfei1,m_uim,m_type,m_cdma_type,m_lowest,m_name,m_person_id,m_givemoney,m_getphone,m_phone_id,m_company,m_contract_id,m_person,m_money,m_three,m_six,m_three_shuoming,m_six_shuoming,m_id);
			m_pCDataBase->ExecuteSQL(csSQL);
		}
		if (use_money_update.GetLength()==0 && yongjin_update.GetLength()==0 && qianfei_update.GetLength()==0)
		{
			CString SQL1,csSQL;
			m_biaoming=biaoming;
			//SQL1="update [whole$] set [UIM卡号]=%s,[手机品牌]='%s',[CDMA手机型号]='%s',[月最低消费标准(元/月)]=%s,[用户姓名]='%s',[身份证号码]=%s,[付费方式]='%s',[领机日期]='%s',[机号]='%s',[担保公司]='%s',[合同编号]='%s',[联系人]='%s',[入网佣金]=%s,[在网三个月佣金]=%s,[在网六个月佣金]=%s where [序号]=%s";
			SQL1="update ["+m_biaoming+"$] set [UIM卡号]=%s,[手机品牌]='%s',[CDMA手机型号]='%s',[月最低消费标准(元/月)]=%s,[用户姓名]='%s',[身份证号码]=%s,[付费方式]='%s',[领机日期]='%s',[机号]='%s',[担保公司]='%s',[合同编号]='%s',[联系人]='%s',[入网佣金]=%s,[在网三个月佣金]=%s,[在网六个月佣金]=%s,[说明(在网三个月佣金)]='%s',[说明(在网六个月佣金)]='%s' where [序号]=%s";
			csSQL.Format(SQL1,m_uim,m_type,m_cdma_type,m_lowest,m_name,m_person_id,m_givemoney,m_getphone,m_phone_id,m_company,m_contract_id,m_person,m_money,m_three,m_six,m_three_shuoming,m_six_shuoming,m_id);
			m_pCDataBase->ExecuteSQL(csSQL);
		}
		if (!(use_money_update.GetLength()!=0 && yongjin_update.GetLength()!=0 && qianfei_update.GetLength()!=0) && !(use_money_update.GetLength()==0 && yongjin_update.GetLength()==0 && qianfei_update.GetLength()==0))
		{
			MessageBox("三个下拉菜单不能有的填写、有的不填写!","系统提示");
		}
	}

	CDialog::OnOK();
}

void CEditDlg::OnSelchangeDatatime() 
{
	// TODO: Add your control notification handler code here
 	int i_yongjin=m_yongjin.GetCurSel();
	CString yongjin;
	yongjin=buff->GetAt(i_yongjin);
	SetDlgItemText(IDC_YONGJIN1,yongjin);
	//**************************************************//
}

void CEditDlg::OnSelchangeUseMoney() 
{
	// TODO: Add your control notification handler code here
	int i_use_money=m_use_money.GetCurSel();
	i_use_money=i_use_money+40;
	CString usemoney;
	usemoney=buff->GetAt(i_use_money);
	SetDlgItemText(IDC_USE_MONEY1,usemoney);
	//**************************************************//
}

void CEditDlg::OnSelchangeQianfei() 
{
	// TODO: Add your control notification handler code here
	int i_qianfei=m_qianfei.GetCurSel(); 
	i_qianfei=i_qianfei+80;
	CString qianfei;
	qianfei=buff->GetAt(i_qianfei);
	SetDlgItemText(IDC_QIANFEI1,qianfei);
	//**************************************************//
}

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -