lyfz_repos/经典版源码/lyfzClient/branches/715/YearForm2.cpp

// YearForm2.cpp : implementation file
//
#include "stdafx.h"
#include "ylgl.h"
#include "YearForm2.h"
#include "MyMdi.H"
#include "VcPlot.h"
#include "VcAxis.h"
#include "VcValueScale.h"
#include "VcSeriesCollection.h"
#include "VcSeries.h"
#include "VcPen.h"
#include "VcCategoryScale.h"
#include "VcColor.h"
#include "VcDataGrid.h"
#include "VcBackdrop.h"
#include "VcFill.h"
#include "VcBrush.h"
#include "VcDataPoints.h"
#include "VcDataPoint.h"
#include "VcDataPointLabel.h"
#include "VcAxisTitle.h"
#include "ShowMschart.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
//  YearForm2

IMPLEMENT_DYNCREATE(YearForm2, MyFormView)

YearForm2::YearForm2()
: MyFormView(YearForm2::IDD)
{
	m_year = atoi(g_date.Mid (0,4));
	m_month = atoi(g_date.Mid (5,2));
	m_day = atoi(g_date.Mid (8,2));
	m_check1 = 1;
	m_check2 = 1;
	m_check3 = 1;
	m_check4 = 1;
	m_radio2 = 0;
	m_radio1 = 1;
	m_check5 = 1;
	m_bInit=0;
	m_timestmap=0;
	m_check6 = 1;
	m_check7 = 1;
	//}}AFX_DATA_INIT
}

YearForm2::~YearForm2()
{
}

void YearForm2::DoDataExchange(CDataExchange* pDX)
{
	MyFormView::DoDataExchange(pDX);
	DDX_Control(pDX, IDC_SPIN3, m_spinday);
	DDX_Control(pDX, IDC_SPIN2, m_spinmonth);
	DDX_Control(pDX, IDC_SPIN1, m_spinyear);
	DDX_Control(pDX, IDC_STATIC1, m_static1);
	DDX_Text(pDX, IDC_EDITyear, m_year);
	DDV_MinMaxUInt(pDX, m_year, 1900, 3000);
	DDX_Text(pDX, IDC_EDITmonth, m_month);
	DDV_MinMaxUInt(pDX, m_month, 1, 12);
	DDX_Text(pDX, IDC_EDITday, m_day);
	DDV_MinMaxUInt(pDX, m_day, 1, 31);
	DDX_Control(pDX, IDC_MSCHART1, m_Chart);
	DDX_Check(pDX, IDC_CHECK1, m_check1);
	DDX_Check(pDX, IDC_CHECK2, m_check2);
	DDX_Check(pDX, IDC_CHECK3, m_check3);
	DDX_Check(pDX, IDC_CHECK4, m_check4);
	DDX_Radio(pDX, IDC_RADIO6, m_radio2);
	DDX_Radio(pDX, IDC_RADIO3, m_radio1);
	DDX_Control(pDX, IDC_MSCHART2, m_Chart2);
	DDX_Control(pDX, IDC_MSCHART3, m_Chart3);
	DDX_Check(pDX, IDC_CHECK5, m_check5);
	DDX_Check(pDX, IDC_CHECK6, m_check6);
	DDX_Check(pDX, IDC_CHECK7, m_check7);
	//}}AFX_DATA_MAP
}

BEGIN_MESSAGE_MAP(YearForm2, MyFormView)
ON_BN_CLICKED(IDC_BUTclose, OnBUTclose)
ON_EN_CHANGE(IDC_EDITyear, OnChangeEDITyear)
ON_EN_CHANGE(IDC_EDITmonth, OnChangeEDITmonth)
ON_EN_CHANGE(IDC_EDITday, OnChangeEDITday)
ON_BN_CLICKED(IDC_RADIO3, OnRadio3)
ON_BN_CLICKED(IDC_RADIO4, OnRadio4)
ON_BN_CLICKED(IDC_RADIO5, OnRadio5)
ON_BN_CLICKED(IDC_RADIO6, OnRadio6)
ON_BN_CLICKED(IDC_RADIO7, OnRadio7)
ON_BN_CLICKED(IDC_CHECK1, OnCheck1)
ON_BN_CLICKED(IDC_CHECK2, OnCheck2)
ON_BN_CLICKED(IDC_CHECK3, OnCheck3)
ON_BN_CLICKED(IDC_CHECK4, OnCheck4)
ON_BN_CLICKED(IDC_CHECK5, OnCheck5)
ON_BN_CLICKED(IDC_CHECK6, OnCheck6)
ON_BN_CLICKED(IDC_CHECK7, OnCheck7)
ON_BN_CLICKED(IDC_BUTprint, OnBUTprint)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// YearForm2 diagnostics

#ifdef _DEBUG
void YearForm2::AssertValid() const
{
	MyFormView::AssertValid();
}

void YearForm2::Dump(CDumpContext& dc) const
{
	MyFormView::Dump(dc);
}
#endif //_DEBUG

/////////////////////////////////////////////////////////////////////////////
// YearForm2 message handlers

