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

// OldClient.cpp : implementation file
//
#include "stdafx.h"
#include "ylgl.h"
#include "OldClient.h"
#include "MyMdi.H"
#include "ModifyDinDan.h"
#include "NeroDlg.h"
#include "ClientRequirement.h"
#include "./helper/ffsco.h"
#include "AddOldClient.h"
#include "AddOldClient2.h"
#include "SendMsgDlg.h"
#include "BasicExcelVC6.h"
#include "Lzari.h"
#include "SelExportType.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// OldClient
IMPLEMENT_DYNCREATE(OldClient, MyFormView)
OldClient::OldClient()
: MyFormView(OldClient::IDD)
{
	//{{AFX_DATA_INIT(OldClient)
	m_filter = _T("");
	//}}AFX_DATA_INIT
}

OldClient::~OldClient()
{
}

void OldClient::DoDataExchange(CDataExchange* pDX)
{
	MyFormView::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(OldClient)
	DDX_Control(pDX, IDC_COMBO1, m_combo1);
	DDX_Control(pDX, IDC_LIST2, m_List1);
	DDX_Control(pDX, IDC_STATIC1, m_static1);
	DDX_CBString(pDX, IDC_COMBO1, m_filter);
	//}}AFX_DATA_MAP
}

BEGIN_MESSAGE_MAP(OldClient, MyFormView)
	//{{AFX_MSG_MAP(OldClient)
	ON_BN_CLICKED(IDC_BUTclose, OnBUTclose)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	ON_CBN_SELCHANGE(IDC_COMBO1, OnSelchangeCombo1)
	ON_WM_TIMER()
	ON_BN_CLICKED(IDC_BUTburncd, OnBUTOldClient)
	ON_NOTIFY(NM_DBLCLK, IDC_LIST2, OnDblclkList2)
	ON_BN_CLICKED(IDC_BUTburncd2, OnBUTburncd2)
	ON_BN_CLICKED(IDC_BUTburncd3, OnBUTburncd3)
	ON_BN_CLICKED(IDC_BUTsendmsg, OnBUTsendmsg)
	ON_BN_CLICKED(IDC_BUTprint3, OnBUTprint3)
	ON_BN_CLICKED(IDC_BUTimport, OnBUTimport)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// OldClient diagnostics

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

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

/////////////////////////////////////////////////////////////////////////////
// OldClient message handlers

void OldClient::OnInitialUpdate()
{
	MyFormView::OnInitialUpdate();
	GetDlgItem(IDC_BUTburncd3)->EnableWindow(IsHasRights2new(49));
	GetDlgItem(IDC_BUTprint3)->EnableWindow(IsHasRights2new(49));
	// TODO: Add your specialized code here and/or call the base class
	CMyMdi Mdi;
	Mdi.SetSubView((CWnd*)GetParent(), (CWnd*)this);

	// Here we create the outbar control using the splitter as its parent
	// and setting its id to the first pane.
	CRect rc2;
	GetWindowRect(rc2);
	::MoveWindow(m_hWnd, g_rc.left, g_rc.top, g_rc.Width(), g_rc.Height(), TRUE);

	EnumChildWindows(m_hWnd, (WNDENUMPROC)EnumChildProc, 0);

	int idarray[] = { IDC_BUTburncd, IDC_BUTburncd2, IDC_BUTburncd3, IDC_BUTimport, IDC_BUTsendmsg, IDC_BUTprint3, IDC_BUTclose };
	int idcount = 7;
	int btnwid;
	CRect prerc;
	for (int a = idcount - 2; a >= 0; a--)
	{
		GetDlgItem(idarray[a + 1])->GetWindowRect(prerc);
		ScreenToClient(prerc);
		GetDlgItem(idarray[a])->GetWindowRect(rc2);
		ScreenToClient(rc2);
		btnwid = rc2.Width();
		rc2.right = prerc.left;
		rc2.left = rc2.right - btnwid;
		GetDlgItem(idarray[a])->MoveWindow(rc2);
	}


	m_static1.SetFont(&g_titlefont);
#ifdef CHILD_VERSION
	m_List1.SetHeadings("id,0;家长姓名,100;宝宝姓名,100;宝宝性别,100;电话,100;QQ,100;宝宝生日,100;套系,100;金额,100;订单日期,100;录入日期,100;录单,100");
#else
	m_List1.SetHeadings("id,0;男宾姓名,100;女宾姓名,100;男宾电话,100;女宾电话,100;男宾QQ,100;女宾QQ,100;男宾生日,100;女宾生日,100;婚期,100;套系,100;金额,100;订单日期,100;录入日期,100;录单,100" );
#endif

	m_List1.LoadColumnInfo(171);
	GetData();

	m_combo1.GetWindowRect(rc2);
	ScreenToClient(rc2);
	rc2.bottom += 200;
	m_combo1.MoveWindow(rc2);
	GetDlgItem(IDC_BUTclose)->GetWindowRect(rc2);
	SetComboHei(&m_combo1, rc2.Height());
}

