// TakeFrom.cpp : implementation file
//
#include "stdafx.h"
#include "LYFZSendMsg.h"
#include "TakeFrom.h"
#include "MyMdi.H"

#include "InputPsw.h"
#include "InputPsw2.h"
#include "SetPathDlg.h"
#include "mysqldata.h"
#include "InputPsw.h"
#include "ReCharge.h"
#include "ShowHistoryReg.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
#pragma comment(lib, "Shlwapi.lib")
/////////////////////////////////////////////////////////////////////////////
// TakeFrom IDC_STATIC2

IMPLEMENT_DYNCREATE(TakeFrom, CFormView)
TakeFrom::TakeFrom()
: CFormView(TakeFrom::IDD)
{
	//{{AFX_DATA_INIT(TakeFrom)
	m_filter = _T("");
	//}}AFX_DATA_INIT
}

TakeFrom::~TakeFrom()
{
}

void TakeFrom::DoDataExchange(CDataExchange* pDX)
{
	CFormView::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(TakeFrom)
	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(TakeFrom, CFormView)
	//{{AFX_MSG_MAP(TakeFrom)
	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_BUTimportphoto, OnBUTimportphoto)
	ON_BN_CLICKED(IDC_BUTshowphoto, OnBUTshowphoto)
	ON_BN_CLICKED(IDC_BUTmoney, OnBUTmoney)
	ON_BN_CLICKED(IDC_BTNaddsp, OnBTNaddsp)
	ON_NOTIFY(LVN_ITEMCHANGED, IDC_LIST2, OnItemchangedList2)
	ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
	ON_NOTIFY(NM_DBLCLK, IDC_LIST2, OnDblclkList2)
	ON_BN_CLICKED(IDC_BUTimportphoto2, OnBUTimportphoto2)
	ON_BN_CLICKED(IDC_BUTTON3, OnButton3)
	ON_BN_CLICKED(IDC_BTNaddsp2, OnBTNaddsp2)
	ON_BN_CLICKED(IDC_BTNaddsp3, OnBTNaddsp3)
	ON_BN_CLICKED(IDC_BTNaddsp4, OnBTNaddsp4)
	ON_BN_CLICKED(IDC_BUTimportphoto4, OnBnClickedButimportphoto4)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// TakeFrom diagnostics

#ifdef _DEBUG
void TakeFrom::AssertValid() const
{
	CFormView::AssertValid();
}

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

/////////////////////////////////////////////////////////////////////////////
// TakeFrom message handlers

void TakeFrom::OnInitialUpdate() 
{
	CFormView::OnInitialUpdate();
	// TODO: Add your specialized code here and/or call the base class
	CMyMdi Mdi;
	Mdi.SetSubView((CWnd*)GetParent(), (CWnd*)this);

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

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

	m_static1.SetFont (&g_titlefont);
	m_List1.SetHeadings("账号,100;余额(可发短信数),160;已发,100;客人姓名,100;电话,100;QQ,100;地址,100;备注,100;申请日期,100;签名,100;通道2,100;签名长度,100" );
	m_List1.LoadColumnInfo ("114");

	m_combo1.GetWindowRect (rc2);
	ScreenToClient(rc2);
	rc2.bottom +=200;
	m_combo1.MoveWindow (rc2); 

	OnButton1();
}

void TakeFrom::FillGrid(BOOL bStatus)
{
	m_List1.DeleteAllItems2 ();
	int ii=0;
	m_List1.m_arLabels.SetSize( m_List1array.GetSize (), 1 );
	int count=0;
	if(bStatus)
	{
		for(ii=0; ii<m_List1.m_arLabels.GetSize (); ii++)
		{
			if(atoi(m_List1array.ElementAt (ii).ElementAt (11))>6)
			{
				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
		{
			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_List1.m_arLabels.ElementAt (count++).Copy (m_List1array.ElementAt (ii));
				}
			}
		}
	}

	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);
}

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

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

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


BOOL TakeFrom::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 CFormView::PreTranslateMessage(pMsg);
	}
	catch(...)
	{
	}
}