void YearForm2::OnInitialUpdate() 
{
	MyFormView::OnInitialUpdate();
	// TODO: Add your specialized code here and/or call the base class
	CMyMdi Mdi;
	Mdi.SetSubView((CWnd*)GetParent(), (CWnd*)this);
	// Here we create the outbar control using the splitter as its parent
	// and setting its id to the first pane.
	CRect rc2;
	GetWindowRect(rc2);	//
	::MoveWindow(m_hWnd,g_rc.left,g_rc.top,g_rc.Width(),g_rc.Height(),TRUE);
	EnumChildWindows(m_hWnd,(WNDENUMPROC)EnumChildProc,0);
	m_static1.SetFont (&g_titlefont);
	m_spinyear.SetRange (1900, 3000);
	m_spinmonth.SetRange (1, 12);
	m_spinday.SetRange (1, 31);
	m_Chart.GetBackdrop().GetFill().SetStyle(1);
	m_Chart.GetBackdrop().GetFill().GetBrush().GetFillColor().Set(255, 255, 255);
	m_Chart.SetShowLegend(TRUE);
	m_Chart.SetColumn(1);
	m_Chart.SetColumnLabel((LPCTSTR)"总收入");
	m_Chart.SetChartType(1);
	// 栈模式
	m_Chart.SetStacking(FALSE);
	VARIANT var;
	m_Chart.GetPlot().GetAxis(1,var).GetValueScale().SetAuto(1);	// 不自动标注Y轴刻度
	m_Chart.GetPlot().GetAxis(0,var).GetCategoryScale().SetAuto(0);			// 不自动标注X轴刻度
	m_Chart.GetPlot().GetAxis(0,var).GetCategoryScale().SetDivisionsPerLabel(1);// 每刻度一个标注
	m_Chart.GetPlot().GetAxis(0,var).GetCategoryScale().SetDivisionsPerTick(1); // 每刻度一个刻度线
	m_Chart.SetColumnCount(1); 
	m_Chart.GetPlot().GetSeriesCollection().GetItem(1).GetDataPoints ().GetItem(-1).GetBrush ().GetFillColor ().Set(255, 0, 0);
	
	// 线宽(对点线图有效)
	m_Chart.GetPlot().GetSeriesCollection().GetItem(1).GetPen().SetWidth(30);
	
	// 数据点类型显示数据值的模式(对柱柱状图和点线图有效)
	// 0: 不显示	1: 显示在柱状图外
	// 2: 显示在柱状图内上方	3: 显示在柱状图内中间	4: 显示在柱状图内下方
	m_Chart.GetPlot().GetSeriesCollection().GetItem(1).GetDataPoints().GetItem(-1).GetDataPointLabel().SetLocationType(1);
	//////////////////////
	m_Chart2.GetBackdrop().GetFill().SetStyle(1);
	m_Chart2.GetBackdrop().GetFill().GetBrush().GetFillColor().Set(255, 255, 255);
	m_Chart2.SetShowLegend(TRUE);
	m_Chart2.SetColumn(1);
	m_Chart2.SetColumnLabel((LPCTSTR)"总支出");
	
	m_Chart2.SetChartType(1);
	// 栈模式
	m_Chart2.SetStacking(FALSE);
	
	m_Chart2.GetPlot().GetAxis(1,var).GetValueScale().SetAuto(1);	// 不自动标注Y轴刻度
	
	m_Chart2.GetPlot().GetAxis(0,var).GetCategoryScale().SetAuto(0);			// 不自动标注X轴刻度
	m_Chart2.GetPlot().GetAxis(0,var).GetCategoryScale().SetDivisionsPerLabel(1);// 每刻度一个标注
	m_Chart2.GetPlot().GetAxis(0,var).GetCategoryScale().SetDivisionsPerTick(1); // 每刻度一个刻度线
	m_Chart2.SetColumnCount(1); 
	m_Chart2.GetPlot().GetSeriesCollection().GetItem(1).GetDataPoints ().GetItem(-1).GetBrush ().GetFillColor ().Set(255, 0, 0);
	
	// 线宽(对点线图有效)
	m_Chart2.GetPlot().GetSeriesCollection().GetItem(1).GetPen().SetWidth(30);
	
	// 数据点类型显示数据值的模式(对柱柱状图和点线图有效)
	// 0: 不显示	1: 显示在柱状图外
	// 2: 显示在柱状图内上方	3: 显示在柱状图内中间	4: 显示在柱状图内下方
	m_Chart2.GetPlot().GetSeriesCollection().GetItem(1).GetDataPoints().GetItem(-1).GetDataPointLabel().SetLocationType(1);
	///////////////////////////
	m_Chart3.GetBackdrop().GetFill().SetStyle(1);
	m_Chart3.GetBackdrop().GetFill().GetBrush().GetFillColor().Set(255, 255, 255);
	m_Chart3.SetShowLegend(TRUE);
	
	
	m_Chart3.SetChartType(1);
	// 栈模式
	m_Chart3.SetStacking(FALSE);
	
	m_Chart3.GetPlot().GetAxis(1,var).GetValueScale().SetAuto(1);	// 不自动标注Y轴刻度
	
	m_Chart3.GetPlot().GetAxis(0,var).GetCategoryScale().SetAuto(0);			// 不自动标注X轴刻度
	m_Chart3.GetPlot().GetAxis(0,var).GetCategoryScale().SetDivisionsPerLabel(1);// 每刻度一个标注
	m_Chart3.GetPlot().GetAxis(0,var).GetCategoryScale().SetDivisionsPerTick(1); // 每刻度一个刻度线
	
	m_Chart3.SetColumnCount(6); 
	m_Chart3.SetColumn(1);
	m_Chart3.SetColumnLabel((LPCTSTR)"全部");
	m_Chart3.SetColumn(2);
	m_Chart3.SetColumnLabel((LPCTSTR)"婚纱照");
	m_Chart3.SetColumn(3);
	m_Chart3.SetColumnLabel((LPCTSTR)"写真照");
	m_Chart3.SetColumn(4);
	m_Chart3.SetColumnLabel((LPCTSTR)"宝宝照");
	m_Chart3.SetColumn(5);
	m_Chart3.SetColumnLabel((LPCTSTR)"全家福");
	m_Chart3.SetColumn(6);
	m_Chart3.SetColumnLabel((LPCTSTR)"情侣照");
	
	
	m_Chart3.GetPlot().GetSeriesCollection().GetItem(1).GetDataPoints ().GetItem(-1).GetBrush ().GetFillColor ().Set(255, 0, 0);
	m_Chart3.GetPlot().GetSeriesCollection().GetItem(2).GetDataPoints ().GetItem(-1).GetBrush ().GetFillColor ().Set(0, 255, 0);
	m_Chart3.GetPlot().GetSeriesCollection().GetItem(3).GetDataPoints ().GetItem(-1).GetBrush ().GetFillColor ().Set(0, 0, 255);
	m_Chart3.GetPlot().GetSeriesCollection().GetItem(4).GetDataPoints ().GetItem(-1).GetBrush ().GetFillColor ().Set(0, 255, 255);
	m_Chart3.GetPlot().GetSeriesCollection().GetItem(5).GetDataPoints ().GetItem(-1).GetBrush ().GetFillColor ().Set(255, 255, 0);
	m_Chart3.GetPlot().GetSeriesCollection().GetItem(6).GetDataPoints ().GetItem(-1).GetBrush ().GetFillColor ().Set(255, 0, 255);
	
	// 线宽(对点线图有效)
	m_Chart3.GetPlot().GetSeriesCollection().GetItem(1).GetPen().SetWidth(30);
	m_Chart3.GetPlot().GetSeriesCollection().GetItem(2).GetPen().SetWidth(30);
	m_Chart3.GetPlot().GetSeriesCollection().GetItem(3).GetPen().SetWidth(30);
	m_Chart3.GetPlot().GetSeriesCollection().GetItem(4).GetPen().SetWidth(30);
	m_Chart3.GetPlot().GetSeriesCollection().GetItem(5).GetPen().SetWidth(30);
	m_Chart3.GetPlot().GetSeriesCollection().GetItem(6).GetPen().SetWidth(30); 
	// 数据点类型显示数据值的模式(对柱柱状图和点线图有效)
	// 0: 不显示	1: 显示在柱状图外
	// 2: 显示在柱状图内上方	3: 显示在柱状图内中间	4: 显示在柱状图内下方
	m_Chart3.GetPlot().GetSeriesCollection().GetItem(1).GetDataPoints().GetItem(-1).GetDataPointLabel().SetLocationType(1);
	m_Chart3.GetPlot().GetSeriesCollection().GetItem(2).GetDataPoints().GetItem(-1).GetDataPointLabel().SetLocationType(1);
	m_Chart3.GetPlot().GetSeriesCollection().GetItem(3).GetDataPoints().GetItem(-1).GetDataPointLabel().SetLocationType(1);
	m_Chart3.GetPlot().GetSeriesCollection().GetItem(4).GetDataPoints().GetItem(-1).GetDataPointLabel().SetLocationType(1);
	m_Chart3.GetPlot().GetSeriesCollection().GetItem(5).GetDataPoints().GetItem(-1).GetDataPointLabel().SetLocationType(1);
	m_Chart3.GetPlot().GetSeriesCollection().GetItem(6).GetDataPoints().GetItem(-1).GetDataPointLabel().SetLocationType(1);
	
	////////////////
	GetDlgItem(IDC_STATIC2)->GetWindowRect(rc2);
	ScreenToClient(rc2);
	m_Chart.MoveWindow (rc2);
	
	GetDlgItem(IDC_STATIC3)->GetWindowRect(rc2);
	ScreenToClient(rc2);
	m_Chart2.MoveWindow (rc2);
	
	GetDlgItem(IDC_STATIC12)->GetWindowRect(rc2);
	ScreenToClient(rc2);
	m_Chart3.MoveWindow (rc2);
	m_bInit=1;

#ifdef CHILD_VERSION
	SetDlgItemText(IDC_CHECK4, _T("引导二销"));
#endif

	DateChange();
}

