413 lines
10 KiB
C++
413 lines
10 KiB
C++
// FSmsYF.cpp : implementation file
|
|
//
|
|
|
|
#include "stdafx.h"
|
|
#include "CorpSms.h"
|
|
#include "FSmsYF.h"
|
|
|
|
#ifdef _DEBUG
|
|
#define new DEBUG_NEW
|
|
#undef THIS_FILE
|
|
static char THIS_FILE[] = __FILE__;
|
|
#endif
|
|
|
|
/////////////////////////////////////////////////////////////////////////////
|
|
// CFSmsYF dialog
|
|
#include "MainFrm.h"
|
|
#include "ProcessSocket.h"
|
|
#include "DLG_SmsList_Export.h"
|
|
|
|
CFSmsYF::CFSmsYF(CWnd* pParent /*=NULL*/)
|
|
: CDialog(CFSmsYF::IDD, pParent)
|
|
{
|
|
//{{AFX_DATA_INIT(CFSmsYF)
|
|
// NOTE: the ClassWizard will add member initialization here
|
|
//}}AFX_DATA_INIT
|
|
m_bInit = false;
|
|
m_bRefresh = false;
|
|
m_bShowToday = true;
|
|
}
|
|
|
|
|
|
void CFSmsYF::DoDataExchange(CDataExchange* pDX)
|
|
{
|
|
CDialog::DoDataExchange(pDX);
|
|
//{{AFX_DATA_MAP(CFSmsYF)
|
|
DDX_Control(pDX, IDC_SMSYF_LIST, m_wndList);
|
|
//}}AFX_DATA_MAP
|
|
}
|
|
|
|
|
|
BEGIN_MESSAGE_MAP(CFSmsYF, CDialog)
|
|
//{{AFX_MSG_MAP(CFSmsYF)
|
|
ON_WM_SIZE()
|
|
ON_NOTIFY(NM_DBLCLK, IDC_SMSYF_LIST, OnDblclkSmsyfList)
|
|
ON_NOTIFY(NM_RCLICK, IDC_SMSYF_LIST, OnRclickSmsyfList)
|
|
ON_NOTIFY(LVN_KEYDOWN, IDC_SMSYF_LIST, OnKeydownSmsyfList)
|
|
//}}AFX_MSG_MAP
|
|
ON_COMMAND( MENU_YF_ADD , On_User_Add )
|
|
ON_COMMAND( MENU_YF_SEE , On_User_See )
|
|
ON_COMMAND( MENU_YF_RESEND , On_User_ReSend )
|
|
ON_COMMAND( MENU_YF_DEL , On_User_Del )
|
|
ON_COMMAND( MENU_YF_REFRESH , On_User_Refresh )
|
|
ON_COMMAND( MENU_YF_FIND , On_User_Find )
|
|
ON_COMMAND( MENU_YF_EXPORT , On_User_Export )
|
|
|
|
END_MESSAGE_MAP()
|
|
|
|
/////////////////////////////////////////////////////////////////////////////
|
|
// CFSmsYF message handlers
|
|
|
|
BOOL CFSmsYF::OnInitDialog()
|
|
{
|
|
CDialog::OnInitDialog();
|
|
|
|
//È¡µÃ¹²ÓòÎÊý
|
|
//CMainFrame * pFrame = static_cast <CMainFrame *>((CMainFrame *)AfxGetMainWnd());
|
|
this->GetParent()->GetParentFrame();
|
|
m_pMainFrame = (CMainFrame *)this->GetParent()->GetParentFrame();
|
|
m_pSocket = &m_pMainFrame->m_Socket;
|
|
m_AdoRS.SetAdoConnection( &m_pMainFrame->m_adoConnection );
|
|
m_AdoRS2.SetAdoConnection( &m_pMainFrame->m_adoConnection );
|
|
|
|
//³õʼ»¯List
|
|
m_Image.Create(16,16,ILC_COLOR32|ILC_MASK,5,5);
|
|
m_Image.Add(AfxGetApp()->LoadIcon(IDI_L_SMS_SEND) );
|
|
m_Image.Add(AfxGetApp()->LoadIcon(IDI_L_LOCK) );
|
|
m_wndList.SubClassWindow2();
|
|
m_wndList.SetHeadings(_T("ÐòºÅ,50; ·¢ËÍʱ¼ä,135;ºÅÂëÊý,60; ¶¨Ê±Ê±¼ä,135; ¶ÌÐÅÄÚÈÝ,320;"));
|
|
m_wndList.SetGridLines(true);
|
|
m_wndList.SetImageList(&m_Image,LVSIL_SMALL);
|
|
//m_wndList.SetBkColor( RGB(237,191,175) );
|
|
//m_wndList.SetTextBkColor( RGB(237,191,175) );
|
|
|
|
m_bInit = true;
|
|
|
|
return TRUE; // return TRUE unless you set the focus to a control
|
|
// EXCEPTION: OCX Property Pages should return FALSE
|
|
}
|
|
|
|
BOOL CFSmsYF::ReHide()
|
|
{
|
|
ShowWindow( SW_HIDE );
|
|
return true;
|
|
}
|
|
|
|
BOOL CFSmsYF::ReShow(BOOL bRefresh)
|
|
{
|
|
ShowWindow( SW_SHOW );
|
|
if ( bRefresh || !m_bRefresh )
|
|
{
|
|
RefreshInfo();
|
|
}
|
|
return true;
|
|
}
|
|
|
|
BOOL CFSmsYF::RefreshInfo()
|
|
{
|
|
m_wndList.ShowWindow( SW_HIDE ); //ΪÁ˼ӿìÏÔʾËÙ¶È
|
|
m_bRefresh = true;
|
|
m_wndList.DeleteAllItems();
|
|
TCHAR szSelect[512]={0};
|
|
if ( m_bShowToday )
|
|
{
|
|
//½ö²éѯµ±ÌìµÄ
|
|
SYSTEMTIME t;::GetLocalTime(&t);
|
|
if ( m_pMainFrame->m_Setup.bSQLUse )
|
|
_stprintf( szSelect , _T("select * from smsbox where BoxType='1' and CreateTime>='%04d%02d%02d' %s order by CreateTime "), t.wYear,t.wMonth,t.wDay,m_strFindAdd ); //²éѯÒÑ·¢¶ÌÐÅ
|
|
else
|
|
_stprintf( szSelect , _T("select * from smsbox where BoxType='1' and CreateTime>=#%04d-%02d-%02d# %s order by CreateTime "), t.wYear,t.wMonth,t.wDay,m_strFindAdd ); //²éѯÒÑ·¢¶ÌÐÅ
|
|
}
|
|
else
|
|
{
|
|
_stprintf( szSelect , _T("select * from smsbox where BoxType='1' %s order by CreateTime ") , m_strFindAdd ); //²éѯÒÑ·¢¶ÌÐÅ
|
|
}
|
|
BOOL b = m_AdoRS.Open( szSelect );
|
|
CAdoRecordSet AdoRS;
|
|
AdoRS.SetAdoConnection( &m_pMainFrame->m_adoConnection );
|
|
long lCount = 0;
|
|
COleDateTime ot;
|
|
SYSTEMTIME t={0};
|
|
TCHAR szMsg[1024]={0};
|
|
long lBoxID=0;
|
|
long lSMSCount=0;
|
|
CString strID;
|
|
CString strCreateTime;
|
|
CString strUserCount;
|
|
COleDateTime tTimer;
|
|
CString strTimer;
|
|
if ( b && m_AdoRS.GetRecordCount() )
|
|
{
|
|
m_AdoRS.MoveFirst();
|
|
while( !m_AdoRS.IsEOF() )
|
|
{
|
|
m_AdoRS.GetCollect( _T("BoxID") , lBoxID );
|
|
m_AdoRS.GetCollect( _T("CreateTime") , ot ); ot.GetAsSystemTime(t);
|
|
m_AdoRS.GetCollect( _T("Msg") , szMsg );
|
|
m_AdoRS.GetCollect(_T("Timer"), tTimer);
|
|
|
|
/*
|
|
m_wndList.InsertItem( 0 , _itot( lCount+1,szSelect,10) , 0 );
|
|
_stprintf( szSelect , "%04d.%02d.%02d %02d:%02d" , t.wYear,t.wMonth,t.wDay,t.wHour,t.wMinute);
|
|
m_wndList.SetItemText(0,1,szSelect);
|
|
m_wndList.SetItemText(0,3,szMsg);
|
|
*/
|
|
|
|
|
|
//È¡¼Ç¼×ÜÊý
|
|
lSMSCount = 0;
|
|
_stprintf( szSelect , _T("select Count(*) from smsitem where BoxID=%d") , lBoxID );
|
|
BOOL b2 = AdoRS.Open(szSelect);
|
|
if ( b2 && AdoRS.GetRecordCount() )
|
|
{
|
|
AdoRS.MoveFirst();
|
|
long lIndex = 0;
|
|
AdoRS.GetCollect( lIndex , lSMSCount );
|
|
}
|
|
|
|
strID.Format( _T("%d") , lCount+1 );
|
|
strCreateTime.Format(_T("%04d.%02d.%02d %02d:%02d") , t.wYear,t.wMonth,t.wDay,t.wHour,t.wMinute);
|
|
strUserCount.Format(_T("%d"),lSMSCount);
|
|
strTimer = _T("");
|
|
if (tTimer.GetStatus() == COleDateTime::valid)
|
|
{
|
|
strTimer.Format(_T("%04d.%02d.%02d %02d:%02d"), tTimer.GetYear(), tTimer.GetMonth(), tTimer.GetDay(), tTimer.GetHour(), tTimer.GetMinute());
|
|
}
|
|
m_wndList.InsertItemAndCol(0,strID,strCreateTime,strUserCount, strTimer,szMsg);
|
|
m_wndList.SetItemData(0,lBoxID);
|
|
|
|
lCount++;
|
|
m_AdoRS.MoveNext();
|
|
}
|
|
}
|
|
m_wndList.ShowWindow( SW_SHOW ); //ΪÁ˼ӿìÏÔʾËÙ¶È
|
|
return true;
|
|
}
|
|
|
|
void CFSmsYF::OnSize(UINT nType, int cx, int cy)
|
|
{
|
|
CDialog::OnSize(nType, cx, cy);
|
|
|
|
if ( m_bInit )
|
|
{
|
|
m_wndList.MoveWindow( 0 , 0 , cx,cy);
|
|
}
|
|
|
|
}
|
|
|
|
void CFSmsYF::OnDblclkSmsyfList(NMHDR* pNMHDR, LRESULT* pResult)
|
|
{
|
|
*pResult = 0;
|
|
On_User_See();
|
|
}
|
|
|
|
void CFSmsYF::OnRclickSmsyfList(NMHDR* pNMHDR, LRESULT* pResult)
|
|
{
|
|
*pResult = 0;
|
|
ShowRMenu();
|
|
}
|
|
|
|
void CFSmsYF::ShowRMenu()
|
|
{
|
|
CMenu menu;
|
|
menu.CreatePopupMenu();
|
|
BOOL bLock = false;
|
|
long lItem = this->GetCurrentSelected();
|
|
|
|
menu.AppendMenu(MF_STRING , MENU_YF_ADD, _T(" н¨Áбí ") );
|
|
|
|
if ( lItem >= 0 )
|
|
{
|
|
menu.AppendMenu(MF_STRING , MENU_YF_SEE, _T(" ²é ¿´ ") );
|
|
menu.AppendMenu(MF_STRING , MENU_YF_RESEND, _T(" Ôٴη¢ËÍ ") );
|
|
menu.AppendMenu(MF_STRING , MENU_YF_DEL, _T(" ɾ ³ý ") );
|
|
}
|
|
else
|
|
{
|
|
menu.AppendMenu(MF_STRING|MF_DISABLED|MF_GRAYED , MENU_YF_SEE, _T(" ²é ¿´ ") );
|
|
menu.AppendMenu(MF_STRING|MF_DISABLED|MF_GRAYED , MENU_YF_RESEND, _T(" Ôٴη¢ËÍ ") );
|
|
menu.AppendMenu(MF_STRING|MF_DISABLED|MF_GRAYED , MENU_YF_DEL, _T(" ɾ ³ý ") );
|
|
}
|
|
menu.AppendMenu(MF_SEPARATOR );
|
|
|
|
//Ë¢ÐÂ
|
|
menu.AppendMenu(MF_STRING , MENU_YF_EXPORT, _T(" µ¼³ö... ") );
|
|
menu.AppendMenu(MF_STRING , MENU_YF_FIND , _T(" ²éÕÒ... ") );
|
|
menu.AppendMenu(MF_SEPARATOR );
|
|
//Ë¢ÐÂ
|
|
menu.AppendMenu(MF_STRING , MENU_YF_REFRESH, _T(" ˢ Р") );
|
|
|
|
//ÏÔʾ²Ëµ¥
|
|
POINT pt ;
|
|
::GetCursorPos( &pt );
|
|
//this->ClientToScreen( &pt);
|
|
menu.TrackPopupMenu(TPM_LEFTBUTTON | TPM_RIGHTBUTTON,pt.x,pt.y, this, NULL);
|
|
menu.DestroyMenu();
|
|
}
|
|
|
|
long CFSmsYF::GetCurrentSelected()
|
|
{
|
|
POSITION pos = m_wndList.GetFirstSelectedItemPosition();
|
|
if ( pos )
|
|
{
|
|
return m_wndList.GetNextSelectedItem(pos);
|
|
}
|
|
return -1;
|
|
}
|
|
void CFSmsYF::On_User_Add()
|
|
{
|
|
m_pMainFrame->m_pFuncView->On_User_List_Add();
|
|
}
|
|
void CFSmsYF::On_User_See()
|
|
{
|
|
long lItem = GetCurrentSelected();
|
|
if ( lItem < 0 )
|
|
return ;
|
|
long lBoxID = m_wndList.GetItemData( lItem );
|
|
if ( lBoxID <= 0 )
|
|
return ;
|
|
m_pMainFrame->m_pFuncView->On_User_List_Read( lBoxID );
|
|
}
|
|
void CFSmsYF::On_User_ReSend()
|
|
{
|
|
long lItem = GetCurrentSelected();
|
|
if ( lItem < 0 )
|
|
return ;
|
|
long lBoxID = m_wndList.GetItemData( lItem );
|
|
if ( lBoxID <= 0 )
|
|
return ;
|
|
m_pMainFrame->m_pFuncView->On_User_List_ReSend( lBoxID );
|
|
}
|
|
void CFSmsYF::On_User_Del()
|
|
{
|
|
long lCount = m_wndList.GetSelectedCount();
|
|
long *lDel = new long[lCount+2];
|
|
POSITION pos = m_wndList.GetFirstSelectedItemPosition();
|
|
long i = 0;
|
|
while(pos)
|
|
{
|
|
lDel[i]= m_wndList.GetNextSelectedItem(pos);
|
|
i ++;
|
|
}
|
|
//µ¹×ªÉ¾³ý
|
|
m_wndList.ShowWindow( SW_HIDE ); //¼Ó¿ìÏÔʾµÄËÙ¶È
|
|
for ( i = lCount ; i>0 ; i-- )
|
|
{
|
|
long lBoxID = m_wndList.GetItemData( lDel[i-1] );
|
|
if ( lBoxID <= 0 )
|
|
continue ;
|
|
|
|
if ( m_pMainFrame->m_pFuncView->m_DLGSend.GetBoxID() == lBoxID )
|
|
{
|
|
long lRet = MessageBox( _T("Ҫɾ³ýµÄÁбíÕýÖб༣¬ÊÇ·ñȷʵɾ³ý£¿") , _T("ÌáÎÊ") , MB_YESNO|MB_ICONQUESTION|MB_DEFBUTTON2);
|
|
if ( lRet != IDYES )
|
|
continue ;
|
|
|
|
if ( !m_pMainFrame->m_pFuncView->m_DLGSend.List_Save() )
|
|
continue;
|
|
if ( !m_pMainFrame->m_pFuncView->m_DLGSend.List_New() )
|
|
continue;
|
|
}
|
|
|
|
TCHAR szSelect[128]={0};
|
|
_stprintf( szSelect , _T("delete from smsbox where BoxID=%d") , lBoxID ); //ÏÈɾ³ýsmsBox
|
|
BOOL b = m_AdoRS.Open( szSelect );
|
|
_stprintf( szSelect , _T("delete from smsitem where BoxID=%d") , lBoxID );//ÔÙɾ³ýBoxItem
|
|
b = m_AdoRS.Open( szSelect );
|
|
m_wndList.DeleteItem( lDel[i-1] ); //ɾ³ýListÖеÄItem
|
|
|
|
}
|
|
m_wndList.ShowWindow( SW_SHOW ); //¼Ó¿ìÏÔʾµÄËÙ¶È
|
|
delete lDel;
|
|
}
|
|
void CFSmsYF::On_User_Refresh()
|
|
{
|
|
RefreshInfo();
|
|
}
|
|
void CFSmsYF::On_User_Find()
|
|
{
|
|
CString strTemp;
|
|
DLG_Find_SmsBox dlg(this);
|
|
dlg.SetParam( !m_bShowToday );
|
|
if ( dlg.DoModal() == IDOK )
|
|
{
|
|
m_strFindAdd = _T("");
|
|
|
|
if ( !m_bShowToday )
|
|
{
|
|
strTemp.Format( _T(" AND CreateTime>=#%04d-%02d-%02d# AND CreateTime<=#%04d-%02d-%02d 23:59:59#"),dlg.m_TBegin.GetYear(),dlg.m_TBegin.GetMonth(),dlg.m_TBegin.GetDay(),dlg.m_TEnd.GetYear(),dlg.m_TEnd.GetMonth(),dlg.m_TEnd.GetDay());
|
|
m_strFindAdd = strTemp;
|
|
}
|
|
if ( dlg.m_strMsg.GetLength()>0 )
|
|
{
|
|
strTemp.Format( _T(" AND Msg like '%%%s%%'"),dlg.m_strMsg );
|
|
m_strFindAdd += strTemp;
|
|
}
|
|
On_User_Refresh();
|
|
|
|
m_strFindAdd = _T(""); //ˢк󣬲éѯ½áÊø
|
|
}
|
|
}
|
|
void CFSmsYF::On_User_Export()
|
|
{
|
|
DLG_SmsList_Export dlg(this);
|
|
dlg.SetParam(&m_AdoRS2,&m_wndList,0);
|
|
dlg.DoModal();
|
|
}
|
|
void CFSmsYF::OnKeydownSmsyfList(NMHDR* pNMHDR, LRESULT* pResult)
|
|
{
|
|
LV_KEYDOWN* pLVKeyDow = (LV_KEYDOWN*)pNMHDR;
|
|
*pResult = 0;
|
|
|
|
if ( pLVKeyDow->wVKey == VK_DELETE )
|
|
{
|
|
On_User_Del();
|
|
}
|
|
if ( pLVKeyDow->wVKey == VK_INSERT)
|
|
{
|
|
On_User_Add();
|
|
}
|
|
if ( pLVKeyDow->wVKey == VK_SPACE)
|
|
{
|
|
On_User_See();
|
|
}
|
|
if ( pLVKeyDow->wVKey == 'S' || pLVKeyDow->wVKey == 's')
|
|
{
|
|
On_User_ReSend();
|
|
}
|
|
if ( pLVKeyDow->wVKey == 'R' || pLVKeyDow->wVKey == 'r')
|
|
{
|
|
On_User_Refresh();
|
|
}
|
|
if ( pLVKeyDow->wVKey == 'A' || pLVKeyDow->wVKey == 'a')
|
|
{
|
|
m_wndList.SelectAllItems();
|
|
}
|
|
if ( pLVKeyDow->wVKey == 'F' || pLVKeyDow->wVKey == 'f')
|
|
{
|
|
On_User_Find();
|
|
}
|
|
|
|
|
|
}
|
|
|
|
void CFSmsYF::OnOK()
|
|
{
|
|
//CDialog::OnOK();
|
|
}
|
|
|
|
void CFSmsYF::OnCancel()
|
|
{
|
|
//CDialog::OnCancel();
|
|
}
|
|
|
|
BOOL CFSmsYF::SetToday(BOOL bToday)
|
|
{
|
|
if ( m_bShowToday != bToday )
|
|
{
|
|
m_bShowToday = bToday;
|
|
m_bRefresh = false;
|
|
}
|
|
return m_bShowToday;
|
|
}
|