?? editdlg.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 + -