【VC开源代码栏目提醒】:本文主要为网学会员提供DComAndGo.cpp,希望对需要DComAndGo.cpp网友有所帮助,学习一下!
// DComAndGo.cpp : implementation file
//
#include "stdafx.h"
#include "qpglxt.h"
#include "DComAndGo.h"
#include "DBaseQuery.h"
#include "externDllHeader.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// CDComAndGo dialog
CDComAndGo::CDComAndGo(CWnd* pParent /*=NULL*/)
: CDialog(CDComAndGo::IDD, pParent)
{
//{{AFX_DATA_INIT(CDComAndGo)
// NOTE: the ClassWizard will add member initialization here
//}}AFX_DATA_INIT
}
void CDComAndGo::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CDComAndGo)
DDX_Control(pDX, IDC_SPXX_BUTUNDO, m_ButUndo);
DDX_Control(pDX, IDC_SPXX_BUTSAVE, m_ButSave);
DDX_Control(pDX, IDC_SPXX_BUTEXIT, m_ButExit);
DDX_Control(pDX, IDC_SPXX_BUTDELE, m_ButDele);
DDX_Control(pDX, IDC_SPXX_BUTCHANGE, m_ButChange);
DDX_Control(pDX, IDC_SPXX_BUTADD, m_ButAdd);
DDX_Control(pDX, IDC_CAG_EDTWWW, m_EdtWww);
DDX_Control(pDX, IDC_CAG_EDTTEL, m_EdtTel);
DDX_Control(pDX, IDC_CAG_EDTTAXPAYER, m_EdtTaxPayer);
DDX_Control(pDX, IDC_CAG_EDTNAME, m_EdtName);
DDX_Control(pDX, IDC_CAG_EDTMEM, m_EdtMem);
DDX_Control(pDX, IDC_CAG_EDTLINKMANTEL, m_EdtLinkManTel);
DDX_Control(pDX, IDC_CAG_EDTLINKMAN, m_EdtLinkMan);
DDX_Control(pDX, IDC_CAG_EDTID, m_EdtID);
DDX_Control(pDX, IDC_CAG_EDTFAX, m_EdtFax);
DDX_Control(pDX, IDC_CAG_EDTCNAME, m_EdtCName);
DDX_Control(pDX, IDC_CAG_EDTADDR, m_EdtAddr);
DDX_Control(pDX, IDC_CAG_EDTACCOUNT, m_EdtAccount);
DDX_Control(pDX, IDC_CAG_COMSTYLE, m_ComStyle);
DDX_Control(pDX, IDC_CAG_COMBANK, m_ComBank);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CDComAndGo, CDialog)
//{{AFX_MSG_MAP(CDComAndGo)
ON_BN_CLICKED(IDC_SPXX_BUTADD, OnSpxxButadd)
ON_BN_CLICKED(IDC_SPXX_BUTCHANGE, OnSpxxButchange)
ON_BN_CLICKED(IDC_SPXX_BUTDELE, OnSpxxButdele)
ON_BN_CLICKED(IDC_SPXX_BUTSAVE, OnSpxxButsave)
ON_BN_CLICKED(IDC_SPXX_BUTUNDO, OnSpxxButundo)
ON_BN_CLICKED(IDC_SPXX_BUTEXIT, OnSpxxButexit)
ON_EN_CHANGE(IDC_CAG_EDTNAME, OnChangeCagEdtname)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CDComAndGo message handlers
void CDComAndGo::OnOK()
{
// TODO: Add extra validation here
//CDialog::OnOK();
}
void CDComAndGo::Clear()
{
m_EdtWww.SetWindowText("");
m_EdtTel.SetWindowText("");
m_EdtTaxPayer.SetWindowText("");
m_EdtName.SetWindowText("");
m_EdtMem.SetWindowText("");
m_EdtLinkManTel.SetWindowText("");
m_EdtLinkMan.SetWindowText("");
m_EdtID.SetWindowText("");
m_EdtFax.SetWindowText("");
m_EdtCName.SetWindowText("");
m_EdtAddr.SetWindowText("");
m_EdtAccount.SetWindowText("");
m_ComStyle.SetCurSel(0);
m_ComBank.SetCurSel(0);
}
void CDComAndGo::Display(CString ID)
{
RxRecordset Drst;
CString sSQL;
if(ID.IsEmpty())
return;
sSQL.Format("SELECT * FROM 往来单位信息表 WHERE 编号 ='%s'",ID);
Drst.Open(sSQL,adCmdText);
CString sWww,sTel,sTaxPayer,sName,sMem,sLinkManTel,sLinkMan,sID,sFax,sCName,sAddr,sAccount,sStyle,sBank;
sID=Drst.GetFieldValue("编号");
sStyle=Drst.GetFieldValue("类型");
sName=Drst.GetFieldValue("名称");
sCName=Drst.GetFieldValue("简称");
sAddr=Drst.GetFieldValue("地址");
sTel=Drst.GetFieldValue("电话");
sFax=Drst.GetFieldValue("传真");
sLinkMan=Drst.GetFieldValue("联系人");
sLinkManTel=Drst.GetFieldValue("联系人电话");
sBank=Drst.GetFieldValue("开户银行");
sAccount=Drst.GetFieldValue("银行账户");
sTaxPayer=Drst.GetFieldValue("纳税人");
sWww=Drst.GetFieldValue("邮箱网址");
sMem=Drst.GetFieldValue("备注");
CString sBankName=ado.FieldToOtherField("银行信息表","编号",sBank,"名称",2);
m_EdtWww.SetWindowText(sWww);
m_EdtTel.SetWindowText(sTel);
m_EdtTaxPayer.SetWindowText(sTaxPayer);
m_EdtName.SetWindowText(sName);
m_EdtMem.SetWindowText(sMem);
m_EdtLinkManTel.SetWindowText(sLinkManTel);
m_EdtLinkMan.SetWindowText(sLinkMan);
m_EdtID.SetWindowText(sID);
m_EdtFax.SetWindowText(sFax);
m_EdtCName.SetWindowText(sCName);
m_EdtAddr.SetWindowText(sAddr);
m_EdtAccount.SetWindowText(sAccount);
CString sStyleName=ado.FieldToOtherField("往来类型表","编号",sStyle,"类型",2);
m_ComStyle.SetWindowText(sStyleName);
m_ComBank.SetWindowText(sBankName);
}
void CDComAndGo::Enabled(bool bEnabled)
{
m_ButUndo.EnableWindow(bEnabled);
m_ButSave.EnableWindow(bEnabled);
m_ButExit.EnableWindow(!bEnabled);
m_ButDele.EnableWindow(!bEnabled);
m_ButChange.EnableWindow(!bEnabled);
m_ButAdd.EnableWindow(!bEnabled);
m_EdtWww.EnableWindow(bEnabled);
m_EdtTel.EnableWindow(bEnabled);
m_EdtTaxPayer.EnableWindow(bEnabled);
m_EdtName.EnableWindow(bEnabled);
m_EdtMem.EnableWindow(bEnabled);
m_EdtLinkManTel.EnableWindow(bEnabled);
m_EdtLinkMan.EnableWindow(bEnabled);
m_EdtFax.EnableWindow(bEnabled);
m_EdtCName.EnableWindow(bEnabled);
m_EdtAddr.EnableWindow(bEnabled);
m_EdtAccount.EnableWindow(bEnabled);
m_ComStyle.EnableWindow(bEnabled);
m_ComBank.EnableWindow(bEnabled);
if(bEnabled==true)
this->m_ComStyle.SetFocus();
else
this->m_ButSave.SetFocus();
}
void CDComAndGo::OnSpxxButadd()
{
AddOrChange=1;
CString sNewID;
sNewID=ado.AutoNumber("往来单位信息表","编号","WD",2);
this->Clear();
m_EdtID.SetWindowText(sNewID);
this->Enabled(true);
this->m_ComStyle.SetFocus();
}
void CDComAndGo::OnSpxxButchange()
{
AddOrChange=2;
this->Enabled(true);
this->m_ComStyle.SetFocus();
}
void CDComAndGo::OnSpxxButdele()
{
if(MessageBox("确定要删除记录吗?"," 系统提示",MB_OKCANCEL|MB_ICONQUESTION)!=1)
return;
CString cID,sSQL;
this->m_EdtID.GetWindowText(cID);
sSQL.Format("DELETE FROM 往来单位信息表 WHERE 编号='%s'",cID);
rst.Open(sSQL,adCmdText);
this->OnCancel();
}
void CDComAndGo::OnSpxxButsave()
{
if(MessageBox("确定要保存记录吗?"," 系统提示",MB_OKCANCEL|MB_ICONQUESTION)!=1)
return;
CString sSQL,sWww,sTel,sTaxPayer,sName,sMem,sLinkManTel,sLinkMan,sID,sFax,sCName,sAddr,sAccount,sBank;
m_EdtWww.GetWindowText(sWww);
m_EdtTel.GetWindowText(sTel);
m_EdtTaxPayer.GetWindowText(sTaxPayer);
m_EdtName.GetWindowText(sName);
m_EdtMem.GetWindowText(sMem);
m_EdtLinkManTel.GetWindowText(sLinkManTel);
m_EdtLinkMan.GetWindowText(sLinkMan);
m_EdtID.GetWindowText(sID);
m_EdtFax
上一篇:
About.pas
下一篇:
西班牙语医院科室名称