extern int GetBalance(CString account);
void TakeFrom::OnBUTmoney() 
{
	// TODO: Add your control notification handler code here
	POSITION pos;
	pos=m_List1.GetFirstSelectedItemPosition();	
	if(pos==NULL)
	{
		return;
	}
	int iItem=m_List1.GetNextSelectedItem(pos);	
	CString account=m_List1.GetItemText (iItem, 0); 
	int balance=GetBalance(account);
	CString str;
	str.Format ("账号%s: 余额:%d", account, balance);
	MessageBox(str);
}

void TakeFrom::OnBTNaddsp() 
{
	InputPsw2 dlg;
	if(dlg.DoModal()!=IDOK)return;
	g_db.SetQueryTimeout(60*10);
	for(int i=0; i<m_List1.GetItemCount (); i++)
	{
		CString account=m_List1.GetItemText (i, 0);
		if(account.GetLength ()!=6)continue;
		CString count2="";
		CRecordset myset(&g_db);
#ifdef SQLSERVER_VERSION
		CString sql="select sum(cast([msgcount] as float)) as cot from sendreg where account='"+account+"' ";
#else
		CString sql="select sum([msgcount]) as cot from sendreg where account='"+account+"' ";
#endif

		myset.Open (CRecordset::forwardOnly, sql);
		if(!myset.IsEOF())
			myset.GetFieldValue ("cot", count2);
		myset.Close();

		CString timestamp=CTime::GetCurrentTime ().Format ("%Y%m%d%H%M%S"); 

		sql="delete from sendreg where [account]='"+account+"' ";
		MyExecuteSQL(&g_db, sql);

		sql=count2;
		count2.Format ("%d", atoi(sql));
		if(atoi(count2))
		{
			sql="insert into sendreg([account],[phones],[content],[timestamp],[log],[msgcount],[msgcount2]) values\
				('"+account+"','汇总','汇总','"+timestamp+"','"+timestamp+"','"+count2+"','"+count2+"')";
			MyExecuteSQL(&g_db, sql);
		}
	}	g_db.SetQueryTimeout(60*2);
}