void OldClient::FillGrid()
{
	m_List1.DeleteAllItems2();
	int ii = 0;
	m_List1.m_arLabels.SetSize(m_List1array.GetSize(), 1);
	int count = 0;

#ifdef CHILD_VERSION
	if (m_filter.IsEmpty())
	{
		for (ii = 0; ii < m_List1.m_arLabels.GetSize(); ii++)
		{
			m_List1.m_arLabels.ElementAt(count++).Copy(m_List1array.ElementAt(ii));
		}
	}
	else
	{
		int type = GetType(m_filter);
		if (type == 1)//电话
		{
			for (ii = 0; ii < m_List1.m_arLabels.GetSize(); ii++)
			{
				if (m_List1array.ElementAt(ii).ElementAt(4).Find(m_filter) != -1)
				{
					m_List1.m_arLabels.ElementAt(count++).Copy(m_List1array.ElementAt(ii));
				}
			}
		}
		else if (type == 2)//拼音
		{
			m_filter.MakeUpper();
			for (ii = 0; ii < m_List1.m_arLabels.GetSize(); ii++)
			{
				if (m_List1array.ElementAt(ii).ElementAt(12).Find(m_filter) != -1 || m_List1array.ElementAt(ii).ElementAt(13).Find(m_filter) != -1)
				{
					m_List1.m_arLabels.ElementAt(count++).Copy(m_List1array.ElementAt(ii));
				}
			}
		}
		else
		{
			for (ii = 0; ii < m_List1.m_arLabels.GetSize(); ii++)
			{
				if (m_List1array.ElementAt(ii).ElementAt(0).Find(m_filter) != -1 || \
					m_List1array.ElementAt(ii).ElementAt(1).Find(m_filter) != -1 || \
					m_List1array.ElementAt(ii).ElementAt(2).Find(m_filter) != -1 || \
					m_List1array.ElementAt(ii).ElementAt(3).Find(m_filter) != -1 || \
					m_List1array.ElementAt(ii).ElementAt(4).Find(m_filter) != -1 || \
					m_List1array.ElementAt(ii).ElementAt(5).Find(m_filter) != -1 || \
					m_List1array.ElementAt(ii).ElementAt(6).Find(m_filter) != -1 || \
					m_List1array.ElementAt(ii).ElementAt(7).Find(m_filter) != -1 || \
					m_List1array.ElementAt(ii).ElementAt(8).Find(m_filter) != -1 || \
					m_List1array.ElementAt(ii).ElementAt(9).Find(m_filter) != -1 || \
					m_List1array.ElementAt(ii).ElementAt(10).Find(m_filter) != -1 || \
					m_List1array.ElementAt(ii).ElementAt(11).Find(m_filter) != -1 || \
					m_List1array.ElementAt(ii).ElementAt(12).Find(m_filter) != -1)
				{
					m_List1.m_arLabels.ElementAt(count++).Copy(m_List1array.ElementAt(ii));
				}
			}
		}
	}
#else
	if(m_filter.IsEmpty ())
	{
		for(ii=0; ii<m_List1.m_arLabels.GetSize (); ii++)
		{
			m_List1.m_arLabels.ElementAt (count++).Copy (m_List1array.ElementAt (ii));
		}
	}
	else
	{ 
		int type=GetType(m_filter);
		if(type==1)//电话
		{
			for(ii=0; ii<m_List1.m_arLabels.GetSize (); ii++)
			{
				if(m_List1array.ElementAt (ii).ElementAt (3).Find (m_filter)!=-1 || m_List1array.ElementAt (ii).ElementAt (4).Find (m_filter)!=-1)
				{
					m_List1.m_arLabels.ElementAt (count++).Copy (m_List1array.ElementAt (ii));
				}
			}
		}
		else if(type==2)//拼音
		{
			m_filter.MakeUpper ();
			for(ii=0; ii<m_List1.m_arLabels.GetSize (); ii++)
			{
				if(m_List1array.ElementAt (ii).ElementAt (15).Find (m_filter)!=-1 || m_List1array.ElementAt (ii).ElementAt (16).Find (m_filter)!=-1)
				{
					m_List1.m_arLabels.ElementAt (count++).Copy (m_List1array.ElementAt (ii));
				}
			}
		}
		else
		{
			for(ii=0; ii<m_List1.m_arLabels.GetSize (); ii++)
			{
				if(m_List1array.ElementAt (ii).ElementAt (0).Find (m_filter)!=-1 ||\
					m_List1array.ElementAt (ii).ElementAt (1).Find (m_filter)!=-1 || \
					m_List1array.ElementAt (ii).ElementAt (2).Find (m_filter)!=-1 || \
					m_List1array.ElementAt (ii).ElementAt (3).Find (m_filter)!=-1|| \
					m_List1array.ElementAt (ii).ElementAt (4).Find (m_filter)!=-1|| \
					m_List1array.ElementAt (ii).ElementAt (5).Find (m_filter)!=-1 || \
					m_List1array.ElementAt (ii).ElementAt (6).Find (m_filter)!=-1 || \
					m_List1array.ElementAt (ii).ElementAt (7).Find (m_filter)!=-1 || \
					m_List1array.ElementAt (ii).ElementAt (8).Find (m_filter)!=-1|| \
					m_List1array.ElementAt (ii).ElementAt (9).Find (m_filter)!=-1 || \
					m_List1array.ElementAt (ii).ElementAt (10).Find (m_filter)!=-1 || \
					m_List1array.ElementAt (ii).ElementAt (11).Find (m_filter)!=-1 || \
					m_List1array.ElementAt (ii).ElementAt (12).Find (m_filter)!=-1 || \
					m_List1array.ElementAt (ii).ElementAt (13).Find (m_filter)!=-1 || \
					m_List1array.ElementAt (ii).ElementAt (14).Find (m_filter)!=-1 )
				{
					m_List1.m_arLabels.ElementAt (count++).Copy (m_List1array.ElementAt (ii));
				}
			}
		}
	}
#endif
	m_List1.m_arLabels.SetSize(count, 1);
	ii = count;
	m_List1.m_LabelCount = ii;
	m_List1.SetItemCountEx(ii);
	CString str;
	str.Format("客人:%d", ii);
	SetDlgItemText(IDC_STATIC2, str);

	CRect rc;
	GetDlgItem(IDC_STATIC2)->GetWindowRect(rc);
	ScreenToClient(rc);
	InvalidateRect(rc);
}

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


