【VC开源代码栏目提醒】:网学会员,鉴于大家对VC开源代码十分关注,论文会员在此为大家搜集整理了“DMerchandise.cpp”一文,供大家参考学习!
// DMerchandise.cpp : implementation file
//
#include "stdafx.h"
#include "qpglxt.h"
#include "DMerchandise.h"
#include "DBaseQuery.h"
#include "RxGrid.h"
#include "externDllHeader.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// CDMerchandise dialog
CDMerchandise::CDMerchandise(CWnd* pParent /*=NULL*/)
: CDialog(CDMerchandise::IDD, pParent)
{
//{{AFX_DATA_INIT(CDMerchandise)
//}}AFX_DATA_INIT
AddOrChange=0;
}
void CDMerchandise::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CDMerchandise)
DDX_Control(pDX, IDC_SPXX_EDTSELL, m_Sell);
DDX_Control(pDX, IDC_SPXX_COMUNIT, m_ComUnit);
DDX_Control(pDX, IDC_SPXX_EDTSPEC, m_EdtSpec);
DDX_Control(pDX, IDC_SPXX_EDTTYPE, m_EdtType);
DDX_Control(pDX, IDC_SPXX_EDTPRICE, m_EdtPrice);
DDX_Control(pDX, IDC_SPXX_EDTNAME, m_EdtName);
DDX_Control(pDX, IDC_SPXX_EDTMEM, m_EdtMem);
DDX_Control(pDX, IDC_SPXX_EDTID, m_EdtID);
DDX_Control(pDX, IDC_SPXX_EDTCNAME, m_EdtCName);
DDX_Control(pDX, IDC_SPXX_EDTAREA, m_EdtArea);
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_ButDelete);
DDX_Control(pDX, IDC_SPXX_BUTCHANGE, m_ButChange);
DDX_Control(pDX, IDC_SPXX_BUTADD, m_ButAdd);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CDMerchandise, CDialog)
//{{AFX_MSG_MAP(CDMerchandise)
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_SPXX_EDTNAME, OnChangeSpxxEdtname)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CDMerchandise message handlers
void CDMerchandise::OnOK()
{
// TODO: Add extra validation here
//CDialog::OnOK();
}
void CDMerchandise::Display(CString ID)
{
RxRecordset Drxt;
CString sSQL;
if(ID.IsEmpty())
return;
sSQL.Format("SELECT * FROM 商品信息查询 WHERE 编号 ='%s'",ID);
Drxt.Open(sSQL,adCmdText);
CString sID,sName,sCName,sUnit,sType,sSell,sArea,sPrice,sMem,sSpec;
sID=Drxt.GetFieldValue("编号");
sName=Drxt.GetFieldValue("名称");
sCName=Drxt.GetFieldValue("简称");
sUnit=Drxt.GetFieldValue("计量单位");
sType=Drxt.GetFieldValue("适用范围");
sArea=Drxt.GetFieldValue("产地");
sPrice=Drxt.GetFieldValue("进价");
sMem=Drxt.GetFieldValue("备注");
sSpec=Drxt.GetFieldValue("规格");
sSell=Drxt.GetFieldValue("销售价格");
this->m_EdtSpec.SetWindowText(sSpec);
this->m_EdtArea.SetWindowText(sArea);
this->m_EdtCName.SetWindowText(sCName);
this->m_EdtID.SetWindowText(sID);
this->m_EdtMem.SetWindowText(sMem);
this->m_EdtName.SetWindowText(sName);
this->m_EdtPrice.SetWindowText(sPrice);
this->m_EdtType.SetWindowText(sType);
this->m_ComUnit.SetWindowText(sUnit);
this->m_Sell.SetWindowText(sSell);
}
BOOL CDMerchandise::OnInitDialog()
{
CDialog::OnInitDialog();
CDBaseQuery* Parent =(CDBaseQuery*)this->FindWindow(NULL,"商品信息查询");
CString sSQL,sID;
sID=Parent->m_Grid.GetItemText(Parent->m_CurrentRow,0);
m_sID=sID;
this->Display(sID);
rst.Open("计量单位表");
this->m_ComUnit.SetRecordset(rst,"计量单位");
return TRUE; // return TRUE unless you set the focus to a control
// EXCEPTION: OCX Property Pages should return FALSE
}
void CDMerchandise::Enabled(bool bEnabled)
{
m_EdtArea.EnableWindow(bEnabled);
m_EdtCName.EnableWindow(bEnabled);
this->m_Sell.EnableWindow(bEnabled);
m_EdtMem.EnableWindow(bEnabled);
m_EdtSpec.EnableWindow(bEnabled);
m_EdtName.EnableWindow(bEnabled);
m_EdtPrice.EnableWindow(bEnabled);
m_EdtType.EnableWindow(bEnabled);
m_ComUnit.EnableWindow(bEnabled);
m_ButUndo.EnableWindow(bEnabled);
m_ButSave.EnableWindow(bEnabled);
m_ButExit.EnableWindow(!bEnabled);
m_ButDelete.EnableWindow(!bEnabled);
m_ButChange.EnableWindow(!bEnabled);
m_ButAdd.EnableWindow(!bEnabled);
if(bEnabled==true)
this->m_EdtName.SetFocus();
else
this->m_ButSave.SetFocus();
}
void CDMerchandise::Clear()
{
m_EdtArea.SetWindowText("");
m_EdtCName.SetWindowText("");
m_EdtMem.SetWindowText("");
m_EdtName.SetWindowText("");
m_EdtPrice.SetWindowText("");
m_EdtType.SetWindowText("");
m_ComUnit.SetWindowText("");
m_EdtSpec.SetWindowText("");
m_Sell.SetWindowText("");
}
void CDMerchandise::OnSpxxButadd()
{
AddOrChange=1;
CString sNewID;
sNewID=ado.AutoNumber("商品信息表","编号","SP",2);
this->Clear();
m_EdtID.SetWindowText(sNewID);
this->Enabled(true);
this->m_EdtName.SetFocus();
}
void CDMerchandise::OnSpxxButchange()
{
AddOrChange=2;
this->Enabled(true);
this->m_EdtName.SetFocus();
}
void CDMerchandise::OnSpxxButdele()
{
if(MessageBox("确定要删除记录吗?"," 系统提示",MB_OKCANCEL|MB_ICONQUESTION)!=1)
return;
CString cID,sSQL;
this->m_EdtID.GetWindowText(cID);
sSQL.Format("DELETE FROM 商品信息表 WHERE 编号='%s'",cID);
if(rst.Open(sSQL,adCmdText)==false)
{
MessageBox("对不起!由于仓库中存在此中商品,所以您不能删除此条记录!","系统提示",MB_OK|MB_ICONSTOP);
return;
}
this->OnCancel();
}
void CDMerchandise::OnSpxxButsave()
{
if(MessageBox("确定要保存记录吗?"," 系统提示",MB_OKCANCEL|MB_ICONQUESTION)!=1)
return;
CString sSQL,sID,sName,sSell,sCName,sUnitID,sUnit,sType,sArea,sPrice,sMem,sSpec;
m_EdtID.GetWindowText(sID);
m_EdtArea.GetWindowText(sArea);
m_EdtCName.GetWindowText(sCName);
m_EdtMem.GetWindowText(sMem);
m_EdtName.GetWindowText(sName);
m_EdtPrice.GetWindowText(sPrice);
m_EdtType.GetWindowText(sType);
m_ComUnit.GetWindowText(sUnit);
m_EdtSpec.GetWindowText(sSpec);
m_Sell.GetWindowText(sSell);
sUnitID=ado.FieldToOtherField("计量单位表","计量单位",sUnit,"编号",1);
if(this->AddOrChange==1)//添加
sSQL.Format("INSERT INTO 商品信息表 VALUES('%s','%s','%s','%s','%s','%s',%s,%s,%s,'%s')",sID,sName,sCName,sType,sSpec,sArea,sUnitID,sPrice,sSell,sMem);
else//修改
sSQL.Format(
上一篇:
CliMain.pas
下一篇:
女生一定要看,不看肯定后悔!_精典日记