void YearForm2::FillGrid()
{
	
}

void YearForm2::OnBUTclose() 
{
	// TODO: Add your control notification handler code here
	GetParent()->SendMessage(WM_CLOSE);
}

void YearForm2::OnChangeEDITyear() 
{
	// TODO: If this is a RICHEDIT control, the control will not
	// send this notification unless you override the MyFormView::OnInitDialog()
	// function and call CRichEditCtrl().SetEventMask()
	// with the ENM_CHANGE flag ORed into the mask.
	DateChange();
	// TODO: Add your control notification handler code here
	
}

void YearForm2::OnChangeEDITmonth() 
{
	// TODO: If this is a RICHEDIT control, the control will not
	// send this notification unless you override the MyFormView::OnInitDialog()
	// function and call CRichEditCtrl().SetEventMask()
	// with the ENM_CHANGE flag ORed into the mask.
	//  DateChange();
	// TODO: Add your control notification handler code here
	
}

void YearForm2::OnChangeEDITday() 
{
	// TODO: If this is a RICHEDIT control, the control will not
	// send this notification unless you override the MyFormView::OnInitDialog()
	// function and call CRichEditCtrl().SetEventMask()
	// with the ENM_CHANGE flag ORed into the mask.
	//    DateChange();
	// TODO: Add your control notification handler code here
	
}