void OldClient::OnSelchangeCombo1()
{
	// TODO: Add your control notification handler code here
	SetTimer(1, 100, NULL);
}

void OldClient::OnTimer(UINT nIDEvent)
{
	// TODO: Add your message handler code here and/or call default
	KillTimer(nIDEvent);
	OnButton1();
}

BOOL OldClient::PreTranslateMessage(MSG* pMsg)
{
	// TODO: Add your specialized code here and/or call the base class
	try
	{
		if (pMsg->message == WM_KEYDOWN)
		{
			switch (pMsg->wParam)
			{
			case VK_RETURN:
				OnButton1();
				return 1;
			case 0x43: // copy
				if ((GetKeyState(VK_CONTROL) & 0x80))
				{
					GetFocus()->SendMessage(WM_COPY);
					return TRUE;
				}
				break;
			case 0x56: //Ctrl + V:
				if ((GetKeyState(VK_CONTROL) & 0x80))
				{
					GetFocus()->SendMessage(WM_PASTE);
					return TRUE;
				}
				break;
			case 0x58: // cut
				if ((GetKeyState(VK_CONTROL) & 0x80))
				{
					GetFocus()->SendMessage(WM_CUT);
					return TRUE;
				}
				break;
			case 0x5A: //undo
			case 0x59: //redo
				if ((GetKeyState(VK_CONTROL) & 0x80))
				{
					GetFocus()->SendMessage(WM_UNDO);
					return TRUE;
				}
				break;
			}
		}
		return MyFormView::PreTranslateMessage(pMsg);
	}
	catch (...)
	{
	}

	return TRUE;
}

void OldClient::OnButton1()
{
	// TODO: Add your control notification handler code here
	UpdateData();
	m_filter.TrimLeft();
	m_filter.TrimRight();
	FillGrid();
}
void OldClient::OnBUTOldClient()
{
	// TODO: Add your control notification handler code here
#ifdef CHILD_VERSION
	AddOldClient2 dlg;
#else
	AddOldClient dlg;
#endif
	if (dlg.DoModal() == IDOK)GetData();
}

void OldClient::OnDblclkList2(NMHDR* pNMHDR, LRESULT* pResult)
{
	// TODO: Add your control notification handler code here
	POSITION pos;
	pos = m_List1.GetFirstSelectedItemPosition();
	if (pos == NULL)return;
	OnBUTburncd2();
	*pResult = 0;
}

void OldClient::OnBUTburncd2()	// 修改客户信息;
{
	// TODO: Add your control notification handler code here
	POSITION pos;
	pos = m_List1.GetFirstSelectedItemPosition();
	if (pos == NULL)
	{
		AfxMessageBox("请先选中您要修改的客户!", MB_ICONINFORMATION);
		return;
	}
	int iItem = m_List1.GetNextSelectedItem(pos);
#ifdef CHILD_VERSION
	AddOldClient2 dlg;
#else
	AddOldClient dlg;
#endif
	dlg.m_bAdd = 0;
	dlg.id = m_List1.GetItemText(iItem, 0);
	if (dlg.DoModal() == IDOK)GetData();
}

void OldClient::OnBUTburncd3()
{
	// TODO: Add your control notification handler code here
	POSITION pos;
	pos = m_List1.GetFirstSelectedItemPosition();
	if (pos == NULL)
	{
		AfxMessageBox("请先选中您要删除的客户!", MB_ICONINFORMATION);
		return;
	}
	int iItem = m_List1.GetNextSelectedItem(pos);
	CString id = m_List1.GetItemText(iItem, 0);

	if (AfxMessageBox("确认删除吗?", MB_YESNO | MB_ICONINFORMATION) != IDYES)return;

	CString sql;
	sql.Format("delete from client3 where id=%d ", atoi(id));
	g_sendhead.bsql = 1;
	g_pMainWnd->ProcessChatMessageRequest2(sql); if (g_bSendOK == 0)return;

	GetData();

}

void OldClient::OnBUTsendmsg()
{
	// TODO: Add your control notification handler code here
	POSITION pos;
	pos = m_List1.GetFirstSelectedItemPosition();
	if (pos == NULL)
	{
		AfxMessageBox("请先选中您要发送短信的客人!", MB_ICONINFORMATION);
		return;
	}
	int iItem;
	CStringArray array;
	while (pos)
	{
		iItem = m_List1.GetNextSelectedItem(pos);
#ifndef CHILD_VERSION
		if(!m_List1.GetItemText (iItem,  3).IsEmpty ())
			array.Add (m_List1.GetItemText (iItem,  3));
#endif
		if (!m_List1.GetItemText(iItem, 4).IsEmpty())
			array.Add(m_List1.GetItemText(iItem, 4));

	}
	SendMsgDlg dlg;
	dlg.m_mode = 2;
	dlg.m_pArray = &array;
	dlg.DoModal();
}

void OldClient::OnBUTprint3()		// 按钮：导出按钮;
{
	// TODO: Add your control notification handler code here
	SelExportType dlg;
	if (dlg.DoModal() != IDOK)return;
	if (dlg.m_type == 1)
	{
		ListToXLS(&m_List1, "c:\\客户资料.xls", 0);
		return;
	}

#ifdef CHILD_VERSION
	CStdioFile fp;
	fp.Open("c:\\clientphone.txt", CFile::modeCreate | CFile::modeWrite);
	CString str;
	CString str1, str2, str3, str4, str5, str6, str7, str8, str9, str10, str11;
	CString phone;
	CString txname, txprice, mensi;

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


	str1 = "家长姓名";
	str2 = "宝宝姓名";
	str3 = "宝宝性别";
	str4 = "电话";
	str5 = "QQ";
	str6 = "宝宝生日";
	str7 = "套系";
	str8 = "金额";
	str9 = "订单日期";

	FillLength(str1, leng1);
	FillLength(str2, leng2);
	FillLength(str3, leng3);
	FillLength(str4, leng4);
	FillLength(str5, leng5);
	FillLength(str6, leng6);
	FillLength(str7, leng7);
	FillLength(str8, leng8);
	FillLength(str9, leng9);
	str = str1 + str2 + str3 + str4 + str5 + str6 + str7 + str8 + str9 + "\n";
	fp.WriteString(str);


	for (int i = 0; i < m_List1.GetItemCount(); i++)
	{
		str1 = m_List1.GetItemText(i, 1);
		str2 = m_List1.GetItemText(i, 2);
		str3 = m_List1.GetItemText(i, 3);
		str4 = m_List1.GetItemText(i, 4);
		str5 = m_List1.GetItemText(i, 5);
		str6 = m_List1.GetItemText(i, 6);
		str7 = m_List1.GetItemText(i, 7);
		str8 = m_List1.GetItemText(i, 8);
		str9 = m_List1.GetItemText(i, 9);

		FillLength(str1, leng1);
		FillLength(str2, leng2);
		FillLength(str3, leng3);
		FillLength(str4, leng4);
		FillLength(str5, leng5);
		FillLength(str6, leng6);
		FillLength(str7, leng7);
		FillLength(str8, leng8);
		FillLength(str9, leng9);
		str = str1 + str2 + str3 + str4 + str5 + str6 + str7 + str8 + str9 + "\n";
		fp.WriteString(str);

	}

	fp.Close();
	MessageBox("电话已保存到c:\\clientphone.txt");
	ShellExecute(NULL, _T("open"), _T("c:\\clientphone.txt"), NULL, NULL, SW_SHOWMAXIMIZED);
#else
	CStdioFile fp;
	fp.Open ("c:\\clientphone.txt", CFile::modeCreate|CFile::modeWrite);
	CString str;
	CString str1,str2,str3,str4,str5,str6,str7,str8,str9,str10,str11;
	CString phone;
	CString txname,txprice,mensi;

	int leng1=10;
	int leng2=10;
	int leng3=18;
	int leng4=18;
	int leng5=15;
	int leng6=15;
	int leng7=15;
	int leng8=15;
	int leng9=15;
	int leng10=15;
	int leng11=15;

	str1="男宾";
	str2="女宾";
	str3="男宾电话";
	str4="女宾电话";
	str5="男宾QQ";
	str6="女宾QQ";
	str7="男宾生日";
	str8="女宾生日";
	str9="婚期";
	str10="套系";
	str11="金额";

	FillLength(str1, leng1);
	FillLength(str2, leng2);
	FillLength(str3, leng3);
	FillLength(str4, leng4);
	FillLength(str5, leng5);
	FillLength(str6, leng6);
	FillLength(str7, leng7);
	FillLength(str8, leng8);
	FillLength(str9, leng9);
	FillLength(str10,leng10);
	FillLength(str11,leng11);

	str=str1+str2+str3+str4+str5+str6+str7+str8+str9+str10+str11+"\n";
	fp.WriteString (str);

	for(int i=0; i<m_List1.GetItemCount (); i++)
	{
		str1=m_List1.GetItemText (i, 1);
		str2=m_List1.GetItemText (i, 2);
		str3=m_List1.GetItemText (i, 3);
		str4=m_List1.GetItemText (i, 4);
		str5=m_List1.GetItemText (i, 5);
		str6=m_List1.GetItemText (i, 6);
		str7=m_List1.GetItemText (i, 7);
		str8=m_List1.GetItemText (i, 8);
		str9=m_List1.GetItemText (i, 9);
		str10=m_List1.GetItemText (i, 10);
		str11=m_List1.GetItemText (i, 11);

		FillLength(str1, leng1);
		FillLength(str2, leng2);
		FillLength(str3, leng3);
		FillLength(str4, leng4);
		FillLength(str5, leng5);
		FillLength(str6, leng6);
		FillLength(str7, leng7);
		FillLength(str8, leng8);
		FillLength(str9, leng9);
		FillLength(str10,leng10);
		FillLength(str11,leng11);

		str=str1+str2+str3+str4+str5+str6+str7+str8+str9+str10+str11+"\n";
		fp.WriteString (str);
	}

	fp.Close ();
	MessageBox("电话已保存到c:\\clientphone.txt");
	ShellExecute(NULL, _T("open"), _T("c:\\clientphone.txt"), NULL, NULL, SW_SHOWMAXIMIZED); 
#endif
}

