www.pudn.com > cygl.rar > Jiezhang.cpp

// Jiezhang.cpp : implementation file 
// 
 
#include "stdafx.h" 
#include "cyglxt.h" 
#include "Jiezhang.h" 
#include "ADOConn.h" 
#include "yydlg.h" 
#ifdef _DEBUG 
#define new DEBUG_NEW 
#undef THIS_FILE 
static char THIS_FILE[] = __FILE__; 
#endif 
extern CString FJH,FJLX; 
///////////////////////////////////////////////////////////////////////////// 
// CJiezhang dialog 
 
 
CJiezhang::CJiezhang(CWnd* pParent /*=NULL*/) 
	: CJieMian(pParent) 
{ 
	//{{AFX_DATA_INIT(CJiezhang) 
	yye = 0; 
	yingfu = 0; 
	xianjin = 0; 
	zhipiao = 0; 
	shuaka = 0; 
	zhekou = 10; 
	//}}AFX_DATA_INIT 
} 
 
 
void CJiezhang::DoDataExchange(CDataExchange* pDX) 
{ 
	CDialog::DoDataExchange(pDX); 
	//{{AFX_DATA_MAP(CJiezhang) 
	DDX_Control(pDX, IDCANCEL, m_QUXIAO); 
	DDX_Control(pDX, IDOK, m_QUEDING); 
	DDX_Control(pDX, IDC_BUTTON1, m_QUEREN); 
	DDX_Control(pDX, IDC_EDIT11, m_zhehoujia); 
	DDX_Control(pDX, IDC_EDIT10, m_zhekou); 
	DDX_Control(pDX, IDC_EDIT9, m_kahao); 
	DDX_Control(pDX, IDC_EDIT8, m_fws); 
	DDX_Control(pDX, IDC_EDIT7, m_shuaka); 
	DDX_Control(pDX, IDC_EDIT6, m_zhipiao); 
	DDX_Control(pDX, IDC_EDIT4, m_xianjin); 
	DDX_Control(pDX, IDC_EDIT5, m_yye); 
	DDX_Control(pDX, IDC_EDIT3, m_yingfu); 
	DDX_Control(pDX, IDC_EDIT2, m_fjh); 
	DDX_Control(pDX, IDC_EDIT1, m_leixing); 
	DDX_Control(pDX, IDC_BUTTONn, m_ZHESUAN); 
	DDX_Control(pDX, IDC_COMBO1, m_fkfs); 
	DDX_Text(pDX, IDC_EDIT5, yye); 
	DDX_Text(pDX, IDC_EDIT3, yingfu); 
	DDX_Text(pDX, IDC_EDIT4, xianjin); 
	DDX_Text(pDX, IDC_EDIT6, zhipiao); 
	DDX_Text(pDX, IDC_EDIT7, shuaka); 
	DDX_Text(pDX, IDC_EDIT10, zhekou); 
	DDX_Text(pDX, IDC_EDIT11, zhehoujia); 
	//}}AFX_DATA_MAP 
} 
 
 
BEGIN_MESSAGE_MAP(CJiezhang, CDialog) 
	//{{AFX_MSG_MAP(CJiezhang) 
	ON_WM_PAINT() 
	ON_WM_NCLBUTTONDOWN() 
	ON_WM_NCMOUSEMOVE() 
	ON_WM_SYSCOMMAND() 
	ON_WM_CTLCOLOR() 
	ON_BN_CLICKED(IDC_BUTTON1, OnQueRen) 
	ON_BN_CLICKED(IDC_BUTTONn, Onzhesuan) 
	ON_WM_SETCURSOR() 
	//}}AFX_MSG_MAP 
END_MESSAGE_MAP() 
 
///////////////////////////////////////////////////////////////////////////// 
// CJiezhang message handlers 
 