void YearForm2::DateChange()
{
	if(m_bInit==0)return;
	m_spinyear.EnableWindow(0);
	m_spinmonth.EnableWindow(0);
	m_spinday.EnableWindow(0);
	
	UpdateData();
	int i;
	int g_nYearposTemp=g_nYearpos;
	BOOL bLastYear=0;
	BOOL bThisYear=0;

#if JEFF_TEST_ON	// 2015开始禁用跨年数据;
	int g_nYearposPre = -1;

	if (m_year >= 2014 && m_year <= atoi(g_date.Left(4)) && g_hisyeararray.GetSize())
	{
		g_nYearpos = -1;
		bThisYear = 1;
		if (m_year == 2014)
		{
			g_nYearposPre = GetYearPos(m_year - 1);
		}
	}
	else if (m_year <= 2013 && g_hisyeararray.GetSize())
	{
		g_nYearpos = GetYearPos(m_year);
		if (g_nYearpos != -1)
			g_nYearposPre = GetYearPos(m_year - 1);
		bLastYear = 1;
	}
#else
	if(m_year==atoi(g_date.Left (4)) && g_hisyeararray.GetSize () )
		bThisYear=1;
	else if(m_year<=atoi(g_date.Left (4))-1 && g_hisyeararray.GetSize ())
		bLastYear=1;
	g_nYearpos=GetYearPos(m_year);
	int g_nYearposPre=GetYearPos(m_year-1);
#endif
	
	g_sendhead.bsql=0;
	g_sendhead.code[0]=14;		// 其他收入;
	g_sendhead.code[1]=13;		// 支出；
	g_sendhead.code[2]=16;		// 订单收入；
	g_sendhead.code[3]=198;		// 二销收入;
#if 0	// Jeff
	g_sendhead.tabcount=4;
#else
	g_sendhead.code[4]=216;		// 会员充值;
	g_sendhead.tabcount=5;
#endif

	CString sql,strdate,strdate2;
	strdate.Format ("%04d-%02d-%02d", m_year, 1, 1);
	strdate2.Format ("%04d-%02d-%02d", m_year, 12, 31);
	CRect rc;
	m_static1.GetWindowRect (rc);
	ScreenToClient(rc);
	InvalidateRect(rc);
	m_static1.SetWindowText (strdate.Left (4)+"年财务表");

	sql = _T("dat>='") + strdate + _T("' and dat<='") + strdate2 + _T("' and (sale2type is null or sale2type='');dat>='") + strdate + _T("' and dat<='") + strdate2 + _T("';date>='") + strdate + _T("' and date<='") + strdate2 + _T("';date>='") + strdate + _T("' and date<='") + strdate2 + _T("'; date>='") + strdate + _T("' and date<='") + strdate2 + _T("'");

	g_pMainWnd->ProcessChatMessageRequest2(sql);
	if(g_bSendOK==0)
	{
		g_nYearpos=g_nYearposTemp;
		m_spinyear.EnableWindow(1);
		m_spinmonth.EnableWindow(1);
		m_spinday.EnableWindow(1);
		return;
	}

#if 0
	DataToArray(&List2array,&List3array,&List11array,&other2salearray); // Jeff delete;
#else
	DataToArray(&List2array,&List3array,&List11array,&other2salearray,&memberarray);	// Jeff添加会员充值;
#endif

	if(bLastYear)//如果是去年, 则加今年的补款
	{
		g_nYearpos=-1;//今年
		g_sendhead.bsql=0;
		g_sendhead.code[0]=14;	// 其他收入;
		g_sendhead.code[1]=13;	// 支出；
		g_sendhead.code[2]=16;	// 订单收入；
		g_sendhead.code[3]=198;	// 二销收入;
#if 0
		g_sendhead.tabcount=4;
#else
		g_sendhead.code[4]=216;	// 会员充值;
		g_sendhead.tabcount=5;
#endif
		g_pMainWnd->ProcessChatMessageRequest2(sql);
		if(g_bSendOK==0)
		{
			g_nYearpos=g_nYearposTemp;
			m_spinyear.EnableWindow(1);
			m_spinmonth.EnableWindow(1);
			m_spinday.EnableWindow(1);
			return;
		}
		CArray<CStringArray, CStringArray>ThisYearList11array;
		CArray<CStringArray, CStringArray>ThisYearList3array;
		CArray<CStringArray, CStringArray>ThisYearList2array;
		CArray<CStringArray, CStringArray>ThisYearother2salearray;
#if 0
		DataToArray(&ThisYearList2array, &ThisYearList3array, &ThisYearList11array, &ThisYearother2salearray);
#else
		CArray<CStringArray, CStringArray>ThisYearmemberarray;
		DataToArray(&ThisYearList2array,&ThisYearList3array,&ThisYearList11array,&ThisYearother2salearray,&ThisYearmemberarray);	// Jeff添加会员充值;
#endif
		int oldsize=List11array.GetSize ();
		List11array.SetSize(oldsize+ThisYearList11array.GetSize ());
		for(i=oldsize; i<oldsize+ThisYearList11array.GetSize (); i++)
		{
			List11array.ElementAt (i).Copy(ThisYearList11array.ElementAt (i-oldsize));
		}
		
		oldsize=List3array.GetSize ();
		List3array.SetSize(oldsize+ThisYearList3array.GetSize ());
		for(i=oldsize; i<oldsize+ThisYearList3array.GetSize (); i++)
		{
			List3array.ElementAt (i).Copy(ThisYearList3array.ElementAt (i-oldsize));
		}
		
		oldsize=List2array.GetSize ();
		List2array.SetSize(oldsize+ThisYearList2array.GetSize ());
		for(i=oldsize; i<oldsize+ThisYearList2array.GetSize (); i++)
		{
			List2array.ElementAt (i).Copy(ThisYearList2array.ElementAt (i-oldsize));
		}
		
		oldsize=other2salearray.GetSize ();
		other2salearray.SetSize(oldsize+ThisYearother2salearray.GetSize ());
		for(i=oldsize; i<oldsize+ThisYearother2salearray.GetSize (); i++)
		{
			other2salearray.ElementAt (i).Copy(ThisYearother2salearray.ElementAt (i-oldsize));
		}

#if 1	// 添加会员充值;
		oldsize=memberarray.GetSize();
		memberarray.SetSize(oldsize+ThisYearmemberarray.GetSize());
		for (i=oldsize;i<oldsize+ThisYearmemberarray.GetSize();i++)
		{
			memberarray.ElementAt(i).Copy(ThisYearmemberarray.ElementAt(i-oldsize));
		}
#endif
	}
	if(g_nYearposPre!=-1)//如果是今年, 则加去年的补款
	{
		g_nYearpos=g_nYearposPre;//去年
		g_sendhead.bsql=0;
		g_sendhead.code[0]=14;			// 其他收入;
		g_sendhead.code[1]=13;			// 支出；
		g_sendhead.code[2]=16;			// 订单收入；
		g_sendhead.code[3]=198;			// 二销收入;
#if 0
		g_sendhead.tabcount=4;
#else
		g_sendhead.code[4]=216;			// 会员充值;
		g_sendhead.tabcount=5;
#endif
		g_pMainWnd->ProcessChatMessageRequest2(sql);
		if(g_bSendOK==0)
		{
			g_nYearpos=g_nYearposTemp;
			m_spinyear.EnableWindow(1);
			m_spinmonth.EnableWindow(1);
			m_spinday.EnableWindow(1);
			return;
		}
		CArray<CStringArray, CStringArray>ThisYearList11array;
		CArray<CStringArray, CStringArray>ThisYearList3array;
		CArray<CStringArray, CStringArray>ThisYearList2array;
		CArray<CStringArray, CStringArray>ThisYearother2salearray;
#if 0
		DataToArray(&ThisYearList2array, &ThisYearList3array, &ThisYearList11array, &ThisYearother2salearray);
#else
		CArray<CStringArray, CStringArray>ThisYearmemberarray;
		DataToArray(&ThisYearList2array,&ThisYearList3array,&ThisYearList11array,&ThisYearother2salearray,&ThisYearmemberarray);	// Jeff添加会员充值;
#endif
		int oldsize=List11array.GetSize ();
		List11array.SetSize(oldsize+ThisYearList11array.GetSize ());
		for(i=oldsize; i<oldsize+ThisYearList11array.GetSize (); i++)
		{
			List11array.ElementAt (i).Copy(ThisYearList11array.ElementAt (i-oldsize));
		}
		
		oldsize=List3array.GetSize ();
		List3array.SetSize(oldsize+ThisYearList3array.GetSize ());
		for(i=oldsize; i<oldsize+ThisYearList3array.GetSize (); i++)
		{
			List3array.ElementAt (i).Copy(ThisYearList3array.ElementAt (i-oldsize));
		}
		
		oldsize=List2array.GetSize ();
		List2array.SetSize(oldsize+ThisYearList2array.GetSize ());
		for(i=oldsize; i<oldsize+ThisYearList2array.GetSize (); i++)
		{
			List2array.ElementAt (i).Copy(ThisYearList2array.ElementAt (i-oldsize));
		}
		
		oldsize=other2salearray.GetSize ();
		other2salearray.SetSize(oldsize+ThisYearother2salearray.GetSize ());
		for(i=oldsize; i<oldsize+ThisYearother2salearray.GetSize (); i++)
		{
			other2salearray.ElementAt (i).Copy(ThisYearother2salearray.ElementAt (i-oldsize));
		}

#if 1	// 添加会员充值;
		oldsize=memberarray.GetSize();
		memberarray.SetSize(oldsize+ThisYearmemberarray.GetSize());
		for (i=oldsize;i<oldsize+ThisYearmemberarray.GetSize();i++)
		{
			memberarray.ElementAt(i).Copy(ThisYearmemberarray.ElementAt(i-oldsize));
		}
#endif
	}
	
    g_nYearpos=g_nYearposTemp;
	KindChange();
	m_spinyear.EnableWindow(1);
	m_spinmonth.EnableWindow(1);
	m_spinday.EnableWindow(1);
}

void YearForm2::KindChange()
{
	int i=0;
	float incomeMember[12]={0};		// add by Jeff:会员卡值;
	float incomedata1[12]={0};		// 前期 - all remark by Jeff
	float incomedata2[12]={0};		// 摄影二销
	float incomedata3[12]={0};		// 化妆二销
	float incomedata4[12]={0};		// 套系升级二销
	float incomedata5[12]={0};		// 选片二销
	float incomedata6[12]={0};		// 其它二销
	float payoutdata[12]={0};		// 支出	
	float fConsumeCards[12] = {0.0};		// add by Jeff:储值卡扣款;
	float fOtherIncome[12] = {0.0};			// add by Jeff:其他收入;
	
	CString stryear[12]={"1月","2月","3月","4月","5月","6月","7月","8月","9月","10月","11月","12月"};

#if 1	// Jeff会员充值;
	for( i=0; i<memberarray.GetSize (); i++)
	{
		incomeMember[atoi(memberarray.ElementAt(i).ElementAt(4).Mid(5,2))-1] += atof(memberarray.ElementAt(i).ElementAt(3));
	} 
#endif
	
    for( i=0; i<List11array.GetSize (); i++)		// 订单收入 ;
	{
		if (List11array.ElementAt(i).ElementAt(8) == "储值卡扣款")	// Jeff add 
		{
			fConsumeCards[atoi(List11array.ElementAt (i).ElementAt (7).Mid (5, 2))-1]+=atof(List11array.ElementAt (i).ElementAt (4));
			//AfxMessageBox("订单收入==储值卡扣款");
		}

		if(List11array.ElementAt (i).ElementAt (5)=="预约收款"||List11array.ElementAt (i).ElementAt (5)=="预约补款")
			incomedata1[atoi(List11array.ElementAt (i).ElementAt (7).Mid (5, 2))-1]+=atof(List11array.ElementAt (i).ElementAt (4));
		else if(List11array.ElementAt (i).ElementAt (5)=="摄影二销")
			incomedata2[atoi(List11array.ElementAt (i).ElementAt (7).Mid (5, 2))-1]+=atof(List11array.ElementAt (i).ElementAt (4));

#ifndef CHILD_VERSION
		else if(List11array.ElementAt (i).ElementAt (5)=="化妆二销")
#else
		else if(List11array.ElementAt (i).ElementAt (5)=="引导二销")
#endif
			incomedata3[atoi(List11array.ElementAt (i).ElementAt (7).Mid (5, 2))-1]+=atof(List11array.ElementAt (i).ElementAt (4));
		else if(List11array.ElementAt (i).ElementAt (5)=="套系升级二销")
			incomedata4[atoi(List11array.ElementAt (i).ElementAt (7).Mid (5, 2))-1]+=atof(List11array.ElementAt (i).ElementAt (4));
		else if(List11array.ElementAt (i).ElementAt (5)=="选片二销")
			incomedata5[atoi(List11array.ElementAt (i).ElementAt (7).Mid (5, 2))-1]+=atof(List11array.ElementAt (i).ElementAt (4));
		else if(List11array.ElementAt (i).ElementAt(5)!="")
			incomedata6[atoi(List11array.ElementAt (i).ElementAt (7).Mid (5, 2))-1]+=atof(List11array.ElementAt (i).ElementAt (4));
	} 
	
	/* -add by Jeff- */
	for ( i = 0; i < List2array.GetSize(); i++)		// 其它收入;
	{
		if (List2array.ElementAt(i).ElementAt(9) == "储值卡扣款")
		{
			fConsumeCards[atoi(List2array.ElementAt (i).ElementAt (3).Mid (5, 2))-1]+=atof(List2array.ElementAt (i).ElementAt (2));
			//AfxMessageBox("其它收入==储值卡扣款");
		}

		fOtherIncome[atoi(List2array.ElementAt (i).ElementAt (3).Mid (5, 2))-1]+=atof(List2array.ElementAt (i).ElementAt (2));
	}
	
	for( i=0; i<other2salearray.GetSize (); i++) 
	{
		if (other2salearray.ElementAt(i).ElementAt(7) == "储值卡扣款")
		{
			fConsumeCards[atoi(other2salearray.ElementAt (i).ElementAt (5).Mid (5, 2))-1]+=atof(other2salearray.ElementAt (i).ElementAt (4));
			//AfxMessageBox("2销收入==储值卡扣款");
		}

		if(other2salearray.ElementAt (i).ElementAt (3)=="摄影二销")
			incomedata2[atoi(other2salearray.ElementAt (i).ElementAt (5).Mid (5, 2))-1]+=atof(other2salearray.ElementAt (i).ElementAt (4));

#ifndef CHILD_VERSION
		else if(other2salearray.ElementAt (i).ElementAt (3)=="化妆二销")
#else
		else if(other2salearray.ElementAt (i).ElementAt (3)=="化妆二销")//"引导二销"
#endif
			incomedata3[atoi(other2salearray.ElementAt (i).ElementAt (5).Mid (5, 2))-1]+=atof(other2salearray.ElementAt (i).ElementAt (4));
		else if(other2salearray.ElementAt (i).ElementAt (3)=="套系升级二销")
			incomedata4[atoi(other2salearray.ElementAt (i).ElementAt (5).Mid (5, 2))-1]+=atof(other2salearray.ElementAt (i).ElementAt (4));
		else if(other2salearray.ElementAt (i).ElementAt (3)=="选片二销")
			incomedata5[atoi(other2salearray.ElementAt (i).ElementAt (5).Mid (5, 2))-1]+=atof(other2salearray.ElementAt (i).ElementAt (4));
		else if(other2salearray.ElementAt (i).ElementAt(3)!="")
			incomedata6[atoi(other2salearray.ElementAt (i).ElementAt (5).Mid (5, 2))-1]+=atof(other2salearray.ElementAt (i).ElementAt (4));
	}
	
	if(m_filter.IsEmpty ())
	{
		for( i=0; i<List3array.GetSize (); i++)
		{
			payoutdata[atoi(List3array.ElementAt (i).ElementAt (3).Mid (5, 2))-1]+=atof(List3array.ElementAt (i).ElementAt (2));
		}
	}
	else
	{
		for( i=0; i<List3array.GetSize (); i++)
		{
			if(m_filter==List3array.ElementAt (i).ElementAt (1))
				payoutdata[atoi(List3array.ElementAt (i).ElementAt (3).Mid (5, 2))-1]+=atof(List3array.ElementAt (i).ElementAt (2));
		}
	}
	
	int nRowCount=12;//	VARIANT var;
	m_Chart.SetRowCount(nRowCount);
	m_Chart2.SetRowCount(nRowCount);
	m_Chart3.SetRowCount(nRowCount);
    float ftemp;
	if(m_radio2==0)//叠加
	{
		for(int row = 1; row <= nRowCount; ++row)	// row月份
		{
			m_Chart.SetRow(row);
			m_Chart.SetRowLabel(stryear[row-1]);
			if(m_check1)	// m_check1:总收入;
				//m_Chart.GetDataGrid().SetData(row, 1, incomedata1[row-1]+incomedata2[row-1]+incomedata3[row-1]+incomedata4[row-1]+incomedata5[row-1]+incomedata6[row-1], 0);//Jeff，没有卡值;
				m_Chart.GetDataGrid().SetData(row, 1, 
				incomeMember[row-1]+
				incomedata1[row-1]+
				incomedata2[row-1]+
				incomedata3[row-1]+
				incomedata4[row-1]+
				incomedata5[row-1]+
				incomedata6[row-1]+
				fOtherIncome[row-1]-
				fConsumeCards[row-1], 
				0);//Jeff，有卡值;
			else
			{
				ftemp=0;
				if(m_check2)
					ftemp+=incomedata1[row-1];
				if(m_check3)
					ftemp+=incomedata2[row-1];
				if(m_check4)
					ftemp+=incomedata3[row-1];
				if(m_check5)
					ftemp+=incomedata4[row-1];
				if(m_check6)
					ftemp+=incomedata5[row-1];
				if(m_check7)
					ftemp+=incomedata6[row-1];
				m_Chart.GetDataGrid().SetData(row, 1, ftemp, 0);
			}
		}
	}
	else
	{
		for(int row = 1; row <= nRowCount; ++row)
		{
			m_Chart.SetRow(row);
			m_Chart.SetRowLabel(stryear[row-1]);
			m_Chart.GetDataGrid().SetData(row, 1, incomedata1[row-1], 0);
			m_Chart.GetDataGrid().SetData(row, 2, incomedata2[row-1], 0);
			m_Chart.GetDataGrid().SetData(row, 3, incomedata3[row-1], 0);
			m_Chart.GetDataGrid().SetData(row, 4, incomedata4[row-1], 0);
			m_Chart.GetDataGrid().SetData(row, 5, incomedata5[row-1], 0);
			m_Chart.GetDataGrid().SetData(row, 6, incomedata6[row-1], 0);
		}
	}
	for(int row = 1; row <= nRowCount; ++row)
	{
		m_Chart2.SetRow(row);
		m_Chart2.SetRowLabel(stryear[row-1]);
		m_Chart2.GetDataGrid().SetData(row, 1, payoutdata[row-1], 0);
		
		/*	m_Chart3.SetRow(row);
		m_Chart3.SetRowLabel(stryear[row-1]);
		m_Chart3.GetDataGrid().SetData(row, 1, dindandata1[row-1]+dindandata2[row-1]+dindandata3[row-1]+dindandata4[row-1]+dindandata5[row-1], 0);
		m_Chart3.GetDataGrid().SetData(row, 2, dindandata1[row-1], 0);
		m_Chart3.GetDataGrid().SetData(row, 3, dindandata2[row-1], 0);
		m_Chart3.GetDataGrid().SetData(row, 4, dindandata3[row-1], 0);
		m_Chart3.GetDataGrid().SetData(row, 5, dindandata4[row-1], 0);
		m_Chart3.GetDataGrid().SetData(row, 6, dindandata5[row-1], 0);*/
	}
	
	m_Chart.Refresh();
	m_Chart2.Refresh();
	//	m_Chart3.Refresh();
}

void YearForm2::OnRadio3() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	if(m_radio1==0)
	{
		m_Chart.SetChartType(3);
		m_Chart2.SetChartType(3);
		m_Chart3.SetChartType(3);
	}
	else if(m_radio1==1)
	{
		m_Chart.SetChartType(1);
		m_Chart2.SetChartType(1);
		m_Chart3.SetChartType(1);
	}
	else if(m_radio1==2)
	{
		m_Chart.SetChartType(14);
		m_Chart2.SetChartType(14);
		m_Chart3.SetChartType(14);
	}
}

void YearForm2::OnRadio4() 
{
	// TODO: Add your control notification handler code here
	OnRadio3();
}

void YearForm2::OnRadio5() 
{
	// TODO: Add your control notification handler code here
	OnRadio3();	
}

void YearForm2::OnCheck1() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	m_check2=m_check3=m_check4=m_check5=m_check6=m_check7=m_check1;
	UpdateData(false);
	KindChange();
}

void YearForm2::OnCheck2() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	if(m_check2==0)
	{
		m_check1=m_check2;
		UpdateData(false);
	}
	KindChange();	
}

void YearForm2::OnCheck3() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	if(m_check3==0)
	{
		m_check1=m_check3;
		UpdateData(false);
	}
	KindChange();	
}