void OldClient::GetData()
{
	g_sendhead.bsql = 0;
	g_sendhead.code[0] = 138;
	g_sendhead.tabcount = 1;
	g_pMainWnd->ProcessChatMessageRequest2(1); if (g_bSendOK == 0)return;

	DataToArray(&m_List1array);








	HidePrice();
	FillGrid();
}

void CheckDate(CString &date)
{
	date.Replace("\\", "-");
	date.Replace("/", "-");
	int pos = date.Find("-");
	if (pos == -1)
	{
		date = "";
		return;
	}
	if (pos < 4)
	{
		date = "";
		return;
	}
	CString year = date.Left(4);
	date = date.Right(date.GetLength() - pos - 1);

	pos = date.Find("-");
	if (pos == -1)
	{
		date = "";
		return;
	}

	CString month = date.Left(pos);
	CString day = date.Right(date.GetLength() - pos - 1);

	date.Format("%d-%02d-%02d", atoi(year), atoi(month), atoi(day));
}

void OldClient::OnBUTimport() // Jeff.导入按钮;
{
#ifdef CHILD_VERSION
	OnBUTimport2();
	return;
#endif
	using namespace YExcel;
	// TODO: Add your control notification handler code here
	BasicExcel e;
	CFileDialog fdlg(true, NULL, "", OFN_HIDEREADONLY, "Excel files(*.xls)|*.xls||");
	if (fdlg.DoModal() != IDOK)return;
	CString path = fdlg.GetPathName();

	e.Load(path);
	BasicExcelWorksheet* sheet1 = e.GetWorksheet("Sheet1");
	if (sheet1)
	{
		size_t maxRows = sheet1->GetTotalRows();
		size_t maxCols = sheet1->GetTotalCols();
		if (maxCols > 12)maxCols = 12;
		if (maxCols < 12)
		{
			AfxMessageBox("格式不对:缺少项目!"); return;
		}
		if (maxRows < 2)
		{
			AfxMessageBox("没有资料!"); return;
		}

		CStringArray array;
		for (size_t r = 0; r < maxRows; ++r)
		{
			for (size_t c = 0; c < maxCols; ++c)
			{
				BasicExcelCell* cell = sheet1->Cell(r, c);
				switch (cell->Type())
				{
				case BasicExcelCell::STRING:
					array.Add(cell->GetString());
					break;
				case BasicExcelCell::WSTRING:
				{
					int leng = wcslen(cell->GetWString());
					char* ppszA = new char[2 * leng + 1];
					memset(ppszA, 0, 2 * leng + 1);
					WideCharToMultiByte(CP_ACP, 0, cell->GetWString(), -1, ppszA, leng * 2, NULL, NULL);
					CString str = ppszA; str.TrimLeft(); str.TrimRight();
					array.Add(str);
					delete[]ppszA;
				}
					break;
				default:
					array.Add("");
				}
			}
			if (r == 0)
			{
				if (array.GetSize() != maxCols)
				{
					AfxMessageBox("资料读取错误"); return;
				}
				if (array.ElementAt(0) != "订单日期")
				{
					AfxMessageBox("格式错误2"); return;
				}
				array.RemoveAll();
			}
		}
		///////////////////////	
		CString sql, temp;
		CString m_name1, m_name2, strRes1, strRes2;
		CString m_date, m_phone1, m_phone2, m_qq1, m_qq2, m_taoxiname, m_taoxijiage, m_time3, m_birthday1, m_birthday2;
		int count = 0;
		for (int i = 0; i < array.GetSize(); i += 12)
		{
			m_date = array.ElementAt(i + 0);
			m_name1 = array.ElementAt(i + 1);
			m_birthday1 = array.ElementAt(i + 2);
			m_qq1 = array.ElementAt(i + 3);
			m_phone1 = array.ElementAt(i + 4);
			m_name2 = array.ElementAt(i + 5);
			m_birthday2 = array.ElementAt(i + 6);
			m_qq2 = array.ElementAt(i + 7);
			m_phone2 = array.ElementAt(i + 8);
			m_time3 = array.ElementAt(i + 9);
			m_taoxiname = array.ElementAt(i + 10);
			m_taoxijiage = array.ElementAt(i + 11);
			CheckDate(m_time3);

			CheckDate(m_date);
			CheckDate(m_birthday1);
			CheckDate(m_birthday2);

			ChinesePinYin::GetFirstLetter(m_name1, strRes1);
			ChinesePinYin::GetFirstLetter(m_name2, strRes2);
			if (m_name1.IsEmpty() && m_name2.IsEmpty())continue;
			if (CheckExist(m_name1, m_name2, m_phone1, m_phone2))continue;
			temp.Format("insert into [client3]([name],[name2],[phone],[phone2],[qq],[qq2],[birthday],[birthday2],[time3],[pinyin],[pinyin2],[date],[ren],[dandate],[taoxiname],[taoxijiage])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')", m_name1, m_name2, m_phone1, m_phone2, m_qq1, m_qq2, m_birthday1, m_birthday2, m_time3, strRes1, strRes2, g_date, g_user.name, m_date, m_taoxiname, m_taoxijiage);
			sql += temp;
			sql += "***";
			count++;
			if (count == 10)
			{
				sql.TrimRight("***");
				g_sendhead.bsql = 1;
				g_pMainWnd->ProcessChatMessageRequest2(sql);
				if (g_bSendOK == 0)
				{
					AfxMessageBox("保存过程中出现错误!");
					return;
				}
				sql.Empty(); count = 0; GetData();
			}
		}
		/////////////////////////////////////
		if (!sql.IsEmpty())
		{
			sql.TrimRight("***");
			g_sendhead.bsql = 1;
			g_pMainWnd->ProcessChatMessageRequest2(sql);
			if (g_bSendOK == 0)
			{
				AfxMessageBox("保存过程中出现错误!");
				return;
			}
			sql.Empty(); count = 0; GetData();
		}
		///////////////////////
	}
	else
		AfxMessageBox("格式错误，或文件未关闭!!");
}

