assetschgdlg.cpp

固定资产管理系统,VC++做的,很有参考价值,源码也说明文档都有.

// AssetsChgDlg.cpp : implementation file
//

#include "stdafx.h"
#include "AssetsMan.h"
#include "AssetsChgDlg.h"
#include "Assets.h"
#include "AssetsEditDlg.h"
#include "columns.h"
#include "column.h"
#include "COMDEF.H"
#include "_recordset.h"
#include "AssetsChgEditDlg.h"

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

extern CUsers curUser;
/////////////////////////////////////////////////////////////////////////////
// CAssetsChgDlg dialog


CAssetsChgDlg::CAssetsChgDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CAssetsChgDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CAssetsChgDlg)
	//}}AFX_DATA_INIT
}


void CAssetsChgDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAssetsChgDlg)
	DDX_Control(pDX, IDC_TYPE_COMBO, m_type);
	DDX_Control(pDX, IDC_ADODC1, m_Adodc);
	DDX_Control(pDX, IDC_DATAGRID, m_DataGrid);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CAssetsChgDlg, CDialog)
	//{{AFX_MSG_MAP(CAssetsChgDlg)
	ON_BN_CLICKED(IDC_AUDIT_BUTTON, OnAuditButton)
	ON_BN_CLICKED(IDC_CHANGE_BUTTON, OnChangeButton)
	ON_CBN_SELCHANGE(IDC_TYPE_COMBO, OnSelchangeTypeCombo)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CAssetsChgDlg message handlers

BOOL CAssetsChgDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	// 显示审核和变更的固定资产信息
	m_type.SetCurSel(0);
	// 刷新列表
	RefreshData();
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CAssetsChgDlg::RefreshData()
{
	CString csql;
	csql = "SELECT a.AId AS 资产编号,a.AName AS 资产名称,d.DepName AS 所属部门,";
	csql += "d1.EmpName AS 负责人, a.UsedYear AS 使用年限, a.Ratio AS 残值率,";
	csql += "d.DepId,a.IsAudit,(CASE WHEN a.IsAudit=1 THEN '已审核' ELSE '已变更' END) AS 是否变更";
	csql += " FROM Assets a,Departments d, Distribute d1 ";
	csql += " Where a.Aid=d1.Aid AND d1.DepId=d.DepId AND a.IsAudit<>0";
	// 判断查询条件
	if(m_type.GetCurSel() == 1)
		csql = csql + " AND a.IsAudit=1";
	else if(m_type.GetCurSel() == 2)
		csql = csql + " AND a.IsAudit=2";
//	MessageBox(csql);
	m_Adodc.SetRecordSource(csql);
	m_Adodc.Refresh();
	// 设置列宽度
	_variant_t vIndex;
	vIndex = long(0);
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(60);
	vIndex = long(1);
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(60);
	vIndex = long(2);
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(60);
	vIndex = long(3);
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(60);
	vIndex = long(4);
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(60);
	vIndex = long(5);
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(60);
	vIndex = long(6);
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(0);
	vIndex = long(7);
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(0);
	vIndex = long(8);
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(60);
	// 设置按钮状态
	ButtonEnable();
}

void CAssetsChgDlg::ButtonEnable()
{
	// 如果此记录已经审核，则审核功能失效
	if (!m_Adodc.GetRecordset().GetEof()) 
 		if(atoi(m_DataGrid.GetItem(7))==1) // 审核
 			GetDlgItem(IDC_AUDIT_BUTTON)->EnableWindow(FALSE);
 		else if(atoi(m_DataGrid.GetItem(7))==2) // 变更
 			GetDlgItem(IDC_AUDIT_BUTTON)->EnableWindow(TRUE);
	else
		GetDlgItem(IDC_AUDIT_BUTTON)->EnableWindow(FALSE);
	// 普通用户没有审核权限
	if(curUser.UserType == "普通用户")
		GetDlgItem(IDC_AUDIT_BUTTON)->EnableWindow(FALSE);
}

BEGIN_EVENTSINK_MAP(CAssetsChgDlg, CDialog)
    //{{AFX_EVENTSINK_MAP(CAssetsChgDlg)
	ON_EVENT(CAssetsChgDlg, IDC_DATAGRID, -600 /* Click */, OnClickDatagrid, VTS_NONE)
	//}}AFX_EVENTSINK_MAP
END_EVENTSINK_MAP()

void CAssetsChgDlg::OnClickDatagrid() 
{
	// TODO: Add your control notification handler code here
	ButtonEnable();	
}

void CAssetsChgDlg::OnChangeButton() 
{
	// TODO: Add your control notification handler code here
	if (m_Adodc.GetRecordset().GetEof() == 1) 
	{
		MessageBox("没有数据");
		return;
	}

	// 变更固定资产，更改数据库表Assets中字段IsAudit为2
	CAssetsChgEditDlg dlg;
	dlg.m_aid = m_DataGrid.GetItem(0);
	dlg.m_aname = m_DataGrid.GetItem(1);
	// 设置部门编号
	dlg.cDepId = m_DataGrid.GetItem(6);
	dlg.m_name = m_DataGrid.GetItem(3);	
	dlg.m_useyear = m_DataGrid.GetItem(4);
	dlg.m_ratio = m_DataGrid.GetItem(5);
	// 打开对话框
	if(dlg.DoModal()==IDOK)
		RefreshData();
	ButtonEnable();
}

void CAssetsChgDlg::OnAuditButton() 
{
	if (m_Adodc.GetRecordset().GetEof() == 1) 
	{
		MessageBox("没有数据");
		return;
	}
	// 审核固定资产，更改数据库表Assets中字段IsAudit为1
	CAssets cAst;
	cAst.sql_Audit(m_DataGrid.GetItem(0));
	RefreshData();
	ButtonEnable();
}

void CAssetsChgDlg::OnSelchangeTypeCombo() 
{
	RefreshData();	
}