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

// TipsDlg2.cpp: implementation of the TipsDlg2 class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "YLGL.h"
#include "ChoosePhotoLog.h"


#ifdef _DEBUG
#undef THIS_FILE
static char THIS_FILE[]=__FILE__;
#define new DEBUG_NEW
#endif

//////////////////////////////////////////////////////////////////////
// Construction/Destruction
//////////////////////////////////////////////////////////////////////

ChoosePhotoLog::ChoosePhotoLog(CWnd* pParent)
: CDialog(ChoosePhotoLog::IDD, pParent)
{
	m_strCurrOrderID = _T("");
}

void ChoosePhotoLog::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	DDX_Control(pDX, IDC_CHOOSEPHOTOLOGLIST, m_LogList);
}

BEGIN_MESSAGE_MAP(ChoosePhotoLog, CDialog)
	ON_BN_CLICKED(IDC_BUTTON_FIND, OnFindBtn)
	ON_BN_CLICKED(IDC_BUTTON_DELETE, OnDeleteBtn)
	ON_BN_CLICKED(IDC_BUTTON_CLOSE, OnCloseBtn)
END_MESSAGE_MAP()


BOOL ChoosePhotoLog::OnInitDialog()
{
	CDialog::OnInitDialog();

	m_LogList.InsertColumn( 0, _T("用户帐号"), LVCFMT_LEFT, 75 );//插入列
	m_LogList.InsertColumn( 1, _T("用户名"), LVCFMT_LEFT, 75 );//插入列
	m_LogList.InsertColumn( 2, _T("记录时间"), LVCFMT_LEFT, 75 );//插入列
//	m_LogList.InsertColumn( 3, _T("物理地址"), LVCFMT_LEFT, 95);//插入列
	m_LogList.InsertColumn( 3, _T("操作类型"), LVCFMT_LEFT, 75 );//插入列
	//m_LogList.InsertColumn( 5, _T("订单号"), LVCFMT_LEFT, 75 );//插入列
	m_LogList.InsertColumn( 4, _T("商品ID"), LVCFMT_LEFT, 75 );//插入列
	m_LogList.InsertColumn( 5, _T("商品名称"), LVCFMT_LEFT, 75 );//插入列
	m_LogList.InsertColumn( 6, _T("照片编号"), LVCFMT_LEFT, 200 );//插入列
	m_LogList.SetExtendedStyle(m_LogList.GetExtendedStyle() | LVS_EX_FLATSB | LVS_EX_FULLROWSELECT | LVS_EX_GRIDLINES | LVS_EX_HEADERDRAGDROP);

	OnFindBtn();
	this->CenterWindow(g_pMainWnd);
	return TRUE;
}

void ChoosePhotoLog::OnFindBtn()
{
	GetData(m_LogArr);
	FillDataForList(m_LogArr);
}

void ChoosePhotoLog::OnDeleteBtn()
{
	int nSize = m_LogList.GetItemCount();
	for(int i=nSize-1; i>=0; i--)
	{
		if(m_LogList.GetItemState(i, LVIS_SELECTED) == LVIS_SELECTED)
		{
			m_LogList.DeleteItem(i);
			CString strFilter = _T("");
			strFilter = _T("LogID=") + m_LogArr.ElementAt(i).ElementAt(0);

			CString strSql = _T("DELETE FROM SelectPhotoLog");
			if(strFilter != _T(""))
			{
				strSql += _T(" where ") + strFilter;
				g_sendhead.bsql = 1;
				g_pMainWnd->ProcessChatMessageRequest2(strSql);
				if (g_bSendOK == 0)
					return;
			}
		}
	}
	OnFindBtn();
}

void ChoosePhotoLog::OnCloseBtn()
{
	CDialog::OnCancel();
}

/************************************************************************/
/*	
	函数: OnBnClickedFindLog
	描述: 查询记录
	参数: 
	返回: 1成功，0失败
*/
/************************************************************************/
int ChoosePhotoLog::GetData(CArray<CStringArray, CStringArray>& arr)
{
	CString strFilter = _T("");
	SelectedFilter(strFilter);

	g_sendhead.bsql = 0;
	g_sendhead.code[0] = 237;
	g_sendhead.tabcount = 1;
	g_pMainWnd->ProcessChatMessageRequest2(strFilter);
	if(g_bSendOK == 0)
		return 0;

	arr.RemoveAll();
	DataToArray(&arr);
	return 1;
}

/************************************************************************/
/*	
	函数: SelectedFilter
	描述: 组成查询条件
	参数: 
		CString& strFilter				返回组成的查询条件
	返回: 
*/
/************************************************************************/
void ChoosePhotoLog::SelectedFilter(CString& strFilter)
{
	CTime startTime, endTime;
	((CDateTimeCtrl*)GetDlgItem(IDC_DATETIME_START))->GetTime(startTime);
	((CDateTimeCtrl*)GetDlgItem(IDC_DATETIME_END))->GetTime(endTime);
	
	CString strStartCT(_T("")), strEndCT(_T(""));
	strStartCT = startTime.Format(_T("%Y-%m-%d 00:00:00"));
	strEndCT = endTime.Format(_T("%Y-%m-%d 23:59:59"));

	CString strTimeFilter = _T("(LogDate>='") + strStartCT + _T("' and LogDate<='") + strEndCT + _T("')");
	CString strtmp = _T("");
	((CEdit*)GetDlgItem(IDC_EDIT_FindCondition))->GetWindowText(strtmp);
	if(strtmp == _T(""))
		strFilter = _T("OrderID = '") + m_strCurrOrderID + _T("' and ") + strTimeFilter;
	else
	{
		CString strOrFilter = _T("(Account like '%") + strtmp + _T("%' or UserName like '%") + strtmp + _T("%' or ClientMac like '%") + strtmp + _T("%' or OptType like '%") + strtmp + _T("%' or OrderID like '%") + strtmp + _T("%')");
		strFilter = _T("OrderID='") + m_strCurrOrderID + _T("' and ") + strTimeFilter + _T(" and ") + strOrFilter;
	}
}

/************************************************************************/
/*	
	函数: SelectedFilter
	描述: 组成查询条件
	参数: 
		CArray<CStringArray, CStringArray>& arr			记录数据
	返回: 
*/
/************************************************************************/
void ChoosePhotoLog::FillDataForList(CArray<CStringArray, CStringArray>& arr)
{
	m_LogList.DeleteAllItems();
	for(int i=0; i<arr.GetSize(); i++)
	{
		if(arr.ElementAt(i).ElementAt(6) != m_strCurrOrderID)
			continue;

		int row = m_LogList.InsertItem(i, arr.ElementAt(i).ElementAt(1));
		m_LogList.SetItemText(row, 1, arr.ElementAt(i).ElementAt(2));
		m_LogList.SetItemText(row, 2, arr.ElementAt(i).ElementAt(3));
	//	m_LogList.SetItemText(row, 3, arr.ElementAt(i).ElementAt(4));
		m_LogList.SetItemText(row, 3, arr.ElementAt(i).ElementAt(5));
	//	m_LogList.SetItemText(row, 5, arr.ElementAt(i).ElementAt(6));
		m_LogList.SetItemText(row, 4, arr.ElementAt(i).ElementAt(7));
		m_LogList.SetItemText(row, 5, arr.ElementAt(i).ElementAt(8));
		m_LogList.SetItemText(row, 6, arr.ElementAt(i).ElementAt(9));
	}
}