void TakeFrom::OnItemchangedList2(NMHDR* pNMHDR, LRESULT* pResult) 
{
	NM_LISTVIEW* pNMListView = (NM_LISTVIEW*)pNMHDR;
	// TODO: Add your control notification handler code here


	*pResult = 0;
}
extern void ConvertToPrice(CString &str);
CString GetLengthEx(CString str)
{
	wchar_t   wstr[500];
	int   k   =   MultiByteToWideChar(CP_ACP,   MB_PRECOMPOSED,   str,   strlen(str),   wstr,   500); 
	str.Format ("%d", k-2);
	return str;
}
void TakeFrom::OnButton1() 
{
	// TODO: Add your control notification handler code here
	DWORD ii=0;
	if(1)
	{
		MyLock lock("xiaoaccessdbmsg");
		CRecordset myset(&g_db);
		CString	sql="select count(*) as cot from clientinfo"; 
		myset.Open (CRecordset::forwardOnly, sql);
		myset.GetFieldValue ("cot", sql);
		myset.Close();
		m_List1array.SetSize(atol(sql) , 1 );
		CRstClientInfo rsSt;
		rsSt.Open();

		while(!rsSt.IsEOF())
		{
			m_List1array.ElementAt (ii).RemoveAll ();
			m_List1array.ElementAt (ii).Add(rsSt.m_account) ;
			m_List1array.ElementAt (ii).Add(rsSt.m_balance) ;
			m_List1array.ElementAt (ii).Add(rsSt.m_name) ;
			m_List1array.ElementAt (ii).Add(rsSt.m_phone) ;
			m_List1array.ElementAt (ii).Add(rsSt.m_qq) ;
			m_List1array.ElementAt (ii).Add(rsSt.m_addr) ;
			m_List1array.ElementAt (ii).Add(rsSt.m_remark) ;
			m_List1array.ElementAt (ii).Add(rsSt.m_applydate) ;
			m_List1array.ElementAt (ii).Add(rsSt.m_signname) ;
			m_List1array.ElementAt (ii).Add(rsSt.m_road) ;
			m_List1array.ElementAt (ii).Add(GetLengthEx(rsSt.m_signname)) ;
			ii++;
			rsSt.MoveNext();if(m_List1array.GetSize ()<=ii)break;
		}
		rsSt.Close();m_List1array.SetSize(ii+1 , 1 );
	}


	int sumcount1=0;
	int sumcount2=0;
	for(int i=0; i<m_List1array.GetSize ()-1; i++)
	{
		/*	CString account=m_List1array.ElementAt (i).ElementAt (0);
		CRecordset myset(&g_db);
		CString sql="select sum([msgcount]) as cot from sendreg where account='"+account+"'"; 
		myset.Open (CRecordset::forwardOnly, sql);
		if(!myset.IsEOF())
		myset.GetFieldValue ("cot", sql);
		myset.Close();
		ConvertToPrice(sql);
		if(sql.IsEmpty ())sql="0";*/
		m_List1array.ElementAt (i).InsertAt (2, "");
		sumcount1+=atoi(m_List1array.ElementAt (i).ElementAt (1));
		//	sumcount2+=atoi(sql);
		sumcount2+=0;
	}
	CString str;
	m_List1array.ElementAt (ii).RemoveAll ();
	m_List1array.ElementAt (ii).Add("") ;
	str.Format("%d", sumcount1);
	m_List1array.ElementAt (ii).Add(str) ;
	str.Format("%d", sumcount2);
	m_List1array.ElementAt (ii).Add(str) ;
	m_List1array.ElementAt (ii).Add("") ;
	m_List1array.ElementAt (ii).Add("") ;
	m_List1array.ElementAt (ii).Add("") ;
	m_List1array.ElementAt (ii).Add("") ;
	m_List1array.ElementAt (ii).Add("") ;
	m_List1array.ElementAt (ii).Add("") ;
	m_List1array.ElementAt (ii).Add("") ;
	m_List1array.ElementAt (ii).Add("") ;
	m_List1array.ElementAt (ii).Add("") ;
	m_List1array.ElementAt (ii).Add("") ;
	m_List1array.ElementAt (ii).Add("") ;
	m_List1array.ElementAt (ii).Add("") ;
	UpdateData();
	m_filter.TrimLeft ();
	m_filter.TrimRight ();
	FillGrid();
}


void TakeFrom::OnBUTshowphoto() //历史冲值
{
	POSITION pos;
	pos=m_List1.GetFirstSelectedItemPosition();	
	if(pos==NULL)
	{
		AfxMessageBox("请先选中您要查看冲值记录的客户!", MB_ICONINFORMATION);
		return;
	}
	int iItem=m_List1.GetNextSelectedItem(pos);	
	CString account=m_List1.GetItemText (iItem, 0);

	ShowHistoryReg dlg;
	dlg.m_account=account;
	dlg.DoModal ();
}

void TakeFrom::OnDblclkList2(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	POSITION pos;
	pos=m_List1.GetFirstSelectedItemPosition();	
	if(pos==NULL)
	{
		return;
	}
	int iItem=m_List1.GetNextSelectedItem(pos);	
	CString account=m_List1.GetItemText (iItem, 0);
	SetPathDlg dlg;
	dlg.m_mode =1;
	dlg.m_account =account;
	if(dlg.DoModal ()==IDOK)	
	{
		MessageBox("修改成功，请手动刷新数据");
		// OnButton1();
	}
	*pResult = 0;
}

void TakeFrom::OnBUTimportphoto() //添加客户
{
	// TODO: Add your control notification handler code here
	InputPsw dlg2;
	if(dlg2.DoModal()!=IDOK)return;
	SetPathDlg dlg;
	if(dlg.DoModal ()==IDOK)	
		OnButton1();
}

