?? paydlg.cpp
字號:
// PayDlg.cpp : implementation file
//
#include "stdafx.h"
#include "MenuManage.h"
#include "PayDlg.h"
#include "Columns.h"
#include "Column.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
extern CMenuManageApp theApp;
/////////////////////////////////////////////////////////////////////////////
// CPayDlg dialog
CPayDlg::CPayDlg(CWnd* pParent /*=NULL*/)
: CDialog(CPayDlg::IDD, pParent)
{
//{{AFX_DATA_INIT(CPayDlg)
m_nPayDeskNumber = 0;
m_nPayRealPrice = 0;
m_nPayRePrice = 0;
m_nPayTotalPrice = 0;
m_strPayUserName = _T("");
m_strPaymode = _T("人民幣");
m_timePay = COleDateTime::GetCurrentTime();
//}}AFX_DATA_INIT
}
void CPayDlg::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CPayDlg)
DDX_Control(pDX, IDC_COMBO_PAYMODE, m_coPaymode);
DDX_Text(pDX, IDC_PAY_DESK_NUMBER, m_nPayDeskNumber);
DDX_Text(pDX, IDC_PAY_REALPRICE, m_nPayRealPrice);
DDX_Text(pDX, IDC_PAY_REPAYPRICE, m_nPayRePrice);
DDX_Text(pDX, IDC_PAY_TOTALPRICE, m_nPayTotalPrice);
DDX_Text(pDX, IDC_PAY_PEOPLE, m_strPayUserName);
DDX_CBString(pDX, IDC_COMBO_PAYMODE, m_strPaymode);
DDX_Control(pDX, IDC_DATAGRID_PAY, m_dbPay);
DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKER_PAY, m_timePay);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CPayDlg, CDialog)
//{{AFX_MSG_MAP(CPayDlg)
ON_EN_UPDATE(IDC_PAY_DESK_NUMBER, OnUpdatePayDeskNumber)
ON_EN_UPDATE(IDC_PAY_REALPRICE, OnUpdatePayRealprice)
ON_BN_CLICKED(IDC_PAY_PRINT_BTN, OnPayPrintBtn)
ON_BN_CLICKED(IDC_CANCEL, OnCancel)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CPayDlg message handlers
void CPayDlg::OnOK()
{
// TODO: Add extra validation here
//--------desk表已結(jié)----------------------//
UpdateData(TRUE);
if(m_nPayDeskNumber == 0)
{
AfxMessageBox("請輸入餐桌編號");
return;
}
if(m_nPayRealPrice<m_nPayTotalPrice)
{
AfxMessageBox("金額不足");
return;
}
CString str,sql,str1;
str.Format("%d",m_nPayDeskNumber);
int temp=0;
str1.Format("%d",temp);
sql = "SELECT * FROM DeskInfo WHERE DeskNum = "+str+" and DeskCheck = "+str1+"";
m_pRecordset_Desk.CreateInstance("ADODB.Recordset");
m_pRecordset_Desk->Open((_variant_t)sql,_variant_t((IDispatch *)theApp.m_pConnection,true),adOpenDynamic,adLockPessimistic,adCmdText);
if(m_pRecordset_Desk->GetRecordCount()!=0)
{
if (AfxMessageBox("是否打印賬單？",MB_YESNO)==IDYES)
{
OnPayPrintBtn();
}
temp = 1;
str.Format("%d" , temp);
m_pRecordset_Desk->PutCollect("DeskCheck",(_variant_t)str);
//付款方式
int selmode;
selmode = m_coPaymode.GetCurSel();
m_coPaymode.GetLBText(selmode,m_strPaymode);
m_pRecordset_Desk->PutCollect("DeskPaymode",_variant_t(m_strPaymode));
//時間
CString paytime;
CTime now=CTime::GetCurrentTime();
paytime=now.Format(_T("%Y-%m-%d %H:%M:%S"));
m_pRecordset_Desk->PutCollect("DeskDateTime",(_variant_t)paytime);
//收銀員
m_pRecordset_Desk->PutCollect("DeskName",(_variant_t)m_strPayUserName);
m_pRecordset_Desk->Update();
m_pRecordset_Desk ->Close();
//-----------order表已結(jié)-----------------------------//
str.Format("%d",m_nPayDeskNumber);
sql = "SELECT * FROM OrderInfo WHERE DeskNum = "+str+" and FoodCheck = "+str1+" ";
m_pRecordset_Order.CreateInstance("ADODB.Recordset");
m_pRecordset_Order->Open((_variant_t)sql,_variant_t((IDispatch *)theApp.m_pConnection,true),adOpenDynamic,adLockPessimistic,adCmdText);
if(m_pRecordset_Order->GetRecordCount()!=0)
{
temp=1;
str.Format("%d" , temp);
while(!m_pRecordset_Order -> adoEOF)//如果不是最后一條記錄
{
m_pRecordset_Order->PutCollect("FoodCheck",(_variant_t)str);
m_pRecordset_Order->Update();
m_pRecordset_Order->MoveNext();//指針下移
}
m_pRecordset_Order ->Close();
}
//--------------------------------------------//
}
str.Format("%d",m_nPayDeskNumber);
str += "號桌已結(jié)帳";
AfxMessageBox(str);
// CDialog::OnOK();
}
void CPayDlg::OnUpdatePayDeskNumber()
{
// TODO: Add your control notification handler code here
UpdateData(TRUE);
CString str,sql,str1;
str.Format("%d",m_nPayDeskNumber);
int temp;
temp = 0;
str1.Format("%d",temp);
//自動計算出對應餐桌應付金額
sql = "SELECT * FROM DeskInfo WHERE DeskNum = "+str+"and DeskCheck = "+str1+" ";
m_pRecordset_Desk.CreateInstance("ADODB.Recordset");
m_pRecordset_Desk->Open((_variant_t)sql,_variant_t((IDispatch *)theApp.m_pConnection,true),adOpenDynamic,adLockPessimistic,adCmdText);
if(m_pRecordset_Desk->GetRecordCount() != 0)//如果記錄集不為空
{
m_nPayTotalPrice = m_pRecordset_Desk->GetCollect("DeskPrice").lVal;
}
m_pRecordset_Desk ->Close();
//將點菜信息綁定到db
sql = "SELECT * FROM OrderInfo WHERE DeskNum = "+str+"and FoodCheck = "+str1+" ";
m_pRecordset_Order.CreateInstance("ADODB.Recordset");
m_pRecordset_Order->Open((_variant_t)sql,_variant_t((IDispatch *)theApp.m_pConnection,true),adOpenDynamic,adLockPessimistic,adCmdText);
m_dbPay.SetRefDataSource(NULL);
m_dbPay.SetRefDataSource((LPUNKNOWN)m_pRecordset_Order);
m_dbPay.SetColumnHeaders(1) ;
m_dbPay.Refresh();
UpdateData(FALSE);
}
BOOL CPayDlg::OnInitDialog()
{
CDialog::OnInitDialog();
// TODO: Add extra initialization here
m_strPayUserName = theApp.m_name;
CString sql;
sql="SELECT * FROM PayModeInfo order by ID";
m_pRecordset_Paymode.CreateInstance("ADODB.Recordset");
m_pRecordset_Paymode->Open((_variant_t)sql,_variant_t((IDispatch *)theApp.m_pConnection,true),adOpenDynamic,adLockPessimistic,adCmdText);
if(m_pRecordset_Paymode->GetRecordCount()!=0)
{
while(!m_pRecordset_Paymode->adoEOF)
{
m_coPaymode.AddString((LPCTSTR)(_bstr_t)m_pRecordset_Paymode->GetCollect("NAME"));
m_pRecordset_Paymode->MoveNext();
}
m_pRecordset_Paymode->Close();
m_coPaymode.SetCurSel(0);
}
UpdateData(FALSE);
return TRUE; // return TRUE unless you set the focus to a control
// EXCEPTION: OCX Property Pages should return FALSE
}
void CPayDlg::OnUpdatePayRealprice()
{
// TODO: Add your control notification handler code here
UpdateData(TRUE);
//找零=實收金額-應收金額
m_nPayRePrice = m_nPayRealPrice - m_nPayTotalPrice;
UpdateData(FALSE);
}
void CPayDlg::OnPayPrintBtn()
{
// TODO: Add your control notification handler code here
UpdateData(TRUE);
//把打印設備環(huán)境附加到DC對象
CDC dc;
CPrintDialog pdlg(FALSE,PD_NOPAGENUMS|PD_NOSELECTION,this);
BOOL bFindPrinter=pdlg.GetDefaults();
if(!bFindPrinter)
return ;
dc.Attach(pdlg.GetPrinterDC());
//取打印機的橫方向和縱方向的分辨率,即每英寸點數(shù)
short cxInch = dc.GetDeviceCaps(LOGPIXELSX);
short cyInch = dc.GetDeviceCaps(LOGPIXELSY);
//字體
CFont font;
//為DC創(chuàng)建字體
VERIFY(font.CreatePointFont(96, "宋體", &dc));
//保存現(xiàn)在的字體
CFont* def_font = dc.SelectObject(&font);
//根據(jù)字體寬度、高度計算每行最大字數(shù)及每頁最大行數(shù)
//取打印紙張高度和寬度
int nPageHeight, nPageWidth;
nPageHeight = dc.GetDeviceCaps(VERTRES);
nPageWidth = dc.GetDeviceCaps(HORZRES);
TEXTMETRIC TextM;
dc.GetTextMetrics(&TextM);
//字體高度
int nCharHeight = (unsigned short)TextM.tmHeight;
//字體平均寬度
int nCharWidth=(unsigned short)TextM.tmAveCharWidth;
//每行最大字數(shù)
int m_MaxLineChar = nPageWidth / nCharWidth - 8;
//每頁最大行數(shù)
int m_LinesPerPage = nPageHeight/ nCharHeight;
//頁邊距
int nXMargin = 2;
int nYMargin = 2;
//獲得行數(shù)
int i;
//設置所需打印紙張數(shù)目
DOCINFO di;
di.cbSize = sizeof(DOCINFO);
di.lpszDocName = "MyMenu printing";
di.lpszOutput = (LPTSTR) NULL;
di.lpszDatatype = (LPTSTR) NULL;
di.fwType = 0;
dc.StartDoc(&di);
dc.StartPage();
//輸出公司名稱
CString stitle,sftitle,space="";
stitle="嘉緣酒店新北口分店";
int n=(36-stitle.GetLength())/2;
for(i=0;i<n;i++)
space=space+" ";
sftitle=space+stitle;
dc.TextOut(2, nYMargin+nCharHeight,sftitle, strlen(sftitle));
//輸出桌號、收銀員、付款方式
CString stable,speople,spaymode;
stable.Format("%d",m_nPayDeskNumber);
speople = m_strPayUserName;
spaymode = m_strPaymode;
stable= "桌 號:"+stable;
speople= "收 銀 員:"+speople;
spaymode="付款方式:"+spaymode;
dc.TextOut( 2, nYMargin+nCharHeight*3, stable, strlen(stable));
dc.TextOut( 2, nYMargin+nCharHeight*4, speople, strlen(speople));
dc.TextOut( 2, nYMargin+nCharHeight*5, spaymode, strlen(spaymode));
stitle="------------------------------------";
dc.TextOut( 2, nYMargin+nCharHeight*6, stitle, strlen(stitle));
//輸出列表的列標題
CString slisttitle;
slisttitle="名稱 單價 數(shù)量 金額(元)";
dc.TextOut( 2, nYMargin+nCharHeight*7,slisttitle, strlen(slisttitle));
int nMaxLinePerPage = nPageHeight/nCharHeight -3;//每頁最大行數(shù)
int nCurPage =1;
//輸出各列的數(shù)據(jù)
//-------------------------//
CString str,sql,str1;
str.Format("%d",m_nPayDeskNumber);
int temp=0;
str1.Format("%d",temp);
sql = "SELECT * FROM OrderInfo WHERE DeskNum = "+str+" and FoodCheck = "+str1+"";
m_pRecordset_Order.CreateInstance("ADODB.Recordset");
m_pRecordset_Order->Open((_variant_t)sql,_variant_t((IDispatch *)theApp.m_pConnection,true),adOpenDynamic,adLockPessimistic,adCmdText);
int m_nLineCount = m_pRecordset_Order->GetRecordCount();
//-------------------------//
CString name,signalprice,acount,totalprice;
int totalacount=0;
i=0;
while(!m_pRecordset_Order->adoEOF)
{
if(m_nLineCount+7-(nCurPage-1)*nMaxLinePerPage > nMaxLinePerPage)
{
//新的一頁
dc.EndPage();
dc.StartPage();
nCurPage ++;
}
name = m_pRecordset_Order->GetCollect("FoodName").bstrVal;
signalprice.Format("%d",m_pRecordset_Order->GetCollect("FoodSignalPrice").lVal) ;
acount.Format("%d",m_pRecordset_Order->GetCollect("FoodAcount").lVal);
totalprice.Format("%d",m_pRecordset_Order->GetCollect("FoodPrice").lVal);
totalacount += m_pRecordset_Order->GetCollect("FoodAcount").lVal;
dc.TextOut( 2, nYMargin+(i+8-(nCurPage-1)*nMaxLinePerPage)*nCharHeight,
name, strlen(name));
dc.TextOut( 2+nCharWidth*15, nYMargin+(i+8-(nCurPage-1)*nMaxLinePerPage)*nCharHeight,
signalprice, strlen(signalprice));
dc.TextOut( 2+nCharWidth*23, nYMargin+(i+8-(nCurPage-1)*nMaxLinePerPage)*nCharHeight,
acount, strlen(acount));
dc.TextOut( 2+nCharWidth*29, nYMargin+(i+8-(nCurPage-1)*nMaxLinePerPage)*nCharHeight,
totalprice, strlen(totalprice));
m_pRecordset_Order->MoveNext();
i++;
}
stitle="------------------------------------";
dc.TextOut( 2, nYMargin+(m_nLineCount+8-(nCurPage-1)*nMaxLinePerPage)*nCharHeight,
stitle, strlen(stitle));
//輸出數(shù)量、件數(shù)
CString snum,sacount;
snum.Format("%d",totalacount);
sacount.Format("%d",m_nLineCount);
snum = "數(shù) 量:"+snum;
sacount="件 數(shù):"+sacount;
dc.TextOut( 2, nYMargin+(m_nLineCount+9-(nCurPage-1)*nMaxLinePerPage)*nCharHeight,
snum, strlen(snum));
dc.TextOut( 2, nYMargin+(m_nLineCount+10-(nCurPage-1)*nMaxLinePerPage)*nCharHeight,
sacount, strlen(sacount));
//輸出總金額：應收金額、實收金額、找零
CString stotal,srealtotal,sdiscount;
stotal.Format("%d",m_nPayTotalPrice);
srealtotal.Format("%d",m_nPayRealPrice);
sdiscount.Format("%d",m_nPayRePrice);
stotal= "應收金額:"+stotal;
srealtotal="實收金額:"+srealtotal;
sdiscount= "找 零:"+sdiscount;
dc.TextOut( 2, nYMargin+(m_nLineCount+11-(nCurPage-1)*nMaxLinePerPage)*nCharHeight,
stotal, strlen(stotal));
dc.TextOut( 2, nYMargin+(m_nLineCount+12-(nCurPage-1)*nMaxLinePerPage)*nCharHeight,
srealtotal, strlen(srealtotal));
dc.TextOut( 2, nYMargin+(m_nLineCount+13-(nCurPage-1)*nMaxLinePerPage)*nCharHeight,
sdiscount, strlen(sdiscount));
//------------------------------------------------//
stitle="------------------------------------";
dc.TextOut( 2, nYMargin+(m_nLineCount+14-(nCurPage-1)*nMaxLinePerPage)*nCharHeight,
stitle, strlen(stitle));
//輸出結(jié)帳時間
CString paytime;
CTime now=CTime::GetCurrentTime();
paytime=now.Format(_T("%Y-%m-%d %H:%M:%S"));
paytime="結(jié)賬時間:"+paytime;
dc.TextOut( 2, nYMargin+(m_nLineCount+15-(nCurPage-1)*nMaxLinePerPage)*nCharHeight,
paytime, strlen(paytime));
srealtotal="謝謝惠顧，歡迎再次光臨！";
dc.TextOut( 2, nYMargin+(m_nLineCount+16-(nCurPage-1)*nMaxLinePerPage)*nCharHeight,
srealtotal, strlen(srealtotal));
//打印結(jié)束
dc.EndPage();
dc.EndDoc();
//恢復原來的字體
dc.SelectObject(def_font);
font.DeleteObject();
DeleteDC(dc.Detach());
return;// TRUE;
}
void CPayDlg::OnCancel()
{
// TODO: Add your control notification handler code here
CDialog::OnOK();
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -