lyfz_repos/经典版源码/lyfzClient/branches/708/MySalary.cpp

// MySalary.cpp : implementation file
//
#include "stdafx.h"
#include "ylgl.h"
#include "MySalary.h"
#include "MyMdi.H"
#include "SetSalary.h"
#include "ShowHisSalary.h"
#include "SalarySet4.h"
#include "SelExpendType.h"
#include "SelExportType.h"
#include <odbcinst.h>
#include <io.h>
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////

IMPLEMENT_DYNCREATE(MySalary, MyFormView)
MySalary::MySalary() : MyFormView(MySalary::IDD)
{
	m_name = _T("");
	m_rate1 = _T("");
	m_rate2 = _T("");
	m_bz = _T("");
	m_base = _T("");
	m_salary = _T("");
	m_rate3 = _T("");
	m_rate4 = _T("");
	m_rate5 = _T("");
	m_money1 = _T("");
	m_money2 = _T("");
	m_money3 = _T("");
	m_money4 = _T("");
	m_money5 = _T("");
	m_money6 = _T("");
	m_bInit = 0;
	m_bAll = 0;
	m_year = atoi(g_date.Mid(0, 4));
	m_month = atoi(g_date.Mid(5, 2));
	m_date2 = GetTmFromStr(g_date);
	m_date1 = m_date2 - CTimeSpan(30, 0, 0, 0);
}

MySalary::~MySalary()
{
}

void MySalary::DoDataExchange(CDataExchange* pDX)
{
	MyFormView::DoDataExchange(pDX);

	DDX_Control(pDX, IDC_LIST11, m_ListTemp);
	DDX_Control(pDX, IDC_COMBO7, m_comboname);
	DDX_Control(pDX, IDC_COMBO6, m_combocaltype);
	DDX_Control(pDX, IDC_LIST8, m_Listdigital);
	DDX_Control(pDX, IDC_LIST7, m_Listtake);
	DDX_Control(pDX, IDC_LIST4, m_List4);
	DDX_Control(pDX, IDC_LIST3, m_List3);
	DDX_Control(pDX, IDC_LIST1, m_ListBox1);
	DDX_Control(pDX, IDC_SPIN2, m_spinmonth);
	DDX_Control(pDX, IDC_SPIN1, m_spinyear);
	DDX_Control(pDX, IDC_LIST2, m_List1);
	DDX_Control(pDX, IDC_STATIC1, m_static1);
	DDX_Text(pDX, IDC_EDITname, m_name);
	DDX_Text(pDX, IDC_EDITrate1, m_rate1);
	DDX_Text(pDX, IDC_EDITrate2, m_rate2);
	DDX_Text(pDX, IDC_EDITbz, m_bz);
	DDX_Text(pDX, IDC_EDITbase, m_base);
	DDX_Text(pDX, IDC_EDITmonth, m_month);
	DDV_MinMaxUInt(pDX, m_month, 1, 12);
	DDX_Text(pDX, IDC_EDITsalary, m_salary);
	DDX_Text(pDX, IDC_EDITyear, m_year);
	DDV_MinMaxUInt(pDX, m_year, 1900, 3000);
	DDX_Text(pDX, IDC_EDITrate3, m_rate3);
	DDX_Text(pDX, IDC_EDITrate4, m_rate4);
	DDX_Text(pDX, IDC_EDITrate6, m_rate5);
	DDX_Text(pDX, IDC_EDITmoney1, m_money1);
	DDX_Text(pDX, IDC_EDITmoney2, m_money2);
	DDX_Text(pDX, IDC_EDITmoney3, m_money3);
	DDX_Text(pDX, IDC_EDITmoney4, m_money4);
	DDX_Text(pDX, IDC_EDITmoney5, m_money5);
	DDX_Text(pDX, IDC_EDITmoney6, m_money6);
	DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKER1, m_date1);
	DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKER2, m_date2);
}

BEGIN_MESSAGE_MAP(MySalary, MyFormView)
	ON_BN_CLICKED(IDC_BUTclose, OnBUTclose)
	ON_LBN_SELCHANGE(IDC_LIST1, OnSelchangeList1)
	ON_EN_CHANGE(IDC_EDITyear, OnChangeEDITyear)
	ON_EN_CHANGE(IDC_EDITmonth, OnChangeEDITmonth)
	ON_BN_CLICKED(IDC_BUTshowall, OnBUTshowall)
	ON_BN_CLICKED(IDC_BUT1, OnBut1)
	ON_BN_CLICKED(IDC_BUT2, OnBut2)
	ON_BN_CLICKED(IDC_BUT3, OnBut3)
	ON_CBN_SELCHANGE(IDC_COMBO6, OnSelchangeCombo6)
	ON_BN_CLICKED(IDC_BUT4, OnBut4)
	ON_BN_CLICKED(IDC_BUTTON4, OnButton4)
	ON_BN_CLICKED(IDC_BUTTON5, OnButton5)
	ON_BN_CLICKED(IDC_BUTTON6, OnButton6)
	ON_CBN_CLOSEUP(IDC_COMBO7, OnCloseupCombo7)
	ON_BN_CLICKED(IDC_BUTTON14, OnButton14)
	ON_BN_CLICKED(IDC_BUTTON7, OnButton7)
	ON_BN_CLICKED(IDC_BUTTON8, OnButton8)
	ON_NOTIFY(DTN_DATETIMECHANGE, IDC_DATETIMEPICKER1, OnDatetimechangeDatetimepicker1)
	ON_NOTIFY(DTN_DATETIMECHANGE, IDC_DATETIMEPICKER2, OnDatetimechangeDatetimepicker2)
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// MySalary diagnostics

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

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

/////////////////////////////////////////////////////////////////////////////
void MySalary::OnInitialUpdate()
{
	MyFormView::OnInitialUpdate();
	if (IsHasRights2new(25) == 0)
	{
		GetDlgItem(IDC_BUT1)->EnableWindow(0);
	}

	CMyMdi Mdi;
	Mdi.SetSubView((CWnd*)GetParent(), (CWnd*)this);
	m_combocaltype.AddString("计算初修提成");
	m_combocaltype.AddString("计算精修提成");
	m_combocaltype.AddString("计算设计提成");

	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_comboname.RefDroppedWidth();
	m_combocaltype.GetWindowRect(rc2);
	ScreenToClient(rc2);
	rc2.bottom += 200;
	m_combocaltype.MoveWindow(rc2);
	m_static1.SetFont(&g_titlefont);

#ifdef CHILD_VERSION
	m_List1.SetHeadings("金额,100;日期,100;款项类别,100;家长姓名,100;宝宝姓名,100;套系类别,100;付款方式,100");
	m_ListTemp.SetHeadings("金额,100;日期,100;款项类别,100;家长姓名,100;宝宝姓名,100;套系类别,100;付款方式,100");
	m_List1.LoadColumnInfo(23);
	m_List3.SetHeadings("姓名,100;总工资,100;基本工资,100;前期业绩,100;后期业绩,100;职务提成,100;部门,100;备注,100");
	m_List3.LoadColumnInfo(124);
	m_List4.SetHeadings("订单号,100;家长姓名,100;宝宝姓名,100;提成金额,100;部门,100;内容,100;数量,100;单价,100;提成方式,100;套系价格,100;日期,100");
	m_List4.LoadColumnInfo(139);
	m_Listtake.SetHeadings("订单号,100;家长姓名,100;宝宝姓名,100;套系,100;价格,100;景点,100;日期,100;摄影,100;助理,100;化妆师,100;助理,100;套系类别,100");

#ifdef LKAY_VERSION
	m_Listdigital.SetHeadings("订单号,100;男宾姓名,100;女宾姓名,100;套系,100;价格,100;初修,100;日期1,100;精修,100;日期2,100;设计,100;日期3,100;初修,50;精修,50;设计,50;选片二销,50;套系类别,100;P数,50;张数,50" );
#else
	//m_Listdigital.SetHeadings("订单号,100;男宾姓名,100;女宾姓名,100;套系,100;价格,100;初修,100;日期1,100;精修,100;日期2,100;设计,100;日期3,100;初修,50;精修,50;设计,50;选片二销,50;套系类别,100");
	m_Listdigital.SetHeadings("订单号,100;家长姓名,100;宝宝姓名,100;套系,100;价格,100;初修,100;日期1,100;精修,100;日期2,100;设计,100;日期3,100;初修,50;精修,50;设计,50;选片二销,50;套系类别,100");
#endif

	m_Listtake.LoadColumnInfo(210);
	m_Listdigital.LoadColumnInfo(211);
#else
	m_List1.SetHeadings("金额,100;日期,100;款项类别,100;男宾姓名,100;女宾姓名,100;套系类别,100;付款方式,100");
	m_ListTemp.SetHeadings("金额,100;日期,100;款项类别,100;男宾姓名,100;女宾姓名,100;套系类别,100;付款方式,100");
	m_List1.LoadColumnInfo(23);
	m_List3.SetHeadings("姓名,100;总工资,100;基本工资,100;前期业绩,100;后期业绩,100;职务提成,100;部门,100;备注,100");
	m_List3.LoadColumnInfo(124);
	m_List4.SetHeadings("订单号,100;男宾姓名,100;女宾姓名,100;提成金额,100;部门,100;内容,100;数量,100;单价,100;提成方式,100;套系价格,100;日期,100");
	m_List4.LoadColumnInfo(139);
	m_Listtake.SetHeadings("订单号,100;男宾姓名,100;女宾姓名,100;套系,100;价格,100;景点,100;日期,100;摄影,100;助理,100;化妆师,100;助理,100;套系类别,100");
	m_Listdigital.SetHeadings("订单号,100;男宾姓名,100;女宾姓名,100;套系,100;价格,100;初修,100;日期1,100;精修,100;日期2,100;设计,100;日期3,100;初修,50;精修,50;设计,50;选片二销,50;套系类别,100");
	m_Listtake.LoadColumnInfo(210);
	m_Listdigital.LoadColumnInfo(211);
#endif
	m_spinyear.SetRange(1900, 3000);
	m_spinmonth.SetRange(1, 12);

	BOOL bShowAll = 0;
	if (g_ncount == 100)bShowAll = 1;
	g_ncount = 0;
	GetData();
	if (bShowAll == 0)
		GetDlgItem(IDC_LIST3)->ShowWindow(0);
	if (IsHasRights2new(25) == 0)
	{
		m_ListBox1.EnableWindow(0);
		m_comboname.EnableWindow(0);
		GetDlgItem(IDC_BUTshowall)->EnableWindow(0);
	}
	else if (bShowAll)
	{
		g_ncount = 0;
		OnBUTshowall();
	}
}

void MySalary::FillGrid(CArray<CStringArray, CStringArray>*array)
{
	m_List1.DeleteAllItems2();
	int ii = 0;
	m_List1.m_arLabels.SetSize(array->GetSize(), 1);
	int count = 0;
	for (ii = 0; ii < m_List1.m_arLabels.GetSize(); ii++)
	{
		m_List1.m_arLabels.ElementAt(count++).Copy(array->ElementAt(ii));
	}
	m_List1.m_arLabels.SetSize(count, 1);
	ii = count;
	m_List1.m_LabelCount = ii;
	m_List1.SetItemCountEx(ii);
}

void MySalary::FillGridTake(CArray<CStringArray, CStringArray>*array)
{
	m_Listtake.DeleteAllItems2();
	int ii = 0;
	m_Listtake.m_arLabels.SetSize(array->GetSize(), 1);
	int count = 0;
	for (ii = 0; ii < m_Listtake.m_arLabels.GetSize(); ii++)
	{
		m_Listtake.m_arLabels.ElementAt(count++).Copy(array->ElementAt(ii));
	}
	m_Listtake.m_arLabels.SetSize(count, 1);
	ii = count;
	m_Listtake.m_LabelCount = ii;
	m_Listtake.SetItemCountEx(ii);
}

void MySalary::FillGridDigital(CArray<CStringArray, CStringArray>*array)
{
	m_Listdigital.DeleteAllItems2();
	int ii = 0;
	m_Listdigital.m_arLabels.SetSize(array->GetSize(), 1);
	int count = 0;
	for (ii = 0; ii < m_Listdigital.m_arLabels.GetSize(); ii++)
	{
		m_Listdigital.m_arLabels.ElementAt(count++).Copy(array->ElementAt(ii));
	}
	m_Listdigital.m_arLabels.SetSize(count, 1);
	ii = count;
	m_Listdigital.m_LabelCount = ii;
	m_Listdigital.SetItemCountEx(ii);
}

void MySalary::OnBUTclose()
{
	GetParent()->SendMessage(WM_CLOSE);
}

void MySalary::GetData()
{
	m_bInit = 1;
	g_sendhead.bsql = 0;
	g_sendhead.code[0] = 34;	// renyuan表;
	g_sendhead.code[1] = 146;	// workrate表;
	g_sendhead.tabcount = 2;
	CString filter = _T("dimission='在职';");
	g_pMainWnd->ProcessChatMessageRequest2(filter);
	if (g_bSendOK == 0)return;
	DataToArray(&m_List1array, &m_Workratearray);

	int i = 0;
	m_ListBox1.ResetContent();
	for ( i = 0; i < m_List1array.GetSize(); i++)
	{
		m_ListBox1.AddString(m_List1array.ElementAt(i).ElementAt(0));
	}

	CString str;
	for (i = 0; i < m_ListBox1.GetCount(); i++)
	{
		m_ListBox1.GetText(i, str);
		if (str == g_user.name)
		{
			m_ListBox1.SetCurSel(i);
			m_comboname.AddString(g_user.name);
			m_comboname.SetCurSel(m_comboname.FindString(0, g_user.name));
			OnSelchangeList1();
			break;
		}
	}
}

void MySalary::OnChangeEDITyear()
{
}

void MySalary::OnChangeEDITmonth()
{
}

extern float GetSalaryFromRule(float fmoney, CString rule);
CString GetRule(CString name)
{
	CString oldrule = g_cominfoarray.ElementAt(0).ElementAt(77);
	CString header = "$" + name + ":";

	CString left, right;
	int pos = oldrule.Find(header);
	if (pos != -1)
	{
		right = oldrule.Right(oldrule.GetLength() - pos - header.GetLength());
		pos = right.Find("$");
		if (pos != -1)
			right = right.Left(pos);
		right = header + right;
		return right;
	}
	return "";
}

void MySalary::OnSelchangeList1()
{
	if (m_bInit == 0)return;
	UpdateData();
	GetDlgItem(IDC_DATETIMEPICKER1)->EnableWindow(0);
	GetDlgItem(IDC_DATETIMEPICKER2)->EnableWindow(0);
	if (m_bAll)
	{
		m_List3array.RemoveAll();
		FillGrid2();
		GetDlgItem(IDC_DATETIMEPICKER1)->EnableWindow(1);
		GetDlgItem(IDC_DATETIMEPICKER2)->EnableWindow(1);
		return;
	}
	CString name;
	/*	int pos=m_ListBox1.GetCurSel ();
	if(pos==-1)
	{
	m_spinyear.EnableWindow(1);
	m_spinmonth.EnableWindow(1);
	return;
	}
	m_ListBox1.GetText (pos, name);*/
	int pos = m_comboname.GetCurSel();
	if (pos == -1)
	{
		GetDlgItem(IDC_DATETIMEPICKER1)->EnableWindow(1);
		GetDlgItem(IDC_DATETIMEPICKER2)->EnableWindow(1);
		return;
	}
	m_comboname.GetWindowText(name);

	CString date1(_T("")), date2(_T(""));
	date1 = m_date1.Format("%Y-%m-%d");
	date2 = m_date2.Format("%Y-%m-%d");
	m_year = m_date1.GetYear();

	int i;
	int g_nYearposTemp = g_nYearpos;
	BOOL bLastYear = 0;
	BOOL bThisYear = 0;
#if JEFF_TEST_ON	// 2015开始禁用跨年数据;
	if (m_year >= 2014 && m_year <= atoi(g_date.Left(4)) && g_hisyeararray.GetSize())
	{
		g_nYearpos = -1;
		bThisYear = 1;
	}
	else if (m_year <= 2013 && g_hisyeararray.GetSize())
	{
		g_nYearpos = GetYearPos(m_year);
		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);
#endif
	///////////////
	CString filter = "name='" + name + "' and dimission='在职';date>='" + date1 + "' and date<='" + date2 + "';;date>='" + date1 + "' and date<='" + date2 + "' and renyuan3='" + name + "';time2>='" + date1 + "' and time2<='" + date2 + "' and status='OK'***date<'" + date1 + "';datetime>='" + date1 + "' and datetime<='" + date2 + "' and name='" + name + "'";
	CString temp;
	temp = ";[date]>='" + date1 + "' and [date]<='" + date2 + "' and [status]='OK' and ([waiter1]='" + name + "' or [waiter12]='" + name + "' or [waiter2]='" + name + "' or [waiter22]='" + name + "')";
	filter += temp;
	temp = ";([time8]>='" + date1 + "' and [time8]<='" + date2 + "' and [status4]='OK' and [waiter5]='" + name + "') or ([time9]>='" + date1 + "' and [time9]<='" + date2 + "' and [status6]='OK' and [waiter7]='" + name + "') or ([time10]>='" + date1 + "' and [time10]<='" + date2 + "' and [status5]='OK' and [waiter4]='" + name + "')";
	filter += temp;

	// filter后***的SQL属于case 61里的。
	g_sendhead.code[0] = 34;	// reyuan
	g_sendhead.code[1] = 59;	// dindanbukuanview
	g_sendhead.code[2] = 60;	// dindan
	g_sendhead.code[3] = 198;	//singleincomemoneyview	其它2销录入表
	g_sendhead.code[4] = 61;	//TX信息arr
	g_sendhead.code[5] = 142;	//dindan_waiterarr
	g_sendhead.code[6] = 192;	//dindan_dindanjdarr
	g_sendhead.code[7] = 193;
	g_sendhead.tabcount = 8;
	g_sendhead.bsql = 0;
	g_pMainWnd->ProcessChatMessageRequest2(filter);
	if (g_bSendOK == 0)
	{
		g_nYearpos = g_nYearposTemp;
		GetDlgItem(IDC_DATETIMEPICKER1)->EnableWindow(1);
		GetDlgItem(IDC_DATETIMEPICKER2)->EnableWindow(1);
		return;
	}
	CArray<CStringArray, CStringArray>userarray;
	CArray<CStringArray, CStringArray>bukuanarray;
	CArray<CStringArray, CStringArray>waiterarray;
	CArray<CStringArray, CStringArray>singleincomearray;
	CArray<CStringArray, CStringArray>bukuanarray2;
	CArray<CStringArray, CStringArray>takearray;
	CArray<CStringArray, CStringArray>digitalarray;
	DataToArray(&userarray, &bukuanarray, &waiterarray, &singleincomearray, &bukuanarray2, &m_List4array, &takearray, &digitalarray);

	///////////////////
	if (bLastYear)//如果是去年, 则加今年的补款
	{
		g_nYearpos = -1;//今年
		filter = "name='" + name + "' and dimission='在职';date>='" + date1 + "' and date<='" + date2 + "';;date>='" + date1 + "' and date<='" + date2 + "' and renyuan3='" + name + "';time2>='" + date1 + "' and time2<='" + date2 + "' and status='OK'***date<'" + date1 + "';datetime>='" + date1 + "' and datetime<='" + date2 + "' and name='" + name + "'";
		CString temp;
		temp = ";[date]>='" + date1 + "' and [date]<='" + date2 + "' and [status]='OK' and ([waiter1]='" + name + "' or [waiter12]='" + name + "' or [waiter2]='" + name + "' or [waiter22]='" + name + "')";
		filter += temp;
		temp = ";([time8]>='" + date1 + "' and [time8]<='" + date2 + "' and [status4]='OK' and [waiter5]='" + name + "') or ([time9]>='" + date1 + "' and [time9]<='" + date2 + "' and [status6]='OK' and [waiter7]='" + name + "') or ([time10]>='" + date1 + "' and [time10]<='" + date2 + "' and [status5]='OK' and [waiter4]='" + name + "')";
		filter += temp;
		g_sendhead.code[0] = 34;		// reyuan
		g_sendhead.code[1] = 59;		// dindanbukuanview
		g_sendhead.code[2] = 60;		// dindan
		g_sendhead.code[3] = 198;		// singleincomemoneyview
		g_sendhead.code[4] = 61;		// dindan + bukuan
		g_sendhead.code[5] = 142;		// mywork
		g_sendhead.code[6] = 192;		// dindanjd
		g_sendhead.code[7] = 193;		// digitalview
		g_sendhead.tabcount = 8;
		g_sendhead.bsql = 0;
		g_pMainWnd->ProcessChatMessageRequest2(filter);
		if (g_bSendOK == 0)
		{
			g_nYearpos = g_nYearposTemp;
			GetDlgItem(IDC_DATETIMEPICKER1)->EnableWindow(1);
			GetDlgItem(IDC_DATETIMEPICKER2)->EnableWindow(1);
			return;
		}
		CArray<CStringArray, CStringArray>ThisYearbukuanarray;
		CArray<CStringArray, CStringArray>ThisYearwaiterarray;
		CArray<CStringArray, CStringArray>ThisYearsingleincomearray;
		CArray<CStringArray, CStringArray>ThisYearbukuanarray2;
		CArray<CStringArray, CStringArray>ThisYearm_List4array;
		CArray<CStringArray, CStringArray>ThisYeartakearray;
		CArray<CStringArray, CStringArray>ThisYeardigitalarray;
		DataToArray(&userarray, &ThisYearbukuanarray, &ThisYearwaiterarray, &ThisYearsingleincomearray, &ThisYearbukuanarray2, &ThisYearm_List4array, &ThisYeartakearray, &ThisYeardigitalarray);

		int oldsize = bukuanarray.GetSize();
		bukuanarray.SetSize(oldsize + ThisYearbukuanarray.GetSize());
		for (i = oldsize; i < oldsize + ThisYearbukuanarray.GetSize(); i++)
		{
			bukuanarray.ElementAt(i).Copy(ThisYearbukuanarray.ElementAt(i - oldsize));
		}

		oldsize = waiterarray.GetSize();
		waiterarray.SetSize(oldsize + ThisYearwaiterarray.GetSize());
		for (i = oldsize; i < oldsize + ThisYearwaiterarray.GetSize(); i++)
		{
			waiterarray.ElementAt(i).Copy(ThisYearwaiterarray.ElementAt(i - oldsize));
		}

		oldsize = singleincomearray.GetSize();
		singleincomearray.SetSize(oldsize + ThisYearsingleincomearray.GetSize());
		for (i = oldsize; i < oldsize + ThisYearsingleincomearray.GetSize(); i++)
		{
			singleincomearray.ElementAt(i).Copy(ThisYearsingleincomearray.ElementAt(i - oldsize));
		}

		oldsize = bukuanarray2.GetSize();
		bukuanarray2.SetSize(oldsize + ThisYearbukuanarray2.GetSize());
		for (i = oldsize; i < oldsize + ThisYearbukuanarray2.GetSize(); i++)
		{
			bukuanarray2.ElementAt(i).Copy(ThisYearbukuanarray2.ElementAt(i - oldsize));
		}

		oldsize = m_List4array.GetSize();
		m_List4array.SetSize(oldsize + ThisYearm_List4array.GetSize());
		for (i = oldsize; i < oldsize + ThisYearm_List4array.GetSize(); i++)
		{
			m_List4array.ElementAt(i).Copy(ThisYearm_List4array.ElementAt(i - oldsize));
		}
		oldsize = takearray.GetSize();
		takearray.SetSize(oldsize + ThisYeartakearray.GetSize());
		for (i = oldsize; i < oldsize + ThisYeartakearray.GetSize(); i++)
		{
			takearray.ElementAt(i).Copy(ThisYeartakearray.ElementAt(i - oldsize));
		}
		oldsize = digitalarray.GetSize();
		digitalarray.SetSize(oldsize + ThisYeardigitalarray.GetSize());
		for (i = oldsize; i < oldsize + ThisYeardigitalarray.GetSize(); i++)
		{
			digitalarray.ElementAt(i).Copy(ThisYeardigitalarray.ElementAt(i - oldsize));
		}
	}
	else if (bThisYear)//如果是今年, 则加去年的补款
	{
		g_nYearpos = 0;//去年
		filter = "date>='" + date1 + "' and date<='" + date2 + "';;date>='" + date1 + "' and date<='" + date2 + "' and renyuan3='" + name + "';time2>='" + date1 + "' and time2<='" + date2 + "' and status='OK'***date<'" + date1 + "';datetime>='" + date1 + "' and datetime<='" + date2 + "' and name='" + name + "'";
		CString temp;
		temp = ";[date]>='" + date1 + "' and [date]<='" + date2 + "' and [status]='OK' and ([waiter1]='" + name + "' or [waiter12]='" + name + "' or [waiter2]='" + name + "' or [waiter22]='" + name + "')";
		filter += temp;
		temp = ";([time8]>='" + date1 + "' and [time8]<='" + date2 + "' and [status4]='OK' and [waiter5]='" + name + "') or ([time9]>='" + date1 + "' and [time9]<='" + date2 + "' and [status6]='OK' and [waiter7]='" + name + "') or ([time10]>='" + date1 + "' and [time10]<='" + date2 + "' and [status5]='OK' and [waiter4]='" + name + "')";
		filter += temp;

		g_sendhead.code[0] = 59;		// dindanbukuanview
		g_sendhead.code[1] = 60;		// dindan
		g_sendhead.code[2] = 198;		// singleincomemoneyview
		g_sendhead.code[3] = 61;		// dindan + bukuan
		g_sendhead.code[4] = 142;		// mywork
		g_sendhead.code[5] = 192;		// dindanjd
		g_sendhead.code[6] = 193;		// digitalview
		g_sendhead.tabcount = 7;

		g_sendhead.bsql = 0;
		g_pMainWnd->ProcessChatMessageRequest2(filter);
		if (g_bSendOK == 0)
		{
			g_nYearpos = g_nYearposTemp;
			GetDlgItem(IDC_DATETIMEPICKER1)->EnableWindow(1);
			GetDlgItem(IDC_DATETIMEPICKER2)->EnableWindow(1);
			return;
		}
		CArray<CStringArray, CStringArray>ThisYearbukuanarray;
		CArray<CStringArray, CStringArray>ThisYearwaiterarray;
		CArray<CStringArray, CStringArray>ThisYearsingleincomearray;
		CArray<CStringArray, CStringArray>ThisYearbukuanarray2;
		CArray<CStringArray, CStringArray>ThisYearm_List4array;
		CArray<CStringArray, CStringArray>ThisYeartakearray;
		CArray<CStringArray, CStringArray>ThisYeardigitalarray;
		DataToArray(&ThisYearbukuanarray, &ThisYearwaiterarray, &ThisYearsingleincomearray, &ThisYearbukuanarray2, &ThisYearm_List4array, &ThisYeartakearray, &ThisYeardigitalarray);

		int oldsize = bukuanarray.GetSize();
		bukuanarray.SetSize(oldsize + ThisYearbukuanarray.GetSize());
		for (i = oldsize; i < oldsize + ThisYearbukuanarray.GetSize(); i++)
		{
			bukuanarray.ElementAt(i).Copy(ThisYearbukuanarray.ElementAt(i - oldsize));
		}

		oldsize = waiterarray.GetSize();
		waiterarray.SetSize(oldsize + ThisYearwaiterarray.GetSize());
		for (i = oldsize; i < oldsize + ThisYearwaiterarray.GetSize(); i++)
		{
			waiterarray.ElementAt(i).Copy(ThisYearwaiterarray.ElementAt(i - oldsize));
		}

		oldsize = singleincomearray.GetSize();
		singleincomearray.SetSize(oldsize + ThisYearsingleincomearray.GetSize());
		for (i = oldsize; i < oldsize + ThisYearsingleincomearray.GetSize(); i++)
		{
			singleincomearray.ElementAt(i).Copy(ThisYearsingleincomearray.ElementAt(i - oldsize));
		}

		oldsize = bukuanarray2.GetSize();
		bukuanarray2.SetSize(oldsize + ThisYearbukuanarray2.GetSize());
		for (i = oldsize; i < oldsize + ThisYearbukuanarray2.GetSize(); i++)
		{
			bukuanarray2.ElementAt(i).Copy(ThisYearbukuanarray2.ElementAt(i - oldsize));
		}
		oldsize = m_List4array.GetSize();
		m_List4array.SetSize(oldsize + ThisYearm_List4array.GetSize());
		for (i = oldsize; i < oldsize + ThisYearm_List4array.GetSize(); i++)
		{
			m_List4array.ElementAt(i).Copy(ThisYearm_List4array.ElementAt(i - oldsize));
		}
		oldsize = takearray.GetSize();
		takearray.SetSize(oldsize + ThisYeartakearray.GetSize());
		for (i = oldsize; i < oldsize + ThisYeartakearray.GetSize(); i++)
		{
			takearray.ElementAt(i).Copy(ThisYeartakearray.ElementAt(i - oldsize));
		}
		oldsize = digitalarray.GetSize();
		digitalarray.SetSize(oldsize + ThisYeardigitalarray.GetSize());
		for (i = oldsize; i < oldsize + ThisYeardigitalarray.GetSize(); i++)
		{
			digitalarray.ElementAt(i).Copy(ThisYeardigitalarray.ElementAt(i - oldsize));
		}
	}

	g_nYearpos = g_nYearposTemp;

	CArray<CStringArray, CStringArray>array;
	array.SetSize(bukuanarray.GetSize() * 4 + bukuanarray2.GetSize() * 4 + singleincomearray.GetSize());

	float money1 = 0;
	float money2 = 0;
	float money3 = 0;
	float money4 = 0;
	float money5 = 0;
	CArray<float, float>moneyarray;
	CStringArray typearray;
	int typepos;

	int ii = 0;
	int arraypos = 0;
	for ( ii = 0; ii < bukuanarray.GetSize(); ii++)
	{
		//	printf("idx=%d, id=%s, money=%s, ren=%s, bz=%s, txtype=%s\n", ii, bukuanarray.ElementAt(ii).ElementAt(5), bukuanarray.ElementAt(ii).ElementAt(0), bukuanarray.ElementAt(ii).ElementAt(6),bukuanarray.ElementAt(ii).ElementAt(7), bukuanarray.ElementAt(ii).ElementAt(8));
		array.ElementAt(arraypos).RemoveAll();
		if (bukuanarray.ElementAt(ii).ElementAt(2) == "3" || bukuanarray.ElementAt(ii).ElementAt(2) == "4")//预约收款/预约补款
		{
			BOOL bWait1 = 0;
			BOOL bWait2 = 0;
			float fscale1 = 0;
			float fscale2 = 0;
			IsWaiter2(bukuanarray.ElementAt(ii).ElementAt(5), name, &waiterarray, bWait1, bWait2, fscale1, fscale2, 1, date1, date2);
			//	printf("摄影师=%s, 化妆师=%s\n", g_cominfoarray.ElementAt(0).ElementAt(56), g_cominfoarray.ElementAt(0).ElementAt(42));
			if (bWait1 && atoi(g_cominfoarray.ElementAt(0).ElementAt(56)))//我是摄影师
			{
				temp.Format("%0.2f", atof(bukuanarray.ElementAt(ii).ElementAt(0))*fscale1);
				ConvertToPrice(temp);
				money1 += atof(temp);
				typepos = FindArray(&typearray, "摄影前期");
				if (typepos == -1)
				{
					typearray.Add("摄影前期");
					moneyarray.Add(atof(temp));
				}
				else
				{
					moneyarray.SetAt(typepos, moneyarray.ElementAt(typepos) + atof(temp));
				}
				array.ElementAt(arraypos).Add(temp);
				array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(1));
				array.ElementAt(arraypos).Add("摄影前期");
				array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(3));
				array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(4));
				array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(8));
				array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(10));
				arraypos++;
			}
			if (bWait2 && atoi(g_cominfoarray.ElementAt(0).ElementAt(57)))//我是化妆师
			{
				temp.Format("%0.2f", atof(bukuanarray.ElementAt(ii).ElementAt(0))*fscale2);
				ConvertToPrice(temp);
				money1 += atof(temp);
				typepos = FindArray(&typearray, "摄影前期");
				if (typepos == -1)
				{
					typearray.Add("摄影前期");
					moneyarray.Add(atof(temp));
				}
				else
				{
					moneyarray.SetAt(typepos, moneyarray.ElementAt(typepos) + atof(temp));
				}
				array.ElementAt(arraypos).Add(temp);
				array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(1));
				array.ElementAt(arraypos).Add("化妆前期");
				array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(3));
				array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(4));
				array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(8));
				array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(10));
				arraypos++;
			}

			IsWaiter3(bukuanarray.ElementAt(ii).ElementAt(5), name, &waiterarray, bWait1, bWait2, fscale1, fscale2);//门市1，门市2
			if (bWait1)
			{
				temp.Format("%0.2f", atof(bukuanarray.ElementAt(ii).ElementAt(0))*fscale1);
				ConvertToPrice(temp);
				money1 += atof(temp);
				typepos = FindArray(&typearray, "前期");
				if (typepos == -1)
				{
					typearray.Add("前期");
					moneyarray.Add(atof(temp));
				}
				else
				{
					moneyarray.SetAt(typepos, moneyarray.ElementAt(typepos) + atof(temp));
				}
				array.ElementAt(arraypos).Add(temp);
				array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(1));
				array.ElementAt(arraypos).Add("前期收款");
				array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(3));
				array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(4));
				array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(8));
				array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(10));
				arraypos++;
			}
			if (bWait2)
			{
				temp.Format("%0.2f", atof(bukuanarray.ElementAt(ii).ElementAt(0))*fscale2);
				ConvertToPrice(temp);
				money1 += atof(temp);
				typepos = FindArray(&typearray, "前期");
				if (typepos == -1)
				{
					typearray.Add("前期");
					moneyarray.Add(atof(temp));
				}
				else
				{
					moneyarray.SetAt(typepos, moneyarray.ElementAt(typepos) + atof(temp));
				}
				array.ElementAt(arraypos).Add(temp);
				array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(1));
				array.ElementAt(arraypos).Add("前期收款");
				array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(3));
				array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(4));
				array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(8));
				array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(10));
				arraypos++;
			}
			continue;
		}
		else if (bukuanarray.ElementAt(ii).ElementAt(7) == "选片二销")//选片补款, 需加摄影师和化妆师
		{
			BOOL bWait1 = 0;
			BOOL bWait2 = 0;
			float fscale1 = 0;
			float fscale2 = 0;
			IsWaiter2(bukuanarray.ElementAt(ii).ElementAt(5), name, &waiterarray, bWait1, bWait2, fscale1, fscale2, 0, date1, date2);
			if (bWait1 && atoi(g_cominfoarray.ElementAt(0).ElementAt(41)))//我是摄影师
			{
				temp.Format("%0.2f", atof(bukuanarray.ElementAt(ii).ElementAt(0))*fscale1);
				ConvertToPrice(temp);
				money5 += atof(temp);
				typepos = FindArray(&typearray, "摄影选片二销");
				if (typepos == -1)
				{
					typearray.Add("摄影选片二销");
					moneyarray.Add(atof(temp));
				}
				else
				{
					moneyarray.SetAt(typepos, moneyarray.ElementAt(typepos) + atof(temp));
				}
				array.ElementAt(arraypos).Add(temp);
				array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(1));
				array.ElementAt(arraypos).Add("摄影选片二销");
				array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(3));
				array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(4));
				array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(8));
				array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(10));
				arraypos++;
			}
			if (bWait2 && atoi(g_cominfoarray.ElementAt(0).ElementAt(42)))//我是化妆师
			{
				temp.Format("%0.2f", atof(bukuanarray.ElementAt(ii).ElementAt(0))*fscale2);
				ConvertToPrice(temp);
				money5 += atof(temp);
#ifdef CHILD_VERSION
				typepos = FindArray(&typearray, "引导选片二销");
#else
				typepos = FindArray(&typearray, "化妆选片二销");
#endif
				if (typepos == -1)
				{
#ifdef CHILD_VERSION
					typearray.Add("引导选片二销");
#else
					typearray.Add("化妆选片二销");
#endif
					moneyarray.Add(atof(temp));
				}
				else
				{
					moneyarray.SetAt(typepos, moneyarray.ElementAt(typepos) + atof(temp));
				}
				array.ElementAt(arraypos).Add(temp);
				array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(1));
#ifdef CHILD_VERSION
				array.ElementAt(arraypos).Add("引导选片二销");
#else
				array.ElementAt(arraypos).Add("化妆选片二销");
#endif
				array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(3));
				array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(4));
				array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(8));
				array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(10));
				arraypos++;
			}
			if (bukuanarray.ElementAt(ii).ElementAt(6) != name)
				continue;

			temp.Format("%0.2f", atof(bukuanarray.ElementAt(ii).ElementAt(0)));
			ConvertToPrice(temp);
			money5 += atof(temp);
			typepos = FindArray(&typearray, bukuanarray.ElementAt(ii).ElementAt(7));
			if (typepos == -1)
			{
				typearray.Add(bukuanarray.ElementAt(ii).ElementAt(7));
				moneyarray.Add(atof(temp));
			}
			else
			{
				moneyarray.SetAt(typepos, moneyarray.ElementAt(typepos) + atof(temp));
			}
			array.ElementAt(arraypos).Add(temp);
			array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(1));
			array.ElementAt(arraypos).Add("选片二销");
			array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(3));
			array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(4));
			array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(8));
			array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(10));
		}
		else
		{
			if (bukuanarray.ElementAt(ii).ElementAt(6) != name)
				continue;

			temp.Format("%0.2f", atof(bukuanarray.ElementAt(ii).ElementAt(0)));
			ConvertToPrice(temp);
			typepos = FindArray(&typearray, bukuanarray.ElementAt(ii).ElementAt(7));
			if (typepos == -1)
			{
				typearray.Add(bukuanarray.ElementAt(ii).ElementAt(7));
				moneyarray.Add(atof(temp));
			}
			else
			{
				moneyarray.SetAt(typepos, moneyarray.ElementAt(typepos) + atof(temp));
			}
			money2 += atof(temp);
			array.ElementAt(arraypos).Add(temp);
			array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(1));
			array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(7));
			array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(3));
			array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(4));
			array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(8));
			array.ElementAt(arraypos).Add(bukuanarray.ElementAt(ii).ElementAt(10));
		}
		arraypos++;
	}

	for (ii = 0; ii < bukuanarray2.GetSize(); ii++)
	{
		array.ElementAt(arraypos).RemoveAll();
		if (bukuanarray2.ElementAt(ii).ElementAt(2) == "3" || bukuanarray2.ElementAt(ii).ElementAt(2) == "4")
		{
			BOOL bWait1 = 0;
			BOOL bWait2 = 0;
			float fscale1 = 0;
			float fscale2 = 0;
			IsWaiter2(bukuanarray2.ElementAt(ii).ElementAt(5), name, &waiterarray, bWait1, bWait2, fscale1, fscale2, 1, date1, date2);
			if (bWait1 && atoi(g_cominfoarray.ElementAt(0).ElementAt(56)))//我是摄影师
			{
				temp.Format("%0.2f", atof(bukuanarray2.ElementAt(ii).ElementAt(0))*fscale1);
				ConvertToPrice(temp);
				money1 += atof(temp);
				typepos = FindArray(&typearray, "摄影前期");
				if (typepos == -1)
				{
					typearray.Add("摄影前期");
					moneyarray.Add(atof(temp));
				}
				else
				{
					moneyarray.SetAt(typepos, moneyarray.ElementAt(typepos) + atof(temp));
				}
				array.ElementAt(arraypos).Add(temp);
				array.ElementAt(arraypos).Add(bukuanarray2.ElementAt(ii).ElementAt(1));
				array.ElementAt(arraypos).Add("摄影前期");
				array.ElementAt(arraypos).Add(bukuanarray2.ElementAt(ii).ElementAt(3));
				array.ElementAt(arraypos).Add(bukuanarray2.ElementAt(ii).ElementAt(4));
				array.ElementAt(arraypos).Add(bukuanarray2.ElementAt(ii).ElementAt(8));
				array.ElementAt(arraypos).Add(bukuanarray2.ElementAt(ii).ElementAt(9));
				arraypos++;
			}
			if (bWait2 && atoi(g_cominfoarray.ElementAt(0).ElementAt(57)))//我是化妆师
			{
				temp.Format("%0.2f", atof(bukuanarray2.ElementAt(ii).ElementAt(0))*fscale2);
				ConvertToPrice(temp);
				money1 += atof(temp);
				typepos = FindArray(&typearray, "摄影前期");
				if (typepos == -1)
				{
					typearray.Add("摄影前期");
					moneyarray.Add(atof(temp));
				}
				else
				{
					moneyarray.SetAt(typepos, moneyarray.ElementAt(typepos) + atof(temp));
				}
				array.ElementAt(arraypos).Add(temp);
				array.ElementAt(arraypos).Add(bukuanarray2.ElementAt(ii).ElementAt(1));
				array.ElementAt(arraypos).Add("化妆前期");
				array.ElementAt(arraypos).Add(bukuanarray2.ElementAt(ii).ElementAt(3));
				array.ElementAt(arraypos).Add(bukuanarray2.ElementAt(ii).ElementAt(4));
				array.ElementAt(arraypos).Add(bukuanarray2.ElementAt(ii).ElementAt(8));
				array.ElementAt(arraypos).Add(bukuanarray2.ElementAt(ii).ElementAt(9));
				arraypos++;
			}
			continue;
		}
	}

	//单笔收入
	for (ii = 0; ii < singleincomearray.GetSize(); ii++)
	{
		array.ElementAt(arraypos).RemoveAll();
		temp.Format("%0.2f", atof(singleincomearray.ElementAt(ii).ElementAt(4)));
		ConvertToPrice(temp);
		if (singleincomearray.ElementAt(ii).ElementAt(3) == "摄影二销")
			money2 += atof(temp);
#ifndef CHILD_VERSION
		else if (singleincomearray.ElementAt(ii).ElementAt(3) == "化妆二销")
#else
		else if (singleincomearray.ElementAt(ii).ElementAt(3) == "引导二销")
#endif
			money3 += atof(temp);
		else if (singleincomearray.ElementAt(ii).ElementAt(3) == "套系升级")
			money4 += atof(temp);
		else if (singleincomearray.ElementAt(ii).ElementAt(3) == "选片二销")
			money5 += atof(temp);

		typepos = FindArray(&typearray, singleincomearray.ElementAt(ii).ElementAt(3));
		if (typepos == -1)
		{
			typearray.Add(singleincomearray.ElementAt(ii).ElementAt(3));
			moneyarray.Add(atof(temp));
		}
		else
		{
			moneyarray.SetAt(typepos, moneyarray.ElementAt(typepos) + atof(temp));
		}


		array.ElementAt(arraypos).Add(temp);
		array.ElementAt(arraypos).Add(singleincomearray.ElementAt(ii).ElementAt(5));
		array.ElementAt(arraypos).Add(singleincomearray.ElementAt(ii).ElementAt(3));
		array.ElementAt(arraypos).Add(singleincomearray.ElementAt(ii).ElementAt(1));
		array.ElementAt(arraypos).Add("");
		array.ElementAt(arraypos).Add("");

		array.ElementAt(arraypos).Add(singleincomearray.ElementAt(ii).ElementAt(7));
		arraypos++;
	}
	array.SetSize(arraypos);

	FillGrid(&array);
	FillGrid4(m_money6);
	FillGridTake(&takearray);
	FillGridDigital(&digitalarray);
	if (userarray.GetSize())
	{
		m_name = userarray.ElementAt(0).ElementAt(0);
		m_base = userarray.ElementAt(0).ElementAt(1);
		CString baseexpendtype = userarray.ElementAt(0).ElementAt(2);
		CString baseexpendtype2 = userarray.ElementAt(0).ElementAt(3);
		m_bz = userarray.ElementAt(0).ElementAt(4);
		typepos = FindArray(&typearray, "前期");
		if (typepos == -1)
		{
			m_money1 = "0";
			money1 = 0;
		}
		else
		{
			money1 = moneyarray.ElementAt(typepos);
		}

		float money12 = 0;
		typepos = FindArray(&typearray, "摄影前期");
		if (typepos == -1)
		{
			money12 = 0;
		}
		else
		{
			money12 = moneyarray.ElementAt(typepos);
		}

		m_money1.Format("%0.2f", money1 + money12);


		money2 = 0;
		float realmoney2 = 0;
		for (int i = 0; i < typearray.GetSize(); i++)
		{
			if ("前期" == typearray.ElementAt(i))continue;
			if ("摄影前期" == typearray.ElementAt(i))continue;
			realmoney2 += GetSalaryFromRule(moneyarray.ElementAt(i), GetRule(typearray.ElementAt(i)));
			money2 += moneyarray.ElementAt(i);
		}
		m_money2.Format("%0.2f", money2);

		ConvertToPrice(m_money6);
		m_salary.Format("%0.2f", atof(m_base) + atof(m_money6) + realmoney2 + GetSalaryFromRule(money1, GetRule(baseexpendtype)) + GetSalaryFromRule(money12, GetRule(baseexpendtype2)));
		ConvertToPrice(m_salary);
	}
	else
	{
		m_name = _T("");
		m_base = _T("");
		m_bz = _T("");
		m_salary = _T("");
		m_money1 = _T("");
		m_money2 = _T("");
		m_money3 = _T("");
		m_money4 = _T("");
		m_money5 = _T("");
		m_money6 = _T("");
	}

	UpdateData(false);
	GetDlgItem(IDC_DATETIMEPICKER1)->EnableWindow(1);
	GetDlgItem(IDC_DATETIMEPICKER2)->EnableWindow(1);
	//////////////////////////////

	CString totalstr, str, field1, field2, field3, field4, field5, field6, field7, field8, field9, field10, field11, field12;
	float sum = 0;
	int waiter1count = 0;
	int waiter12count = 0;
	int waiter2count = 0;
	int waiter22count = 0;
	for (i = 0; i < m_Listtake.GetItemCount(); i++)
	{
		field2 = m_Listtake.GetItemText(i, 3);
		field3 = m_Listtake.GetItemText(i, 4);
		sum += atof(field3);
		field4 = m_Listtake.GetItemText(i, 5);
		field5 = m_Listtake.GetItemText(i, 6);
		field6 = m_Listtake.GetItemText(i, 7);
		field7 = m_Listtake.GetItemText(i, 8);
		field8 = m_Listtake.GetItemText(i, 9);
		field9 = m_Listtake.GetItemText(i, 10);
		if (field6 == name)waiter1count++;
		if (field7 == name)waiter12count++;
		if (field8 == name)waiter2count++;
		if (field9 == name)waiter22count++;

	}
	str = "摄影师与助理\r\n";
	totalstr += str;
	str.Format("摄影: %d\r\n", waiter1count); totalstr += str;
	str.Format("助理: %d\r\n", waiter12count); totalstr += str;
#ifdef CHILD_VERSION
	str.Format("引导: %d\r\n", waiter2count); totalstr += str;
#else
	str.Format("化妆: %d\r\n", waiter2count); totalstr += str;
#endif
	str.Format("助理: %d\r\n", waiter22count); totalstr += str;
	str.Format("订单总金额: %0.2f\r\n\r\n", sum); totalstr += str;

	float sum1 = 0;
	float sum2 = 0;
	float sum3 = 0;
	float sum12 = 0;
	float sum22 = 0;
	float sum32 = 0;
	int sum13 = 0;
	int sum23 = 0;
	int sum33 = 0;
	int sum14 = 0;
	int sum24 = 0;
	int sum34 = 0;
	int count1 = 0;
	int count2 = 0;
	int count3 = 0;
	for (i = 0; i < m_Listdigital.GetItemCount(); i++)
	{
		field2 = m_Listdigital.GetItemText(i, 3);
		field3 = m_Listdigital.GetItemText(i, 4);
		field4 = m_Listdigital.GetItemText(i, 5);
		field5 = m_Listdigital.GetItemText(i, 6);
		field6 = m_Listdigital.GetItemText(i, 7);
		field7 = m_Listdigital.GetItemText(i, 8);
		field8 = m_Listdigital.GetItemText(i, 9);
		field9 = m_Listdigital.GetItemText(i, 10);
		field10 = m_Listdigital.GetItemText(i, 14);
		field11 = m_Listdigital.GetItemText(i, 16);
		field12 = m_Listdigital.GetItemText(i, 17);
		if (m_Listdigital.GetItemText(i, 11) == "OK" && field4 == name && field5 >= date1 && field5 <= date2)
		{
			sum1 += atof(field3);
			sum12 += atof(field10);
			sum13 += atoi(field11);
			sum14 += atoi(field12);
			count1++;
		}
		if (m_Listdigital.GetItemText(i, 12) == "OK" && field6 == name && field7 >= date1 && field7 <= date2)
		{
			sum2 += atof(field3);
			sum22 += atof(field10);
			sum23 += atoi(field11);
			sum24 += atoi(field12);
			count2++;
		}
		if (m_Listdigital.GetItemText(i, 13) == "OK" && field8 == name && field9 >= date1 && field9 <= date2)
		{
			sum3 += atof(field3);
			sum32 += atof(field10);
			sum33 += atoi(field11);
			sum34 += atoi(field12);
			count3++;
		}
	}
	str = "修片与精修与设计\r\n";
	totalstr += str;
#ifdef LKAY_VERSION
	str.Format ("初修: %d单 \r\n订单金额:%0.2f \r\n选片二销:%0.2f\r\nP数:%d\r\n张数:%d\r\n\r\n", count1, sum1, sum12, sum13, sum14);totalstr+=str;
	str.Format ("精修: %d单 \r\n订单金额:%0.2f \r\n选片二销:%0.2f\r\nP数:%d\r\n张数:%d\r\n\r\n", count2, sum2, sum22, sum23, sum24);totalstr+=str;
	str.Format ("设计: %d单 \r\n订单金额:%0.2f \r\n选片二销:%0.2f\r\nP数:%d\r\n张数:%d\r\n\r\n", count3, sum3, sum32, sum33, sum34);totalstr+=str;
#else
	str.Format("初修: %d单 \r\n订单金额:%0.2f \r\n选片二销:%0.2f\r\n\r\n", count1, sum1, sum12); totalstr += str;
	str.Format("精修: %d单 \r\n订单金额:%0.2f \r\n选片二销:%0.2f\r\n\r\n", count2, sum2, sum22); totalstr += str;
	str.Format("设计: %d单 \r\n订单金额:%0.2f \r\n选片二销:%0.2f\r\n\r\n", count3, sum3, sum32); totalstr += str;
#endif
	GetDlgItem(IDC_EDITbz2)->SetWindowText(totalstr);
}

void MySalary::OnBUTshowall() //IDC_BUTshowall查看全部;
{
	// TODO: Add your control notification handler code here
	m_bAll = !m_bAll;
	if (m_bAll)
	{
		GetDlgItem(IDC_BUTshowall)->SetWindowText("查看详情");
		GetDlgItem(IDC_BUT3)->ShowWindow(SW_SHOW);
	}
	else
	{
		GetDlgItem(IDC_BUT3)->ShowWindow(SW_HIDE);
		GetDlgItem(IDC_BUTshowall)->SetWindowText("查看全部");
	}
	GetDlgItem(IDC_BUTshowall)->Invalidate();
	GetDlgItem(IDC_STATIC2)->ShowWindow(!m_bAll);
	GetDlgItem(IDC_STATIC3)->ShowWindow(!m_bAll);
	GetDlgItem(IDC_STATIC4)->ShowWindow(!m_bAll);
	GetDlgItem(IDC_STATIC5)->ShowWindow(!m_bAll);
	GetDlgItem(IDC_STATIC6)->ShowWindow(!m_bAll);
	GetDlgItem(IDC_STATIC7)->ShowWindow(!m_bAll);
	GetDlgItem(IDC_STATIC8)->ShowWindow(!m_bAll);
	GetDlgItem(IDC_STATIC26)->ShowWindow(!m_bAll);
	GetDlgItem(IDC_STATIC27)->ShowWindow(!m_bAll);
	//	GetDlgItem(IDC_BUTTON5)->ShowWindow(!m_bAll);
	//	GetDlgItem(IDC_BUTTON6)->ShowWindow(!m_bAll);
	GetDlgItem(IDC_BUTTON7)->ShowWindow(!m_bAll);
	GetDlgItem(IDC_BUTTON8)->ShowWindow(!m_bAll);
	GetDlgItem(IDC_BUTTON14)->ShowWindow(!m_bAll);
	GetDlgItem(IDC_STATIC9)->ShowWindow(!m_bAll);
	GetDlgItem(IDC_STATIC12)->ShowWindow(!m_bAll);
	GetDlgItem(IDC_STATIC16)->ShowWindow(!m_bAll);
	GetDlgItem(IDC_STATIC10)->ShowWindow(!m_bAll);
	//	GetDlgItem(IDC_EDITname)->ShowWindow(!m_bAll);
	GetDlgItem(IDC_EDITbz)->ShowWindow(!m_bAll);
	GetDlgItem(IDC_EDITbz2)->ShowWindow(!m_bAll);
	GetDlgItem(IDC_EDITbase)->ShowWindow(!m_bAll);
	GetDlgItem(IDC_EDITmoney1)->ShowWindow(!m_bAll);
	GetDlgItem(IDC_EDITmoney2)->ShowWindow(!m_bAll);
	GetDlgItem(IDC_EDITsalary)->ShowWindow(!m_bAll);
	GetDlgItem(IDC_BUTTON4)->ShowWindow(!m_bAll);
	GetDlgItem(IDC_EDITmoney6)->ShowWindow(!m_bAll);
	GetDlgItem(IDC_STATIC15)->ShowWindow(!m_bAll);

	GetDlgItem(IDC_LIST4)->ShowWindow(!m_bAll);
	//	GetDlgItem(IDC_LIST1)->ShowWindow(!m_bAll);
	GetDlgItem(IDC_LIST2)->ShowWindow(!m_bAll);
	GetDlgItem(IDC_LIST3)->ShowWindow(m_bAll);
	GetDlgItem(IDC_LIST7)->ShowWindow(!m_bAll);
	GetDlgItem(IDC_LIST8)->ShowWindow(!m_bAll);
	GetDlgItem(IDC_COMBO7)->ShowWindow(!m_bAll);
	if (m_bAll)
		FillGrid2();
	else
	{
		POSITION pos;
		pos = m_List3.GetFirstSelectedItemPosition();
		if (pos)
		{
			int iItem = m_List3.GetNextSelectedItem(pos);
			CString name = m_List3.GetItemText(iItem, 0);
			CString temp;
			for (int i = 0; i < m_ListBox1.GetCount(); i++)
			{
				m_ListBox1.GetText(i, temp);
				if (temp == name)
				{
					m_ListBox1.SetCurSel(i);
					m_comboname.AddString(name);
					m_comboname.SetCurSel(m_comboname.FindString(0, name));
					OnSelchangeList1();
					break;
				}
			}
		}
	}
}

void MySalary::FillGrid2()
{
	if (m_List3array.GetSize() == 0)GetAllData();
	m_List3.DeleteAllItems2();
	int ii = 0;
	m_List3.m_arLabels.SetSize(m_List3array.GetSize(), 1);
	int count = 0;
	for (ii = 0; ii < m_List3.m_arLabels.GetSize(); ii++)
	{
		m_List3.m_arLabels.ElementAt(count++).Copy(m_List3array.ElementAt(ii));
	}
	m_List3.m_arLabels.SetSize(count, 1);
	ii = count;
	m_List3.m_LabelCount = ii;
	m_List3.SetItemCountEx(ii);
}

void MySalary::GetAllData()
{
	if (m_bInit == 0)return;
	UpdateData();

	CString date1, date2, temp;

	date1 = m_date1.Format("%Y-%m-%d");
	date2 = m_date2.Format("%Y-%m-%d");
	m_year = m_date1.GetYear();

	int i = 0;
	int g_nYearposTemp = g_nYearpos;
	BOOL bLastYear = 0;
	BOOL bThisYear = 0;
#if JEFF_TEST_ON	// 2015开始禁用跨年数据;
	if (m_year >= 2014 && m_year <= atoi(g_date.Left(4)) && g_hisyeararray.GetSize())
	{
		g_nYearpos = -1;
		bThisYear = 1;
	}
	else if (m_year <= 2013 && g_hisyeararray.GetSize())
	{
		g_nYearpos = GetYearPos(m_year);
		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);
#endif

	CString filter = "date>='" + date1 + "' and date<='" + date2 + "';;date>='" + date1 + "' and date<='" + date2 + "';time2>='" + date1 + "' and time2<='" + date2 + "' and status='OK'***date<'" + date1 + "';datetime>='" + date1 + "' and datetime<='" + date2 + "'";

	g_sendhead.code[0] = 59;
	g_sendhead.code[1] = 60;
	g_sendhead.code[2] = 198;
	g_sendhead.code[3] = 61;
	g_sendhead.code[4] = 142;
	g_sendhead.tabcount = 5;
	g_sendhead.bsql = 0;
	g_pMainWnd->ProcessChatMessageRequest2(filter); if (g_bSendOK == 0)return;

	CArray<CStringArray, CStringArray>bukuanarray;
	CArray<CStringArray, CStringArray>waiterarray;
	CArray<CStringArray, CStringArray>singleincomearray;
	CArray<CStringArray, CStringArray>bukuanarray2;

	DataToArray(&bukuanarray, &waiterarray, &singleincomearray, &bukuanarray2, &m_List4array);
	///////////////////
	if (bLastYear)//如果是去年, 则加今年的补款
	{
		g_nYearpos = -1;//今年

		filter = "date>='" + date1 + "' and date<='" + date2 + "';;date>='" + date1 + "' and date<='" + date2 + "';time2>='" + date1 + "' and time2<='" + date2 + "' and status='OK'***date<'" + date1 + "';datetime>='" + date1 + "' and datetime<='" + date2 + "'";
		g_sendhead.code[0] = 59;
		g_sendhead.code[1] = 60;
		g_sendhead.code[2] = 198;
		g_sendhead.code[3] = 61;
		g_sendhead.code[4] = 142;
		g_sendhead.tabcount = 5;
		g_sendhead.bsql = 0;
		g_pMainWnd->ProcessChatMessageRequest2(filter);
		if (g_bSendOK == 0)
		{
			g_nYearpos = g_nYearposTemp;
			return;
		}
		CArray<CStringArray, CStringArray>LastYearbukuanarray;
		CArray<CStringArray, CStringArray>LastYearwaiterarray;
		CArray<CStringArray, CStringArray>LastYearsingleincomearray;
		CArray<CStringArray, CStringArray>LastYearbukuanarray2;
		CArray<CStringArray, CStringArray>LastYearm_List4array;

		DataToArray(&LastYearbukuanarray, &LastYearwaiterarray, &LastYearsingleincomearray, &LastYearbukuanarray2, &LastYearm_List4array);
		int oldsize = bukuanarray.GetSize();
		bukuanarray.SetSize(oldsize + LastYearbukuanarray.GetSize());
		for (i = oldsize; i < oldsize + LastYearbukuanarray.GetSize(); i++)
		{
			bukuanarray.ElementAt(i).Copy(LastYearbukuanarray.ElementAt(i - oldsize));
		}

		oldsize = bukuanarray2.GetSize();
		bukuanarray2.SetSize(oldsize + LastYearbukuanarray2.GetSize());
		for (i = oldsize; i < oldsize + LastYearbukuanarray2.GetSize(); i++)
		{
			bukuanarray2.ElementAt(i).Copy(LastYearbukuanarray2.ElementAt(i - oldsize));
		}

		oldsize = singleincomearray.GetSize();
		singleincomearray.SetSize(oldsize + LastYearsingleincomearray.GetSize());
		for (i = oldsize; i < oldsize + LastYearsingleincomearray.GetSize(); i++)
		{
			singleincomearray.ElementAt(i).Copy(LastYearsingleincomearray.ElementAt(i - oldsize));
		}

		oldsize = waiterarray.GetSize();
		waiterarray.SetSize(oldsize + LastYearwaiterarray.GetSize());
		for (i = oldsize; i < oldsize + LastYearwaiterarray.GetSize(); i++)
		{
			waiterarray.ElementAt(i).Copy(LastYearwaiterarray.ElementAt(i - oldsize));
		}

		oldsize = m_List4array.GetSize();
		m_List4array.SetSize(oldsize + LastYearm_List4array.GetSize());
		for (i = oldsize; i < oldsize + LastYearm_List4array.GetSize(); i++)
		{
			m_List4array.ElementAt(i).Copy(LastYearm_List4array.ElementAt(i - oldsize));
		}
	}
	else if (bThisYear)//如果是今年, 则加去年的补款
	{
		g_nYearpos = 0;//去年
		filter = "date>='" + date1 + "' and date<='" + date2 + "';;date>='" + date1 + "' and date<='" + date2 + "';time2>='" + date1 + "' and time2<='" + date2 + "' and status='OK'***date<'" + date1 + "';datetime>='" + date1 + "' and datetime<='" + date2 + "'";
		g_sendhead.code[0] = 59;
		g_sendhead.code[1] = 60;
		g_sendhead.code[2] = 198;
		g_sendhead.code[3] = 61;
		g_sendhead.code[4] = 142;
		g_sendhead.tabcount = 5;
		g_sendhead.bsql = 0;
		g_pMainWnd->ProcessChatMessageRequest2(filter);
		if (g_bSendOK == 0)
		{
			g_nYearpos = g_nYearposTemp;
			return;
		}
		CArray<CStringArray, CStringArray>LastYearbukuanarray;
		CArray<CStringArray, CStringArray>LastYearwaiterarray;
		CArray<CStringArray, CStringArray>LastYearsingleincomearray;
		CArray<CStringArray, CStringArray>LastYearbukuanarray2;
		CArray<CStringArray, CStringArray>LastYearm_List4array;

		DataToArray(&LastYearbukuanarray, &LastYearwaiterarray, &LastYearsingleincomearray, &LastYearbukuanarray2, &LastYearm_List4array);
		int oldsize = bukuanarray.GetSize();
		bukuanarray.SetSize(oldsize + LastYearbukuanarray.GetSize());
		for (i = oldsize; i < oldsize + LastYearbukuanarray.GetSize(); i++)
		{
			bukuanarray.ElementAt(i).Copy(LastYearbukuanarray.ElementAt(i - oldsize));
		}

		oldsize = bukuanarray2.GetSize();
		bukuanarray2.SetSize(oldsize + LastYearbukuanarray2.GetSize());
		for (i = oldsize; i < oldsize + LastYearbukuanarray2.GetSize(); i++)
		{
			bukuanarray2.ElementAt(i).Copy(LastYearbukuanarray2.ElementAt(i - oldsize));
		}

		oldsize = singleincomearray.GetSize();
		singleincomearray.SetSize(oldsize + LastYearsingleincomearray.GetSize());
		for (i = oldsize; i < oldsize + LastYearsingleincomearray.GetSize(); i++)
		{
			singleincomearray.ElementAt(i).Copy(LastYearsingleincomearray.ElementAt(i - oldsize));
		}

		oldsize = waiterarray.GetSize();
		waiterarray.SetSize(oldsize + LastYearwaiterarray.GetSize());
		for (i = oldsize; i < oldsize + LastYearwaiterarray.GetSize(); i++)
		{
			waiterarray.ElementAt(i).Copy(LastYearwaiterarray.ElementAt(i - oldsize));
		}

		oldsize = m_List4array.GetSize();
		m_List4array.SetSize(oldsize + LastYearm_List4array.GetSize());
		for (i = oldsize; i < oldsize + LastYearm_List4array.GetSize(); i++)
		{
			m_List4array.ElementAt(i).Copy(LastYearm_List4array.ElementAt(i - oldsize));
		}
	}
	g_nYearpos = g_nYearposTemp;

	int ii = 0;
	CString m_base, m_rate1, m_rate2, m_rate3, m_rate4, m_rate5, m_money1, m_money2, m_money3, m_money4, m_money5, m_bz;
	double sum1 = 0;
	double sum2 = 0;
	double sum3 = 0;
	double sum4 = 0;
	double sum5 = 0;
	double sum6 = 0;
	double sum7 = 0;

	m_List3array.SetSize(m_List1array.GetSize() + 1);

	int n = 0;
	for ( n = 0; n < m_List1array.GetSize(); n++)
	{
		m_List3array.ElementAt(n).RemoveAll();
		m_List3array.ElementAt(n).Add("");
		m_List3array.ElementAt(n).Add("");
		m_List3array.ElementAt(n).Add("");
		m_List3array.ElementAt(n).Add("");
		m_List3array.ElementAt(n).Add("");
		m_List3array.ElementAt(n).Add("");
		m_List3array.ElementAt(n).Add("");
		m_List3array.ElementAt(n).Add("");
		m_List3array.ElementAt(n).SetAt(0, m_List1array.ElementAt(n).ElementAt(0));
		CString name = m_List1array.ElementAt(n).ElementAt(0);
		float money1 = 0;
		float money2 = 0;
		float money3 = 0;
		float money4 = 0;
		float money5 = 0;
		float money6 = 0;
		float ftemp;
		CArray<float, float>moneyarray;
		CStringArray typearray;
		int typepos;

		int arraypos = 0;
		for (ii = 0; ii < bukuanarray.GetSize(); ii++)
		{
			if (bukuanarray.ElementAt(ii).ElementAt(2) == "3" || bukuanarray.ElementAt(ii).ElementAt(2) == "4")
			{
				BOOL bWait1 = 0;
				BOOL bWait2 = 0;
				float fscale1 = 0;
				float fscale2 = 0;
				IsWaiter2(bukuanarray.ElementAt(ii).ElementAt(5), name, &waiterarray, bWait1, bWait2, fscale1, fscale2, 1, date1, date2);
				if (bWait1 && atoi(g_cominfoarray.ElementAt(0).ElementAt(56)))//我是摄影师
				{
					money1 += atof(bukuanarray.ElementAt(ii).ElementAt(0))*fscale1;
					ftemp = atof(bukuanarray.ElementAt(ii).ElementAt(0))*fscale1;
					typepos = FindArray(&typearray, "摄影前期");
					if (typepos == -1)
					{
						typearray.Add("摄影前期");
						moneyarray.Add(ftemp);
					}
					else
					{
						moneyarray.SetAt(typepos, moneyarray.ElementAt(typepos) + ftemp);
					}
				}
				if (bWait2 && atoi(g_cominfoarray.ElementAt(0).ElementAt(57)))//我是化妆师
				{
					money1 += atof(bukuanarray.ElementAt(ii).ElementAt(0))*fscale2;
					ftemp = atof(bukuanarray.ElementAt(ii).ElementAt(0))*fscale2;
					typepos = FindArray(&typearray, "摄影前期");
					if (typepos == -1)
					{
						typearray.Add("摄影前期");
						moneyarray.Add(ftemp);
					}
					else
					{
						moneyarray.SetAt(typepos, moneyarray.ElementAt(typepos) + ftemp);
					}
				}
				IsWaiter3(bukuanarray.ElementAt(ii).ElementAt(5), name, &waiterarray, bWait1, bWait2, fscale1, fscale2);
				if (bWait1)
				{
					money1 += atof(bukuanarray.ElementAt(ii).ElementAt(0))*fscale1;
					ftemp = atof(bukuanarray.ElementAt(ii).ElementAt(0))*fscale1;
					typepos = FindArray(&typearray, "前期");
					if (typepos == -1)
					{
						typearray.Add("前期");
						moneyarray.Add(ftemp);
					}
					else
					{
						moneyarray.SetAt(typepos, moneyarray.ElementAt(typepos) + ftemp);
					}
				}
				if (bWait2)
				{
					money1 += atof(bukuanarray.ElementAt(ii).ElementAt(0))*fscale2;
					ftemp = atof(bukuanarray.ElementAt(ii).ElementAt(0))*fscale2;
					typepos = FindArray(&typearray, "前期");
					if (typepos == -1)
					{
						typearray.Add("前期");
						moneyarray.Add(ftemp);
					}
					else
					{
						moneyarray.SetAt(typepos, moneyarray.ElementAt(typepos) + ftemp);
					}
				}
			}
			else if (bukuanarray.ElementAt(ii).ElementAt(7) == "选片二销")//选片补款, 需加摄影师和化妆师
			{
				BOOL bWait1 = 0;
				BOOL bWait2 = 0;
				float fscale1 = 0;
				float fscale2 = 0;

				IsWaiter2(bukuanarray.ElementAt(ii).ElementAt(5), name, &waiterarray, bWait1, bWait2, fscale1, fscale2, 0, date1, date2);
				if (bWait1 && atoi(g_cominfoarray.ElementAt(0).ElementAt(41)))//我是摄影师
				{
					money5 += atof(bukuanarray.ElementAt(ii).ElementAt(0))*fscale1;
					ftemp = atof(bukuanarray.ElementAt(ii).ElementAt(0))*fscale1;
					typepos = FindArray(&typearray, "摄影选片二销");
					if (typepos == -1)
					{
						typearray.Add("摄影选片二销");
						moneyarray.Add(ftemp);
					}
					else
					{
						moneyarray.SetAt(typepos, moneyarray.ElementAt(typepos) + ftemp);
					}
				}
				if (bWait2 && atoi(g_cominfoarray.ElementAt(0).ElementAt(42)))//我是化妆师
				{
					money5 += atof(bukuanarray.ElementAt(ii).ElementAt(0))*fscale2;
					ftemp = atof(bukuanarray.ElementAt(ii).ElementAt(0))*fscale2;
#ifdef CHILD_VERSION
					typepos = FindArray(&typearray, "引导选片二销");
#else
					typepos = FindArray(&typearray, "化妆选片二销");
#endif
					if (typepos == -1)
					{
#ifdef CHILD_VERSION
						typearray.Add("引导选片二销");
#else
						typearray.Add("化妆选片二销");
#endif
						moneyarray.Add(ftemp);
					}
					else
					{
						moneyarray.SetAt(typepos, moneyarray.ElementAt(typepos) + ftemp);
					}
				}
				if (bukuanarray.ElementAt(ii).ElementAt(6) != name)continue;
				money5 += atof(bukuanarray.ElementAt(ii).ElementAt(0));
				ftemp = atof(bukuanarray.ElementAt(ii).ElementAt(0));
				typepos = FindArray(&typearray, bukuanarray.ElementAt(ii).ElementAt(7));
				if (typepos == -1)
				{
					typearray.Add(bukuanarray.ElementAt(ii).ElementAt(7));
					moneyarray.Add(ftemp);
				}
				else
				{
					moneyarray.SetAt(typepos, moneyarray.ElementAt(typepos) + ftemp);
				}
			}
			else
			{
				if (bukuanarray.ElementAt(ii).ElementAt(6) != name)
					continue;

				if (bukuanarray.ElementAt(ii).ElementAt(2) == "5")
				{
					money2 += atof(bukuanarray.ElementAt(ii).ElementAt(0));
				}
				else if (bukuanarray.ElementAt(ii).ElementAt(2) == "1")
				{
					money3 += atof(bukuanarray.ElementAt(ii).ElementAt(0));
				}
				else if (bukuanarray.ElementAt(ii).ElementAt(2) == "6")
				{
					money4 += atof(bukuanarray.ElementAt(ii).ElementAt(0));
				}
				else if (bukuanarray.ElementAt(ii).ElementAt(2) == "2")
				{
					money5 += atof(bukuanarray.ElementAt(ii).ElementAt(0));
				}

				ftemp = atof(bukuanarray.ElementAt(ii).ElementAt(0));
				typepos = FindArray(&typearray, bukuanarray.ElementAt(ii).ElementAt(7));
				if (typepos == -1)
				{
					typearray.Add(bukuanarray.ElementAt(ii).ElementAt(7));
					moneyarray.Add(ftemp);
				}
				else
				{
					moneyarray.SetAt(typepos, moneyarray.ElementAt(typepos) + ftemp);
				}
			}
		}
		for (ii = 0; ii < bukuanarray2.GetSize(); ii++)
		{
			if (bukuanarray2.ElementAt(ii).ElementAt(2) == "3" || bukuanarray2.ElementAt(ii).ElementAt(2) == "4")
			{
				BOOL bWait1 = 0;
				BOOL bWait2 = 0;
				float fscale1 = 0;
				float fscale2 = 0;
				IsWaiter2(bukuanarray2.ElementAt(ii).ElementAt(5), name, &waiterarray, bWait1, bWait2, fscale1, fscale2, 1, date1, date2);
				if (bWait1 && atoi(g_cominfoarray.ElementAt(0).ElementAt(56)))//我是摄影师
				{
					money1 += atof(bukuanarray2.ElementAt(ii).ElementAt(0))*fscale1;
					ftemp = atof(bukuanarray2.ElementAt(ii).ElementAt(0))*fscale1;
					typepos = FindArray(&typearray, "摄影前期");
					if (typepos == -1)
					{
						typearray.Add("摄影前期");
						moneyarray.Add(ftemp);
					}
					else
					{
						moneyarray.SetAt(typepos, moneyarray.ElementAt(typepos) + ftemp);
					}
				}
				if (bWait2 && atoi(g_cominfoarray.ElementAt(0).ElementAt(57)))//我是化妆师
				{
					money1 += atof(bukuanarray2.ElementAt(ii).ElementAt(0))*fscale2;
					ftemp = atof(bukuanarray2.ElementAt(ii).ElementAt(0))*fscale2;
					typepos = FindArray(&typearray, "摄影前期");
					if (typepos == -1)
					{
						typearray.Add("摄影前期");
						moneyarray.Add(ftemp);
					}
					else
					{
						moneyarray.SetAt(typepos, moneyarray.ElementAt(typepos) + ftemp);
					}
				}
			}
		}

		for (ii = 0; ii < singleincomearray.GetSize(); ii++)
		{
			if (singleincomearray.ElementAt(ii).ElementAt(2) != name)continue;
			if (singleincomearray.ElementAt(ii).ElementAt(3) == "摄影二销")
				money2 += atof(singleincomearray.ElementAt(ii).ElementAt(4));
#ifndef CHILD_VERSION
			else if (singleincomearray.ElementAt(ii).ElementAt(3) == "化妆二销")
#else
			else if (singleincomearray.ElementAt(ii).ElementAt(3) == "引导二销")
#endif
				money3 += atof(singleincomearray.ElementAt(ii).ElementAt(4));
			else if (singleincomearray.ElementAt(ii).ElementAt(3) == "套系升级")
				money4 += atof(singleincomearray.ElementAt(ii).ElementAt(4));
			else if (singleincomearray.ElementAt(ii).ElementAt(3) == "选片二销")
				money5 += atof(singleincomearray.ElementAt(ii).ElementAt(4));

			ftemp = atof(singleincomearray.ElementAt(ii).ElementAt(4));
			typepos = FindArray(&typearray, singleincomearray.ElementAt(ii).ElementAt(3));
			if (typepos == -1)
			{
				typearray.Add(singleincomearray.ElementAt(ii).ElementAt(3));
				moneyarray.Add(ftemp);
			}
			else
			{
				moneyarray.SetAt(typepos, moneyarray.ElementAt(typepos) + ftemp);
			}
		}
		m_base = m_List1array.ElementAt(n).ElementAt(1);
		m_rate1 = m_List1array.ElementAt(n).ElementAt(2);
		m_rate2 = m_List1array.ElementAt(n).ElementAt(3);
		m_bz = m_List1array.ElementAt(n).ElementAt(4);
		m_rate3 = m_List1array.ElementAt(n).ElementAt(6);
		m_rate4 = m_List1array.ElementAt(n).ElementAt(7);
		m_rate5 = m_List1array.ElementAt(n).ElementAt(8);

		typepos = FindArray(&typearray, "前期");
		if (typepos == -1)
		{
			m_money1 = "0";
			money1 = 0;
		}
		else
		{
			money1 = moneyarray.ElementAt(typepos);
		}
		float money12 = 0;
		typepos = FindArray(&typearray, "摄影前期");
		if (typepos == -1)
		{
			money12 = 0;
		}
		else
		{
			money12 = moneyarray.ElementAt(typepos);
		}
		m_money1.Format("%0.2f", money1 + money12);
		money2 = 0;
		float realmoney2 = 0;
		for (int i = 0; i < typearray.GetSize(); i++)
		{
			if ("前期" == typearray.ElementAt(i))continue;
			if ("摄影前期" == typearray.ElementAt(i))continue;
			realmoney2 += GetSalaryFromRule(moneyarray.ElementAt(i), GetRule(typearray.ElementAt(i)));
			money2 += moneyarray.ElementAt(i);
		}
		m_money2.Format("%0.2f", money2);

		GetMoney6(name, money6);

		temp.Format("%0.2f", atof(m_base) + money6 + realmoney2 + GetSalaryFromRule(money1, GetRule(m_rate1)) + GetSalaryFromRule(money12, GetRule(m_rate2)));
		ConvertToPrice(temp);
		m_List3array.ElementAt(n).SetAt(1, temp);
		m_List3array.ElementAt(n).SetAt(2, m_base);
		m_List3array.ElementAt(n).SetAt(3, m_money1);
		m_List3array.ElementAt(n).SetAt(4, m_money2);
		sum1 += atof(temp);
		sum2 += atof(m_base);
		sum3 += money1;
		sum4 += money2;

		temp.Format("%0.2f", money6);	ConvertToPrice(temp);
		m_List3array.ElementAt(n).SetAt(5, temp);
		m_List3array.ElementAt(n).SetAt(6, m_List1array.ElementAt(n).ElementAt(5));
		if (m_bz.GetLength() > 100)
			m_List3array.ElementAt(n).SetAt(7, m_bz.Left(100) + "..");
		else
			m_List3array.ElementAt(n).SetAt(7, m_bz);
	}

	temp.Format("%0.2f", sum1);
	ConvertToPrice(temp);
	m_List3array.ElementAt(n).Add("统计:");
	m_List3array.ElementAt(n).Add(temp);
	temp.Format("%0.2f", sum2);
	ConvertToPrice(temp);
	m_List3array.ElementAt(n).Add(temp);
	temp.Format("%0.2f", sum3);
	ConvertToPrice(temp);
	m_List3array.ElementAt(n).Add(temp);
	temp.Format("%0.2f", sum4);
	ConvertToPrice(temp);
	m_List3array.ElementAt(n).Add(temp);

	m_List3array.ElementAt(n).Add("");
	m_List3array.ElementAt(n).Add("");
	m_List3array.ElementAt(n).Add("");
}

void MySalary::FillGrid4(CString &sRet)
{
	sRet = "0";
	if (m_Workratearray.GetSize() == 0)
	{
		/*
		#ifdef CHILD_VERSION
		AfxMessageBox("摄影师，引导师，数码师提成方案未设置，请在菜单-》初始设置-》工资设置中设置!");
		#else
		AfxMessageBox("摄影师，化妆师，数码师提成方案未设置，请在菜单-》初始设置-》工资设置中设置!");
		#endif*/
		return;
	}
	float fsum = 0;
	int	m_data1sy = -1;
	CString	m_data2sy;
	CString	m_data3sy;
	CString	m_data4sy;
	CString	m_data5sy;

	int	m_data1hz = -1;
	CString	m_data2hz;
	CString	m_data3hz;
	CString	m_data4hz;
	CString	m_data5hz;

	int i = 0;
	for ( i = 0; i < m_Workratearray.GetSize(); i++)
	{
		if ("摄影师" == m_Workratearray.ElementAt(i).ElementAt(0))
		{
			m_data1sy = atoi(m_Workratearray.ElementAt(i).ElementAt(1));
			m_data2sy = (m_Workratearray.ElementAt(i).ElementAt(2));
			m_data3sy = (m_Workratearray.ElementAt(i).ElementAt(3));
			m_data4sy = (m_Workratearray.ElementAt(i).ElementAt(4));
			m_data5sy = (m_Workratearray.ElementAt(i).ElementAt(5));
		}
#ifdef CHILD_VERSION
		else if ("引导师" == m_Workratearray.ElementAt(i).ElementAt(0))
#else
		else if ("化妆师" == m_Workratearray.ElementAt(i).ElementAt(0))
#endif
		{
			m_data1hz = atoi(m_Workratearray.ElementAt(i).ElementAt(1));
			m_data2hz = (m_Workratearray.ElementAt(i).ElementAt(2));
			m_data3hz = (m_Workratearray.ElementAt(i).ElementAt(3));
			m_data4hz = (m_Workratearray.ElementAt(i).ElementAt(4));
			m_data5hz = (m_Workratearray.ElementAt(i).ElementAt(5));
		}
	}

	m_List4.DeleteAllItems2();
	int count = 0;
	CString str, price;
	for (i = 0; i < m_List4array.GetSize(); i++)//14
	{
		if (m_List4array.ElementAt(i).ElementAt(14) == "摄影师" && m_data1sy != 3)
		{
			if (m_data1sy == 0)//按服装套数提
			{
				m_List4.m_arLabels.SetSize(count + 1, 1);
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(0));
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(1));
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(2));
				str.Format("%0.2f", atof(m_List4array.ElementAt(i).ElementAt(5))*atof(m_data2sy) + atof(m_List4array.ElementAt(i).ElementAt(6))*atof(m_data3sy));
				m_List4.m_arLabels.ElementAt(count).Add(str);//金额
				fsum += atof(str);

				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(14));
				str.Format("外景%d,内景%d", atoi(m_List4array.ElementAt(i).ElementAt(5)), atoi(m_List4array.ElementAt(i).ElementAt(6)));
				m_List4.m_arLabels.ElementAt(count).Add(str);
				str.Format("%d", atoi(m_List4array.ElementAt(i).ElementAt(5)) + atoi(m_List4array.ElementAt(i).ElementAt(6)));
				m_List4.m_arLabels.ElementAt(count).Add(str);

				str.Format("外景%0.2f,内景%0.2f", atof(m_data2sy), atof(m_data3sy));
				m_List4.m_arLabels.ElementAt(count).Add(str);

				m_List4.m_arLabels.ElementAt(count).Add("按服装套数提成");
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(9));
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(4));
				count++;
			}
			else if (m_data1sy == 1)//按套系金额提成
			{
				if (m_List4array.ElementAt(i).ElementAt(3) != m_List4array.ElementAt(i).ElementAt(15) && m_List4array.ElementAt(i).ElementAt(3) != m_List4array.ElementAt(i).ElementAt(16) && m_List4array.ElementAt(i).ElementAt(3) != m_List4array.ElementAt(i).ElementAt(17) && m_List4array.ElementAt(i).ElementAt(3) != m_List4array.ElementAt(i).ElementAt(18))
				{
					continue;//既不是主摄影师，也不是副..
				}

				m_List4.m_arLabels.SetSize(count + 1, 1);
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(0));
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(1));
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(2));

				if (m_List4array.ElementAt(i).ElementAt(3) == m_List4array.ElementAt(i).ElementAt(15))
					str.Format("%0.2f", atof(m_List4array.ElementAt(i).ElementAt(9))*atof(m_data4sy)*atof(m_List4array.ElementAt(i).ElementAt(19)) / 10000.0);
				else if (m_List4array.ElementAt(i).ElementAt(3) == m_List4array.ElementAt(i).ElementAt(16))
					str.Format("%0.2f", atof(m_List4array.ElementAt(i).ElementAt(9))*atof(m_data4sy)*atof(m_List4array.ElementAt(i).ElementAt(20)) / 10000.0);
				else if (m_List4array.ElementAt(i).ElementAt(3) == m_List4array.ElementAt(i).ElementAt(17))
					str.Format("%0.2f", atof(m_List4array.ElementAt(i).ElementAt(9))*atof(m_data4sy)*atof(m_List4array.ElementAt(i).ElementAt(21)) / 10000.0);
				else if (m_List4array.ElementAt(i).ElementAt(3) == m_List4array.ElementAt(i).ElementAt(18))
					str.Format("%0.2f", atof(m_List4array.ElementAt(i).ElementAt(9))*atof(m_data4sy)*atof(m_List4array.ElementAt(i).ElementAt(22)) / 10000.0);

				m_List4.m_arLabels.ElementAt(count).Add(str);//金额
				fsum += atof(str);

				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(14));
				m_List4.m_arLabels.ElementAt(count).Add("不适用");
				m_List4.m_arLabels.ElementAt(count).Add("不适用");
				str.Format("套系的%d", atoi(m_data4sy));
				m_List4.m_arLabels.ElementAt(count).Add(str + "%");
				m_List4.m_arLabels.ElementAt(count).Add("按套系金额提成");
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(9));
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(4));
				count++;
			}
			else if (m_data1sy == 2)//按加挑照片提成
			{
				m_List4.m_arLabels.SetSize(count + 1, 1);
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(0));
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(1));
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(2));
				str.Format("%0.2f", atof(m_List4array.ElementAt(i).ElementAt(31))*atof(m_data5sy));
				m_List4.m_arLabels.ElementAt(count).Add(str);//金额	
				fsum += atof(str);

				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(14));


				m_List4.m_arLabels.ElementAt(count).Add("不适用");
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(31));

				str.Format("%0.2f", atof(m_data5sy));
				m_List4.m_arLabels.ElementAt(count).Add(str);

				m_List4.m_arLabels.ElementAt(count).Add("按加挑照片提成");
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(9));
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(4));
				count++;
			}
		}
