// OffdutyDlg.cpp : implementation file
//

#include "stdafx.h"
#include "MenuManage.h"
#include "OffdutyDlg.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

extern CMenuManageApp theApp;
/////////////////////////////////////////////////////////////////////////////
// COffdutyDlg dialog


COffdutyDlg::COffdutyDlg(CWnd* pParent /*=NULL*/)
: CDialog(COffdutyDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(COffdutyDlg)
	m_timeDay = 0;
	m_nTotalAcount = 0;
	m_strDayName = _T("");
	//}}AFX_DATA_INIT
}


void COffdutyDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(COffdutyDlg)
	DDX_Control(pDX, IDC_DATETIMEPICKER_OFFTIME, m_timectrlOff);
	DDX_Control(pDX, IDC_DATAGRID_OFF, m_dbTotalDay);
	DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKER_OFFTIME, m_timeDay);
	DDX_Text(pDX, IDC_EDIT_CHECK_ACOUNT, m_nTotalAcount);
	DDX_Text(pDX, IDC_EDIT_OFF_NAME, m_strDayName);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(COffdutyDlg, CDialog)
//{{AFX_MSG_MAP(COffdutyDlg)
ON_BN_CLICKED(IDC_CAL_DAY_BTN, OnCalDayBtn)
ON_BN_CLICKED(IDC_PRINT_DAY_BTN, OnPrintDayBtn)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// COffdutyDlg message handlers

BOOL COffdutyDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_timeDay=CTime::GetCurrentTime();
	
	m_strDayName = theApp.m_name;
	UpdateData(FALSE);
	
	return TRUE;  // return TRUE unless you set the focus to a control
	// EXCEPTION: OCX Property Pages should return FALSE
}

void COffdutyDlg::OnCalDayBtn() 
{
	// TODO: Add your control notification handler code here
	CString sql,str;
	int temp = 1;
	str.Format("%d" , temp);
	//該收銀員經手已結帳的單子
	sql = "Select * From DeskInfo Where DeskCheck = "+str+" and DeskName = '"+m_strDayName+"'";
	m_pRecordset_Desk.CreateInstance("ADODB.Recordset");
	m_pRecordset_Desk->Open((_variant_t)sql,_variant_t((IDispatch *)theApp.m_pConnection,true),adOpenDynamic,adLockPessimistic,adCmdText);
	
	int renminbi_jine=0;
	int qita_jine = 0;
	int total_jine=0;
	int acount=0;
	//計算總單數，并統計人民幣及其他結算金額
	if(m_pRecordset_Desk->GetRecordCount()!=0)
	{
		while(!m_pRecordset_Desk->adoEOF)
		{
			str = m_pRecordset_Desk->GetCollect("DeskPaymode").bstrVal;
			if(str.CompareNoCase("人民幣") == 0)
				renminbi_jine += m_pRecordset_Desk->GetCollect("DeskPrice").lVal;
			else
				qita_jine += m_pRecordset_Desk->GetCollect("DeskPrice").lVal;
			
			acount++;
			m_pRecordset_Desk ->MoveNext();
		}
	}
	
	total_jine = renminbi_jine + qita_jine;
	
	
	m_pRecordset_Off.CreateInstance("ADODB.Recordset");
	m_pRecordset_Off->Open("Select * From CalDayInfo",_variant_t((IDispatch *)theApp.m_pConnection,true),adOpenDynamic,adLockPessimistic,adCmdText);
	
	if(m_pRecordset_Off->GetRecordCount()!=0)
	{
		while(!m_pRecordset_Off->adoEOF)
		{
			m_pRecordset_Off ->Delete(adAffectCurrent);
			m_pRecordset_Off->MoveNext();
		}
		
	}
	
	m_pRecordset_Off->AddNew();
	m_pRecordset_Off->PutCollect("mode",_variant_t("人民幣"));
	str.Format("%d",renminbi_jine);
	m_pRecordset_Off->PutCollect("money",_variant_t(str));
	
	m_pRecordset_Off->AddNew();
	m_pRecordset_Off->PutCollect("mode",_variant_t("其他"));
	str.Format("%d",qita_jine);
	m_pRecordset_Off->PutCollect("money",_variant_t(str));
	
	m_pRecordset_Off->AddNew();
	m_pRecordset_Off->PutCollect("mode",_variant_t("合計"));
	str.Format("%d",total_jine);
	m_pRecordset_Off->PutCollect("money",_variant_t(str));
	
	m_dbTotalDay.SetRefDataSource(NULL);
	m_dbTotalDay.SetRefDataSource((LPUNKNOWN)m_pRecordset_Off);
	m_dbTotalDay.SetColumnHeaders(2) ;
	
	m_dbTotalDay.Refresh();
	
	m_pRecordset_Off->Update();
	
	m_nTotalAcount = acount;
	UpdateData(FALSE);
}