void TakeFrom::OnBUTimportphoto2() //冲值
{
	// TODO: Add your control notification handler code here
	POSITION pos;
	pos=m_List1.GetFirstSelectedItemPosition();	
	if(pos==NULL)
	{
		AfxMessageBox("请先选中您要冲值的客户!", MB_ICONINFORMATION);
		return;
	}
	{
		InputPsw dlg;
		if(dlg.DoModal()!=IDOK)return;
	}


	int iItem=m_List1.GetNextSelectedItem(pos);	
	CString account=m_List1.GetItemText (iItem, 0);
	CString name=m_List1.GetItemText (iItem, 3);
	ReCharge dlg;
	dlg.m_account =account;
	dlg.m_name =name;
	if(dlg.DoModal ()==IDOK)
		OnButton1();
}

void TakeFrom::OnButton2() 
{
	POSITION pos;
	pos=m_List1.GetFirstSelectedItemPosition();	
	if(pos==NULL)
	{
		AfxMessageBox("请先选中您要删除的项目!", MB_ICONINFORMATION);
		return;
	}
	if(AfxMessageBox("警告:删除后将不可恢复, 继续吗?", MB_YESNO|MB_ICONSTOP)!=IDYES)return;
	InputPsw dlg;
	if(dlg.DoModal()!=IDOK)return;

	int iItem=m_List1.GetNextSelectedItem(pos);	
	CString account=m_List1.GetItemText (iItem, 0);
	CString sql;
	sql= "delete from clientinfo where [account]='"+account+"'";
	MyExecuteSQL(&g_db, sql);
	OnButton1();
}