void YearForm2::OnCheck4() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	if(m_check4==0)
	{
		m_check1=m_check4;
		UpdateData(false);
	}
	KindChange();	
}

void YearForm2::OnCheck5() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	if(m_check5==0)
	{
		m_check1=m_check5;
		UpdateData(false);
	}
	KindChange();	
}

void YearForm2::OnCheck6() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	if(m_check6==0)
	{
		m_check1=m_check6;
		UpdateData(false);
	}
	KindChange();		
}

void YearForm2::OnCheck7() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	if(m_check7==0)
	{
		m_check1=m_check7;
		UpdateData(false);
	}
	KindChange();	
}

void YearForm2::OnRadio6() //叠加
{
	// TODO: Add your control notification handler code here
	UpdateData();
	if(m_radio2==0)
	{	
		m_Chart.SetColumnCount(1); 
		m_Chart.SetColumn(1);
		m_Chart.SetColumnLabel((LPCTSTR)"总收入");
		
		m_Chart.GetPlot().GetSeriesCollection().GetItem(1).GetDataPoints ().GetItem(-1).GetBrush ().GetFillColor ().Set(255, 0, 0);
		// 线宽(对点线图有效)
		m_Chart.GetPlot().GetSeriesCollection().GetItem(1).GetPen().SetWidth(30);
		// 数据点类型显示数据值的模式(对柱柱状图和点线图有效)
		// 0: 不显示	1: 显示在柱状图外
		// 2: 显示在柱状图内上方	3: 显示在柱状图内中间	4: 显示在柱状图内下方
		m_Chart.GetPlot().GetSeriesCollection().GetItem(1).GetDataPoints().GetItem(-1).GetDataPointLabel().SetLocationType(1);
	}
	else
	{
		m_Chart.SetColumnCount(6); 
		m_Chart.SetColumn(1);
		m_Chart.SetColumnLabel((LPCTSTR)"前期");
		m_Chart.SetColumn(2);
		m_Chart.SetColumnLabel((LPCTSTR)"摄影二销");
		m_Chart.SetColumn(3);

#ifndef CHILD_VERSION
		m_Chart.SetColumnLabel((LPCTSTR)"化妆二销");
#else
		m_Chart.SetColumnLabel((LPCTSTR)"引导二销");//"引导二销"
#endif

		m_Chart.SetColumn(4);
		m_Chart.SetColumnLabel((LPCTSTR)"套系升级");
		m_Chart.SetColumn(5);
		m_Chart.SetColumnLabel((LPCTSTR)"选片二销");
		m_Chart.SetColumn(6);
		m_Chart.SetColumnLabel((LPCTSTR)"其他收入");
		
		m_Chart.GetPlot().GetSeriesCollection().GetItem(1).GetDataPoints ().GetItem(-1).GetBrush ().GetFillColor ().Set(255, 0, 0);
		m_Chart.GetPlot().GetSeriesCollection().GetItem(2).GetDataPoints ().GetItem(-1).GetBrush ().GetFillColor ().Set(0, 255, 0);
		m_Chart.GetPlot().GetSeriesCollection().GetItem(3).GetDataPoints ().GetItem(-1).GetBrush ().GetFillColor ().Set(0, 0, 255);
		m_Chart.GetPlot().GetSeriesCollection().GetItem(4).GetDataPoints ().GetItem(-1).GetBrush ().GetFillColor ().Set(0, 255, 255);
		m_Chart.GetPlot().GetSeriesCollection().GetItem(5).GetDataPoints ().GetItem(-1).GetBrush ().GetFillColor ().Set(255, 255, 0);
		m_Chart.GetPlot().GetSeriesCollection().GetItem(6).GetDataPoints ().GetItem(-1).GetBrush ().GetFillColor ().Set(255, 0, 255);
		
		// 线宽(对点线图有效)
		m_Chart.GetPlot().GetSeriesCollection().GetItem(1).GetPen().SetWidth(30);
		m_Chart.GetPlot().GetSeriesCollection().GetItem(2).GetPen().SetWidth(30);
		m_Chart.GetPlot().GetSeriesCollection().GetItem(3).GetPen().SetWidth(30);
		m_Chart.GetPlot().GetSeriesCollection().GetItem(4).GetPen().SetWidth(30);
		m_Chart.GetPlot().GetSeriesCollection().GetItem(5).GetPen().SetWidth(30);
		m_Chart.GetPlot().GetSeriesCollection().GetItem(6).GetPen().SetWidth(30);
		// 数据点类型显示数据值的模式(对柱柱状图和点线图有效)
		// 0: 不显示	1: 显示在柱状图外
		// 2: 显示在柱状图内上方	3: 显示在柱状图内中间	4: 显示在柱状图内下方
		m_Chart.GetPlot().GetSeriesCollection().GetItem(1).GetDataPoints().GetItem(-1).GetDataPointLabel().SetLocationType(1);
		m_Chart.GetPlot().GetSeriesCollection().GetItem(2).GetDataPoints().GetItem(-1).GetDataPointLabel().SetLocationType(1);
		m_Chart.GetPlot().GetSeriesCollection().GetItem(3).GetDataPoints().GetItem(-1).GetDataPointLabel().SetLocationType(1);
		m_Chart.GetPlot().GetSeriesCollection().GetItem(4).GetDataPoints().GetItem(-1).GetDataPointLabel().SetLocationType(1);
		m_Chart.GetPlot().GetSeriesCollection().GetItem(5).GetDataPoints().GetItem(-1).GetDataPointLabel().SetLocationType(1);
		m_Chart.GetPlot().GetSeriesCollection().GetItem(6).GetDataPoints().GetItem(-1).GetDataPointLabel().SetLocationType(1);
	}
	
	GetDlgItem(IDC_CHECK1)->EnableWindow(m_radio2==0);
	GetDlgItem(IDC_CHECK2)->EnableWindow(m_radio2==0);
	GetDlgItem(IDC_CHECK3)->EnableWindow(m_radio2==0);
	GetDlgItem(IDC_CHECK4)->EnableWindow(m_radio2==0);
	GetDlgItem(IDC_CHECK5)->EnableWindow(m_radio2==0);
	GetDlgItem(IDC_CHECK6)->EnableWindow(m_radio2==0);
	GetDlgItem(IDC_CHECK7)->EnableWindow(m_radio2==0);
	KindChange();	
}

