【VC开源代码栏目提醒】:网学会员鉴于大家对VC开源代码十分关注,论文会员在此为大家搜集整理了“AssetsChgDlg.cpp”一文,供大家参考学习
// 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();
}
上一篇:
Assets.cpp
下一篇:
基于量子反馈的量子态调控方案研究