void TakeFrom::OnButton3() 
{
	// TODO: Add your control notification handler code here
	DWORD ii=0;
	if(1)
	{
		MyLock lock("xiaoaccessdbmsg");
		CRecordset myset(&g_db);
		CString	sql="select count(*) as cot from clientinfo"; 
		myset.Open (CRecordset::forwardOnly, sql);
		myset.GetFieldValue ("cot", sql);
		myset.Close();
		m_List1array.SetSize(atol(sql) , 1 );
		CRstClientInfo rsSt;
		rsSt.Open();

		while(!rsSt.IsEOF())
		{
			m_List1array.ElementAt (ii).RemoveAll ();
			m_List1array.ElementAt (ii).Add(rsSt.m_account) ;
			m_List1array.ElementAt (ii).Add(rsSt.m_balance) ;
			m_List1array.ElementAt (ii).Add(rsSt.m_name) ;
			m_List1array.ElementAt (ii).Add(rsSt.m_phone) ;
			m_List1array.ElementAt (ii).Add(rsSt.m_qq) ;
			m_List1array.ElementAt (ii).Add(rsSt.m_addr) ;
			m_List1array.ElementAt (ii).Add(rsSt.m_remark) ;
			m_List1array.ElementAt (ii).Add(rsSt.m_applydate) ;
			m_List1array.ElementAt (ii).Add(rsSt.m_signname) ;
			m_List1array.ElementAt (ii).Add(rsSt.m_road) ;
			m_List1array.ElementAt (ii).Add(GetLengthEx(rsSt.m_signname)) ;
			ii++;
			rsSt.MoveNext();if(m_List1array.GetSize ()<=ii)break;
		}
		rsSt.Close();m_List1array.SetSize(ii+1 , 1 );
	}


	int sumcount1=0;
	int sumcount2=0;
	if(1)
	{
		MyLock lock("xiaoaccessdbmsg");
		for(int i=0; i<m_List1array.GetSize ()-1; i++)
		{
			CString account=m_List1array.ElementAt (i).ElementAt (0);
			CRecordset myset(&g_db);


#ifdef SQLSERVER_VERSION
			CString sql="select sum(cast([msgcount] as float)) as cot from sendreg where account='"+account+"'";
#else
			CString sql="select sum([msgcount]) as cot from sendreg where account='"+account+"'";
#endif


			myset.Open (CRecordset::forwardOnly, sql);
			if(!myset.IsEOF())
				myset.GetFieldValue ("cot", sql);
			myset.Close();
			ConvertToPrice(sql);
			if(sql.IsEmpty ())sql="0";
			m_List1array.ElementAt (i).InsertAt (2, sql);
			sumcount1+=atoi(m_List1array.ElementAt (i).ElementAt (1));
			sumcount2+=atoi(sql);
		}
	}

	CString str;
	m_List1array.ElementAt (ii).RemoveAll ();
	m_List1array.ElementAt (ii).Add("") ;
	str.Format("%d", sumcount1);
	m_List1array.ElementAt (ii).Add(str) ;
	str.Format("%d", sumcount2);
	m_List1array.ElementAt (ii).Add(str) ;
	m_List1array.ElementAt (ii).Add("") ;
	m_List1array.ElementAt (ii).Add("") ;
	m_List1array.ElementAt (ii).Add("") ;
	m_List1array.ElementAt (ii).Add("") ;
	m_List1array.ElementAt (ii).Add("") ;
	m_List1array.ElementAt (ii).Add("") ;
	m_List1array.ElementAt (ii).Add("") ;
	m_List1array.ElementAt (ii).Add("") ;
	m_List1array.ElementAt (ii).Add("") ;
	m_List1array.ElementAt (ii).Add("") ;
	m_List1array.ElementAt (ii).Add("") ;
	m_List1array.ElementAt (ii).Add("") ;
	UpdateData();
	m_filter.TrimLeft ();
	m_filter.TrimRight ();
	FillGrid();
}
extern void FillLength(CString &str, int length);
extern int CheckPhoneType(CString phoneno);
void TakeFrom::OnBTNaddsp2() 
{
	// TODO: Add your control notification handler code here
	CStdioFile fp;


	fp.Open ("c:\\短信欠费客户.txt", CFile::modeCreate|CFile::modeWrite);
	CString str;
	CString name,balance,taked,phone;


	int leng1=45;
	int leng2=18;
	int leng3=18;
	int leng4=18;


	name="客人姓名";
	balance="余额";
	taked="已发";
	phone="电话";

	FillLength(name, leng1);
	FillLength(balance, leng2);
	FillLength(taked, leng3);
	FillLength(phone, leng4);

	str=name+balance+taked+phone+"\n";
	fp.WriteString (str);



	CString phones;
	int newline=0;
	for(int i=0; i<m_List1.GetItemCount (); i++)
	{
		name=m_List1.GetItemText (i, 3);
		balance=m_List1.GetItemText (i, 1);
		taked=m_List1.GetItemText (i, 2);
		phone=m_List1.GetItemText (i, 4);

		if(name.IsEmpty ())continue;
		if(atoi(taked)<200)continue;
		if(atoi(balance)>200)continue;

		if(CheckPhoneType(phone)!=-1)
		{
			newline++;
			phones+=phone;	phones+=",";
			if(newline==5)
			{
				newline=0;	phones+="\n";
			}

		}

		FillLength(name, leng1);
		FillLength(balance, leng2);
		FillLength(taked, leng3);
		FillLength(phone, leng4);

		str=name+balance+taked+phone+"\n";
		fp.WriteString (str);

	}
	fp.WriteString ("\n");fp.WriteString ("\n");fp.WriteString ("\n");fp.WriteString ("\n");fp.WriteString ("\n");
	phones.TrimRight (",");
	fp.WriteString ("全部手机，用于群发通知短信:\n");
	fp.WriteString (phones);

	fp.Close ();
	MessageBox("客户已保存到c:\\短信欠费客户.txt");
	ShellExecute(NULL, _T("open"), _T("c:\\短信欠费客户.txt"), NULL, NULL, SW_SHOWMAXIMIZED); 	
}
CString TakeFrom::GetName(CString m_account)
{
	for(int i=0; i<m_List1.GetItemCount (); i++)
	{
		if(m_account==m_List1.GetItemText (i, 0))
			return m_List1.GetItemText (i, 3);
	}
	return "";
}
void TakeFrom::OnBTNaddsp3() 
{
	// TODO: Add your control notification handler code here
	CStdioFile fp; 
	fp.Open ("c:\\上月充值客户.txt", CFile::modeCreate|CFile::modeWrite);
	CString str;
	CString name,date,recharge,money;

	int leng1=45;
	int leng2=18;
	int leng3=18;
	int leng4=18;
	name="客人姓名";
	date="日期";
	recharge="充值";
	money="金额";
	FillLength(name, leng1);
	FillLength(date, leng2);
	FillLength(recharge, leng3);
	FillLength(money, leng4);

	str=name+date+recharge+money+"\n";
	fp.WriteString (str);



	CString strdate1,strdate2;
	int month=CTime::GetCurrentTime ().GetMonth ()-1;
	if(month==0)
	{
		strdate1.Format ("%04d-%02d-%02d", CTime::GetCurrentTime ().GetYear ()-1, 12, 1);
		strdate2.Format ("%04d-%02d-%02d", CTime::GetCurrentTime ().GetYear ()-1, 12, 31);
	}
	else
	{
		strdate1.Format ("%04d-%02d-%02d", CTime::GetCurrentTime ().GetYear (), month, 1);
		strdate2.Format ("%04d-%02d-%02d", CTime::GetCurrentTime ().GetYear (), month, 31);
	}
	RstReCharge rsSt;
	rsSt.m_strFilter ="timestamp>='"+strdate1+"' and timestamp<='"+strdate2+"'";
	rsSt.Open();
	while(!rsSt.IsEOF())
	{
		if(atoi(rsSt.m_count)>100)
		{	
			name=GetName(rsSt.m_account);
			recharge.Format ("%d", atoi(rsSt.m_count) );
			money.Format ("%d", atoi(rsSt.m_money) );
			date=rsSt.m_timestamp;	

			FillLength(name, leng1);
			FillLength(date, leng2);
			FillLength(recharge, leng3);
			FillLength(money, leng4);
			str=name+date+recharge+money+"\n";	
			fp.WriteString (str);
		}
		rsSt.MoveNext(); 
	}
	rsSt.Close(); 






	fp.Close ();
	MessageBox("客户已保存到c:\\上月充值客户.txt");
	ShellExecute(NULL, _T("open"), _T("c:\\上月充值客户.txt"), NULL, NULL, SW_SHOWMAXIMIZED); 	
}