BOOL CJiezhang::OnInitDialog()  
{ 
	CDialog::OnInitDialog(); 
	m_leixing.SetWindowText(FJLX); 
	m_fjh.SetWindowText(FJH); 
	m_ZHESUAN.LoadBitmaps(IDB_ZHESUAN); 
	m_ZHESUAN.SizeToContent(); 
	m_QUEREN.LoadBitmaps(IDB_QUEREN); 
	m_QUEREN.SizeToContent(); 
	m_QUEDING.LoadBitmaps(IDB_QUEDING); 
	m_QUEDING.SizeToContent(); 
	m_QUXIAO.LoadBitmaps(IDB_QUXIAO); 
	m_QUXIAO.SizeToContent(); 
	_variant_t var; 
	ADOConn rst; 
	rst.OnInitADOConn(); 
	CString ssql; 
	ssql.Format("SELECT*FROM Dcb WHERE 餐桌编号='%s'",FJH); 
	_RecordsetPtr m_pRecordset; 
	m_pRecordset=rst.GetRecordSet((_bstr_t)ssql); 
	var=m_pRecordset->GetCollect("合计"); 
	if(var.vt!=VT_NULL) 
	ssql=(LPCSTR)_bstr_t(var); 
	m_yingfu.SetWindowText(ssql.GetBuffer(50)); 
	m_zhehoujia.SetWindowText(ssql.GetBuffer(50)); 
	m_fkfs.AddString("现金"); 
	m_fkfs.AddString("支票"); 
	m_fkfs.AddString("刷卡"); 
	int nyear,nday,nmonth; 
	CString year,month,day,date; 
	CTime t; 
	t=t.GetCurrentTime(); 
	nyear=t.GetYear(); 
	nmonth=t.GetMonth(); 
	nday=t.GetDay(); 
	year.Format("%d",nyear); 
	month.Format("%d",nmonth); 
	day.Format("%d",nday); 
	date.Format("%s-%s-%s",year,month,day); 
	ssql.Format("SELECT*FROM Yye WHERE 时间='%s'",date); 
	m_pRecordset=rst.GetRecordSet((_bstr_t)ssql); 
	var=m_pRecordset->GetCollect("营业额"); 
	if(var.vt!=VT_NULL) 
	ssql=(LPCSTR)_bstr_t(var); 
	m_yye.SetWindowText(ssql.GetBuffer(50)); 
	var=m_pRecordset->GetCollect("现金"); 
	if(var.vt!=VT_NULL) 
	ssql=(LPCSTR)_bstr_t(var); 
	m_xianjin.SetWindowText(ssql.GetBuffer(50)); 
	var=m_pRecordset->GetCollect("支票"); 
	if(var.vt!=VT_NULL) 
	ssql=(LPCSTR)_bstr_t(var); 
	m_zhipiao.SetWindowText(ssql.GetBuffer(50)); 
	var=m_pRecordset->GetCollect("刷卡"); 
	if(var.vt!=VT_NULL) 
	ssql=(LPCSTR)_bstr_t(var); 
	m_shuaka.SetWindowText(ssql.GetBuffer(50)); 
	ssql.Format("SELECT*FROM Dcb WHERE 餐桌编号='%s'",FJH); 
	m_pRecordset=rst.GetRecordSet((_bstr_t)ssql); 
	var=m_pRecordset->GetCollect("服务生"); 
	if(var.vt!=VT_NULL) 
	ssql=(LPCSTR)_bstr_t(var); 
	m_fws.SetWindowText(ssql); 
	rst.ExitConnect(); 
 
	return TRUE;  // return TRUE unless you set the focus to a control 
	              // EXCEPTION: OCX Property Pages should return FALSE 
} 
 
void CJiezhang::OnPaint()  
{ 
	 
	CJieMian::OnPaint(); 
} 
 
void CJiezhang::OnNcLButtonDown(UINT nHitTest, CPoint point)  
{ 
	// TODO: Add your message handler code here and/or call default 
	 
	CJieMian::OnNcLButtonDown(nHitTest, point); 
} 
 
void CJiezhang::OnNcMouseMove(UINT nHitTest, CPoint point)  
{ 
	// TODO: Add your message handler code here and/or call default 
	 
	CJieMian::OnNcMouseMove(nHitTest, point); 
} 
 
void CJiezhang::OnSysCommand(UINT nID, LPARAM lParam)  
{ 
	// TODO: Add your message handler code here and/or call default 
	 
	CJieMian::OnSysCommand(nID, lParam); 
} 
 