#ifdef CHILD_VERSION
		else if (m_List4array.ElementAt(i).ElementAt(14) == "引导师" && m_data1hz != 3)
#else
		else if (m_List4array.ElementAt(i).ElementAt(14) == "化妆师" && m_data1hz != 3)
#endif
		{
			if (m_data1hz == 0)//按服装套数提
			{
				m_List4.m_arLabels.SetSize(count + 1, 1);
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(0));
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(1));
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(2));
				str.Format("%0.2f", atof(m_List4array.ElementAt(i).ElementAt(5))*atof(m_data2hz) + atof(m_List4array.ElementAt(i).ElementAt(6))*atof(m_data3hz));
				m_List4.m_arLabels.ElementAt(count).Add(str);//金额
				fsum += atof(str);

				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(14));
				str.Format("外景%d,内景%d", atoi(m_List4array.ElementAt(i).ElementAt(5)), atoi(m_List4array.ElementAt(i).ElementAt(6)));
				m_List4.m_arLabels.ElementAt(count).Add(str);
				str.Format("%d", atoi(m_List4array.ElementAt(i).ElementAt(5)) + atoi(m_List4array.ElementAt(i).ElementAt(6)));
				m_List4.m_arLabels.ElementAt(count).Add(str);

				str.Format("外景%0.2f,内景%0.2f", atof(m_data2hz), atof(m_data3hz));
				m_List4.m_arLabels.ElementAt(count).Add(str);

				m_List4.m_arLabels.ElementAt(count).Add("按服装套数提成");
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(9));
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(4));
				count++;
			}
			else if (m_data1hz == 1)//按套系金额提成
			{

				if (m_List4array.ElementAt(i).ElementAt(3) != m_List4array.ElementAt(i).ElementAt(23) && m_List4array.ElementAt(i).ElementAt(3) != m_List4array.ElementAt(i).ElementAt(24) && m_List4array.ElementAt(i).ElementAt(3) != m_List4array.ElementAt(i).ElementAt(25) && m_List4array.ElementAt(i).ElementAt(3) != m_List4array.ElementAt(i).ElementAt(26))
				{
					continue;//既不是主化妆师，也不是副..
				}

				m_List4.m_arLabels.SetSize(count + 1, 1);
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(0));
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(1));
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(2));

				if (m_List4array.ElementAt(i).ElementAt(3) == m_List4array.ElementAt(i).ElementAt(23))
					str.Format("%0.2f", atof(m_List4array.ElementAt(i).ElementAt(9))*atof(m_data4sy)*atof(m_List4array.ElementAt(i).ElementAt(27)) / 10000.0);
				else if (m_List4array.ElementAt(i).ElementAt(3) == m_List4array.ElementAt(i).ElementAt(24))
					str.Format("%0.2f", atof(m_List4array.ElementAt(i).ElementAt(9))*atof(m_data4sy)*atof(m_List4array.ElementAt(i).ElementAt(28)) / 10000.0);
				else if (m_List4array.ElementAt(i).ElementAt(3) == m_List4array.ElementAt(i).ElementAt(25))
					str.Format("%0.2f", atof(m_List4array.ElementAt(i).ElementAt(9))*atof(m_data4sy)*atof(m_List4array.ElementAt(i).ElementAt(29)) / 10000.0);
				else if (m_List4array.ElementAt(i).ElementAt(3) == m_List4array.ElementAt(i).ElementAt(26))
					str.Format("%0.2f", atof(m_List4array.ElementAt(i).ElementAt(9))*atof(m_data4sy)*atof(m_List4array.ElementAt(i).ElementAt(30)) / 10000.0);

				m_List4.m_arLabels.ElementAt(count).Add(str);//金额
				fsum += atof(str);

				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(14));
				m_List4.m_arLabels.ElementAt(count).Add("不适用");
				m_List4.m_arLabels.ElementAt(count).Add("不适用");
				str.Format("套系的%d", atoi(m_data4hz));
				m_List4.m_arLabels.ElementAt(count).Add(str + "%");
				m_List4.m_arLabels.ElementAt(count).Add("按套系金额提成");
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(9));
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(4));
				count++;
			}
			else if (m_data1hz == 2)//按加挑照片提成
			{
				m_List4.m_arLabels.SetSize(count + 1, 1);
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(0));
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(1));
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(2));
				str.Format("%0.2f", atof(m_List4array.ElementAt(i).ElementAt(31))*atof(m_data5hz));
				m_List4.m_arLabels.ElementAt(count).Add(str);//金额	
				fsum += atof(str);

				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(14));


				m_List4.m_arLabels.ElementAt(count).Add("不适用");
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(31));

				str.Format("%0.2f", atof(m_data5hz));
				m_List4.m_arLabels.ElementAt(count).Add(str);

				m_List4.m_arLabels.ElementAt(count).Add("按加挑照片提成");
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(9));
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(4));
				count++;
			}
		}
		else if (m_List4array.ElementAt(i).ElementAt(14) == "数码师")
		{
			m_List4.m_arLabels.SetSize(count + 1, 1);
			m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(0));
			m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(1));
			m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(2));

			price = GetPrice(m_List4array.ElementAt(i).ElementAt(6));
			str.Format("%0.2f", atof(m_List4array.ElementAt(i).ElementAt(5))*atof(price));
			m_List4.m_arLabels.ElementAt(count).Add(str);//金额
			fsum += atof(str);

			m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(14));
			m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(6));
			m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(5));

			m_List4.m_arLabels.ElementAt(count).Add(price);

			m_List4.m_arLabels.ElementAt(count).Add("单价x数量");
			m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(9));
			m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(4));
			count++;
		}
	}
	m_List4.m_LabelCount = count;
	m_List4.SetItemCountEx(count);

	sRet.Format("计件提成(总和:%0.2f)", fsum);

	SetDlgItemText(IDC_STATIC16, sRet);
	sRet.Format("%0.2f", fsum);
}

void MySalary::OnBut1()
{

}

void MySalary::OnBut2()
{
}

void MySalary::OnSelchangeCombo6()
{

}

void MySalary::OnBut4()
{
	//	ShowHisSalary dlg;
	//	dlg.DoModal();
}

CString MySalary::GetPrice(CString name)
{
	for (int i = 0; i < m_Workratearray.GetSize(); i++)
	{
		if ("数码师" == m_Workratearray.ElementAt(i).ElementAt(0) && name == m_Workratearray.ElementAt(i).ElementAt(1))
		{
			return m_Workratearray.ElementAt(i).ElementAt(2);
		}
	}
	return "0";
}

void MySalary::GetMoney6(CString name, float &fRet)
{
	fRet = 0;
	/*	if(m_Workratearray.GetSize ()==0)
	{
	return;
	}*/
	float fsum = 0;
	int	m_data1sy = -1;
	CString	m_data2sy;
	CString	m_data3sy;
	CString	m_data4sy;
	CString	m_data5sy;

	int	m_data1hz = -1;
	CString	m_data2hz;
	CString	m_data3hz;
	CString	m_data4hz;
	CString	m_data5hz;

	/*	for(int i=0; i<m_Workratearray.GetSize (); i++)
	{
	if("摄影师"==m_Workratearray.ElementAt (i).ElementAt (0))
	{
	m_data1sy=atoi(m_Workratearray.ElementAt (i).ElementAt (1));
	m_data2sy=(m_Workratearray.ElementAt (i).ElementAt (2));
	m_data3sy=(m_Workratearray.ElementAt (i).ElementAt (3));
	m_data4sy=(m_Workratearray.ElementAt (i).ElementAt (4));
	m_data5sy=(m_Workratearray.ElementAt (i).ElementAt (5));
	}
	#ifdef CHILD_VERSION
	else if("引导师"==m_Workratearray.ElementAt (i).ElementAt (0))
	#else
	else if("化妆师"==m_Workratearray.ElementAt (i).ElementAt (0))
	#endif
	{
	m_data1hz=atoi(m_Workratearray.ElementAt (i).ElementAt (1));
	m_data2hz=(m_Workratearray.ElementAt (i).ElementAt (2));
	m_data3hz=(m_Workratearray.ElementAt (i).ElementAt (3));
	m_data4hz=(m_Workratearray.ElementAt (i).ElementAt (4));
	m_data5hz=(m_Workratearray.ElementAt (i).ElementAt (5));
	}
	}
	if(m_data1sy==-1)
	{

	return;
	}
	if(m_data1hz==-1)
	{

	return;
	}*/
	m_List4.DeleteAllItems2();
	int count = 0;
	CString str, price;
	for (int i = 0; i < m_List4array.GetSize(); i++)//14
	{
		if (m_List4array.ElementAt(i).ElementAt(3) != name)continue;
		if (0)//m_List4array.ElementAt (i).ElementAt (14)=="摄影师" && m_data1sy!=3)
		{
			if (m_data1sy == 0)//按服装套数提
			{
				m_List4.m_arLabels.SetSize(count + 1, 1);
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(0));
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(1));
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(2));
				str.Format("%0.2f", atof(m_List4array.ElementAt(i).ElementAt(5))*atof(m_data2sy) + atof(m_List4array.ElementAt(i).ElementAt(6))*atof(m_data3sy));
				m_List4.m_arLabels.ElementAt(count).Add(str);//金额
				fsum += atof(str);

				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(14));
				str.Format("外景%d,内景%d", atoi(m_List4array.ElementAt(i).ElementAt(5)), atoi(m_List4array.ElementAt(i).ElementAt(6)));
				m_List4.m_arLabels.ElementAt(count).Add(str);
				str.Format("%d", atoi(m_List4array.ElementAt(i).ElementAt(5)) + atoi(m_List4array.ElementAt(i).ElementAt(6)));
				m_List4.m_arLabels.ElementAt(count).Add(str);

				str.Format("外景%0.2f,内景%0.2f", atof(m_data2sy), atof(m_data3sy));
				m_List4.m_arLabels.ElementAt(count).Add(str);

				m_List4.m_arLabels.ElementAt(count).Add("按服装套数提成");
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(9));
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(4));
				count++;
			}
			else if (m_data1sy == 1)//按套系金额提成
			{
				if (m_List4array.ElementAt(i).ElementAt(3) != m_List4array.ElementAt(i).ElementAt(15) && m_List4array.ElementAt(i).ElementAt(3) != m_List4array.ElementAt(i).ElementAt(16) && m_List4array.ElementAt(i).ElementAt(3) != m_List4array.ElementAt(i).ElementAt(17) && m_List4array.ElementAt(i).ElementAt(3) != m_List4array.ElementAt(i).ElementAt(18))
				{
					continue;//既不是主摄影师，也不是副..
				}

				m_List4.m_arLabels.SetSize(count + 1, 1);
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(0));
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(1));
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(2));


				if (m_List4array.ElementAt(i).ElementAt(3) == m_List4array.ElementAt(i).ElementAt(15))
					str.Format("%0.2f", atof(m_List4array.ElementAt(i).ElementAt(9))*atof(m_data4sy)*atof(m_List4array.ElementAt(i).ElementAt(19)) / 10000.0);
				else if (m_List4array.ElementAt(i).ElementAt(3) == m_List4array.ElementAt(i).ElementAt(16))
					str.Format("%0.2f", atof(m_List4array.ElementAt(i).ElementAt(9))*atof(m_data4sy)*atof(m_List4array.ElementAt(i).ElementAt(20)) / 10000.0);
				else if (m_List4array.ElementAt(i).ElementAt(3) == m_List4array.ElementAt(i).ElementAt(17))
					str.Format("%0.2f", atof(m_List4array.ElementAt(i).ElementAt(9))*atof(m_data4sy)*atof(m_List4array.ElementAt(i).ElementAt(21)) / 10000.0);
				else if (m_List4array.ElementAt(i).ElementAt(3) == m_List4array.ElementAt(i).ElementAt(18))
					str.Format("%0.2f", atof(m_List4array.ElementAt(i).ElementAt(9))*atof(m_data4sy)*atof(m_List4array.ElementAt(i).ElementAt(22)) / 10000.0);

				m_List4.m_arLabels.ElementAt(count).Add(str);//金额
				fsum += atof(str);

				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(14));
				m_List4.m_arLabels.ElementAt(count).Add("不适用");
				m_List4.m_arLabels.ElementAt(count).Add("不适用");
				str.Format("套系的%d", atoi(m_data4sy));
				m_List4.m_arLabels.ElementAt(count).Add(str + "%");
				m_List4.m_arLabels.ElementAt(count).Add("按套系金额提成");
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(9));
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(4));
				count++;
			}
			else if (m_data1sy == 2)//按加挑照片提成
			{
				m_List4.m_arLabels.SetSize(count + 1, 1);
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(0));
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(1));
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(2));
				str.Format("%0.2f", atof(m_List4array.ElementAt(i).ElementAt(31))*atof(m_data5sy));
				m_List4.m_arLabels.ElementAt(count).Add(str);//金额	
				fsum += atof(str);

				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(14));

				m_List4.m_arLabels.ElementAt(count).Add("不适用");
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(31));

				str.Format("%0.2f", atof(m_data5sy));
				m_List4.m_arLabels.ElementAt(count).Add(str);

				m_List4.m_arLabels.ElementAt(count).Add("按加挑照片提成");
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(9));
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(4));
				count++;
			}
		}
#ifdef CHILD_VERSION
		else if (0)//m_List4array.ElementAt (i).ElementAt (14)=="引导师" && m_data1hz!=3)
#else
		else if (0)//m_List4array.ElementAt (i).ElementAt (14)=="化妆师" && m_data1hz!=3)
#endif
		{
			if (m_data1hz == 0)//按服装套数提
			{
				m_List4.m_arLabels.SetSize(count + 1, 1);
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(0));
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(1));
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(2));
				str.Format("%0.2f", atof(m_List4array.ElementAt(i).ElementAt(5))*atof(m_data2hz) + atof(m_List4array.ElementAt(i).ElementAt(6))*atof(m_data3hz));
				m_List4.m_arLabels.ElementAt(count).Add(str);//金额
				fsum += atof(str);

				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(14));
				str.Format("外景%d,内景%d", atoi(m_List4array.ElementAt(i).ElementAt(5)), atoi(m_List4array.ElementAt(i).ElementAt(6)));
				m_List4.m_arLabels.ElementAt(count).Add(str);
				str.Format("%d", atoi(m_List4array.ElementAt(i).ElementAt(5)) + atoi(m_List4array.ElementAt(i).ElementAt(6)));
				m_List4.m_arLabels.ElementAt(count).Add(str);

				str.Format("外景%0.2f,内景%0.2f", atof(m_data2hz), atof(m_data3hz));
				m_List4.m_arLabels.ElementAt(count).Add(str);

				m_List4.m_arLabels.ElementAt(count).Add("按服装套数提成");
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(9));
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(4));
				count++;
			}
			else if (m_data1hz == 1)//按套系金额提成
			{
				if (m_List4array.ElementAt(i).ElementAt(3) != m_List4array.ElementAt(i).ElementAt(23) && m_List4array.ElementAt(i).ElementAt(3) != m_List4array.ElementAt(i).ElementAt(24) && m_List4array.ElementAt(i).ElementAt(3) != m_List4array.ElementAt(i).ElementAt(25) && m_List4array.ElementAt(i).ElementAt(3) != m_List4array.ElementAt(i).ElementAt(26))
				{
					continue;//既不是主化妆师，也不是副..
				}

				m_List4.m_arLabels.SetSize(count + 1, 1);
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(0));
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(1));
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(2));

				if (m_List4array.ElementAt(i).ElementAt(3) == m_List4array.ElementAt(i).ElementAt(23))
					str.Format("%0.2f", atof(m_List4array.ElementAt(i).ElementAt(9))*atof(m_data4sy)*atof(m_List4array.ElementAt(i).ElementAt(27)) / 10000.0);
				else if (m_List4array.ElementAt(i).ElementAt(3) == m_List4array.ElementAt(i).ElementAt(24))
					str.Format("%0.2f", atof(m_List4array.ElementAt(i).ElementAt(9))*atof(m_data4sy)*atof(m_List4array.ElementAt(i).ElementAt(28)) / 10000.0);
				else if (m_List4array.ElementAt(i).ElementAt(3) == m_List4array.ElementAt(i).ElementAt(25))
					str.Format("%0.2f", atof(m_List4array.ElementAt(i).ElementAt(9))*atof(m_data4sy)*atof(m_List4array.ElementAt(i).ElementAt(29)) / 10000.0);
				else if (m_List4array.ElementAt(i).ElementAt(3) == m_List4array.ElementAt(i).ElementAt(26))
					str.Format("%0.2f", atof(m_List4array.ElementAt(i).ElementAt(9))*atof(m_data4sy)*atof(m_List4array.ElementAt(i).ElementAt(30)) / 10000.0);

				m_List4.m_arLabels.ElementAt(count).Add(str);//金额
				fsum += atof(str);

				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(14));
				m_List4.m_arLabels.ElementAt(count).Add("不适用");
				m_List4.m_arLabels.ElementAt(count).Add("不适用");
				str.Format("套系的%d", atoi(m_data4hz));
				m_List4.m_arLabels.ElementAt(count).Add(str + "%");
				m_List4.m_arLabels.ElementAt(count).Add("按套系金额提成");
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(9));
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(4));
				count++;
			}
			else if (m_data1hz == 2)//按加挑照片提成
			{
				m_List4.m_arLabels.SetSize(count + 1, 1);
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(0));
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(1));
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(2));
				str.Format("%0.2f", atof(m_List4array.ElementAt(i).ElementAt(31))*atof(m_data5hz));
				m_List4.m_arLabels.ElementAt(count).Add(str);//金额	
				fsum += atof(str);

				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(14));


				m_List4.m_arLabels.ElementAt(count).Add("不适用");
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(31));

				str.Format("%0.2f", atof(m_data5hz));
				m_List4.m_arLabels.ElementAt(count).Add(str);

				m_List4.m_arLabels.ElementAt(count).Add("按加挑照片提成");
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(9));
				m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(4));
				count++;
			}
		}
		else if (m_List4array.ElementAt(i).ElementAt(14) == "数码师")
		{
			m_List4.m_arLabels.SetSize(count + 1, 1);
			m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(0));
			m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(1));
			m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(2));

			price = GetPrice(m_List4array.ElementAt(i).ElementAt(6));
			str.Format("%0.2f", atof(m_List4array.ElementAt(i).ElementAt(5))*atof(price));
			m_List4.m_arLabels.ElementAt(count).Add(str);//金额
			fsum += atof(str);

			m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(14));
			m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(6));
			m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(5));

			m_List4.m_arLabels.ElementAt(count).Add(price);

			m_List4.m_arLabels.ElementAt(count).Add("单价x数量");
			m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(9));
			m_List4.m_arLabels.ElementAt(count).Add(m_List4array.ElementAt(i).ElementAt(4));
			count++;
		}
	}
	m_List4.m_LabelCount = count;
	m_List4.SetItemCountEx(count);

	fRet = fsum;
}

void MySalary::OnButton4()
{
	int pos = m_comboname.GetCurSel();
	if (pos == -1)
	{
		AfxMessageBox("请选择您要导出资料的员工");
		return;
	}

	CString name;
	m_comboname.GetWindowText(name);

	SelExportType dlg;
	if (dlg.DoModal() != IDOK)return;
	if (dlg.m_type == 1)
	{
		int arraysize = 0;
		CArray<CStringArray, CStringArray>array;
		CStringArray moneytypearray;
		CString str, field2, field3;
		float sum = 0;
		for (int i = 0; i < m_List1.GetItemCount(); i++)
		{
			field2 = m_List1.GetItemText(i, 0);
			sum += atof(field2);
			field3 = m_List1.GetItemText(i, 2);
			if (::FindArray(&moneytypearray, field3) == -1)
				moneytypearray.Add(field3);
			array.SetSize(arraysize + 1, 1);
			array.ElementAt(arraysize).Add(m_List1.GetItemText(i, 0));
			array.ElementAt(arraysize).Add(m_List1.GetItemText(i, 1));
			array.ElementAt(arraysize).Add(m_List1.GetItemText(i, 2));
			array.ElementAt(arraysize).Add(m_List1.GetItemText(i, 3));
			array.ElementAt(arraysize).Add(m_List1.GetItemText(i, 4));
			array.ElementAt(arraysize).Add(m_List1.GetItemText(i, 5));
			array.ElementAt(arraysize).Add(m_List1.GetItemText(i, 6));
			arraysize++;
		}

		array.SetSize(arraysize + 1, 1);
		array.ElementAt(arraysize).Add("总计");
		str.Format("%0.2f", sum);
		array.ElementAt(arraysize).Add(str);
		array.ElementAt(arraysize).Add("");
		array.ElementAt(arraysize).Add("");
		array.ElementAt(arraysize).Add("");
		array.ElementAt(arraysize).Add("");	array.ElementAt(arraysize).Add("");
		arraysize++;
		//////////////////////////////////////////////
		array.SetSize(arraysize + 1, 1);
		array.ElementAt(arraysize).Add("");
		array.ElementAt(arraysize).Add("");
		array.ElementAt(arraysize).Add("");
		array.ElementAt(arraysize).Add("");
		array.ElementAt(arraysize).Add("");
		array.ElementAt(arraysize).Add("");	array.ElementAt(arraysize).Add("");
		arraysize++;
		///////////////////////////////////////////////
		//////////////////////////////////////////////
		array.SetSize(arraysize + 1, 1);
		array.ElementAt(arraysize).Add("******");
		array.ElementAt(arraysize).Add("******");
		array.ElementAt(arraysize).Add("以下为分类统计");
		array.ElementAt(arraysize).Add("******");
		array.ElementAt(arraysize).Add("******");
		array.ElementAt(arraysize).Add("******");	array.ElementAt(arraysize).Add("******");
		arraysize++;
		///////////////////////////////////////////////
		array.SetSize(arraysize + 1, 1);
		array.ElementAt(arraysize).Add("");
		array.ElementAt(arraysize).Add("");
		array.ElementAt(arraysize).Add("");
		array.ElementAt(arraysize).Add("");
		array.ElementAt(arraysize).Add("");
		array.ElementAt(arraysize).Add(""); array.ElementAt(arraysize).Add("");
		arraysize++;
		///////////////////////////////////////////////
		for (int aa = 0; aa < moneytypearray.GetSize(); aa++)
		{
			sum = 0;
			for (int i = 0; i < m_List1.GetItemCount(); i++)
			{
				field3 = m_List1.GetItemText(i, 2);
				if (moneytypearray.ElementAt(aa) != field3)continue;
				field2 = m_List1.GetItemText(i, 0);
				sum += atof(field2);
				array.SetSize(arraysize + 1, 1);
				array.ElementAt(arraysize).Add(m_List1.GetItemText(i, 0));
				array.ElementAt(arraysize).Add(m_List1.GetItemText(i, 1));
				array.ElementAt(arraysize).Add(m_List1.GetItemText(i, 2));
				array.ElementAt(arraysize).Add(m_List1.GetItemText(i, 3));
				array.ElementAt(arraysize).Add(m_List1.GetItemText(i, 4));
				array.ElementAt(arraysize).Add(m_List1.GetItemText(i, 5));
				array.ElementAt(arraysize).Add(m_List1.GetItemText(i, 6));
				arraysize++;
			}
			array.SetSize(arraysize + 1, 1);
			array.ElementAt(arraysize).Add(moneytypearray.ElementAt(aa) + "总计");
			str.Format("%0.2f", sum);
			array.ElementAt(arraysize).Add(str);
			array.ElementAt(arraysize).Add("");
			array.ElementAt(arraysize).Add("");
			array.ElementAt(arraysize).Add(""); array.ElementAt(arraysize).Add(""); array.ElementAt(arraysize).Add("");
			arraysize++;

			//////////////////////////////////////////////
			array.SetSize(arraysize + 1, 1);
			array.ElementAt(arraysize).Add("");
			array.ElementAt(arraysize).Add("");
			array.ElementAt(arraysize).Add("");
			array.ElementAt(arraysize).Add("");
			array.ElementAt(arraysize).Add(""); array.ElementAt(arraysize).Add(""); array.ElementAt(arraysize).Add("");
			arraysize++;
			///////////////////////////////////////////////
		}

		m_ListTemp.DeleteAllItems2();
		int ii = 0;
		m_ListTemp.m_arLabels.SetSize(array.GetSize(), 1);
		int count = 0;
		for (ii = 0; ii < m_ListTemp.m_arLabels.GetSize(); ii++)
		{
			m_ListTemp.m_arLabels.ElementAt(count++).Copy(array.ElementAt(ii));
		}
		m_ListTemp.m_arLabels.SetSize(count, 1);
		ii = count;
		m_ListTemp.m_LabelCount = ii;
		m_ListTemp.SetItemCountEx(ii);

		ListToXLS(&m_ListTemp, "c:\\" + name + ".xls", 0);
		return;
	}

	CStdioFile fp;
	fp.Open("c:\\" + name + ".txt", CFile::modeCreate | CFile::modeWrite);
	CString str, field1, field2, field3, field4, field5, field6, field7, field8, field9, field10;

	int leng1 = 20;
	int leng2 = 15;
	int leng3 = 15;
	int leng4 = 15;
	int leng5 = 15;
	int leng6 = 15;
	int leng7 = 15;
	int leng8 = 15;
	int leng9 = 15;
	int leng10 = 15;

	field1 = "收款日期";
	field2 = "收款金额";
	field3 = "款项类别";
	field4 = "客人姓名";

	FillLength(field1, leng1);
	FillLength(field2, leng2);
	FillLength(field3, leng3);
	FillLength(field4, leng4);

	str = field1 + field2 + field3 + field4 + "\n";
	fp.WriteString(str);

	CStringArray moneytypearray;
	CString m_name1, m_name2;
	float sum = 0;
	for (int i = 0; i < m_List1.GetItemCount(); i++)
	{
		field4.Empty();
		field1 = m_List1.GetItemText(i, 1);
		field2 = m_List1.GetItemText(i, 0);
		sum += atof(field2);
		field3 = m_List1.GetItemText(i, 2);
		if (::FindArray(&moneytypearray, field3) == -1)
			moneytypearray.Add(field3);

		m_name1 = m_List1.GetItemText(i, 3);
		m_name2 = m_List1.GetItemText(i, 4);
		if (!m_name1.IsEmpty())
			field4 = m_name1 + ",";
		field4 += m_name2;
		field4.TrimRight(",");
		FillLength(field1, leng1);
		FillLength(field2, leng2);
		FillLength(field3, leng3);
		FillLength(field4, leng4);
		str = field1 + field2 + field3 + field4 + "\n";
		fp.WriteString(str);
	}

	str = "姓名: " + name;
	fp.WriteString(str); fp.WriteString("\n");
	str = "类别: 订单二销提成\n";
	fp.WriteString(str);
	str.Format("总计: %0.2f", sum); fp.WriteString(str);
	fp.WriteString("\n\n\n************************以下为分类统计************************");
	fp.WriteString("\n\n");

	for (int aa = 0; aa < moneytypearray.GetSize(); aa++)
	{
		sum = 0;
		for (int i = 0; i < m_List1.GetItemCount(); i++)
		{
			field3 = m_List1.GetItemText(i, 2);
			if (moneytypearray.ElementAt(aa) != field3)continue;
			field4.Empty();
			field1 = m_List1.GetItemText(i, 1);
			field2 = m_List1.GetItemText(i, 0);
			sum += atof(field2);
			m_name1 = m_List1.GetItemText(i, 3);
			m_name2 = m_List1.GetItemText(i, 4);
			if (!m_name1.IsEmpty())
				field4 = m_name1 + ",";
			field4 += m_name2;
			field4.TrimRight(",");
			FillLength(field1, leng1);
			FillLength(field2, leng2);
			FillLength(field3, leng3);
			FillLength(field4, leng4);
			str = field1 + field2 + field3 + field4 + "\n";
			fp.WriteString(str);
		}

		str = moneytypearray.ElementAt(aa) + "提成\n";
		fp.WriteString(str);
		str.Format("总计: %0.2f", sum); fp.WriteString(str);
		fp.WriteString("\n\n\n");
	}

	fp.Close();
	MessageBox("资料已保存到c:\\" + name + ".txt");
	ShellExecute(NULL, _T("open"), _T("c:\\" + name + ".txt"), NULL, NULL, SW_SHOWMAXIMIZED);
}

void MySalary::OnButton5()
{
	SelExpendType seldlg;
	seldlg.m_mode = 2;
	if (seldlg.DoModal() != IDOK)return;
	SalarySet4 dlg;
	dlg.m_header = "$" + seldlg.m_sel + ":";
	dlg.DoModal();
	/*	SalarySet4 dlg;
	dlg.m_header ="$前期:";
	dlg.DoModal ();	*/
}

void MySalary::OnButton6()
{
	SelExpendType seldlg;
	seldlg.m_bSecond = 1;
	if (seldlg.DoModal() != IDOK)return;
	SalarySet4 dlg;
	dlg.m_header = "$" + seldlg.m_sel + ":";
	dlg.DoModal();
}

void MySalary::OnCloseupCombo7()
{
	OnSelchangeList1();
}

void MySalary::OnButton14()
{
	int pos = m_comboname.GetCurSel();
	if (pos == -1)
	{
		AfxMessageBox("请选择您要导出资料的员工");
		return;
	}
	CString name;
	m_comboname.GetWindowText(name);

	SelExportType dlg;
	if (dlg.DoModal() != IDOK)return;
	if (dlg.m_type == 1)
	{
		ListToXLS(&m_List4, "c:\\" + name + "(计件).xls", 0);
		return;
	}

	CStdioFile fp;
	fp.Open("c:\\" + name + "(计件).txt", CFile::modeCreate | CFile::modeWrite);
	CString str, field1, field2, field3, field4, field5, field6, field7, field8, field9, field10;

	int leng1 = 20;
	int leng2 = 15;
	int leng3 = 15;
	int leng4 = 15;
	int leng5 = 15;
	int leng6 = 15;
	int leng7 = 15;
	int leng8 = 15;
	int leng9 = 15;
	int leng10 = 15;

	CString m_name1, m_name2;
	float sum = 0;

	{
		leng1 = 18;
		leng2 = 15;
		leng3 = 10;
		leng4 = 15;
		leng5 = 10;
		leng6 = 10;
		leng7 = 15;
		leng8 = 15;
		leng9 = 15;

		field1 = "客人姓名";
		field2 = "提成金额";
		field3 = "部门";
		field4 = "内容";
		field5 = "数量";
		field6 = "单价";
		field7 = "提成方式";
		field8 = "套系金额";
		field9 = "日期";

		FillLength(field1, leng1);
		FillLength(field2, leng2);
		FillLength(field3, leng3);
		FillLength(field4, leng4);
		FillLength(field5, leng5);
		FillLength(field6, leng6);
		FillLength(field7, leng7);
		FillLength(field8, leng8);
		FillLength(field9, leng9);
		str = field1 + field2 + field3 + field4 + field5 + field6 + field7 + field8 + field9 + "\n";
		fp.WriteString(str);
		for (int i = 0; i < m_List4.GetItemCount(); i++)
		{
			field1.Empty();
			m_name1 = m_List4.GetItemText(i, 1);
			m_name2 = m_List4.GetItemText(i, 2);
			if (!m_name1.IsEmpty())
				field1 = m_name1 + ",";
			field1 += m_name2;
			field1.TrimRight(",");
			field2 = m_List4.GetItemText(i, 3);
			sum += atof(field2);
			field3 = m_List4.GetItemText(i, 4);
			field4 = m_List4.GetItemText(i, 5);
			field5 = m_List4.GetItemText(i, 6);
			field6 = m_List4.GetItemText(i, 7);
			field7 = m_List4.GetItemText(i, 8);
			field8 = m_List4.GetItemText(i, 9);
			field9 = m_List4.GetItemText(i, 10);

			FillLength(field1, leng1);
			FillLength(field2, leng2);
			FillLength(field3, leng3);
			FillLength(field4, leng4);
			FillLength(field5, leng5);
			FillLength(field6, leng6);
			FillLength(field7, leng7);
			FillLength(field8, leng8);
			FillLength(field9, leng9);

			str = field1 + field2 + field3 + field4 + field5 + field6 + field7 + field8 + field9 + "\n";
			fp.WriteString(str);
		}
		fp.WriteString("\n");
		str = "姓名: " + name;
		fp.WriteString(str); fp.WriteString("\n");
		str = "类别: 计件提成\n";
		fp.WriteString(str);

		str.Format("总计: %0.2f", sum); fp.WriteString(str);
	}

	fp.Close();
	MessageBox("资料已保存到c:\\" + name + "(计件).txt");
	ShellExecute(NULL, _T("open"), _T("c:\\" + name + "(计件).txt"), NULL, NULL, SW_SHOWMAXIMIZED);
}