void TakeFrom::OnBTNaddsp4() 
{
	// TODO: Add your control notification handler code here
	CStdioFile fp;


	fp.Open ("c:\\短信平台客户.txt", CFile::modeCreate|CFile::modeWrite);
	CString str;
	CString filed1,filed2,filed3,filed4,filed5,filed6;


	int leng1=40;
	int leng2=15;
	int leng3=10;
	int leng4=10;
	int leng5=10;
	int leng6=18;


	filed1="影楼名称";
	filed2="电话";
	filed3="账号";
	filed4="余额";
	filed5="已发";
	filed6="签名";

	FillLength(filed1, leng1);
	FillLength(filed2, leng2);
	FillLength(filed3, leng3);
	FillLength(filed4, leng4);
	FillLength(filed5, leng5);
	FillLength(filed6, leng6);
	str=filed1+filed2+filed3+filed4+filed5+filed6+"\n";
	fp.WriteString (str);


	for(int i=0; i<m_List1.GetItemCount (); i++)
	{
		filed1=m_List1.GetItemText (i, 3);
		filed2=m_List1.GetItemText (i, 4);
		filed3=m_List1.GetItemText (i, 0);
		filed4=m_List1.GetItemText (i, 1);
		filed5=m_List1.GetItemText (i, 2);
		filed6=m_List1.GetItemText (i, 9);


		FillLength(filed1, leng1);
		FillLength(filed2, leng2);
		FillLength(filed3, leng3);
		FillLength(filed4, leng4);
		FillLength(filed5, leng5);
		FillLength(filed6, leng6);
		str=filed1+filed2+filed3+filed4+filed5+filed6+"\n";
		fp.WriteString (str);

	}



	fp.Close ();
	MessageBox("客户已保存到c:\\短信平台客户.txt");
	ShellExecute(NULL, _T("open"), _T("c:\\短信平台客户.txt"), NULL, NULL, SW_SHOWMAXIMIZED); 		
}

void TakeFrom::OnBnClickedButimportphoto4()//签名超长
{
	// TODO: 在此添加控件通知处理程序代码
	FillGrid(1);
}