msgview.cpp

本家庭理财系统是一个简易的家庭理财工具

// MsgView.cpp : implementation file
//

#include "stdafx.h"
#include "FFMS.h"
#include "MsgView.h"
#include "GeneralDef.h"

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

/////////////////////////////////////////////////////////////////////////////
// CMsgView

IMPLEMENT_DYNCREATE(CMsgView, CFormView)

CMsgView::CMsgView()
	: CFormView(CMsgView::IDD)
{
	//{{AFX_DATA_INIT(CMsgView)
	m_strInType = _T("");
	m_strOutType = _T("");
	m_strAssetType = _T("");
	//}}AFX_DATA_INIT
}

CMsgView::~CMsgView()
{
}

void CMsgView::DoDataExchange(CDataExchange* pDX)
{
	CFormView::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CMsgView)
	DDX_Control(pDX, IDC_LIST_ASSET, m_listAssetType);
	DDX_Control(pDX, IDC_LIST_OUTTY, m_listOutType);
	DDX_Control(pDX, IDC_LIST_INTY, m_listInType);
	DDX_Text(pDX, IDC_EDIT_INTY, m_strInType);
	DDX_Text(pDX, IDC_EDIT_OUTTY, m_strOutType);
	DDX_Text(pDX, IDC_EDIT_ASSETTY, m_strAssetType);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CMsgView, CFormView)
	//{{AFX_MSG_MAP(CMsgView)
	ON_NOTIFY(NM_CLICK, IDC_LIST_INTY, OnClickListInty)
	ON_NOTIFY(NM_CLICK, IDC_LIST_OUTTY, OnClickListOutty)
	ON_NOTIFY(NM_CLICK, IDC_LIST_ASSET, OnClickListAsset)
	ON_BN_CLICKED(IDC_BTN_INADD, OnBtnInadd)
	ON_BN_CLICKED(IDC_BTN_INMOD, OnBtnInmod)
	ON_BN_CLICKED(IDC_BTN_INDEL, OnBtnIndel)
	ON_BN_CLICKED(IDC_BTN_OUTADD, OnBtnOutadd)
	ON_BN_CLICKED(IDC_BTN_OUTMOD, OnBtnOutmod)
	ON_BN_CLICKED(IDC_BTN_OUTDEL, OnBtnOutdel)
	ON_BN_CLICKED(IDC_BTN_ASSETADD, OnBtnAssetadd)
	ON_BN_CLICKED(IDC_BTN_ASSETMOD, OnBtnAssetmod)
	ON_BN_CLICKED(IDC_BTN_ASSETDEL, OnBtnAssetdel)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CMsgView diagnostics

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

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

/////////////////////////////////////////////////////////////////////////////
void CMsgView::InitCtrl()
{
	//设置列表框控件扩展风格
	DWORD dwExStyle=LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES|LVS_EX_HEADERDRAGDROP|LVS_EX_ONECLICKACTIVATE;//|LVS_EX_UNDERLINEHOT
	m_listInType.SetExtendedStyle(dwExStyle);
	m_listOutType.SetExtendedStyle(dwExStyle);
	m_listAssetType.SetExtendedStyle(dwExStyle);
	m_listInType.InsertColumn(0,"收入类型ID",LVCFMT_CENTER,100);
	m_listInType.InsertColumn(1,"收入类型名称",LVCFMT_CENTER,111);
	m_listOutType.InsertColumn(0,"支出类型ID",LVCFMT_CENTER,100);
	m_listOutType.InsertColumn(1,"支出类型名称",LVCFMT_CENTER,111);
	m_listAssetType.InsertColumn(0,"固定资产类型",LVCFMT_CENTER,111);
	m_listAssetType.InsertColumn(1,"固定资产名称",LVCFMT_CENTER,111);
}

void CMsgView::InitCtrlData()
{
	m_listInType.DeleteAllItems();
	m_listOutType.DeleteAllItems();
	m_listAssetType.DeleteAllItems();
	CDStrs InFields,OutFields,AssetFields;
	adoDB.ExecuteQuery("select * from MSG_IN order by in_id",InFields);
	for(int i=0;i<InFields.size();i++)
	{
		CStrs strs=InFields[i];
		InsertTypeItem(&m_listInType,strs[0],strs[1]);
	}
	adoDB.ExecuteQuery("select * from MSG_OUT order by out_id",OutFields);
	for(i=0;i<OutFields.size();i++)
	{
		CStrs strs=OutFields[i];
		InsertTypeItem(&m_listOutType,strs[0],strs[1]);
	}
	adoDB.ExecuteQuery("select * from MSG_ASSET order by asset_id",AssetFields);
	for(i=0;i<AssetFields.size();i++)
	{
		CStrs strs=AssetFields[i];
		InsertTypeItem(&m_listAssetType,strs[0],strs[1]);
	}
}

