dlgdelannex.cpp

使用vc开发的个人信息管理系统

// DlgDelAnnex.cpp : 实现文件
//

#include "stdafx.h"
#include "dotNET界面.h"
#include "DlgDelAnnex.h"
#include ".\dlgdelannex.h"


// CDlgDelAnnex 对话框

IMPLEMENT_DYNAMIC(CDlgDelAnnex, CDialog)
CDlgDelAnnex::CDlgDelAnnex(CWnd* pParent /*=NULL*/)
	: CDialog(CDlgDelAnnex::IDD, pParent)
	, m_strAnnexId(_T(""))
	, strID(_T(""))
{
}

CDlgDelAnnex::~CDlgDelAnnex()
{
}

void CDlgDelAnnex::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	DDX_Control(pDX, IDC_LIST_DELNANNEX, m_ListCtrl);
	DDX_Control(pDX, IDOK, c_IdOk);
}


BEGIN_MESSAGE_MAP(CDlgDelAnnex, CDialog)
	ON_BN_CLICKED(IDOK, OnBnClickedOk)
	ON_NOTIFY(NM_CLICK, IDC_LIST_DELNANNEX, OnNMClickListDelnannex)
END_MESSAGE_MAP()


// CDlgDelAnnex 消息处理程序

void CDlgDelAnnex::OnBnClickedOk()
{
	// TODO: 在此添加控件通知处理程序代码
	_RecordsetPtr DelAttachmentSet;
	DelAttachmentSet.CreateInstance(__uuidof(Recordset));
	c_IdOk.EnableWindow(false);
	_variant_t _strSQLAttachment("DELETE FROM TAttachment WHERE TAttachmentID="+strID);//NodeId
	if(!theApp.ADOExecute(DelAttachmentSet,_strSQLAttachment)) return ;
	m_ListCtrl.DeleteItem(iItem);
	c_IdOk.EnableWindow(true);
	UpdateData(false);
	if(adStateOpen==DelAttachmentSet->State)	DelAttachmentSet->Close();
	DelAttachmentSet.Release();

	//OnOK();
}

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

	// TODO:  在此添加额外的初始化
	UpdateData(true);
	SetWindowText("删除 \""+m_strDlgName+"\" 的附件");
	m_ListCtrl.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES|LVS_EX_HEADERDRAGDROP);
	m_ListCtrl.InsertColumn(0, "编号", LVCFMT_LEFT, 52);
	m_ListCtrl.InsertColumn(1, "附件名称", LVCFMT_LEFT, 140);
	m_ListCtrl.InsertColumn(2, "附件文件名称", LVCFMT_LEFT, 150);
	CString strFileName, strAnnexName,strTAttachmentID;
	int i=0;
	_RecordsetPtr MySet;
	_variant_t Holder;
	MySet.CreateInstance(__uuidof(Recordset));
	_variant_t _strSQL("SELECT * FROM TAttachment WHERE NodeId='"+m_strAnnexId+"'");
	theApp.ADOExecute(MySet,_strSQL);
	while(!MySet->adoEOF){
		Holder=MySet->GetCollect("TAttachmentID");
		strTAttachmentID = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
		Holder=MySet->GetCollect("TAttachmentName");
		strAnnexName = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
		Holder=MySet->GetCollect("FileName");
		strFileName = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
		m_ListCtrl.InsertItem(i,strTAttachmentID);//NodeName
		m_ListCtrl.SetItemText(i,1,strAnnexName);
		m_ListCtrl.SetItemText(i,2,strFileName);
		i++;
		MySet->MoveNext();
	}
	if(adStateOpen==MySet->State)	MySet->Close();
	MySet.Release();
	return TRUE;  // return TRUE unless you set the focus to a control
	// 异常: OCX 属性页应返回 FALSE
}

void CDlgDelAnnex::OnNMClickListDelnannex(NMHDR *pNMHDR, LRESULT *pResult)
{
	// TODO: 在此添加控件通知处理程序代码
	POSITION pos =m_ListCtrl.GetFirstSelectedItemPosition();
	iItem =m_ListCtrl.GetNextSelectedItem(pos);
	strID=m_ListCtrl.GetItemText(iItem, 0);
	*pResult = 0;
}