void YearForm2::OnRadio7() //对比
{
	// TODO: Add your control notification handler code here
	OnRadio6();
}

BEGIN_EVENTSINK_MAP(YearForm2, MyFormView)
//{{AFX_EVENTSINK_MAP(YearForm2)
ON_EVENT(YearForm2, IDC_MSCHART1, -601 /* DblClick */, OnDblClickMschart1, VTS_NONE)
ON_EVENT(YearForm2, IDC_MSCHART2, -601 /* DblClick */, OnDblClickMschart2, VTS_NONE)
ON_EVENT(YearForm2, IDC_MSCHART3, -601 /* DblClick */, OnDblClickMschart3, VTS_NONE)
//}}AFX_EVENTSINK_MAP
END_EVENTSINK_MAP()
BOOL g_bShowMsChart=0;
HWND g_hShowChartWnd=NULL;
void YearForm2::OnDblClickMschart1() 
{
	// TODO: Add your control notification handler code here
	if(g_bShowMsChart)
	{
		::SendMessage (g_hShowChartWnd, WM_CLOSE, 0, 0);
		return;
	}
	g_bShowMsChart=1;
	CRect rc;
	m_Chart.GetWindowRect (rc);
	ScreenToClient(rc);
	ShowMschart dlg;
	dlg.m_pParent =this;
	dlg.m_pChart=&m_Chart;
	dlg.DoModal ();
	m_Chart.MoveWindow (rc);
	g_bShowMsChart=0;
}

void YearForm2::OnDblClickMschart2() 
{
	// TODO: Add your control notification handler code here
	if(g_bShowMsChart)
	{
		::SendMessage (g_hShowChartWnd, WM_CLOSE, 0, 0);
		return;
	}
	g_bShowMsChart=1;
	CRect rc;
	m_Chart2.GetWindowRect (rc);
	ScreenToClient(rc);
	ShowMschart dlg;
	dlg.m_pParent =this;
	dlg.m_pChart=&m_Chart2;
	dlg.DoModal ();
	m_Chart2.MoveWindow (rc);
	g_bShowMsChart=0;	
}

void YearForm2::OnDblClickMschart3() 
{
	// TODO: Add your control notification handler code here
	if(g_bShowMsChart)
	{
		::SendMessage (g_hShowChartWnd, WM_CLOSE, 0, 0);
		return;
	}
	g_bShowMsChart=1;
	CRect rc;
	m_Chart3.GetWindowRect (rc);
	ScreenToClient(rc);
	ShowMschart dlg;
	dlg.m_pParent =this;
	dlg.m_pChart=&m_Chart3;
	dlg.DoModal ();
	m_Chart3.MoveWindow (rc);
	g_bShowMsChart=0;	
}

void YearForm2::TypeChange(CString str)
{
	m_filter=str;
	KindChange();
}

void YearForm2::OnBUTprint() 
{
	// TODO: Add your control notification handler code here
	if(payoutdlg.GetSafeHwnd ()==NULL)
	{
		payoutdlg.Create (IDD_DLGPayOutSet, this);
		CRect rc,rc2;
		m_Chart.GetWindowRect (rc);
		m_Chart2.GetWindowRect (rc2);
		rc.bottom =rc2.bottom ;
		
		payoutdlg.MoveWindow2 (rc);
		payoutdlg.m_pParent=this;
		payoutdlg.m_mode=3;
		payoutdlg.ShowWindow (SW_SHOW);
	}
	else if(payoutdlg.IsWindowVisible ())
	{
		payoutdlg.ShowWindow (SW_HIDE);
		if(!m_filter.IsEmpty ())
		{
			m_filter.Empty ();
			KindChange();
		}
	}	
	else
		payoutdlg.ShowWindow (SW_SHOW);
}