BOOL OldClient::CheckExist(CString m_name1, CString m_name2, CString m_phone1, CString m_phone2)
{
#ifdef CHILD_VERSION
	for (int i = 0; i < m_List1array.GetSize(); i++)
	{
		if (m_List1array.ElementAt(i).ElementAt(1) == m_name1 && m_List1array.ElementAt(i).ElementAt(2) == m_name2\
			&& m_List1array.ElementAt(i).ElementAt(4) == m_phone1)return 1;
	}
#else
	for(int i=0; i<m_List1array.GetSize (); i++)
	{
		if(m_List1array.ElementAt (i).ElementAt (1)==m_name1 && m_List1array.ElementAt (i).ElementAt (2)==m_name2\
			&& (m_List1array.ElementAt (i).ElementAt (3)==m_phone1 || m_List1array.ElementAt (i).ElementAt (4)==m_phone2) )return 1;
	}
#endif
	return 0;
}

void OldClient::OnBUTimport2()	// 儿童版导入客户资料;
{
	using namespace YExcel;
	// TODO: Add your control notification handler code here
	BasicExcel e;
	CFileDialog fdlg(true, NULL, "", OFN_HIDEREADONLY, "Excel files(*.xls)|*.xls||");
	if (fdlg.DoModal() != IDOK)return;
	CString path = fdlg.GetPathName();

	e.Load(path);
	BasicExcelWorksheet* sheet1 = e.GetWorksheet("Sheet1");
	if (sheet1)
	{
		size_t maxRows = sheet1->GetTotalRows();
		size_t maxCols = sheet1->GetTotalCols();
		if (maxCols > 9)maxCols = 9;
		if (maxCols < 9)
		{
			AfxMessageBox("格式不对:缺少项目!"); return;
		}
		if (maxRows < 2)
		{
			AfxMessageBox("没有资料!"); return;
		}

		CStringArray array;
		for (size_t r = 0; r < maxRows; ++r)
		{
			for (size_t c = 0; c < maxCols; ++c)
			{
				BasicExcelCell* cell = sheet1->Cell(r, c);
				switch (cell->Type())
				{
				case BasicExcelCell::STRING:
					array.Add(cell->GetString());
					break;
				case BasicExcelCell::WSTRING:
				{
					int leng = wcslen(cell->GetWString());
					char* ppszA = new char[2 * leng + 1];
					memset(ppszA, 0, 2 * leng + 1);
					WideCharToMultiByte(CP_ACP, 0, cell->GetWString(), -1, ppszA, leng * 2, NULL, NULL);
					CString str = ppszA; str.TrimLeft(); str.TrimRight();
					array.Add(str);
					delete[]ppszA;
				}
					break;
				default:
					array.Add("");
				}
			}
			if (r == 0)
			{
				if (array.GetSize() != maxCols)
				{
					AfxMessageBox("资料读取错误"); return;
				}
				if (array.ElementAt(0) != "订单日期")
				{
					AfxMessageBox("格式错误2"); return;
				}
				array.RemoveAll();
			}
		}
		///////////////////////	
		CString sql, temp;
		CString m_name1, m_name2, strRes1, strRes2;
		CString m_date, m_phone1, m_qq1, m_taoxiname, m_taoxijiage, m_birthday1, m_sex;
		int count = 0;
		for (int i = 0; i < array.GetSize(); i += 9)
		{
			m_date = array.ElementAt(i + 0);
			m_name2 = array.ElementAt(i + 1);
			m_name1 = array.ElementAt(i + 2);
			m_phone1 = array.ElementAt(i + 3);
			m_qq1 = array.ElementAt(i + 4);
			m_taoxiname = array.ElementAt(i + 5);
			m_taoxijiage = array.ElementAt(i + 6);
			m_birthday1 = array.ElementAt(i + 7);
			CheckDate(m_birthday1);
			CheckDate(m_date);

			m_sex = array.ElementAt(i + 8);
			ChinesePinYin::GetFirstLetter(m_name1, strRes1);
			ChinesePinYin::GetFirstLetter(m_name2, strRes2);
			if (m_name1.IsEmpty() && m_name2.IsEmpty())continue;
			if (CheckExist(m_name1, m_name2, m_phone1, ""))continue;
			temp.Format("insert into [client3]([name],[name2],[phone],[qq],[birthday],[sex],[pinyin],[pinyin2],[date],[ren],[dandate],[taoxiname],[taoxijiage])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')", m_name1, m_name2, m_phone1, m_qq1, m_birthday1, m_sex, strRes1, strRes2, g_date, g_user.name, m_date, m_taoxiname, m_taoxijiage);
			sql += temp;
			sql += "***";
			count++;
			if (count == 10)
			{
				sql.TrimRight("***");
				g_sendhead.bsql = 1;
				g_pMainWnd->ProcessChatMessageRequest2(sql);
				if (g_bSendOK == 0)
				{
					AfxMessageBox("保存过程中出现错误!");
					return;
				}
				sql.Empty(); count = 0; GetData();
			}
			::Sleep(1000);
		}
		/////////////////////////////////////
		if (!sql.IsEmpty())
		{
			sql.TrimRight("***");
			g_sendhead.bsql = 1;
			g_pMainWnd->ProcessChatMessageRequest2(sql);
			if (g_bSendOK == 0)
			{
				AfxMessageBox("保存过程中出现错误!");
				return;
			}
			sql.Empty(); count = 0; GetData();
		}
		///////////////////////
	}
	else
		AfxMessageBox("格式错误，或文件未关闭!!");
}

void OldClient::HidePrice()
{
#ifdef LKAY_VERSION
	if(IsHasRights2new(31))return;
	for(int i=0; i<	m_List1array.GetSize (); i++)
	{
		m_List1array.ElementAt (i).SetAt (5, "***");
		m_List1array.ElementAt (i).SetAt (4, "***");
		m_List1array.ElementAt (i).SetAt (8, "***");
		m_List1array.ElementAt (i).SetAt (7, "***");
	}
#else
	if (IsHasRights2new(31))return;

#ifdef CHILD_VERSION
	for (int i = 0; i < m_List1array.GetSize(); i++)
	{
		m_List1array.ElementAt(i).SetAt(4, "***");
		m_List1array.ElementAt(i).SetAt(5, "***");
	}
#else
	for(int i=0; i<	m_List1array.GetSize (); i++)
	{
		m_List1array.ElementAt (i).SetAt (3, "***");
		m_List1array.ElementAt (i).SetAt (4, "***");
		m_List1array.ElementAt (i).SetAt (5, "***");
		m_List1array.ElementAt (i).SetAt (6, "***");
	}
#endif

#endif
}