void CMsgView::InsertTypeItem(CListCtrl* pList,CString id,CString type)
{
	//获取当前的纪录条数
	int nIndex = pList->GetItemCount();
	LV_ITEM lvItem;
	lvItem.mask = LVIF_TEXT ;   
	lvItem.iItem = nIndex;                              //行数
	lvItem.iSubItem = 0;
	lvItem.pszText = (char*)(LPCTSTR)id;              //第一列
	//在最后一行插入记录值
	pList->InsertItem(&lvItem); 
	//设置该行的其他列的值
	pList->SetItemText(nIndex,1,type);
}

void CMsgView::OnInitialUpdate() 
{
	CFormView::OnInitialUpdate();
	
	// TODO: Add your specialized code here and/or call the base class
	InitCtrl();
	CString sql="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Finance;Data Source=(local)";
	if(adoDB.Open(sql)==TRUE)
		InitCtrlData();
}

void CMsgView::OnClickListInty(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	int nItem=m_listInType.GetNextItem(-1,LVNI_SELECTED);
	if(nItem!=-1)
	{
		CString type=m_listInType.GetItemText(nItem,1);
		GetDlgItem(IDC_EDIT_INTY)->SetWindowText(type);
	}
	*pResult = 0;
}

void CMsgView::OnClickListOutty(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	int nItem=m_listOutType.GetNextItem(-1,LVNI_SELECTED);
	if(nItem!=-1)
	{
		CString type=m_listOutType.GetItemText(nItem,1);
		GetDlgItem(IDC_EDIT_OUTTY)->SetWindowText(type);
	}
	*pResult = 0;
}

void CMsgView::OnClickListAsset(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	int nItem=m_listAssetType.GetNextItem(-1,LVNI_SELECTED);
	if(nItem!=-1)
	{
		CString type=m_listAssetType.GetItemText(nItem,1);
		GetDlgItem(IDC_EDIT_ASSETTY)->SetWindowText(type);
	}
	*pResult = 0;
}

void CMsgView::OnBtnInadd() 
{
	// TODO: Add your control notification handler code here
	if(!UpdateData())
		return;
	if(!adoDB.IsOpen())
	{
		AfxMessageBox("数据库未打开!");
		return;
	}
	if(m_strInType.IsEmpty())
		return;
	CString str;
	CString strID;
	str.Format("select in_id from MSG_IN where in_type='%s'",m_strInType);
	adoDB.ExecuteQueryValue(str,strID);
	if(atoi(strID)!=0)
	{
		AfxMessageBox("当前收入类型已经存在!");
		return;
	}
	adoDB.ExecuteQueryValue("select max(in_id) from MSG_IN",strID);
	int newID=atoi(strID)+1;
	CString sql;
	sql.Format("insert into MSG_IN(in_id,in_type) values(%d,'%s')",newID,m_strInType);
	adoDB.Execute(sql);
	InsertTypeItem(&m_listInType,Int2Str(newID),m_strInType);
}

void CMsgView::OnBtnInmod() 
{
	// TODO: Add your control notification handler code here
	if(!UpdateData())
		return;
	if(!adoDB.IsOpen())
	{
		AfxMessageBox("数据库未打开!");
		return;
	}
	int nItem=m_listInType.GetNextItem(-1,LVNI_SELECTED);
	if(nItem!=-1)
	{
		CString id;
		CString sql;
		sql.Format("select in_id from MSG_IN where in_type='%s'",m_strInType);
		adoDB.ExecuteQueryValue(sql,id);
		if(atoi(id)!=0)
		{
			AfxMessageBox("当前收入类型已经存在!");
			return;
		}
		id=m_listInType.GetItemText(nItem,0);
		sql.Format("update MSG_IN set in_type='%s' where in_id=%d",m_strInType,atoi(id));
		adoDB.Execute(sql);
		m_listInType.SetItemText(nItem,1,m_strInType);
	}	
}

void CMsgView::OnBtnIndel() 
{
	// TODO: Add your control notification handler code here
	if(!adoDB.IsOpen())
	{
		AfxMessageBox("数据库未打开!");
		return;
	}
	int nItem=m_listInType.GetNextItem(-1,LVNI_SELECTED);
	if(nItem==-1)
	{
		AfxMessageBox("没有选定要删除的输入类型信息!");
		return;
	}
	int id=atoi(m_listInType.GetItemText(nItem,0));
	CString sql;
	sql.Format("delete from MSG_IN where in_id=%d",id);
	adoDB.Execute(sql);
	m_listInType.DeleteItem(nItem);
}

