daycount.cpp

小型网吧管理系统,可实现上下机,会员管理,结算功能

// DayCount.cpp : 实现文件
//

#include "stdafx.h"
#include "NetworkX.h"
#include "DayCount.h"
#include ".\daycount.h"
#include "DataCountset.h"


// CDayCount 对话框

IMPLEMENT_DYNAMIC(CDayCount, CDialog)
CDayCount::CDayCount(CWnd* pParent /*=NULL*/)
	: CDialog(CDayCount::IDD, pParent)
	, m_Date(0)
	
	, m_Remark(_T(""))
	, m_AllFee(0)
{
	m_Brush.CreateSolidBrush(RGB(100,200,255));
}

CDayCount::~CDayCount()
{
}

void CDayCount::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKER1, m_Date);

	DDX_Control(pDX, IDC_LIST2, m_List);
	DDX_Text(pDX, IDC_EDIT2, m_Remark);
	DDX_Text(pDX, IDC_EDIT1, m_AllFee);
}


BEGIN_MESSAGE_MAP(CDayCount, CDialog)
	ON_BN_CLICKED(IDOK, OnBnClickedOk)
	ON_WM_CTLCOLOR()
END_MESSAGE_MAP()


// CDayCount 消息处理程序
void CDayCount::show()
{
	if(!m_database.IsOpen())
	{
		m_database.Open(_T("Management"));
	}
	//对列表控件的内容更新,清空原来的内容
	m_List.DeleteAllItems();
	//创建记录集
	CDataCountset m_pSet(&m_database);
	m_pSet.Open(AFX_DB_USE_DEFAULT_TYPE,m_query);
	if(m_pSet.GetRecordCount()!=0)		
		m_pSet.MoveFirst();
	int i=0;
	do
	 {  
		CString s;
		s=m_pSet.m_Date.Format("%Y-%m-%d");
        m_List.InsertItem(i,s,0);
		s.Format("%.1f",m_pSet.m_AllFee);
		m_List.SetItemText(i,1,s);
		m_List.SetItemText(i,2,m_pSet.m_Remark);
		i++;
		 m_pSet.MoveNext();
		
		}  while(!m_pSet.IsEOF());
        m_pSet.MoveFirst();	
}

void CDayCount::OnBnClickedOk()
{
	// TODO: 在此添加控件通知处理程序代码
	UpdateData(true);
	CDataCountset m_pSet(&m_database);
	CString strSQL;
	strSQL.Format("select * from 每日结算");
	m_pSet.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
	if(m_pSet.CanAppend())
	{
		m_pSet.AddNew();
	     m_pSet.m_Date=m_Date;
		 m_pSet.m_AllFee=m_AllFee;
		 m_pSet.m_Remark=m_Remark;
         m_pSet.Update();
	     m_pSet.Requery();
	     m_pSet.MoveLast();

	}
	    CString s;
        s=m_Date.Format("%Y-%m-%D");
        m_List.InsertItem(0,s,0);
		s.Format("%.1f",m_AllFee);
		m_List.SetItemText(0,1,s);
		m_List.SetItemText(0,2,m_Remark);

    m_database.Close();
			
	
}

BOOL CDayCount::OnInitDialog()
{
	CDialog::OnInitDialog();

	// TODO:  在此添加额外的初始化
	
	CenterWindow();
	m_hIcon=AfxGetApp()->LoadIcon(IDR_MAINFRAME);
	this->SetIcon(m_hIcon,TRUE);
	m_List.SetTextColor(RGB(100,0,100));
	m_List.SetTextBkColor(RGB(240,247,233));
	 m_List.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
    m_List.InsertColumn(0,_T("日期"),LVCFMT_IMAGE|LVCFMT_LEFT);
	m_List.InsertColumn(1,_T("网费"));
	m_List.InsertColumn(2,_T("备注"));
	m_List.SetColumnWidth(0,100);
	m_List.SetColumnWidth(1,80);
	m_List.SetColumnWidth(2,80);
	m_query.Format("select * from 每日结算 order by 日期");
	show();
	CTime Nowtime=CTime::GetCurrentTime();
	this->m_Date=Nowtime;
	UpdateData(false);



	return TRUE;  // return TRUE unless you set the focus to a control
	// 异常: OCX 属性页应返回 FALSE
}

HBRUSH CDayCount::OnCtlColor(CDC* pDC, CWnd* pWnd, UINT nCtlColor)
{
	HBRUSH hbr = CDialog::OnCtlColor(pDC, pWnd, nCtlColor);

	// TODO:  在此更改 DC 的任何属性
	if(nCtlColor==CTLCOLOR_DLG)
	  return (HBRUSH)m_Brush;

	// TODO:  如果默认的不是所需画笔，则返回另一个画笔
	return hbr;
}