void COffdutyDlg::OnPrintDayBtn() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	
	CDC dc;
	//把打印設備環境附加到DC對象
	CPrintDialog pdlg(FALSE,PD_NOPAGENUMS|PD_NOSELECTION,this);
	BOOL bFindPrinter=pdlg.GetDefaults();
	if(!bFindPrinter)
		return ;
	dc.Attach(pdlg.GetPrinterDC());
	
	//取打印機的橫方向和縱方向的分辨率
	//即每英寸點數
	short cxInch = dc.GetDeviceCaps(LOGPIXELSX);
	short cyInch = dc.GetDeviceCaps(LOGPIXELSY);
	//字體
	CFont font;
	VERIFY(font.CreatePointFont(96, "宋體", &dc));//為DC創建字體
	CFont* def_font = dc.SelectObject(&font);//保存現在的字體
	
	//根據字體寬度、高度計算每行最大字數及每頁最大行數
	//取打印紙張高度和寬度
	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;
	
	//每行最大字數	//每頁最大行數
	int	m_MaxLineChar = nPageWidth / nCharWidth - 8; 
	int	m_LinesPerPage = nPageHeight/ nCharHeight; 
	
	//頁邊距
	int nXMargin = 2;
	int nYMargin = 2;
	
	//獲得行數
	int i;	
	
	//設置所需打印紙張數目
	DOCINFO di;
	di.cbSize = sizeof(DOCINFO);
	di.lpszDocName = "CalDay 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 sname;
	sname ="收 銀 員:"+m_strDayName;
	dc.TextOut( 2, nYMargin+nCharHeight*3, sname, strlen(sname));	
	//輸出下班時間
	CString sofftime;
	m_timectrlOff.GetWindowText(sofftime);
	sofftime=  "下班時間:"+sofftime;
	dc.TextOut( 2+nCharWidth*20, nYMargin+nCharHeight*3, sofftime, strlen(sofftime));
	//輸出總單數
	CString sacount;
	sacount.Format("%d",m_nTotalAcount);
	sacount = "總 單 數:" + sacount;
	dc.TextOut( 2, nYMargin+nCharHeight*4, sacount, strlen(sacount));
	
	stitle="--------------銷售匯總----------------------";
	dc.TextOut( 2, nYMargin+nCharHeight*6, stitle, strlen(stitle));
	
	//輸出列表的列標題
	CString slisttitle;
	slisttitle="付款方式                      金額(元)";
	dc.TextOut( 2, nYMargin+nCharHeight*7,slisttitle, strlen(slisttitle));	
	
	int nMaxLinePerPage = nPageHeight/nCharHeight -3;//每頁最大行數
	int nCurPage =1;
	
	//輸出各列的數據
	//-------------------------//
	CString sql;
	
	sql =  "SELECT * FROM CalDayInfo ";
	m_pRecordset_Off.CreateInstance("ADODB.Recordset");
	m_pRecordset_Off->Open((_variant_t)sql,_variant_t((IDispatch *)theApp.m_pConnection,true),adOpenDynamic,adLockPessimistic,adCmdText);
	int m_nLineCount = m_pRecordset_Off->GetRecordCount();
	//-------------------------//
	
	CString name,acount;//各種支付方式的綜合

	i=0;
	while(!m_pRecordset_Off->adoEOF)
	{
		if(m_nLineCount+7-(nCurPage-1)*nMaxLinePerPage > nMaxLinePerPage)
		{
			//新的一頁
			dc.EndPage();
			dc.StartPage();
			nCurPage ++;
		}
		
		name = m_pRecordset_Off->GetCollect("mode").bstrVal;
		acount.Format("%d",m_pRecordset_Off->GetCollect("money").lVal) ;
		
		dc.TextOut( 2, nYMargin+(i+8-(nCurPage-1)*nMaxLinePerPage)*nCharHeight, 
			name, strlen(name));
		dc.TextOut( 2+nCharWidth*30, nYMargin+(i+8-(nCurPage-1)*nMaxLinePerPage)*nCharHeight, 
			acount, strlen(acount));
		
		m_pRecordset_Off->MoveNext();
		i++;
	}
	stitle="------------------------------------";
	
	dc.EndPage();
	dc.EndDoc();
	//打印結束
	//最后不要忘記將字體還原，這一句是必需的
	dc.SelectObject(def_font); //恢復原來的字體
	font.DeleteObject(); 
	
	DeleteDC(dc.Detach()); 
	
	return;// TRUE;			
}