HBRUSH CJiezhang::OnCtlColor(CDC* pDC, CWnd* pWnd, UINT nCtlColor)  
{ 
	HBRUSH hbr = CDialog::OnCtlColor(pDC, pWnd, nCtlColor); 
	switch (nCtlColor) {  
	case CTLCOLOR_DLG :  
	case CTLCOLOR_LISTBOX: 
	case CTLCOLOR_MSGBOX: 
	case CTLCOLOR_SCROLLBAR: 
	case CTLCOLOR_EDIT: 
	case CTLCOLOR_STATIC: 
		{ 
			pDC->SetBkMode(TRANSPARENT);  
			HBRUSH B = CreateSolidBrush(RGB(255,0,0)); 
			return (HBRUSH) B; 
		} 
	} 
} 
 
 
void CJiezhang::OnOK()  
{ 
	// TODO: Add extra validation here 
	UpdateData(true); 
	CString fs; 
	m_fkfs.GetWindowText(fs); 
	if(fs=="") 
	{ 
		MessageBox("请选择付款方式","餐饮管理系统"); 
		return; 
	} 
	int nyear,nday,nmonth; 
	CString year,month,day,date,yy1,yingfu1; 
	int yy,yingfu2; 
	yy=yye+zhehoujia; 
	 
	yy1.Format("%d",yy); 
	CTime t; 
	t=t.GetCurrentTime(); 
	nyear=t.GetYear(); 
	nmonth=t.GetMonth(); 
	nday=t.GetDay(); 
	year.Format("%d",nyear); 
	month.Format("%d",nmonth); 
	day.Format("%d",nday); 
	date.Format("%s-%s-%s",year,month,day); 
	ADOConn rst; 
	_bstr_t vSQL; 
 
	if(fs=="现金") 
	{ 
		yingfu2=zhehoujia+xianjin; 
		yingfu1.Format("%d",yingfu2); 
		vSQL="UPDATE Yye SET 营业额='"+yy1+"',现金='"+yingfu1+"' WHERE 时间="+" '"+date+"'"; 
		rst.ExecuteSQL(vSQL); 
	} 
	else if(fs=="支票") 
	{	 
		yingfu2=zhehoujia+zhipiao; 
		yingfu1.Format("%d",yingfu2); 
		vSQL="UPDATE Yye SET 营业额='"+yy1+"',支票='"+yingfu1+"' WHERE 时间="+" '"+date+"'"; 
		rst.ExecuteSQL(vSQL); 
	} 
	else if(fs=="刷卡") 
	{ 
		yingfu2=zhehoujia+shuaka; 
		yingfu1.Format("%d",yingfu2); 
		vSQL="UPDATE Yye SET 营业额='"+yy1+"',刷卡='"+yingfu1+"' WHERE 时间="+" '"+date+"'"; 
		rst.ExecuteSQL(vSQL); 
	} 
	CString kongxian="空闲",fws; 
	m_fws.GetWindowText(fws); 
	vSQL="UPDATE Czb SET 状态='"+kongxian+"'WHERE 餐桌编号="+" '"+FJH+"'"; 
	rst.ExecuteSQL(vSQL); 
	vSQL="UPDATE Ygmd SET 状态='"+kongxian+"'WHERE 员工姓名="+" '"+fws+"'"; 
	rst.ExecuteSQL(vSQL); 
	CString ssql; 
	ssql.Format("delete from Dcb WHERE 餐桌编号='%s'",FJH); 
	rst.ExecuteSQL((_bstr_t)ssql); 
	MessageBox("结帐成功","餐饮管理系统"); 
	rst.ExitConnect(); 
	CDialog::OnOK(); 
	Cyydlg *pMyDlg; 
	pMyDlg = new Cyydlg; 
	pMyDlg->Create(IDD_YY); 
	pMyDlg->ShowWindow(SW_SHOW); 
} 
 
void CJiezhang::OnQueRen()  
{ 
	UpdateData(true); 
	CString kh,ssql; 
	_variant_t var; 
	_RecordsetPtr m_pRecordset; 
	m_kahao.GetWindowText(kh); 
	ADOConn rst; 
	rst.OnInitADOConn(); 
	ssql.Format("SELECT*FROM Yhk WHERE 卡号='%s'",kh); 
	m_pRecordset=rst.GetRecordSet((_bstr_t)ssql); 
	if(m_pRecordset->adoEOF) 
	{ 
		MessageBox("没有该卡号,请确认输入是否正确","餐饮管理系统"); 
		return; 
	} 
	var=m_pRecordset->GetCollect("折扣数"); 
	if(var.vt!=VT_NULL) 
	ssql=(LPCSTR)_bstr_t(var); 
	m_zhekou.SetWindowText(ssql); 
	CString say; 
	say.Format("您的优惠卡折扣数为%s",ssql); 
	{ 
		MessageBox(say); 
	} 
} 
void CJiezhang::Onzhesuan() 
{ 
	UpdateData(true); 
	CString ssql; 
	int shi=yingfu*zhekou/10; 
	ssql.Format("%d",shi); 
	m_zhehoujia.SetWindowText(ssql); 
} 
 
BOOL CJiezhang::OnSetCursor(CWnd* pWnd, UINT nHitTest, UINT message)  
{ 
	if   (pWnd==GetDlgItem(IDOK) || pWnd==GetDlgItem(IDCANCEL)||pWnd==GetDlgItem(IDC_BUTTON1)||pWnd==GetDlgItem(IDC_BUTTONn))    
      {    
          SetCursor(LoadCursor(NULL,IDC_HAND));  
			return   TRUE;   
		}    
	 
	return CDialog::OnSetCursor(pWnd, nHitTest, message); 
}