void MySalary::OnButton7()
{
	int pos = m_comboname.GetCurSel();
	if (pos == -1)
	{
		AfxMessageBox("请选择您要导出资料的员工");
		return;
	}
	CString name;
	m_comboname.GetWindowText(name);

	SelExportType dlg;
	if (dlg.DoModal() != IDOK)return;
	if (dlg.m_type == 1)
	{
		ListToXLS(&m_Listtake, "c:\\" + name + "(摄影).xls", 0);
		return;
	}

	CStdioFile fp;
	fp.Open("c:\\" + name + "(摄影).txt", CFile::modeCreate | CFile::modeWrite);
	CString str, field1, field2, field3, field4, field5, field6, field7, field8, field9, field10;

	int leng1 = 20;
	int leng2 = 15;
	int leng3 = 15;
	int leng4 = 15;
	int leng5 = 15;
	int leng6 = 15;
	int leng7 = 15;
	int leng8 = 15;
	int leng9 = 15;
	int leng10 = 15;

	CString m_name1, m_name2;
	float sum = 0;
	int waiter1count = 0;
	int waiter12count = 0;
	int waiter2count = 0;
	int waiter22count = 0;

	{
		leng1 = 18;
		leng2 = 20;
		leng3 = 12;
		leng4 = 20;
		leng5 = 15;
		leng6 = 10;
		leng7 = 10;
		leng8 = 10;
		leng9 = 10;

		field1 = "客人姓名";
		field2 = "套系";
		field3 = "套系金额";
		field4 = "景点";
		field5 = "日期";
		field6 = "摄影";
		field7 = "助理";
		field8 = "化妆";
#ifdef CHILD_VERSION
		field8 = "引导";
#endif
		field9 = "助理";

		FillLength(field1, leng1);
		FillLength(field2, leng2);
		FillLength(field3, leng3);
		FillLength(field4, leng4);
		FillLength(field5, leng5);
		FillLength(field6, leng6);
		FillLength(field7, leng7);
		FillLength(field8, leng8);
		FillLength(field9, leng9);
		str = field1 + field2 + field3 + field4 + field5 + field6 + field7 + field8 + field9 + "\n";
		fp.WriteString(str);
		for (int i = 0; i < m_Listtake.GetItemCount(); i++)
		{
			field1.Empty();
			m_name1 = m_Listtake.GetItemText(i, 1);
			m_name2 = m_Listtake.GetItemText(i, 2);
			if (!m_name1.IsEmpty())
				field1 = m_name1 + ",";
			field1 += m_name2;
			field1.TrimRight(",");
			field2 = m_Listtake.GetItemText(i, 3);
			field3 = m_Listtake.GetItemText(i, 4);
			sum += atof(field3);

			field4 = m_Listtake.GetItemText(i, 5);
			field5 = m_Listtake.GetItemText(i, 6);
			field6 = m_Listtake.GetItemText(i, 7);
			field7 = m_Listtake.GetItemText(i, 8);
			field8 = m_Listtake.GetItemText(i, 9);
			field9 = m_Listtake.GetItemText(i, 10);
			if (field6 == name)waiter1count++;
			if (field7 == name)waiter12count++;
			if (field8 == name)waiter2count++;
			if (field9 == name)waiter22count++;
			FillLength(field1, leng1);
			FillLength(field2, leng2);
			FillLength(field3, leng3);
			FillLength(field4, leng4);
			FillLength(field5, leng5);
			FillLength(field6, leng6);
			FillLength(field7, leng7);
			FillLength(field8, leng8);
			FillLength(field9, leng9);

			str = field1 + field2 + field3 + field4 + field5 + field6 + field7 + field8 + field9 + "\n";
			fp.WriteString(str);
		}
		fp.WriteString("\n");
		str = "姓名: " + name;
		fp.WriteString(str); fp.WriteString("\n");

		str.Format("摄影: %d\n", waiter1count); fp.WriteString(str);
		str.Format("助理: %d\n", waiter12count); fp.WriteString(str);
#ifdef CHILD_VERSION
		str.Format("引导: %d\n", waiter2count); fp.WriteString(str);
#else
		str.Format("化妆: %d\n", waiter2count); fp.WriteString(str);
#endif
		str.Format("助理: %d\n", waiter22count); fp.WriteString(str);
		str.Format("订单总金额: %0.2f", sum); fp.WriteString(str);
	}

	fp.Close();
	MessageBox("资料已保存到c:\\" + name + "(摄影).txt");
	ShellExecute(NULL, _T("open"), _T("c:\\" + name + "(摄影).txt"), NULL, NULL, SW_SHOWMAXIMIZED);
}

void MySalary::OnButton8()
{
	UpdateData();
	int pos = m_comboname.GetCurSel();
	if (pos == -1)
	{
		AfxMessageBox("请选择您要导出资料的员工");
		return;
	}

	CString date1, date2;

	date1 = m_date1.Format("%Y-%m-%d");
	date2 = m_date2.Format("%Y-%m-%d");

	CString name;
	m_comboname.GetWindowText(name);

	SelExportType dlg;
	if (dlg.DoModal() != IDOK)return;
	if (dlg.m_type == 1)
	{
		ListToXLS(&m_Listdigital, "c:\\" + name + "(数码).xls", 0);
		return;
	}

	CStdioFile fp;
	fp.Open("c:\\" + name + "(数码).txt", CFile::modeCreate | CFile::modeWrite);
	CString str, field1, field2, field3, field4, field5, field6, field7, field8, field9, field10;

	int leng1 = 20;
	int leng2 = 15;
	int leng3 = 15;
	int leng4 = 15;
	int leng5 = 15;
	int leng6 = 15;
	int leng7 = 15;
	int leng8 = 15;
	int leng9 = 15;
	int leng10 = 15;

	CString m_name1, m_name2;
	float sum1 = 0;
	float sum2 = 0;
	float sum3 = 0;
	float sum12 = 0;
	float sum22 = 0;
	float sum32 = 0;
	int count1 = 0;
	int count2 = 0;
	int count3 = 0;

	{
		leng1 = 18;
		leng2 = 20;
		leng3 = 12;
		leng4 = 10;
		leng5 = 15;
		leng6 = 10;
		leng7 = 15;
		leng8 = 10;
		leng9 = 15;
		leng10 = 10;

		field1 = "客人姓名";
		field2 = "套系";
		field3 = "套系金额";
		field4 = "初修";
		field5 = "日期";
		field6 = "精修";
		field7 = "日期";
		field8 = "设计";
		field9 = "日期";
		field10 = "选片二销";
		FillLength(field1, leng1);
		FillLength(field2, leng2);
		FillLength(field3, leng3);
		FillLength(field4, leng4);
		FillLength(field5, leng5);
		FillLength(field6, leng6);
		FillLength(field7, leng7);
		FillLength(field8, leng8);
		FillLength(field9, leng9);
		FillLength(field10, leng10);
		str = field1 + field2 + field3 + field4 + field5 + field6 + field7 + field8 + field9 + field10 + "\n";
		fp.WriteString(str);
		for (int i = 0; i < m_Listdigital.GetItemCount(); i++)
		{
			field1.Empty();
			m_name1 = m_Listdigital.GetItemText(i, 1);
			m_name2 = m_Listdigital.GetItemText(i, 2);
			if (!m_name1.IsEmpty())
				field1 = m_name1 + ",";
			field1 += m_name2;
			field1.TrimRight(",");
			field2 = m_Listdigital.GetItemText(i, 3);
			field3 = m_Listdigital.GetItemText(i, 4);
			field4 = m_Listdigital.GetItemText(i, 5);
			field5 = m_Listdigital.GetItemText(i, 6);
			field6 = m_Listdigital.GetItemText(i, 7);
			field7 = m_Listdigital.GetItemText(i, 8);
			field8 = m_Listdigital.GetItemText(i, 9);
			field9 = m_Listdigital.GetItemText(i, 10);
			field10 = m_Listdigital.GetItemText(i, 14);
			if (m_Listdigital.GetItemText(i, 11) == "OK" && field4 == name && field5 >= date1 && field5 <= date2)
			{
				sum1 += atof(field3);
				sum12 += atof(field10);
				count1++;
			}
			if (m_Listdigital.GetItemText(i, 12) == "OK" && field6 == name && field7 >= date1 && field7 <= date2)
			{
				sum2 += atof(field3);
				sum22 += atof(field10);
				count2++;
			}
			if (m_Listdigital.GetItemText(i, 13) == "OK" && field8 == name && field9 >= date1 && field9 <= date2)
			{
				sum3 += atof(field3);
				sum32 += atof(field10);
				count3++;
			}

			FillLength(field1, leng1);
			FillLength(field2, leng2);
			FillLength(field3, leng3);
			FillLength(field4, leng4);
			FillLength(field5, leng5);
			FillLength(field6, leng6);
			FillLength(field7, leng7);
			FillLength(field8, leng8);
			FillLength(field9, leng9);
			FillLength(field10, leng10);
			str = field1 + field2 + field3 + field4 + field5 + field6 + field7 + field8 + field9 + field10 + "\n";
			fp.WriteString(str);
		}
		fp.WriteString("\n");
		str = "姓名: " + name;
		fp.WriteString(str); fp.WriteString("\n");

		str.Format("初修: %d单 订单金额:%0.2f 选片二销:%0.2f\n", count1, sum1, sum12); fp.WriteString(str);
		str.Format("精修: %d单 订单金额:%0.2f 选片二销:%0.2f\n", count2, sum2, sum22); fp.WriteString(str);
		str.Format("设计: %d单 订单金额:%0.2f 选片二销:%0.2f\n", count3, sum3, sum32); fp.WriteString(str);
	}

	fp.Close();
	MessageBox("资料已保存到c:\\" + name + "(数码).txt");
	ShellExecute(NULL, _T("open"), _T("c:\\" + name + "(数码).txt"), NULL, NULL, SW_SHOWMAXIMIZED);
}

void MySalary::OnDatetimechangeDatetimepicker1(NMHDR* pNMHDR, LRESULT* pResult)
{
	OnSelchangeList1();
	*pResult = 0;
}

void MySalary::OnDatetimechangeDatetimepicker2(NMHDR* pNMHDR, LRESULT* pResult)
{
	OnSelchangeList1();
	*pResult = 0;
}

CString GetExcelDriver()
{
	char szBuf[2001];
	WORD cbBufMax = 2000;
	WORD cbBufOut;
	char *pszBuf = szBuf;
	CString sDriver;
	if (!SQLGetInstalledDrivers(szBuf, cbBufMax, &cbBufOut))
		return "";
	do
	{
		if (strstr(pszBuf, "Excel") != 0)
		{
			sDriver = CString(pszBuf);
			break;
		}
		pszBuf = strchr(pszBuf, '\0') + 1;
	} while (pszBuf[1] != '\0');
	return sDriver;
}

BOOL MakeSurePathExists(CString &Path, bool FilenameIncluded)
{
	int Pos = 0;
	while ((Pos = Path.Find('\\', Pos + 1)) != -1)
		CreateDirectory(Path.Left(Pos), NULL);
	if (!FilenameIncluded)
		CreateDirectory(Path, NULL);
	//	return ((!FilenameIncluded)?!_access(Path,0):
	//	!_access(Path.Left(Path.ReverseFind('\\')),0));

	return !_access(Path, 0);
}

BOOL GetDefaultXlsFileName(CString &sExcelFile)
{
	///默认文件名：yyyymmddhhmmss.xls
	// prompt the user (with all document templates)
	CFileDialog dlgFile(FALSE, ".xls", sExcelFile);
	CString title;
	CString strFilter;

	title = "导出";
	strFilter = "Excel文件(*.xls)";
	strFilter += (TCHAR)'\0';   // next string please
	strFilter += _T("*.xls");
	strFilter += (TCHAR)'\0';   // last string
	dlgFile.m_ofn.nMaxCustFilter++;
	dlgFile.m_ofn.nFilterIndex = 1;
	// append the "*.*" all files filter
	CString allFilter;
	VERIFY(allFilter.LoadString(AFX_IDS_ALLFILTER));
	strFilter += allFilter;
	strFilter += (TCHAR)'\0';   // next string please
	strFilter += _T("*.*");
	strFilter += (TCHAR)'\0';   // last string
	dlgFile.m_ofn.nMaxCustFilter++;

	dlgFile.m_ofn.lpstrFilter = strFilter;
	dlgFile.m_ofn.lpstrTitle = title;

	if (dlgFile.DoModal() == IDCANCEL)
		return FALSE; // open cancelled
	sExcelFile = dlgFile.GetFileName();
	if (MakeSurePathExists(sExcelFile, true)) {
		if (!DeleteFile(sExcelFile)) {    // 删除xls文件;
			AfxMessageBox("覆盖文件时出错！");
			return FALSE;
		}
	}
	return TRUE;
}

int FindArrayCount(CStringArray *pArray, CString Str)
{
	int ret = 0;
	for (int i = 0; i < pArray->GetSize(); i++)
	{
		if (pArray->ElementAt(i) == Str)
			ret++;
	}
	return ret;
}

void ListToXLS(CListCtrl *pList, CString savepath, int nColumn, int nRow)
{
	CString strPath = savepath;
#if 0
	const int nImportCount = 3500;
	INT nItemCount = pList->GetItemCount();
	if ( nItemCount < 5000)
	{
		Import2Excle(pList, savepath, nColumn, nRow);
	}
	else
	{
		int nTimes = 0;
		int nStartRow = 0;
		int nEndRow = 0;
		savepath.TrimRight(_T(".xls"));
		TCHAR szExcelpath[MAX_PATH] = {0};
		while( true )
		{
			nItemCount -= nImportCount;
			if ( nItemCount > 0 )
			{
				nTimes++;
				nEndRow += nImportCount;
				sprintf(szExcelpath, _T("%s%d.xls"), savepath, nTimes);
				Import2Excle(pList, szExcelpath, nColumn, nStartRow, -1, nEndRow);
				nStartRow += nImportCount;
			}
			else
			{
				sprintf(szExcelpath, _T("%s%d.xls"), savepath, nTimes+1);
				Import2Excle(pList, szExcelpath, nColumn, nStartRow, -1, -1);
				break;
			}
		}
	}
#else
	Import2Xls(pList, savepath, nColumn, nRow);
#endif

	strPath = savepath + _T(".dat");
	ShellExecute(NULL, _T("open"),  _T("xlsworker.exe"), strPath, NULL, SW_SHOW);
	///AfxMessageBox(savepath + _T("后台生成,请稍等片刻！"));

	return;

	if (pList == NULL)return;
	CString strTitle = "sheet1";
	CString warningStr;
	CString str, temp;
	if (pList->GetItemCount()>0)
	{
		CDatabase database;
		CString sDriver;
		CString sExcelFile;
		CString sSql;
		CString tableName = strTitle;
		CStringArray colarray;

		// 检索是否安装有Excel驱动 "Microsoft Excel Driver (*.xls)" 
		sDriver = GetExcelDriver();
		if (sDriver.IsEmpty())
		{
			// 没有发现Excel驱动
			AfxMessageBox("没有安装Excel!\n请先安装Excel软件才能使用导出功能!");
			return;
		}

		sExcelFile = "";
		sExcelFile = savepath;
		///默认文件名
		if (!GetDefaultXlsFileName(sExcelFile))
			return;

		// 创建进行存取的字符串
		sSql.Format("DRIVER={%s};DSN='';FIRSTROWHASNAMES=1;READONLY=FALSE;CREATE_DB=\"%s\";DBQ=%s", sDriver, sExcelFile, sExcelFile);

		// 创建数据库 (既Excel表格文件)
		if (database.OpenEx(sSql, CDatabase::noOdbcDialog))
		{
			// 创建表结构
			int i;
			LVCOLUMN columnData;
			CString columnName;
			int columnNum = 0;
			CString strH;
			CString strV;

			sSql = "";
			strH = "";
			columnData.mask = LVCF_TEXT;
			columnData.cchTextMax = 100;
			columnData.pszText = columnName.GetBuffer(100);

			{
				for (i = nColumn; pList->GetColumn(i, &columnData); i++)
				{
					if (i != nColumn)
					{
						sSql = sSql + ", ";
						strH = strH + ", ";
					}
					temp = columnData.pszText;
					temp.Replace("/", "");
					temp.Replace("(", "");
					temp.Replace(")", "");
					int countexist = FindArrayCount(&colarray, temp);
					if (countexist)
					{
						CString ss;
						ss.Format("%d", countexist + 1);

						sSql = sSql + " " + temp + ss + " TEXT";
						strH = strH + " " + temp + ss + " ";
						str = temp;
						str += ss;
						colarray.Add(str);
					}
					else
					{
						sSql = sSql + " " + temp + " TEXT";
						strH = strH + " " + temp + " ";
						colarray.Add(temp);
					}
				}
			}

			columnName.ReleaseBuffer();
			columnNum = i;

			sSql = "CREATE TABLE " + tableName + " ( " + sSql + " ) ";
			database.ExecuteSQL(sSql);

			// 插入数据项
			int nItemIndex;
			{
				for (nItemIndex = 0; nItemIndex < pList->GetItemCount(); nItemIndex++)
				{
					strV = "";
					for (i = nColumn; i < columnNum; i++)
					{
						if (i != nColumn)
						{
							strV = strV + ", ";
						}
						strV = strV + " '" + pList->GetItemText(nItemIndex, i) + "' ";
					}

					sSql = "INSERT INTO " + tableName
						+ " (" + strH + ")"
						+ " VALUES(" + strV + ")";

					database.ExecuteSQL(sSql);
				}
			}
		}

		// 关闭数据库
		database.Close();
		ShellExecute(NULL, _T("open"), sExcelFile, NULL, NULL, SW_SHOW);
	}
	else
		AfxMessageBox("表中没有数据!");
}

//%0.2f
void MySalary::OnBut3() // 导出按钮;
{
	ListToXLS(&m_List3, "c:\\工资表.xls", 0);
}