void CMsgView::OnBtnOutadd() 
{
	// TODO: Add your control notification handler code here
	if(!UpdateData())
		return;
	if(!adoDB.IsOpen())
	{
		AfxMessageBox("数据库未打开!");
		return;
	}
	if(m_strOutType.IsEmpty())
		return;
	CString str; 
	CString strID;
	str.Format("select out_id from MSG_OUT where out_type='%s'",m_strOutType);
	adoDB.ExecuteQueryValue(str,strID);
	if(atoi(strID)!=0)
	{
		AfxMessageBox("当前支出类型已经存在!");
		return;
	}
	adoDB.ExecuteQueryValue("select max(out_id) from MSG_OUT",strID);
	int newID=atoi(strID)+1;
	CString sql;
	sql.Format("insert into MSG_OUT(out_id,out_type) values(%d,'%s')",newID,m_strOutType);
	adoDB.Execute(sql);
	InsertTypeItem(&m_listOutType,Int2Str(newID),m_strOutType);
}

void CMsgView::OnBtnOutmod() 
{
	// TODO: Add your control notification handler code here
	if(!UpdateData())
		return;
	if(!adoDB.IsOpen())
	{
		AfxMessageBox("数据库未打开!");
		return;
	}
	int nItem=m_listOutType.GetNextItem(-1,LVNI_SELECTED);
	if(nItem!=-1)
	{
		CString id;
		CString sql;
		sql.Format("select out_id from MSG_OUT where out_type='%s'",m_strOutType);
		adoDB.ExecuteQueryValue(sql,id);
		if(atoi(id)!=0)
		{
			AfxMessageBox("当前支出类型已经存在!");
			return;
		}
		id=m_listOutType.GetItemText(nItem,0);
		sql.Format("update MSG_OUT set out_type='%s' where out_id=%d",m_strOutType,atoi(id));
		TRACE(sql);
		adoDB.Execute(sql);
		m_listOutType.SetItemText(nItem,1,m_strOutType);
	}	
}

void CMsgView::OnBtnOutdel() 
{
	// TODO: Add your control notification handler code here
	if(!adoDB.IsOpen())
	{
		AfxMessageBox("数据库未打开!");
		return;
	}
	int nItem=m_listOutType.GetNextItem(-1,LVNI_SELECTED);
	if(nItem==-1)
	{
		AfxMessageBox("没有选定要删除的输入类型信息!");
		return;
	}
	int id=atoi(m_listOutType.GetItemText(nItem,0));
	CString sql;
	sql.Format("delete from MSG_OUT where out_id=%d",id);
	adoDB.Execute(sql);
	m_listOutType.DeleteItem(nItem);
}

void CMsgView::OnBtnAssetadd() 
{
	// TODO: Add your control notification handler code here
	if(!UpdateData())
		return;
	if(!adoDB.IsOpen())
	{
		AfxMessageBox("数据库未打开!");
		return;
	}
	if(m_strAssetType.IsEmpty())
		return;
	CString str;
	CString strID;
	str.Format("select asset_id from MSG_ASSET where asset_type='%s'",m_strAssetType);
	adoDB.ExecuteQueryValue(str,strID);
	if(atoi(strID)!=0)
	{
		AfxMessageBox("当前资产类型已经存在!");
		return;
	}
	adoDB.ExecuteQueryValue("select max(asset_id) from MSG_ASSET",strID);
	int newID=atoi(strID)+1;
	CString sql;
	sql.Format("insert into MSG_ASSET(asset_id,asset_type) values(%d,'%s')",newID,m_strAssetType);
	adoDB.Execute(sql);
	InsertTypeItem(&m_listAssetType,Int2Str(newID),m_strAssetType);
}

void CMsgView::OnBtnAssetmod() 
{
	// TODO: Add your control notification handler code here
	if(!UpdateData())
		return;
	if(!adoDB.IsOpen())
	{
		AfxMessageBox("数据库未打开!");
		return;
	}
	int nItem=m_listAssetType.GetNextItem(-1,LVNI_SELECTED);
	if(nItem!=-1)
	{
		CString id;
		CString sql;
		sql.Format("select asset_id from MSG_ASSET where asset_type='%s'",m_strAssetType);
		adoDB.ExecuteQueryValue(sql,id);
		if(atoi(id)!=0)
		{
			AfxMessageBox("当前资产类型已经存在!");
			return;
		}
		id=m_listAssetType.GetItemText(nItem,0);
		sql.Format("update MSG_ASSET set asset_type='%s' where asset_id=%d",m_strAssetType,atoi(id));
		TRACE(sql);
		adoDB.Execute(sql);
		m_listAssetType.SetItemText(nItem,1,m_strAssetType);
	}
}

void CMsgView::OnBtnAssetdel() 
{
	// TODO: Add your control notification handler code here
	if(!adoDB.IsOpen())
	{
		AfxMessageBox("数据库未打开!");
		return;
	}
	int nItem=m_listAssetType.GetNextItem(-1,LVNI_SELECTED);
	if(nItem==-1)
	{
		AfxMessageBox("没有选定要删除的输入类型信息!");
		return;
	}
	int id=atoi(m_listAssetType.GetItemText(nItem,0));
	CString sql;
	sql.Format("delete from MSG_ASSET where asset_id=%d",id);
	adoDB.Execute(sql);
	m_listAssetType.DeleteItem(nItem);
}