lyfz_repos/经典版源码/旧的后台处理/LYFZIPManage/DesignFrom.cpp

// DesignFrom.cpp : implementation file
//
#include "stdafx.h"
#include "LYFZIPManage.h"
#include "DesignFrom.h"
#include "MyMdi.H"
#include "InputPsw.h"
#include "ClientDlg.h"
 #include "SqlDlg.h"
 #include "mysqldata.h"
#include "ClientRequirement.h"
#include "ChoosePhotoSkin2.h"
#include "./helper/ffsco.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
#pragma comment(lib, "Shlwapi.lib")
/////////////////////////////////////////////////////////////////////////////
// DesignFrom

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

DesignFrom::~DesignFrom()
{
}

void DesignFrom::DoDataExchange(CDataExchange* pDX)
{
	CFormView::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(DesignFrom)
	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(DesignFrom, CFormView)
	//{{AFX_MSG_MAP(DesignFrom)
	ON_BN_CLICKED(IDC_BUTclose, OnBUTclose)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	ON_WM_TIMER()
	ON_BN_CLICKED(IDC_BUTshowphoto, OnBUTshowphoto)
	ON_NOTIFY(NM_DBLCLK, IDC_LIST2, OnDblclkList2)
	ON_BN_CLICKED(IDC_BUTimportphoto, OnBUTimportphoto)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// DesignFrom diagnostics

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

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

/////////////////////////////////////////////////////////////////////////////
// DesignFrom message handlers

void DesignFrom::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;姓名,100;号码,100;内容,100;发送时间,100;时间,100;费用,100;真实费用,100;id,0" );
//	m_List1.SetHeadings("账号,100;姓名,100;号码,100;时间,100;费用,100;真实费用,100" );

 	m_List1.LoadColumnInfo (_T("119"));
 

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

	OnButton1();
}

void DesignFrom::FillGrid(BOOL bStatus)
{ 
	m_List1.DeleteAllItems2 ();
	int ii=0;
	m_List1.m_arLabels.SetSize( m_List1array.GetSize (), 1 );
	int count=0;
    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_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 DesignFrom::OnBUTclose() 
{
	// TODO: Add your control notification handler code here
	GetParent()->SendMessage(WM_CLOSE);
}

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

BOOL DesignFrom::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 VK_F9:	
			{
			SqlDlg dlg;
			dlg.DoModal ();
			}
			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(...)
	{
	}

}

void DesignFrom::OnButton1() 
{
	// TODO: Add your control notification handler code here
	if(1)
	{
	MyLock lock("xiaoaccessdbmsg");
	CRecordset myset(&g_db);
	CString	sql="select count(*) as cot from sendregform"; 
	myset.Open (CRecordset::forwardOnly, sql);
	myset.GetFieldValue ("cot", sql);
	myset.Close();
	m_List1array.SetSize(atol(sql) , 1 );
	RstSendRegForm rsSt;
	rsSt.Open();
    DWORD ii=0;
	while(!rsSt.IsEOF())
	{
    	m_List1array.ElementAt (ii).RemoveAll ();
		m_List1array.ElementAt (ii).Add(rsSt.m_account) ;
		m_List1array.ElementAt (ii).Add(rsSt.m_name) ;

		if(rsSt.m_phones.GetLength ()>259)
		    m_List1array.ElementAt (ii).Add(rsSt.m_phones.Left (256)+"...") ;
		else
		    m_List1array.ElementAt (ii).Add(rsSt.m_phones) ;
	 	if(rsSt.m_content.GetLength ()>259)
		    m_List1array.ElementAt (ii).Add(rsSt.m_content.Left (256)+"...") ;
		else
		    m_List1array.ElementAt (ii).Add(rsSt.m_content) ; 
		m_List1array.ElementAt (ii).Add(rsSt.m_log) ;
		m_List1array.ElementAt (ii).Add(rsSt.m_timestamp) ;
		m_List1array.ElementAt (ii).Add(rsSt.m_msgcount) ;
		m_List1array.ElementAt (ii).Add(rsSt.m_msgcount2) ;
		m_List1array.ElementAt (ii).Add(rsSt.m_id) ;
		ii++;
		rsSt.MoveNext();if(m_List1array.GetSize ()<=ii)break;
	}
	rsSt.Close();m_List1array.SetSize(ii , 1 );
	}
 

	UpdateData();
	m_filter.TrimLeft ();
	m_filter.TrimRight ();
	FillGrid();
}

void DesignFrom::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 content=m_List1.GetItemText (iItem, 3);
	CString id=m_List1.GetItemText (iItem, 8);
	CRecordset myset(&g_db);
	CString	sql;
	sql.Format("select [phones] as cot from sendreg where [autoid]=%d", atoi(id)); 
	myset.Open (CRecordset::forwardOnly, sql);
	myset.GetFieldValue ("cot", sql);
	myset.Close();


  	CString phone=sql;



	SqlDlg dlg;
	dlg.m_sql =phone+"\r\n"+content;
	dlg.DoModal ();
	*pResult = 0;
}

void DesignFrom::OnBUTimportphoto() 
{
	// TODO: Add your control notification handler code here
 
}

void FillLength(CString &str, int length)
{
	while(str.GetLength ()<length)
		str+=" ";
}
void DesignFrom::OnBUTshowphoto() 
{ 
	CStdioFile fp;
	fp.Open ("c:\\clientphone.txt", CFile::modeCreate|CFile::modeWrite);
	CString str;
	CString name,m_name1,m_name2;
	CString phone,m_phone1,m_phone2;
	CString txname,txprice,mensi;

	int leng1=20;
	int leng2=30;
	int leng3=30;
	int leng4=30;
	int leng5=20;


 
	name="账号";
	mensi="号码";
	phone="内容";
	txname="发送时间";
	txprice="费用";
	    FillLength(name, leng1);
	    FillLength(mensi, leng2);
	    FillLength(phone, leng3);
	    FillLength(txname, leng4);
	    FillLength(txprice,leng5);
		str=name+mensi+phone+txname+txprice+"\n";
		fp.WriteString (str);



	for(int i=0; i<m_List1.GetItemCount (); i++)
	{
		name=m_List1.GetItemText (i, 0);
 		mensi=m_List1.GetItemText (i, 2);
		phone=m_List1.GetItemText (i, 3);
		txname=m_List1.GetItemText (i, 4);
		txprice=m_List1.GetItemText (i, 6);

		if(mensi.GetLength ()>10) mensi=mensi.Left (10)+"...";
 		if(phone.GetLength ()>10) phone=phone.Left (10)+"...";
	    FillLength(name, leng1);
	    FillLength(mensi, leng2);
	    FillLength(phone, leng3);
	    FillLength(txname, leng4);
	    FillLength(txprice,leng5);
		str=name+mensi+phone+txname+txprice+"\n";
		fp.WriteString (str);
 
	}

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